Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ** SPAM scored: Low **RE: Re-setting V$tables
Dear Tanel, when I read you, it sound like you are faithful employee, in
place since 10 years and you have successfully enforced an enlighten
tyranny way of life.
God bless your boss.
Alas, the rest of the world live more or less under the reign of Chaos,
and contractors, are called anywhere to diagnose systems that are not
decent
and it is out of question for them to have 'Demands' or recommend firing
local people, specially when those people are the not decent people who
hired you.
Unless the DB is totally unusable, you have to present your genius DBA
neck to the axes of the local paper maker. They rule locally whatever it
worth but they also pay you.
Last, decent well planned system usually do not need to import diagnose
services, so what for the rest, those who have nothing, which is think
is in fact the majority? you maybe have notice that I am quite keen on
the license cost, for I can't tell customer, you need to start install
software. It cost time and money, while time is hot, since I am here to
provide answer, and money need only to fall in my contractor pockets,
not in soft vendors.
If you provide a method to do it free, fast and efficient, without creating objects or buying soft, say not requesting administration resources, then you and your customer are in a win/win situation. Win for the time, win for the money.
Beside that, I paid a look to your link and it is only a third of what
you need to proper report if you want to use OWI. No figures on sql and
no sql text neither.
You cannot say between x and y for this hash, that amount of exec, disk
reads, block gets bla bla. you cannot even give the sql text.
Bp
From: Tanel Poder [mailto:tanel.poder.003_at_mail.ee] Sent: Wednesday, 11 October, 2006 2:43 PM To: Polarski, Bernard; oracle-l_at_freelists.org Subject: RE: ** SPAM scored: Low **RE: Re-setting V$tables
I decent production environments you install any standard problem diagnosis tools before the server goes live.
If you start thinking about troubleshooting techniques after the database has been in production for a year and you hit problems, then I guess whoever is responsible for the database support strategy should be fired, especially at these SOX days.
Btw, in (well) planned production environments, there tend to be very little 'ultra fast emergency' and firefighting going on...
Tanel.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Polarski, Bernard
Sent: Wednesday, October 11, 2006 20:10 To: tanel.poder.003_at_mail.ee; oracle-l_at_freelists.org Subject: RE: ** SPAM scored: Low **RE: Re-setting V$tables Nah, this creates objects in DB namely a DB link and a package,you fresh meat.
Lot of customer, these SOx days, will shoot you with a riot gun if you do this, it is not usable on production DB.
I know site were it takes 3 weeks for an 'ultra fast emergency' administration allowance procedure
for such a big deal that creating a GTT. Can't image if I ask for a procedure or worse a DBlink.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 11 2006 - 08:23:23 CDT
![]() |
![]() |