The SYSAUX tablespace contains auxiliary data for Oracle database operations: Main contents: AWR (Automatic Workload Repository) – Performance statistics and snapshotsStatspack – Legacy performance data (if used)SQL Tuning Advisor – SQL tuning recommendations and historySpatial data – Oracle Spatial metadataOLAP – Online Analytical Processing metadataData Mining – Oracle Data Mining repositoryLogical Standby – Logical standby…

SQL*Loader is used to load data from external files into Oracle database tables. In 26ai SQL*Loader enables direct data loading into the database shards for a high speed data ingest. SQL*Loader can load data faster and easier into Oracle Database with automatic parallelism and more efficient data storage. In Oracle AI Database 26ai, SQL*Loader client…

Private Temporary Tables are temporary tables that exist only for the duration of a session or transaction. They are prefixed with ORA$PTT_ and are managed entirely in memory.   The ON COMMIT PRESERVE DEFINITION option creates a private temporary table that is session-specific. Oracle removes all data and drops the table at the end of the session. Quiz Which three…

BIGFILE and SMALLFILE are two types of tablespace architectures in Oracle databases that differ in how they organize datafiles. SMALLFILE Tablespace (Traditional) It is important to remember that this is the default and original Oracle tablespace type. Can contain multiple datafiles (up to 1,022 datafiles per tablespace)Each datafile can be up to 4 million blocks…

Oracle Unified Auditing is a consolidated auditing architecture introduced in Oracle 12c that combines all audit trails into a single, centralized location. What It Does Instead of having separate audit trails scattered across different locations (standard auditing, fine-grained auditing, RMAN, Data Pump, etc.), Unified Auditing captures all audit records in one place – a read-only…

The TEMP tablespace does not appear in the DBA_FREE_SPACE view because of how Oracle manages temporary tablespaces differently from permanent tablespaces. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_FREE_SPACE.html DBA_FREE_SPACE only shows free space in permanent tablespaces. Temporary tablespaces use a different space management mechanism and are tracked separately. Use the DBA_TEMP_FREE_SPACE view instead:

Oracle AI Database provides the industry’s most comprehensive auditing capability, enabling the capture of detailed information relating to who, what, when the action was performed, and the associated context with the activity which generated the audit record. Click here to learn about Auditing in 26ai. Try a quiz The V$OPTION view is the definitive way to…

Oracle background processes are essential components of the database instance. They handle tasks behind the scenes to ensure data integrity, performance, and recovery. Here is a little overview to assist in getting to know background processes: Note: PMON also registers database services with listeners. Server processes, not background processes handle the load into buffer caches.…

SYSAUDIT is focused on monitoring privileged operations, especially those by SYS users. AUDIT_ADMIN is about controlling the audit system itself—setting policies, managing audit data, and configuring audit behavior. If you’re setting up auditing in Oracle 23ai, you’d typically assign AUDIT_ADMIN to DBAs responsible for audit policy management, while SYSAUDIT is more about ensuring oversight of…

OLTP or Online Transaction Processing is a type of data processing that consists of executing a number of transactions occurring concurrently—online banking, shopping, order entry, or sending text messages, for example. These transactions traditionally are referred to as economic or financial transactions, recorded and secured so that an enterprise can access the information anytime for…

Oracle start and stop seems simple enough, but it’s a busy time … SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down. SQL> startup;ORACLE instance started. Total System Global Area 1610609432 bytesFixed Size 9855768 bytesVariable Size 989855744 bytesDatabase Buffers 603979776 bytesRedo Buffers 6918144 bytesDatabase mounted.Database opened.

Oracle did a fine job providing useful documentation for really hard-to-gather-in-one-place things! You can copy the whole document with diagrams, helpful links and notes! https://docs.oracle.com/en/database/oracle/oracle-database/26/dbiad/db_sga.html The source extensively describes the database instance and its associated memory structures, including the System Global Area (SGA), which houses critical components like the Shared Pool, Database Buffer Cache, and…

Oracle announced the release of Oracle AI Database 26ai which replaces Oracle Database 23ai. Downloaded the books for 26ai and compared 23ai and there aren’t any core concept changes. Additional features in 26ai were documented e.g., New Features. Oracle announcement Transitioning from 23ai to 26ai is simple—just apply the October 2025 release update with no…

The 23ai documentation now has 26ai but the error search is the same. This should be your first stop. https://docs.oracle.com/en/error-help/db/ora-01045/?r=26ai Oracle offers an HR database which you can use to test on your own install. I still have an Oracle 21 as well as 23ai database with the HR database which are useful for testing…