RE: Ixora off-line, moved?
I also tried this morning a few times and it was down. -Original Message- Sent: Thursday, January 22, 2004 12:04 PM To: Multiple recipients of list ORACLE-L ixora.com.au seems to be unavailable. Any clue? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Little competition
Title: Message Don King SQL> create table 2 test_table 3 (c1 number) 4 tablespace 5 asm_test 6 pctfree 20 pctused 30; -Original Message-From: Richard Foote [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 1:39 PMTo: Multiple recipients of list ORACLE-LSubject: Little competition Little competition for you all :) It's a two part question: What's wrong with the following piece of expert analysis ? Which well know "Oracle Guru" published this (and continues to display it on his web-page) ? "Sadly, Oracle9i doesn’t allow you to specify the value for PCTFREE if you’re using automatic space management. This is a serious limitation because Oracle9i can’t know in advance about the amount of VARCHAR expansion in a table row, leading to excessive row chaining and poor access performance." SQL> create table 2 test_table 3 (c1 number) 4 tablespace 5 asm_test 6 storage 7 ( pctfree 20 pctused 30 ) 8 ; ( pctfree 20 pctused 30 ) *ERROR at line 7:ORA-02143: invalid STORAGE optionHowever, here’s an important point. While Oracle9i rejects the PCTFREE and PCTUSED parameters with locally managed tablespaces with automatic space management, it does allow you to enter invalid settings for NEXT and FREELISTS settings" You've gotta love it !! Sorry no clues Cheers ;) Richard
RE: Finding SID of current session
select sid from v$mystat where rownum<2 / Kind Regards Suhen Pather IT Software Specialist Land +27 12 680 3282 Cell +27 82 562 3124 email [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 02, 2003 9:44 AM To: Multiple recipients of list ORACLE-L 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 ? George __ George Leonard Oracle Database Administrator Professional Services (Oracle Business Unit) Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! "This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp " -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: George Leonard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: when do you use v$statname?
Ryan, V$sysstat is system wide statistics. It contains name, value and statistic# and class. V$statname is used mostly as a lookup. V$sesstat is session stats which does not contain the *statistic name* column. When joined with v$statname (statistic# column), the statistic name and values can be obtained for a required session. SP -Original Message- Sent: Wednesday, November 26, 2003 3:39 PM To: Multiple recipients of list ORACLE-L both store that info SQL> desc v$statname Name Null?Type - STATISTIC# NUMBER NAME VARCHAR2(64) CLASS NUMBER SQL> desc v$sysstat Name Null?Type - STATISTIC# NUMBER NAME VARCHAR2(64) CLASS NUMBER VALUE NUMBER -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
Don We have successfully used forms 6i against Oracle 9i databases (9iR1 and 9iR2). Just a note that 9iAS Rel1 comes with forms6i. Only in 9iAS rel 2 and above are forms 9i used. Just make sure the correct forms 6i patchset has been applied that fixes the relevant forms bugs. Kind Regards Suhen Pather -Original Message- Sent: Tuesday, November 18, 2003 6:45 AM To: Multiple recipients of list ORACLE-L Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot find any specific information either confirming or denying this assertion. Searches on Metalink and Google both came up with nothing of relevance. I would assume that with an Oracle8i client it shouldn't be a problem, but I haven't worked with Forms at all since v3.0 and she is adamant that it is simply impossible - with no explanation of why. Don Granaman - OraSaurus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RBO to CBO migration books/ material
Hi Any good books available to convert applications from RBO to CBO. References to Oracle 9i. Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).