Monday, June 26, 2006

Why do people email...

Why… Why do people email (unsolicited) really big things to people they do not know? I frequently get screen shots – of character mode sqlplus sessions. Yeah, that’s the ticket – let’s email a 5mb screen shot of our character mode sqlplus session. I get code (really long pieces of code). I get executables. I get dmp files. I get trace files. Alert logs. You name it. Compression – what is that? Cut and paste of simple text – what is that?

Today – a 1.8mb statspack report. The text of the email said “Maybe not the right way to approach for help. But please excuse. … Really sorry for the long post”. They know they are doing something outside the normal bounds of netiquette, but do it anyway. To top it off – the statspack was inline, not an attachment. Not even a chance it wouldn’t be downloaded.

Never mind that it might slam me big time on the road. Heck, when I was using a satellite connection – that simple email would have been more than 5% of my quota for the day!

To top it off – the statspack report was for 15 minutes (that is good), but unfortunately, it was 15 minutes when no one was logged on, when no activity was taking place in the database. Yes – transactions per second? 0.00. Executes per second? 0.47 (meaning, every two or three seconds on average, a statement was executed). User calls per second? 0.03 – 0.03! Each node reports – 1 CPU second used (total of 3 CPU seconds). The only SQL in the report? Yep – the SQL executed by the statspack snaps.

I have no idea why anyone would send such an email. None.

Guess it is sort of like a person at a party that meets a doctor and proceeds to take off a shoe to show them a foot problem and ask for advice.
POST A COMMENT

20 Comments:

Blogger Niall said....

Well doctors at least have the response

"Ah I see, now if you'd undress please" :) I'm sure there must be an IT equivalent.

Mon Jun 26, 01:37:00 PM EDT  

Blogger Bill S. said....

niall said....
said...

Well doctors at least have the response

"Ah I see, now if you'd undress please" :) I'm sure there must be an IT equivalent.


Yup - shake your head and say, "So, what did support have to say? You HAVE contacted support on this, haven't YOU?".

Then smile.

Mon Jun 26, 02:11:00 PM EDT  

Anonymous Mark from NY said....

"Today – a 1.8mb statspack report."

Is there any way to truncate the message text from your mail client, if the message exceeds x bytes? Imagine if someone copies/pastes his alert log (which is never trimmed, of course). :)

Mon Jun 26, 02:26:00 PM EDT  

Anonymous Patty C. said....

Wow - Its almost like *DBA Spam* isn't it?

Mon Jun 26, 02:52:00 PM EDT  

Blogger Howard J. Rogers said....

Ironies will never cease.

"Isn't the Internet wonderful' one day. And 'Aren't its users dumb' the next.

OK, I am taking deliberate liberties, and I know ahead of time that email<>Internet.

But I liked the juxtaposition anyway!

Face it Tom: most people are rude, thoughtless, lazy and daft as hatters. That bit of Ethernet cable "In Which We Trust" (Oh, alright, those wireless thingies too!) just lets 'em right on in!

I'm glad its not just me that gets the thoughtless DBA spam, though!

Mon Jun 26, 04:54:00 PM EDT  

Blogger Thomas Kyte said....

Howard - I so knew you would say that :)

I was waiting for it!

Mon Jun 26, 07:11:00 PM EDT  

Blogger Robert said....

So do you responde at all to dumb things like those ? what is your "typical" response ?

Mon Jun 26, 09:42:00 PM EDT  

Anonymous dan said....

For a while screenshots became the only one one of our project groups seemed to be able to communicate. I griped loudly enough at a meeting that I actually thought I'd made a point and it had actually sunk into some of the more grevious offenders.... Later that day I started getting emails with word documents attached with screenshots embedded in them. *sigh*

Mon Jun 26, 10:04:00 PM EDT  

Anonymous dan said....

