Logon time looks faulty

[Vincento Harris]

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
Vincento

[Erland Sommarskog]

Vincento Harris (wu*****@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, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Vincento Harris]

Erland Sommarskog <so****@algonet.se> wrote in message news:<Xn**********************@127.0.0.1>...

Vincento Harris (wu*****@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