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


set pages 1000 lines 222
col USERNAME for a15
col osuser for a8
col tablespace for a8
col MODULE for a10

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 


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer