Oracle Tunning SQL Optimization Statement Hint

** Credit Web
SQL Optimization Tips oracle hint
Optimal adjustment of the database in SQL, it often will use HINT tips. Currently supported HINT ORACLE as follows:
In the SQL statement optimization process, we often use hint, is to sum up the optimization process in the SQL usage in the common Oracle HINT:
1. / * + ALL_ROWS * /
Show that the choice of the block cost-based optimization method, and the best throughput, minimize consumption of resources.

Note: Alert log show Memory Notification Library Cache Object loaded into SGA

** Credit Web
ในกรณีที่เจอข้อความ object ที่ load เข้า SGA แล้ว เกิน Heap ที่กันไว้ใน SGA ถ้าไม่ได้ใช้ automatic manage memory
Memory Notification: Library Cache Object loaded into SGA
Today, I checked alert.log file. I found:
Memory Notification: Library Cache Object loaded into SGA
Heap size 9426K exceeds notification threshold (8192K)
When I found out on metalink:
These messages are report in alert.log after 10g Release 2 is installed.
Cause:
These are warning messages that should not cause the program responsible for these errors to

Query cache Tables-Indexes without index maxextend fragment and Not index

** Credit Web

Tables/Indexes

Here are some scripts related to Tables/Indexes .

Tabs w/ Questionable Inds

TABLES WITH QUESTIONABLE INDEX(ES) NOTES:

Owner - Owner of the table

Table Name - Name of the table

Column - Name of the column in question