DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Anyone Seen This Behaviour Before?

  1. 12-01-2005, 07:00 PM #1
    kc3
    kc3 is offline Junior Member
    Join Date
    Nov 2005
    Posts
    2

    Anyone Seen This Behaviour Before?

    I have a table with 500 million rows. This table is partitioned. When I look at the table with OEM, I can see the correct row count for the table and each partition. However, when I export the table, or do a select count(*) from sqlplus, I only see 7 million rows? Why the row mismatch?

    The table has not been analyzed but this shouldn't make any difference? I am using 9.2.0.7.
    Reply With Quote Reply With Quote
  2. 12-01-2005, 07:41 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    vpd?

    example?
    Reply With Quote Reply With Quote
  3. 12-07-2005, 11:38 AM #3
    BV1963
    BV1963 is offline Senior Member
    Join Date
    Nov 2001
    Posts
    335
    Quote Originally Posted by davey23uk
    vpd?

    example?
    Perhaps you are looking into 2 different databases/schemas?
    One, who thinks that the other one who thinks that know and does not know, does not know either!
    Reply With Quote Reply With Quote
  4. 12-07-2005, 11:47 AM #4
    wdfloyd
    wdfloyd is offline Junior Member
    Join Date
    Nov 2005
    Location
    Indianapolis
    Posts
    24

    Perhaps old stats?

    Could statistics still exist from some time ago? I believe OEM displays the row counts based on the statistics that exist in the data dictionary. I would think if statistics didn't exist, then OEM would not display a row count. Could it be that the 7 million number is correct and OEM is wrong?

    Otherwise, I would agree with davey, maybe a vpd or something?

    Need to see an example.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width