Jared,
You came to the same conclusion I did. Since this is
the first perl script I have written for production I
still have a lot to learn. I was thinking that I had
missed something painfully obvious.
Thanks for the help. Hope all is well by you.
Pete
- Jared.Still_at_radisys.com wrote:
> Pete,
>
> Even as a rabid Perl fanatic, I still use KSH to
> install statspack.
>
> I just modified the stock scripts a bit so they will
> run without user
> input.
>
> You can do it in Perl, but ksh is probably the tool
> for this job.
>
> Jared
>
>
>
>
>
>
> Peter Barnett <regdba_at_yahoo.com>
> Sent by: ml-errors_at_fatcity.com
> 07/14/2003 03:49 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: Perl Question
>
>
> I am mucking through my first real perl script.
> When
> it is finished it will install statspack on all of
> the
> database throughout the company. That's a gob of
> databases!
>
> To run in batch mode statspack requires two define
> statements:
>
> define default_tablespace = tablespace_name
> define temporary_tablespace = temp_name
>
> Does anyone know the syntax to get these two
> statements to work?
>
> If not, I suppose the individual scripts can be
> called
> individually after the perfstat user is created.
> Either that or chicken out of the perl stuff and go
> back to tried and true shell scripting.
>
>
>
>
>
> =====
> Pete Barnett
> Lead Database Administrator
> The Regence Group
> pnbarne_at_regence.com
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Peter Barnett
> INET: regdba_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
Received on Tue Jul 15 2003 - 08:38:25 CDT