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.…
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 for a20col PROFILE for a30select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,LOCK_DATE,PROFILE from dba_users where USERNAME='&username';…
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 we will learn how to check the alert log using…
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 Review readme file on Patch 28163133. 2.Copy the patch and…
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 Review readme file on Patch 28163133. 2.Copy the patch and…
- Go to the previous page
- 1
- …
- 8
- 9
- 10
- 11