How To Find Invalid Hints
To err is human and to forgive divine 🙂 However, Oracle cannot forgive an invalidly implemented hint; it happens but the problem might cost you arm and leg. Here is a …
How To Find Invalid Hints Read MoreDBA Tips&Tricks
Long Running Queries Monitoring
Long-running queries might be a hard nut to crack. Whether you are curious about performance tuning or just want to be aware of what is going on in your database, …
Long Running Queries Monitoring Read MoreIdentify Full Table Scans
One of the most common issues I see is full-table-scan queries. It’s very easy to fix when you know which query is missing an index. This script will help you …
Identify Full Table Scans Read MoreSmart Database Design
Everything starts with the design. With an incorrect design, you will not be able to do practically anything and everything will be nothing but a struggle. I will provide you …
Smart Database Design Read MoreFind Foreign Keys Without Indexes
While there is a handful of cases where foreign keys without indexes might be useful and needed, more likely you will end up in a problem with unnecessary or plethora …
Find Foreign Keys Without Indexes Read MoreHow To Identify Non-Optimized Big Tables
Big tables have to be optimized. There is no use of huge tables having no indexes, partitions and other optimization features. Feel free to use this script to locate them …
How To Identify Non-Optimized Big Tables Read MoreCheck Memory Usage For Active User Sessions
This script will help you to figure out memory-heavy sessions actively running. WITH w_stat_data AS ( SELECT –+materialize s_stat.sid , s_stat.value FROM v$sesstat s_stat — LEFT JOIN v$statname curr_uga ON …
Check Memory Usage For Active User Sessions Read MoreCheck If You Can Safely Drop a User
The more complex your database gets, the more complicated it is to drop a user. Generally, it’s ok to lock users out only but sometimes (esp. if you are as …
Check If You Can Safely Drop a User Read MoreIndex Usage Monitoring
Sometimes we need to know whether an index is being used or not. Oracle thought about this as well and provides us with this option. ALTER INDEX my_schema.idx_name MONITORING USAGE; …
Index Usage Monitoring Read MoreLOG_FILE_SYNC Wait Event – Possible Solution
You might experience this issue which means LGWR (LogWriter) takes too long to write the content of Log Buffer Cache into REDO Log files. There are two possible causes. Overloaded …
LOG_FILE_SYNC Wait Event – Possible Solution Read MoreDB Overview – Tunning Tips
Hello, this script might give you a little bit of insight on how is your database performing. DECLARE v_value NUMBER; — outout setting v_ok VARCHAR2(50) := ‘<< Value seems to …
DB Overview – Tunning Tips Read More