[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    RE: FRM-40734 - problem with set transaction use rollback segment arms_rollback_segment
From:       "G Dixon" <gdixon () ctri ! com>
Date:       2002-07-19 14:24:53
[Download RAW message or body]

Spreading Rollback Segments and other highly active files
across several disk controllers can improve performance due
to spreading I/O (inherently slow compared to memory
access).  This keeps I/O from queueing up resulting in
waits.

Grant

-----Original Message-----
Kamal
Mutneja
Sent: Friday, July 19, 2002 08:23 AM
To: Multiple recipients of list ODTUG-SQLPLUS-L
rollback segment
arms_rollback_segment

Hi All,

In order to improve processing speed, I have created a
rollback segment names - 'arms_rollback_segment'. Its
status remains online but it gives the following error
- FRM-40734.

I am using this rollback segment in many forms, it
works fine with one form but gives the above mentioned
error with the other.

Also please advise hwo can we make best use of a
rollback segment to enhance performance.

Regards

Kamal Mutneja



__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
Thanks to everyone for making ODTUG 2002 a great success!
Plan now
for next year's conference: Loews Miami Beach, Florida, June
22-27, 2003.
--
Author: Kamal Mutneja
  INET: shinakhi@yahoo.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@fatcity.com (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB
ODTUG-SQLPLUS-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).


Thanks to everyone for making ODTUG 2002 a great success!  Plan now
for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003.
-- 
Author: G Dixon
  INET: gdixon@ctri.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@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-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).
[prev in list] [next in list] [prev in thread] [next in thread]