Logon time looks faulty

Hi

Oracle 8.1.7.4
Hp Unix 11
Application run peoplesoft

Logon_time from v$session shows Friday Jan 3.The database was halted
on Saturday Jan 4.
What is logon_time supposed to represent.All inquiries so far does not
indicate
Thanks for your input

VincentoVincento Harris (wumutek@.yahoo.com) writes:
> Oracle 8.1.7.4
> Hp Unix 11
> Application run peoplesoft
> Logon_time from v$session shows Friday Jan 3.The database was halted
> on Saturday Jan 4.
> What is logon_time supposed to represent.All inquiries so far does not
> indicate
> Thanks for your input

sysprocesser.login_time is precisly the time that particular spid connected
to SQL Server. I don't see any reason why a login time from the 3rd would
be at fault. Depending on the type of application a spid can be connected
for days or months.

All this does of course pertain to SQL Server, since we are in this
newsgroup. There is a mention about Oracle above, which might come
from somewhere else, but if your quesion was about Oracle, you are
in the wrong newsgroup.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog <sommar@.algonet.se> wrote in message news:<Xns9467F0D49EC03Yazorman@.127.0.0.1>...
> Vincento Harris (wumutek@.yahoo.com) writes:
> > Oracle 8.1.7.4
> > Hp Unix 11
> > Application run peoplesoft
> > Logon_time from v$session shows Friday Jan 3.The database was halted
> > on Saturday Jan 4.
> > What is logon_time supposed to represent.All inquiries so far does not
> > indicate
> > Thanks for your input
> sysprocesser.login_time is precisly the time that particular spid connected
> to SQL Server. I don't see any reason why a login time from the 3rd would
> be at fault. Depending on the type of application a spid can be connected
> for days or months.
> All this does of course pertain to SQL Server, since we are in this
> newsgroup. There is a mention about Oracle above, which might come
> from somewhere else, but if your quesion was about Oracle, you are
> in the wrong newsgroup.

Wrong group .....Thanks for your time

Vincento