RE: bind variables in VB using OO4O
Hi John , i have mailed a doc . have a look at it . Regards, Prem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Does anyone have examples of how to use bind variables in VB when using OO4O? John -- 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).
Thanx - I cleared the exam -- another OCP question
Hi list , thanx a lot to all of you . i cleared the #1Z0-031 exam last week . thanx again for all the support given by you friends. Kind 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).
RE: Thanx - I cleared the exam
Hi Dennis , thanx a lot for your encouraging words. my morale being high , let me go ahead with the next exam . Thanks and Regards, Prem. -Original Message- From: [EMAIL PROTECTED] Prem - We had no doubt. I always figure when you've studied enough to doubt your study guide, you're ready to pass the exam. Dennis Williams -- 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).
RE: Thanx - I cleared the exam
When I was doing my OCP exams, I didn't have Dennis to cheer me up, only Heineken.Not that I'm complaining. but Mladen , i can't stop with just one : )) so i better stay away from it during exams. 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).
test mail -- plz. ignore
test mail -- 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).
OCP question from Boson practice tests
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).
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 . - QUESTION #1 what happens when you issue the command below . drop tablespace testtbs including contents cascade constraints and datafiles; A.the tablespace will be dropped , constraints will be droppped and the datafiles will be taken out of the o/s. B. statement will fail C.you must drop constraints before issuing this command. this is what happens when i try on 9.2.0.4 : ERROR at line 1: ORA-02173: invalid option for DROP TABLESPACE but boson's choice is A. i wonder how ??? - 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 ? - so now i have the question whether boson is reliable ? how many in this list have used it ? or am i missing something : (( 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).
Re[1]: OCP question from Boson practice tests
Hi Richard , Many a thanx for both of your replies . All my worry is : do such questions appear in the real exams also ? And your reply has increased my self-confidence. particularly the line : RFTrust what you *see*, not what you *read*. /RF RFYou actually proven this yourself and yet you still have doubts? /RF yes Richard : ( hope i will not repeat this as time goes and my experience grows. i.e., i will be more confident with my answers . okay , coming back to the sizing of temp tablespace question . if suppose , such a question appears in the exam too ( my bad luck ) , what will be your two best answers ? Thanks and 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).
Re[3]: another OCP question -- help me guys
Thanx for your reply Gennick. ..and for your word of caution about partitioned tables. Cary , sometime back said that : Cary There are always two answers to a question that your teacher would ask at school . First one is the right answer. Second one is the answer that your teacher would expect. /Cary The second answer is the one i mostly fail to find. 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).
Re[3]: another OCP question -- help me guys
Ryan People don't seem to be all that interested in Ryan whether you can actually do the job. Ryan , i would change your first line as Some people don't seem to ... Because some people really DO care about what one can do. Ryan They just assume your better than someone Ryan else if you have a nicer resume. I agree . Because resume is the mirror which reflects an individual until the interview happens . 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).
RE: How to remove PL/SQL successfully completed Message
Hi Mudhalvan , set feed off ; did u try this ? not sure though : ) Regards, Prem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mudhalvan, Moovarkku Hi, I am trying to spool the result from PL/SQL procedure. At the end of result I am getting PL/SQL successfully completed. Could anyone tell me how to avoid that message?. This is how my sql looks like set linesize 200 set trimspool on set verify off echo off set serveroutput on -- 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).
standby database configuration in 9iR2 SE ?
List, Can someone give me a doc/URL for the steps invloved in standby database configuration ( manual recovery mode ) on 9iR2 SE ? I do have a doc for standby database configuration ( managed recovery mode ) for 8i EE . except automatic log transfer which is not a feature of SE , will the steps involved be quite different or almost the same ? Your suggestions please . 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).
RE: standby database configuration in 9iR2 SE ?
No Juan . SE also has the feature but Managed Recovery is not possible as in EE . A metalink doc says : quote Basic Standby Database is a feature of SE . that is it Allows the DBA to manually clone a database, and to copy and to apply log files to the standby /quote anyway i'm looking for manual recovery which is possible in SE. Regards, Jp. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Standby is only for Enterprise Ed. -- 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).
utl_smtp and japanese characters ?
Hi all, (B (Bi have written a small procedure to send e-mail from (Bmy oracle database [oracle 9.2.0.3/win2k]. (B (Bmessage := 'Date: ' || TO_CHAR( SYSDATE, 'DD-Mon- HH24:MI:SS' ) || (Butl_tcp.CRLF; (Bmessage := message || 'From: ' || sender || utl_tcp.CRLF; (Bmessage := message || 'Subject: ' || subject || utl_tcp.CRLF; (Bmessage := message || 'To: ' || recipient || utl_tcp.CRLF; (Bmessage := message || 'Mime-Version: 1.0' || utl_tcp.CRLF; (Bmessage := message || 'Content-Type: text/plain; (Bcharset="ISO-2022-JP"'||utl_tcp.CRLF; (Bmessage := message || '$BI=NN0hL>(B' || chr(9) || '$B6u$-NN0h(B (MB)' || (Butl_tcp.CRLF; # JAPANESE CHARACTERS ARE HERE (Bmail_conn :=utl_smtp.open_connection(mailhost,25); (Butl_smtp.helo(mail_conn,mailhost); (Butl_smtp.mail(mail_conn,sender); (Butl_smtp.rcpt(mail_conn,recipient); (Butl_smtp.open_data(mail_conn); (Butl_smtp.write_data(mail_conn, message); (Butl_smtp.close_data(mail_conn); (Butl_smtp.quit(mail_conn); (B (Bthe japanese characters come out as ??? in the e-mail, (Bwhereas english characters work fine. (Bwhat's wrong with my code ? Can someone help me ? (B (BRegards, (BJp. (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
RE: dba studio in oracle9.2
Bahar , i think it's only OEM with 9iR2. ... and perhaps u have everything there . Regards, Jp. -Original Message- On Behalf Of [EMAIL PROTECTED] Hi all, I have installed oracle 9.2 server and managemenst server on windows. I have perform full installation. But there is no DBA Studio in oracle tools. Any comment. -- 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).
RE: Analytic bug in 9.2.0.4
You are right Jared. ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [],[], [] this is on oracle 9.2.0.3 Win2k+SP3. Regards, Jp. -Original Message- While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared -- 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).
Re: Finding SID of current session
George, u can get it from v$mystat. REgards, Jp. 02-12-2003 16:44:25, George Leonard [EMAIL PROTECTED] wrote: Hi there all. How can I find the sid of the current session, I got a pl/sql procedure that needs to do a select from v$session_event but only want to do it for it's own session so I need to know this for the where clause ? -- 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).
Re: shared server or dedicated server -- How to find ?
Tanel , (B (Bv$mts, v$dispatcher, v$shared_server all have a record each. (B (Bbut: (BSQL select server, count(*) from v$session group by server; (Bthis query says that all conn are dedicated. (Bbut the tnsnames.ora in the client (webserver) doesn't enforce for a dedicated conn. (B (B...and LSNCRSTL STATUS doesn't show anything reg. dispatcher. (B (Bwhy it is so ? any thoughts ?!! (B (BThanks Regards, (BJp. (B (B02-12-2003 15:54:24, "Tanel Poder" [EMAIL PROTECTED] wrote: (B (BI would use: (Bselect server, count(*) from v$session group by server; (B (BThat way you'll see how many sessions are using shared servers how many (Bare forced to be dedicated. (you can have dedicated connections in MTS as (Bwell). (B (BOtherwise, you can check views v$mts, v$dispatcher, v$shared_server for (Bstatistics. (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
Re: shared server or dedicated server -- How to find ?
Tanel List, (B (BSQL select name,network,status, from v$dispatcher; (B (BNAME: D000 (BNETWORK : (ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1027)) (BSTATUS : WAIT (B (Bmy listener.ora doesn't have an entry for this and LSNRCTL STATUS (Bdoesn't show that it's listening on port 1027. (Bbut still,if i change my port no in client tnsnames.ora to 1027, (Bi'm able to connect.totally confused :(( (B (BThanks and Regards, (BJp. (B (B (B02-12-2003 15:54:24, "Tanel Poder" [EMAIL PROTECTED] wrote: (B (BI would use: (Bselect server, count(*) from v$session group by server; (B (BThat way you'll see how many sessions are using shared servers how many (Bare forced to be dedicated. (you can have dedicated connections in MTS as (Bwell). (B (BOtherwise, you can check views v$mts, v$dispatcher, v$shared_server for (Bstatistics. (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
shared server or dedicated server -- How to find ?
List , I would like to know whether my database is running on shared server (MTS) or dedicated server mode ? How do i find it out ? it's oracle 9.2.0.3 on Win2k. 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).
test mail -- plz ignore
-- 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).
test mail ...... plz ignore
(B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
Re: ** find whether table or index being accessed
--Boundary-00=_4PUK6RO0 Content-Type: Multipart/Alternative; boundary=Boundary-00=_4PUK12S0 --Boundary-00=_4PUK12S0 Content-Type: Text/Plain; charset=shift_jis Content-Transfer-Encoding: quoted-printable Joshi,=0D =0D i have got a script from metalink for monitoring indexes .=0D it works for 8.1.x too . =0D just try the script that i have mailed to ur personal email address. =0D =0D Regards,=0D Jp.=0D =0D A Joshi [EMAIL PROTECTED] wrote:=0D =0D Hi, Is there an easy way to find out if a table or an index is=0D being used. I mean short of going thru all code or keeping looking at=0D v$sqlarea. I mean even if code is covered there are always ad hoc SQL queries=0D etc. Same for other objects like views etc. Is there a place where orac= le=0D stores objects accessed and any other related info. Thanks --Boundary-00=_4PUK12S0 Content-Type: Text/HTML; charset=shift_jis Content-Transfer-Encoding: quoted-printable HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; charset=3Dshift_jis= META content=3DIncrediMail 1.0 name=3DGENERATOR !--IncrdiXMLRemarkStart IncrdiX-Info X-FIDFLAVOR00-NONE---/X-FID X-FVER/X-FVER X-CNT;/X-CNT /IncrdiX-Info IncrdiXMLRemarkEnd-- /HEAD BODY style=3DBACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px= 10px 10px; FONT-FAMILY: Arial bgColor=3D#ff background=3D scroll=3D= yes ORGYPOS=3D0 X-FVER=3D3.0 TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D100= % border=3D0 TBODY TR TD id=3DINCREDITEXTREGION style=3DFONT-SIZE: 12pt; CURSOR: auto; FONT-F= AMILY: Arial width=3D100% DIV DIVJoshi,/DIV DIVnbsp;/DIV DIVi have got a script from metalink for monitoring indexes ./DIV DIVit works for 8.1.x too . /DIV DIVjust try thenbsp;script that i have mailed to ur personal email add= ress. /DIV DIVnbsp;/DIV DIVRegards,/DIV DIVJp./DIV DIVnbsp;/DIV DIVgt; A Joshi lt;A href=3Dmailto:[EMAIL PROTECTED][EMAIL PROTECTED] hoo.com/Agt; wrote:/DIV/DIV DIVgt;/DIV DIVgt; Hi, Is there an easy way to find out if a table or an index is= /DIV DIVgt; being used. I mean short of going thru all code or keeping look= ing at/DIV DIVgt; v$sqlarea. I mean even if code is covered there are always ad h= oc SQL queries/DIV DIVgt; etc. Same for other objects like views etc. Is there a place wh= ere oracle/DIV DIVgt; stores objects accessed and any other related info. Thanks/DIV= DIVnbsp;/DIV/TD/TR TR TD id=3DINCREDIFOOTER width=3D100% TABLE cellSpacing=3D0 cellPadding=3D0 width=3D100% TBODY TR TD width=3D100%/TD TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle/TD TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle/TD/TR/TBODY/T= ABLE/TD/TR/TBODY/TABLESPAN id=3DIncrediStampSPAN dir=3DltrF= ONT face=3DArial, Helvetica, sans-serif size=3D2__= __BRFONT face=3DComic Sans MS size=3D2= A href=3Dhttp://www.incredimail.com/redir.asp?ad_id=3D309amp;lang=3D9;= IMG alt=3D hspace=3D0 src=3Dcid:2CDEA47B-8D43-4829-B29E-06BA78567C64= align=3Dbaseline border=3D0/Anbsp; IIncrediMail/I - BEmail has= finally evolved/B - /FONTA href=3Dhttp://www.incredimail.com/redir= =2Easp?ad_id=3D309amp;lang=3D9FONT face=3DTimes New Roman size=3D3= BUClick Here/U/B/FONT/A/SPAN/SPAN/FONT/BODY/HTML --Boundary-00=_4PUK12S0-- --Boundary-00=_4PUK6RO0 Content-Type: image/gif; name=IMSTP.gif Content-Transfer-Encoding: base64 Content-ID: 2CDEA47B-8D43-4829-B29E-06BA78567C64 R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gLwAA ACH/C05FVFNDQVBFMi4wAwEh+QQJFAAIACwAFAAPAAAEVRDJSaudJuudrxlEKI6B URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt E30tVVRscMHDqV/u+AgAIfkEBWQACAAsABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --Boundary-00=_4PUK6RO0-- -- 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).
test mail -- plz ignore
-- 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).
Re:How to drop a datafile ?
Perhaps your guess is right Dennis. Dennis For odd features like this marketing probably gets a list from support. /Dennis But Dennis,what is so odd in having this feature ? i think,only ORACLE CORP. knows. Thanx Regards, Jp. 1-11-2003 02:49:30, DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Prem I will provide my guesses and maybe someone that knows the real story will reply. First, in order for Oracle to drop a datafile, you would somehow have to ensure that it is empty. I would guess if Oracle added this feature, then Oracle Support would receive a lot of questions about why it erred out for them. Second, for any software system, what is the portion most likely to cause an error? The part that changed last. If they created this feature at this late date, it would probably produce weird behavior sometime. Finally, developers develop what they are requested to develop. Those requests generally come from marketing. For odd features like this marketing probably gets a list from support. So, if many customers aren't requesting a feature, it will probably never get on the development feature list. But that is all just a guess based on my personal experience working for a software vendor long ago on a faraway planet, and that vendor certainly wasn't Oracle. Dennis Williams -- 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).
Re: RE: How to drop a datafile ?
Thanx everybody. i thought there would be a way to do it. just curious . why is it not so ? any good reason for it ?!!! Regards, Jp. 30-10-2003 02:34:26, [EMAIL PROTECTED] wrote: That won't actually do what you're implying. Checking the docs would prove helpful. From the SQL ref: If the database is in NOARCHIVELOG mode, you must specify the DROP clause to take a datafile offline. However, the DROP clause does not remove the datafile from the database. To do that, you must drop the tablespace in which the datafile resides. Until you do so, the datafile remains in the data dictionary with the status RECOVER or OFFLINE. If the database is in ARCHIVELOG mode, Oracle ignores the DROP keyword. -- 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).
Re: RE: How to drop a datafile ?
Thanx craig. but is there no way of dropping a datafile then ? Regards, Jp. 29-10-2003 18:24:25, Craig Richards wrote: I don't beelive you can drop a datafile from a tablespace, you have to drop the tablespace, just reaize the datafile to 1M if space is the problem Regards -- 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).
Re: How to drop a datafile ?
Thanx Sinardy Rachel. so,the only way is as what Sinardy said. is that so ? Regards, Jp. 29-10-2003 19:44:25, Rachel Carmichael [EMAIL PROTECTED] wrote: The doc is right. You cannot drop a single datafile from a tablespace. -- 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).
How to drop a datafile ?
Guys, it's oracle 9.2.0.3/Win2K. say for some reason (NOT recovery): i want to drop a datafile from a tablespace which has more than 1 datafile.how to do it ? Doc 111316.1 says u need to drop the tablespace or exp/imp the objects in the tablespace. your ideas please. 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).
RE: How to drop a datafile ?
--Boundary-00=_FF7IDL51VA40 Content-Type: Multipart/Alternative; boundary=Boundary-00=_FF7I8WA1VA40 --Boundary-00=_FF7I8WA1VA40 Content-Type: Text/Plain; charset=shift_jis Content-Transfer-Encoding: quoted-printable Hi Mudhalvan,=0D =0D i don't find any option to drop a datafile using OEM.=0D i would be more intereseted in doing it from sqlplus.=0D =0D Jp.=0D =0D ---Original Message---=0D =0D Prem..=0D =0D Why don't you install Enterprise manager in any one of your=0D client .. Login as Stand Alone.. And you can delete the same --Boundary-00=_FF7I8WA1VA40 Content-Type: Text/HTML; charset=shift_jis Content-Transfer-Encoding: quoted-printable HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; charset=3Dshift_jis= META content=3DIncrediMail 1.0 name=3DGENERATOR !--IncrdiXMLRemarkStart IncrdiX-Info X-FIDFLAVOR00-NONE---/X-FID X-FVER3.0/X-FVER X-CNT;/X-CNT /IncrdiX-Info IncrdiXMLRemarkEnd-- /HEAD BODY style=3DBACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px= 10px 10px; FONT-FAMILY: Arial bgColor=3D#ff background=3D scroll=3D= yes X-FVER=3D3.0 ORGYPOS=3D0 TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D100= % border=3D0 TBODY TR TD id=3DINCREDITEXTREGION style=3DFONT-SIZE: 12pt; CURSOR: auto; FONT-F= AMILY: Arial width=3D100% DIVFONT size=3D2Hi Mudhalvan,/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2i don't find anynbsp;option to drop a datafilenbsp;= using OEM./FONT/DIV DIVFONT size=3D2i would be more intereseted in doing it from sqlplus.= /FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2Jp./FONT/DIV DIVFONT size=3D2nbsp;/FONT/DIV DIV id=3DIncrediOriginalMessageIFONT size=3D2---Original Messag= e---/FONT/I/DIV DIVFONT size=3D2nbsp;/FONT/DIV DIV id=3DreceivestringsFONT size=3D2Prem../FONT/DIV DIVFONT size=3D2nbsp;/FONT/DIV DIVFONT size=3D2Why don't you install Enterprise manager in any one o= f your/FONT/DIV DIVFONT size=3D2client .. Login as Stand Alone.. And you can delete t= he same/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV/TD/TR TR TD id=3DINCREDIFOOTER width=3D100% TABLE cellSpacing=3D0 cellPadding=3D0 width=3D100% TBODY TR TD width=3D100%/TD TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle/TD TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle/TD/TR/TBODY/T= ABLE/TD/TR/TBODY/TABLESPAN id=3DIncrediStampSPAN dir=3DltrF= ONT face=3DArial, Helvetica, sans-serif size=3D2__= __BRFONT face=3DComic Sans MS size=3D2= A href=3Dhttp://www.incredimail.com/redir.asp?ad_id=3D309amp;lang=3D9;= IMG alt=3D hspace=3D0 src=3Dcid:371A5E9F-59E0-4BA4-BEF9-7FEE0744F93E= align=3Dbaseline border=3D0/Anbsp; IIncrediMail/I - BEmail has= finally evolved/B - /FONTA href=3Dhttp://www.incredimail.com/redir= =2Easp?ad_id=3D309amp;lang=3D9FONT face=3DTimes New Roman size=3D3= BUClick Here/U/B/FONT/A/SPAN/SPAN/FONT/BODY/HTML --Boundary-00=_FF7I8WA1VA40-- --Boundary-00=_FF7IDL51VA40 Content-Type: image/gif; name=IMSTP.gif Content-Transfer-Encoding: base64 Content-ID: 371A5E9F-59E0-4BA4-BEF9-7FEE0744F93E R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gLwAA ACH/C05FVFNDQVBFMi4wAwEh+QQJFAAIACwAFAAPAAAEVRDJSaudJuudrxlEKI6B URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt E30tVVRscMHDqV/u+AgAIfkEBWQACAAsABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --Boundary-00=_FF7IDL51VA40-- -- 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).
RE: How to drop a datafile ?
--Boundary-00=_ZH8IYHI1VA40 Content-Type: Multipart/Alternative; boundary=Boundary-00=_ZH8ITSM1VA40 --Boundary-00=_ZH8ITSM1VA40 Content-Type: Text/Plain; charset=shift_jis Content-Transfer-Encoding: quoted-printable Mudhalvan , the delete datafile icon in that screen=0D of OEM is not enabled . even if i take the datafile offline,=0D it is not enabled.=0D =0D even in ur screen it looks so ? isn't it ?=0D =0D Jp.=0D ---Original Message---=0D =0D Prem =0D =0D Please check this Screen.. If you still have doubt please let me know= =0D =20 --Boundary-00=_ZH8ITSM1VA40 Content-Type: Text/HTML; charset=shift_jis Content-Transfer-Encoding: quoted-printable HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; charset=3Dshift_jis= META content=3DIncrediMail 1.0 name=3DGENERATOR !--IncrdiXMLRemarkStart IncrdiX-Info X-FIDFLAVOR00-NONE---/X-FID X-FVER/X-FVER X-CNT;/X-CNT /IncrdiX-Info IncrdiXMLRemarkEnd-- /HEAD BODY style=3DBACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px= 10px 10px; FONT-FAMILY: Arial bgColor=3D#ff background=3D scroll=3D= yes ORGYPOS=3D0 X-FVER=3D3.0 TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D100= % border=3D0 TBODY TR TD id=3DINCREDITEXTREGION style=3DFONT-SIZE: 12pt; CURSOR: auto; FONT-F= AMILY: Arial width=3D100% DIVMudhalvan ,nbsp;the delete datafilenbsp; icon in that screen/DI= V DIVof OEM is not enabled . even if i take the datafile offline,/DIV DIVit is not enabled./DIV DIVnbsp;/DIV DIVeven in ur screen it looks so ? isn't it ?/DIV DIVnbsp;/DIV DIVJp./DIV DIV id=3DIncrediOriginalMessageI---Original Message---/I/D= IV DIVnbsp;/DIV DIV id=3Dreceivestrings DIV dir=3Dltr style=3DFONT-SIZE: 11pt iSPAN class=3D284343705-29102= 003FONT size=3D2Prem /FONT/SPAN/DIV/DIV DIVSPAN class=3D284343705-29102003FONT size=3D2/FONT/SPANnbsp;= /DIV DIVSPAN class=3D284343705-29102003nbsp;nbsp;nbsp; FONT size=3D2P= lease check this Screen.. If you still have doubt please let me know/FON= T/SPAN/DIV DIVSPAN class=3D284343705-29102003FONT size=3D2/FONT/SPANnbsp;= /DIV DIVnbsp;/DIV/TD/TR TR TD id=3DINCREDIFOOTER width=3D100% TABLE cellSpacing=3D0 cellPadding=3D0 width=3D100% TBODY TR TD width=3D100%/TD TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle/TD TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle/TD/TR/TBODY/T= ABLE/TD/TR/TBODY/TABLESPAN id=3DIncrediStampSPAN dir=3DltrF= ONT face=3DArial, Helvetica, sans-serif size=3D2__= __BRFONT face=3DComic Sans MS size=3D2= A href=3Dhttp://www.incredimail.com/redir.asp?ad_id=3D309amp;lang=3D9;= IMG alt=3D hspace=3D0 src=3Dcid:99EFB507-7B97-4C97-AAE3-F77F37CDAF34= align=3Dbaseline border=3D0/Anbsp; IIncrediMail/I - BEmail has= finally evolved/B - /FONTA href=3Dhttp://www.incredimail.com/redir= =2Easp?ad_id=3D309amp;lang=3D9FONT face=3DTimes New Roman size=3D3= BUClick Here/U/B/FONT/A/SPAN/SPAN/FONT/BODY/HTML --Boundary-00=_ZH8ITSM1VA40-- --Boundary-00=_ZH8IYHI1VA40 Content-Type: image/gif; name=IMSTP.gif Content-Transfer-Encoding: base64 Content-ID: 99EFB507-7B97-4C97-AAE3-F77F37CDAF34 R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gLwAA ACH/C05FVFNDQVBFMi4wAwEh+QQJFAAIACwAFAAPAAAEVRDJSaudJuudrxlEKI6B URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt E30tVVRscMHDqV/u+AgAIfkEBWQACAAsABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --Boundary-00=_ZH8IYHI1VA40-- -- 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).
RE: How to drop a datafile ?
doc 111316.1 doesn't mention about using OEM for the same. so i hope it cannot be done with OEM. am i right LIST ? so how do i do it from sqlplus ? TIA. 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).
Re: Passed Net8 OCP Exam
--Boundary-00=_4CPVRN00 Content-Type: Multipart/Alternative; boundary=Boundary-00=_5CPVMY50 --Boundary-00=_5CPVMY50 Content-Type: Text/Plain; charset=shift_jis Content-Transfer-Encoding: quoted-printable Congrats Dennis.=0D I was expecting 100% DBA 100% OCP in ur signature.=0D but couldn't.=0D =0D Jp. --Boundary-00=_5CPVMY50 Content-Type: Text/HTML; charset=shift_jis Content-Transfer-Encoding: quoted-printable HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; charset=3Dshift_jis= META content=3DIncrediMail 1.0 name=3DGENERATOR !--IncrdiXMLRemarkStart IncrdiX-Info X-FIDFLAVOR00-NONE---/X-FID X-FVER/X-FVER X-CNT;/X-CNT /IncrdiX-Info IncrdiXMLRemarkEnd-- /HEAD BODY style=3DBACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px= 10px 10px; FONT-FAMILY: Arial bgColor=3D#ff background=3D scroll=3D= yes ORGYPOS=3D0 X-FVER=3D3.0 TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D100= % border=3D0 TBODY TR TD id=3DINCREDITEXTREGION style=3DFONT-SIZE: 12pt; CURSOR: auto; FONT-F= AMILY: Arial width=3D100% DIVCongrats Dennis./DIV DIVI was expecting 100% DBA 100% OCP in ur signature./DIV DIVbut couldn't./DIV DIVnbsp;/DIV DIVJp./DIV/TD/TR TR TD id=3DINCREDIFOOTER width=3D100% TABLE cellSpacing=3D0 cellPadding=3D0 width=3D100% TBODY TR TD width=3D100%/TD TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle/TD TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle/TD/TR/TBODY/T= ABLE/TD/TR/TBODY/TABLESPAN id=3DIncrediStampSPAN dir=3DltrF= ONT face=3DArial, Helvetica, sans-serif size=3D2__= __BRFONT face=3DComic Sans MS size=3D2= A href=3Dhttp://www.incredimail.com/redir.asp?ad_id=3D309amp;lang=3D9;= IMG alt=3D hspace=3D0 src=3Dcid:05BBC5DB-3F3C-4456-AEB7-512ECEBFA6E3= align=3Dbaseline border=3D0/Anbsp; IIncrediMail/I - BEmail has= finally evolved/B - /FONTA href=3Dhttp://www.incredimail.com/redir= =2Easp?ad_id=3D309amp;lang=3D9FONT face=3DTimes New Roman size=3D3= BUClick Here/U/B/FONT/A/SPAN/SPAN/FONT/BODY/HTML --Boundary-00=_5CPVMY50-- --Boundary-00=_4CPVRN00 Content-Type: image/gif; name=IMSTP.gif Content-Transfer-Encoding: base64 Content-ID: 05BBC5DB-3F3C-4456-AEB7-512ECEBFA6E3 R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gLwAA ACH/C05FVFNDQVBFMi4wAwEh+QQJFAAIACwAFAAPAAAEVRDJSaudJuudrxlEKI6B URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt E30tVVRscMHDqV/u+AgAIfkEBWQACAAsABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --Boundary-00=_4CPVRN00-- -- 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).
Re: RE: Find an unprintable character inside a column....
Peter, i would be interested in that. can u mail it to me ? Jp. 09-10-2003 18:29:33, Robson, Peter [EMAIL PROTECTED] wrote: I have a small PL/SQL piece of code used to detect these things, if anyone wants it. -- 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).
Re: Experiences setting OPEN_CURSORS for Java applications
Craig, Thanx for your tool. Right now,let us (developers) use it with Jboss and let u know if there is any issue. Thanx a lt for your support. Regards, Jp. 02-10-2003 21:41:15, Craig Munday [EMAIL PROTECTED] wrote: Jp, I've forwarded you a separate email with the tool included as an attached zip file. In answer to your questions: The JDK version is 1.4.1 and above. I do not expect any problems with JBOSS 3.2.1 and higher although I would be interested in hearing about any problems should you come across some. I've never used apache so I am not sure whether it will work or not. I am definitely interested in helping you to get it working though. -- 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).
Re: Wooo.....Cary's book -- Out of stock !
i got my copy too from bookpool. .need to start reading it. happy weekend (with cary's book in hand) everybody. Jp. 30-9-2003 22:54:27, Stephane Paquette [EMAIL PROTECTED] wrote: I've also picked up my copy yesterday but ...I'm assuming everyone else has theirs by now and are busily reading. ... I still not have finished Tom Kite Expert one on one Stephane Paquette -- 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).
[no subject]
HELP -- 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).
Re: exam
Congrats Bulbul. What are the study materials u used ? ..any suggestion will help me too. Jp. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 5:24 PM 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: 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).
Re: Using dimensions
Raj, what does TFM STFW mean ?!! let me also get used to the list's acronyms :) Jp. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs? I have scanned TFM, but haven't STFW'd yet ... scared of too many hits. Thanks Raj -- 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).
Re: RE: Using dimensions
OwwThank God Raj hasn't replied yet :-) Thanx Gints. Jp. 30-09-2003 18:24:28, Gints Plivna [EMAIL PROTECTED] wrote: google gave me for example such an address http://www.gaarde.org/acronyms/ I'm sure one of hundreds or even thousands -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED] Raj, what does TFM STFW mean ?!! let me also get used to the list's acronyms :) 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).
Re:Suggestion reg. encryption ??
With pleasure Ranganath. ..and ur example,sure ,was useful. Kind Regards, Jp. 30-09-2003 17:47:38, Ranganath K [EMAIL PROTECTED] wrote: Hi Prem, I am also unable to reach it. The sight might be down. However I hope you would have found the example useful. BTW Can you please send me the white paper that you received from iDefense? Thanks and Regards, Ranganath -- 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).
Re: Experiences setting OPEN_CURSORS for Java applications
Craig, CMI can send you a copy if you are interested - CMyou will have to forward me your JDK version and details about any app CMserver that you are using. I would , sure , be very much interested in having a copy of that tool. developers here use diff. versions of JDK apache/tomcat/jboss ... is it JDK version/app. server specific ? can JDBC Expert for JDK 1.4.1_03/jboss 3.2.1 used for JDK 1.4.1_03/apache 2.0.4 ?? 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).
Re: Suggestion reg. encryption ??
Hi Pete, Thanx a lot. http://www.petefinnigan.com/orasec.htm This URL of yours has a lot related to encryption. As u said,i received Best Practices for Securing Oracle from iDefense.com.Is this the paper u mentioned about ? Hi Craig, thanx a lot for your wonderful reply (and for your precious time spent to explain me). u have given me surplus info'. i need to look into the resources u had given me. HSM would be the last option and many many thanx for letting me know that. Hi Ranganath, ton of thanx for your pretty example. i am not able to reach http://www.protegrity.com/. can u ? hope it's down. thanx for your prompt reply..as u always do :) 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).
Suggestion reg. encryption ??
Hi List, Application desc: Something similar (not exactly) to a payment gateway ; java/oracle 9iR2 will be used to develop it; need to store credit card numbers (encrypted) in the database ; SSL will be used for secure transactions; Suggestion needed : this being the case, credit card number encryption can be done with either java or oracle (dbms_obfuscation_toolkit) ; the developers came to me for a suggestion; and i'm here in front of u seeking the same; 1.Security being the priority , which would be the way to go why ? 2.How is it normally done ? TIA. 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).
Re: RE: SQL AREA and LIBARARY CACHE size?
Hi Manoj, this is the statistics i got from one of my instance. sql area225 MB library cache 112 MB I was also confused as u were [ i didn't notice this so far ]. but reading the replies of Tanel Steve once again: tanel But what Steve meant (please correct me if I'm wrong), is that operations on sql areas are managed by library cache structures (library cache latch, KGL manager, lib cache hash table, etc), so sql area is dependent on library cache, despite the fact they both have memory allocated directly from shared pool. /tanel from this (and as per the docs) i understand that sql area is a subset of library cache. perhaps,what subset means is: in terms of the control library cache has over sql area and not in terms of memory allocated. is my understanding correct, Tanel ? steve My best guess at the moment is that when new recreatable chunks are first unpinned, they go onto the transient list, and then when they have been reused, they go back onto the recurrent list. /steve ..and reading this post by Steve,i feel there is something more(a lot) that we need to know/understand to discuss about this. Can Steve/Tanel/List explain me what is transient chunk recurrent chunk ? Regards, Jp. P.S.Thanx Naveen. -- 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).
Re: RE: SQL AREA and LIBARARY CACHE size?
Hi Manoj, to be frank : need to know more basic stuff before i peep into X$ tables. let me get good at fundamentals (a lot to be read explored) first. later i can join u to explore about X$ stuff ;) meanwhile,i'm waiting for someone to explain me about transient chunk recurrent chunk. Jp. 26-09-2003 19:19:25, ManojKr Jha [EMAIL PROTECTED] wrote: Hi Prem, I Think you are also doing the same mistake that I have done yesterday, that was causing so much confusion. I had earlier calculated the library cache and sql area size from X$ksmsp. Please check the size of these component in x$ksmss. WHat is difference in both x$ view is little bit confusing. -- 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).
Re: RE: SQL AREA and LIBARARY CACHE size?
...long long way to go . b4 i reach x$ tables. Tanel, can u brief me about transient chunks recurrent chunks that u were discussing with Steve ? Jp. 26-09-2003 19:54:48, Tanel Poder [EMAIL PROTECTED] wrote: I'd suggest, when possible, not to use any x$ views, but stich with plain old documented ways. That way you'll probably avoid a lot of confusion, especially when database versions might change.. Tanel. -- 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).
Re: SQL AREA and LIBARARY CACHE size?
Hi Manoj, quoteIn my system size of library cache is approx 48 mb and sql area 417 mb/quote can i know where/how did u get the statistics from ? 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).
Re: RE: Re[2]: Cary's book -- Out of stock !
24-09-2003 00:19:47, Mercadante, Thomas F [EMAIL PROTECTED] wrote: I just read the first chapter on-line. Now I gotta order the book. Where Tom ? is it on Amazon or bookpool or BN ... ? -- 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).
Re:Cary's book -- Out of stock !
i placed my order at bookpool on 20-09-2003. ...anxiously waiting for my copy i wonder when i will have it in my hand ?!!! have anyone experienced any delay with bookpool ? hope it's better than Amazon, isn't it ? wolfgang,hope u misunderstood me. i asked Tom about the vendor he chose. thanx for the link anyway.let me go thro' chapter 1 online. Jp. 24-09-2003 14:14:45, Mladen Gogala [EMAIL PROTECTED] wrote: I believe this should answer your question: Barnes Noble.com Your Order Has Been Shipped Dear MLADEN GOGALA: Your order has been shipped, and the details appear below. Within 24 hours of receiving this email, you may track the delivery status of your order at http://www.dropshipexpress.com/tracking/tracking.asp?DCN=420066119102126 The book, which isn't available, according to Amazon, has been shipped by B N. It will probably be a big surprise, but my recommendation is definitely Barnes Noble. -- 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).
Re: How do we know that an index need to be rebuilt.
Read ur interesting reply for the query Mladen and learnt a new rule of thumb from u today. i sent the doc. to Raju ONLY adn NOT to the list. it's just the body of the mail u r seeing there. Regards, Jp. 22-09-2003 15:49:40, Mladen Gogala [EMAIL PROTECTED] wrote: Attachments are stripped from the list messages. On 2003.09.22 02:24, Prem Khanna J wrote: Hi Raju, Check the doc. i have attached. -- 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).
Re: How do we know that an index need to be rebuilt.
Anand, it's the same doc. mentioned by Mladen. i have sent it to your email address ONLY. Jp. 22-09-2003 16:20:21, Anand Kumar [EMAIL PROTECTED] wrote: Prem, Can you mail me the same document -- 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).
Re: How do we know that an index need to be rebuilt.
That's the doc. i mailed raju. Thanx Mladen. can i add a question here : when is it appropriate to use BITMAP index ? seems it has lot of restrictions. read docs about it ...still confused. say, i have a big table with 50,000,000 records in a OLTP env. it has column SEX which will have either MALE or FEMALE. the table will have frequent insert/delete too. often this SEX column is included in many queries. this being my case, can i use bitmap index on this column ? or can u give a simple example for when a bitmap index can be used ? Regards, Jp. 22-09-2003 17:04:40, Mladen Gogala [EMAIL PROTECTED] wrote: There is a Metalink note 77574.1 entitled Guidelines on When to Rebuild a B- Tree Index which explains how to use validate structure and index_stats table. It is far too scientific to ever put into the script. Explanation for the rule of thumb is simple: if number of index blocks is big that means that the number of deleted entries is likely to be big, so let's rebuild it. As I said, rebuilding indexes is not often necessary and is usually done for all the wrong reasons. Quality of the rule of thumb, therefore, doesn't really matter. -- 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).
Re: Bug in 9.2.0.4
Munish, i posted the same content to the LIST this morning. i tried it on my instance and it happens :(( Jp. 22-09-2003 17:19:39, Munish Bajaj [EMAIL PROTECTED] wrote: Hi Listers Any idea about this Bug in 9.2.0.4. If you try select 'Hello' from dual order by 1 desc; you may run into the bug. It creates a dump in udump and could disconnect your session. Oracle is creating a one-off patch to fix. The bug is for any order by x, where x is a number, desc and the column is a constant. It does not happen on my instance. Any Details will be appreciated. -- 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).
Cary's book -- Out of stock !
Hi List, I have placed an order for Cary's book @bookpool. Does someone know when it will be in stock ? Can Mr.Cary Millsap let me know that ? 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).
Re: RE: Bug in 9.2.0.4
Ohhh ! ...i don't find 3110923 patch fix for Ms-Win :( 22-09-2003 20:39:52, Nigel Bishop [EMAIL PROTECTED] wrote: Ooops - Sorry Monday morning cut paste error - patch number should read 3110923 -- 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).
Re: RE: Cary's book -- Out of stock !
Thanx for the info' Ranganath. it's too late now.i have placed my order. that's okay.i will finish it b4 i come there. it will help me a lot ;) Regards, Jp. 22-09-2003 19:59:24, Ranganath K [EMAIL PROTECTED] wrote: Hi Prem, The book should be out during first week of October. BTW the low priced Indian edition of the book should also be out shortly. You could have bought the same when you were in India. You could have saved some $$. -- 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).
Re: ORA-03237 with LOB and locally managed tablespace
Luc, got this for u from metalink. Solution Description You need to ensure that the extent size specification in the tablespace is at least four times the db_block_size. i.e:create tablespace local_t1datafile 'path/filename.dbf' size 20M extent management local uniform size N; *** where N = 4*db_block_size *** The problem is due to the extent size specified in the tablespace. SQL create tablespace local_t1 2 datafile '/oracle10/local_t1/dbf' size 20m 3 extent management local uniform size 16k; SQL create table temp (a1 blob) tablespace local_t1; This generates the ORA-3237 if the db_block_size is = 8K. Explanation --- Whilst Oracle enforces the a minimum uniform extent size of two database blocks, other objects may require larger extents than this, either by virtue of how they are built internally (i.e. an RBS requires at least four blocks and a LOB at least three) or by virtue of their storage specification when being created. Jp. 22-9-2003 21:54:40, [EMAIL PROTECTED] wrote: Hi gurus, Could you explain that. Working with tablespace in locally managed, with uniform extends size, we want to create LOB but we must have the uniform extend size 3 times the db_block_size, right? Otherwise we got ORA-03237. With dictionnary managed tablespace we don't have this problem. -- 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).
Re: Cary's book -- Out of stock !
hope O'reilly prints some more soon. Jp. 22-9-2003 22:09:40, Rachel Carmichael [EMAIL PROTECTED] wrote: It's up to the publisher as to when they will print more, Cary has no control over that. However... it apparently never GOT to Amazon, as I had it on pre-order there, and it is still listed as to be released and not shipping :( -- 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).
Re: RE: download metalink articles - save target as
Paula, 1.open the article in a new window. 2.right click view source 3.save as *.html this is what i do. Jp. -Original Message- [EMAIL PROTECTED] When I right click on a metalink article to try to save it to a local directory and use save target as - it only provides a blank file. What's the easiest way to save these files locally? I want to because sometimes the more useful ones go away. -- 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).
Re: RE: Re[2]: Cary's book -- Out of stock !
Robert, are u the author of 9i RMAN Book by Oracle Press ? sorry for my ignorance. If YES: I have got a doubt in your book. can i mail it to u ? Jp. 23-9-2003 11:44:41, Freeman Robert - IL [EMAIL PROTECTED] wrote: I got my book... I got my book! From Amazon, delivered today! Woo Hoo looks good Cary!! RF -- 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).
Bug in 9.2.0.4 when order by constant desc
Hi all, Got the info' below from www.dba-village.com and thought of sharing it with u guys. If you try select 'Hello' from dual order by 1 desc; you may run into the bug. It creates a dump in udump and could disconnect your session. Oracle is creating a one-off patch to fix. The bug is for any order by x, where x is a number, desc and the column is a constant. 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).
Oracle 9i new features - by Connor McDonald
..a paper presented by Connor at OracleWorld 2003 is here. http://tinyurl.com/o6hp ..thought it may be of interest for many on this list. 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).
Re: How do we know that an index need to be rebuilt.
Hi Raju, Check the doc. i have attached. HTH. Jp. 22-09-2003 14:59:35, Veeraraju_Mareddi [EMAIL PROTECTED] wrote: Dear Friends, Can somebody tell me how do we that an index needs to be rebuilt.. Different scenarios / any documents will be helpful. Thanks in advance. Rajuvera -- 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).
Re: RE: RMAN error - can someone help ?
Ruth, Set you ORACLE_SID which will be the target and try again. c: set ORACLE_SID=AUX92 AUX92 is the name of my auxiliary instance on Host A ( target host ). c: rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys trace=c:\tspitr.log where PE92 is the target on same Host A and LAT92 is my recovery catalog on a diff. host. This is what metalink doc. 180436.1 says: rman target sys/[EMAIL PROTECTED] catalog rman/[EMAIL PROTECTED] auxiliary / trace=d:\tspitr.log It looks like you don't have your ORACLE_SID specified correctly since, if I read this correctly, the database you are trying to restore is on dick c:. my target database is in d:\oracle\ but even then where did this path come from ?? ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF those ;\ in the path look strange and wonder oracle appends that ?? any clues Ruth.just stuck up here and not able to proceed further. i tried it repeatedly. Thanx once again. Jp. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Tuesday, September 16, 2003 10:35 PM To: Multiple recipients of list ORACLE-L Subject: RMAN error - can someone help ? Hi, My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ). My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ). My target destination for backup files is R:\ which resides on Host C (WinNT).This drive R:\ is common to both Host A and B. Things work fine accessing R:\ from both Host A and B. I tried a TSPITR following the doc. 180436.1. It is for 8i. Question #1: is it applicable for 9i also ? If YES, when i say (on Host A,the target), run { ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK; ALLOCATE CHANNEL c1 TYPE DISK; recover tablespace users until time TO_DATE('MAR-05-2002 11:27:00', 'MON-DD- HH:MI:SS'); } i get the error below: channel a1: starting datafile backupset restore channel a1: specifying datafile(s) to restore from backup set restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF released channel: a1 released channel: c1 RMAN-00571: == RMAN-00569: === ERROR MESSAGE STACK FOLLOWS = RMAN-00571: == RMAN-03002: failure of recover command at 09/16/2003 17:48:32 RMAN-03015: error occurred in stored script Memory Script ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF ORA-27040: skgfrcre: create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) Path not found. Question #2: db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata \aux92); why does RMAN try to restore SYSTEM01.DBF to D:\ORACLE\ORA92\DATABASE\ ? i have not mentioned this path anywhere in my recovery action. Question #3: though it is not restore path,why does RMAN's Memory script append ;\ in the path i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF this is where it fails. can someone explain me where the problem is ? TIA. 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).
RMAN-03015 error during TSPITR
Hi, My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ). My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ). My target destination for backup files is R:\ which resides on Host C (WinNT).This drive R:\ is common to both Host A and B. Things work fine accessing R:\ from both Host A and B. I tried a TSPITR following the doc. 180436.1. It is for 8i. Question #1: is it applicable for 9i also ? If YES, when i say (on Host A,the target), run { ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK; ALLOCATE CHANNEL c1 TYPE DISK; recover tablespace users until time TO_DATE('MAR-05-2002 11:27:00', 'MON-DD- HH:MI:SS'); } i get the error below: channel a1: starting datafile backupset restore channel a1: specifying datafile(s) to restore from backup set restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF released channel: a1 released channel: c1 RMAN-00571: == RMAN-00569: === ERROR MESSAGE STACK FOLLOWS = RMAN-00571: == RMAN-03002: failure of recover command at 09/16/2003 17:48:32 RMAN-03015: error occurred in stored script Memory Script ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF ORA-27040: skgfrcre: create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) Path not found. Question #2: db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); why does RMAN try to restore SYSTEM01.DBF to D:\ORACLE\ORA92\DATABASE\ ? i have not mentioned this path anywhere in my recovery action. Question #3: though it is not restore path,why does RMAN's Memory script append ;\ in the path i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF this is where it fails. can someone explain me where the problem is ? TIA. 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).
RMAN error - can someone help ?
Hi, My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ). My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ). My target destination for backup files is R:\ which resides on Host C (WinNT).This drive R:\ is common to both Host A and B. Things work fine accessing R:\ from both Host A and B. I tried a TSPITR following the doc. 180436.1. It is for 8i. Question #1: is it applicable for 9i also ? If YES, when i say (on Host A,the target), run { ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK; ALLOCATE CHANNEL c1 TYPE DISK; recover tablespace users until time TO_DATE('MAR-05-2002 11:27:00', 'MON-DD- HH:MI:SS'); } i get the error below: channel a1: starting datafile backupset restore channel a1: specifying datafile(s) to restore from backup set restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF released channel: a1 released channel: c1 RMAN-00571: == RMAN-00569: === ERROR MESSAGE STACK FOLLOWS = RMAN-00571: == RMAN-03002: failure of recover command at 09/16/2003 17:48:32 RMAN-03015: error occurred in stored script Memory Script ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF ORA-27040: skgfrcre: create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) Path not found. Question #2: db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92); why does RMAN try to restore SYSTEM01.DBF to D:\ORACLE\ORA92\DATABASE\ ? i have not mentioned this path anywhere in my recovery action. Question #3: though it is not restore path,why does RMAN's Memory script append ;\ in the path i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF this is where it fails. can someone explain me where the problem is ? TIA. 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).
Re: RE: RE: Oracle Press OCP exam guide frustrations
Rafiq, How about Boson Practice tests compared to STS ? has anyone on this list found Boson useful ? Jp. 17-09-2003 13:34:36, Caffrey, Melanie [EMAIL PROTECTED] wrote: This is most likely the reason Oracle has now made it a requirement. Otherwise, who would ever take a course? -Original Message- From: M Rafiq [mailto:[EMAIL PROTECTED] Sent: Tue 9/16/2003 11:54 PM To: Multiple recipients of list ORACLE-L Cc: Subject: RE: RE: Oracle Press OCP exam guide frustrations Not really, most of DBA on this list did their OCP without any Oracle formal training. Use your experience on that version, study relevant material or available books/docs, do practice of STS test questions and then you are pretty much ready for exam. I did my OCP from 7. to 9i without attending and formal course and passed in first attempt Regards Rafiq -- 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).
Can i have a copy of metalink doc 52576.1 ?
Hi List, Sorry to post this again.Hope i will get some replies this time. I don't find Doc 52576.1 (Reg. cleaning up a RMAN catalog) on metalink. Can someone mail me if u have a copy of the same ? TIA. 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).
Re: Good small reference !
Raju, SQL select * from dictionary; this will give u list of dictionary views/tables. ...no idea about the scripts though. Jp. 12-09-2003 20:19:25, Veeraraju_Mareddi [EMAIL PROTECTED] wrote: Dear Friends, I am looking for a good reference of all ( some which are very much useful required for DBA ) the SQL scripts ,packages and all required views. UTL*.sql , DBMS_* DBA_* V$* -- 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).
Re: RE: Metalink doc 52576.1 ?
Faan, the Doc. below has the reference of 52576.1. -- Note:1069019.6 Subject: HOW TO GET A CLEAN RMAN CATALOG so, i was looking for that too. i read the doc. 1058332.6 already. You are the only one who responded to my question. Thanx Faan. Jp. 13-9-2003 04:49:27, Faan DeSwardt [EMAIL PROTECTED] wrote: Prem, You may want to check out Note# 1058332.6 for this. It appears that the reference to Note# 52576.1 is bogus. Good Luck! Faan -- 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).
Re: quick rman question
Gurevich, RMAN change backupset XXX delete; this deletes the backupset from disk.i have tried it. Hope change backuppiece XXX delete; also does the same on tape. Jp. 12-09-2003 06:34:27, Gene Gurevich [EMAIL PROTECTED] wrote: Hi does a command change backuppiece ... delete delete the info about a backup piece from a rman catalog only or does it also delete the backup piece itself from the tape? thanks gene -- 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).
Re: Database Link
Yechil,came across the info' below in metalink. --- there is nothing equivalent to 'oerr' available on Windows NT. The oerr utility used on Unix to get Cause/Action lines, is a shell script which extracts error text from the *.msg file with help of the standard Unix awk utility. As neither the advanced shell scripting nor the awk are available in a standard Windows NT installation, neither oerr nor *.msg files are delivered. There is an ORA.HLP file located in %oracle_home%\mshelp that you can use to get the same information. --- Jp. 10-09-2003 17:54:24, Yechiel Adar [EMAIL PROTECTED] wrote: Hello Jared What is the oerr utility? I just finished searching my disk for *oerr* and no exe or com file found. Oracle 9.2.0.4 on windows. Yechiel Adar -- 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).
OT - how/where to buy oracle test voucher ?
Hi everybody, Where/how can i buy a voucher for oracle exam ? I noticed two payment methods while filling up a Prometric registration form for Exam #1Z0-031. One of them was voucher. how and where do i get it ? how much is it ? ...anyone in this list from Japan ? 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).
Metalink doc 52576.1 ?
Hi List, I don't find Doc 52576.1 (Reg. cleaning up a RMAN catalog) on metalink. Can someone mail me if u have a copy of the same ? TIA. 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).
Re: RE: Oracle on Win2000
Bala,my reply is also the same as John said. PC Anywhere or the console straightaway Jp. 04-09-2003 17:34:26, Hallas, John, Tech Dev [EMAIL PROTECTED] wrote: PC Anywhere or direct from the console -- 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).
Re: RE: RMAN backup and recovery scenarios
Thanx Dennis,Robert,and Ruth. I'm going thro' Roberts's book now. as Robert said, it has a dedicated chapter for that. ...and i'm trying all the scenarios one by one . but just thought, i could some more inputs from you Gurus. thanx a lot guys. I will continue with the book. 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).
Re:RMAN backup and recovery scenarios
Thanx Govind. as Robert said, it has a dedicated chapter for that. ...and i'm trying all the scenarios one by one with his book beside. but just thought, i could some more inputs from the LIST. I will continue with the book now. 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).
RMAN backup and recovery scenarios
Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks 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).
Re: alter system reset
Arup Bhai, i remember oracle docs saying NOT to open a spfile and that it may even corrupt the file. Is that always true ? Can the spfile be opened ? can you kindly explain me ? Thanks Regards, Prem Khanna J. 02-09-2003 04:14:26, Arup Nanda [EMAIL PROTECTED] 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. Arup -- 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).
Re: alter system reset
Arup Bhai, many many thanx for your explanation. Regards, Prem Khanna J. 02-09-2003 12:19:25, Arup Nanda [EMAIL PROTECTED] wrote: Prem, The SPFILE should never be opened to be modified; opening a file to see the contents are acceptable and that's what I said. Sometimes opening the file in an editor may not be needed; type in Windows command prompt or cat in unix will let us achive the same objective. Talking about the SPFILE modification, you can't effectively modify it with accuracy. The file is binary (actually binary in the beginning and then text towards the bottom part), so even if you open it in notepad and save it, there is no guarantee that the file will be accurately saved with all contents intact. By the way, I have edited the SPFILE in some cases, only in development, though; but I wouldn't advise it to be done that way; always use ALTER SYSTEM ... SCOPE=SPFILE to modify it or edit the init.ora file and then create the SPFILE from it. You can create the spfile from pfile even when the instance is down. HTH. Arup -- 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).
Re: alter system reset
Arup Bhai/Mladen, these are the lines i read from oracle docs. Caution: Although you can open the binary server parameter file with a text editor and view its text, do not manually edit it. Doing so will corrupt the file. You will not be able to start your instance, and if the instance is running, it could fail. As you said,opening spfile is not a problem...but editing IS. Thanx to you both. Regards, Prem Khanna J. 02-09-2003 12:44:26, Mladen Gogala [EMAIL PROTECTED] wrote: Prem, if you want to read the spfile, you can always do something like strings $ORACLE_HOME/dbs/spfile.ora/tmp/spfile.txt -- 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).
Re: alter system reset
.wanted to know how you gurus handle SPFILE. Thanx Mladen. 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).
Re: book
Hi, Oracle8i Internal Services for Waits, Latches, Locks, and Memory by Steve Adams O'Reilly Associates, Paperback, Published October 1999, ISBN 156592598X This is a good one i know. 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).
Re: Fw: book
Hope Steve Adams will give an answer for your question. Jp. 01-09-2003 18:44:26, [EMAIL PROTECTED] wrote: Sorry to repost but forgot to mention, that I needed a book for Oracle 9i -- 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).
Re: Congratulations Arup (DBA of the Year)
Let me also join the list in congratulating one of the Oracle Gurus whom i admire. 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).
Re: OT - Linux books ??
Thanks Guys. I will go for Linux Administration Handbook. 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).
Re: Query results to .csv
Imran, Try this script. i have used it often. 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).
Re: Query results to .csv
Oops...it's Jared's script. i was not knowing till now. Jp. 26-08-2003 11:14:26, Prem Khanna J [EMAIL PROTECTED] wrote: Imran, Try this script. i have used it often. 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).
OT - Linux books ??
Guys, ...thought of buying a good book for linux system administration. i came across the books below. which one is good ? 1.Running Linux From O'Reilly - By Matt Welsh, Matthias Kalle Dalheimer, Terry Dawson, Lar Kaufman 2.Linux Administration Handbook From Prentice Hall - By Evi Nemeth, Garth Snyder, Trent Hein ...any better suggestion Gurus ?? TIA. 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).
Re: RE: Urgent! Is it safe to apply patch Windows2000-KB823980?
Luis, Sorry for the delayed reply. we installed the same patch on all our 8i/9i instances on win2k. we have not faced any problem so far. Regards, Jp. Has anybody applied Windows2000-KB823980-x86-ENU on their boxes hosting the Database? We are running 9i 9.0.1.1.1 on an Windows 2000 advanced server and our network group is patching all the systems. Is there anything that I need to watch for? We are also runing 9iAS ver 1.0.2.2.0 on Windows 200 advanced server, anything to be aware here? Any information is very welcomed. TIA Luis Octavio de Urioste -- 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).
Re: RE: quick suggestions for tuning ?
Profile(sex,entpc,laccess) and profile(sex,entpc,faccess) Would appear to be called for. Obviousdly you will wish to analyze the schema, and even more obviously you will do all this in test first. If sex is a column that does not have many values (one would think no more than 8 or so) then you can make this a compressed index degree 1, if entpc also has very few values compressing it degree 2 might be helpful (though I'd be sceptical). Thanx a lot for your suggestions Niall. i hope the indexes on sex entpc in profile table is not necessary. so there are some unwanted indexes to be dropped. On the contrary, the performance by index scan will decrease because Oracle must translate the prefix, suffix part in corresponding key Found the above lines in a metalink doc. about index compression. I don't know how far it will affect my performance.Need to test it. Thanks and 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).
Re: quick suggestions for tuning ?
Thanx a lot Jared. With due respect to all my GURUS on this list, i start reading the docs AGAIN. Thanx and Regards, Jp. 13-08-2003 05:46:32, [EMAIL PROTECTED] wrote: From: [EMAIL PROTECTED] Date: Tue, 12 Aug 2003 13:46:32 -0700 I would say that is often the norm. I would not say that it is however desirable. What you need to do is ask yourself What is the benefit of re-reading the data in the buffer over and over? When a database has a high Buffer Hit Ratio it will also have a large number of LIO's, and the reason is poorly written SQL that reads the same data from the cache, over and over. There papers at hotsos.com that will explain this in detail. Jared -- 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).
Re: quick suggestions for tuning ?
Jared, LIO being high and BHCR ~ 99% : is this is a normal or abnormal ? Regards, Jp. 12-08-2003 00:44:23, Jared Still [EMAIL PROTECTED] wrote: But his BCHR is 99.57% ! -- 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).
Re: quick suggestions for tuning ?
quote You poor guy. Try to bring some guy with you who can speak English and Japanese to resolve ths communication problem. in 1993 when I was working in Tokyo for 10 days in my ex-employer office and having problem with Harware, the Japanese Engineer was brining one Bangadeshi guy to communicate with me in English and it worked just fine. /quote Rafiq,it doesn't work the same way everywhere yaar. Bringing a guy just for translation is nearly impossible here. i know some japanese and i try to manage with that. even if u know Japanese,it's not a cake walk to convince a japanese. Client's vary their attitude varies. Do u agree with me ?! 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).
Re: quick suggestions for tuning ?
Thanx a lot Tanel. select count(*) as cnt from profile where sex = ''j?«' and entpc = '192.168.15.1' and laccess between to_date('2003/08/08 00:00: 00','/mm/dd hh24:mi:ss') and to_date('2003/08/08 23:59:59',' /mm/dd hh24:mi:ss') Do you have index on laccess column for example? Though there is index on laccess , it is not yet analyzed. none of the tables/index are analyzed yet. Sorry,i should have told this earlier. Since i'm working with a japanese client,communication is a huge barrier and convincing them is a HERCULEAN task :(( Let me do that first and get back to u. Thanks and 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).
Re: quick suggestions for tuning ?
Thanks a lot Stephane. There are indexes on profile table which u pointed out. but none of the tables/indexes are analyzed yet. Connor pointed that there are 54million consistent gets. LIO is high. does it mean that db_cache_size (700M) is small ? how to deal with this ? Can u throw some light on this Stephane ? Regards, Jp. From: Stephane Faroult [EMAIL PROTECTED] Subject: Fwd: Re: quick suggestions for tuning ? Date: 11-08-2003 00:29:23 I think that indexing the 'profile' table on entpc and laccess could be a good thing to start with. Probably some work to do on MSG_HISTORY as well. You are right about bind variables, but it won't help the queries on MSG_HISTORY, where the long string of ORs is obviously dynamically built. Oracle doesn't often choose to iterate as it should with a long string of ORs (or a long IN list), the 'FIRST_ROWS' hint may help. You can also tell your developers to review the English irregular verbs, especially 'to send'.Forget about the magical INIT parameter. -- Regards, Stephane Faroult Oriole Software -- 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).
Re: RE: quick suggestions for tuning ?
Thanks a lot Millsap,Stephane Faroult,Jared Still,Wolfgang,Tanel and Dennis for your pointers and suggestions. I owe a lot to you Oracle Gurus. A novice DBA like me is ever grateful to this wonderful list. I love this list. Thanks once again. 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).
Re: quick suggestions for tuning ?
Thanks a lot Connor. Apart from bind vars.,LIO is a big issue here. 54 million consistent gets. does it mean that db_cache_size (700M) is small ? any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? Regards, Jp. From: Connor McDonald [EMAIL PROTECTED] Subject: Fwd: Re: quick suggestions for tuning ? Date: 10-08-2003 23:44:25 Its not really rocket science here... CPU is at the top of the timed event - and what causes CPU (or is the most common cause) - logical I/O. 54 million consistent gets later down in the report probably a bit of a giveaway there :-) Next section in the report is some nice queries that use up 4 or so million buffer gets. Good ones to start with... As you've already noticed, no bind variables. Then some other miscellaneous things - look at how much free memory you have in most of your pools SGA breakdown difference - might be able to use that better elsewhere. cheers connor -- 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).
Re: Oracle and Windows 2000 SP4 - any experiences to share
after installing SP4,even MS-Office troubled me a lot. .came back to SP3 again. -- 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).