Thank you!! Appreciate your input.

Quote Originally Posted by LKBrwn_DBA View Post
Adding to vnktummala's post:

1) It will also depend on the number of files. If you have one tablespace with many files, the backups/restore can be parallelized (vg in RMAN) and you can track I/O issues per file.

2) If you have one or several tablespaces for each schema, you can use "transportable tablespaces" feature for moving data or backing up (archiving old) partitions.

3) Otherwise if you have "bigfiles" tablespace, backups/restore can get un-wieldly.

4) And so on...

My 2c