| Speed probleme on Oracle 8.1.6 under Linux [message #54072] |
Mon, 28 October 2002 10:02  |
doudouke
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
hi all,
I have oracle database (8.1.6) running under linux
and sometimes an oracle process take all the time processor on my box. So when I make a very simple request on my DB it take around 1 min !
Have you heard about such a probleme.
Do you think it could be a good think to make a complete audit of the db ?
thx
doude
|
|
|
|
| Re: Speed probleme on Oracle 8.1.6 under Linux [message #54079 is a reply to message #54072] |
Mon, 28 October 2002 16:33  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
How much RAM do you have? What does cat /proc/meminfo show? Did you configure your kernel shared memory parameters?
If your kernel is 2.3.51 or higher, you can try this:
1. Create the directory, as root, /var/shm .
2. Enter the following line in /etc/fstab:
none /var/shm shm defaults
3. Mount the shared memory:
mount shm
4. Start Oracle.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
