Compiling invalid PL/SQL code without fixing it?
This is just demonstration how to compile invalid package body with minor errors without fixing code.You should always write correct code which will compile.Big what if you cannot see code ( wrapped or not your code and protected ) but you need to compile that package . Over the years I noticed that most package … Read more
Inside Encrypted tablespace 11g
Security is a big topic these days so it’s time to play with new Oracle 11g features. Apperently encrypted tablespaces has few advantages over TDE ( table level encryption ) .Could not find detail info how all works but got this from google: “Transparent encryption/decryption takes place during disk input/output (I/O) and not for every … Read more
List dinamically modified parameters
Quick way to find dynamically modified parameters. Again old friend oradebug.Command oradebug dump modified_parameters will dump all dynamically altered parameters (parameteres modified using alter system or alter session command). Example: oradebugh setmypid SQL> alter session set cursor_sharing=force; oradebug dump modified_parameters 1 oradebug tracefile_name /oracle/admin/diag/rdbms/test/trace/test_ora_194.trc host vi /oracle/admin/diag/rdbms/test/test_ora_194.trc DYNAMICALLY MODIFIED PARAMETERS: _memory_broker_stat_interval= 600 service_names … Read more
Cursor high_version count Part 2
high_version counts caused by unsafe binds? Oracle event 10046 can be used to determine if binds are unsafe. From the trace file part that represent binds: BINDS #3: Bind#0 oacdty=02 mxl=22(02) mxlc=00 mal=00 scl=00 pre=00 oacflg=10 fl2=0300 frm=00 csi=00 siz=24 off=0 kxsbbbfp=2aaaac0d8cf0 bln=22 avl=02 flg=09 value=100 First field of interest oacdty represent … Read more
Cursor high_version count Part 1
The sql query was using a lot of CPU’s resources.Research shows that cursor has high version_count. It is not being shared because of bind mismatch. So for troubleshooting I have used CURSORTRACE to trace cursor and get more information why cursor is not being shared. Some basic informations and simple test case : Command to start tracing: … Read more
