| |
|
Topic |
Replies |
Views |
Last message |
 |
|
Finding downgraded sql
Oracle 12.1.0.2 |
2 |
5446 |
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 |
65711 |
Wed, 04 April 2018 23:52
By: juniordbanewbie |
|
|
Better query for max(date) per account in big table
12.1.0.2.0 |
15 |
7595 |
Tue, 03 April 2018 08:10
By: Roachcoach |
|
|
Fine Tune Big SQL Reporting Query |
6 |
6887 |
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 |
5647 |
Thu, 29 March 2018 08:33
By: Roachcoach |
|
|
Incosistent Wait Event
12.1.0.2.0 |
6 |
4798 |
Thu, 29 March 2018 05:06
By: Roachcoach |
|
|
optimzer dynmic smpling |
9 |
6192 |
Thu, 29 March 2018 02:34
By: John Watson |
|
|
Oracle Golden gate- Compression tables
Oracle 12CR2 |
4 |
6564 |
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 |
6263 |
Wed, 28 March 2018 08:34
By: JPBoileau |
|
|
SQL Query performance Tuning
RDBMS : 11.2.0.4.0 |
9 |
8210 |
Tue, 13 March 2018 09:21
By: msol25 |
|
|
Partitioning in table
Oracle 11gr2 rhel |
15 |
8672 |
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 |
5887 |
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 |
14289 |
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 |
4611 |
Wed, 07 February 2018 03:23
By: daulat01 |
|
|
View Performance Tuning By: dancko on Tue, 30 January 2018 |
7 |
5172 |
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 |
6764 |
Thu, 25 January 2018 18:13
By: juniordbanewbie |
|
|
 Driving Table is not given more speed result
Oracle 11g |
15 |
9146 |
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 |
8604 |
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 |
3 |
6196 |
Fri, 15 December 2017 07:06
By: JohnMax |
|
|
Query taking 20 minutes in Production
ORACLE 11g By: manoj12 on Fri, 17 November 2017 |
3 |
5310 |
Fri, 15 December 2017 03:26
By: cookiemonster |
|
|
AWR Interpretation and analysis
oracle 11gr2 on linux |
7 |
5283 |
Fri, 08 December 2017 02:04
By: trantuananh24hg |
|
|
DB Health checks
oracle 11gr2 on linux |
16 |
6951 |
Thu, 07 December 2017 05:43
By: dba4oracle |
|
|
Running out of 64gb Temp Space
12c By: dbogey on Tue, 05 December 2017 |
2 |
4350 |
Tue, 05 December 2017 15:05
By: BlackSwan |
|
|
Session Trace file Location - Oracle 12c
oracle 12c Windows 2012 |
3 |
4020 |
Mon, 04 December 2017 03:24
By: muthukrish104 |
|
|
Undo tablespace(monitoring and avoiding ORA-01555
oracle 11grw on linux |
8 |
5715 |
Sat, 11 November 2017 08:02
By: trantuananh24hg |
|
|
Performance Issue
Oracle8i Enterprise Edition Release 8.1.7.0.0,TNS for 32-bit Windows By: shawaj on Thu, 09 November 2017 |
6 |
33745 |
Sat, 11 November 2017 00:59
By: shawaj |
|
|
Hints
Oracle 11g |
3 |
116208 |
Wed, 25 October 2017 07:53
By: BlackSwan |
|
|
using sysdate from dual takes longer time |
10 |
98964 |
Wed, 18 October 2017 09:42
By: manikandan23 |
|
|
Statspack snap shot at level 7 is slow
11.2.0.4. windows 2012 r2 Datacentre |
15 |
86764 |
Fri, 06 October 2017 15:08
By: John Watson |
|
|
How to partition unpartitioned existing table
12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: jokrasa on Wed, 20 September 2017 |
3 |
70733 |
Wed, 20 September 2017 15:23
By: BlackSwan |
|
|
Performace issue |
6 |
17593 |
Fri, 08 September 2017 04:12
By: Clanner |
|
|
sql need tuning - high cpu_time and buffer gets
oracle 12cR1 EE RAC, RHEL 6.5 |
5 |
15195 |
Thu, 24 August 2017 09:34
By: Alien |
|
|
Join on index and adding default_where
Forms 11G By: Ilonke on Tue, 15 August 2017 |
14 |
6220 |
Tue, 15 August 2017 06:47
By: cookiemonster |
|
|
Performance issue to Update data
Oracle 11g |
7 |
4202 |
Mon, 24 July 2017 08:21
By: Bill B |
|
|
insert query
oracle 11g |
4 |
3851 |
Fri, 21 July 2017 01:41
By: John Watson |
|
|
insert time is drastically reduced
Oracle 12.1.0.2 ,Windows server 2012 64bit By: fabi88 on Mon, 03 July 2017 |
23 |
8303 |
Fri, 07 July 2017 22:53
By: BlackSwan |
|
|
Why my function based did not use?
Oracle 11gr2, any platform |
7 |
3773 |
Wed, 05 July 2017 20:37
By: trantuananh24hg |
|
|
SQL hint between view & table
11.2.0.4 on Solaris 10  |
4 |
3448 |
Sat, 01 July 2017 14:29
By: kamragulshan |
|
|
create partitioning a table
Linux, oracle 11.2 By: kar116 on Wed, 21 June 2017 |
7 |
4043 |
Tue, 27 June 2017 23:11
By: trantuananh24hg |
|
|
Full table scan
Oracle 11g |
8 |
48156 |
Mon, 26 June 2017 04:44
By: samiran_cts |
]
Search
Help
Members
Register
Login
Home