|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
more precise timing with TKPROF By: HibsMax on Tue, 05 December 2006 |
4 |
2711 |
Tue, 05 December 2006 15:48 By: HibsMax ![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) |
|
PGA_AGGREGATE_TARGET & SORT_AREA_SIZE |
2 |
8546 |
Tue, 05 December 2006 14:00 By: d0hboy ![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) |
|
bit confused about Execution Plan By: it_me24 on Sun, 03 December 2006 |
2 |
2295 |
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 |
22955 |
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 |
2459 |
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 |
3624 |
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 |
3586 |
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 |
2600 |
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 |
1811 |
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 |
4837 |
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 |
3717 |
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 |
2177 |
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 |
4221 |
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 |
3954 |
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 |
11668 |
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 |
4727 |
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 |
2615 |
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 |
2335 |
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 |
2295 |
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 |
2140 |
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 |
2953 |
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 |
2724 |
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 |
4112 |
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 |
2257 |
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 |
1997 |
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 |
2449 |
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 |
10796 |
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 |
3003 |
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 |
2777 |
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 |
8586 |
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 |
1845 |
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 |
6525 |
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 |
18051 |
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 |
2906 |
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 |
2330 |
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 |
2414 |
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 |
3974 |
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 |
2849 |
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 |
9502 |
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 |
9231 |
Thu, 16 November 2006 06:05 By: Mohammad Taj ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |