Oracle Text index question, somewhat urgent

[Jonathan Gennick]

I need to ask a question of someone who understands Oracle Text
indexes. So if you know Oracle Text, please read on.

 I was told that if I had a query such as the following:

SELECT falls_name
FROM waterfalls
WHERE INSTR(UPPER(falls_directions),
'MACKINAC BRIDGE') <> 0;

where falls_directions is a CLOB, that I can define a case-insensitive
index using Oracle Text and then use CONTAINS to execute the query
more efficiently:

SELECT falls_name
FROM waterfalls
WHERE 
   CONTAINS(falls_directions,'mackinac bridge') > 0;

Is this correct? Is there such a thing as a case-insensitive index in
Oracle Text? I did take a quick look at the Oracle Text manual, but
this capability didn't leap out at me. Is "case-insensitive" the term
Oracle Text uses? In any case, I need to verify whether what I've been
told is correct. 

Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
http://ValleySpur.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: !ls from sqlplus

[Sinardy Xing]

try this command

which sqlplus

-Original Message-
Sent: 13 June 2002 08:09
To: Multiple recipients of list ORACLE-L


OS: Solaris 2.7
Database: 8.1.7

On dev server, !ls from sqlplus gives the files of current directory where
sqlplus runs.
On pro server, !ls from sqlplus goes to the home directory of os user.

For example,
Login to sqlplus from /u01 on both machines,
on dev: SQL> !pwd
/u01

on pro: SQL> !pwd
/export/oracle

What seting affects this ?

Thanks,

-Li Zhang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Li Zhang
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Sinardy Xing
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: I/O contention with external process reading the oracle logs (online redo logs)

[Tim Gorman]

Just curious, why do you think replication will be less bandwidth?  Are you
replicating only certain schemas/accounts and not the entire database?

Is Quest asserting that shipping the SQL statements are more "compact" than
shipping the redo?  That could be possible, but I'm quite certain that it is
near thing, unless the heavily-modified tables in the app have been indexed
with a heavy hand.  For example, unless SharePlex has some remarkable logic,
it won't be "coalescing" a million-row update into the single SQL statement
that spawned it, which ironically Oracle's advanced replication might be
able to do!  Instead, they'll need to reverse-engineer individual UPDATE
statements for each row, just like Oracle's LogMiner.  The only
circumstances under which I can imagine individual row-level SQL statements
being more compact that the redo resulting from them is when there are lots
of large indices on the table...

---

On another note, the 9iR2 "logical standby" feature is a direct knockoff of
SharePlex, in that the RDBMS ships the SQL instead of the redo logfile, so
the characteristics should be very similar.  Of course, 9iR2 is very new and
*very* raw at the moment, while SharePlex has been around for something like
5-6 years already (i.e. eons!), so that should be a strong consideration.
But, when I last worked with SharePlex (3.0, I think), it had lots of bad
habits like demanding "DBA" role to be granted to it's account both for
installation as well as run-time, setting SETUID on executables owned by
"root" (17-18 of them! drove the UNIX sysadmins insane!  with good reason);
just a lot of lazy development practices that I hope have been fixed...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 8:48 AM
(online redo logs)


> Hello Tim and Rachel
>
> There is band width problem. The line is 256K (we are checking upgrade to
> 512k).
> The database, during peek time produce 10MB of logs every 2-3 minutes.
> On this line it will take 7-8 minutes to pass 10MB if the line was
dedicate
> and it is not dedicated.
>
> Upgrading the line to more then 512K need E1 at least and it is expansive.
>
> Since replication will need less band width we are checking it.
>
> To return to my original question:
> Quest Shareplex -
> Any success stories?
> Why use this and not replication?
> Ant performance tests between Shareplex and Oracle replication?
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Monday, June 10, 2002 4:33 AM
> (online redo logs)
>
>
> > and if you need the remote site to support users, you could use the
> > logical standby feature of 9iR2, which generates SQL statements to be
> > applied and allows the database to be open and active.
> >
> > --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > > why wouldn't you consider simply using the standby database feature?
> > >
> > > do you need the remote site to support users also?
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Sunday, June 09, 2002 11:43 AM
> > > (online redo logs)
> > >
> > >
> > > > Hello All
> > > >
> > > > I just had a meeting today about replication.
> > > > The situations is: One master db that is currently replicated
> > > > (master to master synchronous replication) to a second DB.
> > > > Both machines are NT and the is a direct cable connection
> > > > between the network cards on both machines.
> > > >
> > > > However, this solves the problem of machine failure but does not
> > > cover
> > > > the full disaster recovery as both machines are in the same room.
> > > > In case of fire both machines will be destroyed.
> > > >
> > > > We are thinking about adding asynchronous replication to replicate
> > > the
> > > > changes
> > > > across wan to a remote site. The problem is that this will load the
> > > > production system and the network link (wan is expensive), as the
> > > system
> > > > generates during peek time 10MB of archive logs every 2-3 minutes.
> > > >
> > > > I saw that some of you are using Quest Shareplex.
> > > > Can you share your reasons, success stories etc?
> > > > Benchmarks results will be very welcome.
> > > >
> > > > TIA
> > > >
> > > > Yechiel Adar
> > > > Mehish
> > > > - Original Message -
> > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > > Sent: Thursday, June 06, 2002 4:32 PM
> > > > (online redo logs)
> > > >
> > > >
> > > > NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html
> > > no
> > > > matter what default i set!
> > > > Hi lists,
> > > >
> > > > I am using Quest Shareplex product for Oracle to Oracle one way
> > > > replication.  I have two systems (source and target) and two
> > > environments
> > > > (dev, demo).  On system one, the environments are setup as schemas
> > > within
> > > > one oracle instance (therefore each sche

Memory utilization

[CP]

Hi Gurus,

How can I find out the amount of memory utilized (grabbed from the 
available memory of the OS) by a server process, whenever a user 
establishes a connection with the database.  The OS is Sun Solairs with 
Oracle version 8.1.7.3. In other words, if I have a unix process id, is 
there a way to find out how much memory it is consuming.

Thanks for your help and time in advance.

CP




[EMAIL PROTECTED] wrote:

>OS: Solaris 2.7
>Database: 8.1.7
>
>On dev server, !ls from sqlplus gives the files of current directory where
>sqlplus runs.
>On pro server, !ls from sqlplus goes to the home directory of os user.
>
>For example,
>Login to sqlplus from /u01 on both machines,
>on dev: SQL> !pwd
>/u01
>
>on pro: SQL> !pwd
>/export/oracle
>
>What seting affects this ?
>
>Thanks,
>
>-Li Zhang
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CP
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: V$SQLTEXT text length

[Rodrigues, Bryan]

Jesse,

You could access the v$sqltext. It contains the whole query in 64 character
sections. it is not as organized as sql_text in v$sqlarea, but if you put
all the rows with sql_text field ordered by piece column you will have the
full query.

Bryan Rodrigues

-Original Message-
Sent: Wednesday, June 12, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L


While researching some shared_pool problems  on an 8.1.6 instance, I
happen to notice that the SQL_TEXT column of the V$SQLAREA view is "only"
1000 bytes.  What happens when the statement is longer than that?  Does it
just not show all of it in that view?

Just curious.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Rodrigues, Bryan
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Join Performance in Materialized View

[Paula_Stankus]

Title: RE: Join Performance in Materialized View





I have a join creating a materialized view.  I have been using use_hash hint and parallelism to tune part of the query (join that involves 2 large tables).  Thanks for the info. on setting hash_area_size explictly it made a big difference.

I am using Direct IO and - Wow!  at least 40% perf. increase.  


Here is the rub .I am somewhat limited in what I can do if I want to use refresh fast in MV creation.  


I have a number of small codetables to join into the 2 large tables doing a hash join.  Also, I am using outerjoins and hitting the same codetables with aliases more than once.  

I created all small tables as IOT which is part of outer join predicate per suggestion from another colleague and friend.

This is for a 16 cpu server with 20Gb rams.  It is on the largest table with 9M rows so the results in the MV will be 9M rows.  Just the two tables took 33 minutes adding these smaller tables results in time taking about 2 hours...hmmm.


Like,


create materialized view
partition
select /*+USE_HASE(crt) PARALLEL(crt,8)*/


Adding these small table joins along with the hint above causes the CBO to want to do hash outer joins on everything which subsequently results in writing to temporary tablespace every setting sort_area_size, sort_area_retained_size and hash_area_size very high.  I have allocated a special temporary tablespace with large extent sizes and LMT.  


Since my sort_area is so large it would be silly to set temporary tablespace as a multiple of it but what are the implications of it being smaller.

Doing a lot of I/O waits on temporary tablespace even yet just by adding these small tables.



Seems I would be better off joining the large tables then using nested materialized view to join the rest but how deep can I get with these MV's or is there another way I can accomplish getting the result set for the first two large tables then the smaller tables by using hints (ordered or use_merge).  Inline views are not supported in refresh options of MV.  

Any ideas?  

!ls from sqlplus

[Li Zhang]

OS: Solaris 2.7
Database: 8.1.7

On dev server, !ls from sqlplus gives the files of current directory where
sqlplus runs.
On pro server, !ls from sqlplus goes to the home directory of os user.

For example,
Login to sqlplus from /u01 on both machines,
on dev: SQL> !pwd
/u01

on pro: SQL> !pwd
/export/oracle

What seting affects this ?

Thanks,

-Li Zhang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Li Zhang
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: 3-tier architecture

[DENNIS WILLIAMS]

Tracy
We are wrestling with the same issues that you raise. Still
designing, so I can't speak from experience, just theory. I can't disagree
with anything you say, but here are how I see some of the issues:
   - You agree that PL/SQL in the database will usually be more maintainable
(single point of code) and faster than Java outside.
   - I feel this difference isn't quite as sharp as it would be if you were
comparing client code running on a desktop. There is only a single web
server and it probably has a fast network link to the database. There is
probably a single app. server and with an object-oriented language like
Java, code shouldn't be repeated, moderating the maintenance issue.
   - In the projects I have been on, fundamental mistakes were usually made
by saying up front "we're going to do it this way, period". As a developer,
things like Java and PL/SQL are tools. A good developer should be willing to
use the appropriate tools where needed to meet the project goals. You
wouldn't tell a handyman to fix your house, "but don't use a screwdriver".
   - There will probably be sections where PL/SQL will provide the
performance boost needed. For many other sections, performance may not be
that critical.
   - App servers are capable of some sophisticated caching themselves. This
may provide even greater performance for certain situations than PL/SQL
could ever achieve. Specifically, I have heard of Web sites that are able to
provide data right from the web server rather than making a database
request.
   - If this is a large project, the project leaders probably have some
strong ideas about which language they will use to code the business
language. 
   - Java in the database sounds great for certain situations. Doesn't
require the developers to learn a new language. I would be interested in any
tradeoffs people have found.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 12, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L


We're looking to implement a 3-tier architecture with websphere, java and
oracle.  My question is where should the code be deployed for oltp apps and
batch processes?  Are the business rules(components) deployed on the middle
tier and that same logic (if applicable within batch) deployed as java
within
the database?  It would appear to me that batch would execute faster if the
source resides in the database rather than the app server, but that we are
gaining a maintenance(deployement) issue for the performance gain.  Should
the
business rules be deployed within java and the data access 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: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: DENNIS WILLIAMS
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Connecting as sysdba via ODBC / VB

[Reardon, Bruce (CALBBAY)]

Alex,
Got it from Technet under downloads.
Bruce Reardon

-Original Message-
Sent: Thursday, 13 June 2002 5:53

>From where did you download it? Maybe there exist new version of OLEDB
provider for ADO?

Alex Hillman

-Original Message-
Bruce (CALBBAY)
Sent: Monday, June 10, 2002 11:08 PM

Someone in the last few days requested info on connecting as sysdba from VB.
I deleted the email at the time but I just downloaded the ODBC driver
version 8.1.7.6.0 and found the following:
"NEW FEATURES

ODBC 8.1.7.6.0
Added support for connection syntax "/ as sysdba" and
"/ as sysoper".  The "as sysdba" and "as sysoper" string
can also be contained in the password field.  (Bug 2114033)
Added support for the statement attribute SQL_ATTR_RETRIEVE_DATA.  (Bug
2165706)

ODBC 8.1.7.5.0
Added support for / syntax to be used as username to log
on. (as requested by Bug 1094170)  "

I hope this might be of use and perhaps will work via OCI etc from VB.

HTH,
Bruce Reardon
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RDBMS - key strength

[Keith Peterson]

Suppose you were allowed only ONE sentence to describe
the greatest strength of RDBMS's over say (object
databases, legacy, etc.)... what would that be?

Keith

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Keith Peterson
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: sys corrupted in warehouse, sev1 tar open - resolved

[Reardon, Bruce (CALBBAY)]

Jack,
Something you may find useful if you're not already aware is the schemaname field in 
v$session.
Compare this to username and this may help determine if set current_schema is being 
used.

We use the set current_schema in a login trigger, though the trigger has smarts in it 
to only do it for application users and not for schema owners, sys, system etc.

HTH,
Bruce Reardon

-Original Message-
Sent: Thursday, 13 June 2002 4:20
To: Multiple recipients of list ORACLE-L


It was the "alter system set current_schema=x"
statement after all.

I am sure that this raises some interesting questions,
if only I had time to dwell on it. Just now cleaning
up all the broken indexes from the loads that abended
when the db went down.

I love this job. Where else do you get to play at
work?

jack




>  --- Jack Silvey <[EMAIL PROTECTED]> wrote: >
> All,
> > 
> > thanks for the input. Looks like someone
> implemented
> > a
> > login trigger. haven't seen the code yet, but I
> > would
> > venture a guess he used the unsupported "alter
> > system
> > set current_schema=x".
> > 
> > sometimes you live and learn, sometimes you just
> > live!
> > 
> > thx,
> > 
> > jack silvey
> > 
> > 
> > --- Hately Mike <[EMAIL PROTECTED]> wrote:
> > > I don't hold out much hope here Jack. 
> > > It sounds like data dictionary corruption; maybe
> > > somewhere round user$(?).
> > > That's not to say the situation's irretrievable;
> > > I've seen OTS fix some bad
> > > situations in my time but I'm not sure that I'd
> > want
> > > to keep the database
> > > even if Oracle Support can fix the problem.
> > > 
> > > Regards,
> > > Mike
> > > 
> > > -Original Message-
> > > Sent: 12 June 2002 14:23
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Listers,
> > > 
> > > Our warehouse now has a split personality and we
> > > have
> > > a sev1 open on it. Suspect recovery is in the
> > cards,
> > > but want to avoid if possible.
> > > 
> > > Yesterday, users unable to get to their own
> > > functions.
> > > Soon after, RMAN cannot find package
> > > dbms_backup_restore, even though it exists under
> > > sys.
> > > Oncall ran the sql script to recreate - and the
> > > pacakge was recreated under a schema called
> > > dma_rbate2. RMAN now finds the package under
> > > dma_rbate2, although it is invalid. Drop the
> > package
> > > under dma_rbate2, and now RMAN cannot find the
> > > package
> > > any longer, although it still exists under sys.
> > > 
> > > Logged in as sys. Tried to desc
> > dbms_backup_restore
> > > -
> > > no luck. Tried to desc sys.dbms_backup_restore -
> > > success.
> > > 
> > > Analyst reccomends running catalog.sql. Oncall
> > does
> > > so, and it creates as many packages as it is
> able
> > > under dma_rbate2.
> > > 
> > > I get up this AM and can't login, because the
> > > sessions
> > > can't find the package
> > > dma_rbate2.dbms_application_info.
> > > 
> > > Anyone? Buhler? Buhler?
> > > 
> > > thx,
> > > 
> > > jack
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: Oracle 9.0.1.3 or 9.2.0?

[Bill Pass]

If you want stability I would stick w/9.0.1.3 (or .4
if it is available for your port).

--- Raj Gopalan <[EMAIL PROTECTED]>
wrote:
> Hi DBAs
> 
> We are upgrading from 8.1.5 to 9.x. I thought of
> finding out which release
> of 9i is more stable. As We have got 9.2 couple of
> weeks back, I was just
> wondering what is  worth going for 9.2 instead of
> 9.0.1.3?
> 
> TIA,
> 
> Raj
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Raj Gopalan
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

oracle error logging

[BigP]

I am looking for some good design to log and handle 
oracle /user defined error messgaes in our system , which can be used for 
debugging and error reporting also .Can any body out there share their 
experience ?
 
Bp

RE: SunOS 5.8 I/O buffer size?

[Gogala, Mladen]

Well, I must admit that I drive Hyundai Elantra. I drove VW Golf,
Toyota Corola and Citroen ZX. I cannot tell a Ferrari from a Porsche,
those cars are not in my class.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 4:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SunOS 5.8 I/O buffer size?
> 
> 
> Amazing how so many can't tell a Ferrari from a Porsche.
> 
> Not you Mladen, I realize that's why "Ferrari" was in quotes.
> 
> Jared
> 
> 
> 
> 
> 
> Mladen Gogala <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/12/2002 07:33 AM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L 
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Re: SunOS 5.8 I/O buffer size?
> 
> 
> The "IO buffer size" is the maximal size of a single, atomic disk IO, 
> usually
> either 128k or 256k. All IO requests larger then that will be 
> internally broken
> into multiple requests. As my Solaris is getting rusty (working with 
> HP-UX and
> Linux now) I cannot remember the exact parameter name. It used to be 
> available
> in the "Ferrari" book.
> 
> 
> On 2002.06.12 09:53 Carmen Rusu wrote:
> > 
> > Kevin Loney's Oracle8i DBA Handbook says you need to know the
> > "operating system's I/O buffer size" in order to set the init param
> > DB_FILE_MULTIBLOCK_READ_COUNT correctly.
> > 
> > What is the definition of "operating system's I/O buffer 
> size Loney is
> > talking about?
> > 
> > What is  the value of " I/O buffer size" for SunOS 5.8?
> > 
> > Went to Sun's web site and got lost...I just want two 
> straight answers
> > to my two questions.
> > 
> > 
> > 
> > 
> > Thanks,
> > 
> > Carmen Rusu
> > Sr Oracle DBA
> > 512-463-3657 (office)
> > 512-606-5012 (pager)
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Carmen Rusu
> >   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 list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
> > 
> 
> -- 
> Mladen Gogala
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mladen Gogala
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Gogala, Mladen
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

dedicated sessions

[BigP]

Hi List ,
Is there any way I can make shared connectiuon 
explicitely . When I am looking at v$session I am finding tons of JDBC 
connection which are dedicated . Can I expect some performance gain or low 
resource requirement out of this if I make these dedicated connections to shared 
.
Thanks ,
Bp

RE: V$SQLTEXT text length

[Mohammad Rafiq]

Following query might help:

select piece, sql_text
from v$sqltext
where (address,hash_value) in
  (select sql_address,sql_hash_value
   from v$session
   where paddr = (select addr
  from v$process
  where spid = '&1'))
order by piece
/
set linesize 120
select substr(vs.username,1,10)username,
   vs.osuser,
   vs.sid,
   vs.serial#,
   vs.LOGON_TIME,
   substr(vs.machine,1,15)machine,
   vs.process,
   vp.spid,
   vs.last_call_et
from v$session vs, v$process vp
where vs.paddr = vp.addr
and vs.username is not null
and vs.status = 'ACTIVE'
/

HTH,
Regards
Rafiq


To get SPID:




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 12 Jun 2002 13:59:52 -0800

PIECE column?  By joining V$SQLAREA to V$SQLTEXT?  (on ADDRESS)

So, then, having the text truncated to 1000 chars in V$SQLAREA is no big
deal, but it could be confusing if you had multiple rows in V$SQLAREA with
the first 1000 chars of the SQL statement exactly the same, correct?  The
theory being that you could join to V$SQLTEXT by ADDRESS to get the entire
text if needed.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


 > -Original Message-
 > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 > Sent: Wednesday, June 12, 2002 2:51 PM
 > To: [EMAIL PROTECTED]
 > Cc: Jesse, Rich
 > Subject: Re: V$SQLTEXT text length
 >
 >
 > Please notice the PIECE column.
 >
 > Jared
 >
 > "Jesse, Rich" <[EMAIL PROTECTED]>
 > Sent by: [EMAIL PROTECTED]
 > 06/12/2002 01:04 PM
 > Please respond to ORACLE-L
 >
 >
 > To: Multiple recipients of list ORACLE-L
 > <[EMAIL PROTECTED]>
 > cc:
 > Subject:V$SQLTEXT text length
 >
 >
 > While researching some shared_pool problems  on an
 > 8.1.6 instance,
 > I
 > happen to notice that the SQL_TEXT column of the V$SQLAREA
 > view is "only"
 > 1000 bytes.  What happens when the statement is longer than
 > that?  Does it
 > just not show all of it in that view?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
   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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).




_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: V$SQLTEXT text length

[Jesse, Rich]

D'oh!  I'm 2 for 2 today!  I had "V$SQLTEXT" in the subject, but "V$SQLAREA"
in the body...  

Looks like I'm stopping at the liquor store on the way home...  ;)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 2:51 PM
> To: [EMAIL PROTECTED]
> Cc: Jesse, Rich
> Subject: Re: V$SQLTEXT text length
> 
> 
> Please notice the PIECE column.
> 
> Jared
> 
> "Jesse, Rich" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/12/2002 01:04 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L 
> <[EMAIL PROTECTED]>
> cc: 
> Subject:V$SQLTEXT text length
> 
> 
> While researching some shared_pool problems  on an 
> 8.1.6 instance, 
> I
> happen to notice that the SQL_TEXT column of the V$SQLAREA 
> view is "only"
> 1000 bytes.  What happens when the statement is longer than 
> that?  Does it
> just not show all of it in that view?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: partial restore of a database

[DENNIS WILLIAMS]

Gene
I can't think of anything you're missing. I recall that read-only
tablespaces if you have any must be offline, but maybe that is only for a
database restore, not a tablespace restore. I assume you have a plan to move
the tables back to your production system, maybe just export/import if they
are small.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, June 12, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L


Hi all:

I'm doing a partial restore of a database in order to
recover two lost tables. I figured I would only need
to restore the tablespaces where the tables are
stored,
SYSTEM and RBS tablespaces. I will also need to
restore
to a specific point in time (last Friday). 

I'm a little less clear on what I will have to do
after the restore of the datafiles, archived logs and
controlfile is done. I will need to recover the
datafiles, drop all other datafiles that I don't need
and open the database in resetlogs mode. Is that a
good plan or am I missing something?

thanks

Gene

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: DENNIS WILLIAMS
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: V$SQLTEXT text length

[Jesse, Rich]

PIECE column?  By joining V$SQLAREA to V$SQLTEXT?  (on ADDRESS)

So, then, having the text truncated to 1000 chars in V$SQLAREA is no big
deal, but it could be confusing if you had multiple rows in V$SQLAREA with
the first 1000 chars of the SQL statement exactly the same, correct?  The
theory being that you could join to V$SQLTEXT by ADDRESS to get the entire
text if needed.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 2:51 PM
> To: [EMAIL PROTECTED]
> Cc: Jesse, Rich
> Subject: Re: V$SQLTEXT text length
> 
> 
> Please notice the PIECE column.
> 
> Jared
> 
> "Jesse, Rich" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/12/2002 01:04 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L 
> <[EMAIL PROTECTED]>
> cc: 
> Subject:V$SQLTEXT text length
> 
> 
> While researching some shared_pool problems  on an 
> 8.1.6 instance, 
> I
> happen to notice that the SQL_TEXT column of the V$SQLAREA 
> view is "only"
> 1000 bytes.  What happens when the statement is longer than 
> that?  Does it
> just not show all of it in that view?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

3-tier architecture

[Tracy Rahmlow]

We're looking to implement a 3-tier architecture with websphere, java and
oracle.  My question is where should the code be deployed for oltp apps and
batch processes?  Are the business rules(components) deployed on the middle
tier and that same logic (if applicable within batch) deployed as java within
the database?  It would appear to me that batch would execute faster if the
source resides in the database rather than the app server, but that we are
gaining a maintenance(deployement) issue for the performance gain.  Should the
business rules be deployed within java and the data access 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: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Oracle DB2 DBA Needed in Nebraska (near Colorado border)

[Weaver, Walt]

Huh. I'd be able to make it from Denver to Sidney in two hours in my
airplane, but not by car...

Sidney's a nice town, though.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, June 12, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


Company in Sidney, Nebraska has an Oracle /DB2 DBA  position opening on  its
IT staff.
Sidney is a small town, 2 hours from Denver.. 30 mins from Sterling, CO so
it's very close 
to the CO/NE border.
The area has a very, very low cost of living, so renting or buying a house
is tremendously 
low compared to most other areas of the country.

An excellent Relocation Package is offered.

Description:
The selected candidate will perform typical DBA tasks to ensure reliable and
scheduled availability of multiple development and production databases.
This position will be responsible for monitoring and tuning databases for
optimum performance, 
working with application developers during all phases of the application
development life cycle,
designing and implementing physical database design, influencing all aspects
of 
application architecture and design, and assisting in troubleshooting
application problems.

PLEASE Do Not send your resume for this position UNLESS you have the
qualifications for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

This is a full time staff position so no sub-contractors or third parties
please.

No H-1B candidates please.

Requirements:
-4+ years of Oracle database administration experience
 on HP, SUN, or NT platforms (version 8.x or higher)
-Solid DB2 database administration experience on
 AS400, HP, SUN, or NT platforms.
-4+ years of experience writing and tuning complex SQL.
-Experience in logical and physical relational database
 design and data modeling
-Good communication skills, ability to work well with
 others and multi-task.
-U.S. citizens or permanent residency

The base salary range depends on experience...range is up to 85K..and
possible bonus.
They also offer a comprehensive benefits package, including generous
product discounts, profit sharing, 401K savings plan,
and Health and Dental coverage.

For  immediate consideration, please send your resume as a Word attachment
to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Sidney/Oracle/DB2/KW
ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: OraStaff
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Weaver, Walt
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

OEM Returns ORA-12154

[John Weatherman]

Anybody seen this?  I've isolated some session sql and want to run the
explain plan.  When I do I get a ORA-12154.  Most other funtions work fine.
I am in standalone mode.

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: Troubleshooting ORA-01410

[Peter Gram]

Hi Sean

I would make a database trigger on servererror that could call a dump of 
the session and that way get a error stack  and a system state dump
tahe inclueds the sql that is executing

O'Neill, Sean wrote:

>So this application running on an 8.1.7 database, NT4, has a utility
>supplied by vendor which when run by one of our apps people is reporting an
>ORA-01410 (invalid ROWID).  Given our "history" with the vendor in question
>I have some doubts about the application =:-0
>
>In relation to same I have a few queries:
>
>[1]  Would an Export of the database report problems if above issue existed
>in database?.  A full export is currently taken each night and completing
>without any warnings.
>
>[2]  Is dbverify any good to troubleshoot this type of error?.  I currently
>run a dbverify on Offline backups of the data files in question and no
>errors are being reported.  Granted this is on a "copy" of the datafiles but
>I ran a test before where I corrupted a datafile, took a copy, and the
>dbverify reported problem with copy so I assume my logic is good here?.
>
>[3] If I run ANALYZE TABLE xxx VALIDATE STRUCTURE CASCADE on offending table
>is output reported to screen?
>I have not run it yet as the DB itself is "busy" a lot of the time and above
>is rcommended for quite time due to prevention of Selects, Inserts, Updates
>and Deletes on object.
>
>[4] What other methods could be used to troubleshoot this problem?.  As I
>mentioned I have doubts about the vendor supplied application and would like
>to prove one way or the other if some data corruption exists or not!
>
>Any help with above would be much appreciated :) 
>
>-
>Seán O' Neill
>Organon (Ireland) Ltd.
>[subscribed: digest mode] 
>
>This message, including attached files, may contain confidential
>information and is intended only for the use by the individual
>and/or the entity to which it is addressed. Any unauthorized use,
>dissemination of, or copying of the information contained herein is
>not allowed and may lead to irreparable harm and damage for which
>you may be held liable. If you receive this message in error or if
>it is intended for someone else please notify the sender by
>returning this e-mail immediately and delete the message.
>
>  
>

-- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk

/*
The process of preparing programs for a digital computer is especially
attractive, not only because it can be economically and scientifically
rewarding, but also because it can be an aesthetic experience much like 
composing poetry or music

Donald Knuth
*/ 





smime.p7s
Description: application/pkcs7-signature

Re: V$SQLTEXT text length

[Jared . Still]

Please notice the PIECE column.

Jared






"Jesse, Rich" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/12/2002 01:04 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:V$SQLTEXT text length


While researching some shared_pool problems  on an 8.1.6 instance, 
I
happen to notice that the SQL_TEXT column of the V$SQLAREA view is "only"
1000 bytes.  What happens when the statement is longer than that?  Does it
just not show all of it in that view?

Just curious.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI 
USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

partial restore of a database

[Gurelei]

Hi all:

I'm doing a partial restore of a database in order to
recover two lost tables. I figured I would only need
to restore the tablespaces where the tables are
stored,
SYSTEM and RBS tablespaces. I will also need to
restore
to a specific point in time (last Friday). 

I'm a little less clear on what I will have to do
after the restore of the datafiles, archived logs and
controlfile is done. I will need to recover the
datafiles, drop all other datafiles that I don't need
and open the database in resetlogs mode. Is that a
good plan or am I missing something?

thanks

Gene

__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: V$SQLTEXT text length

[Bill Gentry]

 You can use the "piece" fields, as in the following script:

select a.sid, a.username, s.sql_text
from v$session a, v$sqltext s
wherea.sql_address  = s.address
and  a.sql_hash_value = s.hash_value
order by a.username, a.sid, s.piece;

Hope This Helps,
Bill Gentry - DBA
Allina Health System
Mpls., MN
[EMAIL PROTECTED]
--

On Wed, 12 Jun 2002 12:04:37  
 Jesse, Rich wrote:
>While researching some shared_pool problems  on an 8.1.6 instance, I
>happen to notice that the SQL_TEXT column of the V$SQLAREA view is "only"
>1000 bytes.  What happens when the statement is longer than that?  Does it
>just not show all of it in that view?
>
>Just curious.
>
>Rich Jesse   System/Database Administrator
>[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Jesse, Rich
>  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 list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
>


___
WIN a first class trip to Hawaii.  Live like the King of Rock and Roll
on the big Island. Enter Now!
http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Gentry
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: SunOS 5.8 I/O buffer size?

[Jared . Still]

Amazing how so many can't tell a Ferrari from a Porsche.

Not you Mladen, I realize that's why "Ferrari" was in quotes.

Jared





Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/12/2002 07:33 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: SunOS 5.8 I/O buffer size?


The "IO buffer size" is the maximal size of a single, atomic disk IO, 
usually
either 128k or 256k. All IO requests larger then that will be 
internally broken
into multiple requests. As my Solaris is getting rusty (working with 
HP-UX and
Linux now) I cannot remember the exact parameter name. It used to be 
available
in the "Ferrari" book.


On 2002.06.12 09:53 Carmen Rusu wrote:
> 
> Kevin Loney's Oracle8i DBA Handbook says you need to know the
> "operating system's I/O buffer size" in order to set the init param
> DB_FILE_MULTIBLOCK_READ_COUNT correctly.
> 
> What is the definition of "operating system's I/O buffer size Loney is
> talking about?
> 
> What is  the value of " I/O buffer size" for SunOS 5.8?
> 
> Went to Sun's web site and got lost...I just want two straight answers
> to my two questions.
> 
> 
> 
> 
> Thanks,
> 
> Carmen Rusu
> Sr Oracle DBA
> 512-463-3657 (office)
> 512-606-5012 (pager)
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Carmen Rusu
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
> 

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: V$SQLTEXT text length

[Lyubomir Petrov]

Hi, Rich,

Look in V$SQLTEXT - there is the whole sql statement, split in chunks of 64
characters max each.

HTH,
Lubo

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 1:04 PM


> While researching some shared_pool problems  on an 8.1.6 instance,
I
> happen to notice that the SQL_TEXT column of the V$SQLAREA view is "only"
> 1000 bytes.  What happens when the statement is longer than that?  Does it
> just not show all of it in that view?
>
> Just curious.
>
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Lyubomir Petrov
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: OCI Issue

[Stephane Faroult]

"Turner, Christine" wrote:
> 
> Does anyone know anything about an ORA-1043? We are currently getting it
> within our OCI layer with the application trying to perform a create table
> statement with a select statement. We have issued a tar with Oracle, they
> suggested the 81730 patch, which fixed one computer but not another. Now
> Oracle wants a test case, which we can not provide. Same app, same database,
> etc. We are running Oracle 81730, standard edition on a Windows 2000
> platform.
> 
> Any help and info is greatly appreciated!
> 
> thanks,
> Christine

Christine,

It looks like your program is overwriting memory areas used by the
Oracle client side. I suggest you run your program through purify or the
like before anything else. Probably a dangling pointer, or something
improperly allocated. Check handle allocation/deallocation, with
everything passed as a void * with something to tel the type, it's very
easy to goof. Check also ub2/ub4/sb4, I have had nasty surprises with
some direct load attempts, since data type was provided as ub2 in a
routine and ub4 elsewhere - and I was trying to use the same variable in
both cases. 
-- 
HTH,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: Data Warehouse design

[paquette stephane]

Yes it is ok to have sequences as the primary keys. 
The dimension should not use keys from the source
systems as their own keys. They must be independant.
Also, since the PK of the dimensions are foreign keys
in the fact tables, if using a non-generated key you
will increase the size of the fact tables for nothing.

I've never put relationsips between dimension tables.
All the validation is done before the load in the
staging area.



 --- [EMAIL PROTECTED] a écrit : > 
> Hi,
> 
> I am in the process of designing the data warehouse.
> My Question is can I
> define the relationship between dimension tables.
> Like I have
> country,customer and time zone dimension tables. Can
> I add relationship
> between customer,country and time zone just to
> validate the data before load
> whether the country and zip code is correct or
> should I integrate the
> country and time zone with customer itself. If I
> integrate this. Is it going
> to affect the performance. 'cos for every record it
> is going to validate all
> these things before load.  
> 
> Can I create sequences for primary keys(fact tables
> and for some of the
> dimenasion tables also). Is it OK to have a sequence
> as primary key. 
> 
> I need your expert views on this.
> 
> Regards,
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Need improvement on Oracle Loader

[Deshpande, Kirti]

Ron,
Please check this out :
http://oracle.oreilly.com/news/oraclesqlload_0401.html
And then the book by Jonathan Gennick and Sanjay Sherma...

HTH,

- Kirti 

-Original Message-
Sent: Wednesday, June 12, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L


We have an application that calls SQL*Loader to load data warehouse tables
every night.  We would like to speed up
the loads if possible.  Does anyone have any tips or papers on improving
performance on SQL*Loader?

Thanks!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Deshpande, Kirti
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Oracle DB2 DBA Needed in Nebraska (near Colorado border)

[OraStaff]

Company in Sidney, Nebraska has an Oracle /DB2 DBA  position opening on  its
IT staff.
Sidney is a small town, 2 hours from Denver.. 30 mins from Sterling, CO so
it's very close 
to the CO/NE border.
The area has a very, very low cost of living, so renting or buying a house
is tremendously 
low compared to most other areas of the country.

An excellent Relocation Package is offered.

Description:
The selected candidate will perform typical DBA tasks to ensure reliable and
scheduled availability of multiple development and production databases.
This position will be responsible for monitoring and tuning databases for
optimum performance, 
working with application developers during all phases of the application
development life cycle,
designing and implementing physical database design, influencing all aspects of 
application architecture and design, and assisting in troubleshooting
application problems.

PLEASE Do Not send your resume for this position UNLESS you have the
qualifications for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

This is a full time staff position so no sub-contractors or third parties
please.

No H-1B candidates please.

Requirements:
-4+ years of Oracle database administration experience
 on HP, SUN, or NT platforms (version 8.x or higher)
-Solid DB2 database administration experience on
 AS400, HP, SUN, or NT platforms.
-4+ years of experience writing and tuning complex SQL.
-Experience in logical and physical relational database
 design and data modeling
-Good communication skills, ability to work well with
 others and multi-task.
-U.S. citizens or permanent residency

The base salary range depends on experience...range is up to 85K..and
possible bonus.
They also offer a comprehensive benefits package, including generous
product discounts, profit sharing, 401K savings plan,
and Health and Dental coverage.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Sidney/Oracle/DB2/KW
ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraStaff
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: Need improvement on Oracle Loader

[paquette stephane]

Go at http://www.evdbt.com/papers.htm

You'll find a white paper on sql*loader for DW.



 --- "Smith, Ron L." <[EMAIL PROTECTED]> a écrit : > We
have an application that calls SQL*Loader to load
> data warehouse tables
> every night.  We would like to speed up
> the loads if possible.  Does anyone have any tips or
> papers on improving
> performance on SQL*Loader?
> 
> Thanks!
> Ron
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

V$SQLTEXT text length

[Jesse, Rich]

While researching some shared_pool problems  on an 8.1.6 instance, I
happen to notice that the SQL_TEXT column of the V$SQLAREA view is "only"
1000 bytes.  What happens when the statement is longer than that?  Does it
just not show all of it in that view?

Just curious.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re:RE: OCI Issue

[dgoulet]

Christine,

You could be having more than one issue here, which kind of threw me.  First
ofen is an OCI 7 call, the V8 equivalent is OCIStmtFetch.  If your running
against an Oracle8 or better database it might be wise to upgrade.  Second the
programmer passes the number of rows he/she wants fetched from the database. 
Now if in the past that number was greater than the number of rows in the DB
there would have been no problem.  Now you may be crashing memory with too many
rows.

Dick Goulet

Reply Separator
Author: "Turner; Christine" <[EMAIL PROTECTED]>
Date:   6/12/2002 10:55 AM

I was just updated by the developers, the OCI (ofen) call is performing ONLY
a select statment, not a create table. Would this make a difference?

thanks,
C-


-Original Message-
Sent: Wednesday, June 12, 2002 10:57 AM
To: Multiple recipients of list ORACLE-L


Christine,

Lets see, IF I remember my OCI correctly you pass the OCI function a
character variable that holds the SQL statement.  Is that variable large
enough
for the statement and is it NULL terminated?  I seem to remember an OCI
program
written by our CIM group that ran into this problem and the NULL terminator
was
the problem.  Actually where it was was the problem, off the far end of the
variable.

Dick Goulet

Reply Separator
Author: "Turner; Christine" <[EMAIL PROTECTED]>
Date:   6/12/2002 9:05 AM

Does anyone know anything about an ORA-1043? We are currently getting it
within our OCI layer with the application trying to perform a create table
statement with a select statement. We have issued a tar with Oracle, they
suggested the 81730 patch, which fixed one computer but not another. Now
Oracle wants a test case, which we can not provide. Same app, same database,
etc. We are running Oracle 81730, standard edition on a Windows 2000
platform.

Any help and info is greatly appreciated!

thanks,
Christine
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Turner, Christine
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Turner, Christine
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Need improvement on Oracle Loader

[Brian McGraw]

While I don't have a recommendation for a good white paper, let me just
throw out a blatant plug for Jonathan Gennick & Sanjay Mishra's book,
Oracle SQL*Loader - The Definitive Guide.  This is one book that I
picked up and within just a few minutes was saying 'Wow - I've got to
try that out!'

I would bet that it has some information that you would find beneficial.

Brian

--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--

-Original Message-
L.
Sent: Wednesday, June 12, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L

We have an application that calls SQL*Loader to load data warehouse
tables
every night.  We would like to speed up
the loads if possible.  Does anyone have any tips or papers on improving
performance on SQL*Loader?

Thanks!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Brian McGraw
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Connecting as sysdba via ODBC / VB

[Alex Hillman]

>From where did you download it? Maybe there exist new version of OLEDB
provider for ADO?

Alex Hillman

-Original Message-
Bruce (CALBBAY)
Sent: Monday, June 10, 2002 11:08 PM
To: Multiple recipients of list ORACLE-L


Someone in the last few days requested info on connecting as sysdba from VB.
I deleted the email at the time but I just downloaded the ODBC driver
version 8.1.7.6.0 and found the following:
"NEW FEATURES

ODBC 8.1.7.6.0
Added support for connection syntax "/ as sysdba" and
"/ as sysoper".  The "as sysdba" and "as sysoper" string
can also be contained in the password field.  (Bug 2114033)
Added support for the statement attribute SQL_ATTR_RETRIEVE_DATA.  (Bug
2165706)

ODBC 8.1.7.5.0
Added support for / syntax to be used as username to log
on. (as requested by Bug 1094170)  "

I hope this might be of use and perhaps will work via OCI etc from VB.

HTH,
Bruce Reardon
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Alex Hillman
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Need improvement on Oracle Loader

[DENNIS WILLIAMS]

Ron - Start with
http://www.orafaq.com/faqloadr.htm#SPEED

After that, I'd try Google. Then if you have specific questions, try this
list again. Happy hunting!

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Wednesday, June 12, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L


We have an application that calls SQL*Loader to load data warehouse tables
every night.  We would like to speed up
the loads if possible.  Does anyone have any tips or papers on improving
performance on SQL*Loader?

Thanks!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: DENNIS WILLIAMS
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Need improvement on Oracle Loader

[Grabowy, Chris]

I don't have any white papers or anything, but...

How about SQL*Loading as soon as you get the flat files into some tables in
another database then using transportable tablespaces to move the data into
the datawarehouse?

I would think their are several ways you can preload the data and then move
the loaded tables into place.  It would just depend on which approach you
can take for your specific situation.


-Original Message-
Sent: Wednesday, June 12, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L


We have an application that calls SQL*Loader to load data warehouse tables
every night.  We would like to speed up
the loads if possible.  Does anyone have any tips or papers on improving
performance on SQL*Loader?

Thanks!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Grabowy, Chris
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: Troubleshooting ORA-01410

[Chaim . Katz]

Sean,
[4] If the problem is in the application, maybe you could trace it for a
bit, and see what the SQL looks like.
A select * from emp where rowid = '1' will  give the ORA-01410 error.
A select using an Oracle7 type rowid against an Oracle8i database will also
give the error.

Hth,
Chai






"O'Neill, Sean" <[EMAIL PROTECTED]>@fatcity.com on 06/12/2002 11:53:27
AM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



So this application running on an 8.1.7 database, NT4, has a utility
supplied by vendor which when run by one of our apps people is reporting an
ORA-01410 (invalid ROWID).  Given our "history" with the vendor in question
I have some doubts about the application =:-0

In relation to same I have a few queries:

[1]  Would an Export of the database report problems if above issue existed
in database?.  A full export is currently taken each night and completing
without any warnings.

[2]  Is dbverify any good to troubleshoot this type of error?.  I currently
run a dbverify on Offline backups of the data files in question and no
errors are being reported.  Granted this is on a "copy" of the datafiles
but
I ran a test before where I corrupted a datafile, took a copy, and the
dbverify reported problem with copy so I assume my logic is good here?.

[3] If I run ANALYZE TABLE xxx VALIDATE STRUCTURE CASCADE on offending
table
is output reported to screen?
I have not run it yet as the DB itself is "busy" a lot of the time and
above
is rcommended for quite time due to prevention of Selects, Inserts, Updates
and Deletes on object.

[4] What other methods could be used to troubleshoot this problem?.  As I
mentioned I have doubts about the vendor supplied application and would
like
to prove one way or the other if some data corruption exists or not!

Any help with above would be much appreciated :)

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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:
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Need improvement on Oracle Loader

[Smith, Ron L.]

We have an application that calls SQL*Loader to load data warehouse tables
every night.  We would like to speed up
the loads if possible.  Does anyone have any tips or papers on improving
performance on SQL*Loader?

Thanks!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: ORA-00604 and ORA-01578

[peter . lee]

Thank you to all those that replied.  Unfortunately, the corruption on the
hardware has caused other files to be corrupted.  We had to restore the
database using the export dump file after fixing the hardware problem.

Thank you to all those that replied.

Pete

-Original Message-
Sent: Wednesday, June 12, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L


Hello

Since the tablespace looks like RBS you may be able to drop that tablespace
and
recreate it again, assuming that your update transaction finished ok and the
select
use the RBS to get old values since an update is in progress.

I think that you should run also an OS disk checking utility to verify
that the problem is not a bad block/sector on the disk itself.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, June 11, 2002 7:28 PM


> I have a system when I issued a select statement, I get the following
error.
>
> ORA-00604  Error Occur at recursive level 1
>
> ORA-01578 Oracle Datablock corrupted.  File 6  Block 2853
>
> ORA-01110 Datafile 6 E:\ORANT\DATABASE\RBS1.DBS
>
> We have an export that we may be able to restore.  The database is running
> in non-archive mode.  Any idea on how to resolve this problem?
>
> Thank you in advance
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: OCI Issue

[Turner, Christine]

I was just updated by the developers, the OCI (ofen) call is performing ONLY
a select statment, not a create table. Would this make a difference?

thanks,
C-


-Original Message-
Sent: Wednesday, June 12, 2002 10:57 AM
To: Multiple recipients of list ORACLE-L


Christine,

Lets see, IF I remember my OCI correctly you pass the OCI function a
character variable that holds the SQL statement.  Is that variable large
enough
for the statement and is it NULL terminated?  I seem to remember an OCI
program
written by our CIM group that ran into this problem and the NULL terminator
was
the problem.  Actually where it was was the problem, off the far end of the
variable.

Dick Goulet

Reply Separator
Author: "Turner; Christine" <[EMAIL PROTECTED]>
Date:   6/12/2002 9:05 AM

Does anyone know anything about an ORA-1043? We are currently getting it
within our OCI layer with the application trying to perform a create table
statement with a select statement. We have issued a tar with Oracle, they
suggested the 81730 patch, which fixed one computer but not another. Now
Oracle wants a test case, which we can not provide. Same app, same database,
etc. We are running Oracle 81730, standard edition on a Windows 2000
platform.

Any help and info is greatly appreciated!

thanks,
Christine
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Turner, Christine
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Turner, Christine
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: nmi.log

[Mercadante, Thomas F]

Ramon,
 
I just 
did this the other day.
 
To 
remove the file, it did a   lsnrctl> 
dbsnmp_stop
 
and 
then deleted the file.
 
be 
sure and do a lsnrctl> dbsnmp_start
 
after.
 
hth
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Ramon E. Estevez 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 12, 2002 
  1:26 PMTo: Multiple recipients of list ORACLE-LSubject: 
  nmi.log
  Hi list,
   
  This file has grown up to 800MB.
   
   It has a lot of errors about Oracle 
  Bequeath NT Protocol Adapter
   
  Fatal NI connect error 12640 .
   
  Can I erased that file ?
   
  How do I stop writing to it or stop the error 
  ?
   
  TIA,
   
   
  Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

RE: sys corrupted in warehouse, sev1 tar open - resolved

[Jack Silvey]

It was the "alter system set current_schema=x"
statement after all.

I am sure that this raises some interesting questions,
if only I had time to dwell on it. Just now cleaning
up all the broken indexes from the loads that abended
when the db went down.

I love this job. Where else do you get to play at
work?

jack




>  --- Jack Silvey <[EMAIL PROTECTED]> wrote: >
> All,
> > 
> > thanks for the input. Looks like someone
> implemented
> > a
> > login trigger. haven't seen the code yet, but I
> > would
> > venture a guess he used the unsupported "alter
> > system
> > set current_schema=x".
> > 
> > sometimes you live and learn, sometimes you just
> > live!
> > 
> > thx,
> > 
> > jack silvey
> > 
> > 
> > --- Hately Mike <[EMAIL PROTECTED]> wrote:
> > > I don't hold out much hope here Jack. 
> > > It sounds like data dictionary corruption; maybe
> > > somewhere round user$(?).
> > > That's not to say the situation's irretrievable;
> > > I've seen OTS fix some bad
> > > situations in my time but I'm not sure that I'd
> > want
> > > to keep the database
> > > even if Oracle Support can fix the problem.
> > > 
> > > Regards,
> > > Mike
> > > 
> > > -Original Message-
> > > Sent: 12 June 2002 14:23
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Listers,
> > > 
> > > Our warehouse now has a split personality and we
> > > have
> > > a sev1 open on it. Suspect recovery is in the
> > cards,
> > > but want to avoid if possible.
> > > 
> > > Yesterday, users unable to get to their own
> > > functions.
> > > Soon after, RMAN cannot find package
> > > dbms_backup_restore, even though it exists under
> > > sys.
> > > Oncall ran the sql script to recreate - and the
> > > pacakge was recreated under a schema called
> > > dma_rbate2. RMAN now finds the package under
> > > dma_rbate2, although it is invalid. Drop the
> > package
> > > under dma_rbate2, and now RMAN cannot find the
> > > package
> > > any longer, although it still exists under sys.
> > > 
> > > Logged in as sys. Tried to desc
> > dbms_backup_restore
> > > -
> > > no luck. Tried to desc sys.dbms_backup_restore -
> > > success.
> > > 
> > > Analyst reccomends running catalog.sql. Oncall
> > does
> > > so, and it creates as many packages as it is
> able
> > > under dma_rbate2.
> > > 
> > > I get up this AM and can't login, because the
> > > sessions
> > > can't find the package
> > > dma_rbate2.dbms_application_info.
> > > 
> > > Anyone? Buhler? Buhler?
> > > 
> > > thx,
> > > 
> > > jack
> > > 
> > > 
> > >  
> > >
> >
>

> > >  
> > > 
> > > This email and any attached to it are
> confidential
> > > and intended only for the
> > > individual or 
> > > entity to which it is addressed.  If you are not
> > the
> > > intended recipient,
> > > please let us know 
> > > by telephoning or emailing the sender.  You
> should
> > > also delete the email and
> > > any attachment 
> > > from your systems and should not copy the email
> or
> > > any attachment or
> > > disclose their content 
> > > to any other person or entity.  The views
> > expressed
> > > here are not necessarily
> > > those of 
> > > Churchill Insurance Group plc or its affiliates
> or
> > > subsidiaries. Thank you. 
> > > Churchill Insurance Group plc.  Company
> > Registration
> > > Number - 2280426.
> > > England. 
> > > Registered Office: Churchill Court, Westmoreland
> > > Road, Bromley, Kent BR1
> > > 1DP. 
> > > 
> > > 
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > -- 
> > > Author: Hately Mike
> > >   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 list, send
> an
> > > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') 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).
> > 
> > 
> > __
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: Jack Silvey
> >   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 list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 

RE: Job Scheduler in 9i

[Freeman, Robert]

See inline...

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I guess if your
body's covered in third degree burns, and your foot's caught in a bear
trap, you tend to start talkin' crazy.



-Original Message-
Sent: Wednesday, June 12, 2002 8:03 AM
To: Multiple recipients of list ORACLE-L


Some comments...

>> some earlier versions of the db had job bugs where
>> the next date was not correctly calculated and thus
>> stopped running - typically threw an ora-600 or at
>> least a trace file in bdump (as opposed to udump)

Is this true in 9i? If so, can you provide any bug numbers
we can reference with Oracle? I can't seem to come up with 
any specific to 9i in Metalink.


>> - we're running about 50 jobs at various frequencies
>> on 9013 and not experienced anything you've described,
>> at which point you're probably saying 'gee thanks' :-)

Well, that may be one catch, we are currently on 9011... we have plans to
move
to 9013, but have not yet for some *cough*... very good reasons. Maybe
this is an issue with 9011. If I could identify the bug then perhaps I can
get Oracle to backport an existing patch. 


>> - see if the problem still occurs if you explicitly
>> - set next date within the job itself, ie 'procx;'
>> - becomes 'procx(next_date);' - this is not a great
>> - workaround, but it does confirm if the next date value
>> - is not being derived correctly by the scheduler itself

Tried that, no joy. It's really strange, some jobs will run all the time,
others
run once, twice, three times maybe and then just never run again.

>> - is the interval simple ? the most common errors for
>> job timings I've seen are typically dodgey interval
>> strings or passing a date to the parms instead of a
>> varchar2

Interval is something akin to "sysdate + 5/1440"... doesn't seem to complex.
Like I said, this stuff worked fine in 8i, but in 9i it runs a while and
dies.

Thanks for your thoughts!

RF



hth
connor

 --- "Freeman, Robert" <[EMAIL PROTECTED]> wrote:
> I've got a TAR open on it now, but slow movement.
> 
> RF
> 
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
> Author: Oracle9i New Features 
> Mastering Oracle8i    
> 
> Clark Griswold: Eddie, has anyone ever told you that
> you're bad luck?
> Cousin Eddie: Those were my mother's dying words.
> But I guess if your
> body's covered in third degree burns, and your
> foot's caught in a bear
> trap, you tend to start talkin' crazy.
> 
> 
> 
> -Original Message-
> Sent: Monday, June 10, 2002 2:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> We had the same situation and then we use "cron"
> that never fails. Now, we
> don't trust dbms_job ... I had a TAR open on that,
> but can't access it now.
> 
> Raj
>
__
> Rajendra JamadagniMIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't
> reflect that of ESPN Inc.
> 
> QOTD: Any clod can have facts, but having an opinion
> is an art!
> 
> 
> -Original Message-
> Sent: Monday, June 10, 2002 2:13 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Anyone run into any problems with the job scheduler
> in 9iR1 not kicking
> off jobs when they are scheduled?
> 
> We have a situation where a given job (runs every 4
> hours or so) will be
> kicked
> of successfully 2-3 times, and then on the 4th time
> the scheduler does not
> kick
> it off, next_date is not incremented... it's like
> the job just gets lost in 
> space...This same scheduled job ran fine in 8i.
> (this is an 8i to 9i
> migrated
> database)
> 
> Any thoughts on this?
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Freeman, Robert
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official

RE: Oracle 9.0.1.3 or 9.2.0?

[Grabowy, Chris]

Hello?  9.2 is the terminal release for Oracle9?  So Oracle10 is next, aside
from patches, etc. to 9?

-Original Message-
Sent: Wednesday, June 12, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L


I'd go 9.2 - its the terminal release so will
supported for longer and removes Oracle's standard
reply of 'please move to 9.2 and see if the problem
disappears'

hth
connor

 --- Raj Gopalan <[EMAIL PROTECTED]>
wrote: > Hi DBAs
> 
> We are upgrading from 8.1.5 to 9.x. I thought of
> finding out which release
> of 9i is more stable. As We have got 9.2 couple of
> weeks back, I was just
> wondering what is  worth going for 9.2 instead of
> 9.0.1.3?
> 
> TIA,
> 
> Raj
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Raj Gopalan
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Grabowy, Chris
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re:OCI Issue

[dgoulet]

Christine,

Lets see, IF I remember my OCI correctly you pass the OCI function a
character variable that holds the SQL statement.  Is that variable large enough
for the statement and is it NULL terminated?  I seem to remember an OCI program
written by our CIM group that ran into this problem and the NULL terminator was
the problem.  Actually where it was was the problem, off the far end of the
variable.

Dick Goulet

Reply Separator
Author: "Turner; Christine" <[EMAIL PROTECTED]>
Date:   6/12/2002 9:05 AM

Does anyone know anything about an ORA-1043? We are currently getting it
within our OCI layer with the application trying to perform a create table
statement with a select statement. We have issued a tar with Oracle, they
suggested the 81730 patch, which fixed one computer but not another. Now
Oracle wants a test case, which we can not provide. Same app, same database,
etc. We are running Oracle 81730, standard edition on a Windows 2000
platform.

Any help and info is greatly appreciated!

thanks,
Christine
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Turner, Christine
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Discount book website

[Freeman, Robert]

Bookpool is generally the cheapest site I've found.
They just had a 44% off Oracle Press Sale, which is now over.
Sybex books (including my Oracle8i New Features book) are now
on sale at 44% off!!!

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features 
Mastering Oracle8i    

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I guess if your
body's covered in third degree burns, and your foot's caught in a bear
trap, you tend to start talkin' crazy.



-Original Message-
Sent: Wednesday, June 12, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


I did a quick compare and bookpool.com still has better prices.

Mr. Freeman's book is 4 bucks less on bookpool.com, which basically pays for
shipping, compared to mhorder.com.

The Oracle9i Web Development book is $36.95 on bookpool.com and $44.99 on
mhorder.com, 8 bucks diff, 38% off.

You decide...

-Original Message-
Sent: Tuesday, June 11, 2002 9:05 PM
To: Multiple recipients of list ORACLE-L


I ordered and received my 9ir2 docs(only $9.95 ans s/h), anyways in the 
box is a form:

http://www.mhorder.com/oracle9i


there is 25% savings on some of the 9i books there.

Joe


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Grabowy, Chris
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Freeman, Robert
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: URGENT Off-topic -> Triggers in Informix

[Bob Lofstrand]

Also 
check out www.informix.com/documentation 
to find the online docs.
Informix guide to SQL: Syntax will give you the 
complete run down.

  -Original Message-From: Bob Lofstrand 
  Sent: Wednesday, June 12, 2002 11:26 AMTo: 
  '[EMAIL PROTECTED]'Subject: RE: URGENT Off-topic -> Triggers 
  in Informix
  Informix? Your a ways from home. :)
   
  If I 
  remember correctly you just need some parentheses:
   
  create trigger cmst_trigUPDATE on cmstfor each 
  row( execute procedure sp_cmst_upd ( ) );
   
  Surround your actions with parens and you must 
  call your procedure with empty parens if there are no parameters to 
  pass.
   
  Check out http://www.iiug.org to find and sign up for the 
  Informix listserv.
  
-Original Message-From: Santosh Varma 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 12, 2002 1:33 
AMTo: Multiple recipients of list ORACLE-LSubject: 
URGENT Off-topic -> Triggers in Informix
I wrote a 
trigger in Informix ->
 
create trigger 
cmst_trigUPDATE on cmstfor each rowexecute procedure 
sp_cmst_upd; 
 
But this is 
giving Syntax Error...Any help is welcome...
Thanks and regards,Santosh 


The information contained in this e-mail is strictly confidential and for the intended 
use of the addressee only; it may also be legally privileged and/or price sensitive.  
Notice is hereby given that any disclosure, use or copying of the information by 
anyone other than the intended recipient is prohibited and may be illegal.  If you 
have received this message in error, please notify the sender immediately by return 
e-mail.

Corporate Systems, Inc. has taken every reasonable precaution to ensure that any 
attachment to this e-mail has been swept for viruses.  We accept no liability for any 
damage sustained as a result of software viruses and advise you carry out your own 
virus checks before opening any attachment.

Re: ORA-00604 and ORA-01578

[Yechiel Adar]

Hello

Since the tablespace looks like RBS you may be able to drop that tablespace
and
recreate it again, assuming that your update transaction finished ok and the
select
use the RBS to get old values since an update is in progress.

I think that you should run also an OS disk checking utility to verify
that the problem is not a bad block/sector on the disk itself.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, June 11, 2002 7:28 PM


> I have a system when I issued a select statement, I get the following
error.
>
> ORA-00604  Error Occur at recursive level 1
>
> ORA-01578 Oracle Datablock corrupted.  File 6  Block 2853
>
> ORA-01110 Datafile 6 E:\ORANT\DATABASE\RBS1.DBS
>
> We have an export that we may be able to restore.  The database is running
> in non-archive mode.  Any idea on how to resolve this problem?
>
> Thank you in advance
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: sys corrupted in warehouse, sev1 tar open - resolved

[Connor McDonald]

Its like the old

"Experience is what you get when you were expecting
something else..."

Cheers
Connor

 --- Jack Silvey <[EMAIL PROTECTED]> wrote: > All,
> 
> thanks for the input. Looks like someone implemented
> a
> login trigger. haven't seen the code yet, but I
> would
> venture a guess he used the unsupported "alter
> system
> set current_schema=x".
> 
> sometimes you live and learn, sometimes you just
> live!
> 
> thx,
> 
> jack silvey
> 
> 
> --- Hately Mike <[EMAIL PROTECTED]> wrote:
> > I don't hold out much hope here Jack. 
> > It sounds like data dictionary corruption; maybe
> > somewhere round user$(?).
> > That's not to say the situation's irretrievable;
> > I've seen OTS fix some bad
> > situations in my time but I'm not sure that I'd
> want
> > to keep the database
> > even if Oracle Support can fix the problem.
> > 
> > Regards,
> > Mike
> > 
> > -Original Message-
> > Sent: 12 June 2002 14:23
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Listers,
> > 
> > Our warehouse now has a split personality and we
> > have
> > a sev1 open on it. Suspect recovery is in the
> cards,
> > but want to avoid if possible.
> > 
> > Yesterday, users unable to get to their own
> > functions.
> > Soon after, RMAN cannot find package
> > dbms_backup_restore, even though it exists under
> > sys.
> > Oncall ran the sql script to recreate - and the
> > pacakge was recreated under a schema called
> > dma_rbate2. RMAN now finds the package under
> > dma_rbate2, although it is invalid. Drop the
> package
> > under dma_rbate2, and now RMAN cannot find the
> > package
> > any longer, although it still exists under sys.
> > 
> > Logged in as sys. Tried to desc
> dbms_backup_restore
> > -
> > no luck. Tried to desc sys.dbms_backup_restore -
> > success.
> > 
> > Analyst reccomends running catalog.sql. Oncall
> does
> > so, and it creates as many packages as it is able
> > under dma_rbate2.
> > 
> > I get up this AM and can't login, because the
> > sessions
> > can't find the package
> > dma_rbate2.dbms_application_info.
> > 
> > Anyone? Buhler? Buhler?
> > 
> > thx,
> > 
> > jack
> > 
> > 
> >  
> >
>

> >  
> > 
> > This email and any attached to it are confidential
> > and intended only for the
> > individual or 
> > entity to which it is addressed.  If you are not
> the
> > intended recipient,
> > please let us know 
> > by telephoning or emailing the sender.  You should
> > also delete the email and
> > any attachment 
> > from your systems and should not copy the email or
> > any attachment or
> > disclose their content 
> > to any other person or entity.  The views
> expressed
> > here are not necessarily
> > those of 
> > Churchill Insurance Group plc or its affiliates or
> > subsidiaries. Thank you. 
> > Churchill Insurance Group plc.  Company
> Registration
> > Number - 2280426.
> > England. 
> > Registered Office: Churchill Court, Westmoreland
> > Road, Bromley, Kent BR1
> > 1DP. 
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: Hately Mike
> >   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 list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') 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).
> 
> 
> __
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jack Silvey
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the offi

Re: Oracle 9.0.1.3 or 9.2.0?

[Connor McDonald]

I'd go 9.2 - its the terminal release so will
supported for longer and removes Oracle's standard
reply of 'please move to 9.2 and see if the problem
disappears'

hth
connor

 --- Raj Gopalan <[EMAIL PROTECTED]>
wrote: > Hi DBAs
> 
> We are upgrading from 8.1.5 to 9.x. I thought of
> finding out which release
> of 9i is more stable. As We have got 9.2 couple of
> weeks back, I was just
> wondering what is  worth going for 9.2 instead of
> 9.0.1.3?
> 
> TIA,
> 
> Raj
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Raj Gopalan
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: URGENT Off-topic -> Triggers in Informix

[Bob Lofstrand]

Informix? Your a ways from home. :)
 
If I 
remember correctly you just need some parentheses:
 
create trigger cmst_trigUPDATE on cmstfor each 
row( execute procedure sp_cmst_upd ( ) );
 
Surround your actions with parens and you must 
call your procedure with empty parens if there are no parameters to 
pass.
 
Check out http://www.iiug.org to find and sign up for the 
Informix listserv.

  -Original Message-From: Santosh Varma 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 12, 2002 1:33 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  URGENT Off-topic -> Triggers in Informix
  I wrote a trigger 
  in Informix ->
   
  create trigger 
  cmst_trigUPDATE on cmstfor each rowexecute procedure sp_cmst_upd; 
  
   
  But this is giving 
  Syntax Error...Any help is welcome...
  Thanks and regards,Santosh 


The information contained in this e-mail is strictly confidential and for the intended 
use of the addressee only; it may also be legally privileged and/or price sensitive.  
Notice is hereby given that any disclosure, use or copying of the information by 
anyone other than the intended recipient is prohibited and may be illegal.  If you 
have received this message in error, please notify the sender immediately by return 
e-mail.

Corporate Systems, Inc. has taken every reasonable precaution to ensure that any 
attachment to this e-mail has been swept for viruses.  We accept no liability for any 
damage sustained as a result of software viruses and advise you carry out your own 
virus checks before opening any attachment.

nmi.log

[Ramon E. Estevez]

Hi list,
 
This file has grown up to 800MB.
 
 It has a lot of errors about Oracle 
Bequeath NT Protocol Adapter
 
Fatal NI connect error 12640 .
 
Can I erased that file ?
 
How do I stop writing to it or stop the error 
?
 
TIA,
 
 
Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

RE: RE: Goodbye e3000 & TRU64

[Boivin, Patrice J]

They said the same here (Halifax, eastern Canada) re. Tru64 during an Oracle
Technology Day about two months ago.

No mention of LINUX or HP-UX, though, this was a joint thing between Oracle
and Compaq.

The Compaq cluster servers were really impressive, each one about the size
of a laptop.  Their demonstration went very smoothly.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent: Wednesday, June 12, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L


Brian,

Wasn't that before the merger annopuncement?  At a somewhat recent
Oracle
get together they said they were working with HP and Red Hat to get a shared
filesystem developed so that RAC could run without raw devices.  Compaq's
TRU64
already had it.  Wonder where HP thought they'd get theirs?

Dick Goulet

Reply Separator
Author: Brian McGraw <[EMAIL PROTECTED]>
Date:   6/12/2002 6:48 AM

That's interesting.  

At the 2001 IOUG, I seem to remember someone from Compaq touting how the
TRU64 platform was chosen by Oracle for the initial development of RAC,
and was supposedly the premiere platform for RAC - including getting
away from raw file systems.

Brian

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L

Someone, I don't remember who, commented the other day about not wanting
to
leave their TRU64 environment.  Well according to the following form
Infoweek,
you may not have an option!

Dick Goulet

Mandatory Oracle Plug: Another successful migration from TurboImage
(YUCK) to
Oracle included.



---

** Popular HP Server Bid Farewell

Hewlett-Packard is enticing owners of its once-popular, 
now-doomed e3000 servers to buy HP-UX or Linux systems. The most 
likely migration path will be to HP 9000 servers running HP-UX, 
although buyers could also move to Intel-based ProLiant servers. 
HP is using a number of migration programs, including one that 
provides e3000 customers with "loaner" HP 9000s until they can 
make a full transition.
It's also doing free migration assessments through HP Services 
and software and hardware trade-in rebates.

HP's approach to retiring products will be closely watched, 
especially as it reconciles its product line with that of the 
newly acquired Compaq. Gartner analyst Paul McGuckin says this 
process "might help them see what works and what doesn't when 
they phase out [Compaq] Tru64" Unix machines.

Virginia International Terminals is taking HP up on its offers. 
VIT manages Virginia's shipping ports, using four e3000 servers 
to track 1 million containers annually along the state's 
shoreline. When HP said it was discontinuing the e3000, "it sent 
a shockwave through our organization," says Clark Farabaugh, 
VIT's assistant IT director. VIT took advantage of HP's loaner
program to begin migrating its container-management apps to 
HP-UX, scuttle its old e3000 Turbo Image database, and adopt the 
more Web-friendly Oracle 9i. - Larry Greenemeier

For more, read:
Analyst: HP Cut Chip Orders From Intel By 50%
http://update.informationweek.com/cgi-bin4/flo?y=eHe60BdFGA0V20Bd720AD

Fiorina: HP To Achieve Cost Cuts Ahead Of Schedule
http://update.informationweek.com/cgi-bin4/flo?y=eHe60BdFGA0V20Bdnc0Av
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Brian McGraw
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-

Re: Newline char in oracle files

[Yechiel Adar]

Title: Newline char in oracle files



Hello Beth
 
Had the same problem after upgrading from 81600 to 
81634.
I downloaded textpad from the internet and it solved the 
problem.
It is also much nicer then wordpad.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Seefelt, Beth 
  To: Multiple recipients of list ORACLE-L 
  Sent: Friday, June 07, 2002 5:38 PM
  Subject: Newline char in oracle 
  files
  
  Hi everybody, 
  I have a very odd problem I hope someone can help 
  me with.  I've installed Oracle, OEM and OWB on a couple of NT 4.0 
  servers in the UK.  The text files that Oracle generates during the 
  install - the .config, .ora and the .ctl files from OWB - are generated using 
  a lf as the newline character instead of a cr.  The result is that in 
  notepad they all appear as one run-on line with embedded control characters 
  (line feeds).  I have not had this problem on any of the servers in the 
  US.
  I'm using the same installation media in both 
  places.  Is there UK specific media I should be using?  Or is there 
  is something in the regional settings on the servers that would determine what 
  newline character is used?  
  I've checked the Oracle and Microsoft support sites 
  and even opened a tar but am still stumped, so any suggestions will be 
  appreciated.  I've tried contacting our sysadmin about it but I don't 
  expect any response until the England/Argentina match is over :-)
  TIA, 
  Beth 

Oracle 9.0.1.3 or 9.2.0?

[Raj Gopalan]

Hi DBAs

We are upgrading from 8.1.5 to 9.x. I thought of finding out which release
of 9i is more stable. As We have got 9.2 couple of weeks back, I was just
wondering what is  worth going for 9.2 instead of 9.0.1.3?

TIA,

Raj
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Gopalan
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: Locking Issue

[Bill Pass]

Yes.

If your application executes a DML statement and then
just hangs around without commiting or doing a
rollback this will occur. A user forgetting to commit
or rollback from SQL*Plus is often the cause of
locking problems.

Bill

--- Hamid Alavi <[EMAIL PROTECTED]> wrote:
> List,
> I am monitoring a locking issue on database(oracle
> 8.1.7.0 on sun ), when I
> look at all active session there are no active
> session, but the same time
> there are two active rollback segment assign to two
> session, my question is
> can we have an inactive session with an active
> rollback segment?
> Thanks,
> 
> 
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 
> 
> 
> 
> 
> 
> === Confidentiality Statement
> === 
> The information contained in this message and any
> attachments is 
> intended only for the use of the individual or
> entity to which it is 
> addressed, and may contain information that is
> PRIVILEGED, CONFIDENTIAL 
> and exempt from disclosure under applicable law.  If
> you have received 
> this message in error, you are prohibited from
> copying, distributing, or 
> using the information.  Please contact the sender
> immediately by return 
> e-mail and delete the original message from your
> system. 
> = End Confidentiality Statement
> =  
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Hamid Alavi
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

OCI Issue

[Turner, Christine]

Does anyone know anything about an ORA-1043? We are currently getting it
within our OCI layer with the application trying to perform a create table
statement with a select statement. We have issued a tar with Oracle, they
suggested the 81730 patch, which fixed one computer but not another. Now
Oracle wants a test case, which we can not provide. Same app, same database,
etc. We are running Oracle 81730, standard edition on a Windows 2000
platform.

Any help and info is greatly appreciated!

thanks,
Christine
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Turner, Christine
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: 64-bit OS

[Charlie Mengler]

memconf is one command which will give you the answer.


YTTRI Lisa wrote:
> 
> Hi -
> 
> We have just installed Solaris 2.8 (8) on a new SUN server.  Is there a
> command I can run to tell if it's running in 64-bit mode?
> 
> If I'm building a database for a homegrown Oracle data warehouse - would it
> be best to run 64-bit Oracle?
> 
> Lisa
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: YTTRI  Lisa
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct.
858-831-2229  San Diego, CA 92131
Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Data Warehouse design

[DENNIS WILLIAMS]

Inder - Offhand I'd say everything depends on how much data you are loading,
and the available time window. We do the type of validation you suggest on
our DW, but it is relatively small in the universe of DWs and we only load
it on the weekend. On a really large DW, your scheme might cause the load
times to be unreasonably large. What I have heard from the really large
sites is that they often use Unix utilities to perform data cleaning before
loading.
Often the main advantage of primary keys is to help prevent someone
at your site from accidentally loading the same data twice.

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Wednesday, June 12, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L



Hi,

I am in the process of designing the data warehouse. My Question is can I
define the relationship between dimension tables. Like I have
country,customer and time zone dimension tables. Can I add relationship
between customer,country and time zone just to validate the data before load
whether the country and zip code is correct or should I integrate the
country and time zone with customer itself. If I integrate this. Is it going
to affect the performance. 'cos for every record it is going to validate all
these things before load.  

Can I create sequences for primary keys(fact tables and for some of the
dimenasion tables also). Is it OK to have a sequence as primary key. 

I need your expert views on this.

Regards,

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: DENNIS WILLIAMS
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: 64-bit OS

[SARKAR, Samir]

Lisa,

Just type the command 

 isainfo -kv

This will give u the result. You will have to run this as root.

HTH,
Samir

Samir Sarkar
Oracle DBA 
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 12 June 2002 17:18
To: Multiple recipients of list ORACLE-L


Hi - 

We have just installed Solaris 2.8 (8) on a new SUN server.  Is there a
command I can run to tell if it's running in 64-bit mode?

If I'm building a database for a homegrown Oracle data warehouse - would it
be best to run 64-bit Oracle? 

Lisa

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: YTTRI  Lisa
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: 64-bit OS

[DENNIS WILLIAMS]

Lise - Use the Unix "file" command on the "oracle" file, as in
file $ORACLE_HOME/bin/oracle

Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Wednesday, June 12, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L


Hi - 

We have just installed Solaris 2.8 (8) on a new SUN server.  Is there a
command I can run to tell if it's running in 64-bit mode?

If I'm building a database for a homegrown Oracle data warehouse - would it
be best to run 64-bit Oracle? 

Lisa

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: YTTRI  Lisa
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: DENNIS WILLIAMS
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

64-bit OS

[YTTRI Lisa]

Hi - 

We have just installed Solaris 2.8 (8) on a new SUN server.  Is there a
command I can run to tell if it's running in 64-bit mode?

If I'm building a database for a homegrown Oracle data warehouse - would it
be best to run 64-bit Oracle? 

Lisa

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: YTTRI  Lisa
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: RE: Goodbye e3000 & TRU64

[Jesse, Rich]

A-ha!  This'll explain what I meant:


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 9:48 AM
> To: Jesse, Rich; Multiple recipients of list ORACLE-L
> Subject: Re:RE: Goodbye e3000 & TRU64
> 
> 
> Rich,
> 
> I'm sure they will, some sort of merge of TRU64 and 
> HP-UX.  Now, IF we get
> the best of both OS's we'll probably have a real good end product.
> 
> Dick Goulet
> 
> Reply Separator
> Subject:RE: Goodbye e3000 & TRU64
> Author: "Jesse; Rich" <[EMAIL PROTECTED]>
> Date:   6/12/2002 6:43 AM
> 
> I don't think they can completely cut out Tru64 without 
> offering another
> Unix solution for the Alpha chip.  They've already announced 
> the EV7 and
> EV79 cuts of the Alpha for 2003 and 2004 (I think, or was it 2005?).
> 
> Hell, HPaq's even announced they'll support my beloved 
> OpenVMS until at
> least 2012, so I wouldn't be that worried -- yet.
> 
> My $.02,
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI USA
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 12, 2002 9:03 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Goodbye e3000 & TRU64
> > 
> > 
> > Someone, I don't remember who, commented the other day about 
> > not wanting to
> > leave their TRU64 environment.  Well according to the 
> > following form Infoweek,
> > you may not have an option!
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jesse, Rich
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: REPLICATION: Quest Shareplex

[johanna . doran]

Hi,

I changed the Subject to SHAREPLEX, lets close out the contention thread.  
Could be why there are no responses.   A couple people on the list definitely use it 
and I know I certaintly will have a lot to say about it but have to do it later as I 
am working on Prod issues right now.

Thanks,

Hannah

>  -Original Message-
> From: [EMAIL PROTECTED]@SUNGARD   On Behalf Of Rachel Carmichael 
><[EMAIL PROTECTED]>
> Sent: Wednesday, June 12, 2002 11:33 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: I/O contention with external process reading the oracle logs 
>(online redo logs)
> 
> Shareplex reads the log files so if you can't get the log files
> over the existing line, Shareplex can't read them.
> 
> have you considered using an NFS mounted disk for your archive log
> directory?
> 
> or a process that copies the archived logs to the nfs mounted disk on
> the primary and a another process that copies them off the nfs mounted
> disk on the secondary?
> 
> I had to do something like that when I worked with Sybase, back in the
> 4.7 days, so that I could "backup" the log files realtime.
> 
> 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Data Warehouse design

[Inder . Singh]

Hi,

I am in the process of designing the data warehouse. My Question is can I
define the relationship between dimension tables. Like I have
country,customer and time zone dimension tables. Can I add relationship
between customer,country and time zone just to validate the data before load
whether the country and zip code is correct or should I integrate the
country and time zone with customer itself. If I integrate this. Is it going
to affect the performance. 'cos for every record it is going to validate all
these things before load.  

Can I create sequences for primary keys(fact tables and for some of the
dimenasion tables also). Is it OK to have a sequence as primary key. 

I need your expert views on this.

Regards,

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

9iRelease2 Upgrade Alert -- PLSQL objects referencing 8i database

[Hemant K Chitale]

 
 


  
  
Bookmark
Fixed 
  font 
Go to End

  
  

  


  Doc ID: 

  Note:189914.1

  Subject: 
  Recompilation of PLSQL may fail after Upgrading to Oracle9i 
(ORA-3113 in UTLRP)

  Type: 
  UPGRADE NOTE

  Status: 
  PUBLISHED

  


  Content Type: 
  TEXT/PLAIN

  Creation Date: 
  16-MAY-2002

  Last Revision Date: 
  16-MAY-2002UTLRP may dump if PLSQL references an Oracle8i Database  [BUG:1978040]
~~~
Versions Affected
~
  This problem affects Oracle versions 9.0.1.0 to 9.0.1.2 inclusive.
  The issue is fixed in 9.0.1.3 and Oracle9i Release 2 (9.2.0.1)

Platforms Affected
~~
  GENERIC  - all platforms are affected

Description
~~~
  Recompilation of PLSQL which references objects in remote Oracle8i
  (or earlier) databases via a DBLINK may result in the session
  crashing with ORA-7445 [kglobld] or ORA-3113 errors.

  This can affects recompilation of PLSQL during upgrades to Oracle9i.

Likelihood of Occurrence

  You can hit this problem if PLSQL contains SQL or constructs which
  use a database link to an Oracle8i (or earlier) database.


Possible Symptoms
~
  This problem shows up as compilation of the PLSQL aborting
  with an ORA-3113 error reported to the client, and typically an
  ORA-7445 [kglobld] error in the trace file with the current SQL
  statement showing a reference to a remote database.

Workaround
~~
  One workaround is to upgrade the remote database to Oracle9i.
  If this is not possible then upgrade to 9.0.1.3 or higher
  where this issue is fixed.

Patches
~~~
  This issue is fixed in the 9.0.1.3 (and higher) patch set.

References
~~
  Base bug for this problem [BUG:1978040]

Re:RE: Goodbye e3000 & TRU64

[dgoulet]

Rich,

I'm sure they will, some sort of merge of TRU64 and HP-UX.  Now, IF we get
the best of both OS's we'll probably have a real good end product.

Dick Goulet

Reply Separator
Author: "Jesse; Rich" <[EMAIL PROTECTED]>
Date:   6/12/2002 6:43 AM

I don't think they can completely cut out Tru64 without offering another
Unix solution for the Alpha chip.  They've already announced the EV7 and
EV79 cuts of the Alpha for 2003 and 2004 (I think, or was it 2005?).

Hell, HPaq's even announced they'll support my beloved OpenVMS until at
least 2012, so I wouldn't be that worried -- yet.

My $.02,

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 9:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Goodbye e3000 & TRU64
> 
> 
> Someone, I don't remember who, commented the other day about 
> not wanting to
> leave their TRU64 environment.  Well according to the 
> following form Infoweek,
> you may not have an option!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re:RE: Goodbye e3000 & TRU64

[dgoulet]

Brian,

Wasn't that before the merger annopuncement?  At a somewhat recent Oracle
get together they said they were working with HP and Red Hat to get a shared
filesystem developed so that RAC could run without raw devices.  Compaq's TRU64
already had it.  Wonder where HP thought they'd get theirs?

Dick Goulet

Reply Separator
Author: Brian McGraw <[EMAIL PROTECTED]>
Date:   6/12/2002 6:48 AM

That's interesting.  

At the 2001 IOUG, I seem to remember someone from Compaq touting how the
TRU64 platform was chosen by Oracle for the initial development of RAC,
and was supposedly the premiere platform for RAC - including getting
away from raw file systems.

Brian

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L

Someone, I don't remember who, commented the other day about not wanting
to
leave their TRU64 environment.  Well according to the following form
Infoweek,
you may not have an option!

Dick Goulet

Mandatory Oracle Plug: Another successful migration from TurboImage
(YUCK) to
Oracle included.



---

** Popular HP Server Bid Farewell

Hewlett-Packard is enticing owners of its once-popular, 
now-doomed e3000 servers to buy HP-UX or Linux systems. The most 
likely migration path will be to HP 9000 servers running HP-UX, 
although buyers could also move to Intel-based ProLiant servers. 
HP is using a number of migration programs, including one that 
provides e3000 customers with "loaner" HP 9000s until they can 
make a full transition.
It's also doing free migration assessments through HP Services 
and software and hardware trade-in rebates.

HP's approach to retiring products will be closely watched, 
especially as it reconciles its product line with that of the 
newly acquired Compaq. Gartner analyst Paul McGuckin says this 
process "might help them see what works and what doesn't when 
they phase out [Compaq] Tru64" Unix machines.

Virginia International Terminals is taking HP up on its offers. 
VIT manages Virginia's shipping ports, using four e3000 servers 
to track 1 million containers annually along the state's 
shoreline. When HP said it was discontinuing the e3000, "it sent 
a shockwave through our organization," says Clark Farabaugh, 
VIT's assistant IT director. VIT took advantage of HP's loaner
program to begin migrating its container-management apps to 
HP-UX, scuttle its old e3000 Turbo Image database, and adopt the 
more Web-friendly Oracle 9i. - Larry Greenemeier

For more, read:
Analyst: HP Cut Chip Orders From Intel By 50%
http://update.informationweek.com/cgi-bin4/flo?y=eHe60BdFGA0V20Bd720AD

Fiorina: HP To Achieve Cost Cuts Ahead Of Schedule
http://update.informationweek.com/cgi-bin4/flo?y=eHe60BdFGA0V20Bdnc0Av
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Brian McGraw
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Troubleshooting ORA-01410

[O'Neill, Sean]

So this application running on an 8.1.7 database, NT4, has a utility
supplied by vendor which when run by one of our apps people is reporting an
ORA-01410 (invalid ROWID).  Given our "history" with the vendor in question
I have some doubts about the application =:-0

In relation to same I have a few queries:

[1]  Would an Export of the database report problems if above issue existed
in database?.  A full export is currently taken each night and completing
without any warnings.

[2]  Is dbverify any good to troubleshoot this type of error?.  I currently
run a dbverify on Offline backups of the data files in question and no
errors are being reported.  Granted this is on a "copy" of the datafiles but
I ran a test before where I corrupted a datafile, took a copy, and the
dbverify reported problem with copy so I assume my logic is good here?.

[3] If I run ANALYZE TABLE xxx VALIDATE STRUCTURE CASCADE on offending table
is output reported to screen?
I have not run it yet as the DB itself is "busy" a lot of the time and above
is rcommended for quite time due to prevention of Selects, Inserts, Updates
and Deletes on object.

[4] What other methods could be used to troubleshoot this problem?.  As I
mentioned I have doubts about the vendor supplied application and would like
to prove one way or the other if some data corruption exists or not!

Any help with above would be much appreciated :) 

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Data Warehouse Architect with Oracle DBA experience needed..

[OraStaff]

Established up and coming company in Cleveland, Ohio needs a Data Warehouse
Architect who
has Oracle DBA Data Warehouse experience to join its IT team.
This company has been around since 1987 and is growing by leaps and bounds. 
They are a dynamic company with a corporate environment that encourages 
creativity and teaming.

Candidates who are not in the Greater Cleveland area must be willing to pay
their
own relocation expenses in order to be considered for this position.

PLEASE Do Not send your resume for this position UNLESS you have the
qualifications
for this position.

Please Do Not send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

This is a full time staff position so no sub-contractors or third parties
please.

No H-1B candidates please.

Description:
This position manages system development projects under the general
supervision of
the Sr. Manager. 
Prepares supporting documentation for new project proposals and changes 
to existing systems.
Coordinates the implementation of new projects, maintains and changes to
existing systems.

Requirements:
-Bachelors degree in Computer Science or related business discipline.
-Must Have experience as an Oracle DBA with Datawarehousing skills. 
-Must Be Proficiency in Informatica Power Center and any analytical tools.
-Three (3) to five (5) years experience within a manufacturing and service
environment. 
-Minimum of one-year data warehouse experience.
-In-depth understanding of the business environment, processes, procedures, and
 information technology. 
-Excellent business analysis, decision-making, and communication skills.
-U.S. citizenship or permanent residency.

The base salary range depends on experience...but goes up to 80K.

Candidates who are not in the Greater Cleveland area must be willing to pay
their
own relocation expenses in order to be considered for this position.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Cleveland/D.W. Architect/AJ

ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraStaff
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: RE: Goodbye e3000 & TRU64

[Jesse, Rich]

D'oh!  This time I'll hit the CORRECT keys...  

http://www.compaq.com/hps/download/Tru64UNIX_OpenVMS_Times_Rev2_052202.pdf

Tru64 Clustering will be moving to HP/UX.  D-rool, d-rool!

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


> -Original Message-
> From: Jesse, Rich 
> Sent: Wednesday, June 12, 2002 10:06 AM
> To: '[EMAIL PROTECTED]'; Multiple recipients of list ORACLE-L
> Subject: RE: RE: Goodbye e3000 & TRU64
> 
> 
> A-ha!  This'll explain what I meant:
> 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 12, 2002 9:48 AM
> > To: Jesse, Rich; Multiple recipients of list ORACLE-L
> > Subject: Re:RE: Goodbye e3000 & TRU64
> > 
> > 
> > Rich,
> > 
> > I'm sure they will, some sort of merge of TRU64 and 
> > HP-UX.  Now, IF we get
> > the best of both OS's we'll probably have a real good end product.
> > 
> > Dick Goulet
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: warehouse gets very strange - sys corrupted - sev1 tar

[Thomas Day]

My sentiments exactly.  If you can't drop the schema, go to dba_objects and
drop everything that has a  CREATED that matches the time when the
catalog.sql was mis-run.

Sounds as if someone decided to clean up the database and dropped all those
PUBLIC SYNONYMS that they didn't understand.

You're probably going to have to re-run catalog.sql as SYS also.

It doesn't sound too serious, just don't mess up the database anymore.
Make sure that you understand what you're doing and why you're doing it.



   

Jack van   

ZanenTo: Multiple recipients of list ORACLE-L  



@EY.NL>  cc:   

Sent by: rootSubject: Re: warehouse gets very strange 
-
 sys corrupted - sev1 tar  

   

06/12/2002 

09:48 AM   

Please 

respond to 

ORACLE-L   

   

   






Hi


Did the oncall run catalog.sql as dma_rbate2?? If so he should have been in
bed.

You now have all the packages and procedures created in catalog living in
dma_rbate2 schema? can you drop that schema?

You can desc sys.dbms_backup_restore. Did you loose a public/private
synonym here that can solve the problem of rman not being able to find the
package??


Jack



  Jack Silvey
  
  o.com>   cc:   (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  warehouse gets
very strange - sys corrupted - sev1 tar
  [EMAIL PROTECTED]


  12-06-2002 15:23
  Please respond to
  ORACLE-L





Listers,

Our warehouse now has a split personality and we have
a sev1 open on it. Suspect recovery is in the cards,
but want to avoid if possible.

Yesterday, users unable to get to their own functions.
Soon after, RMAN cannot find package
dbms_backup_restore, even though it exists under sys.
Oncall ran the sql script to recreate - and the
pacakge was recreated under a schema called
dma_rbate2. RMAN now finds the package under
dma_rbate2, although it is invalid. Drop the package
under dma_rbate2, and now RMAN cannot find the package
any longer, although it still exists under sys.

Logged in as sys. Tried to desc dbms_backup_restore -
no luck. Tried to desc sys.dbms_backup_restore -
success.

Analyst reccomends running catalog.sql. Oncall does
so, and it creates as many packages as it is able
under dma_rbate2.

I get up this AM and can't login, because the sessions
can't find the package
dma_rbate2.dbms_application_info.

Anyone? Buhler? Buhler?

thx,

jack




__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
v

REPLICATION: Quest Shareplex

[johanna . doran]

Title: REPLICATION: Quest Shareplex






Hi,


    I changed the Subject to SHAREPLEX, lets close out the contention thread.  Could be why there are no responses.   A couple people on the list definitely use it and I know I certaintly will have a lot to say about it but have to do it later as I am working on Prod issues right now.

Thanks,


    Hannah


 -Original Message-

From:   [EMAIL PROTECTED]@SUNGARD   On Behalf Of Rachel Carmichael <[EMAIL PROTECTED]>

Sent:   Wednesday, June 12, 2002 11:33 AM

To: Multiple recipients of list ORACLE-L

Subject:    Re: I/O contention with external process reading the oracle logs (online redo logs)


Shareplex reads the log files so if you can't get the log files

over the existing line, Shareplex can't read them.


have you considered using an NFS mounted disk for your archive log

directory?


or a process that copies the archived logs to the nfs mounted disk on

the primary and a another process that copies them off the nfs mounted

disk on the secondary?


I had to do something like that when I worked with Sybase, back in the

4.7 days, so that I could "backup" the log files realtime.





--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Mysterious Deadlock

[Vadim Gorbounov]

Walter, 
Any chance the application uses autonomous transaction? 

Vadim

-Original Message-
Sent: Thursday, June 06, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L


We have an application that is periodically 
encountering what appears to be a self-deadlock. Only 
one session is listed and it holds an exclusive (X) 
lock and is waiting for a share (S) lock with NO ROWS 
waited. I have pasted the deadlock graph at the bottom-
-hopefully it will be legible.

Does anyone know how such a lock could be produced? 
I'd really like to be able to recreate such a scenario.

Thanks!
-w

Current SQL statement for this session:
update ACCOUNT set 
ACCOUNT_ID=:ACCOUNT_ID,ACCOUNT_NAME=:ACCOUNT_NAME,LAST_
MODIFIED=:LAST_MODIFIED,CUSTOMER_NODE_ID=:CUSTOMER_NODE
_ID,ACCOUNT_TYPE_ID=:ACCOUNT_TYPE_ID,ACCOUNT_BALANCE=:A
CCOUNT_BALANCE,BALANCE_DATE=:BALANCE_DATE,INVOICE_ID=:I
NVOICE_ID,PREVIOUS_INVOICE_ID=:PREVIOUS_INVOICE_ID,CRED
IT_LIMIT=:CREDIT_LIMIT,UNBILLED_AMOUNT=:UNBILLED_AMOUNT
,ACCOUNT_ACTION_CODE=:ACCOUNT_ACTION_CODE,ACCOUNT_ACTIO
N_DATE=:ACCOUNT_ACTION_DATE where 
ACCOUNT_ID=:key_ACCOUNT_ID
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an 
application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
   -Blocker(s)  ---
--Waiter(s)-
Resource Name  process session holds waits  
process session holds waits
TX-0007004c-26bf34  95 
X 34  95   S
session 95: DID 0001-0025-0002E096  session 95: 
DID 0001-0025-0002E096
Rows waited on:
Session 95: no row

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Vadim Gorbounov
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: I/O contention with external process reading the oracle logs (online redo logs)

[Rachel Carmichael]

Shareplex reads the log files so if you can't get the log files
over the existing line, Shareplex can't read them.

have you considered using an NFS mounted disk for your archive log
directory?

or a process that copies the archived logs to the nfs mounted disk on
the primary and a another process that copies them off the nfs mounted
disk on the secondary?

I had to do something like that when I worked with Sybase, back in the
4.7 days, so that I could "backup" the log files realtime.


--- Yechiel Adar <[EMAIL PROTECTED]> wrote:
> Hello Tim and Rachel
> 
> There is band width problem. The line is 256K (we are checking
> upgrade to
> 512k).
> The database, during peek time produce 10MB of logs every 2-3
> minutes.
> On this line it will take 7-8 minutes to pass 10MB if the line was
> dedicate
> and it is not dedicated.
> 
> Upgrading the line to more then 512K need E1 at least and it is
> expansive.
> 
> Since replication will need less band width we are checking it.
> 
> To return to my original question:
> Quest Shareplex -
> Any success stories?
> Why use this and not replication?
> Ant performance tests between Shareplex and Oracle replication?
> 
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Monday, June 10, 2002 4:33 AM
> (online redo logs)
> 
> 
> > and if you need the remote site to support users, you could use the
> > logical standby feature of 9iR2, which generates SQL statements to
> be
> > applied and allows the database to be open and active.
> >
> > --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > > why wouldn't you consider simply using the standby database
> feature?
> > >
> > > do you need the remote site to support users also?
> > >
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Sunday, June 09, 2002 11:43 AM
> > > (online redo logs)
> > >
> > >
> > > > Hello All
> > > >
> > > > I just had a meeting today about replication.
> > > > The situations is: One master db that is currently replicated
> > > > (master to master synchronous replication) to a second DB.
> > > > Both machines are NT and the is a direct cable connection
> > > > between the network cards on both machines.
> > > >
> > > > However, this solves the problem of machine failure but does
> not
> > > cover
> > > > the full disaster recovery as both machines are in the same
> room.
> > > > In case of fire both machines will be destroyed.
> > > >
> > > > We are thinking about adding asynchronous replication to
> replicate
> > > the
> > > > changes
> > > > across wan to a remote site. The problem is that this will load
> the
> > > > production system and the network link (wan is expensive), as
> the
> > > system
> > > > generates during peek time 10MB of archive logs every 2-3
> minutes.
> > > >
> > > > I saw that some of you are using Quest Shareplex.
> > > > Can you share your reasons, success stories etc?
> > > > Benchmarks results will be very welcome.
> > > >
> > > > TIA
> > > >
> > > > Yechiel Adar
> > > > Mehish
> > > > - Original Message -
> > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > > Sent: Thursday, June 06, 2002 4:32 PM
> > > > (online redo logs)
> > > >
> > > >
> > > > NB_ RESENDING in plain text - sorry, Outlook keeps seinding in
> html
> > > no
> > > > matter what default i set!
> > > > Hi lists,
> > > >
> > > > I am using Quest Shareplex product for Oracle to Oracle one
> way
> > > > replication.  I have two systems (source and target) and two
> > > environments
> > > > (dev, demo).  On system one, the environments are setup as
> schemas
> > > within
> > > > one oracle instance (therefore each schema will be a SOURCE in
> the
> > > > replication).  My other system has each environment set up a
> > > separate
> > > Orace
> > > > Instances (therefore each instance will become a TARGET in the
> > > replication).
> > > >
> > > > I am trying to configure 2 separate replication streams (ie
> so
> > > that
> > > each
> > > > replication process is SEPARATE from the other - one for DEV
> and
> > > one for
> > > > DEMO).  I will accomplish this by setting up Shareplex to use
> > > mulitple
> > > > processes.
> > > >
> > > > HOWEVER, Quest technical support has told me that this will
> > > cause
> > > > contention.  However, I dont see why is would from an os/oracle
> > > point of
> > > > view.  Basically Shareplex has a process which reads the online
> > > redo
> > > > logs. tech support is suggesting that is there a two
> > > processes
> > > > trying to access the same block in the logs that contention can
> > > occur.
> > > This
> > > > does not make sense to me.  Below is the blurb from techincal
> > > support when
> > > I
> > > > questioned their initial repsonse:
> > > >
> > > >
> > >
> >
>

> > > > *

RE: Remove Duplicates

[Alex Hillman]

Ferenc, what happened with your web site - at least 
with Oracle version of it?
 
Alex 
Hillman

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Ferenc MantfeldSent: 
  Tuesday, June 04, 2002 4:49 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Remove Duplicates
  Tom. 
  Replies below.
  Regards: Ferenc Mantfeld Senior Performance Engineer Siebel 
  Performance Engineering Melbourne, 3000, 
  VIC, Australia -Original 
  Message-From: Terrian, Tom 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 4 June 2002 11:54 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Remove Duplicates
  

I know I have seen this posted 
before...
 
We have a large range 
partitioned table that has duplicates in it.  What is the fastest way 
to remove the dups.?  I have the following scripts which do it but may 
be fast or slow.  What do you guys use?
DELETE FROM tablename WHERE ROWID NOT IN 
  (SELECT MIN(ROWID)     FROM tablename     GROUP 
BY fieldnames); [Ferenc 
Mantfeld] This will be your fastest way, provided you have an index on 
the columns searched for. Actually the format of the statement would 
be
 
delete from INVOICE_DETAILS A where A.rowid 
>
(select 
min(rowid) from INVOICE_DETAILS B where 
    B.INV_NUM=A.INV_NUM and 
B.LINE_NUM=A.LINE_NUM ) 
;
 
Ensure you have a composite index on 
INVOICE_DETAILS (INV_NUM, LINE_NUM).
Or
alter table &table_name 
   add constraint duplicate_cons 
   unique key (&column_name) 
 exceptions into 
exception table;[Ferenc Mantfeld] Problem with this is when you want 
to delete the duplicates, you have no way of telling, unless you code the 
min function again. If you have triplicates, and want to keep one 
of them and blow away the other two, this is a tedious way, and all 
this does is to help you identify the 
duplicates. 
How to find duplicates:
select &column_name, count(&column_name) 
 from &table_name 
 group by 
&column_name    having 
count(&column_name) > 1; [Ferenc Mantfeld] Same as above. only 
identifies the duplicates, does nothing to remove 
them. 
 
Tom 
 

RE: sys corrupted in warehouse, sev1 tar open - resolved

[Jack Silvey]

All,

thanks for the input. Looks like someone implemented a
login trigger. haven't seen the code yet, but I would
venture a guess he used the unsupported "alter system
set current_schema=x".

sometimes you live and learn, sometimes you just live!

thx,

jack silvey


--- Hately Mike <[EMAIL PROTECTED]> wrote:
> I don't hold out much hope here Jack. 
> It sounds like data dictionary corruption; maybe
> somewhere round user$(?).
> That's not to say the situation's irretrievable;
> I've seen OTS fix some bad
> situations in my time but I'm not sure that I'd want
> to keep the database
> even if Oracle Support can fix the problem.
> 
> Regards,
> Mike
> 
> -Original Message-
> Sent: 12 June 2002 14:23
> To: Multiple recipients of list ORACLE-L
> 
> 
> Listers,
> 
> Our warehouse now has a split personality and we
> have
> a sev1 open on it. Suspect recovery is in the cards,
> but want to avoid if possible.
> 
> Yesterday, users unable to get to their own
> functions.
> Soon after, RMAN cannot find package
> dbms_backup_restore, even though it exists under
> sys.
> Oncall ran the sql script to recreate - and the
> pacakge was recreated under a schema called
> dma_rbate2. RMAN now finds the package under
> dma_rbate2, although it is invalid. Drop the package
> under dma_rbate2, and now RMAN cannot find the
> package
> any longer, although it still exists under sys.
> 
> Logged in as sys. Tried to desc dbms_backup_restore
> -
> no luck. Tried to desc sys.dbms_backup_restore -
> success.
> 
> Analyst reccomends running catalog.sql. Oncall does
> so, and it creates as many packages as it is able
> under dma_rbate2.
> 
> I get up this AM and can't login, because the
> sessions
> can't find the package
> dma_rbate2.dbms_application_info.
> 
> Anyone? Buhler? Buhler?
> 
> thx,
> 
> jack
> 
> 
>  
>

>  
> 
> This email and any attached to it are confidential
> and intended only for the
> individual or 
> entity to which it is addressed.  If you are not the
> intended recipient,
> please let us know 
> by telephoning or emailing the sender.  You should
> also delete the email and
> any attachment 
> from your systems and should not copy the email or
> any attachment or
> disclose their content 
> to any other person or entity.  The views expressed
> here are not necessarily
> those of 
> Churchill Insurance Group plc or its affiliates or
> subsidiaries. Thank you. 
> Churchill Insurance Group plc.  Company Registration
> Number - 2280426.
> England. 
> Registered Office: Churchill Court, Westmoreland
> Road, Bromley, Kent BR1
> 1DP. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Hately Mike
>   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 list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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).


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Discount book websites

[Charlie Mengler]

http://www.bestwebbuys.com/books/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: AW: Off Topic, slightly - Crystal Reports internal format

[Jared Still]

Brian,

Thank you, that appears to be the solution!

Just hadn't explored enough yet.

Jared


On Tuesday 11 June 2002 15:31, Anderson, Brian wrote:
> In 8.5 developer on the "database" menu, is an option of "set location".
>
> This lets you pick a new connection/table for any table in the report,
> and then it asks if you would like to change all similiar references.
> So you can change one and let it try to match the others, or change each
> table reference yourself.
>
> I don't have 8 installed to see if their is something similiar, but
> maybe that will give you a direction to look.
>
> Do you have "standard", "professional" or "developer"?  That may
> determine whether you have this option.
>
>
> ***
>  Brian L. Anderson
>  SA/DBA
>  Darton College
>  [EMAIL PROTECTED]
> ---
> http://home.earthlink.net/~maryranderson
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, June 11, 2002 2:29 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: AW: Off Topic, slightly - Crystal Reports internal format
> >
> >
> > Arrhhh!
> >
> > Now that the primal scream is out of the way, there must be some
> > kind of workaround.  Still looking...
> >
> > Jared
> >
> >
> >
> >
> >
> > Stefan Jahnke <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 06/11/2002 05:53 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc:
> > Subject:AW: Off Topic, slightly - Crystal
> > Reports internal format
> >
> >
> > Hi Jared
> >
> > Regarding your first problem:
> > I experienced the same "feature" a while ago.
> > Seagate promised that one is able to just change
> > an underlying ODBC connection and that the report
> > should be able to run different data sources.
> > Bunch of bull. Looks like it still doesn't work
> > correctly.
> >
> > And yes, we had to reengineer EVERY single report.
> > CR support ? VERY ah, ... not helpful.
> >
> > Regards,
> > Stefan
> >
> > -Ursprüngliche Nachricht-
> > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Gesendet: Montag, 10. Juni 2002 23:43
> > An: Multiple recipients of list ORACLE-L
> > Betreff: Off Topic, slightly - Crystal Reports internal format
> >
> >
> > List,
> >
> > I have an 'opportunity' to make some points with end users,
> > if possible.
> >
> > I'm booting the crystal reports users off of my production
> > databases (
> > including
> > SAP, can you believe that? ).
> >
> > There reports will now run against a reporting server with
> > snapshotted
> > tables.
> >
> > Their reports have been written with Crystal Reports 8 via ODBC.
> >
> > 2 problems:
> >
> > 1) When originally setup, the ODBC DSN matched the name of
> > the database.
> > Not smart I know, but I inherited it.  Changing the data
> > source in Crystal
> >
> > basically
> > forces you to rewrite the report.
> >
> > 2) The username has changed.  Production is CIMUSER,
> > reporting is CIM_MV.
> > The table names have '_MV' suffix in the reporting database.
> >
> > Any reasonable tool would allow you to change these items
> > without too much
> >
> > fuss.
> >
> > Either CR8 is not reasonable, or I have just not found out
> > how to do it
> > yet.  Without
> > reconstructing the report that is.
> >
> > Any tips, resources, what have you are welcome.
> >
> > If you know of any documentation detailing the *.rpt file
> > format, that
> > would be most
> > appreciated, as I could just modify their reports from the
> > command line or
> >
> > with a
> > hex editor.
> >
> > Thanks,
> >
> > Jared
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   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 list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Stefan Jahnke
> >   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 list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing 

Error pushing deferred transactions

[John Weatherman]

All,

I am trying to set up a job for pushing deferred transactions to a remote
database.
When I run the job, I am getting:

Wed Jun 12 09:26:48 2002
Errors in file /u800/app/oracle/admin/trl1/udump/ora_28709.trc:
ORA-12012: error on auto execute of job 22
ORA-23354: deferred RPC execution disabled for "TRL2.WORLD"
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1520
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1583
ORA-06512: at line 1

Which leads me to:
ORA-23354:
23354, 0, "deferred RPC execution disabled for \"%s\" with \"%s\""
// *Cause: Deferred RPC can not be executed at the destination with
// the specified catchup value because their propogation has
// been disabled.
// *Action: Enable deferred RPC execution with the
//  dbms_defer_sys.set_disabled call.

So, I go to the destination and execute:

SQL> execute
dbms_defer_sys.set_disabled(destination=>'trl1.world',disabled=>false);

PL/SQL procedure successfully completed.

Unfortunately this does not seem to clear the problem.  Is anyone familier
enough 
with the dbms_defer_sys package to tell me what I'm missing?  


TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: SunOS 5.8 I/O buffer size?

[Mladen Gogala]

The "IO buffer size" is the maximal size of a single, atomic disk IO, 
usually
either 128k or 256k. All IO requests larger then that will be 
internally broken
into multiple requests. As my Solaris is getting rusty (working with 
HP-UX and
Linux now) I cannot remember the exact parameter name. It used to be 
available
in the "Ferrari" book.


On 2002.06.12 09:53 Carmen Rusu wrote:
> 
> Kevin Loney's Oracle8i DBA Handbook says you need to know the
> "operating system's I/O buffer size" in order to set the init param
> DB_FILE_MULTIBLOCK_READ_COUNT correctly.
> 
> What is the definition of "operating system's I/O buffer size Loney is
> talking about?
> 
> What is  the value of " I/O buffer size" for SunOS 5.8?
> 
> Went to Sun's web site and got lost...I just want two straight answers
> to my two questions.
> 
> 
> 
> 
> Thanks,
> 
> Carmen Rusu
> Sr Oracle DBA
> 512-463-3657 (office)
> 512-606-5012 (pager)
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Carmen Rusu
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).
> 

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Goodbye e3000 & TRU64

[Brian McGraw]

That's interesting.  

At the 2001 IOUG, I seem to remember someone from Compaq touting how the
TRU64 platform was chosen by Oracle for the initial development of RAC,
and was supposedly the premiere platform for RAC - including getting
away from raw file systems.

Brian

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L

Someone, I don't remember who, commented the other day about not wanting
to
leave their TRU64 environment.  Well according to the following form
Infoweek,
you may not have an option!

Dick Goulet

Mandatory Oracle Plug: Another successful migration from TurboImage
(YUCK) to
Oracle included.



---

** Popular HP Server Bid Farewell

Hewlett-Packard is enticing owners of its once-popular, 
now-doomed e3000 servers to buy HP-UX or Linux systems. The most 
likely migration path will be to HP 9000 servers running HP-UX, 
although buyers could also move to Intel-based ProLiant servers. 
HP is using a number of migration programs, including one that 
provides e3000 customers with "loaner" HP 9000s until they can 
make a full transition.
It's also doing free migration assessments through HP Services 
and software and hardware trade-in rebates.

HP's approach to retiring products will be closely watched, 
especially as it reconciles its product line with that of the 
newly acquired Compaq. Gartner analyst Paul McGuckin says this 
process "might help them see what works and what doesn't when 
they phase out [Compaq] Tru64" Unix machines.

Virginia International Terminals is taking HP up on its offers. 
VIT manages Virginia's shipping ports, using four e3000 servers 
to track 1 million containers annually along the state's 
shoreline. When HP said it was discontinuing the e3000, "it sent 
a shockwave through our organization," says Clark Farabaugh, 
VIT's assistant IT director. VIT took advantage of HP's loaner
program to begin migrating its container-management apps to 
HP-UX, scuttle its old e3000 Turbo Image database, and adopt the 
more Web-friendly Oracle 9i. - Larry Greenemeier

For more, read:
Analyst: HP Cut Chip Orders From Intel By 50%
http://update.informationweek.com/cgi-bin4/flo?y=eHe60BdFGA0V20Bd720AD

Fiorina: HP To Achieve Cost Cuts Ahead Of Schedule
http://update.informationweek.com/cgi-bin4/flo?y=eHe60BdFGA0V20Bdnc0Av
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Brian McGraw
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: I/O contention with external process reading the oracle logs (online redo logs)

[Yechiel Adar]

Hello Tim and Rachel

There is band width problem. The line is 256K (we are checking upgrade to
512k).
The database, during peek time produce 10MB of logs every 2-3 minutes.
On this line it will take 7-8 minutes to pass 10MB if the line was dedicate
and it is not dedicated.

Upgrading the line to more then 512K need E1 at least and it is expansive.

Since replication will need less band width we are checking it.

To return to my original question:
Quest Shareplex -
Any success stories?
Why use this and not replication?
Ant performance tests between Shareplex and Oracle replication?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 4:33 AM
(online redo logs)


> and if you need the remote site to support users, you could use the
> logical standby feature of 9iR2, which generates SQL statements to be
> applied and allows the database to be open and active.
>
> --- Tim Gorman <[EMAIL PROTECTED]> wrote:
> > why wouldn't you consider simply using the standby database feature?
> >
> > do you need the remote site to support users also?
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Sunday, June 09, 2002 11:43 AM
> > (online redo logs)
> >
> >
> > > Hello All
> > >
> > > I just had a meeting today about replication.
> > > The situations is: One master db that is currently replicated
> > > (master to master synchronous replication) to a second DB.
> > > Both machines are NT and the is a direct cable connection
> > > between the network cards on both machines.
> > >
> > > However, this solves the problem of machine failure but does not
> > cover
> > > the full disaster recovery as both machines are in the same room.
> > > In case of fire both machines will be destroyed.
> > >
> > > We are thinking about adding asynchronous replication to replicate
> > the
> > > changes
> > > across wan to a remote site. The problem is that this will load the
> > > production system and the network link (wan is expensive), as the
> > system
> > > generates during peek time 10MB of archive logs every 2-3 minutes.
> > >
> > > I saw that some of you are using Quest Shareplex.
> > > Can you share your reasons, success stories etc?
> > > Benchmarks results will be very welcome.
> > >
> > > TIA
> > >
> > > Yechiel Adar
> > > Mehish
> > > - Original Message -
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > Sent: Thursday, June 06, 2002 4:32 PM
> > > (online redo logs)
> > >
> > >
> > > NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html
> > no
> > > matter what default i set!
> > > Hi lists,
> > >
> > > I am using Quest Shareplex product for Oracle to Oracle one way
> > > replication.  I have two systems (source and target) and two
> > environments
> > > (dev, demo).  On system one, the environments are setup as schemas
> > within
> > > one oracle instance (therefore each schema will be a SOURCE in the
> > > replication).  My other system has each environment set up a
> > separate
> > Orace
> > > Instances (therefore each instance will become a TARGET in the
> > replication).
> > >
> > > I am trying to configure 2 separate replication streams (ie so
> > that
> > each
> > > replication process is SEPARATE from the other - one for DEV and
> > one for
> > > DEMO).  I will accomplish this by setting up Shareplex to use
> > mulitple
> > > processes.
> > >
> > > HOWEVER, Quest technical support has told me that this will
> > cause
> > > contention.  However, I dont see why is would from an os/oracle
> > point of
> > > view.  Basically Shareplex has a process which reads the online
> > redo
> > > logs. tech support is suggesting that is there a two
> > processes
> > > trying to access the same block in the logs that contention can
> > occur.
> > This
> > > does not make sense to me.  Below is the blurb from techincal
> > support when
> > I
> > > questioned their initial repsonse:
> > >
> > >
> >
>

> > > *
> > > The reason you might run into a contention is because multiple
> > captue
> > > processes may be reading the same data block in the redo log.
> > Since there
> > > is only one process that can access a single block, the other
> > process may
> > > have to wait.
> > > Contention is a possibilty, and you will need to run some bench
> > marks to
> > > find out how much, if any, contention you will have.
> > >
> >
>

> > > *
> > >
> > > I would find it HARD to believe that only ONE process can read a
> > block at
> > a
> > > time.  If this were true, then OLTP system would FAIL miserably!
> > >
> > > Anyone have any ideas/comments regarding the OS and Oracle
> > interaction
> > 

RE: Discount book website

[Robertson Lee - lerobe]

For us UK types my best bargain house is 

www.compman.co.uk

Got the 9i DBA Handbook priced at £43.99

- 30% site discount plus another 10% discount member special offer

I paid a grand total of £26.39 for my book (saving £17.60 !!) . Delivery is
free on the UK mainland and I had my book within 2 days delivered to my
door.

This is the 4th book I have bought from them and they have yet to
disappoint. Every Friday I get an email detailing a list of bestsellers with
a 10% discount on them.

Regards and Happy Shopping

Lee


-Original Message-
Sent: 12 June 2002 15:33
To: Multiple recipients of list ORACLE-L


And even cheaper at http://www.bookpool.com  Kevin Loney's DBA Handbook is
$8 US cheaper at Bookpool.

I've got Steve Adams' Internal book on the way as we speak (erm, "type").
I've ordered three Oracle books from them so far.  No delays, no problems,
and the cheapest I could find.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


> -Original Message-
> From: Joe Testa [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 11, 2002 8:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Discount book website
> 
> 
> I ordered and received my 9ir2 docs(only $9.95 ans s/h), 
> anyways in the 
> box is a form:
> 
> http://www.mhorder.com/oracle9i
> 
> 
> there is 25% savings on some of the 9i books there.
> 
> Joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re:Unbreakable 9i metalink

[dgoulet]

Naw, just hacked! :)

Reply Separator
Author: "Jamadagni; Rajendra" <[EMAIL PROTECTED]>
Date:   6/12/2002 5:48 AM

Is it broken?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


 

*This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2

FW: MetaLink Article

[Grabowy, Chris]

I fellow DBA sent this to me...passing it on...

>  -Original Message-
> From: Rothouse, Michael  
> Sent: Wednesday, June 12, 2002 9:05 AM
> Subject:  MetaLink Article
> 
> Pre-Install script which checks your Unix environment to ensure successful
> installation of Oracle 9.x version of RDBMS 
>  tabase_id=NEW&p_id=1348943.999>
> 
> 
> Michael Rothouse
> IOG Database Manager/DBA
> Oracle8i Certified Professional DBA
> 610-989-8275
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Goodbye e3000 & TRU64

[Jesse, Rich]

I don't think they can completely cut out Tru64 without offering another
Unix solution for the Alpha chip.  They've already announced the EV7 and
EV79 cuts of the Alpha for 2003 and 2004 (I think, or was it 2005?).

Hell, HPaq's even announced they'll support my beloved OpenVMS until at
least 2012, so I wouldn't be that worried -- yet.

My $.02,

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 9:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Goodbye e3000 & TRU64
> 
> 
> Someone, I don't remember who, commented the other day about 
> not wanting to
> leave their TRU64 environment.  Well according to the 
> following form Infoweek,
> you may not have an option!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re:SunOS 5.8 I/O buffer size?

[dgoulet]

Carmen,

Regrettably I can't tell you what SUN's buffer or read ahead size is, but I
dealt with that issue on our HP's some years ago & the result can be
"interesting" to say the least.  On the HP-UX platform they allow you up to 32K
of data in a single time slice or read.  Basically it means that you can read
32K of data before you have to release the CPU to another process & wait for
your turn again.  Therefore, once you find that value divide it by your block
size & you have the largest setting for DB_FILE_MULTIBLOCK_READ_COUNT that will
work in your instance.  Setting it larger has no effect, at least on HP, as your
request gets truncated.  (IE, you can ask for 64K but all you'll get is 32K). 
Setting it smaller may on some systems cause a waste of IO resources.  BUT in
any case setting it one way or the other affects the cost based optimizer. 
Example, in a test instance I tried setting DB_FILE_MULTIBLOCK_READ_COUNT =1000.
 The DB ran just fine, but CBO would never use an index.  I then tried
DB_FILE_MULTIBLOCK_READ_COUNT = 1.  Again the DB ran OK, but CBO almost never
wanted to do a full table scan.

Dick Goulet

Reply Separator
Author: "Carmen Rusu" <[EMAIL PROTECTED]>
Date:   6/12/2002 5:53 AM


Kevin Loney's Oracle8i DBA Handbook says you need to know the "operating
system's I/O buffer size" in order to set the init param
DB_FILE_MULTIBLOCK_READ_COUNT correctly.

What is the definition of "operating system's I/O buffer size Loney is talking
about?

What is  the value of " I/O buffer size" for SunOS 5.8?

Went to Sun's web site and got lost...I just want two straight answers to my two
questions.




Thanks,

Carmen Rusu
Sr Oracle DBA
512-463-3657 (office)
512-606-5012 (pager)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carmen Rusu
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: how to you stop an export?

[Yechiel Adar]

In NT use task manager and kill it.
In Win95/8 do Alt-Ctrl-Del and kill the dos session.

Yechiel Adar
Mehish
- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 7:08 PM


> how do you stop an command-line export?  press CTL-C countless times and
> ususally just stops the current table . . . usually end up killing the
> entire session.
> 
> was hoping there's a different way?
> 
> thx
> bill
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Magaliff, Bill
>   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 list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Yechiel Adar
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Discount book website

[Jesse, Rich]

And even cheaper at http://www.bookpool.com  Kevin Loney's DBA Handbook is
$8 US cheaper at Bookpool.

I've got Steve Adams' Internal book on the way as we speak (erm, "type").
I've ordered three Oracle books from them so far.  No delays, no problems,
and the cheapest I could find.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


> -Original Message-
> From: Joe Testa [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 11, 2002 8:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Discount book website
> 
> 
> I ordered and received my 9ir2 docs(only $9.95 ans s/h), 
> anyways in the 
> box is a form:
> 
> http://www.mhorder.com/oracle9i
> 
> 
> there is 25% savings on some of the 9i books there.
> 
> Joe
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: sys corrupted in warehouse, sev1 tar open

[Hately Mike]

I don't hold out much hope here Jack. 
It sounds like data dictionary corruption; maybe somewhere round user$(?).
That's not to say the situation's irretrievable; I've seen OTS fix some bad
situations in my time but I'm not sure that I'd want to keep the database
even if Oracle Support can fix the problem.

Regards,
Mike

-Original Message-
Sent: 12 June 2002 14:23
To: Multiple recipients of list ORACLE-L


Listers,

Our warehouse now has a split personality and we have
a sev1 open on it. Suspect recovery is in the cards,
but want to avoid if possible.

Yesterday, users unable to get to their own functions.
Soon after, RMAN cannot find package
dbms_backup_restore, even though it exists under sys.
Oncall ran the sql script to recreate - and the
pacakge was recreated under a schema called
dma_rbate2. RMAN now finds the package under
dma_rbate2, although it is invalid. Drop the package
under dma_rbate2, and now RMAN cannot find the package
any longer, although it still exists under sys.

Logged in as sys. Tried to desc dbms_backup_restore -
no luck. Tried to desc sys.dbms_backup_restore -
success.

Analyst reccomends running catalog.sql. Oncall does
so, and it creates as many packages as it is able
under dma_rbate2.

I get up this AM and can't login, because the sessions
can't find the package
dma_rbate2.dbms_application_info.

Anyone? Buhler? Buhler?

thx,

jack


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

RE: Discount book website

[Grabowy, Chris]

I did a quick compare and bookpool.com still has better prices.

Mr. Freeman's book is 4 bucks less on bookpool.com, which basically pays for
shipping, compared to mhorder.com.

The Oracle9i Web Development book is $36.95 on bookpool.com and $44.99 on
mhorder.com, 8 bucks diff, 38% off.

You decide...

-Original Message-
Sent: Tuesday, June 11, 2002 9:05 PM
To: Multiple recipients of list ORACLE-L


I ordered and received my 9ir2 docs(only $9.95 ans s/h), anyways in the 
box is a form:

http://www.mhorder.com/oracle9i


there is 25% savings on some of the 9i books there.

Joe


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Grabowy, Chris
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Goodbye e3000 & TRU64

[dgoulet]

Someone, I don't remember who, commented the other day about not wanting to
leave their TRU64 environment.  Well according to the following form Infoweek,
you may not have an option!

Dick Goulet

Mandatory Oracle Plug: Another successful migration from TurboImage (YUCK) to
Oracle included.


---

** Popular HP Server Bid Farewell

Hewlett-Packard is enticing owners of its once-popular, 
now-doomed e3000 servers to buy HP-UX or Linux systems. The most 
likely migration path will be to HP 9000 servers running HP-UX, 
although buyers could also move to Intel-based ProLiant servers. 
HP is using a number of migration programs, including one that 
provides e3000 customers with "loaner" HP 9000s until they can 
make a full transition.
It's also doing free migration assessments through HP Services 
and software and hardware trade-in rebates.

HP's approach to retiring products will be closely watched, 
especially as it reconciles its product line with that of the 
newly acquired Compaq. Gartner analyst Paul McGuckin says this 
process "might help them see what works and what doesn't when 
they phase out [Compaq] Tru64" Unix machines.

Virginia International Terminals is taking HP up on its offers. 
VIT manages Virginia's shipping ports, using four e3000 servers 
to track 1 million containers annually along the state's 
shoreline. When HP said it was discontinuing the e3000, "it sent 
a shockwave through our organization," says Clark Farabaugh, 
VIT's assistant IT director. VIT took advantage of HP's loaner
program to begin migrating its container-management apps to 
HP-UX, scuttle its old e3000 Turbo Image database, and adopt the 
more Web-friendly Oracle 9i. - Larry Greenemeier

For more, read:
Analyst: HP Cut Chip Orders From Intel By 50%
http://update.informationweek.com/cgi-bin4/flo?y=eHe60BdFGA0V20Bd720AD

Fiorina: HP To Achieve Cost Cuts Ahead Of Schedule
http://update.informationweek.com/cgi-bin4/flo?y=eHe60BdFGA0V20Bdnc0Av
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

sys corrupted in warehouse, sev1 tar open

[Jack Silvey]

Listers,

Our warehouse now has a split personality and we have
a sev1 open on it. Suspect recovery is in the cards,
but want to avoid if possible.

Yesterday, users unable to get to their own functions.
Soon after, RMAN cannot find package
dbms_backup_restore, even though it exists under sys.
Oncall ran the sql script to recreate - and the
pacakge was recreated under a schema called
dma_rbate2. RMAN now finds the package under
dma_rbate2, although it is invalid. Drop the package
under dma_rbate2, and now RMAN cannot find the package
any longer, although it still exists under sys.

Logged in as sys. Tried to desc dbms_backup_restore -
no luck. Tried to desc sys.dbms_backup_restore -
success.

Analyst reccomends running catalog.sql. Oncall does
so, and it creates as many packages as it is able
under dma_rbate2.

I get up this AM and can't login, because the sessions
can't find the package
dma_rbate2.dbms_application_info.

Anyone? Buhler? Buhler?

thx,

jack




__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Unbreakable 9i metalink

[Jamadagni, Rajendra]

Is it broken?

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

SunOS 5.8 I/O buffer size?

[Carmen Rusu]

Kevin Loney's Oracle8i DBA Handbook says you need to know the "operating system's I/O 
buffer size" in order to set the init param DB_FILE_MULTIBLOCK_READ_COUNT correctly.

What is the definition of "operating system's I/O buffer size Loney is talking about?

What is  the value of " I/O buffer size" for SunOS 5.8?

Went to Sun's web site and got lost...I just want two straight answers to my two 
questions.




Thanks,

Carmen Rusu
Sr Oracle DBA
512-463-3657 (office)
512-606-5012 (pager)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carmen Rusu
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).

Re: warehouse gets very strange - sys corrupted - sev1 tar

[Jack van Zanen]

Hi


Did the oncall run catalog.sql as dma_rbate2?? If so he should have been in
bed.

You now have all the packages and procedures created in catalog living in
dma_rbate2 schema? can you drop that schema?

You can desc sys.dbms_backup_restore. Did you loose a public/private
synonym here that can solve the problem of rman not being able to find the
package??


Jack


   
  
  Jack Silvey  
  
   
  o.com>   cc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)  
  Sent by: Subject:  warehouse gets very strange - 
sys corrupted - sev1 tar  
  [EMAIL PROTECTED] 
  
   
  
   
  
  12-06-2002 15:23 
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  



Listers,

Our warehouse now has a split personality and we have
a sev1 open on it. Suspect recovery is in the cards,
but want to avoid if possible.

Yesterday, users unable to get to their own functions.
Soon after, RMAN cannot find package
dbms_backup_restore, even though it exists under sys.
Oncall ran the sql script to recreate - and the
pacakge was recreated under a schema called
dma_rbate2. RMAN now finds the package under
dma_rbate2, although it is invalid. Drop the package
under dma_rbate2, and now RMAN cannot find the package
any longer, although it still exists under sys.

Logged in as sys. Tried to desc dbms_backup_restore -
no luck. Tried to desc sys.dbms_backup_restore -
success.

Analyst reccomends running catalog.sql. Oncall does
so, and it creates as many packages as it is able
under dma_rbate2.

I get up this AM and can't login, because the sessions
can't find the package
dma_rbate2.dbms_application_info.

Anyone? Buhler? Buhler?

thx,

jack




__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
  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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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).




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this