RE: Oracle Pure Name and Address
Title: Oracle Pure Name and Address I think it could be part of the Oracle Business Intelligence Suite (ETL: Extract, Transform, and Load). I know Oracle has a feature within such that allows for cleaning up names and addresses!! Ed Haskins -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 2:30 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Pure Name and Address Recently got a 8.1.7 shipment (for hp-ux) and found some CDs I've never seen in an Oracle shipment before Oracle Pure Name Address (5.5.0.33) Oracle Pure Name Address (North America) (5.5.0.33) Oracle Pure Name Address (Europe, Middle East Africa , Asia Pacific, and Latin America) (5.5.0.33) Oracle Geocode (US Data) (5.5.0.33) Anybody familiar with this stuff? (I could just drop it in the CD-ROM but I don't have time at the moment.) Matt Adams GE Appliances
RE: What happens if you lose the alert log?
!! Please do not post Off Topic to this List !! Oracle will automatically recreate the ALERT log file and begin writing to it. Ed -Original Message- Sent: Thursday, September 13, 2001 10:50 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Hi, I had a situation yesterday where a rogue process wrote millions of error messages into the alert log. I was able to get rid of the process, then delete the error messages out. But it would have been quicker to just blow it away and create a new, empty one. I was concerned as to the effect that would have on Oracle. Would it bring Oracle down? What is the best way to handle this? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: financial problems with fatcity.com
How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TNSPING Test Script for NT
Tom,
Thanks!!
Ed
-Original Message-
Sent: Tuesday, August 21, 2001 3:13 PM
To: Multiple recipients of list ORACLE-L
Ed,
how about:
tnsping {sid} 1000 ping.lis
will tnsping the {sid} 1000 times, with the result being placed in a file
created named ping.lis
changing it to
*** file name pingtest.bat
tnsping %1 1000 ping.lis
Can be executed as pingtest {sid}
Another way to do this using a loop within the .bat file follows.
This would execute the tnsping command 1000 times:
*** file name pingtest1.bat
echo TnsPing Test ping.lis
echo date /T ping.lis
for /L %I in (1,1,1000) do tnsping r816 ping.lis
And a third way, using goto looping:
*** file name pingtest2.bat
@rem
@rem Loop through a counter searching for the RunDaily.{seq} file
@rem
@set /A ctr=0
:again
echo TnsPing Test ping.lis
echo date /T ping.lis
set /A ctr=ctr+1
if (%ctr%) == (1000) goto endloop
tnsping r816 ping.lis
goto again
:endloop
hope these help.
Tom Mercadante
Oracle Certified Professional
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L
Can anyone help me with a simple .bat script for NT that will run a TNSPING
against a certain connect descriptor and write the results to a file. I
need to have the TNSPING run for say 1000 loops. Once complete, I can
search through the file for errors.
Thanks,
Ed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Haskins, Ed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: No TNSListner service after intall 8.1.7 on Win 2k
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k Lisa, C:\ set ORACLE_SID=SID_NAME Then... C:\ set ORACLE_SID ORACLE_SID=SID_NAME Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 2:22 PMTo: Multiple recipients of list ORACLE-LSubject: RE: No TNSListner service after intall 8.1.7 on Win 2k Hi Igor, thanks for your reply. Call me a bonehead... but I got nothing. What am I missing? C:\set ORACLE_SID Environment variable ORACLE_SID not defined C:\sqlplus system SQL*Plus: Release 8.1.7.0.0 - Production on Thu Aug 16 13:18:15 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter password: Connected to: Oracle8i Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production SQL select name from v$database; NAME - VIKING SQL -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 2:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: No TNSListner service after intall 8.1.7 on Win 2k Lisa, Try: SET ORACLE_SID You should get: ORACLE_SID='your_sid' Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - From: Koivu, Lisa mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2001 1:28 PM Subject: RE: No TNSListner service after intall 8.1.7 on Win 2k Hi Rick, I ran into this as well. I figured I didn't need a listener on my w2k box because everything was going to be local. However I couldn't connect via sqlplus gui without a listener (no listener error - maybe because I am specifying the sid). I guess it's just another difference between Oracle on windows and Oracle on Unix. If I remember right (it's been s long) when you connect in Unix with the $ORACLE_SID as part of your env, you can do so without @. If you do it with the @, it looks for a listener. When connecting via a windows gui, you are specifying the sid. I'm guessing it's doing something similar to the @ in the background. The cmd window connects without the @ because it's in the environment. By the way, how do you display an environment variable in Windows? I thought it was echo %ORACLE_SID%, but that doesn't work. Anyone? Again I may be pre-coffee.Lisa KoivuOracle Database AdministratorFairfield Resorts, Inc.954-935-4117 -Original Message-From: Cale, Rick T (Richard) [SMTP:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 12:36 PMTo: Multiple recipients of list ORACLE-LSubject: No TNSListner service after intall 8.1.7 on Win 2k Hi All, I did a typical installation of Oracle 8.1.7 on Win 2k. It appears to haveinstalled Ok. I can use srvmgrl - create database - etc.However when I try to use worksheet I get no listner. I should not need onefrom the server. Anyway the install did not create serviceto start the listener. All other installs I have done on NT always createda tnslistner service. This in my first install on Win 2k.Anyone have any ideas on why service did not get created and how to correct? ThanksRick--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
SHARED SQLNET.ora? RE: tnsnames.ora in clients
Has anyone been successful with putting the SQLNET.ora file in the same shared location as the TNSNAMES.ora file? I know it's supposed to be used solely on the user workstation in /network/admin (Net80/admin), but some people are trying to place it on the shared drive as well. We're actually implementing ONAMES, so we're replacing the SQLNET.ora file to specify ONAMES, and some Regions are thinking they only need to place this on the shared drive where TNS_ADMIN points to. I don't think this is supported or works in all situations. Any experiences or comments?? Ed -Original Message- Sent: Tuesday, July 24, 2001 1:02 PM To: Multiple recipients of list ORACLE-L We use a shared tnsnames.ora from a NT server. -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: tnsnames.ora in clients Does this method of sharing the tnsnames work for you? What operating system are you using? I use Novell and when I tried this method of sharing the tnsnames it wouls not work. We had to resolve to downloading the latest copy to the users when they logged in. ROR mª¿ªm [EMAIL PROTECTED] 07/23/01 11:41AM You can write a script and each time when a user logs into a domain it will check and copy the latest tnsnames.ora file. Or you can just place the tnsnames.ora file on the network drive and point everyone to it. [EMAIL PROTECTED] 07/23/01 10:55AM Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Re: Oracle Internet Directory
It's free if you use it simply for Net8...in replace of Oracle Names. If you want to use it for the other features...user authentication, etc...then you need to pay. I would contact Oracle for current pricing. When I last checked...you could purchase licensing based upon the number of entries in the Directory. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, July 17, 2001 1:12 PM To: Multiple recipients of list ORACLE-L Sorry for the OT question. Is OID free if I have the Enterprise license? if not, how much is it? I can't find pricing for it on oraclestore site. thanks for any help. [EMAIL PROTECTED] 07/17/01 12:50PM Check if the schemas ODS and ODSCOMMON exists. Regards. --- [EMAIL PROTECTED] wrote: Hello All. I have a problem in starting my ldap server instance. I have created a database say OIDB2 using UTF8 character set. Oracle internet Directory already installed in my oracle home. I started OID monitor after setting environment variable NLS_LANG=AMERICAN_AMERICA.UTF8, using command oidmon connect=oidb2 sleep=10 start. It started successfully. but when i tried to start ldap server instance using command (oidctl connect=oidb2 server=oidldapd instance=5 start) i received error message ---[gsdsiConnect] ORA-1017, ORA-01017: invalid username/password; logon denied I am stuck with this now. Please help me to come out of this problem. Thanks and Regards Vinay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Scsi I/O speed
Kevin, One thing to remember with SCSI...it's not necessarily the speed of the controller that matters. The SCSI bus will be slowed down to the speed of the slowest device in the chain...or on the bus. For example, if you have a controller with 80mb/s and 3 HDs with 80mb/s and 1 HD at 40mb/s...all running off the same controller...the bus speed will be no more than 40mb/s (the speed of the slowest device). Again, that is the theoretical max speed. Ed -Original Message- Sent: Wednesday, July 11, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Hi all, I was measuring the i/o performance of my scsi drives and I have a quick question that maybe someone could shed some light upon. Currently I am using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of 80mb/s. Well, when I perform the test all of the machines seem to be operation at halp of the max speed. One operates at about 20mb/s read and write and the others are even slower than that. Now on the first one, it is the only HD on the controller, on the others there are two disks. Even on my Ultra/160 it seems to be maxing out at 40 read and write. Am I missing something? Am I reading this the wrong way? Help:( Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on NT unattended installation
Joe, I've done it for the Oracle Client, successfully. This question was posted on LazyDBA, and a couple others responded that they were successful with it. Ed -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 2:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle on NT unattended installation Ed, you've gotten thats to work?, theory is nice, but r/l is what counts joe [EMAIL PROTECTED] 07/11/01 02:05PM Audrey, Yes, you can do a silent install. On a workstation / server that has Oracle installed (NT/2000), go to: START | PROGRAMS | Oracle Installation Products | Universal Installed Concepts Guide This is in HTML format and will show you how you can do a silent install. Ed -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 11, 2001 11:26 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle on NT unattended installation Dear list ! Is there a possibility to do an unattended installation of Oracle server (8.1.7) on NT (Win2000) ? I mean an installation with a script or so without answering questions and clicking 'Next' during the installation. If there is such a possibility for NT , would You please point me to a manual ? I tried to RTFM and found nothing. Thanks a lot in advance. Andrey.
RE: Scsi I/O speed
Kev, Make sure that the SCSI CD-ROM or Tape Drive aren't connected to this controller. Ed -Original Message- Sent: Wednesday, July 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Well yeah, all of this makes perfect sense to me. However, if I am testing the devices I would assume that the test software is going to send as much info as it can down the pipe, you know stuff it. With the Ultra/160 I am assuming that there is only a 80mb/s drive in there, I never opened it up and looked, but I will now. I will use a couple different utilities and see if the rates are the same. Also, I know that the drives I have in these machines are all 80mb/s drives, at least in the other machines, so there shouldn't be any device that is bringing down the rate. I don't know, but I would love to try and iprove this rate. KK -Original Message- Sent: Wednesday, July 11, 2001 2:00 PM To: Multiple recipients of list ORACLE-L Kevin, One thing to remember with SCSI...it's not necessarily the speed of the controller that matters. The SCSI bus will be slowed down to the speed of the slowest device in the chain...or on the bus. For example, if you have a controller with 80mb/s and 3 HDs with 80mb/s and 1 HD at 40mb/s...all running off the same controller...the bus speed will be no more than 40mb/s (the speed of the slowest device). Again, that is the theoretical max speed. Ed -Original Message- Sent: Wednesday, July 11, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Hi all, I was measuring the i/o performance of my scsi drives and I have a quick question that maybe someone could shed some light upon. Currently I am using Ultra 2/Wide scsi conrollers, this is supposed to have an I/O of 80mb/s. Well, when I perform the test all of the machines seem to be operation at halp of the max speed. One operates at about 20mb/s read and write and the others are even slower than that. Now on the first one, it is the only HD on the controller, on the others there are two disks. Even on my Ultra/160 it seems to be maxing out at 40 read and write. Am I missing something? Am I reading this the wrong way? Help:( Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Serious Question (believe it or not)...
Jonathan, Everyone has there own reasons for wanting to write a book. For me, the reasons are: 1. Credibility with peers / clients 2. Sense of accomplishment 3. Enjoy sharing information with people 4. Some extra cash I would certainly say that the first 3 are TRUELY the reason that I would consider such a project, but the extra cash is always a plus!! I certainly am not interested in getting into anyone's personal finances...but could you give us some indication / range of what an author could expect to receive from a book deal? I'm sure it varies depending upon the topic and salesability...but what's a good range? How are book deals typically structured? Thanks, Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, June 07, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Wednesday, June 06, 2001, 4:53:21 PM, Christopher Spence wrote: CS I hope your not doing it to get rich :) Chris brings up a good point. It's *extremely* difficult to predict book sales in advance. Editors get surprised all the time. Books we think will sell well, don't. And sometimes it's the other way around. It's best to go in with low expectations, and hopefully you'll come out pleasantly surprised. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What stands for i in Oracle 8i
Actually now that I think about it... the "i" in Oracle8i actually stands for "i"diot proof. This is what Larry was talking about when he made things easier so that less DBAs were needed. Are you an idiot?? ;-) Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Muthaiah [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 12:56 PMTo: Multiple recipients of list ORACLE-LSubject: What stands for i in Oracle 8iHi,I am just curious about to know for what that i stands for in Oracle 8i.Can any one shed some light?Thanks, Muths"Do not go where the path may lead, go instead where there is no path and leave a trail."
RE: What stands for i in Oracle 8i
I'm pretty sure it means..."i"ncredibly expensive!! Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Muthaiah [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 12:56 PMTo: Multiple recipients of list ORACLE-LSubject: What stands for i in Oracle 8iHi,I am just curious about to know for what that i stands for in Oracle 8i.Can any one shed some light?Thanks, Muths"Do not go where the path may lead, go instead where there is no path and leave a trail."
RE: OT: TUSC and Kevin Loney
spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database writer
Kev, Trying to add multiple DBWR processes on NT is useless since NT uses asynch. I/O. If you remember, all the Oracle processes (DBWR, LGWR, CKPT, ARCH, etc.) run as threads under the oracle.exe process. Multiple DBWR processes are definitely a Unix thing! Also, here's something from MetaStink on the issue: Oracle on NT only allows/needs a single database writer process (DBWR). Multiple DBWRs on UNIX is not multiple real DBWRs which all go scan for dirty buffers and write them to disk. It's really just one real DBWR and some I/O slaves. The real DBWR tells the slave DBWRs to do I/O. On NT, there's really no need for this since async I/O and NT will take care of all that for you. NT acts as the I/O slaves and the real DBWR [1 DBWR thread] then checks the slaves to see if the I/O is done. Melissa Holman Oracle Support Ed Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am assuming that the db writer processes are working. But we all know what happens when we assume something. Any ideas would be appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bumoer Stickers [RE: Rebuilding indexes]
Kev, Read The F*%ing Manual People get RTFM'd much more on the LazyDBA list than here...but I'm fairly certain this must have been used on this List as well at one point or another!! Ed Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, June 01, 2001 5:09 PM To: Multiple recipients of list ORACLE-L What does RTFM mean? -Original Message- Sent: Friday, June 01, 2001 4:28 PM To: Multiple recipients of list ORACLE-L Don't forget these: RTFM Unix or NT? URGENT: Tell me everything you know about ___? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, June 01, 2001 3:31 PM To: Multiple recipients of list ORACLE-L It got me thinking that it would be fun to have some bumper stickers made up for members of this list. Some ideas I had: ARE YOU AN IDIOT? or SHUTDOWN ABORT Don't forget HELP - Kirti -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rebuilding indexes On Fri, 1 Jun 2001, Hatzistavrou Giannis wrote: I don;t quite understand you quoting Once the indexes have all been rebuilt nologging into the original tablespace, all that's left is to refresh the datafiles for that tablespace onto the primary. Is primary a typo error (i.e. standby)? Argh! It was a typo. Of course, after doing many unrecoverable operations, you should refresh the affected datafiles from the primary to the standby. Vadim Gorbounov mentioned the column 'unrecoverable_change#' in v$datafile. This looks like an SCN, not a count of unrecoverable changes. Either way, it seems like a useful way to decide if a datafile shoule be refreshed onto the standby. I can even imagine improving a standby log applier that could be made to refresh such files from the primary automatically. On another topic, I believe I qualify for some sort of award as uber geek. This week I obtained the Washington State license plate ORA DBA for my '74 Volvo. It got me thinking that it would be fun to have some bumper stickers made up for members of this list. Some ideas I had: ARE YOU AN IDIOT? or SHUTDOWN ABORT -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE NAMES /LDAP
Vikas, I just implemented Oracle Names (8.1.6) for Verizon Wireless...corporate-wide. I've setup three ONAMES servers: 1. At Corporate Headquarters in NJ. This server contains the region database for ONAMES. It also serves as the Secondary ONAMES server corporate-wide. 2. In data center in NY. This server provides Primary ONAMES services to the corporate regions in both the North East and South areas. 3. In data center in CA. This server provides Primary ONAMES services to the corporate regions in both the West and Midwest areas. This infrastructure supports 26,000 users accessing 250+ databases corporate-wide. Oracle Names is making its' terminal release in 9i. Oracle is recommending that companies migrate to their LDAP (Oracle Internet Directory) solution. This solution is not cheap...so we have decided to wait probably another year or so before going this route. OiD is also a bit more complicated to setup and administer. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 5:06 AM To: Multiple recipients of list ORACLE-L Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Applications
Finding Oracle DBAs with 4 years experience is tough enough...forget about 4 years experience with Apps!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 10:51 AM To: Multiple recipients of list ORACLE-L Still no response from Oracle Canada, I left a message again - they didn't know what to do when people order CD Packs... Meanwhile I saw on the 'net a job posting that had as one of the competency requirements: 4 years experience with Oracle Applications. I guess this is supposed to be funny. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE NAMES /LDAP
OiD is a separately licensable product...not included as part of the DB license. If I remember correctly, you have the UPU license calculation or a per entry license @ $50/, with 5000 entries being the minimum!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi Ed, Why do you say that OiD is not cheap? I haven't seen any associated costs, other than servers to put it on. Can you explain? The complicated part, though I definitely agree with! :) Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, May 31, 2001 10:51 To: Multiple recipients of list ORACLE-L Vikas, I just implemented Oracle Names (8.1.6) for Verizon Wireless...corporate-wide. I've setup three ONAMES servers: 1. At Corporate Headquarters in NJ. This server contains the region database for ONAMES. It also serves as the Secondary ONAMES server corporate-wide. 2. In data center in NY. This server provides Primary ONAMES services to the corporate regions in both the North East and South areas. 3. In data center in CA. This server provides Primary ONAMES services to the corporate regions in both the West and Midwest areas. This infrastructure supports 26,000 users accessing 250+ databases corporate-wide. Oracle Names is making its' terminal release in 9i. Oracle is recommending that companies migrate to their LDAP (Oracle Internet Directory) solution. This solution is not cheap...so we have decided to wait probably another year or so before going this route. OiD is also a bit more complicated to setup and administer. Ed Haskins Oracle DBA Verizon Wireless -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE NAMES /LDAP
Interesting...Oracle must have changed their minds on this issue. I know we complained that it seemed crazy for us to pay for OiD when ONAMES is free...considering Oracle is de-supporting ONAMES and practically forcing customers to go with OiD (LDAP). I guess they actually used some of the feedback we and others provided to straighten out the inconsistency!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 5:47 PM To: Multiple recipients of list ORACLE-L Hi, Actually, it's not so bad. OiD is licensed separately ONLY when used as general purpose directory service. Check Metalink Note:135696.1 13. Do I need to license OID when deploying the directory for NET8 ? Answer -- No, deploying OID for NET8 is free of charge. Vadim Gorbounov Oracle DBA -Original Message- Sent: Thursday, May 31, 2001 4:44 PM To: Multiple recipients of list ORACLE-L OiD is a separately licensable product...not included as part of the DB license. If I remember correctly, you have the UPU license calculation or a per entry license @ $50/, with 5000 entries being the minimum!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi Ed, Why do you say that OiD is not cheap? I haven't seen any associated costs, other than servers to put it on. Can you explain? The complicated part, though I definitely agree with! :) Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, May 31, 2001 10:51 To: Multiple recipients of list ORACLE-L Vikas, I just implemented Oracle Names (8.1.6) for Verizon Wireless...corporate-wide. I've setup three ONAMES servers: 1. At Corporate Headquarters in NJ. This server contains the region database for ONAMES. It also serves as the Secondary ONAMES server corporate-wide. 2. In data center in NY. This server provides Primary ONAMES services to the corporate regions in both the North East and South areas. 3. In data center in CA. This server provides Primary ONAMES services to the corporate regions in both the West and Midwest areas. This infrastructure supports 26,000 users accessing 250+ databases corporate-wide. Oracle Names is making its' terminal release in 9i. Oracle is recommending that companies migrate to their LDAP (Oracle Internet Directory) solution. This solution is not cheap...so we have decided to wait probably another year or so before going this route. OiD is also a bit more complicated to setup and administer. Ed Haskins Oracle DBA Verizon Wireless -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Is DBMS_OBFUSCATION free in Enterprise Edition?
Free...unless you look at the TCO (Total Cost of Ownership). ;-) Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, May 30, 2001 3:51 PM To: Multiple recipients of list ORACLE-L It is free - very definite answer :-) Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 2:02 PM To: Multiple recipients of list ORACLE-L We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6. My manager needs a definitive answer. Is DBMS_OBFUSCATION free with this version of Enterprise Edition server or is it part of an extra-cost add-on. All definitive answers welcome. I have a call in to Oracle but they have not yet responded. My manager wants to know today. Thanks, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS access
Title: MS access Li, 1GB for Access would be huge...and cause very poor performance. The only way to overcome the size limitation is to upgrade to a real database...preferably Oracle, but that SQL Server thing would work as well for a DB that size. Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Li, Xiangli [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 11:57 AMTo: Multiple recipients of list ORACLE-LSubject: MS access Hi, List Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true? thanks Li
RE: Multimaster Replication
Nihar, Don't remove the network link!! O.KI'm not a replication guru, but my thoughts are that the way replication is setup, the commit can only happen if the data can be replicated as it should. If there is no network connectivity, the instance cannot get to one of the other required instances...and it hangs until it finds it. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, May 21, 2001 5:51 PM To: Multiple recipients of list ORACLE-L hi gurus My Asynchronus multimaster replication is working fine. But the moment i remove the physical connectiviy (network link),it hangs without even updating local data base. i mean it's not allowing me to commit insert statement at one location. Can anybody helps me in this. thanks -Nihar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script that will remove redundant rows from table
Eric, Yes they did...I am not resending this message. Either the List software is screwing up, or my Company's email servers suck. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, May 16, 2001 9:45 PM To: Multiple recipients of list ORACLE-L didn't 27 1/2 people post the answer to this yesterday??? On 16 May 2001, at 17:10, Haskins, Ed wrote: A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script that will remove redundant rows from table
Title: auditing tables A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect descriptors from many SQLNET.ora files throughout the enterprise. My problem is that there exists duplicates from the multiple SQLNET.ora files. I really want to clean this up so that only one entry per connect descriptor exists. I think that a generic script for any table will work in this situation. Thanks, Ed Haskins Oracle DBAVerizon Wireless
Script to remove redundant rows in a table?
A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect descriptors from many SQLNET.ora files throughout the enterprise. My problem is that there exists duplicates from the multiple SQLNET.ora files. I really want to clean this up so that only one entry per connect descriptor exists. I think that a generic script for any table will work in this situation. Thanks, Ed Haskins Oracle DBA Verizon Wireless -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script that will remove redundant rows from table
Title: auditing tables A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect descriptors from many SQLNET.ora files throughout the enterprise. My problem is that there exists duplicates from the multiple SQLNET.ora files. I really want to clean this up so that only one entry per connect descriptor exists. I think that a generic script for any table will work in this situation. Thanks, Ed Haskins Oracle DBAVerizon Wireless
Script that will remove redundant rows from table
A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect descriptors from many SQLNET.ora files throughout the enterprise. My problem is that there exists duplicates from the multiple SQLNET.ora files. I really want to clean this up so that only one entry per connect descriptor exists. I think that a generic script for any table will work in this situation. Thanks, Ed Haskins Oracle DBA Verizon Wireless -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script that will remove redundant rows from table
Sorry for the multiple posts...I first sent this message yesterday and it never posted...I tried a couple times today. Looks like there was some sort of backup between my mail server and the Lists'. I've also received a solution!! Thanks, Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, May 15, 2001 1:46 PM To: Multiple recipients of list ORACLE-L A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect descriptors from many SQLNET.ora files throughout the enterprise. My problem is that there exists duplicates from the multiple SQLNET.ora files. I really want to clean this up so that only one entry per connect descriptor exists. I think that a generic script for any table will work in this situation. Thanks, Ed Haskins Oracle DBA Verizon Wireless -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8i installation problem on Pentium 4
Matt, What version of Oracle 8.1.7 are you trying to install? Actually, for which platform is your CD? The only version that you can install on ME is Personal Oracle, not Enterprise Edition or Standard Edition. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, May 14, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Hi, everyone: I had problem installing Oracle 8.1.7.0 on my Petium 4 machine running Windows Me. I changed the scripts to use -nojit option, however, when I was installing, only Oracle Cllients was installed. Any idea? TIA Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i Real Application Clusters
Rajendra, There is a white paper on OTN about 9i RAC. I think it isn't the most up-to-date white paper, but it's a start. I'm sure there will be more available, as in documentation, once the software ships next month!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, May 09, 2001 9:35 AM To: Multiple recipients of list ORACLE-L Dear Friends Does anyone have any knowledge or experience with Oracle 9i Real Application Cluster stuff? If you have I'd like to hear from you about what it is and your insight. I think it is not out yet, some of you may have had the opportunity to find what it is. ... Thanks in advance 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 ! * This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segments
') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle client for the desktop/Win 2000. Need help with which
Charles, For Win2K...Oracle only supports the 8.1.6 Client or higher. We've standardized on the 8.1.6 Client for our Corporate-wide rollout of the Oracle Client utilizing Oracle Names for DB name resolution. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, April 30, 2001 1:26 PM To: Multiple recipients of list ORACLE-L version. Hi Listeners, Do you recommend the latest version of the Oracle client for the desktop? Our current standard is Oracle 8.0.5. In preparation for Windows 2000, we would like to migrate to a new version sometimes this year. Is there a version you suggest we look at? Thanks in advance, Charles Yuan Oracle DBA 918 744 4333 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charles Yuan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL to Oracle conversion
Kevin, Yes, use Oracle Migration Workbench http://technet.oracle.com/tech/migration/ Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, April 30, 2001 2:15 PM To: Multiple recipients of list ORACLE-L Dear Listers: Does anyone know any good tools or ways to convert MySQL database to Oracle database ? TIA Kevin Tsay SiteSmith, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Tsay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: memory
Kev, What exactly do you mean by all hell breaks loose.? Is there a specific error? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 25, 2001 10:50 AM To: Multiple recipients of list ORACLE-L Hi all, I have a developer running a procedure that is basically an insert statement. When he executes it as stand alone everything is fine, when he executes it from a package all hell breaks loose. Anyone have any ideas? Winnt/8.1.6ee...Also, why would Oracle Process suck up 950MB's of RAM when this procedure crashes? The SGA is supposed to be limited to about 550MB's? Thanks alot Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HYPER VOLUMES - RE: Never split index and data files ...
Here's some info I was able to dig up! Ed Haskins Oracle DBA Verizon Wireless Zoned Bit Recording One way that capacity and speed have been improved on hard disks over time is by improving the utilization of the larger, outer tracks of the disk. The first hard disks were rather primitive affairs and their controllers couldn't handle complicated arrangements that changed between tracks. As a result, every track had the same number of sectors. The standard for the first hard disks was 17 sectors per track. Of course, the tracks are concentric circles, and the ones on the outside of the platter are much larger than the ones on the inside--typically double the circumference or more. Since there is a constraint on how tight the inner circles can be packed with bits, they were packed as tight as was practically possible given the state of technology, and then the outer circles were set to use the same number of sectors by reducing their bit density. This means that the outer tracks were greatly underutilized, because in theory they could hold many more sectors given the same linear bit density limitations. To eliminate this wasted space, modern hard disks employ a technique called zoned bit recording (ZBR), also sometimes called multiple zone recording or even just zone recording. With this technique, tracks are grouped into zones based on their distance from the center of the disk, and each zone is assigned a number of sectors per track. As you move from the innermost part of the disk to the outer edge, you move through different zones, each containing more sectors per track than the one before. This allows for more efficient use of the larger tracks on the outside of the disk. More (http://www.pcguide.com/ref/hdd/geom/tracksZBR-c.html) -- Placing Data at the Beginning of ZBR Disks Data is most quickly transferred when it is located at the beginning of zone-based recording (ZBR) disks. Placing data at the beginning of these disks improves the bandwidth for sequential data transfers. --- Disk geometry refers to how sectors and tracks are organized for each cylinder in a disk drive. The UFS organizes itself to use disk geometry efficiently. If slices in a concatenated metadevice have different disk geometries, DiskSuite uses the geometry of the first slice. This fact may decrease the UFS file system efficiency. Note - Disk geometry differences do not matter with disks that use Zone Bit Recording (ZBR), because the amount of data on any given cylinder varies with the distance from the spindle. Most disks now use ZBR. Use Outer Disk Cylinders First Because of the Zone Bit Recording (ZBR) technology used by Sun, outer cylinders tend to outperform inner cylinders. The outer cylinders are cylinders 0, 1, and 3, as opposed to 4, 5, 6, and 7. CAUTION: Remember, don't use cylinder 2, the overlap cylinder, because it retains the total size of the disk. Some programs are baffled when this cylinder gets changed. -Original Message- Sent: Tuesday, April 24, 2001 10:51 AM To: Multiple recipients of list ORACLE-L - Original Message - Ever since ZBR, the need to use the outside of the disk ( to reduce seeks ) is significantly reduced. PMFJI. The reason for using the outside of the disk is the increased linear velocity there re the heads. Larger circle, same angular velocity, larger linear velocity. Which means you get faster read data transfer rate. Nothing at all to do with reducing seeks. What you end up with is less rotational latency and significantly faster (up to 30% best case) data transfer speed from the silver to the disk cache. From there on to the disk controller and the buffers, it's all the same. This was explained to me by a guy that works on firmware for Seagate. He sent me the best disk speed measure program I've ever seen! Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: News flash - IBM buys Informix
I think Larry should buy Sybase!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, April 24, 2001 3:21 PM To: Multiple recipients of list ORACLE-L It has been announced today that IBM has purchased Informix. See your local tech news service later today for details. H. Wonder what Larry thinks about this? Cheers, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oem2.2
Title: oem2.2 Did you go to MetaLink and do a search on the error? This would likely point to the patch! I did...look what I found: Ed Haskins Oracle DBA Verizon Wireless EM 2.2 File Not Found Errors Using Enterprise Reports and DB Config/Status Reports ~~ Versions Affected ~ Oracle Enterprise Manager Release 2.2.0.0.0 Platforms Affected ~~ Sun Solaris Win32 (Windows 95, Windows 98, Windows NT, and Windows 2000) Description ~~~ After scheduling an Enterprise Report via the Console and a Database Configuration or Database Status Report via DBA Studio, file not found errors will occur as you navigate through the generated database-specific HTML reports. Likelihood of Occurrence/Possible Symptoms ~~ File not found errors will always occur when you navigate through generated database-specifc HTML reports if you schedule an Enterprise Report via the Console and a Database Configuration or Database Status Report via DBA Studio. All services which have special characters in their names will appear in the overview pages, but will appear as broken links (HTTP 404) when trying to drill down. Thus will not be available through the normal navigation of the EM reports. Patches ~~~ Two patches that fix these problems must be applied, and both are available from Oracle MetaLink. One patch, named OMS_22_1486038.[TAR/JAR], must be applied to the Oracle Management Server Release 2.2 machine(s) as well as the Console/DBA Studio Release 2.2 machine(s). The second patch must be applied to the Intelligent Agent machine that executes the report job. Depending on the version of the Intelligent Agent being used, you should apply one of the following patches: Agent Version Corresponding Patch 8.0.6.x IA_806_1356586.[TAR/JAR] 8.1.5.x IA_815_1356586.[TAR/JAR] 8.1.6.x IA_816_1356586.[TAR/JAR] 8.1.7.x IA_817_1356586.[TAR/JAR] Scheduling of an Enterprise Report, Database Configuration Report, or Database Status Report is not supported by any other version of the Intelligent Agent. Note: These patches can be downloaded from the Oracle Support Services website at http://metalink.oracle.com by navigating to the 'Patches' download screen; selecting Oracle Enterprise Manager (for the Management Server and Console/DBA Studio patches) or Oracle Intelligent Agent (for the Intelligent Agent patches) from the pull down menu under 'Product', and clicking the 'Submit' button. From the list of available patches that are displayed, find the patches referenced above. To apply these patches, perform the steps outlined below. Patch Application Instructions for Intelligent Agent ~ 1. Go to the machine which has the Intelligent Agent which will generate the Enterprise Report or the scheduled DBA Studio Report. 2. Shutdown the Intelligent Agent. 3. Depending on the version of the Intelligent Agent being used to execute the report job, untar/Unjar the appropriate Intelligent Agent patch to the $ORACLE_HOME/ directory. Agent Version Corresponding Patch 8.0.6.x IA_806_1356586.[TAR/JAR] 8.1.5.x IA_815_1356586.[TAR/JAR] 8.1.6.x IA_816_1356586.[TAR/JAR] 8.1.7.x IA_817_1356586.[TAR/JAR] On Solaris, you can untar the file via the following command: tar -xvf IA_version of Intelligent Agent_1356586.TAR On Windows platforms, you can unjar the file using WinZip or via the following command: jar -xvf IA_version of IntelligentAgent_1356586.JAR After untarring/unjarring, two subdirectories will be created under the $ORACLE_HOME/network/agent/reports/ directory. Note: If the Intelligent Agent is version 8.0.6 for Windows NT then the two subdirectories will be created under the $ORACLE_HOME/net80/agent/reports/ directory. 4. Restart the Intelligent Agent. Patch Application Instructions for Management Server ~ 1. Go to the machine(s) on which the Management Server runs. 2. Shutdown the Management Server. 3. Untar/Unjar OMS_22_1486038.[TAR/JAR] to the $ORACLE_HOME directory. On Solaris, you can untar the file via the following command: tar -xvf OMS_22_1486038.TAR On Windows platforms, you can unjar the file using WinZip or via the following command: jar -xvf OMS_22_1486038.JAR The existing VtcGenerateReportObject.class and TCLScriptString.class files will be properly overwritten. 4. Restart the Management Server. Patch Application Instructions for Console and DBA Studio ~~ 1. Go to the machine(s) on which the Console and DBA Studio runs. 2. Exit the Console and/or DBA Studio. 3. Untar/Unjar OMS_22_1486038.[TAR/JAR] to the $ORACLE_HOME directory. On Solaris, you can untar the file via the
RE: PLS-00225
Ron, Yes, there is a KEYWORD called ROLLUP which is used in Dimensions typically found in a DW environment. I'm surprised that Oracle has not added this to there list of Oracle Reserved Words. Hopefully the following will help: Ed Haskins Oracle DBA Verizon Wireless ROLLUP ROLLUP enables a SELECT statement to calculate multiple levels of subtotals across a specified group of dimensions. It also calculates a grand total. ROLLUP is a simple extension to the GROUP BY clause, so its syntax is extremely easy to use. The ROLLUP extension is highly efficient, adding minimal overhead to a query. Syntax ROLLUP appears in the GROUP BY clause in a SELECT statement. Its form is: SELECT ... GROUP BY ROLLUP(grouping_column_reference_list) Details ROLLUP's action is straightforward: it creates subtotals which roll up from the most detailed level to a grand total, following a grouping list specified in the ROLLUP clause. ROLLUP takes as its argument an ordered list of grouping columns. First, it calculates the standard aggregate values specified in the GROUP BY clause. Then, it creates progressively higher-level subtotals, moving from right to left through the list of grouping columns. Finally, it creates a grand total. ROLLUP creates subtotals at n+1 levels, where n is the number of grouping columns. For instance, if a query specifies ROLLUP on grouping columns of Time, Region, and Department (n=3), the result set will include rows at four aggregation levels. -Original Message- Sent: Tuesday, April 24, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Hi, I just ran into a problem with v8.1.6 on Linux whereby my stored procedure won't compile because it claims that a table reference is out of scope. It complains about the definition of the arguments to the stored procedure which are as follows: CREATE OR REPLACE PROCEDURE rollup_insert ( vv_rollup_idOUT rollup.rollup_id%TYPE, vv_warrant_id IN rollup.warrant_id%TYPE, vv_rollup_limit_id IN limit.limit_id%TYPE, vv_rollup_time IN VARCHAR2, vv_rollup_emp_badge IN rollup.rollup_emp_badge%TYPE, vv_exec_id OUT INT, vv_rc OUT INT ) AS ... The specific error message complains that rollup is out of scope. If I substitute base level types for these, the procedure will compile. I have included the rollup table definition and ownership below for reference. It is the TWS user trying to execute this procedure. desc rollup - ROLLUP_ID NOT NULLNUMBER WARRANT_ID NOT NULLNUMBER ROLLUP_TIME NOT NULLDATE ROLLUP_TIME_TZ NOT NULLVARCHAR2(3) ROLLUP_EMP_BADGENOT NULLVARCHAR2(4) ROLLUP_LIMIT_ID NOT NULLNUMBER DATESTAMP DATE select owner, object_name, object_type from dba_objects where object_name like '%ROLLUP%'; OWNER OBJECT_NAME OBJECT_TYPE TWS ROLLUP TABLE TWS ROLLUP_INSERT PROCEDURE As you can see, the table and the procedure are owned by the same user. The table exists and the columns referenced in the arguments to the procedure also exist. What am I missing here? Is there a new keyword called ROLLUP somewhere? Any help would be very much appreciated. TIA Ron Morton Database Architect / Administrator Union Switch Signal Inc [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You
RE: RE: Never split index and data files ...
Steve, Thanks for sharing your experiences! Quick question: In the end, once the new hardware was purchased and properly setup, how was the performance of the DB and backup? Were you able to meet the requirement of the 3 hour backup window? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, April 20, 2001 7:32 PM To: Haskins, Ed; Multiple recipients of list ORACLE-L Hi Ed and list, Most of my bad experiences with SAME have been related to adding disk capacity, rather than its performance which is normally OK. The first time I hit it was about 5 years ago when someone had configured the 30 4G drives as a single striped and mirrored volume 15 disks wide, and then someone else had added 2 more mirrored pairs to allow for data growth. The new disks immediately became a hot spot because they had no striping and could not support the same concurrency as the rest of the system. My worst experience with SAME was an 800G data warehouse (noarchivelog mode) that had a requirement to fit a full cold backup into a 3 hour window. Because of the striping, the best backup performance they could get was single threaded! So their wonderful robotic tape library that could in theory backup 500G per hour was useless. As soon as there were 2 or more backup threads active the disk heads started thrashing and the tapes could not stream! To make matters worse, they had bought the disk farm concept, and there were four other unrelated applications sharing the same EMC arrays and one of those was a 24x7 emergency services thing so we could not reconfigure the disk arrays at all. It took 4 people about 3 months to work out a way to do the required reconfiguration from the Unix level in a 4-day outage window. When the time came, of course something went wrong and the whole change had to be backed out! The eventual solution was to spend several millions of dollars on a whole new bunch of hardware. Of course we did the configuration properly the next time so that there would be no disk or controller level contention between the backup threads. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Saturday, 21 April 2001 3:26 To: Multiple recipients of list ORACLE-L Dick, Don't take this the wrong way...it's NOT meant to be sarcastic: You said SAME is a great theory, but I can't and haven't seen it perform well in practice, yet. My question to you: Have you seen it in practice at all? An actual working implementation? For that matter; has ANYONE seen it implemented in a production environment? I'm sure it must be somewhere, but I'm curious if anyone knows where. This is a subject that I'm really into right now...that's why I'm prodding a bit! Thanks, Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, April 20, 2001 12:46 PM To: Multiple recipients of list ORACLE-L Steve, I heard about this SAME philosophy at the last NorthEast Oracle Users Group meeting from a individual who works on the utilities for Oracle in the New England Development Office. Although we did not get deeply into the philosophy, I'll agree that it is not the silver bullet, actually it can become a performance detractor. The individual who wrote the paper for Oracle (Anjo Kolk) is a LONG time Oracle person, actually wrote the core of the kernel, so I believe he's probably writing from a purely theoretical point of view. In that light what he's saying would be true, stripe mirror everything and theoretically you should never have an io bottleneck. BUT, many hardware platforms don't handle mirroring very well unless your using a disk array like EMC's. Now that handles the mirror internally so we've alleviated that problem, but EMC likes to break their drives into 'hyper volumes' so your stripping may or may not be across physical drives. Also your stripes can still have the bottle neck of the number of SCSI cards in the computer. In any case taking a little time to insure that redo logs, archive logs, indexes, and data are all REALLY spread out across devices is the only way to go. SAME is a great theory, but I can't and haven't seen it perform well in practice, yet. Dick Goulet Reply Separator Author: Steve Adams [EMAIL PROTECTED] Date: 4/19/2001 11:25 PM Hi All, The author (Anjo Kolk) is an advocate of SAME (stripe and mirror everything). The SAME philosophy is that everything should be striped across all the disks available. Separating indexes from their tables is contrary to that philosophy. I don't agree with it, but that's where he's coming from anyway. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 20 April 2001 6:56 To: Multiple recipients of list ORACLE-L Whoaaa, I sure hope someone can, because I have never heard that before? Kev -Original
RE: RE: Never split index and data files ...
Dick, Don't take this the wrong way...it's NOT meant to be sarcastic: You said "SAME is a great theory, but I can't and haven't seen it perform well in practice, yet." My question to you: Have you seen it in practice at all? An actual working implementation? For that matter; has ANYONE seen it implemented in a production environment? I'm sure it must be somewhere, but I'm curious if anyone knows where. This is a subject that I'm really into right now...that's why I'm prodding a bit! Thanks, Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Friday, April 20, 2001 12:46 PM To: Multiple recipients of list ORACLE-L Steve, I heard about this SAME philosophy at the last NorthEast Oracle Users Group meeting from a individual who works on the utilities for Oracle in the New England Development Office. Although we did not get deeply into the philosophy, I'll agree that it is not the silver bullet, actually it can become a performance detractor. The individual who wrote the paper for Oracle (Anjo Kolk) is a LONG time Oracle person, actually wrote the core of the kernel, so I believe he's probably writing from a purely theoretical point of view. In that light what he's saying would be true, stripe mirror everything and theoretically you should never have an io bottleneck. BUT, many hardware platforms don't handle mirroring very well unless your using a disk array like EMC's. Now that handles the mirror internally so we've alleviated that problem, but EMC likes to break their drives into 'hyper volumes' so your stripping may or may not be across physical drives. Also your stripes can still have the bottle neck of the number of SCSI cards in the computer. In any case taking a little time to insure that redo logs, archive logs, indexes, and data are all REALLY spread out across devices is the only way to go. SAME is a great theory, but I can't and haven't seen it perform well in practice, yet. Dick Goulet Reply Separator Author: "Steve Adams" [EMAIL PROTECTED] Date: 4/19/2001 11:25 PM Hi All, The author (Anjo Kolk) is an advocate of SAME (stripe and mirror everything). The SAME philosophy is that "everything" should be striped across all the disks available. Separating indexes from their tables is contrary to that philosophy. I don't agree with it, but that's where he's coming from anyway. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 20 April 2001 6:56 To: Multiple recipients of list ORACLE-L Whoaaa, I sure hope someone can, because I have never heard that before? Kev -Original Message- Ghosalkar Sent: Thursday, April 19, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Guys, i was checking my statspack report on oraperf and i came across this statement. "Never split index and data files to different sets of disks." can anyone xplain the logic behind this. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Release (May?)
Rich, There was no "log_archive_start" because it was a benchmark for a data warehouse...which (way more) typically...doesn't operate in ARCHIVELOG mode. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, April 19, 2001 5:36 PM To: Multiple recipients of list ORACLE-L For anyone wanting to see how they created the 3TB database, check out the Full Disclosure Report at http://www.tpc.org/results/FDR/tpch/sun.e10k.3tb.010417.fdr.pdf It contains all the init.oras, Solaris parameters, and the DB creation scripts. It's quite a hoot to see 32GB redos! I did notice the lack of "log_archive_start" anywhere, which would explain why there was no mention of unbelievably long archive write times... :) Also, the claim that the 9i TPC-H 3TB benchmark beat DB2's 1TB marks appears to be just "alleged" and not "convicted", as per the TPC webpage. Enjoy! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 14:51 To: Multiple recipients of list ORACLE-L Subject: Oracle 9i Release (May?) Article Title: Oracle ups the 9i volume Source: the451 Date: 19 Apr 2001 by: the451, special to searchDatabase ... Oracle has published its first benchmark, a TPC-H decision support test, which was run against a 3TB database on Sun Microsystems hardware and allegedly achieved better results than an IBM DB2 database running at 1TB on IBM hardware. Burton claims the result is even more striking This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Track Inserted record ?
Wendy / Helen, Are your query results more than one rows worth of data? If so, you'll need to use something other than a simple sequence or ROWID. A PK would be helpful. Also, maybe you could run this query / insert from a procedure that will create a sequence or unique value to use for all rows returned in that specific query. I'm not a PL/SQL expert, so maybe someone else could help in the actual syntax? HTH a little. Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Helen Zhung [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 19, 2001 6:32 PMTo: Multiple recipients of list ORACLE-LSubject: Track Inserted record ? Hello, ALL: When I insert the query results into a huge temp table (where store all my different query results), How can I track them? so I can spool them out separately to different DATA files? Use Sequence? RowID? Add another PK? Could you please show me how to use them? Thanks a lot for help Wendy Do You Yahoo!?Yahoo! Auctions - buy the things you want at great prices
RE: memory refresher
Kevin, When you say migration...I assume you're doing a data migration from some legacy to Oracle...and likely you're using DataMig to take data that's in the staging area ((source(Oracle)) and importing it into the target Oracle instance, yes? Yes, create a RBS called RBIG and size it appropriately. Are 70,000 records in one table or does the whole migration consist of 70,000 records in a multitude of tables? Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, April 11, 2001 1:06 PM To: Multiple recipients of list ORACLE-L Hi all, If I am doing a migration of say 70 thousand records, isn't it a good idea to turn off all of my little rollback segments and turn on a couple of big rgs? And, how big do you guys think they should be if that is the case? I am trying to increase the performance of this migration, but it is not easy. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Excel to oracle
Ravindra, The first thing you need to do is convert the Excel file to CSV. Do this by opening the Excel file, do a "FILE | SAVE AS" and select "File Type" CSV. This will create you CSV file! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, March 29, 2001 1:46 PM To: Multiple recipients of list ORACLE-L I have a Excel file.How to port the data to Oracle table. I read some artical about using ODBC and things like that.But I am not clear. How can we generate a dat file delimited with comas so that I can use SQlLOADer to port the data. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is there any Access user group?
Access User Groups... Sure, most High Schools have Groups that meet to discuss such things...I think they call them Clubs though! I've heard they provide some really neat technical discussions like..."How to Convert your Parents Paper-based Contact List into Access"..."Access 2000: Breaking the 10MB Barrier". Sorry for the sarcasm...I just couldn't resist! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, March 28, 2001 10:36 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: java servlet service provider
Check out http://portalstudio.oracle.com This may (or may not) be helpful! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, March 27, 2001 10:57 AM To: Multiple recipients of list ORACLE-L Hi, I developed a java servlet based application. I need an ASP. do you know java service provider company ? thanks in advance... = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-27101: shared memory realm does not exist
Abiy, I'm not positive, but it appears that the server's Shared Memory may not be configured. Is the database started and open? I'm assuming not...if in fact Oracle can't allocate the SGA in Shared Memory. You may need to reconfigure your Shared Memory settings and recompile the UNIX Kernel. Check to see if these shared memory settings exist first. Ed Haskins] Oracle DBA Verizon Wireless -Original Message-From: ALEMU Abiy [mailto:[EMAIL PROTECTED]]Sent: Monday, March 26, 2001 10:41 AMTo: Multiple recipients of list ORACLE-LSubject: ORA-27101: shared memory realm does not exist I have this error when I try to connect to a 8.1.7 database instance. I don't really know what's happening. To give just an information, on the server machine I've 2 database engines (7.3.4 and 8.1.7) and on both engines there are 2 or more instances running. I've only one listener.ora file for both engines, with the correct ORACLE_HOMES Thank you folks ... @biy @lemu [EMAIL PROTECTED] Cril Telecom Software France
