Re: Perl DBA Tools

2001-04-24 Thread Jared Still
While that would be a worthwhile endeavor, I'm looking for stuff that is specific to Oracle operations, internal or external, as it relates to DBA tasks. Jared On Monday 23 April 2001 17:25, Patrick Housholder wrote: I just am starting into the perl land. * my project/tool: From

RE: RMAN list command doesn't show any backupsets although backup

2001-04-24 Thread Zvizdenco, Ghenadie
Hi, I'm using RMAN 8.0.5. I deleted with change...delete the backupsets then unregistered using the dbms_rcvcat.unregisterdatabase package. After the new registration I made backups but they are not showed in the RMAN. I looked in the recovery catalog database and foud these backupsets, but they

RE: ORA-04030

2001-04-24 Thread paquette stephane
The ORA 4030 is about a process not having enough room. It's been a bug on Oracle (Oracle 8.0.5 on hpux 10.20 had that) or your opening a cursor in a loop and you're forgetting to close it or something similar. --- Kevin Kostyszyn [EMAIL PROTECTED] a écrit : Acutally, 8.1.5 won't install

RE: import and strange PK violation error ???

2001-04-24 Thread Nirmal Kumar Muthu Kumaran
Hi vadim, Are you sure, when you disable unique constraint, the related index won't be deleted?. Hope that the index will be deleted, i tested in Oracle815, NT. Nirmal. -Original Message- From: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 12:50 AM To:

Re: Fwd: Re: Where can I find real-life-examples about ORACLE

2001-04-24 Thread paquette stephane
Well, I'm an admitted purist too. The dev team has done the datawarehouse first phase by themselves ignoring my recommandations. Hey who am i to tell how do things to a team 100% composed of one of the biggest consulting firm in the world (cgey) with no Oracle knowledge and very little DW

pcscfg.cfg needed

2001-04-24 Thread C.S.Venkata Subramanian
Dear List, Any one of can send pcscfg.cfg file for Red hatLinux6.2 running Oracle 8.1.6 and also for Sun solaris. Treat this as urgent. TIA Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

pcscfg.cfg needed

2001-04-24 Thread C.S.Venkata Subramanian
Dear List, Any one of can send pcscfg.cfg file for Red hatLinux6.2 running Oracle 8.1.6 and also for Sun solaris. Treat this as urgent. TIA Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Perl DBA Tools

2001-04-24 Thread Lord David
Jared Don't have any suggestions (except for enterprise manager that works, fast), but if you're looking for perl development help, I'd be interested. David Lord -Original Message- Sent: 23 April 2001 20:02 To: Multiple recipients of list ORACLE-L Hello List, For those of you that

RE: c compiler problem Solaris not found

2001-04-24 Thread Sinardy Xing
Hi Miller, Thank you for your help. My Solaris only having 1 cc file which is inside /usr/ucb I have Solaris CD with me now is the C compiler included in the package ? or do I have to download ? do you have the URL ? Thank You Sinardy -Original Message- Sent: Tuesday, 24 April 2001

RE: cdump, bdump, udump

2001-04-24 Thread Venkat_Kalepalli
Title: RE: cdump, bdump, udump Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and

MTSCost based Optimzer

2001-04-24 Thread Venkat_Kalepalli
Title: MTSCost based Optimzer Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and

RE: Perl DBA Tools

2001-04-24 Thread Mark Leith
Jared, Adding on to monitoring the alertSID.log, how about also monitoring the Archive log directory for free space - and size, then alert by email when say 90% full. Or go one step further - and when it reaches 90% full ftp the older logs to a backup directory. I'm still thinking about this

RE: Oracle on NT/2000 Service shutdown

2001-04-24 Thread Mark Leith
As a side note - I have noticed with 8.1.7 on Win2K that sometimes the service literally shuts down as quick as the listener service! Never saw this happen until 8.1.7 (8.1.6 still took about 20 seconds). Has anybody else noticed this? Mark -Original Message- Daiminger Sent: Tuesday,

RE: cdump, bdump, udump

2001-04-24 Thread Sinardy Xing
Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these

RE: Oracle on NT/2000 Service shutdown

2001-04-24 Thread Szecsy Tamas
Cann't it be that shutdown goes quickly and startup is slow? If I remember it well there is a possibility with Oracle 8.1.x(x=?) to set startup time for a database. This is to garantee startup time. Tamas Szecsy -Original Message- Sent: 2001.04.24. 12:40 PM To: Multiple recipients of

Re: cdump, bdump, udump

2001-04-24 Thread Joseph S. Testa
read the tuning guide and the administrators guide. nowadays this is a valid answer now that oracle docs are online, NO ONE HAS AN EXCUSE to not read the docs unlike back in the days when you had to pay thousands of dollars for paper docs. joe Venkat_Kalepalli wrote: Hello folks! I am

Oracle DBA Needed in St. Louis-Great Opportunity..

2001-04-24 Thread OraStaff
Well known brand name company in St. Louis, Missouri, is currently looking for an outstanding Oracle DBA who is well versed in physical or logical Oracle DBA work. You will be working on a team of DBA's as well as with a group of Data Analysts, fine tuning several Oracle databases which receive

RE: cdump, bdump, udump

2001-04-24 Thread Lanteigne, Mike
I must be 'old' because I miss my paper docs. I still print out some of the pdf docs, must be a confort thing! Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mohan, Ross
Ed, Ever since ZBR, the need to use the outside of the disk ( to reduce seeks ) is significantly reduced. Ross -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/24/2001 12:00 AM Dick, Thanks! SAME also suggests using the outer half of each disk for data

Re: MTSCost based Optimzer

2001-04-24 Thread Rachel Carmichael
turning on cost-based is easy: set the optimizer_mode parameter to choose in your init.ora, stop and start your database and then analyze all your tables. HOWEVER (and this is a biggie) this will not automatically make all your queries run faster. You will need to examine each and every

RE: Idle time

2001-04-24 Thread Mark Leith
If I understand your question - the commmand column relates to the last command that the user sent to the database - therefore the select entry would mean the last statement sent to the database by that user was a select statement. HTH Mark -Original Message- Vaidya Sent: Tuesday,

RE: Perl DBA Tools

2001-04-24 Thread Rachel Carmichael
truncating listener logs -- or even starting a secondary listener, stopping the one with the log that is too large and removing the log, then restarting the original listener From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

RE: how to install Oracle Developer2000 on Windows98 ?

2001-04-24 Thread Sonja ehovi
Well, I remember that I had such installation problems. To begin with, you must have CD for Win98 . It really annoyed me when I realized that you can't install Developer from CD for Win95/NT. HTH, Sonja -Original Message- Sent: Saturday, April 21, 2001 11:16 AM To: Multiple

Drop table problem

2001-04-24 Thread Ramasamy, Baskar
Hi Could anyone tell me how to solve the below problem. I am trying to drop the table and I am getting the error ora 2266. I have disabled all the foreign key constraints also, but still I am getting the same error, Early response much appreciated Baskar -Original Message- Sent: 23

sort_area_size + temp tablespace extent sizing

2001-04-24 Thread Adrian Roe
Hi List, Quick question regarding temp tablespace extent sizing. I have always assumed that the extent size for a temporary tablespace needs to be equal to the size that sort_area_size is set to. A sort that can't fit into memory then goes and grabs temp tablespace extents of a size equal to

ORA-01458

2001-04-24 Thread Sonja ehovi
Hi all! Oracle 8.1.7 on WinNT. When I try to copy one table from one schema to another I get this error message. ORA-01458: invalid length inside variable character string Description is "very informative" 01458, 0, "invalid length inside variable character string" //

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mark Leith
Care to elaborate on ZBR for those of us with enquiring minds and absolutely no idea what you are on about :) Cheers Mark -Original Message- Sent: Tuesday, April 24, 2001 01:56 To: Multiple recipients of list ORACLE-L Ed, Ever since ZBR, the need to use the outside of the disk ( to

Re: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Nuno Souto
- Original Message - Ever since ZBR, the need to use the outside of the disk ( to reduce seeks ) is significantly reduced. PMFJI. The reason for using the outside of the disk is the increased linear velocity there re the heads. Larger circle, same angular velocity, larger

Listener.log

2001-04-24 Thread Nguyen Thanh-truc
Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen

pool package from database

2001-04-24 Thread Gregory Faktor
Hi All! I looking for script witch will extract package and package body from user_source view and generate create or replace package and create or replace package body scripts. Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Faktor INET:

Oracle vs DB2

2001-04-24 Thread Dennis Taylor
Disclaimer: I am *not* trying to start a religious war, and I am *not* trying to advocate DB2. I am simply offended. Thus this post. As some may remember, I'm doing an evaluation of Oracle vs DB2 vs SQLServer to determine our future direction. Here's a datum that makes a significant difference

RE: MTSCost based Optimzer

2001-04-24 Thread Rachel Carmichael
definitely all or nothing -- if you have analyzed the large table and join it to an unanalyzed small table, you are going to get rule based From: Tim Sawmiller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: MTSCost based

Re: cdump, bdump, udump

2001-04-24 Thread David A. Barbour
Sinardy, Some logs are generated by default (alert_SID.log) but actions triggering entries can be adjusted through either initialization parameters in the initSID.ora file, via commands issued by the DBA, or by users who have been granted specific privileges/roles (commands like ALTER DATABASE,

RE: Listener.log

2001-04-24 Thread Mark Leith
Moving the listenet.log file will not stop the listener to stop writing to this file (like the alertSID.log), you will either need to start stop the listener (if you get a chance to) or there is another lsnrctl command; something like: lsnrctl listener_name reload, which will reload the

RE: Oracle vs DB2

2001-04-24 Thread Boivin, Patrice J
Well, This is on topic - www.wired.com http://www.wired.com today has an article re. IBM announced that it is buying Informix for $1Billion. Ah, if only I had that kind of money myself - I could take more Oracle courses! I don't know what will happen with Informix then, does that mean they

RE: cdump, bdump, udump

2001-04-24 Thread Yosi
Wow. I feel just the opposite. When I had the paper docs, I could take one on the train, take it home, know what I read, feel like I'd accomplished something when I'd read a chunk, etc. I had a relationship with the books, my tuning guide had a corner bent, the app dev guide was missing a cover.

Re: sort_area_size + temp tablespace extent sizing

2001-04-24 Thread paquette stephane
The extent size of the temp tablespace should be a multiple of the sort_area_size parameter + 1 block. If your sort_area_size is 128K and if you need to go to temp tablespace that means that 128K is not enough so you should allocate for more than 128K. temp extent = (sort_area_size*n)+ 1 block

Re: MTSCost based Optimzer

2001-04-24 Thread David A. Barbour
If you have the time and horsepower, analyze the database. If not, wait until somebody complains and run a trace/tkprof against their SQL. You may want to consider using histograms on selected tables. There was a discussion on using histograms earlier this month. Steve Adams wrote a script to

Re: Fwd: Re: Where can I find real-life-examples about ORACLE

2001-04-24 Thread Dennis Taylor
At 12:25 AM 4/24/01 -0800, you wrote: do a star join on their tables it will snow cows. Bwahh hahah! Thanks for the morning laugh. I've never heard that particular expression before. Dennis Taylor Don't be fooled by old cliches - He who laughs last may have

RE: cdump, bdump, udump

2001-04-24 Thread Gogala, Mladen
I'm taking yoga classes and being much happier and less cynical, I'm much less inclined to reply with RTFM, despite the fact that this question more then deserves such an answer. -Original Message- Sent: Tuesday, April 24, 2001 12:40 AM To: Multiple recipients of list ORACLE-L Uh oh -

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Haskins, Ed
Here's some info I was able to dig up! Ed Haskins Oracle DBA Verizon Wireless Zoned Bit Recording One way that capacity and speed have been improved on hard disks over time is by improving the utilization of the larger, outer tracks of the disk. The first hard disks were rather primitive

MTS and Cost Based Analyzer

2001-04-24 Thread David A. Barbour
Why would you be looking to change/implement something if you're not aware of the advantages/disadvantages? Changing to the cost based optimizer requires that both the DBA(s) and the Developer(s) understand how and why it works. Although a simple change to your initSID.ora file (yet another

RE: sort_area_size + temp tablespace extent sizing

2001-04-24 Thread DEMANCHE Luc (Cetelem)
Title: RE: sort_area_size + temp tablespace extent sizing Stephane, What situation would make you choose a certain value (i.e.: using '3' versus '4.5')? -Message d'origine- De: paquette stephane [mailto:[EMAIL PROTECTED]] Date: Tuesday, April 24, 2001 6:03 PM À: Multiple

RE: Listener.log

2001-04-24 Thread Gogala, Mladen
touch $ORACLE_HOME/network/log/listener.log -Original Message- Sent: Tuesday, April 24, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks.

RE: help - spool file name - use variable

2001-04-24 Thread Gogala, Mladen
How about spool report_id.dat ? -Original Message- Sent: Monday, April 23, 2001 6:22 PM To: Multiple recipients of list ORACLE-L I'm writing a sql script file (first run couple of queries, insert results into a temp table), at last, the data need to spool out to separate files. the

RE: Listener.log

2001-04-24 Thread blair
Don't worry. Everything will be all right. The listener.log is still cached in memory. The next time you bounce (cleanly) Oracle it will start a new one listener.log. ..tom -Original Message- From: Nguyen Thanh-truc [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 11:47 AM

Re: Oracle vs DB2

2001-04-24 Thread Dan . Hubler
Why the enterprise license for Oracle? Dennis Taylor [EMAIL PROTECTED]@fatcity.com on 04/24/2001 10:57:11 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Disclaimer: I am *not* trying to start a

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Tim Sawmiller
Thank you for the very informative and detailed explanation. [EMAIL PROTECTED] 04/24/01 12:51PM Oops, I guess I was just too obtuse and brief. Sorry 'bout that! Here is an amplification and correction of what I sent another lister who contacted me offline. Folks, please feel free to correct

RE: Oracle on NT/2000 Service shutdown

2001-04-24 Thread Kimberly Smith
I have not noticed this with Win 2000 but I have noticed it on HP. Granted the machine we are running it on is quicker then the one with 8.0.6 but it was very quick to fail over to the other server. Up and down quick. -Original Message- Sent: Tuesday, April 24, 2001 3:40 AM To: Multiple

RE: Oracle vs DB2

2001-04-24 Thread Murali Vallath
Boivin, Not true, when Oracle purchased Rdb from Digital 10 years ago. This was the talk, Rdb will die in 7 years. Today it is being enhanced every version/release. SO DON'T KNOW, what IBM will do. Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

RE: ORA-01458

2001-04-24 Thread Vadim Gorbounov
Sonja, this is bug. Promised to be fixed in 8.1.6, and back again :( Workaround is to create table .. as select .. OR simply create table, than insert... HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, April 24, 2001 11:26 AM To: Multiple recipients of list ORACLE-L

OT RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mohan, Ross
Title: OT RE: HYPER VOLUMES - RE: Never split index and data files ... Zymurgy Beats Recidivism? || -Original Message- || From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 11:51 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: HYPER

RE: MTSCost based Optimzer

2001-04-24 Thread Rachel Carmichael
Well, I was on 7.3.4 at the time.. so stored outlines were not an option. I haven't used them since, as the 8i databases I have are all new and we coded for cost-based to begin with. Rachel From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list

2 RMAN questions

2001-04-24 Thread Glasrot, Nechama
hi listers ... 1/ i had to delete archived logs before i could back them up thru rman ...my ? is how do i notify rman that these logs no longer exist ... do i crosscheck (mark as expired) all previous logs and then issue a complete resynch ... or do i just resynch ... or ? 2/ i am changing the

RE: Listener.log

2001-04-24 Thread Vadim Gorbounov
Hello, You have to restart your listener. It continues towrite to "invisible" file (inode without any reference from directories). Welcome to UNIX. HTH Vadim Gorbounov Oracle DBA -Original Message-From: Nguyen Thanh-truc [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24,

Grumble - OTN is now as ugly as Oracle.com

2001-04-24 Thread Yosi
WHINE MODE Why do they insist on making these sites unreadable, blinding to the eye, and so on? There's nowhere on the NEW! OTN to rest your eye, to focus, to stabilize, etc... Why would anyone want their site to look like this? /WHINE MODE Sorry, and thanks for letting me vent (like you had

Re: Perl DBA Tools

2001-04-24 Thread Jared Still
On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote: truncating listener logs -- or even starting a secondary listener, stopping the one with the log that is too large and removing the log, then restarting the original listener Good idea. Thanks Rachel Jared -- Please see the

Re: Awfully annoying SQLLDR problem

2001-04-24 Thread David A. Barbour
Tom, Just cogitating and ruminating... You mentioned that you're executing the load as part of a larger procedure. Couldn't you execute a shell script that would ftp the file to the target server and run sqlldr via rsh -c? Another thought would be to have the target file on an

RE: cdump, bdump, udump

2001-04-24 Thread Mohan, Ross
Title: RE: cdump, bdump, udump karma, prana, hatha, or ayurvedic yoga? Most people just think of hatha yoga when they talk about it. Ross p.s. let me know when you can do the Royal Pigeon || -Original Message- || From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] || Sent:

(Fwd) Re: OT - MIME - outbound prep utility for database appl

2001-04-24 Thread Eric D. Pierce
--- Forwarded message follows --- F r o m : Martin Ireland m a r t i n . i r e l a n d @ g o v . a b . c a Organization: Alberta, Innovation Science T o : Eric D. Pierce P i e r c e E D @ C S U S . E D U Date sent: Tue, 24 Apr 2001 09:04:40 -0600 See the

RE: cdump, bdump, udump

2001-04-24 Thread Thater, William
On Tue, 24 Apr 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: -Wow. I feel just the opposite. When I had the paper docs, I could -take one on the train, take it home, know what I read, feel like -I'd accomplished something when I'd read a chunk, etc. I had a -relationship with

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mohan, Ross
My pleasure Tim. How nice of you to say soreally I could do this once a week and never repay the value I get from the list. || -Original Message- || From: Tim Sawmiller [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 1:27 PM || To: Multiple recipients of list ORACLE-L

Re: Listener.log

2001-04-24 Thread Ruth Gramolini
When the listener needs to make a log entry he will create a new log. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 11:47 AM Hello everyone, After moving the listener.log and compressed, there is no more log for the

Re: Perl DBA Tools

2001-04-24 Thread Jared Still
On Tuesday 24 April 2001 03:40, Mark Leith wrote: I'm still thinking about this one - we have loads of requests for functionality in tools that just seem outrageous - shall I send them all to you in a great big list? :-) Thanks for your thought Mark. As for the others, go ahead and send

RE: cdump, bdump, udump

2001-04-24 Thread Eric D. Pierce
what's wrong with your printer? what's wrong with just spending a bunch of money on hardcopy documentation like you used to do On 24 Apr 2001, at 8:15, [EMAIL PROTECTED] wrote: Date sent: Tue, 24 Apr 2001 08:15:54 -0800 To: Multiple recipients of

RE: Perl DBA Tools

2001-04-24 Thread Toepke, Kevin M
Run EXPLAIN PLAN... email me if you want to integrate my version in your tool. Kevin Toepke -Original Message- Sent: Tuesday, April 24, 2001 1:21 PM To: Multiple recipients of list ORACLE-L On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote: truncating listener logs -- or even

RE: Oracle vs DB2

2001-04-24 Thread Weaver, Walt
Not true. You can use the Standard Edition for serving web pages. We're doing it. Costs much less than $160,000, although still more than $6,000 Cdn. One thing I don't get: it's $6,000 Cdn for a 1-user license, right? How is a 1-user license going to do you any good if you're serving web

RE: Listener.log

2001-04-24 Thread Patricia Ashe
Only if the listener has been restarted after moving or removing the listener.log Patricia -Original Message- Sent: Tuesday, April 24, 2001 10:56 AM To: Multiple recipients of list ORACLE-L When the listener needs to make a log entry he will create a new log. Ruth - Original

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mark Leith
Zealous Bumf Router? -Original Message- Patrice J Sent: Tuesday, April 24, 2001 04:51 To: Multiple recipients of list ORACLE-L Zebra Boisterous Rout Zebra Blues Routine Hmm it's hard to come up with meaninful acronyms, usually it's easier... : ) Patrice Boivin Systems Analyst

RE: sort_area_size + temp tablespace extent sizing

2001-04-24 Thread Deshpande, Kirti
Hi Ade, The formula that I use is: extent size = Multiples of sort_area_size. If the data file for the temp tablespace is configured with the additional db block size for the overhead, then the remaining space would take all possible extents without wasting any disk space. In your case you

News flash - IBM buys Informix

2001-04-24 Thread The Oracle DBA
It has been announced today that IBM has purchased Informix. See your local tech news service later today for details. H. Wonder what Larry thinks about this? Cheers, Earl Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official

RE: sort_area_size + temp tablespace extent sizing

2001-04-24 Thread Vadim Gorbounov
Hello, Ade, You are right, Oracle needs one-block header, and you have to add this block to optimize performance. The extent size my be one block + N*SORT_AREA_SIZE N depends on size of typical sort operations. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday,

RE: cdump, bdump, udump

2001-04-24 Thread Gogala, Mladen
Oh, my god! I think that I should return to my beloved threadmill -Original Message- Sent: Tuesday, April 24, 2001 2:16 PM To: Multiple recipients of list ORACLE-L karma, prana, hatha, or ayurvedic yoga? Most people just think of hatha yoga when they talk about it. Ross

Re:RE: Oracle vs DB2

2001-04-24 Thread dgoulet
Patrice, I just read that from IBM's WEB site (http://www.ibm.com/news/2001/04/24.phtml) for those interested. Looks like the DB market in the near future will be Oracle DB2, with a little SQL*Server sprinkled in for spice. My retirement fund may get better, but will I be able to survive

Re:Oracle vs DB2

2001-04-24 Thread dgoulet
Dennis, First off I will totally agree with your last statement, Oracle is not in line with the market needs a severe case of reality check across the board. What their doing to my retirement fund is close to criminal. But, I believe your comparing apples to oranges. DB2 UDB

Re: Listener.log

2001-04-24 Thread David A. Barbour
Okay, you moved the old one. Perhaps you haven't had any activity that would cause an entry to be generated for the log? Or have you changed any of the parameters in your listener.ora file? Regards, David A. Barbour Oracle DBA Nguyen Thanh-truc wrote: Hello everyone, After moving the

Re:OT RE: HYPER VOLUMES - RE: Never split index and data fi

2001-04-24 Thread dgoulet
Aright, someone pass the snow shovel!! It's getting deep in here!! :-) Dick Goulet Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 4/24/2001 9:36 AM Zymurgy Beats Recidivism? || -Original Message- || From: Boivin, Patrice J

RE: cdump, bdump, udump

2001-04-24 Thread Eric D. Pierce
Does everybody else need to wear a really big hat? On 24 Apr 2001, at 10:15, Mohan, Ross wrote: p.s. let me know when you can do the Royal Pigeon ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network

Re: Perl DBA Tools

2001-04-24 Thread John Carlson
How about wrapping this is a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way,

RE: cdump, bdump, udump

2001-04-24 Thread Yosi
Printer's not the same. I understand this is all ethereal, but it's not the same. I've got a collection of the docs in big black looseleaf binders with a label I printed on the side that says which book it is. It's not as carriable as a smaller book, (try opening one of those on a subway...)

Re: 2 RMAN questions

2001-04-24 Thread Ruth Gramolini
I'll try to answer these; You can uncatalog any archivelogs you have removed without using rman. This will accomplish what you wish. But for the future, try to an rman archivelog backup with the delete option. This put the archivelogs in a backupset and then deletes them. Rman know right where

RE: Listener.log

2001-04-24 Thread Patricia Ashe
You have to reload or stop/start the listener to create a new log. -Original Message- Sent: Tuesday, April 24, 2001 8:47 AM To: Multiple recipients of list ORACLE-L Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help

RE: help - spool file name - use variable

2001-04-24 Thread Helen Zhung
I tried, but didnot work. I hard code them now. Thanks "Gogala, Mladen" [EMAIL PROTECTED] wrote: How about "spool report_id.dat" ?-Original Message-Sent: Monday, April 23, 2001 6:22 PMTo: Multiple recipients of list ORACLE-LI'm writing a sql script file (first run couple of queries,

RE: Oracle vs DB2

2001-04-24 Thread Jamadagni, Rajendra
Now we know how Oracle saved a billion $$ ?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have

RE: MTSCost based Optimzer

2001-04-24 Thread Miller, Jay
Hi Rachel, It was my impresssion that joining an analyzed and unanalyzed tables will used CBO, but the choice of access path will be badly skewed since the assumptions Oracle makes about the unanalyzed table will probably be nowhere near reality. Obviously this can result in a terrible access

RE: List of user sessions

2001-04-24 Thread dieter . oberkofler
hi mainak! you might want to have a look at my shareware osession on my web page at: www.materialdreams.com cheers do -Original Message- [EMAIL PROTECTED] Sent: Monday, April 23, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Hi, i want to know that how will i get to know

SQL*net ??? , Y2K installer??? / RE: how to install Oracle Developer2000 on Windows98 ?

2001-04-24 Thread Eric D. Pierce
I think the original question was about failed SQL*Net, but it was to vague to know for sure. Anyway, all of the Developer/2000 CDs I have ever seen are for windows 95/98/NT (american english). If you have an old Developer/2000 CD, you might get problems because earlier versions of the

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mohan, Ross
Tim, The outside track contains more data. Think of it this way: there is X bits per square cm of disk real estate. a track is constant thickness, but steadily increasing circumference, so the area of the track -- and therefore the data storable there -- increases. -- Ross ||

Re: REP: Locally Managed Tablespaces

2001-04-24 Thread The Oracle DBA
A couple of threads here and in other lists have mentioned this. A person puts LMTSs up and sets uniform extents on and sets it to, say 1M. Later they notice that not all extents are 1M. Thanks, Earl --- TheOracleDBA [EMAIL PROTECTED] On Mon, 23 Apr 2001 11:01:37 Jared Still wrote:

Re: Oracle vs DB2

2001-04-24 Thread Tim Sawmiller
FYI, the Oracle Marketing spiel... Price Does Not Equal Cost Databases store, protect, manage and provide access to a company's most important business asset * information. There is no other product that a company will buy that has a greater effect on information systems. Selecting the wrong

Re:Oracle vs DB2

2001-04-24 Thread Dennis Taylor
At 01:13 PM 4/24/01 -0400, you wrote: But, I believe your comparing apples to oranges. DB2 UDB Workgroup is not the equal of Oracle Enterprise. If you want to compare apples apples, try Yes, but in order to put an Oracle database on the web, I HAVE TO USE ENTERPRISE EDITION! The

RE: Listener.log

2001-04-24 Thread Adams, Matthew (GEA, 088130)
No, you do not have to restart the listener. touch the listener.log file (we do a 'cp /dev/null $ORACLE_HOME/network/log/listener.log) and the listener will start writing to it again. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is

Re: cdump, bdump, udump

2001-04-24 Thread Jared Still
On Tuesday 24 April 2001 09:15, Gogala, Mladen wrote: I'm taking yoga classes and being much happier and less cynical, I'm much less inclined to reply with RTFM, despite the fact that this question more then deserves such an answer. Really? I thought you might engage in a little Greco Roman

Re: Oracle vs DB2

2001-04-24 Thread Dan . Hubler
Maybe I am wrong here but.. My understanding is that you can use standard or enterprise for any appication you wish. If your application communicates with the Web/internet, you have to license the product based on UPU's; they will not accept a named user license.

Re: Re[2]:Oracle vs DB2

2001-04-24 Thread Dennis Taylor
At 01:35 PM 4/24/01 -0400, you wrote: Dennis, OK, but your sales critter is DEAD wrong. We bought a Standard edition from Yep. Based on your statement, I checked with the critter. He says yes, you can do it with Standard version. Which costs (ballpark) $33K Cdn for the unlimited user

OT RE: cdump, bdump, udump

2001-04-24 Thread Mohan, Ross
Title: OT RE: cdump, bdump, udump LoL! No, but it is hellaciously hard to do. And extremely rewarding! || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 3:13 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: cdump,

Physical Data Layout

2001-04-24 Thread Chris Rezek
Hello all, We are moving our production database onto new disks to improve performance. It is a high transction OLTP environment using Oracle8i on a SPARC Solaris box. We are divided about which parts of Oracle to put where for the best performance. We have come up with two basic designs.

RE: cdump, bdump, udump

2001-04-24 Thread Ed . Haskins
Yeah, as soon as Palm increases the amount of Memory to something like 1GB. ;-) Ed Haskins Oracle DBA Verizon Wireless maybe someone should convert them to Palm DOC format and we can load them on our Palms to carry with us *everywhere*.;-) -- Bill Thater Certifieable ORACLE

RE: ORA-01458

2001-04-24 Thread Gogala, Mladen
Try upgrading to 8.1.7.1 if it's out for NT. Quite a few bugs were fixed -Original Message- Sent: Tuesday, April 24, 2001 12:52 PM To: Multiple recipients of list ORACLE-L Sonja, this is bug. Promised to be fixed in 8.1.6, and back again :( Workaround is to create table .. as

Recall: Listener.log

2001-04-24 Thread Adams, Matthew (GEA, 088130)
Title: Recall: Listener.log Adams, Matthew (GEA, 088130) would like to recall the message, Listener.log.

  1   2   >