---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | | 517 (100)| | 585 |00:00:00.03 | 1845 | 6 | | | |
| 1 | CONCATENATION | | 1 | | | | | 585 |00:00:00.03 | 1845 | 6 | | | |
|* 2 | FILTER | | 1 | | | | | 585 |00:00:00.03 | 1845 | 6 | | | |
|* 3 | HASH JOIN | | 1 | 1421 | 1037K| 507 (1)| 00:00:07 | 585 |00:00:00.03 | 1845 | 6 | 963K| 963K| 1338K (0)|
|* 4 | TABLE ACCESS FULL | TOBJ | 1 | 1550 | 313K| 424 (1)| 00:00:06 | 2057 |00:00:00.02 | 1521 | 0 | | | |
|* 5 | TABLE ACCESS FULL | TTAB | 1 | 6785 | 3584K| 82 (0)| 00:00:01 | 7549 |00:00:00.01 | 324 | 6 | | | |
|* 6 | FILTER | | 1 | | | | | 0 |00:00:00.01 | 0 | 0 | | | |
| 7 | NESTED LOOPS | | 0 | 1 | 748 | 10 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
| 8 | NESTED LOOPS | | 0 | 1 | 748 | 10 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
| 9 | TABLE ACCESS BY INDEX ROWID| TTAB | 0 | 1 | 541 | 7 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 10 | INDEX RANGE SCAN | TTAB_TS | 0 | 218 | | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 11 | INDEX RANGE SCAN | TOBJ_NAME | 0 | 1 | | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
| 12 | TABLE ACCESS BY INDEX ROWID | TOBJ | 0 | 1 | 207 | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Peeked Binds (identified by position):
--------------------------------------
1 - (VARCHAR2(30), CSID=873): 'C%'
2 - (VARCHAR2(30), CSID=873): (null)
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter(:B2 IS NULL)
3 - access("A"."OBJECT_NAME"="B"."TABLE_NAME")
4 - filter("A"."OBJECT_NAME" LIKE NVL(:B1,"A"."OBJECT_NAME"))
5 - filter("B"."TABLESPACE_NAME" LIKE "B"."TABLESPACE_NAME")
6 - filter(:B2 IS NOT NULL)
10 - access("B"."TABLESPACE_NAME" LIKE :B2)
filter("B"."TABLESPACE_NAME" LIKE :B2)
11 - access("A"."OBJECT_NAME"="B"."TABLE_NAME")
filter("A"."OBJECT_NAME" LIKE NVL(:B1,"A"."OBJECT_NAME"))