Skip to Content
avatar image
Former Member

reorganize oracle table online

Hi

I have a very big table ( about 12GB in size , with index 16 GB) , this need to be reorg often, database ( Oracle 11G) is with dataguard enabled with log shipping to DR database, last time we did online with SQL statement , it took more than 24 hours.

Just wondering what is the best way to reorg this type of big table , is there any tool available for online reorg can do better job ? Is brspace is better option ?

Thanks in advance, reply will be appreciated

Al Mamun

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 29, 2012 at 07:31 AM

    Hi

    >

    > I have a very big table ( about 12GB in size , with index 16 GB) , this need to be reorg often, database ( Oracle 11G) is with dataguard enabled with log shipping to DR database, last time we did online with SQL statement , it took more than 24 hours.

    >

    > Just wondering what is the best way to reorg this type of big table , is there any tool available for online reorg can do better job ? Is brspace is better option ?

    >

    > Thanks in advance, reply will be appreciated

    >

    > Al Mamun

    I'm not sure what do you mean.

    1.- this need to be reorg often,

    why do you need to reorganize often this 12 gb table, may be that is a mistake. not sure, please explain why you need to do it.

    2.- we did online with SQL statement

    what statement?

    3.- it took more than 24 hours.

    it is online, what is the problem if it takes 24 hours (still i think 12 GB in 24 hours is too much

    4.- Is brspace is better option ?

    a better option than what? brspace offers you a lot of flexibility, but it is difficult to compare this tool to "what you have not provided"

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30, 2012 at 05:51 AM

    Hi,

    The best way might be to use brspace .check this

    Note 646681 - Reorganizing tables with BRSPACE

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 30, 2012 at 09:21 AM

    Hi Al Mamun,

    At the first stage, I recommend you to archive the SAP data, in order to avoid long runtime. Secondly, you can use "-p|-parallel" parameter on brspace to fork parallel threads, to decrease the runtime, but it is not generally recommend setting parallel processing too high.

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded