Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: DBV slow W2K server

Mogens Nørgaard

2006-05-30

Replies:


Aaaarrrrgggghhhhhh. DBV used to be the funniest thing around Oracle -
namely when we made fun of the Sybase customers who would run this silly
thing time and again. Oh man, they weren't even allowed to call Sybase
Support unless they had run DBVerify. The catch being that it might take
more than 24 hours to run (it scaled, but not in the cool way, as they
say), and so they had huge problems.... Man, were we laughing about this
and using it massively in Oracle's internal competitive info on Sybase.

Then Oracle did it themselves. Was it in 8.0? And suddenly the
competitive info changed. Unfortunately, it also led to this strange
belief (based on Oracle's documentation) that DBV is good for something.
It pretty much isn't. It's actually faintly dangerous in my opinion.

Why on EARTH would anyone want to run this silly thing? It is a waste of
resources, time and all other things. There might - might - be a few
cases where it could provide useful information, but weigh that against
the costs of running it, the false sense of security it might generate -
and the features and bugs in it that will mis-lead the
not-so-experienced into thinking something horrible is going on in the
blocks - and I can only conclude:

Don't Bother, Vriends.

Mogens

PS: It's taking a very long time because it's doing a lot of IO. So
either stop using DBV or buy more disks.


=?iso-8859-1?Q?O'Neill@(protected):

>Hi Folks,
>
>Would appreciate some help/guidance with an issue I've noticed with the dbv utility on Windows 2000 server. I'm using this utility as part of an offline backup process. For some reason the dbv is now taking over 9 hours to complete. It used to take about half this time. I've been to Internet to try and track down if this is a known issue but to no avail. The Oracle manuals have not been much help either.  I've looked at the server and it does not appear to be maxed out by anything that would cripple the dbv executing.
>
>Regards,
>- Se?n O' Neill
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.