How to determine ideal number of Sessions, Processes and Open Cursors
In my production environment, I recently saw that no one could log on as the listner state was blocked.
Service "prd002l" has 1 instance(s).
Instance "prd002l", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:12730 refused:0 state:blocked
LOCAL SERVER
This is IBM-AIX 5.3 envoronment. CPU = 2 Memory = 16GB
Service "prd002l" has 1 instance(s).
Instance "prd002l", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:12730 refused:0 state:blocked
LOCAL SERVER
This is IBM-AIX 5.3 envoronment. CPU = 2 Memory = 16GB
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Devinder Singh Virdi
In addation to Schwertner comment, if listerner is blocked or stoped, you can still connect to oracle server using SET ORACLE_SID command performed on database server rather than proviiding connecting string.
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
