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,

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 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.

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 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

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 12:18:54 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.