|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
STATSPACK question on 10g and 8i |
2 |
2208 |
Tue, 22 August 2006 03:36 By: alexdabr ![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 execution plan depend on Client / Client-platform ? |
2 |
2078 |
Mon, 21 August 2006 03:39 By: power_logic@yahoo.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) |
|
DB size after Re-org |
3 |
2247 |
Mon, 21 August 2006 02:33 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) |
|
Creating Partitioned table faster than Non-partitioned |
1 |
2000 |
Sat, 19 August 2006 00: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) |
|
From staging tables to datamart table -- how? |
2 |
3419 |
Fri, 18 August 2006 03:50 By: a_developer ![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) |
|
Two questions about interviews |
3 |
1999 |
Thu, 17 August 2006 11:02 By: SQLAREA ![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) |
|
Estimating cache size By: Nau on Mon, 14 August 2006 |
3 |
6024 |
Thu, 17 August 2006 10:15 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) |
|
Inserting huge amount of data into Oracle database By: joelny on Wed, 06 April 2005 |
12 |
13083 |
Thu, 17 August 2006 08:14 By: vrsanaidu ![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) |
|
Staging table from partitioned table |
5 |
4585 |
Thu, 17 August 2006 07:17 By: a_developer ![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) |
|
Dictionary Managed to Locally Managed Tablespace |
14 |
3922 |
Wed, 16 August 2006 06:32 By: JSI2001 ![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) |
|
Analyze before insert - does it help |
1 |
1938 |
Tue, 15 August 2006 06:06 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) |
|
Need help on explain plan |
3 |
2346 |
Tue, 15 August 2006 03:40 By: orafaqer ![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) |
|
Enable Row Movement in Partitioning and Overhead |
1 |
8153 |
Mon, 14 August 2006 21: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 tune a select query which gives a result of 120 million rows? |
7 |
4237 |
Mon, 14 August 2006 15:49 By: Peter D. ![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) |
|
Compund index vs simple index By: Nau on Mon, 14 August 2006 |
1 |
1840 |
Mon, 14 August 2006 11:10 By: SQLAREA ![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) |
|
Increasing the SGA size |
6 |
3609 |
Sun, 13 August 2006 13:20 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 tuning By: gajini on Fri, 04 August 2006 |
6 |
2638 |
Fri, 11 August 2006 08:59 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 find a SQL query which is taking entire resources of an oracle database By: machis on Sat, 05 August 2006 |
3 |
3031 |
Fri, 11 August 2006 03:45 By: gbarbisan ![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) |
|
Releasing SYSTEM TABLE SPACE to USERDATA,INDEX By: manicm on Mon, 07 August 2006 |
5 |
2884 |
Wed, 09 August 2006 21:57 By: lzfhope ![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 hugh data from very big table |
3 |
6590 |
Wed, 09 August 2006 07:31 By: poratips ![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) |
|
Replication Issues with external tables |
1 |
1950 |
Tue, 08 August 2006 22:18 By: ebrian ![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) |
|
Indexing question |
8 |
2909 |
Mon, 07 August 2006 10:17 By: srinivas4u2 ![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 execution By: AlinaC on Wed, 26 July 2006 |
1 |
1854 |
Sat, 05 August 2006 21:06 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) |
|
Looking for optimizations for Oracle DB |
2 |
1905 |
Fri, 04 August 2006 09:17 By: dryloop ![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) |
|
Comparing Hints |
1 |
2099 |
Fri, 04 August 2006 00:58 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) |
how to reduce using virtual memeory |
3 |
2320 |
Thu, 03 August 2006 21:22 By: lzfhope ![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 parse count over db_link from 9i to 9i? |
3 |
2151 |
Thu, 03 August 2006 13:34 By: srinivas4u2 ![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 with output file using TKPROF - Oracle 9i Release 2 |
6 |
5683 |
Thu, 03 August 2006 13:30 By: Littlefoot ![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) |
|
Find Session with high cpu usage |
1 |
2580 |
Thu, 03 August 2006 02: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) |
|
Collecting Stats taking long to execute in PL/SQL code |
5 |
4810 |
Tue, 01 August 2006 16:16 By: wagnerch ![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) |
|
Is there enough SGA By: Brayan on Mon, 31 July 2006 |
1 |
2017 |
Mon, 31 July 2006 04:19 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) |
|
Dilemma on Loading and querying. By: rkl1 on Fri, 28 July 2006 |
1 |
1799 |
Fri, 28 July 2006 21:38 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) |
|
hints required |
9 |
4152 |
Fri, 28 July 2006 11:35 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) |
|
DBA_FREE_SPACE view in 10g taking more time |
1 |
3704 |
Fri, 28 July 2006 06:27 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) |
|
Getting queries |
1 |
1910 |
Fri, 28 July 2006 04:43 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) |
|
Help need .. Urgent |
3 |
1836 |
Fri, 28 July 2006 04:28 By: JSI2001 ![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 the CBO to recognize a FBI |
3 |
2604 |
Fri, 28 July 2006 02:59 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) |
|
Optimizing Hierachical query By: Aju on Mon, 19 June 2006 |
3 |
2480 |
Thu, 27 July 2006 07:07 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) |
|
Pl/sql procedure experience a high parse count using oracle 9i db-link. |
1 |
2028 |
Thu, 27 July 2006 06:54 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) |
|
what is BITMAP CONVERSION TO ROWIDS in Plan? |
2 |
24405 |
Thu, 27 July 2006 05:57 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |