Re: command line vs grid control
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Tue, 03 Jul 2007 07:11:51 -0700
ivl5@xxxxxxxxxxx wrote:
On Jul 3, 1:45 pm, DA Morgan <damor...@xxxxxxxxx> wrote:Bob Jones wrote:"DA Morgan" <damor...@xxxxxxxxx> wrote in messageI said "more recent than" and the list is nearly endless which
news:1183413703.619051@xxxxxxxxxxxxxxxxxxxxxxxxx
emdproduct...@xxxxxxxxxxx wrote:What is the change in 9.2.0.8 makes it impossible?I am used to my old time shell/perl scripts to monitor my database,Assuming some version of Oracle more recent than 9.2.0.8 you can not
routine work, should I invest in oracle 10g grid control?
Any commends will be appreciated
monitor a database using shell/perl scripts any longer.
Anyone that claims otherwise doesn't understand the product.
is precisely the point. You couldn't write all the scripts
required to duplicate the functionality of the OEM grid control
if you worked on it 40 hours a week for the next 6 months. In
No need to duplicate everything. OP talks "monitor my database,
routine work". This can continue to be done with his existing scripts.
"You can not monitor a database using shell/perl scripts any longer"
for 10g+ looks like an overstatement.
fact some of that functionality is literally impossible to
duplicate with any shell script.
And what this functionality is exactly?
Regards,
Igor
The original question was "should I invest in" and the answer is
yes.
--
Daniel A. Morgan
University of Washington
damor...@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org
One simple example: You can not do this.
SELECT TO_CHAR(s.startup_time,' DD MON "at" HH24:MI:SS') INSTART_FMT,
di.instance_name INST_NAME, di.db_name DB_NAME, s.snap_id SNAP_ID,
TO_CHAR(s.end_interval_time,'DD MON YYYY HH24:MI') SNAPDAT,
s.snap_level LVL
FROM dba_hist_snapshot s, dba_hist_database_instance di
WHERE di.dbid = s.dbid
AND di.instance_number = s.instance_number
AND di.startup_time = s.startup_time
ORDER BY snap_id;
Well of course you can. But to do so you would need to buy the
license to do so in the Grid Control. So you've already spent
the money.
Take a look at the list of features monitored here:
http://www.psoug.org/reference/dbms_serv_alert.html
To do this with a shell script would require that you again buy
the appropriate Grid Control license.
More developers were used to build the 10g Grid Control than
to build the 10g database. How far do you think you are going
to get duplicating that with a shell script unless you violate
your employer's license agreement.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- Follow-Ups:
- Re: command line vs grid control
- From: ivl5
- Re: command line vs grid control
- References:
- command line vs grid control
- From: emdproduction
- Re: command line vs grid control
- From: DA Morgan
- Re: command line vs grid control
- From: Bob Jones
- Re: command line vs grid control
- From: DA Morgan
- Re: command line vs grid control
- From: ivl5
- command line vs grid control
- Prev by Date: Re: cannot use LOB locators
- Next by Date: Re: command line vs grid control
- Previous by thread: Re: command line vs grid control
- Next by thread: Re: command line vs grid control
- Index(es):
Relevant Pages
|
