Monthly Archives: settembre 2014

Problem affecting rman and redolog
  • 30
    Set

Problem affecting rman and redolog

  I have worked on a db  were a rman configured to make a backup every 2 hour that means every two hours we found in the alert.log ALTER SYSTEM ARCHIVE LOG and the db suddenly slows. The problem was the db has only 3 redolog. When the backup started rman forces the ALTER SYSTEM ARCHIVE LOG and...

Read More
Search records and null
  • 24
    Set

Search records and null

Find in a table, for any field of the table, how many records are NULL, and of these NULL how many separate by values of another field of the same table. Example result: TAB_NAME                      COL_NAME                      NUM_ROWS                   NUM_NULLS_TOT       NUM_NULLS_X_COLVAL               COLVAL_LE_ID ------------------------------------------------------------------------------------- S_REPORT                        S_TAX_BRACKET_CD                        7111600   7111599   2470            631 S_REPORT                        S_TAX_BRACKET_CD                        7111600   7111599   57859         FC222200 S_REPORT                        S_TAX_BRACKET_CD                        7111600   7111599   3038882   Z2030...

Read More