|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
functional desing advise needed |
5 |
2218 |
Thu, 14 July 2005 04:52 By: ziggy ![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) |
|
Database performance issue By: Hina on Tue, 12 July 2005 |
5 |
2386 |
Thu, 14 July 2005 00:14 By: milind_sri ![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) |
|
using statspack .......! |
0 |
2621 |
Wed, 13 July 2005 09:51 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) |
![icon14.gif](/forum/images/message_icons/icon14.gif) |
Sql Tuning - (urgent) |
2 |
2051 |
Wed, 13 July 2005 05:19 By: SoporteDBA ![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) |
|
wait events |
2 |
2559 |
Wed, 13 July 2005 05:01 By: SoporteDBA ![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) |
|
steps for tuning oracle...! |
3 |
2343 |
Tue, 12 July 2005 11:23 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Regarding CPU utilization |
4 |
2180 |
Tue, 12 July 2005 08:15 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) |
|
Trace files not getting generated |
2 |
5341 |
Mon, 11 July 2005 14:19 By: srinivas4u2 ![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 find out where oracle is using paging and swapping (merged) |
6 |
3336 |
Mon, 11 July 2005 11:35 By: srinivas4u2 ![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) |
|
shutting down database By: kinjal on Fri, 08 July 2005 |
7 |
2336 |
Mon, 11 July 2005 10:12 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 index or single column index? By: liux99 on Wed, 06 July 2005 |
3 |
2378 |
Wed, 06 July 2005 13:15 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) |
|
SQL*Net messages |
1 |
2089 |
Wed, 06 July 2005 12:05 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) |
|
unable to allocate 4128 bytes of shared memory ("shared pool |
4 |
13742 |
Mon, 04 July 2005 01:53 By: ziggy ![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 |
1 |
2010 |
Wed, 29 June 2005 08:23 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) |
|
Logical database design |
5 |
2447 |
Mon, 27 June 2005 13:20 By: andrew again ![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 for temporary table By: liux99 on Fri, 24 June 2005 |
3 |
3054 |
Fri, 24 June 2005 16:31 By: andrew again ![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) |
|
Archival of Production Database |
6 |
2691 |
Wed, 22 June 2005 17:06 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) |
|
How to optimize this sql |
7 |
2311 |
Wed, 22 June 2005 09:41 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) |
|
Need some info Capacity Planning ---- Urgent |
1 |
1927 |
Tue, 21 June 2005 16:13 By: andrew again ![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 increase Performance of Composite Primary Key |
1 |
1819 |
Tue, 21 June 2005 16:03 By: andrew again ![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) |
|
Need some help resizing SGA parameters |
1 |
2110 |
Tue, 21 June 2005 04:09 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Reg. Performance Issue with XML |
0 |
2689 |
Tue, 21 June 2005 02:03 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) |
|
Measuring time exection By: jef1 on Sat, 18 June 2005 |
2 |
2479 |
Mon, 20 June 2005 04:07 By: limer ![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) |
|
choosing the right query |
3 |
2077 |
Sun, 19 June 2005 06:23 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 avoid the full table scan? |
2 |
6970 |
Sat, 18 June 2005 03:56 By: srraajesh ![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) |
|
VERY URGENT -- SQL- TUNING |
5 |
2293 |
Thu, 16 June 2005 14:40 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Decide the size of every component of SGA in given case? |
7 |
3907 |
Thu, 16 June 2005 14:38 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) |
|
Storage recomendation please |
1 |
2624 |
Thu, 16 June 2005 14: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) |
|
Locally Managed Table syntax |
8 |
3373 |
Wed, 15 June 2005 16:38 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 do you cleanup chained rows! |
9 |
2724 |
Wed, 15 June 2005 16:03 By: jake374 ![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) |
getting bad Performance during use |
5 |
3658 |
Wed, 15 June 2005 15:24 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Which parameter? |
8 |
2445 |
Wed, 15 June 2005 08:45 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) |
|
which view to use to know about global partitioned index |
1 |
1742 |
Tue, 14 June 2005 14:00 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) |
|
SQL QUERY NOT USING BITMAP INDEX |
8 |
4562 |
Tue, 14 June 2005 09:30 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) |
|
Index on varchar2(2500) |
7 |
3395 |
Tue, 14 June 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) |
|
RBO is there in oracle 10g? |
5 |
2610 |
Tue, 14 June 2005 09: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) |
|
FTS even there is an index on table. |
5 |
2303 |
Tue, 14 June 2005 08:39 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) |
|
HELP ON STATSPACK |
2 |
2114 |
Tue, 14 June 2005 04:33 By: sponguru_dba ![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 is the user executing query which is using more disk space? |
2 |
2194 |
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 |
1948 |
Mon, 13 June 2005 10:03 By: smartin ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |