Friday, December 26, 2014
Wednesday, December 24, 2014
how to check last analyzed table in oracle
SELECT table_name,num_rows,last_analyzed FROM user_TABLES
TABLE_NAME NUM_ROWS LAST_ANALYZED
------------------------------ ---------- -------------
MTHPASSKBS 611 15-SEP-14
SH_NO 6319 19-SEP-14
D_R_D_SEP 280 11-OCT-14
REQ_TRAINEE_T 3152 20-DEC-14
REQUISITION_T 1251 20-DEC-14
EVALUATION_T 1349 20-DEC-14
EVALUATION_WEEK_T 296 20-DEC-14
REGISTRATION_T 1634 20-DEC-14
OFFICEORDER_T 2069 20-DEC-14
MASTER 710 20-DEC-14
10 rows selected
TABLE_NAME NUM_ROWS LAST_ANALYZED
------------------------------ ---------- -------------
MTHPASSKBS 611 15-SEP-14
SH_NO 6319 19-SEP-14
D_R_D_SEP 280 11-OCT-14
REQ_TRAINEE_T 3152 20-DEC-14
REQUISITION_T 1251 20-DEC-14
EVALUATION_T 1349 20-DEC-14
EVALUATION_WEEK_T 296 20-DEC-14
REGISTRATION_T 1634 20-DEC-14
OFFICEORDER_T 2069 20-DEC-14
MASTER 710 20-DEC-14
10 rows selected
ANALYZE TABLE command
ANALYZE TABLE <TABLE_NAME> COMPUTE STATISTICS;
Tuesday, December 23, 2014
How to check whether Oracle instance is started using pfile or spfile?
SQL> show parameter spfile;
NAME TYPE VALUE
-------------------------------------------------- ----------- ----------------------------------------------------------------------------------------------------
spfile string F:\APP\PRABHAKAR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
It gives path of spfile file which is getting used by database for starting up.
It means my database is using spfile
No value is displayed because database is not using spfile it is using pfile.
It means database is using pfile for startup.
Subscribe to:
Posts (Atom)