|
From: Rob M. <Rob...@co...> - 2005-12-14 16:07:23
|
gua...@po... wrote: >Toad tells the right number in AUDSID, and the "current statement" seems that of squirrel. > >I did the "script all tables" again and the Last Analyzed" date/time changed (in toad), just with one table in the graph, 100'000 Rows, 30 MB. > >Is it possible to know the squirrel statement for a "script all tables"? > >I tried > >select * from V$SQL >where module = 'javaw.exe' >order by first_load_time asc > > What's peculiar to me is, when I do a similar query I don't see SQuirreL (javaw.exe) at all: SQL> select distinct module from V$SQL; MODULE ---------------------------------------------------------------- SQL*Plus In fact just after creating a graph I see the following: select sql_text, module from v$sql where sql_text like 'A%' or sql_text like 'a%' SQL_TEXT MODULE ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' <null> alter database open <null> ALTER SESSION SET TIME_ZONE='-5:00' NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' <null> alter database mount exclusive I can only conclude that there is some setting on the server that is causing this. If you look at class net.sourceforge.squirrel_sql.plugins.graph.TableFrameController in method initFromDB you'll see the database access code. It's using the DatabaseMetaData methods to determine columns, primary keys and constraints for a table that is being added to the graph. I can't see how you would get an Oracle-specific "ANALYZE TABLE..." out of this code. Just curious, can you try removing the Oracle Plugin and just using the Graph plugin do you get the same behavior? Rob Manning (P.S. I'm not the author of this module - that's Gerd Wagner - so I can't speak definitively on this. It's just what I can tell by looking at the code for a couple of minutes.) CollabraSpace - Revolutionary Collaboration Visit us at http://www.collabraspace.com This message has been scanned for viruses by ClamAV v0.83 |
