Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2008
    Posts
    27

    Unanswered: About page number

    Hi All,

    I have a databse with some size,in that db there are some objects,so each object will occupies some space,

    my question is that how we will find out the in which page that object is there?
    2. what the the starting page and ending page?

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    If you really want to understand this answer, you need to read up on how DOL (data only lock) and APL (all pages lock) are structured and also how they work with different isolation levels.

    Heres a short description to get you started.

    sysindexes table.

    doampg - Page number of first OAM page for the table data
    ioampg - Page number of first OAM page for the index data
    first - Page number of first data page if index id is 0 or 1, for rest page number of first leaf-level index
    root - Root page of table or index

  3. #3
    Join Date
    Feb 2008
    Posts
    27
    hi Trvishi,

    do u have any manual or any URL that i have start the above thing wt u have mentioned . if so can u plz help me,

    thank's in advance.................

  4. #4
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Start with

    http://sybooks.sybase.com

    Adaptive Server Enterprise / 12.5 / Performance & Tuning Guide / Locking in Adaptive Server, Data Storage.

    If you have the $$, try attending the Advanced ASE course or borrow the course material from someone if they have already attended for reading. Its a lot better structured/detailed in the course.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •