Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #424

Re: Looking For Direction

Show all headers | View raw

  To: alt.comp.lang.java,comp.l
JC wrote:
>> He may not be a DBA, but if has been writing SQL statements for the
>> app then he would know some of Oracles ways of doing things.
>>
>> Arne
>>
> 
> I dream in SQL ... :)
> 
> Even though I'm not a DBA, from time to time I have to do DBA oriented
> things. Since the system is not highly sophisticated this is never been too
> much of a problem. I'd say the most important thing I do along these lines
> is monitor the size of the tablespaces, how fast they are growing.  Maybe a
> few times in the beginning I had to resize them; but I pretty much have a
> handle on it now. By law we only have to keep ten years worth of data. So
> every night I have a routine that deletes anything older than ten years
> (actually I go ten years and six months just to be safe). We started doing
> this (deleting old data) about a year or so ago. It helps keep the size of
> the database more stable (except whenever we get new contracts that are big
> clients which has happened twice ... once with the state of Alabama and more
> recently with West Virginia). Anyway, what I worry about is with the
> deleting and adding of data on a consistent basis whether something funky
> will happen some day like file corruption, fragmentation, etc. Things which
> I really don't know how to fix of have any experience with.
> -JC

I should note, I certainly wasn't casting any aspersions on you by 
emphasizing that you said you're not a DBA. Neither am I. I can get 
basic DBA things done on a number of RDBMS's like Oracle, SQL Server and 
PostgreSQL, and for the databases you use I suspect you're at the same 
level as myself.

I was simply considering the fact that I myself don't have a great deal 
of time invested in learning how to do these basic DBA tasks. Also, 
there are a lot of resources available for any de facto DBA, for almost 
any widely used RDBMS. So switching from one to another, and acquiring 
the basic skill set that you have for your version of Oracle on another 
RDBMS, is not a large investment of time, IMO.

To reiterate, I am _not_ suggesting that it's a trivial thing for a 
_true_ DBA on RDBMS #1 to acquire the equivalent skills on RDBMS #2.

AHS

-- 
It should be noted that no ethically-trained software engineer would 
ever consent to write a DestroyBaghdad procedure. Basic professional 
ethics would instead require him to write a DestroyCity procedure, to 
which Baghdad could be given as a parameter.
-- Nathaniel Borenstein

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: Looking For Direction "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
  Re: Looking For Direction "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
    Re: Looking For Direction "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
      Re: Looking For Direction "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
        Re: Looking For Direction "JC" <jc@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
          Re: Looking For Direction "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
            Re: Looking For Direction "JC" <jc@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
    Re: Looking For Direction "David Kerber" <david.kerber@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
      Re: Looking For Direction "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
        Re: Looking For Direction "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
        Re: Looking For Direction "David Kerber" <david.kerber@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
          Re: Looking For Direction "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
    Re: Looking For Direction "Martin Gregorie" <martin.gregorie@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
      Re: Looking For Direction "=?UTF-8?B?QXJuZSBWYWpow7h" <=?utf-8?b?qxjuzsbwywpow7h@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000
      Re: Looking For Direction "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:23 +0000

csiph-web