OraFAQ Forum: Performance Tuning » How to create "stats$tab

Home » RDBMS Server » Performance Tuning » How to create "stats$tab_stats" ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create "stats$tab_stats" ? [message #64835]

Tue, 17 February 2004 19:19

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?

Report message to a moderator

Re: How to create "stats$tab_stats" ? [message #64837 is a reply to message #64835]

Wed, 18 February 2004 02:16

Thiru
Messages: 1089
Registered: May 2002

Senior Member

You probably need to run 'create_object_tables.sql' script , as perfstat .

Report message to a moderator

Re: How to create "stats$tab_stats" ? [message #64842 is a reply to message #64837]

Wed, 18 February 2004 15:46

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!

Report message to a moderator

Previous Topic:	Expensive Hardware, not much faster!
Next Topic:	ora-0313 and XML

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 06 12:24:28 CST 2023