|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
query issue oracle 10g |
24 |
4029 |
Thu, 10 March 2011 21:15 By: Flyby ![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) |
|
prev_hash_value not changing in v$session Oracle 10.2.0.4.0 on RHEL |
6 |
4466 |
Thu, 10 March 2011 09:04 By: OraKaran ![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 Performance Oracle 11g Windows2000 Server |
7 |
14527 |
Thu, 10 March 2011 07:57 By: martateixeira ![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 tuning |
7 |
3504 |
Thu, 10 March 2011 07:36 By: marcodba ![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) |
|
Stored Procedure is taking too long time to Execute. (2 Merged) Oracle 11.2 |
6 |
6325 |
Wed, 09 March 2011 12:36 By: BlackSwan ![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 Tuning Oracle 10.2.0.4 By: sathik on Tue, 22 February 2011 |
12 |
5083 |
Tue, 08 March 2011 07:43 By: marcodba ![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) |
|
inserting data using FOR ALL 9i/10g |
3 |
3852 |
Sun, 06 March 2011 17:35 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) |
|
performance tuning oracle 10g |
7 |
4062 |
Fri, 04 March 2011 03:43 By: cookiemonster ![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) |
|
Tunning the query and 4000-5000 parameter in IN clause |
12 |
4485 |
Thu, 03 March 2011 12:12 By: Littlefoot ![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) |
|
Collecting stats oracle 10.2.0.1.0 - windows XP |
1 |
2217 |
Thu, 03 March 2011 04:14 By: Michel Cadot ![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) |
|
Dynamic SQL performance Oracle 10G By: uicmxz on Mon, 28 February 2011 |
1 |
2608 |
Mon, 28 February 2011 17:19 By: BlackSwan ![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) |
|
faster processing of records needed: performance isue oracle 9i/10g/11g |
2 |
2342 |
Mon, 28 February 2011 08:01 By: michael_bialik ![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) |
Wrong REDO log file location Oracle 10G, Solaris 10 |
4 |
4281 |
Fri, 25 February 2011 20:43 By: wkk1020 ![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 to wrire the procedure oracle,10g,unix |
2 |
2099 |
Fri, 25 February 2011 15:10 By: cookiemonster ![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 tuning general |
4 |
2889 |
Fri, 25 February 2011 07:31 By: samosimo ![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_sharing setting in OLTP environment Oracle 9i R2, 10g R2 |
11 |
5098 |
Wed, 23 February 2011 08:13 By: OraKaran ![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) |
|
Identify blocking sessions 11.1.0.7, Standard Edition |
4 |
4847 |
Tue, 22 February 2011 03:49 By: John Watson ![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 Sql query Oracle 10.2.0.3 |
8 |
5242 |
Sun, 20 February 2011 06:00 By: Its_me_ved ![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 10.2.0.4 |
2 |
2312 |
Sun, 20 February 2011 00:26 By: Michel Cadot ![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) |
Performance tuning of PL/SQL Procedure Oracle 10.2.0.5 |
10 |
4601 |
Thu, 17 February 2011 09:26 By: cookiemonster ![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 issue in jsp application Oracle 10.2.0.3,jsp |
2 |
2355 |
Wed, 16 February 2011 05:52 By: rleishman ![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 Update Oracle 11g By: rcd70 on Tue, 15 February 2011 |
1 |
2780 |
Tue, 15 February 2011 18:54 By: BlackSwan ![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) |
Optimal REDO log file size Oracle 10G, Solaris 10 |
9 |
13378 |
Mon, 14 February 2011 03:44 By: Tlg13team ![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 tuning oracle 9i/10g/11g |
6 |
2071 |
Sun, 13 February 2011 23:32 By: Michel Cadot ![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 query Oracle,11.1.0.6,RHEL 5 |
6 |
2575 |
Fri, 11 February 2011 12:44 By: Michel Cadot ![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) |
|
Queries on PGA Settings and related Memory Management Oracle 9i on RHEL |
8 |
7246 |
Fri, 11 February 2011 11:14 By: OraKaran ![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) |
|
Delete command running taking long time windows server 2003, oracle 11g DB By: pradies on Fri, 11 February 2011 |
9 |
4243 |
Fri, 11 February 2011 05:33 By: OraKaran ![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) |
|
Application is slow when no of connections goes up Oracle Database 8.1.7 on Solaris By: rajan69 on Wed, 09 February 2011 |
2 |
2269 |
Wed, 09 February 2011 07:19 By: cookiemonster ![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 Change execution plan of Currently Executing Statement? Oracle 10.2.4.0 on RHEL |
6 |
5395 |
Wed, 09 February 2011 03:21 By: OraKaran ![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) |
|
data caching oraclge 10g By: gamba on Mon, 07 February 2011 |
7 |
2640 |
Tue, 08 February 2011 03:30 By: cookiemonster ![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) |
|
Real time speed improvements & autotrace results. Oracle 9.2/Solaris |
11 |
5427 |
Mon, 07 February 2011 09:43 By: Roachcoach ![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) |
|
Update columns of one table using another table Oracle 10G |
4 |
2820 |
Mon, 07 February 2011 02:08 By: priyankt ![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) |
|
tunning oracle 10g/windows 2003 By: gxeon on Fri, 04 February 2011 |
5 |
2955 |
Fri, 04 February 2011 08:11 By: gxeon ![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 Regarding Nested Loop Oracle 9i R2 on RHEL |
27 |
4208 |
Thu, 03 February 2011 06:34 By: Michel Cadot ![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 Snapshot Avaliable for AWR Report Oracle 11g, Windows 2003 By: pradies on Tue, 01 February 2011 |
8 |
13777 |
Wed, 02 February 2011 01:35 By: Michel Cadot ![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) |
|
Problem queries of Materialized Views Oracle 9.2.0.8 , HP-UX B11.23 |
21 |
3675 |
Tue, 01 February 2011 11:36 By: Art Trifonov ![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) |
|
Disable ADR By: renafi on Fri, 28 January 2011 |
2 |
2686 |
Sat, 29 January 2011 09:07 By: daverich ![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 usage in order by clause on nullable column Oracle 10gR2 on RHEL |
5 |
6645 |
Fri, 28 January 2011 19:12 By: rleishman ![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 a stats table instead of regular stats to get a plan 9i |
2 |
2450 |
Fri, 28 January 2011 02:48 By: Kevin Meade ![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) |
Long Running Query Oracle 9,Unix |
1 |
1769 |
Fri, 28 January 2011 00:36 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |