Thanks for the question, Daniel.
Asked: January 14, 2020 - 8:09 am UTC
Last updated: January 15, 2020 - 7:40 am UTC
Version: 12.1
Viewed 1000+ times
SQL> shutdown abort ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 4294964736 bytes Fixed Size 9037312 bytes Variable Size 1140850688 bytes Database Buffers 2600468480 bytes Redo Buffers 7737344 bytes In-Memory Area 536870912 bytes Database mounted. SQL> select * from v$tablespace order by con_id, ts#; TS# NAME INC BIG FLA ENC CON_ID ---------- ------------------------------ --- --- --- --- ---------- 0 SYSTEM YES NO YES 1 1 SYSAUX YES NO YES 1 2 UNDOTBS1 YES NO YES 1 3 TEMP NO NO YES 1 4 USERS YES NO YES 1 0 SYSTEM YES NO YES 2 1 SYSAUX YES NO YES 2 2 UNDOTBS1 YES NO YES 2 3 TEMP NO NO YES 2 0 SYSTEM YES NO YES 3 1 SYSAUX YES NO YES 3 3 TEMP NO NO YES 3 5 USERS YES NO YES 3 6 LARGETS YES NO YES 3 8 ASKTOM YES NO YES 3 10 SAMPLES YES NO YES 3 11 UNDO01 YES NO YES 3 12 NO_ASSM YES NO YES 3 18 rows selected.
Daniel, March 17, 2020 - 7:48 am UTC
Need more information on Administration? Check out the Administrators guide for the Oracle Database