Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.
  UNION and UNION ALL discrepancy
By: bijou on Fri, 01 August 2008 09:47
  Re: UNION and UNION ALL discrepancy
By: Mahesh Rajendran on Fri, 01 August 2008 09:53
  Re: UNION and UNION ALL discrepancy
By: bijou on Fri, 01 August 2008 10:07
  Re: UNION and UNION ALL discrepancy
By: Michel Cadot on Fri, 01 August 2008 10:20
  Re: UNION and UNION ALL discrepancy
By: Michel Cadot on Fri, 01 August 2008 10:06
  Re: UNION and UNION ALL discrepancy
By: bijou on Fri, 01 August 2008 10:10
  Re: UNION and UNION ALL discrepancy
By: joy_division on Fri, 01 August 2008 12:59
  Re: UNION and UNION ALL discrepancy
By: Frank on Fri, 01 August 2008 14:12
  Re: UNION and UNION ALL discrepancy
By: rleishman on Sun, 03 August 2008 21:45
  Re: UNION and UNION ALL discrepancy
By: bijou on Mon, 04 August 2008 03:43
  Re: UNION and UNION ALL discrepancy
By: Michel Cadot on Mon, 04 August 2008 03:45
  Re: UNION and UNION ALL discrepancy
By: bijou on Wed, 06 August 2008 06:10
  Re: UNION and UNION ALL discrepancy
By: rleishman on Thu, 07 August 2008 21:52
  Re: UNION and UNION ALL discrepancy
By: bijou on Mon, 04 August 2008 03:39
  Index is used still problem
By: bubbly on Wed, 06 August 2008 17:43
  Re: Index is used still problem
By: BlackSwan on Wed, 06 August 2008 17:52
  Re: Index is used still problem
By: bubbly on Wed, 06 August 2008 18:05
  Re: Index is used still problem
By: BlackSwan on Wed, 06 August 2008 18:12
  Re: Index is used still problem
By: rleishman on Wed, 06 August 2008 22:27
  Re: Index is used still problem
By: sunil_v_mishra on Thu, 07 August 2008 03:36
  How to estimate query response time and number of rows without executing q...
By: gkodakalla on Thu, 07 August 2008 02:08
  Re: How to estimate query response time and number of rows without executi...
By: Michel Cadot on Thu, 07 August 2008 02:14
  Re: How to estimate query response time and number of rows without executi...
By: gkodakalla on Thu, 07 August 2008 02:19
  Re: How to estimate query response time and number of rows without executi...
By: Michel Cadot on Thu, 07 August 2008 02:41
  Re: How to estimate query response time and number of rows without executi...
By: gkodakalla on Thu, 07 August 2008 02:52
  need assist to delete histograms
By: kumar.joy on Wed, 06 August 2008 11:49
  Re: need assist to delete histograms
By: BlackSwan on Wed, 06 August 2008 11:52
  Re: need assist to delete histograms
By: Mahesh Rajendran on Wed, 06 August 2008 12:09
  Help me tune the query
By: thalladas on Wed, 06 August 2008 11:17
  Re: Help me tune the query
By: BlackSwan on Wed, 06 August 2008 11:19
  How gathering of stats/ analyze stats work?
By: beetel on Wed, 06 August 2008 06:23
  Re: How gathering of stats/ analyze stats work?
By: Michel Cadot on Wed, 06 August 2008 06:55
  Re: How gathering of stats/ analyze stats work?
By: beetel on Wed, 06 August 2008 07:11
  Re: How gathering of stats/ analyze stats work?
By: Michel Cadot on Wed, 06 August 2008 08:40
  Re: How gathering of stats/ analyze stats work?
By: BlackSwan on Wed, 06 August 2008 08:48
  sql consumes more cpu
By: guyj on Wed, 06 August 2008 01:21
  Re: sql consumes more cpu
By: guyj on Wed, 06 August 2008 01:24
  Re: sql consumes more cpu
By: Michel Cadot on Wed, 06 August 2008 02:04
  Re: sql consumes more cpu
By: rajatratewal on Wed, 06 August 2008 05:09
  Re: sql consumes more cpu
By: guyj on Wed, 06 August 2008 05:48
  Re: sql consumes more cpu
By: rajatratewal on Wed, 06 August 2008 05:56
  to decide pctused,pctfree in Oracle8i (merged)
By: chinmayikkalki on Wed, 06 August 2008 03:02
  Re: Pctused,pctfree
By: Michel Cadot on Wed, 06 August 2008 03:07
  to decide pctused,pctfree in Oracle8i
By: chinmayikkalki on Wed, 06 August 2008 03:57
  Re: to decide pctused,pctfree in Oracle8i
By: Michel Cadot on Wed, 06 August 2008 04:11
  buffer cache handles
By: holdersav2000 on Tue, 05 August 2008 09:16
  Re: buffer cache handles
By: Michel Cadot on Tue, 05 August 2008 10:19
  Re: buffer cache handles
By: holdersav2000 on Tue, 05 August 2008 10:26
  Re: buffer cache handles
By: BlackSwan on Tue, 05 August 2008 10:32
  Re: buffer cache handles
By: holdersav2000 on Tue, 05 August 2008 11:06
  Re: buffer cache handles
By: BlackSwan on Tue, 05 August 2008 11:40
  Re: buffer cache handles
By: holdersav2000 on Wed, 06 August 2008 02:17
  selectivity in index usage
By: krshnn592 on Tue, 05 August 2008 09:48
  Re: selectivity in index usage
By: Michel Cadot on Tue, 05 August 2008 10:18
  Re: selectivity in index usage
By: krshnn592 on Tue, 05 August 2008 10:35
  Re: selectivity in index usage
By: Michel Cadot on Tue, 05 August 2008 10:50
  QUERY REWRITING
By: jayarajkrishna on Sun, 03 August 2008 04:57
  Re: QUERY REWRITING
By: Michel Cadot on Sun, 03 August 2008 04:59
  Re: QUERY REWRITING
By: JRowbottom on Tue, 05 August 2008 08:24
  DB link query.
By: sonumalhi on Mon, 04 August 2008 16:18
  Re: DB link query.
By: BlackSwan on Mon, 04 August 2008 16:26
  Merging large amounts of data into large tables
By: zzasteven on Mon, 04 August 2008 12:49
  Re: Merging large amounts of data into large tables
By: BlackSwan on Mon, 04 August 2008 13:08
  Re: Merging large amounts of data into large tables
By: zzasteven on Mon, 04 August 2008 13:54
  Re: Merging large amounts of data into large tables
By: Michel Cadot on Mon, 04 August 2008 13:47
  Re: Merging large amounts of data into large tables
By: zzasteven on Mon, 04 August 2008 13:56
  Re: Merging large amounts of data into large tables
By: BlackSwan on Mon, 04 August 2008 13:59
  Re: Merging large amounts of data into large tables
By: zzasteven on Mon, 04 August 2008 14:04
  Need suggestion for a better query.
By: pravin3032 on Tue, 22 July 2008 07:39
  Re: Need suggestion for a better query.
By: rleishman on Wed, 23 July 2008 03:19
  Re: Need suggestion for a better query.
By: pravin3032 on Mon, 28 July 2008 09:01
  Re: Need suggestion for a better query.
By: rleishman on Mon, 28 July 2008 22:20
  Re: Need suggestion for a better query.
By: pravin3032 on Tue, 29 July 2008 05:53
  Re: Need suggestion for a better query.
By: rleishman on Tue, 29 July 2008 21:58
  Re: Need suggestion for a better query.
By: pravin3032 on Mon, 04 August 2008 07:27
  SQL Tuning Methods & Books
By: oraclegyaani on Sun, 03 August 2008 11:17
  Re: SQL Tuning Methods & Books
By: Michel Cadot on Sun, 03 August 2008 11:51
  CREATE TABLE using SEQUENCE
By: ravashingravi on Sat, 02 August 2008 02:49
  Re: CREATE TABLE using SEQUENCE
By: Michel Cadot on Sat, 02 August 2008 02:58
  Re: CREATE TABLE using SEQUENCE
By: sunil_v_mishra on Sat, 02 August 2008 15:26
  Re: CREATE TABLE using SEQUENCE
By: Michel Cadot on Sun, 03 August 2008 01:48
  statspack report
By: manoj12 on Thu, 31 July 2008 08:40
  Re: statspack report
By: Michel Cadot on Thu, 31 July 2008 08:51
  Re: statspack report
By: manoj12 on Thu, 31 July 2008 09:22
  Re: statspack report
By: sunil_v_mishra on Fri, 01 August 2008 00:45
  Re: statspack report
By: BlackSwan on Fri, 01 August 2008 00:50
  Re: statspack report
By: manoj12 on Fri, 01 August 2008 01:47
  Re: statspack report
By: manoj12 on Fri, 01 August 2008 03:44
  Re: statspack report
By: sunil_v_mishra on Sat, 02 August 2008 15:12
  Re: statspack report
By: Michel Cadot on Sun, 03 August 2008 01:40
  HIGH no of LOCKS exclusive in tables for UPDATE Statement
By: udara on Mon, 21 July 2008 03:23
  Re: HIGH no of LOCKS exclusive in tables for UPDATE Statement
By: Michel Cadot on Mon, 21 July 2008 03:48
  Re: HIGH no of LOCKS exclusive in tables for UPDATE Statement
By: sunil_v_mishra on Sat, 02 August 2008 16:12
  Re: HIGH no of LOCKS exclusive in tables for UPDATE Statement
By: Kevin Meade on Sat, 02 August 2008 20:59
  criteria for partitioning
By: eaganfox on Tue, 22 July 2008 23:07
  Re: criteria for partitioning
By: BlackSwan on Tue, 22 July 2008 23:13
  Re: criteria for partitioning
By: Michel Cadot on Tue, 22 July 2008 23:34
  Re: criteria for partitioning
By: eaganfox on Fri, 25 July 2008 09:37
  Re: criteria for partitioning
By: sunil_v_mishra on Fri, 01 August 2008 00:30
  Re: criteria for partitioning
By: Michel Cadot on Fri, 01 August 2008 01:24
  Adding INDEX_DESC hint slow down the query
By: shrinika on Mon, 28 July 2008 10:38
  Re: Adding INDEX_DESC hint slow down the query
By: sunil_v_mishra on Mon, 28 July 2008 13:11
  Re: Adding INDEX_DESC hint slow down the query
By: rleishman on Mon, 28 July 2008 22:04
  Re: Adding INDEX_DESC hint slow down the query
By: shrinika on Thu, 31 July 2008 13:28
  Report hangs
By: srini_thiru on Thu, 31 July 2008 05:40
  Re: Report hangs
By: BlackSwan on Thu, 31 July 2008 08:57
  Performance issues after Database Hang during backup
By: virmahi on Mon, 28 July 2008 07:01
  Re: Performance issues after Database Hang during backup
By: Mahesh Rajendran on Mon, 28 July 2008 09:00
  Re: Performance issues after Database Hang during backup
By: sunil_v_mishra on Mon, 28 July 2008 13:38
  Re: Performance issues after Database Hang during backup
By: Mahesh Rajendran on Mon, 28 July 2008 15:03
  Re: Performance issues after Database Hang during backup
By: sunil_v_mishra on Mon, 28 July 2008 15:32
  Re: Performance issues after Database Hang during backup
By: Mahesh Rajendran on Mon, 28 July 2008 17:06
  Re: Performance issues after Database Hang during backup
By: virmahi on Thu, 31 July 2008 03:33
  Re: Performance issues after Database Hang during backup
By: Mahesh Rajendran on Thu, 31 July 2008 06:28
  ora-04030
By: srini_thiru on Fri, 25 July 2008 02:11
  Re: ora-04030
By: Michel Cadot on Fri, 25 July 2008 02:24
  Re: ora-04030
By: srini_thiru on Fri, 25 July 2008 03:19
  Re: ora-04030
By: sunil_v_mishra on Mon, 28 July 2008 14:26
  Re: ora-04030
By: hristo on Fri, 25 July 2008 02:45
  Re: ora-04030
By: srini_thiru on Fri, 25 July 2008 02:58
  Re: ora-04030
By: Michel Cadot on Fri, 25 July 2008 03:18
  Re: ora-04030
By: srini_thiru on Thu, 31 July 2008 05:35
  Re: ora-04030
By: Michel Cadot on Thu, 31 July 2008 05:42
  Reverse key index
By: getritesh on Tue, 29 July 2008 04:07
  Re: Reverse key index
By: Michel Cadot on Tue, 29 July 2008 04:29
  Re: Reverse key index
By: getritesh on Tue, 29 July 2008 05:24
  Re: Reverse key index
By: rleishman on Tue, 29 July 2008 22:03
  Re: Reverse key index
By: getritesh on Wed, 30 July 2008 03:21
  Re: Reverse key index
