SKIP DATAFILES DURING RMAN DATABASE BACKUP

I was taking backup of a database which got failed due to corrupted datafiles. Backup keep on failing for the whole database, even though one of the datafile is corrupted. After searching for the documentation to skip the particular datafile and take backup of remaining 95% of the data, i was able to get some … Continue reading “SKIP DATAFILES DURING RMAN DATABASE BACKUP”

CAN WE GRANT ACCESS TO MULTIPLE TABLES AT A TIME IN ORACLE?

The answer is NO 1)Workaround can be to use the script to generate multiple grant statements 2)Use ROLES as a standard way

TRUNCATE TABLE HANG OR SLOW ORACLE

Truncating a table is faster compared to delete statement in a database. But if the truncate itself is slow, then what may be the cause for the slowness? If flashback archive is enabled for a table which needs to be truncated. In this case, additional overhead is needed to mimic the data which need to … Continue reading “TRUNCATE TABLE HANG OR SLOW ORACLE”

ORA-00059: maximum number of DB_FILES exceeded

Check the parameter db_files Increase the value for number of datafiles

STATSPACK’S IMPORTANCE IN ORACLE DATABASE STANDARD EDITION

How to identify the historical statistics of the database performance during below two circumstances? When using standard edition When there is no license for diagnostics pack, even though database is enterprise This is where statspack gives a helping hand Enable stats pack snap immediately in the database, if the database is exposed to non diagnostics … Continue reading “STATSPACK’S IMPORTANCE IN ORACLE DATABASE STANDARD EDITION”

AWR SNAPSHOTS ARE NOT GENERATED – UNABLE TO GENERATE AWR/ADDM/ASH REPORT IN ORACLE DATABASE

AWR snapshots are crucial for the oracle performance diagnosis report to troubleshoot any critical slowness in the database operations If snapshots are not either fully or partially collected due to some reason, then valuable information is lost which will be really revenue bleed for any organization without any RCA or Proactive tuning. There are two … Continue reading “AWR SNAPSHOTS ARE NOT GENERATED – UNABLE TO GENERATE AWR/ADDM/ASH REPORT IN ORACLE DATABASE”

ORA-28014: cannot drop administrative user or role

Solution:

SQL QUERY TO DISABLE HIDDEN PARAMETERS IN ORACLE