Home » RDBMS Server » Server Administration » About oracle memory
About oracle memory [message #579261] Sun, 10 March 2013 13:35 Go to next message
compuscience
Messages: 97
Registered: September 2012
Member
Dear members,
i have oracle database 9i r2 dedicated server
and have schema has been connected by 150 client
and another one connected with 15 client
at the same database
when i run report (6i version) at the first schema it take long time to be full complete
when i do this step at the second schema with another complex report it run faster

pga is default value
sga is 600M

what can i do to make it faster?

any question for any parameters i am here
thank you very much

Report message to a moderator

Re: About oracle memory [message #579262 is a reply to message #579261] Sun, 10 March 2013 13:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Not the same data.
Not the same concurrency.
It depends on what the report does.

Regards
Michel

Report message to a moderator

Re: About oracle memory [message #579266 is a reply to message #579262] Sun, 10 March 2013 14:12 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>what can i do to make it faster?
Find what is slow & fix it.
If you don't know where or why it is slow, you don't know what need to change to make it faster.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Previous Topic: Not able to open database.
Next Topic: Login using global DB name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 12 23:21:52 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.