OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning
Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

		PLAN_TABLE_OUTPUT By: P1Oracle on Thu, 10 December 2015 03:49
		Re: PLAN_TABLE_OUTPUT By: P1Oracle on Thu, 10 December 2015 03:52
		Re: PLAN_TABLE_OUTPUT By: John Watson on Thu, 10 December 2015 04:02
		Re: PLAN_TABLE_OUTPUT By: cookiemonster on Thu, 10 December 2015 04:47
		Re: PLAN_TABLE_OUTPUT By: msol25 on Thu, 10 December 2015 05:37
		Re: PLAN_TABLE_OUTPUT By: cookiemonster on Thu, 10 December 2015 07:49
		Re: PLAN_TABLE_OUTPUT By: pablolee on Thu, 10 December 2015 07:50
		Re: PLAN_TABLE_OUTPUT By: cookiemonster on Thu, 10 December 2015 10:49
		Re: PLAN_TABLE_OUTPUT By: P1Oracle on Thu, 10 December 2015 06:16
		Re: PLAN_TABLE_OUTPUT By: John Watson on Thu, 10 December 2015 06:20
		Re: PLAN_TABLE_OUTPUT By: P1Oracle on Thu, 10 December 2015 06:24
		Re: PLAN_TABLE_OUTPUT By: msol25 on Thu, 10 December 2015 07:10
		Re: PLAN_TABLE_OUTPUT By: cookiemonster on Thu, 10 December 2015 07:46

		Export from table vs external table By: mokarem on Mon, 07 December 2015 04:53
		Re: Export from table vs external table By: John Watson on Mon, 07 December 2015 04:58
		Re: Export from table vs external table By: mokarem on Mon, 07 December 2015 05:08
		Re: Export from table vs external table By: cookiemonster on Mon, 07 December 2015 05:26
		Re: Export from table vs external table By: Michel Cadot on Tue, 08 December 2015 03:16
		Re: Export from table vs external table By: mokarem on Tue, 08 December 2015 03:40
		Re: Export from table vs external table By: John Watson on Tue, 08 December 2015 03:46
		Re: Export from table vs external table By: Michel Cadot on Tue, 08 December 2015 04:03
		Re: Export from table vs external table By: mokarem on Tue, 08 December 2015 04:21
		Re: Export from table vs external table By: Michel Cadot on Tue, 08 December 2015 04:52

		MULTI TABLE INSERT USING BULK COLLECT By: ramanaapps on Mon, 07 December 2015 04:37
		Re: MULTI TABLE INSERT USING BULK COLLECT By: Littlefoot on Mon, 07 December 2015 04:42
		Re: MULTI TABLE INSERT USING BULK COLLECT By: ramanaapps on Mon, 07 December 2015 04:45
		Re: MULTI TABLE INSERT USING BULK COLLECT By: Michel Cadot on Mon, 07 December 2015 04:44
		Re: MULTI TABLE INSERT USING BULK COLLECT By: John Watson on Mon, 07 December 2015 04:50
		Re: MULTI TABLE INSERT USING BULK COLLECT By: ramanaapps on Mon, 07 December 2015 05:17
		Re: MULTI TABLE INSERT USING BULK COLLECT By: John Watson on Mon, 07 December 2015 05:19
		Re: MULTI TABLE INSERT USING BULK COLLECT By: ramanaapps on Mon, 07 December 2015 05:36
		Re: MULTI TABLE INSERT USING BULK COLLECT By: Michel Cadot on Mon, 07 December 2015 05:40

		Please help for tuning .sql query By: msol25 on Tue, 03 November 2015 03:44
		Re: Please help for tuning .sql query By: John Watson on Tue, 03 November 2015 03:49
		Re: Please help for tuning .sql query By: msol25 on Tue, 03 November 2015 03:52
		Re: Please help for tuning .sql query By: John Watson on Tue, 03 November 2015 03:55
		Re: Please help for tuning .sql query By: msol25 on Tue, 03 November 2015 04:02
		Re: Please help for tuning .sql query By: msol25 on Tue, 03 November 2015 04:05
		Re: Please help for tuning .sql query By: Michel Cadot on Tue, 03 November 2015 04:08
		Re: Please help for tuning .sql query By: msol25 on Tue, 03 November 2015 04:13
		Re: Please help for tuning .sql query By: John Watson on Tue, 03 November 2015 04:17
		Re: Please help for tuning .sql query By: msol25 on Tue, 03 November 2015 04:29
		Re: Please help for tuning .sql query By: John Watson on Tue, 03 November 2015 04:30
		Re: Please help for tuning .sql query By: Michel Cadot on Tue, 03 November 2015 04:35
		Re: Please help for tuning .sql query By: Kevin Meade on Tue, 01 December 2015 22:24
		Re: Please help for tuning .sql query By: John Watson on Tue, 03 November 2015 04:12
		Re: Please help for tuning .sql query By: Michel Cadot on Tue, 03 November 2015 04:07
		Re: Please help for tuning .sql query By: John Watson on Tue, 03 November 2015 04:14
		Re: Please help for tuning .sql query By: cookiemonster on Tue, 03 November 2015 03:57
		Re: Please help for tuning .sql query By: John Watson on Tue, 03 November 2015 03:59

		OPT_PARAM - WORK_AREA_POLICY By: rasikeg@gmail.com on Tue, 03 November 2015 09:46
		Re: OPT_PARAM - WORK_AREA_POLICY By: Michel Cadot on Tue, 03 November 2015 10:25
		Re: OPT_PARAM - WORK_AREA_POLICY By: Kevin Meade on Tue, 01 December 2015 21:57

		Testing SPM By: orausern on Fri, 27 November 2015 08:28
		Re: Testing SPM By: BlackSwan on Fri, 27 November 2015 08:48
		Re: Testing SPM By: orausern on Fri, 27 November 2015 09:02
		Re: Testing SPM By: orausern on Fri, 27 November 2015 09:53
		Re: Testing SPM By: BlackSwan on Fri, 27 November 2015 19:25
		Re: Testing SPM By: orausern on Sat, 28 November 2015 00:35
		Re: Testing SPM By: John Watson on Sat, 28 November 2015 04:27
		Re: Testing SPM By: orausern on Sat, 28 November 2015 04:35
		Re: Testing SPM By: John Watson on Sat, 28 November 2015 04:38
		Re: Testing SPM By: orausern on Sat, 28 November 2015 04:40
		Re: Testing SPM By: orausern on Sat, 28 November 2015 04:43
		Re: Testing SPM By: LNossov on Tue, 01 December 2015 05:20
		Re: Testing SPM By: orausern on Tue, 01 December 2015 09:18

		Making Oracle generate and use different execution plans for any sql By: orausern on Sat, 28 November 2015 09:11
		Re: Making Oracle generate and use different execution plans for any sql By: John Watson on Sun, 29 November 2015 01:41
		Re: Making Oracle generate and use different execution plans for any sql By: orausern on Sun, 29 November 2015 05:56

		Execution plan cost By: pointers on Wed, 25 November 2015 05:13
		Re: Execution plan cost By: Michel Cadot on Wed, 25 November 2015 06:33
		Re: Execution plan cost By: John Watson on Wed, 25 November 2015 08:58
		Re: Execution plan cost By: pointers on Thu, 26 November 2015 00:25

		dbms_xplan By: pointers on Tue, 27 October 2015 07:02
		Re: dbms_xplan By: Michel Cadot on Tue, 27 October 2015 08:05
		Re: dbms_xplan By: LNossov on Wed, 11 November 2015 05:50
		Re: dbms_xplan By: pointers on Tue, 24 November 2015 05:54

		Locking modes By: m.abdulhaq on Fri, 23 October 2015 04:26
		Re: Locking modes By: Littlefoot on Fri, 23 October 2015 04:52
		Re: Locking modes By: cookiemonster on Fri, 23 October 2015 04:57
		Re: Locking modes By: Michel Cadot on Fri, 23 October 2015 09:48
		Re: Locking modes By: m.abdulhaq on Fri, 23 October 2015 21:15
		Re: Locking modes By: BlackSwan on Fri, 23 October 2015 21:23
		Re: Locking modes By: m.abdulhaq on Sat, 24 October 2015 02:09
		Re: Locking modes By: m.abdulhaq on Sun, 25 October 2015 00:00
		Re: Locking modes By: BlackSwan on Sun, 25 October 2015 08:37
		Re: Locking modes By: m.abdulhaq on Mon, 26 October 2015 07:02
		Re: Locking modes By: BlackSwan on Mon, 26 October 2015 08:16
		Re: Locking modes By: m.abdulhaq on Mon, 26 October 2015 23:23
		Re: Locking modes By: cookiemonster on Tue, 27 October 2015 04:52
		Re: Locking modes By: vittalgh on Wed, 11 November 2015 10:28
		Re: Locking modes By: cookiemonster on Wed, 11 November 2015 10:35

		SQL*Net roundtrips By: gkrishn on Sat, 07 November 2015 23:22
		Re: SQL*Net roundtrips By: Michel Cadot on Sat, 07 November 2015 23:59
		Re: SQL*Net roundtrips By: gkrishn on Sun, 08 November 2015 00:16
		Re: SQL*Net roundtrips By: gkrishn on Sun, 08 November 2015 00:18
		Re: SQL*Net roundtrips By: Michel Cadot on Sun, 08 November 2015 00:38
		Re: SQL*Net roundtrips By: gkrishn on Sun, 08 November 2015 00:46
		Re: SQL*Net roundtrips By: Michel Cadot on Sun, 08 November 2015 00:52
		Re: SQL*Net roundtrips By: gkrishn on Sun, 08 November 2015 01:25
		Re: SQL*Net roundtrips By: Michel Cadot on Sun, 08 November 2015 01:30
		Re: SQL*Net roundtrips By: gkrishn on Sun, 08 November 2015 01:41

		dynamic sampling precedence By: kal_youssef on Tue, 03 November 2015 14:48
		Re: dynamic sampling precedence By: BlackSwan on Tue, 03 November 2015 14:53
		Re: dynamic sampling precedence By: John Watson on Tue, 03 November 2015 16:12

		Please help for tuning .sql query By: msol25 on Sun, 01 November 2015 08:26
		Re: Please help for tuning .sql query By: BlackSwan on Sun, 01 November 2015 08:32
		Re: Please help for tuning .sql query By: cookiemonster on Mon, 02 November 2015 03:10

		Unexplained SQL Slowness (AWR Supplied) By: ganna76 on Wed, 28 October 2015 05:31
		Re: Unexplained SQL Slowness (AWR Supplied) By: John Watson on Wed, 28 October 2015 05:36
		Re: Unexplained SQL Slowness (AWR Supplied) By: ganna76 on Wed, 28 October 2015 06:55
		Re: Unexplained SQL Slowness (AWR Supplied) By: John Watson on Wed, 28 October 2015 07:14
		Re: Unexplained SQL Slowness (AWR Supplied) By: ganna76 on Wed, 28 October 2015 08:56
		Re: Unexplained SQL Slowness (AWR Supplied) By: ganna76 on Wed, 28 October 2015 10:19

		A SQL query with self join and analytical function is running slow By: toitdoctor on Wed, 23 September 2015 00:33
		Re: A SQL query with self join and analytical function is running slow By: cookiemonster on Wed, 23 September 2015 02:35
		Re: A SQL query with self join and analytical function is running slow By: cookiemonster on Wed, 23 September 2015 02:49
		Re: A SQL query with self join and analytical function is running slow By: cookiemonster on Wed, 23 September 2015 02:51
		Re: A SQL query with self join and analytical function is running slow By: cookiemonster on Wed, 23 September 2015 03:22
		Re: A SQL query with self join and analytical function is running slow By: cookiemonster on Mon, 19 October 2015 03:16
		Re: A SQL query with self join and analytical function is running slow By: toitdoctor on Wed, 23 September 2015 09:20
		Re: A SQL query with self join and analytical function is running slow By: cookiemonster on Wed, 23 September 2015 09:28
		Re: A SQL query with self join and analytical function is running slow By: Kevin Meade on Fri, 25 September 2015 23:56
		Re: A SQL query with self join and analytical function is running slow By: toitdoctor on Sat, 17 October 2015 16:23
		Re: A SQL query with self join and analytical function is running slow By: BlackSwan on Sat, 17 October 2015 16:36
		Re: A SQL query with self join and analytical function is running slow By: toitdoctor on Sun, 18 October 2015 10:33
		Re: A SQL query with self join and analytical function is running slow By: BlackSwan on Sun, 18 October 2015 10:36
		Re: A SQL query with self join and analytical function is running slow By: Kevin Meade on Sat, 17 October 2015 17:51
		Re: A SQL query with self join and analytical function is running slow By: John Watson on Mon, 19 October 2015 05:53

		Memory issue with PGA and AMM (merged) By: preet_kumar on Wed, 14 October 2015 10:00
		Re: Memory issue with PGA and AMM By: John Watson on Wed, 14 October 2015 10:11
		More PGA allocated than SGA By: preet_kumar on Sun, 18 October 2015 02:21
		Re: More PGA allocated than SGA By: Michel Cadot on Sun, 18 October 2015 03:16

		Please help for Tuning sql Query. By: msol25 on Thu, 15 October 2015 02:26
		Re: Please help for Tuning sql Query. By: Michel Cadot on Thu, 15 October 2015 02:38
		Re: Please help for Tuning sql Query. By: msol25 on Thu, 15 October 2015 02:44
		Re: Please help for Tuning sql Query. By: cookiemonster on Thu, 15 October 2015 02:52
		Re: Please help for Tuning sql Query. By: msol25 on Thu, 15 October 2015 03:29
		Re: Please help for Tuning sql Query. By: cookiemonster on Thu, 15 October 2015 03:43
		Re: Please help for Tuning sql Query. By: msol25 on Thu, 15 October 2015 03:51
		Re: Please help for Tuning sql Query. By: cookiemonster on Thu, 15 October 2015 03:55
		Re: Please help for Tuning sql Query. By: Michel Cadot on Thu, 15 October 2015 05:01
		Re: Please help for Tuning sql Query. By: Kevin Meade on Sat, 17 October 2015 01:20
		Re: Please help for Tuning sql Query. By: John Watson on Thu, 15 October 2015 03:28
		Re: Please help for Tuning sql Query. By: msol25 on Thu, 15 October 2015 03:33
		Re: Please help for Tuning sql Query. By: John Watson on Thu, 15 October 2015 03:33
		Re: Please help for Tuning sql Query. By: msol25 on Thu, 15 October 2015 03:40

		Facing performance issues in simple insert statement from Oracle 10g By: toitdoctor on Fri, 16 October 2015 00:21
		Re: Facing performance issues in simple insert statement from Oracle 10g By: BlackSwan on Fri, 16 October 2015 00:30
		Re: Facing performance issues in simple insert statement from Oracle 10g By: Michel Cadot on Fri, 16 October 2015 01:31
		Re: Facing performance issues in simple insert statement from Oracle 10g By: Littlefoot on Fri, 16 October 2015 14:56

		Any good Way to get dNFS IOPS? By: ThomasG on Thu, 15 October 2015 03:06
		Re: Any good Way to get dNFS IOPS? By: John Watson on Thu, 15 October 2015 03:17
		Re: Any good Way to get dNFS IOPS? By: ThomasG on Thu, 15 October 2015 03:28

		Can we manually assign certain query transaction between RAC nodes ? By: carillpower on Tue, 29 September 2015 22:24
		Re: Can we manually assign certain query transaction between RAC nodes ? By: BlackSwan on Tue, 29 September 2015 22:35
		Re: Can we manually assign certain query transaction between RAC nodes ? By: carillpower on Tue, 29 September 2015 22:59
		Re: Can we manually assign certain query transaction between RAC nodes ? By: BlackSwan on Tue, 29 September 2015 23:18
		Re: Can we manually assign certain query transaction between RAC nodes ? By: carillpower on Wed, 30 September 2015 02:30
		Re: Can we manually assign certain query transaction between RAC nodes ? By: John Watson on Wed, 30 September 2015 02:50
		Re: Can we manually assign certain query transaction between RAC nodes ? By: carillpower on Wed, 30 September 2015 03:25
		Re: Can we manually assign certain query transaction between RAC nodes ? By: bpeasland on Wed, 30 September 2015 09:35
		Re: Can we manually assign certain query transaction between RAC nodes ? By: Kevin Meade on Wed, 30 September 2015 23:19
		Re: Can we manually assign certain query transaction between RAC nodes ? By: carillpower on Sun, 04 October 2015 20:23
		Re: Can we manually assign certain query transaction between RAC nodes ? By: bpeasland on Mon, 05 October 2015 09:36
		Re: Can we manually assign certain query transaction between RAC nodes ? By: John Watson on Wed, 30 September 2015 01:52

		Explain plan depends on Oracle client? By: Buchas on Tue, 29 September 2015 05:56
		Re: Explain plan depends on Oracle client? By: John Watson on Tue, 29 September 2015 06:47
		Re: Explain plan depends on Oracle client? By: cookiemonster on Tue, 29 September 2015 08:23
		Re: Explain plan depends on Oracle client? By: Buchas on Tue, 29 September 2015 08:43
		Re: Explain plan depends on Oracle client? By: John Watson on Tue, 29 September 2015 08:57

		Tuning By: eml2raghu on Wed, 23 September 2015 06:12
		Re: Tuning By: pablolee on Wed, 23 September 2015 07:27
		Re: Tuning By: Kevin Meade on Sat, 26 September 2015 00:06
		tuning By: eml2raghu on Fri, 25 September 2015 12:04
		Re: tuning By: BlackSwan on Fri, 25 September 2015 12:13
		Re: tuning By: BlackSwan on Fri, 25 September 2015 13:00
		Re: tuning By: Kevin Meade on Fri, 25 September 2015 23:26
		Re: tuning By: eml2raghu on Sat, 26 September 2015 11:44
		Re: tuning By: BlackSwan on Sat, 26 September 2015 11:58
		Re: tuning By: eml2raghu on Tue, 29 September 2015 08:35
		Re: tuning By: cookiemonster on Tue, 29 September 2015 08:37
		Re: tuning By: BlackSwan on Tue, 29 September 2015 08:50

		Unable to interpret number of rows accessed during Full Table scan By: orapratap on Wed, 23 September 2015 07:13
		Re: Unable to interpret number of rows accessed during Full Table scan By: John Watson on Wed, 23 September 2015 07:18
		Re: Unable to interpret number of rows accessed during Full Table scan By: orapratap on Wed, 23 September 2015 07:25
		Re: Unable to interpret number of rows accessed during Full Table scan By: bpeasland on Wed, 23 September 2015 09:08
		Re: Unable to interpret number of rows accessed during Full Table scan By: orapratap on Wed, 23 September 2015 09:24
		Re: Unable to interpret number of rows accessed during Full Table scan By: John Watson on Wed, 23 September 2015 09:27
		Re: Unable to interpret number of rows accessed during Full Table scan By: orapratap on Wed, 23 September 2015 10:05
		Re: Unable to interpret number of rows accessed during Full Table scan By: BlackSwan on Wed, 23 September 2015 10:05
		Re: Unable to interpret number of rows accessed during Full Table scan By: orapratap on Wed, 23 September 2015 10:08
		Re: Unable to interpret number of rows accessed during Full Table scan By: bpeasland on Thu, 24 September 2015 08:58
		Re: Unable to interpret number of rows accessed during Full Table scan By: Kevin Meade on Fri, 25 September 2015 23:38
		Re: Unable to interpret number of rows accessed during Full Table scan By: orapratap on Mon, 28 September 2015 05:14
		Re: Unable to interpret number of rows accessed during Full Table scan By: Kevin Meade on Mon, 28 September 2015 06:43

		Query does not error, but does not come back with a result set (as if it's ... By: aft5425@anthem.com on Sun, 13 September 2015 17:15
		Re: Query does not error, but does not come back with a result set (as if i... By: BlackSwan on Sun, 13 September 2015 17:24
		Re: Query does not error, but does not come back with a result set (as if i... By: aft5425@anthem.com on Sun, 13 September 2015 17:41
		Re: Query does not error, but does not come back with a result set (as if i... By: BlackSwan on Sun, 13 September 2015 17:46
		Re: Query does not error, but does not come back with a result set (as if i... By: aft5425@anthem.com on Sun, 13 September 2015 19:48
		Re: Query does not error, but does not come back with a result set (as if i... By: BlackSwan on Sun, 13 September 2015 20:08
		Re: Query does not error, but does not come back with a result set (as if i... By: BlackSwan on Sun, 13 September 2015 20:15
		Re: Query does not error, but does not come back with a result set (as if i... By: aft5425@anthem.com on Sun, 13 September 2015 20:31
		Re: Query does not error, but does not come back with a result set (as if i... By: aft5425@anthem.com on Sun, 13 September 2015 20:34
		Re: Query does not error, but does not come back with a result set (as if i... By: BlackSwan on Sun, 13 September 2015 21:23
		Re: Query does not error, but does not come back with a result set (as if i... By: aft5425@anthem.com on Sun, 13 September 2015 21:50
		Re: Query does not error, but does not come back with a result set (as if i... By: BlackSwan on Sun, 13 September 2015 21:59
		Re: Query does not error, but does not come back with a result set (as if i... By: aft5425@anthem.com on Sun, 13 September 2015 22:30
		Re: Query does not error, but does not come back with a result set (as if i... By: BlackSwan on Sun, 13 September 2015 22:48
		Re: Query does not error, but does not come back with a result set (as if i... By: Kevin Meade on Mon, 14 September 2015 00:52
		Re: Query does not error, but does not come back with a result set (as if i... By: cookiemonster on Mon, 14 September 2015 04:15
		Re: Query does not error, but does not come back with a result set (as if i... By: aft5425@anthem.com on Wed, 16 September 2015 15:24
		Re: Query does not error, but does not come back with a result set (as if i... By: John Watson on Mon, 14 September 2015 04:56
		Re: Query does not error, but does not come back with a result set (as if i... By: cookiemonster on Mon, 14 September 2015 05:13
		Re: Query does not error, but does not come back with a result set (as if i... By: cookiemonster on Mon, 14 September 2015 05:19
		Re: Query does not error, but does not come back with a result set (as if i... By: aft5425@anthem.com on Wed, 16 September 2015 15:18

		Performance improvement required By: saurabh.sha on Wed, 18 March 2015 08:02
		Re: Performance improvement required By: saurabh.sha on Wed, 18 March 2015 08:03
		Re: Performance improvement required By: Lalit Kumar B on Thu, 19 March 2015 09:30
		Re: Performance improvement required By: John Watson on Thu, 19 March 2015 11:54
		Re: Performance improvement required By: BlackSwan on Thu, 19 March 2015 12:00
		Re: Performance improvement required By: saurabh.sha on Fri, 20 March 2015 03:17
		Re: Performance improvement required By: John Watson on Sat, 21 March 2015 03:55
		Re: Performance improvement required By: michael_bialik on Sun, 22 March 2015 07:17
		Re: Performance improvement required By: Kevin Meade on Sun, 22 March 2015 10:41
		Re: Performance improvement required By: saurabh.sha on Tue, 24 March 2015 05:19
		Re: Performance improvement required By: BlackSwan on Fri, 11 September 2015 09:12

		Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux By: Michel Cadot on Tue, 08 September 2015 05:01
		Re: Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linu... By: John Watson on Tue, 08 September 2015 05:24
		Re: Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linu... By: Michel Cadot on Tue, 08 September 2015 06:18
		Re: Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linu... By: John Watson on Wed, 09 September 2015 13:57

		cost is more after releasing FTS on big table (partition table) By: ashishkumarmahanta80 on Tue, 08 September 2015 01:38
		Re: cost is more after releasing FTS on big table (partition table) By: John Watson on Tue, 08 September 2015 01:55
		Re: cost is more after releasing FTS on big table (partition table) By: ashishkumarmahanta80 on Tue, 08 September 2015 02:12
		Re: cost is more after releasing FTS on big table (partition table) By: John Watson on Tue, 08 September 2015 02:18
		Re: cost is more after releasing FTS on big table (partition table) By: cookiemonster on Tue, 08 September 2015 03:00
		Re: cost is more after releasing FTS on big table (partition table) By: cookiemonster on Tue, 08 September 2015 03:19
		Re: cost is more after releasing FTS on big table (partition table) By: John Watson on Tue, 08 September 2015 03:59
		Re: cost is more after releasing FTS on big table (partition table) By: ashishkumarmahanta80 on Tue, 08 September 2015 07:09
		Re: cost is more after releasing FTS on big table (partition table) By: cookiemonster on Tue, 08 September 2015 08:01
		Re: cost is more after releasing FTS on big table (partition table) By: cookiemonster on Tue, 08 September 2015 08:06
		Re: cost is more after releasing FTS on big table (partition table) By: ashishkumarmahanta80 on Wed, 09 September 2015 00:55
		Re: cost is more after releasing FTS on big table (partition table) By: John Watson on Wed, 09 September 2015 01:35

		Query in active session for more than 2 hours By: varunvir on Mon, 08 June 2015 15:31
		Re: Query in active session for more than 2 hours By: BlackSwan on Mon, 08 June 2015 18:06
		Re: Query in active session for more than 2 hours By: varunvir on Tue, 09 June 2015 15:30
		Re: Query in active session for more than 2 hours By: shirleyhu on Thu, 03 September 2015 09:21
		Re: Query in active session for more than 2 hours By: John Watson on Thu, 03 September 2015 12:19
		Re: Query in active session for more than 2 hours By: Kevin Meade on Sun, 06 September 2015 10:14

		Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high times... By: orausern on Fri, 04 September 2015 11:34
		Re: Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high t... By: BlackSwan on Fri, 04 September 2015 11:44
		Re: Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high t... By: John Watson on Fri, 04 September 2015 11:45
		Re: Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high t... By: orausern on Fri, 04 September 2015 11:52
		Re: Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high t... By: John Watson on Fri, 04 September 2015 11:54
		Re: Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high t... By: BlackSwan on Fri, 04 September 2015 12:00
		Re: Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high t... By: orausern on Fri, 04 September 2015 13:07

		Oracle noforce view creates force view By: ram50958 on Tue, 25 August 2015 09:54
		Re: Oracle noforce view creates force view By: Michel Cadot on Tue, 25 August 2015 09:57
		Re: Oracle noforce view creates force view By: John Watson on Tue, 25 August 2015 09:59
		Re: Oracle noforce view creates force view By: cookiemonster on Tue, 25 August 2015 10:22
		Re: Oracle noforce view creates force view By: Michel Cadot on Tue, 25 August 2015 11:03
		Re: Oracle noforce view creates force view By: Michel Cadot on Tue, 25 August 2015 11:06
		Re: Oracle noforce view creates force view By: ram50958 on Tue, 25 August 2015 11:05
		Re: Oracle noforce view creates force view By: John Watson on Tue, 25 August 2015 11:11
		Re: Oracle noforce view creates force view By: Michel Cadot on Tue, 25 August 2015 11:13

		Response time By: kapilavastu on Tue, 21 July 2015 11:27
		Re: Response time By: BlackSwan on Tue, 21 July 2015 11:45
		Re: Response time By: John Watson on Tue, 21 July 2015 12:04
		Re: Response time By: Kevin Meade on Mon, 03 August 2015 22:44
		Re: Response time By: kapilavastu on Mon, 24 August 2015 19:22
		Re: Response time By: Kevin Meade on Mon, 24 August 2015 21:02

		Interesting performance bottle neck issue By: ram50958 on Wed, 19 August 2015 08:28
		Re: Interesting performance bottle neck issue By: BlackSwan on Wed, 19 August 2015 08:37
		Re: Interesting performance bottle neck issue By: John Watson on Wed, 19 August 2015 08:45
		Re: Interesting performance bottle neck issue By: cookiemonster on Wed, 19 August 2015 09:25
		Re: Interesting performance bottle neck issue By: cookiemonster on Wed, 19 August 2015 09:30
		Re: Interesting performance bottle neck issue By: John Watson on Wed, 19 August 2015 09:34
		Re: Interesting performance bottle neck issue By: ram50958 on Wed, 19 August 2015 09:42
		Re: Interesting performance bottle neck issue By: BlackSwan on Wed, 19 August 2015 09:47
		Re: Interesting performance bottle neck issue By: cookiemonster on Wed, 19 August 2015 09:48
		Re: Interesting performance bottle neck issue By: ram50958 on Wed, 19 August 2015 10:05
		Re: Interesting performance bottle neck issue By: BlackSwan on Wed, 19 August 2015 10:09

		Please help for Resolving Issue for Explain plan as query taking long time ... By: msol25 on Sun, 09 August 2015 04:47
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: msol25 on Sun, 09 August 2015 05:05
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: pablolee on Sun, 09 August 2015 05:55
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: msol25 on Sun, 09 August 2015 06:05
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: Michel Cadot on Sun, 09 August 2015 07:06
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: msol25 on Sun, 09 August 2015 07:21
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: cookiemonster on Sun, 09 August 2015 08:38
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: msol25 on Sun, 09 August 2015 08:51
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: Michel Cadot on Sun, 09 August 2015 08:58
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: John Watson on Sun, 09 August 2015 12:32
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: Kevin Meade on Mon, 10 August 2015 01:50
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: msol25 on Tue, 11 August 2015 06:51
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: pablolee on Tue, 11 August 2015 07:25
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: msol25 on Tue, 11 August 2015 09:34
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: cookiemonster on Tue, 11 August 2015 09:41
		Re: Please help for Resolving Issue for Explain plan as query taking long t... By: Kevin Meade on Fri, 14 August 2015 12:27

		statistics update By: sant_new1 on Thu, 13 August 2015 13:34
		Re: statistics update By: BlackSwan on Thu, 13 August 2015 13:46
		Re: statistics update By: Michel Cadot on Thu, 13 August 2015 14:39
		Re: statistics update By: sant_new1 on Thu, 13 August 2015 14:44
		Re: statistics update By: BlackSwan on Thu, 13 August 2015 14:51
		Re: statistics update By: sant_new1 on Thu, 13 August 2015 14:57
		Re: statistics update By: BlackSwan on Thu, 13 August 2015 15:03
		Re: statistics update By: Michel Cadot on Fri, 14 August 2015 01:06
		Re: statistics update By: Michel Cadot on Fri, 14 August 2015 01:05
		Re: statistics update By: sant_new1 on Fri, 14 August 2015 10:37
		Re: statistics update By: Kevin Meade on Fri, 14 August 2015 12:03
		Re: statistics update By: BlackSwan on Fri, 14 August 2015 12:07

		query with hundreds of bind variables By: fplatel on Tue, 11 August 2015 17:13
		Re: query with hundreds of bind variables By: BlackSwan on Tue, 11 August 2015 18:02
		Re: query with hundreds of bind variables By: John Watson on Tue, 11 August 2015 21:55

		Help to tune the query By: grpatwari on Mon, 03 August 2015 07:15
		Re: Help to tune the query By: John Watson on Mon, 03 August 2015 07:34
		Re: Help to tune the query By: Kevin Meade on Mon, 03 August 2015 22:41
		Re: Help to tune the query By: grpatwari on Tue, 04 August 2015 04:50
		Re: Help to tune the query By: Kevin Meade on Tue, 04 August 2015 07:26
		Re: Help to tune the query By: John Watson on Tue, 04 August 2015 07:47
		Re: Help to tune the query By: grpatwari on Wed, 05 August 2015 01:15
		Re: Help to tune the query By: Kevin Meade on Wed, 05 August 2015 08:25
		Re: Help to tune the query By: grpatwari on Thu, 06 August 2015 03:21
		Re: Help to tune the query By: Kevin Meade on Thu, 06 August 2015 08:14
		Re: Help to tune the query By: grpatwari on Fri, 07 August 2015 04:09
		Re: Help to tune the query By: Kevin Meade on Fri, 07 August 2015 08:56

		Cost Issue while using row_number() By: AJAYRAM on Thu, 06 August 2015 06:48
		Re: Cost Issue while using row_number() By: Michel Cadot on Thu, 06 August 2015 08:27
		Re: Cost Issue while using row_number() By: BlackSwan on Thu, 06 August 2015 08:49
		Re: Cost Issue while using row_number() By: gazzag on Thu, 06 August 2015 08:59
		Re: Cost Issue while using row_number() By: AJAYRAM on Fri, 07 August 2015 00:32
		Re: Cost Issue while using row_number() By: cookiemonster on Thu, 06 August 2015 09:05
		Re: Cost Issue while using row_number() By: AJAYRAM on Fri, 07 August 2015 01:08
		Re: Cost Issue while using row_number() By: cookiemonster on Fri, 07 August 2015 03:11
		Re: Cost Issue while using row_number() By: cookiemonster on Fri, 07 August 2015 03:12
		Re: Cost Issue while using row_number() By: AJAYRAM on Fri, 07 August 2015 04:37
		Re: Cost Issue while using row_number() By: cookiemonster on Fri, 07 August 2015 04:46
		Re: Cost Issue while using row_number() By: cookiemonster on Fri, 07 August 2015 04:48

		A way to identify the top sql other than AWR By: orausern on Tue, 04 August 2015 01:50
		Re: A way to identify the top sql other than AWR By: Michel Cadot on Tue, 04 August 2015 03:05
		Re: A way to identify the top sql other than AWR By: orausern on Tue, 04 August 2015 03:40
		Re: A way to identify the top sql other than AWR By: orausern on Tue, 04 August 2015 11:18
		Re: A way to identify the top sql other than AWR By: Michel Cadot on Tue, 04 August 2015 11:24
		Re: A way to identify the top sql other than AWR By: orausern on Tue, 04 August 2015 11:46

		TKPROF output analysis By: muktha_22 on Wed, 22 July 2015 02:20
		Re: TKPROF output analysis By: cookiemonster on Wed, 22 July 2015 02:38
		Re: TKPROF output analysis By: Michel Cadot on Wed, 22 July 2015 02:47
		Re: TKPROF output analysis By: muktha_22 on Thu, 23 July 2015 01:37
		Re: TKPROF output analysis By: Michel Cadot on Thu, 23 July 2015 01:39

		Tuning data deletion that is taking long time By: orausern on Sat, 11 July 2015 09:46
		Re: Tuning data deletion that is taking long time By: BlackSwan on Sat, 11 July 2015 10:49
		Re: Tuning data deletion that is taking long time By: orausern on Sat, 11 July 2015 11:25
		Re: Tuning data deletion that is taking long time By: John Watson on Sun, 12 July 2015 01:41
		Re: Tuning data deletion that is taking long time By: cookiemonster on Mon, 13 July 2015 07:11
		Re: Tuning data deletion that is taking long time By: orausern on Mon, 13 July 2015 10:08
		Re: Tuning data deletion that is taking long time By: BlackSwan on Mon, 13 July 2015 12:54
		Re: Tuning data deletion that is taking long time By: orausern on Mon, 13 July 2015 14:01
		Re: Tuning data deletion that is taking long time By: orausern on Tue, 14 July 2015 12:07
		Re: Tuning data deletion that is taking long time By: John Watson on Tue, 14 July 2015 12:14
		Re: Tuning data deletion that is taking long time By: orausern on Tue, 14 July 2015 12:58
		Re: Tuning data deletion that is taking long time By: orausern on Thu, 16 July 2015 15:19
		Re: Tuning data deletion that is taking long time By: BlackSwan on Thu, 16 July 2015 15:31
		Re: Tuning data deletion that is taking long time By: Michel Cadot on Thu, 16 July 2015 23:57
		Re: Tuning data deletion that is taking long time By: John Watson on Fri, 17 July 2015 01:12
		Re: Tuning data deletion that is taking long time By: orausern on Fri, 17 July 2015 05:59
		Re: Tuning data deletion that is taking long time By: orausern on Mon, 13 July 2015 10:07

Pages (119): [ « ‹ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Thu Apr 25 11:08:24 CDT 2024