|
|
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 |
2954 |
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 |
15222 |
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 |
2319 |
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 |
1849 |
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 |
2494 |
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 |
1973 |
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 |
1822 |
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 |
2110 |
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 |
1885 |
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 |
1772 |
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 |
5115 |
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 |
2223 |
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 |
3504 |
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 |
1725 |
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 |
3098 |
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 |
2559 |
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 |
1814 |
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 |
2552 |
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 |
1439 |
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 |
2095 |
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 |
2705 |
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 |
1901 |
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 |
1448 |
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 |
4164 |
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 |
2387 |
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 |
4909 |
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 |
2732 |
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 |
2368 |
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 |
3501 |
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 |
2703 |
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 |
2897 |
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 |
1991 |
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 |
2049 |
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 |
1694 |
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 |
2291 |
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 |
2036 |
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 |
2663 |
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 |
2201 |
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 |
1940 |
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 |
2708 |
Thu, 15 March 2007 20:38 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |