|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
RBO in 10g |
6 |
2305 |
Thu, 03 May 2007 06:02 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) |
|
Any Suggestion on this STATSPACK Report By: Brayan on Thu, 05 April 2007 |
3 |
2791 |
Thu, 03 May 2007 05:50 By: sriram717 ![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) |
|
Partitioning By: beetel on Thu, 26 April 2007 |
3 |
2352 |
Mon, 30 April 2007 22:30 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) |
|
Some basic tuning steps |
2 |
2566 |
Mon, 30 April 2007 08:19 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) |
|
merge join and hash join |
1 |
1669 |
Mon, 30 April 2007 08:11 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) |
|
Help - Rows accessed in FTS and Explain Plan |
2 |
1789 |
Mon, 30 April 2007 00:40 By: dbaxchangedba ![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 please... |
2 |
1629 |
Sun, 29 April 2007 04:00 By: Mohammad Taj ![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) |
|
Please help find the problem |
15 |
3712 |
Sun, 29 April 2007 02:27 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) |
|
hash partitioning.. help. |
1 |
1761 |
Sun, 29 April 2007 01:49 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) |
|
MERGE statement tuning |
7 |
11067 |
Sun, 29 April 2007 01: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) |
|
Some Suggestions |
1 |
1598 |
Sat, 28 April 2007 10:54 By: Mohammad Taj ![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 generate statspack report for a patricular user in my TEST database ? |
1 |
5330 |
Sat, 28 April 2007 05:10 By: Brayan ![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 generate explain plan in production database |
1 |
2595 |
Sat, 28 April 2007 05:06 By: Brayan ![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 10g slows down pc terribly |
4 |
3099 |
Sat, 28 April 2007 03:26 By: gintsp ![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) |
|
JUNIOR DBA |
1 |
1619 |
Sat, 28 April 2007 02: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) |
|
can we grant SYSDBA privilege to SYSTEM user ? |
1 |
2278 |
Sat, 28 April 2007 02:30 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) |
|
PARALLEL - Hint not working!!! By: Brayan on Fri, 27 April 2007 |
8 |
9345 |
Sat, 28 April 2007 02:22 By: Brayan ![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) |
|
refresh table mon_mods$ |
2 |
9366 |
Fri, 27 April 2007 08:02 By: martijn ![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) |
|
Error while trying to compute Schema Statistics |
6 |
5877 |
Thu, 26 April 2007 11:40 By: Mohammad Taj ![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 Select By: fcatak on Mon, 16 April 2007 |
21 |
5177 |
Thu, 26 April 2007 04:21 By: Dipali Vithalani ![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) |
pls!!!!!! need help |
2 |
1581 |
Wed, 25 April 2007 21:55 By: colly_liu ![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) |
|
Locks |
3 |
4035 |
Wed, 25 April 2007 17:02 By: Thagor ![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 retrieve Explain Plan in Past |
1 |
2362 |
Wed, 25 April 2007 13:35 By: dbaxchangedba ![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) |
|
Row Chaining issue By: Brayan on Tue, 24 April 2007 |
9 |
3989 |
Wed, 25 April 2007 02:12 By: Brayan ![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 RAC performance |
0 |
6817 |
Tue, 24 April 2007 03:25 By: enkhbold ![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) |
|
faq's |
1 |
1710 |
Sat, 21 April 2007 07:42 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) |
|
slow and freezed |
12 |
3156 |
Fri, 20 April 2007 08:33 By: skooman ![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) |
|
Regarding Index |
2 |
1560 |
Fri, 20 April 2007 06:14 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) |
|
faq's in perfomance tuning |
2 |
1887 |
Thu, 19 April 2007 22:25 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) |
|
finding Tuing problem |
4 |
2680 |
Thu, 19 April 2007 15:29 By: vasudevan ![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) |
|
Execution plan changed automatically. How does that happen? By: sganny on Wed, 18 April 2007 |
1 |
2044 |
Wed, 18 April 2007 23:46 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) |
|
if the data is already available in cache,will index be used if we query again? |
1 |
2836 |
Wed, 18 April 2007 03:25 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) |
|
SQL*Net message from client - Event By: Brayan on Tue, 17 April 2007 |
8 |
24587 |
Wed, 18 April 2007 02:00 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) |
|
SQL Tuning By: Brayan on Thu, 12 April 2007 |
12 |
3875 |
Wed, 18 April 2007 00:31 By: Brayan ![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 Performance By: Brayan on Thu, 12 April 2007 |
16 |
3128 |
Tue, 17 April 2007 07:45 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) |
|
efficiently populating tables |
3 |
1808 |
Mon, 16 April 2007 22:51 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) |
|
Archive log |
6 |
4250 |
Thu, 12 April 2007 01: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) |
|
basics step |
1 |
3093 |
Wed, 11 April 2007 02:15 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) |
|
can any one tell what is the order of execution of a query |
1 |
1791 |
Tue, 10 April 2007 09:27 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) |
|
How can I do like this? |
7 |
2883 |
Tue, 10 April 2007 06:40 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |