For the query to display the number and size of database files and the number of extents for CSE tables, set the environment variable ORACLE_SID to the CSE database; for example DBCSE. Enter the following at the command prompt:
SET ORACLE_SID=DBCSE
sqlplus must be executed from this command prompt.
Alternatively, in your workspace, click Start, Setting, Control Panel. In the Control Panel, select System. In the System Properties panel, add the environment variable ORACLE_SID and its value, the database name. Click Set to set the value. sqlplus can be run from any prompt or the icon.
For the query to display next extent for each table and index in the DBCSE database, run the SQL from within sqlplus after logging in as owner of the DBCSE tables.
|
Copyright © 2013 CA.
All rights reserved.
|
|