|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
bit confused about Execution Plan By: it_me24 on Sun, 03 December 2006 |
2 |
1904 |
Tue, 05 December 2006 10:05 By: it_me24 ![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) |
|
Access to the database is very slow. |
4 |
21935 |
Tue, 05 December 2006 09:32 By: Mohammad Taj ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Stored Procedure Performance Slows By: feizz on Mon, 04 December 2006 |
4 |
2260 |
Mon, 04 December 2006 20:51 By: feizz ![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) |
|
Analyze tables using OEM |
2 |
3294 |
Sun, 03 December 2006 22:53 By: seema.taunk ![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 of Lower() function in query |
14 |
3307 |
Sat, 02 December 2006 13:12 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) |
|
Timing queries |
5 |
2395 |
Fri, 01 December 2006 22:36 By: tlahyani ![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 Help me plz urgent |
1 |
1698 |
Fri, 01 December 2006 09:56 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) |
|
Would my SQL work to record which indexes are being used By: aidi-h on Thu, 30 November 2006 |
0 |
4455 |
Thu, 30 November 2006 08:34 By: aidi-h ![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 Rebuild Taking Long |
1 |
3270 |
Thu, 30 November 2006 08:09 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) |
|
Automating - Gathering Satistics By: Brayan on Thu, 30 November 2006 |
1 |
1992 |
Thu, 30 November 2006 06:12 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) |
|
SQL vs. PLSQL |
4 |
4016 |
Thu, 30 November 2006 00:47 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 column combination |
8 |
2814 |
Wed, 29 November 2006 15:01 By: orasaket ![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) |
|
Hierarchical queries with rownum pseudocolumn in 10g vs. 9i |
1 |
11555 |
Tue, 28 November 2006 20:30 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) |
|
TKPROF & Statspack question |
5 |
3502 |
Tue, 28 November 2006 16:54 By: orasaket ![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) |
|
# VERY URGENT # -Monitoring memory utilization in oracle 9i |
1 |
1987 |
Tue, 28 November 2006 06:49 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) |
|
Using Bind Variables |
4 |
2052 |
Mon, 27 November 2006 09:51 By: Anand Ramaswamy ![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 Tuning (Performance) |
1 |
1672 |
Mon, 27 November 2006 08:54 By: vshari ![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) |
|
Statspack |
3 |
1965 |
Sun, 26 November 2006 22:24 By: seema.taunk ![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) |
|
Any Recommendation for Statspack Reprot By: Brayan on Thu, 23 November 2006 |
5 |
2310 |
Sat, 25 November 2006 03:23 By: Brayan ![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) |
|
"+0 trick undesirable", why? By: skooman on Thu, 23 November 2006 |
3 |
1994 |
Fri, 24 November 2006 00:32 By: skooman ![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) |
Bothering "Sudden Death" by unexpected dropping efficient execution plan |
0 |
3871 |
Thu, 23 November 2006 18:44 By: oranje66 ![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 waits |
2 |
1651 |
Thu, 23 November 2006 05:21 By: seema.taunk ![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) |
|
While Analyzing Schema |
3 |
1693 |
Thu, 23 November 2006 01:05 By: dattatraya ![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 Tables |
1 |
1980 |
Wed, 22 November 2006 19: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) |
|
Difference Between Global Index and Local Index |
1 |
10388 |
Tue, 21 November 2006 22:32 By: Mohammad Taj ![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) |
|
Which Partition to Apply? What should be the partition key? |
12 |
2615 |
Tue, 21 November 2006 20:00 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) |
|
DB tuning |
4 |
2039 |
Tue, 21 November 2006 09:02 By: JRowbottom ![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) |
|
GATHER_SCHEMA_STATS - monitoring progress? By: gwicke on Tue, 21 November 2006 |
1 |
8143 |
Tue, 21 November 2006 09:00 By: JRowbottom ![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) |
|
Difference between two query |
2 |
1638 |
Mon, 20 November 2006 22:22 By: moparthy99 ![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) |
|
Regarding parse_calls in v$sqlarea |
2 |
6203 |
Mon, 20 November 2006 08:05 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) |
|
Oracle 9i materialized view refresh problems |
11 |
16313 |
Sat, 18 November 2006 05:16 By: jacquesh ![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 reads from buttom to top |
3 |
2509 |
Sat, 18 November 2006 00:32 By: bagulia_pilla ![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 performance |
4 |
1787 |
Fri, 17 November 2006 06:26 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) |
|
Small Doubt Regarding CBO |
3 |
1583 |
Fri, 17 November 2006 06:18 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) |
|
Please Help me for Tune |
0 |
3868 |
Fri, 17 November 2006 00:03 By: bagulia_pilla ![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 this the best performed query? By: Akshar on Tue, 14 November 2006 |
8 |
2537 |
Thu, 16 November 2006 23:54 By: Akshar ![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) |
|
Chained Fetch Ratio & Parse to Execute Ratio By: Brayan on Thu, 16 November 2006 |
1 |
9224 |
Thu, 16 November 2006 14:00 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) |
|
check last statement executed |
5 |
8920 |
Thu, 16 November 2006 06:05 By: Mohammad Taj ![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) |
|
flushing the buffer cache |
12 |
3166 |
Thu, 16 November 2006 02:11 By: Mohammad Taj ![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) |
|
Interpret STATSPack Report |
0 |
4909 |
Wed, 15 November 2006 14:38 By: faiz_hyd ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |