Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2007
    Posts
    12

    Unanswered: dbms_stats and merge in the same time (same table)

    Hello, could somebody help me ?

    I'm merging into table X in one session and I would like to compute stats (dbms_stats.gather_table_stats) in another session in the same time over same table X. Could this cause some problems ?

    Thank you in advance.
    Lubo

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Could this cause some problems ?
    It depends upon your definition of problems.
    Keep in mind that original session issues a COMMIT, the 2nd session will NOT be able to "see" the changed data.

    Are you changing that BIG a percentage of data that new statistics are needed?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2007
    Posts
    12
    Quote Originally Posted by anacedent
    >Could this cause some problems ?
    It depends upon your definition of problems.
    Keep in mind that original session issues a COMMIT, the 2nd session will NOT be able to "see" the changed data.

    Are you changing that BIG a percentage of data that new statistics are needed?
    Thank you for quick answer :-).

    Well ... no, i don't need statistics for changed data at all. But ... is original session able to see new statistics while proceeding ?

    addition: I mean ... data were changed within one package procedure, which first insert big num of rows and then merge additional columns to those rows. I need to compute stats while merging ... I don't know whether this is clear enough for you ...
    Last edited by lubogabal; 09-25-07 at 14:08.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I need to compute stats while merging .
    WHY do you think you need to compute stats while merging?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2007
    Posts
    12
    >WHY do you think you need to compute stats while merging?

    Actually, I need it because there was an insert just before start of merging. And as I do not have right to compile package which is performing these tasks I need to compute stats manually (i can't include computing stats right into the code of procedure) ...

Posting Permissions

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