WHY MY DATABASE HAS SO MANY PROCESSES CONNECTED
GOAL An instance has reached the maximum number of processes. I want to know why I have so many and if there is any to be disconnected safely. SYMPTOMS The following query shows that my instance has almost reached the number of permited processes. SET LINES 300 SET PAGES 999…
Initialization Parameters, ORA-00020, Processes, Session
EM Event: Warning:ORCL_dbpilot.net – Metrics Process Limit % is at 98
SYMPTOMS Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0.0) sends you emails like the EM Event: Warning:ORCL_dbpilot.net – Metrics Process Limit % is at 98 with the following error messages Host=dbpilot.net Target type=Database Instance Target name=ORCL_dbpilot.net Categories=Capacity Message=Metrics Process Limit % is at 98 Severity=Warning Event reported time=Aug…
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (71)
- Account (3)
- AWR (4)
- Database Errors (7)
- Database Performance (10)
- Datapump (4)
- DBMS_SCHEDULER (2)
- Enterprise Manager (25)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (3)
- High IO Load (4)
- Historical Session Information (3)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS SETTINGS (1)
- Objects (2)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- Optimizer Statistics Advisor (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (3)
- Tablespaces (2)
- Temporary Tablespace (2)
Tags
/etc/sudoers
Account
ACTIVE SESSION HISTORY
Agent
Agent 12c Deinstall
Agent 13c Deployment
ASH
AWR
BLOCKING SESSION
Database Auditing
Database Directory
Database Performance
Datapump
DBMS_SCHEDULER
DBMS_SYSTEM
DEADLOCK
Enterprise Manager
Enterprise Manager Metrics
Failed Logins (Historical) Metric
Failed Logins Metric
GET_ENV
High IO Load
historical session information
Idle Sessions
Initialization Parameters
LOCKED(TIMED)
Object Grants
OEM
OEM 12.1.0.4
OEM 13.1.0.0.0
OMS
Processes
Repository
ROW LOCK
Schema Statistics
Sessions
spfile
SQL_ID
STANDARD EDITION
Standard Query
Statspack Snapshots
TRANSACTION
UTL_FILE
WAITING SESSION
Yum