Oracle Administration Status

How large is the Oracle Database? Gain a comprehensive overview of database size, free space, and used space to proactively manage storage resources and plan for future growth. SQL Code 1col "Database Size" format a20 2col "Free space" format a20 3col "Used space" format a20 4select round(sum(used.bytes) / 1024 / 1024 …

Display the Oracle database chararter set information Explore language and locale configurations that shape data interpretation and presentation for globalized applications and accurate data handling. SQL Code 1select * from nls_database_parameters 2/ Sample Oracle Output 11 22SQL> Purpose: To retrieve and display all …

Show all the Oracle database used or installed Oracle features using dba_feature_usage_statistics Discover which database features have been actively used, providing insights for license management, optimization, and future planning. Show all the Oracle database installed features for an instance SQL Code 1select name …

Identify if Java is installed in the Oralce database using all_objects Gain visibility into the quantity of Java objects owned by the SYS user, aiding in understanding database usage and potential security considerations. This will return 9000'ish if it is... SQL Code 1select count(*) 2from all_objects 3where …

Show the ten largest oracle objects in the database using dba_segments Pinpoint the segments occupying the most storage space within the database to optimize storage usage, address potential bottlenecks, and enhance performance. SQL Code 1col owner format a15 2col segment_name format a30 3col segment_type format a15 …

Shows the distribution of objects and data across all schemas using dba-segments & dba_objects Gain insights into object distribution across database users and their corresponding storage usage for data management, capacity planning, and optimization. Which schemas are taking up all of the space? SQL Code 1set pages …

Oracle Startup Time Discover the precise moment when the database was last initialized, providing insights for troubleshooting, performance analysis using v$instance Identify the Oralce Startup Time using SQL Script SQL Code 1select to_char(startup_time, 'HH24:MI DD-MON-YY') "Startup time" 2from v$instance 3/ Sample …