|
|
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 |
1685 |
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 |
1627 |
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 |
1577 |
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 |
1739 |
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 |
18832 |
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 |
1863 |
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 |
1830 |
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 |
1740 |
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 |
1705 |
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 |
2530 |
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 |
2004 |
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 |
3659 |
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 |
2215 |
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 |
1868 |
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 |
1996 |
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 |
1917 |
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 |
2323 |
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 |
3249 |
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 |
2144 |
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 |
1837 |
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 |
1996 |
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 |
2234 |
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 |
1576 |
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 |
1868 |
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 |
3067 |
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 |
3300 |
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 |
2965 |
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 |
2516 |
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 |
5604 |
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 |
1625 |
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 |
1932 |
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 |
4028 |
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 |
2408 |
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 |
1785 |
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 |
1998 |
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 |
1936 |
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 |
2692 |
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 |
2719 |
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 |
2000 |
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 |
1634 |
Thu, 12 February 2004 09:59 By: Thiru ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |