SQL Query
set lines 2000 Pages 200 col program for a40 col module for a40
SQL Query to Find Out Session wise PGA Usage
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
Script to Check ASM Diskgroup Compatibility
COMPATIBLE.ASM (v$asm_diskgroup. COMPATIBILITY) – The minimum version of the ASM software that can access the disk group. In 11g,
Script to Check Disk group Freespace & Mount Status
SQL Script
set pages 1000 lines 120 col NAME for a16
