RE: Your new book

2003-10-23 Thread DENNIS WILLIAMS
Ryan Actually the math that queueing theory is based on is not calculus. It may also help if you understand that a queue is a fancy French word for "waiting line". See, doesn't it sound much more important academically if you say you study queueing theory than if you say you study waiting lines?

Re: Mauve databases use least RAM

2003-10-23 Thread Nuno Souto
HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets "circulated"to as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > At the risk of opening old wounds, after

Re: Re: Your new book

2003-10-23 Thread rgaffuri
if i want to improve my math skills how much undergraduate math would you recommend? > > From: Paul Drake <[EMAIL PROTECTED]> > Date: 2003/10/23 Thu AM 02:29:24 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Your new book > > Ryan, > > I do not recall seeing

Re: Re: Your new book

2003-10-23 Thread Mladen Gogala
As much as you can get. If not for Cary's book, you'll need abstract algebra for dealing with W2 forms and taxes. On 2003.10.23 08:12, [EMAIL PROTECTED] wrote: if i want to improve my math skills how much undergraduate math would you recommend? > > From: Paul Drake <[EMAIL PROTECTED]> > Date: 20

RE: Change Character sets

2003-10-23 Thread Thomas Day
Thanks. But since it was an import from an US7ASCII database I am completely confident that there'll be no problems. But that's about the only circumstances in which I'd try something like that.

RE: Change Character sets

2003-10-23 Thread Thomas Day
Yup. That's the ticket. "Quintin,

RE: Change Character sets

2003-10-23 Thread Thomas Day
Developers who know their stuff but don't know Oracle. I don't know Java. US7ASCII works. Other character sets don't. Why? Just one of life's little mysteries as far as I'm concerned. Probably there's something they could do to make it work with other character sets but I don't know what it i

What happened to Howard Rogers ?

2003-10-23 Thread sdf
Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets "circulated"to as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTE

Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread tjambu_fatcity
Important:  Please read the following Oracle Alert. We strongly recommend that you do not connect the Oracle Database directly to the Internet. Got your attention?  That is what is in the Alert.  These alerts are beginning to come all too often.  Sounds just like Microsoft's software, yeah? Buffe

RE: Your new book

