OraFAQ Forum: Performance Tuning » Working slowley after 6 to 7hrs

Home » RDBMS Server » Performance Tuning » Working slowley after 6 to 7hrs (oracle 10g XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Working slowley after 6 to 7hrs [message #381468]

Sat, 17 January 2009 01:53

ragasudhai
Messages: 1
Registered: December 2008

Junior Member

Hi all,

Iam upgrading my application to latest version.During the process i have the scripts which run nearly 1 day.After importing the data we are running the scripts.But, after 6 to 7 hrs the scripts are runing very slow.we have doubled the SGA settings to 1024.no use.our data is about 20GB.pls pull me out of the dead end.

thanks in advance......
sudhai,

Report message to a moderator

Re: Working slowley after 6 to 7hrs [message #381469 is a reply to message #381468]

Sat, 17 January 2009 01:55

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

I thought your not asking the question in correct forum section.

Report message to a moderator

Re: Working slowley after 6 to 7hrs [message #381471 is a reply to message #381468]

Sat, 17 January 2009 02:10

dhanuka.rajesh
Messages: 49
Registered: March 2008
Location: Mumbai

Member

Are you trying to upgrade Oracle database server?

I am not able to understand the need for using Scripts for data transfer?

Please provide more details.

Best Regards,

Dhanuka. Rajesh

Report message to a moderator

Previous Topic:	How i can increase the performance of my query
Next Topic:	Performance Issue with FORALL BULK COLLECT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 02 22:48:28 CST 2026