|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to rebuild index By: c_gajen on Thu, 29 September 2005 |
1 |
1403 |
Thu, 29 September 2005 09:35 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) |
|
Statspack By: pjose on Mon, 26 September 2005 |
2 |
1416 |
Thu, 29 September 2005 05:52 By: girish.rohini ![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 TRACE |
2 |
4405 |
Wed, 28 September 2005 14:39 By: nitin_228 ![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) |
|
RAC: "global cache cr request" events take 1 second ocasionally |
1 |
7978 |
Tue, 27 September 2005 11: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) |
|
Use PCTfree/Initran/Maxtran to prevent contention |
3 |
5259 |
Tue, 27 September 2005 11:46 By: smartin ![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) |
|
Poor Performance in Accessing Remote Database |
3 |
1576 |
Mon, 26 September 2005 06:57 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) |
|
Procedure tunning |
4 |
2293 |
Mon, 26 September 2005 01:57 By: sunil_v_mishra ![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) |
Solaris 9, 10g hard parse/soft parse what does it mean? |
1 |
3029 |
Sat, 24 September 2005 06:23 By: Art Metzer ![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 bigger blocksize for indexes help increasing performance and lower I/O |
3 |
1520 |
Fri, 23 September 2005 10:17 By: mjschwenger ![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 the sql by using explain plan By: balasmg on Thu, 22 September 2005 |
1 |
1869 |
Thu, 22 September 2005 11:05 By: Art Metzer ![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) |
|
"slave shutdown wait" - event |
1 |
1386 |
Wed, 21 September 2005 13:13 By: smartin ![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) |
|
Error while installing Statspack |
3 |
6859 |
Mon, 19 September 2005 11:58 By: oracledbanewbie ![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 increase search in the database |
2 |
1659 |
Mon, 19 September 2005 08:09 By: Art Metzer ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
The time of 1 Query is more than 1 hour, HELP ¡¡¡ By: IngRMP on Mon, 19 September 2005 |
1 |
1460 |
Mon, 19 September 2005 08:05 By: Art Metzer ![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) |
|
Difference in retrieving number of rows between two queries |
3 |
2371 |
Fri, 16 September 2005 04:12 By: sharan_it ![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 plan misleads me (merged cross-posts) By: randres on Thu, 15 September 2005 |
9 |
1775 |
Fri, 16 September 2005 02:28 By: randres ![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 out if a table has dirty blocks in buffers By: nile on Thu, 08 September 2005 |
23 |
8114 |
Fri, 16 September 2005 01:41 By: nile ![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) |
|
Oracle9i Function Base index? |
1 |
2333 |
Tue, 13 September 2005 16:00 By: smartin ![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) |
|
different performance results in Oracle9i vs. MSSQL Server 2000 |
2 |
1632 |
Mon, 12 September 2005 14:12 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Can I change the DB_BLOCK_SIZE in Oracle 9i? |
7 |
25229 |
Mon, 12 September 2005 14:07 By: merovingio ![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) |
|
Resolving "latch free" problems By: cubittm on Thu, 01 September 2005 |
1 |
35285 |
Mon, 12 September 2005 08:29 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) |
|
Function Index, is there a limit to the complexity ? |
1 |
1580 |
Fri, 09 September 2005 10:27 By: smartin ![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) |
|
error while taking snapshot..!! |
3 |
2331 |
Thu, 08 September 2005 11:57 By: rsone ![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 stop the Cache Effect ? |
21 |
3223 |
Wed, 07 September 2005 14:19 By: nile ![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 I can remove the table from cache? Which command I should execute By: lanag on Fri, 12 August 2005 |
4 |
1769 |
Tue, 06 September 2005 15:49 By: smartin ![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 ignored problem |
5 |
2011 |
Fri, 02 September 2005 14:29 By: mjschwenger ![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) |
|
Using Hint By: ynaiyer on Fri, 02 September 2005 |
2 |
1643 |
Fri, 02 September 2005 11:27 By: Art Metzer ![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) |
|
Multiple Tablespaces |
2 |
1589 |
Thu, 01 September 2005 09:56 By: smartin ![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) |
|
Union takes more time please help |
3 |
3400 |
Thu, 01 September 2005 09:48 By: smartin ![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 increase performance Delete statement |
5 |
5497 |
Thu, 01 September 2005 06:23 By: IngRMP ![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 with NVL By: hrishy on Wed, 24 August 2005 |
1 |
4618 |
Thu, 01 September 2005 03:59 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) |
performance tuning |
4 |
1907 |
Wed, 31 August 2005 16:15 By: ChrisJr ![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 use index in date column |
5 |
5823 |
Wed, 31 August 2005 09:16 By: d.dineshkumar ![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 issue with high volume table By: Nits on Mon, 29 August 2005 |
2 |
1546 |
Tue, 30 August 2005 09:23 By: Nits ![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) |
|
highly skewed data distribution |
5 |
2632 |
Mon, 29 August 2005 08:21 By: sebastianR ![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) |
|
clustering vs. reorganization |
0 |
2520 |
Mon, 29 August 2005 05:15 By: sebastianR ![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 DB server |
5 |
7949 |
Fri, 26 August 2005 08:18 By: manu_jariwala ![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) |
|
Optimizer=Choose Error |
0 |
2487 |
Fri, 26 August 2005 06:58 By: Scott Cowan ![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 test performance of table? and how to calucalate row size min and max of the Table |
2 |
1492 |
Thu, 25 August 2005 14:34 By: vjeedigunta ![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) |
|
tune the query |
2 |
2066 |
Thu, 25 August 2005 14:27 By: vjeedigunta ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |