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
tablespace By: manns on Tue, 21 March 2006	5	2428	Thu, 23 March 2006 03:41 By: Frank
general query tuning By: mjschwenger on Sun, 19 March 2006	7	4602	Wed, 22 March 2006 15:11 By: mjschwenger
A myth of TKPROF output in Oracle 10.1.0.4 By: tphan_au on Tue, 07 March 2006	3	2942	Mon, 20 March 2006 22:25 By: Art Metzer
Truncation of Queries in Statspack Report By: ajay_gupta_dr on Mon, 20 March 2006	1	1793	Mon, 20 March 2006 06:34 By: Maaher
Function index By: panatisudhakar on Sat, 18 March 2006	3	3147	Mon, 20 March 2006 05:08 By: JSI2001
bitmap index on unstable column By: a_developer on Thu, 16 March 2006	4	2864	Sat, 18 March 2006 21:51 By: a_developer
Transaction never fails ..where By: jagjeet.malhi on Sat, 18 March 2006	0	3825	Sat, 18 March 2006 07:21 By: jagjeet.malhi
Difference in Execution timing By: feroze on Fri, 17 March 2006	1	1567	Sat, 18 March 2006 00:52 By: Frank
Log File Sync By: amitsingla on Fri, 17 March 2006	3	2653	Fri, 17 March 2006 04:56 By: alanm
Interpreting tkprof By: sophieharris on Sun, 12 March 2006	4	10386	Thu, 16 March 2006 15:42 By: sophieharris
operation timed out By: vasudevan on Thu, 16 March 2006	3	2033	Thu, 16 March 2006 15:30 By: Mahesh Rajendran
Materialized view vs Table By: a_developer on Tue, 14 March 2006	2	6039	Thu, 16 March 2006 09:32 By: croK
Oracle 8.1.7.0 - How to find BIND Variable values ? By: deadpoet on Thu, 16 March 2006	0	3895	Thu, 16 March 2006 09:29 By: deadpoet
Difference in location of the hint By: a_developer on Tue, 14 March 2006	2	1887	Wed, 15 March 2006 06:45 By: a_developer
Numeric or Alphanumeric datatype By: gajini on Mon, 13 March 2006	1	2113	Tue, 14 March 2006 02:32 By: rleishman
Partitioned to Composite Partitioned By: a_developer on Sat, 11 March 2006	2	1915	Mon, 13 March 2006 12:45 By: a_developer
parallel hint/execution By: a_developer on Fri, 10 March 2006	2	3866	Sun, 12 March 2006 16:16 By: a_developer
Oracle 8 rebuild index By: marco118 on Thu, 09 March 2006	4	6962	Fri, 10 March 2006 19:22 By: rleishman
Problem with insert statements sharing in shared pool By: sach_sumit on Fri, 10 March 2006	0	4247	Fri, 10 March 2006 08:38 By: sach_sumit
MERGE INTO with a hint By: a_developer on Thu, 09 March 2006	4	19960	Fri, 10 March 2006 00:19 By: a_developer
When to rebuild indexes ... By: tridentadm on Thu, 09 March 2006	0	5048	Thu, 09 March 2006 23:40 By: tridentadm
number of rows per db block By: srhl on Thu, 09 March 2006	2	2191	Thu, 09 March 2006 21:10 By: srhl
Index Monitoring By: faiz_hyd on Thu, 02 March 2006	5	5396	Thu, 09 March 2006 10:07 By: faiz_hyd
Query to select users connected By: MoleyHarey on Thu, 09 March 2006	1	4070	Thu, 09 March 2006 06:13 By: Mahesh Rajendran
best way to create an index By: a_developer on Wed, 08 March 2006	1	1940	Thu, 09 March 2006 00:47 By: rleishman
help for not equal and index usage By: mjschwenger on Mon, 06 March 2006	4	2460	Wed, 08 March 2006 15:10 By: mjschwenger
Sort and hash area size problem By: sach_sumit on Tue, 07 March 2006	1	4503	Wed, 08 March 2006 09:41 By: aciolac
Wait event 'db file sequential read' on TABLE segment By: tphan_au on Tue, 07 March 2006	1	5833	Wed, 08 March 2006 08:48 By: Mahesh Rajendran
Please tune this Query By: hsinghalmrt on Tue, 07 March 2006	8	3669	Wed, 08 March 2006 06:56 By: JSI2001
Statpack report By: rc_ashish on Sat, 05 November 2005	6	7754	Wed, 08 March 2006 06:21 By: Mahesh Rajendran
please help me ->cpu id 0 By: rzmni on Tue, 07 March 2006	0	3574	Tue, 07 March 2006 21:42 By: rzmni
Performance tuning of Oracle 8i By: Vamshee on Tue, 07 March 2006	6	4025	Tue, 07 March 2006 12:38 By: Mahesh Rajendran
Query Optimisation By: mhjoshi on Tue, 07 March 2006	2	1850	Tue, 07 March 2006 07:12 By: JSI2001
ORDER BY CLAUSE By: rvnair123 on Tue, 07 March 2006	3	4092	Tue, 07 March 2006 05:27 By: Frank
Tuning Buffer Hit Ratio on Oracle 8i By: Vamshee on Mon, 06 March 2006	2	2290	Mon, 06 March 2006 13:44 By: Vamshee
log waits By: toshidas2000 on Mon, 06 March 2006	0	4063	Mon, 06 March 2006 13:10 By: toshidas2000
ORA-024012: PLAN_TABLE not found By: Brayan on Thu, 02 February 2006	4	14680	Mon, 06 March 2006 05:22 By: samidc
Index not being used in Query By: samidc on Mon, 06 March 2006	2	2228	Mon, 06 March 2006 02:08 By: Mahesh Rajendran
Bulk Collect in Oracle 8i By: mohit.arora79 on Fri, 03 March 2006	2	3587	Fri, 03 March 2006 05:57 By: rleishman
library cache latch By: aline on Thu, 02 March 2006	1	5096	Thu, 02 March 2006 13:42 By: mchadder