Re: locking tables
Hi Austin I dont know wether it can be done from the DB or not... But you can do it from your application by setting a flag when ever an update is happening and selecting only those records which doesn't hjave this flag set. Regards, Mohan Kris Austin wrote: hi list, how can you prevent another session from selecting from the table until your update has committed? we have a procedure that is querying and updating the table as one transaction. theoretically, we'd like to prevent any other session from accessing that table. is this possible? we cannot limit the oracle account to one session. many sessions need to be open since this is an ecommerce database application. we are running oracle 8.1.6 on solaris. thanks! kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramamohan B N INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Breaking a Table Data into Partitions
Chuck / Joe Qs. Is Following the BEST / Correct Way ? :- AIM A Sample Test to Convert a NON-partitioned Table "sol1" into a Partitioned Table "sol2" :- - Table sol1 = NON-partitioned Table of size 10 MB --- select distinct sol_id from sol1; SOL_ID 0004 0018 0026 0028 0032 0036 0038 7 rows selected. - Table sol2 = Partitioned Table - Created in the SAME Tablespace as sol1 -- create table SOL2 ( sol_id varchar(8), del_flg char(1), - - - - - - ) TABLESPACE TBA_TEMP storage (initial 2 ) partition by range ( sol_id ) (partition solrg1 values less than (maxvalue); CAUSE This Will Allow to Exchange partition of the COMPLETE NON-partitioned Table with the partitioned Table - Exchange Partition :- -- SQL alter table sol2 2 exchange partition solrg1 with table sol1 with validation; Table altered. - SPLIT The Single Partition into 2 Partitions --- SQL ALTER TABLE SOL2 SPLIT PARTITION solrg1 at ('0028') INTO ( PARTITION solrg1 storage (initial 5M next 5M pctincrease 0), PARTITION solrg2 storage (initial 5M next 5M pctincrease 0)); Table altered. NOTE - We Continue to use the SAME partition Name "solrg1" when Splitting the Single partition "solrg1" into 2 partitions "solrg1" "solrg2" . Qs. Is there Any Space management Advantage gained by doing the Same ? RESULT - The Size of Each partition is Explicitly Specified as 5M , therefore the Size of the Total Table CONTINUES to be 10M i.e. Same as it's Size in the NON-partitioned State Qs. Is 10M taken from FREE SPACE (sys.dba_free_space) or is the Existing Already Allocated Space to Table SOL2 RE-Used Suitably ? Chuck : I Could NOT Follow what you meant by COPY . Can COPY be used in the Above Aimed Scenario ? -Original Message- From: Chuck Hamilton [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 8:06 PM To: Multiple recipients of list ORACLE-L Subject: Re: Breaking a Table Data into Partitions If you're going to split a table into multiple tables, then exchange them for partitions, why not just create the partitioned table and copy the original table right into that? I'd only use the "exchange" route when converting partitioned views into a partitioned table. "Joseph S. Testa" [EMAIL PROTECTED] wrote: to do an exchange, you must have ONLY the rows that pertain to that partition in the table, hence my original message: the easiest is to figure out your partition key, split the data into separate table based on the partition key, then do a alter table exchange partition command. NOTICE, split the data into separate table(s) based on the partition key, the error you received is why i said what i said. Besides did you look up: ORA-14099: all rows in table do not qualify for specified partition 14099, 0, "all rows in table do not qualify for specified partition" // *Cause: There is at least one row in the non partitioned table which // does not qualify for the partition specified in the ALTER TABLE // EXCHANGE PARTITION // *Action: Ensure that all the rows in the segment qualify for the partition. // P! ! erform the alter table operation with the NO CHECKING option. // Run ANALYZE table VALIDATE on that partition to find out the // invalid rows and delete them. Does this make sense? Joe VIVEK_SHARMA wrote: Joe AIM A Sample Test to Convert a NON-partitioned Table into a Partitioned Table Failing :- - Table sol1 = NON-partitioned Table - select sol_id from sol1; SOL_ID 0004 0018 0026 0028 0032 0036 0038 7 rows selected. - Table sol2 = Partitioned Table - Created in the SAME Tablespace as sol1 -- create table SOL2 ( sol_id varchar(8), del_flg char(1), - - - - - - ) TABLESPACE TBA_TEMP ! ! storage (initial 2 ) partition by range ( sol_id ) (partition solrg1 values less than ('0028'), partition solrg2 values less than ('0039')); - Exchange Partition FAILING :- --- SQL alter table sol2 2 exchange partition solrg1 with table sol1 with validation; exchange partition solrg1 with table sol1 with validation * ERROR at line 2: ORA-14099: all rows in table do not qualify for specified
Database Management tool
I quickly made a resuirement list which we will be using to evaluate the shortlisted tools. here is the list. ( maybe this can help other dba's or maybe any suggestions to add something ) Requirement list Security management create users,roles,privs Copy users Delete users, roles, privs Reorganisation Make scripts to reorganise tablespaces, tables, indexes, automatically when needed. Notify when reorganisation is necessary. Space management See and manage the use of datafiles within a TS See the use of tablespaces: fragmentation, users, Monitor the free space and notify when there will be trouble throwing extents. Object Management Create, alter, drop objects Truncate tables Import/export utility No Partition Management No scheduling ( own scheduler ) Comparison comparing schemas/init.files/objects/user roles Difference between databases : make scripts to set them equal in data or in structure. Capacity planning Follow the grow of the database and predict further growth. Performance management See the n heaviest processes on the database. ( + sql ) See locks Extensive tracing Scan databases on a regular base Detect problems in time Either solve the problem automatically or make a script to solve it Benchmarking ( before and after changes to see the performance gain ) user interface Graphical All databases manageable from within 1 screen List of tnsnames.ora with auto-storage of used usernames ( cfr. toad ) extra points No performance loss while monitoring DB Interactive wizards Intuitive and efficient GUI
RE: Beta program opportunity
Bugger, not much use for us on Tru64 UNIX. Beta testing ends March 29th 2001. Discover how you can find the root of your storage bottlenecks today! Please check out the "Systems Requirements" link at http://www.quest.com/storage_xpert/system_requirements.asp. You can download the product at http://www.quest.com/storage_xpert/. Please send your feedback to [EMAIL PROTECTED] and technical support queries/issues/problems to [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. 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. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Thankx and more questions about SID
You have some options: select sid from v$mystat where rownum=1; If the user has privilege to access sys.v_$session, then you can issue: select sid from v$session where audsid=userenv('SESSIONID'); However connected as internal the userenv('SESSIONID') gives you a 0. Hence, you couldn't recognize the sid. Regards. -Mensaje original- De: bipin sahani [SMTP:[EMAIL PROTECTED]] Enviado el: sbado 17 de febrero de 2001 12:56 Para: Multiple recipients of list ORACLE-L Asunto: Re:Thankx and more questions about SID Thankx for info Can I write a query which will give me a SESSION ID of only my session?? And where system id is stored? Thankx and regards Bipin --- Arun Aggarwal [EMAIL PROTECTED] wrote: The SID in V$SESSION is session id not the system ID given to the Instance. These are two different things. Regards Arun Aggarwal Aithent Technologies (P) Ltd. [EMAIL PROTECTED] +91-124-6455504 (101) "If I knew what I was so anxious about, I wouldn't be so anxious." --Mignon McLaughlin - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 13:55 Hi ALL, I'm confused regarding numeric and multiple SIDs present in V$SESSION for same USER# and USERNAME How is it possible?? As far as I know there should be one SID for every instance of oracle. Then how v$session shows me more than one SID for same user.And if all these numeric SIDs correspond to one alphanumeric SID which is SID of that instance then where is the mapping between numeric and alpha numeric SID? Thankx and regards Bipin Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Aggarwal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Package Vs Procedure
What is the main difference between Package and procedure ? When a package should be created. Should related procedures be only grouped as a package or otherwise also it can be creaetd. TIA, Raji --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.226 / Virus Database: 108 - Release Date: 1/5/01 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajeshwari INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Best Practices for Partitions ?
Mark, Thanks Indeed for responding My Replies(ANS.) are Given Below your Questions in CAPITALS :- -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Subject:RE: Best Practices for Partitions ? Vivek Take a look at Steve Adams' site here http://www.ixora.com.au/tips/design/partitioning.htm It gives some good advice when considering partitioning, which I infact read through this morning. Composite or Range? ANS. ALL TABLES PARTITIONED BY RANGE Well, what kind of data does this table hold, ANS. WE ARE CONSIDERING PARTITIONG ALL THE 400 TABLES BASED ON PARTITION KEY "BRANCH_ID" DISTRIBUTION OF DMLs :- PRIMARILY INSERTS SELECTS UPDATES - RELATIVELY SMALL DELETES - NEGLIGIBLE NOTE - THIS BEING A BANKING APPLICATION . VARIOUS BRANCHES OF A BANK SPREAD ACROSS THE COUNTRY LOG INTO THE CENTRALISED DATABASE . what are you trying to achieve from a partitioned table? FOR OPS WE ARE PARTITIONING THE DATA TO PREVENT CONTENTION AS THE 2 INSTANCES WILL ACCESS DIFFERENT PARTITIONS BASED ON "BRANCH_ID" . OPS BEING CONSIDERED PRIMARILY FOR SCALABILITY . QS. WHICH INDEXES ARE ADVISABLE IN SUCH A SCENARIO , LOCAL OR GLOBAL ? It more depends on the nature of your DATA. Steve's jist, is that if you have a table partition, you should also have an index that refers to that table partition, as this will also help with maintenance operations etc. If you have an index for the partitioned table as a whole, and decided to reorg one partition, which could be old data, then you would also have to reorg the entire index - which could result in user problems. If you have a partition specific index, you could just reorg each specific partition without affecting performance on the whole. Correct me if I'm wrong Steve.. Regards Mark -Original Message- VIVEK_SHARMA Sent: Friday, February 16, 2001 06:40 To: Multiple recipients of list ORACLE-L Qs. Are Composite Partitions Better than Range partitions as a General rule ? OR is it dependent on Nature of Business/Application ? Qs. For Tables which are partitioned , is it advisable to Partition their Corresponding Indexes Also with the Same Respective Key Values List ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
number(p,s)
number(p,s) datatype conflicts my mind. every book tells that -84 s 127 How can s be minus. Negative scale??
Ixora News - February 2001
Hi All, The February issue of Ixora News is now available online at http://www.ixora.com.au/newsletter/2001_02.htm In this issue ... Fingerprints- Using V$LATCH_MISSES to characterize latching problems Buying time- How purchasing decisions affect Oracle CPU usage No more double trouble- The Oracle8i snapshot problems are fixed @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No Subject
hello dba's ( again ) i'm looking for a way to do a manual "top-session" on a database. According to TopSession from Oracle, the information should be located in v$sessions. Anyone an idea how to read the memory usage out of this table? In v$sess_io i'm able to get the amount of physical reads, but I need the memory usage. thanks for any help Bjorn Naessens Roularta IT Solutions
more questions about SID
Thankx for info. But these SID are unique for each oracle user.They can't be distingish if 10 persons using same Oracle login and issuing 10 different queries. I want to know SID for a specific query issued by me. Is there a way to find it out??? Thankx and regards Bipin --- "Trassens, Christian" [EMAIL PROTECTED] wrote: You have some options: select sid from v$mystat where rownum=1; If the user has privilege to access sys.v_$session, then you can issue: select sid from v$session where audsid=userenv('SESSIONID'); However connected as internal the userenv('SESSIONID') gives you a 0. Hence, you couldn't recognize the sid. Regards. -Mensaje original- De: bipin sahani [SMTP:[EMAIL PROTECTED]] Enviado el: sbado 17 de febrero de 2001 12:56 Para: Multiple recipients of list ORACLE-L Asunto: Re:Thankx and more questions about SID Thankx for info Can I write a query which will give me a SESSION ID of only my session?? And where system id is stored? Thankx and regards Bipin --- Arun Aggarwal [EMAIL PROTECTED] wrote: The SID in V$SESSION is session id not the system ID given to the Instance. These are two different things. Regards Arun Aggarwal Aithent Technologies (P) Ltd. [EMAIL PROTECTED] +91-124-6455504 (101) "If I knew what I was so anxious about, I wouldn't be so anxious." --Mignon McLaughlin - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 13:55 Hi ALL, I'm confused regarding numeric and multiple SIDs present in V$SESSION for same USER# and USERNAME How is it possible?? As far as I know there should be one SID for every instance of oracle. Then how v$session shows me more than one SID for same user.And if all these numeric SIDs correspond to one alphanumeric SID which is SID of that instance then where is the mapping between numeric and alpha numeric SID? Thankx and regards Bipin Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Aggarwal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Redo logging with version 8.1.6.x
Just rolled out version 8.1.6 to our first "serious" application. It appears that more redo is being generated with the newer software. Does that sound accurate? Or is my application owner not telling me the truth regarding his activities? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Thankx and more questions about SID
Hi, Bipin, The statistic# is the same as in v$statname or v$sysstat or v$sesstat. By the way, select distinct sid from v$mystat is not as fast as select sid from v$mystat where rownum = 1, which is the fastest way I've known to get your own SID. Yong Huang [EMAIL PROTECTED] you wrote: But what is significance of STATISTIC# and VALUE in v$mystat?/ __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Package Vs Procedure
Use Package to store related objects together. Also, Package can have not only stored procedures, but also functions as well. HTH. Gunawan Yuwono --- Rajeshwari [EMAIL PROTECTED] wrote: What is the main difference between Package and procedure ? When a package should be created. Should related procedures be only grouped as a package or otherwise also it can be creaetd. TIA, Raji --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.226 / Virus Database: 108 - Release Date: 1/5/01 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajeshwari INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gunawan Yuwono INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: number(p,s)
Selam, Number represantation is not a byte-to-byte represantation like characters'. If it was so, 1234567 occupies 7 bytes. in fact, it's less (I guess). you can check it by dump function in sql*plus. Oracle uses mantisa/exponent notation to store numeric data like OS does. this notation not only saves space, but also holds huge numeric data from negative values to positive values. there should be a note in metalink which explains details with samples. hope this helps... --- "Bunyamin K.Karadeniz" [EMAIL PROTECTED] wrote: number(p,s) datatype conflicts my mind. every book tells that -84 s 127 How can s be minus. Negative scale?? = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment UNAL INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Doubt] - Returning Type Table
Hi Friends : I have the code bellow and would like to return the variable type table. CREATE OR REPLACE PACKAGE cv_types AS TYPE DeptCurType is REF CURSOR RETURN dept%ROWTYPE; TYPE retorno IS TABLE OF SCOTT.dept%ROWTYPE INDEX BY BINARY_INTEGER; TYPE Tipo_Tabela_Emp IS TABLE OF EMP%ROWTYPE INDEX BY BINARY_INTEGER; TYPE Tipo_Tabela_Dept IS TABLE OF DEPT%ROWTYPE INDEX BY BINARY_INTEGER;END cv_types; create or replace function rtc_dept RETURN cv_types.Tipo_Tabela_DeptIScursor resultset isselect * from dept;tabdept cv_types.Tipo_tabela_Dept;I BINARY_INTEGER;tab dept%rowtype; BEGIN i := 1; open resultset; loop fetch resultset into tab; exit when resultset%notfound; tabdept(i).dname := '- ' || tab.dname; dbms_output.put_line (tabdept(i).dname); i := i + 1; end loop; close resultset; RETURN(tabdept);END; scott scott scott scott VARIABLE rtc REFCURSORscott EXECUTE :rtc := rtc_deptbegin :rtc := rtc_dept; end; *ERROR at line 1:ORA-06550: line 1, column 15:PLS-00382: expression is of wrong typeORA-06550: line 1, column 7:PL/SQL: Statement ignored scott PRINT rtcERROR:ORA-24338: statement handle not executed Error printing variable "rtc"scott what is wrong ? Eriovaldo do Carmo Andrietta Widesoft Sistemas Ltda.Limeira/SP - Brasil
[Doubt] Returning cursor / Type Table / Array
Does anyone have examples that works with : Variable in out (refcursor, type table, type record ) Using its in procedures / functions ? Regards Eriovaldo do Carmo Andrietta Limeira/SP - Brasil -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [ANATOMY OF A SELLOUT/ COWARD/ LIAR] Re: OT:Clinton/the econo
I live in the US, I enjoy discussing politics and philosophy, but that is not exactly why I subscribed to this mailing list. Can you take this debate to alt.talk.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Removing multiple spaces from a string
There must be an easy way to remove multiple spaces from a VARCHAR2, but I can't think of one apart from running replace(string,' ', ' ') many times. I'm parsing a large string of text, with all sorts of punctuation and multiple spaces interspersing the words. Any help gratefully received Thanks, Mike Monaghan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MONAGHAN, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo logging with version 8.1.6.x
We can see a significant increase in generated redo information on both Solaris and HP-UX platforms. I think it has also been documented. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo logging with version 8.1.6.x Hi Dan, What os? What did you upgrade from? I didn't see anything significant change with redo when we upgraded... Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Redo logging with version 8.1.6.x Just rolled out version 8.1.6 to our first "serious" application. It appears that more redo is being generated with the newer software. Does that sound accurate? Or is my application owner not telling me the truth regarding his activities? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo logging with version 8.1.6.x - Cherie?
Title: RE: Redo logging with version 8.1.6.x - Cherie? Oh. We were a much lesser upgrade (8.1.5 - 8.1.6) on HP/UX 11.x. So I guess my experience does not speak to what you are seeing. Cherie, do you have any insights to add? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 11:11 AM To: [EMAIL PROTECTED] Subject: RE: Redo logging with version 8.1.6.x Hi. Sorry for the lack of information. Solaris 2.6 From v7.3.4 to v8.1.6 Thanks. CN=Dan [EMAIL PROTECTED] on 02/19/2001 09:37:06 AM Sent by: Koivu, Lisa [EMAIL PROTECTED] Sent From the mail file of: Dan Hubler To: '[EMAIL PROTECTED]' [EMAIL PROTECTED], '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc: Subject: RE: Redo logging with version 8.1.6.x Hi Dan, What os? What did you upgrade from? I didn't see anything significant change with redo when we upgraded... Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Redo logging with version 8.1.6.x Just rolled out version 8.1.6 to our first serious application. It appears that more redo is being generated with the newer software. Does that sound accurate? Or is my application owner not telling me the truth regarding his activities? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NLS question about Euro Sign
Not sure, but I think that is character set WE8ISO8859P15. Henry -Original Message- Sent: Monday, February 19, 2001 11:14 AM To: 'Oracle List'; 'Oracle Lazy DBA list' Hi list, I life in europe an we have the Euro Sign (EUR). My problem ist that I can't save this sign in my oracle databases. My database and client charactersets are WE8ISO8859P1. Database versions are 8.1.5 and 8.1.6. Is there a patch for this or any trick to save euro sign in Oracle database? TIA Volker E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NLS question about Euro Sign
Hi list, I life in europe an we have the Euro Sign (EUR). My problem ist that I can't save this sign in my oracle databases. My database and client charactersets are WE8ISO8859P1. Database versions are 8.1.5 and 8.1.6. Is there a patch for this or any trick to save euro sign in Oracle database? TIA Volker E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: more questions about SID
Howe about this little ditty: select s.sid sid, c.sql_text sql_text, c.address address, ltrim(to_char(c.hash_value,'99'),' ') hash_value from v$open_cursor c, v$session s where c.saddr = s.saddr and c.hash_value != s.sql_hash_value and s.username = 'YOUR_USER_NAME' This should give you all SQL being executed by your user name, unless all users log on to an app, that then uses the same username to access the database. In this case, you could change s.username to OSUSER, if known, or in fact TERMINAL. You should know these for your own PC.. Is this what you are looking for? Regards Mark -Original Message- sahani Sent: Monday, February 19, 2001 02:31 To: Multiple recipients of list ORACLE-L Thankx for info. But these SID are unique for each oracle user.They can't be distingish if 10 persons using same Oracle login and issuing 10 different queries. I want to know SID for a specific query issued by me. Is there a way to find it out??? Thankx and regards Bipin --- "Trassens, Christian" [EMAIL PROTECTED] wrote: You have some options: select sid from v$mystat where rownum=1; If the user has privilege to access sys.v_$session, then you can issue: select sid from v$session where audsid=userenv('SESSIONID'); However connected as internal the userenv('SESSIONID') gives you a 0. Hence, you couldn't recognize the sid. Regards. -Mensaje original- De: bipin sahani [SMTP:[EMAIL PROTECTED]] Enviado el: sbado 17 de febrero de 2001 12:56 Para: Multiple recipients of list ORACLE-L Asunto: Re:Thankx and more questions about SID Thankx for info Can I write a query which will give me a SESSION ID of only my session?? And where system id is stored? Thankx and regards Bipin --- Arun Aggarwal [EMAIL PROTECTED] wrote: The SID in V$SESSION is session id not the system ID given to the Instance. These are two different things. Regards Arun Aggarwal Aithent Technologies (P) Ltd. [EMAIL PROTECTED] +91-124-6455504 (101) "If I knew what I was so anxious about, I wouldn't be so anxious." --Mignon McLaughlin - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 13:55 Hi ALL, I'm confused regarding numeric and multiple SIDs present in V$SESSION for same USER# and USERNAME How is it possible?? As far as I know there should be one SID for every instance of oracle. Then how v$session shows me more than one SID for same user.And if all these numeric SIDs correspond to one alphanumeric SID which is SID of that instance then where is the mapping between numeric and alpha numeric SID? Thankx and regards Bipin Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Aggarwal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
One more time: redo logging and Oracle 8.1.6
Just rolled out version 8.1.6 to our first "serious" application. It appears that more redo is being generated with the newer software. Does that sound accurate? Or is my application owner not telling me the truth regarding his activities? Upgrade was from v7.3.4.4 to v8.1.6.x on Solaris 2.6. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
mts connections
Hi list, I set up MTS for one of my instance in Sun OS 5.7 Looks like that the setup works fine by issue 'lsnrctl services' command: tsp has 2 service handler(s) DEDICATED SERVER established:6332 refused:0 LOCAL SERVER DISPATCHER established:0 refused:0 current:0 max:254 state:ready D000 machine: nnidb1, pid: 5412 (ADDRESS=(PROTOCOL=ipc)(DEV=20)(KEY=#5412.1)) My question is, why no session has ever established through dispather, even though there are 6332 session connected through dedicated services. Is there a threshod for MTS kicks in? TIA Eveleen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Redo space wait ratio
Hi all, Does anyone have a decent explanation of what this is. TOAD is telling me that it is high and I am not sure why. All that I gathered off of metalink is that there is high use of the disk that the redo logs are on. I checked and I don't think that disk usage is unusually high, but I would say the temp tablespace has been being used more that usual. Is this the only explanation? Any ideas? Thanks all. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT [sleaze warning]: Clinton *not* on Oracle board
http://www.zdnet.com/zdnn/stories/news/0,4586,2686881,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NLS question about Euro Sign
use WE8ISO8859P15 -Original Message- Sent: Monday, February 19, 2001 05:16 PM To: Multiple recipients of list ORACLE-L Hi list, I life in europe an we have the Euro Sign (EUR). My problem ist that I can't save this sign in my oracle databases. My database and client charactersets are WE8ISO8859P1. Database versions are 8.1.5 and 8.1.6. Is there a patch for this or any trick to save euro sign in Oracle database? TIA Volker E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Scripts -- Scripts -- Scripts (One more time)
Thank you all people. Greetings ___ Do You Yahoo!? Enva mensajes instantneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NLS question about Euro Sign
I think that is true, but you might want to check Metalink. Henry -Original Message- Sent: Monday, February 19, 2001 11:42 AM To: Henry Poras; 'Oracle List'; 'Oracle Lazy DBA list' Hi Henry, does this mean I have to convert all my databases to WE8ISO8859P15? Volker E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprngliche Nachricht- Von: Henry Poras [mailto:[EMAIL PROTECTED]] Gesendet: 19. February 2001 17:22 An: Schoen Volker; 'Oracle List'; 'Oracle Lazy DBA list' Betreff: RE: NLS question about Euro Sign Not sure, but I think that is character set WE8ISO8859P15. Henry -Original Message- Sent: Monday, February 19, 2001 11:14 AM To: 'Oracle List'; 'Oracle Lazy DBA list' Hi list, I life in europe an we have the Euro Sign (EUR). My problem ist that I can't save this sign in my oracle databases. My database and client charactersets are WE8ISO8859P1. Database versions are 8.1.5 and 8.1.6. Is there a patch for this or any trick to save euro sign in Oracle database? TIA Volker E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: lampert server
Yes. This is harmless. Lamport scheme is used for SCN generation. Particularly applicable to OPS databases since the SCN has to be genarated across all the instances uniquely. Conceptually, determines how the recent SCN will be propogated between the instances. Refer to OPS concept guide, if you need detailed information.. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies www.i2.com "orclbabu" orclbabu@hotTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mail.comcc: Sent by: Subject: lampert server root@fatcity. com 02/19/01 10:21 AM Please respond to ORACLE-L Hi List I recently got this message in my alert log : Picked Lapert Server scheme to generate SCNs. I guess its harmless and more of a information only entry. But does anyone know more about it? Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Converting DOS batch file to UNIX script
DOS: ---snip--- @ECHO OFF ECHO To run this installation please type (at the CD-ROM prompt) IF "==%1" GOTO NODRIVE CD\ MKDIR %1:\DB543 COPY \SERVER\SCRIPTS\Install.bat %1:\DB543\SERVER\SCRIPTS\Install.bat NUL: :NODRIVE REM this is a remark call %1:\DB543\SERVER\Scripts\Install.bat parm1 parm2 parm3 sqlplus system/manager@db ---snip--- UNIX: ---snip--- #!/bin/sh # This is a comment, the 1st line above is a special comment: # it tells UNIX to invoke /bin/sh (the standard command interpreter # for scripts to process this script # adjust your PATH to your needs PATH=/bin:/usr/bin:$ORACLE_HOME/bin: # export your PATH into the environment export PATH # no need for echo off, this is kind of default echo "To run this installation please type (at the CD-ROM prompt)" # UNIX has no drive letters, all drives ( if mounted ) should be accessible under the directory '/', the root directory if [ "X$1" != "X" ] then # 1st parameter ( $1 ) is not empty, I suppose $1 should contain the # base directory of your stuff # note: put white space between 'cd' and the directory name cd / # cp does not create directories, you have to create them yourself mkdir $1/DB543/ mkdir $1/DB543/SERVER mkdir $1/DB543/SERVER/SCRIPTS cp /SERVER/SCRIPTS/Install.bat /$1/DB543/SERVER/SCRIPTS/Install.bat # output redirect NUL would be in UNIX: /dev/null # but cp won't give any messages except an error occurred # so we can omit this fi # note: 'fi' means end if $1/DB543/SERVER/Scripts/Install.bat $parm1 $parm2 $parm3 sqlplus system/manager@db ---snip--- Just a few notes: This is just a try to "translate your DOS Batch file" Be sure to make your scripts executable: chmod +x yourscript and chmod +x $1/DB543/SERVER/Scripts/Install.bat In Unix there is also no need to call a script '.BAT'. You can simply call it 'install' or if you like to 'install.sh' to indicate that is is a Bourne Shell Script (standard scripting language on UNIX). Unix is case sensitive. I don't know exactly what you are going to do with parm1, so I can't figure out more... Hope this helped a bit. Andreas -- Von: Berg, Guy van den[SMTP:[EMAIL PROTECTED]] Gesendet: Montag, 19. Februar 2001 12:20 An: Multiple recipients of list ORACLE-L Betreff: RE: Converting DOS batch file to UNIX script Quick point that could cause some problems...REM is NOT rm in unix! Try # instead or you could end up with an interesting shell script ;) Cheers, g. -Original Message- Sent: 17 February 2001 03:40 To: Multiple recipients of list ORACLE-L cp, mkdir, cd, echo, rm - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 2:02 PM Hello All: We are a Windows shop developing a software product that runs on an Oracle database. Most of our clients also run Oracle on Windows. Recently, a couple of our new clients have decided to run our database on a UNIX server instead of NT server. I do not know what flavour of UNIX our clients have. I know the slashes go in the other direction in UNIX scripts, but can anybody tell me the UNIX equivalent of COPY, MKDIR, CD, ECHO, and REM? Here are a few lines of the batch file we use to install our product. Can anybody help me to convert DOS batch file commands to generic UNIX script commands? ---snip--- @ECHO OFF ECHO To run this installation please type (at the CD-ROM prompt) IF "==%1" GOTO NODRIVE CD\ MKDIR %1:\DB543 COPY \SERVER\SCRIPTS\Install.bat %1:\DB543\SERVER\SCRIPTS\Install.bat NUL: :NODRIVE REM this is a remark call %1:\DB543\SERVER\Scripts\Install.bat parm1 parm2 parm3 sqlplus system/manager@db ---snip--- Thanks for your help. Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Allan Nelson INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
Info needed
Hi all, I would like to look into the metalinks for the technical information,so pls can anyone guide me how to become member and how to access it and whats the address Thanks in advance begin:vcard n:Nagaraj;Vinod tel;cell:303-332-7223 tel;work:720-962-4355 x-mozilla-html:FALSE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Vinod Kumar Nagaraj end:vcard
Send Email on NT/2000
Hi! For all guys running Oracle on NT/2000: I found this nice little tool that you can e.g. use to have the alert log file mailed to you. I also run a tablespace usage script that writes the results to a txt file. Then I use automailer to mail me that file. Check it out: http://www.duodata.de/automailer/ AutoMailer automatically transfers files as email-attachments. The files you wish to be mailed must be stored in a single directory on your hard drive. AutoMailer periodically polls this directory for changes and if a new or modified file is found, it is mailed. hth, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: mts connections
Hi, That it is because you aren't using a service referencing the dispatcher. F.e. On 8i: in init.ora mts_dispatchers="(protocol=ipc)(dispatchers=1)(service=mtsipc)" And in the tnsnames.ora mtsservice= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =IPC)(KEY=SID or if you use listener.ora, then the ipc alias)) ) (CONNECT_DATA = (service_name= mtsipc)) ) -Mensaje original- De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 19 de febrero de 2001 18:21 Para: Multiple recipients of list ORACLE-L Asunto: mts connections Hi list, I set up MTS for one of my instance in Sun OS 5.7 Looks like that the setup works fine by issue 'lsnrctl services' command: tsp has 2 service handler(s) DEDICATED SERVER established:6332 refused:0 LOCAL SERVER DISPATCHER established:0 refused:0 current:0 max:254 state:ready D000 machine: nnidb1, pid: 5412 (ADDRESS=(PROTOCOL=ipc)(DEV=20)(KEY=#5412.1)) My question is, why no session has ever established through dispather, even though there are 6332 session connected through dedicated services. Is there a threshod for MTS kicks in? TIA Eveleen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Info needed
http://metalink.oracle.com/ patrick === Patrick Housholder Sr. Staff Anl Tech Spt Design United Airlines Flight Training Center Denver CO *-Original Message- *From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vinod *Nagaraj *Sent: Monday, February 19, 2001 11:21 AM *To: Multiple recipients of list ORACLE-L *Subject: Info needed * * *Hi all, *I would like to look into the metalinks for the technical information,so *pls can anyone guide me how to become member and how to access it and *whats the address * *Thanks in advance * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Patrick Housholder INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: shutdown Abort...Open normal??
STARUP FORCE - Issue a shutdown abort and then try to immediately restart the database. STARTUP RESTRICT - Open the database and only allow access to users with the RESTRICTED SESSION role. STARTUP MOUNT - Mounts the database, but doesn't open it for use. STARTUP NOMOUNT - Does not mount the database STARTUP RECOVER - Similar to the recover database command. It starts the database and attempts a recovery. STARTUP OPEN - Mounts and Opens the database STARTUP - Default open, which is STARTUP OPEN. "Raghu Kota" [EMAIL PROTECTED] 02/16/01 04:10PM Hi Friends Could you explain this.. SVRMGR connect sys as sysoper; Password: Connected. SVRMGR shutdown abort ORACLE instance shut down. SVRMGR startup open; ORACLE instance started. Database mounted. Database opened. SVRMGR I thought recovery is needed, But its opened? Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
* Oracle DBA Skills Needed in the Northern Part of Virginia...
We are currently seeking Oracle candidates with the following skills for a well known company client in Northern Virgina. ( Greater DC Area) These are full time staff opportunities that do notrequire travel outside the greater DC area. Positions available are: * DBAs These positions require 3+ years of Oracle Experience and excellent communications skills. U.S. Citizens only will qualify for these positions. This companies offer: * Challenge * A compensation package * The opportunity keep up with the lastest technologies. NO sub-contracting opportunities. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: Bill Law, Oracle Placement Specialist Orastaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: One/O. Skills/NOVA/SW/ We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiitiondescribed above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Package Vs Procedure
plus variables( though it's not a good idea to use them ), constants, types, cursors, etc HTH, Michael Netrusov, www.atelo.com - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 19, 2001 10:31 Use Package to store related objects together. Also, Package can have not only stored procedures, but also functions as well. HTH. Gunawan Yuwono --- Rajeshwari [EMAIL PROTECTED] wrote: What is the main difference between Package and procedure ? When a package should be created. Should related procedures be only grouped as a package or otherwise also it can be creaetd. TIA, Raji --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.226 / Virus Database: 108 - Release Date: 1/5/01 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajeshwari INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gunawan Yuwono INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Netrusov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Removing multiple spaces from a string
SQL help replace REPLACE SYNTAX: REPLACE(char, search_string [,replacement_string]) PURPOSE: Returns char with every occurrence of search_string replaced with replacement_string. If replacement_string is omitted or null, all occurrences of search_string are removed. If search_string is null, char is returned. This function provides a superset of the functionality provided by the TRANSLATE function. TRANSLATE provides single character, one to one, substitution. REPLACE allows you to substitute one string for another as well as to remove character strings.-Original Message- Sent: Monday, February 19, 2001 11:05 AM To: Multiple recipients of list ORACLE-L There must be an easy way to remove multiple spaces from a VARCHAR2, but I can't think of one apart from running replace(string,' ', ' ') many times. I'm parsing a large string of text, with all sorts of punctuation and multiple spaces interspersing the words. Any help gratefully received Thanks, Mike Monaghan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MONAGHAN, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Singh Gunmeet-G14987 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo space wait ratio
Hi Kevin, High 'redo log space requests' are often caused by slow log switches. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 20 February 2001 2:22 To: Multiple recipients of list ORACLE-L Hi all, Does anyone have a decent explanation of what this is. TOAD is telling me that it is high and I am not sure why. All that I gathered off of metalink is that there is high use of the disk that the redo logs are on. I checked and I don't think that disk usage is unusually high, but I would say the temp tablespace has been being used more that usual. Is this the only explanation? Any ideas? Thanks all. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
fastscan and maxpgio in Solaris 8?
I have a question concerning some tunables in /etc/system associated with priority paging and Solaris 8. In the Sun/Oracle Best Practices paper, it mentions that, in addition to 'set priority_paging=1', that a couple of other tunables be defined: set fastcan=131072 set maxpgio=65536 Is fastscan and maxpgio still applicable in Solaris 8? Thanks, Lou Avrami ( [EMAIL PROTECTED] ) -- From: David Miller [EMAIL PROTECTED] Date: Thu, 25 Jan 2001 17:10:01 -0600 (CST) Subject: RE: New Sun/Oracle Blueprint available Hi Ross, I forwarded your comments on to the author, Bob Sneed, who replies below. Dave Miller Sun Microsystems, Inc. - Begin Forwarded Message - Date: Thu, 25 Jan 2001 09:58:14 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Mohan, Ross" [EMAIL PROTECTED] From: "Mohan, Ross" [EMAIL PROTECTED] Subject: RE: New Sun/Oracle Blueprint available X-ListServer: v1.0f, build 69; ListGuru (c) 1996-2000 Bruce A. Bergman Mime-Version: 1.0 Dave, The doc looks useful, so thanks for posting this URL. There is plenty in the document to recommend it. But, here is this gem from the document itself: # "An AIO problem has often been perceived when truss is used to observe Oracle I/O operations. With AIO on filesystems, a kaio(2) call can be observed to routinely return ENOTSUP results, and the mistaken conclusion is drawn that AIO is 'broken'. Actually, the kaio(2) system call is not an exposed interface. That is, only the library functions aioread(3) and kin are published as supported by Sun, and kaio(2) is one of the secrets to the libaio.so implementation underlying the AIO API. In other words, this is not a bug - it's a feature!" # Huh? An OS call returns an Error, but is really OK? The real AIO is a hidden "secret" that Sun customers cannot track or read up on, so it's not a bug, but a "feature"?. Sequent ( now IBM ) has had Async IO since 1995, and the calls never threw exceptions when viewed with truss. Good comment! I despise all the 'Secrets of ...' books I see in bookstores, as they run against the grain of 'open', right? In this case, there is indeed no man page for the kaio(2) call, but since it is cleary visible by truss, it is no real secret. The Sun libaio implementation has previously been discussed in SunWorld online, further reducing the 'secret' aspect of this. Don't expect to see kaio(2) documented, though, as it is quite subject to change, and we do try to keep customers and ISV's out of the trouble that comes from interfacing with moving targets in the OS. Historically, most vendors have offered AIO only to RAW devices. Some vendors, like HP an IBM (pre-Dynix), have not historicaly offered 'truss' (or 'strace', or similar) at the command online to allow users to make misdiagnoses such as we have seen so often with truss and libaio. Our offering provides AIO to filesystem files via the same interface as for RAW, and this has proven to be a real workhorse. Since the current implementation must somehow branch between the file versus RAW path, the logic is a 'feature' because ... if (ioctl() says it's RAW) then do KAIO else do LWP-based AIO ... would require an extra system call per I/O compared to the way it is now implemented ... do KAIO if (that failed) then do LWP-based AIO ... and as it turns out, the extra kaio call for the LWP case is a very slight per-call overhead to the LWP-managed logic. I am sympathetic to the notion that 'clever' is merely 'irritating' when the documentation is not there. I would support a customer filing a bug report complaining that kaio(2) is not documented, and should be, even if only to say that it is not a 'supported' or 'exposed' interface. Much later, in the footnotes, the author acknowledges that "Certain Oracle 8.1 releases suppress AIO use on ordinary filesystem files ". Suppress? How? The logic used was essentially "if file is not character special, then use pread/pwrite directly". And, why? Presumably, the "certain releases" referred to are on Solaris, and since there aren't that many "8.1" releases on Solaris, couldn't a specific version be cited? There appears to be a fair bit of work put into this document, and this kind of sentence, which has more the feeling of an unspecified assertion than a hard-won technical observation, does not do it credit. Good comment. The constraint was removed at 8.1.7, and will be with 9i, I am told. 8.1.7 introduces a new init.ora parameter to allow re-enabling AIO to ordinary files. At the time the original copy was written, the 8.1.7 news was not out. Overall, the document has a good intention, but in my humble and hope-to-be-noninflammatory opinion, there is less meat
Using OLE DB connection
Hi there! I have a question concerning the usage of the Oracle OLE DB provider on Win2k. We have a web server (running on Win2k) with a bunch of COM+ objects on it that are connecting to an Oracle database. The connection is made through the Oracle OLE DB provider 8.1.6.2.0. Does anybody have an idea what the performance overhead is when using OLE DB instead of using native Net8? Is it significant? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: lamport server
Hi All, Leslie Lamport's research papers are available at ftp://ftp.digital.com/pub/DEC/SRC/researchreports/ The Ixora search engine has direct links to some of the more interesting ones. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 20 February 2001 3:51 To: Multiple recipients of list ORACLE-L Yes. This is harmless. Lamport scheme is used for SCN generation. Particularly applicable to OPS databases since the SCN has to be genarated across all the instances uniquely. Conceptually, determines how the recent SCN will be propogated between the instances. Refer to OPS concept guide, if you need detailed information.. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies www.i2.com "orclbabu" orclbabu@hotTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mail.comcc: Sent by: Subject: lampert server root@fatcity. com 02/19/01 10:21 AM Please respond to ORACLE-L Hi List I recently got this message in my alert log : Picked Lapert Server scheme to generate SCNs. I guess its harmless and more of a information only entry. But does anyone know more about it? Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: lamport server
Slight typo. Actually it is ftp://ftp.digital.com/pub/DEC/SRC/research-reports/ Henry -Original Message- Sent: Monday, February 19, 2001 8:07 PM To: [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L; [EMAIL PROTECTED] Hi All, Leslie Lamport's research papers are available at ftp://ftp.digital.com/pub/DEC/SRC/researchreports/ The Ixora search engine has direct links to some of the more interesting ones. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 20 February 2001 3:51 To: Multiple recipients of list ORACLE-L Yes. This is harmless. Lamport scheme is used for SCN generation. Particularly applicable to OPS databases since the SCN has to be genarated across all the instances uniquely. Conceptually, determines how the recent SCN will be propogated between the instances. Refer to OPS concept guide, if you need detailed information.. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies www.i2.com "orclbabu" orclbabu@hotTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mail.comcc: Sent by: Subject: lampert server root@fatcity. com 02/19/01 10:21 AM Please respond to ORACLE-L Hi List I recently got this message in my alert log : Picked Lapert Server scheme to generate SCNs. I guess its harmless and more of a information only entry. But does anyone know more about it? Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: EXPLAIN OUTPUT
Some of our developers put '--' i.e. comments in their SQL. This is painful when trying to extract the SQL to explain (screws dbartisan up as well) . Does anybody have an SQL Query that can help or point me to a manual or paper that says it is bad practice to put comments inside SQL blocks. Regards Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
A basic forms question
Hi, A user aksed me (a DBA) the question below about forms: I have been trying to open some Oracle forms but it always gives me this message: "form was created by an old version of form builder" or "cannot open form". Do you know what this mean? I looked at the fmb files and appears to be dated the 9/2/00 when the fmx files are dated the 9/6/00. Is there a way to fix this? It's the same for the other computers in our office but somehow you can open the forms without any hiccups. Also, Is it possible to import the structure of Oracle forms to Access or you have to build them from scratch in Access. So far, we've only been able to import the data from Oracle to Access only. I never use forms so do not know the answer. It seems that the user was using a newer version of forms to open an a form created in an old version. For Forms do you need to upgrade old forms when you upgrade the forms software? Also pls answer the Access question if you can. Much appreciated. Many thanks. Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: more questions about SID
Thankx Mark, That was info. which I'm looking for.Can U pls. expalin me what is hash_value,address,sql_hash_value And where is SYSTEM ID is stored in Oracle Regards Bipin --- DIRCON [EMAIL PROTECTED] wrote: Howe about this little ditty: select s.sid sid, c.sql_text sql_text, c.address address, ltrim(to_char(c.hash_value,'99'),' ') hash_value from v$open_cursor c, v$session s where c.saddr = s.saddr and c.hash_value != s.sql_hash_value and s.username = 'YOUR_USER_NAME' This should give you all SQL being executed by your user name, unless all users log on to an app, that then uses the same username to access the database. In this case, you could change s.username to OSUSER, if known, or in fact TERMINAL. You should know these for your own PC.. Is this what you are looking for? Regards Mark -Original Message- sahani Sent: Monday, February 19, 2001 02:31 To: Multiple recipients of list ORACLE-L Thankx for info. But these SID are unique for each oracle user.They can't be distingish if 10 persons using same Oracle login and issuing 10 different queries. I want to know SID for a specific query issued by me. Is there a way to find it out??? Thankx and regards Bipin --- "Trassens, Christian" [EMAIL PROTECTED] wrote: You have some options: select sid from v$mystat where rownum=1; If the user has privilege to access sys.v_$session, then you can issue: select sid from v$session where audsid=userenv('SESSIONID'); However connected as internal the userenv('SESSIONID') gives you a 0. Hence, you couldn't recognize the sid. Regards. -Mensaje original- De: bipin sahani [SMTP:[EMAIL PROTECTED]] Enviado el: sbado 17 de febrero de 2001 12:56 Para: Multiple recipients of list ORACLE-L Asunto: Re:Thankx and more questions about SID Thankx for info Can I write a query which will give me a SESSION ID of only my session?? And where system id is stored? Thankx and regards Bipin --- Arun Aggarwal [EMAIL PROTECTED] wrote: The SID in V$SESSION is session id not the system ID given to the Instance. These are two different things. Regards Arun Aggarwal Aithent Technologies (P) Ltd. [EMAIL PROTECTED] +91-124-6455504 (101) "If I knew what I was so anxious about, I wouldn't be so anxious." --Mignon McLaughlin - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 13:55 Hi ALL, I'm confused regarding numeric and multiple SIDs present in V$SESSION for same USER# and USERNAME How is it possible?? As far as I know there should be one SID for every instance of oracle. Then how v$session shows me more than one SID for same user.And if all these numeric SIDs correspond to one alphanumeric SID which is SID of that instance then where is the mapping between numeric and alpha numeric SID? Thankx and regards Bipin Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Aggarwal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB === message truncated === Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Problem in configuration of MTS in Oracle8.0.5
Hi,Can U help me out ...I was configuring the my Oracle 8.0.5 Enterprise server in Solaris 2.6 as MTSserver.I'm having 2 seperate ethernet cards ( using TCP/IP Protocol) in that systemwith following parameters ininitSID.ora : mts_dispatchers="ipc,1" mts_dispatchers="(PROTOCOL=TCP)(DISPATCHER=3)" mts_max_dispatchers=10 mts_servers=1 mts_max_servers=10 mts_service=sid mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))" mts_listener_address="(ADDRESS=(PROTOCOL=TCP)(HOST = IP1)(PORT=1521))" mts_listener_address="(ADDRESS=(PROTOCOL=TCP)(HOST = IP2)(PORT=1521))"with (ADDRESS=(PROTOCOL=TCP)(HOST = IP1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST = IP2) (PORT=1521)) in listener.orabut when the database and listener get started , it is showing 9 dispatcherswith TCP with IP1 address and 1 dispatcher with IPC protocols with "service"command in "lisnerctl" utility.Therefore I am unable to connect the server with IP2 address.Now what should I do?Thanks With warm Regards Rana SenguptaExecutive SystemsUsha Martin Telekom Ltd.11 Dr. U N Bhramchari Road.Calcutta - 700017Cell Phone: + 91 98300 32780Email : [EMAIL PROTECTED]Web: www.commandcell.com