|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
URGENT:-ORA-01555: snapshot too old: rollback segment number 17 with name "_SYSS |
5 |
17594 |
Fri, 03 December 2004 02:50 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) |
|
Performance By: Andre on Tue, 30 November 2004 |
0 |
2238 |
Tue, 30 November 2004 07:47 By: Andre ![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) |
|
Autotrace Taking a Long time By: Shikha on Tue, 30 November 2004 |
1 |
1753 |
Tue, 30 November 2004 03:55 By: Shikha ![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) |
|
Using Index By: Venkat on Mon, 29 November 2004 |
0 |
2037 |
Mon, 29 November 2004 19:23 By: Venkat ![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 Tuning |
5 |
2167 |
Mon, 29 November 2004 19:07 By: Venkat ![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) |
|
creating user / roles with maximum CPU percentage By: Uwe on Mon, 29 November 2004 |
0 |
2145 |
Mon, 29 November 2004 02:30 By: Uwe ![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) |
|
keep and recycle pools in oracle 9i By: Uday on Mon, 29 November 2004 |
0 |
2302 |
Mon, 29 November 2004 02:27 By: Uday ![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 data extraction from EXTERNAL TABLES |
5 |
4074 |
Sat, 27 November 2004 00:58 By: William Robertson ![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 version of tomcat is compatible with oracle 9i By: Vishal on Fri, 26 November 2004 |
0 |
2202 |
Fri, 26 November 2004 21:53 By: Vishal ![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) |
|
Pl Help To Tune Full table Scans. |
1 |
2216 |
Fri, 26 November 2004 03:45 By: Frank ![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) |
|
Interpretation Trace file By: Selva on Wed, 24 November 2004 |
1 |
2404 |
Thu, 25 November 2004 20:27 By: Frank ![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) |
|
PL/SQL commit |
6 |
3153 |
Thu, 25 November 2004 20:25 By: Frank ![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 help:-URGENT |
0 |
2589 |
Thu, 25 November 2004 19:04 By: Milind Deshpande ![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-0430 Error for SQL |
0 |
4742 |
Wed, 24 November 2004 23:58 By: Milind Deshpande ![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) |
|
interpreting SQL raw trace data By: jebasti on Fri, 01 October 2004 |
3 |
3107 |
Wed, 24 November 2004 22:40 By: jebasti ![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) |
|
Can I tune this . |
0 |
2315 |
Tue, 23 November 2004 19:11 By: BhavinShah ![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) |
|
Raw Chaining and Row Migration.Scenario : |
2 |
2309 |
Mon, 22 November 2004 22:20 By: BhavinShah ![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) |
|
Data insertion in LOBs cause table to Grow Rapidly |
0 |
2278 |
Mon, 22 November 2004 18:36 By: Dipankar Bhattacharya ![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) |
|
Protecting a Table from Truncated or Delete |
2 |
3265 |
Mon, 22 November 2004 08:07 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) |
|
Intial Extent parameter for Indexes |
2 |
2204 |
Sat, 20 November 2004 06:04 By: William Robertson ![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. ROW Chaining By: tanuj on Sat, 20 November 2004 |
1 |
1725 |
Sat, 20 November 2004 05:55 By: William Robertson ![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) |
|
Assigning intial value to CLOB . will this reduce Fragmentation? By: ragha on Wed, 17 November 2004 |
3 |
2383 |
Thu, 18 November 2004 20:22 By: Frank ![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) |
|
10046 - Unable to trace JDBC thin client |
1 |
3648 |
Wed, 17 November 2004 21:05 By: Frank ![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 storage |
2 |
1739 |
Wed, 17 November 2004 16:57 By: Milind Deshpande ![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 EVENT TRACE By: lily on Wed, 17 November 2004 |
0 |
2262 |
Wed, 17 November 2004 16:47 By: lily ![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 Queries Help Required Urgently Oracle 9i |
0 |
3142 |
Wed, 17 November 2004 09:45 By: Pratap Zope ![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 change the utl_file_dir initialization perameter in ORACLE 7.3 on unix |
6 |
8223 |
Tue, 16 November 2004 10:19 By: Amit ![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-27100: shared memory realm already exists |
1 |
5057 |
Fri, 12 November 2004 02:30 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) |
|
Tunning Timestamp field |
1 |
1785 |
Thu, 11 November 2004 02:08 By: Frank ![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) |
|
Slow performance of DBPLease help! By: Joy on Mon, 11 October 2004 |
1 |
2901 |
Wed, 10 November 2004 13:40 By: Pete Karanikas ![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) |
|
To find out the Stored Procedure name and the Full table scan By: Vijay on Tue, 09 November 2004 |
1 |
1700 |
Tue, 09 November 2004 23:37 By: Padders ![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 tuning a hierachical query having "or" conditions |
2 |
1730 |
Tue, 09 November 2004 20:00 By: dragon wang ![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) |
|
Coalesion on the tablespaces By: Abhijit on Tue, 09 November 2004 |
1 |
2128 |
Tue, 09 November 2004 02:36 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) |
|
Space allocation to TEMP LOB By: Hyma on Mon, 08 November 2004 |
1 |
1839 |
Mon, 08 November 2004 07:15 By: andrew again ![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 much LIO from single row table By: dejan on Wed, 03 November 2004 |
3 |
2128 |
Mon, 08 November 2004 04:04 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) |
|
PGA tuning - Oracle 9i By: Kenneth on Sun, 07 November 2004 |
0 |
2315 |
Sun, 07 November 2004 16:09 By: Kenneth ![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) |
|
database doesnt start |
1 |
2160 |
Sun, 07 November 2004 11:13 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) |
|
FND_STATS.GATHER_SCHEMA_STATISTICS By: Leonie on Thu, 04 November 2004 |
5 |
12816 |
Thu, 04 November 2004 04:24 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) |
|
8i Inserts + Updates SLOW ! By: saustin on Thu, 04 November 2004 |
1 |
1869 |
Thu, 04 November 2004 04:23 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) |
|
Gather Schema Stats fails on functional/bitmap index By: Leonie on Thu, 04 November 2004 |
0 |
2487 |
Thu, 04 November 2004 02:17 By: Leonie ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |