|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Performance |
1 |
1631 |
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 |
1615 |
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 |
1217 |
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 |
1975 |
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 |
8933 |
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 |
1564 |
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 |
3221 |
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 |
2668 |
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 |
1902 |
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 |
1450 |
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 |
1420 |
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 |
1775 |
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 |
2404 |
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 |
2632 |
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 |
3134 |
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 |
1858 |
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 |
1568 |
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 |
1840 |
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 |
1695 |
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 |
2550 |
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 |
2235 |
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 |
2041 |
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 |
1772 |
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 |
1463 |
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 |
1938 |
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 |
1668 |
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 |
1765 |
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 |
1597 |
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 |
3883 |
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 |
1486 |
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 |
1737 |
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 |
2175 |
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 |
1744 |
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 |
1731 |
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 |
2696 |
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 |
2599 |
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 |
1824 |
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 |
4151 |
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 |
2732 |
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 |
1888 |
Fri, 05 August 2005 23:04 By: vidya2005 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |