|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Taking ForEver By: Venkat on Tue, 08 June 2004 |
1 |
2350 |
Mon, 14 June 2004 03:12 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) |
|
Oracle - Info Log By: Angie on Wed, 26 May 2004 |
1 |
1770 |
Fri, 11 June 2004 06:18 By: Frank Naude ![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 at instance Level By: Avi on Thu, 10 June 2004 |
1 |
2330 |
Thu, 10 June 2004 08:04 By: sverch ![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) |
|
Performace Tuning Of Insert Statement |
1 |
1737 |
Thu, 10 June 2004 08:01 By: sverch ![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 in using DBMS_JOB By: fanni on Tue, 08 June 2004 |
0 |
1767 |
Tue, 08 June 2004 04:56 By: fanni ![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) |
|
Understanding FIRST_ROWS |
3 |
3507 |
Mon, 07 June 2004 06:21 By: David Peters ![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) |
|
Memory question |
1 |
2271 |
Fri, 04 June 2004 12:21 By: Art Metzer ![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 improve efficiency of Oracle 9i APS |
0 |
2080 |
Thu, 03 June 2004 05:28 By: Imran Waheed ![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/index By: shweta on Mon, 17 May 2004 |
5 |
2332 |
Wed, 02 June 2004 22:13 By: Vikash ![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 improve performance on insertion, deletion and update By: Vikash on Tue, 01 June 2004 |
2 |
1918 |
Wed, 02 June 2004 07:45 By: sy ![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) |
|
MYSTATS table - Capture Stats? By: IA on Mon, 31 May 2004 |
2 |
2946 |
Tue, 01 June 2004 18:32 By: Sujit Sarkar ![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) |
|
Multiprocessor Processor Performance Research By: Darren on Tue, 01 June 2004 |
0 |
2036 |
Tue, 01 June 2004 14:04 By: Darren ![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) |
|
db peak time urgent By: ramya on Tue, 01 June 2004 |
0 |
2022 |
Tue, 01 June 2004 01:09 By: ramya ![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) |
|
Reverse Key Indexes By: Avi on Mon, 31 May 2004 |
0 |
1990 |
Mon, 31 May 2004 18:54 By: Avi ![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) |
|
tkprof By: Sam on Mon, 31 May 2004 |
1 |
1803 |
Mon, 31 May 2004 14:10 By: andrew again ![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) |
|
Strange Performance Problem |
2 |
1947 |
Mon, 31 May 2004 09:45 By: Pamela Wright ![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) |
|
commit takes a long time |
1 |
1629 |
Mon, 31 May 2004 04:38 By: ora9iDBA ![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) |
|
REBUILD INDEXES |
1 |
1840 |
Mon, 31 May 2004 04:35 By: ora9iDBA ![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 measure a database performance? By: Nabil on Wed, 19 May 2004 |
2 |
2255 |
Sat, 29 May 2004 02:55 By: pcgoud ![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: Oracle 8.0.6 - alter table move |
1 |
2617 |
Wed, 26 May 2004 19:36 By: Sujit Sarkar ![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_STATS.GATHER_TABLE_STATS By: Mahesh on Wed, 26 May 2004 |
0 |
3004 |
Wed, 26 May 2004 10:51 By: Mahesh ![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: truncate take longer time. |
5 |
2264 |
Wed, 26 May 2004 07:37 By: sverch ![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 Viewer Enterprise for Oracle10g |
0 |
3132 |
Wed, 26 May 2004 00:46 By: Alexey B. Danchenkov ![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) |
|
Statistics on tables. |
1 |
1601 |
Tue, 25 May 2004 13:42 By: sverch ![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 |
1 |
1703 |
Thu, 20 May 2004 01:48 By: Frank Naude ![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 a PIN? By: IA on Sun, 16 May 2004 |
2 |
1609 |
Mon, 17 May 2004 18:00 By: IA ![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) |
|
Average IO Time By: IA on Sun, 16 May 2004 |
1 |
1869 |
Sun, 16 May 2004 23:45 By: Daljit Singh ![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) |
|
Acceptable total Waits ? By: IA on Sun, 16 May 2004 |
1 |
1835 |
Sun, 16 May 2004 23:43 By: Daljit Singh ![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 Tuning By: Monu on Mon, 10 May 2004 |
1 |
1785 |
Fri, 14 May 2004 10:20 By: Satish Shrikhande ![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) |
|
IO Advice By: Tomasz on Fri, 14 May 2004 |
1 |
1637 |
Fri, 14 May 2004 08:34 By: andrew again ![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 Inline View |
1 |
2071 |
Thu, 13 May 2004 08:51 By: andrew again ![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 Urgent By: sujit on Tue, 11 May 2004 |
1 |
1809 |
Wed, 12 May 2004 04:45 By: Himanshu ![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) |
|
sample data to test Oracle database performance |
3 |
2490 |
Sat, 08 May 2004 05:12 By: nobita ![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) |
|
Simple SELECT statement taking too long By: Cocoy on Mon, 05 April 2004 |
8 |
2637 |
Mon, 03 May 2004 19:37 By: Cocoy ![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) |
|
Cost-based optimization slows down my query |
4 |
1884 |
Mon, 03 May 2004 07:19 By: David Peters ![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) |
|
Optimize performance for Update Opertaion |
2 |
1720 |
Sat, 01 May 2004 14:07 By: Ali Ansari ![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) |
|
TKPROF STATISTICS-To Mr.Daljit Singh By: Monu on Fri, 30 April 2004 |
0 |
1912 |
Fri, 30 April 2004 03:11 By: Monu ![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) |
|
TKPROF HELP By: Monu on Fri, 30 April 2004 |
0 |
1764 |
Fri, 30 April 2004 00:23 By: Monu ![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) |
|
foreign keys affect performance? |
3 |
1897 |
Thu, 29 April 2004 10:45 By: andrew again ![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) |
|
TKPROF By: Monu on Thu, 29 April 2004 |
2 |
1602 |
Thu, 29 April 2004 04:03 By: Daljit Singh ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |