Nayef Mehdawi wrote:Possibly. You may be able to establish an affinity between instances and partitions, which can reduce contention for global enqueues and interconnect traffic.
Does the partitioning [table partitioning or indexes partitioning] give more performance value over the RAC since i'm using only one disk +DATA
so I haven't any control over the disk groupsYou should talk to the storage team that assigned the disks / LUNs. You should talk to the DBA that created the Disk Group over those disks / LUNs.
The characteristic which you mentioned that there is no Full Table Scan can be done by regular index so with index will be no full table scan as wellIt depends. Many a times a Full Table Scan or a Full Table Scan on only target partition(s) is better than using an index. It really depends on the number of rows and blocks to be read and the distribution of the target rows across the table / partition (the index clustering factor).
Nayef Mehdawi wrote:Partitioning is not a RAC feature. It is an Enterprise Edition feature. It addresses two primary issues.
I searched alot for technical documents regarding partitioning over the RAC , performance and value but i couldn't find any link or oracle document.