Skip to main content

«  View All Posts

Where Does the Database Module Come From?

October 24th, 2023

0 min read

By Admin

It is important to make sure we have access to the right tables and the tables actually contain data. Below are the different database tables and how they are connected to Clarity's Data Management Page  

Currently Running 

JDE Tables: V$SQLAREA , V$SESSION , AUDIT_ACTIONS

Currently Running

Wait Type Distribution 

JDE Tables: V$SYSTEM_WAIT_CLASS

Wait Type Distribution

Most Expensive Query 

JDE Tables: v$osstat

Most Expenive Queries

CPU Pressure

JDE Tables: v$sql , v$sql_plan

CPU Pressure