Re: Updating x$

From: fro_doe <fro_doeNOfrSPAM_at_hotmail.com.invalid>
Date: 2000/06/28
Message-ID: <203f8c26.e9e657fd@usw-ex0102-016.remarq.com>#1/1

Most (probably all) of the x$ tables are dumps of memory structures from the SGA or PGA of the process. Aside from changing the parameter that might affect a given value, the only way I know of is to update the memory location (given by the ADDR value from a x$ select) directly with a C program (or maybe oradebug). This does not sound like a good idea to me. In any case, the database protects updates to these "tables" by reporting an ORA-2030 error on anything but a select.

Doug.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jun 28 2000 - 00:00:00 CDT