|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Slow update with Bulk collect and Forall By: aliceg on Mon, 24 September 2007 |
8 |
6032 |
Fri, 28 September 2007 18:31 By: aliceg ![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 of Oracle 9i in Unix machine (merged 3) |
18 |
2934 |
Fri, 28 September 2007 14:31 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) |
|
ORA-12560:TNS protocol adapter Error while upgrading oracle 8i to Oracle 9i |
3 |
4416 |
Fri, 28 September 2007 11:23 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) |
|
Help: Identifying Problem in the query By: kumarsz on Sun, 23 September 2007 |
20 |
4957 |
Thu, 27 September 2007 08:03 By: kumarsz ![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) |
|
multiple size of db_block |
12 |
3807 |
Thu, 27 September 2007 04:04 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) |
slow perf with Bulk collect and FORALL By: aliceg on Wed, 11 July 2007 |
21 |
11044 |
Wed, 26 September 2007 21:37 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) |
|
Help :Getting Inner query executions from v$sql_plan_statistics_all By: kumarsz on Wed, 26 September 2007 |
8 |
2543 |
Wed, 26 September 2007 12:06 By: mson77 ![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 in SQL queries and PL/SQL |
7 |
2526 |
Wed, 26 September 2007 11:34 By: psiva_oracle ![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 the different between the varchar2 and nvarchar2? |
1 |
1620 |
Wed, 26 September 2007 06:21 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) |
|
Library Cache Lock By: fakru.y on Wed, 26 September 2007 |
1 |
2463 |
Wed, 26 September 2007 03:10 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) |
|
Buffer Cache |
3 |
1701 |
Wed, 26 September 2007 01:23 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) |
|
Adding columns vs Adding tables |
7 |
2142 |
Tue, 25 September 2007 17:32 By: pablolee ![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) |
|
Increase the redo log buffer: a couple of questions |
1 |
1999 |
Tue, 25 September 2007 06:18 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) |
|
AWR REPORT |
4 |
5518 |
Tue, 25 September 2007 04:48 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) |
|
I have one problem with snapshot date |
1 |
1368 |
Mon, 24 September 2007 20:58 By: mson77 ![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 rebuild |
16 |
4941 |
Mon, 24 September 2007 15:35 By: mson77 ![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 code causing redo to generate |
3 |
1596 |
Mon, 24 September 2007 05:56 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) |
|
Variance in -Row Source Generation, Explain Plan and statspack By: kumarsz on Sat, 22 September 2007 |
1 |
3375 |
Sun, 23 September 2007 10:49 By: mson77 ![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 Sharing Problem (STB_OBJECT_MISMATCH) |
5 |
3399 |
Fri, 21 September 2007 13:10 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) |
|
0ra-1920 |
3 |
2059 |
Fri, 21 September 2007 01:02 By: mson77 ![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) |
|
About Bitmap Index |
5 |
1969 |
Thu, 20 September 2007 23:20 By: bagulia_pilla ![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) |
|
top query find through sqlplus ? |
4 |
1803 |
Thu, 20 September 2007 22:00 By: mson77 ![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 of query (Not DBA Level Tuning) By: nawshot on Wed, 19 September 2007 |
4 |
2244 |
Wed, 19 September 2007 14:31 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) |
|
Heavy query with GL |
1 |
2644 |
Wed, 19 September 2007 13:55 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) |
|
Query Tuning Problem (tkprof o/p,query & explain plan attached) |
4 |
3349 |
Wed, 19 September 2007 01:22 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) |
|
Help - Creating Stored Outlines By: kumarsz on Thu, 13 September 2007 |
1 |
2773 |
Tue, 18 September 2007 08:46 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) |
|
outer join problem By: Nusrat on Sun, 16 September 2007 |
9 |
2692 |
Tue, 18 September 2007 06:34 By: flyboy ![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 taking 2min with order by clause |
1 |
1391 |
Tue, 18 September 2007 06:12 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) |
|
Processing lots of data |
5 |
1744 |
Mon, 17 September 2007 12:56 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) |
|
Help - Will Reducing cardinality using histogram make query run faster? By: kumarsz on Wed, 12 September 2007 |
4 |
1642 |
Mon, 17 September 2007 05:48 By: JRowbottom ![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 help needed in tuning the query By: grk28 on Thu, 13 September 2007 |
10 |
3281 |
Sun, 16 September 2007 23:10 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) |
|
statspack |
12 |
11956 |
Sat, 15 September 2007 17:33 By: mson77 ![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) |
|
Finding Status Progress of Query with Single Block I/O By: kumarsz on Sat, 15 September 2007 |
9 |
2236 |
Sat, 15 September 2007 12:22 By: kumarsz ![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) |
|
RMAN causing CPU boottleneck |
2 |
3079 |
Fri, 14 September 2007 11:22 By: srinivnp ![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 in insert |
10 |
2067 |
Fri, 14 September 2007 05:01 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) |
|
AWR report |
1 |
1326 |
Thu, 13 September 2007 05:36 By: ebrian ![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) |
|
TIMED_STATISTICS parameter |
2 |
1649 |
Thu, 13 September 2007 04:57 By: tanmoy1048 ![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 rebuild indexes |
1 |
1345 |
Thu, 13 September 2007 00:03 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) |
|
Module in Statspack Report By: kumarsz on Wed, 12 September 2007 |
3 |
1806 |
Wed, 12 September 2007 13:54 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) |
|
lots of waits sql*net |
2 |
2071 |
Wed, 12 September 2007 12:04 By: thorin666 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |