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.
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).
“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.
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
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.
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.
