Home » RDBMS Server » Performance Tuning » How to create "stats$tab_stats" ?
How to create "stats$tab_stats" ? [message #64835] Tue, 17 February 2004 19:19 Go to next message
Tian Maohuai
Messages: 23
Registered: December 2003
Junior Member
I'm learning "Oracle High-Performance SQL Tuning" written by Donald K. Burleson.When I run "rpt_object_stats.sql",it says that "stats$tab_stats" is not found,I want to know how to create it?
Re: How to create "stats$tab_stats" ? [message #64837 is a reply to message #64835] Wed, 18 February 2004 02:16 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
You probably need to run 'create_object_tables.sql' script , as perfstat .
Re: How to create "stats$tab_stats" ? [message #64842 is a reply to message #64837] Wed, 18 February 2004 15:46 Go to previous message
Tian Maohuai
Messages: 23
Registered: December 2003
Junior Member
Thank you,Thiru.I've found the 'create_object_tables.sql' as you said,it works.Thanks!
Previous Topic: Expensive Hardware, not much faster!
Next Topic: ora-0313 and XML
Goto Forum:
  


Current Time: Tue Sep 22 07:36:53 CDT 2020