How to Check Oracle 11g 12c Database Wallet is Open or Not? v$encryption_wallet

If Oracle wallet is enabled in your oracle database and if you forget to enable the wallet after opening the database you will get following error.
ORA-28365: wallet is not open
In case if you try to access RMAN backup you will get following error message
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open
There is one data dictionary view v$encryption_wallet for the same to check. 

Oracle: SQL Query to Find out Index Name, Column Name for Table

It is common requirement for a developer or DBA to find out the index name, column name for the table. Sometimes the index would be composite index. So in that case we have to find out that also like how many columns associated with the index and their order. There are 2 data dictionary views for the same. DBA_INDEXES and DBA_IND_COLUMNS. DBA_INDEXES gives just index names associated with the table and DBA_IND_COLUMNS gives the associated columns and their order.

How to Backup and Recovery Using Backup as Oracle RMAN Image Copy

RMAN image copy backup will take more space than the normal RMAN backup as it takes the entire datafile file as backups. But some situations we can use this method to backup and restore the database. Here is the method and RMAN command syntax for the same.
1.   Backup the database

Query to Find Out The Total File Size And Data Occupied Size Of Oracle Database

1. Here is the query to find out the total file size of a Oracle database

( select sum(bytes)/1024/1024/1024 DF_size from dba_data_files ) +
( select nvl(sum(bytes),0)/1024/1024/1024 TF_size from dba_temp_files ) +
( select sum(bytes)/1024/1024/1024 RLF_size from sys.v_$log ) +

Sql Query to Get Hostname, IP Address and Terminal from Oracle Database

If your user doesn't have DBA privilege then you can use SYS_CONTEXT function to get the hostname and IP address.

Option a. sys_context
('USERENV', 'SERVER_HOST') from dual;


Stop / Disable automatic ads web page opening in Chrome / IE browsers ( ,

In last few days I have been facing a problem in my browsers like automatically some WebPages are opening without asking anything. It is quite disturbing during the serious browsing and it is slow down my system performance also. The websites are like, etc. sometime it opens the corner popup in the web pages.

How to Increase, Decrease or Resize FRA(Flash Recovery Area) in Oracle Database?

Above two links will help you to configure and check the usage of the Flash Recovery Area (FRA) in Oracle. Now here is the method to resize the FRA in oracle database.
You can use below mentioned commands to see the already allocated space for the FRA.

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google