Common Issues

How To Drop A Database In Oracle | How To Drop Oracle Database Manually

Through this article, we will learn to drop a whole database in Oracle manually with commands.  We can also use the DBCA utility to drop a whole database but this is not in scope for today’s discussion. Steps to follow for dropping a database Please follow the below steps to drop a database successfully.  Please […]

How To Drop A Database In Oracle | How To Drop Oracle Database Manually Read More »

Rolling Forward Physical Standby Database Using Recover From Service Command

From 12C onwards Oracle has introduced a new way of rolling forward a physical standby database by using recover from service commands. There could be a scenario where we need to roll forward a standby database from an archive log gap where the standby lags behind the primary. Our aim is to remain the standby

Rolling Forward Physical Standby Database Using Recover From Service Command Read More »

Temp Tablespace Usage in Oracle

Below queries can be helpful to find details regarding temp tablespace usage. Temp segment usage per session SELECT   S.sid || ‘,’ || S.serial# sid_serial, S.username, S.osuser, P.spid, S.module, P.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used, T.tablespace, COUNT(*) statements FROM v$sort_usage T, v$session S, dba_tablespaces TBS, v$process P WHERE T.session_addr = S.saddr AND

Temp Tablespace Usage in Oracle Read More »

Managing Tablespaces | Tablespace Administration

Oracle database is having of one or more logical storage units called tablespaces, which collectively store all of the database’s data. Every tablespace at Oracle database having one or more files called datafiles, which can be find at the operating system in which Oracle is running. This article will guide you for managing tablespaces with

Managing Tablespaces | Tablespace Administration Read More »

Tablespace Utilization in Oracle | How to Check Oracle Database Tablespace Utilization

Tablespace management in an Oracle database is very much needed and something a DBA needs to do act on it very frequently. It’s DBA job to maintain enough space in the tablespaces in order to have smooth functioning of application and database. This tablespace query can be very helpful when you are trying to understand

Tablespace Utilization in Oracle | How to Check Oracle Database Tablespace Utilization Read More »

How to Find Table Fragmentation in Oracle Database | Reclaim The Fragmented Space

How to find Table Fragmentation in Oracle Database What is Oracle Table Fragmentation? If a table is only subject to inserts, there will not be any fragmentation. Fragmentation comes with when we update/delete data in table. The space which gets freed up during non-insert DML operations is not immediately re-used (or sometimes, may not get reuse ever

How to Find Table Fragmentation in Oracle Database | Reclaim The Fragmented Space Read More »

Adjusting The Password Expiration Policy | PASSWORD_LIFE_TIME

Adjusting The Password Expiration Policy / PASSWORD_LIFE_TIME Doing a default database installation will install a feature that all passwords will expire after 180 days and being unaware of that can be a serious problems in applications as they are unable to connect to the database post that time period. It will cause unnecessary downtime for the

Adjusting The Password Expiration Policy | PASSWORD_LIFE_TIME Read More »