In Oracle database, a tablespace is a logical storage container that is used to store data objects, such as tables, indexes, and partitions. It is a way to organize and manage the physical disk space used by the database. Each tablespace consists of one or more data files, which are the actual physical files on […]
SQL Query To Find The Space Utilization of Tablespaces In Oracle Read More »
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 »
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 »
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
This article can guide you to alter the DBID for Oracle databases whenever we are in need of it. Here we will use DBNEWID utility to change the same. Below are the steps to follow. Steps to Change the DBID for Oracle Database Before starting the process of changing the DBID please ensure you have
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 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 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 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 »
