Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.ADM_SQL_SCORES
Displays the SQL and PL/SQL code that potentially impacts the database performance the most. The top entries are likely candidates for improvements and may need to be investigated further. The impact_score is the product of the scores for executions, parse calls, disk reads per execution, buffer gets per execution, physical read requests per execution, physical write requests per execution, CPU time per execution, I/O wait time per execution, and the PL/SQL-to-SQL ratio. Each of these scores are in the range [0,10]. The higher the number the more impact it has on the performance of the database.