Topic: Database Administration >> SESSIONS_WARNING ,prosesses,sessions
|
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: SESSIONS_WARNING ,prosesses,sessions |
| mr_mehraboon |
Posted: Apr 18, 2007 04:45:21 PM |
Total Post: 7
Joined: Feb, 2007
|
:confused: We have an oracle database with following initialisation parameters processes=550 session=610,
All other licensing parameters such as session_max, SESSIONS_WARNING are not set yet!! We ideally want to have more control over this as we have experienced database hanging due to too many users concurrently connecting to the database (and we ended up killing the database instance, we could not even log in as sysdba! to me it seems that database had hanged because of lack of recourses rather than reaching max session)
I understand the way session max and session warning parameters work, but I don’t fully understand the use of processes and sessions parameters, their differences and how to configure them in conjunction with session max and session warning parameters.
I like to set:
SESSIONS_WARNING=450
SESSION_MAX=500
What should I set processes, and sessions to??
2. I also need to write a shell script to make some fake connections to the database only for testing purpose; can someone give me some tips on this one? (Can all connections be initiated with same OS username, DB user and from within the same machine?
3. What if there is only one username in this database (application user), which is making multiple connections to the database? will the above method work or that I will have to control this by setting a new limit on cuncurrent sessions which one user can make ? how?
Thanks
|
|
|
| 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 | 816 |
| Mohammed Taj | 709 |
| Jayanta Sur | 479 |
| positive fanatic | 418 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 240 |
| Ramesh Jois | 226 |
| Bishal Khetan | 205 |
|
|
