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
CAN WE USE HINT IN VIEW QUERY STATEMENT By: jainarayan5484 on Thu, 02 August 2007	2	2368	Thu, 02 August 2007 13:00 By: Michel Cadot
How to Generate Statistics of a table and how to see in oracle 10g By: jainarayan5484 on Thu, 02 August 2007	2	2503	Thu, 02 August 2007 10:22 By: DreamzZ
performance problem when use parallel and hash join on large tables By: fbucco on Tue, 31 July 2007	5	2885	Wed, 01 August 2007 13:08 By: fbucco
How to find out the bad sql statemets ? By: kesevan on Sat, 28 April 2007	7	5790	Wed, 01 August 2007 10:55 By: Michel Cadot
View doesn't use Index By: vettorel on Mon, 30 July 2007	1	2280	Mon, 30 July 2007 11:22 By: Michel Cadot
Need help - Tuning the SQL By: ritesh15j on Mon, 30 July 2007	2	2277	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	11302	Mon, 30 July 2007 03:50 By: anamika_025
Help : Histograms Size By: orasaket on Sun, 29 July 2007	1	1960	Sun, 29 July 2007 11:13 By: Michel Cadot
Database hanged By: kamragulshan on Wed, 25 July 2007	0	7993	Wed, 25 July 2007 04:51 By: kamragulshan
SGA By: dirish on Wed, 25 July 2007	1	2513	Wed, 25 July 2007 03:35 By: Michel Cadot
ARCH wait on SENDREQ By: ursg02 on Wed, 25 July 2007	1	16258	Wed, 25 July 2007 03:19 By: Michel Cadot
index not used By: pradns on Tue, 24 July 2007	6	3759	Tue, 24 July 2007 06:34 By: pradns
Real Application Testing --> Database Replay By: gkodakalla on Thu, 19 July 2007	1	1986	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	2243	Wed, 18 July 2007 13:12 By: DreamzZ
Time Differnce in Execution with / without Hint By: faiz_hyd on Mon, 16 July 2007	6	4171	Tue, 17 July 2007 23:16 By: rleishman
how to speedup mentioned SQL query By: rajat_chaudhary on Tue, 17 July 2007	22	4377	Tue, 17 July 2007 15:07 By: Michel Cadot
slow update on large table By: subusona on Thu, 12 July 2007	8	7826	Sat, 14 July 2007 03:07 By: michael_bialik
optimatize query?? By: steve_kc on Tue, 10 July 2007	2	3496	Fri, 13 July 2007 00:33 By: orafan23
statspack table fetch continued row By: alanm on Thu, 12 July 2007	16	5241	Thu, 12 July 2007 20:42 By: BlackSwan
Buffer Pool By: poratips on Thu, 21 June 2007	4	4687	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	2983	Thu, 12 July 2007 10:28 By: poratips
execution plan for a stored procedure By: steve_kc on Thu, 12 July 2007	2	7008	Thu, 12 July 2007 04:46 By: ebrian
How Oracle using SAMPLE Clause on statistics? By: aprodovikov on Wed, 11 July 2007	3	4307	Wed, 11 July 2007 06:03 By: Michel Cadot
Performance tuning By: ammishra on Wed, 04 July 2007	12	4219	Tue, 10 July 2007 09:10 By: ammishra
detecting environment issues By: yog_23 on Mon, 09 July 2007	2	2517	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	2597	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	3458	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	2529	Mon, 09 July 2007 01:05 By: kmkan28
Help : Understanding the Explain Plan By: orasaket on Fri, 06 July 2007	5	5467	Sun, 08 July 2007 12:04 By: orasaket
99% Hit-Ratio but poor performance By: naveenkumar001 on Thu, 05 July 2007	3	2583	Sat, 07 July 2007 05:04 By: gintsp
New Server but performance still the same By: alpaje on Tue, 03 July 2007	2	2318	Wed, 04 July 2007 11:58 By: michael_bialik
Perfomance problem due to Distinct clause By: ShivrajGutte on Wed, 04 July 2007	1	2008	Wed, 04 July 2007 07:10 By: Michel Cadot
SQL query needs tuning By: kpremsagar on Sun, 01 July 2007	9	13072	Wed, 04 July 2007 02:23 By: kpremsagar
Performance Problem By: barakula on Tue, 03 July 2007	6	2382	Tue, 03 July 2007 12:39 By: flyboy
How can i tune such a simple sql By: member1975 on Tue, 03 July 2007	3	2632	Tue, 03 July 2007 10:45 By: DreamzZ
gather_statistics By: adee_saleh on Sun, 01 July 2007	7	6936	Tue, 03 July 2007 10:06 By: DreamzZ
Questions about Executing Explain Plan against a query. By: Rustican on Tue, 03 July 2007	1	2213	Tue, 03 July 2007 09:22 By: Michel Cadot
pga_aggregate_target - Issue By: Brayan on Tue, 03 July 2007	4	3017	Tue, 03 July 2007 07:48 By: Brayan
Avoid Index to be used by Queries By: feroze on Mon, 02 July 2007	3	2490	Mon, 02 July 2007 15:42 By: Michel Cadot
Performance issue in report By: jamalfarooq on Fri, 29 June 2007	3	2423	Fri, 29 June 2007 15:41 By: BlackSwan