|
From: Rob M. <Rob...@co...> - 2005-12-14 11:31:48
|
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.
>
>
Can you verify that the session that is executing the "analyze"
statement is indeed the
SQuirreL application? You can check this by executing the following in
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
since I used it)
You see, I doubt that SQuirreL is executing this statement. The reason
I say this is
because I just tried doing what you described on my own local Oracle 9i
database.
Then in the Ent. Mgr Console, I looked at the tables that I graphed and
they all say
that the statistics were last analyzed a few days ago. Except for the
table that I did
an explicit analyze on today from SQuirreL. For that table it says it
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
that table.
Rob
CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83
|
