|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Tuning with Oracle Collections Oracle 9i |
2 |
2433 |
Sun, 13 January 2008 23:20 By: trowsdale ![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) |
|
Help- Tuning Query Oracle 9i R2 |
7 |
1998 |
Sat, 12 January 2008 10:45 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) |
|
works in test env but very slow in production By: pzlj6x on Fri, 11 January 2008 |
3 |
1811 |
Fri, 11 January 2008 15:21 By: Mahesh Rajendran ![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) |
|
PL SQL Merge of tables - efficiency |
7 |
4285 |
Fri, 11 January 2008 13:30 By: Kevin Meade ![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) |
|
table access count |
1 |
1363 |
Fri, 11 January 2008 05:47 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) |
|
What can I do to increase my Library Cache Hit stats 10G Linux By: aidi-h on Thu, 10 January 2008 |
1 |
2505 |
Thu, 10 January 2008 13:48 By: Kevin Meade ![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) |
|
Split partitions in oracle 8.0.4.3 Sun solaris 5.9 |
6 |
2093 |
Wed, 09 January 2008 20:55 By: rleishman ![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) |
|
retrieve execution plan for running session in Oracle 8i database By: wkk1020 on Tue, 08 January 2008 |
6 |
4008 |
Wed, 09 January 2008 20:49 By: rleishman ![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) |
|
performance tuning |
16 |
3219 |
Wed, 09 January 2008 10:08 By: Kevin Meade ![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) |
|
Comparing collection against cursor oracle,9i,sunos |
2 |
1459 |
Wed, 09 January 2008 01:24 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) |
|
How can i tune the query... |
2 |
1417 |
Wed, 09 January 2008 01:22 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) |
|
Bock Inefficiency 100% oracle 8.0.4.3,SunOS 5.9 |
1 |
1250 |
Wed, 09 January 2008 01:18 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) |
|
Merge join verse Filter. Same code, different database, different explain plan By: bickers on Tue, 08 January 2008 |
2 |
1456 |
Tue, 08 January 2008 20:23 By: rleishman ![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 plan and negative value (-1) in where clause By: maga on Tue, 08 January 2008 |
5 |
1890 |
Tue, 08 January 2008 10:14 By: maga ![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) |
|
increasing cache hit ratio oracle,10g,win xp |
2 |
1312 |
Tue, 08 January 2008 03:51 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) |
|
Performance tuning of DDL? By: lwright on Mon, 07 January 2008 |
5 |
3358 |
Tue, 08 January 2008 00:31 By: rleishman ![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) |
|
Index followup decision in case of composite b-tree index |
11 |
4642 |
Mon, 07 January 2008 13:29 By: Kevin Meade ![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 question on Interpreting 10046 trace and the waits |
5 |
2330 |
Mon, 07 January 2008 10:36 By: orausern ![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) |
|
Index Usage By: cgk1983 on Mon, 07 January 2008 |
3 |
1322 |
Mon, 07 January 2008 09:07 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) |
|
Where to Start the Performance Tuning? 9iR2, RHEL AS3.0 |
1 |
1286 |
Mon, 07 January 2008 08:14 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) |
|
Deletion script doesnt completes |
10 |
2219 |
Mon, 07 January 2008 03:46 By: ora_2007 ![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) |
|
SGA - Buffer cache size |
9 |
8962 |
Sun, 06 January 2008 14:03 By: Frank Naude ![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) |
|
slow query 10.2.3.0 |
1 |
1661 |
Sat, 05 January 2008 17:17 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) |
|
sql query running for too long ..... oracle 10g |
2 |
1900 |
Fri, 04 January 2008 17:06 By: Kevin Meade ![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) |
|
11g SQL PERFORMANCE ANALYZER |
0 |
6456 |
Fri, 04 January 2008 08:11 By: prince973 ![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 Statement is too slow |
7 |
9238 |
Thu, 03 January 2008 14:23 By: ashwin_tampa ![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) |
|
Group by clause |
1 |
1261 |
Thu, 03 January 2008 01:15 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) |
|
latch: session allocation and CPU By: panelan on Mon, 31 December 2007 |
6 |
10178 |
Wed, 02 January 2008 23:37 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) |
|
Choose your Buffer Cache Hit Ratio V7 Oracle or higher on any OS |
0 |
6474 |
Wed, 02 January 2008 17:19 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) |
|
same sql but different responce time oracle database (OLTP) 9.2.0.7 on aix |
10 |
2358 |
Mon, 31 December 2007 20:10 By: rleishman ![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) |
|
memory sizng on Win 64 bit, 9.2.0.8 |
1 |
1285 |
Mon, 31 December 2007 05:01 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) |
|
help on indexes oracle,10g,win xp |
3 |
1402 |
Sun, 30 December 2007 01:30 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) |
|
index problem on partition based table By: dusoo on Thu, 27 December 2007 |
10 |
2707 |
Sat, 29 December 2007 16:13 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) |
|
Max time for all sql's in my process being consumed by db file sequential read |
9 |
2319 |
Fri, 28 December 2007 19:44 By: halfydba ![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 collections help 10g |
10 |
2308 |
Fri, 28 December 2007 16:21 By: rleishman ![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) |
|
Entries are getting very slow. |
5 |
1631 |
Fri, 28 December 2007 12:25 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) |
|
EXECUTION TIME |
2 |
1463 |
Thu, 27 December 2007 01:28 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) |
|
CLOB usage and issue with TEMP tablespace By: susmita on Mon, 24 December 2007 |
1 |
3375 |
Mon, 24 December 2007 03:09 By: halfydba ![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) |
|
Long Running SQL- CLOB vs TO_CHAR By: mymot on Fri, 21 December 2007 |
1 |
4376 |
Fri, 21 December 2007 03:07 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) |
|
suggestions required to change the query to improve its performance Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production,windows XP |
2 |
1829 |
Thu, 20 December 2007 20:04 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |