OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Table statistic

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

Table statistic [message #390268]

Thu, 05 March 2009 12:25

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
Is there a way to find if the table statistics is corrupted or not? I have a table NUM_ROWS is less than Sample Size. How is this possible? Can anyone through some light?
Thanks

Report message to a moderator

Re: Table statistic [message #390270 is a reply to message #390268]

Thu, 05 March 2009 12:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

After Messages: 123 why do you refuse to follow Posting Guidelines?
http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Table statistic [message #390278 is a reply to message #390268]

Thu, 05 March 2009 12:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Where is the problem? I don't see anything of what you did.

Regards
Michel

[Updated on: Thu, 05 March 2009 12:45]

Report message to a moderator

Re: Table statistic [message #391571 is a reply to message #390268]

Thu, 12 March 2009 10:50

dba-assist
Messages: 3
Registered: November 2008

Junior Member

[deleted] will show you table statistics, num_rows, last_analyzed, etc

[Updated on: Thu, 12 March 2009 12:59] by Moderator

Report message to a moderator

Re: Table statistic [message #391584 is a reply to message #391571]

Thu, 12 March 2009 11:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As well as a simple query on dba_tables.

STOP SPAMMING ALL TOPICS WITH YOUR USELESS TOOL.

Regards
Michel

[Updated on: Thu, 12 March 2009 11:33]

Report message to a moderator

Previous Topic:	db instance doesn't start automatically
Next Topic:	need help to get space from tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 20:23:51 CST 2024