Thanks for the info. I really appreciate it.
What could cause serial# change over time and why it is changing?

I am collecting "CPU used by this session" and found out some session got huge number on this, so I started to doubt that the serial# change and my collecting program recount them over and over again.


-----Original Message-----
From: Michael McMullen [mailto:[Email Address Removed] Monday, March 31, 2003 10:44 AM
To: LazyDBA.com Discussion; Lei, Michael
Subject: Re: Does anyone know?


I had the exact same thing happen to me once. Of course, I can't recall the
version or the fix but the sid would stay the same with the Serial# changing
continuously. It wasn't executing in parallel either.

Mike
[Email Address Removed] Original Message -----
From: "Lei, Michael" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Monday, March 31, 2003 11:27 AM
Subject: Does anyone know?


Hello Gurus,

Is it possible that a session change its serial# even when it is still
connected to Oracle?
Thx.

Regards,
Michael Lei

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] 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