Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: MetaSlop -- More Screeching and Droning.

RE: MetaSlop -- More Screeching and Droning.

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Tue, 27 Feb 2001 14:11:24 -0800
Message-ID: <F001.002BEDF7.20010227135744@fatcity.com>

<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 #######################################<span
style='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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US