|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Rollback segment error in production HELP |
1 |
3980 |
Thu, 28 April 2005 06:26 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Script needed ---- URGENT Please HELP |
0 |
2541 |
Wed, 27 April 2005 14:08 By: goodfrnd ![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 much SGA..? |
3 |
2300 |
Wed, 27 April 2005 06: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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Help!!!!!!! Tuning using SQL_TRACE |
13 |
4677 |
Tue, 26 April 2005 11:06 By: ankurgodambe ![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 network application information |
1 |
1875 |
Mon, 25 April 2005 08:55 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) |
|
Avoiding Cursors. |
2 |
2053 |
Fri, 22 April 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) |
|
tuning question |
6 |
2429 |
Thu, 21 April 2005 06:29 By: Bruce Carson ![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) |
Analyze table&Index By: chara on Wed, 20 April 2005 |
3 |
2599 |
Wed, 20 April 2005 08:53 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) |
|
Count oracle user process By: ntnboi on Fri, 15 April 2005 |
3 |
4312 |
Wed, 20 April 2005 06:33 By: ntnboi ![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) |
|
this query is taking 58 seconds to execute |
1 |
2303 |
Tue, 19 April 2005 23:38 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) |
![icon11.gif](/forum/images/message_icons/icon11.gif) |
lock_sga parameter cause out of memory error |
2 |
6333 |
Tue, 19 April 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) |
|
large sort |
4 |
2642 |
Tue, 19 April 2005 03:21 By: _simma_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) |
|
URGENT:-Tuning a query |
1 |
2338 |
Sun, 17 April 2005 07:31 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) |
|
how to check whether index is rebuilt or not? |
7 |
7051 |
Wed, 13 April 2005 09:06 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) |
|
Check list to Tune an Application ( SQL & PL/SQL) |
1 |
1962 |
Wed, 13 April 2005 08:32 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) |
|
STATSPACK |
1 |
2364 |
Tue, 12 April 2005 14:27 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 Report |
2 |
2322 |
Tue, 12 April 2005 12:32 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) |
|
Bulk Exception giving incomplete Information. By: abc123 on Fri, 08 April 2005 |
2 |
3480 |
Tue, 12 April 2005 08:44 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) |
|
disk partition strategy for best performance... By: 760613 on Thu, 07 April 2005 |
2 |
2103 |
Mon, 11 April 2005 07:13 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 see the analyze table |
1 |
1987 |
Sun, 10 April 2005 09:27 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) |
|
Oracle 9i Explian Plan output- TOAD |
1 |
3023 |
Thu, 07 April 2005 09:28 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) |
|
To tune query |
0 |
2861 |
Thu, 07 April 2005 08:21 By: anmol1947 ![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) |
|
no_index optimizer hint |
1 |
6518 |
Thu, 07 April 2005 06:36 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) |
|
Selecting data out of a partition |
1 |
8445 |
Fri, 01 April 2005 15:54 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 to tune first |
8 |
4226 |
Wed, 30 March 2005 20:19 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) |
|
Tuning a query |
1 |
3248 |
Mon, 28 March 2005 10:39 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) |
|
Server response degrades |
1 |
1985 |
Thu, 24 March 2005 14: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) |
|
big oracle problem please help By: dong94 on Tue, 22 March 2005 |
2 |
2401 |
Wed, 23 March 2005 20:46 By: dong94 ![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) |
|
PL/SQL code is conusimg alot of shared memory By: v_gate on Fri, 18 March 2005 |
1 |
1853 |
Fri, 18 March 2005 11:26 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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Tunning - urgent By: kavi on Tue, 08 March 2005 |
4 |
2307 |
Fri, 18 March 2005 09: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) |
|
Undo Tablespace Issue - Archiving Case |
5 |
3367 |
Fri, 18 March 2005 09:10 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) |
|
Want sql executed session wise |
1 |
1837 |
Fri, 11 March 2005 03:08 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) |
|
High Consistent gets By: vipin on Thu, 10 March 2005 |
1 |
2319 |
Thu, 10 March 2005 08:14 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) |
|
ora-02287 sequnce not allowed here |
1 |
3052 |
Wed, 09 March 2005 15:12 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) |
|
URGENT:-Performance Tuning a query |
5 |
2778 |
Wed, 09 March 2005 08:15 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) |
|
Issue of low buffer hit ratio |
2 |
4200 |
Wed, 09 March 2005 04:56 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) |
|
Results TRACE By: Tads on Fri, 04 March 2005 |
1 |
1876 |
Tue, 08 March 2005 09: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) |
![icon11.gif](/forum/images/message_icons/icon11.gif) |
Performance problems |
1 |
2008 |
Mon, 07 March 2005 17:16 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Remote DB Status By: fanni on Sun, 06 March 2005 |
2 |
1960 |
Mon, 07 March 2005 06:32 By: sridcpp ![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 not used when changing the selected columns By: himang on Mon, 07 March 2005 |
2 |
1976 |
Mon, 07 March 2005 03:45 By: himang ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |