How to maintain Oracle10g Recyclebin?

SQL> set linesize 132

SQL> column name format a30

SQL> column value format a25

SQL> select

  2    x.ksppinm  name,

  y.ksppstvl  value,

  3    y.ksppstdf  isdefault,

  4    5    decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE')  ismod,

  6    decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE')  isadj

  7  from

  8    sys.x$ksppi x,

  9    sys.x$ksppcv y

 10  where

 11    x.inst_id = userenv('Instance') and

 12    y.inst_id = userenv('Instance') and

 13    x.indx = y.indx and

 14    x.ksppinm like '%&par%'

 15  order by

 16    translate(x.ksppinm, ' _', ' ')

 17  /

Enter value for par: recyclebin

old  14:   x.ksppinm like '%&par%'

new  14:   x.ksppinm like '%recyclebin%'

NAME                           VALUE                     ISDEFAULT ISMOD      ISADJ

------------------------------ ------------------------- --------- ---------- -----

_recyclebin                    TRUE                      TRUE      FALSE      FALSE

1 row selected.

[oracle@danaly ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 12 15:34:56 2005

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

SQL> show parameter recyclebin 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

recyclebin                           string      on

SQL> alter session set recyclebin=off;

Session altered.

SQL> alter session set recyclebin=on

  2  /

Session altered.

SQL> alter system set recyclebin=off;

System altered.

SQL> alter system set recyclebin=on;

System altered.