Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: Export / Import Question
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
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
All
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)...
>
Dear Mladen,
Thanks for your response.
SYS and REPADMIN users are keep on LOGGING-IN and LOGGING-OUT periodically
in the background.
That is why SYS user got deleted(when automatic LOG-OUT happens).
Anyway I'll try auditing feature as you suggested.
Thanks again,
Sami
-Original Message
Dear Mladen,
Thanks for your response.
SYS and REPADMIN users are keep on LOGGING-IN and LOGGING-OUT periodically
in the background.
That is why SYS user got deleted(when automatic LOG-OUT happens).
Anyway I'll try auditing feature as you suggested.
Thanks again,
Sami
-Original Message---
What happens is that you have a database wide logon trigger,
not just a trigger on scott.schema which needs an execution context.
A pseudo session with a SID=0 is established and the trigger is executed.
Personally, I would use auditing ("audit session" or "audit session by scott"),
not a databas
oading data, you
> > turn off archiving. So if you lost that dbf during a
> > load, how would you recover the db? Restore the dbf,
> > apply the logs and restart the load, right?
> >
> > In the same scenario in my environment I'd just
> > restore the
I also have one in Perl that I use to dump an entire schema
to flat files, generating sqlldr parameter and control files
as is goes.
sqlunldr.pl is part of the PDBA toolkit:
http://www.oreilly.com/catalog/oracleperl - click on 'Toolkit'
Jared
On Sat, 2004-01-10 at 19:39, Rachel Carmichael wrote
A quick and dirty hack to the existing PL/SQL code
which typically adds good performance improvement is
to fetch from your cursor in bulk collect (say 200-500
records at a time).
Otherwise its Perl/C/etc/etc time.
hth
connor
--- Tim Gorman <[EMAIL PROTECTED]> wrote: > Options
#1 (Perl) and #2
--
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
--
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 fa
ting a limit somehow.
>>>
>>> Can somebody explain which limit this is and how is it composed or
>>> influenced (temp, sga ?) ?
>>>
>>> Is this reproducible on other systems / versions ?( Metalink post
> reports
>>> This also on early 8.1.x
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
>
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 t
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 o
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
nstance, just the problem user.
-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
can
> 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
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
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
archiving. So if you lost that dbf during a
> load, how would you recover the db? Restore the dbf,
> apply the logs and restart the load, right?
>
> 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 B
reed to
(and also sounds like a good idea) but also wants to
turn on archiving. 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 shutdo
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
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
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
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 "g
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 reference
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 sessio
> 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
--
A
; is
> > > the "industry standard" and makes complete sense in all but a few
extreme
> > > cases.
> > >
> > > Have you considered what archive logging actually provides for you,
and
> > what
> > > is necessary to engineer the same effects
t; what
> > is necessary to engineer the same effects on your own? Think it
> through...
> >
> > >
> > > He's proposed using EMC BCV's which I've agreed to
> > > (and also sounds like a good idea) but also wants to
> > > turn on arc
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
'alt
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 t
INDEX BY BINARY_INTEGER;
> > assarray nAllotment_tabtyp;
> > assarray2 nAllotment_tabtyp;
> > assarray3 nAllotment_tabtyp;
> > uitleg varchar2(100);
> > begin
> > uitleg := 'start loop';
> > for i in 1..psize loop
> >
uitleg := 'insert i= ' || i;
> assarray(i) := i;
> /*
> uitleg := 'insert i2= ' || i;
> assarray2(i) := i;
> */
> end loop;
> EXCEPTION
> WHEN OTHERS THEN
> dbms_output.enable(2);
> dbms_output.put_line(' Exc
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 au
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?
The
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
> implem
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 - OU
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 conc
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 databas
s which I've agreed to
> > (and also sounds like a good idea) but also wants to
> > turn on archiving. 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 th
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
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 thr
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 1
--
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
--
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
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 an
I should have expressed myself more clearly. Suspend is not necessary, it's only fast.
Basically,
with suspend, you don't put tablespaces into backup mode. You suspend, resync, split
and start aonther instance as if it crashed. As no I/O is going to disk, datafiles
aren't
fuzzy, so no recovery
Mladen,
Is the "ALTER SYSTEM SUSPEND" really necessary.
We've just implemented SnapClone mechanims for three Oracle DBs on
Hitachi and EMC SANs, We've been told that only ALTER TABLESPACE ... BEGIN
BACKUP
is necessary.
What we do is
1. Issue an ALTER TABLESPACE ... BEGIN BACKUP for all the tabl
Hi All,
Someone has alerted me to this thread, and asked for a comment.
On a quick scan, and it seems to me that you've mostly got it right.
The "problem" is that when an SQL statement that refers to its base
objects via public synonyms is shared by multiple distinct Oracle users,
then name resol
thout
generating a TB of redo archives for the duration of hot backup mode. Robert
Freeman's
book is definitely the best source for anything RMAN around.
On 2004.01.09 20:29, mkb wrote:
> Hi Ryan,
>
> Not for RMAN. I meant a license for Veritas or
> Legato.
>
> See Mla
ut also wants to
> turn on archiving. 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.
The rebuild-then-reload method seems to make sense on paper,
Subject: Re: Backups in a DW
Environment
The license is for the
software that interfaces Veritas NetBackup to RMAN. RMAN has an API and NBU has an API. The
intersection of the 2 will set you
back about $1500 US IIRC.Jared
"Ryan" <[EM
pond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Backups in a DW Environment
I never heard about the required license from veritas and legato. Can
someone else confirm that this is necessary
Hi Ryan,
Not for RMAN. I meant a license for Veritas or
Legato.
See Mladen's reply re: BCV (basically EMC takes a
snapshot of the mount points onto corresponding mount
points i.e. a 1-to-1 mapping for each mount point onto
a BCV mount point)
Hope that clears up the confusion.
moh
Hi,
This is from a metalink note 1039341.6. It is about 'DEFAULT STORAGE'. I do not know if the OCP question was regarding that.
***
Use the following guidelines to specify DEFAULT STORAGE: Set INITIAL=NEXT.Since a process always writes data equal to SORT_AREA_SIZE to a temporary s
oops. my bad. I really should double-check in the docs before I
pronounce things :)
you are, of course, right. it merely removes the necessity to preface
an object reference with the owner.
--- "Bobak, Mark" <[EMAIL PROTECTED]> wrote:
> Um, roles, privileges, etc are administered however you'd l
CV's. Wouldn't it
> > be just as quick to restore the entire BCV as to do an
> > Oracle recovery from tape?
> >
> > Also Gene, you mention that while loading data, you
> > turn off archiving. So if you lost that dbf during a
> > load, how would you recove
Niall,
I think you're right... and as my databases, even those with multiple
applications in them, rarely have more than 20 named users, that's
likely the reason I see no degradation, even on custom apps.
Nice to know it's not just me :)
Rachel
--- Niall Litchfield <[EMAIL PROTECTED]> wrote:
>
Just go surfing to CA. Be sure to resemble seal as much as possible and jaws will
come.
On 2004.01.09 19:44, quriyat wrote:
>
> Thanks
>
> ___
> No banners. No pop-ups. No kidding.
> Introducing My Way - http://www.myway.com
> --
> Please see the
you
> turn off archiving. So if you lost that dbf during a
> load, how would you recover the db? Restore the dbf,
> apply the logs and restart the load, right?
>
> In the same scenario in my environment I'd just
> restore the entire BCV set and re-start the load. Not
> an
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
Did you try reducing _log_io_size to less than
one-third log_buffers size to make LGWR more active
and less busy .. We have had some success with it..
Thanks,
Ravi.
--- Thomas Jeff <[EMAIL PROTECTED]> wrote:
> Jonathan,
>
>
>
>
see http://www.cybcon.com/~jkstill/util/reset_sequence/reset_sequence.html
"Smith, Ron L." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/09/2004 11:49 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: RAC setup on linux
Joe,
In random order, here's some hints:
Make sure you visit Werner's site, http://www.puschitz.com He has al
pond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Books on rac
OK, that statement wasn't fair. I have not looked at Arup's book. I have no interest in HIPAA. So I shouldn't speak on i
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Books on rac
beware the rampant press books. Most of them seem to be total garbage. All
in large print with little detail. I didnt think much of the Ault Internals
book fr
Title: RE: Books on rac
OK, that statement wasn't fair. I have not looked
at Arup's book. I have no interest in HIPAA. So I shouldn't speak on it. These
are the Rampant books I have skimmed through that I do not like. However, I have
skimmed through several. All the one
Title: RE: Re[2]: Books on rac
Hi Jonathan
Don asked me if I would be interested in writing the Programmers Interview book... the Apps book was just done, so I took him up on the offer.
I am writing for CRC... in fact I have one in process now for them.
April
-Original Message
7;s which I've agreed to(and also
sounds like a good idea) but also wants toturn on archiving. My
thinking is why turn onarchiving if I can restore my DB from last
night'sBCV's and then bring it up to date by re-loading anydata that was
loaded after the BCV split.Our system
dbms_output.put_line(' Exception raised ' || 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_pol
Yes but...
The developers use Cognos tools for all their
development. Nobody writes any PL/SQL, triggers etc.
So again, all that the developers might lose is data
that they loaded which can be easily recovered by
re-running the ETL process.
What I'm trying to say is that the environment
What I love is the discount of 43% off at
Bookpool.com.
That text is only 30% off there.
Amazon lost my business way back when the 1-click
patent waste matter went down.
Pd
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> I had "I love you" and "The Latest Security Patch
> from Microsoft" emails
>
Jonathan,
WILLING IMMEDIATE
IMMEDIATE IMMEDIATE
NAME GETSMISSES TO WAIT %GETS
MISSES REQUEST %SLEEPS
=== === =
using EMC BCV's which I've agreed to
> (and also sounds like a good idea) but also wants to
> turn on archiving. 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 l
Title: RE: Books on rac
"all the other
non-Ault books from
Rampant are total trash."
That's a pretty strong statement, Ryan! Mine is a
non-Ault Rampant book; does it count, too? Before you trash the book and commit
the statement, can I interest you in at least taking a look
urned on. To me, it does'nt make much sense.
He's proposed using EMC BCV's which I've agreed to
(and also sounds like a good idea) but also wants to
turn on archiving. My thinking is why turn on
archiving if I can restore my DB from last night's
BCV's and then bring it
gt; He's proposed using EMC BCV's which I've agreed to
> (and also sounds like a good idea) but also wants to
> turn on archiving. 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-load
Hello April,
I thought you were writing for CRC Press, not Rampant. Did
you switch publishers?
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technol
I had "I love you" and "The Latest Security Patch from Microsoft" emails
stored in my "crap" folder on my home Linux box but I've recently cleaned it.
It might be a good idea to make people on this list feel loved and secure.
On 01/09/2004 04:24:29 PM, Joe Testa wrote:
> In case any of you are co
Well, recovery might be just a wee bit faster then re-loading few gigs of data
using SQL. Also, developers on that DW might lose any work that they haven't done
the night before. This is a production database, which means that it absolutely
must be in archive log mode. One of the big reaso
sing EMC BCV's which I've agreed to
(and also sounds like a good idea) but also wants to
turn on archiving. 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
Title: RE: Books on rac
wait... mine wasn't THAT bad... isn't out yet... but isn't that bad.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11
-Or
Title: RE: RAC setup on linux
joe-
There was a nice document on a *cookbook* to do this by Oracle. I'm not sure if I can get my hands on it as we were working to plan out a Linux install in November. That project fell out of priority.. I'll poke around, but not sure if I would
Um, roles, privileges, etc are administered however you'd like.
The only suggestion I'm making is that rather than having public
synonyms for all objects in your app_owner schema, each user which needs
default access to the objects in the app_owner schema, gets access to
that schema via the logo
Well, any solution will require consideration of the application design
and implementation. I'm just offering a possible suggestion. ;-)
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 provided to
Partly because of the complexity of the technology and uniqueness of each environment,
no book in the field will be 100 per cent of what anyone of us needs; however, the
following is on my database team's bookshelves:
Oracle 9i RAC
By Mike Ault
Published August 2003 by Rampant Tech Press
ISBN: 0
beware the rampant press books. Most of them seem to be total garbage. All
in large print with little detail. I didnt think much of the Ault Internals
book from Rampant... its basically stuff you can copy and paste from
metalink.
Dont know about his RAC book. However, all the other non-Ault books
that method is limiting. Lets say you publish data from various sources
using transportable tablespaces... Its much easier to manage this
publication by putting each transported tablespace in its own user.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
S
My reading of that is that they chose RH over *Unix* rather than Windows for
the DB Server.
"Detailing the problems encountered while using Windows Server 2003 on the
communication and transaction server side, Sharma said, "We have been facing
this perennial problem of business logic malfunction,
Joe,
In random order, here's some hints:
Make sure you visit Werner's site, http://www.puschitz.com He has all sorts
of non-RAC ideas on how to install Oracle on all sorts of RH flavors.
Beware that RH AS 2.1 is bloody old. You may have problems with it
recognizing your newer hardware. Since
ssage-
>From: Ron Rogers [mailto:[EMAIL PROTECTED]
>Sent: Friday, January 09, 2004 12:20 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Re: Books on rac
>
>
>Joe,
> Last year at the midaltantic Oracle users group seminars there was a
>presentation by Mike Ault wha
I've read a couple of the books available on RAC:
- Oracle9i RAC by Madhu Tumma and Mike Ault is decent, I'd give it a 2.5
out of 5. Good multi-platform coverage and decent coverage of the internals.
The book suffers from poor layout/editing. The graphics look like they're
photocopied and the tex
How would you handle the case where there are many sets of privileges,
depending on which user you log in as?
The trigger would give everyone the right to do anything the owner
could to a table. There are times when I want create a "read-only"
account in addition to an app user.
we do allow sqlpl
One interpretation of increased red latch contention
and log buffer space waits is that more work is being
done more quickly - so the log writer can't keep up.
This could mean:
a)the log writer has slowed down
b)the database writer(s) have speeded up, so there
is less
Hi Chris
> Richard,
>
> I agree there are a number of reasons for reorganising
> tables. LMTs remove the
> need to reorganise a tablespace but not to reorganise a
> table. Two further real- ilfe examples of table reorgs:
>
> 1) The purge programs have at last been written and run
> deleting d
Joe,
Last year at the midaltantic Oracle users group seminars there was a
presentation by Mike Ault what was very informative on RAC with a
budget. I believe that he has some decent information available. You
might check www.rampant-books.com for his works.
Ron
>>> [EMAIL PROTECTED] 01/09/2004 2:
AS OF NOW, I have not come across a book which talks about RAC at a
detailed level (at least to the level we expect). There are couple of
books in the market, but they cover very little on RAC (Concepts and
Internals)
But, the Oracle Documentation (At least for the RAC part) is very good
and it
901 - 1000 of 71998 matches
Mail list logo