For the query to display the number and size of database files and the query to display the number of extents for CSE tables, set the environment variable ORACLE_SID to the CSE database; for example DBCSE.
If you are using the Bourne shell:
ORACLE_SID=DBCSE export DBCSE
If you are using the Korn shell:
export ORACLE_SID=DBCSE
Or if you are using c-shell
setenv ORACLE_SID DBCSE
Then log in to the system account as owner of the DBCSE tables to access the DBA tables. For the query to display next extent for each table and index in the DBCSE database, run the SQL from within sqlplus.
The number of Extents on CSE tables and indexes:
Next Extent for CSE tables and indexes:
|
Copyright © 2013 CA.
All rights reserved.
|
|