Oracle DBA case studies
Oracle DBA · Put your knowledge to work in context.
The Oracle Database Administration I exam, listed by Oracle University under the code 1Z0-082, is the first of the two associate-level administration exams on the Oracle Database 19c administration track. It targets working database administrators, systems engineers, and technical consultants who already touch Oracle Database in production or lab environments and want a structured, vendor-recognised validation of day-to-day administration skill. The Oracle DBA case studies are 5 cases and about 3,353 words.
1Sizing the SGA when physical reads climb but DB time does not
A single-instance 19c database on a 64 GB host runs SGA TARGET=12G and PGA AGGREGATE TARGET=8G. DB time is flat month over month, yet the 'physical reads' statistic climbs steadily.
677 words, about 3 min2ORA-12514 after a host rename, with tnsping succeeding
Two databases run on one host: SALES and HRDEV. listener.ora holds only the default LISTENER block on port 1521; both instances register dynamically.
563 words, about 3 min3ORA-01653 during a 40 GB bulk load with a short window
APP DATA is a locally managed, ASSM tablespace with a single datafile: 8 GB, AUTOEXTEND ON NEXT 128M MAXSIZE 8G, sitting on a filesystem with 190 MB free. A nightly bulk load inserts 40 GB into a new table, LOADER.STG EVENTS, and fails after about six minutes with ORA-01653: unable to extend table LOADER.STG EVENTS by 1024 in tablespace APP DATA.
700 words, about 4 min4A 42-minute inactive blocker, plus ITL waits on another table
At 10:05 the help desk reports that order-entry screens freeze. v session shows SID 145 as the only blocker: status INACTIVE, last call 42 minutes ago, machine APP04, last statement an UPDATE of a single row in ORDERS.
701 words, about 4 min5ORA-01555 with an undo tablespace that looks big enough
The UNDO tablespace is 32 GB, fixed size with AUTOEXTEND off. undo retention is 10800 and RETENTION GUARANTEE is not set.
712 words, about 4 min