REDO_TRANSPORT_USER

Property	Description
Parameter type	String
Syntax	REDO_TRANSPORT_USER = user_name
Default value	There is no default value.
Modifiable	ALTER SYSTEM
Basic	No

REDO_TRANSPORT_USER specifies the name of the user whose password verifier is used when a remote login password file is used for redo transport authentication. This user must have SYSOPER privileges and must have the same password in the database that initiates the redo transport session and in the database that is the target of the redo transport session.

If this parameter is not specified, then the password verifier of the SYS user will be used when a remote login password file is used for redo transport authentication.

Note

1. The parameter was introduced in 11g.

Oracle initializatoin parameters

RECYCLEBIN

Property	Description
Parameter type	String
Syntax	RECYCLEBIN = { on | off }
Default value	on
Modifiable	ALTER SESSION, ALTER SYSTEM ... DEFERRED
Basic	No

RECYCLEBIN is used to control whether the Flashback Drop capability is turned on or off. If the parameter is set to off, then dropped tables do not go into the recycle bin. If this parameter is set to on, then dropped tables go into the recycle bin and can be recovered.

Note:

1. The Recycle Bin is a virtual container where all dropped objects reside. Underneath the covers, the objects are occupying the same space as when they were created. If table EMP was created in the USERS tablespace, the dropped table EMP remains in the USERS tablespace. Dropped tables and any associated objects such as indexes, constraints, nested tables, and other dependant objects are not moved, they are simply renamed with a prefix of BIN$$. You can continue to access the data in a
dropped table or even use Flashback Query against it. Each user has the same rights and privileges on Recycle Bin objects before it was dropped. You can view your dropped tables by querying the new RECYCLEBIN view. Objects in the Recycle Bin will remain in the database until the owner of the dropped objects decides to permanently remove them using the new PURGE command. The Recycle Bin objects are counted against a user's quota. But Flashback Drop is a non-intrusive feature.

2. Objects in the Recycle Bin will be automatically purged by the space reclamation process if

· A user creates a new table or adds data that causes their quota to be exceeded.

· The tablespace needs to extend its file size to accommodate create/insert operations.

3. There is no issues with DROPping the table, behaviour wise. It is the same as in 8i / 9i. The space is not released immediately and is accounted for within the same tablespace / schema after the drop.

4. When we drop a tablespace or a user there is NO recycling of the objects.

5. Recyclebin does not work for SYS objects

6. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = 'RECYCLEBIN';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
recyclebin	on	TRUE	TRUE	IMMEDIATE	TRUE		FALSE	recyclebin processing

Oracle initializatoin parameters

RECOVERY_PARALLELISM

Property	Description
Parameter type	Integer
Default value	Operating system-dependent
Modifiable	No
Range of values	Operating system-dependent, but cannot exceed PARALLEL_MAX_SERVERS

RECOVERY_PARALLELISM specifies the number of processes to participate in instance or crash recovery. A value of 0 or 1 indicates that recovery is to be performed serially by one process.

Note:

1. See also

• Oracle Database Performance Tuning Guide for information on setting this parameter in exclusive mode
• Oracle Real Application Clusters Administration and Deployment Guide for information on setting this parameter in a Real Application Clusters environment

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = 'RECOVERY_PARALLELISM';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
recovery_parallelism	0	TRUE	FALSE	FALSE	FALSE		FALSE	number of server processes to use for parallel recovery

Oracle initializatoin parameters