Oracle Contexts is very useful, specially for application developers. You can define namespaces, variables and keep their values in memory instead of needing to commit to a table. You can also use it as a global variable where similars sessions can share, so it's a good way to also exchange information!
The documentation related below is very very good and also gives nice walk-through guides. Be ready to use and adapt them in the OCM exam.
So, here, what I recommend you to study and know very well is:
- Creating a Database Session-Based Application Context.
- Creating a Global Application Context.
- Understand where in memory is it placed (for each type).
- Create a Package to Retrieve Session Data and Set the Application Context.
- Create a trigger to set up the initial value.
Path to Documentation:
Database Security Guide -> 6 Using Application Contexts to Retrieve User Information
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
