|
|
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 |
1845 |
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 |
1654 |
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 |
1679 |
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 |
1792 |
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 |
1778 |
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 |
1876 |
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 |
2077 |
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 |
2330 |
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 |
1870 |
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 |
1635 |
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 |
1854 |
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 |
1872 |
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 |
1778 |
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 |
2032 |
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 |
7731 |
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 |
2545 |
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 |
2903 |
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 |
1526 |
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 |
2885 |
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 |
2413 |
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 |
2066 |
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 |
2809 |
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 |
4672 |
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 |
1680 |
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 |
4339 |
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 |
2098 |
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 |
1619 |
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 |
1812 |
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 |
3006 |
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 |
1702 |
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 |
1796 |
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 |
1894 |
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 |
1838 |
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 |
1600 |
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 |
1713 |
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 |
1584 |
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 |
2155 |
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 |
1731 |
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 |
2018 |
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 |
2676 |
Thu, 18 March 2004 00:29 By: IA ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |