This statement is from a batch program within a pl/sql procedure. (Also, I have many similar ones within the process) The policy table has approximately 6.2 million rows. The procedure is to incrementally(daily) build an extract table from multiple tables. The extract table is then used for
I am looking for a script that I can supply a table name and it returns all users that have access to it (either directly, thru system priveleges or thru roles) and what the access is. Does anybody have something like this that I can use? Thanks
American Express made the following
annotations on
ven to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown
-Original Message-
From: Tracy Rahmlow [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 5:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Sugges
We have experienced intermittent problems (slow response time) with our oltp database today. There appears to be a large number of latch free events and the p2 parameter is indicating an issue with the library cache. Any thoughts on where to go next?
American Express made the following
Hello,
Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve
Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks
American Express made the following
annotations on 11/21/2003 07:28:27 AM
--
.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
and permanently delete this
message and any attachments. Thank you.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy
attachments. Thank you.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED
.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
attachments. Thank you.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED
.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
delete this
message and any attachments. Thank you.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy
and any attachments. Thank you.
**
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL
Anybody take this course before. Any comments, good or bad. Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
Fyi,
There is a version of 9.2 for AIX 4.3.3 and 5L. At least I think they are
different, because the media is shipped with the os version noted as such.
Have you tried this Raj?
on
02/13/2003 08:19 AM PST
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:
://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
Raj,
There appears to be 2 related bugs 2410612 2598387 with different
workarounds. When you state you already made the change
what change are you referring to?
on
02/04/2003 06:53 AM PST
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple
a data compare through sql of the
old and newly reorged table. This seems excessive and not practical for very
large tables. Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City
Anybody using this product? What are your thoughts about it? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
. If you know that as
well, please share. Thanks everybody
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
be written in
pl/sql. Any thoughts?? What are others doing today and are there any papers
available regarding these issues? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX
Anybody every use this product? Good, bad, Located at www.agpw.com.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
.
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
of a resource,
however our sysadms do not see any resource problems. Does anybody have any ideas how
to debug this? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
Hi,
I am unable to query from the database when it hangs up. I am only able to
execute the shutdown abort command.
To:[EMAIL PROTECTED]
cc:Tracy Rahmlow@AMEX
Tracy,
You can start by using the query below to determine what
the sessions are actually waiting on:
select
Hi,
It has been confirmed that we are not running out of space due to the archiver.
To:Tracy Rahmlow@AMEX
cc:
My initial stab in the dark is that if this DB is in archive mode,
that the archiver process could be halting additional transactions
due to lack of space in the archive
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing
Clarification: My initial question was not really asking how to do it. But
more it was trying to find out what other shops do. In addition, since the
production database is large what benefits/costs can I present to justify
cloning a fullsized database to an acceptance database?
For example,
time. Do others load a subset of data (say 25%)
and then extrapolate to a total time? Is that even necessarily accurate to do?
I have my doubts. Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
).
__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL
wondering
if I am alone.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
variable sets. When all we
really want is access to either sqlplus or the reports binaries.Any
thoughts are very much appreciated. Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
am alone
Have a great weekend
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
backup
option? (I realize it does matter how many blocks are updated)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
those buzzwords. In
addition, what would the architecture look like for integrating a datawarehouse
with an oltp environment?
Oh, by the way we have decided to continue to use Oracle, that is not on the
table.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy
or not the info is written to the header? Why do we have
mixed results? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
is written to the header? Why do we have
mixed results? Why, why, why? Thanks and at least its friday.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
looking for
ideas or options to consider. [At least initially they are stating there can
be no downtime for maintenance (upgrades/reorgs)]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
which process(fast
or complete) will provide for a faster refresh for higher than normal updates
to a master table? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
an fyi, in our current design the coverages have been stored with the
vehicle.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
. (Thus my struggles)
-- Forwarded by Tracy Rahmlow on 06/25/2001 01:52 PM
---
06/25/2001 10:18 AM PST
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Tracy,
I
. (Thus my struggles)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Please see prior post. The formatting seems to be hosed up.
-- Forwarded by Tracy Rahmlow on 06/25/2001 03:15 PM
---
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
of the snapshot.
-- Forwarded by Tracy Rahmlow on 05/31/2001 12:29 PM
---
PM PST
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Been a while since I worked
?
-- Forwarded by Tracy Rahmlow on 05/31/2001 12:37 PM
---
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Tracy,
You may know that there were no modifications to the
master
of the snapshot.
-- Forwarded by Tracy Rahmlow on 05/31/2001 12:29 PM
---
PM PST
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Been a while since I worked
thoughts? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
only one copy of table
do not need an ongoing process to keep the tables in sync
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
61 matches
Mail list logo
