RE: stress testing
Henry: John is partially correct. SAR, in concert with VMSTAT / IOSTAT, will provide you with a wealth of information. However, something is missing from the equation here. LoadRunner will generate scattered statistics on overall performance of an application (sorry: biased because Compuware has a better tool), but misses the mark on what other things could affect overall application performance. For example, are you doing to perform a virgin load test where no one is on the network and nothing but this application is running on the client? What about other traffic that would affect overall performance throughout your enterprise network? What about other applications/activities running on the client machines performing the load test. Only then will you have an effective measurement of application performance in the real world. If you truly have to use LoadRunner, get some software that can measure Network Performance as it relates to the load test and as it relates to general network traffic. The load test should account for other activity being performed such as email, backups, file transfers, reading of documents, etc. Otherwise, your numbers will be skewed. Good luck. 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- John Kanagaraj Sent: Friday, January 02, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Subject:RE: stress testing Henry, Sar is a better tool than vmstat/iostat as it collects a broad range of information. Specifically, sar -q should show up CPU queueing and swapping, and sar -v will show up file/process table overflow issues that may occur during stress testing. IMHO, sar is quite underutilized ( had a paper on this last IOUG, but couldn't go and present it :( John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Poras, Henry R. [mailto:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 10:54 AM To: Multiple recipients of list ORACLE-L Subject: stress testing We are planning on running some stress tests on a PeopleSoft/Oracle/Solaris system starting next week (using LoadRunner). I have never gone through a formalized stress test before (most of my stress is brought about informally). So far I am planning to gather statspack information, and periodically get vmstat from the OS. Is there anything else that I should collect? Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. 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: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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
RE: Can't connect MTS from remote.
Generally, 12545 means that something in the connection string for shared environments is missing, the listener.ora, tnsnames.ora and sqlnet.ora contain conflicting parameters, or the init.ora MTS parameters do not match the listener.ora. I would make sure that you can ping the server remotely and that you can TNSPING the server as well. If not, your .ORA settings are inconsistent. 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- Wendry Sent: Tuesday, December 30, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject:Can't connect MTS from remote. Dear all, II have set up MTS on my environment (oracle 8.1.6.0.0), but I can't connect through remote computers. The error is ora-12545 : target or host doesn't exists. My init.ora regarding to MTS goes like this. mts_dispatchers = (PROTOCOL=TCP)(dispatchers=10)(sessions=20) mts_max_dispatchers = 25 mts_servers = 5 mts_max_servers = 30 I also add clause (SERVER = SHARED) on all tnsnames.ora files. I have also tried to use 2 listener namely listener_mts which I set to port 1522, I use this especially to handle the MTS connection. So I add in my init.ora Local_listener = mts1 And in my tnsnames.ora mts1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server2000)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = sheet.almi.net) (SERVER = SHARED) ) ) I still can't connect to the database with message of can't establish connection for this type of server. So I omit the (SERVER = SHARED) part. I can connect, but the connection is DEDICATED instead of MTS. I know this by querying SERVER column of V$session and there's no entry on V$circuit. V$shared_servers shows 5 entry. Is there anyone has experience like I have? Please give me some input here. Thank you all in advance. Regards, Wendry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry 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: Apps 11.5.9 Disater Recovery Site
Ron: I would definitely not suggest ignoring adpatch. Should you actually need to use this DR site and something went wrong, Oracle may not offer you any help. If rsync can offer you 100% replication than I would try it and validate it. However, applications is a much different beast than just the database. File system names, node names, database names, tns names, userids, passwords, etc. are embedded within the code and are very difficult to change. It would be best to take a complete image copy of the database environment, the apps environment and then use adpatch and adadmin to verify the environment once completed. 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- Ron Thomas Sent: Tuesday, December 30, 2003 6:35 PM To: Multiple recipients of list ORACLE-L Subject:Apps 11.5.9 Disater Recovery Site I've been charged with bringing up a disaster recovery site, so time to hit the books again as a lot has changed since the last time I did this. Looking for resource recommendations (FM to read, white papers, etc). Sticky part of this is it is an Applications 11.5.9 installation. The database end of it should not be too difficult (8.1.7.4, soon to be 9.2.0.4), but the applications file system is modified by the adpatch utility which adpatch requires a database connection to function. I can think of 2 ways to get around this requirement. 1. set the two_task to point to a live test system, and run adpatch force using the c and g drivers. The d driver would not need to be run since the changes will come over via the archive logs. 2. ignore adpatch utility completely and use rsync. Suggestion, comments? Thanks,. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas 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: Performance tuning in complex environment
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. -- 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). 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: A brief detour....;-)
Good morning all:
Well some good news, especially for April Wells. I could not find the
TSO/CLIST version of the workshop (we removed it from the class and replaced
it with another complicated workshop from the Data Structures and PL/I
Exercise handbook), however, I think I found the PL/I version. I will have
to wait until next week when our instructors are back from Europe and I will
ping them.
Jared: Given that we don't like attachments, any ideas on how to post
this thing? Reply direct to me.
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-
Carel-Jan Engel
Sent: Tuesday, December 09, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: A brief detour;-)
Back in the early 80's at school we had a towers of hanoi running in PL/1
On Nixdorf 8820, a teletype with matrix printer, printing out the full
configuration after every move you made
Regards, Carel-Jan
-- There will always be another 10 last bugs --
At 07:24 9-12-03 -0800, you wrote:
Hate to say this but you are a bit late. I had my students at University
and here at Compuware create three to four different versions of the
Tower's
of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing,
recursion (yes it can be done), and others. I also had (yep had - lost
this) one for both PL/I and TSO/CLIST Dialog Manager VMS DCL. I actually
created screens where you could dynamically choose the number of pegs and
pieces. It also verified that you were putting smaller pieces on top of
larger ones (one of the core rules for Tof H).
Isn't programming great?
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-
Bobak, Mark
Sent: Monday, December 08, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject:A brief detour;-)
So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who
has
over 100 different implementations of the Towers of Hanoi solution, each in
a different language. Since he didn't have one in PL/SQL, I decided to
write one.
Here it is:
create or replace package hanoi
is
from_peg constant number := 1;
to_pegconstant number := 3;
using_peg constant number := 2;
procedure play(n number);
end hanoi;
/
create or replace package body hanoi
is
procedure do_hanoi(n number, from_peg number, to_peg number, using_peg
number)
is
begin
if(n 0) then
do_hanoi(n-1,from_peg, using_peg, to_peg);
dbms_output.put_line('move '||from_peg||' -- '||to_peg);
do_hanoi(n-1, using_peg, to_peg, from_peg);
end if;
end;
procedure play(n number)
is
begin
do_hanoi(n, from_peg, to_peg, using_peg);
end;
end;
/
This concludes this public service announcement. We now return you to our
regularly scheduled programming.
-Mark
PS Yes, it's a slow day;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bobak, Mark
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
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 brief detour....;-)
Hate to say this but you are a bit late. I had my students at University
and here at Compuware create three to four different versions of the Tower's
of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing,
recursion (yes it can be done), and others. I also had (yep had - lost
this) one for both PL/I and TSO/CLIST Dialog Manager VMS DCL. I actually
created screens where you could dynamically choose the number of pegs and
pieces. It also verified that you were putting smaller pieces on top of
larger ones (one of the core rules for Tof H).
Isn't programming great?
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-
Bobak, Mark
Sent: Monday, December 08, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject:A brief detour;-)
So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who has
over 100 different implementations of the Towers of Hanoi solution, each in
a different language. Since he didn't have one in PL/SQL, I decided to
write one.
Here it is:
create or replace package hanoi
is
from_peg constant number := 1;
to_pegconstant number := 3;
using_peg constant number := 2;
procedure play(n number);
end hanoi;
/
create or replace package body hanoi
is
procedure do_hanoi(n number, from_peg number, to_peg number, using_peg
number)
is
begin
if(n 0) then
do_hanoi(n-1,from_peg, using_peg, to_peg);
dbms_output.put_line('move '||from_peg||' -- '||to_peg);
do_hanoi(n-1, using_peg, to_peg, from_peg);
end if;
end;
procedure play(n number)
is
begin
do_hanoi(n, from_peg, to_peg, using_peg);
end;
end;
/
This concludes this public service announcement. We now return you to our
regularly scheduled programming.
-Mark
PS Yes, it's a slow day;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bobak, Mark
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: Any articles/books that take relational theory and make it en
Ryan: I think the presentation on data modeling may help you understand and explain thoroughly to your team. If not, I would obtain a copy of Robert Barker's CASE*METHOD - Entity Relationship Diagramming book. The Data Modeling Essentials book is very technical and often hard to follow for non-academics. Call if you have any questions. 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- [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 8:25 AM To: Multiple recipients of list ORACLE-L Subject:Any articles/books that take relational theory and make it english? I swapped emails with a member of the list and Im having trouble seeing how you can take 3NF, BCNF, etc... and turn that into DBA speak. One of the guys told me that BCNF essentially means you have a key that you can put a unique constraint on. Well that makes this much easier to understand. All my theory books just discuss theory. Anyone know some that split the difference. IE, not Codd, not CJ Date, Not the academic textbooks. Thanks. -- 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). 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: IOUG Live2004 session confirmation
Talked with Stan Yellott Friday. His is scheduling and confirming today. 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- Tanel Poder Sent: Monday, November 17, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject:IOUG Live2004 session confirmation Hi! Does anyone who submitted their abstracts to IOUG-A Live! 2004 remember when was the deadline for acceptance confirmation from IOUG-A? 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). 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: how can I make Oracle not use all processors in machine?
Helmut: I think (???) if you have MC Service Guard installed, you can specifically allocate CPUs for specific processes. For the SQL*Net stuff, not sure if you can limit these. 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- Daiminger, Helmut Sent: Monday, November 17, 2003 8:04 AM To: Multiple recipients of list ORACLE-L Subject:how can I make Oracle not use all processors in machine? Hi! We are currently discussing Oracle licensing issues. Due to the number of users, named user licensing is not an option for us. Our HP-boxes are having 10 processors each. Since the CPU's are 90% idle, we are thinking about limiting Oracle to only using 4 out of the 10 CPUs. Is this possible (i.e. via the parameter cpu_count)? The other 6 CPU's will then be used by other applications ion the box (e.g. BEA WebLogic etc.). This is 9.2 on HP-UX 11.11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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: Database Normalization
Funny you should ask for this definition. Boyce-Codd Normal Form (BCNF) * Formal definition: * Every determinant must be a candidate key * Stronger form of 3NF * 3NF: Every determinant of a non-key column must be a candidate key * Applies to tables with more than one candidate key * Candidate keys are alternatives to the chosen primary key 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: Monday, November 03, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject:Re: Database Normalization File: reply ive seen tom kyte say the same thing. normalize unless its bad for design and/or hurts performance. which is similiar to normalize until its inconvenient. you could have some real fun and try to explan the boyce-codd normal form from an academic text book :) From: [EMAIL PROTECTED] Date: 2003/11/03 Mon PM 01:34:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database Normalization List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared 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: dual
If you did not commit the inserts to dual, then everyone will only see one row. If you committed the data and still one row appeared, then you must have a row defined for dual. Suggestion: Don't add more rows to dual if you value your dba life. 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: Thursday, October 30, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject:dual List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : why do multiple inserts into sys.dual complete sucessfully when connected as sysdba, but a subsequent select * from dual show only 1 row ? -- 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). 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: proc to pl/sql
Actually there is. It is called a consultant. Because of the mush within 3GL languages, it would be extremely difficult for a tool to convert. 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- From: AK [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Subject: proc to pl/sql Is there any tool out there that can convert pro*c codeto pl/sql ? thanks, -ak 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.
RE: Tomcat
Does not really fit into their open source initiative. Anytime we mention Tomcat as a supported product for our tools, Oracle's prod. Management team cringes. They are not seeing between the lines that the app server has more stuff than most organizations desire; tomcat solves most requirements. However, for complete scalability, Oracle does win over Tomcat. Yet, the OpenSource community is adding features to Tomcat for that purpose. For product vendors, Tomcat is great because the cost for licensing is a big Goose Egg. 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: Thursday, October 30, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject:Tomcat I have the impression that Oracle isn't keen on supporting Tomcat with iAS. Instead, OC4J is supposedly more compliant with J2EE and is faster. How popular is Tomcat? Tomcat is being mentioned more and more often at our site, I am wondering whether we are headed for a collision at some time in the future. How does this all fit in with Oracle's Open Source and PHP initiative? Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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: DBA Support Database
There are tools on the market that discover that for you. They will detect what databases and what applications use them for you automatically. 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: Thursday, October 30, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Subject:DBA Support Database I was thinking about putting together a database that contains a list of DBAs, servers, databases, and applications. The database would be used by the Helpdesk and Management to see who is responsible for a given application or database when problems occur. I thought I would check first and see if anyone has already designed such a database and might be willing to share it. Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: dual
I have seen many databases crash, yes crash, when
dual had more than one row or less than one?
Why you say?
As someone pointed out, this was an internal table to the kernel so
Oracle used it as they felt. It
was and still is considered a heartbeat mechanism within the kernel. In other words, dont mess with it.
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-
From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003
2:05 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: dual
Do you think
it will work if it has no rows ?
Waleed
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003
1:44 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: dual
You may find this interesting.
Looks like a 'where rownum = 1' is
always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other
than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo on
10:42:05 dv03
10:42:05 dv03create table
jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from
jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table
jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03insert into
sys.dual values('Y');
1 row created.
10:42:05 dv03insert into
sys.dual values('Z');
1 row created.
10:42:05 dv03
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03select * from
sys.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03create table
jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from
jkstill.dual;
D
-
X
Y
Z
3 rows selected.
10:42:05 dv03
10:42:05 dv03drop table
jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03delete from
sys.dual;
1 row deleted.
10:42:05 dv03delete from
sys.dual;
1 row deleted.
10:42:05 dv03delete from
sys.dual;
1 row deleted.
10:42:05 dv03
10:42:05 dv03insert into
sys.dual values('X');
1 row created.
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03
10:42:05 dv03create table
jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from
jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table
jkstill.dual;
Table dropped.
10:42:05 dv03
[EMAIL PROTECTED]
Sent by:
[EMAIL PROTECTED]
10/30/2003 08:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:dual
List, here is a
rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
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).
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.
RE: Oracle pricing ain't going down
And this surprises you??? 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: Wednesday, October 22, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Subject:Oracle pricing ain't going down http://www.crn.com/sections/BreakingNews/dailyarchives.asp?ArticleID=45368 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: anyone have opinions on the future of the 'grid'?
Had to chime in here. Carly Fiorina put this in simple terms. Grid implementations for most organizations is a 5-9 year plan and must be started and well thought out BEFORE you do the work. Larry is assuming that you just change over and all is well. Larry forgot to mention the capital investments required for Grid. 10g does have MANY new features, however, only a small amount of the organizations will leverage them. And for reference, any organization that played with 10g's grid/rac implementations has had SIGNIFICANT support from Oracle. IOW: don't do this alone I have submitted a paper discussing Grid, its requirements, etc. for IOUG Live! 2004. Let's see if this gets approved. If so, is should shed some light on the reality of the Grid Kool-AID 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: Thursday, October 16, 2003 2:10 PM To: Multiple recipients of list ORACLE-L Subject:RE: anyone have opinions on the future of the 'grid'? Ain't necessarily so. We already have some customers using grid technology with 9iR2 and 9iAS, along with the toolkit that's available on OTN (whose name escapes me at the moment). These are very high end business clients (not government or academia) that the Advanced Technology Solutions group in Oracle Consulting has worked with, but I won't name them because I'm not sure if they're referenceable. I think one thing that a lot of people are missing around the 10g message is that an important part of any grid technology is self management capabilities (autonomics in grid terms). 10g makes huge strides in the manageability area, and that's useful to ANY Oracle customer, not just those who are looking at the grid side. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Friday, October 17, 2003 1:04 AM To: Multiple recipients of list ORACLE-L I was at the Wash DC Oracle conference yesterday and the key note address was about the future direction of Oracle. It was pretty positive about Grid technology and blade servers. Anyone out there have any opinions? It seems like this technology is probably several years away from being used in the business and government contracting world. Most places you see it are in academia. -- 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: Pete Sharman 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: anyone have opinions on the future of the 'grid'?
Actually Dennis is quite correct. Part of the architectural framework is that you treat disk like a service. All disk storage is sharable across the enterprise grid you configure. If you have multiple grids in place, you would have multiple disk architecture frameworks in place. Alternately, you could share the disk architectures to create a common, scalable grid. Unfortunately, Oracle has been very lax in discussing the financial requirements for the grid. Forget Oracle pricing folks -- think more about the cost to reconfigure your entire data center. 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: Friday, October 17, 2003 2:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: anyone have opinions on the future of the 'grid'? But that would require Oracle software to be installed on all the grids, don't you think? I'm really curious how they are going to pull this off. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 16, 2003 6:30 PM To: Multiple recipients of list ORACLE-L I think the assumption must be that all the computers on the grid are attached to a SAN. Does that seem reasonable? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 16, 2003 5:04 PM To: Multiple recipients of list ORACLE-L For database type stuff, one must wonder how the data itself can be handled by CPU resources scattered hither and yon. The answer comes from the fairly recent knowledge that, in our universe, every particle has a matching particle; and changing one of the particles results in a change in the other particle. Well, the solution to trying to shove data all over the grid becomes obvious: One need only establish central management of the matching particles that make up the CPU and memory of all the computers involved. Initially, this would seem to be a daunting task ... until we recall that Larry is God. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: 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). 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
RE: Financials and APPS password
April: Wanted to chime in on this one but didnt have time. The APPS password is generally secure within the DBA group, HOWEVER, it can be seen by almost everyone that has access to UNIX or Concurrent Manager. Why? Because it can be seen from the command line. Unfortunately, this portion of apps was not well protected. Oracle was working on a solution to this but it appears it will not be fixed until 12i or later. 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- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 8:40 AM To: Multiple recipients of list ORACLE-L Subject: Financials and APPS password Okay, anyone using Financials... E-Business suite... Oracle 11i... whatever you want to call it... I am trying to apply SOME kind of security to my databases. It appears that it is critical for everyone to be able to access production using the APPS id Finance and accounting people, developers, everyone. What does everyone else do in their setups? The newest reason is the need to run the new Mass Additions Trace which apparently requires that you use the apps id. We have found a way to set up any user with a read only version of what APPS has (since they have to be able to compile reportsin production and access production data live rather than a month old clone), but Oracle says that you need to run Mass Additions Trace as apps. Doesanyone let the entire company have the production apps user's password? 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 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. 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.
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: Cary's Book
Oracle10G at work. Database requires a bit of prodding before it decides to work. 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: Monday, September 22, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Subject:Cary's Book Fyi, I just received confirmation from Amazon that my pre-order was shipped. American Express made the following annotations on 09/22/2003 10:46:31 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow 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: IOUG April 18-22, Toronto
Everyone: Speaking as a Focus Area Manager, we are missing the following types of presentations: 1. Presentations for beginners, i.e.: the basics - too many of our presenters concentrate on the intermediate or advanced. Let me tell you that we WANT to see more beginner presentations. 2. Troubleshooting type presentations helping users diagnose both performance and development problems. 3. REAL Advanced presentations and not ones that you think are advanced. Comments returned over the past few years indicate that the advanced' presentations are not as advanced as stated. 4. Tighter quality sessions that offer concrete technical value and ROI for our audience. Should be enough 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 16, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Subject:IOUG April 18-22, Toronto I asked my manager if I can go, maybe I can present a paper. Now I just have to decide what topic to present on. I don't want to do something that is on the bleeding edge, I want to do something that would be useful to the largest number of people. I leave the marketing to Oracle Corp., they know the newer products best it seems to me. I am not a concepts person, I don't go by the product descriptions and features, I go by practical experience. (aka Trial by Fire) Right now we are still planning / testing a migration to 9iAS 9.0.2. on Windows (I know, no comments please), maybe I can do a paper on how to install, configure, secure, and manage 9iAS effectively. If you have any other suggestions, don't hesitate to mention them -- what would be most useful to you at your site? Do I ever want to go to this conference! Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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: IOUG April 18-22, Toronto
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). 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: Oracle survey
Everyone: In looking at this survey, this can be used for multiple purposes. One is to pulse the market, however question one can be used for license violations. Be careful how you answer. 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: Wednesday, September 03, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject:Oracle survey Someone asked about EMS, Oracle posted this: http://infopoll.net/live/surveys/s23243.htm Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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: Oracle client and DNS
Are you pinging with the IP address or the hostname? Second, TNSPING also relies on entries within the TNSNAMES.ora. Is that set up correctly? Was TNS configured to use DNS or not? 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: Monday, September 01, 2003 5:39 AM To: Multiple recipients of list ORACLE-L Subject:Re: Oracle client and DNS If you would be so kind to send us the tnsping output, then we'd be able to help :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 11:59 AM Having problems getting Oracle 8 client working with DNS. I can ping the server hostname from my Windows 2000 client, but I cannot tnsping it Do I need to do anything at the server end. The listener is running on the server. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn 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). 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: RE: Nature of Oracle-l has changed
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: 32 or 64?
The added benefit comes with technology's ability to address/reference disk/memory/etc. in the 64-bit address space. Additionally straight 64-bit computing offers some added performance versus the concatenation of two 32-bit words. Tim is correct in that some performance degradation can be experienced if not implemented properly. Now, several vendors, as Joe Testa indicated, are converting all binaries to 64-bit and will not support 32-bit any longer. HP, Oracle, Sun, etc. are some prime examples. Expect the conversion/migration to take some time as 32-bit apps are still out there and will not be changed for several years. 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: Monday, August 18, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject:Re: 32 or 64? There are no performance benefits from the software change; in fact, anecdotal evidence is that there might even be a hit, since we're now moving more data about (i.e. 64-bit integers instead of 32-bit integers), but that is certainly debatable. Some very simple testing with C programs on dedicated servers should be able to lay that to rest... Bigger SGA and PGA along with access to the latest and greatest (?) software *probably* falls into the category of a benefit, right? The reason it may not be a benefit is that then folks see the ability to add more RAM as an all-round panacea. There's something purifying about having to make do within limitations... Not aware of any specific bugs related to wordsize. By the way, switching between wordsize isn't that hard. Check out the script ?/rdbms/admin/utlirp.sql and the package UTL_RP and some related MetaLink notes... on 8/18/03 9:14 AM, Daniel Fink at [EMAIL PROTECTED] wrote: From a technical and business perspective, what are the reasons to migrate from 32-bit to 64-bit Oracle? Are there known bugs/problems with one version that are not present in the other? Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: What is _NEXT_OBJECT
This is a extremely valuable and irremovable object within the database that is essentially a pointer to the next object ID within the database data dictionary. Don't worry about it. 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: Monday, August 18, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Subject:What is _NEXT_OBJECT I recently had to install a couple of things to my 817 database so that I could get UTL_SMTP. I ran ORACLE\javavm\install\initjvm.sql and ORACLE\rdbms\admin\initplsj.sql as SYS and then followed up by use ALTER objectType to recompile all invalid objects. The only thing I have left is a object of name _NEXT_OBJECT of the type NEXT OBJECT, which has an N/A status. Googling for this gave me http://www.experts-exchange.com/Databases/Oracle/Q_20082312.html which was someone who was having some problems with his database and his _NEXT_OBJECT. I, however, don't seem to be suffering any visible ill-effects so far. What is this thing, and how do I fix it (and I don't really want to do a re-imprt per the experts-exchange web page.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung 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: IMP-00020: long column too large for column buffer size (22)
Once the file has been corrupted, there is no way to fix it. Hopefully you have a copy of the dmp file in another location on the Unix box that you can use to FTP in binary mode. If not, you must export the data again and then perform the proper FTP of the data to NT. 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- [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Subject:IMP-00020: long column too large for column buffer size (22) Hi All, One of our developer ftp'ed the export (dmp) file from UNIX to NT in ASCII mode. He didn't know that it supposed to be done in BINARY mode. Now, he ftp'ed the dmp file back to UNIX in ASCII mode and tried doing the import. Looks like dmp file has been corrupted and Import is giving the following error. IMP-00020: long column too large for column buffer size (22) IMP-00028: partial import of previous table rolled back: 16380 rows rolled back/ Is there any way to fix the dmp file. Any ideas? I searched the metalink and looks like there is no way to correct it. It is on HP-UX and oracle 8.1.7.4 I appreciate your help. Thanks. Best Regards, Prasad 860 843 8377 -- 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). 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: It's an Oracle Fun Friday!
Interesting web site that bigip... Picture of Larry with the annotation -- Coming Soon. Does this mean that Larry truly does not exist yet??? 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: Friday, August 08, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Just looking at netcraft.com to see what Oracle's running these days, when I noticed their netblock is owned by Oracle Datenbanksysteme GmbH. German Oracle First move before the SAP AG hostile takeover bid? Regards, Stephane Faroult Oriole -- 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). 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: what is BAARF?
The Web Site given to us by Cary, www.baarf.com, indicates that a spokesperson, similar to that of the Iraqi Information Minister, is being looked for. Thus, to forward the harmony of the organization, I nominate the following people for consideration 1. Gaja- Always a good spokesperson and we can have fun with him 2. Mogens - Could use his sarcasm to benefit the US audience. 3. Rachel Super Babe Carmichael - No explanation needed 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: Monday, August 04, 2003 3:35 PM To: Multiple recipients of list ORACLE-L According to http://www.baarf.com/ Battle Against Any Raid F BAARF was invented by James Morle on Wednesday the 4th of June, 2003, in the Grange hotel outside Birmingham while having a beer or two with Mogens Nrgaard. On the following day - Thursday the 5th of June, which happens to be the Danish national holiday celebrating our constitution - the Battle Agaist Any Raid Five initiative was announced jointly by James and Mogens in front of the UK Oracle User Group UNIX Special Interest Group meeting at the Grange hotel. Both announcers were careful to sport the Enough is Enough look (including arms folded across the chest) while delivering the message to about 80 delegates. It's important to note, that RAID-3, -4, and -5 are all included in the initiative, so the F in BAARF both stands for Five, Four, and ...err... Free. [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: what is BAARF? .com 08/04/2003 02:19 PM Please respond to ORACLE-L I see it here all the time. Any articles on it? Im assuming its some kind of storage system right? -- 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: 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: TOAD vs BMC's XRAY
Try DevPartnerDB from us (Compuware). You can create profiles of execution and compare one profile to another to optimize all of your code. Quite a cool product. 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, July 22, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject:TOAD vs BMC's XRAY Hi there, I am considering buying an administration tool and programmer's tool. The two I know are Toad and BMC's XRAY but since I do not know them very well I have difficulties deciding which of them is the best. What I need more is to tune the database, trace into time and CPU consuming SQLs, a procedure / trigger editor and debugger. Or maybe you know better tools than these two... any help will be greatly appreciated. Thanks in advance, Fermín Bernaus Berraondo Dpto. de Informática SAMMIC, S.A. [EMAIL PROTECTED] http://www.sammic.com Telf. +34 - 943 157 331 Fax +34 - 943 151 276 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus 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: AIX firmware changes - impact on Oracle software
You should not have to relink Oracle, however, I would make sure that Oracle has no issues with the release of the firmware being installed. I have seen several cases where disk firmware caused performance problems. Thank You Stephen P. Karniotis Strategic Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 08, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Subject:AIX firmware changes - impact on Oracle software Our systems people are getting ready to upgrade the firmware on one of my AIX 4.3.3 database servers. Will I need to relink the Oracle software? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, 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). 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: Oracle Technology Champion OTC
Peter: I am the OTC for both the eBusiness Suite and Technology tracks. If you know the products, you are 50% there. To pass the exams, you have to think like Oracle. Sounds silly, but there are some very-non technical portions of the exam that highlight product competitive issues against IBM and others. If you need specifics, call me. BTW: Say Hi to Stan Yellott for me. Tell him little FAM says HI Thank You Stephen P. Karniotis Strategic Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, July 02, 2003 11:59 PM To: Multiple recipients of list ORACLE-L Subject:Oracle Technology Champion OTC Hi has anyone sat the OTC exam before and did they find it difficult Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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). 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: Look's like Larry's at it again...
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: Oracle releases by the different platforms...
Title: IOUG Live 2003 Greg: Order is Solaris (development platform base) HP-UX, Linux Same time AIX, Windows Same time OpenVMS MVS Thank You Stephen P. Karniotis Strategic Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Loughmiller, Greg [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Subject: Oracle releases by the different platforms... does anyone have a reasonable idea about which Hardware platforms and their order that Oracle releases the RDBMS??? For example, SUN,IBM,HP,LINUX? SUN,HP?etc,etc Thanks in advance!! Greg 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.
RE: IOUG Live 2003
Title: IOUG Live 2003 If you are a member of the IOUG, you can use our userid/password to obtain access. If not, I am not sure how access is provided. Thank You Stephen P. Karniotis Strategic Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: IOUG Live 2003 Does anyone know when we (we-couldn't-go-to-conference types) get access to conference papers or download them? I had sent an email to address on homepage, but it has been only 2+ weeks of no reply. 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 ! 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.
RE: How to Uninstall apps11i
spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Gorman 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). -- Mladen Gogala Oracle DBA -- 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: Senthil Kumar D 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: 10i
OK everyone. Traffic cop time. Everyone that is a beta partner for 10i MUST KEEP THEIR MOUTH SHUT. Don't get anyone in trouble, please. We as partners pushed Oracle for these beta programs. Conversations like this only hurt the process. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, May 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject:10i Got my first look at the 10i beta last night. I can't tell you much about it except to say that looking at some of the new stuff h ;-) While I'm certain many of the new features will not work perfectly for several releases afterwards, they look very cool! RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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).
Localizing keywords from Oracle's SQL engine
Folks: Question has arisen here. Does Oracle localize SQL keywords or just objects? For example, if working in Kanji, will the SELECT keyword be localized or stay in English? Please elaborate. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com 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: Top 10 DBA Do's and Don'ts anyone - Here is my list,
This thread is great. Wish I was paying more attention to it. Here is one Don't Done rely on gui tools to accomplish any task. Great DBAs can endure the SQL to get the answer done. Good DBAs may opt for a GUI tool but will still use command line SQL first. Poor DBAs run for their GUI tools. Here is a DO Do always challenge yourself to find the solution. Do remember that other's have been through the same situation are available to help you. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Sunday, February 23, 2003 6:49 PM To: Multiple recipients of list ORACLE-L Subject:RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's. Too many PIOs could still be an issue. (I would say maybe Cary could speak to this, but I'd rather him spend that time on his book, which I'll be ordering as soon as it's available.) The others have their places as well. I wouldn't practice or preach that bind variables are always, always the right way (usually, but not always). Why not ASSM? Surely, there could be circumstances where ASSM is a good way, or at least ok. Do Use Bind Variables Do tune to Reduce Logical IO's Not Physical IO's. Don't Use ASSM Please consider, Robert, that I'm not challenging your list as these may be very good rules to live by. I don't usually take any 'rule' as hard and fast until I can test it, but there may be others reading the list that would benefit greatly to understand why these things should or should not be done. Thanks for your input, it helps us all learn. Darrell Landrum [EMAIL PROTECTED] 02/23/03 04:23PM Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your Production Database in ARCHIVELOG Mode #5 - Do Use Locally Managed Tablespaces #6 - Do Monitor Your Database #7 - Do Practice Recoveries #8 - Do Get Involved with User Groups and Other Resources #9 - Do Establish Standards and Change Control Processes #10 - Do Think Ahead Bonus! - Do tune to Reduce Logical IO's Not Physical IO's. (With regards to Cary!) Oracle Database Top 10 Don'ts #1 - Don't Waste Time Re-Organizing Your Databases #2 - Don't Use .Log or Other Common Extensions For Your Database File Names #3 - Don't Leave Your Database Open To Attack #4 - Don't Decide Against Hot Backups #5 - Don't Use ASSM #6 - Don't Forget the 80/20 Rule #7 - Don't Stack Views #8 - Don't Be a Normalization Bigot #9 - Don't Forget to Document Everything #10 - Do Not Use Products You are Not Licensed For. Bonus!! - Do Not Assume A Good or Bad Hit Ratio Means Anything Ok, anyone wanna comment? Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Darrell Landrum 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
Follow-up on Legato Registration Offer
Title: Follow-up on Legato Registration Offer Everyone: This is a letter from the IOUG to all the Alliance Partners. The Legato offer is subject to several stipulations. Please read and pass on. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Freeman, Kate [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 4:47 PM To: Alliance Mailing List Subject: Follow-up on Legato Registration Offer Dear GAP Leaders, Per our conversation this morning, below is the stipulation for the Legato Live! registration offer that some of you may have received. Stipulation: The non-member-rate discount of $480 (giving a price point of $895) is specific to Legato customers who have not attended Live! in the past two years (2001 and 2002). This promotion was targeted to non-member customers of Legato that had not attended our event in the last two years. The effort was to drive attendance from a new group of individuals not normally likely to attend our event. The email Legato sent did not indicate the stipulation that both IOUG and Legato had agreed upon together. Legato has been notified of this and will be sending follow up emails to correct any previous assumptions. Thank you, Kate --- You are currently subscribed to ioug-alliance as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] 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.
RE: Oracle Names Server 8.1.7 on HP 11
Zabair: Interesting problem. Where is the names server repository located? We have implemented the Dynamic Discovery Option of the Oracle Names Server. Additionally, we implemented multiple names servers and used the internal replication facility to keep them in sync. I will send you a white paper on how to configure this if you want. I believe it has already been posted by Jared (am I correct Jared) on the orafaq.net web site. Let me know. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Zabair Ahmed [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Names Server 8.1.7 on HP 11 We've currently got Names Server running on 4 host boxes. If one Names server is down, the client is configured to automatically attempt to connect to the next one in the list. We had a problem recently were, if we issued a tnsping from any of the clients we got the following message. TNS-03505 - Failed to resolve name This implies that our client PC is unable to resolve the name and hence was not able to connect to the database. Usually this implies that something is wrong with all our Oracle Names servers. Inorder to resolve this problem, I had to kill the Names Server on each of the 4 boxes and restart it. The Names servers had somehow lost connection to the Oracle Names repository database, although the servers appear to be attached to the database. I reckon we canreduce the chances of this problem occuring again, by adding a second Oracle Names database repository in our database cluster. This means, that if the NAMES servers lose connection to one repository, they can fall back on the second database without any loss of service. What have other people done with their Names Server and respository and do they see any draw backs with the above. Sorry for the long email. TIA With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs 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.
RE:
I have a different way of justifying it. It seems that everyone still assumes the one application = one database mentality. I have chosen to implement a different strategy. Multiple applications = one database. I see no reason to use the file server approach anymore. The issues with downtime, etc. outages are easily managed and performance is not squandered if the equipment is properly configured. So, your tact could be that larger disks can be used by multiple applications in a single database for better and more efficient utilization of resources. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, February 19, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject:RE: I'm curious as to how others with smaller databases deal with it as well.. You can't even buy under 18GB hard disks for some brands of servers anymore.. My production databases are all relatively small i.e. 5 GB - 7 GB, but yet I'd still want several independent physical disks to spread the I/O load... On test servers, the 'extra' space is easy to justify because you often create several instances for different purposes... But on your production box it can seem a bit excessive. I justify it in part by pointing to the increased flexibility afforded.. e.g. you could do cold backups to disk in minutes and then copy the backed up files to tape after the database is restarted. Wayne Straughn -Original Message- Sent: Tuesday, February 18, 2003 7:24 PM To: Multiple recipients of list ORACLE-L Hi, I was wondering how DBAs are coping with these new large disks that are availableyou can purchase 36gb, 72gb, etc. You can fit a whole database on one of these. But with all the performance and redundancy considerations, you wouldn'tso what do you do with the free space? Or how do you tell your bean counter that out of that 72gb you are only going to use 10gb so you need a couple of these? Rgds, Ken Heng -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Heng 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: Wayne Straughn 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:
Easy answer. Separate box for testing, integration testing, etc. OS upgrades are going to affect everyone so it's a one time push. As far as Oracle upgrades, I can install multiple versions of Oracle on the same box (wow, imagine that), have databases pointing to specific versions for usage, and then migrate back to a common version when all upgrades are complete. It's in the planning and the proper implementation. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, February 19, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject:RE: Stephen, Out of curiosity, how do you deal with application testing (or for that matter compatibility) when upgrading the Oracle version? Henry -Original Message- Stephen Sent: Wednesday, February 19, 2003 12:29 PM To: Multiple recipients of list ORACLE-L I have a different way of justifying it. It seems that everyone still assumes the one application = one database mentality. I have chosen to implement a different strategy. Multiple applications = one database. I see no reason to use the file server approach anymore. The issues with downtime, etc. outages are easily managed and performance is not squandered if the equipment is properly configured. So, your tact could be that larger disks can be used by multiple applications in a single database for better and more efficient utilization of resources. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, February 19, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject:RE: I'm curious as to how others with smaller databases deal with it as well.. You can't even buy under 18GB hard disks for some brands of servers anymore.. My production databases are all relatively small i.e. 5 GB - 7 GB, but yet I'd still want several independent physical disks to spread the I/O load... On test servers, the 'extra' space is easy to justify because you often create several instances for different purposes... But on your production box it can seem a bit excessive. I justify it in part by pointing to the increased flexibility afforded.. e.g. you could do cold backups to disk in minutes and then copy the backed up files to tape after the database is restarted. Wayne Straughn -Original Message- Sent: Tuesday, February 18, 2003 7:24 PM To: Multiple recipients of list ORACLE-L Hi, I was wondering how DBAs are coping with these new large disks that are availableyou can purchase 36gb, 72gb, etc. You can fit a whole database on one of these. But with all the performance and redundancy considerations, you wouldn'tso what do you do with the free space? Or how do you tell your bean counter that out of that 72gb you are only going to use 10gb so you need a couple of these? Rgds, Ken Heng -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Heng 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: Wayne Straughn 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
RE: Is this legit? Legato offers deep discount to IOUG-A LIVE
Everyone: This offer is not valid for everyone. Only people that have not attended IOUG Live for at least two years are eligible for this discount. And you must be a Legato customer. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, February 19, 2003 5:03 PM To: Multiple recipients of list ORACLE-L Subject:Is this legit? Legato offers deep discount to IOUG-A LIVE ---Original Message- Sent: Thursday, February 13, 2003 6:52 PM To: Harris Nguyen Event of the Year LEGATO SYSTEMS, INC. Planning to attend IOUG LIVE April 27 to May 1 at Walt Disney World, Florida In support of IOUG, LEGATO is pleased to extend a special time limited registration offer. Save $480 Off Registration when you use the LEGATO Offer Code! Simply: 1. visit http://www.badgeguys.com/reg/ioug2003/welcome.aspx 2. Register under the Non-Member Category 3. Input Offer code #DAA02 And be sure to mark Tuesday, April 29, 2003 on your calendar to hear Bill Maguire, CIO, LEGATO Systems present his keynote address. Join LEGATO and IOUG at IOUG LIVE! 2003 at the Education Conference for Oracle Users by Oracle Users For more info email us at [EMAIL PROTECTED] Offer expires 03/31/03. _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gunther Bishob 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:
containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda 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: Teradata banned from IOUG???
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).
Features of Oracle 8i Standard Versus Enterprise
Hi everyone: Need some help validating features in Standard versus Enterprise. Here is the List: 1. Online Index Build 2. Plan Stability 3. Materialized 4. Bitmap Indexes 5. Point-in-time tablespace recovery 6. Oracle Diagnostics Pack/Tuning Pack 7. Oracle Connection Manager From the Oracle8i Family document, these are listed as E/E options. I would have thought that PIT Tablespace recovery was a standard option. Please reply soon as some contracts depend on the answer. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com 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: Teradata baned from IOUG???
). 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).
Error processing 8i
Hi everyone: Looking for some advice on this topic. I have a web-based application, written in Java, BEA WebLogic and 8.1.7.0.0. I am looking for suggestions on how to perform error processing within both database triggers and stored PL/SQL code. Rachel C. (bless her heart) just called me (yes, only a few have my home phone) and suggested Database Pipes, however, I am ignorant as to how the app server/java front end would process the information contained in the pipe. I would love to use Autonomous transactions, but am unsure where they appeared in the RDBMS. Rachel indicated 8i, but we are not sure which version of 8i. Folks. I am looking for suggestions, as I have been tasked with re-writing an entire web application back end for efficient use of database resources. Thus, any suggestions would be great. TIA Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com 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: Slow SQL*Plus connect.
I would also verify that Oracle Trace is turned off and that within $ORACLE_HOME/otrace/admin there are no files. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, January 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject:RE: Slow SQL*Plus connect. How big is the listener log file?? do you truncate/rename it on regular basis?? just a thought. Sunil Nookala Dell Corp. -Original Message- Sent: Wednesday, January 22, 2003 4:09 AM To: Multiple recipients of list ORACLE-L Hi All, We have experienced a *very* slow connect time to a 9.0.1 database via SQL*Plus (and other apps as well) on a Win2K machine, and I was wondering if anybody else had experienced these slow connection times as well? We have also been asked lately by a number of customers about slow connection times, and to this point haven't found a solution for either ourselves or our contacts.. It's not a network issue as connection times take just as long locally. Connections can take up to around a minute (and the odd occasion a couple of minutes). No MTS is in use. OS's that I've heard about this on are Win2K, XP and NT so I'm also wondering if it may be a Win32 issue. Help! Cheers :) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- 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 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: 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: Sequences in 8.1.7 vs 9i
Yes. I agree that works. The problem is that there are over 2000 lines of code similar to the one I identified. I'm not interested in recommending changing all of it unless it's a conversion issue. Thanks for the help. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, January 23, 2003 2:54 AM To: Multiple recipients of list ORACLE-L Subject:RE: Sequences in 8.1.7 vs 9i Stephen, What about this, SQL Create sequence a; SQL Create table xxx(numtest number, testvalue varchar2(100)); SQL declare x number:=0; begin select a.nextval into x from dual; Insert into xxx values(x, 'TEST'); end; Rgrd, Sony -Original Message- From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 4:49 AM To: Multiple recipients of list ORACLE-L Subject: Sequences in 8.1.7 vs 9i Hello everyone. This one stumps me and I'm wondering if it is a bug that was resolved in 9i. Here is sample code. Create sequence a; Create table xxx(numtest number, testvalue varchar2(100)); Inside PL/SQL block and from SQL*Plus Prompt; Insert into xxx(numbest, testvalue) values (a.nextval(), 'TEST'); PL/SQL: ORA-02287: sequence number not allowed here Take out the () after the sequence name and all is well. Anyone experience something like this??? Application (not my code) written in 8i but imported the database into 9i. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email:[EMAIL PROTECTED] Web: www.compuware.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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: Sequences in 8.1.7 vs 9i
Daniel: You are a sick person. Not going to change the code that much. I need to evaluate the pain for the development team. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, January 23, 2003 10:40 AM To: Multiple recipients of list ORACLE-L Subject:RE: Sequences in 8.1.7 vs 9i Stephen, Wild-hair idea...could you create a function with the name nextval and use it to populate from the sequence? Dan Fink -Original Message- Sent: Thursday, January 23, 2003 6:49 AM To: Multiple recipients of list ORACLE-L Yes. I agree that works. The problem is that there are over 2000 lines of code similar to the one I identified. I'm not interested in recommending changing all of it unless it's a conversion issue. Thanks for the help. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, January 23, 2003 2:54 AM To: Multiple recipients of list ORACLE-L Subject:RE: Sequences in 8.1.7 vs 9i Stephen, What about this, SQL Create sequence a; SQL Create table xxx(numtest number, testvalue varchar2(100)); SQL declare x number:=0; begin select a.nextval into x from dual; Insert into xxx values(x, 'TEST'); end; Rgrd, Sony -Original Message- From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 4:49 AM To: Multiple recipients of list ORACLE-L Subject: Sequences in 8.1.7 vs 9i Hello everyone. This one stumps me and I'm wondering if it is a bug that was resolved in 9i. Here is sample code. Create sequence a; Create table xxx(numtest number, testvalue varchar2(100)); Inside PL/SQL block and from SQL*Plus Prompt; Insert into xxx(numbest, testvalue) values (a.nextval(), 'TEST'); PL/SQL: ORA-02287: sequence number not allowed here Take out the () after the sequence name and all is well. Anyone experience something like this??? Application (not my code) written in 8i but imported the database into 9i. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email:[EMAIL PROTECTED] Web: www.compuware.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto 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
Sequences in 8.1.7 vs 9i
Hello everyone. This one stumps me and I'm wondering if it is a bug that was resolved in 9i. Here is sample code. Create sequence a; Create table xxx(numtest number, testvalue varchar2(100)); Inside PL/SQL block and from SQL*Plus Prompt; Insert into xxx(numbest, testvalue) values (a.nextval(), 'TEST'); PL/SQL: ORA-02287: sequence number not allowed here Take out the () after the sequence name and all is well. Anyone experience something like this??? Application (not my code) written in 8i but imported the database into 9i. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com 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: Blank username in v$session
These correspond to the Oracle background processes. Look at V$PROCESS for the specific information on what is executing. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, January 16, 2003 8:09 PM To: Multiple recipients of list ORACLE-L Subject:Blank username in v$session Hi, I have an instance that is showing null in username, and schemaname = 'sys' in v$session, these are jdbc client not background processes. Anyone know why this is the case? Rgds, Ken Heng -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Heng 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: year 2059 problem
Rich Is it nice to have an operating system that works Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, January 02, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject:RE: year 2059 problem This is not true for all versions of VMS of 4.7+, whether on a 64-bit Alpha or 32-bit VAX. The standard VMS date is (was?) an 8-byte quadword whose value is relative to a base date of November 17, 1858 (Julian Day 240 -- Smithsonian Astrophysical Observatory's day zero) and is accurate until the year 3000-somethingth or 4000-somethingth. At that point, someone's going to finally have to reboot... Enjoy! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, December 30, 2002 6:56 AM To: Multiple recipients of list ORACLE-L UNIX stores time as amount of seconds passed since the 1st of January 1970. Since it is 32-bit value in modern Unices, it can hold up to 2,147,483,648 or approximatively 68 years. The counter overflows on 19th of January 2038 at 3:14:07 AM. People believe that all the hardware will be 64-bit by that time. But apparently it is not the case in Nepal. Oracle, internally can handle dates well beyond that. It is definitely W2K's deficiency. Any other 32-bit platform will have it too. Looks like the only solution is to move to a 64-bit platform/OS. For more information see: http://www.gsp.com/2038/ Hope it helps. Nic. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, December 30, 2002 6:28 AM This strange problem we are facing while implemting Oracle Based ERP at Nepal for asian paints. Nepal follows Hindu calender, as per the hindu calender the current year is 2059. as we try to install oracle 9i keeping year as 2059. oracle gets installed, but it is unable to create database.(OS is windows - 2000 server) even D2K is not running on 2059. we have tried different years and we found that till 2035 oracle is able to create database after 2035 it fails to create database. we have contacted oracle india also. they have said this is windows related problem. can any body help us out. Thanks in advance. -- 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). 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: Those Pesky Little Audit Files (ora_99999.aud)
Depending on the OS, we had created a batch job to simply delete these aud files after a specific amount of time. You may want to implement a similar process. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, December 26, 2002 8:59 PM To: Multiple recipients of list ORACLE-L Subject:Re: Those Pesky Little Audit Files (ora_9.aud) IIRC, these files are generated whenever someone logs in as sysdba or internal. I don't know of any way to stop them. --- Kevin Lange [EMAIL PROTECTED] wrote: I thought I had these files stopped but apparently not. Is there somone out there who can tell me how to stop the Audit files from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Larry E's new toy ?
DO you think if Larry has enough E toys that an F for failures may finally be seen? Perhaps C for closouts. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, December 17, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject:Larry E's new toy ? http://www.computerworld.com/hardwaretopics/storage/story/0,10801,76748,00.h tml Enjoy :) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- 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: Semi-OT: Pics from OracleWorld
Connor: Perfect pictures. Office looks cool. Perhaps Larry could sell Oracle in Linux there. Small platform, low cost. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, December 03, 2002 3:35 PM To: Multiple recipients of list ORACLE-L Subject:Semi-OT: Pics from OracleWorld Apologies for the delay (the digital camera died on the trip over) so apologies as well for the picture quality (all taken with a throwaway disposable camera). But, here they are... the rough bunch that is the Oracle Fatcity-L crew in San Francisco. http://www.oracledba.co.uk/sanfran.htm Cheers Connor = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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.com -- 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: IOUG 2003
Ah. The Queen is ranting again. Confirmations have not been sent out by the IOUG as of yet. Should be sometime within the next week or so. The setup for the speakers is to have us test the registration and to have it ready when the confirmations go out. I would assume that registration will be comparable to last year. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, November 27, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Subject:IOUG 2003 Okay, so I'm trying to get costs for conferences etc so my boss can budget for them. I go to the IOUG site and look at costs for the 2003 conference. I see register online so I click on it. They have it set up for speaker registration already, and ask for the email confirmation code you received. Has anyone on this list, who submitted an abstract, actually RECEIVED a response? Either acceptance or rejection? I haven't. How can you set something up to allow people to register if they don't know which way to register? Sheesh. I can't even register for the University Session I want because I don't know what status I should use when registering. Rachel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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.com -- 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: how to download all the openworld documents?
-U
MF4L(1IW1R:6)U=EO;BP@9ESV5M:6YA=EO;BP@=7-E+!OB!C;W!Y
M:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA;B!T
M:4@:6YT96YD960@F5C:7!I96YT(ES('-TFEC=QY('!R;VAI8FET960@
M86YD(UA2!B92!I;QE9V%L+B!)9B!Y;W4@:%V92!R96-E:79E9!T:ES
M(-O;6UU;FEC871I;VX@:6X@97)R;W(L('!L96%S92!N;W1I9GD@=AE('-E
M;F1EB!I;6UE9EA=5L2!B2!R97!L2!E+6UA:6PL(1E;5T92!T:ES
M(-O;6UU;FEC871I;VXL(%N9!D97-TF]Y(%L;!C;W!I97,N( T*#0I#
M;W)P;W)A=4@4WES=5MRP@26YC+B!H87,@=%K96X@F5AV]N86)L92!P
MF5C875T:6]NR!T;R!E;G-UF4@=AA=!A;GD@871T86-H;65N=!T;R!T
M:ES(4M;6%I;!H87,@8F5E;B!S=V5P=!F;W(@=FER=7-ERX@5V4@W!E
M8VEF:6-A;QY(1IV-L86EM(%L;!L:6%B:6QI='D@86YD('=I;P@86-C
M97!T(YO(')EW!O;G-I8FEL:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE
M9!AR!A(')EW5L=!O9B!S;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@
M6]U('1O(-AG)Y(]U=!Y;W5R(]W;B!V:7)UR!C:5C:W,@8F5F;W)E
(]P96YI;F@86YY(%T=%C:UE;G0N#0H-@
end
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: April Wells
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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.com
--
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: SQL Brain Teaser Challenge
Steve: Unfortunately, I didn't have time to experiment with this Teaser, but I was glad (real glad) to see that several great minds made the attempt. I could use all of you to help teach my students how to use their minds to solve problems like this. Ok. Now back to work folks. See you at OracleWorld Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, November 05, 2002 7:43 PM To: Multiple recipients of list ORACLE-L Subject:RE: SQL Brain Teaser Challenge I have a solution which doesn't rely on hints, but I am not very satisfied with it either. Innovative nonetheless. Another cool way to skin this cat. Thanks! Steve -Original Message- Sent: Tuesday, November 05, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Importance: High Orr, Steve wrote: What do I win? This was stated in the very first post... kudos. :-) At the moment you and Rich Jesse are tied but I'm still not very pleased with the solution. But unless somebody comes up with something better I'll box you up some kudos for shipping. (I afraid to ask but what are kudos anyway?) Thanks. Tentatively yours, Steve Steve, I have a solution which doesn't rely on hints, but I am not very satisfied with it either. It relies on a function, and performance will be likely to be dismal if your tree grows big. Here is the function : create or replace function tree_rank(p_id in number) return number is n_rank number; begin select sum(nodeorder * power(10, -1 * level)) into n_rank from treenode where id in (select id from treenode connect by id = prior parentid start with id = p_id) connect by parentid = prior id start with id = 1; return n_rank; end; / (double 'CONNECT BY', ouch). Note that if you expect more than 10 items per level, you should use somthing bigger than 10 in the power function. However : SQL select * from treenode 2 order by tree_rank(id); ID PARENTID NODEORDER DESCRIPTION -- -- -- 1 0 0 top folder 9 1 0 1st subfolder 2 1 1 2nd subfolder 4 2 1 folder 2 item 1 3 2 2 folder 2 item 2 6 2 3 folder 2 item 3 7 1 2 3rd subfolder 5 7 0 folder 3 item 1 8 7 1 folder 3 item 2 9 rows selected. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 containing: UNSUB ORACLE-L (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.com -- 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: Theory v Practice
OK. For everyone's benefit, this is commonly known as the Developer's Paradox. Essentially, it means that developers write more code so they are brought back to maintain the stuff. Your developers have tragically forced you into this. Instruct them on proper database/application/system design and then send them back to kindergarten. PK FK constraints are STANDARD in all relational databases and indexes are generally mandatory for PKs and sometimes optional for FKs. For performance, make them standard. The list is endless, however, Tim or Cary can Really add ammunition. OK gentlemen, I have left the door WIDE open. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 23, 2002 2:39 PM To: Multiple recipients of list ORACLE-L Subject:Re: Theory v Practice When code is developed to be database generic, developers will steer away from code for a specific database. However, foreign key and check constraints hardly fall into this category. I don't use Sqlserver or DB2, but I would guess that they implement FKs and constraints. Your developers are wasting a lot of time coding something that the database will do for them. The more logic you can put into the database, the better off you are. They'll have to code the constraints all over again when they want to develop a web front-end. You'll probably see some bad data into your tables due to coding bugs. Oracle isn't bug free, but they've got the constraints nailed down pretty well. Jay [EMAIL PROTECTED] 10/23/02 01:45PM The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as they say they will handle all the constraints via VB. I only have a theoretical knowledge of database design, which says this is very wrong. Is the Oracle system being used as anything more than an expensive file system? In real world scenarios, is this a common practice? Regards Craig Healey **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- 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: Theory v Practice
Oops, for got Ladies on my last email. Rachel definitely has some good opinions on this. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 23, 2002 2:39 PM To: Multiple recipients of list ORACLE-L Subject:Re: Theory v Practice it's not common and you should insist on primary and foreign key constraints. all you need is ONE user to hack into the database outside the app and insert/delete/update rows that violate the integrity constraints and your app stops working. --- Craig Healey [EMAIL PROTECTED] wrote: The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as they say they will handle all the constraints via VB. I only have a theoretical knowledge of database design, which says this is very wrong. Is the Oracle system being used as anything more than an expensive file system? In real world scenarios, is this a common practice? Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Healey 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!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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.com -- 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: Get together at OOW
(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!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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). === message truncated === __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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.com -- 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: Oracle pricing...
Not only applies for web based applications, but also for TP monitoring applications like CICS, Tuxedo, etc. Some clients actually priced the number of concurrent connections via these TP monitors versus the 10,000 or so users that use them. Ouch! Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 09, 2002 9:54 AM To: Multiple recipients of list ORACLE-L Subject:Re:Oracle pricing... Named User pricing is for individuals you can name. The Oracle installed users SYS, SYSTEM, DBSNMP, OUTLN, etc do not count. BTW: That does not mean that if one person at your company is on the day shift that they can pass their account on to someone on the night shift. In this case you have 2 named users and have to pay accordingly. Also don't ever, under any circumstances attach any type of WEB or transaction server to this database. You'll need CPU licensing for that. Oracle interprets Named Users very tightly. BTDT, OUCH!! Dick Goulet Reply Separator Author: Amar Kumar Padhi [EMAIL PROTECTED] Date: 10/9/2002 2:08 AM Hi, found the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. Product Named users Licence Processor Licence Oracle db(enterprise) 800 4 Oracle db(standard) 300 15000 Oracle db(personal) 400 -- rgds amar http://amzone.netfirms.com !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=x-user-defined META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLEOracle pricing.../TITLE /HEAD BODY PFONT SIZE=2 FACE=Courier NewHi, /FONT BRFONT SIZE=2 FACE=Courier Newfound the following information on Oracle site. What I am confused about is Named users license charges. How is this calculated? Are these charged for Oracle users also- SYS/SYSTEM etc. /FONT/P PBFONT SIZE=2 FACE=Courier NewProductnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs p;n bsp;nbsp;nbsp;nbsp;nbsp;nbsp; Named users Licencenbsp;nbsp; Processor Licence/FONT/B BRFONT SIZE=2 FACE=Courier NewOracle db(enterprise)nbsp;nbsp;nbsp;nbsp; 800nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp; 4nbsp;nbsp; /FONT BRFONT SIZE=2 FACE=Courier NewOracle db(standard)nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 300nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp; 15000/FONT BRFONT SIZE=2 FACE=Courier NewOracle db(personal)nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 400nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp ;nbsp;nbsp;nbsp;nbsp; -- /FONT /P PFONT COLOR=#00 SIZE=2 FACE=Courierrgds/FONT BRFONT COLOR=#00 SIZE=2 FACE=Courieramar/FONT BRFONT COLOR=#00 FACE=ScriptA HREF=http://amzone.netfirms.com; TARGET=_blankhttp://amzone.netfirms.com/A/FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- 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: Advice needed on move to Sun 15K (losing spindles)
This one is so easy that even a high school student could answer it. Use the theory of constraints (book called The Goal) to this one. When you reduce the number of resources to process a job, sequentially or concurrently, you induce bottlenecks within the process. Thus, by reducing the number of available spindles, you reduce the overall capabilities of the system. Not hard to accomplish. All of the vendors sell their caching technology as a way to avoid bottlenecks. First, shoot the sales rep from Sun and make him explain all of the performance bottlenecks to the CEO. Next, buy more disk. I truly wish disk vendors would stop increasing the minimum storage amount for disks, selling that to CIO's as a way to perform server consolidation, and then not taking the blame for the performance mess. Cache does not work, never worked and will never continue to work until the pipeline is the same size. Use basic theories and you will see the light. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 09, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- 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: Packed decimal
Oracle uses a proprietary field format for numbers. I dont think it is packed decimal, however, I believe most of the Cobol or PL/I programs I wrote against Oracle RDBMS on the mainframe used Packed Decimal to represent number fields. You can use the SIGN function to determine the sign of the value, if thats what you are looking for. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Brooks, Russ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Subject: Packed decimal Hi, Is there any way to identify values in a field, defined in Oracle as number(11,2), with a packed decimal format? Or to update the field with packed decimal values? Thanks, Russ 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.
RE: Orace setting on NT
Yes. Go to the Control Panel, then SYSTEM, and then Environment Variables. You can set the TNS_ADMIN variable there. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, October 07, 2002 12:36 PM To: Multiple recipients of list ORACLE-L Subject:Orace setting on NT Hi . This is a very easy question. I'm usually working with Oracle on UNIX, but today I need to connect to a remote instance from my NT desktop. Is there an equivalent to TNS_ADMIN varaiable in NT? ( I'm trying to force Oracle to use a specific tnsnames.ora file on my machine adn TNS_ADMIN variable is the way to do it on UNIX.) thanks for any help Gene __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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.com -- 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: datafile sizing question
Goddess: The conclusions are correct. The OS must be configured to properly handle the 64-bit architecture, thus, large files. The 32-bit limitation on 2GB files is still imposed unless this occurs. Although Oracle can accommodate 2GB files, you must have the OS handle the outside Oracle work. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, September 25, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject:RE: datafile sizing question I think it's automatic on Solaris 2.8 but I don't know for sure so I'd rather not rely on it. I'm going with 2001M and creating about a year's worth of tablespaces/partitions. 101 datafiles and tablespaces. Just to START. my aching typing fingers! --- Paul Baumgartel [EMAIL PROTECTED] wrote: I believe that the OS filesystem has to be configured for large file support (on HP-UX, it's a kernel parameter) to allow files 2 GB. I usually just add 1 MB to the file size to allow for the header. Personally, I'd play it safe and go with however many 2001 MB files you need to accommodate your objects. --- Rachel Carmichael [EMAIL PROTECTED] wrote: I'm betting that it's not 64-bit Oracle. See, I am the development DBA. As an employee, I get to create the scripts, but I don't get to run them or even get access as oracle to the servers. In other words, all the grunt work, all the responsibility for problems (production is managed by a hosting company) but none of the power to make sure it's right. I love my job. Why? Rachel __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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.com -- 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: BUFFER OVERFLOW, LIMIT OF 2000 BYTES.
You need to execute DBMS_OUTPUT.ENABLE (buffer size); with a max of 100 bytes. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Subject: BUFFER OVERFLOW, LIMIT OF 2000 BYTES. Hi All, Below is a script to retrieve data from BFILE column and its output.The external PDF file is around 53, 435 bytes (text and picture altogether in one file). Anyone please have a fix for this script. I am unable to view the content of the external PDF file on the sreen. Any help is greatly appreciated. Thanks alot Lenka set serveroutput on DECLARE v_book_file BFILE; v_length NUMBER; v_position NUMBER; v_piece RAW (56,320); BEGIN SELECT book_file INTO v_book_file FROM my_book_text WHERE file_desc = 'testing'; dbms_lob.open (v_book_file, ); v_length := dbms_lob.getlength (v_book_file); v_position := 1; LOOP EXIT WHEN v_position v_length; v_piece := dbms_lob.substr (v_book_file, 100, v_position); dbms_output.put_line (utl_raw.cast_to_varchar2(v_piece)); v_position := v_position + 100; END LOOP; dbms_lob.close (v_book_file); END; / == %PDF-1.3 %bcOS 1 0 obj /Creator feff001b7a68001b004d006900630072006f0073006f006600740020005700 6f007200640020 /CreationDate (D:19991019160202) /Title feff001b7a68001b003600310031003700700062006 30031002e005000440046 /Author feff001b7a68001b0052006f006200650072007400630075 /Producer (Acrobat PDFWriter 4.0 for Windows) /ModDate (D:20001019200402+08'00') endobj 2 0 obj [ /PDF /Text /Ima geB ] endobj 3 0 obj /Pages 5 0 R /Type /Catalog /DefaultGray 31 0 R /DefaultRGB 32 0 R endobj 4 0 obj /Type /Page /Parent 5 0 R /Resources /Font /F1 8 0 R /F2 10 0 R /F0 6 0 R /F3 14 0 R /F4 16 0 R /ProcSet [ /PDF /Text /ImageB ] /Contents 57 0 R endobj 5 0 obj /Kids [ 4 0 R 18 0 R ] /Count 2 /Type /Pages /MediaBox [ 0 0 612 792 ] endobj 6 0 obj /Type /Font /Subtype /TrueType /Name /F0 /BaseFont /Arial /FirstChar 31 /LastChar 255 /Widt hs [ 750 278 278 355 556 556 889 667 191 333 333 389 584 278 333 278 278 556 556 556 556 556 556 55 6 556 556 556 278 278 584 584 584 556 1015 667 667 722 722 667 611 778 722 278 500 667 556 833 722 778 667 778 722 667 611 722 667 944 667 667 611 278 278 278 469 556 333 556 556 500 556 556 278 55 6 556 222 222 500 222 833 556 556 556 556 333 500 278 556 500 722 500 500 500 334 260 334 584 750 556 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 5 00 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500 DECLARE *ERROR at line 1: ORA-2: ORU-10027: buffer overflow, limit of 2000 bytes ORA-06512: at SYS.DBMS_OUTPUT, line 91 ORA-06512: at SYS.DBMS_OUTPUT, line 58 ORA-06 5! ! 12: at line 17 Do you Yahoo!? New DSL Internet Access from SBC Yahoo! 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.
RE: Privileges needed for truncate
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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.com -- 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: User / Synonym Question
Create the program to access the transaction table within its schema directly and use a public synonym for power users. That should work. If the transaction table is owned by another user, create a single synonym within the program schema and a public synonym thereafter. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, September 23, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Subject:User / Synonym Question Good Morning/Afternoon/Evening! I have been charged with implementing a data-archive strategy into an existing, production system. The only issue I have remaining is that damagement wants the developers programs to only see the active data when they query the transaction table -- and the power users to see a partition-view of active and history data when they query the transaction table. program connects SELECT * FROM transaction; -- hits the transaction table power user connects SELECT * FROM transaction; -- hits the transaction_all view Is there any easy way to do this without reverting to the use of private synonyms for each power user? I've fought the good fight and have been unable to convince damangement that this is not the best way to do this, so I'm looking for a technical solution. TIA Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M 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.com -- 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: Ioug meeting or HOTSOS Seminar
Given that you will probably see Anjo, Cary, Tom and potentially Gaja, at the event, I would recommend IOUG Live! Reason 1: Significantly more presentations Reason 2: More opportunities to network with other people in your position Reason 3: Greater opportunity to share your stories Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, September 10, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Hello List I got a message about Hotsos Tuning seminar in Dallas. Scheduled in February 2003. The lecturers list include among others: Tom, Anjo, Gaja. http://www.hotsos.com/events/symposium/ I also know that there is an IOUG Live meeting on May 2003, and many of you recommended going. http://bneo15.sba.com/ew/ioug/index3.cfm?clientsess_id=07332332nextpage=cal lpapersconference_id=71 MAYBE (not shouting but a big maybe) I will convince management to spring for one of the two. Which one you recommend? Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: off topic: OCP exam registration
The OPP is open to Oracle Partners and their employees only. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, September 05, 2002 6:21 PM To: Multiple recipients of list ORACLE-L Subject:RE: off topic: OCP exam registration Sunil Who can use this code? Employees /partner of Oracle Partner program or anybody? Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 05 Sep 2002 13:38:43 -0800 Try promotion code OPP to get 30% off. Sunil Nookala Dell Computer corp. Austin, TX -Original Message- Sent: Thursday, September 05, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Hi ALL! I just spoke with Prometric and they told me if I give them my OTN number they will give me discount for OCP exam. I'm the member of OTN , but I don't have any number. Someone know where I can get this number? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle User identified EXTERNALLY
Did you set the init.ora parameter for external authentication? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, September 06, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject:Oracle User identified EXTERNALLY Hi All, Here is the situation . I have a Unix user called oracle on a Sun Solaris box. I created the user called ops$oracle by using the following syntax. CREATE USER OPS$ORACLE PROFILE DEFAULT IDENTIFIED EXTERNALLY DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK; GRANT CONNECT TO OPS$ORACLE; Now I login to Unix box as oracle(Unix user), set up the Oracle environment(ORACLE_SID, ORACLE_HOME etc). Then try to login to sqlplus but It prompts for password or it says invalid username/password. I am under impression that I should be able to login to Oracle without specifying the Oracle password as described below. But I am not able to do so as shown below. Could you please tell me what am I missing and how can I log into oracle through the Unix user without specifying the password as it should be identified externally. Thanks, Ashoke Unix sqlplus / SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 6 10:40:59 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: I also tried Unix sqlplus ops\$oracle SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 6 10:44:27 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter password: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to get rid off certain character from a string ???
You could try the translate function and leave off the translation for the _. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, September 06, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Subject:How to get rid off certain character from a string ??? Hi all, How to get rid off certain character from a string. For example, I have string 'WC_89_06_03', what's an easy way to get 'WC890603' out, is there a function? Thank you in advance! Janet __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ALTER TABLE MOVE command causes table to grow
Jay: I would also wonder that the PCTINCREASE was on the table and the indexes. 10% PCTFREE is fine, but does lead to a significant number of empty blocks. What is your PCTUSED? If small, you will have lots of free space within blocks. Just a thought. Don't let your disk person know this happened as they may try to sell you more hardware. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, September 05, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject:ALTER TABLE MOVE command causes table to grow Had an annoying surprise last week. A table had grown unexpectedly large and I scheduled a time over the weekend to move it to its own tablespace from my medium tablespace. The table ended up growing 50%. I had anticipated it might grow somewhat given the PCTFREE of 10% but freeing up that space in the blocks should, at most, have caused it to grow by 10% (assuming that 10% was completely full). Does anyone have ideas as to why it would have grown by so much? Indexes are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: any tips on migrating from 7.3.4 to 8.1.7
Sebastian: I would definitely make sure that sufficient backups of both Oracle Homes and databases are taken before anything occurs. I would also start with the 8.1.5 database, converting it to 8.1.7. This process is straight forward and does not require a significant amount of work. As far as the 7.3.4 database, the migration assistant can be used to solve most of the migration tasks that must be performed. Additional tasks may be necessary depending on the size of the database, etc. If you are trying to convert into a single database, be careful not to wipe out any data from either environment. If this is the case, then convert to a single database and migrate to 9.0.2. I would also convert to a single Oracle Listener for both databases, using 8.1.7 and then finally 9.2. Hope this helps. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, September 05, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Subject:any tips on migrating from 7.3.4 to 8.1.7 Hello All, I am currently involved in a migration project which involves combining two disparate databases into a single Oracle Engine. One of the databases currently lives on Oracle 7.3.4 and the other is 8.1.5 (both desupported by Oracle). My task is to upgrade to a single instance of 8.1.7 (and eventually 9.2.x). Are there any road bumps that I should be aware of before undertaking this endeavor? Any tricks/tips are appreciated. Thank you in advance Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question about database and service name
Ramon: Let me try these one at a time. 1. True. To a client desktop or device, a database environment is presented as a service (flooky name). The service is a TNS Service via Net8/Oracle*Net. 2. Using multiple service names within the tnsnames.ora file and multiplexing within the listener.ora file, a database can have multiple service names point to it. This is common where application-specific code names are used as TNS Service Names. This is also useful for failover whereas services are on different machines. 3. This one sounds like RAC or OPS where the database can be implemented as multiple services and a service is implemented as multiple instances. In either case, a database instance can only represent one database at a time. That is why service names must be unique within a specific server. Hope this helps. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: Question about database and service name Hi list, Reading the OU manuals Oracle 9i DBA Fundamentals II , in chapter 2 page 12, found 1-) An oracle database is represented to clients as a service. 2-) A database can have one or more services associated with it. 3-) A database can be presented as multiple services and a service can be implemented as multiple database instances. For the No. 2 : I interpret that I can have 2 or 3 or 4 services for just ONE DB. Is that correct ?. How can I do that ? For the No. 3: I interpret that I can refer to the same DB with differents names. As far as I understand, the DB instance name is unique, it can't be changed. So how can I create several services names for one DB. Or is just a trick in the TNSNAMES.ORA and LISTENER.ORA files. Please can anyone give some light in that, I am totally confused !!! Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 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.
RE: SQL*Plus in 10i
Have not heard from Oracle as of yet regarding removing the SQL*Plus interface. To my knowledge, there are extensive enhancements being made to SQL*Plus. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, August 30, 2002 4:43 PM To: Multiple recipients of list ORACLE-L Subject:RE: SQL*Plus in 10i They are going to have iSQL*Plus (or however it's spelled) and you can use that (and OEM) for startup and shutdown. The SQL*Plus text and windows clinet I hear will be gone. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, August 30, 2002 2:34 PM To: Multiple recipients of list ORACLE-L oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL Editor
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLNet and NET8
The answer is yes. SQL*Net and Net8 may contain the same Oracle Homes, but generally do not. Even if they did, SQL*Net connectivity would use the 16-bit drivers and apis whereas Net8 would use the 32-bit drivers and apis. Both pieces of software are intelligent enough to understand which connection to use. Additionally, your 3rd party vendor app will have the corresponding aps within their code tree and those will match the Oracle api it must connect to. If you can, I would install in different homes, unless you are using an old version of Oracle where they are installed in the same tree. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, August 20, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject:Re: SQLNet and NET8 Hi, I had encountered this question 3 years ago. But, unfortunately I don't remember the answer very well. The answer for same ORACLE_HOME depends on the names of SQL*Net and NET8 files. If they are different, no problem. If same, use different ORACLE_HOME. As I said before, I'm not sure. But, This is documented in Oracle support. Call them, they have the answer. For different ORACLE_HOMEs, I don't see a problem. regards... [EMAIL PROTECTED] wrote: Yes, as long as they are in different Oracle_Homes. Dick Goulet Reply Separator Author: Satish Iyer [EMAIL PROTECTED] Date: 8/19/2002 1:38 PM Is it possible to have SqlNet and Net8 installed on the same client machine ? The reson behind this is that on the same machine we have an 3rd party application which can connect only through sqlnet and for the rest of the apps we want to use net8. Any ideas on this configuration should be done. Many thanks Satish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Satish Iyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQl question
I believe it is acting appropriately. You are trying to load a two-character byte filed into three-byte character field. Loader, if you don't terminate by whitespace or nulls, will add the blank into the field because it is character. Thus, you have two options: 1. Change the field to numeric. 2. Trim the data before it is loaded. Check the third position to see if it is a space or null; if so, only load n positions of data. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, August 21, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject:RE: PL/SQl question Dennis, In your PL/SQL program, did you try the RTRIM(date_field,' ') command? I know that TRIM is new, but I thought it needed additional parameters to tell it what to trim. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 21, 2002 10:28 AM To: Multiple recipients of list ORACLE-L I have a question for from one of my developers related to PL/SQL and how data is loaded. I have a field (marketcode) that is defined as VARCHAR2(3). I have a problem when I try to load the value of '20' into this field. All values with three characters work fine. The problem is when the value is less then 3 characters. When tables A and B have data loaded into this field using SQL/Loader the resulting value in the field appears to me as '20' with the third position =null. I have a separate PL/SQL process that loads this field into table C. When PL/SQL populates this same value into this field the field appears to me as '20' with the third position = space. I can't use SQL/Loader for this table as the data needs to be massaged before loading into Oracle. Thus when you try to link the tables together it does not find a match. select A.marketcode, C.marketcode from tableA A, tableC C where A.marketcode=C.marketcode; (this returns 0 records) If I change the SQl statement to the following: select A.marketcode, C.marketcode from tableA A, tableC C where A.marketcode=trim(C.marketcode); (it correctly matches these up) Things I have tried to remedy this problem: 1) I have tried to modify my PL/SQL program to put a TRIM statement around the marketcode field when I populate table C. This did not work. 2) I have tried to check the 3rd position and if it is = space then I set the third position to null. But the field in Oracle is still a space when the program is finished. Does anyone have any thoughts on how I can properly output this field from Pl/SQl so it will match the data loaded via SQL/Loader? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Senware AutoDBA
I'll add to John's comments. It took John, Kirti myself to keep Gaja calm during the presentation. Once we all walked out, Gaja went outside and vented. Their solution is unusual as they believe that performance can optimized by adding hardware to the solution. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, August 21, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Subject:RE: Senware AutoDBA FWIW, someone from Senware presented a paper at IOUG 2002 titled 'Performance management from the ground up' (or somthing like that) which was a load of *$% to say the least. Most of the audience (many on this list) walked out in disgust after the first 10 minutes (Does someone remember the 'green peas' story?) If their product is even twice as good as their rep, it would not be worth considering. I am not blaming their desperate tactics however. Anything to sell a product in this economy :( Just came off a marketing call on the office phone for services I don't need! John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Subject: Re: Senware AutoDBA Interesting web site. They claim to eliminate chained rows by rebuilding the tables. I'd like to see how they intend to do that. They also claim that their product can detect corrupt indexes and rebuild them. How hard can it be to detect ORA-1578? This kind of thing is fairly rare, and hardly seems worth the resources to run DBMS_REPAIR or dbv to check for. Their MO is hardly new. IBM has had a team in place for years designed to make an end run around the purchasing mgr/DBA/whoever when their product wasn't selected. They go to upper mgt to try and convince them of the foolish mistake the product evaluators made. Not surprising that others follow their lead. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Simple favor from the guru's
Lee: Already did. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, August 16, 2002 5:04 AM To: Multiple recipients of list ORACLE-L Subject:RE: Simple favor from the guru's Well, thats about as clear as you can get. Stephen, I guess that should give you enough ammo to shoot your co-worker with :-) -Original Message- Sent: 16 August 2002 03:18 To: Multiple recipients of list ORACLE-L Lord knows I am one of the first to disparage the validity of OCP as a measure of what a DBA should/does really know... however, this is the reply I received from a friend who is an instructor at Oracle University. What they have learned, is NOT what they have been taught. The information this student provided is wrong and would be wrong an all versions of the ocp exam. I have provided notes from chapter one of the Oracle 9i DBA Fundamentals I course notes. Chapter 1 Page 3 Oracle Instance: An Oracle Instance is the combination of the background processes and memory structures. The instance must be started to access the data in the database. Every time an instance is started, a System Global Area (SGA) is allocated and Oracle background processes are started,. Background processes perform functions on behalf on invoking processes. They consolidate functions that would otherwise be handled by multiple Oracle programs running for each users. The background processes perform input/output and monitor other oracle processes to provide increased parallelism for better performance and reliability. Chapter 1 Page 3 Oracle database: An Oracle Database consists of operating system files, also known as database files. They provide the actual physical storage for database information. The database files are used to ensure that the data is kept consistent and can be recovered in the event of a failure of the instance. Chapter 1 Page 9 An Oracle database consist of three file types. Data files containing the actual data in the database, redo logs containing a record of changes made to the database to enable recovery of the data in case of instance failure, and control files containing information necessary to maintain and verify data integrity. Immediately after the definition of a database above is the heading Other Key File Structures, beneath this heading it says The oracle server also uses other files that are NOT part of the database: - The parameter file that defines the characteristics of an Oracle Instance For example it contains parameters that size some of the memory structures of the SGA. - The password file that authenticates users privileged to startup and shutdown an oracle instance (remotely) - Archived Redo log files are offline copies of the redo log files that may be necessary to recover from media failures. Hope this helps clear up any confusion, --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com
RE: Catching errors on inserts
Bob: You can use WHEVER conditions within your SQL*Plus script, however, it stops when an error is received. You could put into an anonymous pl/sql block and use exception handling. Use this format: BEGIN PROCEDURE XXX is BEGIN INSERT STATEMENT with variables for all values EXCEPTION HANDLER END; Call procedure with values for insert END Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, August 16, 2002 3:48 PM To: Multiple recipients of list ORACLE-L Subject:Catching errors on inserts Oracle Water Walkers! I have a very large insert script that may contain data that is larger than the column, I need to be able to identify rows that fails with Value too large for column Im doing 10k inserts via insert into table (val1,val2,...) Is there a way to do this (trap bad rows) in SQL Plus? I don't see how but I figured I ask. The collective intelligence here is greater that I ... Many thanks You people on fatcity are awesome!! bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL Editor.
DevPartner DB Tuner, Debugger Profiler for PL/SQL from Compuware. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, August 15, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject:RE: PL/SQL Editor. I like RapidSQL from Embarcadero - but it's a bit pricy for a pretty good and less expensive alternative try PL/SQL Developer from allroundautomations -bill -Original Message- Sent: Thursday, August 15, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Hello, I need a nice PL/SQL editor any advice ? Thx for any advice Regards W.B __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Place for oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Simple favor from the guru's
Everyone: I am looking to all of my esteemed peers and gurus to clarify something that I know is blatantly wrong. Here is the scenario. I have a co-worker that is preparing for the DBA OCP debacle. They have completed a significant portion of the training and are preparing to take the first set of exams. To see what they have learned, I asked them to define what comprises an Oracle Instance and what comprises an Oracle database. Here are the responses I got: An Oracle Instance The database instance contains storage areas that allow users to use the database, data dictionary, redo log buffers and various processes that help to maintain, tune and run the database An Oracle Database The Database files consist of the parameter file or init.ora file, the physical data files, the control file and the redo log files and archived log files if the database is run in archive log mode Now, we all know that an Oracle instance comprises the background processes, the memory processes, memory storage areas, the and INIT.ORA parameters whereas the database comprises the physical files, data dictionary, users, objects, etc. The problem I have is the education is being supplied by our favorite vendor, Oracle. Did I go on vacation too long or is Oracle professing incorrect information in the OCP. Can one of the people that has taken the exam the classes look this up in the manuals for me? This proves my theory of refusing to take this exam unless hogwhipped and tied down (Rachel, sit down please and thanks for volunteering). If bad information is being given, then what's the use of the exam? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OPS 7.3.4 - how to ?
Requirements: 1. Database must be reconfigured/rebuilt. 2. All datafiles must reside on RAW devices. No autogrowth potential. 3. Several UNIX parameters will require modification to accommodate the increased traffic between the two instances. 4. TNSNAMES and LISTENER .ORA files will require additional entries for changed instance names. Is that a good start for you? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, August 13, 2002 5:38 AM To: Multiple recipients of list ORACLE-L oops ... It's digital UNIX (a sort of predcessor of the Tru64, ig i understood correctly) , don't know exactly which version. Thanks ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Monday, August 12, 2002 8:58 PM To: Multiple recipients of list ORACLE-L What platform? What OS? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, August 12, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Dear gurus ! I have to create an OPS 7.3.4 database (yes, there are still Oracle7 installations out there). Actually we are migrating our current OPS DB to another storage (EMC). So , the software is installed , i just need to create the DB. I can not find which scripts to run after the create database (i.e. catproc.sql , catexp.sql). Does anyone have a list of such scripts to run for OPS , please? Also , are there any known gotchas for OPS 7.3.4 setup ? I plan to export the exisiting DB, to create the new DB (with the same name of the DB and the instances as the original ones) and then to import. Is it OK ? TIA. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: OPS 7.3.4 - how to ?
What platform? What OS? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, August 12, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Dear gurus ! I have to create an OPS 7.3.4 database (yes, there are still Oracle7 installations out there). Actually we are migrating our current OPS DB to another storage (EMC). So , the software is installed , i just need to create the DB. I can not find which scripts to run after the create database (i.e. catproc.sql , catexp.sql). Does anyone have a list of such scripts to run for OPS , please? Also , are there any known gotchas for OPS 7.3.4 setup ? I plan to export the exisiting DB, to create the new DB (with the same name of the DB and the instances as the original ones) and then to import. Is it OK ? TIA. DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: missed Anjo's webcast..
spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table Naming Conventions
Hmmm. Proper data modeling dictates that all names be singular. Plural names imply that multiple values are stored. That's a no no. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, July 31, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject:RE: Table Naming Conventions Gary, you said: What's the consensus (if there is such a thing) on plural vs. singular table names? the correct answer is - BE CONSISTENT!!! doesn't really matter (at least to me!) :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 31, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Many thanks to all for your feedback and advice! As I suspected, naming conventions are really a matter of someone's personal preference, and what's really important is to keep it standard and consistent. One [hopefully] last question: What's the consensus (if there is such a thing) on plural vs. singular table names? Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 11i installation ???
Leslie: Please look at www.oaug.org as this is the web site for the Oracle Applications User Group. You can join their list serve as well. As far as your installation issues, 1. You should install the demo environment as is and do not modify anything. It takes approximately 6GB to install. 2. You are missing some files that are required for the 11.5.6 install and may have been cleaned up by accident. This is the Java Runtime Engine. Please download from either Metalink or it should be on the cds for you. 3. Follow the installation process very carefully, as any modifications in the process can prevent you from completing the process. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, July 29, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject:11i installation ??? Hi all, I purchased the Oracle 11i Release 5 (with 11.5.6 family packs) CD pack for Windows from Oracle online store. My first installed (Win2000) run out of space, and I cleaned the folders manually. When I got more space and installed again, I got: not all the dependencies for the component OEM common files 2.2.0.0.0 are found. Missing component Oracle.swd.jre 1.1.8.10.0. Looks like the manually cleanup didn't go well. What should I do now? Also, how long does the install take? One guy told me to install one product/one db at a time. Is this a good idea? Is demo db enough? Are there any Oracle 11i group/email list? I know, lots of questions. :-) Thanks! Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
(like subscribing). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Foxbase to Oracle
Dennis: Foxbase was originally called 10-base before Fox Systems change the name. Foxbase was changed to FoxPro and then purchased by Microsoft and called Microsoft FoxPro, and then Microsoft Visual FoxPro. I would highly recommend investigating the MSFT solution. Sorry guys, but this is a realistic solution. Oracle, for eight users, will probably cost too much for the implementation. If you need to convert to Oracle, do the following: 1. Convert to FoxPro 2. Bridge Visual FoxPro to SQLServer and use the Data Transformation Services (DTS) to migrate the data to Oracle. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 30, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject:Foxbase to Oracle Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: naming conventions for Oracle/Unix vs. SQL Server
Title: RE: naming conventions for Oracle/Unix vs. SQL Server Paula: The mixed case for Oracle does not matter, as Oracle is not case sensitive. The column names are stored in uppercase within the data dictionary. However, for SQL Server, the case sensitivity of column names is crucial. Another black eye for MSFT. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: naming conventions for Oracle/Unix vs. SQL Server Guys, Please help. I work in an organization where we have both SQL Server on NT and Oracle on Unix. SQL Server and developers who are used to GUI's in NT like column names to have mixed case with no underscores. The Unix folk - like myself prefer underscores and one case. Is there any reason not to adopt mixed case for Oracle? Is this really just what I am used to? I have been using this standard for so long that it maybe the reasons I adopted it do not any longer exist or are not as compelling as developer's today are more comfortable with mixed case. Help! 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.
RE: import question
Title: RE: import question Dan: I believe the SQL on the outbound is eliminated. With DIRECT=Y, the Kernel performs I/O direct to the DMP file versus generating the SELECT statements to retrieve the data and then write out the data. Thats why exports take far less time with DIRECT=Y. You are correct that Redo WILL be generated on the import side. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Straub, Dan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: import question If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. Very interesting, except that I believe you are wrong. ALL of my exports are done with direct=y option. I can demonstrate very easily that there will be 'redo' generated when doing the import by putting the importing database into archivelog mode and turning off the archiver process. If redo is not being produced (as you state), why do I see messages in the alert log telling me that the database is halted because all my redo logs are full and need archiving? Have a nice day, Dan Straub McKesson Information Solutions 541-681-8278 44°03'N 123°05'W (or thereabouts) Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. 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.
RE: peopleslop HR question
Joe: I do not thing the salary is encrypted. I believe it is considered an open field. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Subject: OT: peopleslop HR question For those of you running PS HR, a question was posed to me, is the salary field encrypted, so that the DBA can't go in and look at everyones salary. OB oracle part: OMF stands for what?, Oracle Managed Files. joe 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.
