- Identify the main components of the Oracle system global area. What are the subcomponents of each, and what are their roles?
- Describe the role of the DBW0 process
- Describe the role of the LGWR process
-
- What are the filesystem components of an Oracle database?
-
- Why does the Oracle database need two online redo logs
-
- What purpose does the control file serve in the database?
-
- How does Oracle know where to find the control file when the instance starts?
- What purpose does a password file serve?
-
- Describe the purpose of the tnsnames.ora file. Find this file on a machine containing the Oracle client software. Review the contents of the tnsnames.ora file you located.
- Open your Oracle8i generic documentation on the Oracle software distribution CD-ROM. In it, review the Oracle8i Error Messages and the Net8 Administrators Guide documents to identify the resolutions to the following error messages:
- ORA-3113
- TNS-03505
- TNS-12203
- TNS-12224 or TNS-12541
- TNS-12500
-
- Describe how user processes get connected to a server when dedicated servers are used. What is the difference between prespawned dedicated servers and shared servers?
-
- Describe how user processes get connected to a server when MTS is used.
- (BONUS) Can you identify any potential issues with performance implications related to the use of shared versus dedicated servers? (HINT: Where might bottlenecks lie in each architecture?)
- Enable the AUTOTRACE feature in SQL*Plus as follows.
- Move to the $ORACLE_HOME/sqlplus/admin directory on your machine.
- Run SQL*Plus from the command line in that directory as the SYS or INTERNAL user.
- Run the plustrce.sql script by issuing "@plustrce.sql" at the SQL prompt.
- Log out of SQL*Plus.
- Change directories to $ORACLE_HOME/rdbms/admin
- Log back into SQL*Plus as another user to which the DBA role is granted.
- Run the utlxplan.sql script by issuing "@utlexplan.sql" at the SQL prompt
- Issue the SET AUTOTRACE ON command at the SQL prompt.
- Issue the SELECT * FROM USER_TABLES command in SQL*Plus. Then review the contents of the statement execution plan to get an understanding of the results of the RDBMS parsing operations happening behind the scenes.
- Now, review the contents from the statistics listing. Identify which of the following items are shown as output in this context:
- Redo entry size
- Network roundtrips
- Time it took the listener to connect the user with a server
- Frequency of DBW0 write activity
- BONUS: For those items you could not find in the statistical output for AUTOTRACE, determine where you can find that information. (HINT – issue SELECT NAME FROM DICT WHERE SUBSTR(‘TABLE_NAME’,1,1) = ‘V’)
- Determine where you can find information about rollback segments on your database. (HINT – issue SELECT NAME FROM DICT WHERE SUBSTR(‘TABLE_NAME’,1,1) = ‘V’). List all associated views.
- Determine where you can find information about locks in your database. (HINT – issue SELECT NAME FROM DICT WHERE SUBSTR(‘TABLE_NAME’,1,1) = ‘V’). List all associated views.
SOLUTION: V$LOCK V$LOCKED_OBJECT V$LOCKS_WITH_COLLISIONS V$LOCK_ACTIVITY V$LOCK_ELEMENT'
本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1278213