Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: 11i and table partitioning

Re: 11i and table partitioning

From: Jayaraman Ashok <>
Date: 19 Jul 2002 23:16:04 -0700
Message-ID: <>

Thanks for your views. Can you please send the procedure that was adopted when they partitioned the tables? How they did it and what they did, anything specific to 11i that needs to be done,etc....


sg <> wrote in message news:<>...
> We had performance problems with 11.5.3 in a few months back,
> due to company policy we were not allowed by my boss to support internal
> applications. the company called Oracle and they send a couple of guys
> (I think from RDBMS support) the first thing came to their mind was
> partition the tables something which our dba team have been saying for
> months.
> This is funny because the RDBMS support suggest something that Oracle
> Application support dont understand and dont want to do. May be Oracle
> should educate some RDBMS scalability concept to their Applications
> Support (which is pretty poor in any sense)
> Finally a few large tables (around 20 million rows each) were
> partitioned and the performance was boosted.
> Telemachus wrote:
> > One would not partition without direct and positive confirmation from Oracle
> > support unless your support from Oracle is not important. The possible
> > difference in execution and the different indexes that need to be created to
> > simulate the same behaviour will probably invalidate the 11i schema.
> >
> > Somebody else is bound to be running a bigger 11i installation and asked
> > Oracle about this. They were probably told no too !
> >
> > B: 81630 is desupported by Oracle on that platform.
> >
> >
> > Personally if it wasn't a production system I'd be interested in doing it as
> > a lab experiment.
> > "Jayaraman Ashok" <> wrote in message
> >
> >
> >>Hi
> >>The set up is Oracle 11i apps ver.11.5.5 and the database version is
> >> The platform is RS/6000 Aix 4.3.3. The modules are
> >>GL,AP,AR,OE.I plan to partition a few tables. I have not been able to
> >>find proper documentation for the effects of partitioning in 11i
> >>environment. There are some threads that ask the same question but no
> >>concrete reply from Oracle except for one in which the version was
> >>11.0 and Oracle's reply was not supported. A few of my colleagues are
> >>apprehensive about this as they feel that this may create problems
> >>with flexfield data. Can somebody guide me on this and also tell
> >>whether is it all right to partition tables in 11i.
> >>
> >>Cheers,
> >>Ashok
> >>
> >
> >
Received on Sat Jul 20 2002 - 01:16:04 CDT

Original text of this message