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.…
Learn Oracle Administration best practices, configurations, and expert tips for smooth database management. Optimize performance and security today!
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…