DomainKey-Signature: a=rsa-sha1; c=nofws;        d=gmail.com; s=gamma;        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version         :content-type:content-transfer-encoding:content-disposition         :references;        b=ON4+SIZpEg6RbnDrXJkRyqs8oUqyDifCFBlceNqHq8K0dlUNIKNFYzP5tkZJb69NaV         K7nmHfd2q4RveP8SaDtJnk/osH6DNPWsh1NZd8V8FuQJ46JL/q3SLiZcsNSybIgT+4iK         K4C+ck55y4WEiESuqBwEsQThNMkf0muAfWows=
Message-ID: <9256898f0808081407s6a1907e5m8d1739a94f53c647@mail.gmail.com>
Date: Fri, 8 Aug 2008 17:07:15 -0400
From: dave <david.best@gmail.com>
To: sxmte@email.alaska.edu
Subject: Re: Issues with recyclebin in 10.2.0.3.0
Cc: oracle-l-freelists <oracle-l@freelists.org>
In-Reply-To: <489C8B6D.9020405@email.alaska.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <489C4FF1.3406.000B.0@gcrta.org>	 <489C8B6D.9020405@email.alaska.edu>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: david.best@gmail.com

All the issues I have encountered (so far) with recycle bin can be
found at this URL:

http://newappsdba.blogspot.com/search/label/DB%20Performance

At the time we were on 10.2.0.2 but we upgraded to 10.2.0.3 2 weeks
ago.    I have experienced performance issues but nothing that caused
errors.  Chances are data was modified as your transaction was
running.  A good starting point to read would be metalink
Note:197246.1

On Fri, Aug 8, 2008 at 2:07 PM, Maureen English <sxmte@email.alaska.edu> wrote:
> Has anyone had any issues with the recyclebin in 10.2.0.3.0?
>
> We were doing a software upgrade using a database on HP Tru64
> and a script connecting to the database using an ODBC connection.
> The script was simply dropping about 60 tables (errors okay when
> tables didn't exist), then creating the tables, indexes, sequences.
>
> The user ran the script once and everything was fine.  When he
> ran it a second time, he got the following error:
>
>> 01641 [08/02/08 09:42:54] Statement 0068 DBERR: SaveErrorInfo(): [SQL
>> Error: -1,
>> SQL State: HY000, Native Error Code: 604] SQL Message:
>> [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00604: error
>> occurred at recursive SQL level 1
>> ORA-08177: can't serialize access for this transaction --- Error text:
>> SQLExecDirect() failed (File: OdbcStatement.cpp, Line: 1133, Method:
>> COdbcStatement::ExecDirect())
>> 01641 [08/02/08 09:42:54]     vpsql 0448 FATAL: ERROR: Error executing
>> statement at line: 180 ... Aborting...
>
> Restarting the database made no difference.  I looked around a bit and
> found he had about 168 items in the recycle bin, so I did a purge
> dba_recyclebin
> and everything magically worked.
>
> From what I've read about the recycle bin, objects should disappear from
> it if you need the space.  He certainly didn't need the space, and he had
> been disconnected from the database after running the script the first time.
> Even when he ran it upon restart of the database, he got the error.
>
> Any ideas on what might have been happening?  I cannot reproduce the error
> using sqlplus from the database server or SQL Worksheet from my PC.
>
> - Maureen
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l