Re: more questions
On 2003.09.07 05:19, Mogens Nørgaard wrote: Another fun fact about the OS390 port: If you set max dumb ( :) ) file size to 50 MB, then the session will write 50MB, close the file, open another one, and continue writing trace data to this one, and so one, until the session is done. I'm not an MVS expert, as a matter of fact, I haven't worked with MVS for 15 years. Normally, when I want to have a large trace file I do oradebug unlimit. Is it available on MVS? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: more questions
Another fun fact about the OS390 port: If you set max dumb ( :) ) file size to 50 MB, then the session will write 50MB, close the file, open another one, and continue writing trace data to this one, and so one, until the session is done. Tim Gorman wrote: As an interesting side note, Oracle on MVS/OS390 offers multiplexing of datafiles, since at least Oracle v6, I believe. It's just something that never made the jump to other ports, I guess... on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote: how to startup oracle after machine is bootup? you must configure your /etc/oratab Ans: add this line your_sid:your_oracle_home:AUTO(auto is keyword) how to shutdown oracle before Unix is shutdown? Ans: I don't think that Oracle provide such feature, but you can write OS script add to your in your init.d or simpler way replace your init binary file with your own for example # init 6 your new init /where is my shutdown script/shutdown oracle.sh /or perhaps you want to shutdown listener too or other application do it here/bla.sh sync sync original_init $1 It seems to me that I cannot multiplex data files. Is that true? Ans: Yes Oracle only allow you to multiplex your control files and redolog files but not your data files, however Oracle do recommend you to do RAID 0 + 1 if you have the $$$. Sinardy -Original Message- Sent: 02 September 2003 11:29 To: Multiple recipients of list ORACLE-L Hi Greetings, We are using solaris. I wonder how to startup oracle after machine is bootup and how to shutdown oracle before unix is shutdown? I know how to multiplex control files and redo files. It seems to me that I cannot multiplex data files. Is that true? Thanks! Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: more questions -- "multiplexing of datafiles"
See the ASM feature of Oracle 10g. http://otn.oracle.com/oramag/oracle/03-sep/o5310gcover_storage.html Oracle handles virtualisation and redistribution of datafiles and also provides mirroring of datafiles. Hemant At 07:59 AM 04-09-03 -0800, you wrote: As an interesting side note, Oracle on MVS/OS390 offers multiplexing of datafiles, since at least Oracle v6, I believe. It's just something that never made the jump to other ports, I guess... on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote: > how to startup oracle after machine > is bootup? > you must configure your /etc/oratab > Ans: > add this line > your_sid:your_oracle_home:AUTO(auto is keyword) > > > how to shutdown oracle before Unix is shutdown? > Ans: > I don't think that Oracle provide such feature, but you can write OS script > add to your in your init.d > > or simpler way replace your init binary file with your own > for example > > # init 6 > > your new init > > /where is my shutdown script/shutdown oracle.sh > /or perhaps you want to shutdown listener too or other application do it > here/bla.sh > sync > sync > original_init $1 > > It seems to me that I cannot multiplex data files. Is that true? > > Ans: > > Yes Oracle only allow you to multiplex your control files and redolog files > but not your data files, however > Oracle do recommend you to do RAID 0 + 1 if you have the $$$. > > > Sinardy > > > > > > -Original Message- > Sent: 02 September 2003 11:29 > To: Multiple recipients of list ORACLE-L > > > Hi Greetings, > > We are using solaris. I wonder how to startup oracle after machine > is bootup and how to shutdown oracle before unix is shutdown? > I know how to multiplex control files and redo files. It seems to > me that I cannot multiplex data files. Is that true? > > Thanks! > Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: more questions
As an interesting side note, Oracle on MVS/OS390 offers multiplexing of datafiles, since at least Oracle v6, I believe. It's just something that never made the jump to other ports, I guess... on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote: > how to startup oracle after machine > is bootup? > you must configure your /etc/oratab > Ans: > add this line > your_sid:your_oracle_home:AUTO(auto is keyword) > > > how to shutdown oracle before Unix is shutdown? > Ans: > I don't think that Oracle provide such feature, but you can write OS script > add to your in your init.d > > or simpler way replace your init binary file with your own > for example > > # init 6 > > your new init > > /where is my shutdown script/shutdown oracle.sh > /or perhaps you want to shutdown listener too or other application do it > here/bla.sh > sync > sync > original_init $1 > > It seems to me that I cannot multiplex data files. Is that true? > > Ans: > > Yes Oracle only allow you to multiplex your control files and redolog files > but not your data files, however > Oracle do recommend you to do RAID 0 + 1 if you have the $$$. > > > Sinardy > > > > > > -Original Message- > Sent: 02 September 2003 11:29 > To: Multiple recipients of list ORACLE-L > > > Hi Greetings, > > We are using solaris. I wonder how to startup oracle after machine > is bootup and how to shutdown oracle before unix is shutdown? > I know how to multiplex control files and redo files. It seems to > me that I cannot multiplex data files. Is that true? > > Thanks! > Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: more questions
Check with http://download-west.oracle.com/docs/html/A96167_01/post-inst.htm#sthref548 Make sure to shutdown/start related stuff (viz OAS) that might have been installed too. Also, on some UNIX systems, NFS file system from Server A might have been mounted on Server B. If so, you need to shutdown the database first, umount the file system, then shutdown. Upon starting Server, the bootstrap script to mount the file system (share it), followed by starting of the database. You can modify the script in such a way that, if the FS is not mounted, page the DBA, donot start the Database. Also, the shutdown script normaly has SHUTDOWN ; change it to SHUTDOWN IMMEDIATE / SHUTDOWN ABORT depending on what you prefer. HTH GovindanK >Hi Greetings, > > We are using solaris. I wonder how to startup oracle after machine > is bootup and how to shutdown oracle before unix is shutdown? > I know how to multiplex control files and redo files. It seems to > me that I cannot multiplex data files. Is that true? > > Thanks! > Jin > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: CHEN,JIN > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: more questions
how to startup oracle after machine is bootup? you must configure your /etc/oratab Ans: add this line your_sid:your_oracle_home:AUTO(auto is keyword) how to shutdown oracle before Unix is shutdown? Ans: I don't think that Oracle provide such feature, but you can write OS script add to your in your init.d or simpler way replace your init binary file with your own for example # init 6 your new init /where is my shutdown script/shutdown oracle.sh /or perhaps you want to shutdown listener too or other application do it here/bla.sh sync sync original_init $1 It seems to me that I cannot multiplex data files. Is that true? Ans: Yes Oracle only allow you to multiplex your control files and redolog files but not your data files, however Oracle do recommend you to do RAID 0 + 1 if you have the $$$. Sinardy -Original Message- Sent: 02 September 2003 11:29 To: Multiple recipients of list ORACLE-L Hi Greetings, We are using solaris. I wonder how to startup oracle after machine is bootup and how to shutdown oracle before unix is shutdown? I know how to multiplex control files and redo files. It seems to me that I cannot multiplex data files. Is that true? Thanks! Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CHEN,JIN INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: more questions
Hi Tanel, I can't remember what is the correct procedure about auto startup Oracle. I think you are right is located in /var/opt/oracle (my clustering software does it for me by comfiguring this oratab) perhaps Jin can read the manual about startup and shutdown, I remember there is one small chapter special for this in DB Administration doc. I read from Unix administration book long ago, the author said something like this replace the rm binary to something like this: cp rm .rm.original echo ".rm.original -i" > rm May be is not a good book, I don't know... Sinardy -Original Message- Sent: 02 September 2003 17:54 To: Multiple recipients of list ORACLE-L Hi! > how to startup oracle after machine > is bootup? > you must configure your /etc/oratab > Ans: > add this line > your_sid:your_oracle_home:AUTO(auto is keyword) Y or N are the keywords. I don't remember that auto has been mentioned anywhere. I didn't find any occurrence it in dbstart either. So where is this coming from? And the OP is using Solaris, thus his oratab file is under /var/opt/oracle. > or simpler way replace your init binary file with your own > for example Yeah right, lets just modify kernel binary instead!? Do you really do this kind of stuff at your work? Really spooky... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Re: more questions
Hi! > how to startup oracle after machine > is bootup? > you must configure your /etc/oratab > Ans: > add this line > your_sid:your_oracle_home:AUTO(auto is keyword) Y or N are the keywords. I don't remember that auto has been mentioned anywhere. I didn't find any occurrence it in dbstart either. So where is this coming from? And the OP is using Solaris, thus his oratab file is under /var/opt/oracle. > or simpler way replace your init binary file with your own > for example Yeah right, lets just modify kernel binary instead!? Do you really do this kind of stuff at your work? Really spooky... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
re: more questions about temp.
Ron, 1)Those temp data files to be removed from OS manually. make sure that temp tablespace dropped successfully. 2) for temporary temp tablespace datafiles are shown in dba_temp_files view (if tablespace is not dropped) HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 08 Nov 2002 07:39:02 -0800 list, additional information that needs clarification. After the Temporary tablespace fubar had been dropped the datafile still existed on the OS level. If you have space problems be sure to look at both your permanant and temporary tablespaces. Temporary tablespace do NOT show up in the dba_data_files view. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
re: more questions about temp.
list, additional information that needs clarification. After the Temporary tablespace fubar had been dropped the datafile still existed on the OS level. If you have space problems be sure to look at both your permanant and temporary tablespaces. Temporary tablespace do NOT show up in the dba_data_files view. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: more questions about SID
The address, hash_value and sql_hash_value columns are used to find the
currently executing SQL for the session.
As the SQL clearly shows, the SID, is stored in v$session. These are pretty
dynamic values for sessions, as they are updated regularly, that is why they
are stored in these dynamic tables.
HTH
Mark
-Original Message-
sahani
Sent: Tuesday, February 20, 2001 04:30
To: Multiple recipients of list ORACLE-L
Thankx Mark,
That was info. which I'm looking for.Can U pls.
expalin me what is hash_value,address,sql_hash_value
And where is SYSTEM ID is stored in Oracle
Regards
Bipin
--- DIRCON <[EMAIL PROTECTED]> wrote: > Howe about
this little ditty:
>
> select s.sid sid, c.sql_text sql_text, c.address
> address,
> ltrim(to_char(c.hash_value,'99'),' ')
> hash_value
> from v$open_cursor c, v$session s
> where c.saddr = s.saddr and c.hash_value !=
> s.sql_hash_value and s.username
> = 'YOUR_USER_NAME'
>
> This should give you all SQL being executed by your
> user name, unless all
> users log on to an app, that then uses the same
> username to access the
> database. In this case, you could change s.username
> to OSUSER, if known, or
> in fact TERMINAL. You should know these for your own
> PC..
>
> Is this what you are looking for?
>
> Regards
>
> Mark
>
> -Original Message-
> sahani
> Sent: Monday, February 19, 2001 02:31
> To: Multiple recipients of list ORACLE-L
>
>
> Thankx for info.
>
> But these SID are unique for each oracle user.They
> can't be distingish if 10 persons using same Oracle
> login and issuing 10 different queries.
>
> I want to know SID for a specific query issued by
> me.
>
> Is there a way to find it out???
>
> Thankx and regards
> Bipin
> --- "Trassens, Christian" <[EMAIL PROTECTED]> wrote:
> >
> You have some options:
> >
> > select sid from v$mystat
> > where rownum=1;
> >
> > If the user has privilege to access
> sys.v_$session,
> > then you can issue:
> >
> > select sid from v$session
> > where audsid=userenv('SESSIONID');
> >
> > However connected as internal the
> > userenv('SESSIONID') gives you a 0. Hence,
> > you couldn't recognize the sid.
> >
> > Regards.
> >
> > > -Mensaje original-
> > > De: bipin sahani [SMTP:[EMAIL PROTECTED]]
> > > Enviado el: sábado 17 de febrero de 2001 12:56
> > > Para: Multiple recipients of list ORACLE-L
> > > Asunto: Re:Thankx and more questions about SID
> > >
> > > 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.
> > > >
> > > > 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
> > > >
> > > > - Original Message -
> > > > To: "Multiple recipients of list ORACLE-L"
> > > > <[EMAIL PROTECTED]>
> > > > Sent: Saturday, February 17, 2001 13:55
> > > >
> > > >
> > > > > 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
> > > > > correspond to one alphanumeric SID
> > > > > which is SID of that instance then where is
> > the
> > > > > mapping between numeric and alpha numeric
> SID?
> > > > >
> > > > >
> > > > > Thankx and regards
> > > > > Bipin
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
> > > > > Do You Yahoo!?
> > > > > Get your free @yahoo.co.in address at
> > > > http://mail.yahoo.co.in
> > > > > --
> > > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > > --
> > > > > Author: =?iso-8859-1?q?bipin=20sahani?=
> > > > > 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
> > > > > al
RE: more questions about SID
Thankx Mark,
That was info. which I'm looking for.Can U pls.
expalin me what is hash_value,address,sql_hash_value
And where is SYSTEM ID is stored in Oracle
Regards
Bipin
--- DIRCON <[EMAIL PROTECTED]> wrote: > Howe about
this little ditty:
>
> select s.sid sid, c.sql_text sql_text, c.address
> address,
> ltrim(to_char(c.hash_value,'99'),' ')
> hash_value
> from v$open_cursor c, v$session s
> where c.saddr = s.saddr and c.hash_value !=
> s.sql_hash_value and s.username
> = 'YOUR_USER_NAME'
>
> This should give you all SQL being executed by your
> user name, unless all
> users log on to an app, that then uses the same
> username to access the
> database. In this case, you could change s.username
> to OSUSER, if known, or
> in fact TERMINAL. You should know these for your own
> PC..
>
> Is this what you are looking for?
>
> Regards
>
> Mark
>
> -Original Message-
> sahani
> Sent: Monday, February 19, 2001 02:31
> To: Multiple recipients of list ORACLE-L
>
>
> Thankx for info.
>
> But these SID are unique for each oracle user.They
> can't be distingish if 10 persons using same Oracle
> login and issuing 10 different queries.
>
> I want to know SID for a specific query issued by
> me.
>
> Is there a way to find it out???
>
> Thankx and regards
> Bipin
> --- "Trassens, Christian" <[EMAIL PROTECTED]> wrote:
> >
> You have some options:
> >
> > select sid from v$mystat
> > where rownum=1;
> >
> > If the user has privilege to access
> sys.v_$session,
> > then you can issue:
> >
> > select sid from v$session
> > where audsid=userenv('SESSIONID');
> >
> > However connected as internal the
> > userenv('SESSIONID') gives you a 0. Hence,
> > you couldn't recognize the sid.
> >
> > Regards.
> >
> > > -Mensaje original-
> > > De: bipin sahani [SMTP:[EMAIL PROTECTED]]
> > > Enviado el: sábado 17 de febrero de 2001 12:56
> > > Para: Multiple recipients of list ORACLE-L
> > > Asunto: Re:Thankx and more questions about SID
> > >
> > > 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.
> > > >
> > > > 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
> > > >
> > > > - Original Message -
> > > > To: "Multiple recipients of list ORACLE-L"
> > > > <[EMAIL PROTECTED]>
> > > > Sent: Saturday, February 17, 2001 13:55
> > > >
> > > >
> > > > > 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
> > > > > correspond to one alphanumeric SID
> > > > > which is SID of that instance then where is
> > the
> > > > > mapping between numeric and alpha numeric
> SID?
> > > > >
> > > > >
> > > > > Thankx and regards
> > > > > Bipin
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
> > > > > Do You Yahoo!?
> > > > > Get your free @yahoo.co.in address at
> > > > http://mail.yahoo.co.in
> > > > > --
> > > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > > --
> > > > > Author: =?iso-8859-1?q?bipin=20sahani?=
> > > > > 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).
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > --
> > > > Author: Arun Aggarwal
> > > > INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051
> > FAX:
> > > > (858) 538-5051
> > > > San Diego, California-- Public
> Internet
> > > > access /
RE: more questions about SID
Howe about this little ditty:
select s.sid sid, c.sql_text sql_text, c.address address,
ltrim(to_char(c.hash_value,'99'),' ') hash_value
from v$open_cursor c, v$session s
where c.saddr = s.saddr and c.hash_value != s.sql_hash_value and s.username
= 'YOUR_USER_NAME'
This should give you all SQL being executed by your user name, unless all
users log on to an app, that then uses the same username to access the
database. In this case, you could change s.username to OSUSER, if known, or
in fact TERMINAL. You should know these for your own PC..
Is this what you are looking for?
Regards
Mark
-Original Message-
sahani
Sent: Monday, February 19, 2001 02:31
To: Multiple recipients of list ORACLE-L
Thankx for info.
But these SID are unique for each oracle user.They
can't be distingish if 10 persons using same Oracle
login and issuing 10 different queries.
I want to know SID for a specific query issued by me.
Is there a way to find it out???
Thankx and regards
Bipin
--- "Trassens, Christian" <[EMAIL PROTECTED]> wrote: >
You have some options:
>
> select sid from v$mystat
> where rownum=1;
>
> If the user has privilege to access sys.v_$session,
> then you can issue:
>
> select sid from v$session
> where audsid=userenv('SESSIONID');
>
> However connected as internal the
> userenv('SESSIONID') gives you a 0. Hence,
> you couldn't recognize the sid.
>
> Regards.
>
> > -Mensaje original-
> > De: bipin sahani [SMTP:[EMAIL PROTECTED]]
> > Enviado el: sábado 17 de febrero de 2001 12:56
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Re:Thankx and more questions about SID
> >
> > 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.
> > >
> > > 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
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L"
> > > <[EMAIL PROTECTED]>
> > > Sent: Saturday, February 17, 2001 13:55
> > >
> > >
> > > > 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
> > > > correspond to one alphanumeric SID
> > > > which is SID of that instance then where is
> the
> > > > mapping between numeric and alpha numeric SID?
> > > >
> > > >
> > > > Thankx and regards
> > > > Bipin
> > > >
> > > >
> > > >
> > >
> >
>
> > > > Do You Yahoo!?
> > > > Get your free @yahoo.co.in address at
> > > http://mail.yahoo.co.in
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > > --
> > > > Author: =?iso-8859-1?q?bipin=20sahani?=
> > > > 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).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Arun Aggarwal
> > > 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).
> >
> >
> >
>
> > Do You Yahoo!?
> > Get your free
