Posts
Oracle SQL Scripts and Database Commands 23c 21c 19c 18c 12c 11g 10g 9i 8i We are in the process of building a list of simple scripts used every day by DBA and others. If you have your own scripts you reuse in a text file on you workstation please send it to us. To look at other scripts see the Oracle Scripts Tag …
Read MoreShow all the Oracle users connected to the database SQL Code 1set lines 100 pages 999 2col ID format a15 3col USERNAME format a20 4select username 5, sid || ',' || serial# "ID" 6, status 7, last_call_et "Last Activity" 8from v$session 9where username is not null 10order by status desc 11, last_call_et desc 12/ Sample …
Read MoreShows 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 …
Read MoreOracle 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 …
Read More