|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Update statement query tuning 9i |
7 |
3456 |
Tue, 22 December 2009 01:49 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) |
|
Memory Notification: Library Cache Object loaded into SGA oracle 10g By: gir_sat on Mon, 21 December 2009 |
2 |
15311 |
Mon, 21 December 2009 08:02 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) |
|
Problem in understanding the autotrace output exectution plan and statistics 10.2.0.4, RHEL4 By: spabolu on Thu, 17 December 2009 |
3 |
2870 |
Sun, 20 December 2009 20:52 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 to configure Oracle on Two Servers in Hot Redundant mode Oracle 10g on Windows Server 2003 |
1 |
2326 |
Fri, 18 December 2009 09:09 By: LKBrwn_DBA ![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 tuning help oracle 10g,1,xp |
8 |
3041 |
Fri, 18 December 2009 05:39 By: _jum ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Why Oracle 10g slows down Copmuter after few days Oracle 10g 10.2.0.1.0 |
12 |
5417 |
Thu, 17 December 2009 15:34 By: myinvention99 ![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) |
|
Queries in oracle indexing oracle, 10.1.0.5.0, sun solaris By: sathik on Thu, 17 December 2009 |
4 |
2734 |
Thu, 17 December 2009 10:53 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) |
|
select clause 10g |
2 |
2108 |
Thu, 17 December 2009 00:34 By: pablolee ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
grants running extemely slow Oracle 10.2.0.3 on Linux By: king303 on Tue, 15 December 2009 |
9 |
3784 |
Wed, 16 December 2009 02:55 By: king303 ![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 of a Rollback Oracle 10.2.0.4, Windows 2003 server By: Arokh on Fri, 11 December 2009 |
3 |
1887 |
Fri, 11 December 2009 13:48 By: Arokh ![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 to be restructured for performance gain Oracle 10G |
2 |
2184 |
Fri, 11 December 2009 10:50 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) |
|
APPEND hint in Rule and Cost based optimizer oracle 10g |
5 |
3570 |
Thu, 10 December 2009 19: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) |
|
require to tune a sql query oracle,10.1.0.4.0,Sun solaris 5.10 By: sathik on Wed, 09 December 2009 |
10 |
4116 |
Thu, 10 December 2009 05:58 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) |
|
Index Partitioning local or global or both?? |
9 |
3704 |
Wed, 09 December 2009 06:00 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) |
|
Need to tune a Query - xjd |
6 |
3643 |
Wed, 09 December 2009 00: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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Unindexing foreign key Oracle 10.2G By: wakula on Tue, 08 December 2009 |
1 |
1781 |
Tue, 08 December 2009 06:37 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Horizontal vs Vertical data table design Oracle 10.2G By: wakula on Mon, 30 November 2009 |
6 |
5125 |
Tue, 08 December 2009 02:41 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) |
|
Buffer pool Hit% more than 100% oracle 10g, 10.2, soalaris |
13 |
4594 |
Tue, 08 December 2009 02:20 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) |
|
Performance issue while pl/sql script execution (merged 3) oracle 10.2.0.4 , Solaris sparc |
19 |
8445 |
Mon, 07 December 2009 09:26 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) |
|
retrieve deleted data of user_jobs Oracle 10g, By: spur230 on Sat, 07 November 2009 |
19 |
10276 |
Mon, 07 December 2009 08:32 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) |
|
can we write below query in a better way oracle10g By: chaituu on Fri, 04 December 2009 |
10 |
3894 |
Mon, 07 December 2009 02:52 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) |
|
How to calculate ideal size of log_buffer parameter? 10.2.0.4, sun spark 64 bit By: halim on Thu, 19 November 2009 |
10 |
9938 |
Mon, 07 December 2009 00:47 By: DBA_SangramKeshari ![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 via Crystal Reports and ODBC is very slow, same SQL with toad is fast Oracle Database 10g Enterprise Edition 10.2.0.1.0 |
6 |
10267 |
Thu, 03 December 2009 21:31 By: wvu1999 ![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 identify table need resequencing. 10.2.0.3.0 on xp |
4 |
3121 |
Thu, 03 December 2009 06:07 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) |
|
DBMS_OUTLINE to override HINTS [Merged] Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: spur230 on Fri, 20 November 2009 |
3 |
4652 |
Wed, 02 December 2009 07:20 By: LKBrwn_DBA ![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) |
|
Nologging Feature in Archivelog mode : strange Results Oracle 9.2.0.6.0 on HP-UX |
5 |
3348 |
Tue, 01 December 2009 08:56 By: chetanaZ ![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) |
|
After Version Enabled (Workspace Manager) Oracle 10g |
2 |
2467 |
Fri, 27 November 2009 00:38 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) |
|
Very high executions (Parse=Execute) Oracle 10g, Solaris 10 |
2 |
2812 |
Fri, 27 November 2009 00:37 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) |
|
Performance of a Query 11.5.10, 10g Database |
22 |
8551 |
Mon, 23 November 2009 10:09 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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
How to tune a update statement Oracle 10g, Solaris 10 |
9 |
5232 |
Mon, 23 November 2009 01:10 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) |
|
how to enable trace for other sessions? |
7 |
7389 |
Fri, 20 November 2009 04:47 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) |
|
query delay 10.2.0.3, Windows 2003 |
4 |
2839 |
Wed, 18 November 2009 22:20 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) |
|
ORA-00060 Deadlock issue with trigger 10.2.0.4.0, Linux |
9 |
10964 |
Tue, 17 November 2009 09:52 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) |
|
Profile Limits 10.2.0.4.0 - IBM AIX |
1 |
3542 |
Mon, 16 November 2009 23:11 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) |
|
.trc files |
2 |
1921 |
Mon, 16 November 2009 01:09 By: priyasinha396 ![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 CTAS uses unused space?? |
4 |
2457 |
Fri, 13 November 2009 17: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) |
|
User statistics Oracle 10.2.0.4 By: gkrishn on Mon, 09 November 2009 |
3 |
2987 |
Mon, 09 November 2009 07:07 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) |
|
to check for temporary space usage 10.2.0.4 |
9 |
5184 |
Mon, 09 November 2009 06:35 By: ramoradba ![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 10.2.0.4 IBM AIX 5.3 |
9 |
8023 |
Sat, 07 November 2009 10:09 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) |
|
SQL Tune Oracle 10g Database 10.2.0.4 + Oracle Client 9.2.0.1 By: babuknb on Fri, 06 November 2009 |
7 |
3883 |
Fri, 06 November 2009 08:16 By: babuknb ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |