troubleshooting Question

how do I get data counts for tables in a database that has 6 terabytes of data

Avatar of sikyala
sikyalaFlag for United States of America asked on
Oracle DatabaseLinux
17 Comments4 Solutions546 ViewsLast Modified:
I have a test environment and a production environment. I have production data in my test environment. I want to get a count from both databases and identify the count difference if any between the environments. A script was initially used to do a count against dba_tables. However, soon we discovered that the count isn't accurate until after the table (s) have been analyzed. Is there another method out there besides doing a count on the table themselves? I have tried looking at using statistics. However, it is unclear how to use it to get the information I need. Does anyone know what I can do to get this information?
Join our community to see this answer!
Unlock 4 Answers and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros