| |||||
|
Can anyone tell me when do we need a COLLECTION? More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) Can anyone tell me when do we need a COLLECTION? I know the concept of PLAN and PACKAGE, but unable to understand about COLLECTION.
package is normally linked to plan, however Suppose you want that in a same package , some particular sets of SQLs should have different properties and other set should have different properties then you give the collection id option within a package,for eg: if there are 2 queries and i require that 1st query should have isolation level CS to be for 1st query and RR for the second query then u need to give collection id option within the package for these different isolation levels.
Other Job Interview Questions
|
||||