Re: ora-918

Title: RE: ora-918 Thank Jerry, but month represents field named ia_validity_month. The sql in my message is just to give you an idea what the problematic sql looks like. Yechiel AdarMehish - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of

Urgent: Prodution database recovery

Env: 8.1.7.3 Compaq Alpha Tru64 5.1a An apparent hardware problem caused corrupt blocks ora-600 [12700] to be detected. Analyze table validate structure confirmed this error. We started a PITR to a time before the errors were detected. All datafiles were restored (file copy took ~7.5hrs

For real Gurus only

Hello Gurus I got this link through SAG-L. Have a try. www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services

RE: SQL Question

I'm sure you're already aware of this, but the substr/instr is not as complicated as it looks since instr takes 4 parms, the 4th of which makes cycling through fields 1=8 easy. hth connor --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Stephane, Thanks. Nice idea :) I will pass on this

RE: Urgent: Prodution database recovery

Don't know whether this is of any use, but could it be that you still have a hardware fault that is causing your restore to become corrupted? Regards David Lord -Original Message- From: Hand, Michael T [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 10:23 To: Multiple recipients of

RE: RMAN Question

THANK YOU IT'S TRUE, I WAS USING A 8.0 ORACLE DOCS REGARDS K.Benlatreche -Message d'origine- De : GL2Z/ INF DBA BENLATRECHE [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 29 mai 2002 15:24 À : Multiple recipients of list ORACLE-L Objet : RMAN Question Hi ALL, I want to use RMAN

Undocumented Parameters

Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally

RE: Undocumented Parameters

set echo on spool parm1 select a.ksppinm Parameter, a.ksppdesc Description, b.ksppstvl Session Value, c.ksppstvl Instance Value from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '/_%' escape '/' / spool off -Original Message- lerobe Sent:

Advice needed please

Oracle 8.0.5 Tru64 4.0f One of our developers here is writing a utility to provide fast unloads of tables (to replace fastunloader as it happens) His problem is as follows. Start from the bottom and work your way up. I would be really grateful if anyone can offer up some alternatives for us.

Bind Variable values

Hi All, I want to get the individual sql_trace from my applicaion as they use loads of bind variables, how to get those values so that I can run explain plan and see them individually? for examploe like event 10046? Thanks for your help. Ravi.

RE: Undocumented Parameters

Got this one from somebody, don't remember who, though... select rpad (a.indx ,10) "number" ,rpad (b.KSPPINM ,50) "name" , rpad (a.KSPPSTVL,50) "value" , rpad (a.KSPPSTDF,10) "default" from x$KSPPCV a , X$KSPPI b where a.indx = b.indx; HTH, Mandar. -Original Message-From:

RE: Undocumented Parameters

Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee You know this Chinese proverb, about giving a man a fish and feeding him once vs teaching him how to fish, and feeding him for all his life? The place

Wait time for SQL*Net message

The following statistics is for a server-side application ( pro*c ). The connection is established between proc*c to server as LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and listener.ora EventWait(cs) %wait

RE: Undocumented Parameters

Thanks to everyone. Got it now. Regards Lee -Original Message- Sent: 30 May 2002 13:28 To: Multiple recipients of list ORACLE-L Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee You know

RE: Senior DBA position - Dublin, Ireland

Roy Keane is free at the moment. -Original Message- Sent: Tuesday, May 28, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Before any public outcry I checked in with, and got permission, from list moderator to make this posting!!! Acknowledging we're geographically remote for

Re: Senior DBA position - Dublin, Ireland

Rachel, if his Mother is Irish, all he needs to do is ask for the passport - once he has it - you can apply for one as long as you've been married for over three years i think , again try the government sit http://www.irlgov.ie -it'll give you all you need to know Brian. Brian Mc Quillan

Re: So, What is a 'Production DBA'?

Rachel, I agree with your short list of the areas of responsibilities but I would change the word application to development. An application DBA, from the people I have talked to, is quite busy performing the upgrades and patches that accompany the Oracle Applications. The applications database

Re: Wait time for SQL*Net message

Make your PRO*C program faster. The wait-event SQL*Net message from client on the server-side is indicating that 61% of time is spent waiting for the client-side to say something, anything... Seeing the SQL*Net more data to client wait-event indicates that you're probably using array-fetching

Re: Wait time for SQL*Net message

10 Gigabit Ethernet ;) On Thu, May 30, 2002 at 03:58:31AM -0800, S B wrote: The following statistics is for a server-side application ( pro*c ). The connection is established between proc*c to server as LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and

RE: Undocumented Parameters

Here is a script I got from the honorable Mark Leith. Run this as SYS. set echo on spool parm1 select a.ksppinm Parameter, a.ksppdesc Description, b.ksppstvl Session Value, c.ksppstvl Instance Value from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm

Re: Wait time for SQL*Net message

Hi Type more and a lot faster and hit more enters while sending querries to the database. :-) I would not worry about SQL*Net message from client, it simply means that your client has received the data from the last request and now the server is waiting for the next. If you have a sql*plus

RE: So, What is a 'Production DBA'?

Now see... as one new to the world of Apps DBA, I looked at her list, and realized that it was the other kind of applications... not Oracle Applications although from my experience network support, client support, whipping post, IT team member (possibly team leader), self driven, office

Re: Bind Variable values

Hi If you just want to see the explain plan of a querry with bind variables you don't need the values. just type explain plan for statement and you can read the explain from the plan table(should have been created beforehand) HTH jack

tkprof analysis

Hi, Can any one point me or kindly send me the analysis of TKProf outout please. Thanks you so much for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts

updated rows count

Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this

Re: how to change a foreign key back to a primary key

Trang, Could you be a little bit more specific about what you are trying to do? Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 7:05 PM Subject: how to

Re: how can listener list on two ports for the same db?

Hi Helmut , I will try to clarify using an example. Tnsnames.ora ghi100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = your IP address of the server where database resides )

Re: how can listener list on two ports for the same db?

Hi Helmut , I will try to clarify using an example. Tnsnames.ora ghi100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = your IP address of the server where database resides )

RE: Bind Variable values

Ravi - According to Metalink Note:171647.1, There are four levels available when setting up trace with Event 10046 - · Level 1 is the default. This level traces all activities until the trace session is stopped. · Level 4 provides level 1 tracing and displays the entered

RE: Re[2]: So, What is a 'Production DBA'?

Not sure I agree with prior statements. The Production DBA is the single person(s) responsible for the livelihood and availability of production database environments. He/She/It is the first line of contact should a database-centric application either not perform to expectations or crash.

RE: updated rows count

The SQL%ROWCOUNT and SQL%FOUND can be used to test for the status after an update operation. If SQL%FOUND is true then SQL%ROECOUNT will hold the number of rows updated. If the transaction has failed then %FOUND will be FALSE (and %NOTFOUND will be true) and %ROWCOUNT will be 0 HTH John

Adding processor to Oracle server

I have a Windoze server that has an instance of 8.0.5 Oracle running on it. I just got an email from the network badmins that they are adding a processor to this server today. Glad to be in the loop!! This is a new experience for me. Is this something that may cause problems when Oracle

Re: Bind Variable values

Set the SQL trace event (10046) to level 4 to dump the values of the bind variables. If you can enable SQL trace from within the session, you can use... alter session set events '10046 trace name context forever, level 4'; If you cannot alter the source code or otherwise enable SQL trace

Re: updated rows count

select SQL%ROWCOUNT after update... Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 9:48 AM Hi

RE: Advice needed please

Lee - Just some reactions, few answers. - Generally a process like this will be disk-bound, not CPU-bound, so idle CPU time is to be expected unless your disk is REALLY fast. - Multiple simultaneous full-table scans may not be any faster because the disk heads may need to flit to and fro in

Re: tkprof analysis

Oracle8i Server Tuning guide (part #A76992, available for free download from http://docs.oracle.com), pages 6-22 through 6-30 for TKPROF output example - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7:38 AM Hi, Can any

Re: updated rows count

Do this in PL/SQL, so you can use PL/SQL variables instead of data values embedded in the text of the SQL statement (much nicer on the Shared Pool). From PL/SQL, after each statement you can reference SQL%ROWCOUNT to get the number of rows actually updated... If you prefer Precompilers, you can

Re: Bind Variable values

Hi Jack, thanks for the response however what I was looking is in a sql query they substitue around 100 bind variables (through application) I can't just substitue them one by one in where condition and run the query rather what I wanted to see like puting sql_trace on if we put set events 10046

Re: Wait time for SQL*Net message

depends on what is causing the wait time. if it's because this is an interactive application and you are waiting for the person to enter data into the screen, teaching them to type faster would do it. :) it could be your network lag time or the processor speed on the machine that is the client.

RE: Advice needed please

Thanks Dennis. Anything whether it be a reaction or an answer, is welcome. Regards Lee -Original Message- Sent: 30 May 2002 15:08 To: Multiple recipients of list ORACLE-L Lee - Just some reactions, few answers. - Generally a process like this will be disk-bound, not CPU-bound,

RE: updated rows count

Greg - How is your client executing this SQL update statement? If it is executed from SQL*Plus, you are provided the number of rows updated as a reply. If it is a one-time update, that might be the simplest. With other tools, it depends a lot on the tool. Dennis Williams DBA Lifetouch, Inc.

Re: Undocumented Parameters

Lee, Here ya go. Remember, be *careful* with those hidden params, cowboy. Oracle does not support changing them, and you can really hose the system with em, perhaps beyond the normal capacity to repair it. As they say, this script is unsupported and for educational purposes only, but can come in

Re: updated rows count

After each of 20,000 update statements? Alexandre select SQL%ROWCOUNT after update... Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L

RE: For real Gurus only

great! thanks -Original Message- Sent: Thursday, May 30, 2002 5:23 AM To: Multiple recipients of list ORACLE-L Hello Gurus I got this link through SAG-L. Have a try. www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html Yechiel Adar Mehish -- Please see the

Re: Adding processor to Oracle server

You shouldn't have any problems with Oracle, as long as Windoze will behave... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 9:54 AM I have a Windoze server that has an instance of

Re: updated rows count

One approach: create a new user for this update, create a trigger to log only updates from that user, run the script as newly created user. Alexandre Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about

RE: Bind Variable values

Hi Dennis, Thanks for the answer, I just put event leve4, I could not get the bind variables values, rather gave me :b1,:b2 How do I get those values? And another thing is in tkprof values can please explain me about the query and current rows and cpu and elapsed times? my understanding

Re: Adding processor to Oracle server

Dave: This is automatically taken care by the RDBMS kernel and sometimes relfected in the CPU_COUNT in the V$parameter. Otherwise you can query the X$view X$KVII select kviidsc,kviival from X$kvii where kviitag='ksbcpu'; Best Regards, K Gopalakrishnan Bangalore, INDIA - Original

RE: Adding processor to Oracle server

This should not cause a database problem, however, you may want to check your Oracle license. It will cost you more!!! Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com

Re: So, What is a 'Production DBA'?

I feel that it is hard to draw the lines between Application and Production DBA's. For example where would you place the DBA that maintains SAP? Without the application knowledge he/she/it wouldn't get very far. Also I have been wondering something and this thread seems a good place to ask.

Re: updated rows count

usecat file_name | grep -C update JP On Thursday 30 May 2002 15:48, you wrote: Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big

Re: So, What is a 'Production DBA'?

ron, I've usually seen the term Apps DBA for the DBA who deals with Oracle Applications. As for using development dba vs application dba I was using the terminology of the original poster. My feeling is, separating these functions just adds to overhead and disconnect in solving problems...

Re: _tru64_directio_disabled param Value on Digital Tru64 Unix

So you got a performance improvement by *disabling* DirectIO (ie, by setting _tru64_directio_disabled=TRUE) ? Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 30 May, 2002 3:48 AM I joined in on this thread a little bit

Re: Adding processor to Oracle server

Dave, Your Oracle instance won't have a problem with it. Your Oracle Sales Rep. will be absolutely delighted, because you will owe them more $$$ for the extra CPU license! Better check with your CIO (or equivalent) to see if your organization really wants to add that CPU. Jack C.

Re: _tru64_directio_disabled param Value on Digital Tru64 Unix

Yes, I changed it from the default. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA Hemant K Chitale [EMAIL PROTECTED] 05/30/02 09:32AM So you got a performance improvement by *disabling* DirectIO (ie, by setting _tru64_directio_disabled=TRUE) ? Hemant K Chitale -

RE: SQL Question

Hi Conner, Yes, I agree. But its the 'green bean' developers that I am dealing with :) Regards, - Kirti PS : Your BCHR enhancer code is coming extremely handy :) Great Job, you did !! -Original Message- Sent: Thursday, May 30, 2002 4:23 AM To: Multiple recipients of list

Re: updated rows count

before the update: Select count(*) from table where ... Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 3:48 PM Hi All! My client run big update 20,000 statements. I need to know how many rows was

undeliverable email - Yo Jared

Jared, I have been getting these for a few weeks now on all of my posts. It is only for the name listed below. If anyone else is getting these could this name be removed from this list. These undeliverable emails clutter up my Off-Topic emails. ;o) Thanks, Dave -Original

Re: Senior DBA position - Dublin, Ireland

Brian, first, his grandparents were Irish, his mom was born here. second, we were married for about 7 and a half years so that would qualify me however, it's the he has to ask part that kills the whole deal... he died july 9, 1993 Rachel --- [EMAIL PROTECTED] wrote: Rachel, if his Mother

RE: how to change a foreign key back to a primary key

Trang, How about: alter tableTABLE_NAME drop constraint CONSTRAINT_NAME; alter table TABLE_NAME add constraint pk_TABLE_NAME primary key (COLUMN) using index tablespace indexes; -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 29, 2002 7:06

Re: how can listener list on two ports for the same db?

Title: how can listener list on two ports for the same db? Hello Helmut You need to configure the listener to listen on ONE host with 2 ports. The machine name is the same. You separate the connections via tnsnames.ora on the client side. I got a call today that one of our application

RE: updated rows count

Hi All!=0D My client run big update 20,000 statements. I need to know how many rows wa= s updated (it's could be any number). =0D I thinking about triggers , but this table can be updated not only with thi= s big update. Other users can update rows too.=0D I need to know updated rows number just

Re: how to change a foreign key back to a primary key

Hi Igor, I just wanted to set a concatenated keys for my table. By mistake, I assigned only one primary key instead of two combined together. Here is my table structure: organization_id (primary key) address_id (foreign key) It should have been a primary key as well. I wanted to set this

rman duplicate dbid?

I'm just starting to set up RMAN (8.1.7+) . . . I'm registering all of my databases one by one from the command line. I have two db's on the same solaris box and when I run the rman command they both show up with the same DB_ID, thus preventing me from registering both of them . . . I get an

Re: move the production database from one machine to another

On Wed, May 29, 2002 at 09:13:25PM -0800, Jeremiah Wilton wrote: On Wed, 29 May 2002, Ray Stell wrote: It is not supported as an upgrade process. Oracle does not support prod at 8.1.7.0 and standby at 8.1.7.2. I think this is a real crime, since it would be a great feature to lower

Re: So, What is a 'Production DBA'?

Thanks to all who responded. The debate on the list is just as lively as the one around the water cooler. I did like the response about a 50% pay differential for production DBAs. That will make the bosses hair stand on end! --- Peter Barnett [EMAIL PROTECTED] wrote: We are having this

Re: So, What is a 'Production DBA'?

all it takes is one bad developer (commonly referred to as a duhveloper) to spark the flames remember, dilbert makes its money on the BAD side of software development, there is no humor (and in our cases, no angst) when the people do the jobs they are supposed, on time and properly. In my own

RE: So, What is a 'Production DBA'?

Jay Yes, many of us were developers and for awhile you have the illusion that they should accept you because you are one of them. Eventually you realize the relationship isn't that simple at all. The problems usually come from perspective, interests, and priorities. Many senior developers

RE: rman duplicate dbid?

Bill Perhaps you created one by cloning it from the other one. This can change the SID, but won't change the DB_ID. RMAN can't deal with multiple instances with the same DB_ID. The simplest way around this is to create a separate RMAN catalog for one of them (just create a separate

Re: So, What is a 'Production DBA'?

Actually some of the worst DBA's come from the development track. IMHO, the best DBAs are from the systems world :). Of course this doesn't mean all systems ppl make good dba's or all developers make bad dba's. This is only from my experience. Gene *Let the Wars begin, NOT* [EMAIL

Using DUAL

The developers here have a fondness for usingDUALfor simple operations (select count(*) from dual is executed 1+ times per day). I recall a passing comment somewhere/sometime that there are performance issues with accessingDUAL. Of course, now that I need to provide some information to

Re: So, What is a 'Production DBA'?

I guess it's that old Russian proverb To a hammer, all the world looks like a nail. Developers have experience as hammers and everything revolves around the code. As an ex-developer, now DBA, I know that sometimes you need a screwdriver (or a Harvey Wall Banger).

RE: Bind Variable values

Dennis (or anyone else) I remember these values of 1,4,8,12 but the SQLab tuner from quest insists on doing the 10046 trace at level 15, are there any more hidden levels that we don't know of? Raj __ Rajendra Jamadagni MIS,

Re: So, What is a 'Production DBA'?

Beware of developers that carry screwdrivers. Its a hardware problem, not software. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 5/30/02, Thomas Day [EMAIL PROTECTED] wrote: I guess it's that old Russian proverb To a hammer, all the world looks like a nail. Developers have

RE: So, What is a 'Production DBA'?

I'd take that pay differential thing with a grain of salt. The definitions for Production DBA's, Apps, DBA's, and Development DBA's are merely organizational interpretations. Each organization custom creates these titles so PHB's can put labels on people. In many cases a production DBA is

RE: Using DUAL

Dual is often used for tasks that can easily be done without making a full roundtrip to the database, not to mention network traffic. Such as getting the system date, the user name, determining basic logic that can be done without going to the database. Regards Melanie

RE: rman duplicate dbid?

found a note on metalink about how to change the dbid by recreating the controlfile (note 174625.1) . . . one of those notes with the lovely disclaimer about how the script is not supported by Oracle support, done at your own risk, don't try this on a production db, etc. . . . anyway, it worked

RE: So, What is a 'Production DBA'?

Gene - C'mon ya gotta give us more details. I have heard that most DBAs either come from developers or sys admins, but I can't recall a former sys admin, or maybe they just didn't mention it. I am curious about your observations on the best and worst qualities of each variety. I feel that a

RE: Using DUAL

Oracle Perf Tuning by O'Reilly mentions it, but without explanation: http://www.oreilly.com/catalog/oracle2/chapter/ch10.html There's more, too. Try searching for dual performance iterative OR loop oracle on google.com HTH! :) Rich Jesse System/Database

Re: Bind Variable values

Raj: Level 15 (or level 100 or 200!!) is level 12 only. Anything above level 12 is considered as level 12/ Best Regards, K Gopalakrishnan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 10:13 PM Dennis (or anyone else)

RE: how to changes the sequence no for the redologs

Dennis, I beg to differ with you on this issue. To keep the naming convention simple for the logs and to be able to differentiate between different instances logs, you may have to use 4 characters plus the sequence number for the log name. as an example PRDA+seq.log and PRDB+seq.log. If the OS

RE: rman duplicate dbid?

Bill - Glad that method of changing the db_id worked for you. The advantages I see for separate RMAN catalogs are: - If you need to upgrade the target database, you can do that without affecting the other databases. For example, if the upgrade requires a change to the catalog schema, you can

How do I parse information from a Column

Hi, I am capturing data from v$sqlarea to a table to find out all the query activities on a database. Now I would like to parse sql_text column from a table to get only DML commands(SELECT, INSERT, UPDATE and DELETE) and also FROM clause to get table names. The example is: SELECT

RE: So, What is a 'Production DBA'?

So true! Its different in each organization. Titles change but jobs do not :). [EMAIL PROTECTED] 05/30/02 12:51PM I'd take that pay differential thing with a grain of salt. The definitions for Production DBA's, Apps, DBA's, and Development DBA's are merely organizational interpretations.

RE: Dblink - How to connect two databases

Title: RE: Dblink - How to connect two databases Not sure what you're trying to accomplish, that is, remote query or remote update OR are you just trying to connect to another DB? If you're trying to perform a remote query and you've created a dblink from DB1 pointing to DB2, then you just do

RE: So, What is a 'Production DBA'?

A Harvey Wall Banger? I've never heard of that type of hammer before :) -Original Message- Sent: Thursday, May 30, 2002 12:36 PM To: Multiple recipients of list ORACLE-L I guess it's that old Russian proverb To a hammer, all the world looks like a nail. Developers have experience as

CAPACITY planning

Hi Is any additional benefit in terms of performance in Oracle9i? Does any one have documents on capacity planning? Thx -Seema _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see

RE: move the production database from one machine to another

We decided not to upgrade Oracle in order to reduce the variables at this time. We are only licensed to Standard Edition so standby is not an option. -Li -Original Message- Sent: Thursday, May 30, 2002 8:59 AM To: Multiple recipients of list ORACLE-L On Wed, May 29, 2002 at 09:13:25PM

RE: So, What is a 'Production DBA'?

I know I'm probably going to regret replying to this thread. I'm one of those people who spent years as a programmer...and wound up somewhere in between applications and tech support because I couldn't get the tech support I needed. When we got SAP'd in '93, I finally gave in to becoming a

Re: so when did you switch from NT to unix for oracle

Hi Rafiq, I'll let him know :). From the great, great hospitality shown by Steve to Jonathan, Cary, Anjo, Howard, me and others this week here at the Database Forum I think it's safe to say that Steve is fine - but busy. Steve is a very impressive guy in many ways. But I guess he has to

Re: SAN Implementation

I personally love James Morle's Sane SAN paper available on for instance www.OraPerf.com. James is cool and knows what he's talking about. I used to say with pride that James is the guy who wrote the book which is placed in my bathroom. Turns out that while we've been away for the Database

Jr.DBA, Mid level DBA, Sr.DBA

Hello: Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a Sr. DBA? I know how our HR department makes the division but would be interested in knowing how other people might classify the differences. Regards, Jay

TUNE DB

Hi The following are top5 wiat events in my database? Total TotalTime Avg WaitsTimeouts Waited% of Wait Event Name (in 1000s) (in 1000s) (in Hours) Concern (Secs)

RE: Bind Variable values

That explains it ... I thought quest guys knew something that we didn't know about. 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

RE: So, What is a 'Production DBA'?

There is a definite need for people with detailed knowledge of mission critical apps and it's optimal when DBA's and System Admins are wired in! the role I play doesn't seem to have any technical boundaries Boundaries are things that aggressive DBA's want to break through. They intrusively

Re: updated rows count

Create After update trigger on table assethdr. And let the trigger insert ROWID of changed rows in other table. And you can always do SELECT DISTINCT ROW_ID FROM my_spy_table_with_rowids :-] JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: Urgent: Prodution database recovery

Thanks David, You hit the nail on the head. Hardware problems are preventing the backup files from restoring normally. We've got several hardware experts on site this morning going over the disk/filesystem with a fine-tooth comb. File header dump shows file_id mismatch which disappeared in 2

RE: Help with SQL Aggregate Functions

You probably hit the following bug!!!

RE: how to change a foreign key back to a primary key.Thank You.

Richard and Igor, Thank you both for your quick answers. I do appreciate it very much.The statements work well. Again, thanks for your help. Trang Richard Huntley [EMAIL PROTECTED] wrote: Trang, How about: alter tableTABLE_NAME drop constraint CONSTRAINT_NAME; alter table TABLE_NAME add

Re: So, What is a 'Production DBA'?

Hello Dennis My path: Computer operator, duveloper, system programmer, DBA. About developers: they do not see the whole picture, do not understand limitations etc.. I had a call from the guy who is charge of a project. The database creates about 10 MB of archive logs every 3-4 minutes, and is

  1   2   >