First page Back Continue Last page Graphics
Workshop
Notes:
Server Parameter File Workshop
Check if your current instance is using a server parameter file. If it is, proceed to step 4. If not, proceed to step 2.
Create a SPFILE from the text parameter file.
Restart your instance with the new spfile.
Reduce the size of the shared pool by 4 Mb. Make this change persistent.
Restart the database with the SPFILE. Check that the change made in step 4 is still in effect.
Create a text version of the server parameter file. View the contents.
Restart your instance with the text parameter file.
What is the current value of of your shared_pool_size parameter?