Gotta love that. joe
Mercadante, Thomas F wrote: >Bill, > >You said "One note about the Freeware version of TOAD - it has some internal >thing >that limits it to 5 concurrent connections to the same db, which is a >problem for us in a dev shop." > > >I got around this by replacing the v$session view with the following: >Note the "REPLACE" statement in the select for the PROGRAM and MODULE >columns: > > >CREATE OR REPLACE VIEW V$SESSION ( SADDR, >SID, SERIAL#, AUDSID, PADDR, >USER#, USERNAME, COMMAND, OWNERID, >TADDR, LOCKWAIT, STATUS, SERVER, >SCHEMA#, SCHEMANAME, OSUSER, PROCESS, >MACHINE, TERMINAL, PROGRAM, TYPE, >SQL_ADDRESS, SQL_HASH_VALUE, PREV_SQL_ADDR, PREV_HASH_VALUE, >MODULE, MODULE_HASH, ACTION, ACTION_HASH, >CLIENT_INFO, FIXED_TABLE_SEQUENCE, ROW_WAIT_OBJ#, ROW_WAIT_FILE#, >ROW_WAIT_BLOCK#, ROW_WAIT_ROW#, LOGON_TIME, LAST_CALL_ET, >PDML_ENABLED, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER, >RESOURCE_CONSUMER_GROUP, PDML_STATUS, PDDL_STATUS, PQ_STATUS > ) AS SELECT > SADDR >, SID >, SERIAL# > ,AUDSID > ,PADDR > ,USER# > ,USERNAME > ,COMMAND > ,OWNERID > ,TADDR > ,LOCKWAIT > ,STATUS > ,SERVER > ,SCHEMA# > ,SCHEMANAME > ,OSUSER > ,PROCESS > ,MACHINE > ,TERMINAL > ,REPLACE(UPPER(PROGRAM),'TOAD','FROG') PROGRAM > ,TYPE > ,SQL_ADDRESS > ,SQL_HASH_VALUE > ,PREV_SQL_ADDR > ,PREV_HASH_VALUE > ,REPLACE(UPPER(MODULE),'T·O·A·D·','F~R~O~G') MODULE > ,MODULE_HASH > ,ACTION > ,ACTION_HASH > ,CLIENT_INFO > ,FIXED_TABLE_SEQUENCE > ,ROW_WAIT_OBJ# > ,ROW_WAIT_FILE# > ,ROW_WAIT_BLOCK# > ,ROW_WAIT_ROW# > ,LOGON_TIME > ,LAST_CALL_ET > ,PDML_ENABLED > ,FAILOVER_TYPE > ,FAILOVER_METHOD > ,FAILED_OVER > ,RESOURCE_CONSUMER_GROUP > ,PDML_STATUS > ,PDDL_STATUS > ,PQ_STATUS FROM sys.V_$SESSION > > > > >-bill > >-----Original Message----- >Sent: Wednesday, August 28, 2002 8:18 AM >To: Multiple recipients of list ORACLE-L > > > >PL/SQL Developer. > >http://www.allroundautomations.nl/plsqldev.html > >very very good. > > >-----Mensaje original----- >De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel >Enviado el: miércoles, 28 de agosto de 2002 9:13 >Para: Multiple recipients of list ORACLE-L >Asunto: RE: PL/SQL Editor > > >Try free Toad at http://www.toadsoft.com/downld.html > >regards > >Ofer Harel >DBA team >Barak ITC >[EMAIL PROTECTED] > > > >-----Original Message----- >[mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 28, 2002 8:33 AM >To: Multiple recipients of list ORACLE-L > > >Hi All, > which is the best PL/SQL editor available as a trial version . > the editor should support Oracle sql,PL/SQL and may or may not >support debugging. > The tool should be support Win 9X OS and provide best >performance . > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
