Re: National characters and UTL_FILE
Hello Vladimir I think that you need to take a look at the file before and after applying "unix2dos". Since you work with CE characters, maybe the conversion program can not handle this. BTW - in Oracle 9.2 you can use utl_file to write Unicode to the file. Maybe this will help you. Yechiel AdarMehish - Original Message - From: Vladimir Barac To: Multiple recipients of list ORACLE-L Sent: Friday, December 06, 2002 1:58 PM Subject: National characters and UTL_FILE Hello to everyone I want to write national characters (Central European)to ASCII file, by using utl_file. UTL_FILE is called within unix script, and afterwards ascii file (after applying "unix2dos") is sent as an attachment (by using "uuenview"). Both NLS_CHARACTERSET (EE8ISO8859P2) parameters are same within script (env.variable) and database. But, instead of those specific letters I receive mail with useless content. I have then tried binary ftp of ASCII file, but to no avail. I'm entering and reading those characters trough Forms with no problem at all. So, is it possible to write CE characters (DOS extended character set actually) into ascii file? Regional settings at Windows client (where mail or ftp are received) are appropriate (meaning, they are not set as USA...)...
Oracle/PHP help neded
Hi ! I have a problem with an oracle bulk insert technology. I have to insert big amounts of data in an oracle database in one table and the only suitable way is to have a PLSQL procedure on the server side and to create collection on the server for the data. The oracle client is PHP module for Apache. The PLSQL procedure looks like: begin forall i in 1..1 insert into result_val ( rval, rtype ) values(:myval(i), :mytype(i)); end; Before running the PLSQL procedure I am creating the data collections with OCINewCollection function from PHP and after this I'm binding the data with the collections. The problem is that procedure works 9 times out of 10. When it is working the data is inserted realy fast and everything is fine. When it is not working the php script runs fine and no error message is returned but the data is not inserted. I'm realy confused because no error message is returned and in order to detect the error I'm running a count query after I run the PLSQL procedure to check if any data was inserted or not. Please give me a hint how to figure out what is happening. Best regards, Adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Ciocildau INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Increase size of data files and rollback segments
How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Thanks,David
Blank-padded comparison semantic with VARCHAR2 datatype
Hello all, I am migrating an application to the Oracle backend. Unfortunately, it uses blank-padded semantics when compares string values. I store strings as VARCHAR2 in Oracle, which uses non-padded comparison semantics for it. The question: should I go for CHAR (oracle compare them as blank-padded) or there is some setting (session level preferably), so Oracle compare VARCHAR2 in the same way as CHAR? TIA, Alex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Increase size of data files and rollback segments
On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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]
SET ORACLE-L NOMAIL Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle10i SE benchmarks on HP -- listed
Did you compare the price / performance ratio, the throughput and the total cost for both systems? Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, December 09, 2002 1:34 AM To: Multiple recipients of list ORACLE-L Guys and Gals, The Oracle10i SE benchmarks on HP on Itanium2 (RedHat Linux and HPUX 11i) are already listed at http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=102111202 and http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=102111301 Both configurations are listed as to be available 11-May-2003 although the Hardware is Available Now. Wonder if Oracle has really frozen the 10i production code ? What about the Enterprise Edition, then ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hkchital INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: sql tuning help
Tom, Apologies if this has been covered already but isn't this a prime candidate for the sum(decode()) trick with perhaps instr used to do the match. I think you could take count of all records and subtract the 1 or 0 for each of the specific ones. The select part would look horrendous but overall I think it would be faster as it would allow you to drive off the phy_id which I assume would be indexed. Iain Nicoll -Original Message- Sent: 06 December 2002 18:15 To: Multiple recipients of list ORACLE-L Tom, Actually it returns 1 record. Thanks Rick Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: sql tuning help Sent by: [EMAIL PROTECTED] 12/06/2002 11:41 AM Please respond to ORACLE-L Rick, does this return *any* records at all? the only reason that I ask is that in the 'where' clause, it is saying: where p.phy_id = board_aaps.phy_id (+) and p.phy_id = board_aba.phy_id (+) and p.phy_id = board_abem.phy_id (+) and p.phy_id = board_abfp.phy_id (+) and p.phy_id = board_abim.phy_id (+) and p.phy_id = board_abp.phy_id (+) and p.phy_id = board_abr.phy_id (+) and p.phy_id = board_aobem.phy_id (+) and p.phy_id = board_aobfp.phy_id (+) and p.phy_id = board_aobim.phy_id (+) and p.phy_id = board_aobr.phy_id (+) and p.phy_id = board_other.phy_id (+) and p.phy_id = 1870; well, from my way of thinking, a single record from p.phy_id cannot be equal to all of the others at the same time. so no records should be returned at all. I think I would re-wright the entire mess using a set of UNIONS to accomplish the same thing. something like: select board_other.description strBrdNameOtherTHQuest ,decode(board_aaps.description, null,' ','X') ysnAAPSBoard ,decode(board_aba.description, null,' ','X') ysnABABoard ,decode(board_abem.description, null,' ','X') ysnABEMBoard ,decode(board_abfp.description, null,' ','X') ysnABFPoard ,decode(board_abim.description, null,' ','X') ysnABIMBoard ,decode(board_abp.description, null,' ','X') ysnABPBoard ,decode(board_abr.description, null,' ','X') ysnABRBoard ,decode(board_aobem.description, null,' ','X') ysnAOBEMBoard ,decode(board_aobfp.description, null,' ','X') ysnAOBFPBoard ,decode(board_aobim.description, null,' ','X') ysnAOBIMBAoard ,decode(board_aobr.description, null,' ','X') ysnAOBRBoard ,decode(board_other.description, null,' ','X') ysnOtherBoard from phy_boards pb, boards b, physicians p where p.phy_id = pb.phy_id and pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN ASSOCIATION OF PHYSICIAN SPECIALIST%' union select board_other.description strBrdNameOtherTHQuest ,decode(board_aaps.description, null,' ','X') ysnAAPSBoard ,decode(board_aba.description, null,' ','X') ysnABABoard ,decode(board_abem.description, null,' ','X') ysnABEMBoard ,decode(board_abfp.description, null,' ','X') ysnABFPoard ,decode(board_abim.description, null,' ','X') ysnABIMBoard ,decode(board_abp.description, null,' ','X') ysnABPBoard ,decode(board_abr.description, null,' ','X') ysnABRBoard ,decode(board_aobem.description, null,' ','X') ysnAOBEMBoard ,decode(board_aobfp.description, null,' ','X') ysnAOBFPBoard ,decode(board_aobim.description, null,' ','X') ysnAOBIMBAoard ,decode(board_aobr.description, null,' ','X') ysnAOBRBoard ,decode(board_other.description, null,' ','X') ysnOtherBoard from phy_boards pb, boards b, physicians p where p.phy_id = pb.phy_id and pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN BOARD OF ANESTHESIOLOGY%' etc. / Does this make sense? Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 06, 2002 7:54 AM To: Multiple recipients of list ORACLE-L Hi, Oracle 8.1.6 NT 4.0 I have a rather complex query a developer gave to me to try to improve performance. There are 3 tables used. All relevant columns used are indexed. The tables have been analyzed SQLWKS select count(*) from physicians; COUNT(*) -- 340043 1 row selected. SQLWKS select count(*) from boards; COUNT(*) -- 220 1 row selected. SQLWKS select count(*) from phy_boards; COUNT(*) -- 450674 Below is the sql statement and explain plan. I see one FTS on 440,000+ records but cannot tell exactly what statement it is and how to resolve Any suggestions
RE:
ORA-00600 - HELP -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 5:44 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L NOMAIL Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Indicator variables
Raj, from what I remember, a NOT NULL constraint has no impact on an indicator variable in 3GL programs. The indicator variable indicates whether the value fetched is null or has a value. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 06, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hi All, What value does an indicator variable in a pro*c program assume when the fetch column value is NOT NULL. Is is 0 or something other that -1. I would appreciate your help. Thanks, Rajesh -Original Message- Sent: Friday, December 06, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Adam - Someone posted a better hidden? parameter awhile back. Jared, was that you? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 06, 2002 11:29 AM To: Multiple recipients of list ORACLE-L I was afraid that'd be the only way. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pillai, Rajesh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: To_Number
Yeah. I was doing data loads for a JD Edwards system (migration from a legacy to JD actually). we had to move the decimal point for some number values from their original to some ridiculously high value to get the data to look right within the system. talk about a waste of money (buying Oracle for this product). Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 06, 2002 7:24 PM To: Multiple recipients of list ORACLE-L On Friday 06 December 2002 08:29, Mercadante, Thomas F wrote: I think their theory was to keep the JD Edwards system totally RDBMS neutral - they could switch out any backend that they wanted to. A patently ridiculous idea. Jared Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 06, 2002 10:34 AM To: Multiple recipients of list ORACLE-L That's probably why it's in a VARCHAR. Correct the data? What strange ideas you mortals have. Burton, Laura L.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] BurtonL cc: @prismplus.coSubject: RE: To_Number m Sent by: root 12/06/2002 09:44 AM Please respond to ORACLE-L Thanks for the email!! I did not know about Dump so I learned something new. The record I thought I had a problem with was ok and that is why I did not see anything amiss. However the record after this one was $20041-94. Corrected that and got $145.34 EA. I just told the developer to handle the 1722 error and let someone else deal with how to correct the data. It's ridiculous! Laura -Original Message- Sent: Thursday, December 05, 2002 8:29 PM To: Multiple recipients of list ORACLE-L Did you check it with dump() ? select dump(unit_cost,16) from tablewhatever; for Hex. Check for unprintables that way. Try inserting the bad values into a look-aside table for later analysis i.e. create table look_aside (rownum rowid, bad_val varchar2(20), dump_val varchar2(200)); declare bad_num exception; numval number(10,2); pragma exception_init(bad_num,-1722); Cursor C1 is select rowid,unit_cost from yourtable; begin for x in C1 loop declare -- inner block will allow exception trap begin -- trim and change o's to zeroes numval := to_number(rtrim(replace(x.unit_cost,'O','0'))); exception when bad_num then insert into look_aside values (x.rowid,x.unit_cost, substr(dump(unit_cost,16),1,200)); end; end loop; commit; exception when others then dbms_output.put_line(sqlerrm); end; / You can use the rowids in the look-aside table to zap the bad values later. HTH Jeff Herrick On Thu, 5 Dec 2002, Burton, Laura L. wrote: Since we don't have that many 3rd party software packages I did make the mistake of asking 'Why??' and received 'Because!' so I too am trying to jump in and 'fix it'. As I responded to another email earlier, the RTrim worked because there were spaces after the amount which was causing the problem. The only problem now is I have one record (so far) that has a unit cost that looks like any other unit cost, yet I receive 'invalid number' for it. The only thing I can figure is that there must be an unprintable character in the field that I cannot see and rtrim is not deleting since it isn't a space. Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: Indicator variables
Tom is correct indicator variables 0 - NOT NULL and data retrieved successfully -1 - data is NULL 0 - NOT NULL but possible truncation of data. In 3gl programs such as C ALWAYS use indicator variables. Rick Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: Indicator variables Sent by: [EMAIL PROTECTED] 12/09/2002 08:03 AM Please respond to ORACLE-L Raj, from what I remember, a NOT NULL constraint has no impact on an indicator variable in 3GL programs. The indicator variable indicates whether the value fetched is null or has a value. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 06, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hi All, What value does an indicator variable in a pro*c program assume when the fetch column value is NOT NULL. Is is 0 or something other that -1. I would appreciate your help. Thanks, Rajesh -Original Message- Sent: Friday, December 06, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Adam - Someone posted a better hidden? parameter awhile back. Jared, was that you? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 06, 2002 11:29 AM To: Multiple recipients of list ORACLE-L I was afraid that'd be the only way. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
limiting temp space per user
All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Increase size of data files and rollback segments
A cruel joke Jeremy! BTW may be you can help me out here. I am not receiving back any of the messages I send to the the list and I do not know if list is receiving my messages either. Do you know how to solve this problem? Thanks in advance Shaleen Garg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 3:38 AM On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help Urgent Where is Tablespace Manager??
Title: RE: Help Urgent Where is Tablespace Manager?? This is driving me crazy. Can't seem to find the tablespace manager which I used to pull up from DBA Studio - now I have a different version which doesn't have DBA Studio - where has it been moved or is there a replacement? Help! -Original Message- From: orafaq [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:04 AM To: Multiple recipients of list ORACLE-L Subject: Re: Increase size of data files and rollback segments A cruel joke Jeremy! BTW may be you can help me out here. I am not receiving back any of the messages I send to the the list and I do not know if list is receiving my messages either. Do you know how to solve this problem? Thanks in advance Shaleen Garg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 3:38 AM On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
= sign missing. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 03:43 AM SET ORACLE-L NOMAIL Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Krishna Rao Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help Urgent Where is Tablespace Manager??
Title: RE: Help Urgent Where is Tablespace Manager?? Okay, Apparently not really supported for 9i database just up to 8.1.7 - what replaces it and why am I having so many problems with JRE files? -Original Message- From: Stankus, Paula G Sent: Monday, December 09, 2002 10:11 AM To: '[EMAIL PROTECTED]' Subject: RE: Help Urgent Where is Tablespace Manager?? This is driving me crazy. Can't seem to find the tablespace manager which I used to pull up from DBA Studio - now I have a different version which doesn't have DBA Studio - where has it been moved or is there a replacement? Help! -Original Message- From: orafaq [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:04 AM To: Multiple recipients of list ORACLE-L Subject: Re: Increase size of data files and rollback segments A cruel joke Jeremy! BTW may be you can help me out here. I am not receiving back any of the messages I send to the the list and I do not know if list is receiving my messages either. Do you know how to solve this problem? Thanks in advance Shaleen Garg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 3:38 AM On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: limiting temp space per user
SQL alter user scott quota 10M on temp; User altered. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 06:24 AM All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Krishna Rao Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
STATSPACK
Hi How to clean all old STATSPACK data? Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: limiting temp space per user
Title: RE: limiting temp space per user create a smaller temp table and assign the users account to it. -Original Message- From: Babu Nagarajan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Subject: limiting temp space per user All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Another Java Question
Good Morning. I am trying to get the output of a server process executed by java via Runtime.exec(). Here's the code: import java.sql.*; import java.io.*; public class ip { public static void main (String args []) { Runtime r = Runtime.getRuntime(); try { String sid = emsd; String cmd1 = tnsping + sid + | grep 'Host' | cut -d' ' -f18 | cut -d')' -f1; System.out.println(cmd1); Process p = Runtime.getRuntime().exec(cmd1); int exitValue = p.waitFor(); System.out.println(p); BufferedReader br = new BufferedReader(new InputStreamReader(p.getInputStream())); String ip = br.readLine(); System.out.println(ip); } catch (Exception e) { System.out.println(Generic Exception catch.); } } // end of main() } When I execute it I get: tnsping emsd | grep 'Host' | cut -d' ' -f18 | cut -d')' -f1 java.lang.UNIXProcess@5988f The output of the command line is: 128.100.1.140 Anyone see what I'm missing? Just to make this somewhat oracle related...this is part of a hot backup script. I am trying to grep the ip (and ultimately port) of the listener so I can dynamically generate the connect to the database. :) Thanks, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: STATSPACK
Seema - Which Oracle version. -Original Message- Sent: Monday, December 09, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Hi How to clean all old STATSPACK data? Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STATSPACK
I have not done it but supposely oracle_home\rdbms\admin\sppurge will do it. Rick Seema Singh oracledbam@ho To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tmail.com cc: Sent by: Subject: STATSPACK [EMAIL PROTECTED] om 12/09/2002 11:14 AM Please respond to ORACLE-L Hi How to clean all old STATSPACK data? Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: limiting temp space per user
Temp segments are owned by SYS Waleed -Original Message- Sent: Monday, December 09, 2002 11:04 AM To: Multiple recipients of list ORACLE-L SQL alter user scott quota 10M on temp; User altered. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 06:24 AM All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Krishna Rao Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: STATSPACK
Seema: Head to Tim Gorman's site (www.evdbt.com) and find his sppurpkg.sql download. It uses dbms_jobs to run with a purge each set number of days. It's really slick. Barb Seema Singh [EMAIL PROTECTED] wrote: HiHow to clean all old STATSPACK data?Thx-Seema_STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Seema SinghINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP comm! and for other information (like subscribing).Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
RE: STATSPACK
Title: RE: STATSPACK Well did you look for the table that holds the data? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:15 AM To: Multiple recipients of list ORACLE-L Subject: STATSPACK Hi How to clean all old STATSPACK data? Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
iostat help
Title: iostat help I know what some of the headings are for the following output, but I'm not 100% sure about the CPU section. Does us=users, sy=system, wt=job queue wait, id=process id? cpu us sy wt id 1 3 1 95 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.1 0.7 0.6 4.6 0.0 0.0 5.4 48.2 0 0 c0t0d0 0.0 0.9 1.3 29.8 0.0 0.0 0.0 8.0 0 1 c0t1d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t6d0 0.3 1.6 18.3 14.0 0.0 0.0 0.0 2.9 0 0 c1t1d4 0.1 1.6 0.8 12.9 0.0 0.0 0.1 2.2 0 0 c1t1d5 0.0 0.0 1.6 0.0 0.0 0.0 0.0 10.6 0 0 c1t1d3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 4.1 0 0 c1t1d2 5.0 0.0 161.4 0.0 0.0 0.0 0.0 2.1 0 1 rmt/0 cpu us sy wt id 0 2 0 98
RE: STATSPACK
Title: RE: STATSPACK Wow that does sound way cool Thanks for sending this Barbara. -Original Message- From: Barbara Baker [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: STATSPACK Seema: Head to Tim Gorman's site ( www.evdbt.com http://www.evdbt.com) and find his sppurpkg.sql download. It uses dbms_jobs to run with a purge each set number of days. It's really slick. Barb Seema Singh [EMAIL PROTECTED] wrote: Hi How to clean all old STATSPACK data? Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP comm! and for other information (like subscribing). _ Do you Yahoo!? Yahoo! Mail Plus http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com - Powerful. Affordable. Sign up now http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com
Re: limiting temp space per user
The way we do it is that create two temporary tablespaces. Use one for the production applicationa and other for adhoc users so that adhoc users do not mess up the production. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 8:04 AM SQL alter user scott quota 10M on temp; User altered. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 06:24 AM All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Krishna Rao Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AQ query from dequeuw procedure not using index -URGENT
All, We are using a third party application (Retek Warehouse management) which uses AQ as communication mechanism between processes. The problem we are facing is that the AQ query behind Dequeue is doing a full tablescan on queue table which is causing about 5Billion logical reads/day and is bringing the DB to its knees. Following is the query which I gleaned from tracing the process select /*+ FIRST_ROWS */ qt.rowid, qt.msgid, qt.corrid, qt.priority, qt.delay, qt.expiration, qt.retry_count, qt.exception_qschema, qt.exception_queue, qt.chain_no, qt.local_order_no, qt.enq_time, qt.time_manager_info, qt.state, qt.enq_tid, qt.step_no from PAR3214.GENERICTCP qt where q_name = :1 and state = :2 order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked The procedure call is following DBMS_AQ.DEQUEUE( 'par3214.' || qname, queueopts, msgprops, msg_obj, msgid ); Since this is an internal query, I can not change the HINT ( Itested that removing the hint drops logical reads from 2400 to 3). Any ideas? Thanks Shaleen
Parsing Column val
Hello, One of the column in EACH row has space saperated values. Example Col1 Col2 Col3 == Hello Worldhe she we oracle rules any doubt Out put should look like Col1 Col2 Col3 == Hello Worldhe Hello Worldshe Hello Worldwe Oracle rules any Oracle rules doubt Please Help. URGENT! Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: iostat help
wt=wait for I/O call completion id=idle I know what some of the headings are for the following output, but I'm not 100% sure about the CPU section. Does us=users, sy=system, wt=job queue wait, id=process id? cpu us sy wt id 1 3 1 95 extended device statistics r/sw/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.10.70.64.6 0.0 0.05.4 48.2 0 0 c0t0d0 0.00.91.3 29.8 0.0 0.00.08.0 0 1 c0t1d0 0.00.00.00.0 0.0 0.00.00.0 0 0 c0t6d0 0.31.6 18.3 14.0 0.0 0.00.02.9 0 0 c1t1d4 0.11.60.8 12.9 0.0 0.00.12.2 0 0 c1t1d5 0.00.01.60.0 0.0 0.00.0 10.6 0 0 c1t1d3 0.00.00.00.0 0.0 0.00.04.1 0 0 c1t1d2 5.00.0 161.40.0 0.0 0.00.02.1 0 1 rmt/0 cpu us sy wt id 0 2 0 98 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: STATSPACK
This procedure was adapted from the standard STATSPACK sppurge.sql script that comes with v8.1.7 STATSPACK. I haven't tested it fully in v9 STATSPACK yet. It works, but I don't know if it purges everything -- I think that it does though. STATSPACK has ON DELETE CASCADE constraints enabled, so it's pretty self-sufficient... Seema: Head to Tim Gorman's site (www.evdbt.com) and find his sppurpkg.sql download. It uses dbms_jobs to run with a purge each set number of days. It's really slick. Barb Seema Singh [EMAIL PROTECTED] wrote:Hi How to clean all old STATSPACK data? Thx -Seema __ ___ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i Version Statistics
Title: Oracle 9i Version Statistics I had a colleague ask me about Oracle 9i Version Statistics. I couldn't see anything about that on Metalink, 9.2 / 9.0 new features guide, or through a Google search. Is there such a thing or did the colleague misread the name of a new feature?
Re: Parsing Column val
set colsep off - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 12:23 PM Hello, One of the column in EACH row has space saperated values. Example Col1 Col2 Col3 == Hello Worldhe she we oracle rules any doubt Out put should look like Col1 Col2 Col3 == Hello Worldhe Hello Worldshe Hello Worldwe Oracle rules any Oracle rules doubt Please Help. URGENT! Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AQ query from dequeuw procedure not using index -URGENT
Shaleen, Have you considered using Outlines? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 So WHO is the Reason for the Season?! Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, December 09, 2002 10:04 AM To: Multiple recipients of list ORACLE-L All, We are using a third party application (Retek Warehouse management) which uses AQ as communication mechanism between processes. The problem we are facing is that the AQ query behind Dequeue is doing a full tablescan on queue table which is causing about 5Billion logical reads/day and is bringing the DB to its knees. Following is the query which I gleaned from tracing the process select /*+ FIRST_ROWS */ qt.rowid, qt.msgid, qt.corrid, qt.priority, qt.delay, qt.expiration, qt.retry_count, qt.exception_qschema, qt.exception_queue, qt.chain_no, qt.local_order_no, qt.enq_time, qt.time_manager_info, qt.state, qt.enq_tid, qt.step_no from PAR3214.GENERICTCP qt where q_name = :1 and state = :2 order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked The procedure call is following DBMS_AQ.DEQUEUE( 'par3214.' || qname, queueopts, msgprops, msg_obj, msgid ); Since this is an internal query, I can not change the HINT ( Itested that removing the hint drops logical reads from 2400 to 3). Any ideas? Thanks Shaleen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Enqueue Waits in Oracle Financials
John, Yes, the PMON method is lock. The ICM runs 1 process with a sleep time of 30 seconds and a null value for cache size.All of our managers sleep at least 30 seconds, with the exception of a Service Manager, which is null. I'll probably end up logging a TAR. Thanks, Jay [EMAIL PROTECTED] 12/06/02 07:13PM Jay, Is the PMON method set to LOCK? See the output of the following SQL select profile_option_value from applsys.Fnd_Profile_Option_Values where Level_ID = 10001 And Level_Value = 0 And Application_ID = 0 And Profile_Option_ID = ( Select Profile_Option_Id From apps.Fnd_Profile_Options Where Profile_Option_Name = 'CONC_PMON_METHOD') I believe the ICM (Internal Concurrent Manager) places its own locks for scheduling reasons - maybe that is why you are seeing UL locks. You might also want to check with the Apps SYSADMIN account holder if anything has been changed wrt scheduling (could be the Cache size or Sleep seconds for any of the managers). You can verify if something has been changed by looking at the LAST_UPDATE_DATE on most FND tables. Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SLOW SITE
Hi One of my client website is slow and they are running AOL server for application.Can any one suggest what are the things need to look for better performance? Thx -Seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: iostat help
Title: RE: iostat help Thanks Tim. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: iostat help wt=wait for I/O call completion id=idle I know what some of the headings are for the following output, but I'm not 100% sure about the CPU section. Does us=users, sy=system, wt=job queue wait, id=process id? cpu us sy wt id 1 3 1 95 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.1 0.7 0.6 4.6 0.0 0.0 5.4 48.2 0 0 c0t0d0 0.0 0.9 1.3 29.8 0.0 0.0 0.0 8.0 0 1 c0t1d0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t6d0 0.3 1.6 18.3 14.0 0.0 0.0 0.0 2.9 0 0 c1t1d4 0.1 1.6 0.8 12.9 0.0 0.0 0.1 2.2 0 0 c1t1d5 0.0 0.0 1.6 0.0 0.0 0.0 0.0 10.6 0 0 c1t1d3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 4.1 0 0 c1t1d2 5.0 0.0 161.4 0.0 0.0 0.0 0.0 2.1 0 1 rmt/0 cpu us sy wt id 0 2 0 98 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
EXP-00084: Unexpected DbmsJava error -1031 at step 6661
Anyone seen this export error? The database is Oracle EE V8.1.6.2 on Solaris 2.8. The database has just been freshly recreated by creating a new database and selectively export/import schema by schema. The problem did exist in the old database as well but I was kind of surprised that it did not go away as I assumed that reinstalling the java objects from scratch would fix it... not so. I did check metalink and there were two or three references that suggested rerunning calalog and catproc which I tried but it did not fix the issue for me. Anyone seen and/or have a fix for this? Thanks, Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED] Pager: mailto:[EMAIL PROTECTED] Mobile: (860) 857-4213 -Original Message- Sent: Sunday, December 08, 2002 3:46 AM To: [EMAIL PROTECTED] /Volumes/app/oracle/admin/bin/dba_ora_exptest.ksh on clgprd1@gsun731 Export: Release 8.1.6.2.0 - Production on Sun Dec 8 03:21:26 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Username: Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option JServer Release 8.1.6.2.0 - Production Volume size (ret for no restriction) Export done in US7ASCII character set and US7ASCII NCHAR character set About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting object type definitions . exporting system procedural objects and actions . exporting pre-schema procedural objects and actions . exporting cluster definitions . about to export SYSTEM's tables via Conventional Path ... . . exporting tableDEF$_AQCALL 0 rows exported . . exporting table DEF$_AQERROR 0 rows exported . . exporting table DEF$_CALLDEST 0 rows exported . . exporting table DEF$_DEFAULTDEST 0 rows exported . . exporting table DEF$_DESTINATION 0 rows exported . . exporting table DEF$_ERROR 0 rows exported . . exporting table DEF$_LOB 0 rows exported . . exporting tableDEF$_ORIGIN 0 rows exported . . exporting tableDEF$_PROPAGATOR 0 rows exported . . exporting table DEF$_PUSHED_TRANSACTIONS 0 rows exported . . exporting table DEF$_TEMP$LOB 0 rows exported . . exporting table HELP816 rows exported . . exporting tableSQLPLUS_PRODUCT_PROFILE 0 rows exported . about to export OUTLN's tables via Conventional Path ... . . exporting tableOL$ 0 rows exported . . exporting table OL$HINTS 0 rows exported . about to export DBSNMP's tables via Conventional Path ... . about to export ORAMON's tables via Conventional Path ... . about to export CDGM_CLINDATA's tables via Conventional Path ... . . exporting table DONOR_DATA 117229704 rows exported . . exporting table DONOR_ROWS4826411 rows exported . about to export CDGM_DONOR's tables via Conventional Path ... . . exporting table DONOR_IDS 13937 rows exported . . exporting table ENTRY_NUMBERS 10792 rows exported . . exporting table RANDOMIZATION_NUMBERS 13936 rows exported . about to export CDGM_DSL's tables via Conventional Path ... . . exporting table ANON1 0 rows exported . . exporting table CREATE$JAVA$LOB$TABLE 0 rows exported . . exporting tableDESTRUCTION 78 rows exported . . exporting table ERROR_LOG296 rows exported . . exporting table IDENT1 5601 rows exported . . exporting table JAVA$CLASS$MD5$TABLE370 rows exported . . exporting table PRE_ANON_ARCHIVE 4521 rows exported . . exporting tableSAMPLES 9745 rows exported . . exporting tableSAMP_ERRORS 12 rows exported . . exporting table SHIPMENT_DREQ 10336 rows exported . . exporting table SHIPMENT_HREQ 18 rows exported . about to export CDGM_LIBRARY's tables via Conventional Path ... . . exporting tableCLASSES284 rows exported . . exporting tableDOMAINS100 rows exported . . exporting table
RE: Oracle 9i Version Statistics
Jacques - I wonder if he was referring to STATSPACK in Oracle Version 9i? OpenWorld has a presentation on that. The other idea is that 9i has schema versioning, where users can check out a table, make changes to it, and then you can merge the changes back together.. Look under Database Workspace Management. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 09, 2002 1:14 PM To: Multiple recipients of list ORACLE-L I had a colleague ask me about Oracle 9i Version Statistics. I couldn't see anything about that on Metalink, 9.2 / 9.0 new features guide, or through a Google search. Is there such a thing or did the colleague misread the name of a new feature? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Parsing Column val
Title: RE: Parsing Column val Looks to me like you have to do this in pl/sql unless you can say something about the uniqueness of col1 and col2. Is there a primary key on the table? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: Parsing Column val Hello, One of the column in EACH row has space saperated values. Example Col1 Col2 Col3 == Hello World he she we oracle rules any doubt Out put should look like Col1 Col2 Col3 == Hello World he Hello World she Hello World we Oracle rules any Oracle rules doubt Please Help. URGENT! Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SLOW SITE
Think STATSPACK. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 09, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Hi One of my client website is slow and they are running AOL server for application.Can any one suggest what are the things need to look for better performance? Thx -Seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SLOW SITE
On Mon, 9 Dec 2002, Seema Singh wrote: Hi One of my client website is slow and they are running AOL server for application.Can any one suggest what are the things need to look for better performance? Everything. Network, database, code, OS, machine. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
expert advice for separation of production from report database
Hello List, Right now my transaction and reporting data is on the same database. The whole database is around 200G and is growing out of control. During the business hour,the reporting operation will slow down the whole system. I plan to separate it into two databases: one for transaction and one for reporting. I would like to hear any expert advice regarding the implemention and its pros/cons. Your help will be highly appreciated. I will summarize. Thanks, Michale ** This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege. Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer. Sempra Energy Trading Corp. (SET) is not the same company as SDGE or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Wu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AQ query from dequeuw procedure not using index -URGENT
Title: RE: AQ query from dequeuw procedure not using index -URGENT Outlines is the way to go as John suggested ... also ensure that all tables related to the queues are analyzed ... regularly. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: AQ query from dequeuw procedure not using index -URGENT Shaleen, Have you considered using Outlines? John Kanagaraj This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: AQ query from dequeuw procedure not using index -URGENT
Shaleen, The use of FIRST_ROWS hint with an order by clause is ridiculous. The hint is ignored. Raj John Kanagaraj john.kanagaraTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: Sent by: Subject: RE: AQ query from dequeuw procedure not using index -URGENT [EMAIL PROTECTED] om December 09, 2002 02:49 PM Please respond to ORACLE-L Shaleen, Have you considered using Outlines? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 So WHO is the Reason for the Season?! Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, December 09, 2002 10:04 AM To: Multiple recipients of list ORACLE-L All, We are using a third party application (Retek Warehouse management) which uses AQ as communication mechanism between processes. The problem we are facing is that the AQ query behind Dequeue is doing a full tablescan on queue table which is causing about 5Billion logical reads/day and is bringing the DB to its knees. Following is the query which I gleaned from tracing the process select /*+ FIRST_ROWS */ qt.rowid, qt.msgid, qt.corrid, qt.priority, qt.delay, qt.expiration, qt.retry_count, qt.exception_qschema, qt.exception_queue, qt.chain_no, qt.local_order_no, qt.enq_time, qt.time_manager_info, qt.state, qt.enq_tid, qt.step_no from PAR3214.GENERICTCP qt where q_name = :1 and state = :2 order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked The procedure call is following DBMS_AQ.DEQUEUE( 'par3214.' || qname, queueopts, msgprops, msg_obj, msgid ); Since this is an internal query, I can not change the HINT ( Itested that removing the hint drops logical reads from 2400 to 3). Any ideas? Thanks Shaleen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parsing Column val
Yes there is primary key on the table. --- Koivu, Lisa [EMAIL PROTECTED] wrote: Looks to me like you have to do this in pl/sql unless you can say something about the uniqueness of col1 and col2. Is there a primary key on the table? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject:Parsing Column val Hello, One of the column in EACH row has space saperated values. Example Col1 Col2 Col3 == Hello Worldhe she we oracle rules any doubt Out put should look like Col1 Col2 Col3 == Hello Worldhe Hello Worldshe Hello Worldwe Oracle rules any Oracle rules doubt Please Help. URGENT! Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: limiting temp space per user
Thats what I have now. But these adhoc reports keep running out of temp space and and ends up paging me :-) Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 12:48 PM The way we do it is that create two temporary tablespaces. Use one for the production applicationa and other for adhoc users so that adhoc users do not mess up the production. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 8:04 AM SQL alter user scott quota 10M on temp; User altered. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 06:24 AM All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Krishna Rao Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: limiting temp space per user
Babu - Sounds like this may be more of a user management problem. Also, the automatic paging is based on events you selected, isn't it? In Oracle9i, the Resource Manager is supposed to run something like EXPLAIN PLAN and if the resources exceed preset limits in terms of estimated CPU time or temp space, then the query won't even be launched. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Thats what I have now. But these adhoc reports keep running out of temp space and and ends up paging me :-) Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 12:48 PM The way we do it is that create two temporary tablespaces. Use one for the production applicationa and other for adhoc users so that adhoc users do not mess up the production. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 8:04 AM SQL alter user scott quota 10M on temp; User altered. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 06:24 AM All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Krishna Rao Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Babu Nagarajan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: expert advice for separation of production from report databa
Michael - This is a good solution. The issues are: - how you will move data from production to report. - how much data you will need to move. - how often will you move the data (weekly/daily/hourly?) There are several mechanisms you can use to move the data, and your choice will depend on the issues listed above: - Export/import - Database link - Transportable tablespaces - Replication (snapshots) - Standby Database Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 09, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Hello List, Right now my transaction and reporting data is on the same database. The whole database is around 200G and is growing out of control. During the business hour,the reporting operation will slow down the whole system. I plan to separate it into two databases: one for transaction and one for reporting. I would like to hear any expert advice regarding the implemention and its pros/cons. Your help will be highly appreciated. I will summarize. Thanks, Michale ** This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege. Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer. Sempra Energy Trading Corp. (SET) is not the same company as SDGE or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Wu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OAS Mac IE with secure server
I have been trying to track down the source of a problem with an application here where I can't do much more than search the web - I have seen so many things talking about bugs that are security holes in IE that I'm ready to say let's not let anyone us IE but that is not an option. At this point I'm wondering if anyone has encountered anything like this. The situation is as follows: The application is written in PL/SQL with some JavaScript. The Oracle is 8.1.6 on solaris 7. It is OAS 4 (I know it is old and that probably doesn't help) using secure Appache. Of late we have been receiving complaints that going back either from the browser toolbar or a button in the application using onClick=window.history.back() does not work with IE on a Mac (various versions of IE and the OS). The only Mac I have access to works just fine, but it is old and although we put on the latest IE we could that is still old give the old OS. I found a setting on a Win2K version of IE that can cause the same failure. I couldn't find anything corresponding on the Mac. Now to complicate things, I asked someone else on campus who uses a Mac and has access to our application to look for the corresponding setting on his Mac. His response was something of a surprise. He can't find anything like the setting I found under Win2k and while he does have the problems when accessing our application, he doesn't for any other applications using a secure server. He also has a lot of whitespace at the top of the first page with the Mac that he doesn't have with a Windows machine. One other thing that may or may not be relevant. The error raised is one of the negative ones that have plagued us from time to time and the rest of the message is for the entry page (minus the token) rather than whatever page one is trying to get to - certainly sounds like not everything is being cached. We have not heard of anyone having this problem with Netscape (any OS) and with the setting I found, it appears that it is just an IE configuration problem if it occurs under Windows with IE. As a result, I thought it was a Mac IE configuration problem. Now, it would appear that Mac IE doesn't have the ability to be configured on this. Expanding the search for a cause I have to include OAS which is why I'm asking here. If it is not an OAS configuration problem am sorry for what could turn out to be an off topic post. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sys login -probably a dumb question
Yo win - at least I think so - when I regranted the (supposedly) same password to sys it started working normally - now I have to find who changed the password - cause I create them all with standard scripts. [EMAIL PROTECTED] 12/05/02 04:09PM You probably have the sys password incorrect on instance2. If you specify "as sysdba" it basically ignores the password if you are authorized as an OS user (belong to group oracle, for example). Adam -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: sys login -probably a dumb questionNope - they are both 9.2.0.2 solaris 9 [EMAIL PROTECTED] 12/05/02 02:08PM Any chance that instance 2 is 9i, and instance 1 isn't? -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: sys login -probably a dumb question I have 2 instances on a sun box. instance abc I can connect by just -- sys/not_default@abc but on instance def I can't connect by sys/not_default2@def it gives a ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. I have to use sys/not_default2@def as sysdba. why?
RE: Another Java Question
Runtime might not recognize Unix pipe, you need to do it like: Process p = Runtime.getRuntime().exec(new String[] {/bin/sh,-c, tnsping emsd | grep Host}); Richard Ji -Original Message- Sent: Monday, December 09, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Good Morning. I am trying to get the output of a server process executed by java via Runtime.exec(). Here's the code: import java.sql.*; import java.io.*; public class ip { public static void main (String args []) { Runtime r = Runtime.getRuntime(); try { String sid = emsd; String cmd1 = tnsping + sid + | grep 'Host' | cut -d' ' -f18 | cut -d')' -f1; System.out.println(cmd1); Process p = Runtime.getRuntime().exec(cmd1); int exitValue = p.waitFor(); System.out.println(p); BufferedReader br = new BufferedReader(new InputStreamReader(p.getInputStream())); String ip = br.readLine(); System.out.println(ip); } catch (Exception e) { System.out.println(Generic Exception catch.); } } // end of main() } When I execute it I get: tnsping emsd | grep 'Host' | cut -d' ' -f18 | cut -d')' -f1 java.lang.UNIXProcess@5988f The output of the command line is: 128.100.1.140 Anyone see what I'm missing? Just to make this somewhat oracle related...this is part of a hot backup script. I am trying to grep the ip (and ultimately port) of the listener so I can dynamically generate the connect to the database. :) Thanks, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AQ query from dequeuw procedure not using index -URGENT
Title: RE: AQ query from dequeuw procedure not using index -URGENT This database is running RULE so analyzing wont help. Outlines is a good idea. Any known issues with outlines in 8173? Thanks Shaleen - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 12:39 PM Subject: RE: AQ query from dequeuw procedure not using index -URGENT Outlines is the way to go as John suggested ... also ensure that all tables related to the queues are analyzed ... regularly. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: AQ query from dequeuw procedure not using index -URGENT Shaleen, Have you considered using Outlines? John Kanagaraj
BLEVEL on bit-mapped indexes
According tooracle documentation or metalink sources,if the BLEVEL were to be more than 4, it is recommended to rebuild the index. select index_name, blevel,decode(blevel,0,'OK BLEVEL',1,'OK BLEVEL', 2,'OK BLEVEL',3,'OK BLEVEL',4,'OK BLEVEL','BLEVEL HIGH') OKfrom dba_indexeswhere owner ='owner-name'; When troubleshooting aperformance problem ina data warehousing environmentI found thatsome of the indexes had BLEVEL at 5 or 6. I am curious to know whether these indexesare candidates for rebuild.Should be looking at BLEVEL for bit-mapped indexes at all? I am not that experienced in bit-mapped indexes hence posting it to the group. Thanks in advance. Govind
RE: sys login -probably a dumb question
sometimes password file gets out of sync ... that may be the reason ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Monday, December 09, 2002 4:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: sys login -probably a dumb questionYo win - at least I think so - when I regranted the (supposedly) same password to sys it started working normally - now I have to find who changed the password - cause I create them all with standard scripts. [EMAIL PROTECTED] 12/05/02 04:09PM You probably have the sys password incorrect on instance2. If you specify "as sysdba" it basically ignores the password if you are authorized as an OS user (belong to group oracle, for example). Adam -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: sys login -probably a dumb questionNope - they are both 9.2.0.2 solaris 9 [EMAIL PROTECTED] 12/05/02 02:08PM Any chance that instance 2 is 9i, and instance 1 isn't? -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: sys login -probably a dumb question I have 2 instances on a sun box. instance abc I can connect by just -- sys/not_default@abc but on instance def I can't connect by sys/not_default2@def it gives a ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. I have to use sys/not_default2@def as sysdba. why? This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: AQ query from dequeuw procedure not using index -URGENT
It's oracle AQ internal query so cant change it. I have already tried it without the hint and it does use the index but again can't change the query. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 12:49 PM Shaleen, The use of FIRST_ROWS hint with an order by clause is ridiculous. The hint is ignored. Raj John Kanagaraj john.kanagaraTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: Sent by: Subject: RE: AQ query from dequeuw procedure not using index -URGENT [EMAIL PROTECTED] om December 09, 2002 02:49 PM Please respond to ORACLE-L Shaleen, Have you considered using Outlines? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 So WHO is the Reason for the Season?! Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Monday, December 09, 2002 10:04 AM To: Multiple recipients of list ORACLE-L All, We are using a third party application (Retek Warehouse management) which uses AQ as communication mechanism between processes. The problem we are facing is that the AQ query behind Dequeue is doing a full tablescan on queue table which is causing about 5Billion logical reads/day and is bringing the DB to its knees. Following is the query which I gleaned from tracing the process select /*+ FIRST_ROWS */ qt.rowid, qt.msgid, qt.corrid, qt.priority, qt.delay, qt.expiration, qt.retry_count, qt.exception_qschema, qt.exception_queue, qt.chain_no, qt.local_order_no, qt.enq_time, qt.time_manager_info, qt.state, qt.enq_tid, qt.step_no from PAR3214.GENERICTCP qt where q_name = :1 and state = :2 order by q_name, state, enq_time, step_no, chain_no, local_order_no for update skip locked The procedure call is following DBMS_AQ.DEQUEUE( 'par3214.' || qname, queueopts, msgprops, msg_obj, msgid ); Since this is an internal query, I can not change the HINT ( Itested that removing the hint drops logical reads from 2400 to 3). Any ideas? Thanks Shaleen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: expert advice for separation of production from report databa
Title: RE: expert advice for separation of production from report databa You didn't say if you are looking at a separate box for your reporting db. Push for separate hardware, or else you won't be solving your problem. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: expert advice for separation of production from report databa Michael - This is a good solution. The issues are: - how you will move data from production to report. - how much data you will need to move. - how often will you move the data (weekly/daily/hourly?) There are several mechanisms you can use to move the data, and your choice will depend on the issues listed above: - Export/import - Database link - Transportable tablespaces - Replication (snapshots) - Standby Database Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 09, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Hello List, Right now my transaction and reporting data is on the same database. The whole database is around 200G and is growing out of control. During the business hour,the reporting operation will slow down the whole system. I plan to separate it into two databases: one for transaction and one for reporting. I would like to hear any expert advice regarding the implemention and its pros/cons. Your help will be highly appreciated. I will summarize. Thanks, Michale ** This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege. Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer. Sempra Energy Trading Corp. (SET) is not the same company as SDGE or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Wu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Parsing Column val
output will be written to a 2nd table and I may/may not have primary key on that table. Thanks. --- OraCop [EMAIL PROTECTED] wrote: Yes there is primary key on the table. --- Koivu, Lisa [EMAIL PROTECTED] wrote: Looks to me like you have to do this in pl/sql unless you can say something about the uniqueness of col1 and col2. Is there a primary key on the table? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: Parsing Column val Hello, One of the column in EACH row has space saperated values. Example Col1 Col2 Col3 == Hello Worldhe she we oracle rules any doubt Out put should look like Col1 Col2 Col3 == Hello Worldhe Hello Worldshe Hello Worldwe Oracle rules any Oracle rules doubt Please Help. URGENT! Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: a PL/SQL design question.
Hi, The other option that you have is to use Advance Queuing. You can insert the row and a message on a queue within the same transaction. Your procedure will be a consumer of the messages in the queue. If the transaction that does the insert is rolled back then the message is never placed on the queue and your procedure is never executed. The dequeue of the message is also transactional so if your procedure fails the message will be left on the queue and redelivered. You need to handle the redelivery case is a sensible manner - that is, you do not want the message to be redelivered continually if it is going to fail all the time. Cheers, Craig. -Original Message- Sent: Friday, 29 November 2002 5:04 AM To: Multiple recipients of list ORACLE-L Andrey Bronfin wrote: Dear gurus! I'm looking for a solution to the following problem: I need a way to run a certain stored procedure as soon as a record is inserted into a certain table. A trigger is not feasible for this, since I do not want the execution of the procedure to be a part of the transaction that inserts a row into the table. I want the insertion to be visible to all the users (i.e. committed) as soon as the insertion is done, and then, as a separate transaction of its own, to run the stored procedure. Suggestions , please ? Thanks a lot ! Keyword = AUTONOMOUS TRANSACTION -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parsing Column val
Title: RE: Parsing Column val The only way I can think of doing this in sql would involve a bunch of INSTR() and SUBSTR() functions and hardcoded repetitions, and would get ugly fast. Go with pl/sql, it would be a snap to assemble the result set there. Lisa -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Parsing Column val Yes there is primary key on the table. --- Koivu, Lisa [EMAIL PROTECTED] wrote: Looks to me like you have to do this in pl/sql unless you can say something about the uniqueness of col1 and col2. Is there a primary key on the table? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: Parsing Column val Hello, One of the column in EACH row has space saperated values. Example Col1 Col2 Col3 == Hello World he she we oracle rules any doubt Out put should look like Col1 Col2 Col3 == Hello World he Hello World she Hello World we Oracle rules any Oracle rules doubt Please Help. URGENT! Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Parsing Column val
output will be written to a 2nd table and I may/may not have primary key on that table. Thanks. --- OraCop [EMAIL PROTECTED] wrote: Yes there is primary key on the table. --- Koivu, Lisa [EMAIL PROTECTED] wrote: Looks to me like you have to do this in pl/sql unless you can say something about the uniqueness of col1 and col2. Is there a primary key on the table? Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: OraCop [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: Parsing Column val Hello, One of the column in EACH row has space saperated values. Example Col1 Col2 Col3 == Hello Worldhe she we oracle rules any doubt Out put should look like Col1 Col2 Col3 == Hello Worldhe Hello Worldshe Hello Worldwe Oracle rules any Oracle rules doubt Please Help. URGENT! Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema
OK, I started out thinking that this would be easy. What is a pure SQL solution which generates a results set containing a list of TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a sc
Charlie - Does this sound like what you want? 1 select table_name, column_name 2 from user_tab_columns 3* where nullable = 'Y' Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 3:55 PM To: Multiple recipients of list ORACLE-L schema OK, I started out thinking that this would be easy. What is a pure SQL solution which generates a results set containing a list of TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PAgging
Hi, Which Unix command is used to checking pagging? sar -p and sar -g is ok? What should be value for pagging? Thx -Seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Resolved?
Well, I reduced the PCTUSED and PCTFREE on Friday and a small insert (app. 30,000 rows) seems to have worked as expected. No additional space was claimed and NUM_FREELIST_BLOCKS declined. I'll wait and see what happens during our next large insert. But for now it seems like changing these parameters may have resolved the problem. Jay Miller (with fingers crossed) -Original Message- Sent: Friday, December 06, 2002 4:19 PM To: Multiple recipients of list ORACLE-L How badly do you want the space back? I believe you will indeed need to touch each row. You could update each row with something like (update set column-1=column-1) Good luck! Barb Miller, Jay [EMAIL PROTECTED] wrote: But will this solve my problem in the near term? My understanding is that simply changing the PCT USED won't move the problematic blocks off the freelist until some sort of DML touches the block. Am I correct in this and if so is there any way to resolve it? Jay _ Do you Yahoo!? Yahoo! Mail http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com Plus - Powerful. Affordable. Sign up http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com now -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: a PL/SQL design question.
Title: RE: a PL/SQL design question. An easy way to do this is using DBMS_JOB. That way you can get asynchronous execution, and it isn't tied to the transaction. This is clipped from a fix I just did for a customer. It ain't complete, but hopefully you can follow the logic: v_variables_in_table INTEGER; v_job_num INTEGER; v_job_started INTEGER; BEGIN BEGIN SELECT job_num INTO v_job_num FROM job_number_storage WHERE job_name = 'stored_proc_name'; SELECT 1 INTO v_job_started FROM user_jobs WHERE job=v_job_num; EXCEPTION WHEN NO_DATA_FOUND THEN v_job_started := 0; END; IF v_job_started = 1 THEN DBMS_JOB.REMOVE(v_job_num); END IF; DELETE FROM job_number_storage WHERE job_name = 'stored_proc_name'; -- start the job -- insert into jdp_temp values ('starting job here',sysdate); DBMS_JOB.SUBMIT(v_job_num,'stored_proc_name;',sysdate,'sysdate+1'); INSERT INTO job_number_storage (job_num,job_name) VALUES (v_job_num,'stored_proc_name'); COMMIT; END; / -Original Message- From: Craig Munday [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: a PL/SQL design question. Hi, The other option that you have is to use Advance Queuing. You can insert the row and a message on a queue within the same transaction. Your procedure will be a consumer of the messages in the queue. If the transaction that does the insert is rolled back then the message is never placed on the queue and your procedure is never executed. The dequeue of the message is also transactional so if your procedure fails the message will be left on the queue and redelivered. You need to handle the redelivery case is a sensible manner - that is, you do not want the message to be redelivered continually if it is going to fail all the time. Cheers, Craig. -Original Message- Sent: Friday, 29 November 2002 5:04 AM To: Multiple recipients of list ORACLE-L Andrey Bronfin wrote: Dear gurus! I'm looking for a solution to the following problem: I need a way to run a certain stored procedure as soon as a record is inserted into a certain table. A trigger is not feasible for this, since I do not want the execution of the procedure to be a part of the transaction that inserts a row into the table. I want the insertion to be visible to all the users (i.e. committed) as soon as the insertion is done, and then, as a separate transaction of its own, to run the stored procedure. Suggestions , please ? Thanks a lot ! Keyword = AUTONOMOUS TRANSACTION -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a sc
Title: RE: List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema SELECT table_name,column_name FROM user_tab_columns WHERE nullable = 'N'; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Subject: List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema OK, I started out thinking that this would be easy. What is a pure SQL solution which generates a results set containing a list of TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: List TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a
The following generates it for the entire database. select owner, table_name, column_name from dba_tab_columns where nullable = 'N' order by owner, table_name, column_id For a single schema just add: andowner = 'schemaname' to the where clause. If you want change the = to in and use a list of schemas. On Mon, 2002-12-09 at 15:54, [EMAIL PROTECTED] wrote: OK, I started out thinking that this would be easy. What is a pure SQL solution which generates a results set containing a list of TABLE_NAME, COLUMN_NAME for all NOT NULL columns in a schema? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Rodd Holman [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BLEVEL on bit-mapped indexes
According tooracle documentation or metalink sources,if the BLEVEL were to be more than 4, it is recommended to rebuild the index. select index_name, blevel,decode(blevel,0,'OK BLEVEL',1,'OK BLEVEL', 2,'OK BLEVEL',3,'OK BLEVEL',4,'OK BLEVEL','BLEVEL HIGH') OKfrom dba_indexeswhere owner ='owner-name'; When troubleshooting aperformance problem ina data warehousing environmentI found thatsome of the indexes had BLEVEL at 5 or 6. I am curious to know whether these indexesare candidates for rebuild.Should be looking at BLEVEL for bit-mapped indexes at all? I am not that experienced in bit-mapped indexes hence posting it to the group. Thanks in advance. Govind
RE: a PL/SQL design question.
Title: RE: a PL/SQL design question. Just so you know, you should be able to manually "acknowledge" the enqueue of the message on the queue which will make it availableto the consumerbefore the transaction containing the insert is commited. -Original Message-From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 10 December 2002 10:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: a PL/SQL design question. An easy way to do this is using DBMS_JOB. That way you can get asynchronous execution, and it isn't tied to the transaction. This is clipped from a fix I just did for a customer. It ain't complete, but hopefully you can follow the logic: v_variables_in_table INTEGER; v_job_num INTEGER; v_job_started INTEGER; BEGIN BEGIN SELECT job_num INTO v_job_num FROM job_number_storage WHERE job_name = 'stored_proc_name'; SELECT 1 INTO v_job_started FROM user_jobs WHERE job=v_job_num; EXCEPTION WHEN NO_DATA_FOUND THEN v_job_started := 0; END; IF v_job_started = 1 THEN DBMS_JOB.REMOVE(v_job_num); END IF; DELETE FROM job_number_storage WHERE job_name = 'stored_proc_name'; -- start the job -- insert into jdp_temp values ('starting job here',sysdate); DBMS_JOB.SUBMIT(v_job_num,'stored_proc_name;',sysdate,'sysdate+1'); INSERT INTO job_number_storage (job_num,job_name) VALUES (v_job_num,'stored_proc_name'); COMMIT; END; / -Original Message- From: Craig Munday [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: a PL/SQL design question. Hi, The other option that you have is to use Advance Queuing. You can insert the row and a message on a queue within the same transaction. Your procedure will be a consumer of the messages in the queue. If the transaction that does the insert is rolled back then the message is never placed on the queue and your procedure is never executed. The dequeue of the message is also transactional so if your procedure fails the message will be left on the queue and redelivered. You need to handle the redelivery case is a sensible manner - that is, you do not want the message to be redelivered continually if it is going to fail all the time. Cheers, Craig. -Original Message- Sent: Friday, 29 November 2002 5:04 AM To: Multiple recipients of list ORACLE-LAndrey Bronfin wrote: Dear gurus! I'm looking for a solution to the following problem: I need a way to run a certain stored procedure as soon as a record is inserted into a certain table. A trigger is not feasible for this, since I do not want the execution of the procedure to be a part of the transaction that inserts a row into the table. I want the insertion to be visible to all the users (i.e. committed) as soon as the insertion is done, and then, as a separate transaction of its own, to run the stored procedure. Suggestions , please ? Thanks a lot !Keyword = AUTONOMOUS TRANSACTION -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:PAgging
On HP-UX the best indicator is to run vmstat -s and look for rotations of the clock hand. Dick Goulet Reply Separator Author: Seema Singh [EMAIL PROTECTED] Date: 12/9/2002 2:44 PM Hi, Which Unix command is used to checking pagging? sar -p and sar -g is ok? What should be value for pagging? Thx -Seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: image storage confusion ?? -- UUDECODE
Guys, Suppose I store the images (~100G)in DB ( either as BLOB or BFILE ). I want to have a standby DB for this Prod. DB. Will there be any problem ? any known issues ? what are the things to be taken care of ??? Kindly let me know Guys. TIA. Jp. On Wed, 04 Dec 2002 Connor McDonald wrote : As Cary as mentioned, there's some new goodies in v9. In our case, the controlling of attachments etc is done before processing into the db. I can't remember the specifics (read: I'm no longer at that site) but we found some shareware (mimencode? + a few other little things) we separated encoded emails into separate files which then got processed into separate lobs. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: Were doing the same thing with mail between collaborators on one of our physics projects. But the volume is small, just unDer 250,000 so far. Did the mail ou were saving contain attachments, and if so did you write any code to break off the attachment uudecode it and place it in a blob? If so, I am keenly interested in that code. Is there a publicly available package to do uuencode and uudecode? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Exactly. We had a system that used to drag emails (from qmail so each mail was a file) into clobs in the database. After a year or so we had about 15 million emails in the database - no problems at all. Then one day the some idiot (aka me) put a new version of the program in which successfully loaded the clob but (to cut a long story short) started replicating the email files left, right and centre...It took literally days to clean up millions of (zero byte size) files...after which point that file system needed to be rebuilt anyway, the directory structure was in such a mess Cheers Connor --- [EMAIL PROTECTED] wrote: Arup, What Connor may have been referring to is the inefficiency of managing 20 million files in a filesystem. That's a lot of inodes ( assuming unix ). It's a bit much for a filesystem to deal with. Jared Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 07:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: image storage confusion ?? Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED]
RE: limiting temp space per user
1) Turn the pager off ;) 2) Increase temp space 3) Review sorting requirements of this adhoc stuff. Adjust sort_area_size, sort_area_retained_size if possible at the session level to reduce disk sorts. - Kirti -Original Message- Sent: Monday, December 09, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Thats what I have now. But these adhoc reports keep running out of temp space and and ends up paging me :-) Babu - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 12:48 PM The way we do it is that create two temporary tablespaces. Use one for the production applicationa and other for adhoc users so that adhoc users do not mess up the production. -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 8:04 AM SQL alter user scott quota 10M on temp; User altered. HTH, Krishna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 06:24 AM All Is it possible to limit the temp space used per user - either by using profiles or some other method? I tried using profiles but it would not allow me to set a limit on space usage. TIA Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:(was) Oracle 8i Cert Will Terminate When???
reposting. --- john [EMAIL PROTECTED] wrote: any one knowing when 10 or 10i would be released --- Lyndon Tiu [EMAIL PROTECTED] wrote: I'm barely done with my 9i certification track and I'm hearing of 10i coming out soon. All's too fast! -- Lyndon Tiu Quoting [EMAIL PROTECTED]: Peter, I don't think a date has been announced yet. When they do state a date they give 6 months notice though John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PAgging
Hi, try vmstat. Adam -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 December 2002 09:44 To: Multiple recipients of list ORACLE-L Subject: PAgging Hi, Which Unix command is used to checking pagging? sar -p and sar -g is ok? What should be value for pagging? Thx -Seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Visit our website at http://www.ubswarburg.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: RE: image storage confusion ?? -- UUDECODE
oraora oraora, For blob, it is ok, since it is all in the database, while for bfile, you actually store them in filesystem, so you have to backup those files indivudually. Regards zhu chao [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) === 2002-12-09 17:23:00 ,you wrote£º=== Guys, Suppose I store the images (~100G)in DB ( either as BLOB or BFILE ). I want to have a standby DB for this Prod. DB. Will there be any problem ? any known issues ? what are the things to be taken care of ??? Kindly let me know Guys. TIA. Jp. On Wed, 04 Dec 2002 Connor McDonald wrote : As Cary as mentioned, there's some new goodies in v9. In our case, the controlling of attachments etc is done before processing into the db. I can't remember the specifics (read: I'm no longer at that site) but we found some shareware (mimencode? + a few other little things) we separated encoded emails into separate files which then got processed into separate lobs. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: Were doing the same thing with mail between collaborators on one of our physics projects. But the volume is small, just unDer 250,000 so far. Did the mail ou were saving contain attachments, and if so did you write any code to break off the attachment uudecode it and place it in a blob? If so, I am keenly interested in that code. Is there a publicly available package to do uuencode and uudecode? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Exactly. We had a system that used to drag emails (from qmail so each mail was a file) into clobs in the database. After a year or so we had about 15 million emails in the database - no problems at all. Then one day the some idiot (aka me) put a new version of the program in which successfully loaded the clob but (to cut a long story short) started replicating the email files left, right and centre...It took literally days to clean up millions of (zero byte size) files...after which point that file system needed to be rebuilt anyway, the directory structure was in such a mess Cheers Connor --- [EMAIL PROTECTED] wrote: Arup, What Connor may have been referring to is the inefficiency of managing 20 million files in a filesystem. That's a lot of inodes ( assuming unix ). It's a bit much for a filesystem to deal with. Jared Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 07:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: image storage confusion ?? Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be
Re: Re: Re: RE: image storage confusion ?? -- UUDECODE
Thanx Chao. Still under confusion , whether to store 20,000,000 images of 5k each either in -oracle 8.1.6 on win2k ( BLOB or BFILE ) OR - just on plain linux file system - OR - any file server like NetApp on linux --- which will be better ? how do people usually handle data of such volume ? plz let me know how it is done normally. TIA. Jp. On Tue, 10 Dec 2002 chao_ping wrote : oraora oraora, For blob, it is ok, since it is all in the database, while for bfile, you actually store them in filesystem, so you have to backup those files indivudually. Regards zhu chao [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) === 2002-12-09 17:23:00 ,you wrote£º=== Guys, Suppose I store the images (~100G)in DB ( either as BLOB or BFILE ). I want to have a standby DB for this Prod. DB. Will there be any problem ? any known issues ? what are the things to be taken care of ??? Kindly let me know Guys. TIA. Jp. On Wed, 04 Dec 2002 Connor McDonald wrote : As Cary as mentioned, there's some new goodies in v9. In our case, the controlling of attachments etc is done before processing into the db. I can't remember the specifics (read: I'm no longer at that site) but we found some shareware (mimencode? + a few other little things) we separated encoded emails into separate files which then got processed into separate lobs. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: Were doing the same thing with mail between collaborators on one of our physics projects. But the volume is small, just unDer 250,000 so far. Did the mail ou were saving contain attachments, and if so did you write any code to break off the attachment uudecode it and place it in a blob? If so, I am keenly interested in that code. Is there a publicly available package to do uuencode and uudecode? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Exactly. We had a system that used to drag emails (from qmail so each mail was a file) into clobs in the database. After a year or so we had about 15 million emails in the database - no problems at all. Then one day the some idiot (aka me) put a new version of the program in which successfully loaded the clob but (to cut a long story short) started replicating the email files left, right and centre...It took literally days to clean up millions of (zero byte size) files...after which point that file system needed to be rebuilt anyway, the directory structure was in such a mess Cheers Connor --- [EMAIL PROTECTED] wrote: Arup, What Connor may have been referring to is the inefficiency of managing 20 million files in a filesystem. That's a lot of inodes ( assuming unix ). It's a bit much for a filesystem to deal with. Jared Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 07:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: image storage confusion ?? Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already
Memory issues on HPUX
We are considering implementing a number of new products on HPUX. [We are currently running Tru64 and Solaris boxes but are now looking at HPUX for new applications]. The choice is between HPUX and Solaris. The products will include Oracle8i 8.1.7 Oracle9i 9.2.0 Oracle9iRAC Documentum Plumtree Some of our vendors have put in a FUD factor -- there are memory issues running on HPUX, without giving us any specifics. Are there any well-known Memory issues / Memory leaks running Oracle on HPUX ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hkchital INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sun StoreEdge 9900 Series ?
Any Body has used this Storage Box ? Are Stripe Unit Sizes of 256K , 512K , 1M allowed on this ? Has any body Configured Cache LUN on this ? Any Ideal Setup Methodology for a Hybrid Application ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).