|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
delete no of records |
14 |
3181 |
Wed, 04 August 2010 00:07 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 doesn't use Materialized View Oracle 10g |
1 |
1897 |
Tue, 03 August 2010 10:19 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) |
|
run explain plan syntax , show error window series |
4 |
7503 |
Tue, 03 August 2010 02:44 By: JADYCHEN ![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 with shared pool sizing 8.0.6, windows 2000 server By: ultgnp on Mon, 02 August 2010 |
10 |
2305 |
Mon, 02 August 2010 22:13 By: rahulvb ![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 Oracle 9i |
4 |
2344 |
Mon, 02 August 2010 00:46 By: rahulvb ![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 Oracle 9i |
5 |
2637 |
Sat, 31 July 2010 05:32 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) |
|
An observation Oracle 10.2.0.3 |
14 |
3400 |
Fri, 30 July 2010 22: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) |
|
Which application (software, utility) do I choose for report? Windows platform, Oracle 9,10,11 |
4 |
2167 |
Thu, 29 July 2010 03:25 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) |
|
Cost of a query Oracle 10.2.0.3 |
3 |
2498 |
Wed, 28 July 2010 10:30 By: Its_me_ved ![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 Schemas Oracle, 10.2.0.2.0 , unix |
1 |
1835 |
Tue, 27 July 2010 08:25 By: rahulvb ![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) |
|
REDO LOG GENERTION |
17 |
5163 |
Mon, 26 July 2010 02:59 By: hkchital ![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) |
|
low cost and high cpu cost |
17 |
7341 |
Sun, 25 July 2010 22:43 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) |
|
SETTING PARAMETER |
2 |
1943 |
Fri, 23 July 2010 12:33 By: prashant_ora ![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 hint |
8 |
3444 |
Fri, 23 July 2010 00: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) |
|
CPU used by user SQLs 11g RHEL 5 |
2 |
2084 |
Thu, 22 July 2010 15:03 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 on foreign keys |
17 |
3648 |
Thu, 22 July 2010 10:53 By: John Watson ![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 is taking more time for execution |
4 |
4188 |
Thu, 22 July 2010 10:15 By: prashant_ora ![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) |
|
reduce the elapsed time |
9 |
2344 |
Thu, 22 July 2010 08:25 By: prashant_ora ![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 |
4 |
2048 |
Thu, 22 July 2010 07:47 By: John Watson ![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) |
|
INVISIBLE INDEX-11g |
9 |
6155 |
Thu, 22 July 2010 05:27 By: akilabaskaran ![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 writing |
1 |
1493 |
Thu, 22 July 2010 05:09 By: cookiemonster ![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) |
|
Explain Plan Analysis - Execution ordering Oralce 11g, CentOS5 By: Vackar on Wed, 21 July 2010 |
15 |
6679 |
Thu, 22 July 2010 03:59 By: Vackar ![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) |
|
optimised query |
1 |
1527 |
Thu, 22 July 2010 03: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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
What is the use of DBM STATS PACKAGE? Oracle Database 10.2.0.1 on AIX 5.3 By: vcm643 on Wed, 21 July 2010 |
4 |
3038 |
Thu, 22 July 2010 03:16 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) |
|
Hint is not working properly 9.2.0.8, HP-UX |
14 |
3014 |
Thu, 22 July 2010 02:29 By: indrajit2002 ![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 cursor embedded in select Oracle 10, sqldeveloper 2.1.0.63 By: akj_dk on Wed, 21 July 2010 |
2 |
2014 |
Thu, 22 July 2010 01:50 By: akj_dk ![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 Optimization 11g |
13 |
4752 |
Tue, 20 July 2010 22: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) |
|
High CPU Cost and low optimizer cost Oracle 10G /Linux |
10 |
7428 |
Tue, 20 July 2010 04:28 By: kvelrajan@gmail.com ![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 server Tuning 11g |
8 |
3547 |
Mon, 19 July 2010 18:13 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) |
|
points to ponder while having Index against any column Oracle 10.X |
3 |
2435 |
Mon, 19 July 2010 01:10 By: hkchital ![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 Fragmentation script |
23 |
12889 |
Mon, 19 July 2010 00:58 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) |
|
TRACE SESSION USING DBMS_APPLICATION_INFO ORACLE 10G AND JAVA ON WEBLOGIC AND JBOSS |
11 |
6175 |
Sun, 18 July 2010 12:19 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) |
|
auto execute of job_error_ORA-12012,ORA-04031 oracle,10.2.0.4.0,Linux By: sathik on Tue, 13 July 2010 |
7 |
10794 |
Wed, 14 July 2010 01: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) |
|
Tools for Database Tuning v/s Instance Tuning Oracle 10g, 11g |
1 |
1524 |
Mon, 12 July 2010 20:54 By: rahulvb ![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 statment running for ever Oracle server 11g Enterprise Edition Release 11.1.0.7.0 - 64bit , Linux x86_64 GNU/Linux |
9 |
4482 |
Sun, 11 July 2010 00: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) |
|
Query Performance trace Oracle 10g, |
1 |
1679 |
Sat, 10 July 2010 11:54 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 Query Help Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi |
7 |
2782 |
Fri, 09 July 2010 01:44 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) |
|
parallel DDL oracle 10g |
3 |
2647 |
Thu, 08 July 2010 10:46 By: arunprasad_bh ![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) |
|
excess redo generation By: dalu on Thu, 01 July 2010 |
3 |
3226 |
Tue, 06 July 2010 21:55 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) |
|
Description of Events Windows Server 2003 |
2 |
2720 |
Tue, 06 July 2010 04:19 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |