It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log when redo log switch is over frequently. So suggestion is to Increase the Size of the Online Redologs to reduce Redolog Switch Frequency. And this may also required to improve primary database performance. Please note if using Maximum Protection mode, … Read more
Database server crashed after memory on server used by inactive sessions The Following Example used to illustrate the scenario for User XX, please Review and modify whatever needed to confirm Automatic Kill of the Huge number of Inactive Sessions after a period of Idle Time . 1.CREATE THE PLAN 2.CREATE THE CONSUMER GROUPS 3.CREATE DIRECTIVES … Read more
We may need to find the database growth for different periods in the past. This Article provides the queries to find the monthly database growth OR Segments growth OR Specific Database Schema in the past days based on the AWR snapshots. There are different strategies for calculating the Monthly Growth of the Database : You … Read more
Below Are the differences b/w exp/imp vs Datapump 1. Datapump operates on a group of files called dump file sets. However, normal export operates on a single file. 2. Datapump access files in the server (using ORACLE directories). Traditional export can access files in client and server both (not using ORACLE directories). 3. Exports (exp/imp) … Read more
When executing a Materialized View refresh an ORA-01555 is returned. This returns the following type of error either in the alert.log : There are several solutions that can assist here, outside of the normal UNDO Tuning practices from the note above: 1. Increase the UNDO_RETENTION parameter beyond the threshold seen from the alert.log message for … Read more
Refreshing a Materialized View via the Oracle job scheduler reports the following errors, however manual refresh succeeds. Troubleshooting steps: Object Privileges – If the owner has not granted explicit rights to these objects the scheduled job will fail. To implement the solution, please execute the following steps: Example: If the mview is REFRESH FAST type, … Read more