| |
|
Topic |
Replies |
Views |
Last message |
 |
 |
sticky: How to tune SQL or Identify Performance Problem and Bottleneck  |
7 |
82062 |
Sat, 07 March 2015 12:25
By: Kevin Meade  |
 |
|
 performance tuning
Oracle rdbms 11gR2 and #statspack By: alanm on Mon, 30 July 2018 |
3 |
1085 |
Mon, 30 July 2018 04:37
By: Roachcoach |
|
|
Appropriate join to the desired output
Oracle 11.2 By: senmng on Fri, 27 July 2018 |
2 |
871 |
Mon, 30 July 2018 03:21
By: cookiemonster |
|
|
Sql query to get Max,min and max-1 row from a table
Oracle 11.2 By: senmng on Sun, 22 July 2018 |
2 |
633 |
Sun, 22 July 2018 09:36
By: senmng |
|
|
please help for sql query to find out total number of concurrent connections in database
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: msol25 on Thu, 05 July 2018 |
6 |
1666 |
Thu, 05 July 2018 06:57
By: msol25 |
|
 |
Oracle Text index column when searching multiple tables
12.1.0.2.0 By: LFranz on Fri, 27 April 2018 |
7 |
3975 |
Thu, 28 June 2018 03:12
By: Barbara Boehmer |
|
|
Encountering issues with join condition in stored procedure
Oracle 11.2 By: senmng on Fri, 22 June 2018 |
4 |
1176 |
Sat, 23 June 2018 18:01
By: BlackSwan |
|
|
join is slow
Oracle12g By: Buchas on Fri, 25 May 2018 |
2 |
1604 |
Wed, 20 June 2018 05:22
By: michael_bialik |
|
|
Used Left Join - Query goes for Full Table scan
Oracle 11.2 |
7 |
1975 |
Wed, 20 June 2018 02:47
By: John Watson |
|
|
Wrong plan chosen by optimizer
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production OEL 6 |
11 |
1376 |
Wed, 30 May 2018 09:32
By: Andrey_R |
|
|
Wrong plan chosen by optimizer
Oracle 11.1.0.6 , OEL 6 |
14 |
1198 |
Wed, 23 May 2018 08:03
By: Andrey_R |
|
|
Distinct query taking long time to run
Oracle 11.2,Linux 6 By: senmng on Thu, 10 May 2018 |
7 |
2053 |
Tue, 22 May 2018 14:17
By: senmng |
|
|
ORA-07445: exception encountered: core dump [audplsfailure()+54]
Oracle DB 11.2.0.4 OS: Redhat Linux 6.9 64 Bit |
4 |
1425 |
Tue, 15 May 2018 11:25
By: Michel Cadot |
|
|
Stored procedure taking long time to run
Oracle 11.2, Linux v6 By: senmng on Thu, 03 May 2018 |
4 |
1940 |
Tue, 08 May 2018 10:17
By: BlackSwan |
|
|
Update Query Performance
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 |
2 |
1441 |
Thu, 03 May 2018 00:49
By: John Watson |
|
|
A case need to help clear
Oracle 11.2.0.4, any platform |
12 |
3450 |
Thu, 19 April 2018 05:03
By: John Watson |
|
|
Remove Merge cartesian Join
Oracle 10g |
1 |
1382 |
Wed, 11 April 2018 08:46
By: John Watson |
|
|
Finding downgraded sql
Oracle 12.1.0.2 |
2 |
1344 |
Thu, 05 April 2018 10:14
By: John Watson |
|
|
Is there a way to find out activities due to redo logs
11.2.0.4 Windows 2008 R2 Data Center |
15 |
53044 |
Wed, 04 April 2018 23:52
By: juniordbanewbie |
|
|
Better query for max(date) per account in big table
12.1.0.2.0 |
15 |
2460 |
Tue, 03 April 2018 08:10
By: Roachcoach |
|
|
Fine Tune Big SQL Reporting Query |
6 |
1992 |
Sun, 01 April 2018 16:18
By: dinavahi.saradhi@gmail.co |
|
|
Direct path load insert take much longer than query inside it
12.1.0.2.0 |
4 |
1890 |
Thu, 29 March 2018 08:33
By: Roachcoach |
|
|
Incosistent Wait Event
12.1.0.2.0 |
6 |
1391 |
Thu, 29 March 2018 05:06
By: Roachcoach |
|
|
optimzer dynmic smpling |
9 |
1763 |
Thu, 29 March 2018 02:34
By: John Watson |
|
|
Oracle Golden gate- Compression tables
Oracle 12CR2 |
4 |
2373 |
Thu, 29 March 2018 02:24
By: Roachcoach |
|
|
Reorganizing index datafiles with tables in partition (merged)
Oracle 10g 10.2.0.5, RHEL 6.2 By: reym21 on Mon, 26 March 2018 |
11 |
2480 |
Wed, 28 March 2018 08:34
By: JPBoileau |
|
|
SQL Query performance Tuning
RDBMS : 11.2.0.4.0 |
9 |
2695 |
Tue, 13 March 2018 09:21
By: msol25 |
|
|
Partitioning in table
Oracle 11gr2 rhel |
15 |
3225 |
Mon, 26 February 2018 09:55
By: Roachcoach |
|
|
How long lock should be in order to take snapshot of locks
11.2.0.4, windows 2012 SE |
6 |
2117 |
Thu, 08 February 2018 02:49
By: juniordbanewbie |
|
|
Can we delete specific execution plan in the db buffer for a statement
12.1.0.2 DB Linux 64 Bit |
2 |
10081 |
Thu, 08 February 2018 02:36
By: juniordbanewbie |
|
|
Move unused partitioned from one tablespace to another tablespace.
Oracle 12c (12.1.0.1.0)- Unix |
2 |
1997 |
Wed, 07 February 2018 03:23
By: daulat01 |
|
|
View Performance Tuning By: dancko on Tue, 30 January 2018 |
7 |
1944 |
Tue, 30 January 2018 10:34
By: cookiemonster |
|
|
Is there a equivalent of delete nologging operations
11.2.0.4 SE, Windows 2012 r2 Datacenter |
4 |
3310 |
Thu, 25 January 2018 18:13
By: juniordbanewbie |
|
|
Driving Table is not given more speed result
Oracle 11g |
15 |
4004 |
Thu, 25 January 2018 03:46
By: venkat_kayal |
|
|
Non-value Added Indexes
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
12 |
4177 |
Mon, 15 January 2018 08:15
By: msol25 |
|
|
Consuming a more time (low performance)
Oracle8i Enterprise Edition Release 8.1.7.0.0, for 32-bit Windows By: shawaj on Fri, 17 November 2017 |
4 |
2884 |
Sun, 24 December 2017 03:09
By: SmithXu |
|
|
Query taking 20 minutes in Production
ORACLE 11g By: manoj12 on Fri, 17 November 2017 |
3 |
2353 |
Fri, 15 December 2017 03:26
By: cookiemonster |
|
|
AWR Interpretation and analysis
oracle 11gr2 on linux |
7 |
2423 |
Fri, 08 December 2017 02:04
By: trantuananh24hg |
|
|
DB Health checks
oracle 11gr2 on linux |
16 |
3218 |
Thu, 07 December 2017 05:43
By: dba4oracle |
|
|
Running out of 64gb Temp Space
12c By: dbogey on Tue, 05 December 2017 |
2 |
1621 |
Tue, 05 December 2017 15:05
By: BlackSwan |
]
Members
Search
Help
Register
Login
Home