Re: in 3 tier structure, how could i know which sql be ran?

I was going to answer you but I would have to write a really long paragraph to explain so I just couldnt do it. I can make some suggestions however

In 3 tier structure it is really hard to track a session specially in a web enviroment because if you are using WebLogic I guess you are using the connection pool. The connection from weblogic to the database is constantly changing, if I rememebr right the jdbc connections use pre spawned connection from weblogic connection pool to database so after request the requesting session disconencts immediately and if the same guy sends another request from the browser the session id is changed again because the request would be using another pre spawned connection from connection pool. Basically what I mean is that a client in a browser rarely holds the same connection (therefore session ID). What you probably have to do is play with userenv function and everytime a request is made you store your sessionid and ip in a table then using the information from that table you can probably query v$session, v$sqlarea, v$sqltext etc Otherwise you would have to enable sql trace for the pre spawned connection in the connection pool

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tq8tpi5tdg3e86_at_news.demon.nl>...
> "May" <sunxushi_at_yahoo.com> wrote in message
> news:8c0f1a9e.0109152015.67a62a69_at_posting.google.com...
> > who know?
>
> Your question is, probably due to your English, incomprehensible.
> I can't make any sense out of it.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
Received on Sun Sep 16 2001 - 14:01:40 CDT