Re: Instance down

.or are you trying to put it offline ?. Issue an dbv of each datafile. In any case you should open a tar with Support. It is probably an bug. Tell me whether or not you solve it and the bug number. Regards. --- Seema Singh [EMAIL PROTECTED] wrote: no From: Christian Trassens [EMAIL

Re: Temp problem

Increase the ulimit of oracle or the user running the query or transaction that received the error. Regards. --- Raghu Kota [EMAIL PROTECTED] wrote: Hi friends I had following error in my alert log file, Any ideas why its happening?? Mine is AIX ,oracle7. Mon Jul 23 08:53:43 2001

RE: Lock

If I am not wrong you can use a SELECT FOR UPDATE -Message d'origine- De : Hamid Alavi [mailto:[EMAIL PROTECTED]] Envoyé : mardi 24 juillet 2001 03:45 À : Multiple recipients of list ORACLE-L Objet : Lock hi all, Aay body know, how you can control the lock during the sql

Lawson and Staffware running on Oracle?

Hi all. Does anyone out there know of any issues running on Oracle 8.1.7, which in turn runs on a Unix box (Solaris version 8)? The box will probably be a 3800 or a 4800 (still to be purchased) Info on issues such as sizing, security, tuning etc would be of great help or even any known

RE: The number of used cursors?

Thank you for the anwers. If I try Jon's version I get a big number that does not seem to be related to the number of maximum open cursors ( it's much higher). If I query the V$SQL_CURSOR view, then I get a number the could be the value I look for. Could some one shed some light on this?

constraint naming

O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile:

RE: Lock

I think the only way to not acquire a row level lock, is to use one of the fabled Undocumented Parameters (if this is what you mean of course). I do have to say that using this kind of parameter without the backing of OWS, is not advisable, and therefore, will refrain from telling you which one

Re: weird recursive sql

That recursive stmt hasn't to be involved with the stmt beneath. However, are you using private synonyms or do you have a lot of tables and objects ?. Why don't you look at gets and misses in the v$rowcache ?. Are you suffering of row cache lock wait ?. Are you on 8.1.X ?, do you know the thing

No Subject

SET ORACLE-L DIGEST Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: constraint naming

Guy, Per bug 15148 this is scheduled for 9.0.2. I don't know of any supported method of doing this, other than dropping and recreating the constraint. HTH, -- Anita --- Guy Hammond [EMAIL PROTECTED] wrote: O Wise and Powerful Oracle: Is there a way to change thy system-generated names

Starting Oracle services remotely (Win2K).

Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. Cheers Mark === Mark Leith | T:

Re: The number of used cursors?

Tamas: I've done some looking into this issue and I think it depends on what you want when you say want to know the number of used cursors. If you mean those that have been opened AND parsed, then a count from v$open_cursor will give you that (for the most part). If, however, you want to know

Question on on delete cascade functionality

Dear DBA Gurus, How to add the functionality of on delete cascade to an existing foreign key constraint without dropping the constraint and recreating it using Alter command? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s)

Re: Starting Oracle services remotely (Win2K).

Hi rexec servername -l username -- net start oracle should do it. Or you can use graphical tools through the admin tools and install the snapins = rexec computer [-l username] [-n] command Net start Starts a service, or displays a list of started services. Service

Re: constraint naming

Guy Hammond wrote: O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED]

RE: Starting Oracle services remotely (Win2K).

Hi, Mark Why not to use a Terminal Services (which comes on Win2k's Installation CD) for this purpose? Install TS on a needed box, then install client software on your own machine and go on... Igor -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July

Re: Starting Oracle services remotely (Win2K).

Add the computer in the MMC (Microsoft Management Console) and then you can control whatever you want (if you're an Administrator). Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 7:05 AM Hi all, Has anybody

Re: Question on on delete cascade functionality

sounds like a trigger is needed. joe Ranganath K wrote: Dear DBA Gurus, How to add the functionality of on delete cascade to an existing foreign key constraint without dropping the constraint and recreating it using Alter command? Thanks and Regards, Ranganath DISCLAIMER: This

Re: The number of used cursors?

Hi Tamas, V$SQL_CURSOR is providing the number of cursors for the querying session, but Jon's query, give the current opened cursors for all session. If you restrict v$sesstat to the sid of your session and v$sql_cursor to status not 'CURNULL', you will get the same number. That's: select

IAS-Apache and PHP

Title: IAS-Apache and PHP Hi gurus, Has anyone tried to include a PHP module to Apache in IAS ? Does Oracle support it? We have some PL/SQL applications (drive by OAS) that we need to migrate to IAS. We have some other new applications in PHP. Do we have to maintain two Apaches (one in IAS

RE: How to download website

Use wget. You can get it, along with a bunch of other good stuff, here: http://www.weihenstephan.de/~syring/win32/UnxUtils.html g -Original Message- Sent: Monday, July 23, 2001 3:46 PM To: Multiple recipients of list ORACLE-L hi dba's is there anyway to download complete website

Sun cluster vs Veritas cluster

List, Just wondering if anyone on the list who had experience on both Sun clustering and Veritas clustering software share their experience on both products, strength and weakness or any comparison?? KC

Re: Question on on delete cascade functionality

While a ON DELETE trigger would do what you want, why don't you want to rebuild the constraint? [EMAIL PROTECTED] 07/24/01 08:05AM sounds like a trigger is needed. joe Ranganath K wrote: Dear DBA Gurus, How to add the functionality of on delete cascade to an existing foreign key

retrieving BLOB column..

hi all, do any one tell me how can i retrieve from a blob column. these will be displayed in browser through asp page. r there any functions used to retrieved records(jpg files, gif) from a blob. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html

Re: IAS-Apache and PHP

I'm not an expert in this area but I do know that we haven't two apaches ie. our administrator installed Oracle and IAS and then added PHP module and this WASN'T very painful process ;) How? I don't know :( Oracle 8.1.7 on red hat linux 6.2 Gints Plivna

Solaris 8 and 9i

List, Just wondering if anyone on the list has the combination of Solaris 8 and 9i loaded. Strength and weakness on both products or any comparison?? Currently running Solaris 5.7 and Oracle 8.1.7. My SA wants to go to Solaris 8 and I was thinking about going to 9i on our development box when we

Re: constraint naming

g, Why use system generated FK names. does SYS12345 maen any thing to you? We always generate our FK with an ALTER TABLE command and name the FK with something that can be recognized. Very usefull when you have to drop the FK to accomplish an import of data. ROR mª¿ªm [EMAIL PROTECTED]

urgent synthax of DBV

i need in urgence DBV synthax thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

template for description of Oracle installation

I'am searching for a template of a good looking description of an Oracle installation. Can anybody help me ? Regards, sh476622 --== Sent via Deja.com ==-- http://www.deja.com/ -- Please see the official ORACLE-L FAQ:

RE: urgent synthax of DBV

Try dbv help=y Or click here : http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76955/ch09.htm#1936 (found by searching for 'dbv' at http://tahiti.oracle.com/pls/tahiti/tahiti.homepage :) HTH, Regards, - Kirti Deshpande Verizon Information Services

waits on sequential scans - how did i solve it

list, based on the recommendation of posters (Jack) , i re-created the index with all the columns of a table ! (all 8 of them) analyzed the table/index and now all the queries are satisfied off an indexed range scan.. i also put the indexes on raw devices. regards -- From:

RE: Solaris 8 and 9i

I have solaris 8 and oracle 9i on my home development box. 9i is awesome, but it is also very immature. Solaris 8 has many new features and definitely worth the upgrade. Make sure you get 04/01 or newer. Walking on water and developing software from a specification are easy if both are frozen.

RE: Solaris 8 and 9i

but it is also very immature. For example - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 8:46 AM To: Multiple recipients of list ORACLE-L

RE: Starting Oracle services remotely (Win2K). - Thanks

Thanks to Peter, Igor and of course Jon. It's easy when you know how huh - I used Computer Management in the Admin tools, and simply used the Action of connecting to another computer.. Cheers for your help. Mark -Original Message- Walthour Sent: Tuesday, July 24, 2001 12:46 To:

RE: Input truncated

Just do a carriage return at the end of the last line. The last line will be 35 characters long. Iain -Original Message- Sent: 24 July 2001 15:01 To: Multiple recipients of list ORACLE-L I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35

Input truncated

I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ:

RE: Off Topic: For Sale Sparc 5 170MHz capable of running 9i

Thanks Guy! Mark -Original Message- Sent: Tuesday, July 24, 2001 01:11 To: Multiple recipients of list ORACLE-L Mark, you can get cheap Sun kit in the UK from here: http://213.48.204.69/main/sun.htm g -Original Message- Sent: Monday, July 23, 2001 3:06 PM To: Multiple

Reproduce ORA-0600

I had a production database become corrupt after an ORA-07445 and an ORA-0600 occurred. The instance would not come back up and had to be recovered. I can reproduce and correct the ORA-07445 (bad block) but it doesn't create the ORA-0600 or corrupt the database. I have tried adding rows,

RE: retrieving BLOB column..

Saurabh, Check out the DBMS_LOB package. There are lots of procedures and functions for manipulating BLOBs and CLOBs. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL

RE: waits on sequential scans - how did i solve it

Rahul, If I'd known that there were only 8 columns in the table, I'd have included the recommendation to investigate an Index-Organized Table. That is where the table IS the index and the index IS the table. This saves disc space and cuts I/O in half for DML on the table, since a separate

RMAN duplicate database query

Title: RMAN duplicate database query Hello listers, We have a instance on server A, a RMAN recovery catalogue on server B and a 3rd server C where we want to create a copy of the live database with a new sid. This is on Oracle 8.1.7 The RMAN duplicate command seems to be the one to use

Re: Solaris 8 and 9i

On Tue, Jul 24, 2001 at 05:25:29AM -0800, Rusnak, George A. wrote: List, Just wondering if anyone on the list has the combination of Solaris 8 and 9i loaded. Strength and weakness on both products or any comparison?? Currently running Solaris 5.7 and Oracle 8.1.7. My SA wants to go to

Re: HELP

Norrell, Brian wrote: No one will be watching us, Why don't we do it in the code? i think we can code now... -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the

RE: Input truncated

Andrea: Open up your .sql file in notepad or the like and put a carriage return after the last line so you, in effect, have a final blank line. Jon Walthour --- Original Message --- From: Quaglio Andrea [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date:

RE: Input truncated

Title: RE: Input truncated Andrea, put a carriage return after your last slash and this will go away. It's harmless. Lisa Koivu Ft. Lauderdale, FL, USA -Original Message- From: Quaglio Andrea [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of

RE: Input truncated

In your pl/sql script add a carriage return after / Rick -Original Message- Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1

RE: Input truncated

Hi, Andrea , Nothing to worry about. If you want to get rid of this message, remove blank lines after procedure code. HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original Message- Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L I

RE: waits on sequential scans - how did i solve it

Title: RE: waits on sequential scans - how did i solve it Is this table/index now suitable to be a IOT, it will certainly save some space on an 18M row table John -Original Message- From: Rahul [mailto:[EMAIL PROTECTED]] Sent: 24 July 01 14:53 To: Multiple recipients of list

Re: Input truncated

Andrea, Make sure that at the end of your script you don't have additional returns and one hard return after the last command. (i.e. SET OFF SET OFF SELECT * FROM table / SET ON SET ON one return here and no other lines after Hope

Re: Solaris 8 Question

This happened to me today: Solaris 5.8 we have a large data load exercise going on and the archive log directory filled - database stopped of course. but after I had moved all the archive logs to another location the system still hung - I tried manual switching of log file ,still hung. I had

RE: How to deal with special character like in ' '

You could do select 'string1 '|| chr(38) ||' string2' from dual Baskar -Original Message- Sent: 23 July 2001 18:51 To: Multiple recipients of list ORACLE-L Hi, I want to insert a string like 'AM University' but has problem with '' I want the database exact AM University. But it

RE: RE: tnsnames.ora in clients

Thanks to who responded and responding. Suren -Original Message- Sent: Monday, July 23, 2001 2:13 PM To: Multiple recipients of list ORACLE-L except that ONS is going away in favor of ldap. joe [EMAIL PROTECTED] 07/23/01 12:58PM We switched to ONS 3 years ago have never

Re: RMAN duplicate database query

I am testing the duplicate command now. I don't think you need password file on server A, but you do need a password file on server C. To my understand, you do need 3 connections to make it work. Even you want duplicate days old copy. I think rman somehow needs info from control file on server A.

Re: waits on sequential scans - how did i solve it

I don't think, 7.3.2 supports Index-Organized tables. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 10:36 AM Rahul, If I'd known that there were

RE: Temp tablespace issue

Y'day I got this errors, I tried to resize the file, But I could't succeed! Later I did wakeup SMON and tried with alter tablespace temp ..(pctincrease 0)..But still I getting ora-600 with ora-01114/ora-07376 errors..Then I put that particular temp file in offline!!..I problems increased!!

Re: Solaris 8 Question

Sam, you may find that you need to issue archive log stop and archive log start to force the database to start archiving again. Once it's failed to archive a log it seems to lose heart and give up until you nudge it. Ironically the ARCHIVER will keep writing to the alert log to say that it's

Alert Logs Trashed after Archive Directory Fill

Evening; Over the past year we have had our Archive directory fill up a couple times. During that time, some of our instances have had corrupted archive logs. We found this out by applying them to our Standby Databases and getting errors. There appears to be no set pattern to this

Urgent: ORA-03113

Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, ORA-03113 EOF on communication channel appears (progress bar shows between 65% and 75%). What might be possible reason? Software installation went without problems. Please help -- Please see the official ORACLE-L FAQ:

Data Modeling opinion? Help?

I am currently on a project where I have pretty much completed the logical/physical models. Since the client has there own data modelers, they have reviewed the models and wanted specific changes. I have agreed with all there changes except for one. I have tried to explain why this change

RMAN problem after Duplicate

I duplicated a production database using RMAN. I have done this many times. EXCEPT, this time I forgot to issue a RESET DATABASE for the duplicated database. My backups ran last night for both production and the duplicated database. The backup for the duplicated database failed with this

RE: waits on sequential scans - how did i solve it

I was going to say the same thing until I saw what version of Oracle he was running. Its a Oracle8 and up feature so Rahul is SOL. -Original Message- Sent: Tuesday, July 24, 2001 7:36 AM To: Multiple recipients of list ORACLE-L Rahul, If I'd known that there were only 8 columns in

Re:Data Modeling opinion? Help?

Chris, I do not see a description of the change the modelers have specified in your message, so I will assume the oneway.pdf file is your design and the twoway.pdf is theirs. Their model does have a much simpler layout (fewer table joins), but a much greater likelihood of data

Re: Solaris 8 Question

You should try to query the archive destination select * from v$archive_dest see if it says ERROR And do alter system archive log stop followed by alter system archive log start This will fix the broken archive process. Richard Ji [EMAIL PROTECTED] 07/24/01 11:05AM This happened to me

RE: unrecoverable

Title: RE: unrecoverable Prasad, Select logging from dba_tables / user_tables John -Original Message- From: prasad maganti [mailto:[EMAIL PROTECTED]] Sent: 24 July 01 16:17 To: Multiple recipients of list ORACLE-L Subject: unrecoverable hi dba's how to find out whether a table is

what do I tune?

Hi all: I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several (up to 64) parallel streams. I got a snapshot of the system for each run. I see some of the waits went up significantly when I switched from 2 parallel streams to 64: buffer busy

Re: Snapshot shows as INVALID in DBA_OBJECTs

Dave, There are several issues with MV's/snapshots not displaying info correctly in various DBA/ALL/USER views. So far all that I've found are annoying, but don't interfere with refreshes or any other operations, and are fixed in 9.0.1. This is probably due to the fact that they really are

RE: Reproduce ORA-0600

Hello, What was the first parameter of ora-600 ? We should unserstand if your ora-600 are cause or consequence. if it's consequence( I guess it's in your case), ignore it. 24/7/01 06:10:53, Lord, David - CS [EMAIL PROTECTED] wrote: Try upgrading to 8.1.6, its great at throwing 600's ;-)

Re: system switch off

Depends. Is your server an NT box or UNIX? Your sessions are dead (you cannot reconnect to them), but in an NT box there are no separate processes. On a UNIX box the processes associated with your sessions will remain. Our developers used to go home at the end of the day and just turn off

RE: what do I tune?

What do you want to achieve? The more parallel you run the more some of your waits will go up, but the elapsed time may drop a little or a lot. Also you need to balance it with the total load on your server. If it is a query that is run a lot when there are a lot of users on the system you

What privileges are required for Shareplex?

List, We are installing Shareplex. Could any of you tell what privileges are required for a shareplex user? The customer support person from QUEST says that shareplex user requires DBA privileges. Is it correct? Thanks Rao [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ:

books on data modelling

Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge in this area. I am not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ:

RE: Reproduce ORA-0600

Here are the error messages: ORA-07445: exception encountered: core dump [11] [0] [0] [0] [] [] Mon Jul 2 08:03:19 2001 Thread 1 advanced to log sequence 304 Current log# 8 seq# 304 mem# 0: /u035/oradata/prod/redo08.log Mon Jul 2 13:55:26 2001 Thread 1 advanced to log sequence 305 Current

RE: tnsnames.ora in clients

We use a shared tnsnames.ora from a NT server. -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: tnsnames.ora in clients Does this method of sharing the tnsnames work for you?

RE: books on data modelling

Take a look at Data MOdeling Essentials by Simsion Coriolis -Original Message- Sent: Tuesday, July 24, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge

RE: Data Modeling opinion? Help?

Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that

RE: what do I tune?

Gene: It all depends on a couple of factors: (1) what are the average wait times for each of the wait events, (2) which one(s) have the highest wait times. I would ignore any waits less than 1 centisecond for the most part. Buffer Busy Waits occur when a session is waiting for a buffer to

dbw and lgwr issue

Hi The dbw0 process is taking much CPU since yesterday but I couldn't found any waits.Let me know what could be reason and how ca I came out from this issue.Some time lgwr is also taking some more time. Thanks -Seema _ Get your

RE: Data Modeling opinion? Help?

Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -Original Message- Sent: Tuesday, July 24, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Keep in mind that they pay you

SHARED SQLNET.ora? RE: tnsnames.ora in clients

Has anyone been successful with putting the SQLNET.ora file in the same shared location as the TNSNAMES.ora file? I know it's supposed to be used solely on the user workstation in /network/admin (Net80/admin), but some people are trying to place it on the shared drive as well. We're actually

Need SQL Example

Anyone got a good example of flipping a range of values into columner buckets. I have done this in the past but my solutions always seem so convoluted, it seems I have seen more elegant examples in the past. I want to use decode so it will run on older versions of Oracle. Pseudo Example:

Re:RE: Data Modeling opinion? Help?

Bruce, You are correct, but I've been on both sides of that equation. If the contractor does not keep a good file of their objections I the customer will beat them over the head when I have performance issues. One reason I don't want to be a consultant/contractor any more, your never

RE: Data Modeling opinion? Help?

Exactly. Which is why I am trying to change this now. As for the previous comment, they do not pay me to beat them over the head, BUT they do pay me to do what is right. -Original Message- Sent: Tuesday, July 24, 2001 1:29 PM To: Multiple recipients of list ORACLE-L Yes, but

Re: what do I tune?

Hi, itrprof SQL Analyzer can do what you asked. itrprof: http://www.unal-bilisim.com/products/itrprof/itrprof.html 24/7/01 06:56:29, Gene Gurevich [EMAIL PROTECTED] wrote: Hi all: I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several (up to

RE: Need SQL Example

I think you use sign eg the above will work for integers at least and just requires the the lower and upper values of the ranges plugged in. I'm sure it could be adapted for real numbers but hopefully this will do select sum(decode(sign(:value - (0-1)),1,decode(sign(:value - (64+1)),-1,1,0),

Re:RE: Data Modeling opinion? Help?

Chris, True, except when I as the customer change the specs. Then what is right is what I say. Or as a Program Management instructor told the class As it is written, so let it be done. Dick Goulet Reply Separator Author: Grabowy; Chris [EMAIL

RE: RE: Data Modeling opinion? Help?

Hmmm...when the spec is changed because of some business requirement then that's fine. But when it's changed because your own designers cant argue the design on technical merit then what? A spec should quote all the business rules, and some high level details about the overall architecture of

RE: Data Modeling opinion? Help?

Over the past 17 years, I have been on both sides of this fence. Right is defined by the gods that be. I know, because I have fought the fights. I have been the person having to live with the system left by consultants that designed the system right and they were backed by my manager

Re: system switch off

Just add something, I am using following script to track SPID of such processes and kill them using kill -9 SPID. Sometime it releases oracle session immediately or take a while for rollback. Any how to make sure at sql level , same may be killed at sql level using relevant sid, serial

how to run explain plan on SP???

Hi, Can anyone show me how to run explain plan on a whole stored procedure? 815 on Sun 5.6. Thanks a lot. Leslie __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please

RE: Data Modeling opinion? Help?

It goes with the territory. Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL

RE: Data Modeling opinion? Help?

Chris: You have to remember that you are there as a consultant, as a value add to the client's business, not to argue with them. If they choose to do something different than what you recommend, that's their choice. I agree with what others have said: document, document, document. That way if

Oracle/AIX 64 bit

Guys/Dolls - Are you using 64bit oracle on AIX? Was it a reasonable install? Any gotchas? Notice anything about performance.? ANY comments at all most welcome. Thanks! - Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL

RE: Update ALL colums without knowing their name??-correction

Hi, Thank you for your answer. Unfortunatelly I can't truncate, then insert into ... select ( I myself thought about it before )because the tables are always used ( there are always a few users connecting to database). Thank you Zsolt Csillag Hungary At 13:52 2001.07.23. -0800, you wrote:

Re: Urgent: ORA-03113

You missed some of the parameter or environmental settings. --- Sadzakovic Slavica [EMAIL PROTECTED] wrote: Red Hat 6.2 Oracle 8.1.6.1 192MB of RAM While running dbassist, ORA-03113 EOF on communication channel appears (progress bar shows between 65% and 75%). What might be

RE: Sun cluster vs Veritas cluster

I have used both and somewhat prefer VCS. In both systems, we've had problems where the cluster was in an unknown state and any action to change the state was risky to all the services in the cluster. This is rare for both products. Our Sun support required for us to pay them to certify

OEM Data Gatherer question???

Hi, I installed both OEM 204 Tuning Pack and Diagnostic Pack, TP runs very fine. But when I tried to connect to DP's Performance Mananger, I got message VTM 0005 and Data Gatherer is not running. What is this Data Gatherer? and how to run it? Thanks a lot! Andrea

RE: A lazy connection!

Thank you friends, But we finally figured out. Actually the OUT parameter is procedure is useless as Shailesh pointed out , there is no variable to put the OUT value in auto-execute. So this is what we did. Kept the OUT parameter ( we could took it out but developer insisted to keep it as they

RE: Data Modeling opinion? Help?

Don't get me wrong. I understand that completely. I have spent my whole career as a consultant. There are good things and bad things. I have, in the past, refused to go back to one particular client, but then again so did the whole staff that was done there at one point in time. For the most

Oracle on Hitachi 9900 series

Hi List, I am looking for some suggestions about tuning hitachi storage systems for Oracle databases. We are using Hitachi 9960 with Veritas volume manager and UFS file system. I am particularly looking for this information - What type of configuration are you using ie RAID1 / RAID5. What

rollback and free list contension

Hi let me know if some one have script to monitor rollback segment contension and free list contension then can u please send it. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp --

  1   2   >