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 »
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 »
How to check specific user account details in a Oracle database
1.How to check a specific user account details in a database set lines 400 pages 400col USERNAME for a20col ACCOUNT_STATUS
How to check specific user account details in a Oracle database Read More »
How to check alert log file using SQL query
If you want to know how to query the alert log file then you are in the right place. Today
How to apply PSU patch on dataguard environment
Step-by-Step Applying PSU Patch : 1.Download the latest Opatch Tool and latest patch from My Oracle Support.p28163133_122010_Linux-x86-64.zip —>PSU patchp6880880_122010_Linux-x86-64.zip —>Opatch
How to apply PSU patch on single instance database
Step-by-Step Applying PSU Patch : 1.Download the latest Opatch Tool and latest patch from My Oracle Support.p28163133_122010_Linux-x86-64.zip —>PSU patchp6880880_122010_Linux-x86-64.zip —>Opatch
How to apply PSU patch on single instance database Read More »