RE: Evaluation questions - Precise Tool
You need to detirmine what you are looking for before ANY of those questions can be answered. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 02, 2001 3:20 AM To: Multiple recipients of list ORACLE-L Which Components of this Tool (Precise) are advisable ? How does it Compare with Other Tools ? Any Highlights ? Lastly Paying for a Tool , is it indeed Advisable OR are there any Freeware Tools which may be Good enough ? > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 11:04 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Evaluation questions > > > > Chaim, > > That could work. Logminer wasn't around when I first had this problem, > and I haven't spent time working with it. > > From what I know from listening to Joe present on it though, it would > be a more complicated process than I want. I'd have to be sure that > the dictionary map was always up to date, and I would have to go back > and look > through all the archived logs as well as the online ones, in case the > statement had been archived off. It also sounds like it would be > intensely > manual. > > Joe -- any thoughts on this? > > > I want something that runs FAST, so I can clear locks quickly. And > then go on to the fun stuff of killing duhvelopers. > > Rachel (today it is hot and humid here, and today the AC in the office > > doesn't work killing duhvelopers is looking like more and more > fun) > > > > >From: [EMAIL PROTECTED] > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: Evaluation questions > >Date: Wed, 01 Aug 2001 07:51:19 -0800 > > > > > > > > > > > > > > > > > >"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM > > > >Please respond to [EMAIL PROTECTED] > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >cc:(bcc: Chaim Katz/Completions/Bombardier) > > > > > > > > > >Rachel, > > > >I don't know how to retreive the locking sql either, but reading this > > >discussion > >it occurred to me that 1) in v$session (of the blocked session) we > have > >the > >file#,block#,row# that is being waited on. Maybe with logminer (or > >something > >like it) we could find the most recent SQL that affected this > block/row? > > > >Chaim > > > > > > > >Gary, > > > >I wish it did. I worked with Q Diagnostics for quite a while, and > worked > >directly with the developer (although calling John Beresniewicz a > developer > >is an understatement, he's brilliant!) on answering that problem. > > > >Neither Q nor anything from Platinum (does that tell you how long ago > it > >was?) was able to find the locking sql with any precision. The answer > I got > >back from both of them was "if you figure out how to do it, PLEASE > let us > >know" > > > >Having said that, Q Diagnostics was indeed bliss... I fixed locks > before > >users complained, was able to model and monitor bad SQL and fix it > and had > >lots of good info directly on the desktop. > > > >Rachel > > > > > > >From: "Gary Weber" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: RE: Evaluation questions > > >Date: Tue, 31 Jul 2001 06:11:36 -0800 > > > > > >Rachel, > > > > > >I believe your second wish from below (locking SQL) has been > granted by > > >former Savant product called Q Diagnostic Center, currently owned > by > > >Precise. Drill down to locks, including user and SQL info - its a > bliss. > > > > > >Gary Weber > > >Senior DBA > > >Charles Jones, LLC > > >609-530-1144, ext 5529 > > > > > >-Original Message- > > >Carmichael > > >Sent: Tuesday, July 31, 2001 8:56 AM > > >To: Multiple recipients of list ORACLE-L > > > > > > > > >one I want is "can the package tell me when a datafile extends" &g
RE: Evaluation questions - Precise Tool
Which Components of this Tool (Precise) are advisable ? How does it Compare with Other Tools ? Any Highlights ? Lastly Paying for a Tool , is it indeed Advisable OR are there any Freeware Tools which may be Good enough ? > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 11:04 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Evaluation questions > > > > Chaim, > > That could work. Logminer wasn't around when I first had this problem, > and I > haven't spent time working with it. > > From what I know from listening to Joe present on it though, it would > be a > more complicated process than I want. I'd have to be sure that the > dictionary map was always up to date, and I would have to go back and > look > through all the archived logs as well as the online ones, in case the > statement had been archived off. It also sounds like it would be > intensely > manual. > > Joe -- any thoughts on this? > > > I want something that runs FAST, so I can clear locks quickly. And > then go > on to the fun stuff of killing duhvelopers. > > Rachel (today it is hot and humid here, and today the AC in the office > > doesn't work killing duhvelopers is looking like more and more > fun) > > > > >From: [EMAIL PROTECTED] > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: Evaluation questions > >Date: Wed, 01 Aug 2001 07:51:19 -0800 > > > > > > > > > > > > > > > > > >"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM > > > >Please respond to [EMAIL PROTECTED] > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >cc:(bcc: Chaim Katz/Completions/Bombardier) > > > > > > > > > >Rachel, > > > >I don't know how to retreive the locking sql either, but reading this > > >discussion > >it occurred to me that 1) in v$session (of the blocked session) we > have > >the > >file#,block#,row# that is being waited on. Maybe with logminer (or > >something > >like it) we could find the most recent SQL that affected this > block/row? > > > >Chaim > > > > > > > >Gary, > > > >I wish it did. I worked with Q Diagnostics for quite a while, and > worked > >directly with the developer (although calling John Beresniewicz a > developer > >is an understatement, he's brilliant!) on answering that problem. > > > >Neither Q nor anything from Platinum (does that tell you how long ago > it > >was?) was able to find the locking sql with any precision. The answer > I got > >back from both of them was "if you figure out how to do it, PLEASE > let us > >know" > > > >Having said that, Q Diagnostics was indeed bliss... I fixed locks > before > >users complained, was able to model and monitor bad SQL and fix it > and had > >lots of good info directly on the desktop. > > > >Rachel > > > > > > >From: "Gary Weber" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: RE: Evaluation questions > > >Date: Tue, 31 Jul 2001 06:11:36 -0800 > > > > > >Rachel, > > > > > >I believe your second wish from below (locking SQL) has been > granted by > > >former Savant product called Q Diagnostic Center, currently owned > by > > >Precise. Drill down to locks, including user and SQL info - its a > bliss. > > > > > >Gary Weber > > >Senior DBA > > >Charles Jones, LLC > > >609-530-1144, ext 5529 > > > > > >-Original Message- > > >Carmichael > > >Sent: Tuesday, July 31, 2001 8:56 AM > > >To: Multiple recipients of list ORACLE-L > > > > > > > > >one I want is "can the package tell me when a datafile extends" > > > > > >also, I want (and have NEVER found) a package that can tell me the > >locking > > >SQL, when the locker has gone on and done other SQL after the lock. > > > > > >ex. > > > > > >user1 does: > > > select * from table for update where > > > update table > > > insert into second table > > >and does not commit > > > > > >user2 comes in and tries to update the fi
RE: Evaluation questions
Chaim,
"loading the right log file involves some trial and error"
that is just what I DON'T have time for when the database has slowed to a
crawl and all of upper management is looking over my shoulder wondering why
I haven't fixed it yet.
Rachel
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Wed, 01 Aug 2001 12:15:51 -0800
>
>
>
>
>
>
>
>"Hillman, Alex" <[EMAIL PROTECTED]> on 08/01/2001 02:16:31 PM
>
>Please respond to [EMAIL PROTECTED]
>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>cc:(bcc: Chaim Katz/Completions/Bombardier)
>
>
>
>
>All,
>
>I just tried a log miner test (without the logminer dictionary). It wasn't
>so
>bad:
>
>Here is the blocker:
>
> 1 select sid,type,lmode,request,block,round(ctime/60,2) ctime
> 2 from v$lock
> 3 where block != 0
>
>SID Lock TypeMode Held Mode Requested Blocking? Minutes
>Blocked
>-- --- -- -- --
>---
> 32 TX 6 0 1
>33.83
>
>Here is the blocker's transaction:
>
> 1 select t.xidusn,t.xidslot,t.xidsqn
> 2 from v$transaction t, v$session s
> 3 where t.addr = s.taddr and
> 4s.sid=32;
>
> XIDUSNXIDSLOT XIDSQN
>-- -- --
> 4 55 44118
>
>
>Load a redo log:
>
> 1 begin
> 2 sys.dbms_logmnr.add_logfile
> 3 ('C:\ORACLE\ORADATA\DEV816\REDO02.LOG',
> 4sys.dbms_logmnr.new);
> 5 sys.dbms_logmnr.start_logmnr;
> 6 end;
>
>PL/SQL procedure successfully completed.
>
>
> 1 select sql_redo
> 2 from v$logmnr_contents
> 3 where xidusn=4 and
> 4 xidslt=55 and
> 5 xidsqn=44118;
> 6 and rownum < 4;
>
>SQL_REDO
>
>set transaction read write;
>delete from "UNKNOWN"."Objn:45095" where "Col[1]" = HEXTORAW('c24a46') and
>"Col[2]" = HEXTORAW('534d
>495448') and "Col[3]" = HEXTORAW('434c45524b') and "Col[4]" =
>HEXTORAW('c25003')
>and "Col[5]" = HEXT
>ORAW('77b40c11010101') and "Col[6]" = HEXTORAW('c209') and "Col[7]" IS NULL
>and
>"Col[8]" = HEXTORAW(
>'c115') and ROWID = 'AAALAnAADAAAJAzAAA';
>Check the table name
> 1 select owner,object_name
> 2 from dba_objects
> 3* where object_id=45095
>
>OWNER OBJECT_NAME
>-- --
>SCOTT EMP
>
>
>Voila, the blocking statement is: DELETE FROM emp. (I limited the output,
>but
>there are actually 14 sql_redo statmements that differ only in the value of
>the
>rowid.) (Loading the right log file involves some trial and error.)
>(Remember
>you saw it here first.)
>
>Chaim
>
>
>
>
>
>
>
>
>
>If you had SQL trace available - you would be able to find SQL for the
>session. One time on this list I heard mention about x$trace - like it has
>all data of the event 10046 trace only not in the trace file but in memory.
>Anumbody has some infp about it?
>
>Alex Hillman
>
>-Original Message-
>Sent: Wednesday, August 01, 2001 1:34 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>
>Chaim,
>
>That could work. Logminer wasn't around when I first had this problem, and
>I
>
>haven't spent time working with it.
>
>From what I know from listening to Joe present on it though, it would be a
>more complicated process than I want. I'd have to be sure that the
>dictionary map was always up to date, and I would have to go back and look
>through all the archived logs as well as the online ones, in case the
>statement had been archived off. It also sounds like it would be intensely
>manual.
>
>Joe -- any thoughts on this?
>
>
>I want something that runs FAST, so I can clear locks quickly. And then go
>on to the fun stuff of killing duhvelopers.
>
>Rachel (today it is hot and humid here, and today the AC in the office
>doesn't work killing duhvelopers is looking like more and more fun)
>
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PR
RE: Evaluation questions
"Hillman, Alex" <[EMAIL PROTECTED]> on 08/01/2001 02:16:31 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)
All,
I just tried a log miner test (without the logminer dictionary). It wasn't so
bad:
Here is the blocker:
1 select sid,type,lmode,request,block,round(ctime/60,2) ctime
2 from v$lock
3 where block != 0
SID Lock TypeMode Held Mode Requested Blocking? Minutes Blocked
-- --- -- -- -- ---
32 TX 6 0 1 33.83
Here is the blocker's transaction:
1 select t.xidusn,t.xidslot,t.xidsqn
2 from v$transaction t, v$session s
3 where t.addr = s.taddr and
4s.sid=32;
XIDUSNXIDSLOT XIDSQN
-- -- --
4 55 44118
Load a redo log:
1 begin
2 sys.dbms_logmnr.add_logfile
3 ('C:\ORACLE\ORADATA\DEV816\REDO02.LOG',
4sys.dbms_logmnr.new);
5 sys.dbms_logmnr.start_logmnr;
6 end;
PL/SQL procedure successfully completed.
1 select sql_redo
2 from v$logmnr_contents
3 where xidusn=4 and
4 xidslt=55 and
5 xidsqn=44118;
6 and rownum < 4;
SQL_REDO
set transaction read write;
delete from "UNKNOWN"."Objn:45095" where "Col[1]" = HEXTORAW('c24a46') and
"Col[2]" = HEXTORAW('534d
495448') and "Col[3]" = HEXTORAW('434c45524b') and "Col[4]" = HEXTORAW('c25003')
and "Col[5]" = HEXT
ORAW('77b40c11010101') and "Col[6]" = HEXTORAW('c209') and "Col[7]" IS NULL and
"Col[8]" = HEXTORAW(
'c115') and ROWID = 'AAALAnAADAAAJAzAAA';
Check the table name
1 select owner,object_name
2 from dba_objects
3* where object_id=45095
OWNER OBJECT_NAME
-- --
SCOTT EMP
Voila, the blocking statement is: DELETE FROM emp. (I limited the output, but
there are actually 14 sql_redo statmements that differ only in the value of the
rowid.) (Loading the right log file involves some trial and error.) (Remember
you saw it here first.)
Chaim
If you had SQL trace available - you would be able to find SQL for the
session. One time on this list I heard mention about x$trace - like it has
all data of the event 10046 trace only not in the trace file but in memory.
Anumbody has some infp about it?
Alex Hillman
-Original Message-
Sent: Wednesday, August 01, 2001 1:34 PM
To: Multiple recipients of list ORACLE-L
Chaim,
That could work. Logminer wasn't around when I first had this problem, and I
haven't spent time working with it.
>From what I know from listening to Joe present on it though, it would be a
more complicated process than I want. I'd have to be sure that the
dictionary map was always up to date, and I would have to go back and look
through all the archived logs as well as the online ones, in case the
statement had been archived off. It also sounds like it would be intensely
manual.
Joe -- any thoughts on this?
I want something that runs FAST, so I can clear locks quickly. And then go
on to the fun stuff of killing duhvelopers.
Rachel (today it is hot and humid here, and today the AC in the office
doesn't work killing duhvelopers is looking like more and more fun)
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Wed, 01 Aug 2001 07:51:19 -0800
>
>
>
>
>
>
>
>
>"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM
>
>Please respond to [EMAIL PROTECTED]
>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>cc:(bcc: Chaim Katz/Completions/Bombardier)
>
>
>
>
>Rachel,
>
>I don't know how to retreive the locking sql either, but reading this
>discussion
>it occurred to me that 1) in v$session (of the blocked session) we have
>the
>file#,block#,row# that is being waited on. Maybe with logminer (or
>something
>like it) we could find the most recent SQL that affected this block/row?
>
>Chaim
>
>
>
>Gary,
>
>I wish it did. I worked with Q Diagnostics for quite a while, and worked
>directly with the developer (although calling John Beresniewicz a developer
>is an understatement, he's brilliant!) on answering that problem.
>
>Neither Q nor anything from Platinum (does that tell you how lo
RE: Evaluation questions
yea its more work than you want, now with the GUI version of logminer(caled logminer viewer) it would be easier. joe >>> [EMAIL PROTECTED] 08/01/01 01:34PM >>>Chaim,That could work. Logminer wasn't around when I first had this problem, and I haven't spent time working with it.From what I know from listening to Joe present on it though, it would be a more complicated process than I want. I'd have to be sure that the dictionary map was always up to date, and I would have to go back and look through all the archived logs as well as the online ones, in case the statement had been archived off. It also sounds like it would be intensely manual.Joe -- any thoughts on this?I want something that runs FAST, so I can clear locks quickly. And then go on to the fun stuff of killing duhvelopers.Rachel (today it is hot and humid here, and today the AC in the office doesn't work killing duhvelopers is looking like more and more fun)>From: [EMAIL PROTECTED]>Reply-To: [EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>>Subject: RE: Evaluation questions>Date: Wed, 01 Aug 2001 07:51:19 -0800>>>>>>>>>"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM>>Please respond to [EMAIL PROTECTED]>>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>>cc: (bcc: Chaim Katz/Completions/Bombardier)>>>>>Rachel,>>I don't know how to retreive the locking sql either, but reading this >discussion>it occurred to me that 1) in v$session (of the blocked session) we have >the>file#,block#,row# that is being waited on. Maybe with logminer (or >something>like it) we could find the most recent SQL that affected this block/row?>>Chaim>>>>Gary,>>I wish it did. I worked with Q Diagnostics for quite a while, and worked>directly with the developer (although calling John Beresniewicz a developer>is an understatement, he's brilliant!) on answering that problem.>>Neither Q nor anything from Platinum (does that tell you how long ago it>was?) was able to find the locking sql with any precision. The answer I got>back from both of them was "if you figure out how to do it, PLEASE let us>know">>Having said that, Q Diagnostics was indeed bliss... I fixed locks before>users complained, was able to model and monitor bad SQL and fix it and had>lots of good info directly on the desktop.>>Rachel>>> >From: "Gary Weber" <[EMAIL PROTECTED]>> >Reply-To: [EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>> >Subject: RE: Evaluation questions> >Date: Tue, 31 Jul 2001 06:11:36 -0800> >> >Rachel,> >> >I believe your second wish from below (locking SQL) has been granted by> >former Savant product called Q Diagnostic Center, currently owned by> >Precise. Drill down to locks, including user and SQL info - its a bliss.> >> >Gary Weber> >Senior DBA> >Charles Jones, LLC> >609-530-1144, ext 5529> >> >-Original Message-> >Carmichael> >Sent: Tuesday, July 31, 2001 8:56 AM> >To: Multiple recipients of list ORACLE-L> >> >> >one I want is "can the package tell me when a datafile extends"> >> >also, I want (and have NEVER found) a package that can tell me the >locking> >SQL, when the locker has gone on and done other SQL after the lock.> >> >ex.> >> >user1 does:> > select * from table for update where > > update table> > insert into second table> >and does not commit> >> >user2 comes in and tries to update the first table, one of the rows that> >meets user1's where clause> >> >I can tell that user1 is blocking user2 but not the SQL that is doing the> >blocking. That's useful in beating duhvelopers about the head in order to> >get the code fixed.> >> >> >> > >From: "O'Neill, Sean" <[EMAIL PROTECTED]>> > >Reply-To: [EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>> > >Subject: Evaluation questions> > >Date: Tue, 31 Jul 2001 02:25:49 -0800> > >> > >I'm still slogging away at selection process of DB monitor tool. I'm >now> > >at> > >stage where I'm compiling a list of specific tasks I'd like to take the> > >contenders through and score them on same.> > >E.G.> > >Can package alert if Oracle DB goes down?> > >Can package alert if Control File extends?
RE: Evaluation questions
If you had SQL trace available - you would be able to find SQL for the session. One time on this list I heard mention about x$trace - like it has all data of the event 10046 trace only not in the trace file but in memory. Anumbody has some infp about it? Alex Hillman -Original Message- Sent: Wednesday, August 01, 2001 1:34 PM To: Multiple recipients of list ORACLE-L Chaim, That could work. Logminer wasn't around when I first had this problem, and I haven't spent time working with it. >From what I know from listening to Joe present on it though, it would be a more complicated process than I want. I'd have to be sure that the dictionary map was always up to date, and I would have to go back and look through all the archived logs as well as the online ones, in case the statement had been archived off. It also sounds like it would be intensely manual. Joe -- any thoughts on this? I want something that runs FAST, so I can clear locks quickly. And then go on to the fun stuff of killing duhvelopers. Rachel (today it is hot and humid here, and today the AC in the office doesn't work killing duhvelopers is looking like more and more fun) >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Evaluation questions >Date: Wed, 01 Aug 2001 07:51:19 -0800 > > > > > > > > >"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM > >Please respond to [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc:(bcc: Chaim Katz/Completions/Bombardier) > > > > >Rachel, > >I don't know how to retreive the locking sql either, but reading this >discussion >it occurred to me that 1) in v$session (of the blocked session) we have >the >file#,block#,row# that is being waited on. Maybe with logminer (or >something >like it) we could find the most recent SQL that affected this block/row? > >Chaim > > > >Gary, > >I wish it did. I worked with Q Diagnostics for quite a while, and worked >directly with the developer (although calling John Beresniewicz a developer >is an understatement, he's brilliant!) on answering that problem. > >Neither Q nor anything from Platinum (does that tell you how long ago it >was?) was able to find the locking sql with any precision. The answer I got >back from both of them was "if you figure out how to do it, PLEASE let us >know" > >Having said that, Q Diagnostics was indeed bliss... I fixed locks before >users complained, was able to model and monitor bad SQL and fix it and had >lots of good info directly on the desktop. > >Rachel > > > >From: "Gary Weber" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: Evaluation questions > >Date: Tue, 31 Jul 2001 06:11:36 -0800 > > > >Rachel, > > > >I believe your second wish from below (locking SQL) has been granted by > >former Savant product called Q Diagnostic Center, currently owned by > >Precise. Drill down to locks, including user and SQL info - its a bliss. > > > >Gary Weber > >Senior DBA > >Charles Jones, LLC > >609-530-1144, ext 5529 > > > >-Original Message- > >Carmichael > >Sent: Tuesday, July 31, 2001 8:56 AM > >To: Multiple recipients of list ORACLE-L > > > > > >one I want is "can the package tell me when a datafile extends" > > > >also, I want (and have NEVER found) a package that can tell me the >locking > >SQL, when the locker has gone on and done other SQL after the lock. > > > >ex. > > > >user1 does: > > select * from table for update where > > update table > > insert into second table > >and does not commit > > > >user2 comes in and tries to update the first table, one of the rows that > >meets user1's where clause > > > >I can tell that user1 is blocking user2 but not the SQL that is doing the > >blocking. That's useful in beating duhvelopers about the head in order to > >get the code fixed. > > > > > > > > >From: "O'Neill, Sean" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Evaluation questions > > >Date: Tue, 31 Jul 2001 02:25:49 -0800 > > > > > >I'm still slogging away at selection process of DB monitor tool. I'm >now > > >at > > >s
RE: Evaluation questions
Chaim, That could work. Logminer wasn't around when I first had this problem, and I haven't spent time working with it. >From what I know from listening to Joe present on it though, it would be a more complicated process than I want. I'd have to be sure that the dictionary map was always up to date, and I would have to go back and look through all the archived logs as well as the online ones, in case the statement had been archived off. It also sounds like it would be intensely manual. Joe -- any thoughts on this? I want something that runs FAST, so I can clear locks quickly. And then go on to the fun stuff of killing duhvelopers. Rachel (today it is hot and humid here, and today the AC in the office doesn't work killing duhvelopers is looking like more and more fun) >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Evaluation questions >Date: Wed, 01 Aug 2001 07:51:19 -0800 > > > > > > > > >"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM > >Please respond to [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc:(bcc: Chaim Katz/Completions/Bombardier) > > > > >Rachel, > >I don't know how to retreive the locking sql either, but reading this >discussion >it occurred to me that 1) in v$session (of the blocked session) we have >the >file#,block#,row# that is being waited on. Maybe with logminer (or >something >like it) we could find the most recent SQL that affected this block/row? > >Chaim > > > >Gary, > >I wish it did. I worked with Q Diagnostics for quite a while, and worked >directly with the developer (although calling John Beresniewicz a developer >is an understatement, he's brilliant!) on answering that problem. > >Neither Q nor anything from Platinum (does that tell you how long ago it >was?) was able to find the locking sql with any precision. The answer I got >back from both of them was "if you figure out how to do it, PLEASE let us >know" > >Having said that, Q Diagnostics was indeed bliss... I fixed locks before >users complained, was able to model and monitor bad SQL and fix it and had >lots of good info directly on the desktop. > >Rachel > > > >From: "Gary Weber" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: Evaluation questions > >Date: Tue, 31 Jul 2001 06:11:36 -0800 > > > >Rachel, > > > >I believe your second wish from below (locking SQL) has been granted by > >former Savant product called Q Diagnostic Center, currently owned by > >Precise. Drill down to locks, including user and SQL info - its a bliss. > > > >Gary Weber > >Senior DBA > >Charles Jones, LLC > >609-530-1144, ext 5529 > > > >-Original Message- > >Carmichael > >Sent: Tuesday, July 31, 2001 8:56 AM > >To: Multiple recipients of list ORACLE-L > > > > > >one I want is "can the package tell me when a datafile extends" > > > >also, I want (and have NEVER found) a package that can tell me the >locking > >SQL, when the locker has gone on and done other SQL after the lock. > > > >ex. > > > >user1 does: > > select * from table for update where > > update table > > insert into second table > >and does not commit > > > >user2 comes in and tries to update the first table, one of the rows that > >meets user1's where clause > > > >I can tell that user1 is blocking user2 but not the SQL that is doing the > >blocking. That's useful in beating duhvelopers about the head in order to > >get the code fixed. > > > > > > > > >From: "O'Neill, Sean" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Evaluation questions > > >Date: Tue, 31 Jul 2001 02:25:49 -0800 > > > > > >I'm still slogging away at selection process of DB monitor tool. I'm >now > > >at > > >stage where I'm compiling a list of specific tasks I'd like to take the > > >contenders through and score them on same. > > >E.G. > > >Can package alert if Oracle DB goes down? > > >Can package alert if Control File extends? > > > > > >I'd appreciate your feedback on what you think the monitor package >should
RE: Evaluation questions
Mark,
mark,
Yep, it ain't a walk in the park... as I said. I've been thinking/working on
this for a number of years, haven't found a solution yet.
The problem with taking so many snapshots is that I am afraid that they will
affect performance.
I don't do easy questions... those I answer myself :) Just ask the
instructor of the first Oracle database administration course I ever took
(she and I are still friends, running a "mutual admiration society" these
days). I took the class after working as a DBA for 6 months. And reading
and re-reading the manuals. I didn't ask easy questions then either.
Rachel
>From: "Mark Leith" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Wed, 01 Aug 2001 07:10:27 -0800
>
>Rachel,
>
>This is indeed harder than one would expect.
>
>It is simple in the case of userA still working on the locking transaction,
>which I've put together a script for:
>
>select u.name Owner,
>o.name Object,
>l.sid SID,
>s.username Username,
>t.sql_text SQL,
>l.type Type,
>lmode,
>decode(lmode, 1, 'NULL', 2, 'Row Share', 3, 'Row Exclusive', 4,
>'Share', 5, 'Share Row', 6, 'Exclusive') mode_desc,
>request,
>decode(request, 1, 'NULL', 2, 'Row Share', 3, 'Row Exclusive', 4,
>'Share', 5, 'Share Row', 6, 'Exclusive') request_desc
> from v$lock l,
>v$session s,
>sys.obj$ o,
>sys.user$ u,
>v$sqltext t
> where l.type in ('RW', 'TM', 'TX', 'UL')
>and l.sid = s.sid (+)
>and l.id1 = o.obj# (+)
>and o.owner# = u.user# (+)
>and s.sql_hash_value = t.hash_value
> order by lmode
>
>The problem lies in when they move on to another transaction without a
>commit - and personally if this is the case then I should think the
>developers deserve a DAMNED good slap around the head - as it makes it
>extremely difficult to track the offending SQL. There *seems* to be no way
>of actually doing this from within the v$ tables either..(That humble old
>me
>knows of anyway:)
>
>If however you have a snapshot of all of the relevant tables (v$lock,
>v$session, v$sqltext) at the specific time the lock was placed, then it's
>as
>simple as above. All you would have to do is trace back to the time the
>lock
>was placed, and match the sid to the one in v$session, and then further on
>down joining on sql_hash_value & hash_value as above, based on a time
>stamp.
>
>This is of course possible with our tool - but it means setting up a
>repository of 3 collections, and you would probably want to fire them off
>every 1-2 minutes (maybe higher) to guarantee collecting the data. You then
>pull the data in to a reporting tool (excel for instance) to analyse the
>data.
>
>This is a first pass attempt - I'm going to come back to it in a couple of
>days to see what else I can find out / do. In the meantime does anybody
>else
>have anything to add to this discussion - I think it would be a great help
>to a lot of people if we can come up with a workable solution for this!
>
>Cheers
>
>Mark
>
>-Original Message-
>Carmichael
>Sent: Tuesday, July 31, 2001 04:48
>To: Multiple recipients of list ORACLE-L
>
>
>Gary,
>
>I wish it did. I worked with Q Diagnostics for quite a while, and worked
>directly with the developer (although calling John Beresniewicz a developer
>is an understatement, he's brilliant!) on answering that problem.
>
>Neither Q nor anything from Platinum (does that tell you how long ago it
>was?) was able to find the locking sql with any precision. The answer I got
>back from both of them was "if you figure out how to do it, PLEASE let us
>know"
>
>Having said that, Q Diagnostics was indeed bliss... I fixed locks before
>users complained, was able to model and monitor bad SQL and fix it and had
>lots of good info directly on the desktop.
>
>Rachel
>
>
> >From: "Gary Weber" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Evaluation questions
> >Date: Tue, 31 Jul 2001 06:11:36 -0800
> >
> >Rachel,
> >
> >I believe your second wish from below (locking SQL) has been granted by
> >former Savant product called Q Diagnostic Center, currently owned by
> >Precise. Drill down to locks, including us
RE: Evaluation questions
"Rachel Carmichael" <[EMAIL PROTECTED]> on 07/31/2001 11:48:02 AM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Chaim Katz/Completions/Bombardier) Rachel, I don't know how to retreive the locking sql either, but reading this discussion it occurred to me that 1) in v$session (of the blocked session) we have the file#,block#,row# that is being waited on. Maybe with logminer (or something like it) we could find the most recent SQL that affected this block/row? Chaim Gary, I wish it did. I worked with Q Diagnostics for quite a while, and worked directly with the developer (although calling John Beresniewicz a developer is an understatement, he's brilliant!) on answering that problem. Neither Q nor anything from Platinum (does that tell you how long ago it was?) was able to find the locking sql with any precision. The answer I got back from both of them was "if you figure out how to do it, PLEASE let us know" Having said that, Q Diagnostics was indeed bliss... I fixed locks before users complained, was able to model and monitor bad SQL and fix it and had lots of good info directly on the desktop. Rachel >From: "Gary Weber" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Evaluation questions >Date: Tue, 31 Jul 2001 06:11:36 -0800 > >Rachel, > >I believe your second wish from below (locking SQL) has been granted by >former Savant product called Q Diagnostic Center, currently owned by >Precise. Drill down to locks, including user and SQL info - its a bliss. > >Gary Weber >Senior DBA >Charles Jones, LLC >609-530-1144, ext 5529 > >-Original Message- >Carmichael >Sent: Tuesday, July 31, 2001 8:56 AM >To: Multiple recipients of list ORACLE-L > > >one I want is "can the package tell me when a datafile extends" > >also, I want (and have NEVER found) a package that can tell me the locking >SQL, when the locker has gone on and done other SQL after the lock. > >ex. > >user1 does: > select * from table for update where > update table > insert into second table >and does not commit > >user2 comes in and tries to update the first table, one of the rows that >meets user1's where clause > >I can tell that user1 is blocking user2 but not the SQL that is doing the >blocking. That's useful in beating duhvelopers about the head in order to >get the code fixed. > > > > >From: "O'Neill, Sean" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Evaluation questions > >Date: Tue, 31 Jul 2001 02:25:49 -0800 > > > >I'm still slogging away at selection process of DB monitor tool. I'm now > >at > >stage where I'm compiling a list of specific tasks I'd like to take the > >contenders through and score them on same. > >E.G. > >Can package alert if Oracle DB goes down? > >Can package alert if Control File extends? > > > >I'd appreciate your feedback on what you think the monitor package should > >be > >able to do, ya know those things you want to know about before anyone >else > >does!. I'm particularly fishing for events that might be a bit more > >obscure > >yet still useful to monitor. > > > > > >Sean :) > > > >Rookie Data Base Administrator > >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K > >[0%] OCP Oracle8i DBA > >[0%] OCP Oracle9i DBA > > > >Organon (Ireland) Ltd. > >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > > > >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > > > >"Nobody loves me but my mother... and she could be jivin' too." - BB >King > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: O'Neill, Sean > > INET: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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 s
RE: Evaluation questions
Rachel,
This is indeed harder than one would expect.
It is simple in the case of userA still working on the locking transaction,
which I've put together a script for:
select u.name Owner,
o.name Object,
l.sid SID,
s.username Username,
t.sql_text SQL,
l.type Type,
lmode,
decode(lmode, 1, 'NULL', 2, 'Row Share', 3, 'Row Exclusive', 4,
'Share', 5, 'Share Row', 6, 'Exclusive') mode_desc,
request,
decode(request, 1, 'NULL', 2, 'Row Share', 3, 'Row Exclusive', 4,
'Share', 5, 'Share Row', 6, 'Exclusive') request_desc
from v$lock l,
v$session s,
sys.obj$ o,
sys.user$ u,
v$sqltext t
where l.type in ('RW', 'TM', 'TX', 'UL')
and l.sid = s.sid (+)
and l.id1 = o.obj# (+)
and o.owner# = u.user# (+)
and s.sql_hash_value = t.hash_value
order by lmode
The problem lies in when they move on to another transaction without a
commit - and personally if this is the case then I should think the
developers deserve a DAMNED good slap around the head - as it makes it
extremely difficult to track the offending SQL. There *seems* to be no way
of actually doing this from within the v$ tables either..(That humble old me
knows of anyway:)
If however you have a snapshot of all of the relevant tables (v$lock,
v$session, v$sqltext) at the specific time the lock was placed, then it's as
simple as above. All you would have to do is trace back to the time the lock
was placed, and match the sid to the one in v$session, and then further on
down joining on sql_hash_value & hash_value as above, based on a time stamp.
This is of course possible with our tool - but it means setting up a
repository of 3 collections, and you would probably want to fire them off
every 1-2 minutes (maybe higher) to guarantee collecting the data. You then
pull the data in to a reporting tool (excel for instance) to analyse the
data.
This is a first pass attempt - I'm going to come back to it in a couple of
days to see what else I can find out / do. In the meantime does anybody else
have anything to add to this discussion - I think it would be a great help
to a lot of people if we can come up with a workable solution for this!
Cheers
Mark
-Original Message-
Carmichael
Sent: Tuesday, July 31, 2001 04:48
To: Multiple recipients of list ORACLE-L
Gary,
I wish it did. I worked with Q Diagnostics for quite a while, and worked
directly with the developer (although calling John Beresniewicz a developer
is an understatement, he's brilliant!) on answering that problem.
Neither Q nor anything from Platinum (does that tell you how long ago it
was?) was able to find the locking sql with any precision. The answer I got
back from both of them was "if you figure out how to do it, PLEASE let us
know"
Having said that, Q Diagnostics was indeed bliss... I fixed locks before
users complained, was able to model and monitor bad SQL and fix it and had
lots of good info directly on the desktop.
Rachel
>From: "Gary Weber" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Evaluation questions
>Date: Tue, 31 Jul 2001 06:11:36 -0800
>
>Rachel,
>
>I believe your second wish from below (locking SQL) has been granted by
>former Savant product called Q Diagnostic Center, currently owned by
>Precise. Drill down to locks, including user and SQL info - its a bliss.
>
>Gary Weber
>Senior DBA
>Charles Jones, LLC
>609-530-1144, ext 5529
>
>-Original Message-
>Carmichael
>Sent: Tuesday, July 31, 2001 8:56 AM
>To: Multiple recipients of list ORACLE-L
>
>
>one I want is "can the package tell me when a datafile extends"
>
>also, I want (and have NEVER found) a package that can tell me the locking
>SQL, when the locker has gone on and done other SQL after the lock.
>
>ex.
>
>user1 does:
> select * from table for update where
> update table
> insert into second table
>and does not commit
>
>user2 comes in and tries to update the first table, one of the rows that
>meets user1's where clause
>
>I can tell that user1 is blocking user2 but not the SQL that is doing the
>blocking. That's useful in beating duhvelopers about the head in order to
>get the code fixed.
>
>
>
> >From: "O'Neill, Sean" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Evaluation questions
> >Date: Tue, 31 Jul 2001 02:25:49 -0800
> >
> >I'm still slogging away at selection process of DB monit
Re: Evaluation questions
NOW you tell me 2 jobs later! >From: Scott Shafer <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Evaluation questions >Date: Tue, 31 Jul 2001 12:12:04 -0800 > >Rachel, > >Your problem was you bought that bootleg, domestic "fairy" slop. The >good stuff is the primo, imported "faerie" dust with the red hairs in >it... > >--S > > >Rachel Carmichael wrote: > > > > Applications like that need to have the duhveloper spayed/neutered (they > > should not be allowed to breed!) and then the app should be rewritten. > > > > I lost that particular fight at one job (in any disagreement between me >and > > the programmers, the boss sided with them). Then they DIED on their >busiest > > day of the year. > > > > And blamed me. Apparently I should have been able to stop this from > > happening (locking and rollback segments filled to capacity of the > > tablespace) by magic. I KNEW I should have brought the fairy dust that >day. > > > > Rachel > > > > >From: "Ron Rogers" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: RE: Evaluation questions > > >Date: Tue, 31 Jul 2001 10:47:28 -0800 > > > > > >Also, please keep in mind that some applications will "select for > > >update..." and lock a row until the commit is issued. That could take a > > >long time if the user is busy with daily office activities. > > >ROR mª¿ªm > > > > >_ >Do You Yahoo!? >Get your free @yahoo.com address at http://mail.yahoo.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Scott Shafer > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Evaluation questions
Rachel, Your problem was you bought that bootleg, domestic "fairy" slop. The good stuff is the primo, imported "faerie" dust with the red hairs in it... --S Rachel Carmichael wrote: > > Applications like that need to have the duhveloper spayed/neutered (they > should not be allowed to breed!) and then the app should be rewritten. > > I lost that particular fight at one job (in any disagreement between me and > the programmers, the boss sided with them). Then they DIED on their busiest > day of the year. > > And blamed me. Apparently I should have been able to stop this from > happening (locking and rollback segments filled to capacity of the > tablespace) by magic. I KNEW I should have brought the fairy dust that day. > > Rachel > > >From: "Ron Rogers" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: Evaluation questions > >Date: Tue, 31 Jul 2001 10:47:28 -0800 > > > >Also, please keep in mind that some applications will "select for > >update..." and lock a row until the commit is issued. That could take a > >long time if the user is busy with daily office activities. > >ROR mª¿ªm > > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Evaluation questions
Applications like that need to have the duhveloper spayed/neutered (they should not be allowed to breed!) and then the app should be rewritten. I lost that particular fight at one job (in any disagreement between me and the programmers, the boss sided with them). Then they DIED on their busiest day of the year. And blamed me. Apparently I should have been able to stop this from happening (locking and rollback segments filled to capacity of the tablespace) by magic. I KNEW I should have brought the fairy dust that day. Rachel >From: "Ron Rogers" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Evaluation questions >Date: Tue, 31 Jul 2001 10:47:28 -0800 > >Also, please keep in mind that some applications will "select for >update..." and lock a row until the commit is issued. That could take a >long time if the user is busy with daily office activities. >ROR mª¿ªm > > >>> [EMAIL PROTECTED] 07/31/01 12:21PM >>> >Mark, > >Transactions should not typically last more than 15-20 minutes. But I want >a >warning that there is a lock, not a kill, as it is possible that a >non-typical transaction would last longer. As an example, I'm thinking of >taking phone orders and entering them into a system (catalog sales). >Typical >orders might be small, but holiday time might take longer -- that's why I >want it configurable. > >I don't have sql that does it, that's the problem. And I have no idea how >often to surf through the v$ tables, again a problem. Also, if you have >cursor_sharing on, how does that affect it all? > >Sigh... but it's fun to try to solve on a boring day. > >Rachel > > > >From: "Mark Leith" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: Evaluation questions > >Date: Tue, 31 Jul 2001 06:55:30 -0800 > > > >Rachel, > > > >You are right, I have not seen a tool that does this as standard either, > >though I think there could be a way of doing this with our particular > >product, that I will look in to - but I have a couple of questions: > > > >In a real world situation - what would the timeframe be for a user to > >update > >a table, then move on to another transaction? If we were to monitor >blocked > >sessions, and want to catch the SQL they are currently executing by >firing > >a > >select from v$SQLAREA/V$SQLTEXT action, and inserting a row to a temp > >table, > >how often should the monitoring collection refresh to guarantee >collecting > >that statement? > > > >Is there any SQL that you have currently which can give you this > >information, without going this round about way? > > > >Cheers > > > >Mark > > > >-Original Message- > >Carmichael > >Sent: Tuesday, July 31, 2001 01:56 > >To: Multiple recipients of list ORACLE-L > > > > > >one I want is "can the package tell me when a datafile extends" > > > >also, I want (and have NEVER found) a package that can tell me the >locking > >SQL, when the locker has gone on and done other SQL after the lock. > > > >ex. > > > >user1 does: > > select * from table for update where > > update table > > insert into second table > >and does not commit > > > >user2 comes in and tries to update the first table, one of the rows that > >meets user1's where clause > > > >I can tell that user1 is blocking user2 but not the SQL that is doing the > >blocking. That's useful in beating duhvelopers about the head in order to > >get the code fixed. > > > > > > > > >From: "O'Neill, Sean" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Evaluation questions > > >Date: Tue, 31 Jul 2001 02:25:49 -0800 > > > > > >I'm still slogging away at selection process of DB monitor tool. I'm >now > > >at > > >stage where I'm compiling a list of specific tasks I'd like to take the > > >contenders through and score them on same. > > >E.G. > > >Can package alert if Oracle DB goes down? > > >Can package alert if Control File extends? > > > > > >I'd appreciate your feedback on what you think the monitor package >should > > >be > > >able to do, ya kno
Re: Evaluation questions
Rachel Carmichael wrote: > > And blamed me. Apparently I should have been able to stop this from > happening (locking and rollback segments filled to capacity of the > tablespace) by magic. I KNEW I should have brought the fairy dust that day. > > Rachel either that, or dusted the fairy.;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Evaluation questions
Also, please keep in mind that some applications will "select for update..." and lock a row until the commit is issued. That could take a long time if the user is busy with daily office activities. ROR mª¿ªm >>> [EMAIL PROTECTED] 07/31/01 12:21PM >>> Mark, Transactions should not typically last more than 15-20 minutes. But I want a warning that there is a lock, not a kill, as it is possible that a non-typical transaction would last longer. As an example, I'm thinking of taking phone orders and entering them into a system (catalog sales). Typical orders might be small, but holiday time might take longer -- that's why I want it configurable. I don't have sql that does it, that's the problem. And I have no idea how often to surf through the v$ tables, again a problem. Also, if you have cursor_sharing on, how does that affect it all? Sigh... but it's fun to try to solve on a boring day. Rachel >From: "Mark Leith" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Evaluation questions >Date: Tue, 31 Jul 2001 06:55:30 -0800 > >Rachel, > >You are right, I have not seen a tool that does this as standard either, >though I think there could be a way of doing this with our particular >product, that I will look in to - but I have a couple of questions: > >In a real world situation - what would the timeframe be for a user to >update >a table, then move on to another transaction? If we were to monitor blocked >sessions, and want to catch the SQL they are currently executing by firing >a >select from v$SQLAREA/V$SQLTEXT action, and inserting a row to a temp >table, >how often should the monitoring collection refresh to guarantee collecting >that statement? > >Is there any SQL that you have currently which can give you this >information, without going this round about way? > >Cheers > >Mark > >-Original Message- >Carmichael >Sent: Tuesday, July 31, 2001 01:56 >To: Multiple recipients of list ORACLE-L > > >one I want is "can the package tell me when a datafile extends" > >also, I want (and have NEVER found) a package that can tell me the locking >SQL, when the locker has gone on and done other SQL after the lock. > >ex. > >user1 does: > select * from table for update where > update table > insert into second table >and does not commit > >user2 comes in and tries to update the first table, one of the rows that >meets user1's where clause > >I can tell that user1 is blocking user2 but not the SQL that is doing the >blocking. That's useful in beating duhvelopers about the head in order to >get the code fixed. > > > > >From: "O'Neill, Sean" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Evaluation questions > >Date: Tue, 31 Jul 2001 02:25:49 -0800 > > > >I'm still slogging away at selection process of DB monitor tool. I'm now > >at > >stage where I'm compiling a list of specific tasks I'd like to take the > >contenders through and score them on same. > >E.G. > >Can package alert if Oracle DB goes down? > >Can package alert if Control File extends? > > > >I'd appreciate your feedback on what you think the monitor package should > >be > >able to do, ya know those things you want to know about before anyone >else > >does!. I'm particularly fishing for events that might be a bit more > >obscure > >yet still useful to monitor. > > > > > >Sean :) > > > >Rookie Data Base Administrator > >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K > >[0%] OCP Oracle8i DBA > >[0%] OCP Oracle9i DBA > > > >Organon (Ireland) Ltd. > >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > > > >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > > > >"Nobody loves me but my mother... and she could be jivin' too." - BB >King > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: O'Neill, Sean > > INET: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (note EXACT spelling
RE: Evaluation questions
Gary, I wish it did. I worked with Q Diagnostics for quite a while, and worked directly with the developer (although calling John Beresniewicz a developer is an understatement, he's brilliant!) on answering that problem. Neither Q nor anything from Platinum (does that tell you how long ago it was?) was able to find the locking sql with any precision. The answer I got back from both of them was "if you figure out how to do it, PLEASE let us know" Having said that, Q Diagnostics was indeed bliss... I fixed locks before users complained, was able to model and monitor bad SQL and fix it and had lots of good info directly on the desktop. Rachel >From: "Gary Weber" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Evaluation questions >Date: Tue, 31 Jul 2001 06:11:36 -0800 > >Rachel, > >I believe your second wish from below (locking SQL) has been granted by >former Savant product called Q Diagnostic Center, currently owned by >Precise. Drill down to locks, including user and SQL info - its a bliss. > >Gary Weber >Senior DBA >Charles Jones, LLC >609-530-1144, ext 5529 > >-Original Message- >Carmichael >Sent: Tuesday, July 31, 2001 8:56 AM >To: Multiple recipients of list ORACLE-L > > >one I want is "can the package tell me when a datafile extends" > >also, I want (and have NEVER found) a package that can tell me the locking >SQL, when the locker has gone on and done other SQL after the lock. > >ex. > >user1 does: > select * from table for update where > update table > insert into second table >and does not commit > >user2 comes in and tries to update the first table, one of the rows that >meets user1's where clause > >I can tell that user1 is blocking user2 but not the SQL that is doing the >blocking. That's useful in beating duhvelopers about the head in order to >get the code fixed. > > > > >From: "O'Neill, Sean" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Evaluation questions > >Date: Tue, 31 Jul 2001 02:25:49 -0800 > > > >I'm still slogging away at selection process of DB monitor tool. I'm now > >at > >stage where I'm compiling a list of specific tasks I'd like to take the > >contenders through and score them on same. > >E.G. > >Can package alert if Oracle DB goes down? > >Can package alert if Control File extends? > > > >I'd appreciate your feedback on what you think the monitor package should > >be > >able to do, ya know those things you want to know about before anyone >else > >does!. I'm particularly fishing for events that might be a bit more > >obscure > >yet still useful to monitor. > > > > > >Sean :) > > > >Rookie Data Base Administrator > >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K > >[0%] OCP Oracle8i DBA > >[0%] OCP Oracle9i DBA > > > >Organon (Ireland) Ltd. > >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > > > >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > > > >"Nobody loves me but my mother... and she could be jivin' too." - BB >King > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: O'Neill, Sean > > INET: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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). > > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists >
RE: Evaluation questions
Mark, Transactions should not typically last more than 15-20 minutes. But I want a warning that there is a lock, not a kill, as it is possible that a non-typical transaction would last longer. As an example, I'm thinking of taking phone orders and entering them into a system (catalog sales). Typical orders might be small, but holiday time might take longer -- that's why I want it configurable. I don't have sql that does it, that's the problem. And I have no idea how often to surf through the v$ tables, again a problem. Also, if you have cursor_sharing on, how does that affect it all? Sigh... but it's fun to try to solve on a boring day. Rachel >From: "Mark Leith" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Evaluation questions >Date: Tue, 31 Jul 2001 06:55:30 -0800 > >Rachel, > >You are right, I have not seen a tool that does this as standard either, >though I think there could be a way of doing this with our particular >product, that I will look in to - but I have a couple of questions: > >In a real world situation - what would the timeframe be for a user to >update >a table, then move on to another transaction? If we were to monitor blocked >sessions, and want to catch the SQL they are currently executing by firing >a >select from v$SQLAREA/V$SQLTEXT action, and inserting a row to a temp >table, >how often should the monitoring collection refresh to guarantee collecting >that statement? > >Is there any SQL that you have currently which can give you this >information, without going this round about way? > >Cheers > >Mark > >-Original Message- >Carmichael >Sent: Tuesday, July 31, 2001 01:56 >To: Multiple recipients of list ORACLE-L > > >one I want is "can the package tell me when a datafile extends" > >also, I want (and have NEVER found) a package that can tell me the locking >SQL, when the locker has gone on and done other SQL after the lock. > >ex. > >user1 does: > select * from table for update where > update table > insert into second table >and does not commit > >user2 comes in and tries to update the first table, one of the rows that >meets user1's where clause > >I can tell that user1 is blocking user2 but not the SQL that is doing the >blocking. That's useful in beating duhvelopers about the head in order to >get the code fixed. > > > > >From: "O'Neill, Sean" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Evaluation questions > >Date: Tue, 31 Jul 2001 02:25:49 -0800 > > > >I'm still slogging away at selection process of DB monitor tool. I'm now > >at > >stage where I'm compiling a list of specific tasks I'd like to take the > >contenders through and score them on same. > >E.G. > >Can package alert if Oracle DB goes down? > >Can package alert if Control File extends? > > > >I'd appreciate your feedback on what you think the monitor package should > >be > >able to do, ya know those things you want to know about before anyone >else > >does!. I'm particularly fishing for events that might be a bit more > >obscure > >yet still useful to monitor. > > > > > >Sean :) > > > >Rookie Data Base Administrator > >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K > >[0%] OCP Oracle8i DBA > >[0%] OCP Oracle9i DBA > > > >Organon (Ireland) Ltd. > >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > > > >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > > > >"Nobody loves me but my mother... and she could be jivin' too." - BB >King > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: O'Neill, Sean > > INET: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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). > > >_
RE: Evaluation questions
Rachel, You are right, I have not seen a tool that does this as standard either, though I think there could be a way of doing this with our particular product, that I will look in to - but I have a couple of questions: In a real world situation - what would the timeframe be for a user to update a table, then move on to another transaction? If we were to monitor blocked sessions, and want to catch the SQL they are currently executing by firing a select from v$SQLAREA/V$SQLTEXT action, and inserting a row to a temp table, how often should the monitoring collection refresh to guarantee collecting that statement? Is there any SQL that you have currently which can give you this information, without going this round about way? Cheers Mark -Original Message- Carmichael Sent: Tuesday, July 31, 2001 01:56 To: Multiple recipients of list ORACLE-L one I want is "can the package tell me when a datafile extends" also, I want (and have NEVER found) a package that can tell me the locking SQL, when the locker has gone on and done other SQL after the lock. ex. user1 does: select * from table for update where update table insert into second table and does not commit user2 comes in and tries to update the first table, one of the rows that meets user1's where clause I can tell that user1 is blocking user2 but not the SQL that is doing the blocking. That's useful in beating duhvelopers about the head in order to get the code fixed. >From: "O'Neill, Sean" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Evaluation questions >Date: Tue, 31 Jul 2001 02:25:49 -0800 > >I'm still slogging away at selection process of DB monitor tool. I'm now >at >stage where I'm compiling a list of specific tasks I'd like to take the >contenders through and score them on same. >E.G. >Can package alert if Oracle DB goes down? >Can package alert if Control File extends? > >I'd appreciate your feedback on what you think the monitor package should >be >able to do, ya know those things you want to know about before anyone else >does!. I'm particularly fishing for events that might be a bit more >obscure >yet still useful to monitor. > > >Sean :) > >Rookie Data Base Administrator >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K >[0%] OCP Oracle8i DBA >[0%] OCP Oracle9i DBA > >Organon (Ireland) Ltd. >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > >"Nobody loves me but my mother... and she could be jivin' too." - BB King > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: O'Neill, Sean > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Evaluation questions
Rachel, I believe your second wish from below (locking SQL) has been granted by former Savant product called Q Diagnostic Center, currently owned by Precise. Drill down to locks, including user and SQL info - its a bliss. Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Carmichael Sent: Tuesday, July 31, 2001 8:56 AM To: Multiple recipients of list ORACLE-L one I want is "can the package tell me when a datafile extends" also, I want (and have NEVER found) a package that can tell me the locking SQL, when the locker has gone on and done other SQL after the lock. ex. user1 does: select * from table for update where update table insert into second table and does not commit user2 comes in and tries to update the first table, one of the rows that meets user1's where clause I can tell that user1 is blocking user2 but not the SQL that is doing the blocking. That's useful in beating duhvelopers about the head in order to get the code fixed. >From: "O'Neill, Sean" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Evaluation questions >Date: Tue, 31 Jul 2001 02:25:49 -0800 > >I'm still slogging away at selection process of DB monitor tool. I'm now >at >stage where I'm compiling a list of specific tasks I'd like to take the >contenders through and score them on same. >E.G. >Can package alert if Oracle DB goes down? >Can package alert if Control File extends? > >I'd appreciate your feedback on what you think the monitor package should >be >able to do, ya know those things you want to know about before anyone else >does!. I'm particularly fishing for events that might be a bit more >obscure >yet still useful to monitor. > > >Sean :) > >Rookie Data Base Administrator >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K >[0%] OCP Oracle8i DBA >[0%] OCP Oracle9i DBA > >Organon (Ireland) Ltd. >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > >"Nobody loves me but my mother... and she could be jivin' too." - BB King > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: O'Neill, Sean > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Evaluation questions
one I want is "can the package tell me when a datafile extends" also, I want (and have NEVER found) a package that can tell me the locking SQL, when the locker has gone on and done other SQL after the lock. ex. user1 does: select * from table for update where update table insert into second table and does not commit user2 comes in and tries to update the first table, one of the rows that meets user1's where clause I can tell that user1 is blocking user2 but not the SQL that is doing the blocking. That's useful in beating duhvelopers about the head in order to get the code fixed. >From: "O'Neill, Sean" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Evaluation questions >Date: Tue, 31 Jul 2001 02:25:49 -0800 > >I'm still slogging away at selection process of DB monitor tool. I'm now >at >stage where I'm compiling a list of specific tasks I'd like to take the >contenders through and score them on same. >E.G. >Can package alert if Oracle DB goes down? >Can package alert if Control File extends? > >I'd appreciate your feedback on what you think the monitor package should >be >able to do, ya know those things you want to know about before anyone else >does!. I'm particularly fishing for events that might be a bit more >obscure >yet still useful to monitor. > > >Sean :) > >Rookie Data Base Administrator >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K >[0%] OCP Oracle8i DBA >[0%] OCP Oracle9i DBA > >Organon (Ireland) Ltd. >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > >"Nobody loves me but my mother... and she could be jivin' too." - BB King > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: O'Neill, Sean > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
