This content has been marked as final. Show 2 replies
Hello Ram, welcome to OTN forum.
Please provide your db version
select * from v$version;
If your db version is 10g
then use: SQL> alter system flush buffer_cache;
Thanks for the reply,
My Oracle version is 9i and not 10 g. Here is more precise information for you.
Oracle9i Enterprise Edition Release 188.8.131.52.0 - Production
PL/SQL Release 184.108.40.206.0 - Production
CORE 220.127.116.11.0 Production
TNS for 32-bit Windows: Version 18.104.22.168.0 - Production
NLSRTL Version 22.214.171.124.0 - Production
Thanks in advance for any clarities you provide. :-)