|
|
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 |
1924 |
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 |
21964 |
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 |
2304 |
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 |
3314 |
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 |
3362 |
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 |
2416 |
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 |
1722 |
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 |
4470 |
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 |
3288 |
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 |
2021 |
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 |
4045 |
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 |
2857 |
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 |
11579 |
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 |
3519 |
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 |
2016 |
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 |
2082 |
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 |
1692 |
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 |
1990 |
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 |
2343 |
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 |
2019 |
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 |
3893 |
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 |
1670 |
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 |
1718 |
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 |
1996 |
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 |
10407 |
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 |
2662 |
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 |
2069 |
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 |
8188 |
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 |
1658 |
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 |
6227 |
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 |
16360 |
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 |
2533 |
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 |
1817 |
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 |
1604 |
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 |
3888 |
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 |
2585 |
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 |
9255 |
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 |
8964 |
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 |
3243 |
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 |
4929 |
Wed, 15 November 2006 14:38 By: faiz_hyd ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |