In this post provides you queries to find out the different client connection details like character set, the client software or driver etc. with their count.
Sql Query to Check Different Client Character Set, Client Version and Client Driver or Software Connected to The Database
Query to Get Hostname Instance Name and Startup Time for Oracle RAC Database
As a DBA if you are supporting multiple database environments, it is difficult to maintain the list of instance and database details. Using this query, you will be able to easily to fetch the details from the database. This query also give you the startup time for each instance.
How to Check Active Transaction in Oracle Database – v_$transaction
V_$transaction table will give you the active transaction in the database. This dynamic view get recorded with the active transaction which is being executed or waiting for the resources in the database or operating system.
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
