|
|
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 |
1668 |
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 |
1613 |
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 |
1561 |
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 |
1720 |
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 |
18815 |
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 |
1844 |
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 |
1814 |
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 |
1717 |
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 |
1688 |
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 |
2511 |
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 |
1985 |
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 |
3637 |
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 |
2197 |
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 |
1854 |
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 |
1982 |
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 |
1894 |
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 |
2306 |
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 |
3210 |
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 |
2127 |
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 |
1817 |
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 |
1982 |
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 |
2216 |
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 |
1561 |
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 |
1855 |
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 |
3048 |
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 |
3280 |
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 |
2949 |
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 |
2500 |
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 |
5583 |
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 |
1604 |
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 |
1907 |
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 |
4010 |
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 |
2392 |
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 |
1763 |
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 |
1964 |
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 |
1911 |
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 |
2655 |
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 |
2700 |
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 |
1984 |
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 |
1618 |
Thu, 12 February 2004 09:59 By: Thiru ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |