Is there any ThumbRule for Shared Pool calculation ?
Hi Folks, For Oracle Version 8.1.0 and above, Is there any Shared Pool calculation for Concurrent users >100? Oracle running in Dedicated mode. The below mentioned is Shared pool calculation for Oracle ver 7.x Server running in Dedicated mode. Formula --- Max Session Memory * No. of concurrent users + Total Shared SQL Area Usage + PLSQL Sharable Memory + Minimum 30% Free Space -- = Minimum Allowable Shared Pool Is something like this available for Version 8.1.0 and above? Regards Satish The Information contained and transmitted by this E-MAIL is proprietary to Wipro Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail & notify us immediately at [EMAIL PROTECTED]
Re: 8.1.6. on Linux installation problem
Try the linux dist from www.blackthorne.org. It worked for me on SuSE 7.1 Jared On Sunday 29 July 2001 21:30, Okan CIMEN wrote: > Hello > > When I try to install Oracle 8.1.6 for Linux, I get a message saying; > Initializing Java Virtual Machine from > ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre >. Please wait... > > and installation does not even start. I thought that the problem's reason > is my box's JRE release is 1.3.1. > > Any recommendations? > > Okan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Urgent..DB creation problem..
there are two parameters infact that need to be removed(commented) from init file. mts_dispatcher mts_server thanks for all replies. problem goes away. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, July 30, 2001 12:20 AM > Look at the parameter mts_dispatcher in the init.ora. > Probably you'll see this: > > mts_dispatchers = > "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)" > > I suggest you to choose on the Database Assistant the > option of generating the scripts. And before running > these, renmark the parameter. > > Regards. > --- Saurabh Sharma <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > i'm having a problem in creating new database > > through database config assistant. after giving all > > information (both in typical and custom mode) it > > starts creating DB, but soon shows the msg "invalid > > specification for mts_dispatcher in initSID.ora > > file.." > > > > while there is no DB on the server, how is it > > reading the init.ora file. i've not specified any > > new mts_dispatcher parameter value. > > why it is showing me the error msg. how to counter > > this. > > other errors are oracle not available. > > > > error code ORA-00101 invalid specification for > > system parameter MTS_DISPATCHERS > > > > Saurabh Sharma > > > > [EMAIL PROTECTED] > > http://www.geocities.com/saurabh00pc/stride.html > > > > > > > = > Eng. Christian Trassens > Senior DBA > Systems Engineer > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : 541149816062 > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Christian Trassens > 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: Saurabh Sharma 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).
Lock contention
Hello, How do I find out the sessions in the systems that are waiting for locks and corresponding locks. In other words, how, an sql script will really help, will provide me if a lock contention is going on? rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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).
8.1.6. on Linux installation problem
Hello When I try to install Oracle 8.1.6 for Linux, I get a message saying; Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre. Please wait... and installation does not even start. I thought that the problem's reason is my box's JRE release is 1.3.1. Any recommendations? Okan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Okan CIMEN 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: RE: CURSOR_SHARING = FORCE
Larry, On 8.1.7.1.5 W2K Pro SP1 No errors: SQL> select 'x ' from dual; 'X -- x SQL> select ' x' from dual; 'X -- x SQL> alter system set cursor_sharing=force; System altered. SQL> Select 'x ' from dual; 'X' x SQL> Select ' x' from dual; 'X' x SQL> This is in a simple test database. If I try it on 8.1.7.1.4 NT4 SP6a - (different parameters, different database) then I get a SQL> select 'x ' from dual; 'X -- x SQL> select ' x' from dual; 'X -- x SQL> alter system set cursor_sharing=force; System altered. SQL> Select 'x ' from dual; Select 'x ' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [546660348], [], [], [], [], [], [] Regards, Bruce Reardon -Original Message- Sent: Saturday, 28 July 2001 9:16 Thanks to all who replied. So maybe it *is* a combination of things. Here's a recap: 8.1.7.0.0 W2k Ser SP2 Failure 8.1.7.0.0 W2k Pro SP2 Failure 8.1.7.0.0 W2k Pro SP1 Failure 8.1.7.1.1 W2K Pro SP2 Success 8.1.7.1.1 NT ? ? Failure 8.1.7.1.3 W2K ? ? Failure 8.1.7.1.? HP-UX 11.0 Success I'll ring the DBA sometime next week and find out what Oracle has to say. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
Urgent
So how does oracle come to know the names of the smon process, like in a default installtion, it will be, ora_smon_orcl815, how does oracle come to know this name; also if this process is goes down, how does oracle come to know that smon is down, can I find this smon name in some initialization parameter eg or can i find from some other source, what is the smon process name? also how do I find out how to find process name for smon eg? raj -- On Sun, 29 Jul 2001 19:00:23 Joe Testa wrote: >they start when oracle starts, they are forked from the oracle >executable. > >joe >Viraj Luthra wrote: >> >> Hello all, >> >> A very basic question; the background processes, smon, pmon, etc. do they have an >executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do >they start? like eg. BMC' Patrol agent when it runs is run because there is an >executable called PatrolAgent, is it the same with the background processes, and if >yes where is the location of that executable? >> >> Is there a v$ synonym which has the same fields as sys.file$? >> >> Please reply urgently to above. >> >> rgds, >> >> raja >> >> Get 250 color business cards for FREE! >> http://businesscards.lycos.com/vp/fastpath/ >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Viraj Luthra >> 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) > >-- >Joe Testa >Performing Remote DBA Services, need some backup DBA support? >For Sale: Oracle-dba.com domain, its not going cheap but feel free to >ask :) >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Joe Testa > 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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: Cache Object
they start when oracle starts, they are forked from the oracle executable. joe Viraj Luthra wrote: > > Hello all, > > A very basic question; the background processes, smon, pmon, etc. do they have an >executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do >they start? like eg. BMC' Patrol agent when it runs is run because there is an >executable called PatrolAgent, is it the same with the background processes, and if >yes where is the location of that executable? > > Is there a v$ synonym which has the same fields as sys.file$? > > Please reply urgently to above. > > rgds, > > raja > > Get 250 color business cards for FREE! > http://businesscards.lycos.com/vp/fastpath/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > 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) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
Urgent: Need help
Hello all, A very basic question; the background processes, smon, pmon, etc. do they have an executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do they start? like eg. BMC' Patrol agent when it runs is run because there is an executable called PatrolAgent, is it the same with the background processes, and if yes where is the location of that executable? Is there a v$ synonym which has the same fields as sys.file$? Please reply urgently to above. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: Cache Object
Hello all, A very basic question; the background processes, smon, pmon, etc. do they have an executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do they start? like eg. BMC' Patrol agent when it runs is run because there is an executable called PatrolAgent, is it the same with the background processes, and if yes where is the location of that executable? Is there a v$ synonym which has the same fields as sys.file$? Please reply urgently to above. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: Cache Object
NOT Hamid Alavi wrote: > > Hi All, > > I have a question regarding Cache Object in Memory, If I want to Cache a > large data table in the memory i know it will much faster but what happen > if server crash, in this case all modification on table will be gone or NOT. > Any idea about cashing tables not only lookup tables realy appreciated. > > Hamid > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > 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: David A. Barbour 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: Avoiding Duplicates and Transitive Operations
Ian, love those "caffeine free moments", don't you? As the project manager for one of the databases I messed up (you try accidentally dropping a production tablespace in the middle of the day when you only do cold backups and are in noarchivelog mode) said: "that concludes your mistakes for the next 5 years" Nice to get it out of the way, no? Rachel >From: "MacGregor, Ian A." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Avoiding Duplicates and Transitive Operations >Date: Sun, 29 Jul 2001 09:06:01 -0800 > >Mr. MacGregor would like to recall his posts on this subject. His brain >has failed regression testing. He feels that Real Application Clusters >will solve his lapses into silliness. > >Ian MacGregor >Stanford Linear Accelerator Center >[EMAIL PROTECTED] > >-Original Message- >Sent: Friday, July 27, 2001 4:56 PM >To: Multiple recipients of list ORACLE-L > > >Suppose you have the following tables: > >SQL> select * from test1; > >C1 C2 >- -- > 1 Hello > > >SQL> select * from test2; > >C1 C2 >- -- > 1 Bye > 1 So long > >and you wanted to get distinct records from test1 wherever test1.c1 = >test2.1 > >You could > >Select distinct a.c1, a.c2 from ian.test1 a, ian.TEST2 B > where a.c1 = b.c1 >/ > > C1 C2 > -- >1 Hello > >real: 1531 > >execution Plan >- > 0 SELECT STATEMENT Optimizer=CHOOSE > 10 SORT (UNIQUE) > 21 MERGE JOIN > 32 SORT (JOIN) > 43 TABLE ACCESS (FULL) OF 'TEST2' > 52 SORT (JOIN) > 65 TABLE ACCESS (FULL) OF 'TEST1' > >However anytime you see a distinct clause, you should think, "Hey >there's probably something wrong here." > >A better way to handle the query is > >SELECT C1, C2 FROM ian.TEST1 >WHERE EXISTS (SELECT C1 FROM ian.TEST2) >/ > >SQL> SQL> SELECT C1, C2 FROM ian.TEST1 > 2 WHERE EXISTS (SELECT C1 FROM ian.TEST2) > 3 / > >C1 C2 >- -- > 1 Hello > > real: 1578 > >Execution Plan >-- >0 SELECT STATEMENT Optimizer=CHOOSE >10 FILTER >21 TABLE ACCESS (FULL) OF 'TEST1' >31 TABLE ACCESS (FULL) OF 'TEST2') > 3 / > >C1 C2 >- -- > 1 Hello > > real: 1578 > >Execution Plan >-- >0 SELECT STATEMENT Optimizer=CHOOSE >10 FILTER >21 TABLE ACCESS (FULL) OF 'TEST1' >31 TABLE ACCESS (FULL) OF 'TEST2' > >Neither table is indexed . Because of the low number of records in them. > >What I want to know is if > >SQL> SELECT C1, C2 FROM ian.TEST1 > 2 WHERE EXISTS (SELECT C1 FROM ian.TEST2) > > >undergoes a transitive operation to > > SELECT C1, C2 FROM ian.TEST1 > 2 WHERE EXISTS (SELECT C1 FROM ian.TEST2 >where test1.c1 = test2.c1) > >/ > > >More generally is there any tool out there which shows exactly what the >optimizer does with a query? > > >Ian MacGregor >Stanford Linear Accelerator Center >[EMAIL PROTECTED] >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: MacGregor, Ian A. > 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: MacGregor, Ian A. > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichae
RE: Year of Unix file
How about using stat(2)? $ ls -l proc.txt -rw-rw-r-- 1 oracle dba 3414 Jul 1 00:10 proc.txt $ perl -e '$a=(stat "proc.txt")[9]; print int $a/31536000+1970,"\n"' 2001 There's a better way to convert seconds since epoch to year but for now I just divide it by number of seconds in a year and add 1970 to it. The above perl one-liner is just a convenient way to call stat(2). Yong Huang [EMAIL PROTECTED] you wrote: But the year replaces the time in the 8th field only when the last modification time for the file is more than 6 month (even if it is in the current year :) For example, take a look at line 1,2 (less than 6 month old as of today) & 3,4,5 (over 6 months old as of today).. -rw-rw-r-- 1 oracle dba 2880 Feb 5 08:05 junk.lst -rwxrwx--- 1 oracle dba410 Jan 30 11:08 show_all.ksh -rwx-- 1 oracle dba 77 Jan 25 2001 t1 -rw-rw-r-- 1 oracle dba 3971 Jan 10 2001 my.lst -rw-rw-r-- 1 oracle dba720 Jan 7 2001 bdf.out HTH... Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang 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 directory example.
Sorry for the delay. Try with oidadmin. Have you created the cn=OracleContext ???. Regards. --- [EMAIL PROTECTED] wrote: > Yes Christian > > I have run @?/rdbms/admin/catldap.sql > and Package DBMS_LDAP has been installed in sys > user. > > When i run ldapadd command line command then again i > got the exception > saying parent directory not found. > How should i create a parent directory i.e. > Directory container with o=acme > dc=com in OID.? > > Thanks > Vinay > > > -Original Message- > Trassens > Sent: Thursday, July 19, 2001 2:06 PM > To: Multiple recipients of list ORACLE-L > > > Did you run @?/rdbms/admin/catldap.sql ?. > > Regards. > > > --- [EMAIL PROTECTED] wrote: > > Hello Oracle Gurus. > > > > This time i tried to run the EMP trigger example > > given in Oracle Internet > > Directory Application guide with LDAP/PLSQL API. > > I created the trigger with the script trigger.sql > > under ORA_HOME/LDAP/DEMO > > directory. > > when i run the script empdata.sql toinsert data in > > EMP table encountered > > following error. > > > > LDAP Host: vinay > > LDAP Port: 389 > > Ldap session : 38AA2309(returned from > > init) > > simple_bind_s Returns: 0 > > Adding Entry for DN : [cn=Natt Ball, > > o=acme,dc=com] > > Error code: -31202 > > Error Message : ORA-31202: DBMS_LDAP: LDAP > > client/server error: No such > > object > > Exception encountered .. exiting > > > > I am using Oracle 8.1.7 database on Windows 2000. > > the oid monitor and directory server instance has > > been started successfully > > using oidmon, oidctl commands. > > > > If some one has tried this example then please let > > me know where i am doing > > wrong.. > > > > Thanks > > Vinay > > > > > > -- > > 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). > > > = > Eng. Christian Trassens > Senior DBA > Systems Engineer > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : 541149816062 > > __ > 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: Christian Trassens > 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: > 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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 t
Re: severe lib cache contention !!
I don't remember the answers you received. However I suggest you to reduce the shared_pool_size to a minimum size possible. Set the shared_pool_reserved_size if you have PL code. Put the STANDARD package in keep with the dbms_shared_pool.keep. Set also _kgl_bucket_count to a value like 4 or 3 depending on the size of shared pool. And also put in the init.ora the _sqlexec_progression_count=0. Read the notes of metalink about it. And set a cron with a sql script that verify the amount of free memory from v$sgastat and the # of library cache latches. If it isn't appeared to be any free memory or library cache latch contention is high, trigger the script to issue an alter system flush shared_pool. Set the cron in a period of minutes. Another recomendation try with public synonyms if you have a lot of objets. Better would be if the application could use alter session set current_schema. However the most worthiest of all suggestions, would be to look at the sql running. They shouldn't take longer to accomplish their results or to finish. I mean the longer it takes the transaction the most probable for your to see contention in this latch and also in the cache buffer chains latch. Regards. --- Rahul <[EMAIL PROTECTED]> wrote: > list, > i just ported a system to 8.1.5, the application > DOES NOT make use > of bind variables, each and every query (fired from > 8 clients every 2-3 > seconds) > parses and executes, this keeps the shared pool > patch also very busy... > > i cannot tune the app, is there something i can do > to reduce the lib cache > and shared pool > latch contention ?? > > v$session_wait show all sessions waiting on "latch > free" > > the sleeps in lib cache latch are not properly > spread out also... > > SQL> select * from v$latch_children where latch#=99 > order by 8 > > CHILD#GETSMISSESSLEEPS > -- > 1 209093 149 117 > 5 283185 602 221 > 6 304797 616 264 > 7 583061 3354 1417 > 4 2697205191099 33858 > 211636488 8683396980522 > 360982875 47012872 8777649 > > Interestingly, the same app was NOT showing any > contention on these latches > in 7.3.2 !! > > how can i solve this problem ? > > TIA > > Rahul > > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rahul > 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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).
Cache Object
Hi All, I have a question regarding Cache Object in Memory, If I want to Cache a large data table in the memory i know it will much faster but what happen if server crash, in this case all modification on table will be gone or NOT. Any idea about cashing tables not only lookup tables realy appreciated. Hamid The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Urgent..DB creation problem..
Look at the parameter mts_dispatcher in the init.ora. Probably you'll see this: mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)" I suggest you to choose on the Database Assistant the option of generating the scripts. And before running these, renmark the parameter. Regards. --- Saurabh Sharma <[EMAIL PROTECTED]> wrote: > Hi all, > > i'm having a problem in creating new database > through database config assistant. after giving all > information (both in typical and custom mode) it > starts creating DB, but soon shows the msg "invalid > specification for mts_dispatcher in initSID.ora > file.." > > while there is no DB on the server, how is it > reading the init.ora file. i've not specified any > new mts_dispatcher parameter value. > why it is showing me the error msg. how to counter > this. > other errors are oracle not available. > > error code ORA-00101 invalid specification for > system parameter MTS_DISPATCHERS > > Saurabh Sharma > > [EMAIL PROTECTED] > http://www.geocities.com/saurabh00pc/stride.html > > = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Avoiding Duplicates and Transitive Operations
Mr. MacGregor would like to recall his posts on this subject. His brain has failed regression testing. He feels that Real Application Clusters will solve his lapses into silliness. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, July 27, 2001 4:56 PM To: Multiple recipients of list ORACLE-L Suppose you have the following tables: SQL> select * from test1; C1 C2 - -- 1 Hello SQL> select * from test2; C1 C2 - -- 1 Bye 1 So long and you wanted to get distinct records from test1 wherever test1.c1 = test2.1 You could Select distinct a.c1, a.c2 from ian.test1 a, ian.TEST2 B where a.c1 = b.c1 / C1 C2 -- 1 Hello real: 1531 execution Plan - 0 SELECT STATEMENT Optimizer=CHOOSE 10 SORT (UNIQUE) 21 MERGE JOIN 32 SORT (JOIN) 43 TABLE ACCESS (FULL) OF 'TEST2' 52 SORT (JOIN) 65 TABLE ACCESS (FULL) OF 'TEST1' However anytime you see a distinct clause, you should think, "Hey there's probably something wrong here." A better way to handle the query is SELECT C1, C2 FROM ian.TEST1 WHERE EXISTS (SELECT C1 FROM ian.TEST2) / SQL> SQL> SELECT C1, C2 FROM ian.TEST1 2 WHERE EXISTS (SELECT C1 FROM ian.TEST2) 3 / C1 C2 - -- 1 Hello real: 1578 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 FILTER 21 TABLE ACCESS (FULL) OF 'TEST1' 31 TABLE ACCESS (FULL) OF 'TEST2') 3 / C1 C2 - -- 1 Hello real: 1578 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 FILTER 21 TABLE ACCESS (FULL) OF 'TEST1' 31 TABLE ACCESS (FULL) OF 'TEST2' Neither table is indexed . Because of the low number of records in them. What I want to know is if SQL> SELECT C1, C2 FROM ian.TEST1 2 WHERE EXISTS (SELECT C1 FROM ian.TEST2) undergoes a transitive operation to SELECT C1, C2 FROM ian.TEST1 2 WHERE EXISTS (SELECT C1 FROM ian.TEST2 where test1.c1 = test2.c1) / More generally is there any tool out there which shows exactly what the optimizer does with a query? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: MacGregor, Ian A. 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 Monitoring with BMC
Raja, I no longer use this at my current job. I did at my last job and am currently working with an ex-BMC installer. Here is some information that might be useful. Please let me know if you need more information or care to talk more on this subject. Ok, BMC Patrol and the Oracle KM are the basic parts you will need to start monitoring your databases. The other BMC tools for Oracle are very good but are not addressed here. The Patrol install will include the Operating System KM and have the Oracle KM added to it. This will require approx. 250 MB disk space. Ensure you have at least 2 MB of disk for everyday you keep a log file for. I recommend a log file should be kept at least 30 days (60 MB needed) so you can accurate track system metrics for a month. To install you will need the system root password, and the Oracle System password. The first is needed to ensure BMC will start when the system reboots, the Oracle System password is needed as BMC requires access to the system tables. The Oracle KM will create tables either in system temporary table area, or another table you designate. This will also require room, in addition to the log file and the binaries. The room will vary upon system usage, size of dbs, etc... Allowing about 50 MB is more than ample. If the disk space for you database is very tight I highly recommend reconfiguring and "cleaning" tables before installing any product. What does the Oracle KM do? Basic Oracle performance metric, state of database, table space used, number of users, etc... It also allows you to monitor databases using SQLNet. This allows you to look at any reachable DB without adding Patrol to the system. It will collect over 200 parameters (a BMC term for a metric) for each Oracle instance. This means if you have one set of Oracle binaries running with 5 instances, you will get only one set of data telling you about the status of the binaries (is Oracle running? is it running with no instances active? is Oracle running and the instances active?), but you will also get the data about each table. So if you instance has 1 table or a 100 each table will have the same information recorded about them. Vital stuff to DBAs: - What is the status of the instance? - tables running out of space (extents)? - Disk space running out? - Rollback logs not archived? - SQL programs errors How effective is it? DBAs arrive and do a health check in the morning. Using Patrol this can be reduced from 30 minutes to 10 minutes per instance. Adding scripts that run on-demand or when triggered by the database is straight forward. Control of what each user has access, allows DBAs not to tread on each others toes. Install time: O/S KM, Patrol Agent - 1 hr Console - 1 hr Oracle KM - 1 hr. Time when you start getting useful data, depending on the metric (some need a history to start determining if they are in trouble) ranges from immediately to all metrics reporting within one hour. You will need several days of operations to effectively baseline the warning levels of the parameters. This is like any other tool where the more data collect, the better vision you will have of what is normal and what is a problem. Recommendation - purchase if you need 24/7 database uptime. A DBA and system admin must work together as the close relationship between Oracle and the O/S demands this. __ Alan B. Dewey Geneva (Billing) Team Lead /DBA Lead Arsenal Digital Solutions Worldwide, Inc. 4815 Emperor Boulevard, Suite 110 Durham, NC 27703 Website - www.arsenaldigital.com Tel. (919) 941-4604 Fax (919) 474-0695 Pager (888) 646-6038 Cell (919) 523-5741 Email [EMAIL PROTECTED] "Managing Information with a Passion" ***NOTICE*** This e-mail message is confidential, intended only for the named recipient's) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient's), please immediately notify the sender at (919) 941-4604 and delete this e-mail message from your computer. Thank you. -Original Message- From: Viraj Luthra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 10:11 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Monitoring with BMC Hello all, Has any one used the Oracle Monitoring with BMC, and can share experiences. Also any advantages, disadvantages kind of paper you have written for ypur company, that would be great; evaluating BMC at present. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / ailing Lists --