For a while screenshots became the only one one of our project groups seemed to be able to communicate. I griped loudly enough at a meeting that I actually thought I'd made a point and it had actually sunk into some of the more grevious offenders.... Later that day I started getting emails with word documents attached with screenshots embedded in them. *sigh*

Mon Jun 26, 10:05:00 PM EDT  

Anonymous dan said....

... ooops ... sorry about the double post above.... cat/keyboard interaction issue....

Mon Jun 26, 10:11:00 PM EDT  

Anonymous Steve said....

Dan.

Don't apologise. I think the fact that the cat can type so well and use such good English means we can forgive it for paw-ing 'Enter' twice at the end of it all.

If it wants a job in development, get it to give me a call ;-)

Steve.

Tue Jun 27, 04:29:00 AM EDT  

Blogger Thomas Kyte said....

This shows what my standard response is.

In this case, I added a bit about sending very very large emails without even asking if it would be OK.

Tue Jun 27, 07:02:00 AM EDT  

Anonymous Anonymous said....

I'm really sorry and probably it's
a bit offtopic but
EXEC #30:c=1000,e=782,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342226857795
FETCH #30:c=0,e=60,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342226857941
=====================
PARSING IN CURSOR #31 len=56 dep=2 uid=0 oct=3 lid=0 tim=1124342226858871 hv=1433558559 ad='a7f664f0'
select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1
END OF STMT
PARSE #31:c=1000,e=786,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=1124342226858847
BINDS #31:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b91534 bln=22 avl=04 flg=05
value=49783
EXEC #31:c=999,e=791,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342226859950
WAIT #31: nam='db file sequential read' ela= 22757 p1=1 p2=370 p3=1
WAIT #31: nam='db file sequential read' ela= 47537 p1=1 p2=59112 p3=1
FETCH #31:c=1000,e=70676,p=2,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342226930714
FETCH #31:c=0,e=44,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342226930857
FETCH #30:c=0,e=21,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342226930968
=====================
PARSING IN CURSOR #32 len=169 dep=2 uid=0 oct=3 lid=0 tim=1124342226932318 hv=204386021 ad='a7f73fa4'
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
END OF STMT
PARSE #32:c=1000,e=1047,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=1124342226932292
BINDS #32:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b90eec bln=22 avl=04 flg=05
value=126551
EXEC #32:c=1000,e=1195,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342226933849
WAIT #32: nam='db file sequential read' ela= 38119 p1=1 p2=57826 p3=1
FETCH #32:c=0,e=38395,p=1,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342226972363
=====================
PARSING IN CURSOR #33 len=151 dep=2 uid=0 oct=3 lid=0 tim=1124342226973547 hv=1980305124 ad='a7f71f30'
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee#
END OF STMT
PARSE #33:c=1000,e=1015,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=1124342226973521
BINDS #33:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b90844 bln=22 avl=04 flg=05
value=126551
EXEC #33:c=999,e=1071,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342226974929
WAIT #33: nam='db file sequential read' ela= 16176 p1=1 p2=51413 p3=1
WAIT #33: nam='db file sequential read' ela= 10358 p1=1 p2=52363 p3=1
WAIT #33: nam='db file sequential read' ela= 4997 p1=1 p2=52362 p3=1
FETCH #33:c=999,e=34014,p=3,cr=6,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009039
FETCH #33:c=0,e=13,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009187
FETCH #33:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009263
FETCH #33:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009343
FETCH #33:c=0,e=9,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009411
FETCH #33:c=0,e=15,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009481
FETCH #33:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009604
FETCH #33:c=1000,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009669
FETCH #33:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227009745
FETCH #33:c=0,e=22,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010014
FETCH #33:c=0,e=14,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010100
FETCH #33:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010159
FETCH #33:c=0,e=16,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010363
FETCH #33:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010445
FETCH #33:c=0,e=15,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010631
FETCH #33:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010723
FETCH #33:c=0,e=9,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010781
FETCH #33:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227010835
FETCH #33:c=0,e=35,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227010915
=====================
PARSING IN CURSOR #34 len=175 dep=2 uid=0 oct=3 lid=0 tim=1124342227012882 hv=3073477137 ad='a7d58a98'
select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# order by o.obj#
END OF STMT
PARSE #34:c=2000,e=1605,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=1124342227012859
BINDS #34:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24 offset=0
bfp=f4b8fc0c bln=22 avl=04 flg=05
value=126551
EXEC #34:c=1000,e=1148,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227014250
WAIT #34: nam='db file sequential read' ela= 20824 p1=1 p2=63121 p3=1
FETCH #34:c=0,e=21103,p=1,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227035417
STAT #34 id=1 cnt=0 pid=0 pos=1 obj=0 op='SORT ORDER BY '
STAT #34 id=2 cnt=0 pid=1 pos=1 obj=0 op='NESTED LOOPS '
STAT #34 id=3 cnt=0 pid=2 pos=1 obj=0 op='NESTED LOOPS '
=====================
PARSING IN CURSOR #35 len=116 dep=3 uid=0 oct=3 lid=0 tim=1124342227038025 hv=431456802 ad='a7fa6bd8'
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj#,o.flags from obj$ o where o.obj#=:1
END OF STMT
PARSE #35:c=1999,e=2007,p=0,cr=0,cu=0,mis=1,r=0,dep=3,og=0,tim=1124342227038003
BINDS #35:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b8f9a4 bln=22 avl=02 flg=05
value=82
EXEC #35:c=1000,e=992,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=4,tim=1124342227039451
FETCH #35:c=0,e=73,p=0,cr=3,cu=0,mis=0,r=1,dep=3,og=4,tim=1124342227039611
STAT #34 id=4 cnt=0 pid=3 pos=1 obj=82 op='TABLE ACCESS BY INDEX ROWID TRIGGER$ '
STAT #34 id=5 cnt=0 pid=4 pos=1 obj=130 op='INDEX RANGE SCAN I_TRIGGER1 '
STAT #34 id=6 cnt=0 pid=3 pos=2 obj=18 op='TABLE ACCESS BY INDEX ROWID OBJ$ '
STAT #34 id=7 cnt=0 pid=6 pos=1 obj=36 op='INDEX UNIQUE SCAN I_OBJ1 '
STAT #34 id=8 cnt=0 pid=2 pos=2 obj=22 op='TABLE ACCESS CLUSTER USER$ '
STAT #34 id=9 cnt=0 pid=8 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# '
=====================
PARSING IN CURSOR #17 len=81 dep=1 uid=33 oct=7 lid=33 tim=1124342227040787 hv=753168193 ad='a8b219a8'
DELETE "DP"."DR$SECURITY_CTX1$K" WHERE TEXTKEY = :rid RETURNING DOCID INTO :docid
END OF STMT
PARSE #17:c=37993,e=363195,p=10,cr=36,cu=0,mis=1,r=0,dep=1,og=0,tim=1124342227040763
BINDS #17:
bind 0: dty=1 mxl=32(18) mal=00 scl=00 pre=00 oacflg=00 oacfl2=0 size=56 offset=0
bfp=f3300de8 bln=32 avl=18 flg=05
value="AAARZYAAGAACAqaAAw"
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=05 oacfl2=0 size=0 offset=32
bfp=f3300e08 bln=22 avl=00 flg=01
EXEC #17:c=1000,e=1406,p=0,cr=3,cu=1,mis=0,r=1,dep=1,og=4,tim=1124342227042397
=====================
PARSING IN CURSOR #36 len=343 dep=2 uid=0 oct=3 lid=0 tim=1124342227044812 hv=2367942048 ad='a7f9cb04'
select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0),audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt,avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1),nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0),nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1
END OF STMT
PARSE #36:c=1000,e=1540,p=0,cr=0,cu=0,mis=1,r=0,dep=2,og=0,tim=1124342227044791
BINDS #36:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b8fe20 bln=22 avl=04 flg=05
value=126556
EXEC #36:c=1000,e=868,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227046143
FETCH #36:c=0,e=108,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227046339
BINDS #18:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b5cf8c bln=22 avl=04 flg=05
value=126556
bind 1: (No oacdef for this bind)
EXEC #18:c=0,e=413,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227047205
FETCH #18:c=0,e=364,p=0,cr=6,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227047645
BINDS #19:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b72620 bln=22 avl=04 flg=05
value=126557
EXEC #19:c=0,e=314,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227048141
FETCH #19:c=0,e=78,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227048291
FETCH #19:c=0,e=15,p=0,cr=1,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227048386
FETCH #18:c=1000,e=1003,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227049473
BINDS #20:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b93538 bln=22 avl=04 flg=05
value=126556
EXEC #20:c=0,e=349,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227050135
FETCH #20:c=0,e=150,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227050395
FETCH #20:c=0,e=18,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342227050511
FETCH #20:c=1000,e=474,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227051050
BINDS #28:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b926c8 bln=22 avl=04 flg=05
value=126556
EXEC #28:c=1000,e=485,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227051810
FETCH #28:c=0,e=77,p=0,cr=2,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342227051975
BINDS #30:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=f4b92024 bln=22 avl=04 flg=05
value=126556

Tue Jun 27, 07:48:00 AM EDT  

Blogger shrek said....

let's just say this makes me glad i'm not smartor famous.;-)

Tue Jun 27, 08:55:00 AM EDT  

Anonymous Anonymous said....


Anonymous said....
I'm really sorry and probably it's
a bit offtopic but
EXEC #30:c=1000,e=782,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=1124342226857795
FETCH #30:c=0,e=60,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=4,tim=1124342226857941
.................

Oh you're just too funny ! <eyes rolling>
Tom , please delete it (and this one)
thanks

Tue Jun 27, 10:16:00 AM EDT  

Blogger Robert Vollman said....

Send him a bill. Or direct him to some Oracle consultants.

Tue Jun 27, 12:57:00 PM EDT  

Anonymous Anonymous said....

Tom is a celebrity. You need to change your work email. You must have been a bit nuts to give that out.

Might want to make gmail your public email. You can choose to download the attachment or not.

Won't be long before you are living in a compound with security. Maybe you can talk to Britney Spears and you can get her 'Manny' to be security for your kids?

Won't be long before single female(or claims to be female) DBAs in ask you to marry them.

When I saw Tom speak on 10G new features back in 2004, I thought people in the audience were going to cry they were so excited that he was speaking.

Ryan

Tue Jun 27, 03:51:00 PM EDT  

Anonymous OracleDoc said....

Tom,
I do not envy you at all. When you become famous, your life and what you do is in the spotlight, people will become disillusioned that they know you. As your email inbox proves this.

It's actually funny that some people think you have nothing better to do than answer their emails.

Just seeing some of the questions that people ask on various dba forums makes me agree with Howard's statement.

Wed Jun 28, 03:25:00 AM EDT  

Blogger Richard said....

"Guess it is sort of like a person at a party that meets a doctor and proceeds to take off a shoe to show them a foot problem and ask for advice."

... er, isn't that your whole raison d'être? As for gigantic, silly, overblown (and somewhat worthless) messages, what about http://asktom.oracle.com/pls/ask/f?p=4950:8:15007250903705834464::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:35336203098853

Wed Jun 28, 05:11:00 AM EDT  

Blogger Thomas Kyte said....

er, isn't that your whole raison d'être?

I certainly hope not - I sort of have a day job too.

There is a time and a place, should the doctor expect to be "on call" 24x7 - it is after all their entire reason for existing right?

Wed Jun 28, 07:09:00 AM EDT  

POST A COMMENT

<< Home