RE: Urgent INFO needed. - OFF TOPIC

2003-09-04 Thread VIVEK_SHARMA
$2.50 is simply because of the $ to Rupee PARITY RATIO & respective Cost of Living here in India. Labor in India is NOT Cheap . It is Simply this ratio which gives the impression of being cheap. Also Outsourcers get to pay LESS because of the Current prevailing Work-to-Earnings monetary scen

Re: Urgent INFO needed.

2003-09-04 Thread Maria Aurora de la Vega
Yes, in your experience...and maybe most of the other lister's experience...majority of the time its true... That's because you people are the best DBAs I've seen... Your experiences...10...15 years...some of you have a little over 3 years and are already experts... Of course a lot of other people

Re:RMAN backup and recovery scenarios

2003-09-04 Thread Prem Khanna J
Thanx Govind. as Robert said, it has a dedicated chapter for that. ...and i'm trying all the scenarios one by one with his book beside. but just thought, i could some more inputs from the LIST. I will continue with the book now. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www

Re: RE: RMAN backup and recovery scenarios

2003-09-04 Thread Prem Khanna J
Thanx Dennis,Robert,and Ruth. I'm going thro' Roberts's book now. as Robert said, it has a dedicated chapter for that. ...and i'm trying all the scenarios one by one . but just thought, i could some more inputs from you Gurus. thanx a lot guys. I will continue with the book. Regards, Jp. --

Re: 600-[25012] on delete of IOT table

2003-09-04 Thread GovindanK
Take a look at the Metalink Note:125149.1 ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index As per the note it affects 8.1.(5/6/7).x It has the relevant info. Also take a look at the Docid: 287936.999. HTH GovindanK > Sun solaris 8/oracle 8.1.7.2 64bit. > > After some dat

Re: latch free wait event

2003-09-04 Thread GovindanK
When you get wait seconds > 0 use TKPROF and look for statements taking time. HTH GovindanK > > "Ehresmann, David" wrote: > >> System-wide Wait Analysis >> for current wait events >> >>

RE: RMAN backup and recovery scenarios

2003-09-04 Thread GovindanK
Besides you may refer to Backup & Recovery by Rama Velpuri (8/8i). A bit old but nevertheless good. All said and done, create a clone database and keep crashing it in all ways you can think of, and try to recover it. That should give you the confidence , letting you know how oracle handles the inte

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Jared Still
Or Perl... On Thu, 2003-09-04 at 14:54, Richard Ji wrote: > >so my question is, are there things you can do with external procedures that you > >cant do with java? > > Yes there are, for instance, Java doesn't support raw socket, so if you ever need > that > you will have to do it in C with ex

Re: latch free wait event

2003-09-04 Thread Wolfgang Breitling
The number of waits is irrelevant. What matters is the time waited which in your case shows 0, but I assume that is because you have not set timed_statistics to true. Without that the data from v$system_event are worthless. Cary will probably step in here and tell you that even with timed_stati

Re: latch free wait event

2003-09-04 Thread Daniel Fink
David, Do you have timed_statistics set to true? If not, you need to do so. Although I am pretty certain that this is the case, but let's assume that you truly waited 0 seconds. If you were able to remove ALL of the latch free events, you would improve the response time in the system by 0 seconds.

latch free wait event

2003-09-04 Thread Ehresmann, David
System-wide Wait Analysis for current wait events Average Event Total SecondsTotal Wait Name

RE: RE: URGENT : sql*loader performance problem on partionned tab

2003-09-04 Thread cornichepark
Did you explain plan? I suspect FTS taking place in case of NOT EXISTS. It must be using Range scan for the non partitioned table. Can you confirm / post the explain plan. GovindanK > Here the informations : > table HREL_FUSION : > 63 millions rows > 3 indexes on columns : nodos_or,

600-[25012] on delete of IOT table

2003-09-04 Thread chao_ping
Sun solaris 8/oracle 8.1.7.2 64bit. After some database defrag(via alter table xxx move and alter index xxx rebuild), I got 600-25012 from my delete session and alert file. SQL> DELETE FROM EOI_PDTLIST WHERE ROWNUM=1; DELETE FROM EOI_PDTLIST WHERE ROWNUM=1 * ERROR at line 1: ORA-

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Richard Ji
>so my question is, are there things you can do with external procedures that you cant >do with java? Yes there are, for instance, Java doesn't support raw socket, so if you ever need that you will have to do it in C with external procedure. But what's the chance of anyone is going to use such

RE: RE: Oracle Masters exam

2003-09-04 Thread Freeman Robert - IL
The Exam Cram books are harder and harder to find, but used ones are still available. However, I believe that Pete is going to co-author my upcomming Mastering Oracle10g book from Sybex So, if you liked his style, stay tuned. RF -Original Message- To: Multiple recipients of list ORACL

RE: Oracle on Win2000

2003-09-04 Thread Murali_Pavuloori/Claritas
sure...will be glad to learn somethings from your experiences Murali. "Niall Litchfield"

Oracle 9.2.0.3 Compressed Tables

2003-09-04 Thread John . Larocque
Two questions to anyone that has worked with compressed tables. 1. Have any work arounds been discovered to alter tables and say add columns after a partition has been compressed and then uncompressed? 2. In looking at a block dump of a compressed 9.2 block you can see the following pieces of i

RE: RE: Oracle Masters exam

2003-09-04 Thread Mladen Gogala
I don't believe that you can be an owner of a consultant. This practice was stopped, I believe, in 1865, in the Appomatox courthouse. Virgil Caine is my name and I drove on the Danville train 'til so much cavalry came and tore up the tracks again In the winter of '65, we were hungry, just

RE: Oracle on Win2000

2003-09-04 Thread Nelson, Allan
Title: Message Yes, very much.   Allan -Original Message-From: Niall Litchfield [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 3:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle on Win2000 If a list of "stupid things I have done or found

Off Topic - Norton Internet Security 2003 Software

2003-09-04 Thread KENNETH JANUSZ
PC:  Dell 8200 OS: XP Prof. SP1   I have had this PC with Norton 2002 virus software on it since I bought it over a year ago.  I recently decided to upgrade to Internet Security 2003 Prof. Ed.  Installation has been a mess.  Has anyone attempted to install this on XP Prof.?  If so have you h

Can't query through a synonym, the solution

2003-09-04 Thread Nelson, Allan
Title: Can't query through a synonym, the solution Hi List Well, we figured it out.  Here was the sequence of events T1 - init ora parameter dblink_encrypt_login set to true in the target database T2 - synonym created T3 - init ora parameter dblink_encrypt_login set to false in the targ

RE: Oracle not available???

2003-09-04 Thread Odland, Brad
YOur network guys may have turned off access to ports 1521 or 1575 if you are using onames to stop the spread of the worm. I used to DBA 30 some instances on several windows boxes. Both NT and 2k. Pretty much made a point of rebooting at least once a week. Did cold backups so database was down a

Oracle's Masters program....

2003-09-04 Thread Chris Stephens
Here's a little more info. This is from a lady I work with "Hey I found out a little bit of info on the masters certification. My dad is the author/architect of the test. He did not assign the scoring it sounded like it was an outside organization that came up with the scoring. Anyway he

RE: Future demand for DBAs

2003-09-04 Thread Niall Litchfield
Jesse wrote > Put down the Bud Light and drink a REAL beer like Three > Floyds Alpha King, Sierra Nevada Pale Ale, Guinness, or Goose > Island Honkers Ale. > > There's gotta be an "Oracle" hook here somehere...Drink REAL > beer at OracleWorld! Real Ale Clusters... Flashback Query - you know t

RE: test

2003-09-04 Thread Thater, William
Title: RE: test   -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, September 04, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: test No Bill, it's a POP "test" That's even worse. [Shrek]  is that

RE: Oracle on Win2000

2003-09-04 Thread Niall Litchfield
Title: Message don't always=doesn't ever - you need a tns connection.   Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Ron L.Sent: 03 September 2003 22:39To: Multiple recipients of list ORACLE-LSubject: RE: Oracle on Win2

RE: Oracle on Win2000

2003-09-04 Thread Niall Litchfield
Title: Message If a list of "stupid things I have done or found with Oracle on windows" were to be written would folk be interested   Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bala RegupathySent: 03 September 2003 18:44To: Multip

RE: Re: "Application DBA"

2003-09-04 Thread Niall Litchfield
Noons writes > For an "application DBA"? Exactly which part of the degree > or OCP prepares or qualifies one for such a job > specification? Matter of fact, where is "application DBA" > defined in Oracle education or any other IT education > organization? Which courses from Oracle prepare on

RE: RE: Oracle Masters exam

2003-09-04 Thread Boivin, Patrice J
The last National Geographic talks about slavery, it's running rampant. Jared this is getting into OT !!! Patrice. -Original Message- Sent: Thursday, September 04, 2003 5:00 PM To: Multiple recipients of list ORACLE-L I don't believe that you can be an owner of a consultant. This pract

RE: RE: Oracle Masters exam

2003-09-04 Thread Pete Sharman
Still out there on Amazon, even though I don't get any royalties from it any more (since the publisher went under). It's also available for online purchase chapter by chapter (I think) on http://www.robonerd.com Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handboo

Re: How to find the session holding the library cache pin.

2003-09-04 Thread bulbultyagi
run catblock.sql to create dba_blockers and dba_waiters @?\rdbms\admin\catblock.sql - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 01:54 > dba_blockers > > this doesnt install by default. i cant remember which script runs

Re: How can I measure my DB performance.

2003-09-04 Thread bulbultyagi
I too have mine setup to take a snapshot every 15 minutes. Can you teach me how to automate purges using sppurge.sql ? Thanks . - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 29, 2003 06:04 > Start by installing and config

RE: Oracle Masters exam

2003-09-04 Thread Mladen Gogala
You're becoming a lawyer too? C'ya in court. -- Mladen Gogala Oracle DBA -Original Message- Rachel Carmichael Sent: Thursday, September 04, 2003 3:04 PM To: Multiple recipients of list ORACLE-L You keep putting me into a class in which I do not belong -- but I thank you. I have OCP

RE: Oracle survey

2003-09-04 Thread Karniotis, Stephen
Everyone: In looking at this survey, this can be used for multiple purposes. One is to pulse the market, however question one can be used for license violations. Be careful how you answer. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 M

Re: rename data file on standby database

2003-09-04 Thread Kader Ben
Many thanks Louis for your input, Have nice day, Kader --- Jose Luis Delgado <[EMAIL PROTECTED]> wrote: > Hi Kader... > > you do not need to do the same on the standby > database... > > That logical changes are reflected automatically... > The only thing is that your physical datafile remain

RE: RMAN backup and recovery scenarios

2003-09-04 Thread Freeman Robert - IL
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.r

RMOUG Training Days Call for Papers

2003-09-04 Thread Daniel Fink
The Rocky Mountain Oracle User Group needs YOU! We are looking for a few (well, more than a few) good speakers for our annual Training Days conference to be held in Denver, Colorado on February 11 & 12, 2004. This is your chance to share your knowledge and experience with fellow Oracle professional

RE: Offshore threat

2003-09-04 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: > Well, being 6'4", 270 LBS, capable of running 5 miles and doing 20 > pull ups, I wonder why do people get upset if I become truculent or > belligerent. BTW, your nickname is "Shrek". Mine is "Yogi". Both > nicknames suggest certain size > a

Re: RE: Oracle Masters exam

2003-09-04 Thread rgaffuri
well tom kyte isnt certified and refuses to discuss it on his website. OCP is important for most people. Employers want it. Im not sure masters certification means much unless you are a principal consultant or owner of a consultant. You then use that certification to sell your company. Its the

RE: Urgent INFO needed.

2003-09-04 Thread Brian Dunbar
Joe, It's all about dollars and cents, true. In your view, can a company look past the next quarter and see that by outsourcing they might be jumping over dollars to save pennies? Example, most of the companies in my region aren't Fortune 500, they're small manufacturing outfits - it's rare to s

RE: Offshore threat

2003-09-04 Thread Mladen Gogala
Well, being 6'4", 270 LBS, capable of running 5 miles and doing 20 pull ups, I wonder why do people get upset if I become truculent or belligerent. BTW, your nickname is "Shrek". Mine is "Yogi". Both nicknames suggest certain size and physical build. Am I right? -- Mladen Gogala Oracle DBA --

RE: Offshore threat

2003-09-04 Thread Stephane Paquette
When working at International Air Transport Association (IATA), the company moved around 60 jobs from Geneva and London to Montreal because it was cheaper here. This is all business as usual. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardl

Re: Oracle Masters exam

2003-09-04 Thread Rachel Carmichael
You keep putting me into a class in which I do not belong -- but I thank you. I have OCP through 8i, but only because I made it a point of honor to see if I could pass the exams without ever studying for them, and, in the case of the 8 and 8i certification, without ever having seen a database runn

RE: Offshore threat

2003-09-04 Thread Mercadante, Thomas F
This is all very funny and interesting. Anybody read the story in yesterday's NY times? Mexica has a concern that their textile industry is being "stolen" by China because it is cheaper to make products there than in Mexico. Sound familiar? "This is the business we have chosen to be into" Himen

RE: Oracle Masters exam

2003-09-04 Thread Chris Stephens
I was just looking into this. If I understand it correctly, you have to take 2 'advanced' classes =>$2000-$5000 total (depending on which courses) and then you have to pay $2000 just to take the practicum. This might be the real deal and an exciting achievement to work towards but I for one know

RE: Offshore threat

2003-09-04 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: > non-aggressive gentleman from India. Lawyers do need a killer > instinct, DBAs do > not. For those of us who have it, it's more of a hindrance then a > useful tool. you, sir, have obviously not been a DBA in some of the companies i've work

Re: RE: Oracle Masters exam

2003-09-04 Thread rgaffuri
if your on a 1099 the classes should be a business expense. dont know about the certification. so you could write off the classes. will only save people 25-28% though... > > From: April Wells <[EMAIL PROTECTED]> > Date: 2003/09/04 Thu PM 12:24:35 EDT > To: Multiple recipients of list ORACLE-L <

RE: Oracle Masters exam

2003-09-04 Thread April Wells
Title: RE: Oracle Masters exam see... that's when I got my OCP... when the company decided that I needed to have it, and that they would pay for it.  All it proves to me is that I can pass multiple choice tests... and I can read a book.   April Wells Oracle DBA/Oracle Apps DBA Corporate System

RE: test

2003-09-04 Thread Stefick Ronald S Contr ESC/HRIDD
Title: RE: test No Bill, it's a POP "test" That's even worse. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 04, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: test Babette Turner-Underwood  scribbled on the

RE: Oracle Masters exam

2003-09-04 Thread Pete Sharman
Well, I've had the luxury of not only not paying for any of the certification, but actually being paid to DO the certification: 7.3 - original certification as an Oracle instructor paid for by Oracle 8.0 - paid for by the now defunct Coriolis Group so I could review their exam crams for them 8.1 -

RE: Offshore threat

2003-09-04 Thread Goulet, Dick
Globalization is one of those damned buzzwords that certain politicians and CEO's like to use to mean that everything will be equal between countries. In reality there is no such truth as we've seen twice in the past few years. Now maybe if we had a global monetary system, like the EURO, thing

RE: Re: "Application DBA"

2003-09-04 Thread Thater, William
Mercadante, Thomas F scribbled on the wall in glitter crayon: > Bill, > > Did you point out to them how *freekin wrong* they had been?!?!?!?! > I would not have been able to resist the free shot. ya never know when i'll need to find another contract, so i was very diplomatic. but damn it was

RE: Problem querying remote table through a synonym

2003-09-04 Thread Nelson, Allan
8.1.7.4 Allan -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 12:55 PM To: Multiple recipients of list ORACLE-L What version of Oracle are you running? Murali. "Nelson, Allan"

RE: Offshore threat

2003-09-04 Thread Mladen Gogala
It doesn't work in only one direction. While jobs are bieng lost to cheaper labor markets, Indian companies now have to compete with frighteningly efficient giants like Nike, Coca Cola, IBM, Microsoft, GM, Union Carbide and others. Local companies are losing the market and have to reduce their w

RE: RMAN backup and recovery scenarios

2003-09-04 Thread Ruth Gramolini
Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Prem Khanna J > Sent: Thursda

Re: Oracle Masters exam

2003-09-04 Thread Rodd Holman
In addition, some non-tech HR wag does their screening of applicants based on OCP, Oracle Master's, or some such certification. Yes, certification is an issue whether or not it has technical merit. When it comes at a price that many of us can't personnaly afford, it's a very BIG issue. I don'

RE: test

2003-09-04 Thread Thater, William
Babette Turner-Underwood scribbled on the wall in glitter crayon: > test oh damn, i hate pop quizzes.;-) -- Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] It's no coinciden

