Re: Using dimensions
Title: Using dimensions Query rewriting to use materialized views requires dimensions to be defined. Tanel. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:14 PM Subject: RE: Using dimensions Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs? I have scannedTFM, but haven't STFW'd yet ... scared of too many hits. Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Scott Canaan [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Using dimensions Dimensions are data warehouse constructs. They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed. For example: a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, century. This is used for rollup reporting within the data mart. I don't see any good use of it in an OLTP environment, but I may be wrong. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 AMTo: Multiple recipients of list ORACLE-LSubject: Using dimensions I have tried, but haven't found a good example of how to _use_ a dimension in 9ir2. I defined one, but then sat clueless on what to do with it. Is it any good in an OLTP environment? (I smell the answer is a NO, but still) ... Any notes from your experience? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
Re: Using dimensions
Raj, what does TFM STFW mean ?!! let me also get used to the list's acronyms :) Jp. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs? I have scanned TFM, but haven't STFW'd yet ... scared of too many hits. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using dimensions
google gave me for example such an address http://www.gaarde.org/acronyms/ I'm sure one of hundreds or even thousands -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Using dimensions Raj, what does TFM STFW mean ?!! let me also get used to the list's acronyms :) Jp. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs? I have scanned TFM, but haven't STFW'd yet ... scared of too many hits. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna 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: Off Topic: PC Firewall Recommendation
I've used Black Ice in the past as well Peter, and I know what you mean on that count. I now user Sygate Personal Edition, which is a LOT better at this. It won't let anything in, nor *out* without asking me if it's OK. It also holds a log of incoming and outgoing traffic, showing accepted and blocked. Very good little firewall in my opinion, and I've used Black Ice, Zonealarm, and Symantec products in the past. It's ideal for a single PC (home) installation. http://smb.sygate.com/buy/download_buy.htm (The Free version is at the bottom). Mark -Original Message- Robson, Peter Sent: 29 September 2003 18:50 To: Multiple recipients of list ORACLE-L On the same area - I'm using Black Ice, but its never been clear to me whether these products trap outgoing stuff. The BIG problem as I see it as when one inadvertently loads a 1 pixel gif, populated from a rogue site, which then gives implicit confirmation that there is a PC at the end of the line... Anyone been down this particular topic? peter edinburgh -Original Message- From: Brian Dunbar [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 6:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: Off Topic: PC Firewall Recommendation KENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September 29, 2003 9:05 AM said; I have a Dell 8200 with XP Prof. SP1. I would like recommendations as to a good firewall for this machine. XP has a firewall but it is not the greatest. ZoneAlarm on the desktop - free version or pay to upgrade to the pro version. Assuming you have a home network, you also want to buy a DSL/Cable router - which has it's own firewall built in. If you're feeling frisky, consider replacing the router/firewall with a PC (with 2 nics) running BSD or Linux. You can also find distros tweaked to act as a firewall/router - that's what I've done. FWIW, a friend of mine had his XP system plugged directly into his RR connection. Friend said he didn't need a firewall or router (I'm not into that security crap, I just want to play games). Friend has now had to reformat his box (and lost work) because his box was rooted, blasted and fubared within days of hooking it to the cable connection w/out a firewall. YMMV. ~brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and
Re: (long and boring) SQL AREA and LIBARARY CACHE size?
An expert is the one who fully understands all of the important relationships between different parts of a system, I have a long way to go for getting there. But my sources are Oracle docs, Ixora, Internet, few training materials and of course Oracle server itself with awesome tracing and debugging abilities. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 29, 2003 9:09 PM No expert? Hardly! Tanel, just how the heck do you KNOW all this stuff? --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! As I understand, when shared pool heap is allocated, half of it's memory is actually hidden at first. Oracle just allocates one big permanent type chunk for that. The rest of memory is put on shared pool freelist. Initially this is just one big free chunk as well, but starts shrinking as space requests are done from it. One space request might result in multiple allocated chunks, if there's not enough free space in one memory extent for example. When a new chunk is allocated, the allocator will specify size and type of chunk it wants: - permanent type is permanent, unpinnable and unfreeable chunk. Permanent chunks exist until the whole heap is deallocated. - freeable type chunks can explicitly be freed by allocator (there's also special type of freeable chunks, called freeable with a mark, which can be freed implicitly, depending on memory usage in heap) - recreatable type chunks are pinned (in use) right after allocation and they can't be freed until they are explicitly unpinned. So, when allocating a recreatable type chunk, first freelists are searched for suitably sized free chunks. A heap freelist actually consists of 255 different lists, one for each size range of free chunks (smallest size range starts from 16 bytes, largest is about 64k+). This allows the freelist to be scanned faster. When no exactly matching free chunk is found, the next largest will be taken and is split. The leftover free chunk is placed to appropriate range in freelist. Memory allocations deallocations in shared pool are protected by shared pool latch (by shared pool child latch starting from 9i - you can separate shared pool to several heaps for better concurrency in 9i). AFAIK, Oracle is also able to coalesce adjacent free chunks when they're freed. When a recreatable chunk is allocated, it is marked as pinned - meaning currently in use. Thus noone can free it until it is explicitly unpinned by it's allocator (for example, several chunks might be pinned in shared pool during SQL parse and execution, but get unpinned right after the statement has finished). Here comes the LRU list into play. When a recreatable chunk is unpinned first time, it is put into MRU end of *transient* LRU list, since Oracle doesn't know whether it's needed ever again. When it is pinned next time, then of course it's taken off from LRU list at first, but the chunk itself is marked recurrent and is put in *recurrent* LRU list when unpinned again. (Note that I'm not sure how this LRU list internal structure looks like, whether there are really two LRU lists for each heap or is there a single one with two ends). Now, when a new space request is done, first freelists are scanned, but if there is no sufficient space there, transient LRU list is scanned and if big enough unpinned recreatable chunk is found, it is freed and returned to free list. Ok, but what happens if no suitable chunk is found from neither freelists nor LRU list? Oracle will then release hidden free space, which is allocated as permanent chunk during startup and is not in any freelists. The reason behind that might be that it is good to have less available memory during database startup, dictionary cache population and various applications initialization operations - that way more transient recreatable chunks can be reused and LRU lists don't get that long and there's less fragmentation in shared pool before real work starts. Long LRU and freelists are one reason for shared pool latch contention, that's why one should consider reducing of shared pool in case of this latch problem instead of usual more memory is better approach (as mentioned above, in 9i it's possible to split shared pool into several heaps to improve concurrency). And if even hidden memory is used up, then we get ORA-4031. Ok, this was a tiny part of heap management in Oracle, there is actually much more, such reserved list for shared pool reserved area and what happens free chunk split leftovers which are smaller than 16 bytes etc. Since I'm not expert on SGA, please correct if I'm wrong. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 26, 2003 3:17
Re: RE: Using dimensions
OwwThank God Raj hasn't replied yet :-) Thanx Gints. Jp. 30-09-2003 18:24:28, Gints Plivna [EMAIL PROTECTED] wrote: google gave me for example such an address http://www.gaarde.org/acronyms/ I'm sure one of hundreds or even thousands -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED] Raj, what does TFM STFW mean ?!! let me also get used to the list's acronyms :) Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Title: Message You still can have row migration when pctfree is set too low. ASSM doesn't resolve that. But yeah, ASSM removes the pctused and freelist/group issues (and introduces others :) Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:09 PM Subject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux And why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic segment space management. Initial/next are resolved by using LMT, because that's what takes care of your extent sizes. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard FooteSent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux Hi Mladen, I can't help you with your problem, I haven't had the pleasure on NT or Tru64 but I just wanted to point out that you can't forget about PCTFREE even with ASSM. Cheers Richard - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 30, 2003 12:44 AM Subject: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux I have RDBMS 9.2.0.4 on RH 7.3 and Iexecuted the following command: create tablespace wizard datafile '/oradata/WIZ/wizard01.dbf' size 3072M reuse autoextend on next 1024M maxsize 16385m extent management local autoallocate segment space management auto; The whole system just hung, doing I/O like crazy. I was unable to killl one of the server processes which survived even shutdown abort, so I had to bounce thw whole box. No errors, no traces, no anything. Does anybody else have experience with this? Is there a known bug (not currently known to me) with a patch that I can install? I'd really like to use "SEGMENT SPACE MANAGEMENT AUTO" and forget about pctfree/pctused stuff. --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re: x$ constructs and memory
No, X$ tables exist even before a database is created - they are mostly instance related structures, not database or data dictionary ones. Do a startup nomount and select from x$ksuse or even dual for example and you see. You just can't select from these x$ tables which want to read physical database structures when database doesn't exist or isn't mounted/open. The translation of SGA memory structures to a returnable row set is pure C code, I think. Or if you can point me to these certain catalog scripts, I'd be glad to read them :O) But yes, about the fixed area I wasn't entirely correct at first. The Oracle term fixed_sga is really fixed, that it's size shouln't change if you don't relink of patch your executables. x$version contents are probably in fixed_sga. The other stuff, like enqueues goes to variable SGA (shared pool), but still many memory structures are not dynamic - they're allocated during startup and will remain the same during the lifetime of an instance. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 29, 2003 9:24 PM With all due respect, I don't believe that it is a fixed area. You can create X$ tables by running certain catalog scripts. I believe that the description of X$ tables is located logically close to the description of the data dictionary, which would mean shared pool, not the fixed one. Now, can we get back to bears? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel Poder Sent: Monday, September 29, 2003 1:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: x$ constructs and memory What I have not checked so far is how an ALTER SYSTEM increasing a parameter affects the SGA. In practice it's a realloc() (functionally speaking). It would seem reasonable to me to have a shared memory segment to hold all parameters which can by dynamically changed. I wouldn't touch it if parameters are decreased, but I would have to realloc it in case of a massive increase. Hmm, I guess that I would allow some spare memory initially, performance penalty would otherwise be severe. Which all makes the 10g dynamic rearrangement quite sensible ... Hi! I think the behaviour depends on which parameter you are changing. If you're changing shared_pool_size to higher size, then just additional extents of memory are allocated and heap header is updated. If you set sort_area_size higher, nothing particular happens, except some maximum is increased in UGA I believe and during next sort you can go up to that limit. Some parameters like enqueue_resources can't be changed in the fly, because they are fixed, they stay in fixed area of SGA, fixed area isn't managed as heap as I understand, it does not have any free or LRU lists, because it's physical structure remains unchanged during the lifetime of an instance. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Title: Message Hm, maybe you get something useful out using truss or strace on your server process when creating the tablespace. You should at least see the calls on what you're waiting the most. Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:04 PM Subject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux Smaller file didn't help. Removing the SPACE MANAGEMENT clause did the trick. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux Hi! If your server process couldn't be even killed, then probably it was waiting on kernel IO or smth like that. This is a case when a process can't be killed just like that, even with -9. I assume you already tried to isolate the problem, by creating smaller file or removing auto segment space management clause? Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 5:44 PM Subject: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux I have RDBMS 9.2.0.4 on RH 7.3 and Iexecuted the following command: create tablespace wizard datafile '/oradata/WIZ/wizard01.dbf' size 3072M reuse autoextend on next 1024M maxsize 16385m extent management local autoallocate segment space management auto; The whole system just hung, doing I/O like crazy. I was unable to killl one of the server processes which survived even shutdown abort, so I had to bounce thw whole box. No errors, no traces, no anything. Does anybody else have experience with this? Is there a known bug (not currently known to me) with a patch that I can install? I'd really like to use "SEGMENT SPACE MANAGEMENT AUTO" and forget about pctfree/pctused stuff. --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re:Suggestion reg. encryption ??
With pleasure Ranganath. ..and ur example,sure ,was useful. Kind Regards, Jp. 30-09-2003 17:47:38, Ranganath K [EMAIL PROTECTED] wrote: Hi Prem, I am also unable to reach it. The sight might be down. However I hope you would have found the example useful. BTW Can you please send me the white paper that you received from iDefense? Thanks and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Suggestion reg. encryption ??
Pete, Which paper of Aarons are you referring to? Is the paper entitled Encryption of data at rest? Regards, Craig Munday. At 05:29 AM 29/09/2003 -0800, you wrote: Hi Jp On the specific issue of encryption your main concern will be hiding the encryption key from any prying eyes. There is a couple of links to papers on my site about encryption in Oracle http://www.petefinnigan.com /orasec.htm especially the link to Aarons paper which discusses the key hiding issue. I also wrote a paper for iDefense.com earlier this year about encrypting data in Oracle databases. It was slightly high level as it was aimed at what the possibilities and tools available are. It is not in the public domain so i cannot send out copies but if you email them you might be able to get a copy from them. hope this helps a bit kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Experiences setting OPEN_CURSORS for Java applications
Hi there, I've supported a number of systems implemented in Java running on Oracle and on nearly all of the projects the developers have asked me to increase the number of open_cursors. In most of the cases I have found that the developers were not using the JDBC API efficiently. The main problem being that Statement and ResultSet objects where never explicitly closed. If the developer does not close these objects explicitly, the garbage collector in the Java Virtual Machine will eventually close them. However the problem is that sometimes the garbage collector does not do this soon enough and you exhaust the number of open cursors you have allocated. Even the most diligent developer's sometimes make subtle mistakes like reassigning ResultSet variables and hence losing the reference to the original ResultSet, as I found out in JBoss4.0 DR2. I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. JDBC Expert installs like any other JDBC driver and does not generally require modifications to your application. The tool analyses how your application is using the JDBC API and reports various types of problems (such as resource leaks). I can send you a copy if you are interested - you will have to forward me your JDK version and details about any app server that you are using. Regards, Craig Munday. At 08:34 AM 26/09/2003 -0800, you wrote: I would just like to know what are your experiences setting OPEN_CURSORS for Java applications / middle-tier application servers ? We're rolling out a bunch of applications on WebMethods, Tivoli Identity Manager, Plumtree, Documentum etc --- all non-Oracle clients accessing the database through JDBC connections. The WebMethods consultant wanted me to set OPEN_CURSORS to 500. Plumtree also requries OPEN_CURSORS to 250 or so. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Experiences setting OPEN_CURSORS for Java applications
I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Experiences setting OPEN_CURSORS for Java applications
Craig, CMI can send you a copy if you are interested - CMyou will have to forward me your JDK version and details about any app CMserver that you are using. I would , sure , be very much interested in having a copy of that tool. developers here use diff. versions of JDK apache/tomcat/jboss ... is it JDK version/app. server specific ? can JDBC Expert for JDK 1.4.1_03/jboss 3.2.1 used for JDK 1.4.1_03/apache 2.0.4 ?? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using dimensions
Title: Re: Using dimensions Query rewrite from materialized views does not require dimensions; they are only used in certain fairly obscure situations. on 9/30/03 1:49 AM, Tanel Poder at [EMAIL PROTECTED] wrote: Query rewriting to use materialized views requires dimensions to be defined. Tanel. - Original Message - From: Jamadagni, Rajendra mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 7:14 PM Subject: RE: Using dimensions Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs? I have scanned TFM, but haven't STFW'd yet ... scared of too many hits. Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Scott Canaan [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject: RE: Using dimensions Dimensions are data warehouse constructs. They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed. For example: a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, century. This is used for rollup reporting within the data mart. I don't see any good use of it in an OLTP environment, but I may be wrong. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Subject: Using dimensions I have tried, but haven't found a good example of how to _use_ a dimension in 9ir2. I defined one, but then sat clueless on what to do with it. Is it any good in an OLTP environment? (I smell the answer is a NO, but still) .. Any notes from your experience? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
RE: Re: Cary's book -- Out of stock !
I picked my copy up last night from my local Borders bookstore. They even had a copy for the shelf. I'm assuming everyone else has theirs by now and are busily reading. Please post any comments or observations. Leave it to Cary to put exercises at the end of each chapter. A quick flip through makes me want to abandon study for my last OCP exam. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 23, 2003 11:40 AM To: Multiple recipients of list ORACLE-L RE: Re: Cary's book -- Out of stock !Hi! Figure 9-14 shows an interesting situation in which a single fast CPU out-performs a system with 4 slower CPUs, for a certain condition; this is exactly the situation I am facing while testing the move of a DB (9.0.1.3.0) from a 2-processor (600 MHz) to a 4-processor (400 MHz) box and have been puzzling over reduced performance, even after playing with different degrees of parallel query and having twice as much memory for the DB on the 4-processor box Btw, that's one of the reasons why I suggest my clients to turn off Hyperthreading for their new Intel boxes. HT basically makes your CPU to 2 over 50% slower CPUs, providing that all your virtual CPUs will be loaded and you are using the same types of CPU instructions in all of your processes (I doubt that you are using MMX, SSE or even FPU that much with your Oracle database). Situation gets especially bad with parallel execution where Oracle thinks it has 4 physical processors whilst you actually got 2 for example. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Suggestion reg. encryption ??
Hi Jp, No its not the paper you mention from iDefense but the one you got is not too bad. My paper was called Encrypting data in the Oracle database - as i say if you email them you may be able to get it. kind regards Pete In article [EMAIL PROTECTED], Prem Khanna J [EMAIL PROTECTED] writes Hi Pete, Thanx a lot. http://www.petefinnigan.com/orasec.htm This URL of yours has a lot related to encryption. As u said,i received Best Practices for Securing Oracle from iDefense.com.Is this the paper u mentioned about ? -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: workarea_size_policy=auto and performance efficiency [was: Re:
Hi Tim, I would suggest there are two key advantages to using automatic workspace management. The first and perhaps most important is that yes, unlike the manual method by which sessions cling onto memory, automatic workspace management can deallocate the tuneable portion of the PGAs (those previously set with *_AREA_SIZE parameters) when no longer required. This means that the overall memory consumption used during peak periods (when memory is possibly a problem) is likely to be less as the average memory used per session is likely to be lower due to this deallocation process (although it does somewhat depend on both the size and concurrency of these operations). On a key production database at my current site, the vast majority of the 1000-1200 sessions are sitting with moderate pga_alloc_mem (1/2M) despite most having a substantially larger pga_max_mem due to previous workspace activity (as evidenced in v$process). This overall reduction in memory consumption is measurable at between 1-2G which for us was significant as we were pushing our memory limit previously. Secondly, as memory is more effectively returned, Oracle/we can be both more generous and more flexible in how much memory each session temporarily consumes. With manual tuning, after setting the (say) SAS to (say) 10M, what if a session wanted 11M, or 50M, or 150M etc ? Although as you suggest there are quotas in how much a particular session can consume depending on workload (eg. 5% limit for serial operations, etc.), the maximum memory that can be safely consumed by a session could be somewhat higher. If too many operations require a onepass/multipass executions, then the P_A_T should obviously be reviewed. However although the P_A_T setting kinda provides a safety net for memory consumption, if you have few concurrent, largish workarea operations, you could set the P_A_T to be somewhat higher than perhaps desirable (if reached) knowing it won't in fact be reached because of the low concurrency of these operations. This then increases the maximum memory capacity for each session in a controlled manner, knowing that this memory won't be hogged by the sessions. As I mentioned before, we now experience no disks sorts whatsoever. In our environment, automatic workspace management has been ideal. We have a large number of sessions most of which perform workspace operations at some stage but not concurrently in any significant numbers. Thereby, we have managed to both improve the efficiency of workspace operations by allowing sessions to acquire the necessary memory as required while at the same time dramatically reducing overall memory consumption. Best of both worlds !! Cheers - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 7:39 AM Richard, I take it that your two points are...shall we say...enhancement requests, not current functionality? :-) Following up on the discussion of space-efficiency and tabling (for the moment) my questions about the performance-efficiency side of things. Yes, there certainly is an element of performance-efficiency to space-efficiency if it keeps you from swapping... ...anyway... Using WORKAREA_SIZE_POLICY = MANUAL, only the sort workarea has ever even pretended to give memory back for the duration of the session, depending on the relationship between SORT_AREA_SIZE and SORT_AREA_RETAINED_SIZE. The hash and bitmap workareas have never had this functionality, as near as I can tell. So, I think that you're absolutely correct that sessions using WORKAREA_SIZE_POLICY = MANUAL will allocate the memory and hold onto it for a long time, essentially until they disconnect. Is this correct? Is WORKAREA_SIZE_POLICY = AUTO any different? From what I've gathered, the P_A_T algorithms only occur upon allocation of workarea memory. Is there any additional logic around de-allocation, possibly when the server process has finished using the workarea? Perhaps there is logic to de-allocate before beginning another operation requiring? Or do server processes hold onto workarea memory forever here as well? I'm prepared to accept P_A_T as the best thing since LMT, but so far I don't see it. At least not for all circumstances (as with LMT). I see it as a good thing in memory-constrained environments, but in environments with plenty of RAM I see it so far as a possible source of unnecessary instability with no upside. Thanks! -Tim on 9/29/03 5:10 AM, Richard Foote at [EMAIL PROTECTED] wrote: Hi Tim, There are couple of parts of the conversation we've missed out ;) Firstly, the server process when talking to the P_A_T instance should have said, What the hell is going on here, what do you mean I can't have my full 100M, this keeps on happening and it's just good enough. Get a bloody DBA to increase the P_A_T now because it's bloody obvious that the damn thing is set too low . (especially if the load you describe is typical).
RE: Re: Cary's book -- Out of stock !
I've also picked up my copy yesterday but ...I'm assuming everyone else has theirs by now and are busily reading. ... I still not have finished Tom Kite Expert one on one Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- DENNIS WILLIAMS Sent: Tuesday, September 30, 2003 9:30 AM To: Multiple recipients of list ORACLE-L I picked my copy up last night from my local Borders bookstore. They even had a copy for the shelf. I'm assuming everyone else has theirs by now and are busily reading. Please post any comments or observations. Leave it to Cary to put exercises at the end of each chapter. A quick flip through makes me want to abandon study for my last OCP exam. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 23, 2003 11:40 AM To: Multiple recipients of list ORACLE-L RE: Re: Cary's book -- Out of stock !Hi! Figure 9-14 shows an interesting situation in which a single fast CPU out-performs a system with 4 slower CPUs, for a certain condition; this is exactly the situation I am facing while testing the move of a DB (9.0.1.3.0) from a 2-processor (600 MHz) to a 4-processor (400 MHz) box and have been puzzling over reduced performance, even after playing with different degrees of parallel query and having twice as much memory for the DB on the 4-processor box Btw, that's one of the reasons why I suggest my clients to turn off Hyperthreading for their new Intel boxes. HT basically makes your CPU to 2 over 50% slower CPUs, providing that all your virtual CPUs will be loaded and you are using the same types of CPU instructions in all of your processes (I doubt that you are using MMX, SSE or even FPU that much with your Oracle database). Situation gets especially bad with parallel execution where Oracle thinks it has 4 physical processors whilst you actually got 2 for example. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette 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 Report!
Title: Re: Statspack Report! Without looking at other parts of the report, there is no way of telling if this information is important or not. There is not enough timing information displayed to understand whether these issues are a significant part of your databases performance or not. Please upload your report to http://www.oraperf.com to get a much better organized analysis of the STATSPACK info. Youll need to register but it is worth it, although Veritas has unfortunately become much more aggressive about spam than Precise ever was. For instructions on how to read the results of the YAPP report, please read Bjorns paper on using STATSPACK with YAPP at http://oraperf.veritas.com/whitepapers.html... on 9/29/03 9:29 PM, Gunnar Berglund at [EMAIL PROTECTED] wrote: Hi all, could you please clarify me what these might mean (and how to tune the db in order to avoid those). So I have done a performance report with statspack and the instance is 9.2.0.3 on Solaris8 box. On a report there are a couple of issues I don't understand: Child Get Spin Latch Name Num Requests Misses Sleeps Sleeps 1-4 -- --- --- -- cache buffers chains 609 750,125 572 58 0/0/0/0/0 cache buffers chains 610 641,794 673 38 0/0/0/0/0 cache b! uffers chains 611 508,147 246 23 0/0/0/0/0 cache buffers chains 608 374,928 96 11 0/0/0/0/0 and Top 5 Timed Events ~~ % Total Event Waits Time (s) Ela Time --- direct path write (lob) 101,116 ! 13,637 38.23 and Event Waits Timeouts Time (s) (ms) /txn -- -- -- rdbms ipc message 218,281 202,375 809,339 3708 0.8 Sorry for the mess, but please try to read... TIA gb Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/
RE: how to generate unique file names on Windows.
This adds the time in fractions...
## uniquefile.bat##
@echo off
for /f tokens=2,3,4 delims=/ %%a in ('date /t') do set pre=%%a%%b%%c_
FOR /F TOKENS=5-8 DELIMS=:. %%F IN ('ECHO.^|TIME') DO (
SET Hour=%%F
SET Mins=%%G
SET Secs=%%H
SET Mill=%%I)
set filename=yourPREFIX_%pre: =_%%Hour: =_%%Mins: =_%%Secs:
=_%%Mill:=_%.txt
##
hth
bob
I am trying to write a script on windows that would export the db every
night. Can someone tell me how to generate unique file names on
windows...
What I am looking for is the windows equivalent of echo `date +%m%d%y`
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/[EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RMAN - Compressing using named piped
I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space. Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ? My rman backups are 71g compresed they are 12g. Thanks ahead of time. -Lizz Do you Yahoo!? The New Yahoo! Shopping - with improved product search
RE: RE: Google's architecture -- was Re: paging and google.com
Title: Message An brief overview of Googles architecture http://www.computer.org/micro/mi2003/m2022.pdf Google does use Oracle, but afaik only in-house for internal applications. The clustered search engine is entirely custom code and engine. 10,000 servers would be a pretty big RAC install. :) Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Google's architecture -- was Re: paging and google.com I'm confused. Does Tom Kyte actually say that Google uses Oracle or is he talking of google-like behaviour in Oracle queries ? Hemant At 07:24 AM 26-09-03 -0800, you wrote: http://tinyurl.com/ordz HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Google's architecture -- was Re: paging and google.com hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: x$ constructs and memory
Hi Steve and welcome back, Thanks for that detailed answer BUT... A practical question from the original post remains: What happens when these x$constructs begin to consume large amounts of memory? From your explanation I'm assuming that, beyond monitoring the SGA and PGA, memory consumption of individual X$ in-memory data structures is generally not something we need to worry about. How can we determine how much memory they actually consume? Are there any related tunable parameters of which we should be aware? Thanks, Steve Orr -Original Message- Sent: Monday, September 29, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Hi Daniel and list, There are two types of X$ row sources. X$ tables export in-memory data structures that are inherently tabular, and X$ interfaces that call functions to return data is non-tabular, or not memory resident. For example, the array of structs in the SGA representing processes is exported as the X$ table X$KSUPR. Not all of the struct members are exported as columns, but all of the rows are exported. There is a freelist, implemented as a header that points to the first free slot in the array, and a member of each struct to point to the next free slot. The 'process allocation' latch protects this freelist. The most obvious example of an X$ interface to return non-tabular data is X$KSMSP, which returns one row for each chunk of memory in the shared pool. (There are similar X$ interfaces for other memory heaps). As you may know, heaps are implemented as a heap descriptor and linked list of extents, and within each extent there is a linked list of chunks. So what is done is that when the X$ interface is queried these linked lists are navigated (under the protection of the relevant latch if necessary) an a array is built in the CGA (part of the PGA) from which rows are then returned by the row source. An example of an X$ interface that returns data that is not memory resident is X$KCCLE, which returns one row for each log file member entry in the controlfile. In fact, all the X$KCC* interfaces read data directly from the controlfile. Similarly, the X$KTFB* interfaces return LMT extent information - from the bitmap blocks (for free extents) and from the segment header and extent map blocks (for used extents). Some X$ tables have become X$ interfaces in recent versions, for example X$KTCXB and X$KSQRS. These correspond to the transactions and enqueue resources arrays respectively. The reason is that they are no longer fixed arrays. Instead they are segmented arrays that can be dynamically extended by adding discontiguous chunks of shared pool memory to the array. The freelists and latching for these arrays in unchanged however. All you will notice is that the ADDR column of the X$ output now returns addresses which map into your PGA rather than the SGA. In fact, that is in general a good way to work out whether you are looking at an X$ table or an X$ interface. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -Original Message- Daniel Fink Sent: Tuesday, 30 September 2003 1:10 AM To: Multiple recipients of list ORACLE-L I was sitting on a mountain here in Colorado, pondering Oracle optimization and an interesting scenario crossed my feeble mind. As I began to ponder this (I asked the resident marmot, but he must be a SQL*Server expert...), I came up with several questions. Where in memory (sga or other) do the x$ constructs reside? Some of them are 'populated' by reading file-based structures (control file, datafile headers, undo segments). Does this information reside in memory or is it loaded each time the x$ construct is accessed? What happens when these x$constructs begin to consume large amounts of memory? Is there an upper bound? Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve 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
Data denormalisation seems some attractive
Hi, A co-worker of mine is working on a tiny project. Let say you have commission info and commission details, there are 7 types of commissions. The 7 types of commission shares common fields (from 100% to 30%) From a conceptual point of view, you have 1 entity that is the commission info and 7 entities for the seven types of commissions since they all have private info (some fields are mandatory).. 1 commission must be 1 of the 7 types. Now at the physical level, info is write once, never update and read through a selective search criteria (agent number). Volume is about 8 000 000 commissions. You can have the physical model as the conceptual model. That means you do not have any work for managing integrity but when reading you have more work to get the data. Or You can put all data in 1 table with all fields. When data is inserted you must managed integrity (some common fields are mandatory for 1 type of commission but not for another one) but reading is fast just 1 record to read. Since, I do not know what the future of this project is I recommended the other DBA to keep data normalized. And to do a benchmark if he really wants to denormalize. Your opinions please. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN - Compressing using named piped
Title: Message Can you figure out what to name the pipe in advance? Is there a way to reliably determine what file name RMAN will create? -Original Message-From: laura pena [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space. Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ? My rman backups are 71g compresed they are 12g. Thanks ahead of time. -Lizz Do you Yahoo!?The New Yahoo! Shopping - with improved product search
RE: RE: Using dimensions
Title: RE: RE: Using dimensions I am out sick today ... glad you found the acronyms ... the F is left to your own imagination. Raj -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 30, 2003 5:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Using dimensions OwwThank God Raj hasn't replied yet :-) Thanx Gints. Jp.
RE: RMAN - Compressing using named piped
I can use mknod and create a named pipe a head of time.
I do this when I use the exp or imp utilites (just wondering if I can do same with RMAN):
==
export EXP_DIR="/oracle/export"export PIPE_DIR="/oracle/export"export PIPE_FILE="$PIPE_DIR/imp_pipe"mydump="DBAFULL_090403.DMP.gz"
i=1for db in voicelog authcode_cp authcode_user crd_user crd_cp vlsuperdo echo $i rm -f ${PIPE_FILE}.$i mknod ${PIPE_FILE}.$i p echo `date` echo "Running gzip" nohup cat $EXP_DIR/$mydump | /usr/bin/gunzip -c ${PIPE_FILE}.$i echo `date` echo "Running imp" imp system/$1 FROMUSER=$db TOUSER=$db file=${PIPE_FILE}.$i log=$db.imp.log buffer=1024000 rows=y indexes=n constraints=n feedback=1000 RESUMABLE=Y grants=n commit=y ignore=y echo `date` echo "Done with imp for $i" i=`expr $i + 1`doneecho "Import for Users complete"
=
"Orr, Steve" [EMAIL PROTECTED] wrote:
Can you figure out what to name the pipe in advance? Is there a way to reliably determine what file name RMAN will create?
-Original Message-From: laura pena [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped
I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space.
Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup?
If someone has done this before, can you let me know how ?
My rman backups are 71g compresed they are 12g.
Thanks ahead of time.
-Lizz
Do you Yahoo!?The New Yahoo! Shopping - with improved product search
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Anyone ever implemented aix 5.2 concurrent io ?
Hello everyone, I've come across an IBM whitepaper: improving database performance with aix concurrent io. IBM have tested this with Oracle 9i R2 and claim performance comparable to using raw-volumes. Has anyone in the fatcity community ever tried this? Does Oracle do an open of the database files using the o_cio flag? Or should one mount the jfs2 filesystem using the -o cio option? Looking forward to your reactions. Regards, Hans de Git _ Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git 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: OFA myths was Re: BAARF
Loney didn't write OFA, and methinks he was taking liberties with it. --- Jacques Kilchoer [EMAIL PROTECTED] wrote: Not commenting on the accuracy of the information, but Kevin Loney, in the Oracle8 DBA Handbook (1998), says the following (Chapter 3 Logical Database Layouts), in a section entitled The Optimal Flexible Architecture (OFA) Index segments should not be stored in the same tablespace as their associated tables, since they have a great deal of concurreint I/O during both manipulation and queries. Index segments are also subject to fragmentation due to improper sizing or unpredicted table growth. Isolating the application indexes to a separate tablespace greatly reduces the administrative efforts involved in defragmenting either the DATA or the INDEXES tablespace. From reading his book, I always thought that OFA implied the separation of tables and indexes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Steve Rospo Sent: jeudi, 25. septembre 2003 15:10 I'd like to get rid of the myth that OFA really states all that much about what goes in what tablespace etc. I've got a copy of the Cary's OFA paper entitled The OFA Standard - Oracle7 for Open Systems dated Sept 24, 1995. (Happy belated birthday OFA!) At the end of paper there's a summary of the requirements and the recommendations that make up OFA. The CLOSEST the OFA comes to specifying table/index separation are #7 Separate groups of segments with different lifespans, I/O request demands, and backup frequencies among different tablespaces. -or maybe- #11 *IF* [emphasis mine] you can afford enough hardware that: 1) You can guarantee that each disk drive will contain database files from exactly one application and 2) You can dedicate sufficiently many drives to each database to ensure that there will be no I/O bottleneck. The document itself says, The OFA Standard is a set of configuration guidelines that will give you faster, more reliable Oracle database that require less work to maintain. So every time I read that someone is putting redo here, index tablespaces here, and temp tablespaces there in order to be OFA compliant I kinda shrug. Obviously it's all a good idea to separate this stuff but it's not absolutely required for OFA-ness. Essentially, OFA is just a very good way of separating Oracle code from Oracle data to make administration *much* easier. I'm sure before OFA there were plenty of places that had everything under $ORACLE_HOME/dbs and no naming standard for datafiles. Ugh! Now if we could only find this Cary V. Millsap, Oracle Corporation character so he could explain himself. ;-) '95 was a loong time ago. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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 DIGEST
RE: Top (=10) Issues faced by Oracle DBAs Deploying in a
Unfortunately, we are always adding a new database. The new SAN commission in June-July was supposed to hold 6 databases. Then it became 7 databases in August. Now it is 8 this month and the count will go up to 9 databases by December. As the SAN Storage Admin and Unix SA roles are handled by two people [apart from me, the DBA], I haven't been able to get additional file systems available on the SunCluster accessing the SAN. I have been cramming in 8 databases into file systems sized for 6. Hemant At 09:09 AM 29-09-03 -0800, you wrote: Hemant -- I just came off a gig where I was the storage/Unix/DBA geek, and, in my opinion, while the level of expertise *does* need to be higher, *and different*, for in that environment, it's all front-end. Once you have the database configured and the backup and recovery scripts written and tested, you can go back to having just straight DBAs. At least that's what they did at my last site, and I haven't heard any complaints from them. Bambi. -Original Message- Sent: Saturday, September 27, 2003 11:50 AM To: Multiple recipients of list ORACLE-L As an Oracle DBA , I have no problems putting my Databases on SANs [yes, we have seperate SANs, from different vendors]. However, I find that Storage and Unix Admin skill requirements for a SAN seem to be higher. When Clustered servers access the SAN, it seems to be even more difficult to get an additional mount point made available to the DBA. Hemant At 10:59 AM 25-09-03 -0800, you wrote: Fellow Listers, If you don't deal with Oracle databases on SAN/NAS environments, this posting may not interest you. If so, my apologies, please delete this. Otherwise, please read on. In an effort to better understand what issues you face when deploying an Oracle database in a SAN/NAS environment, I am writing to you to get some real life feedback. Although I have a fair idea, where some of the pain lies, it would be much more valuable if you could tell me. Kind of like From the horse's mouth..;-) And I truly meant that as a compliment...:-) My goal is to fully understand where the real pain lies, so that appropriate solutions can be built to alleviate or even eliminate the pain. You can be as broad or narrow in your responses using the following topics as guidelines: * Initial SAN/NAS Configuration for Database Creation and Application Deployment * Ongoing Storage Volume Management in a SAN/NAS * Ongoing Storage Administration (Growth, Resizing) * Performance Optimization Troubleshooting * Things that require automation * Anything else you think is important that I have missed I do really appreciate you taking the time to put your feedback in black and white. Those of you who take the time and effort to provide feedback, will be entered in a raffle to for some T-shirts and other freebies. Oh, BTW, when you do send your response, please provide your full contact information, so that I know where to mail the goodies. In the interest of not flooding the list, please send me your feedback directly to [EMAIL PROTECTED] As a courtesy to my fellow listers, I will collate all responses and post a summary in the near future. You can count on me to do that. Best regards, Gaja = Gaja Krishna Vaidyanatha| E-Mail: [EMAIL PROTECTED] Principal Technical Product Manager | Phone: (650)-527-3180 Application Performance Management | Web: http://www.veritas.com Veritas Corporation | __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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
RE: Problems creading a Index
Run the following sql statement to see whether there are duplicate entries. Chances are that you will find duplicates hence you get the above error. You may choose to remove the duplicates or create a non-unique index otherwise. select COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM, count(*) from LAWSON2.OEINVCLINE group by COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM having count(*) 1; -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Teresita CastroSent: Monday, September 29, 2003 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: Problems creading a Index HI!! I want to createthe next index: CREATE UNIQUE INDEX LAWSON2.IOEINVCLINE1 ON "LAWSON2".OEINVCLINE(COMPANY, INVC_PREFIX, INVC_NUMBER, ITEM) TABLESPACE LAWSON_PRUEBAS_INDICES PCTFREE 5 STORAGE(INITIAL 40960 ) But I can't because Oracle send me the next error: The following error has occurred: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found I checked on TOAD ( with F4 on the table name) and It give me the next script. I don't have an index with the field ITEM on it, so I don't undestand what I am getting this error. DROP TABLE OEINVCLINE CASCADE CONSTRAINTS ; CREATE TABLE OEINVCLINE ( COMPANY NUMBER (4) NOT NULL, INVC_PREFIX CHAR (2) NOT NULL, INVC_NUMBER NUMBER (8) NOT NULL, LINE_NBR NUMBER (6) NOT NULL, LINE_TYPE CHAR (1) NOT NULL, ITEM CHAR (32) NOT NULL, DESCRIPTION CHAR (30) NOT NULL, ORDER_NBR NUMBER (8) NOT NULL, SHIPMENT_NBR NUMBER (10) NOT NULL, QUANTITY NUMBER (13,4) NOT NULL, INVC_CW_QTY NUMBER (13,4) NOT NULL, SPR_UOM CHAR (4) NOT NULL, SELL_UOM CHAR (4) NOT NULL, SEC_UOM CHAR (4) NOT NULL, MULT_SPR_FL CHAR (1) NOT NULL, SPR_TO_STOCK NUMBER (13,7) NOT NULL, SELL_TO_STOCK NUMBER (13,7) NOT NULL, SEC_UOM_MULT NUMBER (13,7) NOT NULL, LOCATION CHAR (5) NOT NULL, PRICE_STATUS CHAR (1) NOT NULL, ENTERED_PRICE NUMBER (13,5) NOT NULL, UNIT_PRICE NUMBER (13,5) NOT NULL, SELL_PRC_CURR NUMBER (15,7) NOT NULL, SELL_UNIT_PRC NUMBER (15,7) NOT NULL, UNIT_COST NUMBER (13,5) NOT NULL, CURRENT_COST NUMBER (13,5) NOT NULL, NO_CHARGE_FL CHAR (1) NOT NULL, ENTERED_DISC NUMBER (15,2) NOT NULL, ADD_ON_DISC NUMBER (15,2) NOT NULL, ALLOC_DISC NUMBER (15,2) NOT NULL, TAX_EXEMPT_CD CHAR (1) NOT NULL, TAX_CODE CHAR (10) NOT NULL, ENT_TAXABLE NUMBER (15,2) NOT NULL, TAXABLE_BSE NUMBER (15,2) NOT NULL, TAX_AMT_CURR NUMBER (15,2) NOT NULL, TAX_AMT_BSE NUMBER (15,2) NOT NULL, REASON_CODE CHAR (4) NOT NULL, DISC_CODE CHAR (10) NOT NULL, ORD_DISC_FL CHAR (1) NOT NULL, CONTRACT_NBR CHAR (14) NOT NULL, PROMOTION CHAR (10) NOT NULL, ACTIVITY CHAR (15) NOT NULL, ACCT_CATEGORY CHAR (5) NOT NULL, ATN_OBJ_ID NUMBER (12) NOT NULL, ACTIVITY_C CHAR (15) NOT NULL, ACCT_CATEG_C CHAR (5) NOT NULL, ATN_OBJ_ID_C NUMBER (12) NOT NULL, FINAL_INVC_FL CHAR (1) NOT NULL, SLS_ACCT_UNIT CHAR (15) NOT NULL, SLS_ACCOUNT NUMBER (6) NOT NULL, SLS_SUB_ACCT NUMBER (4) NOT NULL, SALES_MAJCL CHAR (4) NOT NULL, SALES_MINCL CHAR (4) NOT NULL, DSC_AMT_01 NUMBER (15,2) NOT NULL, DSC_AMT_02 NUMBER (15,2) NOT NULL, DSC_AMT_03 NUMBER (15,2) NOT NULL, DSC_ACCT_UNIT_01 CHAR (15) NOT NULL, DSC_ACCT_UNIT_02 CHAR (15) NOT NULL, DSC_ACCT_UNIT_03 CHAR (15) NOT NULL, DSC_ACCOUNT_01 NUMBER (6) NOT NULL, DSC_ACCOUNT_02 NUMBER (6) NOT NULL, DSC_ACCOUNT_03 NUMBER (6) NOT NULL, DSC_SUB_ACCT_01 NUMBER (4) NOT NULL, DSC_SUB_ACCT_02 NUMBER (4) NOT NULL, DSC_SUB_ACCT_03 NUMBER (4) NOT NULL, DSC_AMT_BASE NUMBER (15,2) NOT NULL, OFF_ACCT_UNIT CHAR (15) NOT NULL, OFF_ACCOUNT NUMBER (6) NOT NULL, OFF_SUB_ACCT NUMBER (4) NOT NULL, CGS_ACCT_UNIT CHAR (15) NOT NULL, CGS_ACCOUNT NUMBER (6) NOT NULL, CGS_SUB_ACCT NUMBER (4) NOT NULL, LAST_MISC_SEQ NUMBER (3) NOT NULL, LAST_COMM_SEQ NUMBER (3) NOT NULL, TERRITORY CHAR (4) NOT NULL, SALESMAN NUMBER (4) NOT NULL, SALESMAN_2 NUMBER (4) NOT NULL, COMM_RATE_1 NUMBER (7,7) NOT NULL, COMM_RATE_2 NUMBER (7,7) NOT NULL, COMM_SPLIT NUMBER (5,5) NOT NULL, USER_FLD1 CHAR (2) NOT NULL, USER_FLD2 CHAR (30) NOT NULL, USER_FLD3 CHAR (15) NOT NULL, LINE_GRS_CURR NUMBER (15,2) NOT NULL, INVL_OBJ_ID NUMBER (12) NOT NULL, PROD_TAX_CAT
Describe privilege on procedures packages
(Reposting from yesterday morning since I had no takers! :) Hello, I wanted to give another user access to view my procedures packages (just DESC capability), but it seems that the only way for him to be able to DESC them is for me to grant execute. Is this correct?? (I guess I have never had this situation before, it just seems surprising if there is no way to grant a read-only privilege). Thanks! _ Get MSN 8 Dial-up Internet Service FREE for one month. Limited time offer-- sign up now! http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Jackson 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: Separate Indexes and Data
I'd be very interested to know how many people have their index tablespaces on a different backup schedule from their data tablespaces. If so how different? What happens when a media failure occurs and you must restore from backup? You would need to have on hand and apply more redo logs to make the database current. I understand the argument proffered is separating indexes and data can mean that when physical corruption of the file happens to an index tablespace then all one needs do is to offline, drop, drop and rebuild the index tablespace. I admit I have not tried off-lining the tablespace first, but you cannot normally drop a tablespace which is being used to enforce referential integrity. If off-lining the tablespace first does work, I can see someone trying to do the rebuild with the database available and having duplicate records in the parent tables and records without parents in the child tables. On the size of the segments: The paper entitled How To Start Defragmenting and Start Living or something like that strongly advocated uniform extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall. However the paper Never mentioned what to do when an object that used to fit nicely into the 128k extent category now more properly belongs to the 4M category. If you move the data, large holes are left in the other tablespace, and while this does not impact Oracle performance, it does mean that your physical backups are larger than necessary. I am in the process of migrating from uniform to autoallocated extents. This means extents of different sizes share the same tablespace. The extent sizes being multiples of each other. This removes the argument about not having indexes and data in the same tablespaces due to their different sizes. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 29, 2003 8:10 AM To: Multiple recipients of list ORACLE-L Thomas, It *is* a good idea to separate index data from heap data into different tablespaces. But the reason isn't solely to eliminate I/O competition. Even if I/O competition isn't an issue for you (and the OFA Standard doesn't say that it will be), then it's *still* a good idea to separate your index data from your heap data, for reasons including: * Index segments have different backup and recovery requirements than their corresponding heap segments. For example, as Peter mentioned, if you have an index block corruption event, then it's convenient to just offline, kill, and rebuild an index tablespace. If the indexes and data are mixed up in a single tablespace, this is not an option. Another example: If you construct your backup schedule to make media recovery time a constant, then you probably don't need to back up your indexes on the same schedule as you back up your heaps. But unless they're in different tablespaces, this isn't an option either. * Index segments are usually smaller than their corresponding heap segments. Using separate tablespaces allows you to use a smaller extent size to conserve disk storage capacity. I don't think I ever wrote that you need to put indexes and their corresponding tables/clusters on separate disks, but you do need to be *able* to do that if your I/O rates indicate that you should. For the original OFA Standard definition, please see section 3 of the document called The OFA Standard--Oracle for Open Systems, and section 5 of Configuring Oracle Server for VLDB, both available for free at www.hotsos.com. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Thomas Day Sent: Monday, September 29, 2003 9:05 AM To: Multiple recipients of list ORACLE-L My struggle is not with the directory layout OFA. It is with the mythical OFA that every DBA that I have talked to knows all about. Where ORACLE says that if you are a good and competent DBA you will separate your table data and your index data into two separate tablespaces so that one disk head can be reading index entries while another disk head is reading the table data. You've never run into that? Tim Gorman tim @sagelogix.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: ml-errorsSubject: Re: BAARF 09/28/2003 09:44 PM Please respond to ORACLE-L Thomas, Please pardon me, but you are off-target in your criticisms of OFA. It has never advocated separating tables from indexes for performance purposes. Ironically, your email
Re: Suggestion reg. encryption ??
Hi Craig, yes that is the one. cheers Pete In article [EMAIL PROTECTED], Craig Munday [EMAIL PROTECTED] writes Pete, Which paper of Aarons are you referring to? Is the paper entitled Encryption of data at rest? Regards, Craig Munday. At 05:29 AM 29/09/2003 -0800, you wrote: Hi Jp On the specific issue of encryption your main concern will be hiding the encryption key from any prying eyes. There is a couple of links to papers on my site about encryption in Oracle http://www.petefinnigan.com /orasec.htm especially the link to Aarons paper which discusses the key hiding issue. I also wrote a paper for iDefense.com earlier this year about encrypting data in Oracle databases. It was slightly high level as it was aimed at what the possibilities and tools available are. It is not in the public domain so i cannot send out copies but if you email them you might be able to get a copy from them. hope this helps a bit kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN - Compressing using named piped
I dont think you can compress rman files while backups are running. RMAN doesnt support external compression while backups are running 'cause RMAN has to validate backups. You can compress all the files once your backup is completed. I tried that in the past but didnt work. Infect thereare sometechnical forums onmetalink about that. I have a script which I used to validate backups and gzip files after backups are completed. If you are interested I can send you offline, script is not very good but worked fine. -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 7:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space. Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ? My rman backups are 71g compresed they are 12g. Thanks ahead of time. -Lizz Do you Yahoo!?The New Yahoo! Shopping - with improved product searchDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
Re: RE: Separate Indexes and Data
the defrag paper was written back in 1998 I believe. Uniform extents were a good solution pre-9i. We use them here on our 8i databases. I stick with an uniform 5m extent size even though I have tables that can fit into 128k extents, but feel that the overall time savings by using 1 extent size makes up for this. unfortunately unlike most systems we cannot break up our tables into different tablespaces. We use transportable tablespaces to batch publish data to data marts. New tablespaces mean additional transportable tablespaces and more places for stuff to go wrong. I saw some posts on dejanews recently from some pretty experienced DBAs stating that there may be 'flaws' in auto-allocate leading to poor extent sizes that leads to fragmentation. I believe Rachel Carmichael made a post on here a few months back with the similiar experience(could be wrong). Due to even the 'small' chance of flaws in auto-allocate, Im thinking of waiting for version 10g before using it. Just to be safe. Not worth risking a defrag on a production system. From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/09/30 Tue PM 01:34:28 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Separate Indexes and Data I'd be very interested to know how many people have their index tablespaces on a different backup schedule from their data tablespaces. If so how different? What happens when a media failure occurs and you must restore from backup? You would need to have on hand and apply more redo logs to make the database current. I understand the argument proffered is separating indexes and data can mean that when physical corruption of the file happens to an index tablespace then all one needs do is to offline, drop, drop and rebuild the index tablespace. I admit I have not tried off-lining the tablespace first, but you cannot normally drop a tablespace which is being used to enforce referential integrity. If off-lining the tablespace first does work, I can see someone trying to do the rebuild with the database available and having duplicate records in the parent tables and records without parents in the child tables. On the size of the segments: The paper entitled How To Start Defragmenting and Start Living or something like that strongly advocated uniform extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall. However the paper Never mentioned what to do when an object that used to fit nicely into the 128k extent category now more properly belongs to the 4M category. If you move the data, large holes are left in the other tablespace, and while this does not impact Oracle performance, it does mean that your physical backups are larger than necessary. I am in the process of migrating from uniform to autoallocated extents. This means extents of different sizes share the same tablespace. The extent sizes being multiples of each other. This removes the argument about not having indexes and data in the same tablespaces due to their different sizes. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 29, 2003 8:10 AM To: Multiple recipients of list ORACLE-L Thomas, It *is* a good idea to separate index data from heap data into different tablespaces. But the reason isn't solely to eliminate I/O competition. Even if I/O competition isn't an issue for you (and the OFA Standard doesn't say that it will be), then it's *still* a good idea to separate your index data from your heap data, for reasons including: * Index segments have different backup and recovery requirements than their corresponding heap segments. For example, as Peter mentioned, if you have an index block corruption event, then it's convenient to just offline, kill, and rebuild an index tablespace. If the indexes and data are mixed up in a single tablespace, this is not an option. Another example: If you construct your backup schedule to make media recovery time a constant, then you probably don't need to back up your indexes on the same schedule as you back up your heaps. But unless they're in different tablespaces, this isn't an option either. * Index segments are usually smaller than their corresponding heap segments. Using separate tablespaces allows you to use a smaller extent size to conserve disk storage capacity. I don't think I ever wrote that you need to put indexes and their corresponding tables/clusters on separate disks, but you do need to be *able* to do that if your I/O rates indicate that you should. For the original OFA Standard definition, please see section 3 of the document called The OFA Standard--Oracle for Open Systems, and section 5 of Configuring Oracle Server for VLDB, both available for free at www.hotsos.com. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events:
RE: RE: Separate Indexes and Data
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Separate Indexes and Data the defrag paper was written back in 1998 I believe. Uniform extents were a good solution pre-9i. We use them here on our I haven't been following this thread closely, but why are uniform extents no longer good for 9i? 8i databases. I stick with an uniform 5m extent size even though I have tables that can fit into 128k extents, but feel that the overall time savings by using 1 extent size makes up for this. unfortunately unlike most systems we cannot break up our tables into different tablespaces. We use transportable tablespaces to batch publish data to data marts. New tablespaces mean additional transportable tablespaces and more places for stuff to go wrong. I saw some posts on dejanews recently from some pretty experienced DBAs stating that there may be 'flaws' in auto-allocate leading to poor extent sizes that leads to I don't believe it's a flaw, it's by design. At least according to Tom Kyte's new book (first chapter's on the web) it is, which is why I can't see me using it for our DBs. fragmentation. I believe Rachel Carmichael made a post on here a few months back with the similiar experience(could be wrong). Due to even the 'small' chance of flaws in auto-allocate, Im thinking of waiting for version 10g before using it. Just to be safe. Not worth risking a defrag on a production system. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
problem with xmlparser and dom objects
I didnt write this code and am not particularly familiar with this part of Oracle. We are attempting to migrate some CLOB data. To do this we batch load it into DOM objects, then user XMLPARSER to parse it, then do an insert. We are finding that it sucks up so many resources that you cant even log in. This is in an 8i database and the only way to get in is through SVRMGRL and all I can do is a shutdown abort. any idea what to look for in this code? Im not very familiar with ORACLE Java? The code was written before I got here and by someone who is no longer with the company. Ive read a little on Oracle Java and I know Java somewhat. I first thought we were in archive log mode and the archiver could not keep up. We are not. Now I think it may be that the DOM object memory does not get deallocated and when Oracle tries to allocate more memory the system just hangs. I know when you use SQL or PL/SQL and run out of PGA memory the query crashes or Oracle swaps to temp space. anyone have experience with this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Separate Indexes and Data
From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/09/30 Tue PM 02:09:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Separate Indexes and Data -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Separate Indexes and Data the defrag paper was written back in 1998 I believe. Uniform extents were a good solution pre-9i. We use them here on our I haven't been following this thread closely, but why are uniform extents no longer good for 9i? Kyte recommends using auto-segment management 8i databases. I stick with an uniform 5m extent size even though I have tables that can fit into 128k extents, but feel that the overall time savings by using 1 extent size makes up for this. unfortunately unlike most systems we cannot break up our tables into different tablespaces. We use transportable tablespaces to batch publish data to data marts. New tablespaces mean additional transportable tablespaces and more places for stuff to go wrong. I saw some posts on dejanews recently from some pretty experienced DBAs stating that there may be 'flaws' in auto-allocate leading to poor extent sizes that leads to I don't believe it's a flaw, it's by design. At least according to Tom Kyte's new book (first chapter's on the web) it is, which is why I can't see me using it for our DBs. Ive read the book. PCTINCREASE is basically set to 100% so the extent sizes double. Thats 'basically' how it works. I have seen some posts on dejanews saying it doesnt necessarily work this way and some people are finding large extent sizes with just a few extents and when tables are dropped this is leading to fragmentation. It hasnt happened to me, but the posts on dejanews were from some pretty good posters. So Im playing conservative. We also had one of the contributors here mention issues. fragmentation. I believe Rachel Carmichael made a post on here a few months back with the similiar experience(could be wrong). Due to even the 'small' chance of flaws in auto-allocate, Im thinking of waiting for version 10g before using it. Just to be safe. Not worth risking a defrag on a production system. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Separate Indexes and Data
Nuh uh, not me... I have never used or experimented with auto-allocate. I separate indexes and tables so that I can reclaim space by rebuilding the indexes into smaller space. I've just completed writing the scripts for the following: we have a data warehouse, partitioned on the biggest table on date by month. There are 10 or 11 indexes on this table. We overallocate space when we create the new partition for the next month. Data is loaded daily. The hosting company has an automated procedure to add space to the datafile if the used space percentage is greater than some number (we get charged each time they do this, and they never allocate enough space so they do it over and over towards the end of the month). since the indexes are increasing on a daily basis, we overallocate the space. The next month, I go out, determine the partition/tablespace/datafiles that need to be resized (naming standards rule in this case), rebuild the indexes into an interim tablespace, rebuild them back to the original one with a smaller pctfree and then determine how small I can resize them down to. If there were table data in these tablespaces, I'd be out of luck on trying to reclaim space --- [EMAIL PROTECTED] wrote: the defrag paper was written back in 1998 I believe. Uniform extents were a good solution pre-9i. We use them here on our 8i databases. I stick with an uniform 5m extent size even though I have tables that can fit into 128k extents, but feel that the overall time savings by using 1 extent size makes up for this. unfortunately unlike most systems we cannot break up our tables into different tablespaces. We use transportable tablespaces to batch publish data to data marts. New tablespaces mean additional transportable tablespaces and more places for stuff to go wrong. I saw some posts on dejanews recently from some pretty experienced DBAs stating that there may be 'flaws' in auto-allocate leading to poor extent sizes that leads to fragmentation. I believe Rachel Carmichael made a post on here a few months back with the similiar experience(could be wrong). Due to even the 'small' chance of flaws in auto-allocate, Im thinking of waiting for version 10g before using it. Just to be safe. Not worth risking a defrag on a production system. From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/09/30 Tue PM 01:34:28 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Separate Indexes and Data I'd be very interested to know how many people have their index tablespaces on a different backup schedule from their data tablespaces. If so how different? What happens when a media failure occurs and you must restore from backup? You would need to have on hand and apply more redo logs to make the database current. I understand the argument proffered is separating indexes and data can mean that when physical corruption of the file happens to an index tablespace then all one needs do is to offline, drop, drop and rebuild the index tablespace. I admit I have not tried off-lining the tablespace first, but you cannot normally drop a tablespace which is being used to enforce referential integrity. If off-lining the tablespace first does work, I can see someone trying to do the rebuild with the database available and having duplicate records in the parent tables and records without parents in the child tables. On the size of the segments: The paper entitled How To Start Defragmenting and Start Living or something like that strongly advocated uniform extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall. However the paper Never mentioned what to do when an object that used to fit nicely into the 128k extent category now more properly belongs to the 4M category. If you move the data, large holes are left in the other tablespace, and while this does not impact Oracle performance, it does mean that your physical backups are larger than necessary. I am in the process of migrating from uniform to autoallocated extents. This means extents of different sizes share the same tablespace. The extent sizes being multiples of each other. This removes the argument about not having indexes and data in the same tablespaces due to their different sizes. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 29, 2003 8:10 AM To: Multiple recipients of list ORACLE-L Thomas, It *is* a good idea to separate index data from heap data into different tablespaces. But the reason isn't solely to eliminate I/O competition. Even if I/O competition isn't an issue for you (and the OFA Standard doesn't say that it will be), then it's *still* a good idea to separate your index data from your heap data, for reasons including: * Index segments have different backup and recovery requirements than their corresponding heap
COBOL TO ORACLE
Hi, Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed 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: problem with xmlparser and dom objects
there is nothing in the alert log,udump, or cdump on this. Im going to have them run the package with a 10046 trace next. would a different trace be more appropriate? From: [EMAIL PROTECTED] Date: 2003/09/30 Tue PM 02:24:30 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: problem with xmlparser and dom objects I didnt write this code and am not particularly familiar with this part of Oracle. We are attempting to migrate some CLOB data. To do this we batch load it into DOM objects, then user XMLPARSER to parse it, then do an insert. We are finding that it sucks up so many resources that you cant even log in. This is in an 8i database and the only way to get in is through SVRMGRL and all I can do is a shutdown abort. any idea what to look for in this code? Im not very familiar with ORACLE Java? The code was written before I got here and by someone who is no longer with the company. Ive read a little on Oracle Java and I know Java somewhat. I first thought we were in archive log mode and the archiver could not keep up. We are not. Now I think it may be that the DOM object memory does not get deallocated and when Oracle tries to allocate more memory the system just hangs. I know when you use SQL or PL/SQL and run out of PGA memory the query crashes or Oracle swaps to temp space. anyone have experience with this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: x$ constructs and memory
I don't generally get too involved in the x$ stuff, just because it normally helps me very little in my DBA work. Nonetheless, I have been following this one somewhat, and if my understanding is correct, x$ tables are not actually responsible for consuming memory, they are merely a mechanism for displaying various structures internal to the kernel, many of which happen to be transient. Jared Orr, Steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 07:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: x$ constructs and memory Hi Steve and welcome back, Thanks for that detailed answer BUT... A practical question from the original post remains: What happens when these x$constructs begin to consume large amounts of memory? From your explanation I'm assuming that, beyond monitoring the SGA and PGA, memory consumption of individual X$ in-memory data structures is generally not something we need to worry about. How can we determine how much memory they actually consume? Are there any related tunable parameters of which we should be aware? Thanks, Steve Orr -Original Message- Sent: Monday, September 29, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Hi Daniel and list, There are two types of X$ row sources. X$ tables export in-memory data structures that are inherently tabular, and X$ interfaces that call functions to return data is non-tabular, or not memory resident. For example, the array of structs in the SGA representing processes is exported as the X$ table X$KSUPR. Not all of the struct members are exported as columns, but all of the rows are exported. There is a freelist, implemented as a header that points to the first free slot in the array, and a member of each struct to point to the next free slot. The 'process allocation' latch protects this freelist. The most obvious example of an X$ interface to return non-tabular data is X$KSMSP, which returns one row for each chunk of memory in the shared pool. (There are similar X$ interfaces for other memory heaps). As you may know, heaps are implemented as a heap descriptor and linked list of extents, and within each extent there is a linked list of chunks. So what is done is that when the X$ interface is queried these linked lists are navigated (under the protection of the relevant latch if necessary) an a array is built in the CGA (part of the PGA) from which rows are then returned by the row source. An example of an X$ interface that returns data that is not memory resident is X$KCCLE, which returns one row for each log file member entry in the controlfile. In fact, all the X$KCC* interfaces read data directly from the controlfile. Similarly, the X$KTFB* interfaces return LMT extent information - from the bitmap blocks (for free extents) and from the segment header and extent map blocks (for used extents). Some X$ tables have become X$ interfaces in recent versions, for example X$KTCXB and X$KSQRS. These correspond to the transactions and enqueue resources arrays respectively. The reason is that they are no longer fixed arrays. Instead they are segmented arrays that can be dynamically extended by adding discontiguous chunks of shared pool memory to the array. The freelists and latching for these arrays in unchanged however. All you will notice is that the ADDR column of the X$ output now returns addresses which map into your PGA rather than the SGA. In fact, that is in general a good way to work out whether you are looking at an X$ table or an X$ interface. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -Original Message- Daniel Fink Sent: Tuesday, 30 September 2003 1:10 AM To: Multiple recipients of list ORACLE-L I was sitting on a mountain here in Colorado, pondering Oracle optimization and an interesting scenario crossed my feeble mind. As I began to ponder this (I asked the resident marmot, but he must be a SQL*Server expert...), I came up with several questions. Where in memory (sga or other) do the x$ constructs reside? Some of them are 'populated' by reading file-based structures (control file, datafile headers, undo segments). Does this information reside in memory or is it loaded each time the x$ construct is accessed? What happens when these x$constructs begin to consume large amounts of memory? Is there an upper bound? Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Adams 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
Re: COBOL TO ORACLE
Er ... No. COBOL is a programming language. Oracle is a relational database manager. The data used in a COBOL program can be stored in a variety of ways. It's even possilbe to have a COBOL program using data from an Oracle database. I'm not aware that Designer can translate COBOL file definitions into entities; however, if you know COBOL and Oracle it should be fairly straightforward. Muqthar Ahmed Muqthar.Ahmed To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @decoratetoday.c cc: om Subject: COBOL TO ORACLE Sent by: ml-errors 09/30/2003 03:14 PM Please respond to ORACLE-L Hi, Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day 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: COBOL TO ORACLE
You can also Execute SQL directly from Oracle using the precompilers - No need to export the data and use SQL Loader. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, September 30, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Subject:COBOL TO ORACLE Hi, Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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: Data denormalisation seems some attractive
Stephane, From the limited information available, I will take a stab at what seems to be going on here. I don't think there are really 8 entities here first of all, at least not for the details given. No mention is made of the person being paid the commission, who the sale was too, the items sold, etc. It would appear that there is a commission entity. When it comes to commission types though, I don't understand why there are 7 entities. What if a new commission type appears? Modify the model? This doesn't sound like a flexible solution. Please don't say it will never change: that statement has been rendered false too many times. :) Since I don't know what differentiates one type of commission from another, it's a little difficult to say just how to proceed from here. Keeping it simple, a single entity with sufficient attributes, some nullable, to capture all needed commission type info. I thought about mocking up an example for this exercise, but it would be much easier and more productive if you could provide some relevant details on the commission types, with an explanation of why it's thought that separate entities are needed for each. Jared Stephane Paquette [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 07:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data denormalisation seems some attractive Hi, A co-worker of mine is working on a tiny project. Let say you have commission info and commission details, there are 7 types of commissions. The 7 types of commission shares common fields (from 100% to 30%) >From a conceptual point of view, you have 1 entity that is the commission info and 7 entities for the seven types of commissions since they all have private info (some fields are mandatory).. 1 commission must be 1 of the 7 types. Now at the physical level, info is write once, never update and read through a selective search criteria (agent number). Volume is about 8 000 000 commissions. You can have the physical model as the conceptual model. That means you do not have any work for managing integrity but when reading you have more work to get the data. Or You can put all data in 1 table with all fields. When data is inserted you must managed integrity (some common fields are mandatory for 1 type of commission but not for another one) but reading is fast just 1 record to read. Since, I do not know what the future of this project is I recommended the other DBA to keep data normalized. And to do a benchmark if he really wants to denormalize. Your opinions please. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Describe privilege on procedures packages
This link to AskTom may help. http://tinyurl.com/p7o1 -Original Message- Sent: Tuesday, September 30, 2003 12:29 PM To: Multiple recipients of list ORACLE-L (Reposting from yesterday morning since I had no takers! :) Hello, I wanted to give another user access to view my procedures packages (just DESC capability), but it seems that the only way for him to be able to DESC them is for me to grant execute. Is this correct?? (I guess I have never had this situation before, it just seems surprising if there is no way to grant a read-only privilege). Thanks! _ Get MSN 8 Dial-up Internet Service FREE for one month. Limited time offer-- sign up now! http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Jackson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rothouse, Michael 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: Separate Indexes and Data
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Separate Indexes and Data From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/09/30 Tue PM 02:09:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Separate Indexes and Data -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Separate Indexes and Data the defrag paper was written back in 1998 I believe. Uniform extents were a good solution pre-9i. We use them here on our I haven't been following this thread closely, but why are uniform extents no longer good for 9i? Kyte recommends using auto-segment management Actually, the qualifier from Mr. Kyte is to use system-managed LMTs when you not know how big your objects will become (Ch 3, p19). I don't think this is a blanket statement not to use uniform extents. Our DB tables grow linearly (near enough anyway) to correctly estimate storage requirements for at least a fiscal year. Granted, there is a minimal amount of play involved, mostly revolving around how our business expects to be doing in the coming year. I'm much more concerned about fragmentation left from the creation and deletion of DB objects. With LMTs, it's one thing I don't have to worry about. I'm looking forward to LMTs in 9iR2! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Describe privilege on procedures packages
Yes, that's correct. Since the only privilege available on a code object is execute, it doesn't make much sense to allow a user to DESCRIBE the call interface if the user cannot run it. --- Gary Jackson [EMAIL PROTECTED] wrote: (Reposting from yesterday morning since I had no takers! :) Hello, I wanted to give another user access to view my procedures packages (just DESC capability), but it seems that the only way for him to be able to DESC them is for me to grant execute. Is this correct?? (I guess I have never had this situation before, it just seems surprising if there is no way to grant a read-only privilege). Thanks! _ Get MSN 8 Dial-up Internet Service FREE for one month. Limited time offer-- sign up now! http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Jackson 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!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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: Separate Indexes and Data
Hi! In VLDB environments, it is mostly cheaper to restore and recover the index tablespace datafile in case of block corruption. In my experience, I've been lucky and have been able to get rid of corruptions that way, but I'm sure some people have worse experiences, especially when redologs are corrupted as well. Anyway, rebuilding a huge index is much more expensive operation than recovering restoring a datafile (rebuild requires a lot of IO, CPU and temp space). With 9i, the recovery is even better, if you use RMAN - you just can restorerecover one single block is you want. There is one nice exception - if the corruption occurs in a local index partition, it is possible to rebuild only this particular partition, without need to recover anything. (Partitioning can be considered alsi as a high availability feature, in addition to performance improvements). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 8:34 PM I'd be very interested to know how many people have their index tablespaces on a different backup schedule from their data tablespaces. If so how different? What happens when a media failure occurs and you must restore from backup? You would need to have on hand and apply more redo logs to make the database current. I understand the argument proffered is separating indexes and data can mean that when physical corruption of the file happens to an index tablespace then all one needs do is to offline, drop, drop and rebuild the index tablespace. I admit I have not tried off-lining the tablespace first, but you cannot normally drop a tablespace which is being used to enforce referential integrity. If off-lining the tablespace first does work, I can see someone trying to do the rebuild with the database available and having duplicate records in the parent tables and records without parents in the child tables. On the size of the segments: The paper entitled How To Start Defragmenting and Start Living or something like that strongly advocated uniform extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall. However the paper Never mentioned what to do when an object that used to fit nicely into the 128k extent category now more properly belongs to the 4M category. If you move the data, large holes are left in the other tablespace, and while this does not impact Oracle performance, it does mean that your physical backups are larger than necessary. I am in the process of migrating from uniform to autoallocated extents. This means extents of different sizes share the same tablespace. The extent sizes being multiples of each other. This removes the argument about not having indexes and data in the same tablespaces due to their different sizes. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 29, 2003 8:10 AM To: Multiple recipients of list ORACLE-L Thomas, It *is* a good idea to separate index data from heap data into different tablespaces. But the reason isn't solely to eliminate I/O competition. Even if I/O competition isn't an issue for you (and the OFA Standard doesn't say that it will be), then it's *still* a good idea to separate your index data from your heap data, for reasons including: * Index segments have different backup and recovery requirements than their corresponding heap segments. For example, as Peter mentioned, if you have an index block corruption event, then it's convenient to just offline, kill, and rebuild an index tablespace. If the indexes and data are mixed up in a single tablespace, this is not an option. Another example: If you construct your backup schedule to make media recovery time a constant, then you probably don't need to back up your indexes on the same schedule as you back up your heaps. But unless they're in different tablespaces, this isn't an option either. * Index segments are usually smaller than their corresponding heap segments. Using separate tablespaces allows you to use a smaller extent size to conserve disk storage capacity. I don't think I ever wrote that you need to put indexes and their corresponding tables/clusters on separate disks, but you do need to be *able* to do that if your I/O rates indicate that you should. For the original OFA Standard definition, please see section 3 of the document called The OFA Standard--Oracle for Open Systems, and section 5 of Configuring Oracle Server for VLDB, both available for free at www.hotsos.com. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Thomas Day Sent: Monday, September 29, 2003 9:05 AM To: Multiple recipients of list ORACLE-L My struggle is not with the directory layout
RE: COBOL TO ORACLE
Like Thomas Day said, Oracle is an rdbms and COBOL a programming language. You can use Sql*Loader to load flat files into Oracle or use COBOL programs with embedded SQL, you'll need to use Oracle Pro*Cobol to precompile the COBOL source before compiling them. The last time I've used Designer it was 2 years ago and I do not remember any support for transforming flat files to an ERD. Anyway, it would probably be a bad thing, I've seen applications do a 1 to 1 mapping between files and tables. The result was not good... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Thomas Day Sent: Tuesday, September 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Er ... No. COBOL is a programming language. Oracle is a relational database manager. The data used in a COBOL program can be stored in a variety of ways. It's even possilbe to have a COBOL program using data from an Oracle database. I'm not aware that Designer can translate COBOL file definitions into entities; however, if you know COBOL and Oracle it should be fairly straightforward. Muqthar Ahmed Muqthar.Ahmed To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @decoratetoday.c cc: om Subject: COBOL TO ORACLE Sent by: ml-errors 09/30/2003 03:14 PM Please respond to ORACLE-L Hi, Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
LOB Storage
All, I'm being given a requirement to store a BLOB column in the database. I'm being told that the average size of the file (it's a PDF) is 12,000 K. I'm assuming that I should store this column in a separate tablespace from the table data. If I use an LMT tablespace, what should I use for the uniform allocation size? Should I use 12,000 K or something larger to store one PDF per segment? Am I all wrong here? thanks in advance Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Data denormalisation seems some attractive
Hi Jared, Here are more details. One commission detail must be one of the types: manager override (12 fields) first year commission (15 fields), renewal service fee (10 fields), charge back (9 fields), vesting payment (1 field), subsidy (2 fields), supplementary commission (2 fields) sales bonus (3 fields), deferred commission (12 fields) I just talked to the concerned DBA, those are coming from a mainframe system and there is nothing we can do about themeven if some types are strange : For example, the manager overrided type must be linked to 1 of 4 specific types.In my mind an override is not a type but just an attribute of a type, on the mainframe system it is considred as a type. Also, it seems that they are changing some rules so I'll wait to se how my colleague is doing. Thanks Stephane -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 2:38 PMTo: [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: Re: Data denormalisation seems some attractiveImportance: HighStephane, From the limited information available, I will take a stab at what seems to be going on here. I don't think there are really 8 entities here first of all, at least not for the details given. No mention is made of the person being paid the commission, who the sale was too, the items sold, etc. It would appear that there is a commission entity. When it comes to commission types though, I don't understand why there are 7 entities. What if a new commission type appears? Modify the model? This doesn't sound like a flexible solution. Please don't say it will never change: that statement has been rendered false too many times. :) Since I don't know what differentiates one type of commission from another, it's a little difficult to say just how to proceed from here. Keeping it simple, a single entity with sufficient attributes, some nullable, to capture all needed commission type info. I thought about mocking up an example for this exercise, but it would be much easier and more productive if you could provide some relevant details on the commission types, with an explanation of why it's thought that separate entities are needed for each. Jared "Stephane Paquette" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 07:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data denormalisation seems some attractiveHi,A co-worker of mine is working on a tiny project.Let say you have commission info and commission details, there are 7 typesof commissions.The 7 types of commission shares common fields (from 100% to 30%)From a conceptual point of view, you have 1 entity that is the commissioninfo and 7 entities for the seven types of commissions since they all haveprivate info (some fields are mandatory)..1 commission must be 1 of the 7 types.Now at the physical level, info is write once, never update and read througha selective search criteria (agent number).Volume is about 8 000 000 commissions.You can have the physical model as the conceptual model.That means you do not have any work for managing integrity but when readingyou have more work to get the data.OrYou can put all data in 1 table with all fields.When data is inserted you must managed integrity (some common fields aremandatory for 1 type of commission but not for another one) but reading isfast just 1 record to read.Since, I do not know what the future of this project is I recommended theother DBA to keep data normalized.And to do a benchmark if he really wants to denormalize.Your opinions please.Stephane PaquetteAdministrateur de bases de donneesDatabase AdministratorStandard Lifewww.standardlife.caTel. (514) 499-7999 7470 and (514) 925-7187[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephane PaquetteINET: [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 command for other information (like subscribing).
RE: OFA myths was Re: BAARF
-Original Message- Paul Baumgartel Loney didn't write OFA, and methinks he was taking liberties with it. Perhaps. However I notice that DBCA in Oracle 9.2 creates a tablespace called INDX. http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm#sthref807 Oracle9i Administrator's Reference Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris Part No. A97297-01 Appendix G Optimal Flexible Architecture ... Separate Segments With Different Requirements Separate groups of segments with different lifespans, I/O request demands, and backup frequencies across different tablespaces. Table G-5 describes the special tablespaces that the Database Configuration Assistant creates for each Oracle database. ... Table G-5 Special Tablespaces ... INDX - Index associated with data in the USERS tablespace USERS - Miscellaneous user segments ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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).
Which server do u use for 9ias ?
At our university, we are planning to use 9iasR2 in production in a near future. What type of server do you people use for it? Does it need a lot of memory, more than 1 cpu ? It will mostly be used with modplsql procedure and we hope to deploy Discoverer. We are thinking about a X series IBM server with 4 Gig of memory. Would it be better to have 2 2.4Gh cpu or 1 3Gh cpu ? Any thought will be appreciated. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Louis BROUILLETTE 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: 8i OCP Net8 Exam
I also don't recall it being mentioned. Think naming,cman,mts,dispatchers etc. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: 29 September 2003 22:35 To: Multiple recipients of list ORACLE-L Subject: 8i OCP Net8 Exam Can anyone recall whether the Oracle Intelligent Agent figured on the Oracle8i OCP Network Administration exam? Couchman's practice exams have quite a few questions on Intelligent Agent, but when I check the official Test Content Checklist on Oracle's Education website, it isn't directly mentioned. Being the lazy slob I am, wouldn't want to study extra. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Niall Litchfield 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: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Title: Message Hi, We're still on 817 but I was wandering about those new automatic features (Automatic Undo Management, Automatic Segment Space management,..) how well they work ? Anybody using in production with 9i2 ? Stéphane -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent: Tuesday, September 30, 2003 5:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux You still can have row migration when pctfree is set too low. ASSM doesn't resolve that. But yeah, ASSM removes the pctused and freelist/group issues (and introduces others :) Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:09 PM Subject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux And why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic segment space management. Initial/next are resolved by using LMT, because that's what takes care of your extent sizes. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard FooteSent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux Hi Mladen, I can't help you with your problem, I haven't had the pleasure on NT or Tru64 but I just wanted to point out that you can't forget about PCTFREE even with ASSM. Cheers Richard - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 30, 2003 12:44 AM Subject: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux I have RDBMS 9.2.0.4 on RH 7.3 and Iexecuted the following command: create tablespace wizard datafile '/oradata/WIZ/wizard01.dbf' size 3072M reuse autoextend on next 1024M maxsize 16385m extent management local autoallocate segment space management auto; The whole system just hung, doing I/O like crazy. I was unable to killl one of the server processes which survived even shutdown abort, so I had to bounce thw whole box. No errors, no traces, no anything. Does anybody else have experience with this? Is there a known bug (not currently known to me) with a patch that I can install? I'd really like to use "SEGMENT SPACE MANAGEMENT AUTO" and forget about pctfree/pctused stuff. --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: RE: Separate Indexes and Data
My criticism of the defrag paper was that it did not address what to do when a segment grew large enough to belong in a tablespace with a larger uniform extent size. Moving the segment creates holes in its original tablespace which may close only in the fullness of time. Physical backups of the files comprising the original tablespace include this wasted space, this is compounded by how many days backup you keep available, and the number of copies of backups. You have chosen to get around the segment migration problem by using one very large extent size for everything. Don't you find 5M extents wasteful? What is your block size and the median number of used blocks for your segments outside of the system tablespace? How many such segments are there?. Also many of us use a single backup system to support multiple databases. The number of segments outside the system tablespace here is over 125,. Making all segments at least 5M in size would have a major impact on file sizes, which in turn would have a major impact on backup times, and possibly the size of the tape library needed. I'm interested in the flaws in autoallocate. Does it allocate the wrong amount of space? Ian MacGregor [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 30, 2003 10:50 AM To: Multiple recipients of list ORACLE-L the defrag paper was written back in 1998 I believe. Uniform extents were a good solution pre-9i. We use them here on our 8i databases. I stick with an uniform 5m extent size even though I have tables that can fit into 128k extents, but feel that the overall time savings by using 1 extent size makes up for this. unfortunately unlike most systems we cannot break up our tables into different tablespaces. We use transportable tablespaces to batch publish data to data marts. New tablespaces mean additional transportable tablespaces and more places for stuff to go wrong. I saw some posts on dejanews recently from some pretty experienced DBAs stating that there may be 'flaws' in auto-allocate leading to poor extent sizes that leads to fragmentation. I believe Rachel Carmichael made a post on here a few months back with the similiar experience(could be wrong). Due to even the 'small' chance of flaws in auto-allocate, Im thinking of waiting for version 10g before using it. Just to be safe. Not worth risking a defrag on a production system. From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/09/30 Tue PM 01:34:28 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Separate Indexes and Data I'd be very interested to know how many people have their index tablespaces on a different backup schedule from their data tablespaces. If so how different? What happens when a media failure occurs and you must restore from backup? You would need to have on hand and apply more redo logs to make the database current. I understand the argument proffered is separating indexes and data can mean that when physical corruption of the file happens to an index tablespace then all one needs do is to offline, drop, drop and rebuild the index tablespace. I admit I have not tried off-lining the tablespace first, but you cannot normally drop a tablespace which is being used to enforce referential integrity. If off-lining the tablespace first does work, I can see someone trying to do the rebuild with the database available and having duplicate records in the parent tables and records without parents in the child tables. On the size of the segments: The paper entitled How To Start Defragmenting and Start Living or something like that strongly advocated uniform extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall. However the paper Never mentioned what to do when an object that used to fit nicely into the 128k extent category now more properly belongs to the 4M category. If you move the data, large holes are left in the other tablespace, and while this does not impact Oracle performance, it does mean that your physical backups are larger than necessary. I am in the process of migrating from uniform to autoallocated extents. This means extents of different sizes share the same tablespace. The extent sizes being multiples of each other. This removes the argument about not having indexes and data in the same tablespaces due to their different sizes. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 29, 2003 8:10 AM To: Multiple recipients of list ORACLE-L Thomas, It *is* a good idea to separate index data from heap data into different tablespaces. But the reason isn't solely to eliminate I/O competition. Even if I/O competition isn't an issue for you (and the OFA Standard doesn't say that it will be), then it's *still* a good idea to separate your index data from your heap
Re: shared_Pool
I always get a difference , the first one gives a value greater than the second by 12MB I tried with different values of shared_pool_size . What am I doing wrong here ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 06:29 YES regards navneet - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 2:29 AM List, will the following two queries give the same value for the shared_Pool-size ? select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool'; and show parameter shared_pool_size I always get a difference , the first one gives a value greater than the second by 12MB I tried with different values of shared_pool_size . What am I doing wrong here ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Navneet Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LOB Storage
Hi! On which version you are? I would create fairly large extents, 64MB for example. LOBs are stored in chunks anyway, extent size doesn't matter that much. One issue is, if you create very large extent size, you might waste some space in LOB index which is a separate, smaller segment (but is always stored with LOB data segment in 9i). But your LOBs will work with 64k extent sizes as well, but that way you might lose some benefit on multiblock direct reads. Btw, if you use enable storage in row then LOB index entries are always stored in row, which means for smaller LOBs which don't fit inline, no LOB index lookup is needed (for large ones I believe there still is, because large LOBs can't be addressed with small inline inode structure). If your average lob size is in megabytes, I'd put them into 16k or 32k tablespaces, away from regular block size and create a different buffer pool for them - if you are using CACHE type lobs. That way they won't affect LRU mechanisms for normal data buffers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 11:24 PM All, I'm being given a requirement to store a BLOB column in the database. I'm being told that the average size of the file (it's a PDF) is 12,000 K. I'm assuming that I should store this column in a separate tablespace from the table data. If I use an LMT tablespace, what should I use for the uniform allocation size? Should I use 12,000 K or something larger to store one PDF per segment? Am I all wrong here? thanks in advance Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: v$sort_usage
Please , do tell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 02:34 Yes. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, September 29, 2003 4:55 PM To: Multiple recipients of list ORACLE-L Subject: v$sort_usage List, I am unable to find v$sort_usage in the 9i docs, though this synonym exists. Any idea why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: COBOL TO ORACLE
Unfortunately, you have to rewrite it to LISP or Oberon first. On Tue, 2003-09-30 at 15:14, Muqthar Ahmed wrote: Hi, Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Title: Message Not in production, but close to (as in two weeks). They seem to work just fine. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Stephane Paquette [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 4:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux Hi, We're still on 817 but I was wandering about those new automatic features (Automatic Undo Management, Automatic Segment Space management,..) how well they work ? Anybody using in production with 9i2 ? Stéphane -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent: Tuesday, September 30, 2003 5:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux You still can have row migration when pctfree is set too low. ASSM doesn't resolve that. But yeah, ASSM removes the pctused and freelist/group issues (and introduces others :) Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:09 PM Subject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux And why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic segment space management. Initial/next are resolved by using LMT, because that's what takes care of your extent sizes. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard FooteSent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux Hi Mladen, I can't help you with your problem, I haven't had the pleasure on NT or Tru64 but I just wanted to point out that you can't forget about PCTFREE even with ASSM. Cheers Richard - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 30, 2003 12:44 AM Subject: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux I have RDBMS 9.2.0.4 on RH 7.3 and Iexecuted the following command: create tablespace wizard datafile '/oradata/WIZ/wizard01.dbf' size 3072M reuse autoextend on next 1024M maxsize 16385m extent management local autoallocate segment space management auto; The whole system just hung, doing I/O like crazy. I was unable to killl one of the server processes which survived even shutdown abort, so I had to bounce thw whole box. No errors, no traces, no anything. Does anybody else have experience with this? Is there a known bug (not currently known to me) with a patch that I can install? I'd really like to use "SEGMENT SPACE MANAGEMENT AUTO" and forget about pctfree/pctused stuff. --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any
RE: COBOL TO ORACLE
On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote: Like Thomas Day said, Oracle is an rdbms and COBOL a programming language. COBOL *** WAS *** a programming language. Horse *** WAS *** basis of transport. You should have used past tense, Stephane. I'm not really that partial when it comes to horses, but having suffered COBOL, I would really leave it in the ancient past, together with Spanish Inquisition and crucifiction as a viable capital punishment. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: v$sort_usage
You should go to OTN and not use the local copy. For some reason, the 9.2 manual (Reference) left v$sort_usage out. On OTN you have 8.1.7 docs available as well, and it is the same thing. On Tue, 2003-09-30 at 16:49, [EMAIL PROTECTED] wrote: Please , do tell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 02:34 Yes. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, September 29, 2003 4:55 PM To: Multiple recipients of list ORACLE-L Subject: v$sort_usage List, I am unable to find v$sort_usage in the 9i docs, though this synonym exists. Any idea why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
Development environments
Here is a very interesting article on IDE's vs. code editors. http://www.infoworld.com/article/03/09/19/37FEcodeedit_1.html
RE: OFA myths was Re: BAARF
and the first thing that I do is to delete the INDX tablespace!!! As well as dropping the ORD* users, SCOTT, Tim, Tammy-Fae, Jim Bob and all the other crappy stuff that auytomatically gets installed. I try and get it back to the original 8.0 install!!! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 30, 2003 4:25 PM To: Multiple recipients of list ORACLE-L -Original Message- Paul Baumgartel Loney didn't write OFA, and methinks he was taking liberties with it. Perhaps. However I notice that DBCA in Oracle 9.2 creates a tablespace called INDX. http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm#sthref807 Oracle9i Administrator's Reference Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris Part No. A97297-01 Appendix G Optimal Flexible Architecture ... Separate Segments With Different Requirements Separate groups of segments with different lifespans, I/O request demands, and backup frequencies across different tablespaces. Table G-5 describes the special tablespaces that the Database Configuration Assistant creates for each Oracle database. ... Table G-5 Special Tablespaces ... INDX - Index associated with data in the USERS tablespace USERS - Miscellaneous user segments ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Separate Indexes and Data
Good question Ian. If anyone does have a different backup schedule for index tbs , I would be interested to know how they ensure that the index TBS do not have any data segments in them. Jared MacGregor, Ian A. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 10:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Separate Indexes and Data I'd be very interested to know how many people have their index tablespaces on a different backup schedule from their data tablespaces. If so how different? What happens when a media failure occurs and you must restore from backup? You would need to have on hand and apply more redo logs to make the database current. I understand the argument proffered is separating indexes and data can mean that when physical corruption of the file happens to an index tablespace then all one needs do is to offline, drop, drop and rebuild the index tablespace. I admit I have not tried off-lining the tablespace first, but you cannot normally drop a tablespace which is being used to enforce referential integrity. If off-lining the tablespace first does work, I can see someone trying to do the rebuild with the database available and having duplicate records in the parent tables and records without parents in the child tables. On the size of the segments: The paper entitled How To Start Defragmenting and Start Living or something like that strongly advocated uniform extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall. However the paper Never mentioned what to do when an object that used to fit nicely into the 128k extent category now more properly belongs to the 4M category. If you move the data, large holes are left in the other tablespace, and while this does not impact Oracle performance, it does mean that your physical backups are larger than necessary. I am in the process of migrating from uniform to autoallocated extents. This means extents of different sizes share the same tablespace. The extent sizes being multiples of each other. This removes the argument about not having indexes and data in the same tablespaces due to their different sizes. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, September 29, 2003 8:10 AM To: Multiple recipients of list ORACLE-L Thomas, It *is* a good idea to separate index data from heap data into different tablespaces. But the reason isn't solely to eliminate I/O competition. Even if I/O competition isn't an issue for you (and the OFA Standard doesn't say that it will be), then it's *still* a good idea to separate your index data from your heap data, for reasons including: * Index segments have different backup and recovery requirements than their corresponding heap segments. For example, as Peter mentioned, if you have an index block corruption event, then it's convenient to just offline, kill, and rebuild an index tablespace. If the indexes and data are mixed up in a single tablespace, this is not an option. Another example: If you construct your backup schedule to make media recovery time a constant, then you probably don't need to back up your indexes on the same schedule as you back up your heaps. But unless they're in different tablespaces, this isn't an option either. * Index segments are usually smaller than their corresponding heap segments. Using separate tablespaces allows you to use a smaller extent size to conserve disk storage capacity. I don't think I ever wrote that you need to put indexes and their corresponding tables/clusters on separate disks, but you do need to be *able* to do that if your I/O rates indicate that you should. For the original OFA Standard definition, please see section 3 of the document called The OFA Standard--Oracle for Open Systems, and section 5 of Configuring Oracle Server for VLDB, both available for free at www.hotsos.com. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Thomas Day Sent: Monday, September 29, 2003 9:05 AM To: Multiple recipients of list ORACLE-L My struggle is not with the directory layout OFA. It is with the mythical OFA that every DBA that I have talked to knows all about. Where ORACLE says that if you are a good and competent DBA you will separate your table data and your index data into two separate tablespaces so that one disk head can be reading index entries while another disk head is reading the table data. You've never run into that? Tim Gorman tim @sagelogix.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: ml-errorsSubject: Re: BAARF 09/28/2003 09:44
RE: Data denormalisation seems some attractive
So, you're not allowed to actually model this at all, but just port over some VSAM structures and call it a database. See the thread on COBOL. Jared Stephane Paquette [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 01:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data denormalisation seems some attractive Hi Jared, Here are more details. One commission detail must be one of the types: manager override (12 fields) first year commission (15 fields), renewal service fee (10 fields), charge back (9 fields), vesting payment (1 field), subsidy (2 fields), supplementary commission (2 fields) sales bonus (3 fields), deferred commission (12 fields) I just talked to the concerned DBA, those are coming from a mainframe system and there is nothing we can do about them even if some types are strange : For example, the manager overrided type must be linked to 1 of 4 specific types. In my mind an override is not a type but just an attribute of a type, on the mainframe system it is considred as a type. Also, it seems that they are changing some rules so I'll wait to se how my colleague is doing. Thanks Stephane -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 2:38 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Data denormalisation seems some attractive Importance: High Stephane, >From the limited information available, I will take a stab at what seems to be going on here. I don't think there are really 8 entities here first of all, at least not for the details given. No mention is made of the person being paid the commission, who the sale was too, the items sold, etc. It would appear that there is a commission entity. When it comes to commission types though, I don't understand why there are 7 entities. What if a new commission type appears? Modify the model? This doesn't sound like a flexible solution. Please don't say it will never change: that statement has been rendered false too many times. :) Since I don't know what differentiates one type of commission from another, it's a little difficult to say just how to proceed from here. Keeping it simple, a single entity with sufficient attributes, some nullable, to capture all needed commission type info. I thought about mocking up an example for this exercise, but it would be much easier and more productive if you could provide some relevant details on the commission types, with an explanation of why it's thought that separate entities are needed for each. Jared Stephane Paquette [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 07:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data denormalisation seems some attractive Hi, A co-worker of mine is working on a tiny project. Let say you have commission info and commission details, there are 7 types of commissions. The 7 types of commission shares common fields (from 100% to 30%) >From a conceptual point of view, you have 1 entity that is the commission info and 7 entities for the seven types of commissions since they all have private info (some fields are mandatory).. 1 commission must be 1 of the 7 types. Now at the physical level, info is write once, never update and read through a selective search criteria (agent number). Volume is about 8 000 000 commissions. You can have the physical model as the conceptual model. That means you do not have any work for managing integrity but when reading you have more work to get the data. Or You can put all data in 1 table with all fields. When data is inserted you must managed integrity (some common fields are mandatory for 1 type of commission but not for another one) but reading is fast just 1 record to read. Since, I do not know what the future of this project is I recommended the other DBA to keep data normalized. And to do a benchmark if he really wants to denormalize. Your opinions please. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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
RE: 8i OCP Net8 Exam
Thanks everyone for your input on this topic. Now if I can just get motivated. ;-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 30, 2003 3:40 PM To: Multiple recipients of list ORACLE-L I also don't recall it being mentioned. Think naming,cman,mts,dispatchers etc. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: 29 September 2003 22:35 To: Multiple recipients of list ORACLE-L Subject: 8i OCP Net8 Exam Can anyone recall whether the Oracle Intelligent Agent figured on the Oracle8i OCP Network Administration exam? Couchman's practice exams have quite a few questions on Intelligent Agent, but when I check the official Test Content Checklist on Oracle's Education website, it isn't directly mentioned. Being the lazy slob I am, wouldn't want to study extra. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: LOB Storage
Tom In this case, I would use a uniform extent size -- you know approximately how large the data is today. Since there is no measureable overhead for having multiple segments, I would go with something much smaller than a 12MB extent size -- 512K to 1MB, depending on what your OS read size is. Kevin Just Plain Certifiable -Original Message- Sent: Tuesday, September 30, 2003 4:25 PM To: Multiple recipients of list ORACLE-L All, I'm being given a requirement to store a BLOB column in the database. I'm being told that the average size of the file (it's a PDF) is 12,000 K. I'm assuming that I should store this column in a separate tablespace from the table data. If I use an LMT tablespace, what should I use for the uniform allocation size? Should I use 12,000 K or something larger to store one PDF per segment? Am I all wrong here? thanks in advance Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke 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).
A question for the hourlies out there...
Friends -- I find it weird that I've been consulting some 25 years and have never run into this situation, and really could use your two cents. Here's the deal. I am supposed to travel for a client. They have me on a plane Sunday, expect me to work M-F onsite *and possibly the weekend*, returning Monday. Now, if I get to the airport at 9AM for a flight at 11AM and arrives at 3PM for a client meeting at 4-6PM, how does that bill? M-F, I bill for hours onsite. If I work Sat/Sun, I bill for hours onsite... but what if I don't? My time isn't my own... I'm at the client's service... I'm not with my family... that's not time off... how does that bill? Monday, I get to the airport at 6AM for a flight at 8AM arriving back at 3PM... does that bill a full day, or just time in the air? TIA! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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).
Nested tables
I have developers that would like to use Oracle's nested tables capability. I have not dealt with this before, so I was wondering if I could get information from those that are using them. How stable are nested tables? Are there issues I need to worry about? I will be using this in an Advanced Replication Environment. The manuals say they support replicating nested tables, but do they really? Thanks, Rick Stephenson Oracle Database Administrator Ovid Technologies, Inc. [EMAIL PROTECTED] This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. 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. If you are not the intended recipient you are notified that disclosing, copying, forwarding or otherwise distributing or taking any action in reliance on the contents of this information is strictly prohibited.
RE: Off Topic: PC Firewall Recommendation
-- snip If you're feeling frisky, consider replacing the router/firewall with a PC (with 2 nics) running BSD or Linux. You can also find distros tweaked to act as a firewall/router - that's what I've done. -- snip The Linux distro I used was www.smoothwall.com (which is the similar to www.ipcop.com ) and I found that it worked very well. even on a sub 100MHz PC with 16MB RAM. Of course I had to load a customized module for IPSec bypass to allow me to connect to work using a Cisco VPN client. -Original Message- Sent: Monday, September 29, 2003 1:05 PM To: Multiple recipients of list ORACLE-L KENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September 29, 2003 9:05 AM said; I have a Dell 8200 with XP Prof. SP1. I would like recommendations as to a good firewall for this machine. XP has a firewall but it is not the greatest. ZoneAlarm on the desktop - free version or pay to upgrade to the pro version. Assuming you have a home network, you also want to buy a DSL/Cable router - which has it's own firewall built in. If you're feeling frisky, consider replacing the router/firewall with a PC (with 2 nics) running BSD or Linux. You can also find distros tweaked to act as a firewall/router - that's what I've done. FWIW, a friend of mine had his XP system plugged directly into his RR connection. Friend said he didn't need a firewall or router (I'm not into that security crap, I just want to play games). Friend has now had to reformat his box (and lost work) because his box was rooted, blasted and fubared within days of hooking it to the cable connection w/out a firewall. YMMV. ~brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suri, Deepak 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: COBOL TO ORACLE
Crucifixion is a perfectly viable form of punishment, but only for the first offense. Best thing the Romans ever done for us. Oh, yeah. If we didn't have crucifixion, this country would be in a right bloody mess. Rich Jesse, People's Front of Judea -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: COBOL TO ORACLE On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote: Like Thomas Day said, Oracle is an rdbms and COBOL a programming language. COBOL *** WAS *** a programming language. Horse *** WAS *** basis of transport. You should have used past tense, Stephane. I'm not really that partial when it comes to horses, but having suffered COBOL, I would really leave it in the ancient past, together with Spanish Inquisition and crucifiction as a viable capital punishment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8i OCP Net8 Exam
Dennis, Do you have good practice exams? I have found that the best preparation for the OCP exams are good practice exams. I have reached the point where I just skim through the material in the whatever book you use (probably only possible if you have some miles on the clock as a DBA) and then drive the in depth study from the practice exams. This way you are spending your time more focused and find out what exactly the OCP exam will expect from you vs. what some author would like to teach you or even what the correct answer is in reality. Also, many of these questions in the practice exams will appear in the actual OCP exam which builds your confidence while writing the actual exam. You will also find that there are several inaccuracies in the OCP exam that is directly inherited from the incorrect Oracle Education materials. If you have a good book then the author will appropriately point this out like Pete Sharman's Oracle 8i DBA Exam Cram book. Pete is an expert in this field and I personally wish that he would bring out his own Sherman guides for all the OCP exams as Pete has taught as an Oracle Education Instructor for many years. He is also a very experienced DBA that can relate what is correct in the real world to what the OCP exam expects from you, which is the key to passing the OCP exam. Good Luck! Faan PS: There are no questions on the IA in the Net8 Exam for 8i -Original Message- Sent: Tuesday, September 30, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Thanks everyone for your input on this topic. Now if I can just get motivated. ;-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 30, 2003 3:40 PM To: Multiple recipients of list ORACLE-L I also don't recall it being mentioned. Think naming,cman,mts,dispatchers etc. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: 29 September 2003 22:35 To: Multiple recipients of list ORACLE-L Subject: 8i OCP Net8 Exam Can anyone recall whether the Oracle Intelligent Agent figured on the Oracle8i OCP Network Administration exam? Couchman's practice exams have quite a few questions on Intelligent Agent, but when I check the official Test Content Checklist on Oracle's Education website, it isn't directly mentioned. Being the lazy slob I am, wouldn't want to study extra. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Faan DeSwardt 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
Re: x$ constructs and memory
Mladen: I am not sure where I am failing to understand you ;). First of all X$ objects are NOT tables, so there is no question of blocks or memory or dictionary cache. They are some C structures and their point in time (I am not finding a better word) values are exposed as table formats. That is what my understanding. I don't see any relation between them and dictionary cache.. AM I missing something? Regards, Gopal - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 2:24 AM Description of the X$ does reside in the dictionary cache, but those tables are entry points into the code. So, besides their description, they don't consume memory, i.e. their blocks aren't cached. On Tue, 2003-09-30 at 15:29, [EMAIL PROTECTED] wrote: I don't generally get too involved in the x$ stuff, just because it normally helps me very little in my DBA work. Nonetheless, I have been following this one somewhat, and if my understanding is correct, x$ tables are not actually responsible for consuming memory, they are merely a mechanism for displaying various structures internal to the kernel, many of which happen to be transient. Jared Orr, Steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 07:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: x$ constructs and memory Hi Steve and welcome back, Thanks for that detailed answer BUT... A practical question from the original post remains: What happens when these x$constructs begin to consume large amounts of memory? From your explanation I'm assuming that, beyond monitoring the SGA and PGA, memory consumption of individual X$ in-memory data structures is generally not something we need to worry about. How can we determine how much memory they actually consume? Are there any related tunable parameters of which we should be aware? Thanks, Steve Orr -Original Message- Sent: Monday, September 29, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Hi Daniel and list, There are two types of X$ row sources. X$ tables export in-memory data structures that are inherently tabular, and X$ interfaces that call functions to return data is non-tabular, or not memory resident. For example, the array of structs in the SGA representing processes is exported as the X$ table X$KSUPR. Not all of the struct members are exported as columns, but all of the rows are exported. There is a freelist, implemented as a header that points to the first free slot in the array, and a member of each struct to point to the next free slot. The 'process allocation' latch protects this freelist. The most obvious example of an X$ interface to return non-tabular data is X$KSMSP, which returns one row for each chunk of memory in the shared pool. (There are similar X$ interfaces for other memory heaps). As you may know, heaps are implemented as a heap descriptor and linked list of extents, and within each extent there is a linked list of chunks. So what is done is that when the X$ interface is queried these linked lists are navigated (under the protection of the relevant latch if necessary) an a array is built in the CGA (part of the PGA) from which rows are then returned by the row source. An example of an X$ interface that returns data that is not memory resident is X$KCCLE, which returns one row for each log file member entry in the controlfile. In fact, all the X$KCC* interfaces read data directly from the controlfile. Similarly, the X$KTFB* interfaces return LMT extent information - from the bitmap blocks (for free extents) and from the segment header and extent map blocks (for used extents). Some X$ tables have become X$ interfaces in recent versions, for example X$KTCXB and X$KSQRS. These correspond to the transactions and enqueue resources arrays respectively. The reason is that they are no longer fixed arrays. Instead they are segmented arrays that can be dynamically extended by adding discontiguous chunks of shared pool memory to the array. The freelists and latching for these arrays in unchanged however. All you will notice is that the ADDR column of the X$ output now returns addresses which map into your PGA rather than the SGA. In fact, that is in general a good way to work out whether you are looking at an X$ table or an X$ interface. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -Original Message- Daniel Fink Sent: Tuesday, 30 September 2003 1:10 AM To: Multiple recipients of list ORACLE-L I was sitting on a mountain here in Colorado, pondering Oracle optimization and an interesting scenario crossed my feeble
RE: Off Topic: PC Firewall Recommendation
Whatever you use go to https://grc.com/x/ne.dll?bh0bkyd2 and http://grc.com/lt/leaktest.htm for testing your firewall product and make sure that the basic stuff is configured correctly. Also want to check out the URL http://grc.com/lt/scoreboard.htm about various PC firewall products leaking and possible issues which certain versions. -f -Original Message- Sent: Tuesday, September 30, 2003 3:10 PM To: Multiple recipients of list ORACLE-L -- snip If you're feeling frisky, consider replacing the router/firewall with a PC (with 2 nics) running BSD or Linux. You can also find distros tweaked to act as a firewall/router - that's what I've done. -- snip The Linux distro I used was www.smoothwall.com (which is the similar to www.ipcop.com ) and I found that it worked very well. even on a sub 100MHz PC with 16MB RAM. Of course I had to load a customized module for IPSec bypass to allow me to connect to work using a Cisco VPN client. -Original Message- Sent: Monday, September 29, 2003 1:05 PM To: Multiple recipients of list ORACLE-L KENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September 29, 2003 9:05 AM said; I have a Dell 8200 with XP Prof. SP1. I would like recommendations as to a good firewall for this machine. XP has a firewall but it is not the greatest. ZoneAlarm on the desktop - free version or pay to upgrade to the pro version. Assuming you have a home network, you also want to buy a DSL/Cable router - which has it's own firewall built in. If you're feeling frisky, consider replacing the router/firewall with a PC (with 2 nics) running BSD or Linux. You can also find distros tweaked to act as a firewall/router - that's what I've done. FWIW, a friend of mine had his XP system plugged directly into his RR connection. Friend said he didn't need a firewall or router (I'm not into that security crap, I just want to play games). Friend has now had to reformat his box (and lost work) because his box was rooted, blasted and fubared within days of hooking it to the cable connection w/out a firewall. YMMV. ~brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suri, Deepak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Faan DeSwardt 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: COBOL TO ORACLE
Mladen, maybe it is the past for you but it is quite the present for me. We just decided between 2 packages (insurance industry): one in cobol using flat files on AS400 and the other one where all jobs are in cobol but the database is Oracle. We have choose the second one. So, in the next week, I'll install Oracle Pro*Cobol on the unix boxes and then support the people having precompilation problems. Youppi ! Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Tuesday, September 30, 2003 5:15 PM To: Multiple recipients of list ORACLE-L On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote: Like Thomas Day said, Oracle is an rdbms and COBOL a programming language. COBOL *** WAS *** a programming language. Horse *** WAS *** basis of transport. You should have used past tense, Stephane. I'm not really that partial when it comes to horses, but having suffered COBOL, I would really leave it in the ancient past, together with Spanish Inquisition and crucifiction as a viable capital punishment. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 question for the hourlies out there...
If you have to travel at the client's request / requirement, then you should be able to bill for your travel time, beginning with the time you arrive at the airport and ending with the arrival time. Any weekend work for the client should be billed for the time onsite. (You may want to consider billing the travel time at a reduced rate.) I would think that you would want to negotiate this with the client before you travel and put it in writing, so that there are no surprises at invoice time. Remember, the client is hiring your expertise and your time is valuable. My $.02 -Original Message- Bellow, Bambi Sent: Tuesday, September 30, 2003 5:09 PM To: Multiple recipients of list ORACLE-L Friends -- I find it weird that I've been consulting some 25 years and have never run into this situation, and really could use your two cents. Here's the deal. I am supposed to travel for a client. They have me on a plane Sunday, expect me to work M-F onsite *and possibly the weekend*, returning Monday. Now, if I get to the airport at 9AM for a flight at 11AM and arrives at 3PM for a client meeting at 4-6PM, how does that bill? M-F, I bill for hours onsite. If I work Sat/Sun, I bill for hours onsite... but what if I don't? My time isn't my own... I'm at the client's service... I'm not with my family... that's not time off... how does that bill? Monday, I get to the airport at 6AM for a flight at 8AM arriving back at 3PM... does that bill a full day, or just time in the air? TIA! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary W. Parker 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: COBOL TO ORACLE
Title: RE: COBOL TO ORACLE COBOL still lives and breathes, though, in many MANY shops (this one included). Just like the Mainframe, it won't go away easily or soon... I feel your pain, though, I lived through it too... and if I never have to figure out where an alter sends the program based on the data ever again I will die happy... worse than any goto around! April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 30, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: COBOL TO ORACLE On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote: Like Thomas Day said, Oracle is an rdbms and COBOL a programming language. COBOL *** WAS *** a programming language. Horse *** WAS *** basis of transport. You should have used past tense, Stephane. I'm not really that partial when it comes to horses, but having suffered COBOL, I would really leave it in the ancient past, together with Spanish Inquisition and crucifiction as a viable capital punishment. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: x$ constructs and memory
Hi Steve, The X$ interfaces do not use memory persistently, and the memory usage of the X$ tables is fixed and necessary to an instance. Thus memory growth is not possible. Memory growth is possible for the segmented arrays, which some of the X$ interfaces expose. However, it is very unusual, because the defaults are rather generous. If you query V$RESOURCE_LIMIT, you will normally see that the MAX_UTILIZATION falls way short of the INITIAL_ALLOCATION. Even if there is significant growth, it is unlikely to chew up more than a few M of shared pool memory, because the structures involved are each very small. (You do however need to worry about similar growth in the instance lock database in a RAC environment). To answer another question raised later in this thread ... the metadata for X$ objects is present in the library cache during a query and may be cached afterwards, but there is no corresponding metadata in the dictionary cache. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -Original Message- Steve Sent: Wednesday, 1 October 2003 12:49 AM To: Multiple recipients of list ORACLE-L Hi Steve and welcome back, Thanks for that detailed answer BUT... A practical question from the original post remains: What happens when these x$constructs begin to consume large amounts of memory? From your explanation I'm assuming that, beyond monitoring the SGA and PGA, memory consumption of individual X$ in-memory data structures is generally not something we need to worry about. How can we determine how much memory they actually consume? Are there any related tunable parameters of which we should be aware? Thanks, Steve Orr -Original Message- Sent: Monday, September 29, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Hi Daniel and list, There are two types of X$ row sources. X$ tables export in-memory data structures that are inherently tabular, and X$ interfaces that call functions to return data is non-tabular, or not memory resident. For example, the array of structs in the SGA representing processes is exported as the X$ table X$KSUPR. Not all of the struct members are exported as columns, but all of the rows are exported. There is a freelist, implemented as a header that points to the first free slot in the array, and a member of each struct to point to the next free slot. The 'process allocation' latch protects this freelist. The most obvious example of an X$ interface to return non-tabular data is X$KSMSP, which returns one row for each chunk of memory in the shared pool. (There are similar X$ interfaces for other memory heaps). As you may know, heaps are implemented as a heap descriptor and linked list of extents, and within each extent there is a linked list of chunks. So what is done is that when the X$ interface is queried these linked lists are navigated (under the protection of the relevant latch if necessary) an a array is built in the CGA (part of the PGA) from which rows are then returned by the row source. An example of an X$ interface that returns data that is not memory resident is X$KCCLE, which returns one row for each log file member entry in the controlfile. In fact, all the X$KCC* interfaces read data directly from the controlfile. Similarly, the X$KTFB* interfaces return LMT extent information - from the bitmap blocks (for free extents) and from the segment header and extent map blocks (for used extents). Some X$ tables have become X$ interfaces in recent versions, for example X$KTCXB and X$KSQRS. These correspond to the transactions and enqueue resources arrays respectively. The reason is that they are no longer fixed arrays. Instead they are segmented arrays that can be dynamically extended by adding discontiguous chunks of shared pool memory to the array. The freelists and latching for these arrays in unchanged however. All you will notice is that the ADDR column of the X$ output now returns addresses which map into your PGA rather than the SGA. In fact, that is in general a good way to work out whether you are looking at an X$ table or an X$ interface. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -Original Message- Daniel Fink Sent: Tuesday, 30 September 2003 1:10 AM To: Multiple recipients of list ORACLE-L I was sitting on a mountain here in Colorado, pondering Oracle optimization and an interesting scenario crossed my feeble mind. As I began to ponder this (I asked the resident marmot, but he must be a SQL*Server expert...), I came up with several questions. Where in memory (sga or other) do the x$ constructs reside? Some of them are 'populated' by reading file-based structures (control file, datafile headers, undo segments). Does this information reside in memory or is it loaded each time the x$ construct is accessed? What happens when these x$constructs begin to consume large
Re: x$ constructs and memory
Hi! Yep, I also think that x$ tables have nothing to do with row cache, instead their behaviour is hardcoded to Oracle executable. I did a simple test just in case (but I'm not sure whether it was sufficient), by parsing a select from x$kturd 10 times didn't see any big increases in v$rowcache stats. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 12:14 AM Mladen: I am not sure where I am failing to understand you ;). First of all X$ objects are NOT tables, so there is no question of blocks or memory or dictionary cache. They are some C structures and their point in time (I am not finding a better word) values are exposed as table formats. That is what my understanding. I don't see any relation between them and dictionary cache.. AM I missing something? Regards, Gopal - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 2:24 AM Description of the X$ does reside in the dictionary cache, but those tables are entry points into the code. So, besides their description, they don't consume memory, i.e. their blocks aren't cached. On Tue, 2003-09-30 at 15:29, [EMAIL PROTECTED] wrote: I don't generally get too involved in the x$ stuff, just because it normally helps me very little in my DBA work. Nonetheless, I have been following this one somewhat, and if my understanding is correct, x$ tables are not actually responsible for consuming memory, they are merely a mechanism for displaying various structures internal to the kernel, many of which happen to be transient. Jared Orr, Steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 07:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: x$ constructs and memory Hi Steve and welcome back, Thanks for that detailed answer BUT... A practical question from the original post remains: What happens when these x$constructs begin to consume large amounts of memory? From your explanation I'm assuming that, beyond monitoring the SGA and PGA, memory consumption of individual X$ in-memory data structures is generally not something we need to worry about. How can we determine how much memory they actually consume? Are there any related tunable parameters of which we should be aware? Thanks, Steve Orr -Original Message- Sent: Monday, September 29, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Hi Daniel and list, There are two types of X$ row sources. X$ tables export in-memory data structures that are inherently tabular, and X$ interfaces that call functions to return data is non-tabular, or not memory resident. For example, the array of structs in the SGA representing processes is exported as the X$ table X$KSUPR. Not all of the struct members are exported as columns, but all of the rows are exported. There is a freelist, implemented as a header that points to the first free slot in the array, and a member of each struct to point to the next free slot. The 'process allocation' latch protects this freelist. The most obvious example of an X$ interface to return non-tabular data is X$KSMSP, which returns one row for each chunk of memory in the shared pool. (There are similar X$ interfaces for other memory heaps). As you may know, heaps are implemented as a heap descriptor and linked list of extents, and within each extent there is a linked list of chunks. So what is done is that when the X$ interface is queried these linked lists are navigated (under the protection of the relevant latch if necessary) an a array is built in the CGA (part of the PGA) from which rows are then returned by the row source. An example of an X$ interface that returns data that is not memory resident is X$KCCLE, which returns one row for each log file member entry in the controlfile. In fact, all the X$KCC* interfaces read data directly from the controlfile. Similarly, the X$KTFB* interfaces return LMT extent information - from the bitmap blocks (for free extents) and from the segment header and extent map blocks (for used extents). Some X$ tables have become X$ interfaces in recent versions, for example X$KTCXB and X$KSQRS. These correspond to the transactions and enqueue resources arrays respectively. The reason is that they are no longer fixed arrays. Instead they are segmented arrays that can be dynamically extended by adding discontiguous chunks of shared pool memory to the array. The freelists and latching for these arrays in unchanged however. All you will notice is that the ADDR column of the X$ output now
probe database using OEM event or job
Title: probe database using OEM event or job Can someone help me with this? Running Oracle 9.2.0.3 under win2000 I have an application server that occasionally looses connectivity with the listener on the database server although other application servers have no problems connecting. I get error 'Fatal NI connect error 12535' I would like to setup an OEM event (user defined?) or user defined job that must run from the application server having the problem which will test the connection to the listener on the database server (could be like a tnsping XXX) and if it is unsuccessful, notify me via email, pager, etc. has anyone done this? Can it be done with a TCL script? Any samples appreciated? John Baylis Database Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada (604) 697-6476 (Office) (604) 313-6054 (Cell)
RE: RE: Separate Indexes and Data
But those holes of exactly the right size for new objects to fit into. Since you'll presumably move it once it gets about 1,000 extents or so that isn't a huge amount of space that's being wasted. Jay Miller Sr. Oracle DBA -Original Message- Sent: Tuesday, September 30, 2003 4:45 PM To: Multiple recipients of list ORACLE-L My criticism of the defrag paper was that it did not address what to do when a segment grew large enough to belong in a tablespace with a larger uniform extent size. Moving the segment creates holes in its original tablespace which may close only in the fullness of time. Physical backups of the files comprising the original tablespace include this wasted space, this is compounded by how many days backup you keep available, and the number of copies of backups. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: A question for the hourlies out there...
In States things are probably different, but in few European companies I've worked for, it's that you get paid for the hours you work (naturally), if you work on the weekends you get paid as well - if don't then you don't. If you arrive one day earlier for being able to start in the morning next day, they paid half a day for that or smth. Of course, it matters what you've negotiated in your contract. I hope this helped, Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 1:09 AM Friends -- I find it weird that I've been consulting some 25 years and have never run into this situation, and really could use your two cents. Here's the deal. I am supposed to travel for a client. They have me on a plane Sunday, expect me to work M-F onsite *and possibly the weekend*, returning Monday. Now, if I get to the airport at 9AM for a flight at 11AM and arrives at 3PM for a client meeting at 4-6PM, how does that bill? M-F, I bill for hours onsite. If I work Sat/Sun, I bill for hours onsite... but what if I don't? My time isn't my own... I'm at the client's service... I'm not with my family... that's not time off... how does that bill? Monday, I get to the airport at 6AM for a flight at 8AM arriving back at 3PM... does that bill a full day, or just time in the air? TIA! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: A question for the hourlies out there...
Bellow, Bambi wrote: Friends -- I find it weird that I've been consulting some 25 years and have never run into this situation, and really could use your two cents. Here's the deal. I am supposed to travel for a client. They have me on a plane Sunday, expect me to work M-F onsite *and possibly the weekend*, returning Monday. Now, if I get to the airport at 9AM for a flight at 11AM and arrives at 3PM for a client meeting at 4-6PM, how does that bill? M-F, I bill for hours onsite. If I work Sat/Sun, I bill for hours onsite... but what if I don't? My time isn't my own... I'm at the client's service... I'm not with my family... that's not time off... how does that bill? Monday, I get to the airport at 6AM for a flight at 8AM arriving back at 3PM... does that bill a full day, or just time in the air? TIA! Bambi. I usually bill per day, not per hour, but a couple of years ago I had a contract where I was spending 2 days every two weeks at a place considerably more remote from my home than my ususal contracts (something like 4 hours door to door). I was arriving at 11am, leaving the following day at 4pm and fully billing two days. You can argue, which is usually true, that you can read doc and write reports at the airport or in the plane. I have also been sent to Singapore by a French company, the day spent in the plane (business class) eating, watching movies and being pampered by stewardesses was invoiced at the usual rate. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Re: probe database using OEM event or job
Title: probe database using OEM event or job On unix you could do: while true; do tnspingALIAS out || mail [EMAIL PROTECTED] out; sleep 300; done; (obviously you have to replace ALIAS and e-mail address there) It will send you the tnsping output ifit happens to fail. (you'll get a failure message after every 300 seconds though). On windows, you could play around with %ERRORLEVEL% and goto cycles... You have to download sleep command though, Windows does not have such extraordinarily complicated scientific tool in standard package. Tanel. - Original Message - From: Baylis, John To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 2:14 AM Subject: probe database using OEM event or job Can someone help me with this? Running Oracle 9.2.0.3 under win2000 I have an application server that occasionally looses connectivity with the listener on the database server although other application servers have no problems connecting. I get error 'Fatal NI connect error 12535' I would like to setup an OEM event (user defined?) or user defined job that must run from the application server having the problem which will test the connection to the listener on the database server (could be like a tnsping XXX) and if it is unsuccessful, notify me via email, pager, etc. has anyone done this? Can it be done with a TCL script? Any samples appreciated? John Baylis Database Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada (604) 697-6476 (Office) (604) 313-6054 (Cell)
Re: COBOL TO ORACLE
Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. If you are using SQL*Loader make sure to check the log after load. For larger loadsi would suggest direct load. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? I wonder how a tool will take care of Implicit Redefinition/Multiple Record Structures unless the Developer/DBA mentions them somewhere. HTH GovindanK-Original Message- From: Muqthar AhmedSent: 9/30/2003 12:16:28 PMTo: [EMAIL PROTECTED]Subject: Re: COBOL TO ORACLEHi, Thanks Muqthar Ahmed DBA Author: Muqthar Ahmed INET: [EMAIL PROTECTED] . ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
Re: Big table, small table
Are you using any trunc functions while querying. Do this. SELECT column_name,count(*) from small_table group by column_name; Run this for all the tables. My guess is that atleast 30% of the rows in the small table is for the value that you gave. So the optimizer is forced to read the index first followed by data read. When you drop the index, it does a FTS. Hence it is faster. HTH GovindanK-Original Message- From: [EMAIL PROTECTED]Sent: 9/29/2003 6:01:55 AMTo: [EMAIL PROTECTED]Subject: Re: Big table, small tableI have five tables, three are 3 million rows, one is a little more than 1 million, one a little less than one million. All tables are structured the same, with the same indexing, just different types of data. There is a date column with a normal index. A query with a 'between' on the date column against the largest table screams. Any of the largest tables are acceptable performance. The smallest is extremely slow, while the million row table sits around for 20 minutes or so. If I remove the index from the million row table, I get acceptable results. All of the tables and in! dexes are analyzed. Why would taking an index off make this query faster? What doesn't the CBO know that not using an index is the best path? --- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 Phone: (352) 796-7211, Ext. 4033 Fax: (352) 754-6776 Email: Mailto:[EMAIL PROTECTED] http://WaterMatters.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 con! taining: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). . ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
Re: Separate Indexes and Data
You can always schedule a script which drops all table segments from index tablespaces ;) Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 01, 2003 12:44 AM Subject: RE: Separate Indexes and Data Good question Ian. If anyone does have a different backup schedule for index tbs , I would be interested to know how they ensure that the index TBS do not have any data segments in them. Jared "MacGregor, Ian A." [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 10:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Separate Indexes and DataI'd be very interested to know how many people have their index tablespaces on a different backup schedule from their data tablespaces. If so how different? What happens when a media failure occurs and you must restore from backup? You would need to have on hand and apply more redo logs to make the database current. I understand the argument proffered is separating indexes and data can mean that when physical corruption of the file happens to an index tablespace then all one needs do is to offline, drop, drop and rebuild the index tablespace. I admit I have not tried off-lining the tablespace first, but you cannot normally drop a tablespace which is being used to enforce referential integrity. If off-lining the tablespace first does work, I can see someone trying to do the rebuild with the database available and having duplicate records in the parent tables and records without parents in the child tables.On the size of the segments: The paper entitled "How To Start Defragmenting and Start Living" or something like that strongly advocated uniform extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall. However the paperNever mentioned what to do when an object that used to fit nicely into the 128k extent category now more properly belongs to the 4M category. If you move the data, large holes are left in the other tablespace, and while this does not impact Oracle performance, it does mean that your physical backups are larger than necessary. I am in the process of migrating from uniform to autoallocated extents. This means extents of different sizes share the same tablespace. The extent sizes being multiples of each other. This removes the argument about not having indexes and data in the same tablespaces due to their different sizes. Ian MacGregorStanford Linear Accelerator Center [EMAIL PROTECTED]-Original Message-Sent: Monday, September 29, 2003 8:10 AMTo: Multiple recipients of list ORACLE-LThomas,It *is* a good idea to separate index data from heap data into different tablespaces. But the reason isn't solely to eliminate I/O competition. Even if I/O competition isn't an issue for you (and the OFA Standard doesn't say that it will be), then it's *still* a good idea to separate your index data from your heap data, for reasons including:* Index segments have different backup and recovery requirements than their corresponding heap segments. For example, as Peter mentioned, if you have an index block corruption event, then it's convenient to just offline, kill, and rebuild an index tablespace. If the indexes and data are mixed up in a single tablespace, this is not an option. Anotherexample: If you construct your backup schedule to make media recovery time a constant, then you probably don't need to back up your indexes on the same schedule as you back up your heaps. But unless they're in different tablespaces, this isn't an option either.* Index segments are usually smaller than their corresponding heap segments. Using separate tablespaces allows you to use a smaller extent size to conserve disk storage capacity.I don't think I ever wrote that you need to put indexes and their corresponding tables/clusters on separate disks, but you do need to be*able* to do that if your I/O rates indicate that you should.For the original OFA Standard definition, please see section 3 of the document called "The OFA Standard--Oracle for Open Systems," and section 5 of "Configuring Oracle Server for VLDB," both available for free at www.hotsos.com.Cary MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming events:- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney- Hotsos Symposium 2004: March 7-10 Dallas- Visit www.hotsos.com for schedule details...-Original Message-Thomas DaySent: Monday, September 29, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LMy struggle is not with the directory layout OFA.It is with the "mythical" OFA that every DBA that I have talked to
locally managed autoallocate (was: Separate Indexes and Data)
Ive read the book. PCTINCREASE is basically set to 100% so the extent sizes double. Thats 'basically' how it works. I have seen some posts on dejanews saying it doesnt necessarily work this way and some people are finding large extent sizes with just a few extents and when tables are dropped this is leading to fragmentation. It hasnt happened to me, but the posts on dejanews were from some pretty good posters. So Im playing conservative. We also had one of the contributors here mention issues. I think Jonathan Lewis has explained the algorithm before, but it's also something that we have investigated here. The algorithm (ignoring some details) is: There will be 4 extent sizes used, 64K, 1M, 8M, 64M As long as object allocation is 1M or less, 64K extent sizes are used, When object allocation is between 1M and 64M, 1M extent sizes are used. When object allocation is between 64M and 1G, 8M extent sizes are used. When object allocation is more than 1G, 64M extent sizes are used. However, when you initially create the object, the extents are determined by figuring out the space allocated to the newly created object taking into account the INITIAL, NEXT, PCTINCREASE, MINEXTENTS storage parameters. So the object might start off with 1M extents instead of starting off with 64K extents. The algorithm is similar to the one outlined above but it is more complicated. The NEXT and PCTINCREASE seem to be ignored after the object is created. e.g. create table ... tablespace locally_managed_autoallocate storage (initial 1M next 512K minextents 15 pctincrease 0) ... ; Initial allocation will be 1M + (15 - 1) * 512K = 8M When you create the table, you will see eight extents, each of one megabyte. There are additional wrinkles, but I don't think the algorithm has bugs. I don't think that there really is fragmentation in the sense that an unused extent will remain unused forever. All extents will be in one of the 4 sizes mentioned above, and all are subject to reuse at some point. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Experiences setting OPEN_CURSORS for Java applications
Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [Oracle Server] - Layer 4 It does not parse Java source code and is not a code analyzer, however the tool will intercept all calls that an application makes on the JDBC API, analyze them and forward them onto the vendor driver. In this way the tool is transparent to the application and can be installed or removed without modification to the application code. I would not call it a traffic analyzer because to me that term implies that it sits on a network and analyzes network traffic much like an Intrusion Detection System might do. Regards, Craig Munday. At 04:11 AM 30/09/2003 -0800, you wrote: I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: probe database using OEM event or job
Hi, Can you just use the built in OEM event Database UpDown - though perhaps this only comes with the Diagnostics Pack for OEM. As for a user defined test - You could just do something like select user from dual and hope it comes back if it can't connect - I haven't tried this. However, I think you'll find that user defined tests use the agent which connects via BEQ rather than via the listener so this won't help that much. In the diagnostics pack you also have a listener SQLNet up down event You could also write all this in a batch / perl / windows script / whatever language. Have a look at Metalink notes to see all the events that are predefined: Note:69563.1 Subject: Overview of all the Event TCL files used by Enterprise Manager Note:69592.1 Subject: Quick reference of the events available in Enterprise Manager The following forum has good info on user defined events: From: Christian Lang 31-Oct-00 15:03 Subject: User Defined SQL Test As for the sleep command - get it as its the easiest way (and part of resource kit) However, there are some (obscure) ways to emulate this functionality, eg: 44. How to pause in a batch for a preset number of seconds? === You can use the MS-DOS CHOICE.COM command for the purpose as the example below demonstrates @echo off echo Testing a delay, starting at ... echo.| time | find /v new choice /c:. /t:.,5 /n Pausing for five seconds echo ending at ... echo.| time | find /v new The choice command was introduced with MS-DOS 6. If you have an earlier MS-DOS version you can use my similar CHOOSE.EXE from ftp://garbo.uwasa.fi/pc/ts/tsutlf16.zip. For pauses longer than 99 seconds see the item #64. For better understanding the CHOICE parameter values, see the end of item #40. Tom Lavedas points out that if one uses type nul | choice /c:. /t:.,5 /n Pausing for five seconds The piping of the output from the TYPE command into CHOICE acts to defeat keyboard entry for the wait period. Also see the later item How can I write a SLEEP command to pause for a certain time? for more on this question. 64. How can I write a SLEEP command to pause for a certain time? == If the delay you want is no more than 99 seconds the answer is fairly simple. All you need is the CHOICE command with appropriate options. For example the following batch pauses for ten seconds. You can, if you wish, break the wait by pressing the key b. @echo off choice /cb /t:b,10 /n nul rem ^^ use b as the a break the wait key For longer waits a loop is needed. The following batch sets a ten minute wait. Remove the line echo %count_% if you do not wish any progress report output. @echo off set count_=. set target_=... :_loop echo %count_% choice /cb /t:b,60 /n nul set count_=.%count_% if not %count_%==%target_% goto _loop :_end As so many items, parts of this one owe to the insights of Tom Lavedas, and parts are totally my own (un)doing. For this and other useful (?) batch tricks see: Resources NT batch specific news:alt.msdos.batch.nt http://groups.google.com/groups?oi=djqas_ugroup=alt.msdos.batch.nt UltraTech knowledge base http://www.ultratech-llc.com/Personal/Files/?File=ResKit.TXT JSI Windows NT/2000 Tips, Tricks, Registry Hacks and more... http://www.jsiinc.com/Reghack.htm#Tip%20Index NT/Win2k scripting - good on bat differences between NT and DOS http://www.seanet.com/~shardy/ntscript.html Resources batch general: Batfiles: The DOS batch file programming handbook and tutorial - good examples and hints / tricks http://home7.inet.tele.dk/batfiles/ DOS Batch Language: A personal view by Ted Davis - good intro for beginners http://131.151.112.77/~batch/batchtoc.htm news:alt.msdos.batch http://groups.google.com/groups?oi=djqas_ugroup=alt.msdos.batch Multilingual Batch Programs http://gearbox.maem.umr.edu/~batch/multilingual.html Programs by Prof. Timo Salmi - THE author of the alt.msdos.batch FAQ http://garbo.uwasa.fi/pc/ts.html and then search for tsbat67.zip 184193 Mar 8 11:16 A collection of useful batch files and tricks, T.Salmi HTH, Bruce Reardon -Original Message- Sent: Wednesday, 1 October 2003 9:54 AM To: Multiple recipients of list ORACLE-L On unix you could do: while true; do tnsping ALIAS out || mail [EMAIL PROTECTED] out; sleep 300; done; (obviously you have to replace ALIAS and e-mail address there) It will send you the tnsping output if it happens to fail. (you'll get a failure message after every 300 seconds though). On windows, you could play around with %ERRORLEVEL% and goto cycles... You have to download sleep command though, Windows does not have such extraordinarily complicated scientific tool in standard
RE:
Take Pepcid AC ... that might help in digestion.. Seriously your email should go to listguru @ fatcity.com -Original Message-From: Frits Hoogland [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 12:10 PMTo: Multiple recipients of list ORACLE-LSubject: SET ORACLE-L DIGEST 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: Experiences setting OPEN_CURSORS for Java applications
Thanks for the answer. Yep, it seems more like JDBC proxy with analyzing capabilities than a regular traffic analyzer which sits aside sniffs some packets. May I ask, how much time have you spent on writing such thing? I'm planning to write something similar, but on SQL*Net level... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 3:44 AM Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [Oracle Server] - Layer 4 It does not parse Java source code and is not a code analyzer, however the tool will intercept all calls that an application makes on the JDBC API, analyze them and forward them onto the vendor driver. In this way the tool is transparent to the application and can be installed or removed without modification to the application code. I would not call it a traffic analyzer because to me that term implies that it sits on a network and analyzes network traffic much like an Intrusion Detection System might do. Regards, Craig Munday. At 04:11 AM 30/09/2003 -0800, you wrote: I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using dimensions
Title: Using dimensions Got a link for this requirement in the manual? Raj -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 4:50 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Using dimensions Query rewriting to use materialized views requires dimensions to be defined. Tanel. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:14 PM Subject: RE: Using dimensions Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs? I have scannedTFM, but haven't STFW'd yet ... scared of too many hits. Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Scott Canaan [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Using dimensions Dimensions are data warehouse constructs. They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed. For example: a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, century. This is used for rollup reporting within the data mart. I don't see any good use of it in an OLTP environment, but I may be wrong. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 AMTo: Multiple recipients of list ORACLE-LSubject: Using dimensions I have tried, but haven't found a good example of how to _use_ a dimension in 9ir2. I defined one, but then sat clueless on what to do with it. Is it any good in an OLTP environment? (I smell the answer is a NO, but still) ... Any notes from your experience? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 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: Describe privilege on procedures packages
This was the closest i could get. set pagesize 60;set linesize 180;column position noprint;column sequence noprint;break on object_type skip 1;break on package_name skip 1;break on object_name skip 1;column object_type format A15 wrap;column package_name format A30 wrap;column object_name format A30 wrap;column argument_name format A30 wrap;column in_out format A10 wrap;column data_type format A15 wrap;column default_value format A10 wrap;column type_name format A10 wrap;column type_subname format A10 wrap;select b.object_type! ; ,a.package_name ,a.object_name ,a.argument_name ,a.position ,a.sequence ,a.in_out ,a.data_type ,a.default_value ,a.type_name! ; ,a.ty! pe_subname from user_arguments a ,user_objects b where a.position 0 and b.object_id = a.object_id order by b.object_type ,a.package_name ,a.object_name , a.position/ Create a procedure which will dbms_output this and grant execute priviliges on it.-Original Message- From: Gary JacksonSent: 9/30/2003 9:31:29 AMTo: [EMAIL PROTECTED]Subject: Re: Describe privilege on procedures packages(Reposting from yesterday morning since I had no takers! :) Hello, I wanted to give another user access to view my procedures packages (just DESC capability), but it seems that the only way for him to be able to DESC them is for me to grant execute. Is this correct?? (I guess I have never had this situation before, it just seems surprising if there is no way to grant a read-only privilege). Thanks! _ Author: Gary Jackson INET: [EMAIL PROTECTED] . ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
