| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbsnmp, outln and SAFE check script
In our configuration, the only user of SYSTEM tablespace is SYSTEM and SYS.
We have 'ALTER USER'd everyone else and moved them with no issues.
-----Original Message-----
From: Reardon, Bruce (CALBBAY) [SMTP:Bruce.Reardon_at_comalco.riotinto.com.au] Sent: Wednesday, November 15, 2000 5:21 PM To: Multiple recipients of list ORACLE-L Subject: dbsnmp, outln and SAFE check script
Hi,
Following on from the SAFE check script kindly supplied by Laura.
Is it possible or advisable to move tables owned by the OUTLN user out of the system tablespace?
I would imagine that they should stay there but interested in experience of others.
Is it possible or advisable to alter the DBSNMP and OUTLN users to have a temporary table space other than system?
I read a Metalink forum posting suggesting it should be done but have others done this?
Note that I have altered sys and system and to have a separate temporary tablespace.
Thanks,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au
-----Original Message-----
Sent: Thursday, 16 November 2000 2:11
To: Multiple recipients of list ORACLE-L
It comes from an article 'How to Stop Defragmenting and Start Living: The
Definitive Word on Fragmentation' by B. Himatsingka and J. Loaiza from the
Oracle Corporation.
SAFE = Simple Algorithm for Fragmentation Elimination
I made a script which contain queries for the rules referenced in the
article. I'll send it to you if you want it.
Laura
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 16 2000 - 08:06:13 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |