Friday, December 26, 2014

DBD::mysql::st execute failed: Table './bugs/bugs_fulltext' is marked








mysql> REPAIR TABLE bugs_fulltext;

| Table  | Op     | Msg_type | Msg_text | 
 bugs.bugs_fulltext | repair | status   | OK       |

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


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.