Sybase Question:
Download Questions PDF

How do I find the oldest open transaction in Sybase?


select h.spid,, p.cmd,, h.starttime,
p.hostname, p.hostprocess, p.program_name
from master..syslogshold h,
master..sysprocesses p,
master..sysusers u
where h.spid = p.spid
and p.suid = u.suid
and h.spid != 0 /* not replication truncation point */

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
How do I check if log truncation is blocked in Sybase?What are the different types of (All Page) locks in Sybase?