Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    Unanswered: Differerence acces path linked server Oracle 9/10

    We are experiencing huge performance issues with fetching data from a linked Oracle database after upgrading the receiving database to Oracle 10g.
    It looks as though all data is first fetched at the receiving end, cause temp spaces are floaded. The query ran with no problem between 2 Oracle 9i databases.
    Can anyone suggest a solution for enforcing the query at the backend.
    We're looking into using a specific hint to enforce this.
    So far , we expect that /*+driving_site*/ could be a solution, but we are not sure about its use.
    Anyone an idea?
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  2. #2
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    in dwh is necessary this hint, i used often.
    check database settings as parameters, tablespaces size. and check your database version on metalink, if this is not known issue
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

Posting Permissions

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