Out of topic :Compare 2 data files in unix

BDY.RTF Description: RTF file

RE: SEQ#, DUAL and Oracle literacy

The problem seems to be with the preferred ven-duh ! Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Tuesday, 18 June 2002 12:07 PM To: Multi

RE: IBM AIX & Shark storage?

James We use Shark internally, connected to AIX, Solaris and Windows servers. Much better than Hitachi IMO. The caching mechanism is similar to EMC, and the IO performance is excellent, even with RAID5. Actually I am told it is RAID-S, but it is all a black box to me. I just know that my DSS DW D

RE: Exp & Imp & User ?

This will get you started. http://tahiti.oracle.com/pls/tahiti/tahiti.drilldown?remark=&word=Create+use r&book=a85397&preference= http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76955/ch01.htm#17082 http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/s

Re: Exp & Imp & User ?

RTFM http://tahiti.oracle.com -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094

RE: Once again : Oracle vs Sql Server

I guess this is the link u were talking abt. http://www.eweek.com/article/0,3658,s=1869&a=27379,00.asp also had fun in reading http://gotdotnet.com/team/compare/oraclerespond.aspx -Original Message- From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] Sen

Re: Once again : Oracle vs Sql Server

Any "non-biased" study would have to be so generic as to be essentially useless, like the TPC benchmarks. That said, there was something recently in PC Magazine's online version that compares a number of databases doing some general tasks. For the most part anything of any use that was published w

RE: Exp & Imp & User ?

All your questions are clearly answered in the Oracle Utilities Guide. Available (Free) at http://tahiti.oracle.com/pls/db92/db92.homepage?remark=tahiti. Try it. - Kirti -Original Message- Sent: Tuesday, June 18, 2002 11:33 PM To: Multiple recipients of list ORACLE-L I want to kn

Re: Exp & Imp & User ?

RTFM Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 18 Jun 2002 20:33:20 -0800 I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after cre

RE: what is the latest db that will support ***CLIENT-SERVER*** "

OTS says: "Client-server developer 6i products are certified and supported on 9i(9.0.x) database from patchset 5a onwards. It is recomended to use latest patchset. " What that means, I have no idea, but I'm asking. Note that on another related TAR, they said that developer

Re: Online vs offline backups

I wrote a little snippet that should answer at least some of your questions. Let me know if there's anything unclear in there: http://www.speakeasy.net/~jwilton/oracle/baseline-cold-backup.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 18 Jun 2002, Tracy Rahmlow wrote: > If

Exp & Imp & User ?

I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the n

RE: SEQ#, DUAL and Oracle literacy

Sure !! :) I think the DBA suggested that the Duhveloper reads Chapter 1 from Tom Kyte's book, if not anything else. I volunteered to read it to them using my own copy ;) I would love to do that!! My boss has read a few chapters from this book (upon my request) and is using his new found Oracle

Free buffer requested

Hi list, Scenario Sun 880 Solaris 8, Oracle 8.1.7.3, 8GB Ram, 4 processors Redo logs 200MB size 4 groups in 1 disk DBWriter = 2 log buffer 200 BM Shared Pool 1 GB db block buffers 100,000 db block size 8K I started a process and checked the V$sysstat and get those values are extremely high fr

Online vs offline backups

If you create a new database and do a full online backup (this also includes future regular full online backups) is it ever necessary to do a full offline backup? I have heard conflicting answers, regarding this and am looking for some clarification. Don't 24x7 applications always have to execut

RE: Free Buffer Waits

Obviously, you have something in your system competing for resources. There are multiple sessions requesting the same block. Everything seemed to run fine and now all of a sudden things dont work , but nothing new has been introduced into the system. How can this be ?Perhaps you have oth

RE: RE: Advance Oracle Trigger Writing Advice

Title: RE: RE: Advance Oracle Trigger Writing Advice Hi Hannah, I think you could use a simpler feature to brute-force a trace of your trigger's execution path.  The SYS.DBMS_SYSTEM.KSDWRT procedure provides output facilities for the alert.log and session trace files.  SYS.DBMS_SYSTEM.KSDWR

RE: Once again : Oracle vs Sql Server

Stephane - The closest I've seen is the eWeek benchmark. It actually put the databases head-to-head on the same server. I don't have the URL handy, but you can probably go to www.eweek.com and browse around. However, ultimately the issue comes down to your situation. For example, MSSQL only runs o

RE: autostart 8.1.7 intelligent agent on Solaris

the latter -Original Message- Sent: Tuesday, June 18, 2002 9:08 AM To: Multiple recipients of list ORACLE-L trying to set up the intelligent agent to autostart on unix . . . if it's already running and I save the listener config (lsnrctl save_config) does that save the agent config, to

RE: Once again : Oracle vs Sql Server

No. -Original Message- Sent: Tuesday, June 18, 2002 3:28 PM To: Multiple recipients of list ORACLE-L Hi all, Any non-biaised study between Oracle and Sql Server available ? TIA = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EM

RE: Question regarding Oracel Financials CD Pack

Thanks RON, I shall update him now ... -Original Message- Sent: Tuesday, June 18, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Apps 11.5 is purely web/java based. There is no client install except for the java applet. That said, if they are going to use other tools such as

Once again : Oracle vs Sql Server

Hi all, Any non-biaised study between Oracle and Sql Server available ? TIA = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo

RE: SEQ#, DUAL and Oracle literacy

Here's a performance tuning query to help identify the problem: SELECT column_name "The problem is the..." FROMdba_tab_columns WHERE owner='SYS' AND table_name = 'DUAL' / :-) -Original Message- Sent: Tuesday, June 18, 2002 2:13 PM To: Multiple recipients of list ORACLE-

FW: Extremely slow query

> It's not consistently waiting on anything. I'm running the scripts from > Perf Tuning 101 (Chapter 2) as this executes. > This session shows these waits: > > Total Time > Avg >SID Username EVENT Waits

Re: Question regarding Oracel Financials CD Pack

Apps 11.5 is purely web/java based. There is no client install except for the java applet. That said, if they are going to use other tools such as ADI, etc, then sqlnet will need to be installed on the client machines. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] "The problem with some people

RE: SEQ#, DUAL and Oracle literacy

My deepest condolences... -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'pre

RE: Reverse Engineering Triggers

Title: RE: Reverse Engineering Triggers Steve, I don't have a handy script, but if you're using 9i, you could easily create something that just spools the output of select dbms_metadata.get_ddl('TRIGGER',trigger_name) FROM USER_TRIGGERS; then just run the spool file -Original Messag

Re: Reverse Engineering Triggers

Steve, Here is a korn shell script I use. It also looks at dba_trigger_cols. I was trying to do the same thing a while back, but most of the scripts I found didn't look at dba_trigger_cols. This view becomes important if a trigger does something like 'before update of on '. I will also use e

RE: SEQ#, DUAL and Oracle literacy

So did you fix it? -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred

Question regarding Oracel Financials CD Pack

Hello ALL, The Following is a mail from my friend , I do not have answer for it.. do anybody have , pl share with us ... Thanks in advance Madhu > -Original Message- > From: Pai, Ashish > Sent: Tuesday, June 18, 2002 1:33 PM > To: Reddy, Madhusudana > Subject: Ques

RE: SEQ#, DUAL and Oracle literacy

I'm at the complete bottom of Oracle knowledge and even I know what the dual table is. Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so th

SEQ#, DUAL and Oracle literacy

Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you th

Reverse Engineering Triggers

Anyone have a handy-dandy script to create a script which recreates triggers? (By querying user/dba_triggers.) Member of the Wheel Reinvention Prevention Society, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City N

RE: Something that may be of interest

Well, you could run Linux as the primary OS and use VMware for Linux to run Outlook/Exchange and other Windows only app. I am currently doing the same thing as you do, but I am thinking about doing the above. -Original Message- Sent: Tuesday, June 18, 2002 1:19 PM To: Multiple recipients

Re: Extremely slow query

I have the exact same explain plan when I run it, and it takes 2 seconds for me. What is this session waiting on? What are the system waits? Check v$system_event, v$system_wait, v$session_event, and v$session_wait. >From: "Bunyamin Karadeniz" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED]

RE: Needed information on Data security

Checkout 'Oracle Encryption Articles and Code' at http://www.cybcon.com/~jkstill/util/. There is very nice information on this topic. - Kirti -Original Message- Sent: Tuesday, June 18, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Hi, Is anybody using dbms_obfuscation_toolki

Uninstall Patch

List, Is it possible to Unistall Patch4 from 8.1.7.4 on sun solaris, We have an application running on 8.1.7.0 but when we upgrade to 8.1.7.4 the application can not retreive data from a table with long column format. I realy appreciate if any clue? Hamid Alavi Office 818 737-0526 Cell818

RE: autostart 8.1.7 intelligent agent on Solaris

You have to manually put the line "lsnrctl dbsnmp_start" in your boot rc script. Even though lsnrctl is used to start the agent, the agent appears to be an entirely separate product. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, June 18, 2002 9:08 AM T

RE: V$SQLAREA vs. V$SQLTEXT

Well I'm unclear about the inconsistent wording in the docs: "V$SQLTEXT This view contains the text of SQL statements belonging to shared SQL cursors in the SGA." "V$SQLAREA This view lists statistics on shared SQL area and contains one row per SQL string. It provides statistics on SQL stateme

RE: How to extract data from existing table to csv file.

I'd use MS access using an ODBC linked table and save the data to a csv file (I know you said sqlplus). Regards, Waleed -Original Message- Sent: Monday, June 17, 2002 7:38 PM To: Multiple recipients of list ORACLE-L Hi All, Could anyone tell me how to get data from existing table as

RE: OID

On Windohs, you'll need to install the GNU-licensed CygWin (http://www.cygwin.com) in order to use the Unixy shell scripts. I've tried this at home, and the scripts worked exactly like they do on Linux. Note that doesn't mean they always work *correctly*, they just work the same. HTH! GL! Ric

MEMORY LEAKAGE

Hi How to check memory leakage on SUn box.I used sar -k command.Is any other way to check memory leakage? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ

Multiple LOADS on kept objects?

Hey all, While looking at V$DB_OBJECT_CACHE in a 8.1.6.0.0 on Solaris 2.8, I noticed that a couple of the objects kept via STARTUP TRIGGER have multiple LOADS. The objects are the SYS.DBMS_OUTPUT and SYS.DBMS_APPLICATION_INFO packages, but not the package bodies. I know that a load can occur if

RE: Something that may be of interest

I run Linux on the laptop using VMware. Works great but I still have Win2K as the primary O/S. The only thing keeping me enslaved the the MS Monopolistic Meast is a dependence on Outlook/Exchange. Since Lindows claims to be able to run Outlook my interest is piqued. Oh yeah, another dependence on

Needed information on Data security

Hi, Is anybody using dbms_obfuscation_toolkit for encrypting the data for encrypting the data in the database. How is the performance after enabling this,Can you please let me know the Pros and cons of this package. Or is there any other way u people are encryting the data,Please let me know We ar

RE: On delete cascade

Title: RE: On delete cascade Stephanie, wouldn't it be easy enough to find out what is referencing what?  If the developer doesn't know, just ask the DBA.  If the DBA doesn't know, then time to find another one.  The use of ON DELETE CASCADE is commonly use to maintain data integrity, so unles

RE: IBM AIX & Shark storage?

we are using Shark (prod) as well as Hitachi (development). Yes, Shark is Raid 5, and so was our Hitachi. Shark is better. We haven't seen bad performance hits, but we are not transactional, we are read only there. SQL-Loader loads run the same regardless of shark or ssa though. April Wells -

Re[2]: Something that may be of interest

Now us MicroSlop bashers have an alternative. I love it!! Now I just hope that both companies survive and end up with a 50/50 split on the desktop/laptop/palm market. Then with real competition we might get interoperability & innovation. Dick Goulet Reply Separator___

RE: V$SQLAREA vs. V$SQLTEXT

Did you join these tables by HASH_VALUE to other tables (or to each other) and discover that quirky bug relating to the 32 bit arithmetic? HASH_VALUE in v$sqltext is signed whereas HASH_VALUE in v$sqlarea is unsigned. This can cause joins to fail. Check for negative HASH_VALUE in v$sqltext. htt

RE: How to extract data from existing table to csv file.

Title: RE: How to extract data from existing table to csv file. create an sql file like this (do_csv.sql): set heading off set space 0 set pages 0 set linesize 0 set echo off set feedback off spool my_csv.csv select '"COL1","COL2"' from dual; select '"'||col1||'"'||','||    '"'||col2||'"

Re: Something that may be of interest

Even neater! I may have to get a home computer after all. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 17, 2002 7:13 PM > Some screenshots: > > http://www.lindows.com/lindows_products_screenshots.php > > -Original Me

Re: Something that may be of interest

Neat ! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 17, 2002 6:28 PM > Jared & All, > > My apologies for posting something that is a little off topic, but at least > I'm short on words. Check out

RE: V$SQLAREA vs. V$SQLTEXT

Not sure - but could it be that if the statement fits entirely in to the V$sqlarea.sql_text field (varchar2(1000))? -Original Message- Sent: 18 June 2002 17:21 To: Multiple recipients of list ORACLE-L Can a statement be in V$SQLAREA and not in V$SQLTEXT at the same time? -- Please see

Re[2]: RE: OCP newsletter, latest changes...

Jared, Just turned to my Network Guru who is chasing the Cisco cert. There are three tests at $100 each and then the 2 day practical which is $2,000. Dick Goulet Reply Separator Author: Jared Still <[EMAIL PROTECTED]> Date: 6/18/2002 6:03 AM

autostart 8.1.7 intelligent agent on Solaris

trying to set up the intelligent agent to autostart on unix . . . if it's already running and I save the listener config (lsnrctl save_config) does that save the agent config, too? or do I have to manually put the line "lsnrctl dbsnmp_start" in my boot rc script? thanks bill -- Please see the

IBM AIX & Shark storage?

DBA's Anyone using IBM's Shark storage solution? What is you're opinion? I understand it uses raid 5 :-( with a big cache in front. I've talked to a couple of DBA's that are using them and they think they are great and haven't experienced any problems with poor performance (including write spe

V$SQLAREA vs. V$SQLTEXT

Can a statement be in V$SQLAREA and not in V$SQLTEXT at the same time? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

Oracle developer openings in San Diego

If there are any current or former Pergrine employees reading this list, feel free to contact me off list for Oracle developer openings at my shop. Also non-Pergrine employees are free to contact me because we have at least two Oralce developer openings. Maintenance Warehouse is a profitable and

Unable to obtain requested swap space

Hi DBAs and GURUs, Could you please explain me what does below message means? we got a box and it needs to be tuned. server : Digital OSF1 V4.0 878 alphaOracle7 Server Release 7.3.4.0.0 with the 64-bit option Currently Oracle shared memory segment is loaded in multiple shared memory segments and I

Re: RE: OCP newsletter, latest changes...

This new certification test sounds similar to what Cisco does, and Cisco certification is highly regarded among networking folks, as you must know what you're doing to obtain certification. As I recall, it takes a couple of days to get through it all. Anyone know what the Cisco tests cost? Jar

Re:legislative audit

One of the two star generals I had the priviledge of working for at Wright-Patt had a plaque on the wall of his office that read (if memory servers correctly) "Public monies must be handled with the most pristine of hands, the utmost of integrity, and the cleanest of consciences." ___

Re:a simple question about FKs

Gene, In the event of a delete from the parent Oracle has a chance to check the child table(s) to see if the parent is still valid. But since a truncate is really a DDL, not DML, command there is no such chance. Therefore if you want to truncate a table you have to disable the foreign keys.

Re: How to remove Lock on a Table

Interesting. Next time you need to kill a session, how about using ORAKILL to kill the thread. and see if you get better results. The process ID column in v$process is the thread# on Win2k. Jared On Tuesday 18 June 2002 00:18, Alexandre Gorbatchev wrote: > Hi, > Looks the same for 9.0.1.3 on

RE: RE: OCP newsletter, latest changes...

In the U.S. employees can deduct business expenses? Here in Canada it is only possible for self-employed individuals (i.e. contractors), with some exceptions for taxi drivers, sales people, waiters/waitresses etc. Unless you have a letter from your manager re. training not possible, I wonder how

Re: OCP newsletter, latest changes...

Nothing surprising. Oracle is so big that "one head doesn't know what another head does." At least when they don't have to certify pieces together 8-) The only problem with current Oracle GUI is Java... from another point, this makes (ok, suppose to) the same GUI working on differnet platforms. I

Re:RE: On delete cascade

Fawzia, I'm going to disagree with just about everybody on this one. Assuming, and that is a BIG assumption, that the parent and child relationships have been properly established there is no real good reason not to use 'on delete cascade'. I've one &^%$ duhveloper who does not want to use

Re: a simple question about FKs

You did it right. It's just the way oracle works. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 9:43 AM > Hi. > > I was trying to truncate a table, which is a parent > to two ot

Re: a simple question about FKs

Hi Gene, You cannot truncate a table that is a parent in enabled FK constraints. You did the right thing. or you can simply delete (of course longer) with enabled constraints. -- Alexandre > Hi. > > I was trying to truncate a table, which is a parent > to two other tables (its PK is referred to

RE: New buzz-word?

Uhhh... call it denormalization. :-) -Original Message- Sent: Monday, June 17, 2002 8:38 PM To: Multiple recipients of list ORACLE-L i thought it was do do do do <--- 4 times joe Orr, Steve wrote: > 9th normal form must be another dimension is space and time or the > Twilight Zone

RE: OCP newsletter, latest changes...

That explains it. We're just paying the license fees for the test software. :) -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- Sent: Monday, Jun

RE: OCP newsletter, latest changes...

Can I get an Amen??? :) -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- Sent: Monday, June 17, 2002 9:38 PM To: Multiple recipients of list ORACLE

RE: a simple question about FKs

> >Hi. > >I was trying to truncate a table, which is a parent > >to two other tables (its PK is referred to by two >FKs >from two other tables). These "other" tables are >empty. >When I tried to truncate the parent table, however, >I >got an error message ORA-02266: unique/primary keys >in >table

a simple question about FKs

Hi. I was trying to truncate a table, which is a parent to two other tables (its PK is referred to by two FKs from two other tables). These "other" tables are empty. When I tried to truncate the parent table, however, I got an error message ORA-02266: unique/primary keys in table referenced by en

RE: RE: OCP newsletter, latest changes...

Hey folks. I just saw this thread this morning. What a crime. It seems that the only way Oracle can generate sufficient streams of revenue is to punish those that popularize their software for the market. As an Oracle DBA and IT Manager, I will not pay for any of my staff to obtain a certifi

RE: dedicated sessions

My experience is that MTS is fine until you get into the 400 - 500 concurrent user range, and then it goes to hell in a hand basket. The CPU usage itself will not be very high, but that is because MTS under heavy load precludes the DB from doing any useful work, as it spends a lot of its res

RE: change Language on server after Oracle install

Ok, final word on this. I transferred the language files required for French, some of the messages appeared in French but not all. I updated my TAR, final word is: 17-JUN-02 20:02:53 GMT Hi Patrice, I just finished verifying that unfortunately the only way to do what you want is to reinstall

RE: On delete cascade

>From: "Malik, Fawzia" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Tue, 18 Jun 2002 03:38:25 > > >Hi Gurus, > >I have just been told by a colleague that I must >not use "On delete Cascade" >as for sure it could have serious negative >implica

Re: On delete cascade

Hello Fawzia, What exacltly these "serious negative implications" are? Basically, any implementation of transparent cascade deleting can cause problems. Like unintentional data loss, locking problems, mutationg table problem. Another transparent procedure may be implemented using triggers. Howeve

RE: RE: Advance Oracle Trigger Writing Advice

Hi, The problem is fairly complex and I am unable to reproduce it by manually feeding in the statements of the suspect transaction. Both statements hit triggers which use autonomous transactions to do things. Its the second statement that fails and I am unable to tell if something in

RE: RE: OCP newsletter, latest changes...

Here in Canada I was told you can do it if you have a letter from your employer stating that they are unable to provide you with the training you require to stay up-to-date in your field. I asked my previous manager if he could write me such a letter, he just grinned and said: "well, it should be

RE: what is the latest db that will support ***CLIENT-SERVER*** "

Eric, 9i WILL and DOES support 6i client, it is only Forms/Reports 9i deployment in client-server environment, which is not supported. Until 2008 you can continue to use Forms/Reports 6i with 9i, unless of course they de-support it in Oracle 25i. Raj ___

Re: OCP Related

Hi Santosh,   At the time I needed this material, I didn't find anything valuable in the internet for free. Maybe coz DBA's don't have much free time except for books (which is paid). Maybe reasons are different. :) My advice: nothing better buying good OCP book for 50$. that's 10% of what y

RE: How to compare data between two tables

MINUS, INTERSECT ? Pick your weapons. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia -Original Message- Sent: Monday, 17 June 2002 4:08 PM To: Multiple recipients of list ORACLE-L I have two tables which have the same

On delete cascade

Hi Gurus, I have just been told by a colleague that I must not use "On delete Cascade" as for sure it could have serious negative implications We need to be able to remove an entry and to avoid writing a script (deleteing children then parent) I was just doing to set the above... Anyone have

Re: dedicated sessions

Hi,   you have lower memory requirement with shared servers. It may also improve performance in case dedicated connections take so much memory that it goes to use a swap. Guidelines - use dedicated connections if you have enough memory to hande them or if connections are always active. If ea

RE: RE: Advance Oracle Trigger Writing Advice

Hanna, I still have a fairly confused view of what your problem is and how you plan to solve it. Jean is right about the solution - autonomous transactions are the easier way (dbms_pipe is the other one) to ensure that you will not lose any track of your debugging information even if the tr

Re: I/O contention with external process reading the oracle logs (online redo logs)

Title: RE: I/O contention with external process reading the oracle logs (online redo logs) Thanks to all of you for the input. The suggestion of sending the log files and checking the size of the resulting Shareplex output is very good.   I talked today with the sales person and she will put m

Sqlplus hangs when using 8.1.7 db against 9.2 listener

Hello! Have you faced this kind of error: I am using win2000 and I have installed on that server both 8.1.7 and 9.2.0 oracle versions. Now I have listener92 up and running. I am able to connect mine 9.2 instances without problem (with sql*net) but when I am trying to connect 8.1.7 instance,

Re: how to determine the character set in the export file of oracle

You can see the character set in the export log file. I browsed one of my exports (816 on NT) and did not see any indication of character set in the export file itself. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, Ju

Re: dedicated sessions

Hello Bp   The topic was discussed on the list some time ago. The trade off seems to be memory vs. CPU. If I recall correctly MTS use more resources and dedicated connection use about 3MB for each connection on NT.   Yechiel AdarMehish - Original Message - From: BigP To: M

OCP Related

could any one of you tell me the sites where OCP related materials are available and where i can give free tests for readying for OCP exams ? Thanks and regards,Santosh  

Re: Advance Oracle Trigger Writing Advice

Hello Hanna Why do not write the data that you want to output to your own table. Give everyone insert permission and the trigger will write the data. Later you can query it and see the output. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROT

how to determine the character set in the export file of oracle

Hi List, I keep on taking exports from oracle on one machine and import the data from the export file onto anothermachine . I usually face a problem of character set conversion due to which import fails. So I have to take the export from the same machine by making a Net8 entry point to that serve