Hi, Jack:
I think it is because of you do not use middleware to do connection
pool. For web application, it is terrible that apache directly connect to
database, even using MTS. I suggest you think about your system archeture.

Regards
zhu chao
msn:[Email Address Removed] Original Message -----
From: "Liu, Jack" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Sunday, June 29, 2003 5:53 AM
Subject: inactive share server in v$session


> Hi,
> I use MTS setup fot TCP, I found all session with username are in inactive
> status and using shared server, the last_call_et is longer than 200. Since
> this is a web application, I check I have a lot of httpd process in the
> Apache, can anyone help me about this?
> I use 8.1.7.4, intermedia text and Apache server.
>
> Thanks a lot,
>
> Jack
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
>

Oracle LazyDBA home page