-
Hi,
Can the users sys and system be assigned a locally managed temporary tablespace as their temporary tablespace?
Thanks in Advance..
-
-
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
-
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???
-
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
-
even it does not perform excessive sort you must NEVER use tablespace system for anything else!
-
Originally posted by pando
even it does not perform excessive sort you must NEVER use tablespace system for anything else!
Thanks Pandu.
Nagesh
-
Hi,
what if some sorting needs to be done by sys in the mount stage?
Thanks
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|