Home » RDBMS Server » Server Administration » About oracle memory
About oracle memory [message #579261] Sun, 10 March 2013 13:35 Go to previous 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
 
Read Message
Read Message
Read Message
Previous Topic: Not able to open database.
Next Topic: Login using global DB name
Goto Forum:
  


Current Time: Thu Apr 25 22:47:42 CDT 2024