Hi Sesi,
BEFORE_REPORT_TRIGGER is fired before sql statement is executed, so you
can't abort your report execution here by using that trigger.
HTH,
Sony
> -Original Message-
> From: Sesi Odury [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 21, 2003 4:19 AM
> To: Multiple recipients
You think that's good? Try this one...
Me
---
RedHat Linux 7.2 Oracle 9.2.0.2
dbca *always* hangs at 41% - "Creating and starting Oracle instance".
No background process ever gets started - no pmon, no smon, nothing.
This is regardless of kernel parameters, memory or any other such stuff.
Runnin
Did you try with a 10046 trace? Could it be an array vs. non-array fetch
thing? Which client environment are you using to fetch the rows from the
ref cursor?
There is no init.ora involved with this.
/Bjørn.
Bahar, Rivaldi (BBASSI-CHQ) wrote:
Hi Listers,
Is there any specific parameters
Hi all
I have a problem when doing an export in one of ourt production
databases. The export fails with ORA-01555, snapshot too old error.
I have increased the number of rollback segments and their sizes on
the database. Also I have went to an extent of specifying the
parameter constent=n on my s
Hello AllThe
link below contains a summary of my experiences in installingOracle Apps 11i
(11.5.7) on Linux (Redhat 8.0 and SUSE 8.1Professional).I'm posting
it because I would really have appreciated being able to read something like
this prior to starting my installation
:-)http://databee.
I'm getting the following error while trying to select from table using dblink:
ORA-02046 distributed transaction already begun
Thanks
Manoj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
Dale,
thanks for sharing, this is going to be pretty useful in the future. I read
the warnings and had a copy of Suse 7.0 at home so I've only ever installed
it onto the recommended platform. Armed with your summary I may have a shot
at installing it on 8.1.
Cheers,
Mike
-Original Message-
Jackson,
As you have discovered , the issue is that other transactions are
overwriting your read consistent view of the tables.
Options could include
1) Running the export at a quite time (sounds like you have tried that but
with only partial suucess)
2) Taking a direct export which reduces the tim
Hi All
We are having this major problem when we are trying to install Oracle
9i software on HP-Unix 11. It just hangs when it's linking, please
help as we need to upgrade our production databases to 9i.
Check here :
Installing oracle 920. On linking getting the ff error :
Error in invoking iora
Now I know where they got my e-mail...
Pat.
-Original Message-
Sent: Thursday, February 20, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L
Sorry all, this was supposed to go to the OT list!!
Mark
-Original Message-
Sent: 20 February 2003 09:22
To: Multiple recipients of
Title: Message
Perhaps because no matter how many courses people attend, they won't
learn how Oracle works without administering it in a real environment for a
prolonged period of time.
No
database of previously reported cases can make technicians learn how to
troubleshoot -- they must hav
Title: RE: Endianness using External Tables
Hi
Melissa
Yes, I
tried to do the same on a Windows PC today, but the results are the same (wrong
byte order).
Any
other ideas ? I already reached the point, where I wrote a function, that
converts the wrong integers back to hex and these back t
Dear Listers,
Oracle 8i HP-UX11.
We have a database link with a remote database which is accessed from the
application code. In the application code, a call is made to the
'dbms_session.close_database_link' procedure (that is what they claim!!).
We want to track the call to the database link and
Title: RE: HPUX SCSI Performance
It turns out it's a bug with vxfs on
all Itanium system's
HP is starting to work on a patch for it hopefully
it'll be out soon
Thanks for the input though.
David Hill
-Original Message-
From: Rich Holland
[mailto:[EMAIL PROTECTED]]
Se
I logged a TAR on Tuesday for the 9.2.0.2.0 patch on Tru64, same error --
turns out there is a shell memory allocation limit being reached.
161328.1 Relinking Oracle 9i on True64/HP-UX/Sun Fails With Out of Memory
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations
Review and increase kernel parameters maxtsiz, maxdsiz, maxssiz (maxtsiz_64bit,
maxdsiz_64bit, maxssiz_64bit). It is possible that maxssiz (process stack space) is
too low, and hence 'Out of Memory'.
Refer to HP-UX Oracle Installation Guide for some guidelines to select proper values
for these
Title: Message
I was asked of a
problem in a friend's site about replication.
The
problem.
They implemented
replication using Materialized Views with an refresh update of ON DEMAND and
some immediate. It works for some days and suddenly some MV stop
replicating.
He has checked
metal
Hello,
We have an Java application wich is establish a database connection
via JDBC driver,
by using a parameter file:
---
#JDBC_Driver=oracle.jdbc.driver.OracleDriver
#JDBC_URL=jdbc:oracle:thin:@chicago.eos.elro:1521:dgesten
#JDBC_User=...
#JDBC_Pa
If on UNIX, running the oerr utility can be helpful to quickly find a bit more
information about ORA errors: (I do not know, what's available on Windows).
df2hp105 [oracle] => oerr ora 2046
02046, 0, "distributed transaction already begun"
// *Cause: internal error or error in external trans
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This
that's it.
Thanks Jared.
Pat.
-Original Message-
Sent: Friday, February 21, 2003 2:34 AM
To: Multiple recipients of list ORACLE-L
Not necessarily. If you're backing up vxfs with Veritas Netbackup
and also have someother component from Veritas that I can't recall
at the moment, filesy
Jared,
No they do not have to begin with 1 and in fact my 10 groups are currently
11 - 20. I too have rearranged/reorg'ed redo logs while the database was
up. Mostly with success, but in one case linesize was too short when I
built my script and production (V7.3) was briefly left with only one re
Hi Kirti,
We are on v8.1.7.2 32-bit on IBM 4.3.3. I am not sure should we have to
apply the 8.1.7.4 patch? Sometimes just read the note is very confusing,
so just apply this patch to upgrade to 8.1.7.4?
Joan
"Deshpande, Kirti" wrote:
>
> Hello All,
> If anyone successfully applied this patch (f
I lost a data file that contained the tablespace for an empty partition. I
dropped the datafile from Oracle, and the table itself seems okay, but I'm
wondering what I can do with that partition. Can I simply merge that
partition with another partition? Any ideas especially if you've encountered
a s
You might not have to increase the tablespace size. Maxextents = 121 is
likely to be a bigger part of the problem. Query dba_tablespaces and
look at your intial and next values as well as your maxextents
parameter. You might find you have enough datafile space and are
choking on the default stor
You might try running hot backups at the OS level instead. It sounds
like your export is just taking too long. To get it to work with active
users on board you might have to increase your rollback segments to
truly ridiculous levels especially if you have large batches running
while the export is
go
get'm big dawg In all honesty, this was educational to me as I'm not
sure that a lot of people understand the process for the selection.. I have
learned something today. And once that's accomplished, I need to celebrate.. So
now I can go home and drink beer for the rest of the day:-)
Title: Message
Is the MV set up for FAST REFRESH or
COMPLETE?
If FAST REFRESH, check to see if the tablespace of
MV Log table, named MLOG$_ where is the first
20 characters of the table on which the log is based, has enough space for the
mlog$ to grow.
If complete refresh, do it manuall
I'm trying to isolate high CPU consumers in a stressed application, and have noticed
that I'm spending a lot of time doing recursive calls. Specifically, a high
percentage of recursive calls and recursive CPU usage come from the following
anonymous block:
DECLARE job BINARY INTEGER :=job; nex
Now this thread has gone on for a while so its time for my contribution
:-). PL/SQL is such a necessary although pedestrian language that its
not interesting. Of the scripting languages TCL, PERL, and Python all
include facilities for embedding them into other code or adding other
code to them.
No problem. If you can figure out a way to install it without using that
ugly little adcrdb.sh hack that I had to do I would really appreciate you
telling me. Except for that bit the install isn't too bad.
Cheers
- Dale
> thanks for sharing, this is going to be pretty useful in the future. I
read
Dennis,
Why not just drop the partition?
Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 9:19 AM
> I lost a data file that contained the tablespace for an empty partition. I
> dropped the datafile from Oracle, an
It is likely that you will have to rebuild your kernel. If you start
sam as root and go to kernel confiuration -> configurable parameters you
will find parameters named maxssiz and maxssiz_64bit. Adjust them to
allow the stack enough space to perform your link. Note that you will
only need to ad
Charu,
The view V$DBLINK can show you if the link is in use.
select open_cursors, in_transaction
from v$dblonk
where db_link = 'mylink'
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 8:03 AM
> Dear L
FORTRAN - Only one or two of us left that have even heard of it, much less
actually made $$$ using it
Rick Weiss
-Original Message-
Sent: Thursday, February 20, 2003 10:59 PM
To: Multiple recipients of list ORACLE-L
Assembler.
On Wednesday 19 February 2003 03:33, Robson, Peter wrote:
Title: need to compare long data against varchar2
I need to devise a method of comparing the TEXT column of dba_views against varchar2.
End result I want to find the views that reference a particular table within its text.
example (which ~obviously~ will not work):
select view_name
from dba_
V$dblink
-Original Message-
Sent: Friday, February 21, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
Dear Listers,
Oracle 8i HP-UX11.
We have a database link with a remote database which is accessed from
the application code. In the application code, a call is made to the
'dbms
Hey, just a minute - aren't you forgetting Dos... ?
peter
Now this thread has gone on for a while so its time for my contribution
:-). PL/SQL is such a necessary although pedestrian language that its
not interesting. Of the scripting languages TCL, PERL, and Python all
include facilities for e
If
there is a demand, I will be happy to expound at some length
on the
processes by which the papers for our track were chosen,
but I
do believe that a different forum might
be
appropriate, as we are getting a bit far off the main
topic
of how to manage Oracle technology.
We
spent las
There's a note on metalink that covers some of the relevant parameters:
68105.1 'Commonly Misconfigured HP-UX Kernel Parameters'.
9i is a lot more resource hungry than 8i, and you need to make sure you
have the right HP-UX patchsets.
Cheers
Simon Anderson
"Deshpande, Kirti" <[EMAIL PROTECTED
> I will echo Joe's sentiments on knowing the command line.
>
> It has the added benefits of not doing things you were unaware
> of after pushing the 'go' button, as the much better understanding
> of RMAN you will attain by learning to do it from the keyboard.
>
> Jared
I'll echo Jared's comments
I would echo a previous post that you can't backup a database with the
export utility. I suspect you get your error because you are using
consistent=y in the export. The database is trying to give you data as of
the time you started the export. The fact that you are getting the snapshot
too old
Just had a thought here, have not tried it yet. I have a database that I am
working with that is generating 28 GB of redo each day. I would really like
to know what objects are generating all this redo without going through the
hassle of mining a bunch of log files. It occurred to me that if tab
Ethan - 28-gig GAAAK!
Ideas:
1. Sample your SQL buffer to start getting some ideas.
2. Use LogMiner to read some of the archive logs to see the DML
statements. You can also directly see how much redo is being generated by
each statement.
I think you have the right idea, probably some in
Jackson,
I can't say it for HP-UX, but in Tru64 Unix, a cousin-in-law of HP-UX, the
error can occur if the ulimit is set too low. Check MetaLink Note 166350.1
for information on how to check and set the ulimit.
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE
check dba_2pc_pending, there may be entries in there.
Oracle follows the 2-phase commit method when queries are submitted from
stored programming units, it is default behaviour that cannot be changed.
We ran into this with a Web application that was doing remote querying, and
Oracle said the only
Title: FW: need to compare long data against varchar2
This worked for me. I got the getlong code from a post by ORACLEtune on expertsexchange.
select object_name
from dba_objects
where object_id in (select obj#
from sys.view$
where getlong('sys.vi
Add me to the count.
Though, I was making "rubles" not $$$ using it -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 9:49 AM
> FORTRAN - Only one or two of us left that have e
I heard from ORACLe sales person "the ORACLE 9ir2 RAC come with ORACLE
cluster and we don't need SUN cluster". I don't know is it true or NOT?
anyone implement that?
Thanks.
_
--
Please see the official ORACLE-L FAQ: http://ww
> Now this thread has gone on for a while so its time for my
> contribution
> :-). PL/SQL is such a necessary although pedestrian language that its
> not interesting. Of the scripting languages TCL, PERL, and Python all
> include facilities for embedding them into other code or adding other
> co
It wouldn't be too difficult to craft a solution using the to_lob
function, global temporary tables and the owa_pattern package.
Read the docs on to_lob, and you'll see that it's functionality
is limited to use with inserts, hence the use of the global temporary
table, though not strictly necessa
Yeah Yeah Yeah !
peter
.
FORTRAN - Only one or two of us left that have even heard of it, much less
actually made $$$ using it
Rick Weiss
-Original Message-
Sent: Thursday, February 20, 2003 10:59 PM
To: Multiple recipients of list ORACLE-L
Assembler.
On Wednesday 19 February
Title: RE: Endianness using External Tables
It's
pretty inconsistent. Using just "DATA IS BIG ENDIAN" and "BYTEORDERMARK
NOCHECK", it usually doesnn't work, but I also got cases, where it actually did
work. The DDL scripts are generated and the data looks the same.
I used
SQL*LOADER now an
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC
System/6000: Version 2.3.4.0.0.
I know there is SQL that allows setting a data file to auto
extend. I am trying to find out where in the data dictionary you can find
out whether a data file is set to auto-extend or not. In later ver
RMAN is cool. Especially in 9i since everything is automated, as in
channel allocation and such.
RMAN in 8i was a bit painfull since a couple of steps were manually
necessary.
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: [EMAIL PR
It's interesting you should mention the
'select for update' in this context.
I'm still working on a puzzle where
I do:
create table t1 (n1 number);
insert into t1 values (0);
insert into t1 values(1);
commit;
select rowid from t1 where n1 = 0;
for i in 1..1000 loop
update t1 set n1 = n1 +
On Fri, Feb 21, 2003 at 06:43:48AM -0800, Joan Hsieh wrote:
> Hi Kirti,
>
> We are on v8.1.7.2 32-bit on IBM 4.3.3. I am not sure should we have to
> apply the 8.1.7.4 patch? Sometimes just read the note is very confusing,
> so just apply this patch to upgrade to 8.1.7.4?
Frankly, I don't think
Hi,
The simpler approach is to check the user level redo (or session level
redo) using the v$sysstat,sesstat views and you can find the programmes
associated with those huge (!) redo.
Dumping the redologs and analyzing is just complex when you have a
simple solution ;)
=
Have a nice day !
It might work to turn on monitoring on the tables.
alter table xyz monitoring;
Then periodically check dba_tab_modifications.
> -Original Message-
> The goal is to identify the objects, then identify the jobs
> that work on
> those objects and see if I can reduce redo. I suspect a lot
There are 2 issues here. First the error. What version of Oracle are you
using? Is the TEMP tablespace set up as TEMPORARY? What block size are
you using (impacts max extents on older versions of Oracle)? If you are
not the only user on the system, you must also account for other sorts
that are
Hi DBAs,
Oracle 8.1.6 WinNT
I am trying to understand how Oracle Names is configured. We have a Oracle
Names database on server 1.
We also have 2 other oraclenames services on server 2 and 3. I understand
how server 1 was created and works.
What I do not understand is the services on server 2 an
Title: RE: Programming languages that make DBA's lives easier
I much pefer Oberon or Scheme.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
We have enough youth.
How about a fountain of intelligence?
-Original Message-
From: Weiss, Rick [mailto:[EMAIL PROTECTED]]
Sent: Friday,
Title: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
oops.. Just talked with the good old Veritas/Sun boys
the software would need to be there to handle and configure the inter-connoect:-)
-Original Message-
From: Loughmiller, Greg
Sent: Friday, February 21, 2003 1
Joan,
You may want to log in an iTAR to find out if this patch can be applied to 8.1.7.2.
The note said it was for 8.1.7.4 and I have been applying it to only 8.1.7.4 software
on our servers. Other lower versions of 8.1.7.x are not patched, as we are upgrading
those databases to 8.1.7.4.
HTH,
Which version of Oracle ?
Has someone switched on supplemental logging
at the database level, perhaps ?
Have you got dbms_job kicking in every 5 seconds
with job_queues set to 10 ? (Honest, I have seen
it happen, and the effect on redo was astonishing -
and there was only one job actually ever
Darn!!
I had taken a hasty look at 'Oracle 8i reference', before posting the query.
Not my day today.
Thanks Allan.
Regards,
Charu
-Original Message-
Allan
Sent: Friday, February 21, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
V$dblink
-Original Message-
Sent: Frida
Title: Message
IIRC, you needed FILE$ or FILEXT$ - something like that anyway (those
brain cells are long gone, I'm afraid!)
Pete
"Controlling
developers is like herding cats."
Kevin
Loney, Oracle DBA Handbook
"Oh
no, it's not. It's much harder than
that!"
Bruce
Pihlamae, long-term Orac
Is it smiliar to FORTKNOX ? I heard that there are also big bucks to make.
Stefan
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: [EMAIL PROTECTED]
Please remove nospam to contact me via email.
visit our website: http://www.bov.de
subscri
You're welcome.
Since you're interested in that, Veritas can also backup
databases in the same way, though we don't have the
product for that.
Block level incrementals without RMAN. Pretty cool
stuff if you ask me, provided recovery is as simple as it
is with RMAN. They can work magic when the
Title: AIX question
AIX 4.3.3
Can anyone tell me if there's a command to determine what volumes/disks are on each controller?
I'm way out of my element here but the SA for this system is scarce.
Thanks for any suggestions, and have a great weekend everyone
Lisa Koivu
Oracle Database
Title: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
news to me... Just had a conversation with several folks yesterday.. The requirements that we have been told are:
1. File systems-use veritas Cluster manager
2. Raw Devices - Gotta use the SUN Cluster 3.x
So I assume thes
FYI... I think BLIB is the tool you're thinking of... It stands for Block
Level Incremental Backup...
Tim
-Original Message-
Sent: Friday, February 21, 2003 1:34 AM
To: Multiple recipients of list ORACLE-L
Not necessarily. If you're backing up vxfs with Veritas Netbackup
and also ha
I believe this is true for Linux platform only.
-Original Message-
Sent: Friday, February 21, 2003 8:16 AM
To: Multiple recipients of list ORACLE-L
I heard from ORACLe sales person "the ORACLE 9ir2 RAC come with ORACLE
cluster and we don't need SUN cluster". I don't know is it true or
Whoever told you that must have been on some new form of drug.
RAC runs on top of cluster software from the vendors. The cluster needs
to be working before you can install RAC. How you do that without the
OS cluster software is beyond me.
Pete
"Controlling developers is like herding cats."
Kevi
In addition to the other comments about export not being a backup, let me
add a few things. Managing the trade off between many rollback segments
(good for oltp performance) and large rollback segments (necessary to avoid
1555) is often a tough one. As somebody else said, you can optimize exp
Title: RE: Programming languages that make DBA's lives easier
For some reason http://mindprod.com/unmain.html comes to my mind.
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any c
Ethan,
> monitoring is active and my stats are up to date I should be able to
> multiply the total number of updates, inserts and commits by
> the average row
> size and get a rough % of what objects are generating the most redo.
Note that the amount of redo does not depend on the average row
Title: need to compare long data against varchar2
Mark
Not that I have an answer for you, but what about
synonyms to tables / views being referenced ?
Ferenc MantfeldDreaming costs you nothing. Not dreaming costs you
everything.
- Original Message -
From:
Markham, Richard
LOL
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 8:39 AM
> > Now this thread has gone on for a while so its time for my
> > contribution
> > :-). PL/SQL is such a necessary although pedestrian language that its
> >
So here are two takes at the problem, one takes a look at costly (in regards
to amount of redo) tables and the other indexes. Note this is only a way to
guestimate this information.
select owner,
table_name,
round((ratio_to_report(ttl) over ()) * 100, 1) as percent_ratio
from (
Title: Message
Thks
Arup, I'll let him know those points.
Tks
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Arup NandaSent:
Friday, February 21, 2003 10:30 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: Replication
Is th
Title: RE: Oh Where Oh Where Is My Redo Coming From
Ethan,
I think focusing on which transaction generates more redo will be more helpful than which object ... right?
Let me know if I didn't understand your question completely ...
Raj
--
Indexes on such tables which has DML...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 21 Feb 2003 07:44:18 -0800
Just had a thought here, have not tried it yet. I have a database that I am
working with that is generating
Rick,
NAMESCTL is your best friend here. Look up notes 113036.1 and 60535.1 on
Metalink (I have stopped referring to ML as MetaStink and MetaBlink!)
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
Disappointment is inevitable, but Discouragement is optional!
** The opinion
select * from filext$;
AFAIK an entry here means this file is now in auto-extend mode.
HTH & YMMV
HAND!
"Sam Bootsma"
I think thats the goal of .NET CLI. Write in anything ... mix and match.
On Fri, 21 Feb 2003, Nelson, Allan wrote:
> Now this thread has gone on for a while so its time for my contribution
> :-). PL/SQL is such a necessary although pedestrian language that its
> not interesting. Of the scripti
Does Oracle have punch cards with their logo on them?
How do we order some? We need some for our Fortran applications...
; )
Pat.
-Original Message-
Sent: Friday, February 21, 2003 10:49 AM
To: Multiple recipients of list ORACLE-L
FORTRAN - Only one or two of us left that have even h
Yes, that is correct. SUN Cluster is not needed for Linux.
> -Original Message-
> From: Molina, Gerardo [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 21, 2003 12:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: [Q] ORACLE 9iR2 RAC on SUN server no need for
> SUN Cluste
Your Oracle sales person is incorrect. I would ask him
to see if he can actually prove it.
Oracle provides clustering components for Linux and NT
only at this time. Oracle does provide a RACpatch for
SC2.2 and 3.0 with 9iR2 and that patch needs to be
installed after you install SC and before inst
Ethan,
v$sess_io will provide a list of the sessions generating block
changes and, therefore, redo. Link this back to v$session, etc. for the
'offending' sessions, sql. I've used this several times with great
success. Sometimes it was a data load, others it was bad sql.
When you change a b
Greg, Sorry to be picky but you can still use raw
Devices with Veritas DBE/AC 3.5 if you don't want to
use thier CFS.
If you use SC then your only choice is raw and you
probably will need Veritas to manage you LVM's anyway.
Scott
--- "Loughmiller, Greg"
<[EMAIL PROTECTED]> wrote:
> news to me..
Yes, that is what I was saying, however large rows or tables with a lot of
indexes would also be prone to generate more redo, that is why I suggest
joining DBA_TAB_MODIFICATIONS to DBA_TABLES to get avg_row_len and
DBA_IND_COLUMNS to get the total # of columns indexes on the table, the
thought bein
Stephen,
My understanding is having consistent=y uses no rollback, since the changes
occurring
during the export are not being captured in the export dump.
on few occasions i've still got the spurious ora-1555(snap shot too
old)error on exporting a 80GB highly
transactional database which termina
richard,
select name
from user_dependencies
where referenced_name =
and type = view
chaim
"Ferenc Mantfeld" <[EMAIL PROTECTED]>@fatcity.com on 02/21/2003
01:14:00 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L <[EMAIL PR
Sure that is the way I would typically do it, but in this case I have an
application that is running 8000 batch processes per day, redo is very
consistent for most of the 24 hours. I asked myself what is the simplest
way to figure out which objects likely generate all of this redo.
Monitoring sess
That feature is not available until 8.0 or 8i, forget which.
Jared
"Sam Bootsma" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/21/2003 07:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Aut
Title: storing credit card numbers in a database
I've been asked to find out a way to encrypt credit card numbers and store that encrypted string in the database. ...any oracle functions or functionality to do this? or would we have to encrypt the numbers in the application and then pass
Title: AIX question
Lisa;
Here is a set of 3 scripts that I used to map our disks on an IBM S70a with a
large SSA Disk set that used the AIX Logical Disk Manager. You might be
able to glean all the commands from the scripts or just use them yourself
if they work on your system. The
I believe that there is a RAC book in the works. I
don't know what the expected publish date is... I'll
contact the author and find out.
RF
--- "Broodbakker, Mario" <[EMAIL PROTECTED]>
wrote:
> Vladimir,
>
> The official manuals do a good job. Besides from
> that The O'Reilly Oracle Parallel Pr
And, though I'm not sure if you need root to run it, I remember smitty
was a wonderful little menu-driven tool for finding such information.
And you hit a key combo that would show you the actual command for
future reference.
You'll have to forgive the vagueness, it's been quite some time since
1 - 100 of 168 matches
Mail list logo