|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Using Index Monitoring in Oracle 9i |
4 |
1690 |
Thu, 29 April 2004 00:15 By: staylor ![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 server Ram Upgrade |
1 |
1497 |
Fri, 23 April 2004 03:24 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 gain in qualifying the owner of a table when querying? |
1 |
1509 |
Thu, 22 April 2004 22:18 By: dieter ![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) |
|
problem installation |
0 |
1627 |
Thu, 22 April 2004 21:40 By: Martial ![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 to guage query run time By: Joël on Tue, 20 April 2004 |
0 |
1618 |
Tue, 20 April 2004 10:06 By: Joël ![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) |
|
optimizer_mode,multiple db_block_size By: rajesh on Tue, 20 April 2004 |
0 |
1717 |
Tue, 20 April 2004 03:14 By: rajesh ![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 Problem with Stored procedure |
0 |
1917 |
Mon, 19 April 2004 02:41 By: Prabha R ![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) |
|
pctfree and pctused settings By: dennis on Thu, 15 April 2004 |
2 |
2151 |
Fri, 16 April 2004 09:07 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) |
|
Querying a Partitioned table By: Raj on Wed, 14 April 2004 |
2 |
1695 |
Thu, 15 April 2004 00:45 By: Ajendra ![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) |
|
TEMP Space used by each user - HOWTO? By: IA on Wed, 14 April 2004 |
1 |
1477 |
Wed, 14 April 2004 20:41 By: ora9iDBA ![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) |
|
PROBLE IN ANALYZE |
1 |
1681 |
Wed, 14 April 2004 07:57 By: Thiru ![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 indexes behave on a varchar field |
2 |
1701 |
Tue, 13 April 2004 08:22 By: Thiru ![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 Between faster? |
3 |
1603 |
Sun, 11 April 2004 14:51 By: William Robertson ![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) |
|
DBA_SEGMENTS Alternate code? |
1 |
1876 |
Fri, 09 April 2004 11:46 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) |
|
Explain Plan in TOAD |
3 |
7548 |
Thu, 08 April 2004 13:11 By: sverch ![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) |
|
High overhead on DBA_SEGMENTS |
3 |
2374 |
Wed, 07 April 2004 15:38 By: Thiru ![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 sub-queries |
0 |
2737 |
Tue, 06 April 2004 08:42 By: David Peters ![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) |
|
Optimizer |
1 |
1361 |
Mon, 05 April 2004 11:15 By: Thiru ![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) |
|
Forcing optimizer to use full scan |
11 |
2720 |
Fri, 02 April 2004 04:26 By: Thiru ![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) |
|
Information on Statistics generation for Partition Tables By: sabir on Sun, 28 March 2004 |
1 |
2246 |
Thu, 01 April 2004 12:26 By: Thiru ![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) |
|
striping |
5 |
1901 |
Thu, 01 April 2004 10:17 By: Thiru ![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 a Query By: satyan on Wed, 31 March 2004 |
0 |
2641 |
Wed, 31 March 2004 13:20 By: satyan ![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) |
|
nested select statements By: David on Thu, 25 March 2004 |
2 |
4511 |
Wed, 31 March 2004 09:07 By: David ![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 to join performance views ? By: IA on Tue, 30 March 2004 |
1 |
1510 |
Wed, 31 March 2004 06:29 By: Thiru ![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) |
|
Buffer Cache Hit rate stays low |
4 |
4175 |
Mon, 29 March 2004 23:04 By: allen ![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) |
|
View index By: bill on Wed, 24 March 2004 |
2 |
1940 |
Mon, 29 March 2004 12:14 By: Ivan ![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) |
|
Shared Pool. By: Max on Fri, 19 March 2004 |
2 |
1446 |
Sat, 27 March 2004 09:33 By: Raj ![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) |
|
Application is Hanging. |
2 |
1662 |
Fri, 26 March 2004 09:06 By: Thomas G ![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) |
|
Different way of execute |
15 |
2840 |
Fri, 26 March 2004 05:38 By: Anatol Ciolac ![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) |
|
Delete Query taking long time |
1 |
1526 |
Wed, 24 March 2004 11:35 By: Thiru ![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) |
|
log file sync |
1 |
1630 |
Wed, 24 March 2004 09:17 By: Thiru ![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) |
|
high level of processor utilization By: Tibor on Sun, 21 March 2004 |
1 |
1720 |
Mon, 22 March 2004 11:04 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) |
|
Bind Variables |
1 |
1677 |
Mon, 22 March 2004 08:58 By: Thiru ![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) |
|
Delete statement takes a very long time |
1 |
1436 |
Mon, 22 March 2004 05:25 By: Thiru ![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 By: Rock on Fri, 19 March 2004 |
1 |
1545 |
Sun, 21 March 2004 23:48 By: Daljit 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) |
|
Memmory By: Razi on Wed, 17 March 2004 |
2 |
1420 |
Sun, 21 March 2004 04:06 By: Thiru ![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) |
|
logging DDL statements, etc? |
3 |
1993 |
Thu, 18 March 2004 15:36 By: Vijay ![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 novice By: Avi on Sun, 14 March 2004 |
2 |
1554 |
Thu, 18 March 2004 05:30 By: Thiru ![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) |
|
Explain Plan - Query Performance Tuning |
1 |
1863 |
Thu, 18 March 2004 04:39 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) |
|
Query taking too long to run |
2 |
2341 |
Thu, 18 March 2004 00:29 By: IA ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |