Hi,
I'm
planning a migration to oracle9i. We are testing on 9.0.1.0 because
we want to
be able to connect with this version to oracle 7.3.4 db.
We started
with 9.2 but found a known bug which prevented to connect to
oracle7.3.4.
Any advice on which version of 9i to go to will be
In my experience, 9.2.0.4 is the best one so far. I don't think that you
should be chosing versions based on 7.3.4 connectivity.
On 2003.10.30 06:09, Jeroen van Sluisdam wrote:
Hi,
I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because
we want to be able to connect with this
Title: Nachricht
Hi Paul,
please see answers below...
1. Is this a stand alone OID or is it part of 9iAS infrastructure or
OCS?
This will bestand alone. Probably we
need to integrate it with Windows Active Directory. Not sure yet. We are still
discussing about it.
2.
Yes, I have seen the MULTIPLE CHILDS PRESENT as
well.
Yet still, how do you explain the high ratio of NONEs.
Surely you/someone isn't running so any DDLs / ANALYZEs etc
when you query V$SQL and find that 1261 of 2733 are NONEs
?
I ran a test where I began a DBMS_STATS.GATHER_SCHEMA_STATS and
Hi List,
I am getting the following RMAN error. Any help would be really appreciated.
RMAN script:-
==
RMAN replace script ts_system_backup
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
sql 'alter system switch logfile';
resync catalog;
Tamizh,
You are probably running out of space in the file-system you
were located within when you invoked RMAN. It would be
better to specify a full path-name in the FORMAT= clause
(i.e. specify directory as well as filename), to make sure
that the file-system where you are creating the
What platform are you running 9.2.0.4?
Thanks
Mladen Gogala [EMAIL PROTECTED] wrote:
In my experience, 9.2.0.4 is the best one so far. I don't think that you should be chosing versions based on 7.3.4 connectivity.On 2003.10.30 06:09, Jeroen van Sluisdam wrote: Hi, I'm planning a migration to
Group,
Tru64 was made for RAC.
If you have the choice: Go Tru64
(just ignore the fact the platform will be decommissioned,
some orgs still run openvms, that was clustering...)
Linux will run RAC, but it will help if
you bring the T64 methods to Linux when setting it up:
- choose a CFS.
-
Title: 10046 trace data question
Thanks everyone for your replies.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts,
how can I splitt a file into many files with tar command.
Rgds.
Arslan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Hi Guys,
We are currently unable to do a full database export as it fails due to dump
file being over 2GB.
Will setting this parameter to unlimited get round the problem?
TIA,
Lisa.
-Original Message-
Sent: 29 October 2003 21:15
To: Multiple recipients of list ORACLE-L
Thanks to
RH Linux 8.0 with 2.4.22 kernel built manually.
On 10/30/2003 09:29:25 AM, laura pena wrote:
What platform are you running 9.2.0.4?
Thanks
Mladen Gogala [EMAIL PROTECTED] wrote:
In my experience, 9.2.0.4 is the best one so far. I don't think that you
should be chosing versions based on
man split.
On 10/30/2003 09:34:38 AM, [EMAIL PROTECTED] wrote:
how can I splitt a file into many files with tar command.
Rgds.
Arslan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network
Gurus
I've applied many of the things I've learnt from this list over the years
and today I tried a 10046 trace for the first time on a reported slow
transaction. From what I can tell the biggest offender is a wait seemingly
associated with rollback (see below) called 'direct path write'. Is this
I
forgot to mention we will be running hp-ux11.11 64 bit, plan to run
oracle also on 64 bit
Jeroen
-Oorspronkelijk
bericht-
Van: Jeroen van Sluisdam
[mailto:[EMAIL PROTECTED]
Verzonden: Thursday, October 30,
2003 12:09
Aan: Multiple recipients of list
ORACLE-L
Onderwerp:
tar to stdout and pipe into 'split'
eg
tar cvf - mydir | split ...
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Thu, 30 Oct 2003 06:34:38
how can I splitt a file into many files with
tar command.
Also found this in my archives, courtesy of Rachel.
Regards
Lee
-Original Message-
Sent: 16 May 2001 22:28
To: Multiple recipients of list ORACLE-L
there is a note out on Metalink on how to do this. You can also break the
export into separate files in later versions of Oracle8i. or
Sorry Lisa,
This doesn't work for export files. Sounds like you are hitting an OS limit.
What are you running Oracle on. You can export to a compressed file via a
UNIX pipe. (if indeed it is UNIX you are running on).
Regards
Lee
-Original Message-
Sent: 30 October 2003 14:39
To:
Hi List,
How to fix this error without changing something in OS level? Is tehre any command to
set max block size in RMAn before we do backup?
Thanks in advance?
RMAN-08031: released channel: c1
RMAN-08031: released channel: c2
RMAN-08031: released channel: c3
RMAN-00571:
Lisa,
Have you're SA set the ulimit to unlimited, or you can use the filesize
parameter in export to break the export into several files.
hth
..JIM...
[EMAIL PROTECTED] 10/30/03 8:39:26 AM
Hi Guys,
We are currently unable to do a full database export as it fails due to
dump
file being over
OK - so I'd not got round to reading a recent previous post on the same
issue, seems tim= is in hundredths of seconds for 8i. So I got that bit of
the answer. Still pondering on those 'direct path write' waits though.
_
Tim Onions
Head of Oracle Development
Speech
There is no version of 32 bit Oracle 9i for HP-UX 11. You have to use 64 bit
Oracle binaries for HP
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 30 Oct 2003 06:49:25 -0800
I forgot to mention we will be running hp-ux11.11 64
I have the impression that Oracle isn't keen on supporting Tomcat with iAS.
Instead, OC4J is supposedly more compliant with J2EE and is faster.
How popular is Tomcat?
Tomcat is being mentioned more and more often at our site, I am wondering
whether we are headed for a collision at some time in
Have you ever considered purchasing Robert Freeman's RMAN book?
If memory serves me right, it does describe MAXPIECESIZE option
to configure and allocate channel commands.
On 10/30/2003 10:04:32 AM, [EMAIL PROTECTED] wrote:
Hi List,
How to fix this error without changing something in OS
I can't provide a solution.
But I do agree with your nomenclature
: Context/Intermedia/Text/whateverTheHell
and ConTerMedText.
I have [or rather HAD] Intermedia/Text setup in an 9iFS 1.1.9 and 9iFS 9.0.1
environment. The IFS_TEXT index was successful for not very many files.
We've given up
you can also use the FILESIZE parameter available in export since 8i
(the only docs I have are for 8.1.7 so I'm not sure if it was available
before that release)
--- Robertson Lee - lerobe [EMAIL PROTECTED] wrote:
Also found this in my archives, courtesy of Rachel.
Regards
Lee
I was thinking about putting together a database that contains a list of
DBAs, servers, databases, and applications. The database would be used
by the Helpdesk and Management to see who is responsible for a given
application or database when problems occur.
I thought I would check first and
Ron
Our help desk people use a software application that is capable of
storing configuration information like this. You may want to check with them
first to see if they already have something you can build on rather than
starting something new. Unless I'm missing something, what you describe
Avnish
Glad to see you are getting some excellent suggestions. We run Lawson
here. Lawson itself uses the database in a pretty simple manner, so that
rules out a lot of stuff, except if you've added customizations of your own.
Lawson uses bind variables, so that rules out some suggestions. I
IIRC, 'direct path write' represents writes to temporary segments.
--- Tim Onions [EMAIL PROTECTED] wrote:
OK - so I'd not got round to reading a recent previous post on the
same
issue, seems tim= is in hundredths of seconds for 8i. So I got that
bit of
the answer. Still pondering on those
Ron:
I have heard of this being done especially in large companies that have
many, many databases. It is difficult to keep track of all the little
details that are spread out all over the company. Having a central data
mart for this information I thing would be very helpful. The only problem I
I think if you are having 32 bit Oracle software, this is the limit. There
is a document on Metalink specifying export dump size limits with 32 and 64
bit software. Other listers already suggested you couple of options to
resolve this issue.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To:
Tamizh,
To set the limit on the size of the output file use
set limit channel d1 kbytes=30; for a 3 gig file .
Ron
[EMAIL PROTECTED] 10/30/03 10:04AM
Hi List,
How to fix this error without changing something in OS level? Is tehre
any command to set max block size in RMAn before we do
Title: RE: sqlplus prompt question in 9i
It could be your sql
Here is the prompt I have been using for a while with no problems at all
If the db is down you get a prompt of
Nolog
set termout off
define new_prompt='nolog'
column value new_value new_prompt
select SYS_CONTEXT('USERENV',
We recently signed a corporate agreement with Oracle that basically
gave us a named-user license for every person in the company. Now,
we have databases sprouting like rabbits. Our four-dba team now
is supporting SAP, two different Siebels, a data warehouse, and
myriad other projects - over 200
Looks sort spillage to disk due to the where clause.
Andy Rivenes
[EMAIL PROTECTED]
At 06:44 AM 10/30/2003 -0800, Tim Onions wrote:
Gurus
I've applied many of the things I've learnt from this list over the years
and today I tried a 10046 trace for the first time on a reported slow
transaction.
Is there any tool out there that can convert pro*c
codeto pl/sql ?
thanks,
-ak
Just a quick reply to this.
You are, in fact, formulating the sort of request which would be input to a
corporate data architecture. We have built such a thing, and it includes the
issues you refer to. More importantly, we have identified who is responsible
for every single piece of data in the
It looks like you need to SET LIMIT ... for the channel allocation, if
8i, to less than 2GB. In 9i this can be set with MAXSETSIZE (not sure if
SET LIMIT is still supported in 9i).
Note that you cannot back up a file larger than the SET LIMIT size, so
based on your ulimit command I assume
List , I am using Oracle enterprise edition 9.2.0.1.0 on windows.
I was trying to write the equivalent for a rollup , using grouping sets.
This works :
select dept_id, title, sum ( salary ) from s_emp where dept_id 35 group by
grouping sets ( (dept_id , title ) );
This also works :
select
List, here is a rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
Please see the official ORACLE-L
List - If a manager seems to be contemplating outsourcing, you might want to
post this. Unless you work for an outsourcer. ;-)
http://techupdate.zdnet.com/techupdate/stories/main/Hidden_Costs_of_IT_Outso
urcing.html
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the
Hi, Tim,
Assuming you don't have more than 1000 files, what's your db_files set to and
what's select file#, name from v$tempfile? If you do have more than 1026 files,
select file#, name from v$datafile.
Also show us select * from v$sort_usage if you can run that DELETE again.
XCTEND rlbk=0:
Ken, Ron
I think the most important step is to ask some very hard questions about
what data you really need. From what I've seen (and been involved in), you
begin with a burst of enthusiasm and tend to collect far too much data. Then
you can't keep it all updated, so the data tends to get
Hello listers,
At OW, SF RAC users, IOUG and Oracle put their heads together to launch a new RAC-SIG.
IOUGhas started aRAC-SIG list server for its members.http://www.ioug.org/ioug_p/dynamic_pkg.show?v_name=DISPLAY_RAC_SIG
Last week the RAC-SIG took a global turn, it wasofficially launched
If you did not commit the inserts to dual, then everyone will only see one
row.
If you committed the data and still one row appeared, then you must have a
row defined for dual.
Suggestion: Don't add more rows to dual if you value your dba life.
Thank You
Stephen P. Karniotis
Technical
Actually there is. It is called a consultant.
Because of the mush within 3GL languages, it would
be extremely difficult for a tool to convert.
Thank You
Stephen
P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313)
227-4350
Mobile: (248)
408-2918
Email:
Yong:
They are temp files. The file# for the temp files start with db_files+1.
Because of this, there may be chances your pl will have 1000+ though you
have only hand ful of datafiles.
KG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday,
Does not really fit into their open source initiative. Anytime we mention
Tomcat as a supported product for our tools, Oracle's prod. Management team
cringes. They are not seeing between the lines that the app server has more
stuff than most organizations desire; tomcat solves most requirements.
I have seen something of the kind done at one of my large customers (600+ databases,
Oracle + Sybase), where I have had more than a hand into the Oracle part (the
inventory is stored in *blush* Sybase) and I am working on something similar with a
colleague elsewhere, where there are _only_ 80
With Oracle, quality always ends with the number 4.
6.0.38.4
7.3.4
8.1.7.4
9.2.0.4
Mladen Gogala
What is also unfortunate that the company X which outsourced its project to India,
didn't do its job right ... If you just want the cheapest Rolex, you can't complain
about its quality later on. I am not saying this couldn't have happened, whatever
happened is unfortunate, but I am just saying
Ron,
As you may have seen already, some issues have been pointed out. However,
there are deeper issues... :(
Databases need to run on Servers - these servers in turn rely on other
services below them, namely Disk infrastructure (such as SANs, NAS, Switch
fabric, etc.) as well as other networking
Straight from the TUSC Oracle Performance Tuning Tips Techniques
book, pp 439-440.
This
is supposed to help reduce the number of network trips for Forms
applications.
My
problem is... I don't know what this "bad" thing is supposed to look like from
the server side.
Is
there a standard
Hi.
I have created a field in a table with a default
clause. - f1 number(1) not null default 1. How can I
get rid of the default now?
thanks
Gene
__
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
--
Please
Ends in 4? Unless you are trying to use Heterogeneous Services (HS) under
9.2.0.4 on an AIX 5L system. Then you are waiting for Oracle development to
issue a patch.
(Not that I am running into this situation or anything. And I'm not bitter
:)
FYI, 9.2.0.3 is the ONLY 9.2 version for AIX that HS
Exactly per your last point - licensing is a big Goose
Egg.
We've just completed a whole suite of Cognos tool
installs and Cognos are pushing Tomcat. They're app
server is now standardized on Tomcat. I talked to one
of the analyts onsite here and he mentioned that they
are moving away from IIS
Do you have any technical details on this Consultant package?
What version, is it stable, what products does it work with? ...
;-)
boss
Actually there is. It is called a consultant.
Because of the mush within 3GL languages, it would be extremely difficult
for a tool to convert.
default null
-Original Message-
Sent: Thursday, October 30, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
Hi.
I have created a field in a table with a default
clause. - f1 number(1) not null default 1. How can I
get rid of the default now?
thanks
Gene
Is it a freeware :)
-ak
- Original Message -
From:
Karniotis, Stephen
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 30, 2003 9:24
AM
Subject: RE: proc to pl/sql
Actually
there is. It is called a
consultant.
Because
of
I believe your only option with the alter table command is to set it to
null (which it can't be on an insert that doesn't provide a value since
the column is set up as not null).
ALTER TABLE table_name
MODIFY (column_name DEFAULT NULL);
-Original Message-
Sent: Thursday, October 30,
Olga Gurevich wrote:
I have created a field in a table with a default
clause. - f1 number(1) not null default 1. How can I
get rid of the default now?
Oracle9i SQL Reference
Release 2 (9.2)
ALTER TABLE
column_clauses
add_column_clause
If a column has a default value, then you can use the DEFAULT
It's because we designed it that way. In earlier releases (can't remember
the specific version we brought this in with), you could put more than one
row in DUAL and then select them all, but all the things that should have
returned only one row then failed with a 1403 (?) error - single row query
Hi, Gopal,
Now I know where you are! I just joined this list. I left here two years
because of too much spam (off-topic messages).
I know that number is db_files + tempfile#. But if he indeed has 1026
datafiles, p1 *will* be file# in v$datafile.
Yong
--- K Gopalakrishnan [EMAIL PROTECTED]
Yeah right ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original
Tim,
As you have seen, this is due to writes to and reads from the TEMPORARY
tablespace of that user. This could be due to both SORT segments
(SORT_AREA_SIZE overflow) as well as HASH segments due to HASH Joins going
to TEMP when they overflow HASH_AREA_SIZE. This can be seen from
You may find this interesting.
Looks like a 'where rownum = 1' is always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo
List,
This question is for anyone using RMAN with Oracle 8i and Failsafe on
Win2k.
What will happen when the primary node fails and Oracle Failsafe
switches to the other node while RMAN is runningg.??
Will the database come up or it will not be able to??
Thanks.
Yuval
This transmission
Yuval,
I'm assuming you are running Microsoft Cluster Services.
Are you running the Rman backup on the cluster, or on the physical box?
Either way, I think your Rman backup will fail, but the database will come
back just fine. Rman simply has a connection attached to the database
running on
John/Tim,
The 'direct path read/write' are for cursor #14. The delete is cursor #15.
Check the trace file for the preceding cursor #14.
Paul
-Original Message-
Sent: Thursday, October 30, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Tim,
As you have seen, this is due to
Hi John, don't know other than what you have speculated on. We would have
to have more info to investigate further.
Andy Rivenes
[EMAIL PROTECTED]
At 10:39 AM 10/30/2003 -0800, you wrote:
Tim,
As you have seen, this is due to writes to and reads from the TEMPORARY
tablespace of that user. This
Do you think it
will work if it has no rows ?
Waleed
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003
1:44 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: dualYou may find
this interesting. Looks like a
'where
There are tools on the market that discover that for you. They will detect
what databases and what applications use them for you automatically.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
I have seen many databases crash, yes crash, when
dual had more than one row or less than one?
Why you say?
As someone pointed out, this was an internal table to the kernel so
Oracle used it as they felt. It
was and still is considered a heartbeat mechanism within the kernel. In other
Hi, Tim,
John has good input. You can't conclude that your DELETE requires a sort.
v$sort_usage (or preferablly v$tempseg_usage beginning with 9.2) shows all
types of usage of temporary segments. If the segtype column says it's 'SORT',
the session is sorting. If it's 'HASH', it's hashing. For
Aren't the key features of Tru64 (trucluster, advfs) being ported
to HP-UX, so there is some hope that the success I have had with
Tru64 will show up in HP-UX.
That's if we stay with Unix as opposed to moving to Linux.
-Original Message-
Sent: Thursday, October 30, 2003 5:58 AM
To:
So, when you look for the segment_type,segment_name,owner in dba_extents,
what do you see for file_id=1026 and block_id's as listed in p2?
On 10/30/2003 09:44:25 AM, Tim Onions wrote:
Gurus
I've applied many of the things I've learnt from this list over the years
and today I tried a 10046
Thanks, Paul. Your message is more insightful than John's and mine!
Sometimes it's too easy to see the tree without seeing the woods.
Yong
--- [EMAIL PROTECTED] wrote:
John/Tim,
The 'direct path read/write' are for cursor #14. The delete is cursor #15.
Check the trace file for the
Does anyone have any statistics about
overhead associated with using the Signon Audit in an 11.0.3/ 8.1.7.4/8.0.6.3
environment. We are using full installs of AP, GL, FA and CE. Size
of the production database is 100G. Can't tell you exactly what we'd
be auditing; we are under siege by Internal
The perception of outsourcing has been that you can send your work offshore,
and get it done cheaper, with higher quality.
I think that this article helps to dispel that as a myth. It may or may not be
less expensive, it may or may not be better.
Jared
Jamadagni, Rajendra [EMAIL
Didn't try no rows. I imagine all kinds of things would break.
Khedr, Waleed [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 11:04 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: dual
Do you
Same is true for getting the 'cheapest' price for a project that just
requires a contractor to work in house. SOMETIMES you get what you pay
for, and (from what I understand) occasionally what you
deserve.
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \
Thanks
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 23:49
It's because we designed it that way. In earlier releases (can't remember
the specific version we brought this in with), you could put more than one
row in
I have observed 2 rows in dual till version 7.3.4. All application using
dual in their logic having more than 2 rows were giving wrong results. Quick
fix was to track it and delete more than one row(s). Duplicate import of
sys/system stuff were known to be culprit.
Regards
Rafiq
Reply-To:
Thanks lisa
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 20:54
His essays are still available here
http://www.geocities.com/lydian_third/
Lisa.
-Original Message-
Sent: 23 October 2003 15:04
To:
But sure as hell does drive salaries down over here.
On 10/30/2003 03:04:24 PM, [EMAIL PROTECTED] wrote:
The perception of outsourcing has been that you can send your work
offshore,
and get it done cheaper, with higher quality.
I think that this article helps to dispel that as a myth. It
consultants work with any product. they like to get paid so that they can
eat. they are relatively stable, and are just looking to get along.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, October 30, 2003 1:04 PM
To: Multiple recipients of list
[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
Do you have any technical details on this Consultant package?
What version, is it stable, what products does it work with? ...
consultant version bill1.0 is stable having been in production since 1968,
all reported installations of
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003
3:09 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: dual
Didn't try no rows. I imagine all
kinds of things would break. [Shrek]
yes
they will... trust me.
Total Pages Examined : 1280
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 1
Total Pages Empty : 1279
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages marked corrupt:
Just to say thanks to all who replied- Waleed,
Valdimir. Govidan. sorry if i missed anyone
Gene
--- Khedr, Waleed [EMAIL PROTECTED] wrote:
default null
-Original Message-
Sent: Thursday, October 30, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
Hi.
I have created a
On a
Unix system, you can "tput reset" to clear up that mess after viewing a binary
file
by
accident.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 02, 2003
3:39 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: alter
It is true, auditing adds significant overhead, but not session auditing.
Significant overhead is added by DML auditing because you ad significant
amount of modified blocks to every transaction you audit, you are using space
and additional CPU cycles. It can add to much more frequent checkpoints,
Title: RE: Outsourcing's dirty secret
not only salries, but job opportunities as well:-)
greg
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 30, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Outsourcing's dirty secret
Hi DBAs,
Oracle 9.2.0.1
Win 2000
In Enterprise Console there is an option to produce a report on either 1
Database Configuration Report or 2. Database Status Report. When
I choose either on I always get 3% complete and amount of time thusfar just
keeps going. I never get a report and never
Vicki,
As long as your *Purge* Audit signon data, I really do not see any
significant overhead. We have a 200 Gb DB and see no issues. What level is
your Profile set to? The advantages of Signon Audit far outweighs the load
it places - for e.g. you have no other way of seeing which user is logged
I encountered the same problem once many years ago, for the same reason.
Quite a pickle for a newbie - OWW bailed me out on that one. :)
Jraed
M Rafiq [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 12:29 PM
Please respond to ORACLE-L
To:Multiple recipients of list
Paul
Oh well spotted, I'd completely missed that, cursor #14 is MUCH more complex
and would require a fair degree of sorts.
Thanks
T¬
_
Tim Onions
Head of Oracle Development
Speech Machines (A MedQuist Company)
..the speech-to-data Application Service Provider
Title: RE: DBA Support Database
I'll throw in my *very expensive free* comments...
expensive free comments
This begins to create the corporate metadata and architecture as Peter mentions. We are on this road, and there are several tools that can do *auto discovery*. There are some very nice
Hi
Vicki,
We're
not running 11.03 (we're on 10.7) and we have auditing running for sign-on audit
set for Responsibility (so we get recorded what responsibility they're using).
We were running it set for User so that the DBAs could use that information to
get back who was running what. In
1 - 100 of 138 matches
Mail list logo