drop table ora$ptt_am_i_memoryingORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create private temporary table ora$ptt_am_i_memorying (col1 number)Table created.
alter session set statistics_level=allStatement processed.
insert into ora$ptt_am_i_memorying
select rownum from dual connect by rownum <=1010 row(s) inserted.
select * from ora$ptt_am_i_memorying| COL1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|---|
select sql_id, sql_text
from v$sql
where sql_text like '%ora$ptt_am_i_memorying%' and sql_text not like '%v$sql%'| SQL_ID | SQL_TEXT | 7un6chmkuj08p | select * from ora$ptt_am_i_memorying | 7f1ycyw846hx0 | insert into ora$ptt_am_i_memorying select rownum from dual connect by rownum <=10 |
|---|
select sql_id,plan_hash_value, id, lpad(' ',depth,' ')||operation||' '||options Operation, object_name, cardinality, io_cost , starts, last_output_rows, last_cr_buffer_gets, last_disk_reads, last_disk_writes, last_elapsed_time
from v$sql_plan_statistics_all where sql_id in ('7un6chmkuj08p','7f1ycyw846hx0')
order by 1,2,3| SQL_ID | PLAN_HASH_VALUE | ID | OPERATION | OBJECT_NAME | CARDINALITY | IO_COST | STARTS | LAST_OUTPUT_ROWS | LAST_CR_BUFFER_GETS | LAST_DISK_READS | LAST_DISK_WRITES | LAST_ELAPSED_TIME | 7f1ycyw846hx0 | 1731520519 | 0 | INSERT STATEMENT | - | - | - | 1 | 0 | 1 | 0 | 0 | 379 | 7f1ycyw846hx0 | 1731520519 | 1 | LOAD TABLE CONVENTIONAL | ORA$PTT_AM_I_MEMORYING | - | - | 1 | 0 | 1 | 0 | 0 | 379 | 7f1ycyw846hx0 | 1731520519 | 2 | COUNT | - | - | - | 1 | 10 | 0 | 0 | 0 | 25 | 7f1ycyw846hx0 | 1731520519 | 3 | CONNECT BY WITHOUT FILTERING | - | - | - | 1 | 10 | 0 | 0 | 0 | 22 | 7f1ycyw846hx0 | 1731520519 | 4 | FAST DUAL | - | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 2 | 7un6chmkuj08p | 2680862117 | 0 | SELECT STATEMENT | - | - | - | 1 | 10 | 12 | 0 | 0 | 46 | 7un6chmkuj08p | 2680862117 | 1 | TABLE ACCESS STORAGE FULL | ORA$PTT_AM_I_MEMORYING | 10 | 2 | 1 | 10 | 12 | 0 | 0 | 46 |
|---|