In article [EMAIL PROTECTED], nelson flores
[EMAIL PROTECTED] writes
Something important to take into account when talking about security, is
the problem with if you don't know it's happening you can't stop it...
..
Remember to read/analyze logs for unusual stuff (Oracle or FW logs)...
preferably
Correct me if I am wrong ... but Oracle *does* maintain a list of currently connected
users ... it is called v$session. Why are you trying to do the same manually?
Raj
Rajendra dot Jamadagni at nospamespn dot com
Is there a place that we can see the code without installing the PDBA
toolkit? I don't need to dump any table or schema, I just need to dump a
selected query result (many many rows) into a text file.
Do you just use perl's print to write data?
Guang
On Sun, 11 Jan 2004, Jared Still wrote:
I
]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: Export / Import Question
.com
]Subject: RE: Export / Import
Question
.com
]
om cc:
Sent by: Subject: RE: Export / Import Question
Don,
Comments inline...
Yes! IME, there ARE still problems in the CBO, especially with complex
subqueries.
I have more than a dozen systems where management insists on staying with
the RBO!
[TG]: With all due respect, what does management know about this stuff
anyway? They do not work
Hi Pete
Thanks for the reference. I did visit your site earlier and collected
necessary info.
Using our internal documents, we did come up with our audit review.
Anyway, once again thanks a lot.
Regards
Vidya
Pete Finnigan wrote:
Hi Vidya,
security! - There are a few checklists for security
Since when is redo log writing
performance handled by DB_WRITERS
or DBWR_IO_SLAVES?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
Now, the Sr DBA here is screaming about the performance since I made the
change,
in particular, he says he's seeing high redo latch contention
There could be some interaction.
If DBWR needs to write a block for
which the most recent changes are in
the log buffer but not in the log file, then
DBWR posts LGWR to write - and in
earlier versions of Oracle DBWR would
then wait for LGWR to sync, in later versions
DBWR links the buffer to a
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tony Miller
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Warning :
This is an automated message. Your mail could not be delevered to [EMAIL PROTECTED]
since the email id is changed.
Please send your mails in future to : [EMAIL PROTECTED]
Regret for the inconveniences.
With regards,
IT Department,
Venkateshwara Hatcheries Pvt. Ltd.,
Hosur - 635
Steve,
By distinct user do you mean distinct username? Or sid/serial#
combination? In my case, we use connection pooling, while there may be
up to 300 sessions, they are all the same named user.
Rachel
--- Steve Adams [EMAIL PROTECTED] wrote:
Hi All,
Someone has alerted me to this thread,
how do you feel about connection pooling? Our software engineers implemented
that here? Am I wrong to be concerned about large numbers of users using the
same named user?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, January 10, 2004 6:39
it up to date by re-loading any
data that was loaded after the BCV split.
The rebuild-then-reload method seems to make sense on paper, but it is the
cause of extreme difficultly in actual practice. If you have not yet
already implemented a very mature change-management procedure, to record
Yes, I hadn't read the line
so the tablespaces had to be put into backup mode or (8i and after) the
database had to be suspended
you _do_ have an OR between the backup mode and the database .. suspended.
We hadn't heard of anyone using the SUSPEND and didn't want to take the chance
of a database
It's always a little hard to tell from a low-concurrency
experiment how bad things can be at high concurrency.
(If it were easy, Cary wouldn't have had to have written
his book).
I have an example where a collision rate of 0.25%
results in an increase in response time of 8% at
relatively low
Note in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearance2:
March 2004 Hotsos Symposium - Keynote
March 2004 Charlotte NC -
Ryan:
Same named user with large number of connections is not a problem.
Things will become bad only IFF the large number of different users
using the same set of public synonymns.
KG
--- Ryan [EMAIL PROTECTED] wrote:
how do you feel about connection pooling? Our software engineers
I'm concerned about other problems. We may have 30,000 concurrent users,
sharing 5 or so named users. My big concern is maintenance and tracing.
Has anyone worked with this type of environment? How do you build tracing
into the front end so I can tell which sid, serial# is experience problems?
If you are on Oracle 9i, try connection identifier using
DBMS_SESSION.SET_IDENTIFIER for each of the client sessions. Even if teh
USERNAME in V$SESSION shows your named user, the field CLIENT_IDENTIFIER
will show the actual user (say, the application userid). The trace files
will show that, even
PROTECTED]
Verzonden: dinsdag 6 januari 2004 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
The workarea_policy stuff does not apply
to things like pl/sql tables, only to tuneable
memory. Given that you don't have the
problem when you disable
' || uitleg );
end;
end;
-Oorspronkelijk bericht-
Van: Jonathan Lewis [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 6 januari 2004 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
The workarea_policy stuff does not apply
to things
Hi!
If you intend to use roles to simplify privilege management, you are
almost forced to use public synonyms, as you cannot create a private
synonym owned by a role. Your other alternative is to hard-code the
How can you create a public synonym OWNED by a role?
This is new to me, despite the
Tanel,
I'm fairly sure that Rachel was not implying that a role
could own a synonym, public or private.
The point was that using role based privilege management,
you either create private synonyms for each user, or create
public synonyms.
Another alternative is a logon trigger that does an
by re-loading any
data that was loaded after the BCV split.
The rebuild-then-reload method seems to make sense on paper, but it is the
cause of extreme difficultly in actual practice. If you have not yet
already implemented a very mature change-management procedure, to record
all
by re-loading any
data that was loaded after the BCV split.
The rebuild-then-reload method seems to make sense on paper, but it is
the
cause of extreme difficultly in actual practice. If you have not yet
already implemented a very mature change-management procedure, to
record
all
Does anybody have any good resources (links/whitepapers) on setting up,
managing and monitoring an Oracle Standby environment?
I found Oracle Backup Recovery 101 by Stephan Haisley and Kenny Smith to
be useful.
Gudmundur
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Having worked in an environment where every user was a distinct named
user, and I therefore could (and at points did) have something 1700
distinct connections (yes, I said one thousand seven hundred).
I like connection pooling. It limits the stress on the database,
because the number of
Tanel,
you can't create a public synonym owned by a role, sorry if I wasn't
clear. But public synonyms are available to all users, regardless of
the role you assign to the user. So you have to use public synonyms
when you use roles, unless you either specify the object owner name in
all
yep, that's what I meant :)
additionally, if you decide to create private synonyms for each user,
you still have the potential problem of forgetting a user when you add
a new synonym. Yes, I use SQL to generate the SQL I need but even so,
it's a lot easier to include create public synonym and
In the UGA, I should think (which also means the
SGA if you are running MTS). It can't be in the
PGA (ignoring the fact that the UGA is in the PGA
for non-MTS) or you couldn't have global pl/sql
tables that persist across database calls.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Rachel,
I think we had a similar situation in my previous life, when we had to get the programmers to modify their code to trace specific areas of the application. The way we went about doing this (in this case they had a concept of using a catalog.xml file where all the SQL queries got stored
I have seen people bulk collect into pl/sql tables so much data that you
cannot even connect to the server. So I'm assuming that ones the UGA fills
up, Oracle will allocate whatever unused memory is left on the server for
pl/sql tables?
- Original Message -
To: Multiple recipients of list
. My thinking is why turn on
archiving if I can restore my DB from last night's
BCV's and then bring it up to date by re-loading any
data that was loaded after the BCV split.
Our system is not 24x7 so we can shutdown before the
BCV split. Also, it's not directly accessed by users
for ad-hoc queries
?
In the same scenario in my environment I'd just
restore the entire BCV set and re-start the load. Not
an expert on EMC's BCV technology but my sysadmin says
it can be done and yes, I'll test before I sign off on
it.
True, I'd be nice to have archive logging aswell. But
is it a necassity
Hi Paula,
Paul and Steve have given some good ideas on this but also you should
lock down the database as hard as you can. Even if the database is only
accessed via the application server its data is still available from the
internet. Issues such as SQL Injection and cross site scripting can come
Something important to take into account when talking about security, is
the problem with if you don't know it's happening you can't stop it...
..
Remember to read/analyze logs for unusual stuff (Oracle or FW logs)...
preferably with an IDS, as it makes the job of finding out whether you
have a
Would it be incorrect to assume that you never do inserts
into newly loaded partitions, or updates that could increase
the length of rows?
1 pctfree could be problematic in that case.
Btw, if you're sure that rows won't grow, it use even pctfree 0 instead of
1. One thing you have to have in
.
-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]
Sent: Sat 1/10/2004 4:34 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Re: pga workarea and ora-04030
I have seen people bulk collect into pl/sql tables so much data that you
cannot even connect to the server
On 2004.01.10 16:49, DENNIS WILLIAMS wrote:
Gene - As a part of putting the database back in archivelog mode, I hope you
take another backup.
Actually, taking backup should be a part of every major intervention on the database.
Changing the database mode from noarchivelog to archivelog most
Yeah, I configured RMAN on a system. Then the users didn't want me to turn
off cold backups. My response was that a DBA wouldn't say there was such a
thing as too many backups, so we do both.
Specifically with noarchivelog/archivelog, if you try to recover using a
backup from before you turned
Ok, thanks, this makes sense.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, January 10, 2004 10:34 PM
yep, that's what I meant :)
additionally, if you decide to create private synonyms for each user,
you still have the
Jared has a utility to dump tables to flat files
http://www.cybcon.com/~jkstill/util/
on the lefthand menu, under Utilities click on Dump Tables to Flat
Files
--- Guang Mei [EMAIL PROTECTED] wrote:
Hi:
I have a program (running on oracle 8173 server) that writes 48
Millions
lines
PROTECTED]
Verzonden: dinsdag 6 januari 2004 16:49
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga workarea and ora-04030
The workarea_policy stuff does not apply
to things like pl/sql tables, only to tuneable
memory. Given that you don't have the
problem when you disable p_a_t
Options #1 (Perl) and #2 (PRO*C) would be fastest and easiest. The PRO*C
demo programs provide a decent start, for option #2. Option #3 (OCI) would
be not faster than PRO*C and, due to the increased complexity of OCI, a more
problematic approach.
SQL*Plus is the easiest method to implement by
exactly the same with steve trying to log a bug about x$ksmlru
frits
-Original Message-
Sent: donderdag 8 januari 2004 20:59
To: Multiple recipients of list ORACLE-L
Comment in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who
Onkel Mogens wrote:
All to stay in my house (except Gaja - don't know what he's up to).
Rock'n'roll. And none of them know what I meant when I asked them to
bring some old clothes for some unusual teambuilding...
You're not having them do construction work on your house again, are you?
Gaja
Onkel Mogens wrote:
there just MIGHT be a need for me to use a few, chosen, Danish bad
words. I shall try, of course, to keep it in Danish. Shouldn't offend too
many.
Maybe not offend but it could bring back bad memories for some about
blisters and aching backs, especially if one of the words
sorry, the second query uses equality operator..
WHERE UPPER(col1) = 'xyz';
index hint is not helping.
regards,
B S Pradhan
--
On Thu, 08 Jan 2004 zions swordfish wrote :
hi, pradhan,
I don't see any kind of differences with your two queries, but
I suggest you to use
Dick/John
Thanks for all your input. I conclude from this discussion that it is not
possible to have different, seperate external procedure listeners for
different SIDs in the same instance at least not in 8.1.7.
Incidentially, I have been having an issue with running an rsh command via
an
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tony Miller
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
- Original Message -
From: Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 08, 2004 6:34 AM
Subject: RE: table reorganizations
Jolene,
Tables should never *need* to be reorganized. This is an old falacy. If
you know how big
-
From: Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 08, 2004 6:34 AM
Subject: RE: table reorganizations
Jolene,
Tables should never *need* to be reorganized. This is an old falacy.
If
you know how big a table is going to grow, say
-
From: Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 08, 2004 6:34 AM
Subject: RE: table reorganizations
Jolene,
Tables should never *need* to be reorganized. This is an old
falacy. If
you know how big a table is going to grow
- Original Message -
Wouldn't it be nice if dbms_stats could do an incremental refresh,
tracking ONLY stats changes that might make a difference to execution plan:
I'd settle for a flag I could turn on and off, saying:
do/do not change stats for this object.
I know which of
Yahwoll, mein herr!
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 09, 2004 6:09 AM
Waddya mean, propaganda sheets? We never release propaganda - everything always
works the way we say it
Pete Sharman scribbled on the wall in glitter crayon:
Well, so here's the challenge for RMOUG training days - loosening
Rachel's lips. Who's gonna join me in this endeavour? :)
oh i have several methods i'd like to try.;-)
--
Bill Shrek Thater ORACLE DBA
I'm going to work my
For one thing, please don't install 8.1.6. Install at least 8.1.7 and upgrade it to
8.1.7.4. You will be much better off. Actually, providing your system meets or
exceeds the minimum requirements stated in the installation manual, this install goes
fairly easily. DO read the installation
08, 2004 6:34 AM
Subject: RE: table reorganizations
Jolene,
Tables should never *need* to be reorganized. This is an old
falacy. If
you know how big a table is going to grow, say in a year, then
place it in a
Locally Managed tablespace with extent sizes
Note in-line.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearance2:
March 2004 Hotsos Symposium - Keynote
March 2004 Charlotte NC -
Is any single table more than 2G ? If not, just break
up the export into individual schemas and/or tables.
For those tables that are more than 2G, you could
compress via a pipe - for NT might mean running export
over sqlnet from a unix box.
hth
connor
--- [EMAIL PROTECTED] wrote: Hi DBAs,
.
There are of course other cases but you get my point ;)
Cheers
Richard
- Original Message -
From: Mercadante, Thomas F
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 08, 2004 6:34 AM
Subject: RE: table reorganizations
You could migrate the database to 8i, or you could use sql to split the
table into 2GB and do the export in pieces, or you could just shut the
database down and do a cold backup of the database, retaining any media
you need to reinstall Oracle 7. Make sure if you are in archivelog mode
that you
Thanks. Sounds SUPER!
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
I'd settle for a flag I could turn on and off, saying:
do/do not change stats for this object.
snip
Available in Oracle 10g - lock stats.
--
Please see the official ORACLE-L FAQ:
Ruth,
thanks, I am back. I took the redundancy policy to 4 now and deleted
today's backupset and try to recover from the yesterday backupset which
is a valid status in the rman report. I still got error. Rman still
looking for today's backupset sequence. If I do the crosscheck and
delete the
I've uses the UNIX split command successfully with Oracle 7.3.4:
# set maximum file size for each chunk of the export file
#
MAXFILESIZE=1500m
export MAXFILESIZE
#
# create filenames for the parts of the backup
#
FILENAME1=$BACKUP_DIR/exporthrprd1.dmp
FILENAME2=$BACKUP_DIR/exporthrprd2.dmp
There are good documents on Metalink (one in particular by Lawrence To).
The Oracle RDBMS manuals are informative as well.
I run a script bat file on Windows on the primary to transfer the logs
every half hour to the secondary. And a bat file once a day on the
secondary to apply the logs. I use
You don't mention OS, but if it's a flavor of unix, you could probably
do:
mknod my_pipe p
exp file=my_pipe all other export options
split -b 2047m my_pipe exp.dmp
This will generate multiple files, 2.047 MB per file. They will be
named exp.dmpaa, exp.dmpab, exp.dmpac, etc,etc.
To import,
:Cary Millsap [EMAIL PROTECTED]@fatcity.com on 01/07/2004 07:44 PM PST
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Suggestions Needed: Latch free - library cache
One way is by writing
The migration to an Oracle8i database is not possible, b'cause, the package
using the database only support Oracle7. I will have problem if they decide
to reuse this product.
The coldbackup is the less demanding solution.
Thanks
-Original Message-
Sent: January 9, 2004 9:39 AM
To:
--- [EMAIL PROTECTED] wrote:
Hi DBAs,
Because of some requirements from one of our vendor,
we still have a
database running Oracle7.3.4 on WindowsNT and since
this package is no longer used, so we
want to export the content of this database.
The database is around 60G, one table is 55G.
Mark, Jolane
It's on WindowsNT, but I will install client7 on a Unix machine and I will
use the pipe.
Thank you
Luc
-Original Message-
Sent: January 9, 2004 10:01 AM
To: Multiple recipients of list ORACLE-L
You don't mention OS, but if it's a flavor of unix, you could probably
do:
Thanks, I've grabbed the whitepaper by Lawrence To (from
http://otn.oracle.com/deploy/availability/pdf/stby8i_twp.pdf if anyone is
interested). I'll take that home for bed time reading ;)
If I have any more specific questions I'll give you all a shout again! ;)
Many thanks
Mark
-Original
Hi Mark...
I have a good one... if you wanna copy email me
off-list...
Regards!
JL
--- Mark Leith [EMAIL PROTECTED] wrote:
Hi All,
Does anybody have any good resources
(links/whitepapers) on setting up,
managing and monitoring an Oracle Standby
environment?
It will be a windows
--- Shrake, Jolene [EMAIL PROTECTED] wrote:
There are good documents on Metalink (one in
particular by Lawrence To).
The Oracle RDBMS manuals are informative as well.
I run a script bat file on Windows on the primary to
transfer the logs
every half hour to the secondary. And a bat file
oh, just reserve the whole place :)
From what I've been seeing, it's somewhere between 10-20 people so
far...
Jared? you started it, have you been keeping track?
If not, anyone who is interested in a Tuesday night get-together at
Hotsos, email me directly and I'll get a headcount to Gary -- to
TRIGGERS=N
On 01/09/2004 09:09:26 AM, Smith, Ron L. wrote:
I have a user who want to refresh only the DATA in a test database with
DATA from the production database. He does not want to replace any
procedures, functions, triggers, etc...
My question is, if I do a full or user level export,
Guys,
Any good doc. on securing data on database on internal network behind firewall with an
application server accessing it in the DMZ. I am thinking Advanced security but would
appreciate something on this subject. I have stored some documents on security from
previous strings but cannot
Ron,
I share your feeling. All stored objects are recreated with CREATE OR REPLACE -
IGNORE=Y is inoperant for them.
IMHO the best you can do is generate as many table-level exports as you have tables,
with TRIGGERS=N. Of course, usual fun with constraints. On the bright side, you will
be
about 5
lines or so which was similar to implement than the mutating trigger
solution.
Regards,
N.
:--Original Message-
:-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
:-Behalf Of
:-GovindanK
:-Sent: 08 January 2004 21:20
:-To: Multiple recipients of list ORACLE-L
:-Subject: Re
Sorry, I tried set until time, it works. Now I think we can move rman to
production since we tested all kinds of restore.
Thanks and have nice day!
Joan
Joan Hsieh wrote:
Ruth,
thanks, I am back. I took the redundancy policy to 4 now and deleted
today's backupset and try to recover from
Joan - Glad to hear your success. In the meanwhile I replied to your earlier
message.
Just to clarify, when you used a time-based recovery, setting a time earlier
than the most recent backup, RMAN ignored the most recent backup and
restored from an earlier backup? Wouldn't that have the
Joan - I have not used the redundancy policy, but my understanding is this
just involves how many backup copies to retain. It does not relate to
recovery as I read the manual.
Do you have Robert Freeman's book Oracle9i RMAN Backup Recovery?
Are you attempting an incomplete recovery or a
David,
See MetaLink Doc ID 39817.1, if you have access to MetaLink. Also, see
Cary Millsap's new book: Optimizing Oracle Performance.
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was
search for tracing event 10046, or better, buy
http://www.oreilly.com/catalog/optoraclep/index.html
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
I am trying to find a reference or document that explains how timing data
is
collected in 8i and 9i.
--Original Message-From: Tracy Rahmlow
[mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 9:44
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Suggestions Needed: Latch free - library cacheDuring the Hotsos course I thought I remember hearing
that the pool could be
I'd like to go
Allan
-Original Message-
Sent: Friday, January 09, 2004 9:35 AM
To: Multiple recipients of list ORACLE-L
oh, just reserve the whole place :)
From what I've been seeing, it's somewhere between 10-20 people so far...
Jared? you started it, have you been keeping track?
[ITS] [EMAIL PROTECTED] writes
You should be aware that Oracle relies on the client providing this information,
so it isn't always available. In particular, the JDBC thin driver tends to
always use __jdbc__.
Hi,
certainly for the IP address you have to be using TCP.
kind regards
Pete
--
, January 08, 2004 6:34 AM
Subject: RE: table reorganizations
Jolene,
Tables should never *need* to be reorganized. This is an
old
falacy. If
you know how big a table is going to grow, say in a year, then
place it in a
Locally Managed tablespace
HUMM, I've taken a pretty tight stand against open ended external procedures and Java
Stored Procedures. Thankfully the developers here agree. Basically I've told them
that can't have an external or java procedure that executes a command send into it.
That being the case rsh or sh command
I generally dislike large gatherings of people but for a Oracle-L get
together I'll make the sacrifice. Count me in.
At 07:54 AM 1/9/2004, you wrote:
We considered this Mogens but you lost out to the Steve Adams 1-day
seminar in a surprisingly close vote.
As for an Oracle-L Tuesday group dinner
Would love to know!
-Original Message-
Stahlke, Mark
Sent: Friday, January 09, 2004 11:34 AM
To: Multiple recipients of list ORACLE-L
Greetings,
Does anyone know of a good, readable tutorial on Oracle Warehouse Builder?
I've been searching Google and even looking for books on
End of January is fine.
Gary
(817)424-3443 Office
(817)296-8000 Cell
-Original Message-
Rachel Carmichael
Sent: Friday, January 09, 2004 9:35 AM
To: Multiple recipients of list ORACLE-L
oh, just reserve the whole place :)
From what I've been seeing, it's somewhere between 10-20
David - I'll second Carel-Jan's suggestion. If you are this interested in
this topic, you'll find Cary's book invaluable.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 09, 2004 10:15 AM
To: Multiple recipients of list ORACLE-L
search
Ron - You may want to ask yourself what you're getting into. My preference
is that the developers be creating scripts to make their procedure,
function, trigger changes, along with detailed instructions for installing
them. I make my counteroffer that I will recover a copy of the production
To the OP: Other people point out common reasons for library cache latch
contention. A less common reason is extensive use of public synonyms.
If that's the reason, you also see row cache objects latch contention.
I'm not sure that's right. If everyone uses a public synonym, then
you get
This is the only reasonable policy, because all OS commands would
necessarily execute on the server side. Developers, generally speaking,
do not have access to the database server, so I don't see much use
for that. If the idea is to spawn a command on the developer's workstation
by using rsh or
During the Hotsos course I thought I remember hearing that the pool
could be too large and that could have a negative impact on the
library cache latch. Am I confusing this with something else (maybe
the buffer busy event)? If true how do you go about determining the
optimal size?
Hi Vidya,
security! - There are a few checklists for security on my website at
http;//www.petefinnigan.com/orasec.htm - but i guess you should have
access to security and health check tools internally in Oracle?
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site:
901 - 1000 of 67344 matches
Mail list logo
