Re: Beta program opportunity

2001-02-17 Thread Rachel Carmichael
yes, it does require the root password, once, on installation so I had my sysadmin sit with me when I installed it, and had him type in the password, haven't needed it since >From: "Thater, William" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EM

Re: Beta program opportunity

2001-02-17 Thread Rachel Carmichael
I"m running it on a machine that has 7.3.4, 8.0.5 and 8.1.6 no problems! >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Beta program opportunity >Date: Fri, 16 Feb 2001 12:56:30 -0800 > >Rachael, > >I looked at t

Oracle DBA Needed in Cleveland, Ohio..

2001-02-17 Thread OraStaff
We are currently seeking an individual a for commerical company in Cleveland, Ohio that has a permanent staff opportunity available for an Oracle DBA. * Requirements: - 2+ yrs. Oracle DBA experience on UNIX, - At least one yr of 7.34 or 8 in a large shop - U.S. Citizenship or permanent reside

Re: Thankx and more questions about SID

2001-02-17 Thread Charlie Mengler
I'm doing this from home, from memory & still on my 1st cup of coffee. SQL> select distinct sid into n_sid from v$mystat; HTH & YMMV! bipin sahani wrote: > Thankx for info > > Can I write a query which will give me a SESSION ID of > only > my session?? > > And where system id is store

RE: this drove me crazy!!!

2001-02-17 Thread Rao, Maheswara
Saurabh, When I created this function fist time, I also got error. Then I created emp table (in test schema) and then again created the function. This second time, the fuction is created without any errors. And I found this idea acadamically good. However, usage of this in real time might be

Re: this drove me crazy!!!

2001-02-17 Thread Saurabh Sharma
but this function is created with compilation errors.. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 1:15 AM > > > I can do it. > SQL> create or replace function dumb > 2 return number is > 3 pragma autonomous_tra

Re: could we please stop the political discussions?

2001-02-17 Thread Saurabh Sharma
I appreciate ur views..Jacques it's better if v discuss something meaningful..for which this list was created.   saurabh - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Saturday, February 17, 2001 8:50 AM Subject: could we p

Re:Thankx and more questions about SID

2001-02-17 Thread bipin sahani
Thankx for info Can I write a query which will give me a SESSION ID of only my session?? And where system id is stored? Thankx and regards Bipin --- Arun Aggarwal <[EMAIL PROTECTED]> wrote: > The SID in V$SESSION is session id not the system ID > given to the Instance. >

Re: Numeric SID

2001-02-17 Thread Arun Aggarwal
The SID in V$SESSION is session id not the system ID given to the Instance. These are two different things. Regards Arun Aggarwal Aithent Technologies (P) Ltd. [EMAIL PROTECTED] +91-124-6455504 (101) "If I knew what I was so anxious about, I wouldn't be so anxious." --Mignon McLaughlin -

RE: Numeric SID

2001-02-17 Thread Amar Kumar Padhi
SID stands for Session Id and is unique for each session within an instance. Amar Kumar Padhi Software Consultant -Original Message- Sent: Saturday, February 17, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Hi ALL, I'm confused regarding numeric and multiple SIDs present in

Numeric SID

2001-02-17 Thread bipin sahani
Hi ALL, I'm confused regarding numeric and multiple SIDs present in V$SESSION for same USER# and USERNAME How is it possible?? As far as I know there should be one SID for every instance of oracle. Then how v$session shows me more than one SID for same user.And if all these numeric SIDs c