|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
who is the user executing query which is using more disk space? |
2 |
3447 |
Mon, 13 June 2005 23:13 By: sunil_v_mishra ![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) |
|
Document security model |
3 |
2585 |
Mon, 13 June 2005 10:03 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) |
|
Oracle sequence |
2 |
3063 |
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 |
5010 |
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 |
4181 |
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 |
3829 |
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 |
3096 |
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 |
6331 |
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 |
2793 |
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 |
5403 |
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 |
4995 |
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 |
3313 |
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 |
4168 |
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 |
8458 |
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 |
9276 |
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 |
4348 |
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 |
4195 |
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 |
29044 |
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 |
2946 |
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 |
3088 |
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 |
7111 |
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 |
3011 |
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 |
3799 |
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 |
3838 |
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 |
3144 |
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 |
6985 |
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 |
3021 |
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 |
5720 |
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 |
2991 |
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 |
3897 |
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 |
3731 |
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 |
2893 |
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 |
5940 |
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 |
5978 |
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 |
3619 |
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 |
3399 |
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 |
2860 |
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 |
10339 |
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 |
3686 |
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 |
3084 |
Sun, 01 May 2005 21:08 By: chunyuh ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |