6.2 Case Study 1
6.2.1 Problem Description
This case helps a company optimize a backend news publishing system. The frontend is a large website, with a Java application connecting to the database via a middleware connection pool. The operating system is Sun OS 5.8, and the database version is 8.1.7.
System Symptoms: Accessing news pages is extremely slow, with backend publishing management experiencing the same issues, often taking tens of seconds to return. This performance is unacceptable, necessitating optimization and issue identification.
6.2.2 Checking and Tracking Database Processes
Since the publishing system is non-real-time, diagnostics were performed at night with minimal user access. I clicked the relevant pages on the frontend while tracking backend processes. I queried the v$session view to obtain process information:
SQL> select sid, serial#, username from v$session;
SID SERIAL# USERNAME
---------------
1 1
2 1
3 1
4 1
5 1
6 1
7 284 IFLOW
11 214 IFLOW
12 164 SYS
16 1042 IFLOW
10 rows selected.