Check whether recyclebin is enabled or not using below commands.
SQL Query to Get Oracle Blocking Sessions
In this post I am going to explain you how to get the Oracle blocking session details.
SQL
Get details of which session is blocking and waiting.
SQL Script to Check the Open Cursors in the Oracle Database
SQL Query
set pages 1000 lines 120 col username for a15 SELECT OC.inst_id, OC.user_name username,
SQL Script to Find out Total SGA and Current SGA Utilization
This query gives you the total SGA and its current usage by combining v$sga, v$sgastat and v$sga_dynamic_components dynamic views.
SQL Script to Check the User wise Count in Oracle database
Here is the SQL script
set lines 120 pages 1000 break on report compute SUM of tot on report
Script to Kill My Own SQLPLUS Session
Here I am giving you tip to kill your own sqlplus session connected to the oracle database.
Syntax
How to Check When was the Table Insert, Update, Delete Done on Oracle Tables or Partitions
This is done with the help of the DBMS_STATS. FLUSH_DATABASE_MONITORING_INFO package. This package flushes in-memory monitoring information for all the tables to the dictionary.
