RE: sizing sort_area_size
Hi, Looking at v$sort_segment also can gve you a good idea of how much space you are using in your temporary tablespace, across the current uptime of the instance, assuming that it is a true temporary tablespace. Regards Pete -Original Message- Sent: 18 September 2003 23:35 To: Multiple recipients of list ORACLE-L > I have been doing some alter sessions to improve performance of gigabyte sized 'minus' operations. How do I tell if this is helping other than completion time? > > I believe that if LIOs to PIOs ratio improves with the SAME query then sort_area_size has helped right?(notice Im not trying to improve my cache/hit ratio). If you see less direct IO waits on your temporary tablespace, then increasing s_a_s has helped. > > I get this from v$sess_io. > > how do I tell how much temp tablespace my session uses? I cant find a statistic for it? I see that I used up all my PGA since PGA size and PGA max size are equal in v$sesstat. select * from v$sort_usage where sid = ; > anything else I can look at? Activity on temp tablespace from v$tempstat.. but it's only good enough for comparing with baselines.. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BAARF
Hi, To add my two pennies worth. By design I create physical database lqyouts that seperate indexes and tables by tablespace for ease of management, unless the database is real small. My experience over the years with Oracle, has been the object corruptions in the database have occurred more frequenty with indexes than tables, and when it happens its good just to be able to scrap the index tablespaces datafiles and start again. Regards Pete -Original Message- Sent: 29 September 2003 02:45 To: Multiple recipients of list ORACLE-L Thomas, Please pardon me, but you are off-target in your criticisms of OFA. It has never advocated separating tables from indexes for performance purposes. Ironically, your email starts to touch on the real reason for separating them (i.e. different types of I/O, different recovery requirements, etc). Tables and indexes do belong in different tablespaces, but not for reasons of performance. Cary first designed and implemented OFA in the early 90s and formalized it into a paper in 1995. Quite frankly, it is a brilliant set of rules of how Oracle-based systems should be structured, and a breath of fresh air from the simplistic way that Oracle installers laid things out at the time. It took several years for Oracle Development to see the light and become OFA-compliant, and not a moment too soon either. Just imagine if everything were still installed into a single directory tree under ORACLE_HOME? All of things you mention here have nothing to do with OFA. Please read the paper. Hope this helps... -Tim P.S.By the way, multiple block sizes are not intended for performance optimization; they merely enable transportable tablespaces between databases with different block sizes. on 9/25/03 11:04 AM, Thomas Day at [EMAIL PROTECTED] wrote: > > I would love to have a definitive site that I could send all RAID-F > advocates to where it would be laid out clearly, unambiguously, and > definitively what storage types should be used for what purpose. > > Redo logs on RAID 0 with Oracle duplexing (y/n)? > Rollback (or undo) ditto? > Write intensive tablespaces on RAID 1+0 (or should that be 0+1)? > Read intensive tablespaces on RAID ? (I guess 5 is OK since it's cheaper > than 1+0 and you won't have the write penalty) > > While we're at it could we blow up the OFA myth? Since you're tablespaces > are on datafiles that are on logical volumns that are on physical devices > which may contain one or many actual disks, does it really make sense to > worry (from a performance standpoint) about separating tables and indexes > into different tablespaces? > > We have killed the "everything in one extent" myth haven't we? Everybody's > comfortable with tables that have 100's of extents? > > And while we're at it, could we include the Oracle 9 multiple blocksizes > and how to use them. The best that I've seen is indexes in big blocks, > tables in small blocks --- uh, oh, time to separate tables and indexes. > > Maybe we will never get rid of the OFA myth. > > Just venting. > > Tired of arguing in front of management with Oracle certified DBAs that > RAID 5 is not good, OFA is unnecessary, and uniform extents is the only way > to go. Looking for a big stick to catch their attention with. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cali
RE: Problem in dropping Materialized View
Hi, Did you rename the materialized view? If so you are probably hitting bug 1335477. Can you see the view name in user_mviews? I think you have to try and re-create the materialized view and then drop it. Really suggest you contact Oracle, unless someone on the list has the definitive fix. Regards Pete [END] -Original Message- Sent: 17 October 2003 07:54 To: Multiple recipients of list ORACLE-L Hi Gurus Oracle 8.1.7 on HP Unix I have some problems in Materialized view Here are the sequence of steps Created a normal view CT_PRODUCTID_VW Created a materialized view CT_PRODUCID_MVW Dropped view CT_PRODUCTID_VW Rename CT_PRODUCTID_MVW to CT_PRODUCTID_VW Now I cannot drop the materialized view CT_PRODUCTID_VW SQL> select owner,object_type from all_objects where object_name='CT_PRODUCTID_VW'; OWNER OBJECT_TYPE -- -- COMMADMTABLE SQL> ANALYZE TABLE CT_PRODUCTID_VW VALIDATE STRUCTURE CASCADE; Table analyzed. SQL> DROP MATERIALIZED VIEW COMMADM.CT_PRODUCTID_VW; DROP MATERIALIZED VIEW COMMADM.CT_PRODUCTID_VW * ERROR at line 1: ORA-12003: snapshot "COMMADM"."CT_PRODUCTID_VW" does not exist SQL> drop snapshot COMMADM.CT_PRODUCTID_VW; drop snapshot COMMADM.CT_PRODUCTID_VW * ERROR at line 1: ORA-12003: snapshot "COMMADM"."CT_PRODUCTID_VW" does not exist SQL> DROP MATERIALIZED VIEW LOG ON CT_PRODUCTID_VW; DROP MATERIALIZED VIEW LOG ON CT_PRODUCTID_VW * ERROR at line 1: ORA-12002: there is no snapshot log on table "COMMADM"."CT_PRODUCTID_VW" SQL> drop table ct_productid_vw; drop table ct_productid_vw * ERROR at line 1: ORA-12083: must use DROP MATERIALIZED VIEW to drop "COMMADM"."CT_PRODUCTID_VW" The definition of the materialized view is as follows: CREATE MATERIALIZED VIEW CT_PRODUCTID_VW BUILD IMMEDIATE REFRESH START WITH SYSDATE NEXT (SYSDATE + 1) AS SELECT msi.segment1productid, msi.description description, msi.inventory_item_id inventory_item_id, mc.segment1 product_family, mc.segment2 product_type FROM [EMAIL PROTECTED] mcs, [EMAIL PROTECTED] mc, [EMAIL PROTECTED]mic, [EMAIL PROTECTED] msi where 1=1 and mc.structure_id = 50112 and mc.segment3 != 'SPARE' and mc.global_name= 'US' and mc.enabled_flag = 'Y' and mcs.global_name = mc.global_name and mcs.category_set_name = 'PROD GROUP' and mic.category_set_id = mcs.category_set_id and mic.category_id = mc.category_id and mic.global_name = mc.global_name and mic.organization_id = 1 and mic.inventory_item_id = msi.inventory_item_id and msi.organization_id = mic.organization_id and msi.global_name = mc.global_name AND msi.auto_created_config_flag = 'N' AND msi.item_type IN ('ATO MODEL','CONFIG SPARE','CONFIG SUB','FEATURE PACK','PRODUCT LIST>$0','PTO MODEL','SPARE') and msi.inventory_item_status_code IN ('ENABLE-MAJ','ENABLE-NON','ENABLE-OPT','NONORD') Any help to drop this object is highly appreciated. With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. # : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using an index defined on members of a user defined type
Hi, I am looking at Oracle schema for IBM's MQ Workflow and I have a table that has an index on members of a user defined type. This index is not getting used when it could help a delete statement. Using the 10053 trace I got this snippet in the trace: SINGLE TABLE ACCESS PATH No statistics type defined for function TIMESTAMP_WF No default selectivity defined for function TIMESTAMP_WF Does anyone have any experience in setting up functions so that the database will use indexes against them? In this case the table looks like this: CREATE TABLE AUDIT_TRAIL ( CREATED TIMESTAMP_WFNOT NULL , EVENT NUMBER(10,0)NOT NULL , TEMPL_VALID_FROMTIMESTAMP_WF , ACTIVITY_TYPE NUMBER(10,0) , ACTIVITY_STATE NUMBER(10,0) , ACTIVITY_RC NUMBER(10,0) , CONTAINER_CONTENT BLOB , PROCESS_NAMEVARCHAR2(63)NOT NULL , PROCESS_ID VARCHAR2(64)NOT NULL , TOP_LVL_PROC_NAME VARCHAR2(63)NOT NULL , TOP_LVL_PROC_ID VARCHAR2(64)NOT NULL , PARENT_PROC_NAMEVARCHAR2(63) , PARENT_PROC_ID VARCHAR2(64) , PROC_TEMPL_NAME VARCHAR2(32)NOT NULL , BLOCK_NAMES VARCHAR2(254) , USER_NAME VARCHAR2(32) , SECOND_USER_NAMEVARCHAR2(32) , ACTIVITY_NAME VARCHAR2(32) , SECOND_ACT_NAME VARCHAR2(32) , COMMAND_PARAMETERS VARCHAR2(1024) , ASSOCIATED_OBJECT VARCHAR2(64) , OBJECT_DESCRIPTION VARCHAR2(254) , PROGRAM_NAMEVARCHAR2(32) , EXTERNAL_CONTEXTVARCHAR2(254) ) TABLESPACE ADTTRAIL; and the index is: CREATE INDEX AT_CREATED_PROCID ON AUDIT_TRAIL ( CREATED.D, CREATED.S , PROCESS_ID ) TABLESPACE ADTTRAIL; and here is the type CREATE OR REPLACE TYPE TIMESTAMP_WF AS OBJECT( D DATE, S NUMBER(6), STATIC FUNCTION CONSTRUCT( str VARCHAR2 ) RETURN TIMESTAMP_WF, MEMBER FUNCTION AS_STRING RETURN VARCHAR2, MEMBER FUNCTION AS_DATE_STRING RETURN VARCHAR2, MEMBER FUNCTION ADD_SECONDS( sec INTEGER ) RETURN TIMESTAMP_WF, MEMBER FUNCTION SUB_TIMESTAMP_WF(other_Timestamp IN TIMESTAMP_WF) RETURN INTEGER , ORDER MEMBER FUNCTION COMPARE(other_Timestamp IN TIMESTAMP_WF) RETURN INTEGER ); / CREATE OR REPLACE TYPE BODY TIMESTAMP_WF AS STATIC FUNCTION CONSTRUCT( str VARCHAR2 ) RETURN TIMESTAMP_WF IS BEGIN IF str IS NULL THEN RETURN NULL; END IF; IF LENGTH( str ) >= 26 THEN RETURN TIMESTAMP_WF( TO_DATE( SUBSTR( str, 1,19 ), '-mm-dd-hh24.mi.s s' ), TO_NUMBER( SUBSTR( str, 21, 6 ) )); END IF; IF LENGTH( str ) >= 19 THEN RETURN TIMESTAMP_WF( TO_DATE( SUBSTR( str, 1,19 ), '-mm-dd-hh24.mi.s s'), 0 ); END IF; RETURN TIMESTAMP_WF( TO_DATE('ERROR'), 0); END; MEMBER FUNCTION AS_STRING RETURN VARCHAR2 IS BEGIN RETURN TO_CHAR(D,'-mm-dd-hh24.mi.ss')||'.'||SUBSTR(To_Char(S,'099'), 3); END; MEMBER FUNCTION AS_DATE_STRING RETURN VARCHAR2 IS BEGIN RETURN TO_CHAR(D,'-mm-dd-hh24.mi.ss'); END; MEMBER FUNCTION ADD_SECONDS( sec INTEGER ) RETURN TIMESTAMP_WF IS BEGIN RETURN TIMESTAMP_WF( D + sec/86400, S ); END; MEMBER FUNCTION SUB_TIMESTAMP_WF(other_Timestamp IN TIMESTAMP_WF) RETURN INTEG ER IS BEGIN RETURN ((D - other_TimeStamp.D)*86400); END; ORDER MEMBER FUNCTION COMPARE(other_Timestamp IN TIMESTAMP_WF) RETURN INTEGER IS BEGIN IFD > other_Timestamp.D THEN RETURN 1; ELSIF D < other_Timestamp.D THEN RETURN -1; END IF; RETURN S - other_Timestamp.S; END; END; / Regards Pete __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Configuring Oracle with RAID and OFA
Hi, Dwayne I agree with Rachel's comments. In the past I have laid out databases on RAID1+0, and there are some documents available indicating that this is the disk layout of choice for databases. Now I am faced with SAN and no say in how the disks are configured. So I have just created the normal set of directories, so that I don't have all the files lumped together from a file system perspective. Of course I would really like some separate disks for online redo logs and the archive logs, but I am not going to get them! Regards Pete -Original Message- Sent: 27 March 2003 13:39 To: Multiple recipients of list ORACLE-L With a single RAID-5 device, you can't place the database files on separate physical disks. Having said that, just as a means of documenting the database, I would still generate an OFA-compliant set of directories and place the various database objects in the separate directories. You won't get any benefit of separating files (which may or may not be beneficial in any case) but you will be able to easily distinguish which files are which type and the database they belong to. I presume that you, like me, have no say in how your disk system is configured? Rachel --- Dwayne Cox <[EMAIL PROTECTED]> wrote: > Hi all, > > I am configuring a system for use with Oracle and am confused on the > concepts > of RAID and OFA, specifically how they work together. > > I inherited a system that is a RAID 5 utilizing 5 disks. Oracle8i > (8.1.7) is > currently running on it. The database is setup on one disk (data > files, > control files, redo logs, etc.). > > I understand that striping spreads the info out across all the disks. > That > being true, is it necessary to put the redo logs, rollback segments, > etc on > sepaparte disks ala OFA? > > Since the database is not in production yet, I have time to make > these changes > (not to mention we are planning to redo the setup with Red Hat > Advanced > Server and upgrade to Oracle9i). > > Thanks in advance for your help. Feel free to point me to additional > reading > materials that will clarify this for me. > > Dwayne > > -- > Dwayne Cox > Corporate Database Administrator > Info Tech, Inc. > 5700 SW 34th Street, Suite 1235 > Gainesville, FL 32608 > > email: [EMAIL PROTECTED] > phone: 352.381.4521 fax: 352.381. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (no
RE: Intermedia tag "<" problem
Hi, You will have to change your input data and replace the "<" with "<". This is one of the standard 5 XML entity references. Really you need to make sure that you have no double quotes, single quotes, less than , greater than or ampersands in your data and if you do replace then with the appropriate entity reference: & -> & " -> " ' -> ' < -> < > -> > Regards Pete -Original Message- Sent: 28 March 2003 14:34 To: Multiple recipients of list ORACLE-L Hi Gurus, We are working with Intermedia Text 8.1.6. We created a intermedia index on a search field. We also created 2 sections in this field. Table name : S01 Filed name : S01_search Sections name : SY,MAN Here is an example of data in this field: CyanePhibro Energy * This example works fine. But we have a problem when there is a "<" character in the data. Intermedia thinks it's a new tag and tries to find a section but it cannot. Exemple: Cyane < 10 Phibro Energy * Question : 1- Should we do something with the "<" in our data ? TIA Luc = Luc Demanche [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ****** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Any tips to installing Designer 9i?
Hi, Do not make the path to the Oracle home you install Designer into any longer than 13 characters long, or you will find that certain tools do not work. The drive designator (e.g. C:\) does not count toward this total. Regards Pete -Original Message- Sent: 31 March 2003 22:49 To: Multiple recipients of list ORACLE-L Check the readme file or installation notes. It will tell you where to install Designer to make it work. I installed a couple of years old version, and I was asked to install in another Oracle_home. Hope this helps --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Hey all, > > I'm downloading Designer 9.0.2.4.0 to try it out. I don't want to > #$%^@ up > my current ORACLE_HOME, like I've done while testing every other > Oracle > product for Winders 2000. Any tips? > > Without reading the docs yet (still downloading), I plan to install > it into > another ORACLE_HOME. Other than that and some Registry scraping so I > can > actually remove Designer when I'm done, anything else I should be > aware of? > > > TIA, > Rich > > Rich JesseSystem/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI > USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: unix shell script question
Hi, This works in ksh: DBNAME=PROD LINE_PROD=500 OTHER=\${LINE_${DBNAME}} eval echo $OTHER Regards Pete [END] -Original Message- Sent: 15 July 2003 11:35 To: Multiple recipients of list ORACLE-L Hi List, The requirement is as follows: DBNAME=PROD ( 'DBNAME' variable contains value 'PROD' ) LINE_PROD=100 ( 'LINE_PROD' variable contains value 100 ) Now I want to echo the LINE_PROD variable using DBNAME variable. e.g echo ${LINE_${DBNAME}} should return 100. Is this possible and if yes, how ? I tried some ways but couldn't find any way. Regards, ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dilip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: XDB XLMSCHEMA
Hi, I do not have a tool for what you want. But I did experiment with XDB during the Summer of 2002. There is a XML IDE called XML Spy that integrates with Oracle XDB (http://www.altova.com/) and I suggest that you go to the XDB forum on Technet to ask your questions, I do not think that XDB is widley enough used to get answers on this forum. Regards Pete -Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED]Sent: 06 November 2003 14:29To: Multiple recipients of list ORACLE-LSubject: XDB XLMSCHEMA List, There doesn't seem to be any cool tools to generate XMLSchemas for XDB that I could find. Here is a simple sql script to pull a table out of the data dictionary and generate a basic XMLSCHEMA to register in Oracle XDB. I'm trying to figure out what the conversion is for Oracle datatypes to XML data types. I figure Oracle's varchar2 datatype converts to XML's string datatype. Is there a document that would have the conversion somewhere? Secondly, I'm trying to add the generation to the xmlschema for ref (i.e. ) for constraints. I know there is a lot of knowledge on this list. Was wondering if any one had a decode or snipet of code that they would be willing to give me to add to my simple program to pull constraints and turn them into ref statements, or better yet point me to a tool. TIA M. column dum1 noprintcolumn dum2 noprintcolumn dum3 noprintcolumn dum4 noprint # set termout off# set feedback off#set verify off# set echo offset pagesize 0set heading off spool xml.out select table_name dum2, 6 dum3, 1 dum4, 'DECLARE' from user_tablesUNIONselect table_name dum2, 7 dum3, 1 dum4, lower(table_name)||'schema VARCHAR2(2000) := '' from user_tablesUNIONselect table_name dum2, 8 dum3, 1 dum4, 'xmlns:xs="http://www.w3.org/2001/XMLSchema"' from user_tablesUNIONselect table_name dum2, 9 dum3, 1 dum4, 'xmlns:xdb="'">http://xmlns.oracle.com/xdb">' from user_tablesUNIONselect table_name dum2, 10 dum3, 1 dum4, '' from user_tablesUNIONselect table_name dum2, 11 dum3, 1 dum4, '' from user_tablesUNIONselect table_name dum2, 12 dum3, 1 dum4, '' from user_tablesUNIONselect a.table_name, 20, a.column_id, decode( a.column_id, 1, '','')|| rpad(' ||decode(a.data_type, 'VARCHAR2', 'VARCHAR2 ('||a.data_length||')', 'CHAR', 'type="xs:string"', 'NCHAR', 'type="xs:string"', 'NVARCHAR2', 'type="xs:string"', 'CLOB', 'type="xs:clob"', 'BLOB', 'type="xs:blob"', 'NUMBER','type="xs:float"', 'DATE', 'type="xs:date"', 'ERROR!! '||a.data_type||' not handled!') ||decode( a.nullable, 'Y',' ', ' nillable="false"/>' ) ||decode( a.nullable, 'N','', '/>') from user_tab_columns a, user_tables b where a.table_name = b.table_nameUNIONselect table_name dum2, 30 dum3, 1 dum4, '' from user_tablesUNIONselect table_name dum2, 40 dum3, 1 dum4, '' from user_tablesUNIONselect table_name dum2, 50 dum3, 1 dum4, '' from user_tablesUNIONselect table_name dum2, 60 dum3, 1 dum4, ''';' from user_tablesUNIONselect table_name dum2, 70 dum3, 1 dum4, 'BEGIN' from user_tablesUNIONselect table_name dum2, 80 dum3, 1 dum4, 'DBMS_XMLSCHEMA.RegisterSchema(''http://otn.oracle.com/'||lower(table_name)||'.xsd'' ,'||lower(table_name)||'schema );' from user_tablesUNIONselect table_name dum2, 90 dum3, 1 dum4, 'END;' from user_tablesUNIONselect table_name dum2, 95 dum3, 1 dum4, '/' from user_tablesorder by 1, 2, 3/ Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __
RE: Friday at the coding face...
official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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, I am not aware of a 9i book, but I don't think you can go wrong by getting hold of Steve Adam's book on 8i internals. Regards Pete -Original Message- Sent: 01 September 2003 10:44 To: Multiple recipients of list ORACLE-L Sorry to repost but forgot to mention, that I needed a book for Oracle 9i > Hello list > any recommendations about buying a book on oracle internal working , oracle > kernel ? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: get sid (session id) and serial#?
Title: Message Hi, It is my understanding that Oracle do support the dbms_support package and that it should have been in the 8i distribution, but was missed out by mistake. It's calls to sys.dbms_system.set_ev they do not supoprt since this enables you to set any debug event in the kernel. Regards Pete -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: 30 August 2003 00:30To: Multiple recipients of list ORACLE-LSubject: Re: get sid (session id) and serial#? Oracle officially "desupported" the package in 8i; but then included (by mistake?) in 9i. In 8i, however, you could pester your friendly neuighborhood Support Analyst to give you the package. You could try from 9i sources, too; but not sure if they work. Arup - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, August 29, 2003 5:29 PM Subject: RE: get sid (session id) and serial#? It's not in 8.1.5 Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John KanagarajSent: Friday, August 29, 2003 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: get sid (session id) and serial#? Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand. John KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment is inevitable, but Discouragement is optional!** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali. __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __
RE: Oracle9iR2 - temporary tablespace usage error
Hi, There are a couple of issues here. Firstly you need to know that when you get the error about the "temp" segment when building the index, the segment in question is the index. It is just that when building the index Oracle creates a temp segment to sort the data in and to create the index in and when it finishes it changes the segment type to "index". But if it runs out of space trying to build the index, it reports the error about the segment without first changing the segment type. When it comes to the temporary space in a tempfile temporary tablespace, Oracle never actually drops the extents that get allocated until the database is shutdown, instead they just get marked as being available when the session that first created them no longer needs them. Regards Pete -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: 05 September 2003 14:59To: Multiple recipients of list ORACLE-LSubject: Oracle9iR2 - temporary tablespace usage error HI all, I'm getting the following error when using temporary tablespace on a locally managed system tablespace. Seems if my system tablespace is locally managed I can not create a dictionary managed tablespace. Can anyone let me know if it is a bad idea to have system tablespace locally managed and why I am getting the following the error on building an index: ERROR at line 1:ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01 Also, I issue the following query and looks like the tempoary tablespace is not being free'ed up( or maybe this is not what this v$ tables is telling me): select tablespace_name, file_id,bytes_used,bytes_freefrom v$temp_space_header; SQL> select tablespace_name,file_id,bytes_used,bytes_free 2 from v$temp_space_header; TABLESPACE_NAME FILE_ID BYTES_USED BYTES_FREE-- -- -- --TEMP01 2 2146435072 0 Thanks in advance. Lizz Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __
RE: DB2 has a foot in the door
Hi, I looked into SE but found that Oracle would not allow it to be used on a machine that has 4 or more CPUs or can support that many CPUs, which for this company is a problem because we generally run Oracle on Sun servers. Don't know if that has changed now with later Oracle releases. Regards Pete -Original Message- Sent: 10 September 2003 13:21 To: Multiple recipients of list ORACLE-L When negotiating site licensing, does Oracle encourage the customers to buy EE licences? Or can people negotiate for a mix of EE or SE. Just curious, I don't know how that would work -- not very compatible with OracleStore, it seems to me. Patrice. -Original Message- Sent: Wednesday, September 10, 2003 5:59 AM To: Multiple recipients of list ORACLE-L We also has site licensing. It was done 3-4 years ago. Maybe Oracle changed tactics since then. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).