RE: Yet another tool for Command_line_history for Linux DBA

From: Marquez, Chris <CMarquez_at_aarp.org>
Date: Wed, 12 Jan 2005 09:45:12 -0500
Message-ID: <7E412C164E6ECB468834A39F31E6E0D406688FE1@mbs06dc.na.aarp.int>

>> Cut'n'paste!
Amen!

>> save the resulting text file
>> come back to it when a similar scenario comes up. Ahh, personal notes...I'm amazed to find how many DBA's will do and learn the same thing over and over.

>> with a hopefully meaningful name=20
Got a love W2K dir/file search capabilities...use it daily on my own files.

Good to see I'm not the only one...you don't want to know how many personal DBA notes, doc, html file I have saved over the past 6 years.

Chris Marquez
Oracle DBA
HEYMONitor(tm) - heymonitor.com
"Oracle Monitoring & Alerting Solution"

-----Original Message-----
From: Steven Patenaude [mailto:spatenau_at_gmail.com]=20 Sent: Tuesday, January 11, 2005 6:40 PM
To: Marquez, Chris
Cc: oracle-l_at_freelists.org
Subject: Re: Yet another tool for Command_line_history for Linux DBA

On Tue, 11 Jan 2005 16:15:10 -0500, Marquez, Chris <CMarquez_at_aarp.org> wrote:
> For those of us with "fat fingers" this would be a blessing.

>=20

> I can not tell you how many times I fail to simply type v$istnance,=20
> v$instnace, v$instance! And often...and I mean often, I will run this=20
> little select in a spool and to eye-ball that I'm in the right place=20
> before rolling out some DDL...

>=20

> And about those debug sessions with your developers when you might=20
> select from dba_tab_privs, dba_sys_privs, and dba_role_privs, over,=20
> and over again to verify grants and privs...

I usually have two windows open, one the telnet sqlplus session and the other a gui text editor. Cut'n'paste! I'll usually save the resulting text file with a hopefully meaningful name and often will come back to it when a similar scenario comes up.

Steven

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

Received on Wed Jan 12 2005 - 08:47:33 CST