Bind Variables in VB
All, Can anyone provide examples of how to issue an SQL statement in VB using Bind Variables (using DAO or ADO). Many thanks for any responses. Dave Leach Technical Services Claybrook Computing Internal ext * 4992 Phone * 01293 604992 Fax 01293 604029 E-Mail * [EMAIL PROTECTED] The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
Privileges
Hi, Can anyone point me in the direction of a list of privileges (version 8.1.7) and their meanings. Obviously most are self explanatory but there are a few I'm not too sure about. I tried using the Java Search facility in the Oracle documentation but this only points me to the relevant section and does not highlight where in the section the search words are. I have also tried Metalink and could not find a definitive list. Any help would be appreciated. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
Unix O/S Authentication
Hi, I want to connect to a Unix server (Solaris 8 for Intel) from an NT Workstation as SYSOPER (not SYSDBA) with authenticated performed by the OS. Can anyone tell me if this can be done and point me to any decent papers detailing how to do this. I've searched the documentation which comes with Oracle for Solaris 8 on Intel and cannot find a clear explanation of how to do this. I am familiar with how to do this on an NT server. Many thanks for any replies. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
Solaris Mailing List
Hi, Can anyone point me to a mailing list for Solaris? Any help appreciated. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
RE: Repost: Problems installing Solaris for Intel patch required
Peter,
Many
thanks for the reply on this, I'm still stuck. From reading the
administrators manual I think your spot on in that the message should not
matter, the problem is that the patch does not install (verifyed this by doing a
patchadd -p and showrev -p, so what do I do next, any
ideas??
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: 04 October 2001
01:10To: Multiple recipients of list ORACLE-LSubject:
Re: Repost: Problems installing Solaris for Intel patch required
forIf my memory serves
me right this is being caused by the fact that some packages that the patch
may apply to are not installed on your system. This is not in itself a problem unless you know you
need that package. You then need to locate it either on your install CD's or
download it form the Sun website. HTHPeter McLarty
E-mail: [EMAIL PROTECTED]Technical Consultant
WWW: http://www.Mincom.comAPAC Technical
Services Phone: +61 (0)7 3303 3461 Brisbane, Australia
Mobile: +61 (0)402 094
238 --
Facsimile: +61
(0)7 3303 3048
Dave Leach
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
10/03/01 07:45 PM Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]> cc:
Fax to: Subject:
Repost: Problems installing Solaris for Intel patch
required forHelp: I've tried the Sun web site but to no avail and I can't go no
further,I am using patchadd to install 2 patches (107545-03 and
106542-17) toSolaris for Intel, these patches are required for Oracle
8.1.6. I keepgetting the following message:Checking
installed patches...One or more patch packages included in107545-03
are not installed on this system.I assume that I am missing some
required packages but the release notes forthe patches do not mention
this, how can I determine what's missing andhence what I need to do to
overcome this?Many thanks for any help or lnks to any usefull web
sites,Dave
Leach**The
above information is confidential to the addressee and may be privileged.
Unauthorised access and use is prohibited.Internet
communications are not secure and therefore this Company doesnot accept
legal responsibility for the contents of this message.If you are not
the intended recipient, any disclosure, copying,distribution or any action
taken or omitted to be taken in reliance onit, is prohibited and may be
unlawful.Claybrook Computing Limited is a subsidiary of Claybrook
Computing (Holdings) LimitedRegistered Office: Abbey House. 282
Farnborough Road, Farnborough,Hampshire GU14 7NJRegistered in England
and Wales No 1287205A Hogg Robinson plc
company**--
Please see the official ORACLE-L FAQ: http://www.orafaq.com--
Author: Dave Leach INET: [EMAIL PROTECTED]Fat
City Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California -- Public
Internet access / Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing
list you want to be removed from). You mayalso send the HELP command
for other information (like subscribing).-- This transmission is for the intended addressee only and
is confidentialinformation. If you have received this transmission in
error, pleasedelete it and notify the sender. The contents of this e-mail
are theopinion of the writer only and are not endorsed by the Mincom
Groupof companies unless expressly stated
otherwise.
Repost: Problems installing Solaris for Intel patch required for
Help: I've tried the Sun web site but to no avail and I can't go no further, I am using patchadd to install 2 patches (107545-03 and 106542-17) to Solaris for Intel, these patches are required for Oracle 8.1.6. I keep getting the following message: Checking installed patches... One or more patch packages included in 107545-03 are not installed on this system. I assume that I am missing some required packages but the release notes for the patches do not mention this, how can I determine what's missing and hence what I need to do to overcome this? Many thanks for any help or lnks to any usefull web sites, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
Problems Installing a patch on Solaris for Intel
Apologies for asking another question on this (posted one yesterday) but I'm stuck, I am using patchadd to install 2 patches (107545-03 and 106542-17) to Solaris for Intel, these patches are required for Oracle 8.1.6. I keep getting the following message: Checking installed patches... One or more patch packages included in 107545-03 are not installed on this system. I assume that I am missing some required packages but the release notes for the patches do not mention this, how can I determine what's missing and hence what I need to do to overcome this? Many thanks for any help, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
How to apply patch to Solaris for Intel
Can anyone help!!, I've recently installed Solaris for Intel on a standalone box to have a "dabble" with. I want to install the patch 106542-17 so I can then install Oracle 8.1.6. The standalone machine does not have Internet access, and when downloading the patch to my PC running NT 4.0 the file is downloaded as a zip file. I can FTP the zip file across to the Solaris box but Solaris presumably has not concept of a zip file so what can I do to get this patch installed? Any help would be very appreciated, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
RE: How do you audit a DBA?
Thanks for all the serious and amusing replies on this, superb stuff!! Seriously, I raised this question just to cover my back so when I give my answer (the answer being NO!!) then no other bright spark can justifiably contradict it. Thanks again for your time, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
How do you audit a DBA?
Anyone who can help, I've been asked if Oracle can somehow audit the DBA ie. Raise an alert if the DBA were to execute DML statements against sensitive tables, this assumes the DBA has the SYS password. I thought this was a pretty reasonable question but couldn't think of an answer. My trail of though was maybe an email alert to a designated member of staff sent via a trigger on the table. Any comments would be very appreciated. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
Freeable memory Chunks
Hi all, When querying the view X$KSMSP can anyone tell me whether memory chunks with a value in KSMCHCLS of 'freeabl' can be used immediately. We currently have an application running against our database which is causing the ORA-4031 error. The app does not make use of shared sql and after flushing the shared pool within a few minutes the shared pool summary looks like this: CONTENTSCHUNKS RECREATABLE FREEABLE TOTAL - --- - - KGFF heap91336 4564 5900 KGK contexts 2 2376 2376 KGK heap 3 16996 560 17556 KGL handles 11305 2050328 2050328 KQLS heap 80 35360 45368 80728 LISTEN ADDRESS 2 1188 1188 PLS cca hp desc 1 164 164 PLS non-lib hp 120962096 character set m 6 31196 31196 dictionary cach 87127776127776 fixed allocatio 20 640 640 free memory 5126 1736532 joxs heap19292 kzull 28 1456 1456 library cache11695 1131164 4434300 5565464 listener addres 11616 permanent memor 8 5829368 row cache lru 2310121012 session param v 26 93288 93288 sql area 20517 842020 11812896 12654916 table columns 18 15736 15736 In a few minutes the sql area has risen from 200 chunks to 20517. It appears that approx 12Mb of chunks associated to slq area are freeable, so are these chunks usable in which case the error must be caused by the size of the available chunks? Many thanks for any replies, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
RE: Users & Schema's
Many thanks for all the replies on this, it is indeed a documented parameter under the ALTER SESSION command. I can't believe I missed this bearing in mind the time I spent searching. My sanity is restored for now!! Dave Leach -Original Message- Sent: 22 August 2001 11:32 To: Multiple recipients of list ORACLE-L Dave, You can use the following : alter session set current_schema = USERB Check out the SQL Reference manual - Chapter 7 SQL Statements, ALTER SESSION (page 387) HTH Mark -Original Message- Sent: Wednesday, August 22, 2001 11:02 To: Multiple recipients of list ORACLE-L Help!!, Can anyone shed some light on this or am I just going mad!!. We have a situation whereby multiple users need to access (both selects and dml) tables belonging to 1 specific schema, this must also be achieved without prefixing the tables with the userid as the SQL is driven by the application and is not configurable. My original idea was to use synonyms but I am sure that I have read somewhere that in 8i there was an alternative to this whereby a user can be set up to use another users schema eg. USERA when logged on will effectively be treated as if they are logged on as USERB. I have searched every bit of documentation I can find (manuals, metalink etc) but can find no mention of this, have I just dreamn't this or can someone shed some light. Many thanks for any replies. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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: Mark Leith 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: Dave Leach 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).
FW: Users & Schema's
-Original Message- Sent: 22 August 2001 10:42 To: 'Rahul' Fantastic, what a relief!! I have just looked this up on Metalink and have read a note saying this is an undocumented parameter, I'm now in 2 minds as to whether to use it, although it sounds exactly what we want. Many thanks again, Dave Leach -Original Message- Sent: 22 August 2001 10:29 To: '[EMAIL PROTECTED]' Cc: Dave Leach are we talking about alter user set current_schema = new schema ? you require a BECOME USER priv for this > ------ > From: Dave Leach[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Wednesday, August 22, 2001 5:01 PM > To: Multiple recipients of list ORACLE-L > Subject: Users & Schema's > > Help!!, > > Can anyone shed some light on this or am I just going mad!!. > > We have a situation whereby multiple users need to access (both selects > and > dml) tables belonging to 1 specific schema, this must also be achieved > without prefixing the tables with the userid as the SQL is driven by the > application and is not configurable. > > My original idea was to use synonyms but I am sure that I have read > somewhere that in 8i there was an alternative to this whereby a user can > be > set up to use another users schema eg. USERA when logged on will > effectively > be treated as if they are logged on as USERB. I have searched every bit > of > documentation I can find (manuals, metalink etc) but can find no mention > of > this, have I just dreamn't this or can someone shed some light. > > Many thanks for any replies. > > Dave Leach > > > ** > The above information is confidential to the addressee and may be > privileged. Unauthorised access and use is prohibited. > > Internet communications are not secure and therefore this Company does > not accept legal responsibility for the contents of this message. > > If you are not the intended recipient, any disclosure, copying, > distribution or any action taken or omitted to be taken in reliance on > it, is prohibited and may be unlawful. > > Claybrook Computing Limited is a subsidiary of > Claybrook Computing (Holdings) Limited > Registered Office: Abbey House. 282 Farnborough Road, Farnborough, > Hampshire GU14 7NJ > Registered in England and Wales No 1287205 > > A Hogg Robinson plc company > ** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dave Leach > 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: Dave Leach 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).
Users & Schema's
Help!!, Can anyone shed some light on this or am I just going mad!!. We have a situation whereby multiple users need to access (both selects and dml) tables belonging to 1 specific schema, this must also be achieved without prefixing the tables with the userid as the SQL is driven by the application and is not configurable. My original idea was to use synonyms but I am sure that I have read somewhere that in 8i there was an alternative to this whereby a user can be set up to use another users schema eg. USERA when logged on will effectively be treated as if they are logged on as USERB. I have searched every bit of documentation I can find (manuals, metalink etc) but can find no mention of this, have I just dreamn't this or can someone shed some light. Many thanks for any replies. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
RE: Oracle Internet Structure
Many thanks to all who replied on this, this is a great help. Dave Leach -Original Message- Sent: 12 July 2001 11:45 To: Multiple recipients of list ORACLE-L Hi, I realize I'm way behind on this but can anyone point me to any links which describe the components that make up Oracle's Application Server in a novice way. The sort of things I'm looking for are In simple terms what is an Apps server? What is an Apache Server and how does this integrate with the Apps server? What is the difference between a Web site and Portal? What third party technologies are used with Oracle Apps server?. I have looked on OTN but cannot find something which describes the structure at the level required (ie. a complete novice) As I say I'm a complete novice in this area but our company is just starting to look at a web based solution and I want to get an understanding of what's involved and how this may effect me as a DBA. Any help would be appreciated. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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: Dave Leach 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).
RE: ONS Install - my life is at an end
Ross, Don't know if this will help but I successfully installed ONS on 8.0.5 for NT about 18 months ago and documented the procedure. I have attached the document if this helps. Ignore the initial few paragraphs on Net8 Assistant. Dave Leach -Original Message- Sent: 12 July 2001 23:47 To: Multiple recipients of list ORACLE-L Ok, so no one liked the InterMedia Question, so let's forget that one. How about this? ONS, ver817namesctl installs and builds OK, but I cannot get names (name server) to run.if i run the make manually, it claims to be missing libnon8.a Sure enough, it's not on the file system. Any one run into this? I didnot find anything on MetaRetch, and R'ing the FM did not help... Thanks in advance! - Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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). ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** onames.doc
Oracle Internet Structure
Hi, I realize I'm way behind on this but can anyone point me to any links which describe the components that make up Oracle's Application Server in a novice way. The sort of things I'm looking for are In simple terms what is an Apps server? What is an Apache Server and how does this integrate with the Apps server? What is the difference between a Web site and Portal? What third party technologies are used with Oracle Apps server?. I have looked on OTN but cannot find something which describes the structure at the level required (ie. a complete novice) As I say I'm a complete novice in this area but our company is just starting to look at a web based solution and I want to get an understanding of what's involved and how this may effect me as a DBA. Any help would be appreciated. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
RE: strange explain plan
Gene, This is not much help I'm afraid but are the statistics etc on both the old and new table at the same stage (preferrable both up to date)?. I've tried to recreate this on NT with no success, keep me informed. Dave Leach -Original Message- Sent: 06 July 2001 14:36 To: Multiple recipients of list ORACLE-L Hi. This is a second attempt. My first Email never got posted. I have the following query: select a1.MBR_TYP_CDE MBR_TYP_CDE, (COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD )) DISTINCTALLMERCHCO from MDSS_STAR.NOVUS_NETWRK_MBR_D a1 group by a1.MBR_TYP_CDE The explain plan for it is as follows: 0-0-5898 1.5898 SELECT STATEMENTSQL1 Cost = 5898 1-0-1 2.1 SORT GROUP BY 2-1-1 3.1 SORT GROUP BY 3-2-14.1 SORT GROUP BY 4-3-1 5.1 TABLE ACCESS FULL NOVUS_NETWRK_MBR_D It has three group by's and the query fails with 0ra-0600 [15851]. when I create a new table as select * from the old table the plan changes: 0-0-9721 1.9721 SELECT STATEMENTSQL1 Cost = 9721 1-0-1 2.1 SORT GROUP BY 2-1-1 3.1 TABLE ACCESS FULL NOVUS_NETWRK_MBR_D_TMP and the query works. Does anyone have any guess as to what is going on? thank you for any help Gene = __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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). ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
Index Behaviour
Hi, In the following query "membno" is a Non Unique Indexed field: select surnam from basic where membno <> 10. Whether the table is analyzed or not the Explain Plan still shows a Full Table Scan unless I specify a Hint to use the Index. Using the index is more costly so I would expect CBO to always do a FTS unless the hint is specified. But without a hint why does RBO do a FTS and ignore the index? Platform NT Version 8.1.7.0.0 Optimizer Mode is Choose: Many thanks for any replies Dave Leach PS. Like the Bear stories, being brought up in London we miss out on all this. ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
SYSSTAT statistics
DBA's, Can anyone shed some light on the following query. I have performed a single column update on 1 row (update basic set col1 = 9998 where col1 = 9). The following stats were displayed prior to the update: consistent gets 15291 db block changes 199 db block gets 1120 After the update the stats were as follows: consistent gets 15350 db block changes 209 db block gets 1136 My question is what is it that causes the 'consistent gets' figure to increase, I was under the impression that all blocks would be acquired in current mode. Many thanks for any replies. Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach 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).
RE: Partition Elimination
Many thanks for the replies on this. I was indeed using autotrace instead of doing an explain plan with utlxpls. I have also found the detail I was looking for in the documentation (can't beleive I didn't seee it before, it must have been a long day!!). Cheers, Dave Leach -Original Message- Sent: 31 May 2001 18:22 To: Multiple recipients of list ORACLE-L Oracle could be doing partition elimination but the tools that you are using to see the execution plan is not showing you the details you're looking for. I usually do: Truncate table plan_table; explain plan for ; select * from plan_table; There should be two columns that indicate the partition-start_number and the partition_stop_number for this full table scan. If it's not working let's know. Regards, Waleed -Original Message- Sent: Thursday, May 31, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Hi All, Can anyone help me with this. I have range partitioned a table (no indexes) and then computed statistics. I have now queried the table using the partition key as the only criteria in the where clause. Why does Oracle still do a full table scan, why is it not clever enough to only scan the partition(s) effected by the where condition?. The Oracle documentation gives a good insight into partitioning but does not go into detail about when partition elimination will be performed and what the explain plan would look like when this occurs. If anyone can point me to a section of the documentation that covers this I would be grateful. Many Thanks, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Hogg Robinson PLC Registered Office: Abbey House, 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 3249700 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Khedr, Waleed 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). ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Hogg Robinson PLC Registered Office: Abbey House, 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 3249700 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Partition Elimination
Hi All, Can anyone help me with this. I have range partitioned a table (no indexes) and then computed statistics. I have now queried the table using the partition key as the only criteria in the where clause. Why does Oracle still do a full table scan, why is it not clever enough to only scan the partition(s) effected by the where condition?. The Oracle documentation gives a good insight into partitioning but does not go into detail about when partition elimination will be performed and what the explain plan would look like when this occurs. If anyone can point me to a section of the documentation that covers this I would be grateful. Many Thanks, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Hogg Robinson PLC Registered Office: Abbey House, 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 3249700 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
No Subject
SET ORACLE-L DIGEST ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Hogg Robinson PLC Registered Office: Abbey House, 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 3249700 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