RE: Oracle on Win2000

2003-09-04 Thread Thater, William
  -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 4:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle on Win2000 Hammer, screwdriver and duct tape.   ;o)[Shrek]  C4 is much more fun.;-)   --

Re: Problem querying remote table through a synonym

2003-09-04 Thread Murali_Pavuloori/Claritas
What version of Oracle are you running? Murali. "Nelson,

RE: Oracle Masters exam

2003-09-04 Thread Thater, William
Title: RE: Oracle Masters exam   -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Thursday, September 04, 2003 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Masters exam I though about trying to figure out how to get it to be a wri

Be careful applying patchset 9204

2003-09-04 Thread zhu chao
I plan to apply patchset 9204 for my 9203 rac and found a lot of problems in metalink, so be careful applying that PATCHSET.So I stop. here is the list: 1.OUI bug. Must install OUI 2.2.0.18 before patch the database. 2.OUI bug. OUI do not install OUI to other nodes in a RAC system. You must instal

RE: Oracle Standby Database Backups.

2003-09-04 Thread Jose Luis Delgado
Tom I was wondering about the last log file on your primary database that still hasn't been sent to your standby database until a switch log occurs... (thinking about sustained mode too) Have you taken that into account?? JL --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Arup, >

RE: EXECUTE IMMEDIATE and PL/SQL variables???

2003-09-04 Thread Chelur, Jayadas {PBSG}
This can be done using a Package Variable. Here are the steps :- (1) Package Specification = CREATE OR REPLACE PACKAGE DSQL AS n_TestValue NUMBER; FUNCTIONGetValue RETURN NUMBER; END; (2) Package Body CREATE OR REPLACE PACKAGE BODY DS

Problem querying remote table through a synonym

2003-09-04 Thread Nelson, Allan
Title: Problem querying remote table through a synonym I'm confused, has anyone ever seen something like this before? This query works as you can see: select count(*) from [EMAIL PROTECTED];   COUNT(*) --     275375 We execute the following DDL: DROP SYNONYM MV_USER_ENABL

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Mladen Gogala
Anything stored is always easier to configure then anything external. It shouldn't be easier to use, though. And you should judge where dies it make sense. For reading a simple file 10 times a day (document scanning application at my previous company), a properly written C program (using fork,

Re: Offshore threat

2003-09-04 Thread Nuno Souto
LOL! Funny how this "globalisation" bull only works in one direction, eh? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > ** Another programmer who lost his job to an Indian > outsourcer is willing to relocate in India. But Indian > officials have told him they don't hire Ame

Wel it appears the 10g world is coming soon

2003-09-04 Thread Joe Testa
During my free time(ha, between developing pages for kid's soccer association, redcross instructor and board member, family, work), are you all interested in my discoveries when i start trudging thru the 10G world? if so i'll pick up the "new features for 10g" series when i can get my hands on

Re: Urgent INFO needed.

2003-09-04 Thread Joe Testa
Fact of the matter is the majority of the time its true, like it or not. Those of you who know me, know I DON'T do politically correct, I call a spade a spade. Its true at the officer level in a company(and I'm there in the company I'm in now), its all about dollars and cents, especially toda

RE: Oracle Standby Database Backups.

2003-09-04 Thread Jose Luis Delgado
Tom it's me again... I have a (I consider) really good document about stand by databases... (old, maybe, but still applies to 8i standby databases)... if you are interested... I can send you a copy... it focuses about the 'details' with theses databases... HTH JL --- "Mercadante, Thomas F"

RE: RMAN backup and recovery scenarios

2003-09-04 Thread DENNIS WILLIAMS
Prem - I haven't found anything significant online. Perhaps someone else (Bwill point to a resource. If you want to learn RMAN, my recommendation is to (Bget a couple of books. The advantage of a book is you end up with a (Bcomprehensive resource for reference. Myself, I need to go back and refr

RE: Oracle Masters exam

2003-09-04 Thread Mladen Gogala
My complaint is not based on moral grounds. My complaint is that Oracle's greed is interfering with my own. There is drastic difference in the behavior of Oracle Corp. from the times before Oracle 8.0 and after. Support has worsened, the quality of the code is falling, bugs are more and more numer

Re: alter system reset

2003-09-04 Thread bulbultyagi
Mladen , you seem to be correct, I checked the spfile and the parameters I try to modify exist there, but reseting them takes one extra step Say for example I find that undo_suppress_errors=false in the spfile. Now if I try SQL> alter system reset undo_suppress_errors scope=spfile sid='lahiri' ; a

RE: Oracle Masters exam

2003-09-04 Thread Freeman Robert - IL
With respect to all of you out there... I hear so many complaints about greedy Oracle, and about having to take a class to get certified and the dollar cost of that. I remind you folks that Oracle is a for profit venture. It's not Oracle's responsibility to make anything affordable. It's the respon

Re: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-04 Thread Rachel Carmichael
Shows how in the loop I am since I left the steering committee :) my apologies, it is, as Indy pointed out, September 23 --- Indy Johal <[EMAIL PROTECTED]> wrote: > Rachel > > Is it September 18 or 23. > > > Indy Johal > Manager, Database Administration > PR Newswire > [EMAIL PROTECTED] > h

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Stephane Paquette
We have tested a product this winter that was using an external C proc to call cobol programs. Stephane -Original Message- Jared Still Sent: Thursday, September 04, 2003 11:34 AM To: Multiple recipients of list ORACLE-L One thing you can do is bypass all of your security if you aren't

RE: Oracle Masters exam

2003-09-04 Thread Boivin, Patrice J
>From what I heard at an 8i Internals seminar, the OCM exams are nothing like the OCP exams. They really put people on the spot. Patrice. -Original Message- Sent: Thursday, September 04, 2003 12:20 PM To: Multiple recipients of list ORACLE-L So, it's nothing like OCP where you get the

Re: Re: "Application DBA"

2003-09-04 Thread Nuno Souto
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > more and more employers are requiring OCPs and 'related degrees' such as computer > science or a masters degree. > At least in the US they are. How are things in other parts of the world? For an "app

RE: Oracle Masters exam

2003-09-04 Thread April Wells
Title: RE: Oracle Masters exam I though about trying to figure out how to get it to be a write off... I'm not sure how taking an advanced class will help me to pass the test... I kind of would like to take it just to see if I can... but I really don't want to be doing it just to drum up Ora

RE: Oracle Masters exam

2003-09-04 Thread Mladen Gogala
Mike, it's always about the money. Unfortunately, I notice that Oracle Corp. is getting greedier and greedier. Bugs are more and more numerous and versions are released at such rapid pace that it is extremely hard an expensive to keep up the pace. Of course, Oracle would like to get some addition

Re: more questions -- "multiplexing of datafiles"

2003-09-04 Thread Hemant K Chitale
See the ASM feature of Oracle 10g. http://otn.oracle.com/oramag/oracle/03-sep/o5310gcover_storage.html Oracle handles virtualisation and redistribution of datafiles and also provides mirroring of datafiles. Hemant At 07:59 AM 04-09-03 -0800, you wrote: As an interesting side note, Oracle on MV

Re: more questions

2003-09-04 Thread Tim Gorman
As an interesting side note, Oracle on MVS/OS390 offers multiplexing of datafiles, since at least Oracle v6, I believe. It's just something that never made the jump to other ports, I guess... on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote: > how to startup oracle after machine > is

Re: Urgent INFO needed.

2003-09-04 Thread Quamrul Polash
I could not say it in a better way /Quamrul From: Maria Aurora de la Vega <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Urgent INFO needed. Date: Wed, 03 Sep 2003 21:19:41 -0800 Its quite unfair for DBAs to blame

Re: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-04 Thread Indy Johal
Rachel Is it September 18 or 23. Indy Johal Manager, Database Administration PR Newswire [EMAIL PROTECTED] http://www.prnewswire.com (201) 946-5687 [W] (201) 400-3960 [M] "We tell your story to the world." Rachel Carmichael <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/04/03 11:24

RE: Oracle Masters exam

2003-09-04 Thread Hately, Mike (LogicaCMG)
The masters seems a far better test of ability than OCP. Unfortunately Oracle have attached the spurious "must attend 2 Oracle classes" clause which makes it obvious that the whole program is just another revenue channel. I've considered signing up for it but I baulk at the idea of handing over m

Re: oracle 10i

2003-09-04 Thread Indy Johal
Bahar This is not Oracle 10i but 10G. It is new Oracle Release which is going to be release during the Oracle Openworld Next Week.  So be ready  for adventure thru bug again and have fun ()  in reading the Manual again. I came to know some very good features but it is still not finalized [ I

Re: rename data file on standby database

2003-09-04 Thread Jose Luis Delgado
Hi Kader... you do not need to do the same on the standby database... That logical changes are reflected automatically... The only thing is that your physical datafile remain as initially, but your controlfile has the changes. Was I clear? note that the only changes that you need to do at your

Re: RE: Oracle Masters exam

2003-09-04 Thread rgaffuri
i saw some posts on the usenets that oracle has been cancelling masters exams and not refunding the money. saw a couple of posts on that. > > From: "Mladen Gogala" <[EMAIL PROTECTED]> > Date: 2003/09/04 Thu AM 11:19:30 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subjec

RE: Oracle Standby Database Backups.

2003-09-04 Thread Mercadante, Thomas F
Jose, I've taken nothing into account. I'm still asking theoretical questions, trying to prepare for a discussion I will be having this afternoon. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, September 04, 2003 11:29 AM To: Multiple recipients of list

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread DENNIS WILLIAMS
Ryan I'm no expert either. What I heard is that the advantage of external procedures were good where you have something that needs the performance of the underlying system. The C code runs directly on the server, whereas Java is on top of Oracle, which is system-independent. Dennis Williams DBA

Re: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-04 Thread Rachel Carmichael
September 18, NYC, (that meets the 212 area code, by the way, you could have included 516 too!) www.nyoug.org for details --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > Why don't listers meet on the east coast, somewhere in the area codes > 203,718 or 212? I don't pay roaming charges in those ph

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Goulet, Dick
Depends on your developers. We have few JAVA developers, but quite a few C programmers. Plus I've got this great book of math routines in C. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, September 04, 2003 10:49 AM To: Multiple recipients of l

Re: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Jared Still
One thing you can do is bypass all of your security if you aren't careful. EXTPROC needs to run as some user other than Oracle (nobody for instance), otherwise you've just created a huge security breach. There are other security implications as well. Even running as 'nobody', you need to ensure

RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1

2003-09-04 Thread david hill
Title: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1 1 Important Difference RHAS 2.1 is the only certified version if you are using 9.2 -Original Message- From: Kulev, Milen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 04, 2003 4:59 AM To: Multiple recipients of list O

RE: RE: Oracle on Win2000

2003-09-04 Thread Brian Dunbar
Prem Khanna J [mailto:[EMAIL PROTECTED] on Thursday, September 04, 2003 4:05 AM said; > Bala,my reply is also the same as John said. > "PC Anywhere or the console straightaway" My favorite for remote console access on W2K is TightVNC - http://www.tightvnc.com/ - or the 'ol standby, NetMeeting. W

RE: Oracle Masters exam

2003-09-04 Thread Mladen Gogala
So, it's nothing like OCP where you get the certification when you spew out certain amount of the green stuff? I wonder how long will it take before seeing oracle masters who don't know how to take a hot backup. -- Mladen Gogala Oracle DBA -Original Message- Sharman Sent: Wednesday, S

Re: alter system reset

2003-09-04 Thread Arup Nanda
ALTER SYSTEM RESET applies to RACs only and you need to give the SID parameter. When you said "I find that shared_pool_size exists there", did it exist as the follwoing? *.shared_pool_size=... I bet it did. Note how you used the SID in setting the value alter system set shared_pool_size=40M scop

oracle 10i

2003-09-04 Thread A.Bahar
what is this ? oracle 10i ! -- 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 ---

RE: RE: URGENT : sql*loader performance problem on partionned tab

2003-09-04 Thread NGUYEN Philippe (Cetelem)
Title: RE: RE: URGENT : sql*loader performance problem on partionned table - not sql*loader problem but cursor pb! Here the informations : table HREL_FUSION :     63 millions rows     3 indexes on columns : nodos_or, nodos_or, numcli <--- too much indexes ?? table primedi_enr2_tem

RE: Oracle Standby Database Backups.

2003-09-04 Thread Mercadante, Thomas F
Arup,   Thanks for the reply.  So I am assuming that the Standby database is in archivelog mode?  Good idea performing the backup on the standby rather than the Primary.  Our Primary is supposed to grow to 3TB, so your idea has merit.  And our servers will be in two different buildings, so

RE: Oracle not available???

2003-09-04 Thread Boivin, Patrice J
No, in Task Manager. place the cursor over the task bar (at the bottom of the screen), right-click, and Task Manager will be one of the items listed. Open it, go to the Performance tab. Patrice. -Original Message- Sent: Thursday, September 04, 2003 3:45 AM To: Multiple recipients of lis

  1   2   >