Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Question on Oracle 9i/10g and the HP SPI for Databases

Tony Williams
Regular Advisor

Question on Oracle 9i/10g and the HP SPI for Databases

We are on Oracle 8.1.7 and use the DBSPI. We have heard that the new management features of Oracle 9i and 10g eliminate the need for a product like the DBSPI. Does anyone know what the new features for managing 9i and 10g in areas like space management, archiving, performance, and roll back segments are and why you wouldn't need the DBSPI?
2 REPLIES
Steven E. Protter
Exalted Contributor

Re: Question on Oracle 9i/10g and the HP SPI for Databases

I just did a 10g installation this morning. Its possible to semi-automate backups and space managment with that database.

In addition, database defragmentation is done on the fly.

There is still some need to manage archive logging, performance and rollback segments. Otherwise why would we need the dba's?

:-)

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Brian Crabtree
Honored Contributor

Re: Question on Oracle 9i/10g and the HP SPI for Databases

Tony,

Some things you won't need it for, and some you will.

1. Instance monitoring. No way to do this without a separate product.

2. Tablespace monitoring. While it will make sure that fragmentation is not a problem, the tablespace can still run out of space, even if you use AUTOEXTEND.

3. Archive area monitoring. Logs put out on disk should be monitored, since this can cause the database to hang waiting for space.

4. Listener availablility (part of 1, but still important).

5. Alertlog monitoring. Some things you will get notification for from your application, other things will only show up in the alertlog.

Thanks,

Brian