Home » RDBMS Server » Performance Tuning » Working slowley after 6 to 7hrs (oracle 10g XP)
Working slowley after 6 to 7hrs [message #381468] Sat, 17 January 2009 01:53 Go to next message
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,
Re: Working slowley after 6 to 7hrs [message #381469 is a reply to message #381468] Sat, 17 January 2009 01:55 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

I thought your not asking the question in correct forum section.
Re: Working slowley after 6 to 7hrs [message #381471 is a reply to message #381468] Sat, 17 January 2009 02:10 Go to previous message
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
Previous Topic: How i can increase the performance of my query
Next Topic: Performance Issue with FORALL BULK COLLECT
Goto Forum:
  


Current Time: Tue Jun 18 07:20:29 CDT 2024