Re: Windows NT and pinning objects at reboot time.

Ok, here goes...

I havn't tried this, but it *may* be the simplest to implement pinning after startup.

The database is started via a .CMD file in your database directory.

%ORACLE_HOME%\database\strtorcl.cmd

On NT, the OracleStartORCL "service" executes this CMD file to start up oracle with the ORADIM program.

I would insert a PLUS33/80 or SRVMGR command after ORADIM invoking your pinning script.

I don't think ORADIM waits around for the SGA to become available, so you may need to find a SLEEPing solution to postpone execution until the SGA is available.

Good luck!

"Don Wolf" <Don.Wolf_at_IAMS.com> wrote:

> Hello,
>
> I am relatively new to using Oracle on a Windows NT environment and I am
> having difficulty with what would normally be a fairly simple task in UNIX.
>
> When the Windows NT machine reboots the databases are started
> automatically, just like UNIX (if you set it up right). However, in UNIX I
> have the ability to have it use my own scripts for startup/shutdown of the
> database(s). Within these scripts I can do anything to the database I
> want, including pinning large objects into the SGA. The reason I would
> like to pin these objects is because they are quite large and I can gain
> performance improvements by pinning them. Is there anyplace in Windows NT
> that I can "hook" into to have it run additional things when each database
> is started? Or perhaps there is another way to do this without "hooking"
> into the actual startup?
>
> Any suggestions/advise would be greatly appreciated.
> --
> Don Wolf
> The IAMS Company
> Don.Wolf_at_IAMS.com

--
joebrown
@leading.net Received on Fri Sep 25 1998 - 20:31:30 CDT