Database Reference
In-Depth Information
------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |E-Bytes|
------------------------------------------------------------------
|* 1 | HASH JOIN | | 1 | 3 | 138 |
|* 2 | TABLE ACCESS FULL| DEPARTMENTS | 1 | 1 | 16 |
|* 3 | TABLE ACCESS FULL| EMPLOYEES | 1 | 31 | 930 |
------------------------------------------------------------------
-----------------------------------------------
| Cost (%CPU)| E-Time | A-Rows | A-Time |
-----------------------------------------------
| 7 (15)| 00:00:01 | 4 |00:00:00.01 |
| 3 (0)| 00:00:01 | 1 |00:00:00.01 |
| 3 (0)| 00:00:01 | 45 |00:00:00.01 |
-----------------------------------------------
--------------------------------------------
| Buffers | Reads | OMem | 1Mem | Used-Mem |
--------------------------------------------
| 12 | 1 | 887K| 887K| 267K (0) |
| 7 | 0 | | | |
| 5 | 1 | | | |
--------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1
2 - SEL$1 / D@SEL$1
3 - SEL$1 / E@SEL$1
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("E"."DEPARTMENT_ID"="D"."DEPARTMENT_ID")
2 - filter("D"."DEPARTMENT_NAME"=:DNAME)
3 - filter(("E"."SALARY">:SAL AND "E"."HIRE_DATE">TO_DATE(:HIRED,'dd.mm.yy')))
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - (#keys=1) "D"."DEPARTMENT_NAME"[VARCHAR2,30], "E"."FIRST_NAME"[VARCHAR2,20], "E"
."LAST_NAME"[VARCHAR2,25], "E"."SALARY"[NUMBER,22]
2 - "D"."DEPARTMENT_ID"[NUMBER,22], "D"."DEPARTMENT_NAME"[VARCHAR2,30]
3 - "E"."FIRST_NAME"[VARCHAR2,20], "E"."LAST_NAME"[VARCHAR2,25], "E"."SALARY"[NUMBER
,22], "E"."DEPARTMENT_ID"[NUMBER,22]
Tracing the SQL*Plus session at level 4 or 12 proves that the data types of the bind variables
(parameter
oacdty
) match the data types in the original trace file with the exception of the bind
variable with data type
DATE
(
oacdty=12
), which cannot be reproduced with a SQL*Plus variable.
Following is the relevant section of an Oracle10
g
trace file:
BINDS #3:
kkscoacd
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
