gplivna.blogspot.com

gplivna.eu

Oracle Server Class Diagram

http://www.gplivna.eu/papers/oracle_class_diag.htm

Oracle Server Class Diagram. This diagram was created for educational purposes for subject Object Oriented Modelling. It contains 4 parts - Processes, Memory, Physical storage and Logical Storage. It was created for Oracle 8, so don't look for any new stuff. And of course even in those times it wasn't complete. Diagram is a general overview of Oracle construction and some basic concepts and probably is helpful for a newbie ;). All diagram (122 kbytes, gif image). Processes (29 kbytes, gif image).

datubazes.wordpress.com

Par | Datubāzes

https://datubazes.wordpress.com/par

Par datubāzēm (t.sk. Oracle, MySQL, SQL Server u.c.) un visu, kas ar tām saistīts. Jebkurš projekts sākas ar vīziju neatkarīgi no tā vai tā tiek vai netiek formalizēta uz papīra. Tad nu šī ir jūsu monitoros redzamā projekta – Raksti latviešu valodā par datubāzēm – vīzija. Ir relatīvi apmeklēti. Tiesa gan tie abi ir angliski. Diemžēl izskatās, ka ir diezgan vāji ar interneta resursiem par datubāzēm latviski, tāpēc man radās doma vismaz kaut nedaudz šo robu aizpildīt. Vairums šīs vietnes rakstu ir sacerēti...

gplivna.eu

Ways to activate Oracle trace

http://www.gplivna.eu/papers/oracle_trace.htm

Alternative ways to activate trace. For my preffered ways to activate oracle trace look at Oracle trace description. Article. All below mentioned ways to enable/disable tracing are possible in 10g, but not all in previous versions. For example package dbms monitor was not available in 9i. Using alter session set sql trace . Alter session set sql trace = true;. Which in functionality is equivalent to the. Alter session set events '10046 trace name context forever, level 1';. It is is equivalent to the.

gplivna.eu

Naming conventions for Oracle tables, columns, indexes...

http://www.gplivna.eu/papers/naming_conventions.htm

Naming conventions for Oracle tables, columns, indexes. Why any naming conventions at all? It is very important to follow some naming standards. And guidelines in the process of designing Oracle database. It is even more important if you have task to design Oracle database containing hundreds of tables and thousands of other objects. If you have project command of several people it is absolutely necessary to pick a naming convention. But you should check whether they haven't other widespread standards.

gplivna.eu

Long running Operations in Oracle (entries in v$session_longops)

http://www.gplivna.eu/papers/v$session_longops.htm

Long running Operations in Oracle (entries in v$session longops). What are long running operations and how to monitor them? Built in types of long operations. Work behind the scenes. 10 000 database block threshold. Index Fast Full Scan. 1 000 database block threshold. Even 20 block hash join may show up in v$session longops. Hash joins can either fly or crawl. Linear prediction may be wrong. References and Further reading. What are long running operations and how to monitor them? Select * from (. One of...

gplivna.eu

Do you have data waste or data base?

http://www.gplivna.eu/papers/data_waste_or_data_base.htm

Do you have data waste or data base? Characteristics for data waste. 1 Lack of documentation. 2 The only well-informed person has left a while ago. 3 Lack of initial design. 4 Lack of naming conventions. 5 All logic in application / db has only tables. 6 Many persons have already taken part to make data waste bigger each with his own imagination and level of understanding. 7 Physical attributes of database objects. 71 N o constraints and referential integrity. 75 C haotic indexes. You probably have (or h...

gplivna.eu

Data migration from old to new application: an experience

http://www.gplivna.eu/papers/legacy_app_migration.htm

Data migration from old to new application: an experience. Organize and code your data migration effectively. There are several valuable articles around the internet that provides general overview and strategy for data migration or data conversion method (for example The Complete Data Migration Methodology by Joseph R. Hudicka, Dulcian, Inc., http:/ www.dulcian.com/papers/The%20Complete%20Data%20Migration%20Methodology.html. All data groups were migrated by the same scenario source data. Later In migrati...

gplivna.eu

Using Analytic Functions in Reports

http://www.gplivna.eu/papers/using_analytic_functions_in_reports.htm

Using Analytic Functions in Reports. What is so cool in analytic functions? Case one: persons and their citizenships. Case two: peoples without valid identity cards. Case three: getting the current value and first value in a hierarchy. Case four: do all that in few sections. Appendix 1 Database model diagram used in this document. Analytics has been around since 8i but unfortunately it is terra incognita. 1] Effective Oracle by Design by Thomas Kyte ISBN:. As well as articles and Oracle documentation:.

gplivna.eu

Description of this site

http://www.gplivna.eu/desc_e.htm

Description of this site. Here you can find some formulated thoughts. And other RDBMSes. MySQL stuff is old and most probably out of date. If you don't know what is Oracle then you can visit wikipedia. For more descriptional and historical info. The site is running since May 2006, here you can find longer works. Smaller thoughts and some other stuff is also in my blog. According to google analytics there are 156 countries out of 193 whose people have at lest once visited this site. Data waste or data base.