Monitoring

Monitoring Connection Monitoring

sql

Copy

-- Check active connections
SELECT username, machine, program 
FROM v$session 
WHERE username IS NOT NULL;

Network Monitoring

bash

Copy

# Test connectivity
tnsping ORCL
# Trace network
export TRACE_LEVEL_CLIENT=16
sqlplus username/password@ORCL

Log Analysis

bash

Copy

# View trace files
cd $ORACLE_HOME/log
grep ORA- *.log