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
performance problem when use parallel and hash join on large tables By: fbucco on Tue, 31 July 2007	5	2474	Wed, 01 August 2007 13:08 By: fbucco
How to find out the bad sql statemets ? By: kesevan on Sat, 28 April 2007	7	5343	Wed, 01 August 2007 10:55 By: Michel Cadot
View doesn't use Index By: vettorel on Mon, 30 July 2007	1	2085	Mon, 30 July 2007 11:22 By: Michel Cadot
Need help - Tuning the SQL By: ritesh15j on Mon, 30 July 2007	2	1989	Mon, 30 July 2007 10:54 By: Michel Cadot
how to increase a performance of a table in oracle 10g (merged) ( 1 2) By: anamika_025 on Wed, 25 July 2007	53	9261	Mon, 30 July 2007 03:50 By: anamika_025
Help : Histograms Size By: orasaket on Sun, 29 July 2007	1	1748	Sun, 29 July 2007 11:13 By: Michel Cadot
Database hanged By: kamragulshan on Wed, 25 July 2007	0	7839	Wed, 25 July 2007 04:51 By: kamragulshan
SGA By: dirish on Wed, 25 July 2007	1	2314	Wed, 25 July 2007 03:35 By: Michel Cadot
ARCH wait on SENDREQ By: ursg02 on Wed, 25 July 2007	1	16041	Wed, 25 July 2007 03:19 By: Michel Cadot
index not used By: pradns on Tue, 24 July 2007	6	3448	Tue, 24 July 2007 06:34 By: pradns
Real Application Testing --> Database Replay By: gkodakalla on Thu, 19 July 2007	1	1787	Thu, 19 July 2007 08:04 By: Michel Cadot
Deletion on an partition table is very slow By: balaji1010 on Wed, 18 July 2007	2	2014	Wed, 18 July 2007 13:12 By: DreamzZ
Time Differnce in Execution with / without Hint By: faiz_hyd on Mon, 16 July 2007	6	3793	Tue, 17 July 2007 23:16 By: rleishman
how to speedup mentioned SQL query By: rajat_chaudhary on Tue, 17 July 2007	22	3602	Tue, 17 July 2007 15:07 By: Michel Cadot
slow update on large table By: subusona on Thu, 12 July 2007	8	7209	Sat, 14 July 2007 03:07 By: michael_bialik
optimatize query?? By: steve_kc on Tue, 10 July 2007	2	3272	Fri, 13 July 2007 00:33 By: orafan23
statspack table fetch continued row By: alanm on Thu, 12 July 2007	16	4605	Thu, 12 July 2007 20:42 By: BlackSwan
Buffer Pool By: poratips on Thu, 21 June 2007	4	4352	Thu, 12 July 2007 10:29 By: poratips
ORA-1652: unable to extend temp segment by 16 in TEMP TS By: poratips on Fri, 08 June 2007	3	2631	Thu, 12 July 2007 10:28 By: poratips
execution plan for a stored procedure By: steve_kc on Thu, 12 July 2007	2	6792	Thu, 12 July 2007 04:46 By: ebrian
How Oracle using SAMPLE Clause on statistics? By: aprodovikov on Wed, 11 July 2007	3	4068	Wed, 11 July 2007 06:03 By: Michel Cadot
Performance tuning By: ammishra on Wed, 04 July 2007	12	3598	Tue, 10 July 2007 09:10 By: ammishra
detecting environment issues By: yog_23 on Mon, 09 July 2007	2	2258	Tue, 10 July 2007 00:33 By: BlackSwan
Index created is not using(I dont want to use hints) By: donind on Mon, 09 July 2007	4	2172	Mon, 09 July 2007 14:53 By: michael_bialik
Partitioned table takes longer to load than ordinary table By: kpremsagar on Wed, 04 July 2007	3	3063	Mon, 09 July 2007 03:02 By: rleishman
How to use optimizer hint in a recursivly called procedure By: kmkan28 on Fri, 06 July 2007	2	2253	Mon, 09 July 2007 01:05 By: kmkan28
Help : Understanding the Explain Plan By: orasaket on Fri, 06 July 2007	5	5151	Sun, 08 July 2007 12:04 By: orasaket
99% Hit-Ratio but poor performance By: naveenkumar001 on Thu, 05 July 2007	3	2310	Sat, 07 July 2007 05:04 By: gintsp
New Server but performance still the same By: alpaje on Tue, 03 July 2007	2	1945	Wed, 04 July 2007 11:58 By: michael_bialik
Perfomance problem due to Distinct clause By: ShivrajGutte on Wed, 04 July 2007	1	1821	Wed, 04 July 2007 07:10 By: Michel Cadot
SQL query needs tuning By: kpremsagar on Sun, 01 July 2007	9	12529	Wed, 04 July 2007 02:23 By: kpremsagar
Performance Problem By: barakula on Tue, 03 July 2007	6	2033	Tue, 03 July 2007 12:39 By: flyboy
How can i tune such a simple sql By: member1975 on Tue, 03 July 2007	3	2259	Tue, 03 July 2007 10:45 By: DreamzZ
gather_statistics By: adee_saleh on Sun, 01 July 2007	7	6534	Tue, 03 July 2007 10:06 By: DreamzZ
Questions about Executing Explain Plan against a query. By: Rustican on Tue, 03 July 2007	1	2026	Tue, 03 July 2007 09:22 By: Michel Cadot
pga_aggregate_target - Issue By: Brayan on Tue, 03 July 2007	4	2604	Tue, 03 July 2007 07:48 By: Brayan
Avoid Index to be used by Queries By: feroze on Mon, 02 July 2007	3	2102	Mon, 02 July 2007 15:42 By: Michel Cadot
Performance issue in report By: jamalfarooq on Fri, 29 June 2007	3	2147	Fri, 29 June 2007 15:41 By: BlackSwan
implications of merging 17 tables into 1... By: orausern on Tue, 26 June 2007	11	2755	Thu, 28 June 2007 23:45 By: flyboy
poor performance of selecting from view. By: eggplant on Thu, 28 June 2007	0	7235	Thu, 28 June 2007 15:07 By: eggplant