not notice all of this unless you start doing
library cache dumps.
That is, the use of public synonyms is a major scalability threat, but
does not normally cause performance problems.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au
. So yes, package variables
and bind variable are there (although the bind meta-data is in the SGA) but
sort areas, row source buffers, and runtime state data are also major space
consumers.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http
was under way when the PGA heap dump was
taken.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
-Original Message-
Satav, Pawan
Sent: Tuesday, 11 November 2003 8:55 PM
To: Multiple recipients of list ORACLE-L
Good
, but there is no corresponding metadata in the dictionary cache.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
-Original Message-
Steve
Sent: Wednesday, 1 October 2003 12:49 AM
To: Multiple recipients of list ORACLE-L
Hi
is that the ADDR column of the X$ output now returns addresses which
map into your PGA rather than the SGA. In fact, that is in general a good
way to work out whether you are looking at an X$ table or an X$ interface.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
; others like these ones you've mentioned do not
need to, but some of them do so anyway.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve Adams
of chunks
and thus the relative size of these and other shared pool areas depends
entirely how recently objects have been used, because they all share the
same LRU mechanisms (although there is an additional subordinate LRU
mechanism for the dictionary cache).
@ Regards,
@ Steve Adams
@ http
can see chunks moving
from the transient to recurrent list. My best guess at the moment is that
when new recreatable chunks are first unpinned, they go onto the transient
list, and then when they have been reused, they go back onto the recurrent
list.
@ Regards,
@ Steve Adams
@ http
to be returned from the first row piece.
Although it is possible for that to be the case with row chaining, it's more
likely a symptom of migration.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
accept OwnerName prompt Owner
,
although it is in the V$ views, nor is it visible in the trace files because
the waiting session does not have a corresponding process that is waiting).
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
-Original Message
doubled
db_block_buffers, but unless going from about 600M to about 1.2G, then it was not a
level playing field. Unfortunately,
he does not give those numbers.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
Hi Andrea,
Don't do it! Adding commits makes the code more complex, much less efficient and risks
violating transactional
integrity. See http://www.ixora.com.au/newsletter/2001_09.htm#commits for a detailed
explanation of the problems.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au
Hi All,
Does anyone have an email address for Bert? I looked for his email address when I
first read that article a week ago,
but did not find one. I think I know what was wrong with his test, but it is hard to
be sure because he left out a lot
of the details.
@ Regards,
@ Steve Adams
hardware
diagnostic logs for evidence of
either memory or network errors, and make sure that you don't have someone trying to
use some old client software that
is not compatible with the RDBMS version.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http
that you scanned already
had a large number of block in the cache.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
-Original Message-
Sent: Friday, 2 November 2001 6:39
To: Steve Adams; Multiple recipients
of cache available for the archival writes. You would also do well to avoid
RAID-S of course!
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
-Original Message-
Sent: Thursday, 1 November 2001 5:45
.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all
-Original Message-
Sent: Thursday, 1 November 2001 10:10
To: Multiple recipients of list ORACLE-L
Greg,
I may be way off here but FIRST_ROWS
Hi Rahul,
Ah, I see. You're looking at KGLHDLMD instead of KGLHDPMD.
@ 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
Hi Nirmal,
There is some information about the X$ tables available on the Ixora web site.
However, knowledge of the X$ tables is not really important for most DBAs.
They are only useful in rare, advanced tuning and diagnostic situations.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au
Hi Tamas,
When a session is waiting for a row-level lock you can see the row required in the
V$SESSION columns ROW_WAIT_OBJ#,
ROW_WAIT_FILE#, ROW_WAIT_BLOCK# and ROW_WAIT_ROW#. A script like Oracle's utllockt.sql
can be used to identify the
blocker.
@ Regards,
@ Steve Adams
@ http
to another object.
@ 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: Monday, 29 October 2001 13:55
To: Multiple recipients
Hi Riyaj,
The checkpoint object call is used prior to a direct read of an object. DBW0 scans the
cache once based on the obj#.
This was introduced in 8.0 as an optimization for parallel query. Previously each
extent was checkpointed separately.
@ Regards,
@ Steve Adams
@ http
the sessions holding the pins. See
executing_packages.sql at
http://www.ixora.com.au/scripts/misc.htm#executing_packages for an example.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http
the sessions holding the pins. See
executing_packages.sql at
http://www.ixora.com.au/scripts/misc.htm#executing_packages for an example.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
@ http
Hi Rahul,
0 means not pinned; 3 means pinned in exclusive mode.
I don't know what 1 means. I'm not accustomed to seeing it.
Do you have any examples?
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.secularislam.org/call.htm - For Muslims
Hi Jack,
It is a background wait, so unless user processes are waiting for DBWn in 'free buffer
waits' or 'write complete waits'
then you don't have a problem, no matter how big the 'db file parallel wait' numbers
are.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au
Hi All,
Oracle uses direct I/O on W2K so the O/S block size is an irrelevance.
@ 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
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
Hi Saurabh,
Try running $ORACLE_HOME/rdbms/admin/catperf.sql first.
@ 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
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
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
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
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
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 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
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
_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 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
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
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 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
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
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
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
;
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 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
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
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
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
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
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
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
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
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
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 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
.
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
. 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
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
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 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
.
@ 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 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
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
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
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
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 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
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
1 - 100 of 128 matches
Mail list logo