Profile cover photo
Profile photo
Ashokan .B
76 followers
76 followers
About
Communities and Collections
View all
Posts

Post has attachment
Oracle dba/monitoring/tuning.sql
Oracle dba/monitoring/tuning.sql SET SERVEROUTPUT ON SET LINESIZE 1000 SET FEEDBACK OFF SELECT * FROM   v$database; PROMPT DECLARE   v_value  NUMBER;   FUNCTION Format(p_value  IN  NUMBER)      RETURN VARCHAR2 IS   BEGIN     RETURN LPad(To_Char(Round(p_valu...
Add a comment...

Post has attachment
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 SERVEROUTPUT ON DECLARE    CURSOR c1    IS       SELECT version FROM v$instance;    CURSOR c2    IS       SELECT host_name,          ...
Add a comment...

Post has attachment
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 using the following query. You will find that your tablespace status is offline. Alter the tablespace to online. SQL> select segm...
Add a comment...

Post has attachment
ORA-00445: background process "m001" did not start after 120 seconds
Add a comment...

Post has attachment
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 can't be opened. If it is focibly opened it throws error (ora-00600) as shown below: SQL> alter database open; alter datab...
Add a comment...

Post has attachment
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 context switches may degrade performance dramatically. In order to reduce the number of these context switches we can use a...
Add a comment...

Post has attachment
ORACLE: sql - JOIN vs IN vs EXISTS and JOIN vs NOT IN vs NOT EXISTS the logical difference
ORACLE: sql - JOIN vs IN vs EXISTS  and JOIN vs NOT IN vs NOT EXISTS the logical difference There is a common misconception that IN behaves equaliy to EXISTS or JOIN in terms of returned results. This is simply not true. To see why not, let's review what ea...
Add a comment...

Post has attachment
solution :- constraint (SYS.I_SOURCE1) violated
I am trying to drop an object from oracle using sqlplus then meanwhile i am cancelling the operation . After i am drop the same object then  raise the error  that object does not exist. And after i am creating the same object with some modification  then ge...
Add a comment...

Post has attachment
ORA-48223: Interrupt Requested - Fetch Aborted - Return Code [51111] [HM_INFO]
ORA-48223: Interrupt Requested - Fetch Aborted - Return Code [51111] [HM_INFO] ORA-51108: unable to access diagnostic repository - retry command ORA-48223: Interrupt Requested - Fetch Aborted - Return Code [51111] [HM_INFO] ORA-06512: at "SYS.DBMS_IR", line...
Add a comment...

Post has attachment
Purging trace and dump files with 11g ADRCI
Purging trace and dump files with 11g ADRCI In previous versions of Oracle prior to 11g, we had to use our own housekeeping scripts to purge the udump, cdump and bdump directories. In Oracle 11g, we now have the ADR (Automatic Diagnostic Repository) which i...
Add a comment...
Wait while more posts are being loaded