Contact Me

Email

raunakvdas@gmail.com


LinkedIn

https://www.linkedin.com/in/raunak-vishwanath-das-a07b7b87/

Popular posts from this blog

Image
How to shutdown a Single Instance Database in Oracle 19c Overview Shutdown is an operation performed when a command is issued by the Administrator to bring down the Database or when it receives a signal to bring down the Database incase of a failure/malfunction or due to SHUTDOWN ABORT comm and execution. The options used by t he Administrator to bring down the Database is called as Shutdown Modes and the Database Server follows a sequence to shutdown a Database . Let's check how does that happen. Concepts The following are the shutdown Modes. Shutdown Modes A database administrator with SYSDBA or SYSOPER privileges can shut down the database using the SQL*Plus SHUTDOWN command or Enterprise Manager. The SHUTDOWN command has the following options that determine the shutdown behavior. Now let's look into each SHUTDOWN option in detail. SHUTDOWN ABORT  This mode is used for emergency situations, such as when shutdown with "IMMEDIATE" option doesn't work. This mode o...
Read more
 PROMPT [STEP 11] I/O Latency during periods this SQL appeared COLUMN filetype_id   FORMAT 999 HEADING 'TYPE_ID' COLUMN ms_per_read   FORMAT 999.999 COLUMN ms_per_write  FORMAT 999.999 WITH r AS (   SELECT MIN(snap_id) b, MAX(snap_id) e   FROM   dba_hist_sqlstat   WHERE  sql_id='&sql_id' ) SELECT f.filetype_id,        ROUND(f.readtim  / DECODE(NULLIF(f.phyrds ,0),0,1,f.phyrds ),3) AS ms_per_read,        ROUND(f.writetim / DECODE(NULLIF(f.phywrts,0),0,1,f.phywrts),3) AS ms_per_write FROM   dba_hist_filestatxs f, r WHERE  f.snap_id BETWEEN r.b AND r.e GROUP  BY f.filetype_id, f.readtim, f.phyrds, f.writetim, f.phywrts ORDER  BY ms_per_read DESC NULLS LAST;
Read more
 -- =========================================== -- SQL_ID Deep-Dive: Step-by-Step (Copy-All) -- Safe (SELECT-only). No time window required. -- =========================================== -- Formatting SET LINESIZE 300 SET PAGESIZE 200 SET TRIMSPOOL ON SET TAB OFF SET VERIFY OFF SET FEEDBACK ON SET TIMING ON SET HEADING ON COLUMN inst_id              FORMAT 99 COLUMN sql_id               FORMAT A13 COLUMN child_number         FORMAT 999 COLUMN plan_hash_value      FORMAT 9999999999 COLUMN sql_plan_hash_value  FORMAT 9999999999 COLUMN last_active_time     FORMAT A19 COLUMN wait_or_class        FORMAT A40 COLUMN op                   FORMAT A45 COLUMN object_name          FORMAT A40 COLUMN snap_time            FORMAT A20 COLUMN name     ...
Read more