What could be the problem in this database?

You work as a DBA for a company and you have the responsibility of managing one of its online transaction processing (OLTP) systems. The database encountered performance-related problems and you generated an Automatic Workload Repository (AWR) report to investigate it further. View the Exhibits and examine the AWR report.
What could be the problem in this database?
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):

You work as a DBA for a company and you have the responsibility of managing one of its online transaction processing (OLTP) systems. The database encountered performance-related problems and you generated an Automatic Workload Repository (AWR) report to investigate it further. View the Exhibits and examine the AWR report.

What could be the problem in this database?
Exhibit 1 (exhibit):

Exhibit 2 (exhibit):

Exhibit 3 (exhibit):

Exhibit 4 (exhibit):

A.
Java pool is not configured.

B.
The CPU in the system is slow.

C.
The shared pool size is inadequate.

D.
The database buffer cache is inadequate.

E.
The OPEN_CURSORS parameter is set to a small value.



Leave a Reply 0

Your email address will not be published. Required fields are marked *