HI lists can anybody throw this sql statement I need to create a trigger that will fire on shutdown (just before shutdown) of the database. It has to collect the flwng infm into a table called free_mem_prc 1. The time in minutes the system has been up( means my instance is running since 200 minuts) 2. Max no.of processes utilized by that instance (Can I get from V$resource_limit??) 3. The free memory (Can I get from v$sgastat??) the table is free_mem_prc ( a number - this stores 1 b number - this stores 2 c number ) - this stores 3 Are there any possible bugs with shutdown triggers... ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).