|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Performance |
1 |
1583 |
Thu, 25 August 2005 14:25 By: vjeedigunta ![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 figure out checkpoint running slow By: rkl1 on Mon, 22 August 2005 |
1 |
1572 |
Wed, 24 August 2005 07:43 By: deepa_balu ![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 of tables need sugession |
1 |
1175 |
Wed, 24 August 2005 04:25 By: girish.rohini ![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) |
|
Users and default optimizer_mode |
2 |
1934 |
Tue, 23 August 2005 07:57 By: Scott Cowan ![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 waits |
5 |
8888 |
Mon, 22 August 2005 08:37 By: smartin ![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) |
|
precise question: use a histogram here? |
1 |
1520 |
Mon, 22 August 2005 07:46 By: smartin ![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 rewrite a query |
4 |
3182 |
Sun, 21 August 2005 17:10 By: Barbara Boehmer ![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) |
|
Hints on a poor performing view |
7 |
2622 |
Fri, 19 August 2005 11:41 By: scottwmackey ![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 performing bad |
6 |
1853 |
Fri, 19 August 2005 09:25 By: smartin ![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) |
|
Strange Database Shutdowns By: rkl1 on Tue, 16 August 2005 |
1 |
1407 |
Fri, 19 August 2005 02:24 By: kugenuma ![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) |
|
Drill to Evaluate By: rkl1 on Thu, 18 August 2005 |
1 |
1374 |
Fri, 19 August 2005 02:20 By: kugenuma ![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) |
|
tuning with statpack |
1 |
1730 |
Fri, 19 August 2005 01:59 By: kugenuma ![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) |
|
Selecivity on like in a query By: stsy on Thu, 18 August 2005 |
0 |
2356 |
Thu, 18 August 2005 07:18 By: stsy ![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 make this query fast? |
10 |
2593 |
Wed, 17 August 2005 15:36 By: oracle_user_2005 ![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) |
|
slow server |
1 |
3091 |
Wed, 17 August 2005 11:34 By: mjschwenger ![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) |
|
Move Production database to test environment for load tests |
2 |
1816 |
Wed, 17 August 2005 08:21 By: HansHaeberle ![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) |
|
Foreign Keys vs. custom scripts By: andogs on Tue, 16 August 2005 |
2 |
1517 |
Wed, 17 August 2005 05:19 By: Maaher ![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) |
|
Urgent reply needed By: RB on Mon, 15 August 2005 |
4 |
1793 |
Mon, 15 August 2005 14:53 By: RB ![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) |
|
Solaris V880 W/32 G ram Oracle 10.1.2 - parameters? |
1 |
1654 |
Mon, 15 August 2005 14:26 By: smartin ![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) |
Oracle 8.1.6 Solaris 7 - redo log group switch |
5 |
2501 |
Mon, 15 August 2005 13:39 By: nmacdannald ![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) |
|
Row chaining and Local Tablespace By: rkl1 on Wed, 10 August 2005 |
6 |
2194 |
Mon, 15 August 2005 10:21 By: smartin ![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 By: Manav on Thu, 11 August 2005 |
6 |
1997 |
Sun, 14 August 2005 12:20 By: Barbara Boehmer ![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) |
|
open connection memory overhead |
2 |
1733 |
Sat, 13 August 2005 10:01 By: skempins ![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) |
|
B*-tree or bitmap index? |
1 |
1419 |
Thu, 11 August 2005 19:07 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) |
|
How to make this query run faster using PL/SQL update and insert By: Rathor on Thu, 11 August 2005 |
1 |
1896 |
Thu, 11 August 2005 13:58 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) |
![icon2.gif](/forum/images/message_icons/icon2.gif) |
how to get full version of sql statement |
1 |
1628 |
Thu, 11 August 2005 06:52 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) |
|
Full Table Scan |
3 |
1716 |
Thu, 11 August 2005 03:35 By: puneetsachar ![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) |
|
All sorting etc done on temp space By: djcot on Tue, 09 August 2005 |
2 |
1558 |
Wed, 10 August 2005 16:46 By: djcot ![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) |
I don't get Rows & Row Source Operation |
3 |
3841 |
Wed, 10 August 2005 15: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) |
|
Solaris 7 Oracle 8.1.6 logfile switch takes 10 minutes |
1 |
1442 |
Wed, 10 August 2005 14:31 By: Art Metzer ![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 & Performance Tuning |
2 |
1695 |
Wed, 10 August 2005 14:27 By: Art Metzer ![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) |
|
best strategy to gather statistics in a very dynamic |
3 |
2136 |
Wed, 10 August 2005 08:45 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) |
|
How manage over 8GB memory |
3 |
1704 |
Tue, 09 August 2005 15:53 By: nmacdannald ![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) |
|
who reads the redo logs |
5 |
1681 |
Tue, 09 August 2005 15:50 By: nmacdannald ![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) |
![icon10.gif](/forum/images/message_icons/icon10.gif) |
SQL Analyze |
0 |
2656 |
Tue, 09 August 2005 13:36 By: quetzalcoatl ![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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
indexes sql tunning |
1 |
2557 |
Mon, 08 August 2005 20:46 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) |
|
how to split the query using rowid |
1 |
1782 |
Mon, 08 August 2005 13:12 By: nmacdannald ![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) |
|
user_segments and tablesize:some thing wrong By: rkl1 on Mon, 08 August 2005 |
3 |
4102 |
Mon, 08 August 2005 12:03 By: rkl1 ![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) |
|
8.1.6 control file too large, how to shrink? |
0 |
2691 |
Mon, 08 August 2005 02:44 By: nmacdannald ![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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
What is the use of index |
6 |
1847 |
Fri, 05 August 2005 23:04 By: vidya2005 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |