Re: Relocating LOB segment
- From: sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
- To: dmarc-noreply@xxxxxxxxxxxxx
- Date: Mon, 9 Feb 2015 09:32:49 +0530
You can use DBMS_REDEFINITION
<http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_redefi.htm>
.
On Sat, Feb 7, 2015 at 8:14 AM, Yong Huang <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
> Hi Kevin,
>
> Is there any reason why it's not the default in 11g? One user asked me and
> I don't know a good answer.
>
> I'm convinced of its advantage and will set db_securefile to always on all
> our databases. Thanks.
>
> Yong
>
> ------------------------------
> *From:* Kevin Jernigan <kevin.jernigan@xxxxxxxxxx>
> *To:* coloradodba@xxxxxxxxx; Yong Huang <yong321@xxxxxxxxx>
> *Cc:* Oracle-l Digest Users <oracle-l@xxxxxxxxxxxxx>
> *Sent:* Friday, February 6, 2015 5:16 PM
> *Subject:* Re: Relocating LOB segment
>
> There are no known edge cases where BasicFiles works better than
> SecureFiles, other than MSSM tablespaces. This is one of the reasons we
> made SecureFiles the default starting in Oracle Database 12c.
>
> -KJ
>
> --
> 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)
> +1-650-607-0392 (o)
> +1-415-710-8828 (m)
>
> On 2/6/15 7:57 AM, Brent Day wrote:
>
>
> We actually set db_aecurefile parameter to always on all of our instances
> and have only seen positive results.
>
> Of course the setting change only applies to newly created lobs after
> the setting is changed. LOBs created before have to be converted through a
> move/reorganize.
>
> Of course the tablespace has to be ASSM or you will get the respective
> error.
>
> We own advanced compression and advanced security and the deduplicte
> that come with advanced compression has proven very beneficial for several
> of our apps.
>
> The Lob compression works very well and I have found medium compression
> on LOBS to work well. I tried high but the CPU usage outweighed the benefit
> for our needs.
>
> As always YMMV
>
> Brent
>
> On Friday, February 6, 2015, Yong Huang <yong321@xxxxxxxxx> wrote:
>
> > If you are on 11.2 and use SecureFiles then you can export with
> parallel
>
> It actually started at 11.1.
>
> Now I have a question. Can anybody think of anything bad about setting
> db_securefile to always in Oracle 11g so all LOBs are created as SecureFile
> instead of BasicFile? We're recommended to use SecureFile LOB (see Doc
> 1467662.1 and many others), and it's the default in 12c. Other than the
> restriction that SecureFile LOB can't be created in a non-ASSM i.e. MSSM
> tablespace, I see only benefit, no disadvantage. Without the advanced
> security or compression license, users have to be careful not to
> accidentally add certain clauses to trigger usage of these licenses. But
> that's a minor concern.
>
> Yong Huang
>
>
>
>
>
>
--
*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*
Other related posts:
