Topic: Oracle on Unix/Linux >> Setting memory on Solaris
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Setting memory on Solaris |
| gsram |
Posted: Apr 10, 2003 06:39:00 AM |
Total Post: 2
Joined: Jan, 2003
|
We were advised by a company to check what the memeory thresholds were on the machine we recently installed 2 Gig in. The reason for this was to ensure Oracle got a optimal amount for it's use. How can we check whether we have the optimal setting for Oracle (8i)
Thanks
--------------------
Indy
|
|
|
 saurav |
| Posted: Apr 10, 2003 10:02:00 PM |  |
|
Total Post: 13
Joined: Jan, 2003
|
Hi Indy,
You can find total memory on Solaris by following command
/usr/sbin/prtconf | grep size
If you want to check Oracle related memory parameter then check your /etc/system file.
I am assuming you have specified Kernel parameters.
Here is one example for these parameters.
Kernel Parameters on our SUN Enterprise with 640MB for Oracle 8.1.x
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=2500
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
Check your Oracle installation document for detail of these parameters.
Hope it helps.
Regards,
Vigyan Kaushik
Oracle DBA
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 387 |
| Vinoth Kumar | 379 |
| Gopu Gopi | 350 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
