1.Let me create a test case : I will take different OS statistics and run time statistics to compare with AWR report generated after execution. Case A.About test case in lower CPU:- I will create a table first create table t (id number, sometext varchar2(50),my_date date) tablespace data; Now I will create a simple procedure to load bulk data create […]
Adaptive Cursor Sharing: This document will explain step by step to analyze adaptive cursor sharing. Let’s start with the basics. Let’s create a table as a copy of dba_objects. SQL> create table t as select * from dba_objects; Now, if we run a query like ‘select object_name from t where object_id=1027’, then it must go through the full […]
First we need to load data SQL> alter session set tracefile_identifier=’ABC’; Session altered. Elapsed: 00:00:00.01 SQL> alter system set events ‘10046 trace name context forever, level 12′; System altered. Elapsed: 00:00:00.18 SQL> create table t1(c1 number,c2 char(2000)); Table created. Elapsed: 00:00:00.03 SQL> set autotrace on; SQL> set autotrace traceonly; SQL> insert into t1 select rownum,’A’ from dual connect by rownum<100000; […]
A.Enabling SPM manually to stabilize plan for a particular query For this test case I will create a table with skewed data so that for one bind value it will go for one execution plan and for other bind value,it will go for another execution plan.Ideally this should be good to go for different execution plan depending on the bind […]
Logical IO vs Physical IO vs Consistent gets I have created 1 GB table T1. Let me check how many blocks are there in the table after I have analyzed it. SQL> select BLOCKS from user_tables where table_name=’T1′; BLOCKS ———- 139153 Autotrace report Let me clean buffer cache and check the auto trace report. SQL>set autotrace […]
I referred some reference from my favorite Tim Hall blog (ORACLE_BASE) A.Basic of optimizer statistics: – The optimizer cost model relies on statistics collected about the objects involved in a query, and the database and host where the query runs. Statistics are critical to the optimizer’s ability to pick the best execution plan for a SQL statement. Object What influences […]
Author:-https://www.linkedin.com/in/maheshsrikakula/ Oracle License Cost Calculation basics How to enable/disable oracle license features at Binary Level
OMS Server: Where runs the Enterprise Manager Middleware Client Server: Where we’re going to install the agent 1.Pre-requisites setup to be done in Client Server Create directory where agent will be installed in Client Server In Client,You need to create a directory or mount point as /u01/oemcc Install telnet in Client Server yum install telnet -y Test if the server […]
What is PGA The Program Global Area (PGA) is a private memory region that contains the data and control information for a server process. Only a server process can access the PGA. Oracle Database reads and writes information in the PGA on behalf of the server process. An example of such information is the run-time area of a cursor. Each […]