Pages

▼
Wednesday, 11 April 2018

handle cancelled session request from java to oracle,When a user run a report query, and he closes the window immediately does the query still keeps running

›
Backend db is oracle 11g  Frontend is Java  handle cancelled session request from java in oracle,When a user run a report query, and he ...
Thursday, 17 September 2015

Oracle dba/monitoring/tuning.sql

›
Oracle dba/monitoring/tuning.sql SET SERVEROUTPUT ON SET LINESIZE 1000 SET FEEDBACK OFF SELECT * FROM   v$database; PROMPT DECLAR...

Script to find Oracle database performance

›
Script to find Oracle database performance Just the below line up to last / copy and paste to sqlplus using / as sysdba SET SERVEROUTPU...
Thursday, 30 October 2014

ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'

›
ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS' 1) find the status of your rollback segments by u...
Wednesday, 30 July 2014

ORA-00445: background process "m001" did not start after 120 seconds ---ORA-00445: background process "J003" did not start after 120 seconds

›
ORA-00445: background process "m001" did not start after 120 seconds      Incident details in: /app/u01/app/oracle/diag/rdbms/inc...
Friday, 30 May 2014

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], []

›
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [] The Problem: Oracle Database remains in mounted state. It...
Monday, 7 April 2014

Bulk collect is the bulk binding syntax for select statements.(Performance tuning - PL/SQL)

›
Bulk Collect Executing sql statements in plsql programs causes a context switch between the plsql engine and the sql engine. Too many ...