General Storage Enhancement

These questions are based on 1Z0-045 – Oracle Database 10g DBA New Features for Oracle8i OCPs.

 

Objective: General Storage Enhancement
Sub-Objective: Relocate SYSAUX occupants

 

Single Answer, Multiple Choice

You want to relocate the STREAMS component from the SYSAUX tablespace to the SYS_COM tablespace. The SYS_COM tablespace is a bigfile tablespace. Which statement is true?

 

 

  1. You cannot relocate the STREAMS component.
  2. None of the occupants of the SYSAUX tablespace can be relocated.
  3. You cannot relocate the STREAMS component to a bigfile tablespace.
  4. The STREAMS component under the SYSAUX tablespace can be relocated only to the SYSTEM tablespace.

 

Answer:
A. You cannot relocate the STREAMS component.

 

Tutorial:
The Oracle Streams (STREAMS) component cannot be relocated from the SYSAUX tablespace because there is no move procedure that is applicable to relocate the STREAMS component. You can check the availability of the move procedure used to relocate the STREAMS component by using the following query:

 

SQL> SELECT occupant_name,occupant_desc,schema_name,move_procedure,move_procedure_desc
2 FROM v$sysaux_occupants
3 WHERE occupant_name=’ODM’;

 

If the move procedure does not exist, the component cannot be relocated.

 

The option stating that none of the occupants of the SYSAUX tablespace can be relocated is incorrect. There are only a few components that cannot be relocated. You can query the V$SYSAUX_OCCUPANTS dictionary view to identify the components that can be moved and also the name of the move procedure used to relocate the components.

 

The option stating that you cannot relocate the STREAMS component to a bigfile tablespace is incorrect. The SYSAUX components can be relocated to bigfile tablespaces, provided the move procedure exists for the component to relocate the component. The STREAMS component cannot be relocated to any tablespace because there is no move procedure applicable to relocate the STREAMS component.

 

The option stating that the STREAMS component under the SYSAUX tablespace can be relocated only to the SYSTEM tablespace is incorrect because the STREAMS component cannot be relocated to any other tablespace.

 

Reference:
1. Oracle University – Oracle Database 10g: New Features for Administrators – General Storage Enhancement
D17079GC10
Edition 1.0
February 2004
D39100

 

2. Oracle University – Oracle Database 10g: New Features for Administrators – General Space Management Enhancements
D17079GC21
Edition 2.1
October 2005
D22243

 

3. Oracle Database Administrator’s Guide
10g Release 2 (10.2)
Part Number B14231-02
Chapter: 8 Managing Tablespaces
Topic: Managing the SYSAUX Tablespace
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#i1011659

Like what you see? Share it.Google+LinkedInFacebookRedditTwitterEmail
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: