|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Why did I not use the index? Windows XP, Oracle 10.2.0.2 Release |
4 |
1866 |
Sun, 16 March 2008 21:09 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) |
|
sqlplus: query takes too much time sqlplus:oracle database By: viko on Fri, 14 March 2008 |
4 |
3777 |
Sun, 16 March 2008 20:20 By: gamyers ![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) |
|
Doubt regarding ORA-30036: unable to extend segment by 8 in undo tablespace |
0 |
8916 |
Sun, 16 March 2008 06:11 By: rolex.mp ![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 - Stored Outline Oracle 9i R2 on RHEL |
4 |
3320 |
Fri, 14 March 2008 12:25 By: OraKaran ![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) |
|
Waits During Inserts . |
2 |
1816 |
Thu, 13 March 2008 13:52 By: faiz_hyd ![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 get recordcount & elapsed time without get result set while run proc in sql*plus? oracle 9.2.0.1.0 |
3 |
2804 |
Thu, 13 March 2008 01:11 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) |
|
AWR report |
0 |
6249 |
Wed, 12 March 2008 16:14 By: balaji1482 ![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) |
|
package not completing |
3 |
1258 |
Wed, 12 March 2008 15:28 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) |
|
need help! how to intercept sql command of update Oracle 10g xe, Windows xp |
4 |
3394 |
Wed, 12 March 2008 06:49 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 takes too much time 10.1.0.5.0/HPUX |
3 |
1467 |
Tue, 11 March 2008 21:58 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) |
|
Statspack |
11 |
2232 |
Tue, 11 March 2008 03:28 By: JRowbottom ![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) |
|
IMPROVE PERFORMANCE WHEN INSERT RECORDS |
2 |
1491 |
Tue, 11 March 2008 01:42 By: curlybird ![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 in explain plan |
3 |
1422 |
Mon, 10 March 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) |
|
AWR Report or ADDM Report? Oracle 10g - 10.2.0.3.0 on RHEL 64 bit |
1 |
10449 |
Mon, 10 March 2008 12:47 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) |
|
Tunning required Oracle 9.2.0.7.0 |
5 |
1572 |
Mon, 10 March 2008 06:39 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) |
|
optimized search for max() function |
2 |
1498 |
Mon, 10 March 2008 06:36 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 Metrics for Capacity Planning Oracle 10G and 9i |
1 |
1624 |
Mon, 10 March 2008 05:31 By: Frank Naude ![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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Impact of NLS Sort Oracle10g, UNIX |
1 |
2841 |
Thu, 06 March 2008 08:52 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Reclaiming free space questions Oracle g10 |
6 |
1989 |
Thu, 06 March 2008 07:22 By: hd999 ![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 Suggestion |
3 |
1747 |
Thu, 06 March 2008 06:37 By: hd999 ![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 oracle 10g,windows |
2 |
2120 |
Wed, 05 March 2008 09:20 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) |
|
query hangs on order by |
4 |
2135 |
Wed, 05 March 2008 01:25 By: dhananjay ![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) |
|
Single operation slows down a query Oracle9i, 9.2.0.6.0, Win 2003 |
4 |
1627 |
Tue, 04 March 2008 23:25 By: irremediable ![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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Can you fix this query? oracle 10g By: zim327 on Mon, 03 March 2008 |
5 |
2487 |
Tue, 04 March 2008 20:50 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) |
|
Sizing tablespaces |
26 |
8138 |
Tue, 04 March 2008 13:39 By: lotusdeva ![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 |
2 |
1273 |
Fri, 29 February 2008 21: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) |
|
SQL statement in the SGA Oracle 10g , Linux AS4 |
4 |
1435 |
Fri, 29 February 2008 11:20 By: rsreddy28 ![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 Database Stop working By: MIFI on Thu, 21 February 2008 |
13 |
6039 |
Fri, 29 February 2008 08:19 By: MIFI ![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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
drop partition slow Oracle 9.2.0.6.0 with Partitioning option - Solaris 9 By: jzt9sf on Wed, 27 February 2008 |
7 |
9889 |
Fri, 29 February 2008 07: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) |
|
:x ORA-01920: user name 'PERFSTAT' conflicts with another user or role name :x oracle 10.2.0.3.0 DB running on Vista ultimate By: racman on Thu, 28 February 2008 |
3 |
15353 |
Fri, 29 February 2008 07:53 By: racman ![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) |
|
Seperate datafiles for tables in Same schema Oracle 10g on Linux By: MIFI on Fri, 29 February 2008 |
3 |
1432 |
Fri, 29 February 2008 06:33 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) |
|
Tunning SQL Query |
1 |
1339 |
Fri, 29 February 2008 06:04 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) |
![icon13.gif](/forum/images/message_icons/icon13.gif) |
slow pc startup after 10g By: alzuma on Mon, 25 February 2008 |
3 |
1497 |
Fri, 29 February 2008 00:10 By: racman ![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 Oracle 10g,Unix |
8 |
3053 |
Thu, 28 February 2008 21:08 By: ravi214u ![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) |
|
trace-strange case |
3 |
1317 |
Thu, 28 February 2008 12:38 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) |
|
Index rebuild issue oracle 9i,linux By: tannad on Thu, 28 February 2008 |
4 |
1435 |
Thu, 28 February 2008 06:23 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 performance |
8 |
2931 |
Thu, 28 February 2008 03:09 By: MarcS ![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) |
|
Rebuild all the indexes of schema |
7 |
6508 |
Wed, 27 February 2008 21:09 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) |
|
>>>Wired SQL Tuning issue, maybe Oracle's bug<<<< ORACLE XE, 10G, Solaris, Windows By: elawcn on Wed, 27 February 2008 |
1 |
1326 |
Wed, 27 February 2008 20:55 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) |
|
Execution time differences between Devl and Test Oracle 10g/Windows2000 |
3 |
1526 |
Tue, 26 February 2008 16:56 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |