Dba_tablespaces

Oracle Undo: Check Extent Status in DBA_UNDO_EXTENTS Purpose A report query runs for forty minutes on a busy system and ends with ORA-01555: snapshot too old. The query is correct. The undo it needed to build a consistent picture of the data was overwritten before the query finished. Somewhere between the size of the …

Show the Datafiles That Make Up an Oracle Tablespace Capacity planning for an Oracle database starts with knowing which files hold each tablespace and how large they are. A tablespace is a logical container. Its data lives in one or more datafiles on disk, and dba_data_files lists them. The query below takes a …

Description of Oracle Database SQL code for Identifying Tablespaces Needing Space This code helps identify tablespaces requiring additional space to maintain an 80% utilization threshold in your Oracle database. Below is a breakdown of its purpose, components, and key points: Sample SQL Command 1set pages 999 lines 100 …

Setting a Default Temporary Tablespace in Oracle Database Purpose Every Oracle database needs one answer to a plain question: where does temporary work go for a user who has no temporary tablespace of their own? The database default temporary tablespace is that answer. A new installation creates a single temporary …

Identify Oracle Database Segments Nearing Their Maximum Extent Limit Oracle ignores the MAXEXTENTS storage parameter for objects in a locally managed tablespace, unless the tablespace has ALLOCATION_TYPE set to USER. That one rule decides whether the query below is useful on your database. It is a real early warning in …

Lists the Contents of the Temporary Tablespace(s), Including Details About Each Temporary Object and Its Associated Session v$sort_usage is the view to open when TEMP fills up: it holds one row per temporary segment in use, with the user, the session, the tablespace and the blocks allocated. Whether the trigger is an …