|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
number of stmts executed against an oracle instance By: Mo on Thu, 12 February 2004 |
1 |
2823 |
Sat, 14 February 2004 03:52 By: Thiru ![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) |
|
10 % Hit Ratio By: Qavi on Mon, 09 February 2004 |
3 |
2371 |
Thu, 12 February 2004 09:59 By: Thiru ![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) |
|
Sample database for tuning tests |
1 |
4962 |
Wed, 11 February 2004 10:03 By: ilver ![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) |
|
local vs dictionary tablespaces By: Sam on Mon, 09 February 2004 |
2 |
2864 |
Wed, 11 February 2004 06:46 By: Thiru ![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) |
|
size of the tables By: Sam on Sun, 08 February 2004 |
1 |
2559 |
Mon, 09 February 2004 06:56 By: Thiru ![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) |
|
1oo Hit Ratio By: Qavi on Mon, 09 February 2004 |
1 |
2440 |
Mon, 09 February 2004 06:51 By: Thiru ![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) |
|
Re:Table of 1.4 gb size returns 0rows |
1 |
2417 |
Sun, 08 February 2004 03:23 By: Thiru ![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) |
|
Criteria for Initial Extents and Next Extents of Blank Table and Having Rows in above 8 Lakhs |
1 |
2446 |
Fri, 06 February 2004 04:15 By: Thiru ![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 By: PagInit on Wed, 28 January 2004 |
2 |
2630 |
Thu, 05 February 2004 09:29 By: Michel Bartov ![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 table and Index usage by CBO |
1 |
3257 |
Tue, 03 February 2004 15:28 By: Thiru ![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 Temp Tablespace allocation problem |
0 |
3894 |
Mon, 02 February 2004 21:37 By: Raju KVG ![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 solve latch Promble? |
3 |
3419 |
Mon, 02 February 2004 08:16 By: Thiru ![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 can I Improve Performance By: Shesh on Thu, 22 January 2004 |
2 |
2362 |
Fri, 30 January 2004 13:36 By: ilver ![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 |
2 |
3501 |
Fri, 30 January 2004 13:18 By: ilver ![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 improve performance ? By: Anil on Tue, 27 January 2004 |
1 |
2511 |
Fri, 30 January 2004 13:05 By: ilver ![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 long each commit took? By: Devyani on Wed, 28 January 2004 |
4 |
2332 |
Thu, 29 January 2004 08:01 By: Devyani ![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) |
|
control tracefiles for other sessions By: ilver on Mon, 26 January 2004 |
2 |
3433 |
Tue, 27 January 2004 07:02 By: Thiru ![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) |
|
splitting datafiles By: Mat on Mon, 26 January 2004 |
1 |
2639 |
Mon, 26 January 2004 05:20 By: Thiru ![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 max_processes? |
4 |
4304 |
Fri, 23 January 2004 13:03 By: Thiru ![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) |
|
This query is running forever - urgent help pls |
1 |
2371 |
Thu, 22 January 2004 20:51 By: Shesh ![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) |
|
Partitioned table, Merge Query By: panna on Thu, 22 January 2004 |
0 |
3415 |
Thu, 22 January 2004 01:56 By: panna ![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) |
|
Views |
4 |
3882 |
Wed, 21 January 2004 09:21 By: woodchuck ![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) |
|
purging of data By: jun on Thu, 15 January 2004 |
2 |
2493 |
Sat, 17 January 2004 06:43 By: Thiru ![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 force the sql query to use or not to use index |
1 |
2896 |
Sat, 17 January 2004 06:37 By: Thiru ![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 .... from and performance issues |
7 |
5154 |
Fri, 16 January 2004 11:30 By: andreyp ![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 between Joins By: Shesh on Sun, 11 January 2004 |
1 |
2468 |
Thu, 15 January 2004 11:16 By: Thiru ![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) |
|
Start SQL*PLUS or SQL WorkSheet with problems. |
4 |
3370 |
Wed, 14 January 2004 06:40 By: Rodrigo Almeida ![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) |
|
1z0-024 questions |
2 |
2797 |
Wed, 14 January 2004 01:50 By: Ananth K.T ![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) |
|
Reg Partition By: Raj on Sun, 11 January 2004 |
1 |
2462 |
Tue, 13 January 2004 14:40 By: Mike ![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) |
|
understanding execution plans |
3 |
2564 |
Fri, 09 January 2004 08:24 By: Thiru ![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) |
|
re: freespace in database(oracle8i) |
4 |
3159 |
Thu, 08 January 2004 21:20 By: jun g. ![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) |
|
partitioned tables By: Sam on Tue, 23 December 2003 |
2 |
2578 |
Wed, 07 January 2004 05:02 By: Mike ![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 By: Parag on Mon, 29 December 2003 |
9 |
4713 |
Tue, 06 January 2004 04:28 By: neil ![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) |
|
Statistics description |
1 |
2376 |
Mon, 05 January 2004 02:04 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) |
|
resources on tuning |
4 |
3290 |
Tue, 30 December 2003 23:55 By: GIRIDHAR KODAKALLA ![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 and explain plan By: Sam on Sun, 28 December 2003 |
3 |
3732 |
Mon, 29 December 2003 17:39 By: Sam ![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 |
1 |
2510 |
Mon, 29 December 2003 08:26 By: Thiru ![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) |
|
statistics |
3 |
3169 |
Mon, 29 December 2003 04:25 By: Thiru ![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) |
|
meaning of 'VW_NSO_1' |
1 |
4961 |
Mon, 22 December 2003 22:39 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) |
|
buffer cache holds objects not listed in dba_objects |
5 |
3711 |
Mon, 22 December 2003 19:52 By: S.Rajesh Kannan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |