Gerard H. Pille

The order of the selected columns is important, and currently (version 3.2) wrong. As a consequence, the right hand side of the Open Cursors (sql text, explain plan, ...) remains empty or causes errors. Easily solved by using the following query: select SQL_Text SQL , p.child_number as chld , c.SQL_ID as sqlid , CURSOR_TYPE , LAST_SQL_ACTIVE_TIME , SQL_EXEC_ID from v$open_cursor c join v$sql_plan p on c.ADDRESS = p.ADDRESS and c.HASH_VALUE = p.HASH_VALUE and c.sql_id = p.sql_id and p.id = 0 where...

The order of the selected columns is important, and currently (version 3.2) wrong. As a consequence, the right hand side of the Open Cursors (sql text, explain plan, ...) remain empty or cause errors. Easily solved by using the following query: select SQL_Text SQL , p.child_number as chld , c.SQL_ID as sqlid , CURSOR_TYPE , LAST_SQL_ACTIVE_TIME , SQL_EXEC_ID from v$open_cursor c join v$sql_plan p on c.ADDRESS = p.ADDRESS and c.HASH_VALUE = p.HASH_VALUE and c.sql_id = p.sql_id and p.id = 0 where sid...

Sorry Ivan, only now I saw your message. But I hate patching on GitHub, let alone patching a "partial" project. What does that mean?

To get a result that is readable (the descriptions should be used as column headers): SELECT osid W_PROC, i.instance_name INSTANCE, 'INST #: '||instance INST, decode(blocker_osid,null,'',blocker_osid)||'@i:'||blocker_instance BLOCKER_PROC, num_waiters waiters, decode(p.spid,null,'', p.spid)||' from Instance '||s.final_blocking_instance FBLOCKER_PROC, p.program image, wait_event_text wait_event, wc.p1 p1, wc.p2 p2, wc.p3 p3, in_wait_secs Seconds, time_since_last_wait_secs sincelw, chain_id ||': '||chain_signature...

Hi, in "4.1.280 INSPECT", the syntax of the replacing-phrase looks quite a lot like the syntax of the tallying-phrase. Kind regards, Gerard

Multiples of 8, not configurable, and corresponding to a terminal's behaviour. That's why I didn't "see" it until a colleague mentioned that possibility.

concerning a-real-cobol-computus 008900* IF EASTER-SUNDAY > 31, EASTER IS IN APRIL - MOVE THE 00890025 009000* MONTH TO APRIL AND SUBTRACT 31 FROM THE MONTH. 00900025 while in fact 31 is subtracted from EASTER-SUNDAY. Kind regards, Gerard

Edit -> Preferences -> Database Settings -> Oracle -> Default Date Format ?