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
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
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
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
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
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
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
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.
>
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
-
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
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
11 matches
Mail list logo