| my database runs slowly [message #52382] |
Thu, 18 July 2002 08:20  |
cacael
Messages: 8
Registered: January 2002
|
Junior Member |
|
|
my database is on solaris 2.6 . Now my database is very slow . These are important parameters of my settings.
db_block_buffers 300000
db_block_size 4096
shared_pool_size 314572800
processes 150
- Os RAM 3Go
- /etc/system file
********************************
*Begining of Oracle settings
********************************
set semsys:seminfo_semmni = 100
set semsys:seminfo_semmns = 300
set semsys:seminfo_semmsl = 150
set semsys:seminfo_semopm = 100
set semsys:seminfo_semvmx = 32767
set shmsys:shminfo_shmmax = 512000000
set shmsys:shminfo_shmmni = 100
set shmsys:shminfo_shmseg = 10
set shmsys:shminfo_shmmin = 1
********************************
*End of Oracle settings
i've almost 200 users .
When i use vmstat , it shows bad memory performance.
Please how can i solve my problem ?
|
|
|
|
|
|
| Re: my database runs slowly [message #52395 is a reply to message #52382] |
Thu, 18 July 2002 22:45  |
P
Messages: 29
Registered: May 2002
|
Junior Member |
|
|
The memory parameter you have show add up to about 1.5 gigs but this does not include pga of users or large pool or java pool. What does your total amount of SGA total at peak times.
of the 200 odd connections how many are active? would MTS help relieve memory contraints?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
