|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle sequence |
2 |
2001 |
Mon, 13 June 2005 09:36 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) |
|
When to use index |
6 |
3297 |
Mon, 13 June 2005 05:53 By: d.dineshkumar ![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) |
|
Constraint state in DWH environment (rely disable novalidate) |
0 |
3590 |
Sun, 12 June 2005 04:30 By: henning.schroer ![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 - number of rows returned. |
5 |
3234 |
Fri, 10 June 2005 08:08 By: Lee Sutton ![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 Question |
2 |
2136 |
Thu, 09 June 2005 04:15 By: nabeelkhan ![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) |
|
What is happening with this sql? |
15 |
5310 |
Wed, 08 June 2005 20:10 By: rramanat ![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) |
|
select large amount of data |
1 |
2007 |
Wed, 08 June 2005 15:47 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) |
|
forced view |
4 |
4866 |
Wed, 08 June 2005 00:20 By: nabeelkhan ![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) |
URGENT:-Performance Tuning. |
8 |
3117 |
Tue, 07 June 2005 15:28 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) |
|
Stubborn Query |
4 |
2536 |
Tue, 07 June 2005 06:35 By: nabeelkhan ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
How to read the execution plan By: shibu on Wed, 01 June 2005 |
6 |
3424 |
Mon, 06 June 2005 09:06 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) |
|
Composite bitmap indexes |
2 |
7807 |
Mon, 06 June 2005 08:49 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) |
|
can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s |
11 |
7663 |
Sun, 05 June 2005 09:00 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) |
|
Reg. out put of DBMS_XPLAN.DISPLAY |
6 |
3549 |
Sun, 05 June 2005 07:23 By: nabeelkhan ![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) |
|
Select on same table gives poor performace. By: abc123 on Sat, 04 June 2005 |
1 |
3320 |
Sun, 05 June 2005 02:24 By: nabeelkhan ![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 Partition rebuild Query |
1 |
28496 |
Fri, 03 June 2005 08:16 By: carsten.jorgensen ![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) |
|
The same sql runs very slowly in jboss-cmp,very quickly in native jdbc. |
1 |
2251 |
Thu, 02 June 2005 21:01 By: peixubin ![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 Information |
1 |
2171 |
Tue, 31 May 2005 09:07 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) |
|
What are the steps to tune a query |
3 |
6047 |
Mon, 30 May 2005 09:08 By: d.dineshkumar ![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) |
|
Datawarehouse query |
3 |
2049 |
Thu, 26 May 2005 20:41 By: well_rbs ![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 "Rows" equal 0 in TKPROF. Is this a setting? |
6 |
3174 |
Thu, 26 May 2005 14:27 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) |
|
Batch Tuning |
3 |
3007 |
Mon, 23 May 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) |
|
Performance problem!! By: kinjal on Mon, 23 May 2005 |
2 |
2262 |
Mon, 23 May 2005 09:44 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) |
|
activating Online Index Build By: mbexel on Wed, 18 May 2005 |
3 |
5716 |
Fri, 20 May 2005 08:58 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) |
|
Statspack for 9i on 8.1.6 |
1 |
2315 |
Fri, 20 May 2005 06:07 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Ploblem connect oracle by Vb application By: chara on Tue, 17 May 2005 |
3 |
4514 |
Wed, 18 May 2005 10:44 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) |
|
Prameters For Improving DB Perfomance By: ksst on Fri, 13 May 2005 |
3 |
2154 |
Fri, 13 May 2005 22:33 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) |
|
statspack top 5 wait event |
2 |
2955 |
Fri, 13 May 2005 07:24 By: Frank ![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) |
|
Comparision of Two Execution Plan |
4 |
2351 |
Wed, 11 May 2005 09:07 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) |
|
ARCHIVELOG GETTING FILLED |
1 |
2030 |
Tue, 10 May 2005 02:16 By: mihelic ![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) |
|
Cursor Performance Issue |
1 |
5083 |
Tue, 10 May 2005 02:07 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) |
|
Oracle Schema slowing performance By: ravin on Wed, 04 May 2005 |
9 |
5159 |
Mon, 09 May 2005 12:23 By: Frank ![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 takes long time -need help to improve Performance By: pzlj6x on Fri, 06 May 2005 |
4 |
2482 |
Sat, 07 May 2005 08:18 By: pzlj6x ![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) |
Why does checkpoint only happen at log switch? :( By: Jadie on Thu, 05 May 2005 |
2 |
2613 |
Fri, 06 May 2005 13:48 By: Jadie ![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) |
|
max size of sga in oracle 81 windows 2000 server |
1 |
2168 |
Thu, 05 May 2005 11:47 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) |
|
dbms_stats |
2 |
9803 |
Tue, 03 May 2005 08:40 By: balavignesh ![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 Doubt |
5 |
2346 |
Mon, 02 May 2005 10:11 By: sujit_ocp ![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) |
|
what should be approximate Size of SGA ? |
1 |
2342 |
Sun, 01 May 2005 21:08 By: chunyuh ![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) |
|
Deleting from Huge table By: abc123 on Thu, 28 April 2005 |
4 |
2671 |
Fri, 29 April 2005 11:48 By: pscjhe ![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) |
|
V$SYSSTAT |
1 |
2919 |
Fri, 29 April 2005 08:44 By: Frank Naude ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |