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)