About oracle memory [message #579261] |
Sun, 10 March 2013 13:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/51284ef89d03d81360279635761fcedd?s=64&d=mm&r=g) |
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
|
|
|
|
|