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

Thread: Temporary Tablespace

  1. 10-03-2002, 11:19 PM #1
    default
    default is offline Junior Member
    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..

    Reply With Quote Reply With Quote
  2. 10-04-2002, 01:15 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes why not?
    Reply With Quote Reply With Quote
  3. 10-04-2002, 01:17 AM #3
    gnagesh
    gnagesh is offline Senior Member
    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
    Reply With Quote Reply With Quote
  4. 10-04-2002, 03:11 AM #4
    pando
    pando is offline Pando & Company
    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???
    Reply With Quote Reply With Quote
  5. 10-04-2002, 05:53 AM #5
    gnagesh
    gnagesh is offline Senior Member
    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
    Reply With Quote Reply With Quote
  6. 10-04-2002, 06:05 AM #6
    pando
    pando is offline Pando & Company
    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!
    Reply With Quote Reply With Quote
  7. 10-04-2002, 08:28 AM #7
    gnagesh
    gnagesh is offline Senior Member
    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
    Reply With Quote Reply With Quote
  8. 10-04-2002, 02:25 PM #8
    default
    default is offline Junior Member
    Join Date
    Jul 2001
    Posts
    93
    Hi,

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

    Thanks
    Reply With Quote Reply With Quote
  9. 10-04-2002, 02:34 PM #9
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  10. 10-04-2002, 02:40 PM #10
    Shestakov
    Shestakov is offline Senior Advisor
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width