|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
performance tuning Oracle rdbms 11gR2 and #statspack By: alanm on Mon, 30 July 2018 |
3 |
12080 |
Mon, 30 July 2018 04:37 By: Roachcoach ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Sql query to get Max,min and max-1 row from a table Oracle 11.2 By: senmng on Sun, 22 July 2018 |
2 |
10190 |
Sun, 22 July 2018 09:36 By: senmng ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
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 |
13368 |
Thu, 05 July 2018 06:57 By: msol25 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Oracle Text index column when searching multiple tables 12.1.0.2.0 By: LFranz on Fri, 27 April 2018 |
7 |
19577 |
Thu, 28 June 2018 03:12 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Encountering issues with join condition in stored procedure Oracle 11.2 By: senmng on Fri, 22 June 2018 |
4 |
11669 |
Sat, 23 June 2018 18:01 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
join is slow Oracle12g By: Buchas on Fri, 25 May 2018 |
2 |
9616 |
Wed, 20 June 2018 05:22 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Used Left Join - Query goes for Full Table scan Oracle 11.2 |
7 |
12745 |
Wed, 20 June 2018 02:47 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Wrong plan chosen by optimizer Oracle Database 11g Release 11.2.0.1.0 - 64bit Production OEL 6 |
11 |
10957 |
Wed, 30 May 2018 09:32 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Wrong plan chosen by optimizer Oracle 11.1.0.6 , OEL 6 |
14 |
11867 |
Wed, 23 May 2018 08:03 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Distinct query taking long time to run Oracle 11.2,Linux 6 By: senmng on Thu, 10 May 2018 |
7 |
10534 |
Tue, 22 May 2018 14:17 By: senmng ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-07445: exception encountered: core dump [audplsfailure()+54] Oracle DB 11.2.0.4 OS: Redhat Linux 6.9 64 Bit |
4 |
20919 |
Tue, 15 May 2018 11:25 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Stored procedure taking long time to run Oracle 11.2, Linux v6 By: senmng on Thu, 03 May 2018 |
4 |
9415 |
Tue, 08 May 2018 10:17 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Update Query Performance Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 |
2 |
8097 |
Thu, 03 May 2018 00:49 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
A case need to help clear Oracle 11.2.0.4, any platform |
12 |
12026 |
Thu, 19 April 2018 05:03 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Remove Merge cartesian Join Oracle 10g |
1 |
7884 |
Wed, 11 April 2018 08:46 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Finding downgraded sql Oracle 12.1.0.2 |
2 |
7752 |
Thu, 05 April 2018 10:14 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Is there a way to find out activities due to redo logs 11.2.0.4 Windows 2008 R2 Data Center |
15 |
69862 |
Wed, 04 April 2018 23:52 By: juniordbanewbie ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Better query for max(date) per account in big table 12.1.0.2.0 |
15 |
10797 |
Tue, 03 April 2018 08:10 By: Roachcoach ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Fine Tune Big SQL Reporting Query |
6 |
9378 |
Sun, 01 April 2018 16:18 By: dinavahi.saradhi@gmail.co ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Direct path load insert take much longer than query inside it 12.1.0.2.0 |
4 |
8029 |
Thu, 29 March 2018 08:33 By: Roachcoach ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Incosistent Wait Event 12.1.0.2.0 |
6 |
7174 |
Thu, 29 March 2018 05:06 By: Roachcoach ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
optimzer dynmic smpling |
9 |
8908 |
Thu, 29 March 2018 02:34 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Golden gate- Compression tables Oracle 12CR2 |
4 |
9127 |
Thu, 29 March 2018 02:24 By: Roachcoach ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
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 |
9231 |
Wed, 28 March 2018 08:34 By: JPBoileau ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Query performance Tuning RDBMS : 11.2.0.4.0 |
9 |
11577 |
Tue, 13 March 2018 09:21 By: msol25 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Partitioning in table Oracle 11gr2 rhel |
15 |
12124 |
Mon, 26 February 2018 09:55 By: Roachcoach ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How long lock should be in order to take snapshot of locks 11.2.0.4, windows 2012 SE |
6 |
8445 |
Thu, 08 February 2018 02:49 By: juniordbanewbie ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Can we delete specific execution plan in the db buffer for a statement 12.1.0.2 DB Linux 64 Bit |
2 |
16468 |
Thu, 08 February 2018 02:36 By: juniordbanewbie ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Move unused partitioned from one tablespace to another tablespace. Oracle 12c (12.1.0.1.0)- Unix |
2 |
6622 |
Wed, 07 February 2018 03:23 By: daulat01 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
View Performance Tuning By: dancko on Tue, 30 January 2018 |
7 |
7594 |
Tue, 30 January 2018 10:34 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Is there a equivalent of delete nologging operations 11.2.0.4 SE, Windows 2012 r2 Datacenter |
4 |
9059 |
Thu, 25 January 2018 18:13 By: juniordbanewbie ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Driving Table is not given more speed result Oracle 11g |
15 |
12338 |
Thu, 25 January 2018 03:46 By: venkat_kayal ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Non-value Added Indexes Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
12 |
11958 |
Mon, 15 January 2018 08:15 By: msol25 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
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 |
3 |
8475 |
Fri, 15 December 2017 07:06 By: JohnMax ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query taking 20 minutes in Production ORACLE 11g By: manoj12 on Fri, 17 November 2017 |
3 |
7394 |
Fri, 15 December 2017 03:26 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
AWR Interpretation and analysis oracle 11gr2 on linux |
7 |
7698 |
Fri, 08 December 2017 02:04 By: trantuananh24hg ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DB Health checks oracle 11gr2 on linux |
16 |
9991 |
Thu, 07 December 2017 05:43 By: dba4oracle ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Running out of 64gb Temp Space 12c By: dbogey on Tue, 05 December 2017 |
2 |
6380 |
Tue, 05 December 2017 15:05 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Session Trace file Location - Oracle 12c oracle 12c Windows 2012 |
3 |
6159 |
Mon, 04 December 2017 03:24 By: muthukrish104 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Undo tablespace(monitoring and avoiding ORA-01555 oracle 11grw on linux |
8 |
8532 |
Sat, 11 November 2017 08:02 By: trantuananh24hg ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |