Re: Sql Tuning Thoughts?

this question in nothing flat. Justin Cave At 10:24 AM 1/22/2004, Tracy Rahmlow wrote: This statement is from a batch program within a pl/sql procedure. (Also, I have many similar ones within the process) The policy table has approximately 6.2 million rows. The procedure is to incrementally(daily) build

RE: SLA/metrics for RFP for programming services

is a reasonable metric. If there are other things running at the same time, you'd have to qualify the requirement with the amount of CPU, RAM, I/O, etc that will be available to this new ETL process. Justin Cave It's not just a matter of defining that the deliverables are to be completed during X number of days

RE: kill session privilege

table, etc. I don't have much of a problem with a developer killing their own session even in production. Justin Cave Goulet, Dick [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

Re: ** OCP for 9i requirements

Justin Cave - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What

Re: oracle client on PC's

probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave

Re: SQL*Loader to load mutiple languages from the single

When the French characters are loaded properly, are you setting NLS_LANG to FRANCE_FRENCH.UTF8, or are you using a different character set? Justin Cave At 01:39 PM 1/2/2004, [EMAIL PROTECTED] wrote: Dear All, Happy New Year! I have to load both French and Japanese characters from the same

RE: SQL*Loader to load mutiple languages from the single

, you'll have to ensure that everything is encoded with the same character set. Justin Cave At 08:09 PM 1/2/2004, Sami wrote: Justin,Thanks for your reply. When the French characters are loaded properl I did set NLS_LANG=French -Original Message- Justin Cave Sent: Friday, January 02, 2004 7:14

Re: order by

some_constant . An integer constant would refer to the positional parameter but what about a real value which is not an integer ? Aside from SQL brain-teasers, I cannot imagine a practical use for ORDER BY constant real number. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L

RE: Career Advice

experience with a particular package than someone who has useful business knowledge and enough technology understanding to pick up the specifics. Justin Cave At 11:54 AM 12/17/2003, Saira Somani-Mendelin wrote: Sadly, I do agree with you, but it’s a silly world out there. You can’t get a job working

Re: connection pooling from an application server to oracle

, the important thing to remember is that each connection will be assigned to a particular user for the length of that user's transaction. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat

RE: Plan stability

, and hints are only suggestions, does that imply that the CBO can ignore plan stability? Justin Cave

Re: Plan stability

to the CBO or new Oracle functionality should cause the ideal plan to change, etc. If you want to force Oracle to use a particular plan, plan stability is orders of magnitude easier! Justin Cave Hi, list friends: We are using partition to archive history data in our production OLTP database. We

RE: Tuning help required

. Justin Cave At 02:49 AM 9/24/2003, you wrote: Before checking stats, execution plans and the like take a look at your query. I presume that it is generated, otherwise you would probably say that a date belongs to a month by using a BETWEEN the first and the thirty first rather than listing all the 31

Re: Restricting the size of a BLOB column

constraint on the table that looks at the number of bytes in the column. You could certainly do this with a trigger, but the constraint makes more sense to me. Justin Cave Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin

Re: how to make sql prompt like USER@DATABASE ?

Aboali --- Senior Software Developer Management Information Systems http://www.mis-kuwait.com Phone: +965.240.64.25 +965.240.67.98 +965.240.80.92 Ext. 235 Fax. +965.240.81.53 Cell. +965.790.31.65 Justin Cave Distributed Database Consulting

Re: ODBC through server side sql

up front, but it's well worth it IMHO, particularly for non-technical users. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Full table scan

indexes and then look up the value of col2 in the table. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: SQL*Net Connection under-performing

TRACE_LEVEL_SERVER=OFF TNSPING.TRACE_LEVEL=OFF NO sqlnet.ora exists on Database 2 4) NO process.dat , regid.dat exists in ORACLE_HOME/network/log Dir of ORACLE_HOME for Both Database 5) Multiple listener processes are Running for BOTH Databases Qs How may the issue be approached ? Justin Cave

RE: Global names

... Yes, you can. We create a dblink from dev to production, for example, when we need to refresh data. No problem, even with identical global names. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL

Re: Global names

. Junior developers? If the changing the database name requires code changes, then the duhvelopers need some remedial education. I fully agree. Unfortunately, my project can't really tell other projects to educate their developers. Thanks! Justin Cave Distributed Database Consulting -- Please

Global names

hearing about it. Thanks, Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Comparing between two tables

want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: strange SQL with TOAD

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave Distributed Database

Re: TNSPING another question

saying it couldn't find the host name before querying DNS. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: OT: Guidelines/Standards for supporting non-oracle

. Most mid-sized organizations could probably have a full-time Brio/ Crystal/ Access report writer if they walked around to a few managers and asked them about the reports they're assembling by hand now. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http

Re: Best way to store images in DB ?

it's well worth it. Justin Cave Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: [Q] MS ODBC for ORACLE driver connection problem!!

against Oracle 9. The recommend staying with the 8.1.7 Oracle client if you want to use their driver. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: ORACLE-Function problem

) Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: VC++ to Oracle connectivity without installing client

] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave Distributed Database Consulting -- Please see

Re: Relation Between Oracle Sessions

of opening a new connection to the database. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: secure connection

to the intranet. Well, in a medical environment, it's nice to be sure that patient data isn't flowing over the wire in plain text. I assume the same would be true in banking/ financial companies. Justin Cave Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message

Re: secure connection

Administrator's Guide from tahiti.oracle.com. It's got a chapter on setting up encryption and authentication at the SQL*Net layer. Justin Cave Distributed Database Consulting Any help would be greatly appreciated. Murat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: ODBC limits

send the HELP command for other information (like subscribing). Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Oracle InterMedia/Blob,Clob

an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave

RE: High values

PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave -- Please see the official ORACLE-L FAQ

Re: How to convert SQLSERVER DBS to ORACLE DBs

or less automagically. You can download it from OTN. Justin Cave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: multiple 8.1.7 db Migration Question

PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave -- Please see the official ORACLE-L

Re: Inserts are taking time !

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave -- Please see the official

Re: Inserts are taking time !

subscribing). Justin Cave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Serving BLOB from the database

. Is serving images from the database scalable? Yes. I've seen benchmarks that had interMedia faster than a standard file system in a three-tier configuration. Slightly slower in a two-tier configuration, but certainly scaling. Justin Cave -- Please see the official ORACLE-L FAQ: http

Re: Standby with TAF config. - How to ?

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave