anyone uses Quest software??

[james07]

HI

Does anyone here uses any of the management or monitoring software from Quest?

I was checking out Spotlight on Oracle, which I found it to be fascinating, but I know my company will never buy it, because we're cheap.

So if anyone used something simular or better, please let me know, so I can check it out.


thanks a bunch.


new dba

[sreddy]

There are many but, money matters. To mention few:

Oracle Enterprize Manager
Embarcedro DBArtisian
BMC Patrol
...
..
.

[rogerF]

There are "tons" of monitoring scripts available freely on the net. The gui tools only act as a front end to execute those queries. I was forced to work with Oracle because I had unix experience and couldn't even do a "select " statement. However by going out to the net and downloading some scripts(and testing on a test machine) I was able to monitor the DB and learn about SQL.

Once you've gotten about 8-15 scripts that show most of the stuff you need to see(tablespaces, tables, users, privs, syns, blah blah blah) than you can write a simple shell script that uses that "case" statement to prompt the user to choose one of your scripts.

Here are some links for free scripts:

[url]http://home1.gte.net/rkupcuna/html/oracle_scripts.htm[/url]

[url]http://www.timonions.com/[/url]

[url]http://www.bytelife.com/sql4dba.htm[/url]

[url]http://www.angelfire.com/biz4/oraclealley/[/url]

If your really lost- I can send you a tarball with my script and subscripts- you would have to change the ENV variables to customize it for your site.
roger_feldman@hotmail.com

[warevalley]

Dear James07;
why don't you visit [url]www.warevalley.com[/url] to find what you really want to ? This tool is for the develolment application and performance tool for developer and DBA of Oracle.