Teckstack

ALPHAGEEK369
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”
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.