Performance Tuning | PeopleSoft Tutorial

Tag Archive

Tag Archives for " Performance Tuning "

Enabling Automated SQL Tuning in Oracle 11g

You need to identify if Automatic SQL Tuning job is enabled and regularly running. Use the following query to determine if any Automatic SQL Tuning jobs are enabled: SELECT client_name, status, consumer_group, window_group FROM dba_autotask_client ORDER BY client_name; If the Automatic SQL Tuning job is enabled, you will see something like this:       […]

Continue reading
1 2 3
>