DBA

How Do you move table from sys tablespace to user tablespace :-

sql>alter table tablename move tablespace tablespacename;

Finding out Table and Tablespace Location :-

sql>select owner,table_name,tablespace_name from dba_tables where table_name='tablename';


How many memory layers are in the shared pool?

Shared poll consists of two layers.

• Library Cache ---- parsed sql staments and cursor information its a symmentric check.
• Data Dictionary Cache --- user account,privilege,segments,datafile and extend information stored in the data dictionary cache.