Hi
In solaris use "prtconf" command
In HPUX
Use the following script to determine the clock speed:
HPUX=/stand/vmunix # 10.x
C=`echo itick_per_tick/D | adb $HPUX /dev/kmem | tail -1 \
| awk '{print $2/1}'`
echo "Clock speed of `hostname` is: $C Mhz."
- Original Message -
To:
Very impressive! I will definitly try this.
Thanks Again,
Jake
On Tue, Oct 21, 2003 at 06:44:25PM -0800, Larry Elkins wrote:
> Stephane,
>
> Pretty slick trick!!! But I can't believe that you, of all people, didn't
> throw in an analytic just to confuse things even more, plus, avoid that
> seco
Ryan,
Your two questions have different answers.
I studied mathematics as an undergrad. I focused on the abstract stuff:
predicate calculus, language theory, functional analysis, topology,
In my studies I constructed many, Many, MANY proofs. (A "proof" in
mathematics is a piece of technical
Yes, I understand BBW, and how PCTFREE affects
block density, and hence BBW. My point, which you appear to have missed, is
PCTUSED does not affect block density which is determined by PCTFREE.
Lets take a simple case of 10% PCTFREE, and 40%
PCTUSED. Blocks will fill up to 90% _no matter_
Hello,
I am attempting to convert the CLOBs in an existing table into ORDDOCs in a new table.
I _seemed_ to be almost there. I allocated a new ORDDOC using INIT(), and used
writeToSource() on the doc pointer to transfer the text (which I first converted to
RAW). The application that accepts thi
Stephane,
Pretty slick trick!!! But I can't believe that you, of all people, didn't
throw in an analytic just to confuse things even more, plus, avoid that
second pass on sliced_kipling ;-)
SQL> l
1 select translate(ltrim(text, '/'), '/', ' ') verse
2 from (select text, row_number() over (p
have they added the ability to rename tablespaces? this way you can publish
data easier?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 9:39 PM
> Hi Listers
>
> Saw this on SearchOracle
> What new features are customers
People here are bound by non-disclosure agreements, even if they've seen 10g,
which most of us have not. Don't despair, I know a guy who can help you.
His name is Tom Kyte and he can be contacted at http://asktom.oracle.com.
Tell him that Mladen sent you and everything will be OK.
On 2003.10.21 21
Hi Craig,
Yup. The application was written in Java using JDBC. Could you kindly email
me the tool you mentioned? At this point, I could not figure out the cause
of ora-1000.
Thanks!
elain
From: Craig Munday <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE
Hi Listers
Saw this on SearchOracle
What new features are customers excited about in 10G?
Abramson: What they've done is given you complete flexibility. They have
introduced transportable table spaces, so all you have to do is export
metadata and just copy files across during an upgrade. You do
--
The contents of this post are my opinions only
If swallowed seek medical advice
> -Original Message-
> From: Muqthar Ahmed [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 22 October 2003 06:44
> To: Multiple recipients of list ORACLE-L
>
what is your math background? what level of math would you recommend
performance specialists to have?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 3:49 PM
> Michael, I've responded by preceding your questions with "MM:
here is a list of tuning books to read. I used to work with the guy who
wrote it. He definitely knows what he is doing. There are quite a few people
on this list who can attest to that.
http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/re
f=cm_lm_dp_l_2/102-3468524-1000163
Title: RE: Cache a table
Mladen,
John Beresniewicz did some test (last one I know of in 2000 with Oracle 8.0) with diffent values of
_db_aging_cool_count
_db_aging_freeze_cr
_db_aging_hot_criteria
_db_aging_stay_count
_db_aging_touch_time
_db_percent_hot_default
_db_percent_hot_keep
_db_perc
I bet you can get that 4 minutes down to 1 if you dispense with the
down/up/down and just do checkpoint/abort/failover/startup.
Why bother with "immediate" for a cluster failover? Isn't it just a
waste of time?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 21 Oct 2003, Tortorelli
I'm seeing my posts
end up in the "Your new book" and other threads multiple times. I want to assure
you I am not sending them multiple times. Since I don't see other messages
duplicated, I have to assume that there is some problem with my company's SMTP
server. I'll refrain from sending any
Cary,
Thank you for your in-depth response. It was very helpful. To me, the
hardest books to read and understand are those that tell you WHAT but not
WHY. From the excellent reviews I've received (look at MLaden's review just
posted), it appears to give plenty of WHY. I appreciate that very much.
Thank you Dennis. I will take a look at that sample chapter, then probably
go out and pick up the book.
Thanks again.
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader
Cary, I believe that I'm more then entitled to a commission.
On 10/21/2003 06:04:26 PM, Michael Milligan wrote:
Cary,
Thank you for your in-depth response. It was very helpful. To me, the
hardest books to read and understand are those that tell you WHAT but
not
WHY. From the excellent reviews I've
Hi:
I found that a query worked quite well on Oracle 8173 is running very slow
on Oracle 9i.
I doubled check init paramters and they are the same. The table involved
has about 20M rows. The tables has been analyzed in both cases. Is there
any thing I should look or set in 9i so that query can run
Good idea. I located the meaning of TIM column (time to "age" buffer).
BTW, did I tell you that I like your signature?
On 10/21/2003 05:39:25 PM, Pete Sharman wrote:
Have a look at Steve Adam's web site. He probably knows more about
it
than
just about anyone else I know (as usual!)
Pete
"Contro
Title: Message
Just to add to Alex's point below, John Beresniewicz wrote a paper
some time ago (about two or three years) that effectively explains the
different buffer pools, and provides test results of the mid-point
insertion algorithms:
http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2
http://www.oracle.com/ip/deploy/database/oracle9i/index.html?Std_One.html
___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
http://www.oracle.com/ip/deploy/database/oracle9i/index.html?Std_One.html
___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
Hi Again,
What I do when a model is going to change is try to make it as flexible as
possible from the start. Build more abstraction into the model than you
normally would. Normalization is even more important here, even going to 4th
or 5th form, or at least Boyce-Codd 3rd. You want to design it s
MLaden,
Thank you very, very much for a great review. I hope you'll post that to
Amazon. As a matter of fact, I enjoy queuing theory. I remember almost
buying a book called "Practical Queuing Analysis" by Mike Tanner.
I was a biology major in college, so I may muddle through the math, but
it'll b
Thank you.it works.
Muqthar
DBA
-Original Message-
Sent: Tuesday, October 21, 2003 5:05 PM
To: Multiple recipients of list ORACLE-L
SELECT blah, blah, blah...
FROM (SELECT blah, blah, blah..., ROWNUM r
FROM
WHERE ...)
WHERE r = 2;
N
Sorry to double post. It didn't show up on the board and after about an hour
I thought there was a problem. Of course as soon as I posted again, they
both showed up! I'll be more patient next time.
Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-98
Cary,
I don't mean to ask you to brag, but can you please tell me if your new
book, of which I've heard good things, is different in any way than other
Oracle Performance Tuning books out. Does it take a different approach? Does
it
teach different methodologies? Is it more readable? I'd be very in
Title: RE: Cache a table
Sure, Wolfgang. Thank you for the correction.
Alex.
-Original Message-
From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 21, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Cache a table
I suppose you mean "2%
Cary,
Thank you for your in-depth response. It was very helpful. To me, the
hardest books to read and understand are those that tell you WHAT but not
WHY. From the excellent reviews I've received (look at MLaden's review just
posted), it appears to give plenty of WHY. I appreciate that very much.
I suppose you mean "2% of db_block_buffers"
At 03:34 PM 10/21/2003, you wrote:
John,Tom,
There is a difference between pools {DEFAULT vs. KEEP and RECYCLE}.
By default only DEFAULT pool use "mid-point" insert. It is controlled by
hidden parameters
_db_percent_hot_default (Percent of default buf
Oh my, that *is* convoluted. :)
Stephane Faroult <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/21/2003 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Can I conca
Hi Muqthar,
have a look at the ROWNUM functionality. This may be
able to help you.
Regards,
Mark
--- Muqthar Ahmed <[EMAIL PROTECTED]>
wrote: > Hi,
>
> Is there a way to pull ONLY 2nd row from the
> selected rows.
>
> Thanks
> Muqthar Ahmed
> DBA
> --
> Please see the official ORACLE-L FAQ
Have a look at Steve Adam's web site. He probably knows more about it than
just about anyone else I know (as usual!)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-O
Title: RE: Cache a table
John,Tom,
There is a difference between pools {DEFAULT vs. KEEP and RECYCLE}.
By default only DEFAULT pool use "mid-point" insert. It is controlled by hidden parameters
_db_percent_hot_default (Percent of default buffer pool considered hot) default 50
_db_percent_hot
BTW, a good text to really understand the "touch counts" is found
here:
http://cslibrary.stanford.edu/105/LinkedListProblems.pdf
It's not oracle specific, but gives you a hint how do things work.
On 10/21/2003 05:14:28 PM, Mladen Gogala wrote:
Did anyone try to benchmark the touch count based alg
Did anyone try to benchmark the touch count based algorithm against
the old LRU list? LRU list had advantage of being intuitive, while
touch count algorithm is depending on many parameters for which I
don't exactly understand the impact. LRU list parameters were
essentially defining the desired
SELECT blah, blah, blah...
FROM (SELECT blah, blah, blah..., ROWNUM r
FROM
WHERE ...)
WHERE r = 2;
No guarantees, that you will be always getting the same row (depending
on in-line query).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Me
Jake Johnson wrote:
>
> The following query returns 33 records.
>
> SYS0 freestyle!! 12-MAY-02
> SYSTEM5 freestyle!! 12-MAY-02
> OUTLN11 freestyle!! 12-MAY-02
>
>
> But, I would like to have all 33 records appended together to have one long record.
>
> SYS0 freestyle!! 12-MAY-02SYSTEM5 fre
Use an inline query.
select column1, column2
from (select rownum as i_rownum, column1, column2
from tableA)
where i_rownum = 2;
Daniel Fink
Muqthar Ahmed wrote:
> Hi,
>
> Is there a way to pull ONLY 2nd row from the selected rows.
>
> Thanks
> Muqthar Ahmed
> DBA
> --
> Please see the
No, the most complete and detailed queueing theory thing I've ever done
is Chapter 9 of the book. You might be thinking of "Batch Queue
Management and the Magic of '2'", which is a completely different thing.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performa
Thanks for correction.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Tim Gorman
Sent: Tuesday, October 21, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
The switch being referred to occurred with 8i, where Oracle
went to the "touch-count" algorithm. See
"http://www
Hi,
Is there a way to pull ONLY 2nd row from the selected rows.
Thanks
Muqthar Ahmed
DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Muqthar Ahmed
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Before Oracle 8 and the new touch count algorithm the cache attribute made
sense. If a small, frequently used table was read by a full scan, it would
have been put at the end of the LRU chain eligible to be aged out
immediately, quite possibly by itself if it consisted of more than ~
db_file_mu
We do
disaster recovery testing twice per year.
The
test includes all production systems. The unix guys are sent to another
city, where the unix boxes are, to do their stuff and the dba to another
location : no fight this way ;-)
Stephane Paquette
Administrateur
de bases de d
The switch being referred to occurred with 8i, where Oracle
went to the "touch-count" algorithm. See
"http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=papers_main
" for paper #136.
I guess "most frequently used" is a good way to describe it
-- nice choice of words!
> Tom,
>
> I think you are c
I was fortunate to attend the Hotsos Clinic and read the advance version. It is
not your normal tuning book. If you are looking for checklists, hand holding,
"do x to solve y" solutions, don't bother with the book. If you are looking for
a book to teach you the skills to solve your performance prob
Tom,
I think you are correct, if we are talking about Oracle 9, where oracle
switched from "most recently used" to "most frequently used" algorithm.
But, prior to that, it seems possible to think of scenarios, where
"cache" would be helpful. May be, that's one of the reasons, why oracle
changed
I think so! :-)
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/21/2003 3:04 PM
Is it (review) as good as Mladen's? -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Freeman Robert - IL
Sent: Tuesday, October 21, 2003 2:54 PM
To: Multiple r
go to asktom.oracle.com and search for stragg.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
*
Humm, what purpose would that serve? How would that be useful? My
perception is a row of data is independently referenced and if you
concat n rows into one string... the data would no longer be referenced
individually.
No doubt someone on this list can give you a solution, but Im sure it
would nee
there is a queuing theory article on hotsos. you have to be a member to read it...
does it have more detail than what is in your book?
unfortunately i havent had a chance to read it yet. Ill get to it. Everyone I know who
has read it, really liked it.
>
> From: "Cary Millsap" <[EMAIL PROTEC
Is it (review) as good as Mladen's? -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Freeman Robert - IL
Sent: Tuesday, October 21, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Well I got the honor of being the first to publish a review on Amazon
for
Cary's book..
We are approximately 1/3 of The 7% Solution... (an old Sherlock Holmes movie
detailing his cocaine addiction)
-Original Message-
Sent: Tuesday, October 21, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
What a horrible problem it must be, if we are solution?
On 10/20/2003 05:39:3
Well I got the honor of being the first to publish a review on Amazon for
Cary's book it is a good read!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/21/2003 2:24 PM
I'll try to correct spelling errors before I post it to the Amazon,
but I will do it, d
Michael, I've responded by preceding your questions with "MM:" and my
answers with "CVM:".
MM: ...can you please tell me if your new book, of which I've heard good
things, is different in any way than other Oracle Performance Tuning
books out. Does it take a different approach?
CVM: Drastically
poor
bastard. you'll spend hours and hours developing a document nobody really
wants, nobody will read, and (hopefully) you will never use.
if I
were you, I'd start lobbying for an outside agency to write it for you.
sure, you'd have to work with them. but they would get it done faster,
I'll try to correct spelling errors before I post it to the Amazon,
but I will do it, despite the fact that I'm not very fond of Amazon.
On 10/21/2003 03:09:32 PM, Michael Milligan wrote:
MLaden,
Thank you very, very much for a great review. I hope you'll post that
to
Amazon. As a matter of fact,
MLaden,
Thank you very, very much for a great review. I hope you'll post that to
Amazon. As a matter of fact, I enjoy queuing theory. I remember almost
buying a book called "Practical Queuing Analysis" by Mike Tanner.
I was a biology major in college, so I may muddle through the math, but
it'll b
I always wondered why Oracle thought this was a useful table attribute.
My gut feeling is that it is an extra that does little.
For example, say we want to keep a code table in memory because it is
constantly being hit for column verifiction. By definition, if a table is
constantly being queried
Hi,
All our DB have an 8k block size (8172/aix).
Even the reporting/dss database where data is accessed mainly by full scan.
Can we quantify the gain in % of switching from an 8k to 16k block size from
a performance point of view ?
Stephane Paquette
Administrateur de bases de donnees
Database
Hi Again,
What I do when a model is going to change is try to make it as flexible as
possible from the start. Build more abstraction into the model than you
normally would. Normalization is even more important here, even going to 4th
or 5th form, or at least Boyce-Codd 3rd. You want to design it s
Thank you all for all the help/suggestion/links and information about data modelling.
Regards
B S Pradhan
---
On Tue, 21 Oct 2003 [EMAIL PROTECTED] wrote :
>ive been told 'data modelling for mere mortals' is a good place to start.
> >
> > From: "bhabani s pradhan" <[EMAIL PROTE
My understanding is that the KEEP and RECYCLE Pools are just 'names' in the
sense that they are placeholders for assigning an object to the BUFFER_POOL
{ KEEP | RECYCLE | DEFAULT } clause, and that the 'aging' algorithms for
KEEP and RECYCLE are exactly the same. Assigning a specific object to one
Hey Michael
I enjoyed your write-up.. especially a few db guys telling 'its relational because
they are related'... I have also heard about it and the fact is that SQL the language
for all the RDBMA is based on relational algebra and relational calcus and there in
maths a rwo-column structure
The following query returns 33 records.
SYS0 freestyle!! 12-MAY-02
SYSTEM5 freestyle!! 12-MAY-02
OUTLN11 freestyle!! 12-MAY-02
But, I would like to have all 33 records appended together to have one long record.
SYS0 freestyle!! 12-MAY-02SYSTEM5 freestyle!! 12-MAY-02OUTLN11 freestyle!!
1
Thank you Dennis. I will take a look at that sample chapter, then probably
go out and pick up the book.
Thanks again.
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader
I'm not Cary but a satisfied reader who read the book in a
very detailed way and probably caused some headache to Cary.
Allow me, nevertheless, to respond to your question.
Cary's book IS different because it does not cover the classical
approach to tuning and explaining in detail all well known an
Arup,
Thanks for your reply. We don't have a metalink account. Could you please
send the note to me? My puzzle is that it seems the lock was acquired since
all of records were inserted into the table. How did the error come from
commit command?
Dave
From: "Arup Nanda" <[EMAIL PROTECTED]>
Well we use SQR too ... but it smells of COBOL and BASIC ... plus its use (maybe
it is us) of gloal variables stinks.
Somehow I never liked it, whatever reports I wrote in my development days, I wrote a
pl/sql package to do processign and then use SQR to retrieve from temp table and print
Damed Duhvelopers! *-)
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, October 21, 2003 2:19 PM
To: Multiple recipients of list ORACLE-L
Dick,
Thanks for your reply. Unfortunately, the loader's log file was overwritten
before our developer call
Sorry to double post. It didn't show up on the board and after about an hour
I thought there was a problem. Of course as soon as I posted again, they
both showed up! I'll be more patient next time.
Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-98
Michael
Oh yeah, this book takes a revolutionary approach compared to any other
book written to this point. The first chapter is posted at
http://www.oreilly.com/catalog/optoraclep/index.html
read this and you will see that this book is an entirely new method of
locating the root cause of Oracle
Dick,
Thanks for your reply. Unfortunately, the loader's log file was overwritten
before our developer called me since she tried to rerun the job.
Dave
From: "Goulet, Dick" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE:
Hi Guys ,
I have been recently tasked to write up
procedures and steps / documentation for disaster recovery of db/system
.
Any help , pointers ,links related to this is
highly appreciated .
Thanks,
-ak
OCP DBA 8i
If your on Oracle 8.1.x or above also check doc id 1018919.102.
Distributed_lock_timeout has become a hidden or more properly a deprecated parameter.
Namely change the default at your own risk.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, Oct
Here is the script you requested.
Rem
Rem $Header: utlrp.sql 15-nov-2001.10:56:31 rburns Exp $
Rem
Rem utlrp.sql
Rem
Rem Copyright (c) 1998, 2001, Oracle Corporation. All rights reserved.
Rem
RemNAME
Rem utlrp.sql - UTiLity script Recompile invalid Pl/sql modules
Rem
RemDESCRIPTION
Re
Raj,
What's wrong with SQR? I used it for a few years and found it great.
Especially for batch processing (both report writing and batch updating).
We chose it when we ran away from Cobol about 9 years ago. At the time, our
choices were Oracle Rpt (can you say RPG?), the very first version of Or
Here's a weird
idea to consider: You might replicate to a dummy table XYZ, then rename
CT_PRODUCTIED_VW to CRAP; then rename XYZ to CT_PRODUCTIED_VW. Then rename
CRAP to XYZ. If there are any dependent stored procedures, you will
probably be required to recompile them. But, if the depende
I would suggest the $ORACLE_HOME/rdbms/admin/utlrp.sql script, which
recompiles any invalid objects, or the $ORACLE_HOME/rdbms/admin/utlirp.sql
script, which will invalidate and recompile objects for you.
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL PROTECTED
An 8.1.7.4 production database on HP-UX 11.0 running Apps 11.5.7 takes long to
shutdown and is causing cluster failover testing to time out.
Upon shutdown immediate it takes 1-3 minutes for the DATABASE DISMOUNTED, DATABASE
CLOSED, and Archival stopped messages in the alert log but then it takes
We looked at SQR in 1994. We chose Perl instead, it was much
more flexible. The fact that Perl was free didn't have anything to
do with the decision.
Perl was just much more capable for data processing and reporting.
Jared
"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PRO
Cary,
I don't mean to ask you to brag, but can you please tell me if your new
book, of which I've heard good things, is different in any way than other
Oracle Performance Tuning books out. Does it take a different approach? Does
it
teach different methodologies? Is it more readable? I'd be very in
connect / as sysdba
@?/rdbms/admin/utlrp
> -Original Message-
>
>
> Hi,
> Can someone send all object compilation script?
> Thx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-
As someone has pointed out to me, latch contention is a consumer
of CPU. If you are familiar with Oracle's process of spinning on a
latch, you will realize that while waiting for a latch, the CPU will 'spin',
rather than go to the expense of doing a context switch and moving
on to something els
Seema,
SQL*Plus script "gen_recompile.sql" at
"http://www.EvDBT.com/tools.htm";. It's the eighth one in
the list...
-Tim
> Hi,
> Can someone send all object compilation script?
> Thx
> -Seema
>
> __
> ___ Enjoy MSN 8 patented spam con
Hi,
Can someone send all object compilation script?
Thx
-Seema
_
Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet
Service. Try it FREE for one month! http://join.msn.com/?page=dept/dialup
--
Please see the of
On Win2K the easiest way to hack your way back into the
database is to log on as local administrator then run
orapwd utility to re-create the password file (change
working directory to ORACLE_HOME/bin then type orapwd
and you'll see the full syntax).
New password file should be created in such
You can do it on Win2K, if your Win account is a member of ORA_DBA
group.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Rama, Shreekantha (K.)
Sent: Tuesday, October 21, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L
No ! this is is on Windows 2000..
Warm Regards
Unfortunately there *IS* (or maybe was) a bug (1967363) that caused
contention for the root block of indexes. Since the root block always
hashes to the same latch it's pretty easy to get contention on that one
latch. It's also pretty easy to get with badly fragmented DMTs when
checking for table
Cary,
I don't mean to ask you to brag, but can you please tell me if your new
book, of which I've heard good things, is different in any way than other
Oracle Performance Tuning books out. Does it take a different approach? Does
it
teach different methodologies? Is it more readable? I'd be very in
It works if you precede it with
SET ORACLE_SID=yourinstancename
(Windoz uses registry settings, not environmental variables)
and run sqlplus from the command line (not the GUI).
Also, the Oracle owner is the ADMINISTRATOR userid (at least on my boxes).
Of course, your milage may vary.
All that is nice, but from my practice so far, by far the most
frequent cause of the buffer busy waits id DBWR being unable to catch
up. This can come as a consequence of several things:
- Poorly written transaction that modifies thousands of blocks during
peak time hours. Typical example is bill
Dave,
If memory is functioning normally: When you use direct=y in Sql*Loader it
flags all of your indexes as invalid and then revalidates/rebuilds then when the load
is complete. The reason is that loading data is faster when you don't have to parse
index entries all the time and an i
David,
Take a look at Note 19332.1, which explains the error and what to do next.
In short, the essence of the note is: The error comes if the time waited is
mor than the value of the distributed_lock_timeout parameter. Even if you do
a select from the remote database, it acquires a TX lock and t
I believe Oracle will round that block size off. What I would not be sure of is what
Oracle did during database creation. I believe it should have gone with an 8K (8192
bytes) block size since the specified size of 4608 Bytes is above a 4K (4096 Bytes)
block size.
Dick Goulet
Senior Oracle DB
Oops, I didn't see that part. Thanks for the catch, Hemant.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- SQL Optimization 101: 12/8-12 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.c
why one can't do same on widoz as well ?
works well .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 8:44 AM
> is this a Unix box?
>
> if so, log on as the oracle account to the Unix server. Then in
> sqlplus
I would read some of C.J. Date's papers, or books from his "Relational
Database Writings" series. Also, there is a recent book called "Data
Modeling for Everyone" by Sharon Allen (Curlingstone Press) which is good.
Most importantly, understand the fundamental principles of relational theory
as it
1 - 100 of 163 matches
Mail list logo