Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: oradebug suspend question
Tanel,
I know, we are not what we would like to be, so I am trying to find some middle point. We can't make drastic changes to app, ESPN's daily business including on-air scores and programming gets affected by that (not to mention the huge calculators that run to estimate how much money we make by charging all of you to watch ESPN <g>).
Thanks, you almost confirmed my fear.
ps: I just got confirmed to Hotsos/04 and Steve Adams class, so hopefully I'll meet you in Dallas, TX. Raj
-----Original Message-----
Sent: Thursday, December 04, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Then have two sets of packages for reports, when releasing new versions, do them on set 2 whilst normal users are running on set 1. This gives you time to test new versions in production as well. When tests are successful, switch to set 2.
Oh yes, this requires your application/reports to be aware of this "set" architecture. Basically you should have some kind of control table where you state on which set newly executed reports should run.
Btw, how can you have constant DML activity and reporting going on when you
have suspended your sessions?
When your session executes a package and is suspended, the package is still
pinned anyway and you cant just replace it on the fly.
The baseline is, despite RAC you still one single database and you can't have this kind of online updating without doing some fundamental changes in the app.
Tanel.
**************************************************************************************5
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Fri Dec 05 2003 - 06:24:32 CST