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

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

Re: Looking For Direction

Show all headers | View raw

  To: alt.comp.lang.java,comp.l


>
> 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

---
 * 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