Re: Hello
This looks like the Novarg worm What say people ? If yes, then thank you Listguru for filtering out the binaries [EMAIL PROTECTED] is a mass-mailing worm. The worm will arrive as an attachment with a file extension of .bat, .cmd, .exe, .pif, .scr, or .zip. When the machine gets infected, the worm will set up a backdoor into the system by opening TCP ports 3127 thru 3198. This will potentially allow a hacker to connect to the machine and utilize it as a proxy to gain access to it's network resources. In addition, the backdoor has the ability to download and execute arbitrary files. The worm will perform a DoS starting on February 1, 2004. On February 12, 2004 the worm has a trigger date to stop spreading. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 04:04 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
linux
Hello list, sorry for the off topic question , but I thought that a question on unix would not ruffle too many feathers. what all changes will you make to convert linux to a Real time operating system ? Can anyone please help me with an answer and explanation ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: another OCP question -- help me guys
Hi list , sorry to pester you with questions regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at the 2 questions below . Don't apologize Prem, who else are you gonna call, ghostbusters? :) - QUESTION #1 what happens when you issue the command below . drop tablespace testtbs including contents cascade constraints and datafiles; but boson's choice is A. i wonder how ??? Statement is incorrect, cascade constraints is placed in the end. Fine that explains that boson is wrong. But if you want to prepare for ocp then , you must also consider the possibility that a novice like me was sitting at boson preparing these questions. So the next time you come across a question whose answer doesn't match yours do the following in the order specified: 1. Assume boson is right and recheck your answer. Try it out on a test database. (make sure you get the conditions of the question correctly implemented). See the docs. 2. Assume boson is right and read the solution /explanation for the answer, then tally it with your answer and solution. 3. Still not happy ? Assume boson is right and re-read the question, there may be one word or a comma or a full stop or a bracket ,etc that is completly changing the meaning of the question but you may skipped it when reading the question. (It happens a lot to me, but then I am dumb :). Now tally your answer with boson 4. Still not happy ? (there is no pleasing you, is there? :) ok now you can do two things: 4a. The question and the solution given by boson are blatantly wrong (because of a typo or because I had set the question paper ) AND YOU ARE ABLE TO COMPLETLY REASON OUT out what is so wrong about the question and answer, what should it have been, what if that part of the question was changed so , etc etc, ; then correct the question and answer and move onto the next one. 4b The question is still blatantly wrong but you have a nagging doubt, then ask around . There may be some obscure formula (which works only in OCP exams) or the answer may be the least of all the evils given . Either which way time to mug it up Now keeping in mind these policies, have another look at the two questions you have given above and below. - QUESTION #2 you need to determine how much space has been allocated for a table. which view would give you this information ? A. dba_extents B. dba_ts_quotas C. dba_segments my choice is C . but boson's choice is A . it says other views cannot give the required details . a metalink doc says that dba_segments.blocks gives the total number of blocks allocated to the table. what will be the choice that you would go for ? - Both A and C are right. What will really boggle your mind is deciding what to say if you get the exact same question in the ocp exam and you have to make a single choice. But relax ocp exams are not as troublesome, they are much more professionally prepared. so now i have the question whether boson is reliable ? how many in this list have used it ? or am i missing something : (( After reading my letter I hope there is at least one thing you can say : Boson is not reliable , but it is essential. Remember , there is a big difference between studying and studying for an exam . And the only way to ace the ocp is to do many question papers like boson. .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCP question from Boson practice tests
Prem , OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and humbly, play by its rules. Right now if your are serious about giving OCP exams then please enable suspension of disbelief , don't ask why and just mug up the following 3 (any one of them may come up in the ocp exam , though not together) : 1. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be a multiple of the parameter sort_area_size 2. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be a multiple of sort_area_size * db_block_size 3. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to ben * sort_area_size + db_block_size. OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and play by its rules. Best of luck . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 16:14 Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Merge
Hello list I am using Oracle 9.2.0.1.0 , Consider the merge command : merge into table1 using on (column matching condition) then update set . when not matched then insert values ...; Is there a restriction that the column specified in 'column matching condition' cannot be placed in the 'update set' clause ? The docs don't mention this, but I tried this out and I seem to be experiencing this behaviour. Thanks in advance Q. Which hardware platform does Oracle perform the best on? A. A 35 mm slide projector. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Hi list
List, thanks to all of you I finally completed my OCP exams (thought they would never end) Thanks for your help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: order by
List can you please explain to me why select empno from emp order by empno ; is the same as select empno from emp order by sqrt(3.14); but not the same as select empno from emp order by dbms_random.value; What does sort by a random value do ? and why isn't dbms_random.value in the documentation for 9i Release 2 ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 29, 2003 03:34 [EMAIL PROTECTED] wrote: Hello list, Can someone please explain to me why the following order by clauses are valid and yield the same results : select empno, deptno from emp order by sqrt (1) ; and select empno, deptno from emp order by sqrt ( 3.14234 ) ; The docs say that in the order by clause you could specify only (a) column names or (b) positional parameters or (c) expressions involving the columns A constant falls under the c) category. It's an expression, which involves anything you want. That said, I fail to see any practical use . -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sequence
Hello list and a happy new year to everyone, why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values (mysequence.currval, mysequence.nextval ) ; where 1. mysequence is create sequence mysequence increment by 1 start with 1 maxvalue 1000 nocycle nocache ; and 2. test is Name Null?Type ID NUMBER(7) ID2NUMBER -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: order by
I was curious to find out why all the other sorts work the same but order by dbms_random.value ( which also returns a number like sqrt (3.14) ) behaves totally different. Any ideas ? Also could you please tell me what does it mean when someone says order by non integer some_constant . An integer constant would refer to the positional parameter but what about a real value which is not an integer ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 01, 2004 21:34 It is for the same reason that 'select empno from emp' without and order by, also returns the same results. Take a look at $ORACLE_HOME/sqlplus/demo/demobld.sql Didn't you ask this same question earlier this week? Jared On Thu, 2004-01-01 at 01:14, [EMAIL PROTECTED] wrote: List can you please explain to me why select empno from emp order by empno ; is the same as select empno from emp order by sqrt(3.14); but not the same as select empno from emp order by dbms_random.value; What does sort by a random value do ? and why isn't dbms_random.value in the documentation for 9i Release 2 ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 29, 2003 03:34 [EMAIL PROTECTED] wrote: Hello list, Can someone please explain to me why the following order by clauses are valid and yield the same results : select empno, deptno from emp order by sqrt (1) ; and select empno, deptno from emp order by sqrt ( 3.14234 ) ; The docs say that in the order by clause you could specify only (a) column names or (b) positional parameters or (c) expressions involving the columns A constant falls under the c) category. It's an expression, which involves anything you want. That said, I fail to see any practical use . -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sequence
Joe you are absolutely right From the sql reference : Where to use currval and nextval If any of these locations contains references to both CURRVAL and NEXTVAL, then Oracle increments the sequence and returns the same value for both CURRVAL and NEXTVAL. Sorry for the rtfm question. I am really lucky to learn from you all. Thanks list and a happy new year to you too. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 01, 2004 18:54 Sounds like you need to read the docs on sequences, happy new year and happy reading. joe [EMAIL PROTECTED] wrote: Hello list and a happy new year to everyone, why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values (mysequence.currval, mysequence.nextval ) ; where 1. mysequence is create sequence mysequence increment by 1 start with 1 maxvalue 1000 nocycle nocache ; and 2. test is Name Null?Type ID NUMBER(7) ID2NUMBER -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: order by
Thanks Justin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 02, 2004 00:39 At 10:44 AM 1/1/2004, you wrote: I was curious to find out why all the other sorts work the same but order by dbms_random.value ( which also returns a number like sqrt (3.14) ) behaves totally different. Any ideas ? When you order by dbms_random, Oracle will generate a random number for each row and sort on those random numbers. When you order by a constant real value, Oracle has no way to order the results, so they will be returned in whatever order they are retrieved from the database. Also could you please tell me what does it mean when someone says order by non integer some_constant . An integer constant would refer to the positional parameter but what about a real value which is not an integer ? Aside from SQL brain-teasers, I cannot imagine a practical use for ORDER BY constant real number. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
order by
Hello list, Can someone please explain to me why the following order by clauses are valid and yield the same results : select empno, deptno from emp order by sqrt (1) ; and select empno, deptno from emp order by sqrt ( 3.14234 ) ; The docs say that in the order by clause you could specify only (a) column names or (b) positional parameters or (c) expressions involving the columns -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
merge
Hello list I am using Oracle 9.2.0.1.0 , Consider the merge command : merge into table1 using on (column matching condition) then update set . when not matched then insert values ...; Is there a restriction that the column specified in 'column matching condition' cannot be placed in the 'update set' clause ? The docs don't mention this, but I tried this out and I seem to be experiencing this behaviour. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: guidance
Hi tanel , thanks for the prompt reply. I was not able to understand your answer. What do you mean by new software installation ? What happens when you specify nls_lang in your test database ? are your messages in the specified language or do they remain in english ? - Original Message - From: Tanel Poder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 19:27 Subject: Re: guidance Hi! Did you do a new software installation? When you install software, you cah choose which languages to install - if you installed only English, then all error messages will be in english, but day names, month names, currency symbols etc.. will be still there, regardless of which languages you installed. Happy holidays to you, too! Tanel. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 4:47 PM Subject: Re: guidance Hello Tanel , sorry to trouble you but I have tried asking a question in [EMAIL PROTECTED] several times and no-one seems to answer. Can you please help me out. I am not even sure whether I am doing something wrong or thats how things are supposed to be when specifying nls_lang, but I was curious so here goes : (by the way have a merry Xmas and a happy new year ) I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. - Original Message - From: Tanel Poder [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 03:24 Subject: Re: guidance Forget the modern tuning skills and when you're asked what shows the best that your database works optimally; 1) Buffer cache hit ratio is 99% 2) Buffer cache hit ratio is 99,999% 3) Buffer cache hit ratio is 99% 4) Users aren't complaining Then answer 3 for sure ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:04 AM List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
Re: exam
Can you tell me if the same happens to you when you specify nls_lang in 9i release 2, or is it just me ? - Original Message - To: Jamadagni, Rajendra [EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 02:17 Thanks anyway merry xmas - Original Message - From: Jamadagni, Rajendra [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 22:38 Subject: RE: exam sorry ... no idea about this issue, you need to talk to Oracle. Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 9:50 AM To: Jamadagni, Rajendra Subject: Re: exam Hello Mr Jamadagni , sorry to trouble you but I have tried asking a question in [EMAIL PROTECTED] several times and no-one seems to answer. Can you please help me out. I am not even sure whether I am doing something wrong or thats how things are supposed to be when specifying nls_lang, but I was curious so here goes : I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. Have a merry xmas and a happy new year :) - Original Message - From: Jamadagni, Rajendra [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 21:09 Subject: RE: exam Congratulations ... so what was your Hit ratio ... Raj -Original Message- List , thanks to you all I passed my oracle 9i performance tuning exam today with good marks. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
List please help
List , sorry to keep troubling you all but even if you are not interested in helping could someone just let me know if this happens by default in 9i release 2 or am I doing something wrong. I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ignore: List please help
List, I did a reinstall and got the french language support back when I specified the languages during the reinstall. Thanks Merry xmas and happy new year :) - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, December 25, 2003 06:39 List , sorry to keep troubling you all but even if you are not interested in helping could someone just let me know if this happens by default in 9i release 2 or am I doing something wrong. I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
seq
Hello list , why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values (mysequence.currval, mysequence.nextval ) ; where 1. mysequence is create sequence mysequence increment by 1 start with 1 maxvalue 1000 nocycle nocache ; and 2. test is Name Null?Type ID NUMBER(7) ID2NUMBER -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
specify nls_lang
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
messages
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
messages
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
nls_lang
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c: sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to english c: sqlplus Enter user-name: Any ideas ? I tried out the following but to no avail : 1. I specified ora_nls33 to point to D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my %oracle_home% 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing dates , the months are in French. sysdate also gives the month in french 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect specification since there are no utf8 windows clients ) 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries pick up the correct local currency symbol. and nls_language and nls_territory values in nls_session_parameters are correct. 5. Alert log doesn't show any errors. My database character set is AL32UTF8 , did not specify an nchar characterset while creating the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
create table as select
List , I am using Oracle 9.2.0.1.0 enterprise edn on windows. I have a table with a long datatype column. Is there any way of duplicating this table using the create table ... as select command ? or do I have to use the copy command ? Is the copy command present in 10g ? desc s_warehouse Name Null?Type -- -- .. . ADDRESSLONG . create table test as select * from s_warehouse ; create table test as select * from s_warehouse * ERROR at line 1: ORA-00997: illegal use of LONG datatype -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
grouping sets
List , I am using Oracle enterprise edition 9.2.0.1.0 on windows. I was trying to write the equivalent for a rollup , using grouping sets. This works : select dept_id, title, sum ( salary ) from s_emp where dept_id 35 group by grouping sets ( (dept_id , title ) ); This also works : select dept_id, title, sum ( salary ) from s_emp where dept_id 35 group by grouping sets ( (dept_id , title ), dept_id ); However this locks up the session , oracle.exe shows a cpu usage of 99% and even a shutdown abort by the sysdba does not work. In fact no new users are able to log in , not even sysdbas. select dept_id, title, sum ( salary ) from s_emp where dept_id 35 group by grouping sets ( (dept_id , title ), dept_id, title ); Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dual
List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : why do multiple inserts into sys.dual complete sucessfully when connected as sysdba, but a subsequent select * from dual show only 1 row ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dual
Thanks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 30, 2003 23:49 It's because we designed it that way. In earlier releases (can't remember the specific version we brought this in with), you could put more than one row in DUAL and then select them all, but all the things that should have returned only one row then failed with a 1403 (?) error - single row query returning more than one row. I remember well way way back in time before I joined Oracle having the fun of trying to debug why all our clients apps failed the night after we let a manager do the database maintenance. The forms that the apps used all included the date and time on the screen, and of course the manager had somehow ended up with two rows in DUAL, hence the failure. Very simple to address, by just deleting the extra row (and of course, never letting that manager do database maintenance again!). In due course, Oracle realized that DUAL was a special table and built into the kernel the functionality you mention to ensure that only one row is ever returned and hence those types of problems should not occur any more. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Friday, October 31, 2003 3:55 AM To: Multiple recipients of list ORACLE-L List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : why do multiple inserts into sys.dual complete sucessfully when connected as sysdba, but a subsequent select * from dual show only 1 row ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What happened to Howard Rogers ?
Thanks lisa - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 20:54 His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October 2003 15:04 To: Multiple recipients of list ORACLE-L howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue him over it. Supposedly in australia companies own you while you work theere and you need special permission to publish. From: sdf [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:24:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What happened to Howard Rogers ? Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- -- This message is intended only for the use of the person(s) (Intended Recipient) to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dobson, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this
Re: Find CPU clock speed on HP-UX 11
Hi In solaris use prtconf command In HPUX Use the following script to determine the clock speed: HPUX=/stand/vmunix # 10.x C=`echo itick_per_tick/D | adb $HPUX /dev/kmem | tail -1 \ | awk '{print $2/1}'` echo Clock speed of `hostname` is: $C Mhz. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 12:24 Hi! I'm new to HP-UX and need to find out how many processors are in a mchine and at what clock speed they operate. I can get the number of CPUs through glance or top, but I have no idea about the clock speed. How would I get that information? I would know how to do it on Solaris though... ;) Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Passed Net8 OCP Exam
Congrats dennis - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 17, 2003 00:54 I just passed the Net8 Administration OCP exam. This was my last exam, so I suppose I am now an OCP for Oracle8i. Thanks to everyone for their helpful tips. Some people said (or implied) that this is a very easy exam. I would dispute that. I found it just like the other exams, in that if you have quite a bit of on-the-job experience in the area, then it is easy. If not, you'll have to study more. In my case, - I don't like networking, and hate to drop everything to configure or debug someone's tnsnames.ora file. - Never had an Oracle networking class. - Our site has only needed local naming, so that is pretty much all my networking experience. Found all the questions related to local naming pretty easy. Never used Oracle Names, Connection Manager, MTS, Advanced Security. With the trend toward application servers with their connection pooling feature, I don't foresee us using any of those Oracle tools. I may need to use LDAP in the future, but that wasn't covered in the Oracle8i Net8 exam My goal was just to study and practice enough to practice the exam, and I accomplished the goal. Not a very lofty goal, but sometimes you do what you gotta do. Thanks everyone for the helpful suggestions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to add ' (comma) at the begining and end of each line? Either Unix or Windows
Use the 'search and replace' functionality of ultraedit with 'regular expressions' enabled. First select 'replace all' for replacing % with ' Then select 'replace all' for replacing $ with ' - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 19:50 Unix or Windows Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Homework
List, anyone finished the exercises in cary's book ? or at least chapter 5 ? . I tried www.oreilly.com/catalog/optoraclep. Hey maybe I can get you guys to write my term paper too :) Professor Milsap is a real stickler for assignments and will probably flunk me for copying. But seriously, Cary says that Most of the exercises don't have a single correct answer I wanted to learn what reasoning you all applied. (For example to differentiate betweenwait events within and wait events between. Cause many a times it gets difficult to be sure of whether this wait is within the next fetch or not ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: encrypt traffic across internet?
List, so ssh forwarding will not work with windows ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 17:40 Hmm I wonder what the Metalink Technicians would have to say on this. Patrice. -Original Message- Sent: Sunday, October 12, 2003 6:29 PM To: Multiple recipients of list ORACLE-L I have a question about using the port forwarding feature of ssh. The initial connection to the listener gets tunneled thru by ssh. But what happens if the os is windows and bequeathing the connection is not possible and a redirect must take place ? Listener sends a redirect message back to the client with the location of the dispatcher or dedicated server process. The client then connects directly to the dispatcher or dedicated server process. Now won't all the communication bypass the ssh port forwarding ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 21:14 Or you can tunnel sqlplus and many other programs through ssh. -Original Message- Sent: Wednesday, October 08, 2003 10:40 AM To: Multiple recipients of list ORACLE-L The question was posed to me about a simple web browser (non ssl), accessing an oracle database and shooting the information across the internet to a client, this info is NOT encrypted i assume. is that also true for like remote sqlplus connections and if you wanted it to be for web, you need to go via SSL and for sqlplus what can be used? Is this where ASO comes in(i think thats is, advanced security option?) thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
Fw: encrypt traffic across internet?
I have a question about using the port forwarding feature of ssh. The initial connection to the listener gets tunneled thru by ssh. But what happens if the os is windows and bequeathing the connection is not possible and a redirect must take place ? Listener sends a redirect message back to the client with the location of the dispatcher or dedicated server process. The client then connects directly to the dispatcher or dedicated server process. Now won't all the communication bypass the ssh port forwarding ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 21:14 Or you can tunnel sqlplus and many other programs through ssh. -Original Message- Sent: Wednesday, October 08, 2003 10:40 AM To: Multiple recipients of list ORACLE-L The question was posed to me about a simple web browser (non ssl), accessing an oracle database and shooting the information across the internet to a client, this info is NOT encrypted i assume. is that also true for like remote sqlplus connections and if you wanted it to be for web, you need to go via SSL and for sqlplus what can be used? Is this where ASO comes in(i think thats is, advanced security option?) thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to copy recursive files in Windows? like unix cp -r
xcopy /e /h source destn - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 00:29 Hi List: How to copy recursive files in Windows? like unix cp -r Thanks in advance, Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help with a scripting problem
c:\progra~1\RESOUR~1\robocopy - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 03:04 I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how to get around this? echo select 'host c:\program files\resource kit\robocopy;' from dual; Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: encrypt traffic across internet?
Richard , I have a question about using the port forwarding feature of ssh. The initial connection to the listener gets tunneled thru by ssh. But what happens if the os is windows and bequeathing the connection is not possible and a redirect must take place ? Listener sends a redirect message back to the client with the location of the dispatcher or dedicated server process. The client then connects directly to the dispatcher or dedicated server process. Now won't all the communication bypass the ssh port forwarding ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 21:14 Or you can tunnel sqlplus and many other programs through ssh. -Original Message- Sent: Wednesday, October 08, 2003 10:40 AM To: Multiple recipients of list ORACLE-L The question was posed to me about a simple web browser (non ssl), accessing an oracle database and shooting the information across the internet to a client, this info is NOT encrypted i assume. is that also true for like remote sqlplus connections and if you wanted it to be for web, you need to go via SSL and for sqlplus what can be used? Is this where ASO comes in(i think thats is, advanced security option?) thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alter session
List, what does the following do ? alter session set current_schema=sys; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 'shared pool'
Mladen , thanks for replying . Please tell me why does one get a difference between the values returned from v$sgastat and the shared pool size set in the parameter file ? Please , explain this to me . Arup explained that the memory required to manage the buffer cache is also allocated from the shared pool. Is there any ratio or does this mean that if I allocate x MB to my buffer cache, Oracle allocates that x mb for the buffer cache , and an additional x mb or 32 mb for managing the buffer cache and places it in the shared pool ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 03:49 Not so on my instance. SQL select sum(bytes) from v$sgastat 2 where pool='shared pool'; SUM(BYTES) -- 251658240 SQL show parameter shared_pool NAME TYPEVALUE --- -- shared_pool_reserved_sizebig integer 10905190 shared_pool_size big integer 218103808 SQL select 251658240-218103808 from dual; 251658240-218103808 --- 33554432 SQL show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 419430400 SQL On Tue, 2003-10-07 at 17:54, [EMAIL PROTECTED] wrote: List please try out the following : 1. select sum(bytes) from v$sgastat where pool='shared pool'; 2. find out the size of the shared pool you have specified in your parameter files. 3. subtract the two values 4. When I do the same as above the difference is exactly equal to my db_cache_size. So does this mean that if I allocate x MB to my buffer cache, Oracle allocates that x mb for the buffer cache , and an additional x mb for managing the buffer cache and places it in the shared pool ? Please explain this to me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: 'shared pool'
Mladen ,is all this documented anywhere or is it all very common knowledge ? I can't believe that all you expert dbas would let Oracle take away tens of mbs of memory without telling you. - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 04:11 Mladen , thanks for replying . Please tell me why does one get a difference between the values returned from v$sgastat and the shared pool size set in the parameter file ? Please , explain this to me . Arup explained that the memory required to manage the buffer cache is also allocated from the shared pool. Is there any ratio or does this mean that if I allocate x MB to my buffer cache, Oracle allocates that x mb for the buffer cache , and an additional x mb or 32 mb for managing the buffer cache and places it in the shared pool ? - Original Message - From: Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 03:49 Subject: Re: 'shared pool' Not so on my instance. SQL select sum(bytes) from v$sgastat 2 where pool='shared pool'; SUM(BYTES) -- 251658240 SQL show parameter shared_pool NAME TYPEVALUE --- -- shared_pool_reserved_sizebig integer 10905190 shared_pool_size big integer 218103808 SQL select 251658240-218103808 from dual; 251658240-218103808 --- 33554432 SQL show parameter db_cache_size NAME TYPEVALUE --- -- db_cache_sizebig integer 419430400 SQL On Tue, 2003-10-07 at 17:54, [EMAIL PROTECTED] wrote: List please try out the following : 1. select sum(bytes) from v$sgastat where pool='shared pool'; 2. find out the size of the shared pool you have specified in your parameter files. 3. subtract the two values 4. When I do the same as above the difference is exactly equal to my db_cache_size. So does this mean that if I allocate x MB to my buffer cache, Oracle allocates that x mb for the buffer cache , and an additional x mb for managing the buffer cache and places it in the shared pool ? Please explain this to me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
'shared pool'
List please try out the following : 1. select sum(bytes) from v$sgastat where pool='shared pool'; 2. find out the size of the shared pool you have specified in your parameter files. 3. subtract the two values 4. When I do the same as above the difference is exactly equal to my db_cache_size. So does this mean that if I allocate x MB to my buffer cache, Oracle allocates that x mb for the buffer cache , and an additional x mb for managing the buffer cache and places it in the shared pool ? Please explain this to me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shared_Pool_size
Arup , wow I am so glad that you answered . You always come up with the real mccoy answers. However I have a few questions stemming from what you said: 1. I tried running select * from v$sgastat where pool = 'shared pool' order by 3; on my 9.2.0.1.0 enterprise edition. I was unable to get any row containing name= 'db_block_buffers' and pool='shared pool' Which version did you run this on ? 2. If I allocate x MB to my buffer cache, does this mean that Oracle allocates that x mb for the buffer cache , and an additional x mb for managing the buffer cache and places it in the shared pool ? I did select sum(bytes) from v$sgastat where pool='shared pool; From this I subtracted the value of shared_pool_size. The difference is exactly equal to my db_cache_size. 3. What is the size of your buffer cache ? I wish Oracle had clearly defined all its memory needs in big big bold letters for novices like me. - Original Message - To: [EMAIL PROTECTED] Sent: Friday, October 03, 2003 9:16 PM Bulbul, I apologize for getting back to you late on this issue. As you can probably tell, I hardly find time to look at the Oracle-L messages. Anyway, your question is valid; actually it's an aberration of understanding the pool management in Oracle. When you define the shared_pool_size parameter in initialization parameter, that is not really the *whole* share pool, but only for part of it. The shared pool contains several other types of objects, such as PL/SQL Dianas, etc. Here is the output for my case. SQL show parameter shared_pool_size NAME TYPEVALUE --- -- shared_pool_size string 3600 SQL select sum(bytes) from v$sgastat where pool = 'shared pool'; SUM(BYTES) 81,344,064 As you can see, the defined shared pool is only 36 MB whereas the actual allocated shared pool is about 80 MB. Where does the extra 44 MB come from? To find out we have to break down the shared pool. SQL l 1 select * from v$sgastat where pool = 'shared pool' order by 3; POOLNAME BYTES --- -- shared pool trigger inform 408 shared pool fixed allocation callback 1,904 shared pool PLS non-lib hp2,136 shared pool trigger source2,280 shared pool table definiti3,664 shared pool temporary tabl6,040 shared pool trigger defini8,312 shared pool KGK heap 9,944 shared pool table columns19,752 shared pool KGFF heap43,728 shared pool log_buffer 98,304 shared pool SYSTEM PARAMETERS 107,920 shared pool long op statistics array124,000 shared pool enqueue_resources 151,008 shared pool network connections 158,096 shared pool ktlbk state objects 165,088 shared pool message pool freequeue 191,192 shared pool DML locks 206,976 shared pool db_handles 220,000 shared pool processes 268,000 shared pool PL/SQL DIANA413,072 shared pool transactions468,160 shared pool State objects 539,680 shared pool sessions680,960 shared pool KQLS heap 829,752 shared pool event statistics per sess 972,160 shared pool PL/SQL MPCODE 1,080,168 shared pool dictionary cache 1,533,464 shared pool miscellaneous 1,996,984 shared pool db_block_hash_buckets 5,253,744 shared pool sql area 8,864,600 shared pool library cache10,415,712 shared pool free memory 11,150,056 shared pool db_block_buffers 35,356,800 Note the last value, db_block_buffers: 35,356,800. Wait! shouldn't the db block buffers be in db_block_buffers? What are they doing in shared pool? Even though the actual buffers are defined by the parameter db_block_buffers, and the bufferes are created there, the actual management of the buffers, i.e. which one is free, which one is at which end of the Least Recently Used (LRU) list, etc. are maintained in the shared pool. Theefore the 35 MB area you see is allocated to the management of the db block buffers, outside the 36 MB I have defined. The 36 MB I defined goes into the sql area (8 MB), library cache (10 MB), db block hash buckets (5 MB) and dictionary cache (1 MB) and about 11 MB is free = 36 MB. The rest are all outside the defined shared pool. Hence you see a different number. Hope this helps. Arup Nanda
contents of shared pool
List please try out the following : 1. select sum(bytes) from v$sgastat where pool='shared pool'; 2. find out the size of the shared pool you have specified in your parameter files. 3. subtract the two values 4. When I do the same as above the difference is exactly equal to my db_cache_size. So does this mean that if I allocate x MB to my buffer cache, Oracle allocates that x mb for the buffer cache , and an additional x mb for managing the buffer cache and places it in the shared pool ? Please explain this to me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
exam
Thanks Do you feel you learned anything from this exam? My initial answer was : If there is one thing that I have learnt from this exam , its that studying for an exam is different from studying. This principle doesn't seem to apply so much to backup and recovery , adminstration fundamentals ,etc. However now that I have had a day to think about your question I have the following to say. I have spent all this time ( while I was preparing for this exam) complaining and being nervous. I was wrong to complain. Its only when we have a deadline to meet that we sit down and devote time to something. If nothing else this exam made me sit down and give time to studying and learning. I am glad that this exam is a part of ocp. Because of this exam I came into contact with so many wonderful new things and concepts. Granted that the very fact that I had a deadline to meet meant that I only learnt their names and did not get to know them well but I learnt that the rabbit hole really goes deep . This exam has taught me to respect performance tuning. If i did not have to give this exam , I would have remained oblivious to my ignorance. Now I feel more humble and at the same time eager to learn. Thanks list, I am lucky to learn from you all. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: exam
Congratulations. Thanks Do you feel you learned anything from this exam? My initial answer was : If there is one thing that I have learnt from this exam , its that studying for an exam is different from studying. This principle doesn't seem to apply so much to backup and recovery , adminstration fundamentals ,etc. However now that I have had a day to think about your question I have the following to say. I have spent all this time ( while I was preparing for this exam) complaining and being nervous. I was wrong to complain. Its only when we have a deadline to meet that we sit down and devote time to something. If nothing else this exam made me sit down and give time to studying and learning. I am glad that this exam is a part of ocp. Because of this exam I came into contact with so many wonderful new things and concepts. Granted that the very fact that I had a deadline to meet meant that I only learnt their names and did not get to know them well but I learnt that the rabbit hole really goes deep . This exam has taught me to respect performance tuning. If i did not have to give this exam , I would have remained oblivious to my ignorance. Now I feel more humble and at the same time eager to learn. Thanks list, I am lucky to learn from you all. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- List , thanks to you all I passed my oracle 9i performance tuning exam today with good marks. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: exam
The exam was well made. They were very keen on 1. the exact values of the various hit ratios 2. deadlocks. All in all I would say that the preparation for this exam is a lot more tougher than the exam itself. Performance tuning course is VAST. But I could be wrong about the exam, because frankly the exam is all blurred in my memory. I don't remember the questions , all I remember is that as soon as the paper started I found that all the v$ synonyms stopped making sense to me. Had to read the words in the questions much more carefully in this exam than in any other exam. Most of the answers are so close to being correct till you zero in on that one word in the answer which makes the answer either totally wrong or the one. Performance tuning exam , well all I can say is that I am glad that its over. Now I can actually start studying performance tuning. Still have my sql exam left though. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 20:29 Congrats! How did you find the exam, Easy? Tough? Ambigous? Regards Naveen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 7:55 PM To: Multiple recipients of list ORACLE-L Subject: exam List , thanks to you all I passed my oracle 9i performance tuning exam today with good marks. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
exam
List , thanks to you all I passed my oracle 9i performance tuning exam today with good marks. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shared_Pool
I always get a difference , the first one gives a value greater than the second by 12MB I tried with different values of shared_pool_size . What am I doing wrong here ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 06:29 YES regards navneet - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 2:29 AM List, will the following two queries give the same value for the shared_Pool-size ? select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool'; and show parameter shared_pool_size I always get a difference , the first one gives a value greater than the second by 12MB I tried with different values of shared_pool_size . What am I doing wrong here ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Navneet Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: v$sort_usage
Please , do tell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 02:34 Yes. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, September 29, 2003 4:55 PM To: Multiple recipients of list ORACLE-L Subject: v$sort_usage List, I am unable to find v$sort_usage in the 9i docs, though this synonym exists. Any idea why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
v$sort_usage
List, I am unable to find v$sort_usage in the 9i docs, though this synonym exists. Any idea why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shared_Pool
List, will the following two queries give the same value for the shared_Pool-size ? select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool'; and show parameter shared_pool_size I always get a difference , the first one gives a value greater than the second by 12MB I tried with different values of shared_pool_size . What am I doing wrong here ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shared pool size
List, will the following two queries give the same value for the shared_Pool-size ? select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool'; and show parameter shared_pool_size I always get a difference , the first one gives a value greater than the second by 12MB I tried with different values of shared_pool_size . What am I doing wrong here ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: guidance
Tanel , good you drew that smiley . I am so worried about this exam that for a minute there I was noting down what you wrote. Thanks for cheering me up though. Here is a question for you Which two statements about row migration are true? (Choose two) A. Row migration is caused by a PCTREE value set too low. B. Row migration can be resolved using the ANALYZE command. C. Row migration can be reduced by choosing a larger block size. D. Row migration means that row pieces are stored in different blocks. E. Queries that use an index to select migrated rows perform additional I/O. Answer: A, B Shouldn't it be a and e ? What does answer b mean when it says : row migration can be RESOLVED Whatever the meaning , analyze .. or analyze.. list chained rows would not be able to differentiate between chained or migrated rows, right ? And upon migration , the index will not be updated and will retain the old rowid right? so then e is correct . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 03:24 Forget the modern tuning skills and when you're asked what shows the best that your database works optimally; 1) Buffer cache hit ratio is 99% 2) Buffer cache hit ratio is 99,999% 3) Buffer cache hit ratio is 99% 4) Users aren't complaining Then answer 3 for sure ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:04 AM List , I am planning to give my 9i performance tuning exam on the first
Re: guidance
Thanks O'mladen one. No really, thanks , good advice. I am really going hyper about performance tuning exam. The course is so vast, and the exam so expensive. Honestly how can you test a newbie in performance tuning ? shouldn't it be a part of ocm ? Instead of putting that riduculous condition of attending Oracle classes to give ocp they should see how much experience you have before allowing you to appear for performance tuning exam. I would be much more prepared for the exam if I had apprenticed under you for a while. Look at me I haven't even read Cary's book ( wait a minute , neither have many people on this list , thanks to amazon) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 03:09 Realx and feel the force. Only if you open your mind, you can master the force. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: guidance List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shared server connections
Mladen, aren't you talking about connection multiplexing and not connection pooling ? Isn't pooling is supposed to carried out by the dispatchers themselves. Let me know if I should rtfm. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 19:44 Well, to successfully use connection pooling, you need connection manager. My information is that pooling by the instance is rather buggy and slow. Here is an excerpt from the oracle documentation: Oracle Connection Manager, an Oracle Net Services component, enables multiple client network sessions to be multiplexed, or funneled, through a single network connection to a database. The session multiplexing feature reduces the demand on resources needed to maintain multiple network sessions between two processes by enabling the server to use fewer network connection endpoints for incoming requests. This enables you to increase the total number of network sessions that a server can handle. With multiple Oracle Connection Managers, thousands of concurrent users can connect to a server. Figure 1-12 shows how session multiplexing can be used in a Web architecture. When Oracle Connection Manager is run on the same computer as an application Web server, the application Web server can route multiple client sessions through Oracle Connection Manager to ensure that those sessions have continuous access to an Oracle database server. This functionality is especially useful for Web applications where session availability and response time are major concerns. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 7:25 PM To: Multiple recipients of list ORACLE-L Subject: shared server connections Hello list, I am using 9.2.0.1.0 enterprise edition on windows. I have a database in shared server mode. Every time any one tries to use a shared server connection , I find that after the execution of any query the processor usage shoots up to 95-98%. I have two dispatchers configured , and whenever I specify pool=on , I see the following : As long as the shared server connection is maintained the processor usage remains high and the v$dispatcher_rate(CUR_LOOP_RATE) and v$dispatcher_rate( CUR_EVENT_RATE ) values for the concerned dispatcher go on increasing steadily even though there is only one user and he is sitting idle. If this user logs off, cpu usage falls down to normal. This happens with any user who tries to use a shared server connection. No such problem if a dedicated connection is used. If I restart the instance after setting pool=off then there is no such problem. Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Re: 10g: SQL Plus
In nt cmd shell , you could make copy pasting easy by going into properties and selecting 'quick edit mode' . In fact you could make this behaviour the default by choosing 'save properties for future windows with same title'. Then you need not select mark and copy , etc . Just use the right and left mouse buttons. I prefer the cmd shell because of its excellent command history using arrow keys. In fact using the F7 key allows me to choose the command i want . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 21:14 Losing the pseudo-GUI version would be a a drag, because it's so easy to copy and paste text in it (not so easy in a Windows command prompt). Try right click - paste or click the upper left icon and choose paste To copy - choose mark then enter -its then in the clipboard Ive actually began to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hiding passwords
In ntfs you can set permissions on a file . But that wouldn't stop a member of the adminstrator group. What you need to do is to aditionally encrypt the file or folder as well. Then no one else can even list the contents of the folder, not even another administrator. In xp its as easy as right clicking the file/folder , select properties , advanced, 'encrypt contents to secure data'. Now every time you need access just double click the file/folder. Decryption is allowed only for you and occurs on the fly and transparently. But make sure you backup your certificates just in case the system crashes and you have to reinstall. You can then import your certificates and decrypt this folder. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 18:49 In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Patrice. -Original Message- Sent: Wednesday, September 24, 2003 9:55 AM To: Multiple recipients of list ORACLE-L Jared, You said: One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. This is true. But to accomplish the same functionality, you can dynamically create a temporary .bat file that creates the environmental and then execute that bat file. Unfortunately on Windows, anything that you do can be repeated by someone else who logs onto the system. I guess you could secure a folder that only the Oracle account could see, and have these scripts placed in those folders so that the other users cannot get into them without rebooting the machine and bringing it up in DOS mode. That (I think) would prevent snooping. Not sure though. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 23, 2003 6:00 PM To: Multiple recipients of list ORACLE-L Paul, Any chance these scripts could be run from Cygwin, Uwin, MKS Toolkit, or anything that will let you use a korn shell? That would simplify things tremendously. One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. That ability would make this task simple from command.com. Another possibility is to put your passwords in the registry, restrict that portion of the registry, ( or the whole thing ), and use a Perl script to retrieve the passwords and kick off the other jobs. What I do in linux is use a password server ( as seen in Perl for Oracle DBA's) and retrieve the password across the network, encrypted of course. This works on windows as well, though you're there restricted to doing this strictly from within the Perl script. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 01:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwords Tom, As Dave Barry would say, Har! Unfortunately, we are talking about 3rd-party people who have the 'right' to log in for support (debugging their ^%(^#@ products, and installing updates). I've got them under local admin accounts (as opposed to domain accounts), so they can only get to their own servers. BUT... that's as far as I can go to secure things except at the folder level (and Oracle loves it (!) when you try and do folder security on the datafiles, controlfiles, etc.). I appreciate the thought, but you did not go far enough... Kill them all, and save on security hardware. Any workable ideas? Desperately yours, Paul R. Sherman DBA/Sr. Appl. Analyst Bacou-Dalloz office - 401-232-1200 x200 cell- 401-935-2802 Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwords Paul, It's simple really. Do not allow them to log-on to the Win2k server - don't give them an account; keep the passwords secret; and keep the machine in a locked room. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 23, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Hello, If you do that in Win2k, then you have more env variables for 'authorized' people to see when they do a SET cr. Now, to be frank, I have an ulterior (a 'maxed-out' interior or exterior) motive in this reply. I have yet to see an intelligent (never mind elegant) of protecting system variables from someone's view when they do a SET in a DOS session. You can keep them out of Control Panel/System/Advanced/Environmental Variables, but you can't keep them out of DOS, so whaddya do? That's what
guidance
List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shared server connections
Hello list, I am using 9.2.0.1.0 enterprise edition on windows. I have a database in shared server mode. Every time any one tries to use a shared server connection , I find that after the execution of any query the processor usage shoots up to 95-98%. I have two dispatchers configured , and whenever I specify pool=on , I see the following : As long as the shared server connection is maintained the processor usage remains high and the v$dispatcher_rate(CUR_LOOP_RATE) and v$dispatcher_rate( CUR_EVENT_RATE ) values for the concerned dispatcher go on increasing steadily even though there is only one user and he is sitting idle. If this user logs off, cpu usage falls down to normal. This happens with any user who tries to use a shared server connection. No such problem if a dedicated connection is used. If I restart the instance after setting pool=off then there is no such problem. Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 10g: SQL Plus
They were supposed to get rid of sqlplusw - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 22, 2003 23:09 Hej Jay Yes it stil there :-) Jay Wade wrote: Hello: Was watching Larry Ellison's key note and he mentioned that they still have SQL Plus in 10g. I heard rumor that it was removed. Since it seems as though some from this list have seen it does it still have SQL Plus or has it been removed? Thanks In Advance, Jay _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
query rewrite system privilege
List, I finally got an answer to the problem I was facing with materialized views and the 'query rewrite' system privilege . Thanks for all your help especially mladen and thomas. - Original Message - To: [EMAIL PROTECTED] Sent: Saturday, September 20, 2003 00:42 Hello, The answer to your question is that the query rewrite system privilege has been deprecated in Oracle 9i. So the behavior you see is correct. I think we need to fix the documentation. Also, the user does not need special privileges to enable query rewrite in the session or for queries to get rewritten with materialized views. All privilege checks are done only when creating the materialized view (similar to an index). Regards, Shilpa Lawande. [EMAIL PROTECTED] wrote: I am using oracle 9.2.0.1.0 enterprise edition on windows A user in my database is able to create materialized views with query rewrite enabled. But I have not given him 'query rewrite' system privilege. Isn't it required to create a mat. view with query rewrite enabled ? I quote from Oracle9i SQL Reference docs : To create a materialized view in another user's schema You must have the CREATE ANY MATERIALIZED VIEW system privilege. ...To create the materialized view with query rewrite enabled, in addition to the preceding privileges The owner of the master tables must have the QUERY REWRITE system privilege. If you are not the owner of the master tables, you must have the GLOBAL QUERY REWRITE system privilege or the QUERY REWRITE object privilege on each table outside your schema. SQL sho user USER is SYS SQL create user test identified by test 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users; User created. SQL grant create session, create table, create materialized view to test ; Grant succeeded. SQL connect test/[EMAIL PROTECTED] Connected. SQL create table master as select * from user_tables ; Table created. create materialized view mymatview tablespace users build immediate refresh on demand enable query rewrite as select table_name, count(*) from master group by table_name; Materialized view created. How was this user able to create this materialized view with query rewrite enabled ? Not only this , I find that this user is also able to enable query rewrite in his session also, as I show below : SQL alter session set optimizer_mode=choose; Session altered. SQL alter session set query_rewrite_enabled=true; Session altered. SQL alter session set query_rewrite_integrity=enforced; Session altered. SQL @?\rdbms\admin\utlxplan Table created. SQL set autotrace traceonly explain SQL analyze table master compute statistics; Table analyzed. SQL select table_name, count(*) from master group by table_name; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3 Card=204 Bytes=612 0) 10 TABLE ACCESS (FULL) OF 'MYMATVIEW' (Cost=3 Card=204 Bytes= 6120) Any ideas as to how all this was possible without 'query rewrite' or 'global query rewrite' ? I would be very grateful if you could explain what I am doing wrong . I fear this might be an RTFM type of mistake on my part. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
pct_direct_access for a secondary index on an iot
Hello list, I am unable to get a value in dba_indexes(pct_direct_access) for a bitmap index I created on an iot. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Can someone help me by telling me what I need to do. I have done the following : --First create the iot with a mapping table. sql create table countries ( country_id char(2) , country_name varchar2 (40) , currency_name varchar2(25), constraint country_c_id_pk primary key (country_id ) ) organization index including country_name pctthreshold 20 tablespace users overflow tablespace indx mapping table; Table created. SQL insert into HR.countries values ( 'C', 'A', NULL ) ; 1 row created. SQL insert into HR.countries values ( 'D', 'A', NULL ) ; 1 row created. SQL insert into HR.countries values ( 'E', 'A', NULL ) ; 1 row created. SQL COMMIT ; Commit complete. --Now create a bmp index on it. SQL create bitmap index myindex on countries (country_name ) ; Index created. --This command should analyze the iot and its mapping table. SQL analyze table countries compute statistics; Table analyzed. --Might as well analyze the bmp index ( this does no harm right ? ) SQL analyze index myindex compute statistics; Index analyzed. SQL select index_name, pct_direct_access from DBA_indexes where index _name = 'MYINDEX' and owner=user; INDEX_NAME PCT_DIRECT_ACCESS -- - MYINDEX --As you can see I get a null value in the pct_dircect_access column. .Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 'query rewrite' system privg
So then a user without query rewrite system privg, would be able to create a materialized view with enable query rewrite clause, but not enable query rewrite for himself. But this user without query rewrite system privg, would still be able to sucessfully execute : alter session set query_rewrite_enabled=true; wouldn't that enable query rewrite for him ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 20:54 My guess is that just because the Mat View is enabled for query rewrite doesn't mean that it's going to happen. The Query Rewite attribute on the Mat View probably indicates that it is eligible for rewrite. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 16, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Hello list , I am using oracle 9.2.0.1.0 enterprise edition on windows A user in my database is able to create materialized views with query rewrite enabled. But I have not given him 'query rewrite' system privilege. Isn't it required to create a mat. view with query rewrite enabled ? drop user test cascade; create user test identified by test default tablespace users temporary tablespace temp quota unlimited on users; grant create session, create table, create materialized view to test ; Now this user is able to create materialized view mymatview tablespace users build immediate refresh on demand enable query rewrite as select * from dual ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL help needed
Hey there kirti , good to have you back. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 19:09 Hello All, Thanks for your wonderful ideas. I just forwarded those to my dear Developer (my wife, that is :) After posting my question to the list last night, I was told that the query will be run against an Informix database :) Typical Developers !!! ;) Cheers! - Kirti --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: Hello Listers, I need some SQL help. Not sure if this is possible in plain SQL or not, but here it is: I have a table with two columns: EMPNBR LINENBR -- --- 100 1 200 4 300 8 400 9 50014 How would I find out the missing linenbrs (2,3,5,6,7) if I was given minlinenbr as 1 and maxlinenbr as 10 that would be passed as variables (using ). Thanks. - Kirti __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 'query rewrite' system privg
Mladen , so what you are saying is that even if a user doesn't have 'query rewrite' privg but has create materialized view privg he can create a materialized view with query rewrite enabled and sucessfully execute 'alter session set query_rewrite_enabled=true;' but even then query rewrite wouldn't be enabled for him ? I tried this out, it doesn't seem to be that way . But I don't really know much about Oracle , so please can you explain this to me some more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 20:54 Nope. It's required to use it, not to create it. By enabling query rewrite, you enable the RDBMS to rewrite your query and use it to resolve your select, even if the view itself was not mentioned in it. You can always create material view and do select from it. Material views are snapshots with fancy names. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Subject: 'query rewrite' system privg Hello list , I am using oracle 9.2.0.1.0 enterprise edition on windows A user in my database is able to create materialized views with query rewrite enabled. But I have not given him 'query rewrite' system privilege. Isn't it required to create a mat. view with query rewrite enabled ? drop user test cascade; create user test identified by test default tablespace users temporary tablespace temp quota unlimited on users; grant create session, create table, create materialized view to test ; Now this user is able to create materialized view mymatview tablespace users build immediate refresh on demand enable query rewrite as select * from dual ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
'query rewrite' system privg
Hello list , I am using oracle 9.2.0.1.0 enterprise edition on windows A user in my database is able to create materialized views with query rewrite enabled. But I have not given him 'query rewrite' system privilege. Isn't it required to create a mat. view with query rewrite enabled ? drop user test cascade; create user test identified by test default tablespace users temporary tablespace temp quota unlimited on users; grant create session, create table, create materialized view to test ; Now this user is able to create materialized view mymatview tablespace users build immediate refresh on demand enable query rewrite as select * from dual ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: pct_direct_access for a secondary index on an iot
Resending , didn't seem to have reached the list the first time. Hello list, I am unable to get a value in dba_indexes(pct_direct_access) for a bitmap index I created on an iot. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Can someone help me by telling me what I need to do. I have done the following : --First create the iot with a mapping table. sql create table countries ( country_id char(2) , country_name varchar2 (40) , currency_name varchar2(25), constraint country_c_id_pk primary key (country_id ) ) organization index including country_name pctthreshold 20 tablespace users overflow tablespace indx mapping table; Table created. SQL insert into HR.countries values ( 'C', 'A', NULL ) ; 1 row created. SQL insert into HR.countries values ( 'D', 'A', NULL ) ; 1 row created. SQL insert into HR.countries values ( 'E', 'A', NULL ) ; 1 row created. SQL COMMIT ; Commit complete. --Now create a bmp index on it. SQL create bitmap index myindex on countries (country_name ) ; Index created. --This command should analyze the iot and its mapping table. SQL analyze table countries compute statistics; Table analyzed. --Might as well analyze the bmp index ( this does no harm right ? ) SQL analyze index myindex compute statistics; Index analyzed. SQL select index_name, pct_direct_access from DBA_indexes where index _name = 'MYINDEX' and owner=user; INDEX_NAME PCT_DIRECT_ACCESS -- - MYINDEX --As you can see I get a null value in the pct_dircect_access column. .Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
db_file_multiblock_read_count
Hello list, seeking your personal opinions and experiences about db_file_multiblock_read_count. What do you all set your db_block_size and db_file_multiblock_read_count to? How did you all come to decide that those values would suit your systems ? Any windoze user here who can tell me how can one find out the max operating system I/O size (on windows) in order to set db_file_multiblock_read_count ? .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03113 on using create_stored_outlines
Hello list I need your help with a problem I am having whenever I start using outlines. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Suppose two users scott and hr have select any table, create any outline privileges and select_catalog_role. SQL conn scott/[EMAIL PROTECTED] Connected. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=hr; Session altered. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL create table test as select * from scott.emp ; create table test as select * from scott.emp * ERROR at line 1: ORA-03113: end-of-file on communication channel (And I get a core dump file ) The same thing happens irrespective of the category name I use in alter session set create_stored_outlines , even when i specify alter session set create_stored_outlines=default;, and even when I use random values. But when I do the following then no problems : SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=false; Session altered. SQL create table test as select * from scott.emp ; Table created. Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Resynchronizing the stored outline definition
Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from private test * ERROR at line 1: ORA-18004: outline already exists However the following succeeds : SQL exec dbms_outln_edit.refresh_private_outline ('TEST' ) ; PL/SQL procedure successfully completed. Any ideas why the identitiy statement fails ? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: alter system reset
You are correct arup The parameter originally existed as *.parameter=value After running alter system set parameter=value sid='lahiri' ; it now exists as lahiri.parameter=value So either I specify the sid name while setting the parameters or I should use the following to reset the parameters alter system reset parameter sid='*' ; Thanks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 20:29 ALTER SYSTEM RESET applies to RACs only and you need to give the SID parameter. When you said I find that shared_pool_size exists there, did it exist as the follwoing? *.shared_pool_size=... I bet it did. Note how you used the SID in setting the value alter system set shared_pool_size=40M scope=spfile sid='lahiri' ; This properly set the value for the SID lahiri, not globally. That is why the RESET operation was successful after the SET operation. The same is true for any other parameters that is reset. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 3:29 AM Yes , opened up spfile in a text editor and undo_suppress_errors exists. But I get the error , no matter which parameter I try to reset. ex: undo_management, undo_tablespace, undo_retention, pga_aggregate_target, workarea_size_policy, shared_pool_size, sort...etc, etc However when I open the spfile I find that shared_pool_size exists there , then I try resetting it (just to test it out) SQL alter system reset shared_pool_size scope=spfile sid='lahiri' ; alter system reset shared_pool_size scope=spfile sid='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE SQL alter system set shared_pool_size=40M scope=spfile sid='lahiri' ; System altered. SQL alter system reset shared_pool_size scope=spfile sid='lahiri' ; System altered. Why does this happen ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 00:44 Does the entry even exist in the SPFILE? Open up the spfile in notepad and check the existence of the parameter in there. Do the following: SQL alter system set undo_suppress_errors = false scope=spfile sid='ananda'; System altered. SQL ALTER SYSTEM RESET undo_suppress_errors scope=spfile sid='ananda'; System altered. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 2:14 PM Hello list I am using Oracle 9.2.0.1.0 enterprise on windows. When I run the following ( connected as sysdba , and using an spfile called %oracle_home%\database\spfilelahiri.ora ) SQL show user USER is SYS SQL host echo %oracle_sid% LAHIRI SQL sho parameter db_name NAME TYPE VALUE db_namestring lahiri SQL ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'; ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE Any ideas ? I get the same problem irrespective of the parameter I try to reset. .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network
Re: Privileges associated with Role
dba_sys_privs role_sys_privs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 21:44 Hi List How to look for all the privileges associated with particular Role(for example R1)? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Resynchronizing the stored outline definition
Duh,oh Thanks But Jared , the problem was that the FM itself told me to type : CREATE PRIVATE OUTLINE p_ol1 FROM PRIVATE p_ol1; Ref : Oracle 9i Database Performance Tuning Guide and Reference a96533.pdf page 7-9 , Chapter 7 : Using Plan Stability to Preserve Execution Plans, Section : Example of Editing Outlines Would really appreciate your input about the ora-03113 and core dump problem I keep getting when I use create_stored_outlines : Suppose two users scott and hr have select any table, create any outline privileges and select_catalog_role. SQL conn scott/[EMAIL PROTECTED] Connected. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=hr; Session altered. SQL select count (*) from scott.emp ; COUNT(*) -- 6 SQL create table test as select * from scott.emp ; create table test as select * from scott.emp * ERROR at line 1: ORA-03113: end-of-file on communication channel (And I get a core dump file ) The same thing happens irrespective of the category name I use in alter session set create_stored_outlines , even when i specify alter session set create_stored_outlines=default;, and even when I use random values. But when I do the following then no problems : SQL conn hr/[EMAIL PROTECTED] Connected. SQL alter session set create_stored_outlines=false; Session altered. SQL create table test as select * from scott.emp ; Table created. Any ideas ? . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 21:14 Perhaps some RTFM is in order here. A studios examination of the fine docs might suggest 'create or replace'. Jared On Tue, 2003-09-09 at 05:59, [EMAIL PROTECTED] wrote: Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from private test * ERROR at line 1: ORA-18004: outline already exists However the following succeeds : SQL exec dbms_outln_edit.refresh_private_outline ('TEST' ) ; PL/SQL procedure successfully completed. Any ideas why the identitiy statement fails ? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: alter system reset
Yes , opened up spfile in a text editor and undo_suppress_errors exists. But I get the error , no matter which parameter I try to reset. ex: undo_management, undo_tablespace, undo_retention, pga_aggregate_target, workarea_size_policy, shared_pool_size, sort...etc, etc However when I open the spfile I find that shared_pool_size exists there , then I try resetting it (just to test it out) SQL alter system reset shared_pool_size scope=spfile sid='lahiri' ; alter system reset shared_pool_size scope=spfile sid='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE SQL alter system set shared_pool_size=40M scope=spfile sid='lahiri' ; System altered. SQL alter system reset shared_pool_size scope=spfile sid='lahiri' ; System altered. Why does this happen ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 00:44 Does the entry even exist in the SPFILE? Open up the spfile in notepad and check the existence of the parameter in there. Do the following: SQL alter system set undo_suppress_errors = false scope=spfile sid='ananda'; System altered. SQL ALTER SYSTEM RESET undo_suppress_errors scope=spfile sid='ananda'; System altered. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 2:14 PM Hello list I am using Oracle 9.2.0.1.0 enterprise on windows. When I run the following ( connected as sysdba , and using an spfile called %oracle_home%\database\spfilelahiri.ora ) SQL show user USER is SYS SQL host echo %oracle_sid% LAHIRI SQL sho parameter db_name NAME TYPE VALUE db_namestring lahiri SQL ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'; ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE Any ideas ? I get the same problem irrespective of the parameter I try to reset. .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: alter system reset
Mladen , you seem to be correct, I checked the spfile and the parameters I try to modify exist there, but reseting them takes one extra step Say for example I find that undo_suppress_errors=false in the spfile. Now if I try SQL alter system reset undo_suppress_errors scope=spfile sid='lahiri' ; alter system reset undo_suppress_errors scope=spfile sid='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE However the following works : SQL alter system set undo_suppress_errors =false scope=spfile sid='lahiri' ; System altered. SQL alter system reset undo_suppress_errors scope=spfile sid='lahiri' ; System altered. This problem is not present in 9.2.0.4 ? Thanks for the help. ... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 12:59 Arup, problem is in the version. I've had the very same problem, plus some more (occasionally, database wouldn't start after changing parameters) with 9.2.0.1. The latest greatest version is, as you are very well aware, 9.2.0.4 and it works like a charm. On 2003.09.01 15:14, Arup Nanda wrote: Does the entry even exist in the SPFILE? Open up the spfile in notepad and check the existence of the parameter in there. Do the following: SQL alter system set undo_suppress_errors = false scope=spfile sid='ananda'; System altered. SQL ALTER SYSTEM RESET undo_suppress_errors scope=spfile sid='ananda'; System altered. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 2:14 PM Hello list I am using Oracle 9.2.0.1.0 enterprise on windows. When I run the following ( connected as sysdba , and using an spfile called %oracle_home%\database\spfilelahiri.ora ) SQL show user USER is SYS SQL host echo %oracle_sid% LAHIRI SQL sho parameter db_name NAME TYPE VALUE db_namestring lahiri SQL ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'; ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE Any ideas ? I get the same problem irrespective of the parameter I try to reset. .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
Re: How can I measure my DB performance.
I too have mine setup to take a snapshot every 15 minutes. Can you teach me how to automate purges using sppurge.sql ? Thanks . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 06:04 Start by installing and configuring statspack. I have mine setup to take a snapshot every 15 minutes. It collects a lot of data, I am now in the midst of automating a purge process. :) Then implement YAPPPACK from http://www.miracleas.dk/en/tech.html and use the data to create response time charts. At least, that's one way to do it. Jared Jake Johnson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/28/2003 04:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How can I measure my DB performance. Is there a standard query I can run to compare the performance of a db. (Kind of like bogomips for unix) Thanks, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Tires, and Wheel Packages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jake Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to find the session holding the library cache pin.
run catblock.sql to create dba_blockers and dba_waiters @?\rdbms\admin\catblock.sql - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 01:54 dba_blockers this doesnt install by default. i cant remember which script runs it. check metalink. warning... its a VERY slow view. From: Murali_Pavuloori/[EMAIL PROTECTED] Date: 2003/08/28 Thu PM 04:14:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to find the session holding the library cache pin. Gurus: One of the developers has changed his java code and wants to load the class into the db. He did this on production db while users are accessing the application...and then complained that his session is just sitting in idle state I queried the v$session_wait and found that his session is waiting for the library cache pinquestion is how to tell which session is holding the enqueue? Thanks in advance for your help. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
book
Hello list any recommendations about buying a book on oracle internal working , oracle kernel ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: book
Sorry to repost but forgot to mention, that I needed a book for Oracle 9i Hello list any recommendations about buying a book on oracle internal working , oracle kernel ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alter system reset
Hello list I am using Oracle 9.2.0.1.0 enterprise on windows. When I run the following ( connected as sysdba , and using an spfile called %oracle_home%\database\spfilelahiri.ora ) SQL show user USER is SYS SQL host echo %oracle_sid% LAHIRI SQL sho parameter db_name NAME TYPE VALUE db_namestring lahiri SQL ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'; ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE Any ideas ? I get the same problem irrespective of the parameter I try to reset. .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
V$cache
Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say that this is an Oracle9i Real Application Clusters view. But so is V$BH and I am able to query that when connected as sys . . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: V$cache
Sorry for the trouble list. found out need to run ?\rdbms\admin\catclust.sql thanks - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 13:46 Hello list, I am using Oracle9i Enterprise Edition Release 9.2.0.1.0 on windows. I get 'object does not exist' error when I try to query the V$cache. The docs say that this is an Oracle9i Real Application Clusters view. But so is V$BH and I am able to query that when connected as sys . .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hey Jared
Sobig -F does carry out spoofing , but Jared here is a question : either which way (spoofed or not) wouldn't list-guru remove all attached binaries ? Anyway I am not going to open any such mails. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 25, 2003 23:25 Wasn't from me. Our virus checker here at work would stop it. From home I use Linux, so I'm not propagating virusii from there. That would require that I manually forward a message with a virus. That is also not likely, since my ISP stops those. A virus will spoof someones email address when that address is found in the address book of the infected machine, typically a PC running Outlook. As SoBig has it's own SMTP engine, this is likely what happened. Jared Dilip Patel [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/25/2003 10:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Hey Jared Jared, Did you send the list/me some mail with Your Details as subject line. It has some .pif file as extention. Maybe that is some virus, So wanted to make sure before i open it. Thanks. From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Nature of Oracle-l has changed Date: Mon, 25 Aug 2003 04:39:17 -0800 Here's a perfect example of an email that should never have been sent. Sigh... I'll learn one of these days. This does not characterize the people I work for, as they're a pretty good bunch and actually do understand technology. It's more of a generalized rant fueled by past experiences. Should have hit 'delete' on this one instead of 'send'. Jared On Sun, 2003-08-24 at 11:19, Jared Still wrote: Mladen, My version of the explanation of this goes back to childhood. When you were in school, just which crowd were those execs in? The 'in' crowd, the jocks, the party hounds. If like me, you were one of the 'eggheads', you didn't fit in so well with their clique, and maybe you still don't. When in school, I was told I would be more popular if I wasn't so smart. I was even told that once as an adult. After pondering that for a bit, I decided they could all bite the green weenie if they didn't like it. This is probably how I earned my Hawkeye Pierce like cynicism, which I do work hard at keeping in check, lest it cause me more problems with the former 'in' folk that I now work for. 'They' don't like it when people are smarter than they are, and understand things they don't understand, and can't hope to understand. Hmm, this is getting a but cynical, so I guess I'll stop before I provide too much fodder for an HR type that has finally learned how to use google. Jared On Sat, 2003-08-23 at 17:19, Mladen Gogala wrote: On 2003.08.23 18:34, Tim Gorman wrote: Six years ago, a CIO commented to me, waving down a corridor which had offices full of developers, If I had my way, I'd get rid of all of them and replace them with lawyers. We'd buy applications instead of building them and then sue the vendors. My response was something along the lines of if you think developers are expensive, go price some lawyers, but it certainly bounced off him. At the time, I took it as just another colorful comment from a colorful guy. But he was dead serious, along with his CIO/CFO brethren, and the passing of Y2K and the dot-com bubble pop has expedited his prediction... I always wondered where does this prejudice against us, computer geeks (my apologies to anyone offended by that expression, but I'm a hard core computer geek) comes from? I must say that this prejudice is very hard to understand. IT people are very well educated, very hard working, regularly willing to work long hours and sacrifice their weekends for the benefit of the company. I found that very same attitude against the darned geeks at several executives and managers of several companies I worked for. Even if lawyers are much more expensive the programmers, system and database administrators, application designers, they are still very willing to make the switch. I'm not quite sure why are we so hated? Why would anyone want to kill a nice and seet little wabbit? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
Killing jobs
Hello list Q1. How can a dba remove the a job scheduled by another user ? DBMS_JOB does not allow a user to touch any jobs except their own. Q2. Every time I schedule a job using dbms_job it doesn't show up properly in dba_jobs or all_jobs or user_jobs until I logoff and log on again . Let me explain : I have scheduled a job as scott on my test database 9iRelease 2 9.2.0.1.0 on windows. There is a table called Test in the scott schema . It has a single column of type date. I want to insert date into it every 30 seconds. I ran the following as scott : variable jobno number ; variable instno number ; begin select instance_number into :instno from v$instance; dbms_job.submit ( job = :jobno, what = 'insert into scott.test values( sysdate ); commit ; ', next_date = trunc (sysdate + 1/(24*60), 'MI'), interval = 'sysdate + 1 / (24*60*2)', no_parse = true, instance = :instno, force = false ) ; end ; / print jobno This completed sucessfully. at time 13:13:43 hrs Now I check user_jobs select JOB, last_date, next_date, next_sec from user_jobs where job = :jobno; JOB LAST_DATENEXT_DATE -- ----- 5 24-aug-003 13:14:00 I checked again at 13:14:30 , 13:15:00 , 13:15:30 , 13:16:00 , 13:16:30 , etc and it always says the same as above. (null value in last_date and 13:14:00 as next_date) I logout at 13:17:00 and log back in. Now when I run the query I get JOB LAST_DATENEXT_DATE -- ------ 724-aug-003 13:17:05 24-aug-003 13:17:35 and the scott.test table has a single value select * from scott.test ; 24-aug-003 13:17:05 Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem with Autotrace ?
I don't know much about Oracle, Is there a spelling mistake in the command you gave ? SQL set autot trace - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 28, 2003 09:19 Guys, when i try the same from a different machine,i get the error below. { this client machine has 9.2.0.2/Win2K server - with SP3 } SQLconnect cti/[EMAIL PROTECTED]; SQLset autot trace SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report .seems to be unusual.isn't it ? had anyone faced the same problem ? can someone help me out. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
session_cached_cursors
Hello list , Performance tuning docs say that : To enable the caching of session cursors you must set the initialization parameter set session_cached_cursors. You can also enable it dynamically with alter session set But neither of the following works on 9.2.0.1.0 enterprise edition (win32) alter system set session_cached_cursors=10 scope=memory; alter system set session_cached_cursors=10 scope=spfile; alter system set session_cached_cursors=10 scope=both; However this works alter session set session_cached_cursors=10 ; Why ? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Advice needed on dbms_shared_pool value
Hi Tanel , I was preparing for the 9i performance tuning exam , that is why I was dealing with stuff like DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD. I know its even below the last possible thing you would want to tune in real life, but theoretical stuff seems to be a favourite with ocp sometimes. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 26, 2003 06:04 Hi! Why do you want to tune this parameter? I've never needed it? I suggest just to keep it as it is if you don't have very specific shared pool problems. And usually those problems come from bad application or bugs anyway... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 26, 2003 12:59 AM Hello list I needed your advice on the following : 1. What value do you all specify in DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) ? (1.a.) Should it be set equal to the shared_pool_size ? (1.b.) Should it be greater than shared_pool_size ? (But wouldn't that be impossible. The free list would not be able to service a user request for a size greater than the shared_pool_size) (1.c) Should it be set equal to shared_pool_size minus shared_pool_reserved_size. ( I am not clear on this . Please tell me : can the free list service a request by taking space from the reserved area AND the rest of shared pool or is it 'one or the other and not both together' ) 2. After sucessfully executing DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) (2.a) why doesn't the 'value' show up in select aborted_request_threshold from v$shared_pool_reserved ; ? (2.b) Where would I look to see the change ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dbms_job
Hello list, I am running 9.2.0.1.0 enterprise edition on win32. Why doesn't the Supplied PLSQL Packages and Types Reference docs mention dbms_system ? It doesn't seem to be explained anywhere in the docs although the admin docs say that it can be used enable sql_trace for another session. I was able to do that only after learning about its parameters thru : sql describe dbms_system while I was logged in as sysdba. .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_SHARED_POOL
Hello list, 1. Can the following statement be executed sucessfully only by the sysdba ? EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD (25165824 ) ; 2. ?\rdbms\admin\dbmspool.sql creates dbms_shared_pool . And it explicitly grants execute on dbms_shared_pool to execute_catalog_role. Still I cannot run the above statement when connected as system/manager on my 9.2.0.1.0 enterprise edn on windows. I get the following errors : SQL sho user USER is SYSTEM SQL EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 25165824 ) ; BEGIN DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 31457280 ) ; END; * ERROR at line 1: ORA-04068: existing state of packages has been discarded ORA-04063: package body SYSTEM.DBMS_SHARED_POOL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 3. However When I run as sysdba, no problems SQL sho user USER is SYS SQL EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 25165824 ) ; PL/SQL procedure successfully completed. Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbms_job
Thanks pete - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 26, 2003 02:44 Hi The package dbms_system is now private, the body and header are both created in $ORACLE_HOME/rdbms/admin/prvtutil.plb. The sql file $ORACLE_HOME/rdbms/admin/dbmsutil.sql has the following in it now: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Advice needed on dbms_shared_pool value
Hello list I needed your advice on the following : 1. What value do you all specify in DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) ? (1.a.) Should it be set equal to the shared_pool_size ? (1.b.) Should it be greater than shared_pool_size ? (But wouldn't that be impossible. The free list would not be able to service a user request for a size greater than the shared_pool_size) (1.c) Should it be set equal to shared_pool_size minus shared_pool_reserved_size. ( I am not clear on this . Please tell me : can the free list service a request by taking space from the reserved area AND the rest of shared pool or is it 'one or the other and not both together' ) 2. After sucessfully executing DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) (2.a) why doesn't the 'value' show up in select aborted_request_threshold from v$shared_pool_reserved ; ? (2.b) Where would I look to see the change ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbms_job
Thanks chris. Let me know if you find out anything more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 25, 2003 23:39 It would seem that dbms_system has become undocumented. It used to be partially documented, e.g. there was a description of set_sql_trace_in_session, but they seem to have pulled that as of 8.1. You're supposed to use dbms_support now, but that too seems to be undocumented. At least on Solaris, you have to beg support for the 8i install script, but the 9i install script is included in $ORACLE_HOME/rdbms/admin. There are some notes about this in some of the forums at metalink ( I searched 'dbms_system dbms_support'). HTH, -Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: dbms_job Hello list, I am running 9.2.0.1.0 enterprise edition on win32. Why doesn't the Supplied PLSQL Packages and Types Reference docs mention dbms_system ? It doesn't seem to be explained anywhere in the docs although the admin docs say that it can be used enable sql_trace for another session. I was able to do that only after learning about its parameters thru : sql describe dbms_system while I was logged in as sysdba. .. LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Exam
Hi list, I am going to give my Oracle 9i dba fundamentals II ( backup, recovery , networking) exam tomorrow (7th july) . Any last minute advice ? Really nervous about it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: controlfile backup obsolete above 2 days
Thanks chip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 11:10 : MetaLink Bug 2458246 (fixed in 9.2.0.2) : : DENNIS WILLIAMS wrote: : : Offhand it sounds to me like you may have uncovered an error. I would search : metalink and if you don't find an error matching this situation, I would : file a TAR. : : Dennis Williams : DBA, 80%OCP, 100% DBA : Lifetouch, Inc. : [EMAIL PROTECTED] : : : -Original Message- : Sent: Friday, June 20, 2003 9:34 PM : To: Multiple recipients of list ORACLE-L : : : Hello list : sorry to trouble you all so much, : I tried all that I stated below on another database I created, and as : long as I don't use an spfile , no problem. As soon as I start using : an spfile , I always get my backup shown as obsolete , irrespective of : the number of days (the value of n) I specify in ''report obsolete : recovery window of n days; '' . : Also a few more details , previously i was getting the problem on a : 9.2.0.1.0 enterprise edition database in noarchivelog mode. The : problem I stated above is on a 9.2.0.1.0 enterprise edition database : in archivelog mode with automatic archiving enabled. All this on : win32. : : : : - Original Message - : To: [EMAIL PROTECTED] : Sent: Saturday, June 21, 2003 00:28 : : : : Hello list : : I was having problems with my controlfile backups being reported as : : obsolete ; : : I have narrowed down the problem to the number of days specified in : : the recovery window . : : : : 1. My control_file_record_keep_time=7 : : : : 2. Suppose I start rman and there are no backups yet. (This is : : confirmed by the commands : : : delete noprompt force backup ; : : delete nopromt force copy ; : : list backup ; (This shows no o/p confirming that there are no : : backups ) : : list backup of controlfile ; (This shows no o/p confirming that : there : : are no backups ) : : : : 3. All the rman configuration settings are at their default values : . : : I did not modify any , and just to be sure I checked using 'show all : : ;' : : : : 4. Now I backup the database : : : backup database ; : : : : As expected it creates a single set with a single piece whose name : is : : in the o/p: : : : : channel ORA_DISK_1: finished piece 1 at 21-Jun-2003 00:13:01 : : piece handle=D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 comment=NONE : : channel ORA_DISK_1: backup set complete, elapsed time: 00:00:28 : : Finished backup at 21-Jun-2003 00:13:01 : : : : : : 5. I confirm this by using 'list backup ;' and : : list backup of controlfile ; : : : : 6. NOW THE PROBLEM IS : : : : : : : RMAN report obsolete recovery window of 1 days ; : : : : no obsolete backups found : : : : : : RMAN report obsolete recovery window of 2 days ; : : : : no obsolete backups found : : : : : : : : RMAN report obsolete recovery window of 3 days ; : : : : Report of obsolete backups and copies : : Type KeyCompletion TimeFilename/Handle : : - -- -- : : Backup Set3 21-Jun-2003 00:12:52 : : Backup Piece 3 21-Jun-2003 00:12:52 : : D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 : : : : Why is this happening for all values above 2 days ? : : Please advise : : . : : : : : : : : : -- : Please see the official ORACLE-L FAQ: http://www.orafaq.net : -- : Author: Chip : INET: [EMAIL PROTECTED] : : Fat City Network Services-- 858-538-5051 http://www.fatcity.com : San Diego, California-- Mailing list and web hosting services : - : To REMOVE yourself from this mailing list, send an E-Mail message : to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in : the message BODY, include a line containing: UNSUB ORACLE-L : (or the name of mailing list you want to be removed from). You may : also send the HELP command for other information (like subscribing). : -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sql loader question
Hello list I have a doubt regarding the following question : ** SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario? A. direct-path load B. conventional path load Answer : Direct-path load , ( It is said free blocks which implies Direct-Path Load, because Conventional-Path Load also use partially filled blocks. ) *** Shouldn't it be conventional path load, because insert commands are being used . Direct path load builds blocks of data in memory and saves these blocks directly into the extents allocated for the table being loaded -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Drop Tablespace
OMF ? What was the name of the file ? You can tell from that whether its omf or not. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 02:05 : Hi List, : : Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the : data file also disappeared from the list of datafiles, as I know the : datafile must be removed manually Any idea? : : I am using 9.0.1 on solaris 2.8 : : Thanks, : : Hamid Alavi : : Office : 818-737-0526 : Cell phone : 818-416-5095 : : -- : Please see the official ORACLE-L FAQ: http://www.orafaq.net : -- : Author: Hamid Alavi : INET: [EMAIL PROTECTED] : : Fat City Network Services-- 858-538-5051 http://www.fatcity.com : San Diego, California-- Mailing list and web hosting services : - : To REMOVE yourself from this mailing list, send an E-Mail message : to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in : the message BODY, include a line containing: UNSUB ORACLE-L : (or the name of mailing list you want to be removed from). You may : also send the HELP command for other information (like subscribing). : -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
exam
Hello list, I am planning to appear for my Oracle 9i database fundamentals II exam ( 1z0-032 ) on the 7th . I would be grateful for any advice , pointers ,etc. Bit nervous cause it looks tougher than 1z0-031 ( dba fundamentals 1 ) thanks ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Recovery Question: Restore with loss of control files and no catalo database
Hi Timothy , I am guessing about the following answers, and I work on 9.2.0.1.0 but anyway here goes : (1) How do I recover from a RMAN backup to disk if I have lost all the original database files (control files, data files and redo logs) In nomount First run SET DBID SET UNTIL SEQUENCE number THREAD 1; Then RESTORE CONTROLFILE ... FROM 'media_handle' or TAG; mount database; restore database; recover database ; open resetlogs database; Don't know the answer to the second question, let me know if you find out . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What are the restrictions in naming an Oracle SID/Database?
DB_NAME specifies a database identifier of up to 8 characters. The following characters are valid in a database name: alphanumeric characters, underscore (_), number sign (#), and dollar sign ($). No other characters are valid. Oracle removes double quotation marks before processing the database name. Therefore you cannot use double quotation marks to embed other characters in the name. The database name is case insensitive. In fact cannot use non-ASCII characters in a database name and in the create database statement. For example cannot use special characters from european \ asian character sets like characters with umlauts. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 30, 2003 21:19 : What are the restriction in naming an Oracle SID/Database? : : 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? : : 2. What is the maximum size of a SID/Database name in Unix? : : 3. What is the maximum size of a SID/Database name in Windows? : : 4. Is there any other restrictions? : : : : Thanks, : Ashoke : : -- : Please see the official ORACLE-L FAQ: http://www.orafaq.net : -- : Author: Mandal, Ashoke : INET: [EMAIL PROTECTED] : : Fat City Network Services-- 858-538-5051 http://www.fatcity.com : San Diego, California-- Mailing list and web hosting services : - : To REMOVE yourself from this mailing list, send an E-Mail message : to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in : the message BODY, include a line containing: UNSUB ORACLE-L : (or the name of mailing list you want to be removed from). You may : also send the HELP command for other information (like subscribing). : -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TSPITR or PITR
Hello list I came across the following question in the TMH exam guide for 1z0-032: Chris, a DBA, while performing maintenance tasks accidentally drops a very important table. What is the best method available for Chris to recover this table if he is aware of the time when the table was dropped? A . Change-based recovery B*. Point-in-time recovery C . Tablespace point-in-time recovery D . Cancel-based recovery Answer : Point-in-time recovery Wouldn't TSPITR be the best method available in general ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Advice
Hello list , I am planning to appear for my Oracle 9i database fundamentals II exam ( 1z0-032 ) on the 7th . I would be grateful for any advice , pointers ,etc. Bit nervous cause it looks tougher than 1z0-031 ( dba fundamentals 1 ) thanks ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).