1Z0-908 case studies
1Z0-908 · Put your knowledge to work in context.
The Oracle Database 19c: Administration credential (exam 1Z0-908, often called the OCP 19c DBA) is a professional-level certification for database administrators who run Oracle Database 19c in production. It suits DBAs moving from day-to-day operations toward full ownership of an instance: installation and patching, storage layout, security, backup and recovery, performance work, concurrency and undo, multitenant management, connectivity, and scheduling. The 1Z0-908 case studies are 5 cases and about 4,187 words.
1What Limit and Retention Settings Are Really Controlling the Flash Recovery Area
FINDB runs Oracle 19c on a single instance with a 900 GB database, ARCHIVELOG mode, and a 400 GB fast recovery area on a SAN LUN. RMAN is configured with RETENTION POLICY TO REDUNDANCY 2, and a nightly job at 01:00 takes a compressed level 0 database backup plus an archive log backup.
868 words, about 4 min2Log File Sync Averaging 10 ms While Redo Writes Average 0.6 ms
SALESDB is a 19c single-instance OLTP database with a 4-hour peak from 10:00 to 14:00. The AWR report for that window shows 240 minutes elapsed and 1,920 minutes of DB time.
846 words, about 4 min3ORA-01555 on a Six-Hour Report With a 195 GB Undo Tablespace
REPORTDB runs Oracle 19c with a 120 GB undo tablespace that has AUTOEXTEND ON, NEXT 1 GB and MAXSIZE 200 GB. undo retention is 10800 seconds and retention guarantee is not enabled.
779 words, about 4 min4Creating the Application Schema in the Wrong Container
PRODCDB is a 19c multitenant database on a single instance, hosting 30 pluggable databases. Every PDB contains a schema named APP owned by an application account with the same password.
845 words, about 4 min5Shared Pool Starvation After an SGA Target Was Set Too High
PRODDB runs Oracle 19c on a 256 GB, 64-core Linux host with a single instance. The spfile sets SGA TARGET to 200G and PGA AGGREGATE TARGET to 64G.
849 words, about 4 min