Skip to content

Instantly share code, notes, and snippets.

@xtender
Created July 12, 2021 18:10
Show Gist options
  • Save xtender/c823573170b09f76ba98d355863c4e12 to your computer and use it in GitHub Desktop.
Save xtender/c823573170b09f76ba98d355863c4e12 to your computer and use it in GitHub Desktop.
Long invalid SQL text
# tail *compiler3*.trc
2021-07-12 18:05:55.424*:SQL_Compiler:opitca.c@2435:opitca(end):
End of opitca for curnum#=3 sqlid=<unknown>
qesdpDPCSetupNextExec(enter): SQL_ID=4gyc8k159wp2s
AP: qesdpDPCSetupNextExec: Not an adaptive plan
qesdpInitExecMutable(enter): SQL_ID=4gyc8k159wp2s
qesdpInitExecMut (exit)
qesdpSetupMutable(enter): SQL_ID=4gyc8k159wp2s
Enabling tracing for cur#=1 sqlid=b9haqy47mhw4s top-level
Parsing cur#=1 sqlid=b9haqy47mhw4s len=22429
sql=select/*+ findme*/ 1 x0,100000000000000000000000000000000000000 x1,100000000000000000000000000000000000000 x2,100000000000000000000000000000000000000 x3,100000000000000000000000000000000000000 x4,100000000000000000000000000000000000000 x5,100000000000000000000000000000000000000 x6,100000000000000000000000000000000000000 x7,100000000000000000000000000000000000000 x8,100000000000000000000000000000000000000 x9,100000000000000000000000000000000000000 x10,100000000000000000000000000000000000000 x11,100000000000000000000000000000000000000 x12,100000000000000000000000000000000000000 x13,100000000000000000000000000000000000000 x14,100000000000000000000000000000000000000 x15,100000000000000000000000000000000000000 x16,100000000000000000000000000000000000000 x17,100000000000000000000000000000000000000 x18,100000000000000000000000000000000000000 x19,100000000000000000000000000000000000000 x20,100000000000000000000000000000000000000 x21,100000000000000000000000000000000000000 x22,100000000000000000000000000000000000000 x23,100000000000000000000000000000000000000 x24,100000000000000000000000000000000000000 x25,100000000000000000000000000000000000000 x26,100000000000000000000000000000000000000 x27,100000000000000000000000000000000000000 x28,100000000000000000000000000000000000000 x29,100000000000000000000000000000000000000 x30,100000000000000000000000000000000000000 x31,100000000000000000000000000000000000000 x32,100000000000000000000000000000000000000 x33,100000000000000000000000000000000000000 x34,100000000000000000000000000000000000000 x35,100000000000000000000000000000000000000 x36,100000000000000000000000000000000000000 x37,100000000000000000000000000000000000000 x38,100000000000000000000000000000000000000 x39,100000000000000000000000000000000000000 x40,100000000000000000000000000000000000000 x41,100000000000000000000000000000000000000 x42,100000000000000000000000000000000000000 x43,100000000000000000000000000000000000000 x44,100000000000000000000000000000000000000 x45,100000000000000000000000000000000000000 x46,100000000000000000000000000000000000000 x47,100000000000000000000000000000000000000 x48,100000000000000000000000000000000000000 x49,100000000000000000000000000000000000000 x50,100000000000000000000000000000000000000 x51,100000000000000000000000000000000000000 x52,100000000000000000000000000000000000000 x53,100000000000000000000000000000000000000 x54,100000000000000000000000000000000000000 x55,100000000000000000000000000000000000000 x56,100000000000000000000000000000000000000 x57,100000000000000000000000000000000000000 x58,100000000000000000000000000000000000000 x59,100000000000000000000000000000000000000 x60,100000000000000000000000000000000000000 x61,100000000000000000000000000000000000000 x62,100000000000000000000000000000000000000 x63,100000000000000000000000000000000000000 x64,100000000000000000000000000000000000000 x65,100000000000000000000000000000000000000 x66,100000000000000000000000000000000000000 x67,100000000000000000000000000000000000000 x68,100000000000000000000000000000000000000 x69,100000000000000000000000000000000000000 x70,100000000000000000000000000000000000000 x71,100000000000000000000000000000000000000 x72,100000000000000000000000000000000000000 x73,100000000000000000000000000000000000000 x74,100000000000000000000000000000000000000 x75,100000000000000000000000000000000000000 x76,100000000000000000000000000000000000000 x77,100000000000000000000000000000000000000 x78,100000000000000000000000000000000000000 x79,100000000000000000000000000000000000000 x80,100000000000000000000000000000000000000 x81,100000000000000000000000000000000000000 x82,100000000000000000000000000000000000000 x83,100000000000000000000000000000000000000 x84,100000000000000000000000000000000000000 x85,100000000000000000000000000000000000000 x86,100000000000000000000000000000000000000 x87,100000000000000000000000000000000000000 x88,100000000000000000000000000000000000000 x89,100000000000000000000000000000000000000 x90,100000000000000000000000000000000000000 x91,100000000000000000000000000000000000000 x92,100000000000000000000000000000000
alter session set tracefile_identifier='compiler3';
alter session set events 'trace [SQL_Compiler.*] disk=high';
declare csql clob:='select/*+ findme*/ 1 x0';
begin
for i in 1..500 loop
csql:=csql || rpad(',1',40,'0') || ' x'||i;
end loop;
csql:=csql||' () from dual';
for i in 1..1e5 loop
execute immediate csql;
end loop;
end;
/
disc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment