Hi All
what is the program that we run to get the statistics of the database.
Hello Sudhakar,
to collect oracle database statistics you should use the BR*Tools (brconnect):
http://help.sap.com/saphelp_erp2004/helpdata/EN/88/fce73a86e99c77e10000000a114084/content.htm
To view the statistics you can use the PL/SQL Package DBMS_STATS:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm
If you have the SQL Developer you can also query it very easily via GUI.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.