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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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
101 - 115 of 115 matches
Mail list logo