| 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:Question for Peoplesoft DBAs
Dennis,
You can change the next extent sizes on any PeopleSlop table from any Oracle tool you want. You can even export & import them to compress the extents without causing a problem. The only reason you'd want to edit the PeopleSlop data dictionary is in the event of an upgrade or other action that would cause Peopletools to re-create the table/index. The best thing in that case would be to go to a Peopletools class. The best thing is just to leave matters as they are & when hell breaks loose blame it on PleopleSlop who are in the wrong in the first place. The reason being that the default sizing for PeopleSlop is 8K. What a bunch of Maroons!!!
Dick Goulet
____________________Reply Separator____________________Subject: Question for Peoplesoft DBAs Author: dmeng_at_focal.com
PS DBAs,
I have a real 'dummy-level' question for you: I just took over a new PS
database and I noticed some tables already
have 51 extents after only a few days. I am trying to increase the next
extent size. While I know how to do this in Oracle,
I am not sure if this should be done via PeopleTools or via svrmgrl. If I
have to use PeopleTools, where do I do that from? What kind of operations
can be done via svrmgrl and what can only be done via People Tools?
Dennis Meng
Database Administrator
Focal Communications
847-954-8328
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: dmeng_at_focal.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: 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 Mon Dec 04 2000 - 12:30:15 CST
 |
 |