Oracle : Key Tables

This lists some of the tables that are of good use when looking at data at the session level.


1. v$session_longops: Has data regarding operations that are running on the database.

Execution plan on SQLPLUS

To get only the execution plan for a query and check for its performance even before executing the query, use the foll command on sqlplus:

set autotrace traceonly explain

This will show the execution plan for the query.

ORA: 01653: Unable to extend Table

An oracle error when Oracle is unable to extend the table in a tablespace.

Solution:
Extend the tablespace size

alter database datafile 'xyz.dbf' resize 1000M (The new total size)

Getting the datafile: Go to DBA->Segment management and Tablespaces in TOAD.

Sometimes the system may not have enough space for increasing tablespace file size.

Create a new file and attach it to the tablespace

ALTER TABLESPACE
ADD DATAFILE 'abc.dbf' SIZE 100M
AUTOEXTEND ON
NEXT 1024K
MAXSIZE 250M