The System Resource Verifier (aka sysresv) is an Oracle utility that gives you the status and OS resource information for a database instance. It shows you information on the shared memory and semaphore usage of the database and is extremely useful when you need to remove orphaned Oracle memory segments and avoiding a costly and time consuming reboot.
Tag: startup failure
Let’s take a look at one of my early articles in the IOUG Tip Booklet. It is still relevant today…
In Oracle 9i, the spfile was introduced as a new method to store the initialization parameters. The use of the spfile helped to simplify the remote startup of a database and added options for the busy DBA. In this article, we will look at the spfile and how it is managed on UNIX/Linux and Windows.
RSS - Posts