When Running the 10gR2 Pre-Upgrade Checks Script "<10gR2 ORACLE_HOME>/rdbms/admin/utlu102i.sql", got the following Output:- ********************************************************************** Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile] ********************************************************************** -- No deprecated parameters found. No changes are required. . ********************************************************************** Obsolete Parameters: [Update Oracle Database 10.2 init.ora or spfile] ********************************************************************** --> "hash_join_enabled" --> "log_parallelism" --> "transaction_auditing" --> "enqueue_resources" Following Links did NOT help so much http://en.wikipedia.org/wiki/Obsolete http://en.wikipedia.org/wiki/Deprecated Thanks indeed ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA Sent: Thursday, October 26, 2006 4:25 PM To: oracle-l@xxxxxxxxxxxxx Subject: Difference between Deprecated & Obsolete parameters of 10gR2 ? ... Basic Qs Folks What is the Difference between Deprecated & Obsolete parameters of 10gR2 ? Thanks indeed **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***