|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Full table scan with varying consistent gets By: skelly on Sat, 05 March 2005 |
1 |
2431 |
Sat, 05 March 2005 22:08 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) |
|
SQL AREA HIT Ratio By: timgb on Wed, 23 February 2005 |
8 |
12266 |
Fri, 04 March 2005 11:24 By: Frank ![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-04030 By: nemo on Tue, 01 March 2005 |
2 |
11548 |
Fri, 04 March 2005 10:52 By: nemo ![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) |
|
Parallel Hint Question By: bhagwan on Mon, 21 February 2005 |
2 |
2966 |
Thu, 03 March 2005 04:03 By: anmol1947 ![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) |
|
Indexes not working after analyzing tables |
9 |
3001 |
Wed, 02 March 2005 21:48 By: pgongloo ![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 difference BOLB vs. LONG RAW |
0 |
3569 |
Wed, 02 March 2005 08:55 By: AllanJones ![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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
on consumption of resources By: Tads on Wed, 02 March 2005 |
1 |
2164 |
Wed, 02 March 2005 07:49 By: Tads ![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) |
|
Why Performance and Tuning is important By: Mustafa on Mon, 21 February 2005 |
4 |
3033 |
Wed, 02 March 2005 01:52 By: Frank ![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) |
|
Does Increasing Field Length Decrease Perf? By: Steve F on Mon, 31 January 2005 |
3 |
2913 |
Tue, 01 March 2005 15:38 By: andrew again ![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: chained rows By: Jadie on Fri, 25 February 2005 |
4 |
5759 |
Mon, 28 February 2005 11:13 By: Frank ![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) |
|
RAW datatype with NUMBER |
5 |
7213 |
Thu, 24 February 2005 00:16 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) |
|
materialized view |
1 |
2422 |
Wed, 23 February 2005 13:06 By: Mack Sundar ![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) |
|
Invalid Object in sys schema By: Sarah on Fri, 04 February 2005 |
1 |
7074 |
Wed, 23 February 2005 12:35 By: Mack Sundar ![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) |
|
Diff Execution Plan for Same Query?Pl:help |
1 |
2459 |
Wed, 23 February 2005 12:14 By: Mack Sundar ![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) |
|
Pass parameter to DML or new procedure? |
5 |
3920 |
Tue, 22 February 2005 15:51 By: Todd Barry ![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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
Replace Outer Join with Unions |
1 |
2926 |
Tue, 22 February 2005 08:00 By: Master.Richard ![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) |
|
Using Consumer groups By: Uwe on Tue, 22 February 2005 |
0 |
2862 |
Tue, 22 February 2005 04:35 By: Uwe ![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) |
|
Re: materialized view |
0 |
2705 |
Tue, 22 February 2005 03:24 By: Sreedhar Reddy ![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) |
|
Does DML on Global temp table generates REDO |
4 |
3674 |
Mon, 21 February 2005 03:39 By: Vivek Vijai ![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) |
|
CBO estimates Bitmap Index retrieval at 100 times Btree cost. |
1 |
4663 |
Mon, 21 February 2005 02:39 By: John Hammond ![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 statement reparsing again.Pl help |
1 |
2742 |
Fri, 18 February 2005 06:34 By: Art Metzer ![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) |
|
get proc and package names By: Vinu on Thu, 17 February 2005 |
2 |
2896 |
Thu, 17 February 2005 22:16 By: Vinu ![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) |
|
Urgent:How to find long running query in Oracle |
1 |
7651 |
Wed, 16 February 2005 05:33 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) |
|
Performance Tuning.very critical |
5 |
11633 |
Tue, 15 February 2005 11:43 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) |
|
trace unused tables By: Panki on Tue, 15 February 2005 |
2 |
2979 |
Tue, 15 February 2005 10:57 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) |
|
Connect By Cause Full tablescan:pl help |
2 |
2922 |
Tue, 15 February 2005 01:49 By: BhavinShah ![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) |
|
Warning from "SYSTEM.DBMS_APPLICATION_INFO" package |
3 |
4674 |
Mon, 14 February 2005 14:11 By: Tomaz Barrantes Jr. ![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 is size of the INSTANCE |
1 |
2638 |
Mon, 14 February 2005 02:31 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) |
|
open_cursors value is exceeded By: sri on Tue, 07 September 2004 |
5 |
8118 |
Sat, 12 February 2005 02:09 By: Pravin Singh ![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) |
|
CBO vs RBO Explain plan |
0 |
4623 |
Fri, 11 February 2005 00:39 By: Kilburn High Rd ![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) |
|
Writing a Performance Stress Test |
3 |
2062 |
Tue, 08 February 2005 10:57 By: lily ![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) |
|
Response time By: Nainar on Tue, 08 February 2005 |
1 |
2549 |
Tue, 08 February 2005 03:39 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) |
|
SGA Tuning By: Ammes on Sat, 05 February 2005 |
1 |
2861 |
Mon, 07 February 2005 01:08 By: vinay ![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 not properly used when LIKE operator used |
3 |
3113 |
Sun, 06 February 2005 23:30 By: Shikha ![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) |
|
Output display By: Ant on Fri, 04 February 2005 |
5 |
2757 |
Sun, 06 February 2005 21:05 By: Sreedhar Reddy ![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) |
|
COMPUTE and ESTIMATE By: lily on Tue, 25 January 2005 |
2 |
2308 |
Fri, 04 February 2005 10:27 By: lily ![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 tunning By: santosh on Wed, 02 February 2005 |
3 |
4564 |
Fri, 04 February 2005 01:48 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) |
|
Joining tables - Compare multiple columns of a table with a Single column of oth By: priya on Tue, 01 February 2005 |
2 |
3085 |
Thu, 03 February 2005 19:55 By: priya ![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 join problem (full table scan) |
3 |
3820 |
Wed, 02 February 2005 05:55 By: John Smith ![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) |
|
Detrimental effect of many extents By: helen on Tue, 01 February 2005 |
4 |
3251 |
Wed, 02 February 2005 05:15 By: Madonna ofthe Wasps ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |