Tablespace is Growing fast in Oracle Database :
Tablespace is a logical storage structure of a database that contains tables, indexes etc. So if a table, lob partition or index is growing high, then the corresponding tablespaces will…
Basic Commands in RAC:
As an experienced DBA, we must know the basic commands in RAC for Oracle DBA. So, today in this article, we will learn some basic commands in RAC (Oracle Database)…
What is granules in Oracle Database :
Granules in oracle refers to a unit of memory allocation used for managing the SGA (System Global Area) memory structure or we can say it is a unit of contiguous…
How to find the DDL of a user in Oracle Database:
Today in this article, we will learn how to get the DDL of a user in Oracle Database. This can be useful when migrating the database as well and we…
How to get the DDL of a Tablespace in Oracle :
To find the DDL (Data Definition Language) of a tablespace in Oracle Database, we can work the DBMS_METADATA package.A tablespace consists of one or more physical data files. DDL of…
How to find DDL of a table in Oracle Database :
Tables are an essential component that store data in a structured manner. At times, you may need to find the DDL of a table in Oracle database, which is a…
Enable-Disable Archivelog Mode in Oracle Database:
Here we will learn how to enable-disable archivelog mode in Oracle database. But why do we enable-disable archivelog mode in oracle database and why it is important? First of all,…
How to check oracle database users with critical system privileges:
1.SELECT_ANY_DICTIONARY: SELECT GRANTEE, PRIVILEGEFROM DBA_SYS_PRIVSWHERE PRIVILEGE='SELECT ANY DICTIONARY'AND GRANTEE NOT IN ('DBA','DBSNMP','OEM_MONITOR','OLAPSYS','ORACLE_OCM','SYSMAN','WMSYS'); 2.SELECT ANY TABLE: SELECT GRANTEE, PRIVILEGEFROM DBA_SYS_PRIVSWHERE PRIVILEGE='SELECT ANY TABLE'AND GRANTEE NOT IN ('DBA', 'MDSYS', 'SYS', 'IMP_FULL_DATABASE', 'EXP_FULL_DATABASE','DATAPUMP_IMP_FULL_DATABASE',…
Basic Linux commands for DBA :
Today in this article we will learn about some basic Linux commands for DBAs that you should know while working that may help to troubleshoot in your daily tasks. Also,…
Steps to Check if an Oracle Database is Performing Slow:
As a DBA it is very common in our daily basis scenarios if a database is performing slow. You should be a performance expert too along with a database administrator.…