|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
oracle 10g analyze table temporary segments oracle 10g |
1 |
6422 |
Tue, 05 February 2008 03: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) |
|
db job oracle 8.1.6.3,HP UNIX |
1 |
1369 |
Tue, 05 February 2008 00:55 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) |
|
Query not running in oracle 10.2.0.3 Oracle, 10.2.0.3, windows |
7 |
3679 |
Mon, 04 February 2008 11:12 By: Kevin Meade ![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) |
|
select query taking long time By: varu123 on Sun, 03 February 2008 |
25 |
7221 |
Mon, 04 February 2008 04:53 By: varu123 ![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) |
|
patch 4589082 By: dirish on Mon, 04 February 2008 |
4 |
3650 |
Mon, 04 February 2008 03:08 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) |
|
Questions about measuring job execution time |
1 |
1428 |
Sun, 03 February 2008 20:13 By: kingming ![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) |
|
if RULE BASE exists in 11G |
3 |
2293 |
Fri, 01 February 2008 04:54 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) |
|
Newbie, help with ADDM finding By: hristo on Mon, 14 January 2008 |
7 |
15194 |
Thu, 31 January 2008 22:29 By: trantuananh24hg ![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) |
|
Materialized View issue Solaris, Oracle 10.2.0.2 |
1 |
1315 |
Thu, 31 January 2008 01:41 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) |
|
Only Select Query Running . Concurrency Problem Solaris, Oracle 10.2.0.2 |
3 |
2146 |
Wed, 30 January 2008 01:21 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) |
|
How to determine blocksize for new data warehouse? By: DrNeko on Tue, 29 January 2008 |
1 |
1691 |
Tue, 29 January 2008 20:16 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 is running long 10.2.0.2.0 , sun solris |
5 |
2177 |
Tue, 29 January 2008 08:37 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) |
|
about update perform By: zxx2403 on Mon, 28 January 2008 |
3 |
2081 |
Mon, 28 January 2008 19:56 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) |
|
Measurements |
3 |
1509 |
Sun, 27 January 2008 22:37 By: durgadas.menon ![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- slow running sql |
3 |
1830 |
Sun, 27 January 2008 08:05 By: KrishnaBoppana ![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) |
|
Rollback and trace/tkprof |
4 |
2042 |
Sat, 26 January 2008 09:05 By: psynaps3 ![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) |
|
Insert using DB Link (merged) |
9 |
10121 |
Fri, 25 January 2008 10:36 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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
Index hint inside the view is not working ORACLE 10g, AIX |
1 |
2091 |
Thu, 24 January 2008 00: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) |
|
Reproduce performance problem in test Oracle 9i |
2 |
1624 |
Wed, 23 January 2008 20:59 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) |
|
bitmap conversion in explain plan oracle 9.2 windows 2000 server By: agemaia on Wed, 23 January 2008 |
2 |
2377 |
Wed, 23 January 2008 20:35 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 Profiler tool Oracle 10g Linux for Java Application |
4 |
1629 |
Wed, 23 January 2008 02:31 By: amit_nanote ![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) |
|
Sparodic database slowness |
2 |
1362 |
Tue, 22 January 2008 10:16 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) |
|
how to specify priority of active sql sessions running in the database Oracle database 10 g,Windows 2000 professional |
1 |
1485 |
Tue, 22 January 2008 10:15 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) |
|
Performance issue |
8 |
2161 |
Tue, 22 January 2008 08:43 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) |
|
Concurrency wait. How I can resolve. Oracle 10.2.0.2, Solaris. |
5 |
31548 |
Tue, 22 January 2008 04:06 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) |
|
From Where should i want to start for tuning sqls |
1 |
1465 |
Tue, 22 January 2008 00:26 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) |
|
DBMS_STATS.gather_table_stats |
12 |
229942 |
Mon, 21 January 2008 20:53 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) |
|
Newbie: SQL runs slow on 10g, not on 9i By: hristo on Tue, 04 December 2007 |
31 |
7031 |
Sat, 19 January 2008 04:01 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) |
|
Delete data and transaction log problem |
10 |
2478 |
Fri, 18 January 2008 02:00 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) |
|
Query wih bind variables By: gkrishn on Wed, 16 January 2008 |
6 |
2008 |
Thu, 17 January 2008 05:00 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) |
|
SQL statement takes too long to run |
7 |
3918 |
Wed, 16 January 2008 21: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) |
|
last queries oracle 9i windows 2000 server sp4 By: agemaia on Wed, 16 January 2008 |
1 |
1447 |
Wed, 16 January 2008 20:56 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) |
|
index monitoring Oracle 9i windows 2000 server sp4 By: agemaia on Wed, 16 January 2008 |
2 |
1373 |
Wed, 16 January 2008 16:41 By: agemaia ![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) |
|
Update only 8 rows in a huge Table Oracle 10g Rel 2 |
7 |
2028 |
Wed, 16 January 2008 12:51 By: Kevin Meade ![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 tuning of SQL query oracle 9i |
1 |
1359 |
Wed, 16 January 2008 09:22 By: S.Rajaram ![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 oracle 9.2.0 , solaris 8 |
1 |
1332 |
Tue, 15 January 2008 21:45 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) |
|
Query slow Oracle 9i By: gkrishn on Tue, 15 January 2008 |
5 |
1617 |
Tue, 15 January 2008 16:47 By: gkrishn ![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) |
|
Newbie: Query uses index and runs slow By: hristo on Mon, 14 January 2008 |
4 |
1870 |
Mon, 14 January 2008 20:29 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) |
|
How get full data from table |
6 |
2504 |
Mon, 14 January 2008 05:05 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) |
|
sga_max_size: Oracle reserves all at ones? By: hristo on Mon, 14 January 2008 |
1 |
1941 |
Mon, 14 January 2008 03:41 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |