Basic Commands in RAC:
As an experienced DBA, we must know the basic commands in RAC for Oracle DBA. So, today in this article, […]
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
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
How to find the DDL of a user in Oracle Database: Read More »
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
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
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
Enable-Disable Archivelog Mode in Oracle Database: Read More »
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
How to check oracle database users with critical system privileges: Read More »
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
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
Steps to Check if an Oracle Database is Performing Slow: Read More »