Thank you.. But I needed to know when the service was *created.* On Jan 31, 2008 11:37 AM, D'Hooge Freek <Freek.D'Hooge@xxxxxxxxx> wrote: > Do you mean the service_names ? > > SQL> descr v$services > Name Null? Type > ----------------------------------------- -------- > ---------------------------- > SERVICE_ID NUMBER > NAME VARCHAR2(64) > NAME_HASH NUMBER > NETWORK_NAME VARCHAR2(512) > CREATION_DATE DATE > CREATION_DATE_HASH NUMBER > GOAL VARCHAR2(12) > DTP VARCHAR2(1) > AQ_HA_NOTIFICATION VARCHAR2(3) > CLB_GOAL VARCHAR2(5) > > Regards, > > Freek D'Hooge > Uptime > Oracle Database Administrator > email: freek.dhooge@xxxxxxxxx > tel +32(0)3 451 23 82 > http://www.uptime.be > disclaimer > > > ________________________________________ > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Shivaswamy Raghunath > Sent: donderdag 31 januari 2008 17:25 > To: Oracle-L > Subject: RAC Service > > Hello. > I am doing some trouble shooting. Is there a way to identify when a > service is created? I deduce it has to be at cluster level. But, so far it > has been futile effort my end. > Just as we know when an objected is created in the database, is there not > something which stores the info - this reource is created on such and such a > time? > TIA, > Shiva >