rahul.mra

 Profile Answers by rahul.mra 

• Jul 2nd, 2008

 

Lock: controling access to page
In sybase, locking is done at page level (whereas in Oracle, it is at row level).
So, suppose if we have a lock (shared lock, write lock) on a page, than we can not access any rows in that page.

dhampack

 Profile Answers by dhampack 

• Nov 23rd, 2008

 

Sybase does support locking at row level in version 12.5 onwards.

Sybase use locking in below modes
- Shared
- Exclusive
- Update

For APL(all page locking), sybase locks data as well index page
For DOL(data only locks) either row level or data page level, sybase use not transactional locking(latches)