|
|
Topic |
Replies |
Views |
Last message |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
decode By: memory on Thu, 05 April 2007 |
11 |
2967 |
Tue, 10 April 2007 02:50 By: Maaher ![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 materialized views By: laiko on Fri, 06 April 2007 |
8 |
15236 |
Mon, 09 April 2007 23:40 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) |
|
fastest way for delete cascade By: laiko on Fri, 06 April 2007 |
3 |
2330 |
Sat, 07 April 2007 02:51 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) |
|
Selecting different columns behave differently. |
2 |
1863 |
Sat, 07 April 2007 01:18 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) |
|
All v$session_event numbers don't add to total time |
5 |
2508 |
Fri, 06 April 2007 10:50 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) |
|
table and its count By: ozzy80 on Thu, 05 April 2007 |
3 |
1984 |
Thu, 05 April 2007 14:23 By: ozzy80 ![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 a table- "newbie" help |
2 |
1834 |
Thu, 05 April 2007 07:22 By: karaseg ![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) |
|
hint usage. |
4 |
2122 |
Wed, 04 April 2007 14:01 By: nmacdannald ![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) |
|
Table Partition - Suggestion required By: Brayan on Wed, 04 April 2007 |
2 |
1895 |
Wed, 04 April 2007 02:53 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) |
|
Procedure Cost Problem |
1 |
1784 |
Wed, 04 April 2007 02:44 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) |
|
Query regarding Analyze table By: be2sp1 on Wed, 04 April 2007 |
2 |
5125 |
Wed, 04 April 2007 02:41 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
tuning of plsql program By: memory on Wed, 04 April 2007 |
3 |
2236 |
Wed, 04 April 2007 02:12 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
How to tune my sql script By: memory on Mon, 02 April 2007 |
10 |
3519 |
Tue, 03 April 2007 22: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) |
|
Complex query |
2 |
1738 |
Tue, 03 April 2007 22:21 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) |
|
Database Performance Issue VS Network Performance Issue |
3 |
3110 |
Tue, 03 April 2007 14:57 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) |
|
views in 92 By: moody1 on Tue, 03 April 2007 |
3 |
2572 |
Tue, 03 April 2007 13:57 By: moody1 ![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 |
2 |
1826 |
Mon, 02 April 2007 22:40 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) |
|
Does Altering Index Monitoring have Locks |
2 |
2563 |
Mon, 02 April 2007 11:12 By: gkodakalla ![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 regarding deleting the reords from DB |
1 |
1450 |
Mon, 02 April 2007 06:22 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 error 35153 temporary tablespace is empty |
1 |
2107 |
Mon, 02 April 2007 03:09 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) |
|
Forms Performance |
8 |
2718 |
Fri, 30 March 2007 02:13 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) |
|
Sizing a DB |
2 |
1912 |
Thu, 29 March 2007 13:47 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) |
|
Training on 10g PT |
1 |
1460 |
Thu, 29 March 2007 03:30 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) |
|
Slow Query Execuation By: bahy91 on Wed, 28 March 2007 |
12 |
4175 |
Wed, 28 March 2007 07:18 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) |
|
tuning needed for a query |
3 |
2397 |
Tue, 27 March 2007 07:48 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) |
|
list all active connections with sql statement used? By: bahy91 on Mon, 26 March 2007 |
9 |
4921 |
Mon, 26 March 2007 09:14 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) |
|
Oracle10g Performance question By: bahy91 on Thu, 22 March 2007 |
9 |
2744 |
Mon, 26 March 2007 02:11 By: bahy91 ![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 optimizer |
4 |
2378 |
Sat, 24 March 2007 12:24 By: nmacdannald ![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 execution time is fluctuating lot |
3 |
3510 |
Fri, 23 March 2007 22: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) |
|
Any Better Way to Tune this Query |
2 |
2711 |
Fri, 23 March 2007 22:06 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) |
|
10gR2 impossible de lancer DBCONSOLE By: Haler on Fri, 16 March 2007 |
2 |
2907 |
Fri, 23 March 2007 09:46 By: Haler ![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 Needed |
2 |
2003 |
Fri, 23 March 2007 09:11 By: nmacdannald ![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) |
|
Caling package |
2 |
2062 |
Thu, 22 March 2007 02:13 By: danijelv ![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 Space Usage Measurements |
1 |
1707 |
Wed, 21 March 2007 08:28 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) |
|
STATSPACK Report |
3 |
2303 |
Wed, 21 March 2007 06:29 By: cbruhn2 ![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) |
|
to find out how many times a table got queried |
4 |
2046 |
Mon, 19 March 2007 16:45 By: cbruhn2 ![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 rewrite the outer join statement |
3 |
2675 |
Sat, 17 March 2007 08:06 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) |
|
Oracle 8.1.7 statistics problem |
3 |
2213 |
Fri, 16 March 2007 14:29 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) |
|
Delete statement and performance |
5 |
1953 |
Fri, 16 March 2007 01:21 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) |
|
Benchmarking UPDATE Statements |
3 |
2720 |
Thu, 15 March 2007 20:38 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |