| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MetaSlop -- More Screeching and Droning.
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Mohan,
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>You
brought laughter to the entire team here!!! Great. Keep it up.
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Rao
<span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<font
color=navy><a href="mailto:Maheswara.Rao_at_SunGardP3.com" title="Return Mail Address">Maheswara.Rao_at_SunGardP3.com<font color=navy>
<span
class=EmailStyle18><span style='font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>
<font size=2 color=black
face=Tahoma>-----Original
Message-----
From: Mohan, Ross
[mailto:MohanR_at_stars-smi.com]
Sent: Tuesday, February 27, 2001
4:26 PM
To: Multiple recipients of list
ORACLE-L
Subject: MetaSlop -- More
Screeching and Droning.
<span
style='font-size:12.0pt'>
<span
style='font-size:10.0pt;color:black'>Our own esteemed Paul Baumgartel wants to
know how our
<span style='font-size:10.0pt;
color:black'>equally esteemed Kevin would have handled the MetaCrack<font
color=black>
<span style='font-size:10.0pt;
color:black'>announcement. <span
style='color:black;mso-color-alt:windowtext'>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><span
style='font-size:12.0pt;color:black'> <font
color=black>
<span
style='font-size:10.0pt;color:black'>There are several possibilities, depending
on what is ACTUALLY <font
color=navy><span style="mso-spacerun:
yes"> <span
style='font-size:10.0pt;color:black'>going on in the Armani Sweatshop on
Ellison Lane. <font
color=black>
<span
style='font-size:10.0pt;color:black'>Scenario One: <font
color=black>
<span
style='font-size:10.0pt;color:black'>ATTENTION: Oracle Customers --
Special DBA Announcement.<span
style='color:black'> <span style="mso-spacerun: yes"> <span style='color:black;mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;color:black'>PASS THIS TO YOUR DBA!<font color=black> <span style='color:black;mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;color:black'>No doubt you have recently seen
performance on MetaLink do<span
style='color:black'> <span
style='font-size:10.0pt;color:black'>down like a career hooker on a
Presidential candidate. There<span
style='color:black'> <span style='font-size:10.0pt;color:black'>is a reason for this, and here it is:<font color=black> <span style='color:black;mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;color:black'>We had a cowboy DBA who stayed up too late
one night reading <font
size=2 color=black>"Oracle
Latches, Waits, and Blinking Lights" by Tom Swift.<font
color=black> <span
style='font-size:10.0pt;color:black'>(Doubtless you are aware of this classic
review of oracle internals.)<span
style='color:black'>
<span style='font-size:10.0pt;
color:black'>Unfortunately, aforementioned cowboy badly misinterpreted the
settings of <font
size=2 color=black>the
_db_block_write_flush_or_scan_depth_increment_rigidity parameter<font
color=black> <span
style='font-size:10.0pt;color:black'>and really screwed up our systems. After
out "Global IT Group" got on<span
style='color:black'> <span
style='font-size:10.0pt;color:black'>the problem ( ok, the "other"
cowboy rookie DBA we have ) he tried everything<span
style='color:black'> <span
style='font-size:10.0pt;color:black'>he could, and actually worsened things by
setting the "_please_make_it_better"<span
style='color:black'> <span
style='font-size:10.0pt;color:black'>parameter to TRUE, as opposed to
IMMEDIATE. As you may know, this undoc<span
style='color:black'> <span
style='font-size:10.0pt;color:black'>parameter only works in TRUE mode for
Oracle8, and MetaLink is still running<span
style='color:black'> <span style='font-size:10.0pt;color:black'>on Oracle 7.2.3.4.2.<font color=black> <span style='color:black;mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;color:black'>Finally, we called in someone competent
from our front line support. She had<span
style='color:black'> <span
style='font-size:10.0pt;color:black'>actually quit, and was packing her desk in
disgust (at not being allowed to properly address customer requests ever since
the "iTar" process performed auto-deletes on all online requests) but
was stopped by an alert middle manager for "one last favor". After
she set the "_divert_funds_from_marketing" parameter<font
color=black> <span
style='font-size:10.0pt;color:black'>to TRUE, everything came back for a
handful of minutes. <span style='color:black;
mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;color:black'>During this brief operational period, we
had a "staggering" number of requests hit our front end webservers (
Apache on Linux-based Palm Pilots ) and MetaLink<font
color=black>
<span style='font-size:10.0pt;
color:black'>could not respond to the seven requests simultaneously. <font
color=black>
<span
style='font-size:10.0pt;color:black'>We are currently throwing hardware at the
problem, and hope to be able to provide<span
style='color:black'> <span
style='font-size:10.0pt;color:black'>roughly the same level of service you'd expect
at a local Seven-Eleven any day now. <span
style='color:black;mso-color-alt:windowtext'>
<span
style='font-size:10.0pt;color:black'>So Long, and Thanks for All the Power
Units!!!! <font
color=black>
<span
style='font-size:10.0pt;color:black'>################ END METALINK MESSAGE #######################################<spanstyle='color:black'> <span style='color:black; mso-color-alt:windowtext'>
<font size=3 color=black
face="Times New Roman"> <font
color=black>
<span
style='font-size:10.0pt;color:black'>There are other scenarios, but my
hourglass just returned from my metalink<span
style='color:black'>
<span style='font-size:10.0pt;
color:black'>search, so i've got to go now.........<font
color=black> <span
style='color:black;mso-color-alt:windowtext'>
<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><span
style='font-size:12.0pt;color:black'> <font
color=black>
<span
style='font-size:12.0pt;color:black'><span style="mso-spacerun:
yes"> <span style='color:black;
mso-color-alt:windowtext'>
Received on Tue Feb 27 2001 - 16:11:24 CST
 |
 |