Thehelpfuldba.com

Running the SQL Health Check (SQLHC) report – A DBA's blog

In my case, the SQL was running for greater than 5 minutes so I was able to get the SQL id quite easily. Run the SQLHC tool as follows: Sign on as sysdba. Issue the command as follows: START sqlhc.sql T 3t3ypamk8wu40. the first parameter “T” indicates that my site has the SQL tunning pack. (Valid values are Tuning (T), Diagnostics (D) or

Actived: 8 days ago

URL: https://thehelpfuldba.com/running-the-sql-health-check-sqlhc-report/

ORA-01157 while activating a physical standby database

WebWe had previously created a 2 node RAC physical standby database. Today, we were attempting to bring it up as a primary by issuing the commands: startup mount; …

Category: Health Go Health

Lost connection to your session during a restore database

WebIf you are restoring a database in rman and you lose connection to your session due to a network blip, you can resume the restore after the network connection …

Category: Health Go Health

Script to connect to multiple Linux servers with Python & Paramiko

WebThe script reads in a text file with a list of servers and then logs on to each server and tests if I am able to successfully log on with my user account. In order for the …

Category: Health Go Health

February 2018 – A DBA's blog

WebThis week a colleague of mine was building a physical standby. The method she had chosen was to copy the backups from the primary server to the standby server and then restore …

Category: Health Go Health

General – Page 5 – A DBA's blog

WebPlease see blog post entitled “Moving undo table spaces on a RAC with users online” for some additional background. In summary, we had to free up space on a certain ASM …

Category: Health Go Health

Oracle – Page 6 – A DBA's blog

WebThis week a colleague of mine was building a physical standby. The method she had chosen was to copy the backups from the primary server to the standby server …

Category: Health Go Health

Databases – Page 7 – A DBA's blog

WebIf you have a SQL performance issue, Oracle Support may request you to run the SQL Health Check script. This is a pretty cool process, so I thought I would document it.

Category: Health Go Health

thehelpfuldba.com

WebSQL Tuning Health-Check Script (SQLHC). Oracle will usually ask for this tool to be run to assist in diagnosing a SQL performance isse. The tool is used to check the environment …

Category: Health Go Health