Usually "select count(*) from v$processes" during online hours for our PA-RISC
HP-UX B11.11 production server (with 4GB RAM) ranges from 21-80.
We initially run into problems of nfile & nproc being exceeded and we've since
increased these by about 6-7 fold and we don't face this issue anymore.
We have also increased our Oracle processes & sesssions limit from initial 300
to 500 and then to 900.
Things stabilized longer but every 2-3 weeks, the number of Oracle processes
(as given by "select count(*) from v$processes" would exceed 900). We ran
script to monitor the number of Oracle processes and it rarely go above 100
but when there's a disruption, it just suddenly hit 900.
I can't increase the max processes in Oracle beyond 1200 due a couple of
sem* kernel parameters.
What could be the cause of the surge in Oracle processes? Can a mistuned
system cause this or this is mistuned Oracle or Application went wild?
So what should I do next? There's no error in syslog nor Oracle
listener lsnridb.log logfiles.
In Oracle clients' logs, it says :
ORA-12500: TNS:listener failed to start a dedicated server process
Someone gave me a list of settings that Oracle recommended for
kernel parameteras follows :
Parameter Recommended Formula or Value
maxdsiz 1073741824 (1 GB)
maxdsiz_64bit 2147483648 (2 GB)
maxssiz 134217728 (128 MB)
maxssiz_64bit 1073741824 (1 GB)
shmmax The size of physical memory or 1073741824 (0X40000000),
whichever is greater.
Note: To avoid performance degradation, the value should
be greater than or equal to the size of the available
You cannot necessarily use CPU and memory as the indicator for a database server. Often the IO gets maxed before those. At that same time what are your IO stats looking like. If there is an IO bottleneck
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc.
This document explains the different types of consol…
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…