|
|
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 |
2982 |
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 |
15256 |
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 |
2349 |
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 |
1883 |
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 |
2528 |
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 |
2003 |
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 |
1857 |
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 |
2136 |
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 |
1914 |
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 |
1803 |
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 |
5143 |
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 |
2253 |
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 |
3540 |
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 |
1756 |
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 |
3129 |
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 |
2595 |
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 |
1848 |
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 |
2579 |
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 |
1468 |
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 |
2125 |
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 |
2735 |
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 |
1930 |
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 |
1476 |
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 |
4192 |
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 |
2412 |
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 |
4943 |
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 |
2761 |
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 |
2395 |
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 |
3529 |
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 |
2728 |
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 |
2926 |
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 |
2023 |
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 |
2078 |
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 |
1724 |
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 |
2316 |
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 |
2062 |
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 |
2694 |
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 |
2232 |
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 |
1972 |
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 |
2741 |
Thu, 15 March 2007 20:38 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |