Re: Windows NT and pinning objects at reboot time.

There is a parameter you can put in the INIT file which will run SQL scripts at load time. The name of the parameter escapes me at the moment .... something like RUN_SQL = ( xyz.SQL) though.

On Sat, 26 Sep 1998 01:31:30 GMT,
joebrownNO_SPAM_me_very_MUCH_at_leading.net (Joe Brown) wrote:

>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
Received on Fri Oct 02 1998 - 05:54:50 CDT