RE: Database management techniques and frameworks

2003-12-09 Thread Thater, William
Orr, Steve scribbled on the wall in glitter crayon: I'm not assuming such a tool exists... It indeed does exist because the salesman who happened to be selling it said so and it must be of course it does, and they'll install it for you because they can install and tune it EXACTLY THE SAME WAY

RE: Database management techniques and frameworks

2003-12-09 Thread Denny Koovakattu
Makes me remember the story I was told about damagement running around telling users to log off because the latches are red ;) -- Denny Koovakattu Quoting Thater, William [EMAIL PROTECTED]: Orr, Steve scribbled on the wall in glitter crayon: I'm not assuming such a tool exists... It

Re: Database management techniques and frameworks

2003-12-09 Thread Mladen Gogala
Serves them right for not using mauve database, which, as everybody knows, uses the least RAM. On 12/09/2003 10:24:27 AM, Denny Koovakattu wrote: Makes me remember the story I was told about damagement running around telling users to log off because the latches are red ;) -- Denny

Re: Database management techniques and frameworks

2003-12-09 Thread Brian Haas
Mladen Gogala wrote: Serves them right for not using mauve database, which, as everybody knows, uses the least RAM. According to my source(taped up in my cubicle), mauve has the most ram. ;) -Brian -- / * Brian Haas

RE: Database management techniques and frameworks

2003-12-08 Thread Orr, Steve
in a future post -- still compiling.) Adam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 11:09 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25

Re: Database management techniques and frameworks

2003-12-08 Thread Mladen Gogala
] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time

RE: Database management techniques and frameworks

2003-12-08 Thread Bellow, Bambi
/2003 11:09 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development

RE: Database management techniques and frameworks

2003-12-08 Thread Orr, Steve
[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 11:09 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all

Re: Database management techniques and frameworks

2003-12-06 Thread Jared Still
That isn't a moth! Any improvements to PDBA toolkit are welcome. As Mladen points out, it is somewhat out of date. But then again, it works, and it is fairly simple. If you buy one on Mladens recommendation, I'll send him a check for 10% of what I make on it. Mladen, I'll round it up to

Re: Database management techniques and frameworks

2003-12-05 Thread ryan_oracle
management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where

RE: Database management techniques and frameworks

2003-12-05 Thread DENNIS WILLIAMS
of list ORACLE-L [EMAIL PROTECTED] Subject: Database management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database

Re: Database management techniques and frameworks

2003-12-05 Thread AdamDonahue
ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You

RE: Database management techniques and frameworks

2003-12-05 Thread Goulet, Dick
When I had only one instance to baby sit doing the script thing was OK, but it also missed things like the listener not being up and lost of other problems. Besides it was a pain to add it to each new server as they came along. Therefore I re-wrote those scripts into one C language program

RE: Database management techniques and frameworks

2003-12-05 Thread Bellow, Bambi
: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log

Re: Database management techniques and frameworks

2003-12-05 Thread Ryan
PROTECTED] Subject: Database management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance

Re: Database management techniques and frameworks

2003-12-05 Thread Ryan
one more point. Sorry for all the emails. I found that when writing scripts for monitoring you really should follow an abstraction philosohpy similiar to what you see in Object Oriented programming. Write utility scripts, use data files, then have utility scripts that 'echo' out data from them

Re: Database management techniques and frameworks

2003-12-05 Thread Ryan
with chained rows, tablespace sizes, etc... Write scripts for this and send your self emails. Have statspack snapshots run daily. From: [EMAIL PROTECTED] Date: 2003/12/05 Fri PM 01:49:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database management

Re: Database management techniques and frameworks

2003-12-05 Thread Mladen Gogala
Ryan, have you tried PDBA toolkit? The address is: http://www.oreilly.com/catalog/oracleperl/pdbatoolkit/ This toolkit has a plethora of very useful scripts. I seem to recollect an ugly looking O'Reilly book with moth on an orange overtone cover, which does a very good job on documenting it. The

RE: Database management techniques and frameworks

2003-12-05 Thread AdamDonahue
ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You

RE: Database management techniques and frameworks

2003-12-05 Thread Bellow, Bambi
recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Database management techniques and frameworks Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's

RE: Database management techniques and frameworks

2003-12-05 Thread AdamDonahue
Perhaps it should have said Occam's razorian ;) Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 01:59 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Database management techniques and frameworks