RE: UTL_RAW and slowness

2003-10-26 Thread Craig Munday
://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

Re: UTL_RAW and slowness

2003-10-25 Thread Craig Munday
. Either would suit your purpose. Blowfish is there courtesy of Craig Munday. RC4 is there courtesy of a leak at RSA, but it's in the public domain now, so that doesn't matter anymore. Also check Pete Finnigans site: http://www.petefinnigan.com/ HTH Jared Jamadagni, Rajendra [EMAIL

Re: max open cursors exceeded

2003-10-21 Thread Craig Munday
(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

RE: Steps to convert a RAC to a single instance.

2003-10-03 Thread Craig Munday
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Re: Experiences setting OPEN_CURSORS for Java applications

2003-10-02 Thread Craig Munday
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

Re: AW: Experiences setting OPEN_CURSORS for Java applications

2003-10-02 Thread Craig Munday
the most benefits. Particularly database administrators, probably because they are the ones that are called upon to resolve the errors (such as ORA-1000) when they occur. Let me know if you would like a copy, and I'll email it privately to you - its too big to send to the list. Regards, Craig Munday

Re: Suggestion reg. encryption ??

2003-09-30 Thread Craig Munday
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

Re: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Craig Munday
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

Re: Experiences setting OPEN_CURSORS for Java applications

2003-09-30 Thread Craig Munday
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

Re: Suggestion reg. encryption ??

2003-09-29 Thread Craig Munday
to provide further information if you need it. Regards, Craig Munday. At 10:34 PM 28/09/2003 -0800, you wrote: Hi List, Application desc: Something similar (not exactly) to a payment gateway ; java/oracle 9iR2 will be used to develop it; need to store credit card numbers (encrypted

RE: OFA and Shared Storage

2003-09-22 Thread Craig Munday
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: What is a large database?

2003-09-22 Thread Craig Munday
-- 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

RE: wrapping packages

2003-09-21 Thread Craig Munday
a line containing: UNSUB ORACLE-L (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

Re: tunning an index built

2003-09-18 Thread Craig Munday
). -- 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

Re: Oracle's use of Indexes

2003-09-18 Thread Craig Munday
Craig, Just out of interest, what type of application is running on the database? I was just wondering why you were not using the plan stability features in 8i on your production database. Regards, Craig Munday. At 05:45 AM 2/06/2003 -0800, Craig Healey wrote: OK, I'm confused. Maybe it's

RE: AW: RMAN Backup to tape or disk (SAN) ???

2003-09-18 Thread Craig Munday
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

RE: RMAN in NOCATALOG mode?

2003-09-18 Thread Craig Munday
containing: UNSUB ORACLE-L (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

Oracle Press OCP exam guide frustrations

2003-09-16 Thread Craig Munday
to expect? Does anyone know of any other resources I might be able to use? How are the OCP exam guides published by Sybex? Any help would be greatly appreciated. Regards, Craig. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat

RE: RE: Oracle Press OCP exam guide frustrations

2003-09-16 Thread Craig Munday
to expect? Does anyone know of any other resources I might be able to use? How are the OCP exam guides published by Sybex? Any help would be greatly appreciated. Regards, Craig. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday INET: [EMAIL

Re: 9iAS vs. Weblogic and Websphere

2003-07-23 Thread Craig Munday
Hi, One thing that you will note about 9iAS is that it has a HUGE install footprint when compared to Weblogic and JBoss. Weblogic and JBoss are relatively simple to get going, ie. less configuration. Cheers, Craig. At 07:54 PM 22/07/2003 -0800, Ryan wrote: I havent dug into 9iAS yet, but I want

Re: Anyone from Australia

2003-06-18 Thread Craig Munday
for any improper, untimely or incomplete transmission. -- 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

RE: Oracle JMS

2003-06-18 Thread Craig Munday
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

RE: applying transactions

2003-06-13 Thread Craig Munday
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

RE: Configuring Oracle with RAID and OFA

2003-03-30 Thread Craig Munday
: UNSUB ORACLE-L (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

RE: Configuring Oracle with RAID and OFA

2003-03-30 Thread Craig Munday
: 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

RE: Configuring Oracle with RAID and OFA

2003-03-30 Thread Craig Munday
) Can you tell me exactly how you ensure you are part of the purchasing decisions? I'd love to find some new ways to be heard. Rachel --- Craig Munday [EMAIL PROTECTED] wrote: Rachel, There seems to be something inherently wrong with a DBA not getting to determine the layout of their disks

RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

2003-02-24 Thread Craig Munday
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

RE: encryption - peoplesoft 8 - oracle ??

2003-02-24 Thread Craig Munday
Title: storing credit card numbers in a database How will you protect the encryption key? There is one thing that most people seem to miss about the DBMS_OBFUSCATION_TOOLKIT and that is, it DOES NOTprovide key management. Having access to the encryption and decryption routines is only

RE: Question about RMAN and recovery scenario.

2003-02-10 Thread Craig Munday
a line containing: UNSUB ORACLE-L (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

RE: RMAN: I don't trust it

2003-02-10 Thread Craig Munday
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

RE: RAC on linux

2003-02-02 Thread Craig Munday
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

RE: a PL/SQL design question.

2002-12-09 Thread Craig Munday
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: a PL/SQL design question.

2002-12-09 Thread Craig Munday
m,job_name) VALUES (v_job_num,'stored_proc_name'); COMMIT; END; / -Original Message- From: Craig Munday [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: a PL/SQL design question. Hi, The ot

RE: Data Purging - Approaches

2002-10-15 Thread Craig Munday
Title: RE: Data Purging - Approaches ...and when the archiving takes place, make sure that the simplest file format is chosen to store the data. A file format that can be read with a text editor is probably a good choice - in ten years time, at least someone will be able to browse the file.

RE: count(*)

2002-09-22 Thread Craig Munday
still like to know the purpose of the count(*) and what verification it is performing? And also, why are there so many rows being inserted into the table. Cheers,Craig. -Original Message-From: Craig Munday [mailto:[EMAIL PROTECTED]]Sent: Friday, 20 September 2002 10:53 AMTo

RE: count(*)

2002-09-22 Thread Craig Munday
Title: RE: count(*) Hi Depending on how the transactions are defined I do not think that you will be able to achieve the throughput as the single row will be a point of serialisation. Cheers, Craig. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent:

RE: Stupid Bind Variable question

2002-09-22 Thread Craig Munday
Title: RE: Stupid Bind Variable question Hi, I suggest the following: - If a literal is always going to be the same value than it is marginal whether you use a bind variable for this. - I'm not sure why you are using the to_char to_date functions? You should be able to create a bind

RE: count(*)

2002-09-19 Thread Craig Munday
Title: RE: count(*) Hi, I am not sure if I have a solution for you, but I have a number of questions: 1) just for my interest, what type of application would need to insert 3-4 million records per hour? 2) Why does the application need to do the select count(*)? What verification is

RE: recording SQLPlus activity

2002-06-27 Thread Craig Munday
Title: RE: recording SQLPlus activity Ray, The integration problems you seem to be having sounds like the problem is more with the cowboys...errrdevelopers :-) Or with the processes and procedures in your development group. I would have thought that with a hundred or so developers it

RE: recording SQLPlus activity

2002-06-26 Thread Craig Munday
in the same user, we cant tell who. 3. Audit: what audit can I turn on? thanks. Ray From : Craig Munday [EMAIL PROTECTED] Reply-To : [EMAIL PROTECTED] To : Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject : RE: recording SQLPlus activity Date : Mon, 24 Jun 2002 18:08:20 -0800

RE: recording SQLPlus activity

2002-06-24 Thread Craig Munday
Title: RE: recording SQLPlus activity Ray, Why would you want to record every SQL statement that your developers issue? Are they just using SQL*Plus or some other language? Cheers, Craig. -Original Message- From: Ray Gordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 25 June 2002

RE: Cost vs Rule

2002-03-13 Thread Craig Munday
Title: RE: Cost vs Rule Bill, If you really want to use CBO I would have thought that the plan stability features of Oracle would be sufficient to squash any argument about predictability. I have not used these myself, but they seem to have been included because of the need to guarantee

RE: ORA-01000: maximum open cursors exceeded

2002-02-27 Thread Craig Munday
Title: RE: ORA-01000: maximum open cursors exceeded Sam, That sounds like a huge number of cursors, does the Java application really have 7500 cursors open at any one time? I too have found that some Java applications have required a large number of open cursors but this is only because the

RE: Limiting RMAN backup size

2002-02-06 Thread Craig Munday
TIA, I suggest reading the section of the manual on Back Sets. I've included the link below for you. Cheers,Craig. http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76990/rmanconc.htm#443835 -Original Message-From: Sona [mailto:[EMAIL

RE: RMAN Incremental backups.

2002-02-06 Thread Craig Munday
Title: RE: RMAN Incremental backups. Can someone explain why incremental backups are only valid in archivelog mode? I don't think this is correct and the manual states that consistent incremental backups are possible. I took the quote below from the Oracle 8i Recovery Manager Users Guide and

Temporal or Time-Oriented Databases (was auditing tables)

2002-02-03 Thread Craig Munday
Title: Temporal or Time-Oriented Databases (was auditing tables) The thread on auditing tables and the mention of temporal or time-oriented databases prompted me to ask about a design problem that has recurred on different projects for me. Seeing as this problem has occurred multiple times I

RE: formatting in SQLPLUS

2002-02-03 Thread Craig Munday
Title: RE: formatting in SQLPLUS Or try. set pagesize xxx where xxx is the number of lines per page. -Original Message- From: Dennis M. Heisler [mailto:[EMAIL PROTECTED]] Sent: Monday, 4 February 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: formatting in

RTFM questions (formally RE: PL/SQL)

2002-01-28 Thread Craig Munday
Title: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help

RE: Limits on referential integrity

2002-01-21 Thread Craig Munday
Title: RE: Limits on referential integrity Jared and Dennis, In the J2EE world I've found that developers can have a little trouble with RI because in some cases it is not the developer that is performing the DML operations - the J2EE container does this for them when using Container

RE: Server mode

2002-01-20 Thread Craig Munday
Bunyamin, Are the clients connected directly to the database or do they connect through some type of application server like JBoss or Web Logic? If they are connecting to an application server then youcan get away with a lot less connections and use dedicated servers. The theory goes that

RE: DBA Experiences with Oracle and RAID 0+1

2002-01-14 Thread Craig Munday
Title: RE: DBA Experiences with Oracle and RAID 0+1 If I remember correctly, I do not think that chapter covers RAID. There is a good white paper on implementing RAID for Oracle at http://www.quest.com/whitepapers/Raid1.pdf Cheers, Craig. -Original Message- From: Ken Janusz

RE: Criteria for handoff from development

2002-01-06 Thread Craig Munday
Title: RE: Criteria for handoff from development Dennis, Just a couple of more points that I've found useful in the past: 1) Start looking at the CORE software requirements (assuming requirements or use cases are being developed) so you can get a good understanding of what the system is

RE: Criteria for handoff from development

2002-01-06 Thread Craig Munday
Title: RE: Criteria for handoff from development Hi, Just a word of warning about enforcing foreign key relationships. Depending on the Java technology that you use, you might find it impossible to implement foreign keys. For example, some EJB application servers do not understand

RE: Criteria for handoff from development

2002-01-06 Thread Craig Munday
Title: RE: Criteria for handoff from development Dennis, I would be very careful with RAID 5 if your system is going to be very write intensive. There is a very good white paper on implementing RAID for Oracle on the www.quest.com site. Here is the link for your reference

RE: Encryption - Question about the key

2001-12-18 Thread Craig Munday
Title: RE: Encryption - Question about the key Jared + Ragendra, One option that you might have is to use a Host Security Module HSM such as those from Thales or Eracomm (cheaper PC based card ~$2000AUD). Essentially this is a piece of cryptographic hardware connected to your host that