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
Category: ORACLE
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 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; |
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
“sending ioctl to a partition!” Error in System Messages in Oracle Linux
On Linux systems running Oracle database, the following error messages are displayed due to bug 17186167. The problem is fixed
What is the endian format in Oracle databases?
What is Endian? Endian is the storage method of multi-byte data types in memory. In other words, it determines the
ORA-01017: invalid username/password error received during connection to standby database
Even if the password (orapwSID) file in the primary database is copied to the standby database side and the you
Find How Much Time Left For Query Completion Oracle
We can use the information in the v$session_longops view to determine the working time and the remaining time of a
How To Compress Data Pump Export
Since Oracle 11g version, Data Pump allows to compress the backup before writing to dump file with “compression” parameter. The
ORA-27104: system-defined limits for shared memory was misconfigured
In the Oracle 12c version, during database creation with dbca, this error is received because the shmall kernel parameter is