Auditing is the monitoring and collection of some user database actions and record these data in some tables. Auditing is always enabled. Oracle Database generates audit records during or after the execution phase of the audited SQL statements. But AUD$ table will growth and will impact the performance of database.

The AUD$ table is used for the database auditing purpose suc as:
CREATE SESSION,
LOGON, LOGOFF,
SELECT, INSERT, DELETE

When AUDIT_TRAIL is set to either DB or DB_EXTENDED value. From 11g forwards AUDIT_TRAIL is activated by default and it is set to DB.

We need to maintain AUD$. So let us see how we can achieve this. Here is the step by step actions

Yazının devamını oku »

As you know both option must be use by Oracle licenses. Before we start we need to clarify some information.

Oracle Standard Edition or Standard Edition xx; there are no management packs. These can be purchased only with the Enterprise Edition, and they are also not a part of the Oracle Personal Edition. As i said before you need to license those option separately

Yazının devamını oku »

I love to join some event if i had free time. One of my friend invited me to join their session to talk about What data is become important, what we do as a dba in future, what oracle do for future etc.

Yazının devamını oku »

You may need to enable or disable EM express on 12c. Do not forget you still can use cent browser for java related screens

Here is the steps and controls

Yazının devamını oku »

You can find related script by below

Enjoy!!

Yazının devamını oku »

You may need to move some objects to another tablespace or you may need to move all objects to one new tablespace under schema

I will share some sql statement to achieve this purpose. Here is the steps:

Yazının devamını oku »

These days, CDs and DVDs are not popular. However, you still may need to use CD drive to able to insert a disc and mount it on Linux for your needs.

In this post we will do it step by steps. Here are the our steps:

Yazının devamını oku »

This issue often occurs at Oracle database 12c installation process. But I faced with that error message during restore/recovery operation…

This error occurs whenever we want to mount the database but the multitenant container database was not set up properly. To fix this, follow below commands

Yazının devamını oku »

As you know Redo files are one of the most important file for Oracle databases. It have to be mirror and also have big enough for performance and contunity.

In Oracle formal documentation, redo switch should be between 6-8 in 1 hour. If you have a number than this( its also related what you are running) you need to change your redolog file size.

In this post, I try to explain how we can resize redolog files on RAC instance while we have ASM.

Yazının devamını oku »

In some case, you would need to move or rename your datafiles which is belong to your tablespaces in your database.

I try to explain step by step how you can move your data files on your system.

Yazının devamını oku »