Group Discounts available for 3+ students and Corporate Clients

Statistics Gathering

1. Gather Schema Statistics
1.1. To gather schema statistics we will submit a request using the requests window,
System Administrator: Requests > Run
1.2. Select Gather Schema Statistics from the LOV in Name field and then on Parameters window select ALL in the Schema Name field.



Note: For further details of parameters click the Help (B) or for more details read about GATHER_SCHEMA_STATS.
1.3. Click OK (button).
1.4. Now schedule as per your requirements. I have scheduled it to run this request every Sunday mid night for one year.



1.5. On clicking OK (button) as we have selected Save this schedule the following window will appear,


1.6. Enter Name and Description of the schedule and press OK (button).
1.7. Now on the main window Submit the request by clicking Request (button).
1.8. Also have a look on the following requests you may submit as per your requirements



1.9. I had submitted a request to show the log file and next day I viewed the log file which is show below,
Note: Please note the time taken on vision machine so it will vary on the size of data. For this reason I scheduled it at mid night.


+ —————————————————————————+

* * Starts* * 15-SEP-2006 23:55:08

* * Ends* * 16-SEP-2006 05:28:45

+ —————————————————————————+





“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Statistics Gathering"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6