The objective is to go through Oracle database physical and logical structures, highlighting the consequences of some Oracle's internal design choices for developers of database applications. The presentation defines Oracle related basic terms and illustrates them based on the database architecture.
The following topics are discussed:
• Database with its physical and logical structures (tablespace, segment, extent, block, database user, schema, user's quota)
• Single instance (significant memory structures: buffer cache, shared pool)
• Real Application Cluster (RAC)
• Connecting to the database (TNS, database service)
• SQL statements processing (hard and soft parsing, cursor, cursor sharing, execution plan)
The second part of the tutorial focuses on software tools, which support non-database administrators in working with Oracle database. The tutorial will give a set of practical hints related to CERN environment. Based on the information passed during the presentation and a set of usage examples, a participant should be able to find him/herself installation packages and start working with Oracle database quickly and efficiently. The tools covered by the lecture are: SQL*Plus, Benthic Golden, Oracle SQL Developer and CERN developed tool, which enables the control of the internals of your database connections: Session Manager.