Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: number of tablespaces in 9i

    Hi guys

    I understand ASM was introduced in Oracle 10g.

    However, in 9i, would more tablespaces enhance performance?

    Regards

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >However, in 9i, would more tablespaces enhance performance?
    If that is the only change, then the answer is NO
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    I'm sure that wouldn't be the only change. I was just asking generally. If I rephrase my question:

    In Oracle 9i, how would one decide how many tablespaces to have in their database?

    Like say, if the kind of data to be loaded in the db is 100s of files every 15 min each with 10 to 50 columns and all these columns having entries of data type (number).

    Regards

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >In Oracle 9i, how would one decide how many tablespaces to have in their database?

    A tablespace is a logical entity & for DBA's benefit & NONE for performance!

    If the ONLY change is number of tablespaces, explain how performance can change?

    The number of tablespace has NO impact on DB performance.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2008
    Posts
    464
    Thanks for replying.

    I've found out that the number of tablespaces used to have an effect on performance in the pre-SAN days when data had to be manually distributed/striped across an array of hard-disks.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I've found out that the number of tablespaces used to have an effect on performance in the pre-SAN days when data had to be manually distributed/striped across an array of hard-disks.

    It is NOT the number of tablespaces that impacts performance.
    It is the number of physical disk volumes that can impact performance.
    By assigning different data files residing on different physical disk volume to the same tablespace can improve performance.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •