Making Oracle simple for you!

Simplifying Oracle learning by sharing knowledge with professionals across the globe

How to check FRA location utilization in Oracle

Flash Recovery Area must be monitored regularly. Sometimes FRA runs our of space and a DBA must be able to gather FRA space utilization. It is very important to monitor space usage in the fast recovery area to ensure that it is large enough to contain backups and other recovery-related...

READ MORE

How to check last modified table in Oracle

As a DBA, application team sometimes might ask you to provide details of last modified table in oracle. The table modification can be insert, update or delete. Below queries get details of last or latest modified table in oracle database. Run the queries depending upon the database version. Last...

READ MORE

How to check check single table size in oracle

Once you run the query, it will ask your table name. Enter the table name in the format of owner.tablename. Eg - scott.emp select segment_name,segment_type, sum(bytes/1024/1024/1024) GB from dba_segments where segment_name='&Your_Table_Name' group by segment_name,segment_type;

READ MORE

How to check database PITR after refresh

Database refresh is common task for a DBA. But after every database refresh, you must check the PITR date and time. This should be checked before you issue OPEN RESETLOGS command. Query to Check PITR – Issue it before OPEN RESETLOGS select distinct to_char(checkpoint_time,'dd/mm/yyyy...

READ MORE

How ot check archive generation in Oracle

The below query gives results of archive generation in oracle database. Use below query to find the archive space requirements and you can use it to estimate the archive destination size perfectly well. Query to check archive generation in oracle SELECT A.*,...

READ MORE

How to disable firewall in Linux 7

Disabling firewall in Linux 5/7 versions is little bit different than Linux 7. Sometimes you need to disable firewall in Linux 7 version as part of Database installation pre-requisites. This article will help you to find the status of firewall and then enable / disable it. Firewall Status The...

READ MORE

How to query between dates condition in Oracle

select count(*) from DW.TB_PCDWH0091_FCT_PROJ_DTL where dw_load_dt between to_date('2016-09-01', 'YYYY-MM-DD HH24:MI:SS') and to_date('2016-10-31', 'YYYY-MM-DD HH24:MI:SS');

READ MORE

How to check view query in oracle

set long 20000; set pagesize 0 ; set linesize 1000; set feedback off ; set verify off ; set trimspool on; column text for a1000; SELECT text FROM dba_views WHERE view_name = '&VIEW_NAME';

READ MORE

How to check database lock conflict in Oracle

Database lock conflicts are one of the issues which DBA needs to deal with. The database locks can keep users waiting for very long and we much know how to check database locks. Users reporting that their query is taking too long to execute, then you must also check if there are any locks on the...

READ MORE

How to check tablespace utilization in Oracle

A DBA must maintain adequate space in database tablespaces in order to have smooth functioning. All the tablespaces must be below threshold value and they all must be online (In case if no tablespace is put offline). Below query gives the tablespace utilization percentages. Query to Check...

READ MORE