|
eration id):
---------------------------------------------------
1 - filter("OBJECT_NAME"='bbb')
统计信息
----------------------------------------------------------
0 recursive calls
0 db block gets
702 consistent gets
0 physical reads
0 redo size
992 bytes sent via SQL*Net to client
374 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
0 rows processed
SQL> select /*+test_similar*/* from t where object_name='ccc';
执行计划
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2 | 186 | 149 (1)| 00:00:02 |
|* 1 | TABLE ACCESS FULL| T | 2 | 186 | 149 (1)| 00:00:02 |
--------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("OBJECT_NAME"='ccc')
统计信息
----------------------------------------------------------
0 recursive calls
0 db block gets
702 consistent gets
0 physical reads
0 redo size
992 bytes sent via SQL*Net to client
374 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
0 rows processed
SQL> select /*+test_similar*/* from t where object_name='ddd';
执行计划
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2 | 186 | 149 (1)| 00:00:02 |
|* 1 | TABLE ACCESS FULL| T | 2 | 186 | 149 (1)| 00:00:02 |
--------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("OBJECT_NAME"='ddd')
统计信息
----------------------------------------------------------
0 recursive calls
0 db block gets
702 consistent gets
0 physical reads
0 redo size
992 bytes sent via SQL*Net to client
374 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
0 rows processed
SQL> Set autotrace off
SQL> select sql_id,child_number,sql_text from v$sql where sql_text like '%/*+test_similar*/%'
and sql_text not like '%sql_text%'
And sql_text not like '%EXPLAIN PLAN%';
SQL_ID CHILD_NUMBER SQL_TEXT
------------- ------------ ---------------------------------------------------------------------------
2uff8qc1h3jyx 0 select /*+test_similar*/* from t where object_name=:"SYS_B_0"
|