Name of the Machine storet Name of the Instance and its Log-Mode NAME LOG_MODE ---------------------------------------- ------------------------------ STORET NOARCHIVELOG Oracle and Tools Version Information BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production PL/SQL Release 8.1.6.1.0 - Production CORE 8.1.6.0.0 Production TNS for DEC OSF/1 AXP: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production ControlFileInformation NAME ---------------------------------------------------------------------- /data/oradata/storet/control01.ctl /data/oradata/storet/control02.ctl /data/oradata/storet/control03.ctl LogFileInformation STATUS MEMBER ------- -------------------------------------------------- /data/oradata/storet/redo0101.log /data/oradata/storet/redo0102.log /data/oradata/storet/redo0201.log /data/oradata/storet/redo0202.log /data/oradata/storet/redo0301.log /data/oradata/storet/redo0302.log 6 rows selected. DataFileInformation STATUS BYTES NAME ------- --------- ------------------------------------------------------- SYSTEM 367001600 /data/oradata/storet/system01.dbf ONLINE 2.517E+09 /data/oradata/storet/rbs01.dbf ONLINE 52428800 /data/oradata/storet/users01.dbf ONLINE 104857600 /data/oradata/storet/tools01.dbf ONLINE 2.097E+09 /data/oradata/storet/temp01.dbf ONLINE 5.369E+09 /data/oradata/storet/appl_data12.dbf ONLINE 4.719E+09 /data/oradata/storet/appl_data11.dbf ONLINE 2.684E+09 /data/oradata/storet/appl_data10.dbf ONLINE 2.684E+09 /data/oradata/storet/appl_data09.dbf ONLINE 2.684E+09 /data/oradata/storet/appl_data08.dbf ONLINE 2.147E+09 /data/oradata/storet/appl_data07.dbf ONLINE 2.147E+09 /data/oradata/storet/appl_data06.dbf ONLINE 2.147E+09 /data/oradata/storet/appl_data05.dbf ONLINE 2.147E+09 /data/oradata/storet/appl_data04.dbf ONLINE 5.033E+09 /data/oradata/storet/appl_data03.dbf ONLINE 5.369E+09 /data/oradata/storet/appl_data02.dbf ONLINE 3.221E+09 /data/oradata/storet/appl_data01.dbf ONLINE 314572800 /data/oradata/storet/appl_index05.dbf ONLINE 4.719E+09 /data/oradata/storet/appl_index04.dbf ONLINE 5.369E+09 /data/oradata/storet/appl_index03.dbf ONLINE 4.295E+09 /data/oradata/storet/appl_index02.dbf STATUS BYTES NAME ------- --------- ------------------------------------------------------- ONLINE 2.684E+09 /data/oradata/storet/appl_index01.dbf ONLINE 2.147E+09 /data/oradata/storet/temp02.dbf ONLINE 2.147E+09 /data/oradata/storet/temp03.dbf ONLINE 2.147E+09 /data/oradata/storet/temp04.dbf ONLINE 20971520 /data/oradata/storet/sqlstation01.dbf ONLINE 2.147E+09 /data/oradata/storet/temp05.dbf ONLINE 57344 /data/oradata/storet/temp06.dbf 28 rows selected. Tablespace Information and Allocated Space Information TABLESPACE_NAME ALLOCATEDSPACE ------------------------------ ------------------------------------------- APPL_DATA 40353.398784 MB APPL_INDEX 17381.195776 MB RBS 2516.5824 MB SQLSTATION 20.97152 MB SYSTEM 367.0016 MB TEMP 10687.143936 MB TOOLS 104.8576 MB USERS 52.4288 MB 8 rows selected. User Information And Associated Tablespace USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE -------------------- ------------------------- ------------------------- SYS SYSTEM TEMP SYSTEM TOOLS TEMP OUTLN TOOLS TEMP EXT_ORACLE USERS TEMP BGSUSER TOOLS TEMP SDE APPL_DATA TEMP STORET_OWNER APPL_DATA TEMP CODER SQLSTATION TEMP STORET_READER APPL_DATA TEMP AURORA$ORB$UNAUTHENT SYSTEM SYSTEM ICATED DBSNMP SYSTEM SYSTEM ORDPLUGINS TOOLS TEMP EXP_USER USERS TEMP DBVISION TOOLS TEMP USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE -------------------- ------------------------- ------------------------- ORACLE USERS TEMP OWSUSER SYSTEM TEMP OAS_PUBLIC SYSTEM TEMP MDSYS SYSTEM SYSTEM SQLSTATION SQLSTATION TEMP ORDSYS TOOLS TEMP 20 rows selected. Complete Information on Tablespace and Storage Parameters TBS_NAME I_EXTENT N_EXTENT MIN_EXTENTS MAX_EXTENTS STATUS -------------------- --------- --------- ----------- ----------- --------- SYSTEM 16384 16384 1 505 ONLINE RBS 5242880 5242880 10 1024 ONLINE USERS 262144 262144 1 505 ONLINE TOOLS 262144 262144 1 1024 ONLINE TEMP 20971520 20971520 1 ONLINE APPL_DATA 40960 40960 1 505 ONLINE APPL_INDEX 40960 40960 1 505 ONLINE SQLSTATION 40960 40960 1 505 ONLINE 8 rows selected. Information on Datafile and Associated Tbs and Size TBS_NAME FILE_NAME TOTAL_SPACE ------------------ ---------------------------------------- ------------------- APPL_DATA /data/oradata/storet/appl_data12.dbf 5368.70912MB APPL_DATA /data/oradata/storet/appl_data11.dbf 4718.592MB APPL_DATA /data/oradata/storet/appl_data10.dbf 2684.35456MB APPL_DATA /data/oradata/storet/appl_data09.dbf 2684.35456MB APPL_DATA /data/oradata/storet/appl_data08.dbf 2684.35456MB APPL_DATA /data/oradata/storet/appl_data07.dbf 2147.483648MB APPL_DATA /data/oradata/storet/appl_data06.dbf 2147.483648MB APPL_DATA /data/oradata/storet/appl_data04.dbf 2147.483648MB APPL_DATA /data/oradata/storet/appl_data02.dbf 5368.70912MB APPL_DATA /data/oradata/storet/appl_data01.dbf 3221.225472MB APPL_DATA /data/oradata/storet/appl_data03.dbf 5033.1648MB APPL_DATA /data/oradata/storet/appl_data05.dbf 2147.483648MB APPL_INDEX /data/oradata/storet/appl_index05.dbf 314.5728MB APPL_INDEX /data/oradata/storet/appl_index04.dbf 4718.592MB APPL_INDEX /data/oradata/storet/appl_index03.dbf 5368.70912MB APPL_INDEX /data/oradata/storet/appl_index01.dbf 2684.35456MB APPL_INDEX /data/oradata/storet/appl_index02.dbf 4294.967296MB RBS /data/oradata/storet/rbs01.dbf 2516.5824MB SQLSTATION /data/oradata/storet/sqlstation01.dbf 20.97152MB SYSTEM /data/oradata/storet/system01.dbf 367.0016MB TEMP /data/oradata/storet/temp01.dbf 2097.152MB TBS_NAME FILE_NAME TOTAL_SPACE ------------------ ---------------------------------------- ------------------- TEMP /data/oradata/storet/temp03.dbf 2147.483648MB TEMP /data/oradata/storet/temp06.dbf .057344MB TEMP /data/oradata/storet/temp05.dbf 2147.483648MB TEMP /data/oradata/storet/temp04.dbf 2147.483648MB TEMP /data/oradata/storet/temp02.dbf 2147.483648MB TOOLS /data/oradata/storet/tools01.dbf 104.8576MB USERS /data/oradata/storet/users01.dbf 52.4288MB 28 rows selected. Information on Users and Quotas on Tablespaces TABLESPACE_NAME USERNAME Allowed Quota on Tablespace -------------------- -------------------- -------------------------------------- USERS SYSTEM UnLimitedQuota USERS ORACLE UnLimitedQuota TOOLS ORACLE UnLimitedQuota USERS HCL UnLimitedQuota USERS PQA UnLimitedQuota USERS CCA UnLimitedQuota USERS TIM UnLimitedQuota SQLSTATION SQLSTATION UnLimitedQuota TEMP CODER UnLimitedQuota SQLSTATION CODER UnLimitedQuota USERS SCOTT UnLimitedQuota TEMP PKD UnLimitedQuota APPL_DATA PKD UnLimitedQuota 13 rows selected. List of Users Not Created with Specific Quotas USERNAME -------------------- AURORA$ORB$UNAUTHENT ICATED DBSNMP EXT_ORACLE USERNAME -------------------- MDSYS OAS_PUBLIC ORDPLUGINS ORDSYS OUTLN OWSUSER SDE STORET_OWNER SYS 13 rows selected. Database Link Information OWNER DB_LINK USERNAME -------------------- -------------------------------------- -------------------- PUBLIC STORET.EPA.GOV List of Tablespaces and Current Storage Parameters Tablespace Name AllocatedSpace Free Space APPL_DATA 40353.398784 MB 13030.948864 MB APPL_INDEX 17381.195776 MB 1582.94016 MB RBS 2516.5824 MB 2181.029888 MB SQLSTATION 20.97152 MB 9.6256 MB SYSTEM 367.0016 MB 140.058624 MB TEMP 10687.143936 MB 8757.714944 MB TOOLS 104.8576 MB 80.519168 MB USERS 52.4288 MB 23.273472 MB List of Tablespaces and its Allocated and Current Extents Tablespace Name MaxExtentsAllocated MaxExtentsReached APPL_DATA 505 828 APPL_INDEX 505 25 RBS 1024 9 SQLSTATION 505 0 SYSTEM 505 666 TEMP 91 TOOLS 1024 11 USERS 505 0 PL/SQL procedure successfully completed.