tables to be checked daily as DBA

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 .

thanks

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.