Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

Which two statements are true about the use of the procedures listed in the
v$sysaux_occupants.move_procedure column?

Which two statements are true about the use of the procedures listed in the
v$sysaux_occupants.move_procedure column?

A.
The procedure may be used for some components to relocate component data to the SYSAUX
tablespace from its current tablespace.

B.
The procedure may be used for some components to relocate component data from the
SYSAUX tablespace to another tablespace.

C.
All the components may be moved into SYSAUX tablespace.

D.
All the components may be moved from the SYSAUX tablespace.

Explanation:
V$SYSAUX_OCCUPANTS displays SYSAUX tablespace occupant information.
MOVE_PROCEDURE: Name of the move procedure; null if not applicable
For example, the tables and indexes that were previously owned by the system user can now be
specified for a SYSAUX tablespace. You can query the v$sysaux_occupants view to find the exact
components stored within the SYSAUX tablespace.

Show Hint

Leave a Reply 9

Your email address will not be published. Required fields are marked *

Mustafa

Mustafa

A , B

A,B Moving Occupants Out Of or into the SYSAUX Tablespace

You will have an option at component install time to specify that you do not want the component to reside in SYSAUX. Also, if you later decide that the component should be relocated to a designated tablespace, you can use the move procedure for that component, as specified in the V$SYSAUX_OCCUPANTS view, to perform the move.

The move procedure also lets you move a component from another tablespace into the SYSAUX tablespace.

Reply

Di

Di

This column name lists the procedure that can be used to relocate the components that is already located into SYSAUX Tablespace.

Reply

Auron

Auron

the correct answer is B,D
You will have an option at component install time to specify that you do not want the component to reside in SYSAUX. Also, if you later decide that the component should be relocated to a designated tablespace, you can use the move procedure for that component, as specified in the V$SYSAUX_OCCUPANTS view, to perform the move.

Reply

Amar

Amar

Correct answer is A and B for following reason.

The move_procedure column shows the procedure parameters that needs to be passed on to move the component. You can give any USER tablespace to move the component out of SYSAUX or you can give SYSAUX tablespace name to move component into SYSAUX.

Moreover D is also not correct since not all components of SYSAUX can move out of it.

Reply

Carlos

Carlos

A,B

http://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces010.htm#ADMIN11386

For example, assume that you install Oracle Ultra Search into the default tablespace, which is SYSAUX. Later you discover that Ultra Search is using up too much space. To alleviate this space pressure on SYSAUX, you can call a PL/SQL move procedure specified in the V$SYSAUX_OCCUPANTS view to relocate Ultra Search to another tablespace.

The move procedure also lets you move a component from another tablespace into the SYSAUX tablespace.

Reply

liu

liu

A B
For some rows in v$sysaux_occupants move_procedure are null, I suppose it means these components can’t be moved.

Reply