By: sunil_v_mishra on Wed, 30 July 2008 16:45
  Re: Reverse key index
By: getritesh on Wed, 30 July 2008 21:36
  Re: Reverse key index
By: rleishman on Wed, 30 July 2008 22:52
  Re: Reverse key index
By: BlackSwan on Wed, 30 July 2008 22:31
  Performance
By: manoj12 on Thu, 24 July 2008 05:35
  Re: Performance
By: Mahesh Rajendran on Thu, 24 July 2008 07:04
  Re: Performance
By: manoj12 on Thu, 24 July 2008 07:08
  Re: Performance
By: Mahesh Rajendran on Thu, 24 July 2008 07:11
  Re: Performance
By: manoj12 on Thu, 24 July 2008 07:17
  Re: Performance
By: manoj12 on Fri, 25 July 2008 04:15
  Re: Performance
By: rleishman on Fri, 25 July 2008 07:45
  Re: Performance
By: manoj12 on Tue, 29 July 2008 00:02
  Re: Performance
By: rleishman on Tue, 29 July 2008 22:09
  Stale Statisics
By: rsreddy28 on Tue, 29 July 2008 04:58
  Re: Stale Statisics
By: Michel Cadot on Tue, 29 July 2008 05:24
  gather stats
By: ArvindBhope on Tue, 29 July 2008 00:23
  Re: gather stats
By: Michel Cadot on Tue, 29 July 2008 01:11
  Re: gather stats
By: ArvindBhope on Tue, 29 July 2008 02:37
  Re: gather stats
By: Michel Cadot on Tue, 29 July 2008 03:19
  Tuning 'LIKE' Clause
By: getritesh on Mon, 28 July 2008 12:48
  Re: Tuning 'LIKE' Clause
By: sunil_v_mishra on Mon, 28 July 2008 13:59
  Re: Tuning 'LIKE' Clause
By: Michel Cadot on Mon, 28 July 2008 14:24
  type tables in plsql/ variable IN list
By: eaganfox on Fri, 25 July 2008 09:25
  Re: type tables in plsql/ variable IN list
By: szogu on Fri, 25 July 2008 09:34
  Re: type tables in plsql/ variable IN list
By: eaganfox on Fri, 25 July 2008 09:36
  Re: type tables in plsql/ variable IN list
By: coleing on Fri, 25 July 2008 17:54
  need help to optimize the query
By: skumar.dba on Wed, 23 July 2008 19:16
  Re: need help to optimize the query
By: rleishman on Thu, 24 July 2008 22:26
  need assistance to tune the query
By: kumar.joy on Thu, 24 July 2008 11:56
  Re: need assistance to tune the query
By: Michel Cadot on Thu, 24 July 2008 12:22
  Re: need assistance to tune the query
By: kumar.joy on Thu, 24 July 2008 12:44
  Re: need assistance to tune the query
By: Michel Cadot on Thu, 24 July 2008 12:55
  Re: need assistance to tune the query
By: kumar.joy on Thu, 24 July 2008 13:07
  Re: need assistance to tune the query
By: Michel Cadot on Thu, 24 July 2008 13:17
  Re: need assistance to tune the query
By: BlackSwan on Thu, 24 July 2008 12:48
  Re: need assistance to tune the query
By: BlackSwan on Thu, 24 July 2008 14:48
  Re: need assistance to tune the query
By: rleishman on Thu, 24 July 2008 22:22
  Testing of generated test data from Sequence
By: sreechaitu on Thu, 24 July 2008 13:01
  Re: Testing of generated test data from Sequence
By: BlackSwan on Thu, 24 July 2008 13:08
  how find SGA size is sufficient or not?
By: skumar.dba on Tue, 22 July 2008 17:46
  Re: how find SGA size is sufficient or not?
By: BlackSwan on Tue, 22 July 2008 17:50
  Re: how find SGA size is sufficient or not?
By: Michel Cadot on Tue, 22 July 2008 23:36
  Re: how find SGA size is sufficient or not?
By: sunil_v_mishra on Wed, 23 July 2008 08:07
  Re: how find SGA size is sufficient or not?
By: Michel Cadot on Wed, 23 July 2008 08:14
  Re: how find SGA size is sufficient or not?
By: sunil_v_mishra on Wed, 23 July 2008 13:17
  Re: how find SGA size is sufficient or not?
By: Michel Cadot on Wed, 23 July 2008 13:31
  Re: how find SGA size is sufficient or not?
By: sunil_v_mishra on Thu, 24 July 2008 01:11
  Re: how find SGA size is sufficient or not?
By: Michel Cadot on Thu, 24 July 2008 01:44
  Is possible to turn the following into a view
By: bztom33 on Mon, 21 July 2008 11:53
  Re: Is possible to turn the following into a view
By: BlackSwan on Mon, 21 July 2008 11:55
  Re: Is possible to turn the following into a view
By: Kevin Meade on Mon, 21 July 2008 14:51
  Re: Is possible to turn the following into a view
By: bztom33 on Wed, 23 July 2008 16:00
  Re: Is possible to turn the following into a view
By: Kevin Meade on Wed, 23 July 2008 16:03
  high cost
By: balaji1482 on Thu, 17 July 2008 13:25
  Re: high cost
By: BlackSwan on Thu, 17 July 2008 13:29
  Re: high cost
By: alanm on Thu, 17 July 2008 14:18
  Re: high cost
By: balaji1482 on Thu, 17 July 2008 17:22
  Re: high cost
By: rsoma on Fri, 18 July 2008 01:12
  Re: high cost
By: balaji1482 on Fri, 18 July 2008 17:17
  Re: high cost
By: BlackSwan on Fri, 18 July 2008 17:22
  Re: high cost
By: balaji1482 on Fri, 18 July 2008 19:10
  Re: high cost
By: BlackSwan on Fri, 18 July 2008 19:29
  Re: high cost
By: balaji1482 on Sat, 19 July 2008 09:58
  Re: high cost
By: Michel Cadot on Sat, 19 July 2008 10:00
  Re: high cost
By: JRowbottom on Mon, 21 July 2008 06:25
  Re: high cost
By: balaji1482 on Wed, 23 July 2008 10:28
  Avoiding : ORA-00470: LGWR process terminated with error
By: Josphat Kioko on Tue, 12 October 2004 04:56
  Re: Avoiding : ORA-00470: LGWR process terminated with error
By: sunil_v_mishra on Wed, 23 July 2008 07:54
  performance issues in insert stmt
By: jyothsna1612 on Wed, 23 July 2008 05:09
  Re: performance issues in insert stmt
By: Michel Cadot on Wed, 23 July 2008 05:28
  Slow query with customer data
By: elmu on Thu, 17 July 2008 09:03
  Re: Slow query with customer data
By: alanm on Thu, 17 July 2008 10:15
  Re: Slow query with customer data
By: rleishman on Sun, 20 July 2008 21:57
  Re: Slow query with customer data
By: elmu on Mon, 21 July 2008 07:30
  Re: Slow query with customer data
By: Kriptas on Mon, 21 July 2008 11:22
  Re: Slow query with customer data
By: rleishman on Mon, 21 July 2008 22:36
  Re: Slow query with customer data
By: MartinMM on Tue, 22 July 2008 03:35
  Re: Slow query with customer data
By: elmu on Tue, 22 July 2008 07:07
  Re: Slow query with customer data
By: Kriptas on Tue, 22 July 2008 13:19
  Better way to handle this query?
By: Olivia on Tue, 22 July 2008 06:38
  Re: Better way to handle this query?
By: Michel Cadot on Tue, 22 July 2008 06:45
  Re: Better way to handle this query?
By: Olivia on Tue, 22 July 2008 06:53
  Re: Better way to handle this query?
By: Olivia on Tue, 22 July 2008 08:45
  Re: Better way to handle this query?
By: tahpush on Tue, 22 July 2008 06:46
  Re: Better way to handle this query?
By: BlackSwan on Tue, 22 July 2008 11:00
  optimize queries
By: acarella on Fri, 18 July 2008 10:59
  Re: optimize queries
By: BlackSwan on Fri, 18 July 2008 11:02
  Re: optimize queries
By: Kevin Meade on Sat, 19 July 2008 01:50
  Re: optimize queries
By: acarella on Mon, 21 July 2008 07:30
  Re: optimize queries
By: michael_bialik on Tue, 22 July 2008 08:30
Pages (119): [ «    51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66    »]  Return to the default flat view Create a new topic
Goto Forum:
  
 [ Syndicate this forum (XML) ] [ RSS ]
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Fri Jul 05 14:01:34 CDT 2024