|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Performance |
1 |
1617 |
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 |
1603 |
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 |
1206 |
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 |
1966 |
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 |
8919 |
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 |
1553 |
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 |
3209 |
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 |
2656 |
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 |
1887 |
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 |
1436 |
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 |
1408 |
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 |
1761 |
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 |
2389 |
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 |
2623 |
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 |
3120 |
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 |
1844 |
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 |
1553 |
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 |
1827 |
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 |
1682 |
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 |
2537 |
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 |
2224 |
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 |
2029 |
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 |
1759 |
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 |
1451 |
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 |
1924 |
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 |
1658 |
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 |
1749 |
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 |
1590 |
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 |
3871 |
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 |
1473 |
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 |
1724 |
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 |
2165 |
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 |
1734 |
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 |
1713 |
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 |
2683 |
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 |
2586 |
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 |
1809 |
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 |
4136 |
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 |
2718 |
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 |
1877 |
Fri, 05 August 2005 23:04 By: vidya2005 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |