Re: New year humor

Chanukah is a Jewish holiday that is celebrated about the same time as Christmas. It depends on the differences between the Jewish calendar and the Christian one. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 06,

RE: RE: New year humor

- Original Message - From: Sinardy Xing [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sun, 05 Jan 2003 20:28:36 Ha ha ha... but what is Chanukah? Jewish Diwali :-) Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ:

Help with IMPort

I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the data nor capture some change made directly to the table structure of the first ones. Thanks --

The best method for scheduled work

Hi, I want to move ( insert into select and than delete from ) some records of a table to another one at midnights. It would be very nice if it has logging facility. Do you have any good documantation about * scheduled triggers * executing time based queries using sqlplus Thanks in

RE: strange issue with setting transaction

Hi Sony, Commit will slow down your script. (I mean use the reasonable number of transactions per commit) Perhaps you can set your Rollback segment optimal value to null. Your rollback will never shrink : ) Sinardy -Original Message- Sent: 06 January 2003 10:09 To: Multiple recipients

RE: Help with IMPort

Hi Raja Kumar, If you don't know what are the differences use the parameters touser and fromuser During importation Oracle will recreate those tables I think if you not use the ignore = y you will get error message since Oracle cannot insert due to different table structure Just guessing If

Re: Help with IMPort

The best method that I know is: 1) export from production. 2) drop user cascade in development or at least drop all tables. 3) create user in development. 4) import into development with indexes=n and constraint=n. 5) import again into development with rows = n and ignore = y. Step 4 will build

Re: Samba , Write Access , Linux

www.samba.org Raymond Lee Meng Hong wrote: Hi friend My colleuge after installing Application Server and my database in a red hat linux 7.3 and resign , It leave me no clue on configure a samba folder in application server. But i don't have any idea on configura those folder as

No logging question

Hi All, I want to avoid generation of archivelogs against all the DML applied to some tables. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: functions/procedures and commits

Hi John Dunn, My answer is never commit, Oracle will rollback. Are you consider auto commit an implicitly commitment? Sinardy -Original Message- Sent: 02 January 2003 22:14 To: Multiple recipients of list ORACLE-L Under what circumstances is a COMMIT done implicitly? If I call

RE: The best method for scheduled work

Hi Murat Balkas, 1. Perhaps you want to play around with Oracle's sysdate from dual? 2. If I am you, I will prepare my sql script then using cron (unix) to execute it (Windows has it's own version of scheduler program come with OS) I believe most OS equip with scheduler program Good luck.

Unix for oracle dba -- Suggest a book ?

Guys, i know a bit of Linux.and not completely a newbie to Unix. Can u suggest me a good/best book for Unix ? ..Unix for oracle DBA. i.e,tuning unix for good performance of oracle. any such book available ? kindly let me know guys. TIA. Jp. -- Please see the official ORACLE-L

IOUG-A

I've finally managed to fit IOUG-A into my timetable, after years of thinking that I really ought to go some day. I see from the 'University Class' listings that no-one is doing anything about specific on how the cost based optimizer works. Two questions - If I found some place in the locale

RE: No logging question

As Far as I know, you can't stop the normal DMLs from getting logged. You can create table using NOLOGGING clause, but then only the SQLLOADER DIRECT PATH LOADS and DIRECT PATH INSERTS will not be logged. normal DMLs will still be logged Regards Naveeb -Original Message- Sent: Monday,

AW: Unix for oracle dba -- Suggest a book ?

Hi oraora I like this one as a general (but in depth) one for Unix Admins, because it has lots of real life stuff: Paperback: 896 pages ; Dimensions (in inches): 1.30 x 9.23 x 7.06 Publisher: Prentice Hall PTR; ISBN: 0130206016; 3rd edition (August 2000) Also this little booklet for Oracle

Re: Unix for oracle dba -- Suggest a book ?

Oracle8i and Unix Performance Tuning by Ahmed Alomari --- oraora oraora [EMAIL PROTECTED] wrote: Guys, i know a bit of Linux.and not completely a newbie to Unix. Can u suggest me a good/best book for Unix ? ..Unix for oracle DBA. i.e,tuning unix for good performance of oracle.

Re: MTS / Dedicated

S Anandan, I think for 75 connections, dedicated server is good enough. 75 connection is nothing for a database, and you said your user never idle at any time, so dediacted server is better . Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net

Re: AW: Unix for oracle dba -- Suggest a book ?

Stefan, would you mind posting the names of the books, as well as the authors? :) Rachel --- Stefan Jahnke [EMAIL PROTECTED] wrote: Hi oraora I like this one as a general (but in depth) one for Unix Admins, because it has lots of real life stuff: Paperback: 896 pages ; Dimensions (in

RE: Unix for oracle dba -- Suggest a book ?

This is the latest one that I've seen. I have it and the parts that I've read are good. http://www.amazon.com/exec/obidos/ASIN/0072223049/qid%3D1041862110/sr%3D11-1 /ref%3Dsr%5F11%5F1/103-3312873-7713423 Oracle 9i UNIX Administration Handbook, by Don Burleson (ISBN 0072223049), 2002 David

max open files

Hi, Do you know about any limits for max. open files concerning use of utl_file. I'm writing a plsql program to dum several tables and make use of utl_file. I'm getting invalid operation when opening 12 files sequentially and when I rewrite the program to do this only when needed it disappears.

audit user activities

Re: Unix for oracle dba -- Suggest a book ?

I've found a wonderful resource in the following book: Oracle DBA on Unix and Linux by Michael Wessler http://www.samspublishing.com It covers some of the differences in features between 8i and 9i as well as handling the specifics of administrating Oracle specifically on Unix platforms.

encrypted user/passwd connection

RE: Automatic backup on Oracle 9i -- For Jared

I should have mentioned that another useful one could be QRM. QRM = I am experiencing interference. QRM? = Are you experiencing interference? Look across the table at your DBA-mates during your next meeting with management and say or ask QRM(?). Or blink your eyes. --.- .-. --

RE: Statspack Viewer

http://www.geocities.com/alexdabr/ George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: 082 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web:

RE: Statspack Viewer

What is the URL for this product? RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: AW: Unix for oracle dba -- Suggest a book ?

Thanx Stefan. can u mention the title of the book please ? i would like to buy it as soon as possible ! TIA. Jp. On Mon, 06 Jan 2003 Stefan Jahnke wrote : Hi oraora I like this one as a general (but in depth) one for Unix Admins, because it has lots of real life stuff: Paperback: 896 pages ;

RE: Unix for oracle dba -- Suggest a book ?

A second book you will find very helpful is from Sun... Configuration and Capacity Planning for Solaris Servers. Also, my Unix bookshelf has the following references.. The New Kornshell - Bolsky Korn PERL in a Nutshell - Siever sed awk - Dougherty UNIX Programming Tools - Johnson UNIX

RE: No logging question

If you use the NOLOGGING option, you still generate redo entries (which become archive log entries). Even if the DML is not logged, the generation of UNDO is still logged for rollback purposes. -Original Message- Sent: Monday, January 06, 2003 2:34 AM To: Multiple recipients of list

RE: encrypted user/passwd connection

WOW! This Encryption was GOOOD!! Happy New Year! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrey BronfinSent: 06 January 2003 13:44To: Multiple recipients of list ORACLE-LSubject: encrypted user/passwd connection

RE: Help with IMPort

To fine tune the suggestions aready made, you probably don't want to drop all the table but just tables both in production and development/test. I would create a list of tables exported from production via export / show and use this to create a drop table script. Mike -Original

Re: Unix for oracle dba -- Suggest a book ?

Doesn't anyone read the manuals any more?! Oracle9i Installation Guide - Unix http://download-east.oracle.com/docs/html/A96167_01/toc.htm Oracle9i Administrator's Reference - Unix http://download-east.oracle.com/docs/html/A97297_01/toc.htm

RE: audit user activities

Dear list ! I need to audit / log several activities of users against the DB . I need to trace a user's login/logout as well as DML operations on certain tables. I understand that there are more than one way to achieve these. Could you please share your experiences / tricks on the matter. Thanks

RE: Statspack Viewer

http://www.geocities.com/alexdabr/ I have not seen any comments about this product from anyone yet. I am not sure if it is too new, unknown or what. Again, I am looking for any comments from anyone who has used or evaluated it. Thanks Please respond to [EMAIL PROTECTED] Sent by:

Sun HA Monitoring and Oracle 9

Here's a little background. We are currently running Oracle 8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster. We use HA monitoring for failover, in case there is a problem with any of the nodes. The version of HA is 2.2. We installed Oracle 9.2.0.1 on the cluster and created a new database

RE: audit user activities

I seem to be drawing a blank on this one. -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 8:19 AMTo: Multiple recipients of list ORACLE-LSubject: audit user activities

Re: Statspack Viewer

http://www.statsviewer.narod.ru/ Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 06, 2003 9:58 AM What is the URL for this product? RWB -- Please see the official ORACLE-L FAQ:

RE: Statspack Viewer

Title: RE: Statspack Viewer It is good, and for me, it is worth the money. 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 ESPN Inc. QOTD:

RE: Unix for oracle dba -- Suggest a book ?

Hallo, What is manuals? TIA -Original Message- Sent: Monday, January 06, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Doesn't anyone read the manuals any more?! Oracle9i Installation Guide - Unix http://download-east.oracle.com/docs/html/A96167_01/toc.htm Oracle9i

RE: encrypted user/passwd connection

LOL :) -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: encrypted user/passwd connection WOW! This Encryption was GOOOD!! Happy New Year! -Original

RE: Database/system Crashing

Title: RE: Database/system Crashing Yes there are NFS mounts involved. What you said about the OS locks on the audit directory makes a lot of sense. My SA's are back to thinking it's a OS problem because it crashed again with the database shut down. The odd thing is that there is nothing

RE: Unix for oracle dba -- Suggest a book ?

I like this one as a general (but in depth) one for Unix Admins, because it has lots of real life stuff: UNIX System Administration Handbook (3rd Edition) Paperback: 896 pages ; Dimensions (in inches): 1.30 x 9.23 x 7.06 Publisher: Prentice Hall PTR; ISBN: 0130206016; 3rd edition

RE: Unix for oracle dba -- Suggest a book ?

And if you are running on Solaris, get Solaris Internals from Sun. Unix System Administartor Handbook is a good Unix book too. -Original Message- Sent: Monday, January 06, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Oracle8i and Unix Performance Tuning by Ahmed Alomari ---

RE: IOUG-A

Hi Jonathan, As I am not from that area, I won't comment. However, it would be a nice opportunity to meet the Guru! John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Help with IMPort

You will need to apply the structural changes before importing for existing tables. If you want to make a test db as copy of original one try cloning! It is easy and quick. --- [EMAIL PROTECTED] wrote: I have 2 8i database out of which one is production and the other is for development and

RE: Sun HA Monitoring and Oracle 9

Scott - My sys admin is out today, but I believe he found TeamQuest to be a better tool. He was getting hints that Sun may switch to that product as their standard. Just consider this an unconfirmed rumor. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-

RE: Unix for oracle dba -- Suggest a book ?

If you want to understand how Oracle uses Unix get a copy of James Morle's Scaling Oracle. It's not a beginner's Unix book but it's accurate and detailed. regards, Mike Hately -Original Message- Sent: 06 January 2003 15:59 To: Multiple recipients of list ORACLE-L Doesn't anyone read

RE: Database/system Crashing

Val - I had a horrible problem using RMAN over NFS. Just hanging. Eventually it turned out that NFS was configured for only a few connections (I can't recall the exact term used). The assumption was that if we were only doing one thing, then that should be adequate. It turned out this needed to be

Prevent FTS

Hi All, I've 3 tables table x,y,z pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is (col_1,col_2) where clause is : where x.col_1 = y.col_1 and x.col_2 = y.col_2 and x.col_1 = z.col_1 and x.col_2 = z.col_2 and y.col_1 = z.col_1 and y.col_2 = z.col_2 and

RE: Database/system Crashing

Title: RE: Database/system Crashing If the database has data files on NFS mounts, then any network problems or problems on the NFS server can crash things. Disappearing NFS mounts can be very nasty. That's why it's a big no-no to putANY files related to the database -- data files, log

RE: IOUG-A

Grosvernor might be a good place. Don't know the price... but it is close (right next to Downtown Disney, and is a very nice Resort Hotel) Cheaper than the Swan and Dolphin... but very nice. 1850 Hotel Plaza Blvd. Lake Buena Vista, Florida 32830 Reservations: 1.800.624.4109 April Wells

RE: Help with IMPort

Amar - I was just thinking about suggesting. And as a bonus, you can test your backups, always a good idea. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 11:10 AM To: Multiple recipients of list ORACLE-L You will need

RE: Database/system Crashing

Title: RE: Database/system Crashing Val, Not having an entry in the alert log or having trace files is not all that odd. This indicates a hard crash of the instance, where the background processes were unable to write to the files. This could be a result of the instance being forcefully

RE: Prevent FTS

Wny do you say that a FTS of table Z is bad? How many blocks has the table allocated (user_tables.blocks)? How many blocks will the query be returning? Is an index read really better? Use hints to test the different access paths and prove it. FTS are not always bad. I have examples where a FTS is

RE: Help with IMPort

Title: RE: Help with IMPort Yeah ... yeah ... but after cloning will you submit the databases for a DNA test to prove that it is a true clone? Oops ... Sorry ... I almost forgot we are talking databases here ... is cloning legal yet? Raj

Re: IOUG-A

If you make the reservation, I will send you the money. All credit cards are maxed, not from Christmas but ... Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 06, 2003 12:39 PM Grosvernor might be a good place. Don't know

RE: Prevent FTS

col_1 and col_2 are primary key columns in all 3 tables. There is no implicit data type conversion. col_1 is varchar2 and col_2 is varchar2 in all 3 tables. col width is also same in all 3 tables. -Original Message- Sent: Monday, January 06, 2003 11:52 PM To: Gurnani, Manoj If an

RE: IOUG-A

Mine are only about 2/3 there... from our trip... but I will make reservation. Preference music-movie or sports? April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Monday, January 06, 2003

RE: encrypted user/passwd connection

Yet another reason HTML isn't a good idea for e-mail. Try a View Source on the message and you'll see: encoded content removed -- binaries not allowed by ListGuru A virus perhaps Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: IOUG-A

Sorry... that was for just Ruth... April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Monday, January 06, 2003 12:18 PM To: Multiple recipients of list ORACLE-L If you make the

RE: Help with IMPort

Dennis, Amar - My interpretation of the environment was that dev/test has a different set of tables, some of the tables match production table names but may not have the same columns or data. In this case, my first suggestion to drop matching table names from dev/test is insufficient. Maybe

Re: IOUG-A

You're making the reservation, you get to choose. But I prefer sports over movies. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 06, 2003 1:35 PM Mine are only about 2/3 there... from our trip... but I will make

RE: No logging question

One option is using the create table unrecoverable as select... While not DML, in some circumstances it can accomplish the same thing depending on your desired result set. It's not a perfect solution. I don't know of anyway off the top of my head to simply avoid generating redo on generic dml

Re: encrypted user/passwd connection

Jesse, Rich wrote: Yet another reason HTML isn't a good idea for e-mail. Try a View Source on the message and you'll see: encoded content removed -- binaries not allowed by ListGuru A virus perhaps Rich Rich Jesse System/Database Administrator

RE: Help with IMPort

Michael - Yeah but the developers are always whining about something anyway :-) Just kidding. Yes, timing of the refresh can be an issue. We are looking toward a staging environment. Now that will be identical to production. Then we can execute a script that will create or modify tables and other

RE: Database/system Crashing

Title: RE: Database/system Crashing I'd agree with Dan. You need to find the root cause of the crash. If you rebuild to the current state from scratch, the odds are you'll see the same problem reoccur. Secondly, while NFS mounted volumes will work, they should always be a last resort as any

RE: audit user activities

Audrey, Are these direct connections or coming through JVM or some other middle tier server where the userid cannot be discerned. You can use the audit statement for SQL statements to look at any of the following: specific SQL statements only system priv statements any statement issued by a

Re: Prevent FTS

[EMAIL PROTECTED] wrote: Hi All, I've 3 tables table x,y,z pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is (col_1,col_2) where clause is : where x.col_1 = y.col_1 and x.col_2 = y.col_2 and x.col_1 = z.col_1 and x.col_2 = z.col_2 and y.col_1 =

FW: IOUG-A

Title: FW: IOUG-A Jonathan, if you do decide to give that class, I am definately interested. $250 I can talk my boss into. $1300 for IOUG-A, I can't. (Ah, the joys of working for a non-IT-centric company.) Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut

RE: No logging question

Welcome to the dark side, heh heh heh ! There is a hidden parameter that will achieve this . it is _disable_logging. Be warned though, if you set it to true, you have lost your ability to recover, and the only way you will recover is with full cold backup and would lose all subsequent work

Are too many Foreign Keys in one table bad?

I am designing some tables to store Customer Support Data. The main table (SUPPORT_DATA) contains many (up to 15) foreign key links to other tables. Most of the other tables are small lookup REFTABLES (eg Priority Type). A few bigger tables store up to 1000 records eg CUSTOMER_DATA. I am

RE: Help with Import

Title: RE: Help with Import Dennis, We do almost the same thing that you described. We have a 140G database. Everyday we *clone* that production database and call it 'DAYOLD'. This database is used by app support to investigate data related issues and bugs. But a day before release, we

RE: Prevent FTS

What is the significance of parameter OPTIMIZER_INDEX_COST_ADJ ? When I tried to change the value the explain plan has changed . alter session set OPTIMIZER_INDEX_COST_ADJ = 10 table access for Z was by index rowid alter session set OPTIMIZER_INDEX_COST_ADJ = 100 table access for Z was full

Prueba

RE: No logging question

Ferenc... You're still kicking buddy. Where are you now? I'm at Avaya in Carrolton, TX, Sr. Tech Lead for their operations group. Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com www.KBMotorsports.biz -Original Message- Sent: Monday, January 06, 2003 1:19 PM To:

rbs' maxextents in LMT

