Journey to Become Expert Oracle Professional
Time model statistics is an important part in AWR Report. It provides the details of processing time spent by database for the given snapshot periods. Script time_model.sql gives the Time Model Statistics detail for any two snapshots.
What is execution plan? An execution plan describes the list of operations which are performed by SQL Engine for SQL statement. The order of operations and their implementation is decided by the oracle query optimizer. An execution plan also shows
Oracle database slow after schema IMPORT. Some days ago I got called from one of my client regarding the slowness of one of the data synchronization process after performing IMPORT operation of the schema. I called the onsite DBA to
What is DB Time? DB Time is the total time spent by the all user processes which are actively working or actively waiting in the database calls. It includes the CPU Time, IO Wait time and non-idle time. It tells
DB Time is very important metric in AWR report. When analyzing an AWR report the, DB Time is the first thing which i see as it tells us how much activity database was performing in that time interval. Suppose we have to perform analysis on
I was searching for the java program which should List TNS entries from TNSNAMES.ORA using java. I Google this but not found any satisfactory answer. So I have written the below code to list the tns entries from TNSNAMES.ORA file.
Below are the oracle session monitoring scripts for the database version 9i, 10g and above versions.
When we create a table in oracle with CLOB datatype, oracle creates LOB segment and LOB index for this column. By default this LOG segment and LOB index gets created in the tablespace where table is currently residing. This article demonstrate