--- Paul Drake <[EMAIL PROTECTED]> wrote:
> --- Jacques Kilchoer <[EMAIL PROTECTED]>
> wrote:
> >
> > In what cases does the SERIAL# need to be used?
>
> orakill.
>
> sqlnet.expire_timeout did not work on NT for 8.1.7.
> garbage middle-tier apps that don't close
> connections
> require the use
Hi,
How can I know the PGA size which my session is
utilizing?
Thanks in advance.
Syed
Hi Jared,
haven't seen it, too. But the fact
was spreaded over the newsgroups.
We still have some 3rd party apps that don't use
*any* feature above Oracle 7 (well, almost). Queries with
the RULE hint where it's not necessary.
But if we change a thing, support will be lost.
So we decided to rewri
Yes Jared,
That is true.. I also saw note .. but never heard
of 10i.
The rule-based optimizer (RBO) will no longer be supported
when Oracle9i is de-supported. The release after Oracle9i (referred to
in this article as Oracle10i) will only support the cost-based
optimizer (CBO).
-
Hi,
http://www.dba-oracle.com/bp/bp_book6_utils.htm
The book by Dave Moore has explained lots of utilities and kgmgr is one of
them.
--- Jacques Kilchoer <[EMAIL PROTECTED]>
wrote:
>
> In what cases does the SERIAL# need to be used?
orakill.
sqlnet.expire_timeout did not work on NT for 8.1.7.
garbage middle-tier apps that don't close connections
require the use of orakill.
Pd
__
Do you Yahoo
Good evening dear sir from down under (It's 22:07, here in Connecticut).
Yes, it is safe to do. The only case when you do have to be careful is when
the table you want to take for a ride into another tablespace is an index
organized table and is being used. Then, you have to specify "online" opti
WE!? Do you also happen to work for Veritas? Wow!
Veritas then, already is a superpower and a major
force to be reckoned with. The only thing you need to do
to achieve the total Oracle World Domination is to...
acquire me :)
On 2003.10.06 21:59, Gaja Krishna Vaidyanatha wrote:
Mladen,
Anjo quit Or
Good morning, everyone,
> Env: Oracle 8.1.7.4, Sun 5.8
>
> We have a master table with a FREST REFRESH based on PRIMARY KEY. We would like to
> rebuild the master table, snapshot log and snapshot to reclaim space. There is no
> advanced replication involved. It is simply a snapshot (or material
Hi List,
I have been asked to look into the possibility of populating a BLOB column
(Oracle 8i currently) using an SQL Script. All the examples I've ever seen
involve reading the blob from a file and inserting it directly to the table
though.
The reasoning behind this is the desire to deliver a
Mladen,
Anjo quit Oracle and joined Precise Software in
November/December timeframe of 2001. When Veritas
acquired Precise this year, he became a "veritable
Veritas employee"...;-)
So your conclusion is 100% accurate - Veritas is a
very serious contender in the Oracle Performance
Solutions market
Hey dude,
Thanks for that, although, I don't want to be tagged
as a "spammer"...;-).
Cheers,
Gaja
--- [EMAIL PROTECTED] wrote:
> Our good friend Gaja Vaidyanatha is now with
> Veritas,
> so this isn't really too surprising. :)
>
> Jared
>
>
>
>
>
>
> David Wagoner <[EMAIL PROTECTED]>
>
Hi list I had done dbms_defer_sys.set_disabled('MASTER_SITE',TRUE); I just set it to FALSE and repeated the command and now the group is quiesced. Thx--- On Mon 10/06, quriyat < [EMAIL PROTECTED] > wrote:
From: quriyat [mailto: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Date: Mon, 06 Oct 2003 16:19:2
Hi list I had done dbms_defer_sys.set_disabled('MASTER_SITE',TRUE); I just set it to FALSE and repeated the command and now the group is quiesced. Thx--- On Mon 10/06, quriyat < [EMAIL PROTECTED] > wrote:
From: quriyat [mailto: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Date: Mon, 06 Oct 2003 16:19:2
9i has this functionality in dbms_storage_map
-Original Message-
Sent: Monday, October 06, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
Hi Everyone!
I recently read an article about a SQL-Server stored procedure called
'xp_fixeddrives'. What it does is return a structure to t
I didSQL> begin 2 DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY('MY_GRP'); 3 end; 4 /PL/SQL procedure successfully completed.
SQL> SELECT GNAME, STATUS FROM DBA_REPGROUP;GNAME STATUS-- -MY_GRPQUIESCINGSQL> /
It is one
Thank you John. I guess I can revise my question, then, to say "Why not use
SID/SERIAL# all the time?" :)
I suppose there are reasons but it seems unnecessary to have two sets of values that
uniquely identify a session. Though of course, from the documentation, AUDSID is
unique over the lifetime
Hi Everyone!
I recently read an article about a SQL-Server stored procedure called
'xp_fixeddrives'. What it does is return a structure to the database user
that contains relevant information about specific disks. I was wondering
if anyone has ever seen, dreamed about, written, borrowed, bough
Thanks, didn't know this was available.
Ora NT DBA <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 02:54 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: OCP 7.3 &
Our good friend Gaja Vaidyanatha is now with Veritas,
so this isn't really too surprising. :)
Jared
David Wagoner <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 01:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROT
First time I've seen this note: 189702.1
Jared
Is it really worth the effort to convert dictionary-managed system
tablespaces to
locally-managed in 9.2? Ostensibly, I should see some performance
improvements due
to less recursive sql, etc; but from Googling/Metalink in looking for more
info, it
doesn't appear as though many sites have bothe
Jacques,
>In what cases does the SERIAL# need to be used? Can someone give an example
where a session-level command would be
>applied to an incorrect session object if SERIAL# were not available?
For backward compatibility reasons :) Looks like AUDSID wasn't generated 7.2
and prior unless AUDIT_
Another option is to list multiple *dmp files in the FILE parameter; ie
FILE=(file1.dmp, file2.dmp, ...)
along with the FILESIZE parameter. When the file1.dmp reaches the size specified in
FILESIZE, then file2.dmp
is created, and so on. The trick is to list enough files in the FILE parameter to
c
Yes, but only from an EXTPROC.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Monday, October 06, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L
Hello,
Is it possible to execute an exe from a stored procedure? If so can you please
provide an exmp
Hello,
Is it possible to execute an exe from a stored procedure? If so can you please
provide an exmple?
Thanks
Jake
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jake Johnson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity
If you choose to implement this method, make sure that all the tables can be in the
exchange partition command. The exchange partition command has certain requirements to
be able to complete the exchange (similarity of indexes and constraints), and the
table has to be suitable for building a "co
Yes, I have a 4.5G export file on a Solaris box.
Have your System Admininstrator check to ensure the filesystem you are
writing the export file to is configured for "large files".
Once you've verified that, then you can export (or import) via a named
pipe. See Note #30528.1 or one of many other M
> David Wagoner wrote:
>
> Just got this email from Veritas...apparently they are getting into
> the database performance business for Oracle (and SQL Server too I
> think).
>
>
> Best regards,
>
> David B. Wagoner
> Database Administrator
> Arsenal Digital Solutions
> "the most trusted source
Hi All,
>From the Oracle Education Certification Page:
http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html
Shows 4 possible tests:
Oracle9i
DBA OCP Upgrade Path
Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs.
In order to make the process of staying
curren
Well, they've just acquired OraPerf. I don't know whether Anjo Kolk
is now a veritable Veritas employee, but if he is, then Veritas is
a very serious contender in oracle performance tools/consulting market.
If they acquire hotsos, everybody else, including Quest, is done for.
On Mon, 2003-10-06 at
This
is the renamed Precise Software tools they bought earlier this year
.
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003
1:59 PMTo: Multiple recipients of list ORACLE-LSubject:
FW: Oracle Performance Software from Veritas
Dan,
It was never my intention to make you or anyone
else feel bad.
And I certainly feel the same frustrations
that you felt when looking at the Web site to begin with.
I agree completely that the page in
question showed a significant lack of attention to the information pres
You can use the partitionning option.
Load into a 1 partitionned table then do a partition exchange with the
target table.
It allows you to have the current data live while loading into the
partitionned table.
Once the load is loaded just exchange the partition with the table, it is
fast as it is
Hi All,
We have an Oracle database that is a kind of data warehouse. We load data
from mainframe into the database every day. The following are the steps how
we load data currently:
1. get the data file from Datacom
2. ftp the data file from mainframe to the Sun machine where the Oracle
data
Melanie,
There is truth in what you said originally. As soon as I read your
original email, I felt bad. I appreciate your willingness to stand
up and disagree. Some of us take issue, rightly so, with the content of
the page, but we (me included!) should do a better job of critiquing
the page in
>>
Have any of you experienced similar problems with XDB while patching or
upgrading?
Jared
>>
Yes. In our case, the XDB tablespace was simply too small. We were not
planning on using it, but installed it anyway, and had set the XDB tblspc
size to somethin like 32M. We wound up setting autoexte
Hi,
I am reading the following doc:
Oracle9i
Release Notes
Release 2 (9.2.0.1.0) for Sun Solaris (32-bit)
April 2003
Part No. A97348-04
and I found that it says the Import/Export file is limited to 2,147,483,647
Bytes (see below). Does this mean the max dump file size. I don't have 9i to
try no
Dear list,
As promised, I have summarized the issues that folks
on this list are dealing with, when deploying Oracle
in a SAN/NAS enviroment. I really appreciate the time
that you took to respond to my questions. Thanks to
everyone who responded.
Issues:
--
1) Lack of performance consistency
Title: Message
I
haven't used or thought about these scripts since version 7.0, until one day
last year.
Another DBA at our shop had written a script called "startdb", which
starts up your current ORACLE_SID. So, thinking I'd be efficient and save maybe
10 -15 keystokes in starting a data
Just
got this email from Veritas...apparently they are getting into the database
performance business for Oracle (and SQL Server too I
think).
Best regards,
David B. Wagoner Database Administrator Arsenal Digital
Solutions "the
most trusted source for STORAGE
MANAGEMENT SERV
Sorry
Jared, I responded before I got far enough in the list to see your
post.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Monday, October 06, 2003 2:59
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Cary's book - Rapidly moving OTHey folks
Well, I have to prove that I know few other things besides
stirring trouble...
On Mon, 2003-10-06 at 15:49, [EMAIL PROTECTED] wrote:
> Nice work Mladen!
>
> Thanks for doing this, let us know what else you find.
>
> I haven't had time yet to play with it.
>
> Jared
>
>
>
>
>
> Mladen Goga
Nice work Mladen!
Thanks for doing this, let us know what else you find.
I haven't had time yet to play with it.
Jared
Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 01:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list O
List,
I ran into some difficulties today while applying the 9.2.0.4 patch to a
9.2.0.1 db on RH 8.0, and was curious if anyone else had seen
similar problems.
After installing the 9.2.0.4 sw ( after installing the 2.2.0.18 OUI of course ) , I
started the database via 'startup migrate' and then
I haven't seen this book, but I occasionally do technical reviews for
Rampant and I must say that the books that I've seen so far are rather
good and make good sense (I've seen chapters of Arup's book and Stpehen
Andert's book about wait event interface). I seriously intend to buy
both of those boo
Well all, I’ve been corrected in my
statements below, and I am always one to own up to my mistakes (or
misstatements).
I guess what I should have said is that in
SOME cases, there is not always a clear communication between all parties
involved when an advertisement is made.
In thi
It looks like a promising undocumented utility.Below is what I managed
to get by running it. I also asked the question on metalink.forum.
Later, I'll ask it on asktom.oracle.com.
inst = "compldb" app = "sqlplus" home = "help"
KGMGR> help
Commands:
STARTUP PFILE=param file: Startup instance
CO
Hi.
I am trying to speed up the following query:
update table X set col1=2; I set the degree of
parallelism for the table X to 16 and added a hint:
update /*+ parallel(X,16) */ table X set col1=2;
I only got 4 parallel slaves - one for each partition
in the table. When I do that same operation for
It's 7 bytes
"elain he" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 11:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: what's the size of a date field?
Hi,
I'
You have listed the reasons why many folks
don't use the supplied oraenv scripts.
It has long been necessary to modify the dbshut and
dbstart scripts as well, if you use them, as they have
in the past not worked so well.
Been awhile since I've even used them, so they may
have improved while I
Well, I have published a book, but just one.
I wasn't necessarily poking fun at the author, but the web page is a hoot.
Time for this thread to die, I guess.
Jared
"Melanie Caffrey" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 12:54 PM
Please respond to ORACLE-L
more terrific work from Don Burleson. I believe he is the editor on the series.
is it jsut more or is most of the stuff from this guy redundant material you can get
for free from the docs? I hear his Unix for DBAs and Wait Statistic books are pretty
good(though have some inaccuracies).
most of
That sounds very interesting.
I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i.
Being able to skip the 8/8i exams should make this attractive to many folks.
Jared
"Ron Rogers" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 08:39 AM
Please respond to ORACLE-L
elain he wrote:
>
> Hi,
> I'm trying to figure out the size (in bytes) of a DATE column. Executing the
> three queries below returned me three different values. Is there any way of
> finding the size of a date column in the database?
>
> Thanks.
>
> elain
>
> select * from testing;
> DOB
>
Hey folks, move it to the OT list, or just keep it private.
Jared
Bob Lofstrand <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/06/2003 10:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
OT list please.
Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/04/2003 11:09 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Cary's book[Scanned]
I lo
why does the song "and Bingo was his name-o" keep echoing through my
mind now?
--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote:
> Hey...I don't have a "tnsping0"! Heck, I don't have
> "agtctl0" or any of the other "*0" programs! How do I
> install them? Where is the hidden $ORACLE_HOME
The size is 7.
avg_row_len includes the row header.
dba_tab_columns.data_length has the "correct" result 7.
The length function applies to varchar2 fields, so the date is converted to a
character using your default date format, and the length of the string is returned.
length ('06-OCT-03') = 9
Alright. Now, I feel I have to
defend this poor guy. For if I don’t,
who will?
First of all, the book title lists the
covered items as
Hidden programs – COMMA –
export/import – COMMA
And so forth.
VERY different from something like
Hidden programs: export/import, SQL
>From the Fine Manual:
Oracle9i Database Performance Tuning Guide and Reference, Release 2 (9.2)
Part Number A96533-02
Chapter 24 Dynamic Performance Views for Tuning
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/sqlviews.htm#32598
V$SESSION
. SID: Session identifier, used to
Hey...I don't have a "tnsping0"! Heck, I don't have
"agtctl0" or any of the other "*0" programs! How do
I
install them? Where is the hidden
$ORACLE_HOME/bin? If
my management finds out that I bungled the install of
9i
I could be in deep doo-doo.
...or not...
-Original Message
You mean the ls on the $ORACLE_HOME/bin directory (imported directly into the
documentation without editing)?
I always wanted to know how to get those secret ckpcch.ora and ncomp.log utilities to
work.
Jay
>>> [EMAIL PROTECTED] 10/06/03 02:39PM >>>
OK, well I thought it was funny.
Doing a goo
Perhaps a
grep -i kgmgr $ORACLE_HOME/bin/*
might be of help. I'm not sure what a "KGMGR iterator context" is, but the
"mig" utility is an intesting hit...
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex
Nope, it's in $ORACLE_HOME/wmd.
On Mon, 2003-10-06 at 15:19, Stephane Paquette wrote:
> You mean the hidden $ORACLE_HOME/bin directory
>
> Stephane Paquette
> Administrateur de bases de donnees
>
> Database Administrator
>
> Standard Life
>
> www.standardlife.ca
>
> Tel. (514) 499-7999 7470
how about that "Oracle utility" unzip?
and of course, oerr should be kept out of the hands of newbie DBAs
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> Geez at least get rid of the "old linked programs from the dir/ls
> listing" oracleO
>
> :)
>
> joe
>
>
> Daniel Fink wrote:
>
> > I see wh
Geez at least get rid of the "old linked programs from the dir/ls
listing" oracleO
:)
joe
Daniel Fink wrote:
I see what you mean. Too funny!
Hmm...I guess I've been wrong all these years. And all that time
I wasted reading the official documentation on such "undocumented" and
"hidden" pro
You
mean the hidden $ORACLE_HOME/bin directory
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.standardlife.ca
Tel.
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EM
Actually, Velpuri explains precisely why do you need to do that.
Backup controlfile does not contain last SCN, so one has to do
recovery to bring all datafiles to the same SCN. As there is always
a possibility that log files have some other SCNs, they need to be reset
and cleaned or those SCNs wi
I see what you mean. Too funny!
Hmm...I guess I've been wrong all these years. And all that time
I wasted reading the official documentation on such "undocumented"
and "hidden" programs like export/import, sql*loader, tkprof...
[EMAIL PROTECTED] wrote:
OK, well I thought it was funny.
Doing a
Oracle 9.2 on Linux RH8: who knows what the kgmgr utility is?
I can't find any useful references to it.
Here's the usage: usage: KGMGR[KEY=key] [IFILE=file name | command]
Thanks,
Jared
Hi Scott
Answer to Question 1 (answers Question 2, 3 too).
Bkp & Rcvry by Rama Velpuri - Case 8:Recovery with a Bkp control fileIf you use a backup control file, you need to perform media recovery.Also, Oracle will force you to use the 'using backup controlfile' option.Once recovery is done, yo
Hi,
I'm trying to figure out the size (in bytes) of a DATE column. Executing the
three queries below returned me three different values. Is there any way of
finding the size of a date column in the database?
Thanks.
elain
select * from testing;
DOB
-
06-OCT-03
desc testing
Name
OK, well I thought it was funny.
Doing a google search on some Oracle stuff, I found the following page.
http://www.dba-oracle.com/bp/bp_book6_utils.htm
Scroll down a bit? Do you see the funny part?
Jared
Hehe
Found a posting from Michael Ault on same subject. Michael - are you there?
Thread Status: Active
RDBMS Version: 9.2.0.1
Operating System and Version: Solaris 2.8 64 bit
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): OCI
Product Version: 9.2.0.1
Library Paths 32
As Weblogic is not an Oracle product, it is not surprising that Metalink returned
nothing. Try your query on Google.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, October 06, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
did it have an accompanying ORA- message or some such? If not than its either a
Weblogic error, a weblogic translation of an oracle error, or your developers trapped
the oracle error and translated it to something else(I hate when they do that).
>
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> D
Mine are all from 1.5 to 2 years apart. 10 to 18 woo hoo!
Of course, about 1/2 of the available women in the world run yelling when I
tell them I have custody of 5 kids. Since the other 1/2 are married, that
leaves me high and dry! ;-)
RF
-Original Message-
To: Multiple recipients of
I found the issue. I was only running 9.2.0.1 and it successfully worked on 9.2.0.3.
I know this will help someone in the future. Good luck!
On Mon, Oct 06, 2003 at 08:49:30AM -0800, Jake Johnson wrote:
> No, the correct field is atrb_srt_ord. I also tried order by 1 and that didn't work
>
Guys,
I setup lsnrstartstop scripts for root that does the su -c to oracle and runs
them. I could run as oracle successfully but using the su - c command brought me this
error:
"Oracle ld.so.1: /opt/oracle/product/9.2.0/bin/lsnrctl: fatal: libclntsh.so.9.0: open
failed: No such file or di
Title: RE: Cary's book - Rapidly moving OT
We have 5 also. All teens now. Very scary. Braces, learning to drive, starting college. I hope yours were more spred out.
Why? How? Three little girls, that's about right, then Surprise, twin boys. Uh oh.
Wouldn't trade them for anything but w
i think one of the reasons utllock.sql is slow is because it joins data dictionary
views instead of just hitting the underlying tables.
does anyone have a modified utlock.sql that hits the underlying tables? dba_blockers
is instanely slow sometimes.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROT
Our web administrator was deploying a new J2EE application to production and
received the error broken_pipe. We are using the thin client. Apparently
Weblogic tries to verify existence the tables the application uses. The
deployment was otherwise successful in that the error occurred several times
No, the correct field is atrb_srt_ord. I also tried order by 1 and that didn't work
either. The field names are in the describe below.
Thanks
Jake
On Fri, Oct 03, 2003 at 01:29:33PM -0800, Dave Hau wrote:
> Is it because you misspelled "atrb_srt_ord" as "atrb_str_ord" in the
> ORDER BY claus
Title: RE: Question with lock script - phantom objects
MG,
the one you mention is slow... that's why this script.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
Hans:
This parameter limits the max # of buffers can be pending for an AIO
operation. Usually you never need to tune (!) this parameter as the default
holds good for most platforms.
BTW what is the size of the log buffer? You will never have more than 4k
pending buffers unless you have a really h
Raj,
Are you certain that in all the cases id1 is an obj#? Its meaning depends on the
type of lock. An unfortunate coincidence might make it match an obj# when it is
actually something else.
HTH
SF
>- --- Original Message --- -
>From: "Jamadagni, Rajendra"
><[EMAIL PROTECTED
I actually sat for the beta of that exam, the week before OracleWorld. I
haven't received my scores yet, so I doubt that it is actually being offered
to the general public yet. But that *is* the plan.
Brian
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL PROT
The script as such works, but I do not like user scripts
accessing objects owned by SYS directly. I normally use
modified version of utlockt.sql in which dba_locks_temp
and lock_holders are global temporary tables in my schema
which do not get dropped & re-created every time.
On Mon, 2003-10-06
Hi All,
The current value for my AIX 4.3.3 / 8.1.7.4 instance parameter
_db_writer_max_writes is 4096. I've just raised my aio maxreqs to 16384.
Would it be beneficial to increase _db_writer_max_writes?
HTH,
Hans de Git
_
MSN Zoeke
List,
While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html
"Upgrade E
Title: Question with lock script - phantom objects
Hi all,
I am using following script to see locks in the DB. Do you see any problems with it?
cut here =
connect / as sysdba
set linesize 200 feedback off heading on pagesize 100
column sid f
thanks guys. Im only familiar with the oracle database, so I dont know if I can
believe what I read when dealing with other databases.
so I wanted to check. while we are on the topic of other databases. What kind of wait
interface's do other databases provide? How robust are they?
>
> From: D
Cary - Thanks so much for providing the historical perspective on this
issue. Perhaps you could confirm or refute a theory of mine. My theory is
that in the early days of databases, most of the guidelines for database
tuning came from benchmarks. This was an activity that received a lot of
top-notc
List please try out the following :
1. select sum(bytes) from v$sgastat where pool='shared pool';
2. find out the size of the shared pool you have specified in your
parameter files.
3. subtract the two values
4. When I do the same as above the difference is exactly equal to my
db_cache_size.
Arup ,
wow I am so glad that you answered . You always come up with the real mccoy
answers. However I have a few questions stemming from what you said:
1. I tried running select * from v$sgastat where pool = 'shared pool'
order by 3;
on my 9.2.0.1.0 enterprise edition. I was unable to get any
Title: Mensagem
Tom,
do u know the ip of email server? If yes then maybe i can help
u.
Regards
PG
-Mensagem original-De: Erik Williams
[mailto:[EMAIL PROTECTED] Enviada: sexta-feira, 3 de Outubro
de 2003 20:45Para: Multiple recipients of list
ORACLE-LAssunto: RE: how to
Listers,
sorry for this basic questionnare.
..was reading the RMAN B&R docs (9iR2).got these
doubts and thought of claryfying it with u experts.
Q1.after a controlfile recovery from backup,is "open
resetlogs" always necessary ?
Q2.is there any scenario,where "open resetlogs" is not
necessary af
Hi,
blocksize in aix is 4k by default, not 512 byte.
And read ahead can be controlled by aix kernel parameter. If you really want to
bypass aix filesystem read ahead, just change the kernel parameter dynamically. (I
cannot remember the detailed kernel parameter, maybe min/maxpgahead)).
99 matches
Mail list logo