|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
urgent help required |
2 |
1665 |
Thu, 18 March 2004 00:27 By: IA ![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) |
|
Tips |
2 |
1609 |
Tue, 16 March 2004 10:34 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) |
|
Tuning Issue Urgent By: ora on Sun, 14 March 2004 |
1 |
1556 |
Mon, 15 March 2004 10:54 By: ABC ![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 schema vs. public schema By: Avi on Sun, 14 March 2004 |
1 |
1714 |
Mon, 15 March 2004 03:20 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) |
|
Oralce Error ORA-04031: unable to allocate 4608 bytes of shared memory ("large pool","unknown object |
6 |
18812 |
Thu, 11 March 2004 21:33 By: jitendra ![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) |
|
utlbstat, utlestat By: Sam on Wed, 10 March 2004 |
2 |
1839 |
Thu, 11 March 2004 00:01 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) |
|
is tuning necessary or not. |
1 |
1808 |
Wed, 10 March 2004 23: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) |
|
LOG_BUFFER - Selects? |
2 |
1711 |
Tue, 09 March 2004 22:38 By: bhavin shah ![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) |
|
Covering Index - Execution plan |
2 |
1683 |
Tue, 09 March 2004 22:01 By: Patrick Tahiri ![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) |
|
9i Performance on NT4 By: deni on Thu, 04 March 2004 |
3 |
2506 |
Sat, 06 March 2004 03:18 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) |
|
create index on date fields |
3 |
1979 |
Thu, 04 March 2004 02:02 By: santosh ![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) |
|
SYSTEM STATISTICS in Distributed Enviornment By: Prasad on Mon, 23 February 2004 |
5 |
3629 |
Wed, 03 March 2004 08:29 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) |
|
redo logs size ? |
1 |
2189 |
Tue, 02 March 2004 04:06 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) |
|
Sort_Area_Size By: shesha on Mon, 01 March 2004 |
1 |
1849 |
Tue, 02 March 2004 03:23 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) |
|
How to trace Application Activity? |
1 |
1976 |
Tue, 02 March 2004 03:12 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) |
|
Why Don Burleson's "get_busy.ksh" does'nt work? |
3 |
1888 |
Mon, 01 March 2004 02: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) |
|
Query Results not coming second time |
6 |
2302 |
Mon, 01 March 2004 02:31 By: kamal matta ![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 do i read new messages in cursor By: Vinod on Sun, 29 February 2004 |
0 |
3204 |
Sun, 29 February 2004 23:22 By: Vinod ![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) |
|
Limiting the number of hits to 1 with rownum. |
4 |
2122 |
Sun, 29 February 2004 22:13 By: Patrick Tahiri ![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) |
|
Stored Procedure - Bind Variables - Performance |
3 |
1812 |
Sun, 29 February 2004 22:12 By: Patrick Tahiri ![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 9i optimizer By: NDU on Mon, 23 February 2004 |
3 |
1976 |
Sun, 29 February 2004 03:53 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) |
|
automate spurge.sql job By: Tjan on Fri, 27 February 2004 |
1 |
2211 |
Sat, 28 February 2004 23:24 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) |
|
optimizing query - taking way too long to run |
1 |
1553 |
Thu, 26 February 2004 03:18 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 hit ratio reduces to -3 |
3 |
1848 |
Tue, 24 February 2004 22:57 By: kamal matta ![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*Net Message from client |
2 |
3043 |
Mon, 23 February 2004 08:50 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) |
|
Very slow wildcard query By: Rohan on Thu, 19 February 2004 |
4 |
3273 |
Mon, 23 February 2004 04:58 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) |
|
cost based optimizer By: ora on Fri, 20 February 2004 |
2 |
2943 |
Fri, 20 February 2004 22:21 By: Manish Thawani ![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 - Which is the best? |
6 |
2492 |
Fri, 20 February 2004 09: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) |
|
SYSTEM STATISTICS By: Prasad on Wed, 18 February 2004 |
3 |
5579 |
Fri, 20 February 2004 06:42 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) |
|
Locking Table By: Qavi on Wed, 18 February 2004 |
1 |
1599 |
Thu, 19 February 2004 07: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) |
|
Index Performance - autotrace on explain |
3 |
1900 |
Thu, 19 February 2004 03:29 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) |
|
ora-0313 and XML By: agnes on Wed, 18 February 2004 |
0 |
4004 |
Wed, 18 February 2004 19:34 By: agnes ![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 create "stats$tab_stats" ? |
2 |
2384 |
Wed, 18 February 2004 15:46 By: Tian Maohuai ![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) |
|
Expensive Hardware, not much faster! By: justin on Mon, 16 February 2004 |
2 |
1759 |
Wed, 18 February 2004 04:17 By: justin ![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 9i tuning self test wanted By: lavanya on Tue, 17 February 2004 |
1 |
1955 |
Wed, 18 February 2004 03:54 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) |
|
Oracle 7 does not use index properly By: flo on Sun, 15 February 2004 |
2 |
1908 |
Tue, 17 February 2004 08:34 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) |
|
Oracle 9i Performance Doubts By: Prasad on Tue, 17 February 2004 |
1 |
2650 |
Tue, 17 February 2004 05: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) |
|
Performance Problem / Query Problem |
0 |
2692 |
Sun, 15 February 2004 18:43 By: kothari Alpesh ![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) |
|
number of stmts executed against an oracle instance By: Mo on Thu, 12 February 2004 |
1 |
1978 |
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 |
1610 |
Thu, 12 February 2004 09:59 By: Thiru ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |