Sybase Question:

Download Job Interview Questions and Answers PDF

How do I find the oldest open transaction in Sybase?

Sybase Interview Question
Sybase Interview Question

Answer:

select h.spid, u.name, p.cmd, h.name, 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?