AW: AW: [Squirrel-sql-users] squirrel - plugin graph

[<gua...@po...>]

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 =3D 'javaw.exe'
order by first_load_time asc

1.) select tbl.* ,ROWID from "GUANTERR"."FGHIK" tbl
2.) analyze table GUANTERR.FGHIK compute statistics
3.) select null as table_cat,        owner as table_schem,        =
table_name,        0 as NON_UNIQUE,        null as index_qualifier,      =
  null as index_name, 0 as type,        0 as ordinal_position, null as =
column_name,        null as asc_or_desc,        num_rows as cardinality, =
       blocks as pages,        null as filter_condition from all_tables =
where table_name =3D 'FGHIK'   and owner =3D 'GUANTERR' union select =
null as table_cat,        i.owner as table_schem,        i.table_name,   =
     decode (i.uniqueness, 'UNIQUE', 0, 1),        null as =
index_qualifier,        i.index_name,        1 as type,        =
c.column_position as ordinal_position,        c.column_name,        null =
as asc_or_desc,        i.distinct_keys as cardinality,        =
i.leaf_blocks as pages,        null as filter_condition from all_indexes =
i, all_ind_columns c where i.table_name =3D 'FGHIK'   and i.owner =3D =
'GUANTERR'   and i.index_name =3D c.index_name   and i.table_owner =3D =
c.table_owner   and i.table_name =3D c.table_name


Maybe there is an oracle parameter which lead to the analyze?

Renato



-----Urspr=FCngliche Nachricht-----
Von: Rob Manning [mailto:Rob...@co...]=20
Gesendet: Mittwoch, 14. Dezember 2005 12:31
An: Guanter Renato, PF52
Cc: squ...@li...
Betreff: Re: AW: [Squirrel-sql-users] squirrel - plugin graph


gua...@po... wrote:

>In the toad session browser I could observe the statement.
>To analyze the "big" tables took also some minutes and squirrel was =
naturally busy.
> =20
>
Can you verify that the session that is executing the "analyze"=20
statement is indeed the
SQuirreL application?  You can check this by executing the following in=20
SQuirreL:

select SYS_CONTEXT('userenv','sessionid') from dual

The resultant number is the "sessionid" and should appear in the =
SESSION_ID
column in TOAD.(Or whatever it's called these days - it's been a while=20
since I used it)

You see, I doubt that SQuirreL is executing this statement.  The reason=20
I say this is
because I just tried doing what you described on my own local Oracle 9i=20
database.
Then in the Ent. Mgr Console, I looked at the tables that I graphed and=20
they all say
that the statistics were last analyzed a few days ago.  Except for the=20
table that I did
an explicit analyze on today from SQuirreL.  For that table it says it=20
was last analyzed
today at precisely the time that I executed the statement from SQuirreL.

So, maybe you can fire up the Ent. Mgr. Console where you are, graph one =

table in
SQuirreL and look to see if the "Last Analyzed" date/time changes for=20
that table.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83