Home » RDBMS Server » Server Administration » one query plz
one query plz [message #219716] Thu, 15 February 2007 11:44 Go to next message
pavan27
Messages: 50
Registered: December 2006
Location: bangalore
Member
hai to every one,

i want to know how many rows are in each table in the user tables

regards,
pavan

Report message to a moderator

Re: one query plz [message #219717 is a reply to message #219716] Thu, 15 February 2007 11:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Update your stats, look into num_rows.
But this information may always not be reliable.
As the stats get outdated, values of NUM_ROWS are outdated.
The value of NUM_ROWS depends on stats and someone can easily change it using dbms_stats.

Report message to a moderator

Re: one query plz [message #219718 is a reply to message #219717] Thu, 15 February 2007 11:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And please search before posting. There many threads talking about this.
http://www.orafaq.com/forum/m/121074/42800/?srch=num_rows#msg_121602

Report message to a moderator

Previous Topic: Tablespace migration : Local to dictionary
Next Topic: Why we find 2 ADMINS ( SYS and SYSTEM )!!?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:29:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.