Oracle

How to Trace the Password Change History of Oracle Database Accounts

Question: How to Monitor Password Change History? Oracle only tracks the date that the password will expire based on …

About Schema Only Accounts Schema is a collection of objects, while db user is an account to connect to the instance.

The Problem Unable to rename or delete the ASM disk. This disk is on multipath introduced to 2 node cluster. The disk is …

The Problem On CentOS/RHEL 6.x there are too many kdmflush processes owned by the root user which was notified after …

The Problem The free space as shown by the dba_free_space seems incorrect. The total space used by all the segments in …

The Problem When trying to connect to a database as sysdba, ORA-12545 is occured and connection is failed. For Example:

Question: DB_FILE_MULTIBLOCK_READ_COUNT is set to 16 in the spfile. How to unset the parameter as it keeps reverting …

There are two kinds of initialization parameters: Dynamic initialization parameters can be changed for the current …

The goal of this post is to provide steps to add, remove, replace or move an Oracle Cluster Repository (OCR) and/or …

It is not possible to directly restore a manual or automatic OCR backup if the OCR is located in an ASM disk group.

The script provided below will report On Space Usage in Tablespaces. Access Privileges required: SELECT on …