| |
|
Topic |
Replies |
Views |
Last message |
 |
|
Database performance tuning (merged)
12c By: mha2020 on Sat, 18 January 2020 |
3 |
13468 |
Sat, 18 January 2020 06:48
By: John Watson  |
|
|
Top SQL and Top sessions
Oracle 11g,Oracle 12c, Linux |
2 |
13121 |
Thu, 14 November 2019 07:55
By: cookiemonster |
|
|
Solution for database hung
Oracle 11.2.0.4,Linux 6 |
11 |
20506 |
Wed, 13 November 2019 07:52
By: BalajiDBA |
|
|
Disk file operations i/o
ORACLE 11.2.0.4 on HP-UX. By: nimaz85 on Mon, 21 October 2019 |
4 |
19267 |
Mon, 21 October 2019 10:57
By: Michel Cadot |
|
|
queue management system
Developer 10g Database 10 |
1 |
13141 |
Sat, 07 September 2019 06:36
By: Michel Cadot |
|
|
ORA-16951: Too many bind variables supplied for this SQL statement (merged)
oracle 11gr2 linux |
6 |
111372 |
Tue, 20 August 2019 10:01
By: dba4oracle |
|
|
Slow query with hash clustering (latch free - multiblock read objects)
Oracle 11g R2, RHEL 7 |
2 |
12953 |
Mon, 15 July 2019 02:55
By: tabokie |
|
|
Consider of load-test invoking only one insert statement
Oracle 11g, any platform |
1 |
12177 |
Wed, 05 June 2019 02:48
By: John Watson |
|
|
improve performance on updating clob data
Oracle RDBMS, 12.1, Windows By: unna on Wed, 22 May 2019 |
7 |
18355 |
Tue, 28 May 2019 09:38
By: Michel Cadot |
|
|
poor performance during switch log file
Oracle 12.2.0.1 linux 7.6 By: fabi88 on Sun, 12 May 2019 |
5 |
14812 |
Mon, 20 May 2019 22:02
By: trantuananh24hg |
|
|
Query Taking Alot of time ..Help in Tuning
11g By: rrcr on Tue, 12 February 2019 |
6 |
17614 |
Thu, 18 April 2019 03:32
By: cookiemonster |
|
|
Oracle CPU usage Analysis
11g |
3 |
12879 |
Thu, 11 April 2019 01:18
By: John Watson |
|
|
Oracle high "cost" SELECT query
Oracle 12 |
13 |
24624 |
Thu, 14 March 2019 08:46
By: cookiemonster |
|
|
Retrieving 8k rows from one table takes too long
Oracle EE 11.2.0.3.0 - 64bit, Linux |
8 |
16457 |
Sun, 10 March 2019 01:26
By: dba4oracle |
|
|
high buffers
oracle 11gr2 linux |
19 |
22081 |
Sat, 09 March 2019 21:30
By: dba4oracle |
|
|
Table Order in Join
11g By: rrcr on Thu, 07 February 2019 |
5 |
14012 |
Thu, 07 February 2019 11:03
By: John Watson |
|
|
RELY constraints
DB 12.x |
0 |
9498 |
Tue, 05 February 2019 04:55
By: John Watson |
|
|
driving table and join order
12c |
2 |
14084 |
Thu, 10 January 2019 14:35
By: John Watson |
|
|
table Partition when values are unknown
11g |
23 |
22034 |
Wed, 09 January 2019 03:36
By: cookiemonster |
|
|
how to avoid window sort?
oracle 12c release 2 |
8 |
19377 |
Fri, 16 November 2018 03:46
By: cookiemonster |
|
|
Optimal Chunk size for update of 50M record table
Oracle 11g RAC, Linux OEL 6 ( 1 2) |
46 |
42373 |
Tue, 06 November 2018 03:10
By: Andrey_R |
|
|
A question about how to code a procedure to use dbms_parallel_execute package for a huge insert
11.2.0.4 on Linux |
13 |
18841 |
Wed, 31 October 2018 11:15
By: orausern |
|
|
scripts of Oracle SQL Performance Tuning and Optimization
Oracle By: big on Thu, 25 October 2018 |
2 |
10507 |
Thu, 25 October 2018 06:36
By: big |
|
|
Is there a need to install os monitoring tools since gv$osstat already has the os statistics
12.2.0.1 Windows 2016 |
2 |
11658 |
Wed, 17 October 2018 02:43
By: juniordbanewbie |
|
|
No more data to read from socket
No more data to read from socket (Oracle error 17410 ) |
14 |
19026 |
Mon, 15 October 2018 05:04
By: saipradyumn |
|
|
How do I know who are running the long running ops sql?
12.1.0.2 RH7 |
1 |
9651 |
Tue, 02 October 2018 02:45
By: Michel Cadot |
|
|
Transaction Isolation Level
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
2 |
8568 |
Sat, 29 September 2018 06:31
By: saipradyumn |
|
|
Pleaese clear my doubt about View and synonym having same name
UNIX 11.35 By: Akmmhto on Wed, 26 September 2018 |
6 |
11092 |
Fri, 28 September 2018 12:07
By: Akmmhto |
|
|
Index on order by column
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
9 |
13044 |
Tue, 18 September 2018 02:53
By: saipradyumn |
|
|
Range Scan Index
Oracle 11g, any platforms |
18 |
15480 |
Thu, 30 August 2018 09:34
By: JPBoileau |
|
|
Exporting AWR data in a csv file
RHEL 6 64-bit, Oracle 12.2.0.1 |
8 |
12416 |
Thu, 30 August 2018 02:22
By: Roachcoach |
|
|
Appropriate join to the desired output
Oracle 11.2 By: senmng on Fri, 27 July 2018 |
3 |
10829 |
Tue, 28 August 2018 02:47
By: jennifer roche |
|
|
 performance tuning
Oracle rdbms 11gR2 and #statspack By: alanm on Mon, 30 July 2018 |
3 |
9350 |
Mon, 30 July 2018 04:37
By: Roachcoach |
|
|
Sql query to get Max,min and max-1 row from a table
Oracle 11.2 By: senmng on Sun, 22 July 2018 |
2 |
7718 |
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 |
10449 |
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 |
15989 |
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 |
9184 |
Sat, 23 June 2018 18:01
By: BlackSwan |
|
|
join is slow
Oracle12g By: Buchas on Fri, 25 May 2018 |
2 |
7347 |
Wed, 20 June 2018 05:22
By: michael_bialik |
|
|
Used Left Join - Query goes for Full Table scan
Oracle 11.2 |
7 |
10067 |
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 |
8328 |
Wed, 30 May 2018 09:32
By: Andrey_R |
]
Search
Help
Members
Register
Login
Home