Temporary Tablespace
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Temporary Tablespace

  1. #1
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    Can the users sys and system be assigned a locally managed temporary tablespace as their temporary tablespace?

    Thanks in Advance..


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes why not?

  3. #3
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Originally posted by default
    Hi,

    Can the users sys and system be assigned a locally managed temporary tablespace as their temporary tablespace?

    Thanks in Advance..

    I would suggest SYSTEM can be altered to LMT TEMP tablespace and leave SYS as it is.
    Nagesh

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by gnagesh
    Originally posted by default
    Hi,

    Can the users sys and system be assigned a locally managed temporary tablespace as their temporary tablespace?

    Thanks in Advance..

    I would suggest SYSTEM can be altered to LMT TEMP tablespace and leave SYS as it is.
    are you joking?

    do you know by doing that SYS will use tablespace system for sorting???

  5. #5
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Originally posted by pando
    Originally posted by gnagesh
    Originally posted by default
    Hi,

    Can the users sys and system be assigned a locally managed temporary tablespace as their temporary tablespace?

    Thanks in Advance..

    I would suggest SYSTEM can be altered to LMT TEMP tablespace and leave SYS as it is.
    are you joking?

    do you know by doing that SYS will use tablespace system for sorting???
    may be I am wrong. I think it is very rare for sys to be perform LARGE sorts, unless you use other than start/stop/recovery operations. Please correct me if i am wrong.

    Nagesh

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    even it does not perform excessive sort you must NEVER use tablespace system for anything else!

  7. #7
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Originally posted by pando
    even it does not perform excessive sort you must NEVER use tablespace system for anything else!
    Thanks Pandu.
    Nagesh

  8. #8
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    what if some sorting needs to be done by sys in the mount stage?

    Thanks

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by default
    what if some sorting needs to be done by sys in the mount stage?
    What kind of sorts should be done in mount stage???? All Oracle has to do in mount stage is to find the control file and read it. What should it sort? And even if it had to, it certainly could not perform any disk sort (at least not in database terms), as the database is still not open, so no tablespace is available to store intermediate sort runs.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Juriy, i gess that he was thinking about query to V$, X$ tables with some kind of sort operations.
    These tables/views avaiable in mount stage.

Posting Permissions

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



Click Here to Expand Forum to Full Width