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 Fragmentation !! By: AlinaC on Thu, 23 March 2006	6	6907	Thu, 23 March 2006 07:07 By: Mahesh Rajendran
tablespace By: manns on Tue, 21 March 2006	5	2518	Thu, 23 March 2006 03:41 By: Frank
general query tuning By: mjschwenger on Sun, 19 March 2006	7	4727	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	3005	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	1832	Mon, 20 March 2006 06:34 By: Maaher
Function index By: panatisudhakar on Sat, 18 March 2006	3	3213	Mon, 20 March 2006 05:08 By: JSI2001
bitmap index on unstable column By: a_developer on Thu, 16 March 2006	4	2936	Sat, 18 March 2006 21:51 By: a_developer
Transaction never fails ..where By: jagjeet.malhi on Sat, 18 March 2006	0	3869	Sat, 18 March 2006 07:21 By: jagjeet.malhi
Difference in Execution timing By: feroze on Fri, 17 March 2006	1	1627	Sat, 18 March 2006 00:52 By: Frank
Log File Sync By: amitsingla on Fri, 17 March 2006	3	2720	Fri, 17 March 2006 04:56 By: alanm
Interpreting tkprof By: sophieharris on Sun, 12 March 2006	4	10490	Thu, 16 March 2006 15:42 By: sophieharris
operation timed out By: vasudevan on Thu, 16 March 2006	3	2105	Thu, 16 March 2006 15:30 By: Mahesh Rajendran
Materialized view vs Table By: a_developer on Tue, 14 March 2006	2	6106	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	3925	Thu, 16 March 2006 09:29 By: deadpoet
Difference in location of the hint By: a_developer on Tue, 14 March 2006	2	1945	Wed, 15 March 2006 06:45 By: a_developer
Numeric or Alphanumeric datatype By: gajini on Mon, 13 March 2006	1	2167	Tue, 14 March 2006 02:32 By: rleishman
Partitioned to Composite Partitioned By: a_developer on Sat, 11 March 2006	2	1983	Mon, 13 March 2006 12:45 By: a_developer
parallel hint/execution By: a_developer on Fri, 10 March 2006	2	3927	Sun, 12 March 2006 16:16 By: a_developer
Oracle 8 rebuild index By: marco118 on Thu, 09 March 2006	4	7067	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	4276	Fri, 10 March 2006 08:38 By: sach_sumit
MERGE INTO with a hint By: a_developer on Thu, 09 March 2006	4	20105	Fri, 10 March 2006 00:19 By: a_developer
When to rebuild indexes ... By: tridentadm on Thu, 09 March 2006	0	5085	Thu, 09 March 2006 23:40 By: tridentadm
number of rows per db block By: srhl on Thu, 09 March 2006	2	2236	Thu, 09 March 2006 21:10 By: srhl
Index Monitoring By: faiz_hyd on Thu, 02 March 2006	5	5479	Thu, 09 March 2006 10:07 By: faiz_hyd
Query to select users connected By: MoleyHarey on Thu, 09 March 2006	1	4132	Thu, 09 March 2006 06:13 By: Mahesh Rajendran
best way to create an index By: a_developer on Wed, 08 March 2006	1	1991	Thu, 09 March 2006 00:47 By: rleishman
help for not equal and index usage By: mjschwenger on Mon, 06 March 2006	4	2561	Wed, 08 March 2006 15:10 By: mjschwenger
Sort and hash area size problem By: sach_sumit on Tue, 07 March 2006	1	4565	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	5889	Wed, 08 March 2006 08:48 By: Mahesh Rajendran
Please tune this Query By: hsinghalmrt on Tue, 07 March 2006	8	3777	Wed, 08 March 2006 06:56 By: JSI2001
Statpack report By: rc_ashish on Sat, 05 November 2005	6	7840	Wed, 08 March 2006 06:21 By: Mahesh Rajendran
please help me ->cpu id 0 By: rzmni on Tue, 07 March 2006	0	3602	Tue, 07 March 2006 21:42 By: rzmni
Performance tuning of Oracle 8i By: Vamshee on Tue, 07 March 2006	6	4105	Tue, 07 March 2006 12:38 By: Mahesh Rajendran
Query Optimisation By: mhjoshi on Tue, 07 March 2006	2	1907	Tue, 07 March 2006 07:12 By: JSI2001
ORDER BY CLAUSE By: rvnair123 on Tue, 07 March 2006	3	4147	Tue, 07 March 2006 05:27 By: Frank
Tuning Buffer Hit Ratio on Oracle 8i By: Vamshee on Mon, 06 March 2006	2	2343	Mon, 06 March 2006 13:44 By: Vamshee
log waits By: toshidas2000 on Mon, 06 March 2006	0	4096	Mon, 06 March 2006 13:10 By: toshidas2000
ORA-024012: PLAN_TABLE not found By: Brayan on Thu, 02 February 2006	4	14755	Mon, 06 March 2006 05:22 By: samidc
Index not being used in Query By: samidc on Mon, 06 March 2006	2	2287	Mon, 06 March 2006 02:08 By: Mahesh Rajendran
Bulk Collect in Oracle 8i By: mohit.arora79 on Fri, 03 March 2006	2	3648	Fri, 03 March 2006 05:57 By: rleishman