2003-10-23 Thread Thater, William
Title: Message   -Original Message-From: Cary Millsap [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 7:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: Your new book Niall,   This is a very kind, and I believe (maybe it's only hopeful belief)

RE: Mauve databases use least RAM

2003-10-23 Thread Norris, Gregory T [ITS]
> HJR's saga still rates as one of the all-time > dumbass knee-jerk reactions from Oracle > damagement. I don't mean to rub salt in an open sore, but you've got me curious. What happened with HJR? I don't think I've heard anything about this... -- My employers like me, but not enough to let me

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread Mark Leith
I find it more interesting that the problem doesn't apply to Windows servers... ;)   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: 23 October 2003 14:25To: Multiple recipients of list ORACLE-LSubject: Do not connec

RE: Re[2]: Your new book

2003-10-23 Thread Thater, William
Jonathan Gennick scribbled on the wall in glitter crayon: > O'Reilly's production people would have been much happier > had I given that advice (I didn't), and had Cary taken it > (he wouldn't have, I'm sure). There was much wailing and > gnashing of teeth over Cary's math. Many battles were foug

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread Norris, Gregory T [ITS]
No problem, it's unbreakable!!! ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Thursday, October 23, 2003 8:25 AMTo: Multiple recipients of list ORACLE-LSubject: Do not connect Oracle DB to the Internet. Oracle A

Re: What happened to Howard Rogers ?

2003-10-23 Thread rgaffuri
howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue hi

stupid dbms_job question

2003-10-23 Thread rgaffuri
im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYS

Re: RE: Your new book

2003-10-23 Thread rgaffuri
i took a discrete math class last summer at a state university. Id recommend for all technical people. I hadnt had math in 10 years and found it extremely difficult(half the class failed). the problem solving skills you get out of doing are incredible. No you dont learn new oracle commands but y

Re[4]: Your new book

2003-10-23 Thread Jonathan Gennick
Thursday, October 23, 2003, 8:49:29 AM, you wrote: TW> and why? if the math was needed to make the point TW> without spending twice the amount of words, why did they TW> think the readers would understand that fact at least TW> even if they didn't completely follow the math? sorry i TW> guess i jus

Re: What happened to Howard Rogers ?

2003-10-23 Thread KENNETH JANUSZ
I am one of those 'used to work for oracle'. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 23, 2003 9:04 AM > howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably

RE: RE: Your new book

2003-10-23 Thread April Wells
Title: RE: RE: Your new book I took a discrete structures for computer science math class as an undergrad.  It was great, once I got past the Swedish accent of the instructor and figured out that "contraposite" was the contra opposite. Yes, a highly recommended class, even if you don't do wel

Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread MacGregor, Ian A.
Title: Message The exploit  involves passing a large argv[1] argument to  the oracle or oracle0 binary.   Credit for discovering the vulnerability goes to  [EMAIL PROTECTED].  The error was first discovered on a LINUX box but I have seen notes that AIX is vulnerable as well.  What is not pub

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread Wolfgang Breitling
On Windows servers you don't need Oracle to exploit buffer overflows and execute code on the operating system. Why try and find an unlocked window (no pun here) when the front door is wide open. At 07:44 AM 10/23/2003, you wrote: I find it more interesting that the problem doesn't apply to Windo

Re: stupid dbms_job question

2003-10-23 Thread Gene Sais
It's called cron :).  Or you could run a shell script that executes then sleeps for 5 mins. >>> [EMAIL PROTECTED] 10/23/03 10:09AM >>>im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows...variable jobno number;variable instno number;begin 

RE: Re[4]: Your new book

2003-10-23 Thread Thater, William
Jonathan Gennick scribbled on the wall in glitter crayon: > It was all our own inadequacy, having nothing to do with > readers. We weren't collectively prepared to handle the > level of math that Cary put in his book. Our tools weren't > up to the task. We couldn't take Cary's equations from Word

Re[2]: Your new book

2003-10-23 Thread Jonathan Gennick
Thursday, October 23, 2003, 2:54:26 AM, Niall wrote: NL> I wouldn't want anyone to think that I personally think that the math is NL> a mistake for the book, my concern is that it may hurt sales NL> unnecessarily. We'll never really know, because this is one of those cases where it's just not poss

RE: Shutdown takes 20+ minutes

2003-10-23 Thread Tortorelli, Mary Jo
Jeremiah and Jared,   Big thanks for your comments.  I was going down the path of trying to figure out the cause versus just solving the problem.  I understand from a co-worker there was a huge thread on shutdown abort before I got on this listserver.   Appreciate the info again! Now I just

Re[6]: Your new book

2003-10-23 Thread Jonathan Gennick
Thursday, October 23, 2003, 9:33:14 AM, you wrote: TW> ah... thank you for the explanation and the insight to TW> the publishing practice. It's an interesting business. Fun to be in at times, and frustrating at others. Cary's book counts as one of the fun times. He changed my thinking completely w

comparison HP-san vs netapp

2003-10-23 Thread Jeroen van Sluisdam
  Hi,   I need urgently a qualitative comparison between an SAN (based on eva3000) and netapp F825 environment concerning oracle. We have been tallking to suppliers now for weeks and suddenly a manager comes up with a netapps alternative and we have a deadline to decide already weeks

RE: Oracle pricing ain't going down

2003-10-23 Thread Karniotis, Stephen
And this surprises you??? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 22, 2003 5:24 PM To: Multiple r

RE: Mauve databases use least RAM

2003-10-23 Thread Goulet, Dick
Dennis, Personally I don't care if any Oracle employee ever answers a post on the list. The point is they are out there listening to the REAL world of Oracle use. That's a ton better than their competition, and I believe we've all benefited from that alone. As for when they do post a

Re: Re: stupid dbms_job question

2003-10-23 Thread rgaffuri
id prefer to handle this in the database. > > From: "Gene Sais" <[EMAIL PROTECTED]> > Date: 2003/10/23 Thu AM 10:29:33 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: stupid dbms_job question > > It's called cron :). Or you could run a shell script that execute

Re: questions regarding nologging

2003-10-23 Thread M Rafiq
Mladen, Thanks for your input. Yes, I also rebuilt all relevant indexes with nologging option so no normal redo genearation either. However, the table was moved into LMT tbs from a dictionery managed tbs. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAI

RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

2003-10-23 Thread Hemant K Chitale
Yes. However, every time he has replied to me, he has been confident that he IS right. Mind you, Richard, you are "immortalised" now ! Hemant At 05:04 PM 22-10-03 -0800, you wrote: So now the blame rests solely on Richard for any material in the note that's wrong. :) Check the latest update: http

RE: What happened to Howard Rogers ?

2003-10-23 Thread Dobson, Lisa
His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October 2003 15:04 To: Multiple recipients of list ORACLE-L howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We a

Re: stupid dbms_job question

2003-10-23 Thread Gudmundur Josepsson
I had an issue with dmbs_job where the jobs would become broken if I altered them. Have you checked if the job becomes broken after you change the interval? Gudmundur > im trying to submit a job that runs every 5 minuts. Only way I can get the > submit to work is as follows... > > variable job

Performance problem with Shareplex and Oracle

2003-10-23 Thread Luc . Demanche
Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED A

Re: Cache a table

2003-10-23 Thread Richard Foote
Hi It depends on how you define an LRU list I guess. When I close my eyes and picture the cache, I still see a LRU in there somewhere. Please note I don't often close my eyes in this manner ;) Also when you say that the CACHE option has no effect, that's also a little questionable. This is just a

How to trace 3rd party app

2003-10-23 Thread Rick_Cale
Hi DBAs, How can I trace a 3rd party app that produces a ora-3113 error? I am looking into dbms_support package but I am not sure what trace event and level it does. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City N

Oracle 8 support notice?

2003-10-23 Thread Loughmiller, Greg
Hey folks, there was a post late last week that had the details of the 8i Support extension. Would someone be so kind to forward that post to me "off post" please?   Specifically - looking for the metalink info that spells that out.   Thanks! Greg

Re: Performance problem with Shareplex and Oracle

2003-10-23 Thread Hemant K Chitale
With 2 CPUs, a Run-Queue of 1.27 isn't high. As SharePlex seems to be the only process taking CPU, it is taking 100% of 1 CPU. If it is one process only, then the CPU speed __could__ [and I'm not saying "IS"] the constraint. Adding CPUs wouldn't help. However, upgrading to a faster CPU would

RE: Re: stupid dbms_job question

2003-10-23 Thread Gints Plivna
Just a shot in the dark Have you set initialization parameters in the init file? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 23, 2003 6:14 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Re: stupid dbms_job question > > i

RE: What happened to Howard Rogers ?

2003-10-23 Thread Boivin, Patrice J
Not from here... temporarily unavailable. : ) Pat. -Original Message- Sent: Thursday, October 23, 2003 12:24 PM To: Multiple recipients of list ORACLE-L His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October

Re: stupid dbms_job question

2003-10-23 Thread Quintin, Richard
An interval of trunc(sysdate)+(trunc(to_char(sysdate,'s')/900)+1)*5/24/60 ought to give you every 5 minutes. Courtesy of Tom... On Thu, 2003-10-23 at 10:29, Gene Sais wrote: > It's called cron :). Or you could run a shell script that executes > then sleeps for 5 mins. > >>> [EMAIL PROTECTED

RE: Oracle 8 support notice?

2003-10-23 Thread Nigel Bishop
Title: Message Look at Doc IDs 250629.1 & 148054.1 - the extension is for some platforms only   Regards     Nigel BishopSnr. Oracle DBAiokoTel DDI:  +44 (0) 1904 435 458Mobile:   +44 (0) 7881 624 386Fax:  +44 (0) 1904 435 450Email:    [EMAIL PROTECTED]  www.ioko.com

RE: Oracle pricing ain't going down

2003-10-23 Thread Goulet, Dick
NO, not really, but I was hoping based on Uncle Larry's statements. Lets put it this way, IF we could get a site license from Oracle (As Uncle Larry defined it) for the same price per year, or less, as our current support contract the discussions about SQL*Server and PostGreSql would come to a

RE: Re: stupid dbms_job question

2003-10-23 Thread rgaffuri
what initialization parameters? job_queue_processes is fine. > > From: "Gints Plivna" <[EMAIL PROTECTED]> > Date: 2003/10/23 Thu AM 11:49:32 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Re: stupid dbms_job question > > Just a shot in the dark > Have you set

Re: What happened to Howard Rogers ?

2003-10-23 Thread Mladen Gogala
Thanks for this, Lisa. The "9i New Features" book on his site seems to be very good On 10/23/2003 11:24:25 AM, "Dobson, Lisa" wrote: His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October 2003 15:04 To: Multiple rec

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread DENNIS WILLIAMS
Ian - I haven't been able to locate this on Metalink, but can you give a quick idea about how I can ensure I don't have a vulnerability here? Our databases are behind firewalls and all access is through app servers. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Me

RE: RE: CBO, RBO and will v5 ever really go away?

2003-10-23 Thread Hemant K Chitale
You are able to run your SQL without schema-statistics, even if OPTIMIZER_MODE=CHOOSE ? Hemant At 10:54 AM 20-10-03 -0800, you wrote: Didn't I mention that? Bug 2954921... simple query blows away one of their internal views. Here's a snippet of the text from the TAR. select a.* from nt_admin_p

RE: Re: stupid dbms_job question

2003-10-23 Thread Jamadagni, Rajendra
Ryan, remove the trunc() from sysdate+1/96 trunc is removing your time part. or you should be using ROUND(SYSDATE+1/96,'MI') instead. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in thi

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread Matthew Zito
This vulnerability is only exploitable by local users. That is to say, if you have a local user (one that uses telnet or (ideally) ssh to log in) that has permissions to execute the oracle binary, you are vulnerable to this. It has nothing to do with whether or not your system is attached to the

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread Hemant K Chitale
Dennis, Note 251910.1 "Oracle Security Alert #59 Dated: 20 October 2003 Updated: 22 October 2003 Severity: 2 Buffer Overflow in Oracle Database Server Binaries Description A potential buffer overflow has been discovered in the "oracle" and "oracleO" (the letter O) binaries of the Oracle Databas

RE: Cache a table

2003-10-23 Thread Khedr, Waleed
Thanks for posting this. I agree LRU and MRU are just simple names for too many methods to achieve the required functionality. Waleed -Original Message- Sent: Thursday, October 23, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Hi It depends on how you define an LRU list I gue

RE: Boolean dates...

2003-10-23 Thread Bellow, Bambi
Oh, hell, I'll play. The word trivia comes from the Latin "tri" (three) and "via" (road). As I understand it, back in the day when those words were bantied around, and all roads led to Rome, trading centers and little towns popped up where two roads intersected, but where three roads intersected,

RE: comparison HP-san vs netapp

2003-10-23 Thread Goulet, Dick
Jeroen,       NetApp depends on TCP/IP to use their products.  Now that's NOT a bad thing, but you need to isolate the file traffic from your general network.  With a SAN your using normal disk io channels into the switch, which effectively isolates file activity from the network.  It's your

FW: Re: Your new book

2003-10-23 Thread Bellow, Bambi
Golly. That depends on how much you want to improve and what you already know. Apart from Calculus, I have found Discrete Math, and Finite Math. I didn't think much of my Prob & Stat class, but clearly it has its uses, too. I have not used a hair of Transformational Geometry since I took the cou

RE: stupid dbms_job question

2003-10-23 Thread Goulet, Dick
What is JOB_QUEUE_INTERVAL set to? If it's more than 5 minutes then what your seeing is what you get. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 10:09 AM To: Multiple recipients of list ORACLE-L im trying to submit a job th

RE: Re: stupid dbms_job question

2003-10-23 Thread Gints Plivna
JOB_QUEUE_INTERVAL I think But I found that it is obsolete in Release 9.0.1 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 23, 2003 7:15 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Re: stupid dbms_job question > > what i

RE: Re: stupid dbms_job question

2003-10-23 Thread Khedr, Waleed
Check if the job fails for some reason, any trace files for j??? in udump or bdump Also check job_queue_processes setting Waleed -Original Message- Sent: Thursday, October 23, 2003 11:14 AM To: Multiple recipients of list ORACLE-L id prefer to handle this in the database. > > From: "

RE: How to trace 3rd party app

2003-10-23 Thread DENNIS WILLIAMS
Rick - What is the configuration? Is the app on the same server or remote across SQL*Net? Metalink has a pretty good paper on the basics of debugging an ORA-3113. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multip

Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:

2003-10-23 Thread Jerome Roa
sold out na lahat-yung Tower 3 sa Eastwood is only for Lease?? At 11:34 AM 10/17/2003 -0800, you wrote: The article states that leaf blocks are not reused, which is indeed incorrect, and has been for a very long time. Hemant K Chitale <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/17/2003

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Nelson, Allan
How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our data

RE: Boolean dates...

2003-10-23 Thread Michael Milligan
So that's what you call trivia about trivia? :-) Actually, that is really interesting. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:55 A

RE: Your new book

2003-10-23 Thread Michael Milligan
Cary, Is Mike Tanner's book "Practical Queuing Analysis" good in your opinion? Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 22, 2003 11:54 PM To:

RE: Re: stupid dbms_job question

2003-10-23 Thread Cortese Joseph
I am so sorry, I replied to the wrong email. -Original Message- Sent: Thursday, October 23, 2003 12:46 PM To: '[EMAIL PROTECTED]' Are you heading out to lunch -Original Message- Sent: Thursday, October 23, 2003 11:14 AM To: Multiple recipients of list ORACLE-L id prefer to ha

RE: Mauve databases use least RAM

2003-10-23 Thread Thater, William
Goulet, Dick scribbled on the wall in glitter crayon: > use at your own risk. Now is there any way we can get Uncle Larry to > subscribe/listen??? *-) well, if we could get him to subscribe and *listen*, that's OK... my fear is that he'd subscribe and *talk*.;-) -- Bill "Shrek" Thater

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Luc . Demanche
Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (

RE: How to trace 3rd party app

2003-10-23 Thread Rick_Cale
Dennis, The dot net app is on a remote server. I will search MetaLink. Thanks Rick DENNIS WILLIAMS

RE: Re: stupid dbms_job question

2003-10-23 Thread Cortese Joseph
Are you heading out to lunch -Original Message- Sent: Thursday, October 23, 2003 11:14 AM To: Multiple recipients of list ORACLE-L id prefer to handle this in the database. > > From: "Gene Sais" <[EMAIL PROTECTED]> > Date: 2003/10/23 Thu AM 10:29:33 EDT > To: Multiple recipients of li

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Luc . Demanche
Dan, The process taking 50% is an Oracle process and it is connected on Shareplex Oracle user. I have two different error messages: 1- "System call error: sp_cop(dsm) Temporary error (h_errno = 2) gethostbyname (can't add entry for ora4) I got this error every 10 minutes, but I didn't find someth

Re: How to trace 3rd party app

2003-10-23 Thread Mladen Gogala
Are you talking about .NET? Well, no wonder that you have problems. I'm sure that BSOD will not have any problems working .NET. On 10/23/2003 02:19:24 PM, [EMAIL PROTECTED] wrote: Dennis, The dot net app is on a remote server. I will search MetaLink. Thanks Rick DEN

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Nelson, Allan
Shareplex is fast here. We replicate a 6 CPU db to a 4 CPU machine without excessive loads or problems. We run an average of 29 messages with about 1 GB in the queues. Our data is 0 minutes old. Outside of contacting Quest support I'm sure of how much help I can be. When I have seen SP claim as

Re: Performance problem with Shareplex and Oracle

2003-10-23 Thread Mladen Gogala
Who's using other 50%? Is SP active or is waiting? On 10/23/2003 02:19:32 PM, [EMAIL PROTECTED] wrote: Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bot

how to specify tablespace in Designer

2003-10-23 Thread Ben
Hi Can someone who has used Designer to generate DDL let me know how you specify which tablespace a table or index is to be created in. I am using the Design Editor and the DBAdmin tab and can't seem to find it. Thanks in advance. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.n

Solved... Was: Boolean dates...

2003-10-23 Thread Jose Luis Delgado
List... I finally found the answer about the infamous 'boolean dates'! (this was the term that my boss used when he told me about the dates... boolean dates). After receiving a lot of mails talking about Julian dates... I started to test in that way. I could find the following which is the solut

Re: Re: What happened to Howard Rogers ?

2003-10-23 Thread rgaffuri
there was alot more on howards site. oracle made him take it down and the person who put up taht site didnt copy everything. he has a new site. www.dizwell.com not much yet, but its worth bookmarking. > > From: Mladen Gogala <[EMAIL PROTECTED]> > Date: 2003/10/23 Thu PM 12:09:34 EDT > To: Mu

RE: comparison HP-san vs netapp

2003-10-23 Thread Matthew Zito
Title: Message   Depending on the number of hosts on your theoretical SAN, Netapp will make management much much easier.  And like Dick says, have at least two gigabit cards in your hosts that are dedicated for your NFS throughput and dual attachments in the 825 and set up VIF on the filer. 

RE: how to specify tablespace in Designer

2003-10-23 Thread Mercadante, Thomas F
Ben, You need to implement the table to assign storage attributes to it. This can be done either in the Ron or Db Designer where you are at. In Db Designer/DbAdmin tab, expand the database|Users|spcific User|Schema|Table Implementations entry. Click the green plus to implement a table in this a

RE: Re: stupid dbms_job question

2003-10-23 Thread Goulet, Dick
Well, you didn't say what version of the database we were talking about. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L JOB_QUEUE_INTERVAL I think But I found that it is obsolete

index full scan over an index fast full scan in an analytic function?

2003-10-23 Thread rgaffuri
I have an index on the two columns used in this query. Why would the optimizer choose an index full scan over an index fast full scan? My question isnt why an index is used, but the type of index scan? select * from (select col1, col2, dense_rank() over (partition by co

RE: Mauve databases use least RAM

2003-10-23 Thread Goulet, Dick
OH DEAR, now that would require the list to up the bandwidth. Good point!! *-) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Goulet, Dick scribbled on the wall in glitter crayo

stop compile

2003-10-23 Thread AK
is there any way trigger I can write so that no body can compile object (package/procedure) and alter table during business hours  in 8.1.7.4 db.     -ak

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Goulet, Dick
Now we don't use Shareplex, but I do know of others who do & this is not the first time I hear of performance problems, but I may be able to shed some light on the problem. Since Shareplex reads the redo logs, if one statement on the source database affects more than one row (lets say 10 for ar

Re: index full scan over an index fast full scan in an analytic function?

2003-10-23 Thread rgaffuri
i cant attach the 10053 trace. it has proprietary info. There isnt much in analytic explain plan either. does anyone know in general why a full scan would be faster than a fast full scan? > > From: <[EMAIL PROTECTED]> > Date: 2003/10/23 Thu PM 03:09:26 EDT > To: Multiple recipients of list ORA

Re: Cache a table

2003-10-23 Thread Jared . Still
Craig Shalahamer still refers to the cache as LRU/MRU.  What has changed are the algorithms that determine the lifespan and placement of a buffer in the cache. www.orapub.com Jared   Richard Foote <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  10/23/2003 08:34 AM  Please respond to ORACL

RE: Re: What happened to Howard Rogers ?

2003-10-23 Thread Michael Milligan
He had great stuff on his site. Why did Oracle make him take it down? His stuff his very readable and informative IMHO. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reade

Re: stop compile

2003-10-23 Thread Mladen Gogala
Your problem is not an oracle problem. It's an organization problem. To say the least, nobody but DBA should be able to perform a DDL on the production database. All three of you should take care of that. On 10/23/2003 03:04:40 PM, AK wrote: is there any way trigger I can write so that no body can

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Nelson, Allan
Your DNS is toasty. Gethostbyname is a UNIX system call that takes your ip address and turns it into a name. This could be a big part of your delay. Networked apps do not take kindly to being unable to both forward and reverse lookups. H_errno = 2 is not found. Allan -Original Message

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Nelson, Allan
Since the results of triggers firing in the source will appear in the log files, then in general you do not want the same triggers firing in the target. Similarly since data integrity is usually enforced in the source db you can typically disable it in the target. I suppose something on this orde

RE: Performance problem with Shareplex and Oracle

2003-10-23 Thread Luc . Demanche
I probably found my problem. My replicated tables have a lot of indexs. I removed all of them, and step by step I will add indexs who will help my replication. Tx Luc -Original Message- Sent: October 23, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Since the results of trigge

** temp tablespace

2003-10-23 Thread A Joshi
Hi,   I have a huge  temp tablespace (4GB) and not much usage (current usage is 50MB  from v$ tables) . However it keeps running out of space. It ran out of space yesterday and I was hoping it would release but it got an error again. The database is only 35GB mostly small tables. IT is temporary

dba interview questions

2003-10-23 Thread system manager
Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official OR

Re: stop compile

2003-10-23 Thread Reginald . W . Bailey
You might try using Fine Grained Access or a database level trigger that fires upon altering of a table. Also look into auditing the objects. To prevent a stored program from being compiled during business hours you can simply remove all object privileges from the the object so that no one will b

Re: comparison HP-san vs netapp

2003-10-23 Thread Binley Lim
Title: Message What is a "VIF on the filer"? - Original Message - From: Matthew Zito To: Multiple recipients of list ORACLE-L Sent: Friday, October 24, 2003 7:59 AM Subject: RE: comparison HP-san vs netapp   Depending on the number of hosts on your the

Re: dba interview questions

2003-10-23 Thread Jonathan Gennick
Thursday, October 23, 2003, 4:14:34 PM, you wrote: sm> Dear List,Can anyone send me a list of dba interview questions? Forget the questions. Somebody send me the answers! :) Heh. Maybe you could do the interview in Jeopardy format, where you state the answer, and force the candidate to back i

Oracle Spatial...

2003-10-23 Thread Bellow, Bambi
Anybody know of any good docs that can help me get into the bowels of Oracle Spatial without getting dirty? TIA! Bambi. -- 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.fatci

RE: Boolean dates...

2003-10-23 Thread Bob Lofstrand
Title: RE: Boolean dates... So would that make it meta-trivia? -Original Message- From: Michael Milligan [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 23, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Boolean dates... So that's what you call trivia about

RE: Oracle Spatial...

2003-10-23 Thread Guerra, Abraham J
The Oracle manuals are the best documentation by far. Abraham Guerra -Original Message- Sent: Thursday, October 23, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Anybody know of any good docs that can help me get into the bowels of Oracle Spatial without getting dirty? TIA! Bam

RE: Re: What happened to Howard Rogers ?

2003-10-23 Thread tim
Because they said so. Signed, -Another former Oracle employee threatened by Oracle Legal about info posted to the internet > He had great stuff on his site. Why did Oracle make him > take it down? His stuff his very readable and informative > IMHO. > > > This e-mail, including attachments,

RE: Your new book

2003-10-23 Thread Cary Millsap
That's one book that I don't have. A good friend of mine says it's very good, especially as an introduction. I browsed it in a bookstore once, and if my memory serves me correctly, the only reason I didn't buy it is that I felt like Gross & Harris (which I already owned) covered everything I would

  1   2   >