I would like to introduce this very useful utility from Oracle. ORAChk, previously known as RACCheck tool, can be used to verify/audit your Oracle databases environment. 121 more words
Tags » 11g
Result cache is a powerful tool to gain performance in PL/SQL.
There are many examples on the internet that proves this, e.g. these articles on All things Oracle: 958 more words
From time to time, when working at various sites I have to check connections to a database. If you have been an Oracle DBA for some time, you already know that the listener has to be up and services have to be registered before you can connect from a remote host. 310 more words
AWR reports are very very important for tuning any database. At times you may not get access to PRODUCTION databases(sounds stupid, but really happens though you are DBA but will not have access to PROD) but you need to review the PRODUCTION database, during that time, one of the best way is to get the dump of AWR snapshots from the PRODUCTION database and load them to your local database and you can review entire database locally with out accessing PRODUCTION database. 1,391 more words