SQL Query to Find Out Session wise PGA Usage

SQL Query

 

set lines 2000 Pages 200
col program for a40
col module for a40

SQL Query to Find Out Sessions Using More Temp Space

Query

set pages 1000 lines 222
col USERNAME for a15
col osuser for a8
col tablespace for a8
col MODULE for a10
SELECT  so_us.TABLESPACE   

Easy way to Connect and Query OCI Autonomous Database - SQL Developer Web

Oracle provides easy way to connect the OCI autonomous database. This is free SQL developer like tool which is in build in the OCI console itself. Here I am going to explain how to access and use it. 

How to Create or Provision OCI Autonomous Database

Step 1. 

Click on navigation menu and Click on Autonomous Data Warehousing or Autonomous Transaction Processing