Db_buffer_cache and library_cache
What is the main difference between the functions of db_buffer_cache and library_cache?
Lets follow the following structure of granting priviledge..A -> b -> C -> d -> EIf we revoke priviledge from c, then what happens with d and e.
hi, It depends upon the type of privilege you are revoking. Is it object priviledge or system priviledge. There is one major difference in the revocation of object privileges and system privileges. Wi...
While creating a new user we set his password as identified GLobally, what does it mean?
We dont set user's password as "identified globally". We write "identified globally" to decide user's scope.Details:In Oracle, we can create user in three ways:1. local user2. external user3. Global u...
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
DB Buffer cache: when a query is executed then server process looks for block in buffer cache. If the block is not available in buffer cache then server process reads the block from data files.L...