Give two methods you could use to determine what DDL changes have been made.
You could use Logminer or Streams
How would you determine what sessions are connected and what resources they are waiting for?
Use of V$SESSION and V$SESSION_WAIT
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Setting GLOBAL_NAMES describes how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they are linking.
You could use Logminer or Streams
How would you determine what sessions are connected and what resources they are waiting for?
Use of V$SESSION and V$SESSION_WAIT
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Setting GLOBAL_NAMES describes how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they are linking.
No comments:
Post a Comment