|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
UTLBSTAT UTLESTAT By: Alps on Fri, 22 December 2006 |
1 |
2181 |
Tue, 02 January 2007 06:31 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) |
|
Performance issue - Physical Reads / Buffer Gets - Statspack Report By: kumarsz on Tue, 19 December 2006 |
12 |
8618 |
Mon, 01 January 2007 14:36 By: kumarsz ![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) |
|
Tablespace for table with 1,000,000 rows |
6 |
3455 |
Mon, 01 January 2007 10:37 By: emilSverige ![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 Update Process By: yerics on Thu, 28 December 2006 |
4 |
2349 |
Sat, 30 December 2006 20:21 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) |
|
too many views |
4 |
2151 |
Thu, 28 December 2006 00:35 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) |
|
how to use dbms_system.set_sql_trace_in_session with 10046 level 12 By: kumarsz on Wed, 27 December 2006 |
2 |
6076 |
Wed, 27 December 2006 20:18 By: kumarsz ![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) |
|
TPC testing By: it_me24 on Wed, 27 December 2006 |
4 |
1965 |
Wed, 27 December 2006 11:36 By: it_me24 ![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) |
|
tkprof fetch count |
3 |
2618 |
Wed, 27 December 2006 05: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) |
|
does it cause any negative impact on performance |
2 |
2076 |
Wed, 27 December 2006 04: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) |
|
about sql tuning |
2 |
2302 |
Sat, 23 December 2006 10:02 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) |
|
Table Stats running |
2 |
2314 |
Fri, 22 December 2006 11:47 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) |
|
Oracle Database Slow |
1 |
2141 |
Fri, 22 December 2006 03:04 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) |
|
Avoiding FTS, Any better Way to write this |
3 |
2574 |
Thu, 21 December 2006 20: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) |
|
Which One is better... VARCHAR or Number |
3 |
1742 |
Wed, 20 December 2006 07:09 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) |
|
High activity of "delete from smon_scn_time" in statspack report |
1 |
5199 |
Wed, 20 December 2006 06:14 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) |
|
Process tuning |
35 |
5650 |
Tue, 19 December 2006 20:43 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) |
|
Introduce a good book for oracle performance tuning! |
2 |
1846 |
Tue, 19 December 2006 20:14 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) |
|
Help - Performance Issue - statspack report attached |
4 |
3083 |
Tue, 19 December 2006 02:52 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) |
|
how to handle this wait event: "control file sequential read"? |
1 |
2335 |
Mon, 18 December 2006 22:27 By: Mohammad Taj ![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 tuning |
1 |
1826 |
Mon, 18 December 2006 13:08 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) |
|
LATCH FREE - HIGH DURING MID NIGHT |
1 |
1926 |
Mon, 18 December 2006 12:12 By: dba_blr ![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) |
|
Post fast/complete refresh COMPILE_STATE=NEEDS_COMPILE |
0 |
6900 |
Mon, 18 December 2006 03:29 By: blazingrock4u ![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 is high |
4 |
2419 |
Mon, 18 December 2006 00:03 By: subhajit ![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 the speed of a MView Refresh |
1 |
1957 |
Sun, 17 December 2006 06:14 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) |
|
Shared Pool Advisory for Shared Pool Size |
3 |
6438 |
Sat, 16 December 2006 08:44 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) |
|
Trace Oracle Job Session using tkprof |
3 |
6552 |
Sat, 16 December 2006 08: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) |
|
Windows vs Linux |
1 |
1779 |
Fri, 15 December 2006 21:37 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) |
|
Looking for a guru By: rvgriff on Thu, 14 December 2006 |
5 |
5590 |
Thu, 14 December 2006 15:43 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) |
|
DBF files |
4 |
2179 |
Thu, 14 December 2006 05:45 By: kudur_kv ![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) |
|
session cached cursors |
2 |
6144 |
Thu, 14 December 2006 03:43 By: seema.taunk ![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 - Database growth monthwise |
5 |
5630 |
Wed, 13 December 2006 15:41 By: orasaket ![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 By: Alps on Tue, 12 December 2006 |
8 |
2665 |
Tue, 12 December 2006 12:48 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) |
|
Timed out trying to start process J002 massage |
1 |
10156 |
Tue, 12 December 2006 03:01 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) |
nothing in trace-file |
2 |
1992 |
Fri, 08 December 2006 23:27 By: Mohammad Taj ![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 tunning |
2 |
3343 |
Thu, 07 December 2006 16:19 By: Admin@Lightsql.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 tuning |
2 |
2218 |
Thu, 07 December 2006 04:59 By: ataufique ![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) |
|
Doubt on Oracle Post-Wait Extension in Semaphore allocation |
0 |
5740 |
Thu, 07 December 2006 00:22 By: girishta ![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) |
|
Alter Table parallel complexity By: rkl1 on Tue, 05 December 2006 |
2 |
7017 |
Wed, 06 December 2006 09:04 By: rkl1 ![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) |
|
more precise timing with TKPROF By: HibsMax on Tue, 05 December 2006 |
4 |
2495 |
Tue, 05 December 2006 15:48 By: HibsMax ![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) |
|
PGA_AGGREGATE_TARGET & SORT_AREA_SIZE |
2 |
8035 |
Tue, 05 December 2006 14:00 By: d0hboy ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |