OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Regarding sort optimsation (merged) By: jobsushil on Fri, 12 October 2007	8	3791	Tue, 16 October 2007 09:20 By: JRowbottom
sql performance issue. By: lm_suresh on Tue, 16 October 2007	4	3215	Tue, 16 October 2007 08:41 By: arunprasad_bh
Reading DBMS_XPLAN output By: emreb on Tue, 16 October 2007	5	6063	Tue, 16 October 2007 05:22 By: emreb
parallel query By: vkrmhj on Tue, 16 October 2007	4	2677	Tue, 16 October 2007 03:15 By: rleishman
performance issue on oracle 8 By: rc_ora on Tue, 16 October 2007	1	2653	Tue, 16 October 2007 02:12 By: Michel Cadot
difference between db_buffer_keep and db_keep_cache_size? difference between db_buffer_keep and db_keep_cache_size? By: ashishmcajec on Mon, 15 October 2007	1	4021	Mon, 15 October 2007 23:17 By: BlackSwan
Keep buffer &recycle cache size Keep buffer &recycle cache size By: ashishmcajec on Mon, 15 October 2007	5	3520	Mon, 15 October 2007 23:10 By: BlackSwan
while taking performance measeure ? By: skumar.dba on Thu, 11 October 2007	7	6153	Mon, 15 October 2007 12:12 By: Michel Cadot
degradation after restart By: Sergius on Fri, 12 October 2007	8	4239	Mon, 15 October 2007 08:39 By: Mohammad Taj
search on text column By: navkrish on Fri, 12 October 2007	3	2441	Mon, 15 October 2007 06:58 By: JRowbottom
DB link problem DB link problem By: milind_sri on Fri, 12 October 2007	4	3308	Fri, 12 October 2007 13:44 By: Michel Cadot
slow in all aspects By: vasudevan on Thu, 11 October 2007	4	3639	Fri, 12 October 2007 00:05 By: Michel Cadot
SGA and PGA By: e3339 on Thu, 11 October 2007	1	2470	Fri, 12 October 2007 00:05 By: Michel Cadot
sample size in user_table By: navkrish on Thu, 11 October 2007	3	2783	Thu, 11 October 2007 17:44 By: BlackSwan
View not using index on underlying tables By: Terry Burns on Thu, 11 October 2007	3	3706	Thu, 11 October 2007 13:41 By: BlackSwan
Large table help inserting into large tables. By: zzasteven on Tue, 09 October 2007	9	5941	Thu, 11 October 2007 09:01 By: Kevin Meade
Updaing a 804 million partioned table (for 365 days) from a 67 million table By: Aju on Thu, 11 October 2007	1	3208	Thu, 11 October 2007 04:12 By: Michel Cadot
ora 01555 By: risy_s on Thu, 11 October 2007	3	6126	Thu, 11 October 2007 02:17 By: Michel Cadot
Long Read Time By: e3339 on Wed, 10 October 2007	1	2498	Wed, 10 October 2007 14:16 By: BlackSwan
Index creation.... By: lm_suresh on Tue, 09 October 2007	4	4390	Wed, 10 October 2007 09:31 By: mson77
Different explain plan Different explain plan By: rubhatta on Tue, 09 October 2007	2	3548	Wed, 10 October 2007 01:30 By: Michel Cadot
Rule for optimizing the query (merged) By: ashishmcajec on Tue, 09 October 2007	4	3301	Tue, 09 October 2007 23:00 By: rleishman
Performance Not Improved with Hint By: mchittib on Tue, 09 October 2007	4	2670	Tue, 09 October 2007 22:20 By: mchittib
Non Standard Block size By: tanmoy1048 on Wed, 03 October 2007	5	5971	Tue, 09 October 2007 13:00 By: Michel Cadot
Takes long time on sorting. By: lm_suresh on Fri, 05 October 2007	8	4928	Mon, 08 October 2007 07:07 By: Michel Cadot
delete statement taking long time By: el33t on Sun, 07 October 2007	8	11749	Mon, 08 October 2007 06:42 By: el33t
What are the keep tables and indexes in Oracle HRMS, Oracle Financials and Oracle Payroll By: ish_bhatia on Mon, 08 October 2007	1	2856	Mon, 08 October 2007 06:34 By: JRowbottom
SQL Query for tuning SQL Query for tuning By: kr_arvind on Mon, 08 October 2007	1	2536	Mon, 08 October 2007 06:32 By: JRowbottom
How to make table scan faster By: legna on Mon, 08 October 2007	6	2873	Mon, 08 October 2007 05:46 By: JRowbottom
Help reading TOAD Explain Plan By: bogey on Wed, 25 October 2006	18	20345	Fri, 05 October 2007 05:32 By: JRowbottom
sql query optimization By: antana on Fri, 05 October 2007	1	2150	Fri, 05 October 2007 04:35 By: Michel Cadot
Performance Tuning By: ramakrishnakapilavai on Thu, 04 October 2007	2	3204	Thu, 04 October 2007 04:54 By: Michel Cadot
Optimizing Oracle SQL statements - can anyone help? By: jimicron on Fri, 28 September 2007	2	3289	Thu, 04 October 2007 04:18 By: JRowbottom
database is going down very frequently By: karismapanda on Thu, 04 October 2007	6	3178	Thu, 04 October 2007 02:21 By: Michel Cadot
sql performance tuning By: gsr29 on Wed, 03 October 2007	3	3262	Wed, 03 October 2007 14:34 By: gsr29
Outer Join killing Performance By: kumarsz on Mon, 28 August 2006	16	33779	Wed, 03 October 2007 10:37 By: mson77
Tuning query (insert using select) By: etl_prasad on Mon, 01 October 2007	9	6195	Tue, 02 October 2007 14:08 By: BlackSwan
open cursors By: dirish on Mon, 01 October 2007	15	6929	Tue, 02 October 2007 03:10 By: Michel Cadot
Lots of 'Row Lock Waits" on the indexes, but no on the based table By: wqhhust on Mon, 01 October 2007	3	14501	Mon, 01 October 2007 17:28 By: wqhhust
Rollback per transaction % too high and a lot db file sequential reads By: thorin666 on Mon, 01 October 2007	4	4018	Mon, 01 October 2007 17:02 By: OracleDisected