Hi Larry,
I think that the answer is that the statistics are of no use to the CBO until an
index is created.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 2 February 2001 11:16
To: Multiple recipients
Hi Casey,
Look at the USED_UBLK field in V$TRANSACTION, twice.
If the number is going down, then the transaction is rolling back.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 7 February 2001 0:00
Hi Gopal,
That was 8.1.5.
I have not tried it again since.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 7 February 2001 16:56
To: Multiple recipients of list ORACLE-L
Gautam !
If my memory serves
and used the CF enqueue lock, it will release it.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 8 February 2001 4:21
To: Multiple recipients of list ORACLE-L
Hi Steve,
I still couldn't figure out why we have
me if I can
delete it?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve Adams
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hi Kevin,
Try the ideal_cache_size.sql script at
http://www.ixora.com.au/scripts/cache.htm#ideal_cache_size on the Ixora web
site.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 9 February 2001 1:32
Hi Arun,
Which URL were you using?
I've just checked, and this one still appears to work ...
http://openworld.oracle.com/oowdba-wwwprd-apps/plsql/oow_user.show_public?p_even
t=3p_type=search
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au
ds the end of
the segment and then round up the highest interested transaction slot count that
you see to a prime number, and take that as the number of freelists to use.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: T
by the where clause predicates.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Tuesday, 13 February 2001 3:31
To: Multiple recipients of list ORACLE-L
Hi all,
Could someone attempt to explain the difference
Hi Paul,
Is there a difference in the 'no buffer to keep pinned count' statistic in
V$MYSTAT?
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Tuesday, 13 February 2001 8:41
To: Multiple recipients of list ORACLE-L
s directly, so that the X lock in the library cache
will not be needed any more. However, I suspect that the locking order for the
snapshot refresh is a bug too. Let's see what Oracle say ...
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Origin
Hi Larry,
Assuming that your 'control_file_record_keep_time' parameter is defaulting to 7
days, this suggests that you are archiving a log file every 9 seconds
consistently! If that's right, you would do well to use much bigger log files.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au
of additional 'consistent gets' is not much less than that.
This suggests that there is an extra consistent get for each fetch,
unless the previous fetch finished at a database block boundary.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au
-
De: Steve Adams [SMTP:[EMAIL PROTECTED]]
Enviado el: lunes 12 de febrero de 2001 18:31
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Reality check on freelists
Hi Russell,
No, the number of freelist is best made prime, whereas the number of
transaction
slots
Hi Yong,
That has to be FOR UPDATE SKIP LOCKED.
There is some stuff about it on the Ixora web site.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 15 February 2001 2:31
To: Multiple recipients of list
of LGWR from null commits or rollbacks.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 15 February 2001 4:37
To: Multiple recipients of list ORACLE-L
I'm using transactions, with a delete followed
Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 15 February 2001 4:27
To: Multiple recipients of list ORACLE-L
Have you personally done this in your test database (and may be in your
production database)?
Are
contiguously in a single semaphore set. That is why my book says, "If
the semaphore clients are not always shut down and started up in strict
sequence, then an extra allowance at least equal to the largest single
requirement is recommended."
@ Regards,
@ Steve Adams
@ http://www.ix
statistics.
...
This
book covers the kernel services for waits, latches, locks, and
memory.
@ Regards,@ Steve
Adams@ http://www.ixora.com.au/@ http://www.christianity.net.au/
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Friday, 16 February 2001
1:56To
reasonable storage
parameter to put into 'sql.bsq', then the two scripts on this page will help
you: http://www.ixora.com.au/scripts/dd.htm
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 16 February 2001 3:07
5% of this list want to see my "marketing",
if you can call it that, then I'm sure that even fewer want to see his. By
adding us to his mailing list, he has shown disrespect for our privacy, our
liberty and the law.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@
a difficult time
getting Oracle support to listen to you!
Let us know if you find anything else interesting. Remember don't rely on the
default database order in which records are returned.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original
trouble- The Oracle8i snapshot problems are fixed
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve Adams
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
Hi Kevin,
High 'redo log space requests' are often caused by slow log switches.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Tuesday, 20 February 2001 2:22
To: Multiple recipients of list ORACLE-L
Hi all
Hi All,
Leslie Lamport's research papers are available at
ftp://ftp.digital.com/pub/DEC/SRC/researchreports/
The Ixora search engine has direct links to some of the more interesting ones.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au
Hi Kam,
The inability to limit the amount of memory available for file system buffers
used to be a problem under earlier versions of Solaris. At 2.6 and above just
make sure that 'priority_paging' is in use and all will be well (in this regard
at least).
@ Regards,
@ Steve Adams
@ http
t;
I have added a link for this book to the Resources page on the Ixora web site at
http://www.ixora.com.au/resources/index.htm. A more substantial review will have
to wait until my copy gets here.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
---
type# from sys.obj$ where name like '_';
NAMETYPE#
-- --
V 4
T 10
SQL
@ Regards,
@ Steve Adams
@ http://www.ix
Hi Murali,
There was a thread on this on Ixora Answers in January ...
http://www.ixora.com.au/q+a/0101/06105002.htm
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 23 February 2001 4:41
To: Multiple
Hi Russ,
Yes, a bounce will not achieve anything, and neither will a full table scan if
it is done in parallel or if 'delayed_logging_block_cleanouts' is TRUE (which is
the default at 7.3 and 8.0).
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au
anonymous and executable
pages from the other.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 March 2001 12:06
To: Multiple recipients of list ORACLE-L
Group,
being fairly new
Hi Steve,
I once got to work on an oil rig in the middle of Bass Strait.
The pay was based on how dangerous your work was, rather than the skill
required.
It is not often that being a DBA puts you at the bottom of the pay
scale!
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http
that it is effectively unchanged for disk I/O because of
the LVM logical track group size restriction.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, 23 March 2001 7:17
To: Multiple recipients
that do this sort of stuff.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 23 March 2001 11:46
To: Multiple recipients of list ORACLE-L
Dear Listers,
I've download a presentation talking about Calculating
as NOLOGGING. The undo is correspondingly trivial. However, if
there are indexes then you get lots of index redo (layer 10) and
corresponding undo.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Sunday, 25 March 2001
Hi Glenn,
Try 'log_file_usage.sql' at
http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Tuesday, 27 March 2001 5:51
To: Multiple recipients of list ORACLE
,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Tuesday, 27 March 2001 7:27
To: Steve Adams
Cc: Oracledba
As always your script was exactly what I was looking for. I am assuming
the
column sys.x_$kccle.lesiz is number of blocks
.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 30 March 2001 19:20
To: Multiple recipients of list ORACLE-L
Hi,
I want to find out what roles are currently enabled for users logged on. The
users are logging
Hi Danisment,
It is after each wait. Whether each wait corresponds to a single system call
depends on whether the file is multiplexed, and whether Oracle passes large
multiblock reads to the operating system in a single call on that platform.
@ Regards,
@ Steve Adams
@ http
difference in CPU usage.
I too remember being taught this back in version 6 days, and it is in the Gurry
and Corrigan "Oracle Performance Tuning" book (2nd edition, page 138) so there
may have been some validity to it in the past.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au
Hi All,
I'd say that there must be something badly wrong with the application if it
cannot cope with 1,500 concurrent users. I know of sites supporting more than 20
times that number of active users on a single server with consistent sub-second
response times.
@ Regards,
@ Steve Adams
to be able to make their Oracle stuff scale
much better than MetaLink does. Maybe its because of the performance consultant
they use. I understand that Oracle management politely declined an offer of help
from the same consultant.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au
with these but I would focus on the
others first. In general, the Anjo Kolk paper on "Oracle7 Wait Events and
Enqueues" is the best starting point for information about different enqueue
types. You can find it at http://www.evdbt.com/event.pdf
@ Regards,
@ Steve Adams
@ http://www.ix
Hi Steve,
I've not checked recently, but Guy Harrison used to have one on his web site.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 6 April 2001 1:52
To: Multiple recipients of list ORACLE-L
Hi,
When
. The fact that it has to do
a full scan each time you run it will probably make you use it selectively on
columns that are subject to literal predicates in expensive queries. In my
opinion, that's probably a good thing. Enjoy!
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au
to a
consistent state. Also, the read only open allows you to assess better which
recovery option you want to take without committing you to either.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 6 April 2001 8:32
.
Hope this help,
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Hi all,
I was just trying to figure out why in an outer join Oracle prefers to
access the table with the (+) first. I would have thought that the table
from
.
Hope this help,
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Hi all,
I was just trying to figure out why in an outer join Oracle prefers to
access the table with the (+) first. I would have thought that the table
from
s.kxfpdpnum != 999 and
p.addr = s.kxfpdpcpr and
p.inst_id = s.kxfpdpcin
order by
1, 2, 3, 4
/
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 11 April 2001 7:16
fi
elif [ "0$v1b" -lt "0$v2b" ] ; then
echo "$v1 is less than $v2"
else
echo "$v1 is greater than $v2"
fi
elif [ "0$v1a" -lt "0$v2a" ] ; then
echo "$v
Hi Raja,
Yes, IFS stand for the "Internal Field Separator".
It is a special shell variable in Bourne based shells.
See the sh(1) man page for more information about it.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Origin
Hi Raj,
These are I/O slaves. You get them by setting 'dbwr_io_slaves' and possibly
other similar parameters.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 12 April 2001 21:52
To: Multiple recipients
Hi All,
Further to that, it is necessary to use DBMS_SQL or native dynamic SQL for this
as PL/SQL does not support ALTER SYSTEM directly.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 18 April 2001 3
Hi Bhat,
The CREATE TABLE privilege probably needs to be granted directly.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
PS. Please don't copy "[EMAIL PROTECTED]" on questions to the list.
-Original Message-
Sent: Wednesday
obtained via roles.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 18 April 2001 21:16
To: Multiple recipients of list ORACLE-L
Hi Steve,
The account has DBA privilege and by using a direct DDL I am
. Otherwise, a simple
(aka B*-tree) index should be considered.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 19 April 2001 8:15
To: Multiple recipients of list ORACLE-L
I have (had) an index
er, a more helpful course of action is to look at X$KSQST to investigate
what type of enqueues those waits are coming from. There is a script called
"enqueue_stats.sql" at http://www.ixora.com.au/scripts/locks.htm on the Ixora
web site that might help.
@ Regards,
@ Steve Adams
@ htt
ful, but using it for a first-order layout rule is a mistake." This is
consistent with what I recommend in the series of tips on disk configuration on
the Ixora web site.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Messag
of dollars on a whole new bunch of hardware. Of course
we did the configuration properly the next time so that there would be no disk
or controller level contention between the backup threads.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original
not hear of KDE-DB (KDB) in
that environment, but it does not surprise me that they are using it. Telstra
employs about 10% of Australia's IT workforce and when lamenting the lack of
standards there we often used to say Telstra has at least one of everything!
@ Regards,
@ Steve Adams
@ http
Hi Ade and list,
This is folk lore.
Please see http://www.ixora.com.au/q+a/0103/27075321.htm for the explanation.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 25 April 2001 1:01
To: Multiple
that be probably help
somewhat.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 27 April 2001 1:51
To: Multiple recipients of list ORACLE-L
RDBMS: 8.1.6.2 OS: AIX 4.3.3
Our large (600G) insert-intensive (17Meg / min
in
buffer header order. For levels higher than 3, the buffers and blocks are dumped
in hash chain order.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 27 April 2001 8:07
To: Multiple recipients of list ORACLE-L
the 'sort_area_size' and thus avoid those writes entirely.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Saturday, 28 April 2001 1:15
To: Multiple recipients of list ORACLE-L
Hi List ,
I am in the middle of Major
in there,
the best thing for you to do would be to create private synonyms.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 3 May 2001 7:26
To: Multiple recipients of list ORACLE-L
Ross,
Is this OPS?
According
Hi there,
Have a look at http://www.ixora.com.au/newsletter/2001_03.htm#ideal for an 8i
alternative.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Monday, 7 May 2001 11:30
To: Multiple recipients of list ORACLE-L
;
COUNT(*)
--
1
SQL select parse_calls, version_count from v$sqlarea where sql_text = 'select
count(*) from t ';
PARSE_CALLS VERSION_COUNT
--- -
3 3
SQL
@ Regards,
@ Steve Adams
Hi Waleed,
I ran the test below under 8.1.6.0 on NT using SQL*Plus and I would have
expected the same results under 8.1.6.3 on Solaris.
Do you possibly have a small shared pool with very quick reuse?
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au
Hi Jacques,
It is not reliable if there is row migration.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 11 May 2001 3:07
To: Multiple recipients of list ORACLE-L
-Original Message-
From: Jared
the web for information on
Python's pickle module.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 11 May 2001 3:11
To: Multiple recipients of list ORACLE-L
Sometimes I really love the developers at Oracle
that the file numbers in X$BH were offset thus, as those in X$KCBFWAIT
are. But when I started using the
corrected script I got even more strange results and backed out the fix, but it
seems that I overlooked the 8.0
version. Sorry.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http
on that.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Saturday, 12 May 2001 0:26
To: Multiple recipients of list ORACLE-L
Can somebody please explain to me what this event is, I am not able to find
good documentation on this issue
hypothesis
however.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 16 May 2001 22:31
To: Multiple recipients of list ORACLE-L
Thanks for the reply Steve,
this event was not proping up before until we enabled
, and the DBWn processes in all
instance need to flush the cache in their own instances.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 17 May 2001 4:11
To: Multiple recipients of list ORACLE-L
Thanks
Hi Diego,
I don't know of any way in which using DBMS_PIPE might be related to CI enqueue
waits. However, even if there is something to their suggestion, if your ID
values are 0 and 5 then the CI call you are waiting for is one of the reuse
block range calls.
@ Regards,
@ Steve Adams
to the tip you mentioned. While it is
the sort of thing I might say, I don't remember actually having said so.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 18 May 2001 0:05
To: Multiple recipients of list ORACLE-L
have pushed you toward QIO in the
first place.
Johnson,
Could you please post the URL to the tip you mentioned so that I can fix it.
@ Thanks,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 18 May 2001 10:06
To: Multiple
Hi All,
Another correction. That error number has been changed to 7248 since Oracle8. I
think I need a coffee!
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 18 May 2001 10:01
To: Multiple recipients
about the major issues first.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 18 May 2001 2:01
To: Multiple recipients of list ORACLE-L
Hello Gurus,
I need help in this performance issue.
Oracle 7.3.4
HPUX
of the
discussion?
Johnson
--- Steve Adams [EMAIL PROTECTED] wrote:
Hi All,
OK, you're all correct. Tempfiles can be sparse (it
seems to be platform
specific). Nevertheless, I'm unclear why Veritas
think that is it any more of a
problem for Oracle to get ENOSPC from a sparse
tempfile
Hi Johnson,
No, that's a datafile tablespace with temporary contents. A tempfile tablespace
is inherently temporary. Check the documentation for the difference between ...
CREATE TABLESPACE ... TEMPORARY
and
CREATE TEMPORARY TABLESPACE ...
@ Regards,
@ Steve Adams
@ http
to anyone else, thus the bogus reply just to the
sender. What a clever way to kill a thread!
Maybe Jared should apply this technique to messages headed job offer from SAUDI
ARABIA. :-)
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original
Hi All,
The May 2001 issue of Ixora News is now available online at
http://www.ixora.com.au/newsletter/2001_05.htm.
In this issue ...
Sin-onyms - Are synonyms really bad?
Not so fast - Incremental checkpointing can defeat commit cleanouts
@ Regards,
@ Steve Adams
@ http
not participate in recovery in
anyway and thus do not need to be backed up.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Monday, 21 May 2001 11:15
To: Multiple recipients of list ORACLE-L
I am interested to know what
Hi Shreepad,
Please see http://www.ixora.com.au/q+a/cpu.htm#15_10_1999.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Tuesday, 22 May 2001 22:16
To: Multiple recipients of list ORACLE-L
Hi,
I wish to test
_db_percent_hot_default to something like
80. That would allow up to 80% of the DEFAULT buffer pool to be used for hot
buffers thereby improving the caching of the buffers that are causing you to
wait.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message
Hi All,
A cheaper solution to this is to use an AFTER LOGON trigger to set
CREATE_STORED_OUTLINES to true. If the users have the CREATE ANY OUTLINE system
privilege, you'll be able to see which indexes are being used in the
DBA_OUTLINE_HINTS view.
@ Regards,
@ Steve Adams
@ http
Hi All,
No, I'm waiting for Henry to announce the details of the commercial DBA union!
The pre-announcement is at http://www.lazydba.com/xcomment.pl?discussions:6
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
PS. This is a joke for the benefit
to
international copyright law, but individuals are seldom immune to community
disapprobation.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 8 June 2001 3:01
To: Multiple recipients of list ORACLE-L
I hate
,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 8 June 2001 7:59
To: Multiple recipients of list ORACLE-L
Google also stores the text of a lot of these .pdfs in cache. - E
-Original Message-
Sent: Thursday, June 07
Hi Bill,
The FOR UPDATE clause syntax allows for the possibility of column-level locking, but
Oracle only implements row-level
locking. So the OF column_name phrase is just ignored.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original
are right that it is searched linearly, my experience suggests that the
CPU saving of session cursor cache
hits can exceed the CPU cost of unlatched linear searches with values much larger than
100.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au
Hi there,
You can see deferred rollback segments in X$KTTVS or in DBA_SEGMENTS.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Thursday, 18 October 2001 16:55
To: Multiple recipients of list ORACLE-L
Hi, DBAs
robust code that handles the error. A good
example of such code can be seen
in '$ORACLE_HOME/rdbms/admin/recover.bsq'.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http://www.christianity.net.au
Hi Ed,
I would agree with the _kgl_latch_count change, but the _kgl_bucket_count change seems
unwarranted and extreme. Rather I
suspect that the size of your library cache hash table rather reflects an oversized
shared pool, probably with some use
of literal SQL.
@ Regards,
@ Steve Adams
*
ERROR at line 1:
ORA-00235: controlfile fixed table inconsistent due to concurrent update
SQL
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http
a week
would be good too if you can manage
that.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http://www.christianity.net.au/ - For all
-Original Message-
Sent: Friday, 19 October 2001 19
SQL /
select count(*) from v$loghist
*
ERROR at line 1:
ORA-00235: controlfile fixed table inconsistent due to concurrent update
SQL /
COUNT(*)
--
823
SQL
@ Regards,
@ Steve Adams
@ http
10% more expensive. My results were between 10%
and 30%.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http://www.christianity.net.au/ - For all
-Original Message-
Sent: Saturday, 20
also be used, and is somewhat more
useful. Be warned, however, that
I've seen it crash an instance once.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http://www.christianity.net.au/ - For all
1 - 100 of 128 matches
Mail list logo
