DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001
    hi all,

    Can somebody tell me what al are the tables like v$sysstat etc that i have to look daily to monitor the database for performance and routine check.

    and also the difference between latching and lock .


  2. #2
    Join Date
    Oct 2000
    A latch forces serialized access to certain memory processes.

    A lock is a mechanism to ensure that more than one user cannot change data in a table (row level locks) or table structure (table locks). Locks can be shared or exclusive.

    There are lots of V$ synonyms (widely referred to as views) that are helpful in tuning and gaining an idea of what is happening on the database.

    Look at v$fixed_table to see a list.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.