Re: bitmap index not used

2003-10-29 Thread Tanel Poder
I'd recommend you to take a dump. A 10053 dump. And see from there. :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 10:09 PM Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has

RE: bitmap index not used

2003-10-29 Thread Khedr, Waleed
Probably the histogram is deciding that. Remove the histogram and see if there is any changes. Waleed -Original Message- Sent: Wednesday, October 29, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has 7131413

10046 trace data question

2003-10-29 Thread Jamadagni, Rajendra
Title: 10046 trace data question Does anyone know where tim= comes from? Is it from a certain epoch? e.g. PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5 tim=1042250821743271 hv=1053795750 ad='1eed99f0' COMMIT END OF STMT PARSE

RE: 10046 trace data question

2003-10-29 Thread Khedr, Waleed
Title: 10046 trace data question I believe it's from v$timer This view lists the elapsed time in hundredths of seconds. Time is measured since the beginning of the epoch, which is operating system specific, and wraps around to 0 again whenever the value overflows four bytes (roughly 497

RE: Re[3]: SQL and PL/SQL tuning template document required urgen

2003-10-29 Thread DENNIS WILLIAMS
Jonathan Thanks for replying. I tend to agree with you, I never found the user level ratings to be useful. You've probably assessed Cary's book more than anyone besides Cary himself. How much experience with Oracle do you feel a person should have before we recommend this book to them? I

Re: 10046 trace data question--addendum

2003-10-29 Thread Paul Baumgartel
That's in 9i...in 8i it was centiseconds. --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Does anyone know where tim= comes from? Is it from a certain epoch? e.g. PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5 tim=1042250821743271 hv=1053795750 ad='1eed99f0' COMMIT END OF STMT

Re: 10046 trace data question

2003-10-29 Thread Paul Baumgartel
I believe that it's microseconds since the Unix epoch (1/1/1970 00:00:00 UTC). --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Does anyone know where tim= comes from? Is it from a certain epoch? e.g. PARSING IN CURSOR #15 len=6 dep=2 uid=5 oct=44 lid=5 tim=1042250821743271 hv=1053795750

RE: 10046 trace data question

2003-10-29 Thread Tim Fleury
Title: Message Refer to page 133 and 134 of Cary Millsap's book, Optimizing Oracle Performance. For his research server it is the number of elapsed microseconds since the Unix Epoch (00:00:00 UTC,1 January 1970). -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL

Removing NUMGROUP from lexer in ConTerMedText index

2003-10-29 Thread Jesse, Rich
Hey all, I've setup a Context/Intermedia/Text/whateverTheHell index on 8.1.7.4 on HP/UX to index about 25 description fields in order for our users to search on them. This was two years ago, and now someone has discovered at least one issue. One description contains something like:

RE: 10046 trace data question

2003-10-29 Thread Cary Millsap
Title: 10046 trace data question In release 8, its V$TIMER.HSECS. In release 9, it varies by platform. Its the unadulterated value of gettimeofday() on our Linux server. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis101: 10/28

RE: ORA-4031 error help.

2003-10-29 Thread Michael Milligan
It may have to do with an object not being able to load into SGA because of not enough contiguous memory in the SGA. It happens in MTS environments. Try pinning your larger objects. -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 12:39 PM To: Multiple

RE: sqlplus prompt question in 9i

2003-10-29 Thread Joan Hsieh
Guang, You don't need to do it manually, you just type what it prompt you, it will connect to database without any problem. It had problem in crontab batch job only. Joan Quoting Guang Mei [EMAIL PROTECTED]: Joan: Thanks for the reply. This would work if dbstart is called when starting

RE: 10046 trace data question

2003-10-29 Thread Henry Poras
Title: Message But if that is true, shouldn't we all have about the same values (assuming the OS time is set up correctly)? tim in my trace files are really different from this value. Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tim

Re[5]: SQL and PL/SQL tuning template document required urgen

2003-10-29 Thread Jonathan Gennick
Wednesday, October 29, 2003, 5:29:25 PM, you wrote: DWYou've probably assessed Cary's book more than anyone besides Cary DW himself. How much experience with Oracle do you feel a person should have DW before we recommend this book to them? I'd recommend it to anyone. I tend to recommend

Running DBMS_STATS causes ORA-3113 error on 9.2.0.3 Solaris 64-bit

2003-10-29 Thread laura pena
We are having issues running dbms_stats.gather_table_stats. We get and ORA-3113 error message . The following can be found in the ALERT file: Errors in file /oracle/admin/VLDB/udump/vldbn1_ora_21486.trc:ORA-07445: exception encountered: core dump [000100E81374] [SIGSEGV] [Address not mapped to

<    1   2