Re: Re[2]: Oracle vs Mysql
On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAC
[EMAIL PROTECTED] wrote: Firstly, apology if this question sounds silly. I am intrested in setting up a RAC configuration at my home with a few desktop PC's. I would run either Win2K or Redhat Linux for the same. I am not sure whether I would be able to setup the RAC using a few desktop PC's. I look fwd to your advise in setting up the same. I believe an external storage is required for setting up RAC. Can I configure a 3rd pc's hard disk as a external storage for RAC??. Hello, Yes, you can install RAC on PC. You must have external storage. The cheaper way for PC is 2 x SCSI (ex. Adaptec 29160) plus SCSI HDD. You must connect two PC's and HDD together, using one cable. look at: http://www.ibiblio.org/pub/Linux/ALPHA/linux-ha/High-Availability-HOWTO-7.html#ss7.1 regards, -- Marcin Przepiórowski www.oracledba.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: OS authentication; remote login; domain qualification
I added the parameter to registry OSAUTH_PREFIX_DOMAIN=true but it didn't help. Any other place where i can see..? Thanks and Regards B S Pradhan --- On Mon, 19 Jan 2004 Jared Still wrote : You must set OSAUTH_PREFIX_DOMAIN=true in the registry to use externally identified domain accounts. I can't recall if the default value is true or false, but try setting it explicitly. Jared On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote: Hi All, The client machine is an NT machine and it belongs to a domain GALAXY Oracle Db server is on Solaris. client sqlnet.ora has the following setting: NAMES.DIRECTORY_PATH= (TNSNAMES) LOG_DIRECTORY_CLIENT=c:\oracle\ora81\network\log USE_DEDICATED_SERVER=ON SQLNET_AUTHENTICATION_SERVICES=NTS initialization parameters: REMOTE_OS_AUTHENT=TRUE os_authent_prefix = - with an user name Without the domain remote connection is possible.. ** SQL create user USER1 identified externally 2 default tablespace ts1 3 temporary tablespace TEMP; User created. SQL grant connect to USER1; Grant succeeded. C:\sqlplus /@sn1 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:51:45 2003 (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.4.0 - 64bit Production SQL show user USER is USER1 SQL select username, osuser from v$session; USERNAME OSUSER -- -- SYS oracle USER1 USER1 *** But when i try the username with the NT domain it fails to connect remotely: * SQL create user GALAXY\USER1 identified externally 2 default tablespace ts1 3 temporary tablespace TEMP; User created. SQL grant connect to GALAXY\USER1; Grant succeeded. When I connect try using sqlplus /@sn1 it fails C:\sqlplus /@sn1 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:49:56 2003 (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied What I think issue here is, the connection is thru tns-listener and the NT domain and the server machine are different. Is there any solution for this / Is it possible to connect the remote unix DB server with OS authentication from an NT client with domain name ? Thanks and Regareds B S Pradhan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FW: Disk capacity planning
Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle vs Mysql
- Original Message - Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle Beat ya: Oracle Add-In for Lotus 123. Using Ora*Net (Async), V4.1.4. 1987. And demoed to the press that same year. g,dr (which BTW was classified by a local expert journo - a la Celko - as a ho-hum technology. Then a few years later M$ delivered ODBC and this same journo called it the way of the future! One wonders) version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, SQL*QMS. Very good, but never really pushed by Oracle. And I STILL pronounce Pro*Pascal as Pro*Rascal, after all the probs it gave me on demos... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NEW LYRICS TO BEATLES SONGS - OT but nice
Write in C ("Let
it Be")
When I find my code in tons of
trouble,
Friends and colleagues come to
me,
Speaking words of
wisdom:
"Write in
C."
As the deadline fast
approaches,
And bugs are all that I can
see,
Somewhere, someone
whispers:
"Write in
C."
Write in C, Write in
C,
Write in C, oh, Write in
C.
LOGO's dead and
buried,
Write in
C.
I used to write a lot of
FORTRAN,
For science it worked
flawlessly.
Try using it for
graphics!
Write in
C.
If you've just spent nearly 30
hours,
Debugging some
assembly,
Soon you will be glad
to
Write in
C.
Write in C, Write in
C,
Write in C, yeah, Write in
C.
BASIC's not the
answer.
Write in
C.
Write in C, Write in
C
Write in C, oh, Write in
C.
Pascal won't quite cut
it.
Write in
C.
=
YESTERDAY
Yesterday,
All those backups seemed a waste of
pay.
Now my database has gone
away.
Oh I believe in
yesterday.
Suddenly,
There's not half the files there
used to be,
And there's a
milestone
hanging over
me
The system crashed so
suddenly.
I pushed something
wrong
What it was I could not
say.
Now all my data's
gone
and I long for
yesterday-ay-ay-ay.
Yesterday,
The need for back-ups seemed so far
away.
I knew my data was all here to
stay,
Now I believe in
yesterday.
===
Songs to program
by...
Eleanor
Rigby
Eleanor
Rigby
Sits at the
keyboard
And waits for a line on the
screen
Lives in a
dream
Waits for a
signal
Finding some
code
That will make the machine do some
more.
What is it
for?
All the lonely users, where do they
all come from?
All the lonely users, why does it
take so long?
Guru
MacKenzie
Typing the lines of a program that
no one will run;
Isn't it
fun?
Look at him
working,
Munching some chips as he waits for
the code to compile;
It takes a
while...
All the lonely users, where do they
all come from?
All the lonely users, why does it
take so long?
Eleanor
Rigby
Crashes the system and loses 6 hours
of work;
Feels like a
jerk.
Guru
MacKenzie
Wiping the crumbs off the keys as he
types in the code;
Nothing will
load.
All the lonely users, where do they
all come from?
All the lonely users, why does it
take so long?
==
Unix Man
(Nowhere Man)
He's a real UNIX
Man
Sitting in his UNIX
LAN
Making all his UNIX
plans
For
nobody.
Knows the blocksize from
du(1)
Cares not where /dev/null goes
to
Isn't he a bit like
you
And me?
UNIX Man, please
listen(2)
My lpd(8) is
missin'
UNIX
Man
The wo-o-o-orld is at(1) your
command.
He's as wise as he can
be
Uses lex and yacc and
C
UNIX Man, can you help me At
all?
UNIX Man, don't
worry
Test with time(1), don't
hurry
UNIX
Man
The new kernel boots, just like you
had planned.
He's a real UNIX
Man
Sitting in his UNIX
LAN
Making all his UNIX plans For
nobody ...
Making all his UNIX plans For
nobody.
Something
Something in the way it
fails,
Defies the algorithm's
logic!
Something in the way it
coredumps...
I don't want to leave it
now
I'll fix this problem
somehow
Somewhere in the memory I
know,
A pointer's got to be
corrupted.
Stepping in the debugger will show
me...
I don't want to leave it
now
I'm too close to leave it
now
You're asking me can this code
go?
I don't know, I don't
know...
What sequence causes it to
blow?
I don't know, I don't
know...
Something in the initializing
code?
And all I have to do is think of
it!
Something in the listing will show
me...
I don't want to leave it
now
I'll fix this tonight I
vow!
Re: pga workarea and ora-04030
If you want to work out how much difference there is in different code paths, then you have to do some very patient testing. Run your test program for lots of different array sizes, say 1, 2, 3, and so on up to 100M. On each run, disconnect and reconnect your session, and check v$sesstat for pga and uga memory usage before and after each run, as well as the memory reported from the O/S (I think ps -al and look at the RSS figure for your shadow process is the HP-UX option - but someone may have a better idea). You then need to run a second set of tests where the size of an array element is significantly different from the first test - e.g. test1 uses a varchar2(32) test2 uses varchar2(1000) (and the third test uses varchar2(8000) ). Then you may be able to figure out the significant differences in handling It is quite likely that there is a different code path for allocating and freeing memory as you change versions of Oracle, or change parameters within a version; and it is quite possible that a piece of code for handling arrays changed from version to version - and any change could have introduced an unreasonable error. In passing, I thought the 'array is a fully pre-allocated' was a version 6 thing that got fixed in version 7. I would be amazed if arrays had gone backwards a step - it's easy enough to check: change your test to populate just element 1 and element 1 and see if your session still crashes. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 12, 2004 11:44 AM Jonathan, Thanks for your answer this clarifies a bit more But it still bothers me that this program can swallow 4Gb of physical memory and 4 Gb of swap and it is still not enough. You explain that the memory of pl/sql tables is not in the sga so that's clear now. What still bothers me is that my original program works fine with pga_target = 0 and wa-size-policy=manual When I try this with this test-program it fails (see below) VU_2exec testarray(1); begin testarray(1); end; * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-04030: out of process memory when trying to allocate 8144 bytes (cursor work he,qesaQBInit:buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_OUTPUT, line 127 ORA-06512: at VRIJ_UIT.TESTARRAY, line 23 ORA-06500: PL/SQL: storage error ORA-06512: at line 1 Somehow these setting influence the way the pl/sql program works. This testprogram is clearly not enough to explain this behaviour. Because we Use quite some pl/sql I would like to know more because it could happen Maybe with other programs. Oracle 7 the same code runs fine also. I read a post that the difference for pl/sql tables is that they are now implemented as fully allocated arrays in memory whether they were implemented in oracle 7 and chained linked lists. Obviously this takes more memory but why do these 2 settings play such a role? Is the memory involved differently when using these settings? Can I monitor specific memory usage with these setting and how should this be done on HPUX? Regards, Jeroen -Oorspronkelijk bericht- Van: Jonathan Lewis [mailto:[EMAIL PROTECTED] Verzonden: Saturday, January 10, 2004 6:54 PM Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: pga workarea and ora-04030 I think what you've demonstrated is that pl/sql tables are not limited by pga-aggregate target, and that a pl/sql table can grow until it has taken up all the available memory on your machine. I'd guess that each element in your table takes about the same space - with a little error round the edges - so you can have 17.6M rows before you are out of memory - either as two tables of 8.8M or one table of 17.6M. The sleep time is probably because you start going to SWAP and your session spends time dumping real memory to disc. When the SGA is 1.5G smaller, that frees up an extra 1.5G of memory for you to use as PGA - so you get lots more entries in the table before you run out of memory. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC -
RE: FW: Disk capacity planning
Hi The bad news is that I don't believe that calculating IO/Sec *can* be done for a *new* system. At least I'd like to see how it is done. I'm willing to bet that any formula for doing it will include (x%) for 'overhead', which actually means 'stuff I don't know about'. Of course if the *new* system is a replacement for an old system with known IO requirements and the workload is similar (or predictably different) then obviously a calculation/lower bound could be set. (of course if one has the exact data set that you will use, and the IO required by each and every sql statement in use, and the exact number of clients and the exact machine and software configuration that will be used for always then one can measure your IO requirement. I have never seen such a situation.) Actually however I think that this bad news is rather mitigated by the fact that I don't believe that capacity can be calculated ahead of time for a *new* system either. It will entirely depend on the take up of the application and any changes to the design/usage post go-live. I think that that leaves us in a relatively good position, namely that we can estimate values for B,P etc based on our skill, judgement (and budget :( ), and that because none of the figures are *hard* figures it ought to be possible to negotiate *sensible* disk purchases. They key is to take into account all the demands on the system (as Cary says). I'm afraid that for *new* systems though getting into formulae for *calculating* requirements is likely to give false assurances. Time to brush up on negotiating skills (and to find how how to effectivey bribe your sys admin and/or budget holders). Yours unscientifically Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 20 January 2004 09:19 To: Multiple recipients of list ORACLE-L Subject: Re: FW: Disk capacity planning Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the
RE: Spool to Excel File
Or use Data|Import Data|New Database Query to import via ODBC. This is especially useful for Pivot Tables etc since the dataset (but not the display set) can be larger than the number of rows in an Excel sheet. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Richard Sent: 20 January 2004 05:14 To: Multiple recipients of list ORACLE-L Subject: Re: Spool to Excel File Hi, You won't be able to write an Excel format directly but you can create a .csv file, which Excel will happily read in - you'll just have no real formatting options. Look into some of the sql*plus commands like set heading off, set verify off, set feedback off, set pages 0, set lines 1000, set trimspool on. Of course you might want different settings to the ones I proposed but you will find these commands useful to get rid of stuff you don't (or perhaps do) want in the file. If you really want to generate a legitimate Excel file then start searching the web for programs to do this. I have seen one or two that do this reasonably well but cannot remember names. Regards, Mark. Mudhalvan, Moovarkku To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: apan.co.jp Subject: Spool to Excel File Sent by: [EMAIL PROTECTED] .com 20/01/2004 15:44 Please respond to ORACLE-L Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
IBM Workload Manager on AIX
Hi All, I asked this question before, but that was during Xmas holidays, and I got not much response: Has anyone experience in using IBM's WorkLoad Manager on RS/6000 with AIX 5.x? I'm especially interested in the use for managing several Oracle instances on one server, including sharing available capacitay as well as limiting resources when too much resources are available. We're more interested in all-day constant performance (response-times) than in peek performance every now and then, and SLA-agreed response-times when the system is fully loaded. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FW: Disk capacity planning
Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os per second can they perform and they even have tools to measure it. Speaking of monitoring I/O, there used to be an old OS, which is mostly dead today and it used to have command monitor io/item=queue which would show length of the I/O queues per device, which was extremely useful, because you could quickly find out which devices are hot and which are not. On 2004.01.20 04:19, [EMAIL PROTECTED] wrote: Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
RE: All packages under sys is invalid
Someone is messing with standard package ... so it would seem. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, January 19, 2004 5:01 PM To: Multiple recipients of list ORACLE-L All, I have an strange problem, most of the packages under SYS user are invalid when I compile it it's compile without error but when I back again the package still is invalid, anybody have any idea? Thanks in advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Oracle vs Mysql
if Oracle is offshoring its develeoping of its database, everyone else will also... so much for job security. anyone I heard postgre sql has multi-versioning? Is it implemented like Oracle? So UDB is the new DB2? Oracle claims that DB2 is not one database but a different database for different Operating Systems, is this true? Is it true with UDB? From: Mladen Gogala [EMAIL PROTECTED] Date: 2004/01/19 Mon PM 11:04:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle vs Mysql It needs not to have the same capabilities, it needs to have capabilities that people are using. The primary capabilities that people need, in my opinion, are a decent scripting language, with the full complement of the database triggers, procedures, packages and functions, ability to store/access/administer huge objects, hundreds of gigabytes in size, a decent SQL implementation with plethora of functions and a support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support with something similar to long extinct SQL*Module (originally an IBM technology) and there would be huge number of users. Fortunately for oracle, MySQL still has problems with the most basic things: transactions, versioning, locking and SQL implementation. My conclusion is that MySQL will never be much more then a toy, despite the hype, catchy name and apparent popularity. I see much more dangerous adversaries in UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open source on Unix, and there are rumors of IBM musing over such a move, Oracle would most probably be toast. I must say that after some oracle's mischiefs, I wouldn't be the last one to defect and switch the databases. I wasn't the last one to leave DEC either, despite the fact that I was teaching VMS courses in 1992. My point is that Oracle is extremely feature rich. Very few people are using more then 20% of the database capabilities. Initially, in V8, I worked hard to learn about the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used in production. By now, I've forgotten it all. It's almost the same situation with Java in the database. Very few are using it. Most people test it, then say aha! and move on. Those two features will not make a whole lot of difference when a viable competitor emerges. Oracle 10g was written, for the most part outside of US. With beta testing this closed and restricted, it's not going to be tested thoroughly, not even close to thoroughly. What we are likely to get is an unstable, buggy and almost unusable gridlock version. Competitor might emerge sooner then some people are realizing. On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: If MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs Mysql Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key
RE: Spool to Excel File
Mudhalvan,
I generate files that excel can open all the time. they are not actual
real excel files, but Excel can deal with them quite easily.
Here is a tablespace report I run every week. Note the use of the CHR(9)'s.
This is a TAB character. This forces each column into a new cell in the
spreadsheet. CHR(10) is a line-feed.
Feel free to borrow all of this!
Hope this helps!
SET serveroutput ON
SET feedback OFF
SET lines 150
SET pages 100
SET trimspool ON
exec dbms_output.enable(10)
spool tbslspace_rpt.xls
DECLARE
CURSOR UpTime IS
SELECT INITCAP(instance_name) Instance_Name ,INITCAP(Host_Name) Host_Name
,Version,
ROUND(SYSDATE+1-startup_time) || DECODE(ROUND(SYSDATE+1-startup_time),1,'
Day ', ' Days ') ||
MOD(ROUND((SYSDATE+1 - startup_time) * 24),24) || ' Hours ' ||
MOD(ROUND((SYSDATE+1 - startup_time) * 24*60),60) || ' Minutes ' UpTime
FROM v$instance;
UpTime_Rec UpTime%ROWTYPE;
CURSOR TblSpace IS
SELECT d.status , d.tablespace_name ,
TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'999,990') Tbs_Size,
TRUNC(NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024)Used,
TO_CHAR(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0), '990.00')
Used_Pct ,
DECODE(SIGN(80 - NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100,
0)),-1,'** Warning 80% **',NULL) Msg
FROM sys.DBA_TABLESPACES d,
(SELECT tablespace_name, SUM(bytes) bytes
FROM DBA_DATA_FILES GROUP BY tablespace_name) a,
(SELECT tablespace_name, SUM(bytes) bytes
FROM DBA_FREE_SPACE GROUP BY tablespace_name) f
WHERE d.tablespace_name = a.tablespace_name(+)
AND d.tablespace_name = f.tablespace_name(+)
AND NOT (d.extent_management LIKE 'LOCAL' AND d.CONTENTS LIKE 'TEMPORARY')
ORDER BY 2;
TblSpace_Rec TblSpace%ROWTYPE;
c_email_list VARCHAR2(300);
mail_message VARCHAR2(32000);
mail_message1 VARCHAR2(32000);
loc_start_time DATE;
TblSpace_Msg NUMBER := 0;
BEGIN
BEGIN
SELECT email_notify_txt
INTO c_email_list
FROM WTW_JOB_NOTIFY
WHERE job_name = UPPER('Wtw_Report_Tablespaces');
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
END;
loc_start_time := SYSDATE;
OPEN UpTime;
FETCH UpTime INTO UpTime_Rec;
CLOSE UpTime;
dbms_output.put_line(CHR(9) || CHR(9) ||
UpTime_Rec.Instance_Name || INITCAP('
Uptime/TABLESPACE Report FOR ') ||
TO_CHAR(SYSDATE,'fmMonth ddth, '));
dbms_output.put_Line(CHR(9) || CHR(9) ||
'UpTime : ' || UpTime_Rec.UpTime);
dbms_output.put_Line(
'Status' || CHR(9) ||
INITCAP('TABLESPACE Name') || CHR(9) ||
INITCAP('SIZE (M)') || CHR(9) ||
'Used (M)' || CHR(9) ||
'Used (Pct)' || CHR(9) ||
'Message');
OPEN TblSpace;
FETCH TblSpace INTO TblSpace_Rec;
WHILE TblSpace%FOUND LOOP
dbms_output.put_Line(
TblSpace_Rec.Status || CHR(9) ||
TblSpace_Rec.Tablespace_Name || CHR(9) ||
TblSpace_Rec.Tbs_Size|| CHR(9) ||
TblSpace_Rec.Used|| CHR(9) ||
TblSpace_Rec.Used_Pct|| CHR(9) ||
TblSpace_Rec.Msg);
IF TblSpace_Rec.Msg IS NOT NULL THEN
TblSpace_Msg := 1;
END IF;
FETCH TblSpace INTO TblSpace_Rec;
EXIT WHEN TblSpace%NOTFOUND;
END LOOP;
CLOSE TblSPace;
END;
/
spool OFF
exit
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, January 19, 2004 11:44 PM
To: Multiple recipients of list ORACLE-L
Dear Friends,
I am trying to send output from SQLPlus to Excel file. If any
one did the same before please let me know.
Thank You
Mudhalvan M.M
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mudhalvan, Moovarkku
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE
RE: Re[2]: Oracle vs Mysql
Mladen Gogala scribbled on the wall in glitter crayon: On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, hey, i resemble that remark.;-) i enjoyed using SQL*Calc and SQL*Graph and i even remember the very first version of SQR when it stood for Structured Query Reporter.;-) oh damn, have we been at this too long?;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Nothing in life is to be feared. It is only to be understood. - Marie Curie -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access
Title: RE: MS Access ACCESS-L. For subscription/signoff info and archives, see http://peach.ease.lsoft.com/archives/access-l.html . Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: viraj2 [SMTP:[EMAIL PROTECTED] Hi all, I was wondering if any one out here knows if there is a good list (mailing list) for discussing MS Access problems. I am specifically looking for migrating/converting large Access database into Oracle database. I need to know what will be the steps to convert such a database into an Oracle database. Also need to learn Access from start. Please reply fast, I need to dive into this one. Thanks and Regards, Raja
RE: Re[2]: Oracle vs Mysql
Ahhh. Sql*Calc, Sql*Graph, Sqr EasySqr. Those were the good old days. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 8:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, hey, i resemble that remark.;-) i enjoyed using SQL*Calc and SQL*Graph and i even remember the very first version of SQR when it stood for Structured Query Reporter.;-) oh damn, have we been at this too long?;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Nothing in life is to be feared. It is only to be understood. - Marie Curie -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAC
I'm going down that path right now. I'll keep you all posted. hardware: 2.0G, 1G of ram, 40G internal, 2 of those. external 120G firewire HD. waiting on the HD to continue, relatively new hardware so had to ditch the whole RHAS 2.1 and aint willing to pay RH for AS3. joe Marcin Przepiórowski wrote: [EMAIL PROTECTED] wrote: Firstly, apology if this question sounds silly. I am intrested in setting up a RAC configuration at my home with a few desktop PC's. I would run either Win2K or Redhat Linux for the same. I am not sure whether I would be able to setup the RAC using a few desktop PC's. I look fwd to your advise in setting up the same. I believe an external storage is required for setting up RAC. Can I configure a 3rd pc's hard disk as a external storage for RAC??. Hello, Yes, you can install RAC on PC. You must have external storage. The cheaper way for PC is 2 x SCSI (ex. Adaptec 29160) plus SCSI HDD. You must connect two PC's and HDD together, using one cable. look at: http://www.ibiblio.org/pub/Linux/ALPHA/linux-ha/High-Availability-HOWTO-7.html#ss7.1 regards, -- Marcin Przepiórowski www.oracledba.pl -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: All pakages under sys is invalid
@?/rdbms/admin/utlirp On 01/19/2004 05:00:37 PM, Hamid Alavi wrote: All, I have an strange problem, most of the packages under SYS user are invalid when I compile it it's compile without error but when I back again the package still is invalid, anybody have any idea? Thanks in advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure I'd trust it that far. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 2:10 PM To: Multiple recipients of list ORACLE-L I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. Eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-904 after table rename
Oradebug is the right way to go because, for some reason, alter system set events='904 trace name errorstack forever, level 10'; doesn't do anything. The only way to activate trace is to go to oradebug, attach the session (of course, one needs to do gymnastics with V$SESSION and V$PROCESS to find the SPID) and then use oradebug event 904 With all these strings attached, it's still a very useful tool to see which tables are being missed in action. On 01/19/2004 05:00:10 PM, Chris Stephens wrote: I went through a similar problem with the 904 error. I had to use oradebug to get a trace file to be produced. Good luck, Chris -Original Message- Sent: Monday, January 19, 2004 8:14 AM To: Multiple recipients of list ORACLE-L It turns out that the user had configured TOAD to use a table filter, which causes it to create and store a query. As you've probably guessed, the query was referencing a column which no longer exists. On a related note, I initially tried to capture the failing query using alter system set events='904 TRACE NAME ERRORSTACK', but no trace files were ever created. Any idea what the command should really have been? -Original Message- Norris, Gregory T [ITS] Sent: Friday, January 16, 2004 9:10 AM To: Multiple recipients of list ORACLE-L We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904 error (invalid column name) when trying to access the new table under TOAD. I can't think of anything weird about this table, except that the original has some column-level grants (but not to his userid... he has select/insert/update/delete on both tables). I had him try exiting and restarting TOAD, in case it was caching something relevant, but that didn't make any apparent difference. Any idea what might be going on? SQL desc tool_request_old NameNull?Type --- TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6) TREQ_PEOPLE_FKEYNOT NULL NUMBER(6) TREQ_SUBMIT_DATENOT NULL DATE TREQ_COMPLETE_DATE DATE TREQ_STATUS NOT NULL NUMBER(6) TREQ_COMMENTSVARCHAR2(2024) TREQ_BYPASS_STARTDATE TREQ_BYPASS_END DATE SQL desc tool_request NameNull?Type --- TREQ_ID NOT NULL NUMBER(6) TREQ_PERS_IDNOT NULL NUMBER(6) TREQ_STATUS_ID NOT NULL NUMBER(6) TREQ_SUBMIT_TMSTNOT NULL DATE TREQ_BYPASS_START_TMST DATE TREQ_BYPASS_END_TMST DATE TREQ_COMPLETE_TMST DATE TREQ_COMMENTSVARCHAR2(1024) -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail
Re: Thanx - I cleared the exam
Prem, congrats good luck! On 01/20/2004 12:54:27 AM, Prem Khanna J wrote: When I was doing my OCP exams, I didn't have Dennis to cheer me up, only Heineken.Not that I'm complaining. but Mladen , i can't stop with just one : )) so i better stay away from it during exams. Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
AMEN!! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, January 19, 2004 8:42 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle vs MysqlIf MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs MysqlSounds like the old Oracle vs. Ingress battles. Oracle won because it wasbetter at marketing. All detailed in the book "The Difference Between Godand Larry Ellison". I can see it now -- MySQL, the Oracle of the freedatabases.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, January 14, 2004 4:39 PMTo: Multiple recipients of list ORACLE-LRyan, It's postgres.org. I'm not sure how they generate the operatingrevenue they need, but that's why they are not advertising like MySql AB is.Dick GouletSenior Oracle DBAOracle Certified 8i DBA-Original Message-Sent: Wednesday, January 14, 2004 5:05 PMTo: Multiple recipients of list ORACLE-Li thought postgre was a for profit company? how do they generate revenues?- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with variousdatabases. 2) Postgres is free. I believe that you can buy commercial support, but Idon't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant findany licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government hadan Oracle EE license on windows. They didnt even use foreign keyconstraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any freedatabase could have handled that. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: If you have the choice, look at PostgreSQL in addition to MySQL.From whatI've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a littlepilot project with the goal to see "what the heck is Postgres"), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing ofclustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart,but it can be quite a convenient storage space for a small corner shop ora small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
AQ
Is queue message an idle or an non-idle wait event? I have looked through the docs at tahti and metalink and can't find much info on AQ. Does anybody know where there are resources on this topic? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite COBOL, and could effortlessly have them do DB work. I also didn't have to hunt thru all the source for a single SQL statement since they were in their own file(s). No tricky and time-consuming compiler-specific format-specific precompilers. Just SQueaL. Of course, this was the year 5 BD (Before DBA). It'd be mildly interesting to go back and look at the process now. My $.02, Rich -Original Message- Sent: Monday, January 19, 2004 10:40 PM To: Multiple recipients of list ORACLE-L Monday, January 19, 2004, 11:04:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG A good compiler support MG with something similar to long extinct SQL*Module (originally an IBM technology) I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Best regards, Jonathan Gennick --- Brighten the corner where you are -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle vs Mysql
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 8:39 AM Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Title: Message Most people only use a fraction of Oracle's featuresand some are deceived bythe Oracle Marketeerswho tell themthatthey NEED them all. Maybe the 80/20 rule also applies to technology purchases... Especially when the cost differential is huge. My 4X4 pickup works just fine and I don't need a Hummer or Land Rover. Offroad in Montana, Steve -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, January 19, 2004 6:42 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle vs MysqlIf MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs MysqlSounds like the old Oracle vs. Ingress battles. Oracle won because it wasbetter at marketing. All detailed in the book "The Difference Between Godand Larry Ellison". I can see it now -- MySQL, the Oracle of the freedatabases.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, January 14, 2004 4:39 PMTo: Multiple recipients of list ORACLE-LRyan, It's postgres.org. I'm not sure how they generate the operatingrevenue they need, but that's why they are not advertising like MySql AB is.Dick GouletSenior Oracle DBAOracle Certified 8i DBA-Original Message-Sent: Wednesday, January 14, 2004 5:05 PMTo: Multiple recipients of list ORACLE-Li thought postgre was a for profit company? how do they generate revenues?- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with variousdatabases. 2) Postgres is free. I believe that you can buy commercial support, but Idon't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant findany licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government hadan Oracle EE license on windows. They didnt even use foreign keyconstraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any freedatabase could have handled that. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: If you have the choice, look at PostgreSQL in addition to MySQL.From whatI've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a littlepilot project with the goal to see "what the heck is Postgres"), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing ofclustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart,but it can be quite a convenient storage space for a small corner shop ora small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
help
help Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Gentry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AQ
It is defined as below in the Reference Guide: The session is waiting on an empty OLTP queue (Advanced Queuing) for a message to arrive so that the session can dequeue that message. I would treat it as an Idle Wait, similar to, SQL*Net message from client. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: Is queue message an idle or an non-idle wait event? I have looked through the docs at tahti and metalink and can't find much info on AQ. Does anybody know where there are resources on this topic? thanks, David Ehresmann -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
I've got my GX21-9129-9 right here in front of me. It should be in a museum... I'll take Obscure Geek References for $800, Alex. Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 20, 2004 9:10 AM To: Multiple recipients of list ORACLE-L Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle vs Mysql
I do indeed. Rumor was that rpt/rpf was written by Larry himself. On 01/20/2004 09:39:34 AM, Goulet, Dick wrote: Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle vs Mysql
On 01/20/2004 08:04:33 AM, Thater, William wrote: Mladen Gogala scribbled on the wall in glitter crayon: oh damn, have we been at this too long?;-) Yes, we probably have. I must say that the spirit of Oracle Corp. has changed significantly since the days of Geoff Squire, Chris Ellis, Richard Barker and the gang. Those guys used to understand techies and were extremely helpful. The company was more open and didn't hide the database entrails so thoroughly as today. I was routinely able to get betas (like 7.0.12 or 8.0.3, which was, by the way, the very last beta I've ever received), to test them out, to learn them and to use them. The understanding was mutual: I was given early access, and, in return, I was pushing oracle everywhere I worked. Now, the whole thing is more MS like, more corporate. It may be good for stock owners, but that is not the company I grew accustomed to. This one doesn't inspire much loyalty or devotion. I'm actively looking for a change. So far, the most serious candidate is PostgresSQL, with the database formerly known as DB2 close second. I must say that I really, really like today's IBM. It ceased being an Infernal Bloody Monopolly and is now a company that I'm rather intrigued by. Oracle, on the other hand, is just another corporate giant trying to shove ever more defective products down my throat for more and more bucks and following the suit in the fine art of outsourcing. I believe that Orcle DBA has reached the end of the line, both perspective-wise and technology-wise. I'm planning to stay on this list for another year and then, I'm gone. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
Probably because they were dropping RPT RPF SQR smells a lot like it, YUCK! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Re[2]: Oracle vs Mysql
[snip] 120 col. punch cards? You had a high-density model. Mine only had 80 cols, of which 72 were usable for my goto-happy Fortran statements. SF No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 8:39 AM Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- -- --- -- --- -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Mladen, Well, I'll agree with you over 90% of your post. Oracle is extremely feature rich, to my vast enjoyment. BTW: We use pl/sql objects and Java stuff in production, mostly Oracle's pre-canned Java, but we do have a production application with it's own Java function too. As for IBM, looks like their going to play on Linux as well Uncle Larry better get his stuff together if he plans to compete. Still looking for the details of his site licensing idea. Got a CIO who's willing to sign on and toss out all other RDBMS's, if it's reasonable. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, January 19, 2004 11:04 PM To: Multiple recipients of list ORACLE-L It needs not to have the same capabilities, it needs to have capabilities that people are using. The primary capabilities that people need, in my opinion, are a decent scripting language, with the full complement of the database triggers, procedures, packages and functions, ability to store/access/administer huge objects, hundreds of gigabytes in size, a decent SQL implementation with plethora of functions and a support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support with something similar to long extinct SQL*Module (originally an IBM technology) and there would be huge number of users. Fortunately for oracle, MySQL still has problems with the most basic things: transactions, versioning, locking and SQL implementation. My conclusion is that MySQL will never be much more then a toy, despite the hype, catchy name and apparent popularity. I see much more dangerous adversaries in UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open source on Unix, and there are rumors of IBM musing over such a move, Oracle would most probably be toast. I must say that after some oracle's mischiefs, I wouldn't be the last one to defect and switch the databases. I wasn't the last one to leave DEC either, despite the fact that I was teaching VMS courses in 1992. My point is that Oracle is extremely feature rich. Very few people are using more then 20% of the database capabilities. Initially, in V8, I worked hard to learn about the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used in production. By now, I've forgotten it all. It's almost the same situation with Java in the database. Very few are using it. Most people test it, then say aha! and move on. Those two features will not make a whole lot of difference when a viable competitor emerges. Oracle 10g was written, for the most part outside of US. With beta testing this closed and restricted, it's not going to be tested thoroughly, not even close to thoroughly. What we are likely to get is an unstable, buggy and almost unusable gridlock version. Competitor might emerge sooner then some people are realizing. On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: If MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs Mysql Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had
tnsnames.ora not working ?
Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $ sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle vs Mysql
On 01/20/2004 10:09:34 AM, KENNETH JANUSZ wrote: Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM I've never done anything with System/3. My first IBM was 3084 with MVS and IMS, running on 8M RAM. After an upgrade, it was a monster with 16M RAM and CICS/DL1 combination. You might be interested in the fact that this system was routinely supporting between 800 and 900 users. Of course, the use of the Trashing System Option or TSO, for short, was severely limited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Oracle vs Mysql
Tuesday, January 20, 2004, 9:19:44 AM, Goulet, Dick ([EMAIL PROTECTED]) wrote: GD Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure I'd trust GD it that far. You know, I talked to someone at last year's MySQL conference who was using MySQL to manage three terabytes. I don't recall the details of what he was doing, how many users, how much I/O, etc. I recall though, that it was a mostly read-only database. However, I don't think size alone is a very meaningful statistic. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tnsnames.ora not working ?
Hello, On Tuesday 20 January 2004 11:01 am, Mercadante, Thomas F wrote: Reuben, If the normal connection is throwing an error, then it stands to reason that the seond one would not connect either. You need to get a connection working first before you try something else. I can confirm that this: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) work just fine. That why I'm confused why using tnsnames.ora by putting that entry in tnsnames.ora does not work. The entry is given to me by the DBA of the server I'm trying to connect to. The Oracle error you are getting is complaining about the service_name entry. Is this the same value for the database that you are trying to connect to? I'm not sure what you meant, but I suppose yes. The DBA gave me those entry that I copy-paste in my previous message. Is the database advertising itself as a service of dev_db? As far as I know, yes. I'm thinking the problem is more in the client side (me) rather than the server side. Am I correct ? Fix this first and get the connection to work via the normal method. And then you can try the other method. What do you mean by normal method? Is there a fundamental difference or assumption that I made that may not be true when I'm making connection by passing all the information in the user-name field and by using service name (like [EMAIL PROTECTED]) that is defined in tnsnames.ora? And, finally, why in the world do you want to do this? ummm, do what? What I want is to define that entry in tnsnames.ora so when I want to connect I can just type [EMAIL PROTECTED] as my username, rather than using the long description. Thanks for any help. RDB Tom Mercadante Oracle Certified Professional -Original Message- From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 10:49 AM To: Multiple recipients of list ORACLE-L Subject: tnsnames.ora not working ? Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $ sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: help
Abandon hope, all ye who enter here (Dante Alighieri) On 01/20/2004 10:24:27 AM, Bill Gentry wrote: help Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Gentry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[4]: Oracle vs Mysql
Tuesday, January 20, 2004, 9:34:25 AM, Jesse, Rich ([EMAIL PROTECTED]) wrote: JR Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make JR a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite JR COBOL, and could effortlessly have them do DB work. Yep! Rdb. That's where I used 'em. Once I took a program that I'd written to use SQL, and ported it to use regular files on the disk, and I did it by rewriting my module API in C. I never actually recompiled the program itself. I simply relinked with set of C subroutines that mimicked my SQL Module interface, but that went to disk files (indexed files I think, but it was so long ago I don't recall for sure). It was pretty cool. I could switch between using SQL and files simply by relinking. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora not working ?
Reuben, If the normal connection is throwing an error, then it stands to reason that the seond one would not connect either. You need to get a connection working first before you try something else. The Oracle error you are getting is complaining about the service_name entry. Is this the same value for the database that you are trying to connect to? Is the database advertising itself as a service of dev_db? Fix this first and get the connection to work via the normal method. And then you can try the other method. And, finally, why in the world do you want to do this? Good Luck. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 10:49 AM To: Multiple recipients of list ORACLE-L Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $ sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora not working ?
Are you using Oracle Services? I've seen this happen before and we change SERVICE_NAME to SID and everything works fine. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Reuben D. Budiardja Sent: Tuesday, January 20, 2004 10:49 AM To: Multiple recipients of list ORACLE-L Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $ sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Module compilers
All this talk about SQL Modules has got me to wondering. Does Oracle provide a SQL Module compiler at all? I seem to recall seeing mention of one for use with Ada. Does such a think exist for Oracle? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
On 01/20/2004 09:19:44 AM, Goulet, Dick wrote: Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure I'd trust it that far. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Given the price, I believe that some testing would be warranted, don't you think? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AQ
However... do not blindly treat SQL*Net messages as Idle waits. They can be important indicators of networking issues. Stephen [EMAIL PROTECTED] 01/20/04 08:24AM It is defined as below in the Reference Guide: The session is waiting on an empty OLTP queue (Advanced Queuing) for a message to arrive so that the session can dequeue that message. I would treat it as an Idle Wait, similar to, SQL*Net message from client. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: Is queue message an idle or an non-idle wait event? I have looked through the docs at tahti and metalink and can't find much info on AQ. Does anybody know where there are resources on this topic? thanks, David Ehresmann -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora not working ?
If you have a line like this on your sqlnet.ora names.default_domain = world Then try putting an entry like this in tnsnames.ora dbname.world=(etc. etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Inprocess actually. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:54 AM To: Multiple recipients of list ORACLE-L On 01/20/2004 09:19:44 AM, Goulet, Dick wrote: Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure I'd trust it that far. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Given the price, I believe that some testing would be warranted, don't you think? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
YES! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:10 AM To: Multiple recipients of list ORACLE-L Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 8:39 AM Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC setup on linux [again]
There's a new-ish RAC/Linux install guide on OTN: http://otn.oracle.com/tech/linux/pdf/RAC_1030.pdf Interestingly enough the guide specifically shows *not* to alias localhost at all (page 9). Hmmm... Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, January 09, 2004 5:14 PM To: Multiple recipients of list ORACLE-L Rich, Before now, I've not heard of setting localhosts to the real IP address. I've only seen it aliased to loopback ( 127.0.0.1 ). Why would you do otherwise? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tnsnames.ora not working ?
On Tuesday 20 January 2004 11:20 am, Scott Canaan wrote: Are you using Oracle Services? I've seen this happen before and we change SERVICE_NAME to SID and everything works fine. That does not work for me either. RDB -Original Message- Reuben D. Budiardja Sent: Tuesday, January 20, 2004 10:49 AM To: Multiple recipients of list ORACLE-L Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $ sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FW: Disk capacity planning
I agree wholeheartedly. This is why I think that anyone who attempts to size a system with formulas alone (that is, without testing) is almost 100% certain to either overspend miserably or downright fail. There are two things that are really important about testing. One is that it shows you how much hardware you'll need, because you can use real operational measurements to count things like IOps, instead of counting on smart people to infer operational statistics accurately while looking at paper. Just as importantly, it shows you how much wasted work your db/app/users are doing. This gives you the chance to eliminate that waste and go forward on a less expensive infrastructure than you might have imagined if you had studied it only on paper. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Niall Litchfield Sent: Tuesday, January 20, 2004 4:15 AM To: Multiple recipients of list ORACLE-L Hi The bad news is that I don't believe that calculating IO/Sec *can* be done for a *new* system. At least I'd like to see how it is done. I'm willing to bet that any formula for doing it will include (x%) for 'overhead', which actually means 'stuff I don't know about'. Of course if the *new* system is a replacement for an old system with known IO requirements and the workload is similar (or predictably different) then obviously a calculation/lower bound could be set. (of course if one has the exact data set that you will use, and the IO required by each and every sql statement in use, and the exact number of clients and the exact machine and software configuration that will be used for always then one can measure your IO requirement. I have never seen such a situation.) Actually however I think that this bad news is rather mitigated by the fact that I don't believe that capacity can be calculated ahead of time for a *new* system either. It will entirely depend on the take up of the application and any changes to the design/usage post go-live. I think that that leaves us in a relatively good position, namely that we can estimate values for B,P etc based on our skill, judgement (and budget :( ), and that because none of the figures are *hard* figures it ought to be possible to negotiate *sensible* disk purchases. They key is to take into account all the demands on the system (as Cary says). I'm afraid that for *new* systems though getting into formulae for *calculating* requirements is likely to give false assurances. Time to brush up on negotiating skills (and to find how how to effectivey bribe your sys admin and/or budget holders). Yours unscientifically Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 20 January 2004 09:19 To: Multiple recipients of list ORACLE-L Subject: Re: FW: Disk capacity planning Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because
RE: All packages under sys is invalid
so what's the solution? -Original Message- Sent: Tuesday, January 20, 2004 4:10 AM To: Multiple recipients of list ORACLE-L Someone is messing with standard package ... so it would seem. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, January 19, 2004 5:01 PM To: Multiple recipients of list ORACLE-L All, I have an strange problem, most of the packages under SYS user are invalid when I compile it it's compile without error but when I back again the package still is invalid, anybody have any idea? Thanks in advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
On Wed, 14 Jan 2004, eric king wrote: I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FW: Disk capacity planning
Chris, Thanks. When people do what you say, it's kind of like what would have happened if NASA had used the following assumption throughout the Apollo project: Assume adequate quantities of breathable air... It would have made the planning phase much simpler, but it would have been a touch more difficult on the users once the journey began. :) Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 3:19 AM To: Multiple recipients of list ORACLE-L Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail
Re: Spool to Excel File
If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/ With that you could slurp data out via DBI, and then build a customized spreadsheet based on the data. But I'd agree with what others have said. Dumping to csv, or some other delimited format and then importing into Excel would probably be the easiest way to go. -- Dan On Mon, 19 Jan 2004, Mudhalvan, Moovarkku wrote: Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: All packages under sys is invalid
Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 12:45 PM To: Multiple recipients of list ORACLE-L so what's the solution? -Original Message- Sent: Tuesday, January 20, 2004 4:10 AM To: Multiple recipients of list ORACLE-L Someone is messing with standard package ... so it would seem. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, January 19, 2004 5:01 PM To: Multiple recipients of list ORACLE-L All, I have an strange problem, most of the packages under SYS user are invalid when I compile it it's compile without error but when I back again the package still is invalid, anybody have any idea? Thanks in advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora not working ?
what is the listener status?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, January 20, 2004 10:49 AM To: Multiple recipients of list ORACLE-L Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $ sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Re[2]: Oracle vs Mysql
The old IBM System3 machines used 120 col. punch cards. And initially they had no HD's. Everything was done with cards and a reader/sorter. To compile a program you took the code you wrote, punched it into cards and then put it behind a stack of cards that was the compiler. The machine read the cards and generated another pile cards that was the compiled code. No matter how big the code you were compiling it took about 30 minutes to do a compile. All data was stored on cards - lots and lots of cards. Ken - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 9:34 AM [snip] 120 col. punch cards? You had a high-density model. Mine only had 80 cols, of which 72 were usable for my goto-happy Fortran statements. SF No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 8:39 AM Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- -- --- -- --- -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re[2]: Oracle vs Mysql
Tuesday, January 20, 2004, 12:44:43 PM, Daniel Hanks ([EMAIL PROTECTED]) wrote: DH nd to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only DH (iirc) if you use the 'Innodb' table type. My experience recently was just the opposite. I could create foreign key constraints *except* on innodb tables. However, I could create innodb tables, and transactions on them worked as I expected. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book The Difference Between God and Larry Ellison tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product SQL*Star, that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked isn't than like Oracle's SQL*Star?. My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L On Wed, 14 Jan 2004, eric king wrote: I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora not working ?
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
Re: Spool to Excel File
I've never used it before, but there is a piece to Excel called Microsoft query that allows you to query the database directly. Check help in Excel, search for query - ways to retreive data from external sources. HTH, Mike Daniel Hanks [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: Re: Spool to Excel File [EMAIL PROTECTED] .com 01/20/2004 01:04 PM Please respond to ORACLE-L If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/ With that you could slurp data out via DBI, and then build a customized spreadsheet based on the data. But I'd agree with what others have said. Dumping to csv, or some other delimited format and then importing into Excel would probably be the easiest way to go. -- Dan On Mon, 19 Jan 2004, Mudhalvan, Moovarkku wrote: Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NEW LYRICS TO BEATLES SONGS - OT but nice
Please, let's not turn this into a bulletin board. Spontaneous humor in a conversation (thread) is one thing, cutting and pasting completely non-relevant articles is another. For those of you that are non-native English speakers, the one thing... another thing phrase means don't do this. Jared Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/20/2004 01:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:NEW LYRICS TO BEATLES SONGS - OT but nice Write in C (Let it Be) When I find my code in tons of trouble, Friends and colleagues come to me, Speaking words of wisdom: Write in C. As the deadline fast approaches, And bugs are all that I can see, Somewhere, someone whispers: Write in C. Write in C, Write in C, Write in C, oh, Write in C. LOGO's dead and buried, Write in C. I used to write a lot of FORTRAN, For science it worked flawlessly. Try using it for graphics! Write in C. If you'veI'll fix this tonight I vow! ...
RE: Oracle vs Mysql
Huh???!?? What did you search for? I get many hits searching for postgresql. Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 20, 2004 12:29 PM To: Multiple recipients of list ORACLE-L [snip] A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. [snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
On 01/20/2004 01:29:25 PM, DENNIS WILLIAMS wrote: Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book The Difference Between God and Larry Ellison tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. I have a book devoted to PostgresSQL at home. When I come home, I'll post the information. The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product SQL*Star, that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked isn't than like Oracle's SQL*Star?. My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Not often, it's the rule. After all, technical merits are not the only criteria. The company management usually wants to know whether they can get 7x24 support, what happens if a critical security flaw is discovered, how long will it take to get the solution, are there any training facilities or will they have to pay for the airplane tickets in order to train people. That is why I keep mentioning IBM. None of these two databases stands the chance of a snowflake in heck if the big blue decides to put its weight behind UDB on Linux. For a technically good product to succeed, it needs to fulfill the requirements of the corporate world. That is why ElectroLux robot, despite the price tag of $3000 is more successful in the commercial environment then iRobot's Roomba, with the price tag of $200 (I love my Roomba, and it doesn't make any trouble). ElectroLux has service contract with Sears and the only thing you can do with Roomba is to pack it up and send it back. That is acceptable to me, but not acceptable to Hilton (and I don't mean Paris). It's exactly the same with the databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L On Wed, 14 Jan 2004, eric king wrote: I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL
RE: FW: Disk capacity planning
I found myself working with some larger databases in the 500-800 GB range that also spawn into multiple test databases. I take a df -k or bdf and bring that into excel. Then I take a query on all autoextend and break that out by disk. then I put that all together and tell what's left on disks. This allows me to quickly match test to prod by using autoextend and then run this to find out just which disks are WAY over kill and which ones still have room left. I may find a disk that has been promised 40 gig, but only had 5 gig on it, but then find 2-5 volumes that have 5-30 gig on them, and I can then add datafiles where they are needed and pull the extra autoextend from the full disk. The advantage is I'm usually quite okay while they are working and come back around and make it more perfect before they get me into trouble. -- Michael Kline Midlothian, VA 23112 804-744-1545 Chris, Thanks. When people do what you say, it's kind of like what would have happened if NASA had used the following assumption throughout the Apollo project: Assume adequate quantities of breathable air... It would have made the planning phase much simpler, but it would have been a touch more difficult on the users once the journey began. :) Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 3:19 AM To: Multiple recipients of list ORACLE-L Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should
CSPP's latest report
If you are interested in latest report of CSPP(Computer Systems Policy Project)... http://www.cspp.org/reports/ChooseToCompete.pdf -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
pga_aggregate_target and a memory leak
One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FW: Disk capacity planning
--- Niall Litchfield [EMAIL PROTECTED] wrote: Hi The bad news is that I don't believe that calculating IO/Sec *can* be done for a *new* system. At least I'd like to see how it is done. I'm willing to bet that any formula for doing it will include (x%) for 'overhead', which actually means 'stuff I don't know about'. Of course if the *new* system is a replacement for an old system with known IO requirements and the workload is similar (or predictably different) then obviously a calculation/lower bound could be set. (of course if one has the exact data set that you will use, and the IO required by each and every sql statement in use, and the exact number of clients and the exact machine and software configuration that will be used for always then one can measure your IO requirement. I have never seen such a situation.) Actually however I think that this bad news is rather mitigated by the fact that I don't believe that capacity can be calculated ahead of time for a *new* system either. It will entirely depend on the take up of the application and any changes to the design/usage post go-live. I think that that leaves us in a relatively good position, namely that we can estimate values for B,P etc based on our skill, judgement (and budget :( ), and that because none of the figures are *hard* figures it ought to be possible to negotiate *sensible* disk purchases. They key is to take into account all the demands on the system (as Cary says). I'm afraid that for *new* systems though getting into formulae for *calculating* requirements is likely to give false assurances. Time to brush up on negotiating skills (and to find how how to effectivey bribe your sys admin and/or budget holders). Yours unscientifically Niall this is where the z-space kicks in (discreteness). if you're using direct attached storage, the cabinets typically hold 14 drives spread across a split backplane per enclosure. 10 = PCI-X slots open 0 4 Server PCI-X buses n dual channel external SCSI RAID controllers n dual channel external SCSI RAID enclosures n*14 = drives 0 so we will attempt to spread the IO across the PCI-X bus channels, across RAID controller channels, across drives. so pick the following: 1 cabinet, 1 dual channel SCSI RAID controller, 14 drives 2 cabinets, 2 dual channel SCSI RAID controllers, 28 drives 3 cabinets, 3 dual channel SCSI RAID controllers, 42 drives (we have a winner :) ). 4 cabinets, 4 dual channel SCSI RAID controllers, 56 drives
Parallel Query determined by?
I've inherited a system that has a whole lot of indexes set to degree 10 and many tables set to 2 4. The users are complaining that Precise is showing a whole lot of time in Parallel Sync Wait. It is an HP box running 8.1.7.4 with 16 processors. The box is normally not very busy. Are there various init.ora settings that help the Parallel servers sync up, or is this just too high a setting? I'm suggesting we back of a good many of these things to simply 2 or 4 and then work our way up from there. Some of those indexes set to 10 are only 20 meg and 4 extents. There's no way they are getting 10 on that I would think. Can't find a whole lot on Metalink either. Or a good book on 800 gig warehouses using parallel? -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Oracle vs Mysql
Tuesday, January 20, 2004, 1:29:25 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote: DW I can recall editorials debating whether Unix/Oracle would ever be DW industrial strength enough to support critical applications. I admit to not being involved in databases that far back, but I've read enough to believe that Oracle was definitely the upstart in the early days, much like MySQL is now, and that's reason enough for Oracle Corp to worry about this new competition. Oracle grew up and became the heavyweight, and MySQL seems to be trying to follow the same path. All MySQL really needs to do is to add capability fast enough to keep up with the demands of their current customers. Their customers will grow, will continue to use MySQL, and as the product becomes more capable, more customers will jump on the bandwagon. DWThe story the author relates has to do with distributed databases. Ingres DW was developing a distributed database capability. Larry got wind of this and DW announced an new product SQL*Star, that hadn't even been discussed within DW Oracle. LOL! Took guts to do that. Larry must've given the developers heart-burn. DWMy point is that each time these free databases are discussed, people DW mention the fact that Postgres is superior from a technical standpoint. But DW from what I see, often it is the best marketed product that prevails. Someone mention books. Was that you Dennis? From what data I see, MySQL books far outsell PostgreSQL books. MySQL is the product with the mindshare, not PostgreSQL. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Inserts
This may be more on that parallel being set too high, but looking for ways to improve insert speed. I've seen the APPEND hint mentioned, but not sure if that speeds things up or simply says Insert at the end. Also, a co-worker found a PL/SQL on a degree=4 table that has a cursor, then one insert and then another insert to the same table before the cursor loops. What might this do to a parallel table? Maybe it's limited to only one server per cursor, but this could cause some fun otherwise. Thoughts, suggestions, white papers, places to look? -- Maks Midlothian, VA 23112 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spool to Excel File
I have used Microsoft Query in Excel. The syntax is a little tricky but it works pretty good. -Original Message- Sent: Tuesday, January 20, 2004 12:50 PM To: Multiple recipients of list ORACLE-L I've never used it before, but there is a piece to Excel called Microsoft query that allows you to query the database directly. Check help in Excel, search for query - ways to retreive data from external sources. HTH, Mike Daniel Hanks [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: Re: Spool to Excel File [EMAIL PROTECTED] .com 01/20/2004 01:04 PM Please respond to ORACLE-L If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/ With that you could slurp data out via DBI, and then build a customized spreadsheet based on the data. But I'd agree with what others have said. Dumping to csv, or some other delimited format and then importing into Excel would probably be the easiest way to go. -- Dan On Mon, 19 Jan 2004, Mudhalvan, Moovarkku wrote: Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Burton, Laura INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Password management using profiles
I have set up a profile where the passwords expire in 30 days, 6 characters minimum, grace period before the account locks to 6 days. It works as expected when the user logs in to our web site and tries to change the password. Users receive error messages whenever their password doesn't comply with the rules we have set up in the profile. We use the verify_function. The only problem I have is that when the users go to our web site they are presented with a login screen. If their account is locked or expired, or it is within the grace period before the account expires they don't receive a message to that account. If the account is expired the login screen resets and prompts for user id and password over and over. I have opened a TAR wit Oracle support, but they don't have an answer to that effect. They say it is an application issue. I've researched everywhere I could think of and everything I have found is the same, use profiles and the verify_function function. I've also read the documentation regarding password management, but I couldn't find anything of help. Our database is 8.1.7.2, and we're in Unix 5.8. We're using 9iAS release 1. We have created a DAD to connect to the database. When users click on our link then they see the login screen, just the same way as Metalink's. Only if they sign on successfully and try to change the password the profile works as a charm. I guess we need something that checks for the password status once the user enters id and password in the login screen. I'd appreciate any help in finding documents or web sites I can visit to find a solution to this problem. We'd like to enforce our password policies as soon as possible, but upper management doesn't want me to do it until we can display the information regarding password status. Users may be at a loss if they just see the login screen resetting without knowing why, and our Help Desk would be inundated with calls. Thanks again for any suggestions! Ana E. Choto Systems Programmer American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ana Choto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-904 after table rename
Hi! Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 4:19 PM Oradebug is the right way to go because, for some reason, alter system set events='904 trace name errorstack forever, level 10'; doesn't do anything. The only way to activate trace is to go to oradebug, attach the session (of course, one needs to do gymnastics with V$SESSION and V$PROCESS to find the SPID) and then use oradebug event 904 With all these strings attached, it's still a very useful tool to see which tables are being missed in action. On 01/19/2004 05:00:10 PM, Chris Stephens wrote: I went through a similar problem with the 904 error. I had to use oradebug to get a trace file to be produced. Good luck, Chris -Original Message- Sent: Monday, January 19, 2004 8:14 AM To: Multiple recipients of list ORACLE-L It turns out that the user had configured TOAD to use a table filter, which causes it to create and store a query. As you've probably guessed, the query was referencing a column which no longer exists. On a related note, I initially tried to capture the failing query using alter system set events='904 TRACE NAME ERRORSTACK', but no trace files were ever created. Any idea what the command should really have been? -Original Message- Norris, Gregory T [ITS] Sent: Friday, January 16, 2004 9:10 AM To: Multiple recipients of list ORACLE-L We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904 error (invalid column name) when trying to access the new table under TOAD. I can't think of anything weird about this table, except that the original has some column-level grants (but not to his userid... he has select/insert/update/delete on both tables). I had him try exiting and restarting TOAD, in case it was caching something relevant, but that didn't make any apparent difference. Any idea what might be going on? SQL desc tool_request_old NameNull?Type --- TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6) TREQ_PEOPLE_FKEYNOT NULL NUMBER(6) TREQ_SUBMIT_DATENOT NULL DATE TREQ_COMPLETE_DATE DATE TREQ_STATUS NOT NULL NUMBER(6) TREQ_COMMENTSVARCHAR2(2024) TREQ_BYPASS_STARTDATE TREQ_BYPASS_END DATE SQL desc tool_request NameNull?Type --- TREQ_ID NOT NULL NUMBER(6) TREQ_PERS_IDNOT NULL NUMBER(6) TREQ_STATUS_ID NOT NULL NUMBER(6) TREQ_SUBMIT_TMSTNOT NULL DATE TREQ_BYPASS_START_TMST DATE TREQ_BYPASS_END_TMST DATE TREQ_COMPLETE_TMST DATE TREQ_COMMENTSVARCHAR2(1024) -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: pga_aggregate_target and a memory leak
[EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... Be careful with pga_aggregate_target. I have very recently seen a case (Solaris + 9.2 but I cant't tell you exactly which patch level - probably the most recent) where two (by the way atrocious) queries generated by a DSS tool were responding very differently - and in a way that differences in the queries couldn't explain. From an Oracle standpoint, stats were roughly the same. Tracing proved that we were waiting for CPU, and truss that a call to mmap() was the culprit. Why, no idea. We first switched it (pga_thing) off, no more slow call to mmap(). However, it was still slow because we hadn't checked sort_area_size which was ridiculously small. We set sort_area_size to 10M, still with pga_aggregate_target unset, and once again the same very slow calls to mmap(). Memory misalignment? Anything else? Not much time to enquire but it looks like a mine field. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how do I interpret this in bstat/estat
Hi. I am looking at the bstat/estat report and see a high number of enqueue timeouts in the statistics section of the report. How do I tackle that? In the Niemec's book he receoomends increasing the enqueue_resources parameter. Metalink says that these may be related to DISTRIBUTED_LOCK_TIMEOUT being exceeded in a distributed transaction. Comments about changing ENQUEUE_RESOURCES are ill-founded. But it doesn't make any recommendations. So my question is whether anyone has any practical suggestions what I can do to address this issue. I am running Oracle 9203 (yes, I should be usuns the statspack, but I haven't switched to it yet). TIA Gene __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
On Tue, 20 Jan 2004, Mladen Gogala wrote: I have a book devoted to PostgresSQL at home. When I come home, I'll post the information. O'Reilly has Practical Postgresql, the full text of which is also available online: http://www.commandprompt.com/ppbook/ I know there are a couple of others floating around as well. But you're right, MySQL (sadly, IMO) has the mindshare. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AQ
Hi! I think what Kirti meant here, is that from only database's point of view (scope), the SQL*Net message from client waits do not indicate any database bottlenecks. Anyway, when you have network bottleneck, from my experience you usually see other SQL*Net message waits, like more data to/from client etc as well. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 6:39 PM However... do not blindly treat SQL*Net messages as Idle waits. They can be important indicators of networking issues. Stephen [EMAIL PROTECTED] 01/20/04 08:24AM It is defined as below in the Reference Guide: The session is waiting on an empty OLTP queue (Advanced Queuing) for a message to arrive so that the session can dequeue that message. I would treat it as an Idle Wait, similar to, SQL*Net message from client. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: Is queue message an idle or an non-idle wait event? I have looked through the docs at tahti and metalink and can't find much info on AQ. Does anybody know where there are resources on this topic? thanks, David Ehresmann -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle vs Mysql
What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:19 AM RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-904 after table rename
On 01/20/2004 02:59:35 PM, Tanel Poder wrote: Hi! Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones. And that, exactly is the problem. First, when you set event using alter system, the setting is system wide. Second, if you want to inspect a session that is currently executing, you can't. Oradebug is a kludge, but it works. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Password management using profiles
On 01/20/2004 02:34:45 PM, Ana Choto wrote: I have set up a profile where the passwords expire in 30 days, 6 characters minimum, grace period before the account locks to 6 days. It works as expected when the user logs in to our web site and tries to change the password. Users receive error messages whenever their password doesn't comply with the rules we have set up in the profile. We use the verify_function. The only problem I have is that when the users go to our web site they are presented with a login screen. If their account is locked or expired, or it is within the grace period before the account expires they don't receive a message to that account. If the account is expired the login screen resets and prompts for user id and password over and over. I have opened a TAR wit Oracle support, but they don't have an answer to that effect. They say it is an application issue. I've researched everywhere I could think of and everything I have found is the same, use profiles and the verify_function function. I've also read the documentation regarding password management, but I couldn't find anything of help. Our database is 8.1.7.2, and we're in Unix 5.8. We're using 9iAS release 1. We have created a DAD to connect to the database. When users click on our link then they see the login screen, just the same way as Metalink's. Only if they sign on successfully and try to change the password the profile works as a charm. I guess we need something that checks for the password status once the user enters id and password in the login screen. I'd appreciate any help in finding documents or web sites I can visit to find a solution to this problem. We'd like to enforce our password policies as soon as possible, but upper management doesn't want me to do it until we can display the information regarding password status. Users may be at a loss if they just see the login screen resetting without knowing why, and our Help Desk would be inundated with calls. So, let me make things straight: the problem is happening only when they attempt to access the database through the web? What authorization mechanism are you using on the web? JSP? ASP? CGI? EJB? The part that performs user authentication should be cabable of detecting the error, just like SQL*Plus is. Oracle support is probably right. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Hence why Sql*Server is out there. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:29 PM To: Multiple recipients of list ORACLE-L Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book The Difference Between God and Larry Ellison tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product SQL*Star, that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked isn't than like Oracle's SQL*Star?. My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L On Wed, 14 Jan 2004, eric king wrote: I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how do I interpret this in bstat/estat
Gene, This is the problem with high-level aggregate reports like BSTAT/ESTAT and STATSPACK. A possible problem is highlighted, but there is no detail on the possible cause. One way to get more info is monitor V$SESSION_EVENT view searching for sessions with lots of waits on enqueue wait-event: select sid, time_waited from v$session_event where event_name = 'enqueue' order by 2 desc; When you find an active session that seems to fit, then find out more about it, and most especially slap a level-8 SQL trace on the session for a period of time. Also, get more information from V$SESSION to understand what program is running, etc... Very often, you find out that the situation is benign, for example: * a single session is responsible for all enqueue timeouts; this session simply waits on a DBMS_PIPE for messages, but the sending application is not sending any messages, thus waiting application racks up lots of timeouts... Hope this helps... -Tim Hi. I am looking at the bstat/estat report and see a high number of enqueue timeouts in the statistics section of the report. How do I tackle that? In the Niemec's book he receoomends increasing the enqueue_resources parameter. Metalink says that these may be related to DISTRIBUTED_LOCK_TIMEOUT being exceeded in a distributed transaction. Comments about changing ENQUEUE_RESOURCES are ill-founded. But it doesn't make any recommendations. So my question is whether anyone has any practical suggestions what I can do to address this issue. I am running Oracle 9203 (yes, I should be usuns the statspack, but I haven't switched to it yet). TIA Gene __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
Jonathan, The only reason MySql is known better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:49 PM To: Multiple recipients of list ORACLE-L Tuesday, January 20, 2004, 1:29:25 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote: DW I can recall editorials debating whether Unix/Oracle would ever be DW industrial strength enough to support critical applications. I admit to not being involved in databases that far back, but I've read enough to believe that Oracle was definitely the upstart in the early days, much like MySQL is now, and that's reason enough for Oracle Corp to worry about this new competition. Oracle grew up and became the heavyweight, and MySQL seems to be trying to follow the same path. All MySQL really needs to do is to add capability fast enough to keep up with the demands of their current customers. Their customers will grow, will continue to use MySQL, and as the product becomes more capable, more customers will jump on the bandwagon. DWThe story the author relates has to do with distributed databases. Ingres DW was developing a distributed database capability. Larry got wind of this and DW announced an new product SQL*Star, that hadn't even been discussed within DW Oracle. LOL! Took guts to do that. Larry must've given the developers heart-burn. DWMy point is that each time these free databases are discussed, people DW mention the fact that Postgres is superior from a technical standpoint. But DW from what I see, often it is the best marketed product that prevails. Someone mention books. Was that you Dennis? From what data I see, MySQL books far outsell PostgreSQL books. MySQL is the product with the mindshare, not PostgreSQL. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
Yupp. RPF=report formatter or some such. -Original Message- eric king Sent: Tuesday, January 20, 2004 1:19 PM To: Multiple recipients of list ORACLE-L What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:19 AM RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
Eric, They were the precusors to Oracle reports. RPT was the report extraction tool, and RPF was the report formatter. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 3:19 PM To: Multiple recipients of list ORACLE-L What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:19 AM RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-904 after table rename
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug. -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Tuesday, January 20, 2004 3:25 PM To: Multiple recipients of list ORACLE-L On 01/20/2004 02:59:35 PM, Tanel Poder wrote: Hi! Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones. And that, exactly is the problem. First, when you set event using alter system, the setting is system wide. Second, if you want to inspect a session that is currently executing, you can't. Oradebug is a kludge, but it works. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Spool to Excel File
Strange, no one has mentioned OWA_SYLK. Do a search on SYLK at asktom.oracle.com There are 2 versions, one for web output and one for excel output. SYLK allows cell references, etc, if needed, which you won't get with CSV. Jared Mudhalvan, Moovarkku [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 08:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Spool to Excel File Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
But, unless you have old diskettes... you'll never see them. They died with the demise of v5. -Original Message- Sent: Tuesday, January 20, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Yupp. RPF=report formatter or some such. -Original Message- eric king Sent: Tuesday, January 20, 2004 1:19 PM To: Multiple recipients of list ORACLE-L What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:19 AM RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Password management using profiles
We're using pl/sql gateway and the Apache server. We've set up a default DAD on the gateway configuration screen, the connect string is our server name. Basic authentication, Package/Session Management Type: Stateless(Reset Package State). I've tried the profile by setting up a test user and expiring the account. If I go to sqlplus and log in with the expired user account sqlplus prompts me for a new password. I don't have a problem with that, but you know how users are, they wouldn't figure out why. And management wants users to receive a message telling them why they have to change their passwords without going through the Help Desk. My guess is that a pl/sql package has to be written so users get their password check at login time and receive messages such as the number of days they have before the password expires, or that the password is actually expired. Thanks Ana E. Choto Systems Programmer American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 Mladen Gogala [EMAIL PROTECTED] ng.comTo Sent by: Multiple recipients of list [EMAIL PROTECTED] ORACLE-L [EMAIL PROTECTED] .com cc Subject 01/20/2004 03:24 Re: Password management using PMprofiles Please respond to [EMAIL PROTECTED] com On 01/20/2004 02:34:45 PM, Ana Choto wrote: I have set up a profile where the passwords expire in 30 days, 6 characters minimum, grace period before the account locks to 6 days. It works as expected when the user logs in to our web site and tries to change the password. Users receive error messages whenever their password doesn't comply with the rules we have set up in the profile. We use the verify_function. The only problem I have is that when the users go to our web site they are presented with a login screen. If their account is locked or expired, or it is within the grace period before the account expires they don't receive a message to that account. If the account is expired the login screen resets and prompts for user id and password over and over. I have opened a TAR wit Oracle support, but they don't have an answer to that effect. They say it is an application issue. I've researched everywhere I could think of and everything I have found is the same, use profiles and the verify_function function. I've also read the documentation regarding password management, but I couldn't find anything of help. Our database is 8.1.7.2, and we're in Unix 5.8. We're using 9iAS release 1. We have created a DAD to connect to the database. When users click on our link then they see the login screen, just the same way as Metalink's. Only if they sign on successfully and try to change the password the profile works as a charm. I guess we need something that checks for the password status once the user enters id and password in the login screen. I'd appreciate any help in finding documents or web sites I can visit to find a solution to this problem. We'd like to enforce our password policies as soon as possible, but upper management doesn't want me to do it until we can display the information regarding password status. Users may be at a loss if they just see the login screen resetting without knowing why, and our Help Desk would be inundated with calls. So, let me make things straight: the problem is happening only when they attempt to access the database through the web? What authorization mechanism are you using on the web? JSP? ASP? CGI? EJB? The part that performs user authentication should be cabable of detecting the error, just like SQL*Plus is. Oracle support is probably right. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
Re: ORA-904 after table rename
But you can't set events with it :( Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 10:39 PM You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug. -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Tuesday, January 20, 2004 3:25 PM To: Multiple recipients of list ORACLE-L On 01/20/2004 02:59:35 PM, Tanel Poder wrote: Hi! Note that when you set an event with alter system, it will only apply for new sessions created, not for any existing ones. And that, exactly is the problem. First, when you set event using alter system, the setting is system wide. Second, if you want to inspect a session that is currently executing, you can't. Oradebug is a kludge, but it works. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Oracle vs Mysql
On 01/20/2004 03:29:33 PM, Goulet, Dick wrote: Jonathan, The only reason MySql is known better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Dick, when you are talking about big mouth from Finland, you probably don't refer to Pamela Anderson, also from Finland? The other person from Finland, whom I will not mention except by the first name (Linus) should be given credit for a wonderful OS that is successfully breaking the MS monopoly. I wonder whether this Linus needs a security blanket to carry around. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spool to Excel File
"SYLK allows cell references, etc, if needed, which you won't get with CSV. " Ahh. but you can with my method! If you use tab separated columns, you can also generate formula's that look like text, but work just fine in the spreadsheet! Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 20, 2004 3:44 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Spool to Excel FileStrange, no one has mentioned OWA_SYLK. Do a search on SYLK at asktom.oracle.com There are 2 versions, one for web output and one for excel output. SYLK allows cell references, etc, if needed, which you won't get with CSV. Jared "Mudhalvan, Moovarkku" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 08:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Spool to Excel FileDear Friends, I am trying to send output from SQLPlus to Excel file. If anyone did the same before please let me know. Thank YouMudhalvan M.M-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mudhalvan, MoovarkkuINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To 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).
Re: Re[2]: Oracle vs Mysql
I know I used to set up RPT and do all sorts of complex updating things. At the State and with things coming from mainframes, the data organization seemed to lend itself well to RPT. Since the organization was like of loops within loops, I could take the high order update and then loop through the subdata, and if it had subdata, so be it, I could get it too. What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:19 AM RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC
If you are using Linux, you can use NBD's (network block devices) that will allow you to use a third PC as a storage device. You can download the drivers at http://nbd.sourceforge.net/ There's a pretty good paper out there as well, at http://www.fi.muni.cz/~kripac/orac-nbd/ that will walk you through the installation and configuration of the NBDs. The performance isn't great, but it works. If you need more information, let me know -- I did a paper on this at IOUG last year and would be happy to send it to you. Regards, Brian -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 9:30 PM To: Multiple recipients of list ORACLE-L Dear All, I am posting this again as It seems to have got lost Regards Sriram Kumar -Original Message- Sent: Monday, January 19, 2004 1:26 PM To: '[EMAIL PROTECTED]' Importance: High Dear Guru's, Firstly, apology if this question sounds silly. I am intrested in setting up a RAC configuration at my home with a few desktop PC's. I would run either Win2K or Redhat Linux for the same. I am not sure whether I would be able to setup the RAC using a few desktop PC's. I look fwd to your advise in setting up the same. I believe an external storage is required for setting up RAC. Can I configure a 3rd pc's hard disk as a external storage for RAC??. Your views are very much appriciated. Thanks and Regards Sriram Kumar DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hengen, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
