How To Check Page Verify Option of Databases Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we
ORA-20001: Statistics Advisor: Invalid task name for the current user
During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA
How To Check Last Log Backup Time Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we
How To Move Datafile Online in Oracle 12c
In Oracle 12c databases, datafile can be moved online. In earlier versions this was not possible. With 12c, a datafile
How To Check Auto Close Option of Databases Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we
Data Pump Import/Export is Running Slow or Hangs
When Data pump is running slowly or when it is hanging, determining which query is currently running will help in
How To Check Whether Data File Sizes is Reached a Specific Size Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we
How To Check the Status of Data Pump Master and Worker Processes
You can access summary information about the status of Data Pump Master and worker processes with the following query.
|
1 2 3 4 5 6 7 8 9 |
SELECT s.sid, s.module, s.state, s.event AS event, s.seconds_in_wait AS secs, sql.sql_text AS sql_text FROM v$session s JOIN v$sql sql ON sql.sql_id = s.sql_id WHERE s.module LIKE 'Data Pump%' ORDER BY s.module, s.sid; |
How To Check Whether Readable Secondary is Enabled on Availability Groups Using Policy Based Management
Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
We can receive this error in the case of many sorting or join operations in 12c databases. The reason for