Re: Merge data from 10g database to 11g database

  • From: kevin jernigan <kevin.jernigan@xxxxxxxxxx>
  • To: sbecker6925@xxxxxxxxx
  • Date: Wed, 13 Jun 2012 11:41:06 -0700

Sandra,

How are the documents stored in the 11g database? Are you using the 
SecureFiles LOB feature of 11g, or still using the older format 
(BasicFiles)?

Kevin Jernigan
Senior Director Product Management
Advanced Compression, Hybrid Columnar
Compression (HCC), Database File System
(DBFS), SecureFiles, Database Smart Flash
Cache, Total Recall, Database Resource
Manager (DBRM), Direct NFS Client (dNFS),
Continuous Query Notification (CQN),
Index Organized Tables (IOT), Information
Lifecycle Management (ILM)
(650) 607-0392 (o)
(415) 710-8828 (m)


On 6/13/2012 10:21 AM, Sandra Becker wrote:
> We archive documents Monday-Friday using the merge statement.  Sometimes
> the data is copied back to production but not deleted from the archive
> database and re-archived later, hence the use of the merge statement.
>   Through June 6th we could merge as many as 6,000 documents in just over an
> hour.  Last Saturday the archive database was moved from a SLES10 server to
> a SLES11 server and also new, faster storage, then the database was
> upgraded to 11g.  IT also did some work on the network but I've been told
> that would have no impact on the database servers, only our app servers.
>   Since Monday morning, it now takes over 90 minutes to archive only 300
> documents.   Queries run directly from the 11g archive database perform
> much better than they did when it was on the old server and 10g.
> Questions:
>
> 1.  The production database is 10g, the archive database is 11g.  Does
> Oracle have to do some kind of conversion on the data as it merges it into
> the 11g database?
>
> 2.  What else should I be looking at?  Specific metrics that might give me
> a clue where the problem is?
>
> Thanks in advance for any guidance you can provide.
>
--
http://www.freelists.org/webpage/oracle-l


Other related posts: