Re: oracle client on PC's
We do an install on the workstation but the installation has been packaged and is pushed I believe with SMS or at least it used to be done that way. From: Jeffrey Beckstrom [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: oracle client on PC's Date: Tue, 06 Jan 2004 12:14:28 -0800 The application is a third-party application using Merant's ODBC driver. How do people normally install the client. Do you do an install to every workstation??? [EMAIL PROTECTED] 1/6/04 2:54:34 PM At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote: Rather than installing the Oracle client on every client PC, we have been: - installing client on 1 PC - copying directory to a network server - extract the registry for oracle key - fix registry that was extracted to reference the network drive - load registry on client PCs - add the network pc as a search drive to the client pc. We are now experiencing problems over the WAN and looking at ways to eliminate the Oracle dll overhead. Short of installing Oracle on every client PC, what are our options? There is a reason that Oracle doesn't support configurations like this. There is a fair amount of chatter between an application and the Oracle client DLL's. When this chatter starts flying over the network rather than merely going to a local DLL, you start to get performance problems. How are your application(s) designed? It's probably possible to tweak an OCI application to make fewer OCI calls. If you're using ODBC, and have the budget, you could purchase one of the wire-protocol ODBC drivers. Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 english?
I have not read through the entire thing but from what I have seen so far, I like Data Modeling for Everyone by Sharon Allen (CurlingStome Publishing) ISBN 1904347002. It covers the theory to the implementation (Logical - Physical transformation). From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Any articles/books that take relational theory and make it english? Date: Wed, 19 Nov 2003 05:24:57 -0800 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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/photospgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NT/WINDOWS 2000 resources for ORACLE
spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 EE and SE on same box
We did that this year except it was 8.0.6 SE and 8.1.7 EE. No big issue. Other than having 2 listeners on different ports the most annoying task was that the method of setting the Oracle Home and associated environment variables for the usage by the shell scripts and the database start procedures initiated by server bootstrap had to be changed. This was a server consolidation effort. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Oracle EE and SE on same box Date: Mon, 03 Nov 2003 11:39:35 -0800 Hi: Are there any resources out there (official Oracle or otherwise) that pertain to installing both Enterprise and Standard on the same box. Regards, Gary Norwell Systems Analyst Hybrid Turkeys _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Effect on Oracle of changing server time from EST to GMT
Another issue might be related to doing time-based recovery. Oracle has a couple of notes on metalink related to changing server time and database impact. Note:1013279.6 - HOW DOES DAYLIGHT SAVINGS TIME AFFECT THE DATABASE? Note:77370.1 - What are the effects of changing the system clock on an Oracle Server instance? From: Stephane Faroult [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Effect on Oracle of changing server time from EST to GMT Date: Thu, 16 Oct 2003 15:04:40 -0800 Well, some jobs (including snapshot refreshes) may get confused, and if you create or alter objects I wonder how Oracle may handle dependencies ... Fortunately you are moving 5 hours ahead, rather than back, so risks are probably quite limited. -- Regards, Stephane Faroult Oriole Software -- 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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Remote Installation of Oracle on Win2K
Has anyone performed a remote install of Oracle 9i onto a Windows 2000 Server using PCAnywhere or know if it will work? Trying to avoid having to go to the console which is about an hour away by car at IBM's data centre. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Remote Installation of Oracle on Win2K
Yep. Read that too, in my copy of the installation guide, sitting on my living room floor next to my computer. But, wasn't planning on using Microsoft Terminal Server. Was interested in using Symantec PCAnywhere for remote install. I had bad experiences with Terminal Server being funky. Did not cooperate with BEA Tuxedo at all. From: Carol Bristow [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Remote Installation of Oracle on Win2K Date: Mon, 08 Sep 2003 07:39:28 -0800 According to the installation guide, which happens to be on my desk, Installation of Oracle 9i server components from a remote Terminal Services Client onto a Windows 2000 server that is running Terminal Server Service or a Windows NT 4.0 Terminal Server is unsupported. If you attempt to install Oracle 91 in this manner, many database configuration tools hang. It goes on to list examples, which include the database configuration assistant and the database upgrade assistant. HTH, Carol Bristow DPRA Inc. 1300 N 17th St Suite 950 Rosslyn, VA 22209 Work: 703-841-8025 Fax: 703-524-9415 -Original Message- Sent: Monday, September 08, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Has anyone performed a remote install of Oracle 9i onto a Windows 2000 Server using PCAnywhere or know if it will work? Trying to avoid having to go to the console which is about an hour away by car at IBM's data centre. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Carol Bristow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Our servers (AIX/HP) don't even have emacs on it. Use vi for small stuff otherwise I fall into the ftp with windows environment to work. I use CodeWright. From: Orr, Steve [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. Date: Fri, 25 Jul 2003 12:09:36 -0800 vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Microsoft VS Oracle (again)
Well, I am not particularly fond of SQL Server, but it does point in time recovery and online recovery. At least we did it in the DB Admin class for SQL Server 2000. Docn isn't that great (except maybe the IT Professional series). From: Nuno Souto [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Microsoft VS Oracle (again) Date: Tue, 01 Jul 2003 23:45:30 -0800 - Original Message - Any comments? Yes. got that one last year. Still got it. Installed the doco in my PC at work so I could read it in peace and quiet (!). Installed the s/w as well so I could play with it. Went straight to their recovery manual. Basically, it reads like this: restore all db files apply saved logs No partial recovery, no online recovery, no PITR, nothing. Put me off the whole thing straight away. But if I may quote dubya: make no mistake, they'll fix it. And then it will be quite interesting... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 authentication from windows
This is an interesting one. I am currently going through (tortured) another system audit. One of the many questions the auditors (I am being attacked from all sides) had about the Oracle configuration was Can remote authenticated network users connect to the database?. If auditors know this is a weakness, maybe it would be a good idea to avoid its use. btw I do use O/S authenticated userids but remote authentication has been disabled (deliberately). We are running Oracle on Unix so our batch jobs use O/S authenticated ids. From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: oracle authentication from windows Date: Thu, 19 Jun 2003 12:19:59 -0800 That, of course, will render your database totally insecure and open to anybody who can bring in a WinXP laptop, change the windoze username and log in as he pleases. DBA that sets his production parameters the way Arup described deserves to be publicly tortured by Bill O'Reilly in the no spin zone. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 19, 2003 3:46 PM To: Multiple recipients of list ORACLE-L Sure. Just declare these in your init.ora os_authent_prefix=OPS$ remote_os_authent=TRUE bounce the database, add a user called OPS$the Windows username, e.g. OPS$AK if your Windows login id is AK as create user ops$ak identified externally From windows connect as /@servicename, e.g. sqlplus /@service1 If it doesn't work, the OS user may be different. Use this query while connected to the database from Windows cleint. SQL select sys_context('USERENV','OS_USER') from dual; See what OS username comes up; use that instead. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Thursday, June 19, 2003 1:10 PM We want our client users ( forms user ) to just enter windows password and then automatically able to get in to oracle .Is there a way oracle can authenticate from windows ( or active directory ) . enbadding password in runform.exe not an option . thanks, -ak _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dbshut script - shutdown or shutdown immediate
Peter, Shutdown immediate would be a better choice. Might also be a good idea to have the app server process stopped prior to the database instance being shutdown. I have seen apps that have left ghost connections or go nuts when the database disappeared (bad error handling I guess). david From: Schauss, Peter [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: dbshut script - shutdown or shutdown immediate Date: Wed, 02 Apr 2003 07:03:38 -0800 I have one Oracle instance which supports an application server which always maintains a database connection. The UNIX system administrator tells me that this instance always hangs when she tries to shut down the system. The other instances, which do not support a 24x7 process shut down properly. Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to sqlplus is connect internal shutdown Should I modify the script to shutdown immediate so that it kills any connections? Environment is Oracle 8.1.7 /AIX 4.3.3. Thanks, Peter Schauss Northrop Grumman Corporation -- 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). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: POLL: Database to DBA ratio
Chuck, I support 17 development, 2 production oracle databases, 3 DB2/MVS databases and 1 SQL Server. A coworker supports only 1 application and that is in UAT/Dev environment but it is a highly active application in the multi-Terabyte range (UDB). We have external prod. support for some of our apps (IBM). I think how many a DBA can support will depend upon a number of things such as (by no means a complete list): - Production Support and/or App. Dev support - Frequency of change to an application. Some stay in a constant state of change. - Complexity of system (ERP, n-tier, custom, vendor) - Procedures/processes/technology to allow easier support of multiple systems. David From: Chuck Hamilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: POLL: Database to DBA ratio Date: Tue, 11 Mar 2003 06:59:21 -0800 I'm trying to build a case for management that we need additional DBAs so I'd like to take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your shop? This includes development and production databases. At our shop it's 33:1. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Character Set / Encrypted text question
Mark, I have seen this issue here where an application scrambles/encrypts data into a character field varchar2 but it doesn't work right when moved to another environment. The source environment was using NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 but the target was using NLS_LANG=AMERICAN_AMERICA.US7ASCII. Going from an 8-bit characterset to a 7-bit characterset causes problems where the byte code value should have been properly represented by 8 bits and not 7. eg. VARCHAR2(15) field contains data ÚØÝ (dec: 218, 216, 221) comes out as U?Y when converted to US7ASCII (see SQL CONVERT function). Another app I use here does work, but it stores the values in Hex not with the character representation. Options: Used 8 bit characterset on database. Store data as hex value eg. Passwords stored in Oracle table (dba_users [sys.user$]) which is a VARCHAR2(30) field. User RAW fields. Converting the database characterset requires a database recreation. David From: Mark Richard [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Character Set / Encrypted text question Date: Wed, 05 Mar 2003 19:28:46 -0800 Dear List, I have a question for the character set guru's out there... We are trying to store encrypted text from a Forte application into a varchar2 column in Oracle (8.1.7.4). When Forte retrieves the string a couple of the characters appear to have changed value. I assume we are experiencing some kind of character set limitation. Does anyone have any ideas about how we might work around this issue? I have included the NLS section from out init.ora section for reference. The only workaround we can think of is converting the string to hex values and reassembling these into a long string and then storing that result. Does this sound reasonable (assuming it's not a simple character set change). Please keep the help simple - I have never had to be concerned with character sets before and don't really understand all of the terminology. # NLS settings nls_date_format = DD-MON- nls_sort= BINARY nls_language= AMERICAN nls_numeric_characters = ., Thanks in advance, Mark. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 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: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Duplicate online Database
I would never want to rely on that method. I had run into that several years ago (Y2K), a Unix Admin had backed up a server and restored to a test machine. Oracle wasn't shutdown at the time of the filesystem backup. The problems were numerous because of checkpoint information in the datafiles vs the control files were out of whack. The database was garbage. You got real lucky to have a database you could even start. David From: Ofer Harel [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duplicate online Database Date: Tue, 04 Mar 2003 04:58:51 -0800 Unfortunately I found one of my database need a recovery back on time without a legal backup. There where only the disks backup. So I tried, I had nothing to lose. And it worked. Not documented, not recommended, but it worked. Of course, now this database is backup :) Ofer -Original Message- Sent: Tuesday, March 04, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Ofer, Are you suggesting that it is OK to copy an open database without using hot backup mode, as long as there isn't a log switch during copy? Do you use this method at your place of employment? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 4 Mar 2003, Ofer Harel wrote: if the database is not heavy updateable, i.e., the switching of redo log is rare, and the database is not too large, you can try this scenario: 1. copy (operation system) all the datafiles, redo log, etc.. you need to copied the hall database without a redo log switch in the middle. 2. Act with those files as its a hot backup 3. Recover the database using a 'backup controlfile to trace' 4. It work to me if you need more, email -Original Message- I need to duplicate online database Oracle 8.1.7. It is not possible to shutdown the primary database. Can I do online backup this primary database by RMAN, and + using archivelogs create duplicate database? Inconsistent backups of RMAN + archivelogs = duplicate database?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ofer Harel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Duplicate online Database
Thomas, To prevent the situation from occuring I have the SA exclude the mount points/directories where the database datafiles are located from the filesystem backups. I know this made our people who manage the Tivoli Storage Management system happy. From: Thomas Day [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duplicate online Database Date: Tue, 04 Mar 2003 07:19:35 -0800 The last time I had a UNIX SA backup an open database the backup software locked a control file just as Oracle was trying to write a checkpoint. Crashed the database and left the database unopenable. Fortunately (or per Oracle's recommendation) we had multiple copies of the control file and we just copied a good version over the corrupted one. Database worked fine after that. Personally I would never recommend backing up an open database and, if that were to happen, I would consider that backup to be a 'scratch' tape. david davis ddoralist To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @hotmail.comcc: Sent by: rootSubject: RE: Duplicate online Database 03/04/2003 09:49 AM Please respond to ORACLE-L I would never want to rely on that method. I had run into that several years ago (Y2K), a Unix Admin had backed up a server and restored to a test machine. Oracle wasn't shutdown at the time of the filesystem backup. The problems were numerous because of checkpoint information in the datafiles vs the control files were out of whack. The database was garbage. You got real lucky to have a database you could even start. David From: Ofer Harel [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duplicate online Database Date: Tue, 04 Mar 2003 04:58:51 -0800 Unfortunately I found one of my database need a recovery back on time without a legal backup. There where only the disks backup. So I tried, I had nothing to lose. And it worked. Not documented, not recommended, but it worked. Of course, now this database is backup :) Ofer -Original Message- Sent: Tuesday, March 04, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Ofer, Are you suggesting that it is OK to copy an open database without using hot backup mode, as long as there isn't a log switch during copy? Do you use this method at your place of employment? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 4 Mar 2003, Ofer Harel wrote: if the database is not heavy updateable, i.e., the switching of redo log is rare, and the database is not too large, you can try this scenario: 1. copy (operation system) all the datafiles, redo log, etc.. you need to copied the hall database without a redo log switch in the middle. 2. Act with those files as its a hot backup 3. Recover the database using a 'backup controlfile to trace' 4. It work to me if you need more, email -Original Message- I need to duplicate online database Oracle 8.1.7. It is not possible to shutdown the primary database. Can I do online backup this primary database by RMAN, and + using archivelogs create duplicate database? Inconsistent backups of RMAN + archivelogs = duplicate database?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ofer Harel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE
Listener/Database shutdown sequence
Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Listener/Database shutdown sequence
Tom, It is for the server auto-start/auto-shutdown procedures run by root. From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 09:04:11 -0800 David, it just doesn't matter. why do you even feel the need to shut the listener down? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 03, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Re: Listener/Database shutdown sequence
From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 08:19:06 -0800 Why do you/they think it matters, regardless of the documentation? You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down. Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up before the database opens. Otherwise, you will have to wait for instance registration with the listener, or force it with 'alter system register'. For dedicated connections, this problem can be avoided with a sid_desc in the listener.ora -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, david davis wrote: Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Listener/Database shutdown sequence
Jeremiah I didn't really think it mattered for the shutdown. Though I know in Oracle 7 it did matter for the startup (we use MTS). Another DBA seemed to imply that the sequence was important on shutdown of 8i. So if in doubt I RTFM, suffer the metalink search and post to the list. As usual, the most successful path is the list. Thx David From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 08:19:06 -0800 Why do you/they think it matters, regardless of the documentation? You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down. Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up before the database opens. Otherwise, you will have to wait for instance registration with the listener, or force it with 'alter system register'. For dedicated connections, this problem can be avoided with a sid_desc in the listener.ora -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, david davis wrote: Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ 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: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MS SQL hasn't given up!
Sorry but point 7 isn't exactly true. Transaction logging does take place and can be backed up for reapplication to a database backup. Its not perhaps as well implemented as Oracle's but I have a system with the transaction log backed up every 30 minutes. The implementation is different but the effect is the same with the ability to do point in time recovery. And they do have log shipping capability in SQL Server 2000 (Enterprise). The point that really bothered me was the lack of multiplexing the writes to the transaction logs (redo). DB2/UDB has it. The MSS method (only option) is to Mirror. David From: Jan Pruner [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: MS SQL hasn't given up! Date: Fri, 28 Feb 2003 07:19:10 -0800 Fresh in memory because 2 days ago I had meeting with MS SQL people from Microsoft. I will talk about MS SQL 2000 Enterprise. 1. MS SQL cannot handle exception. There is nothing like EXCEPTION WHEN ... THEN. 2. MS SQL has nothing like package. 3. MS SQL has nothing like partitioned table (next release in 2 years will have) 4. There is nothing like INSERT NOLOGGING. You have start/stop logging for whole session. 5. There's nothing like sequence (Well, IDENTITY column IS NOT sequence). 6. Well, you can use undocumented function pwdencrypt and pwdcompare to store passwords (the same hash function for storing users password is using MS SQL) :-) 7. There is nothing like ARCHIVE MODE in MS SQL. Just my notes from meeting. JP On Thursday 27 February 2003 21:35, you wrote: I agree - the biggest advantage Oracle has to MS SQL Server is Unix stability to Windows stability. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MS SQL hasn't given up!
Nope. Can backup online. However certain actions can't be perfomed while the transaction log is being backed. eg. Add new database file to the system. This also applies to database backups. David From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: MS SQL hasn't given up! Date: Fri, 28 Feb 2003 08:59:14 -0800 Not sure if this is true... I heard that to back up the transaction log, the database has to be stopped. ??? Pat. -Original Message- Sent: Friday, February 28, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Fresh in memory because 2 days ago I had meeting with MS SQL people from Microsoft. I will talk about MS SQL 2000 Enterprise. 1. MS SQL cannot handle exception. There is nothing like EXCEPTION WHEN ... THEN. 2. MS SQL has nothing like package. 3. MS SQL has nothing like partitioned table (next release in 2 years will have) 4. There is nothing like INSERT NOLOGGING. You have start/stop logging for whole session. 5. There's nothing like sequence (Well, IDENTITY column IS NOT sequence). 6. Well, you can use undocumented function pwdencrypt and pwdcompare to store passwords (the same hash function for storing users password is using MS SQL) :-) 7. There is nothing like ARCHIVE MODE in MS SQL. Just my notes from meeting. JP On Thursday 27 February 2003 21:35, you wrote: I agree - the biggest advantage Oracle has to MS SQL Server is Unix stability to Windows stability. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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 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: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MS SQL hasn't given up!
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: STEVE OLLIG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Dealing with 3rd Party Applications
it to TRUE for the instance. If you can set TIMED_STATISTICS to TRUE, then please use the sort=prsela,exeela,fchela clause with the TKPROF command; if it is FALSE, then please use sort=exeqry,execu,fchqry,fchcu clause. This way, the worst SQL statements will percolate to the top of the TKPROF report... If you can get a TKPROF report, would you like to paste the relevant section for the offending SQL statement back to the list? That way, you'll get lots of ideas from the best tuning folks in the world. And don't forget to DISABLE or DROP that trigger when you've gotten your trace! Coming from personal experience, it is *VERY* embarrassing to have to explain why the file-system housing the USER_DUMP_DEST keeps filling up... :-( Also how do you usually deal with 3rd party application issues like this? 95% of our databases/applications are from 3rd party vendors and it's a pain trying to get them performing better. We never have control over the application and it is always a pain. However, don't neglect the possibility that the application is somehow misconfigured or configured inappropriately somehow. It's not easy to ask questions about this without triggering the knee-jerk No! Everything's fine! response, but is it reasonable that an application session would need to perform those several-thousand queries at each login? Is it a two-tier (a.k.a. client-server) application where every user session spawns a corresponding database session, or is it an N-tier application where the app-server is creating a pool of database connections. A huge up-front load like you describe is more characteristic of the N-tier app-server, and less characteristic of client-server connections. Just some food for thought... Thanks, Jeff Eberhard Good luck! -- 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). -- 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). _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: newbie dba question
Alex In my experience, when I have inherited systems worrying about tuning was the least of my concerns. I could think of other things to look into first (no particular order): - Backup/Recovery procedures - like do backups happen, archivelog mode on (you would be surprised) - Database Event monitoring and notification processes in place - Security - Database Layout - System Resources = got enough room for your next backup As for tuning, I will leave that for the many DBA's on the list who are Guru's in that field. David From: Alex Dashko [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: newbie dba question Date: Wed, 26 Feb 2003 19:53:48 -0800 Hello Gurus, I heard that if I can get great ORACLE advice, this is the place, so here is my question. I've been asked to take over an existing db in production. What would be the right way to get a quick understanding on what's happening in it in terms ways for proactive tuning? I am just getting started while trying to be ahead of the curve. Is this something I should be looking into, or is it more like if it ain't broke, don't fix it? :). It'd be nice to get started and have a good view on what's going on. Also, can someone can share their experience on what can be done when customers report intermittent, but rather dramatic slowdowns in the system. Please note, the slowdowns are reported to be occurring in the entire system. What would be a good place to look when this happens and get some quick feedback? Thank you very much! Best regards, Alex - Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL - Exception Handling for utl_file
Perhaps someone on the list will know the answer as I have not found anything in the manual (though I might have missed it). If a procedure is performing file i/o to more than one file and an exception is raised related to the utl_file package how can I determine which file had the exception? eg. begin ... utl_file.put_line(fh_extract,v_extract_dataline); utl_file.put_line(fh_log,v_logmsg); ... exception when utl_file.write_error then ... end; David _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 long to hold onto old Oracle CDs?
Wild. You would think a business that makes and sells software would keep better track of it. Sounds kind of sloppy. So I guess I got lucky. David From: Mogens Nørgaard [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 21:48:50 -0800 On the local level (eg Denmark) they might have a CD or they might not. There won't be a centralised, systematic archiving effort. Frankly, when I was in Support, I would sometimes contact a customer that I knew had a certain (old) version and have them ship a copy or lend it to me, so that I could help another customer. I'm not sure there's a central archive at HQ either. I've never heard about it, which doesn't say much, but I know for a fact about certain versions on certain platforms that couldn't even be located in Development during their supported cycle - but that's the odd exception, of course. I'd be very surprised if Oracle has a registered copy of version 5 in an archive, although there might still be some sensitive and confidential installations around with that version running. Mogens david davis wrote: I cut an iTAR on Metalink back last Oct. It would have been simpler. If someone had maintained our support agreement. But while that was being resolved. The sent me the CD. I got the CD in a couple of days. I was informed by someone at IBM that Oracle could burn new CD's. If you truly have a need for the CD. Such as lost/broken. Put pressure on them via your account rep. I hardly think it is likely for a vendor to say they don't have the code. If we have people on the list with software dating back to Oracle 4, I doubt Oracle is purging its archives of the software. It would be irrational. It is more likely they are just being difficult. Doing nothing is always the easiest route for the vendor. From: Adams, Matthew (GECP, MABG, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 09:24:11 -0800 Two months ago, I tried to order older non-supported CDs (7.3, 8.0.5, 8.0.6) and they told me they could not ship them. How did you order them? Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Monday, February 24, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Actually the CD's are available. You just have to request them from Oracle. Of course, this does depend upon having a support contract. Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to cracked media. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 06:58:58 -0800 Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see
RE: Top 10 DBA Do's and Don'ts anyone - Here is my list,
I agree with not relying on a GUI tool, but can't necessarily agree with a Good DBA will use command line SQL first. Personally, I figure a good DBA should make effective use of their time. Use or don't use the tool when it makes sense to do so. I use the tools for one off items but not for applying mass changes or items I want to batch. Good thing I am not sensitive. :-) Perhaps a Don't Don't rush in applying changes to the database without reviewing/testing first. David Davis Mediocre DBA Manulife Financial From: Karniotis, Stephen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, Date: Sun, 23 Feb 2003 16:28:43 -0800 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
Re: How long to hold onto old Oracle CDs?
Actually the CD's are available. You just have to request them from Oracle. Of course, this does depend upon having a support contract. Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to cracked media. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 06:58:58 -0800 Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 long to hold onto old Oracle CDs?
How about making them into clocks. I have seen this done. A potential revenue source is available. Or drink coasters for the fashionable IT person. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 09:19:00 -0800 Yeah, these are actually replacements, too. But when I ordered them, the person (back when you could actually talk to a person on a non-level 1 call) was surprised that they had any 7.x media in stock. She had said that they would distribute the CDs only as long as they had stock. Maybe I'll make an Oracle Mobile using these CDs and all the Start Here CDs that come with every pack. At least I won't be throwing them out... :) Thx! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Actually the CD's are available. You just have to request them from Oracle. Of course, this does depend upon having a support contract. Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to cracked media. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 06:58:58 -0800 Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using fully qualified table_name.database_object in
Our application vendor code doesn't pre-qualify table references and to isolate batch processes from running under the object owner. I use synonyms (public) so the code doesn't have to change but I get the security isolation that I want. Wouldn't want a developer sliding a drop table into his code or perhaps a delete/update to the vendor's audit trail. I have 5800 synonyms in our OLTP environment and about 1300 in our reporting environment. I have not found it difficult to manage (well not very - the wrapped database links are a little more work) and our application is always changing (or so it seems). What's the big deal with herding cats. The sleep for like 23 1/2 hrs a day. David Davis Manulife Financial From: Nelson, Allan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Using fully qualified table_name.database_object in Date: Mon, 24 Feb 2003 10:18:53 -0800 Most application developers in my experience are in love with synonyms exactly so they won't have to fully qualify the table name. Oracle uses them fairly extensively in APPs. They do require some overhead for looking up the synonym and they can be a mess if nested deeply enough. Controlling use of synonyms on the other hand is a lot like herding cats. Allan -Original Message- From: laura pena [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 10:29 AM To: Multiple recipients of list ORACLE-L code? I would like to know if it is advocated to use fully qualified table_name.database objects in application code. Example would be schema.table_name in a PL/SQL code. I would like to know the Pros/Cons if there are any? Thanks in advance. _ Do you Yahoo!? Yahoo! http://rd.yahoo.com/finance/mailtagline/*http://taxes.yahoo.com/ Tax Center - forms, calculators, tips, and more __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 long to hold onto old Oracle CDs?
I cut an iTAR on Metalink back last Oct. It would have been simpler. If someone had maintained our support agreement. But while that was being resolved. The sent me the CD. I got the CD in a couple of days. I was informed by someone at IBM that Oracle could burn new CD's. If you truly have a need for the CD. Such as lost/broken. Put pressure on them via your account rep. I hardly think it is likely for a vendor to say they don't have the code. If we have people on the list with software dating back to Oracle 4, I doubt Oracle is purging its archives of the software. It would be irrational. It is more likely they are just being difficult. Doing nothing is always the easiest route for the vendor. From: Adams, Matthew (GECP, MABG, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 09:24:11 -0800 Two months ago, I tried to order older non-supported CDs (7.3, 8.0.5, 8.0.6) and they told me they could not ship them. How did you order them? Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Monday, February 24, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Actually the CD's are available. You just have to request them from Oracle. Of course, this does depend upon having a support contract. Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to cracked media. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 06:58:58 -0800 Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Programming languages that make DBA's lives easier
I think it would be more appropriate to say. Today is a good day to die! From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Programming languages that make DBA's lives easier Date: Wed, 19 Feb 2003 09:59:12 -0800 Live long and prosper! -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier Klingon. -Original Message- If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? -- 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i or 9i ?
In your scenario - I would install the same version as what is being taught in your course. You can always install 9i later after you become comfortable with 8i. David Davis From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Mon, 17 Feb 2003 11:28:58 -0800 I'm going to go ahead w/ the Oracle 8i course. I spoke w/ the course instructor and he also advised me to take the 8i course because Oracle8i is what is out there. So my question is: Should I install Oracle 8i or 9i at home? What would u guys do? I would love to learn both. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 16, 2003 5:23 AM hello ... and offers more features like xml database, bulk query, can be set compatible to 8i, ... if you can choose take 9i. that's what we did. BUT: nothing is flawless. Be prepared for patches and pitfalls - even in 9i rel 2. We run 9i and 8i on NT5 and Solaris 8 and 9 and linux. patches and pitfalls in the UNIX world are almost the same, little differences to the NT world. Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna [EMAIL PROTECTED] 02/16/03 06:05 AM If its just the basic's I think 9i is actually easier than the older versions. For example using Undo Management instead of trying to learn the use of Rollback segments. Of course with Oracle (like most vendors) you can get bogged down when the kitchen sink has been tossed at you on the install CD's. It can seem overwhelming. From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Sat, 15 Feb 2003 17:33:39 -0800 Is 9i a lot more difficult to learn than 8i? Can i use what I learned on 8i on 9i? --pachanga - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 2:43 PM Les, Something to consider on which to choose is the market pentration for 9i implementations. I work for a large insurance company which has zero 9i implementations. In fact as far as I know the key system I work on will probably be the first one (Oracle 7.3.4 - 9i) going in Q3/Q4. Most of our systems are 8 with some on 8i. Clients are funny in not wanting to part with money to perform database upgrades. If they don't see any benefit from it. On that basis, you might want to consider at least learning something about 8i as it would be very likely you would run into a client that is using it. Though going the 8i classes then upgrading to 9i does feel like a lot of work. Something I hate. :-) David Davis Manulife Financial From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Fri, 14 Feb 2003 15:53:46 -0800 Thanks, that got me happy since I do have a couple years of windows experience ;) So now, i have 1 vote for oracle 8i and one for 9i. Any other opinions? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 1:54 PM Les - Oh you wanted the hard questions answered as well. Given that you mentioned you were a MS sys admin, I'd say that would give you a leg up. A lot of shops have combined DBA/Sys admins for MS. That might be your easiest transition. I hate to say this, especially on this list, but you may want to look at adding MS SQL certification just to give you more options, like the target employer might have Oracle and MS SQL. Depending on your salary demands, your chances of getting on as a newbie DBA are probably okay. A lot depends on your networking ability, good resume, no criminal record that can be easily traced ;-), good personal hygiene, charm in interviews, persistence, and just plain luck. The ecommerce side has had a real dose of reality in the last couple of years, but is still there. Consider just getting some Oracle experience and then moving over to ecommerce. Most companies still have some type of ecommerce area. Otherwise, in your spare time, learn everything you can about ecommerce from the marketing drivel down to HTML. These are obviously not well-informed opinions, but worth every penny you paid ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Thanks for the replies
RE: {SPAM?} RE: Teradata baned from IOUG???
Another advantage of SQR is multi-platform. We used to run SQR/MVS against DB2, now run it on Unix against Oracle and of course the SQR for Windows product against Oracle. It was simple to port our SQR code from DB2/MVS to Oracle. Now it might be tougher as we use a lot of Oracle specific stuff in our queries which makes it harder to port. But SQR is a decent product. We use it with PeopleSoft but another part of our business (Investment division) also uses the product for their systems. I wish I had it available for use with one of our finance systems. Having to program in PL/SQL. That's a real drag when it comes to doing file i/o for logs/reports. From: Jamadagni, Rajendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: {SPAM?} RE: Teradata baned from IOUG??? Date: Fri, 14 Feb 2003 07:29:29 -0800 Well, I see one reason ... (I am no expert in Oracle reports), but it seems more maintainable to write in SQR than in reports (so they claim here). Plus SQR can act asa glorified data loader when a bunch of processing needs to be done on incoming raw data. I wouldn't discount SQR right away, but after all it is almost glorified COBOL (IMHO). Doing dynamic SQL is much much easier in SQR than in Oracle Reports (again my experience SQR 4/5/6 and ORacle Reports 6/6i). SQRs use of lookup tables and breaks make life simpler as well. It has usable array interface ... for data processing. We have couple of SQR reports that run in about 4000 lines of code (don't ask me why) My $0.01 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, February 14, 2003 10:09 AM To: Multiple recipients of list ORACLE-L We looked at SQR in 94. We didn't have need of controlling fonts and such, which I guess SQR is good at. The SQR rep could come up with no compelling reason to use SQR rather than Perl, so simple ( as in not much procedural processing needed ) reports were done in Sqlplus. Anything complex was done in Perl. We never regretted that decision. Jared ESPN_Disclaimer.txt _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i or 9i ?
Les, Something to consider on which to choose is the market pentration for 9i implementations. I work for a large insurance company which has zero 9i implementations. In fact as far as I know the key system I work on will probably be the first one (Oracle 7.3.4 - 9i) going in Q3/Q4. Most of our systems are 8 with some on 8i. Clients are funny in not wanting to part with money to perform database upgrades. If they don't see any benefit from it. On that basis, you might want to consider at least learning something about 8i as it would be very likely you would run into a client that is using it. Though going the 8i classes then upgrading to 9i does feel like a lot of work. Something I hate. :-) David Davis Manulife Financial From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Fri, 14 Feb 2003 15:53:46 -0800 Thanks, that got me happy since I do have a couple years of windows experience ;) So now, i have 1 vote for oracle 8i and one for 9i. Any other opinions? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 1:54 PM Les - Oh you wanted the hard questions answered as well. Given that you mentioned you were a MS sys admin, I'd say that would give you a leg up. A lot of shops have combined DBA/Sys admins for MS. That might be your easiest transition. I hate to say this, especially on this list, but you may want to look at adding MS SQL certification just to give you more options, like the target employer might have Oracle and MS SQL. Depending on your salary demands, your chances of getting on as a newbie DBA are probably okay. A lot depends on your networking ability, good resume, no criminal record that can be easily traced ;-), good personal hygiene, charm in interviews, persistence, and just plain luck. The ecommerce side has had a real dose of reality in the last couple of years, but is still there. Consider just getting some Oracle experience and then moving over to ecommerce. Most companies still have some type of ecommerce area. Otherwise, in your spare time, learn everything you can about ecommerce from the marketing drivel down to HTML. These are obviously not well-informed opinions, but worth every penny you paid ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Thanks for the replies guys, I really appreciate it. Can i get some input on these 2 questions: What chances am I looking at to getting hired as a newbie DBA once I graduate? I want to get into the Ecommerce side of Oracle (connecting DBs to websites/portals?). Which certification/path should I be following? Thanks in advance!! THANKS, I'M STARTING TO LIKE THIS LIST ALREADY! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 12:35 PM Les - Here is an idea for you. Think up a trivial application for a database. Maybe your home albums or DVDs. Try to make it a little relational, like have an artist table. Force yourself to work with it. At the right time I was secretary of a bowling league, so each year I rewrote a league management program in a different language, whatever I needed to learn. I went through Oracle, COBOL, Perl, C, all in different years. The point is that by playing user you get a good feel for why the heck somebody would use a database to begin with. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 2:00 PM To: Multiple recipients of list ORACLE-L I'm more of a windoz SA and have been working with a little Unix here there for hte past 2yrs (RH, Mandrake, Solaris). What I really want to accomplish is to switch to Unix and Databases. My goal is to use my certifcation as a way to get my foot in the door of the DB world and after a couple of years, do some consulting. I downloaded oracle 9i for Solaris and have yet to install it because I wanted to read up on Oracle 1st. Will install it this weekend ;) I want to work with DBs because I think it's always going to be about managing information and the need is never going to die. I don't know of any midsize companies who would survive w/o some type of DB and after being laid off twice, I'm reconsidering going into a different IT career. - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Friday, February 14, 2003 8:34 AM The $3000 is true if he takes them through 'oracle' university but not if the local community college offers the classes. What I did (and it seemed to work fine) for my
Re: Oracle 8i or 9i ?
If its just the basic's I think 9i is actually easier than the older versions. For example using Undo Management instead of trying to learn the use of Rollback segments. Of course with Oracle (like most vendors) you can get bogged down when the kitchen sink has been tossed at you on the install CD's. It can seem overwhelming. From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Sat, 15 Feb 2003 17:33:39 -0800 Is 9i a lot more difficult to learn than 8i? Can i use what I learned on 8i on 9i? --pachanga - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, February 15, 2003 2:43 PM Les, Something to consider on which to choose is the market pentration for 9i implementations. I work for a large insurance company which has zero 9i implementations. In fact as far as I know the key system I work on will probably be the first one (Oracle 7.3.4 - 9i) going in Q3/Q4. Most of our systems are 8 with some on 8i. Clients are funny in not wanting to part with money to perform database upgrades. If they don't see any benefit from it. On that basis, you might want to consider at least learning something about 8i as it would be very likely you would run into a client that is using it. Though going the 8i classes then upgrading to 9i does feel like a lot of work. Something I hate. :-) David Davis Manulife Financial From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle 8i or 9i ? Date: Fri, 14 Feb 2003 15:53:46 -0800 Thanks, that got me happy since I do have a couple years of windows experience ;) So now, i have 1 vote for oracle 8i and one for 9i. Any other opinions? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 1:54 PM Les - Oh you wanted the hard questions answered as well. Given that you mentioned you were a MS sys admin, I'd say that would give you a leg up. A lot of shops have combined DBA/Sys admins for MS. That might be your easiest transition. I hate to say this, especially on this list, but you may want to look at adding MS SQL certification just to give you more options, like the target employer might have Oracle and MS SQL. Depending on your salary demands, your chances of getting on as a newbie DBA are probably okay. A lot depends on your networking ability, good resume, no criminal record that can be easily traced ;-), good personal hygiene, charm in interviews, persistence, and just plain luck. The ecommerce side has had a real dose of reality in the last couple of years, but is still there. Consider just getting some Oracle experience and then moving over to ecommerce. Most companies still have some type of ecommerce area. Otherwise, in your spare time, learn everything you can about ecommerce from the marketing drivel down to HTML. These are obviously not well-informed opinions, but worth every penny you paid ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Thanks for the replies guys, I really appreciate it. Can i get some input on these 2 questions: What chances am I looking at to getting hired as a newbie DBA once I graduate? I want to get into the Ecommerce side of Oracle (connecting DBs to websites/portals?). Which certification/path should I be following? Thanks in advance!! THANKS, I'M STARTING TO LIKE THIS LIST ALREADY! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 14, 2003 12:35 PM Les - Here is an idea for you. Think up a trivial application for a database. Maybe your home albums or DVDs. Try to make it a little relational, like have an artist table. Force yourself to work with it. At the right time I was secretary of a bowling league, so each year I rewrote a league management program in a different language, whatever I needed to learn. I went through Oracle, COBOL, Perl, C, all in different years. The point is that by playing user you get a good feel for why the heck somebody would use a database to begin with. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 2:00 PM To: Multiple recipients of list ORACLE-L I'm more of a windoz SA and have been working with a little Unix here there for hte past 2yrs (RH, Mandrake, Solaris). What I really want to accomplish
Re: {SPAM?} RE: Teradata baned from IOUG???
Good Advice. But Alas, I have not yet had the time to learn Perl. Though I have all the material to learn it. Including a interesting little book Perl for Oracle DBAs. One of these days I will stop treading water and starting swimming for shore. From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED], david davis [EMAIL PROTECTED] Subject: Re: {SPAM?} RE: Teradata baned from IOUG??? Date: Sat, 15 Feb 2003 18:50:05 -0800 Try Perl. It's magnitudes better than PL/SQL for files and logs. Jared On Saturday 15 February 2003 14:23, david davis wrote: Another advantage of SQR is multi-platform. We used to run SQR/MVS against DB2, now run it on Unix against Oracle and of course the SQR for Windows product against Oracle. It was simple to port our SQR code from DB2/MVS to Oracle. Now it might be tougher as we use a lot of Oracle specific stuff in our queries which makes it harder to port. But SQR is a decent product. We use it with PeopleSoft but another part of our business (Investment division) also uses the product for their systems. I wish I had it available for use with one of our finance systems. Having to program in PL/SQL. That's a real drag when it comes to doing file i/o for logs/reports. From: Jamadagni, Rajendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: {SPAM?} RE: Teradata baned from IOUG??? Date: Fri, 14 Feb 2003 07:29:29 -0800 Well, I see one reason ... (I am no expert in Oracle reports), but it seems more maintainable to write in SQR than in reports (so they claim here). Plus SQR can act asa glorified data loader when a bunch of processing needs to be done on incoming raw data. I wouldn't discount SQR right away, but after all it is almost glorified COBOL (IMHO). Doing dynamic SQL is much much easier in SQR than in Oracle Reports (again my experience SQR 4/5/6 and ORacle Reports 6/6i). SQRs use of lookup tables and breaks make life simpler as well. It has usable array interface ... for data processing. We have couple of SQR reports that run in about 4000 lines of code (don't ask me why) My $0.01 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, February 14, 2003 10:09 AM To: Multiple recipients of list ORACLE-L We looked at SQR in 94. We didn't have need of controlling fonts and such, which I guess SQR is good at. The SQR rep could come up with no compelling reason to use SQR rather than Perl, so simple ( as in not much procedural processing needed ) reports were done in Sqlplus. Anything complex was done in Perl. We never regretted that decision. Jared ESPN_Disclaimer.txt _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Know 1 database, know them all?
Must have been basic theory or perhaps they were referring to ANSI SQL which we all use. You will find substantial differences between UDB, DB2/MVS, Oracle and SQL Server and all the others. I have worked at one time or another with the above mentioned and moving from one to another was fairly easy as a developer but for a DBA it was more complicated due to architecture differences in implementation. Of course, maybe I am just a slow learner. btw This guy was he the same one that said in a couple of years programmers won't be needed anymore or perhaps that 640K is all that you will ever need. David Davis Manulife Financial From: Les Ayudo [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Know 1 database, know them all? Date: Sat, 15 Feb 2003 17:38:38 -0800 I overheard one guy mention that once you learn one database, you know them all. Is this true? Or was he just talking about the theory behind the db? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PS question
Lisa, I have seen no requirement for DBMS_JOB from PeopleSoft in HRMS 7.5 (or earlier). Though we have used it in the past ourselves when we were doing replication. I do see DBMS_IJOB running (due to job_queue_processes being set) but that wasn't a PeopleSoft thing. As a general rule PeopleSoft avoids DBMS specific features (hence no triggers, sequences, RI features. David Davis From: Koivu, Lisa [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: PS question Date: Fri, 31 Jan 2003 11:17:08 -0500 Good morning, my esteemed friends, If you have a moment to answer a question, I would be most grateful. If you don't, that's OK, delete away :) What does Peoplesoft use DBMS_JOB for? Do you know? The previous DBA obviously has no clue. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-309-4157 _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: Peoplesoft Oracle
Dick, The grant users option has been around since release 2 (was on installation table back then). I had not tested turning it off. Our practice is create the userid then change the default tablespaces then notify clients of new userid. It works for us, because the DBA's happen to be the security administrators. If you are creating the Oracle side of the user account, how are you doing password synchronisation? PeopleSoft 8 has password aging done within the application, but to use pure database password aging prior to PeopleSoft 8 you can use Braintree's SQLSecure product. The peopleSoft software has DLL/database integration with the product if you have it installed. It also does cross database password synchronisation. I thought the lowest common denominator was DB2 guess its been lowered. The do Windows development on SQLServer, but Unix is done on UDB. I wonder if PeopleSoft will move away from SQLServer as a source development platform now the Microsoft is trying to get into the CRM business. Direct competition. David Davis From: [EMAIL PROTECTED] To: david davis [EMAIL PROTECTED], Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re[2]: Peoplesoft Oracle Date: Wed, 29 Jan 2003 09:44:23 -0500 David Lisa, 1st point is that were still on PeopleTools 7.53 so this may be somewhat dated. Anyway, go to Peopletools, utilities, use Peopletools options. Uncheck the Grant Access option low behold, PeopleTools will not try to create a user via the grant connect to syntax that is so out dated as to be atrocious. The down side is that you now have to create the user manually, but we did put together a trigger/dbms_job system that does it automatically as we wanted. Now why in tarnation would one want to do that, Well as it turns out if you use that syntax, as Lisa noted, everyone is assigned SYSTEM as their default and temp tablespace. Well that's not so bad since their there only for a very brief period of time before changing over to SYSADMIN or whatever else you happen to use. The problem is that PeopleSoft in their VAST wisdom coded the first 2 select statements with a group by in them, just incase there was a duplication of data in ps.psdbowner and/or psoprdefn. Now I do not want to bad mouth them because that was not a bad idea. The bad point is that you end up with temp segments in system and a fragmented system tablespace. YUCK!! OH for 9i and a system wide default temp tablespace!! OH, also one item of extreme note. DON'T setup password aging for your users. PeopleTools doesn't appreciate it at all. BTW: I would not say that PeopleSoft does not know databases, they just minored in them instead. The real problem is that they code to the least common denominator in the dbms market, namely SqlServer. So be prepared for lots of fun, and do watch Customer Connection. They every once in a while come out with a note or patch that is Oracle specific and really does help. One would think that there'd be more of them since something like 75% of PeopleSoft's installs are on Oracle. Of course their development is on Sql Server. Go figure!! Dick Goulet Reply Separator Subject:Re: Peoplesoft Oracle Author: david davis [EMAIL PROTECTED] Date: 1/28/2003 8:13 PM There is a resolution 19368 on customer connection which discusses which rights the SYSADM account requires and which ones can be revoked. Though it was somewhat better formatted when I retrieved it in 1999. It was last modified in 2002. I am curious how you turn off the create user? I didn't think you could do that, only control the grants that take place. A little gotcha I ran into a couple of years ago when I revoked access was that had errors in app designer. The DLL referenced DBA_TABLES (oops) I think that was in V7.0. David Davis From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Peoplesoft Oracle Date: Tue, 28 Jan 2003 14:39:21 -0800 Lisa, Sounds like a default install of PeopleSoft. Step 1 that you can do is re-assign everyone to use a real temp tablespace. Step 2 is break up that db onto seperate spindles. Step 3 is to turn off autoextend exept for those tablespaces that are nearing say 90% full, then set autoextend to something sensible. As far as the user accounts are concerned that's normal. I for one would revoke DBA from sysadmin grant alter any user instead. Afterwards, I'd get into PeopleTools turn off the creat user function. I could write more, but this should keep you VERY busy. Dick Goulet Koivu; Lisa [EMAIL PROTECTED] wrote on 1/28/03 1:08 pm: Hello everyone, My apologies for bombarding the list with more questions than answers as of late. This one is pretty desparate. For those of you who support Peoplesoft databases - Are there any websites that you frequent to check for quirks, weird anomalies, etc. related
Re: Peoplesoft Oracle
There is a resolution 19368 on customer connection which discusses which rights the SYSADM account requires and which ones can be revoked. Though it was somewhat better formatted when I retrieved it in 1999. It was last modified in 2002. I am curious how you turn off the create user? I didn't think you could do that, only control the grants that take place. A little gotcha I ran into a couple of years ago when I revoked access was that had errors in app designer. The DLL referenced DBA_TABLES (oops) I think that was in V7.0. David Davis From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Peoplesoft Oracle Date: Tue, 28 Jan 2003 14:39:21 -0800 Lisa, Sounds like a default install of PeopleSoft. Step 1 that you can do is re-assign everyone to use a real temp tablespace. Step 2 is break up that db onto seperate spindles. Step 3 is to turn off autoextend exept for those tablespaces that are nearing say 90% full, then set autoextend to something sensible. As far as the user accounts are concerned that's normal. I for one would revoke DBA from sysadmin grant alter any user instead. Afterwards, I'd get into PeopleTools turn off the creat user function. I could write more, but this should keep you VERY busy. Dick Goulet Koivu; Lisa [EMAIL PROTECTED] wrote on 1/28/03 1:08 pm: Hello everyone, My apologies for bombarding the list with more questions than answers as of late. This one is pretty desparate. For those of you who support Peoplesoft databases - Are there any websites that you frequent to check for quirks, weird anomalies, etc. related to your specific Peoplesoft/Oracle combination? I've just inherited this environment. It's Oracle 8.1.7 on AIX. I don't know the version of AIX and I don't know the version(s) of the Peoplesoft modules being used. However I am seeing some very weird things - not the least of which is every tablespace is dictionary managed, all are on autoextend, there are 600 open database accounts but it looks like the app only connects as SYSADM, all users have SYSTEM for default/temp ts, the entire freaking database is on one disk, all redologs (one in each group) are on one disk, etc., etc., etc. The list goes on. I'm afraid to turn this environment upside down and fix it because management is only interested in keeping the system alive, not improving it. The previous DBA is elusive at best, probably because I yelled at him last year after catching him creating objects on the fly in my databases :) I'll do the obvious things like add redologs and check backup and recovery, etc. User error is extraordinarily high in this environment. Everything else I am afraid to touch without doing my homework first. Any websites, suggestions, comments, etc. would be greatly appreciated. The only good thing to come of all this is I'M BAACK in Unix again !!! Woo Hoo!!! Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 6.0.6249.1 TITLEPeoplesoft amp; Oracle/TITLE /HEAD BODY !-- Converted from text/rtf format -- PFONT SIZE=2 FACE=ArialHello everyone, /FONT /P PFONT SIZE=2 FACE=ArialMy apologies for bombarding the list with more questions than answers as of late.nbsp; This one is pretty desparate. /FONT /P PFONT SIZE=2 FACE=ArialFor those of you who support Peoplesoft databases - Are there any websites that you frequent to check for quirks, weird anomalies, etc. related to your specific Peoplesoft/Oracle combination?nbsp; /FONT/P PFONT SIZE=2 FACE=ArialI've just inherited this environment.nbsp; It's Oracle 8.1.7 on AIX.nbsp; I don't know the version of AIX and I don't know the version(s) of the Peoplesoft modules being used.nbsp; However I am seeing some very weird things - not the least of which is every tablespace is dictionary managed, all are on autoextend, there are 600 open database accounts but it looks like the app only connects as SYSADM, all users have SYSTEM for default/temp ts, the entire freaking database is on one disk, all redologs (one in each group) are on one disk, etc., etc., etc.nbsp; The list goes on.nbsp; I'm afraid to turn this environment upside down and fix it because management is only interested in keeping the system alive, not improving it.nbsp; The previous DBA is elusive at best, probably because I yelled at him last year after catching him creating objects on the fly in my databases :)/FONT/P PFONT SIZE=2 FACE=ArialI'll do the obvious things like add redologs and check backup and recovery, etc.nbsp; User error is extraordinarily high in this environment.nbsp; Everything else I am afraid to touch without doing my homework first.nbsp; Any websites, suggestions
Re: Peoplesoft Oracle
Lisa, What you have described is a PeopleSoft database with bad habits. The usage of dictionary managed tablespaces is normal but will probably change over time. While the PeopleSoft installation guide and delivered scripts create using the older method, you can certainly using the locally managed approach. There is a document red paper on PeopleSoft customer connection titled PeopleSoft 8 Batch Performance on Oracle Database that is probably worth downloading. Path to the documents is products|peopletools|peopletools resource library. Alas, documentation from the vendor is weak. Or as I have discovered postively brilliant in comparison to other vendors who say nothing configure Oracle the same as SQL Server {doh}. Can't really comment on the autoextend. Use it myself to delay going through change mgmt process. :-) PeopleSoft does deliver a script to autoextend but it is not the default. So that was a deliberate choice of the DBA. It is normal for all application users to connect via the schema owner. The users Oracle account is used during the logon process for cross authentication with application security and the database. This changes to certain degree in PeopleTools 8 family. I believe at some point in PeopleSoft 8, you will have the possibilty of losing the individuals Oracle userid and connection is via the app server (tuxedo) and connection id. The user when accessing PeopleSoft is only connected to Oracle using their userid for an extremely brief time so it is really what is set for the SYSADM account that is key. I have as standard practice set the the default tablespace and temp tablespace after userids are created. Just being tidy besides shows up on my monitoring reports. The entire database on one disk. That isn't the vendor's fault. They state before installing the database to modify the scripts to specify the filesystem locations. One disk or a hundred, that is the DBA's responsibility. You can certainly move tablespaces, redo logs around as needed. On the other hand there are things you should be careful with (eg.). Don't just change the password for SYSADM except via the PeopleSoft security administration (unless you wanted to be hunted down by users). Also applies to user accounts. Moving tables to other tablespaces should first be done via the application designer tool first which updates the meta-data (peopletools tables). Objects that maintain PeopleTools meta-data should be first created in App Designer and then built using the generated SQL script. I would suggest reading the Administration guide which covers things such as the DDL Model, security administration etc. Also, the installation guide has some stuff for tuning (snicker). A couple of reports available for the application DDDAUDIT SYSAUDIT. Our environment is very stable. PeopleSoft HRMS 7.51, PeopleTools 7.58 HP/UX 10.20, Oracle 7.3.4 {Hoping to upgrade to 9i and HP/UX 11i this year} All batch processing is via Control-M scheduler and not the vendor delivered program launcher aka process scheduler. All access via external processes connect using their own userid (O/S authenticated for batch) with explicit grants. Nobody (clients/developers/support staff) has direct access to SYSADM except for the DBA's. Our reporting environment is a hybrid of 3.22, 7.0, 7.51 custom structures based on PeopleTools 7.58. The environment is populated via SQL Server DTS (el cheapo ETL)and database links. We have previously used Oracle Replication (lots of problems on Oracle 7 (maybe it was the 600 snapshots)) but now use custom triggers etc. If you can dream of it, you can do it. Its just the administration can be a bit of work until you understand it and have things setup in a fashion that makes sense for you. References: David Kurtz posted a document PeopleSoft for the Oracle DBA on customer connection. Check out his site www.go-faster.co.uk. He may have a more current document (mine is 1999, but then I am used to out of date software). sites: www.slerp.com peoplesoft.ittoolbox.com I have looked at them but don't generally rely on them. I do believe there is a Peoplesoft list that might be worth joining. Ensure you have access to customer connection. You might as well be tortured like the rest of us trying to find things. David Davis, DBA Manulife Financial [EMAIL PROTECTED] From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Peoplesoft Oracle Date: Tue, 28 Jan 2003 13:08:59 -0800 Hello everyone, My apologies for bombarding the list with more questions than answers as of late. This one is pretty desparate. For those of you who support Peoplesoft databases - Are there any websites that you frequent to check for quirks, weird anomalies, etc. related to your specific Peoplesoft/Oracle combination? I've just inherited this environment. It's Oracle 8.1.7 on AIX. I don't know
RE: senior oracle dba
It is definately an HR thing. I went from being an PeopleSoft application developer to a Senior DBA overnight (DBA quit and I volunteered). I knew diddly (sometimes still feel that way 5 yrs later) but because I was a senior developer they had to make me a senior DBA for HR seniority/compensation reasons. This happens all the time. Titles don't mean a whole lot. David Davis, Just a DBA Manulife Financial From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: senior oracle dba Date: Wed, 22 Jan 2003 11:08:09 -0800 Bp, Often where the term Senior DBA comes up is with company HR departments. It isn't usual for we DBAs to greet each other with Hi, I'm a senior DBA. I agree with Mark's comments, but just wanted to point out this other aspect to the issue. Sometimes HR people use this as a method for categorizing people in terms of making sense out of salaries. HR criteria may have nothing to do with what you are thinking of. Personally I often can't understand HR criteria. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 22, 2003 12:05 PM To: Multiple recipients of list ORACLE-L Mark , Thanks for the reply . I think learning is a never ending process , specially in IT industry where new version of software is out before 30% adapts the previous version .But is there a line which can be drawn ? No one knows everything . But experience tells where to look for proper things and what plannings and cautions to be taken before adapting any change . -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 3:39 PM Bp, All I know is that I'm not a senior DBA. I think you'll know if you really are or not. Have you worked with clustered databases, different types of partitioning, different os / io / backup architectures, rman, fgac, capacity planning, tuning, etc? There's a million things you may or may not have had exposure to, and while there isn't a magical number where you qualify I think it's where you have experienced a lot. I've worked with people who have been working with Oracle for ~15 years and their understanding of the product, and history of experiences, makes me realise how junior I am. Are you asking because you are considering applying for a job or perhaps looking for a change to your position description? BigP big_planet_2000@ho To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tmail.comcc: Sent by: Subject: senior oracle dba [EMAIL PROTECTED] 22/01/2003 10:05 Please respond to ORACLE-L How does one qualify for senior oracel dba. Do you guys have any questionare which I can ask myself . -Bp Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: senior oracle dba
DBA = Damn Bad Attitude or as my management feel, cranky, moody, difficult cynical - typical DBA. From: Hately, Mike (NESL-IT) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: senior oracle dba Date: Thu, 23 Jan 2003 06:09:09 -0800 Senior isn't an absolute term. A senior DBA in a small development house could be the guy who knows how to add a tablespace. A senior DBA in a large company may have to combine a good level of technical ability with a good deal of management and business skills. The term also seems to be used to imply a high level of experience and/or length of service. I have to admit it does sound better than 'old and cynical'. Regards, Mike Hately -Original Message- Sent: 23 January 2003 13:14 To: Multiple recipients of list ORACLE-L Very good point. I know where I work, HR classifies DBA as an analyst for pay reasons. The Senior DBA position, is more of a management-type role. More money, more management responsibilities but less actual DBA work. -D- -- Dwayne Cox Oracle Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. On Wed, 22 Jan 2003 11:08:07 -0800 DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Bp, Often where the term Senior DBA comes up is with company HR departments. It isn't usual for we DBAs to greet each other with Hi, I'm a senior DBA. I agree with Mark's comments, but just wanted to point out this other aspect to the issue. Sometimes HR people use this as a method for categorizing people in terms of making sense out of salaries. HR criteria may have nothing to do with what you are thinking of. Personally I often can't understand HR criteria. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: CPU Problem
Definately worth repeating. Its an excellent article. Read it last night. Hmmm. Maybe I need a life. Do they even make records anymore? Would the children of today even understand the reference? I suddenly feel very old. :-) From: Cary Millsap [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: CPU Problem Date: Thu, 07 Nov 2002 14:43:46 -0800 SQL that does excessively many reads from memory. Trace it. Read Why you should focus on LIOs instead of PIOs at www.hotsos.com/catalog. My apologies to the list for repeating myself like a broken record. :) Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Alavi Sent: Thursday, November 07, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Hi List, We are facing with some CPU problem (cpu 100% usage!), Just want to get some idea from you guys, any clue what can cause this problem: Here is a copy of some part of ora.ini This happen during usage of some long query with subquery, this can be the cause of problem or just some wrong setting in ini file. I appreciate your help. compatible = 8.1.7.4 db_block_buffers = 1 db_block_lru_latches = 4 db_block_size = 8192 db_file_multiblock_read_count = 16 hash_area_size = 2048000 java_pool_size = 20971520 large_pool_size = 614400 log_buffer = 262144 log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 max_enabled_roles = 30 open_cursors = 300 optimizer_index_caching = 90 optimizer_index_cost_adj = 35 os_authent_prefix = processes = 100 session_cached_cursors = 100 shared_pool_size = 134217728 sort_area_retained_size = 262144 sort_area_size = 262144 timed_statistics = TRUE Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on in-doubt transaction
Check out the documentation for the dbms_transaction package. I have used it previously (dbms_transaction.purge_lost_db_entry). In my case, the cause was due to a problem in SQL Server (DTS process). See Docids on Metalink: 67590.1 - PROCEDURE:DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY 100664.1 - How to Troubleshoot Distributed Transactions Good Luck. From: Mandal, Ashoke [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Question on in-doubt transaction Date: Mon, 04 Nov 2002 09:54:14 -0800 Greetings All, We have a stand alone database on a Windows-NT box. As far as I understand from the users of this database that this is not in distributed environment. But there is one in-doubt transaction in this database and if users try to work in this database the response is very slow due to this in-doubt transaction. We bounced the database. Restarted the service but in-doubt transaction is still sitting there from Feb 2002. We could see this transaction in DBA Studio also. How to clean this transaction? Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Choose an Internet access plan right for you -- try MSN! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).