Category: Oracle

Find Oracle SQL Execution History Details

DBAs are always asked about the database performance issues, which are mostly caused by some SQL queries’ execution plan changes.

This post demonstrates how to get a SQL query performance details like executions, disk/physical read/write, cpu time, elapsed time and waiting time, etc.

With the help of those statistics of a specific SQL query, DBA can easily identify the issue, and remediate it by applying SQL plan baselines.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Log in

What to Check Before Truncate a Table?

This post shows what need to be checked before truncating a table in Oracle. Otherwise it might cause unexpected tables’ data loss and application outage in mission critical environment.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Log in

ORA-31633: unable to create master table SYS_EXPORT_SCHEMA_01

The following errors occur when exporting/importing through data pump:

 ORA-31626: job does not exist
 ORA-31633: unable to create master table "USERNAME.SYS_EXPORT_SCHEMA_01"
 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
 ORA-06512: at "SYS.KUPV$FT", line 1048
 ORA-01031: insufficient privileges

SOLUTION

To make sure user ‘USERNAME’ to have enough privileges to do import/export.

How to Create Service on Non-RAC PDB

As we know, we can use ‘srvctl’ utility to create a service for a RAC database. Now I demonstrate how to create a service for a standalone CDB/PDB database.

For non CDB/PDB database, we can use ‘service_name’ parameter to specify service names.

SQL> show parameter service_name;

 NAME             TYPE    VALUE
 --------------- ------- ------------------
 service_names   string  HR,STOCK,INVENTORY

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe

ORA-04021: timeout occurred while waiting to lock object

When manually compiling a package body, the following error occurs:

SQL> alter package USER.PKGNAME compile body;
alter package USER.PKGNAME compile body
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object USER.PKGNAME

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe