|
|
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 |
3086 |
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 |
15355 |
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 |
2442 |
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 |
1970 |
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 |
2614 |
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 |
2109 |
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 |
1945 |
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 |
2231 |
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 |
2004 |
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 |
1889 |
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 |
5237 |
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 |
2332 |
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 |
3643 |
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 |
1831 |
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 |
3219 |
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 |
2696 |
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 |
1939 |
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 |
2662 |
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 |
1561 |
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 |
2216 |
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 |
2833 |
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 |
2031 |
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 |
1562 |
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 |
4299 |
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 |
2504 |
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 |
5073 |
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 |
2901 |
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 |
2510 |
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 |
3633 |
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 |
2839 |
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 |
3035 |
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 |
2137 |
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 |
2181 |
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 |
1819 |
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 |
2401 |
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 |
2200 |
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 |
2780 |
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 |
2312 |
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 |
2047 |
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 |
2830 |
Thu, 15 March 2007 20:38 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |