Toad World® Forums

How to Get Row Count in Schema Browser


#1

I want to have the row count displays next to each table in my schema browser, and I need your help to make this happen, for example,

EMPLOYEE (1312)

The following is an excerpt from the online help from “TOAD for Oracle”:

To get the rowcount for a dataset

In the right hand side, right click over the data grid and select Get Rowcount.

But, when I right click over the data grid(RHS), I only have the ‘configure’ option without **‘Get Rowcount’ available.

I have looked all over the options in View|Options and online help, but I still cannot make the total of row counts displays next to each table in my schema browser. I know there is probably a setup option to turn On/Off for this, but I just cannot find it.

Any/all the help on this would be greatly appreciated.

Thanks.
**


#2

[ Attachment(s) from John Dorlon included below]

What version are you running? It should be right there on the grid. See
attachment.

You can also right-click on the table name in the LHS and choose “Record
Count” there. You can muliselect tables to see record count on that one.

Another thing you can do, if your tables are analyzed, is turn on the Num Rows
column in the SB LHS. I added an attachment to show you how to do that too.
(just right click on the column header in SB LHS).

-John


#3

Err… The help says:

“to get the rowcount for a dataset”

You asked for

“to have the row count displays next to each table in my schema
browser”

Those are two very different things. And before you insist on an automated
rowcount for every table, you might want to follow up with your DBA to ask if
that’s such a good idea.

If you’re not sure what I mean with the above, try this as a test in a Dev
– Not PROD – environment:

Issue the command:

SELECT ‘SELECT Count(1) FROM ‘ || table_name || ‘;’

FROM all_tables

WHERE owner = ‘[schema]’

Replace [schema] with your own selection of course.

Store the resulting dataset (remember that word from the help file?) in a file
named count_everything.sql.

Then run it… remember, do this in a Dev, not PROD environment.

Then consider the length of time, with the size of the tables in the schema you
choose in relation to an environment that may have 200 to 300 tables with
numerous tables having 1 million to 30 million rows in them. What you are asking
for is a very, very bad idea from a resource perspective. I’m sure your
experienced DBA will agree with me.

Roger S.


#4

You can muliselect tables to see record count on that one.

I stand corrected, the functionality is there but I’d still highly
recommend you exercise caution when using it.

Roger S.


#5

If it makes you feel any better, Roger, it uses unique indexes when possible.
:slight_smile:

I agree though, you should be careful with this…it could result in a very long
running query!


#6

If it makes you feel any better, Roger,

it uses unique indexes when possible. :slight_smile:

Heh, I’m not just a developer. I also handle production support
responsibilities for a varied array of applications. It’s the
“production support hat” that’s talkin’ at the moment :wink:

Roger


#7

You wrote:

What version are you running? It should be right there on the grid. See
attachment.

Both Toad for Oracle 10.5 and 9.6 are available to me and both do not have ‘get rowcount’ option. Where is your attachment? How do I get it?

Thanks.


#8

I don’t know what ToadForOracle.com does with the attachments. Send me
an email and I’ll send them to you directly. John.Dorlon@quest.com


#9

Hello Roger,

Thanks for the useful information from DBA’s stand point of view. Your time and help is very much appreciated. FYI, I have been corresponding with John Dorlon through emails so that I could view his attachments and screenshots. As of this writing, I believe John has provided solutions to meet my needs.

p.s. I will copy and paste John’s solutions to this posting later.

Thanks again,
Jinlan


#10

Hi John,

You are wonderful and thank you very much for your help. Your suggested solutions work!. I tried to share your solutions on this posting, but I am having problems to post this thread after I cut/pasted your solutions. For some reason, the Toad Commercial Discussion has difficulty to post my message with 'cut/paste/ text in Mozilla Firefox (Sorry Everyone, I tried to share John’s solutions but all tries failed.)

If you are interested in John’s solutions, please let either john or myself know, and I can assure you that you will receive his solutions, one way or the other.

Cheers and thanks again,
Jinlan