First page Back Continue Last page Graphics
Example: V$PARAMETER
Use V$PARAMETER to find the current value of initialization parameters
Find the location of the Alert log for this instance:
Notes:
The V$PARAMETER view shows the current value for all database initialization parameters. Since there can sometimes be confusion as to what parameter file the instance was started with, this view is invaluable.
The example above shows us how to determine the location of the alert log for the instance. The alert log is typically named “ALERTinstance_name.LOG" and is a standard text file that can be viewed with any text editor. The alert log contains messages about significant events and is often used in debugging.
Notes for this slide continue on the next page…