Code generation for query block SEL$1 (#0)
qksqbDumpQbcdef() dumping query block tree sqlid=84zghzsc8b7rj
qbcdef qbcp=@0x2b4afb907cb0 name=SEL$1
FROM position=40
end of FROM position=49
START position=25
END position=49
SELECT clause=@0x2b4afb903080 (qbcsel)
FROM clause=@0x2b4afb902d88 (qbcfro)
WHERE clause=@(nil) (qbcwhr)
GROUP BY clause=@(nil) (qbcgbh)
HAVING clause=@(nil) (qbchav)
ORDER BY clause=@(nil) (qbcord)
Outer Query Block=@(nil) (qbcoqb)
Inner Query Block=@(nil) (qbciqb)
Next Query Block=@(nil) (qbcnxt)
View Query Block=@(nil) (qbcvqb)
Set Query Block=@(nil) (qbcseb)
Set Q.B. Parent=@(nil) (qbcsep)
qbcflg=0x40400
qbcxfl=0x0
qbcxxfl=0x0
qbcxxxfl=0x0
seldef selp=@0x2b4afb903080 name=SYSDATE
name=SYSDATE
flags=0x11
end position=40
select operand=@0x2b4afb903010
next element=@(nil)
opndef opnp=@0x2b4afb903010 type=base operand [3]
position=32
opnflg=0x30040
opnxfl=0x0
opnflg2=0x0
strtyp=SYSDATE
frodef frop=@0x2b4afb902d88 alias=DUAL
alias=DUAL
table=DUAL
next pointer=@(nil) (fronxt)
containing q.b. (froqbc)=@0x2b4afb907cb0
view q.b. (frovqb)=@(nil)
outer join to=@(nil) (frooutj)
flags, flags, and more flags
froflg=0x43
froxfl=0x100
froxxfl=0x40000000
froxxxfl=0x0
fro4xfl=0x0
Code generation for table DUAL[DUAL] using frokmode:23
qknAllocate
Allocate FAST_DUAL_QKNTYP(0x2b4afb91adf0 rwo:0x2b4afb91aea8)
[]
qkatab: froqkn:0x2b4afb91adf0 fro:DUAL
frorwo:
[]
froqkn:
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) processed
Traversing query block SEL$1 (#0) because of (14)
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) traversed
Traversing query block SEL$1 (#0) because of (3)
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) traversed
qkaMarkQkn: -> FAST_DUAL_QKNTYP(0x2b4afb91adf0)
flags_in:
qkaMarkQkn: <- FAST_DUAL_QKNTYP(0x2b4afb91adf0)
out:
out_left:
out_right:
Traversing query block SEL$1 (#0) because of (6)
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) traversed
Traversing query block SEL$1 (#0) because of (12)
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) traversed
Traversing query block SEL$1 (#0) because of (5)
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) traversed
qknAllocate
Allocate STMT_MARKER_QKNTYP(0x2b4afb919fb8 rwo:(nil)) on top of FAST_DUA
L_QKNTYP(0x2b4afb91adf0)
qkenndfs: node 0x2b4afb91adf0(dnum_qkn 1) of type FAST_DUAL_QKNTYP exprs_qkn 2b4afb91ae30
qkenndfs: node 0x2b4afb919fb8(dnum_qkn 2) of type STMT_MARKER_QKNTYP exprs_qkn 2b4afb919ff8
**** qkeDumpExpressionScopes expression scopes ****
Expression:
[(0x2b4afb903010:8:SYSDATE@!)]
Defined by : Node STMT_MARKER_QKNTYP (dnum_qkn 2) type QKE_REF dob 1
Referenced by: Node STMT_MARKER_QKNTYP (dnum_qkn 2)
********** End of qkeDumpExpressionScopes *********
Traversing query block SEL$1 (#0) because of (4)
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) traversed
Traversing query block SEL$1 (#0) because of (1)
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) traversed
Traversing query block SEL$1 (#0) because of (5)
qkaPlanSignatureCB
node : 0x2b4afb91adf0, node->type_qkn #: 66,node->exprs: (nil), node->dn
_qkn: (nil), dn->kkfdntyp: 0
FAST_DUAL (0x2b4afb91adf0)
Query block SEL$1 (#0) traversed
Starting SQL statement dump
user_id=0 user_name=SYS module=sqlplus@jyrac1 (TNS V1-V3) action=
sql_id=84zghzsc8b7rj plan_hash_value=1388734953 problem_type=3
----- Current SQL Statement for this session (sql_id=84zghzsc8b7rj) -----
/* SQL Analyze(146,0) */ select sysdate from dual
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x7f6236e8 145 package body SYS.DBMS_SQLTUNE_INTERNAL
0x7f6236e8 12043 package body SYS.DBMS_SQLTUNE_INTERNAL
0x854a3268 1276 package body SYS.DBMS_SQLDIAG
0x758e9c58 1 anonymous block
sql_text_length=50
sql=/* SQL Analyze(146,0) */ select sysdate from dual
----- Explain Plan Dump -----
----- Plan Table -----