|
|
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 |
6041 |
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 |
2936 |
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 |
4419 |
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 |
4984 |
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 |
3810 |
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 |
11057 |
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 |
2555 |
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 |
2531 |
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 |
1626 |
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 |
2468 |
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 |
1704 |
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 |
2147 |
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 |
2004 |
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 |
5520 |
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 |
1371 |
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 |
4948 |
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 |
1602 |
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 |
3383 |
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 |
3412 |
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 |
2065 |
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 |
1974 |
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 |
1805 |
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 |
2251 |
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 |
2660 |
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 |
3350 |
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 |
2782 |
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 |
2699 |
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 |
1395 |
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 |
1746 |
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 |
1645 |
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 |
3292 |
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 |
11966 |
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 |
2239 |
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 |
3086 |
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 |
2080 |
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 |
1330 |
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 |
1654 |
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 |
1351 |
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 |
1809 |
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 |
2082 |
Wed, 12 September 2007 12:04 By: thorin666 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |