Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Why it is preferred to create a table space on a partition other than the system partition?

user-image
Question added by عقبة بلخيري , Ingénieur d'état en Informatique , Administration
Date Posted: 2016/06/05
SYED Mubbashir Rehman
by SYED Mubbashir Rehman , Application Support Engineer (Mid Level) , VERSCOM SOLUTIONS

  • Easy roll-in and roll-out of data.
  • Easier administration of large tables.
  • Flexible index placement.
  • Faster query processing.
  • Table partitioning improves performance by eliminating large amounts of I/O.

fahd soliman
by fahd soliman , programmer , National Agency for Network Services

to get the largest performance, that when Oracle system work on system partition, the other table space will be in hand and have the speed to read from other partition

More Questions Like This