Sunday, 5 April 2015

Find out which table is using maximum tablespace

Which table is using maximum tablespace :- 

Run the below SQL :-

select sum(bytes)/1024/1024, s.segment_name, s.segment_type
    from dba_lobs l, dba_segments s
    where s.segment_type = 'LOBSEGMENT'
    and l.table_name = 'PS_PV_ATT_DB_SRV'
    and s.segment_name = l.segment_name
    group by s.segment_name,s.segment_type;

No comments:

Post a Comment

The purge process did not run because the Oprid configured to start the Process Scheduler did not have the required permissions to run the purge process.

  Purge process - Required permissions The PeopleSoft Oprid used to start the Process Scheduler, as defined in the Scheduler's psprcs.cf...