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 »
Today in this article we will learn about some basic Linux commands for DBAs that you should know while working
Basic Linux commands for DBA : Read More »
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 »
If you want to know how to query the alert log file then you are in the right place. Today
How to check alert log file using SQL query Read More »
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 dataguard environment Read More »
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 »