SQL Script SYSAUX Occupants

Updated: 28-Dec-2005
Version: 1.0

Description

Displays the contents of the SYSAUX tablespace

Parameters

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set pages 200
set lines 100 
col occupant_desc form a55 wrap
col move_procedure form a35 wrap
col Mb form 99,999

spool sysaux.lst

select occupant_desc, move_procedure,space_usage_kbytes/1024 Mb
from v$sysaux_occupants
order by Mb 
/

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links