Hi: Oracle 8173 on Sun Solaris 2.8. I am in the process of converting rollback segments from DMT to LMT (to see how much performance we can get, if any). The tablespace size is 8G and I used to create rbs like: create rollback segment RBS00X storage(initial 2048K next 2048K minextents 20

RE: No logging question

It is an all or nothing shutdown of logging however and cannot be applied to a limited set of DML, correct? Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com www.KBMotorsports.biz -Original Message- Sent: Monday, January 06, 2003 1:19 PM To: Multiple recipients of list

RE: Database/system Crashing

Title: RE: Database/system Crashing Val, Sorry I missed the previous messages. Was this a Sun platform? Did the system crash with a CPU panic in /var/adm/messages? We resovled a Sun NFS related crashes a couple of months ago. Richard Ji -Original Message-From: Webber Valerie H

Re: FW: IOUG-A

I too will attend that class, even if I can't get my boss to spring for it. They are sending me there, but they don't have to pay for the conference, so I should be able to talk them into it. Stephen Andert [EMAIL PROTECTED] 01/06/03 12:14PM Jonathan, if you do decide to give that class, I am

RE: Prevent FTS

Read Tim Gorman's The Search For Intelligent Life in the Cost-Based Optimizer. I think its on his website - http://www.evdbt.com/papers.htm Babu

RE: Help with Import

Raj - Thanks for sharing the details of how this method works in practice for you. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 06, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Dennis, We do almost the same

RE: Prevent FTS

Please check Jonathan Lewis book 'Practice Oracle 8i'. This book provides lot more details about these two optimizer related parameters that could significantly affect FTS situations. optimizer_index_caching optimizer_index_cost_adj The general 'harmless' guidelines could be setting 10 to

RE: Database/system Crashing

Title: RE: Database/system Crashing Richard, Yes this is a SUN platform. One SA now believes it is independent of the database since it happens when the database isn't running. I moved the background dest files to the other disk (other than the root disk.) Normally it would have crashed by

Re: Automatic backup on Oracle 9i -- For Jared

-.-. --.- -.. . -.- WA9CAM/0 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 06, 2003 8:58 AM I should have mentioned that another useful one could be QRM. QRM = I am experiencing interference. QRM? = Are you experiencing

Re: rbs' maxextents in LMT

Hi, the trick is to use package dbms_space_admin (Cf Oracle Doc) to convert from DMT to LMT. With this method, you obtain a USER allocation type as seen in dba_tablespaces view that allow you to use maxextents clause. N.B. to ease the conversion, it's better to have DMT tablespaces already

Re: Are too many Foreign Keys in one table bad?

If the code is unique its not a problem. Only part that can give trouble is u r allowing to update code in reftable . That's not coool . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 06, 2003 12:03 PM I am designing some tables

RE: Help with Import

Hi, We use a slightly different approach here... We have a couple of development environments which get refreshed with a subset of data (using Princeton Softech's Move for Servers) every so often. The system testers also have a couple of environments like this. These environments are good for

Re: rbs' maxextents in LMT

Guang, You should use LMTs with UNFORM extent allocation of some size So create the tablespaces and the rollback segments but not the INITIAL or NEXT. I am not sure what you meamn by runaway processes. If a transaction needs rollback segment space, it will need to extend it. You can still

Re: Are too many Foreign Keys in one table bad?

Greg, I don't think Oracle will have a real problem with 15 tables or 1,000 rows. If the ref tables are quite small then they won't even be worth indexing - Oracle will just read the entire table at one anyway. You might want to tell Oracle to CACHE the reference tables, although I don't think

Re: Prevent FTS

manoj.gurnani, hI, It seems that you do not need this clause: and y.col_1 = z.col_1 and y.col_2 = z.col_2 right? Is your table z rather small? If your table have different size or your optimizer mode is different, oracle will show different plan. It is

Re: RE: Unix for oracle dba -- Suggest a book ?

Thanx Mike. Had a look at the contents of the book. seems to be good. hope i will have a copy of it soon. Thanx once again. Regards, Jp. On Mon, 06 Jan 2003 Hately, Mike (NESL-IT) wrote : If you want to understand how Oracle uses Unix get a copy of James Morle's Scaling Oracle. It's not a

Re: Are too many Foreign Keys in one table bad?

Mark, Based on the presentation and testing Dan Fink did for the last NYOUG meeting, it's possible that the ref tables SHOULD be indexed, and that it will help performance to index them. Rachel --- Mark Richard [EMAIL PROTECTED] wrote: Greg, I don't think Oracle will have a real problem

True inner peace

By following the simple advice I read in an article, I have finally found inner peace... It said: The way to achieve inner peace is to finish all the things I had started. So, today I have finished one bottle of cognac, two bottles of red wine, a bottle of Jack Daniels, my Prozac's, and a box

Re: Are too many Foreign Keys in one table bad?

I don't think Oracle will have a real problem with 15 tables or 1,000 rows. If the ref tables are quite small then they won't even be worth indexing - Oracle will just read the entire table at one anyway. Not necessarily. There can be quite a difference between using an index on a small

Re: Are too many Foreign Keys in one table bad?

All, Point well taken (both Rachel's and Jared's). I should have said (and was even thinking - although the brain and hands sometimes act independently) might not be worth indexing. It sounds like a helpdesk system for a pretty small customer base so I was assuming that system load isn't likely

SQL*Plus core dump

Dear List, Apologies in advance for the long message, but the error messages are no doubt significant to the problem. As part of our testing procedures we kill SQL scripts (anonymous PL/SQL blocks normally) during execution using the following: SQL alter system kill session '18,44329';

Re: Are too many Foreign Keys in one table bad?

I'm flattered you put me in the same category as Kirti, Dan, Jared, Connor and Jonathan. If I recall the cost of my (one) trip to Australia, it would be cheaper to import you to IOUG than it would be to get us there! I'm not sure about Jared and Connor, the rest of us will be at IOUG. And for

Re: True inner peace

I *knew* I was forgetting something. damn, where did I leave that box of chocolates? The rest of your list are already long gone. :) Come to the dark side Ferenc, join us on the OT list before Jared and the members here get annoyed with the non-technical posts :) --- mantfield [EMAIL

Re: encrypted user/passwd connection

Andre, Oracle does not send passwords across the network in clear text, they are encrypted by default. Jared On Monday 06 January 2003 05:43, Andrey Bronfin wrote: Dear list ! I have just been asked the following question: is it possible to make a connection from an Oracle client to an

ORA-00600: [2662]

Hi all, I hit by this error ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], [54173017], [16781180], [], [] Can you help me where to find info about this error Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing

  1   2   >