Category: Scripts

How to check tablespace size in oracle database set linesize 150 set pagesize 5000 col owner for a15 col segment_name for a30 col segment_type for a20 col TABLESPACE_NAME for a30… Read more »

Check user status in oracle database Here with the use of below scripts you can check the status of particular user whether is open/locked or expired , you can check… Read more »

Check sql session detail in oracle database   SET LINESIZE 190 COLUMN spid FORMAT A10 COLUMN username FORMAT A15 COLUMN program FORMAT A65 SELECT s.inst_id, s.sid,s.serial#, p.spid, s.username, s.program FROM… Read more »

How to check Export/Import data pump job status Monitor export/Import with the data pump views – The main view to monitor Export/Import jobs are dba_datapump_jobs and dba_datapump_sessions. set line 190… Read more »

How to check free space in UNDO tablespace select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select sum(bytes) / 1024 / 1024 SIZEMB, b.tablespace_name from dba_data_files a, dba_tablespaces b where… Read more »

Script for Oracle Database session,user,process and sid details. col OS_USER for a25 col SID for a10 col USERNAME for a20 col PID for a20 select        substr(a.spid,1,9) pid,        substr(b.sid,1,5)… Read more »

Database and server details Report from OEM: 1- How do get the number of databases for each category version? SELECT property_value, COUNT(*) FROM mgmt$target_properties WHERE target_type = ‘oracle_database’ AND property_name… Read more »