[askdba] Re: [dba_gurus] Re: Re: How to tune tables for inserts and Updates?
- From: "Kurian Abraham" <kzabraham@xxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Tue, 5 Oct 2004 12:03:11 +0530
Since you are on 9iR2 , Try using MERGE
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Chirag DBA
Sent: Monday, October 04, 2004 7:40 PM
To: Nisar Tareen
Cc: askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
oracle-dba-masters@xxxxxxxxxxxxxxx; dba_gurus@xxxxxxxxxxxxxxx
Subject: [askdba] Re: [dba_gurus] Re: Re: How to tune tables for inserts
and Updates?
Thanx Tareen.
I was sure but the questions from client shaken me.
I willsurely not go for MTS.=20
I was expecting this kind of answer. Thanx again.
- Chiku
----- Original Message -----
From: Nisar Tareen <ntareen@xxxxxxxxx>
Date: Mon, 4 Oct 2004 07:01:02 -0700 (PDT)
Subject: Re: [dba_gurus] Re: [askdba] Re: How to tune tables for
inserts and Updates?
To: Chirag DBA <chiragdba@xxxxxxxxx>, askdba@xxxxxxxxxxxxx,
oracle-l@xxxxxxxxxxxxx
Cc: oracle-dba-masters@xxxxxxxxxxxxxxx, dba_gurus@xxxxxxxxxxxxxxx
Chirag,=20
With the size of your database , U should not worry at all, One
concern , if you do not have to many useres remove MTS. I will make
the connecton fast for your users.
Have a big share pool and a large db buffer all will work fine for
you. No need to work till any serious problem is raised.
Nisar Tareen=20
Chirag DBA <ChiragDBA@xxxxxxxxx> wrote:
Hi,
I have one question here.
I have a database with 60 tables and out of that 19 are for
transaction and others will be populated with the help of nightly
pumps.
there are 17 indexes which are PK and FK, n others are required to
create as per the requirement like Creating an index on Foreign key n
some on the basis of search criteria n all. I think it may go upto 30
indexes.
Environment will be HP - UX 11i and 9iR2. I m expecting 5000
transaction so I think 7 transactions in 2 minutes.
Can this lead to any Performance problem ? I m very confident but the
concrns from the client made me think again.
I think this is a very small DB compare to other Databases.=20
I have a plan for Block level tuning at a time of DB creation like
small block size, n pctfree, pctused, freelists and all are ok.
Or else I may put it in MTS too.=20
No Querry is too big as I have tried to each entity in a different
table which has reduced my data redundancy n to merge the keys I have
Transaction tables which are very few.
can any one see any performance issue?=20
- Chiku
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
=20
To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
=20
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.=20
=20
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
________________________________
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
=20
To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
=20
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Other related posts:
