|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Improving performance of a query using order by clause |
5 |
2762 |
Mon, 28 May 2007 11:54 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) |
|
Physical gets increasing after scheduled export |
2 |
1696 |
Mon, 28 May 2007 05:03 By: sujeetsaxena16 ![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 Database Performance Tuning (Note Sheets) |
2 |
5480 |
Sun, 27 May 2007 04:49 By: ahmedb72 ![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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
Stress Oracle & OAS |
3 |
4336 |
Fri, 25 May 2007 02:17 By: waveblue ![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) |
|
Does using dbms_lob package improve performance |
3 |
2026 |
Thu, 24 May 2007 10:39 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) |
|
UL locks in Oracle Workspace Manager By: rokyta on Thu, 24 May 2007 |
0 |
10716 |
Thu, 24 May 2007 05:34 By: rokyta ![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 |
4 |
2898 |
Wed, 23 May 2007 03:29 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 to get TRACE for a Sql script which is being called from a shell program |
11 |
2659 |
Tue, 22 May 2007 10:04 By: tahpush ![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) |
|
Need Help |
5 |
1977 |
Tue, 22 May 2007 00:29 By: faisalferoze ![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) |
|
NEED GUIDENCE By: pavanv on Sat, 19 May 2007 |
2 |
2627 |
Sun, 20 May 2007 05:29 By: mchadder ![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) |
|
optimizer mode in oracle 10g |
4 |
9389 |
Fri, 18 May 2007 13:15 By: DreamzZ ![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 |
5 |
1803 |
Fri, 18 May 2007 13: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) |
|
Statspack Report By: chara on Wed, 16 May 2007 |
3 |
5049 |
Fri, 18 May 2007 11:50 By: DreamzZ ![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) |
|
dbms_profiler |
6 |
4550 |
Wed, 16 May 2007 05:39 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) |
|
My production statspack report |
7 |
5753 |
Wed, 16 May 2007 03:33 By: kamkan ![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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
Slow query responce |
3 |
4284 |
Tue, 15 May 2007 04:39 By: jai_subi ![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) |
|
Setting sql trace parameter |
2 |
5073 |
Tue, 15 May 2007 01:47 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) |
|
Rule based but has cost in explain plan.. why? By: beetel on Fri, 11 May 2007 |
3 |
2077 |
Mon, 14 May 2007 13:45 By: jrich ![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) |
|
my production database is taking 50% of CPU consumption in main db server |
12 |
5826 |
Mon, 14 May 2007 06:39 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) |
|
SGA size |
12 |
5979 |
Sun, 13 May 2007 04:41 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) |
|
Explain plan Cost vs time elapsed By: beetel on Fri, 11 May 2007 |
2 |
2922 |
Sat, 12 May 2007 02:41 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 query too slow -maybe needs indexes? By: eb222 on Fri, 11 May 2007 |
4 |
2451 |
Fri, 11 May 2007 13:48 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) |
|
Regarding partitions |
4 |
1983 |
Fri, 11 May 2007 08:39 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) |
|
Tuning update statement |
3 |
3417 |
Thu, 10 May 2007 07:22 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) |
|
indexes difference as table columns |
3 |
1965 |
Thu, 10 May 2007 03:42 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) |
|
Optimal size for my memory components ( development db ) |
1 |
1628 |
Thu, 10 May 2007 03:13 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) |
|
Long Running SQL -V$session_longops By: mymot on Wed, 09 May 2007 |
2 |
2431 |
Wed, 09 May 2007 16:34 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) |
|
TUNING |
4 |
2774 |
Wed, 09 May 2007 09:58 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) |
|
Re-creating partitioned tablespaces from backup. By: Brayan on Tue, 08 May 2007 |
6 |
3161 |
Wed, 09 May 2007 05:08 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) |
|
Long Running SQL - Oracle By: mymot on Tue, 08 May 2007 |
3 |
2204 |
Tue, 08 May 2007 07:53 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) |
|
insufficient privileges when generating explain plan for a synonym |
4 |
6122 |
Tue, 08 May 2007 04:10 By: win3vin ![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) |
|
DATABASE DOWN WHEN MANY USERS LOG IN By: MELAKU on Sat, 28 April 2007 |
19 |
4591 |
Mon, 07 May 2007 00: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) |
|
Index Issues |
5 |
2296 |
Sun, 06 May 2007 21:27 By: Teddyboy ![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 with ONLINE Option |
2 |
1845 |
Sun, 06 May 2007 16: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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
oracle sql query analyzer optimize tool |
3 |
3556 |
Sat, 05 May 2007 09:06 By: saibal ![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) |
|
Gather Statistics - SYS By: Brayan on Thu, 03 May 2007 |
2 |
4280 |
Fri, 04 May 2007 17:02 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) |
|
Shared Pool Statistics - StatsPack Report By: Brayan on Fri, 04 May 2007 |
3 |
13156 |
Fri, 04 May 2007 08:01 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) |
|
Movting Index partitions to differenet tablespaces. |
1 |
1609 |
Fri, 04 May 2007 03:32 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) |
|
Performance monitoring |
1 |
2261 |
Fri, 04 May 2007 03:04 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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Problem with spreport.sql |
4 |
12357 |
Thu, 03 May 2007 14:03 By: thorin666 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |