Data porting is slow in ORacle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Data porting is slow in ORacle

  1. #1
    Join Date
    Apr 2008
    Posts
    26

    Data porting is slow in ORacle

    Dear all,

    Here My developer trying to port the data in Oracle database,
    He develope a Procedure to import the data (which include Insert and Update statement). Now he is complaning abt its running slow,
    Being as a DBA i need to check it out the reason Y??

    One more thing he is running that procedure thru ORacle Forms & Builder.

    I need to verify That with this whether it is using SQLLDR or NOT. How can i check it out.

    ANd what else cud be the reason for slow performance apart.


    can nebody help me out

    THanks in advance.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Do you have a definition of what "slow" means in this particular case?
    Have you check explain plan for each one of the offending queries?
    Have you traced the session to check wait events?

    Wouldn't hurt if you make a list of what you think are the DBA responsibilities, not sure what's your doubt about it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Apr 2008
    Posts
    26
    Hi PAVB,

    THanks4 the reply, But i think ur not understand my Threads,

    Here i just want 2 make conform that while using ORacle Forms n Report, if some one written a procedure to INsert and Update, whether it will directly fire that procedure OR as oracle porvide the SQLLDR utility to insert the data in database, Will it going to use this utility in BAckground or not.........????


    I think its not but i want to make conform it...


    Again abt the Defination of "SLOW" , i kno that it could cos of redo generatin, rodo file size ,wait event n all that.....
    Apart from this basic thing i would like to discusse more reasons with you.

    I'm completlyaware of the DBA roles

    NewYS Thanks
    Its OK no problem.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    huh?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    He develope a Procedure to import the data (which include Insert and Update statement).
    Post the procedure here.

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