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

Thread: temp tables

  1. #1
    Join Date
    Sep 2003
    Posts
    49

    temp tables

    My application uses large number of GLOBAL temporary tables (db 9.2.0.1). Any performance problem will arise in the database? Give some suggestions.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Not sure what you mean -- do you mean, is there a problem just in having a high number of temp tables? I wouldn't think so, no.

    However it might mean that the application developers are over-reliant on them, which is common in ex-SQL Server developers. It's often the case that populating and querying a temp table in Oracle can just be replaced with a query of an inline view.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Yes, a performance problem could arise when you use GTT and CBO. As you cannot analyze GTT, CBO estimates statistics and the guess could be wrong, causing bad performace of the query. Fortunately, you can estimate statistics yourself and set them using dbms_stats. As slimdave pointed out, use of GTTs should be rare, if you have "large number" of them, you made a mistake in application design. GTTs also use RBS and redo, which you avoid by using inline views.
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  4. #4
    Join Date
    Sep 2003
    Posts
    49
    Thanks for ur valuable suggestions.
    my application uses nearly 50 GTT.

Posting Permissions

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


Click Here to Expand Forum to Full Width