RE: A brief detour....;-)

[Bobak, Mark]

Vladimir,

Nice solution!  I had first briefly considered a SQL solution, but it didn't
immediately come to mind, and the PL/SQL recursive solution was pretty
straightforward, so, I went that direction.  I wasn't really too concerned
about expense, in this case;-)  I don't see too many practical
applications. ;-)

-Mark


-Original Message-
From:   Vladimir Begun [mailto:[EMAIL PROTECTED]
Sent:   Mon 12/8/2003 8:19 PM
To: Multiple recipients of list ORACLE-L
Cc: 
Subject:Re: A brief detour;-)
Bobak, Mark wrote:
 > Here it is:
[...]
 > This concludes this public service announcement.  We now return
 > you to our regularly scheduled programming.

Interesting. PL/SQL recursive solutions are expensive, though. :)
Did not check it, maybe something alike was posted already...

SET VERIFY OFF PAGES 200
DEFINE disks=7
REM Please do not use all_objects :)
DEFINE big_table=all_objects
COLUMN "Implementation Plan" FORMAT A20
SPOOL hanoi_solution.txt
SELECT 'Move it from '
 || TO_CHAR(MOD(BITAND(ROWNUM, ROWNUM - 1), 3) + 1)
 || ' to '
 || TO_CHAR(MOD(-BITAND(-ROWNUM - 1, -ROWNUM), 3) + 1) AS "Implementation Plan"
   FROM &&big_table
  WHERE ROWNUM < POWER(2, &&disks)
AND &&disks < 8
/
SPOOL OFF

Should work correctly.

Regards,
-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vladimir Begun
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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).


<>

OpenLDAP instead of OID

[Mladen Gogala]

Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with 
OpenLDAP.
The road runner page is no longer accessible. Does anybody have a copy? If so, please 
publish 
the location, because I'm trying it right now. Please, if anybody has that page, post 
it again or forward it
privately. Thanks in advance. The message I'm talking about is below.


--
Mladen Gogala
Oracle DBA 



-Original Message-
DENNIS WILLIAMS
Sent: Monday, August 18, 2003 11:30 PM
To: Multiple recipients of list ORACLE-L


Congratulations Stefan! 
   Thanks for posting this.
Do you (or anyone else) have any ideas for doing this with Micro$oft Active
Directory?

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


-Original Message-
Sent: Monday, August 18, 2003 8:15 AM
To: Multiple recipients of list ORACLE-L


Hi list

Some people where interested in feedback regarding the usage of OpenLDAP
instead of OID or Names to resolve TNS strings. Seems to work ;). Here is
what to do:

Prerequisite: I used openldap-2.0.23 instead of 2.1, since I had to use
CygWin to test it locally on my laptop.

Bill of materials:

CygWin http://www.cygwin.com, I used the latest version, 1.5.2-1test

Oracle Client, version >= 8.1.6.x 

OID LDIFS, can be taken from $ORACLE_HOME/ldap/admin, if the OID option is
installed, or from 
Oracle Disks:
Disk3\stage\Components\oracle.oid.server\9.2.0.1.0\1\DataFiles\admin.1.1.jar

HowTo: http://home.nc.rr.com/jtlayton/oid2openldap.html

Simply follow the howto to get openldap running and include the OID schemas.

Then, create an ldap.ora under $ORACLE_HOME/network/admin, which looks like
this:

DIRECTORY_SERVERS=localhost:389
DIRECTORY_SERVER_TYPE=oid DEFAULT_ADMIN_CONTEXT="cn=Manager,dc=world"

.. and change sqlnet.ora to contain:

NAMES.DIRECTORY_PATH= (LDAP)

Finished, enjoy.
Stefan

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Tel.: +49 201/45 13-289
mailto:[EMAIL PROTECTED]
http://www.bov.de
Abonnieren Sie unseren Newsletter: http://www.bov.de/enews

Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am
24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder
mailto:[EMAIL PROTECTED]

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir
um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche
Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.



 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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).



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Mladen Gogala
Oracl

Re: Add/Drop partition and CBO statistics

[zhu chao]

Hi list:
I did another add partition last monday evening, and that time everything is ok. 
Maybe statistics did not change much(like high value in tables/indexes).
I will do more research and give feedback to you .
And I think there must be other DBAs also using partitions, why not share your 
pains and gains?

Regards.
Zhu Chao.


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 04, 2003 4:49 AM


> I've got a perfect application for partitioning by date. Each "month" is a new batch 
> of data and everything is set for the last date of the month.
> 
> But they asked me today, if we drop a partition of old data, and then add a new 
> partition for the next month, load it, what needs analyzed?
> 
> Is it enough to simply analyze the new partition?
> 
> --
> 13308 Thornridge Ct
> Midlothian, VA  23112
> 804-744-1545
> > Reply in lines.
> > 
> > Zhu Chao
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, December 03, 2003 7:29 PM
> > 
> > 
> > > Agreed that scanning one big index is faster than many partitions.
> > > 
> > > Then raises the questions - I thought partitioning is for:
> > > 1) ease of archiving/dropping off old partitions - drop old and create new
> > > partitions in a sliding window. A single large global index negates a lot of
> > > this ease - even though it is true that deletes on non-partitioned tables
> > > would be even more inconvenient.
> > Yes, that is why we use local index.not Global indexes.
> > 
> > > 2) efficiencies in partition pruning for queries. If you are "querying whole
> > > table" - why bother with partitioning?
> > > The point then becomes you don't need to partition in the first place, or
> > > your partitioning scheme is not appropriate?
> > Sometimes it is constrained by complex real  applications. A table has tens 
> > of columns and you can only partition by one key(or several columns), and to use 
> > partition elimination, the SQL must contains the partition key. So only these 
> > limited SQL can use partition pruning. While in complex real life application, 
> > there will always SQL with different where clause that do not use the partition 
> > key at all.
> > The other constraint is business logic.We should partition according to 
> > product online time, but we have ten tables to archive and only one 
> > table(products) has that key, all other tables do not have that column. Adding 
> > such a column to other tables need considrable application rewrite and is 
> > denied. So we use product_id(the primary key of most tables) as the partition 
> > key.
> >  
> > > > When partitioning key is not a part of the index and you are querying
> > > whole table, then it is faster to scan one big index than many smaller ones.
> > > The difference is something like log rows to partcount*log (rows/partcount).
> > > >
> > > > > BTW, local indexes are the only way to go -- I've never
> > > > > understood the point
> > > > > of global indexes on partitioned tables -- maybe someone else can?
> > Global indexes are faster than local index, so if you have schedule down 
> > time and need better performance, go to global index. OLTP is more suitable for 
> > GLobal index, tomas kyte said in his expert one on one.
> > 
> > Regards
> > Zhu Chao.
> > 
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > -- 
> > > Author: Binley Lim
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing 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.net
> > -- 
> > Author: zhu chao
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing 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.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Denny Koovakattu]

And how do you join one ?

Denny

Pete Sharman wrote:

  Well, you could have joined the beta program if you were THAT
interested, Mladen!

Ducks and runs.  :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

-Original Message-
Mladen Gogala
Sent: Tuesday, December 09, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L

Larry Ellison has publicly stated that his goal is to produce a database
with 
less then 100 tunable parameters. Allegedly, he came rather close with
10g.
As far as 10g is concerned, I'm rather disappointed with the marketing
hype 
being created with oracle not making an early version available. I don't
plan
on migrating to 10g until I learn it well and if some oracle sales guy
tries to exert pressure on me to migrate, he will get a very stable sign
used by English archers after the battle at Agincourt to signify that
they 
still have all the fingers needed to operate a longbow. I've had my fill
of
white papers and articles and now I want to see the software.

On 12/08/2003 02:24:33 PM, [EMAIL PROTECTED] wrote:
  
  
.. And there used to be all these dc_   parameters that one could set,
giving the dba control over the dictionary cache, which was not a part

  
  of
  
  
the shared pool. And then came Oracle V7, with the shared_pool_size,
wresting that control.

Regards






  
  
  
  
Mladen Gogala

  
  
  
  
<[EMAIL PROTECTED]   To: Multiple recipients

  
  of list ORACLE-L <[EMAIL PROTECTED]>   
  
  
ading.com>   cc:

  
  
  
  
Sent by: Subject: Re:

  
  dc_used_extents ,dc_free_extents and dc_histogram_defs   
  
  
[EMAIL PROTECTED]

  
  
  
  
ity.com

  
  
  
  
  
  
  
  
12/08/2003

  
  
  
  
01:29 PM

  
  
  
  
Please respond

  
  
  
  
to ORACLE-L

  
  
  
  
  
  
  
  



Well, once upon a time, in a land far, far away, there was Oracle V6

  
  with
  
  
something called "TPO", which was essentially row locking + PL/SQL V1

  
  (no
  
  
stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve
Feuerstein
and Howard  Rogers know a thing or two about the Jurassic period in

  
  the
  
  
database
development. BTW, that was also when buffer hit ratio was invented.

  
  The
  
  
entries that you see are remnants from oracle v6, together with the

  
  table
  
  
called "V$ROWCACHE" and are both religiously maintained for the
compatibility
reasons, because Oracle Corp. doesn't want to disappoint all those who

  
  are
  
  
still running V6. Even compatibility with V5 is still maintained. In

  
  Oracle
  
  
5.1.22,
dictionary views weren't called "user_tables" and "user_objects", they

  
  were
  
  
called
"tab" (user_tables) and cat (from "CATALOG", replaced with

  
  "USER_OBJECTS").
  
  
The term
"CATALOG" was directory command on Apple IIe (6502, later Z80) with

  
  100k
  
  
floppies,
computer immensly popular at the time, and I believe that is why the

  
  first
  
  
implementation of "user_objects" was called "catalog". Now, let's fast
forward to the
present time and Oracle 9.2.0.4.  Do "Select * from tab" and "select *

  
  from
  
  
cat".
You'll be surprised. For all those still running V5.1.22 with forms

  
  2.0 and
  
  
2.3,
the world is not over yet.

On 12/08/2003 12:39:30 PM, Guang Mei wrote:


  Hi:

I am reading some statspack reports from our 8173 DB (on Sun
  

  
  Solaris) and
  
  

  found some of "Dictionary Cache Stats" are pretty high (much higher
  

  
  than
  
  

  2%). I notice that "Pct Get Miss" for dc_used_extents
  

  
  ,dc_free_extents
  
  
and


  dc_histogram_defs are high (the second column data below).  Is this
something I need to pay attention in terms of doing performance
optimization? If yes, what are the things (regarding "Dictionary
  

  
  Cache")
  
  

  that I should look in order to improve the performance?

TIA.

Guang

ps, here are some "dc_" stats from my reports and a copy of actual
  

  
  report
  
  

  (partial):
  

  
  
  

Re: A brief detour....;-)

[Vladimir Begun]

Bobak, Mark wrote:
> Here it is:
[...]
> This concludes this public service announcement.  We now return
> you to our regularly scheduled programming.
Interesting. PL/SQL recursive solutions are expensive, though. :)
Did not check it, maybe something alike was posted already...
SET VERIFY OFF PAGES 200
DEFINE disks=7
REM Please do not use all_objects :)
DEFINE big_table=all_objects
COLUMN "Implementation Plan" FORMAT A20
SPOOL hanoi_solution.txt
SELECT 'Move it from '
|| TO_CHAR(MOD(BITAND(ROWNUM, ROWNUM - 1), 3) + 1)
|| ' to '
|| TO_CHAR(MOD(-BITAND(-ROWNUM - 1, -ROWNUM), 3) + 1) AS "Implementation Plan"
  FROM &&big_table
 WHERE ROWNUM < POWER(2, &&disks)
   AND &&disks < 8
/
SPOOL OFF
Should work correctly.

Regards,
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: CLONE db

[anu]

I assume both OS are same (Linux).
 
What you can do is rename the filenames using alter tablespace or alter database rename file. So

 
1) Copy database files, archive logs etc. to new machine
2) Startup mount
3) Rename files 
4) Start recovery
 
You could also take a backup controlfile to trace then change the file u get in udump to change the file names. Then use it to create a controlfile on the new machine. However using controlfile and creating a new controlfile means you can only do 'resetlogs'. 
 

1) Copy database files to new machine
2) Startup nomount
3) Create controlfile 
4) Start recovery
 
Seema Singh <[EMAIL PROTECTED]> wrote:
Hi,I have hotbackup for x date.I want to create clone to another box on Linux(Oracle9i).is it possible to clone with same instance name on diffrent box with diffrent file location?I think yes.Can someone send me correct steps how to clone on linux box?Thx-Seema_Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Seema SinghINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED]
tcity.com
 (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Pete Sharman]

Well, I think part of the problem is a perception (how valid it is I
don't think I'm in a position to say, but the perception certainly
exists) that allowing access to the code too early simply provides
ammunition for competitors to be far more prepared than we'd like them
to be.  :)

And no apologies needed.  Particularly from someone that's bigger than
me!  :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Mladen Gogala
Sent: Tuesday, December 09, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L


On 2003.12.08 17:24, Pete Sharman wrote:
> Well, you could have joined the beta program if you were THAT
> interested, Mladen!

I missed the opportunity because I was amid changing jobs.  I tried to
lay my hands
on the software several times since then, to no avail.

> 
> Ducks and runs.  :)

No need, Pete. I've always appreciated your advice and expertize. Your
posts have been 
very useful to me on more then one occasion. I am the one to apologize
for blowing off 
some steam, but I must confess,  that I  don't understand such secrecy,
especially not 
after it has already been announced. 



-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Mladen Gogala]

On 2003.12.08 17:24, Pete Sharman wrote:
> Well, you could have joined the beta program if you were THAT
> interested, Mladen!

I missed the opportunity because I was amid changing jobs.  I tried to lay my hands
on the software several times since then, to no avail.

> 
> Ducks and runs.  :)

No need, Pete. I've always appreciated your advice and expertize. Your posts have been 
very useful to me on more then one occasion. I am the one to apologize for blowing off 
some steam, but I must confess,  that I  don't understand such secrecy, especially not 
after it has already been announced. 



-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Database management techniques and frameworks

[Orr, Steve]

I'm not assuming such a tool exists... It indeed does exist because the
salesman who happened to be selling it said so and it must be true. ;-)
A former boss saw it, got it (on eval) then tried to get me to use it.
Lucky for me I was able to deflect such silliness until the boss was
fired. I was also fortunate in that, while some of the Unix dweebs
thought the tool was cool, they eventually tired of the scene and I was
able to continue with my proven script/monitoring routines. As a happy
Bambi below the heavens I did frolic.  :-)



-Original Message-
Mladen Gogala
Sent: Monday, December 08, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L


Here, of course, you're assuming that such a magical GUI, sort of DBA in
an 
ancient oil lamp, tools exist. Well, they do not. Even if you have some
useful 
gooey tools, they do require extensive configuration and customization
to become 
useful and they do require extensive knowledge from the person doing
configuration and customization. Other then that, I find it quite
questionable how useful it is to fire your own customers and replace
them with cheap Elbonian labor. Anyone who has called Oracle support
recently knows exactly what I'm talking about. On 12/08/2003 04:44:31
PM, "Orr, Steve" wrote:
> No Bambi,
> 
> No, no, no... This is not what damagement wants. They don't want you 
> to develop your own tools and scripts so they are dependent on you. 
> They want to spent lots of money on a GUI tool they can see and they 
> want a sales drone to show them how easy it is and tell them that 
> anybody can be a DBA if they just had this GUI tool. That way, if they

> don't like you they can get rid of you and just pluggin another warm 
> body. Sort of like handing a hammer to an unskilled laborer and 
> saying, "Here, you are now a master carpenter." By all means stop 
> using that geek stuff like Perl. Stop being subversive to the system 
> by developing your own stuff and use the GUI wizbang tool that 
> damagement likes.
> 
> 
> 
> -Original Message-
> Bellow, Bambi
> Sent: Friday, December 05, 2003 1:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Adam --
> 
> I've done this more times than I can count.  The answer is "it depends

> on your environment, your desired results, and, more often than not, 
> your corporate structure".  Here's some examples:
> 
> 1)  Monitoring script pages DBA group if X happens, Unix group if Y 
> happens, Network group if Z happens.  Simultaneously, XTerm windows 
> are popped up in both Operations and HelpDesk with the name and pager 
> number of the person paged (via uucp)
> 
> 2)  Monitoring script sends messages to centralized Error Management 
> System. Error Management System handles it
> 
> 3)  Monitoring script finds problem and corrects problem.  If problem 
> continues, email is generated
> 
> 4)  Error Management System has external handles (not APIs) which can 
> be used to call Monitoring Scripts, which need to be modified to 
> ustilize System's internal structures (sometimes written in French -- 
> *that* was
> fun!)
> 
> 5)  Monitoring script simply sends emails
> 
> 6)  Monitoring script keeps track of the errors in log files which are

> compared to log files from X time ago and only the differences are 
> reported
> 
> 7)  Monitoring script has redundancy built in such that the first X 
> times a particular problem is encountered, the Monitoring System 
> ignores it, then generates a page
> 
> 8)  Monitoring script has redundnacy built in such that after the 
> first time the problem is encountered, a page is sent, and if there is

> still a problem 15 minutes later, someone else is paged and so on up 
> the company ladder
> 
> It goes on and on.  This is largely what I've been doing for the past 
> 8 years.  Note that the words "Monitoring script" as used above is 
> generally an inherently complicated conglomeration of several 
> different scripts, generally with a governor and/or one or more 
> driver(s), infrequently on different operating systems, sometimes in 
> multiple languages and/or utilizing, or integrating with, or extending

> the capabilities of, one or more COTS products, which use different 
> mechanisms to trigger and synchronize them.  Generally, there is some 
> kind of "IGNORE" functionality which allows for specified downtime for

> maintenance, or "ALTERNATE" functionality for unusual yet definable 
> situations, and hierarchy of tests (if the database is down, that 
> implies that a subsequent error that a user cannot connect to it has 
> already been dealt with) and, occasionally has sniffers on other boxes

> to determine whether remote scripts need to be run either dependent 
> upon remote conditions or independent of them.  Sometimes, there is a 
> process which kicks off other jobs and manages the security.  I 
> particularly enjoy those where there is fault tolerance built in such 
> that if Monitoring script X on Machine Y craps out, Machine Z takes 
> ove

CLONE db

[Seema Singh]

Hi,
I have hotbackup for x  date.I want to create clone to another box on 
Linux(Oracle9i).
is it possible to clone with same instance name on diffrent box with 
diffrent file location?I think yes.
Can someone send me correct steps how to clone on linux box?
Thx
-Seema

_
Get holiday tips for festive fun. 
http://special.msn.com/network/happyholidays.armx

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Seema Singh
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: A brief detour....;-)

[Jonathan Gennick]

Monday, December 8, 2003, 4:19:27 PM, Bobak, Mark ([EMAIL PROTECTED]) wrote:
BM> So, I saw on SlashDot (http://www.slashdot.org/) a story
BM> about a guy who has over 100 different implementations
BM> of the Towers of Hanoi solution, each in a different
BM> language. Since he didn't have one in PL/SQL,

Aw, PL/SQL never gets no respect.

BM> I decided to write one.

Cool! I hope you posted the PL/SQL solution on Slashdot too.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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 Data Guard

[Nalla Ravi]

Hi Carel,

What if 50% of tables doesn't have Primary/Unique
keys, how it is going be with LSB then? Can you please
explain more.

with thanks,
Vi


--- Carel-Jan Engel <[EMAIL PROTECTED]>
wrote: > Comments inline
> 
> At 14:54 8-12-03 -0800, you wrote:
> >Hi Carel,
> >
> >That is good help, can you please send me the pdf
> that
> >  you implemented there then.
> 
> Was on its way already
> 
> 
> >Tell me one thing I agree that we some
> >times
> >(rather most of the time ) generate less redo so 
> we
> >should be smooth. Can you tell me is there any
> >releation  between LSB and Primary keys, I read 
> like
> >LCR(logical Change Request) is based on Primary  
> keys
> >as It does not depends on Transaction at that time.
> 
> Because LSB 'reverse engineers' SQL from the redolog
> info, it needs to get 
> hold of the right rows. The rows get
> inserted/updated/deleted, and _a_ 
> unique identification, not being the rowid, is
> required. So, every row 
> needs to be uniquely identified.
> 
> 
> 
> >Have you implemnented LSB successfully?
> 
> Yes, using a PSB / LSB combination for standby and
> reporting purposes 
> respectively.
> 
> 
> >with many thanks,
> >Vi.
> >
> >  --- Carel-Jan Engel <[EMAIL PROTECTED]>
> >wrote: > Comments inline
> > >
> > > At 13:34 8-12-03 -0800, you wrote:
> > > >Hi  Tanel,
> > > >
> > > >
> > > >Much appreciated, The fact is I am interested
> in
> > > >Logical standby rather than physical.
> > > >
> > > >   Our 30-50% of our Production data needs to
> be
> > > >replicated to another database and where they
> will
> > > >have their processing and batches.
> > >
> > > It all depends on the amount of redolog you
> > > generate. When that's pretty
> > > much, you waste some resources by transporting
> > > online/archived redologs you
> > > actually don't need.
> > >
> > >
> > > >  Now We didn't go to Snapshot because It is on
> > > >multiple  tables (where we didnot have PK's and
> > > many
> > > >tables) and due to performance issue I didn't
> want
> > > to
> > > >use Snapshots (they did not want  any tables to
> be
> > > >truncate before being loaded even via
> snapshots).
> > >
> > > So, they don't like nologging operations like
> > > truncate, not even on the
> > > standby database?
> > >
> > >
> > > >  The best option I think is Logical Standby
> > > Database.
> > > >Or Can  you please suggest me any other means.
> > > >
> > > >Replication should be quicker like
> once
> > > in
> > > >every 20 minutes, Even Transportable tablespacs
> > > does
> > > >not work here since they need all tables to
> 24*7.
> > >
> > > LSB might work, but do not consider the option
> of
> > > failing over to it. Be
> > > aware that, altough in maximum protection mode
> your
> > > redolog arrives at the
> > > SB system within the transaction, it doesn't get
> > > applied there instantly.
> > > SQL Application takes place _after_ the
> log-switch
> > > on the Primary. When you
> > > take 10 minutes of redolog, and perform a
> logswitch,
> > > the SQL Apply process
> > > might even take longer than 10 minutes to
> complete
> > > processing of the
> > > redologfile. There is a risk that not every
> > > transaction arrives within 20
> > > minutes at the LSB. So, your log-switching
> frequency
> > > and the amount of redo
> > > you generate per unit of time both play a major
> role
> > > in the refresh rate of
> > > the LSB.
> > >
> > > I'll send you the PDF of a DG Special I did in
> Kista
> > > a few months ago.
> > >
> > >
> > > Regards, Carel-Jan
> > >
> > > -- There will allwasy be another 10 last bugs --
> > >
> > >
> > > >Any suggestion would be more helpful.
> > > >
> > > >with thanks,
> > > >Vi.
> > > >
> > > >
> > > >
> > > >--- Tanel Poder <[EMAIL PROTECTED]>
> wrote: >
> > > >
> > > >Hi All,
> > > > > >
> > > > > > can any one let me know kindly the
> following
> > > info.
> > > > > >
> > > > > > 1) Has any one used the Oracle 9i Data
> Guard?
> > > > >
> > > > > Yes, physical standby and successfully.
> > > > >
> > > > > > 2) If yes then,  is there any performance
> > > impact
> > > > > on
> > > > > > Target/Source server database.
> > > > >
> > > > > Your database has to be in archivelog mode,
> but
> > > when
> > > > > you are thinking such
> > > > > solutions as DG, then you probably are
> already
> > > > > running archivelog anyway.
> > > > >
> > > > > If you run in maximum protection or maximum
> > > > > availability, yes there is. The
> > > > > impact depends mainly on network connection
> > > between
> > > > > primary and standby(s)
> > > > > and the speed of redolog disks. You could
> tune
> > > these
> > > > > by using faster
> > > > > network, enabling jumbo frames and SDU size
> if
> > > using
> > > > > Gbit ethernet, also
> > > > > setting lgwr and log apply processes
> priority
> > > higher
> > > > > than others.
> > > > >
> > > > > > 3) any drawbacks using Data Guard.
> > > > >
> > > > > You should set your database or critical
> > > tablespaces
> > > > 

RE: rebuilding indexes - sure to cause a ruckus

[Orr, Steve]

I think it needs an index. ;-)


-Original Message-
Paul Baumgartel
Sent: Monday, December 08, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L

"somewhat on the longish side"???

I'd hate to see a "long" article!  ;-)


--- Richard Foote <[EMAIL PROTECTED]> wrote:
> Hi Yong,
> 
> Saying there are a "few" errors is being a little kind to Don's 
> "Inside Oracle Indexing" article.
> 
> In part, these are some of the issues I raised directly with Don in a 
> number of emails (warning somewhat on the longish side ;):
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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 Data Guard

[Carel-Jan Engel]

Comments inline

At 14:54 8-12-03 -0800, you wrote:
Hi Carel,

That is good help, can you please send me the pdf that
 you implemented there then.
Was on its way already


   Tell me one thing I agree that we some
times
(rather most of the time ) generate less redo so  we
should be smooth. Can you tell me is there any
releation  between LSB and Primary keys, I read  like
LCR(logical Change Request) is based on Primary   keys
as It does not depends on Transaction at that time.
Because LSB 'reverse engineers' SQL from the redolog info, it needs to get 
hold of the right rows. The rows get inserted/updated/deleted, and _a_ 
unique identification, not being the rowid, is required. So, every row 
needs to be uniquely identified.



Have you implemnented LSB successfully?
Yes, using a PSB / LSB combination for standby and reporting purposes 
respectively.


with many thanks,
Vi.
 --- Carel-Jan Engel <[EMAIL PROTECTED]>
wrote: > Comments inline
>
> At 13:34 8-12-03 -0800, you wrote:
> >Hi  Tanel,
> >
> >
> >Much appreciated, The fact is I am interested in
> >Logical standby rather than physical.
> >
> >   Our 30-50% of our Production data needs to be
> >replicated to another database and where they will
> >have their processing and batches.
>
> It all depends on the amount of redolog you
> generate. When that's pretty
> much, you waste some resources by transporting
> online/archived redologs you
> actually don't need.
>
>
> >  Now We didn't go to Snapshot because It is on
> >multiple  tables (where we didnot have PK's and
> many
> >tables) and due to performance issue I didn't want
> to
> >use Snapshots (they did not want  any tables to be
> >truncate before being loaded even via snapshots).
>
> So, they don't like nologging operations like
> truncate, not even on the
> standby database?
>
>
> >  The best option I think is Logical Standby
> Database.
> >Or Can  you please suggest me any other means.
> >
> >Replication should be quicker like once
> in
> >every 20 minutes, Even Transportable tablespacs
> does
> >not work here since they need all tables to 24*7.
>
> LSB might work, but do not consider the option of
> failing over to it. Be
> aware that, altough in maximum protection mode your
> redolog arrives at the
> SB system within the transaction, it doesn't get
> applied there instantly.
> SQL Application takes place _after_ the log-switch
> on the Primary. When you
> take 10 minutes of redolog, and perform a logswitch,
> the SQL Apply process
> might even take longer than 10 minutes to complete
> processing of the
> redologfile. There is a risk that not every
> transaction arrives within 20
> minutes at the LSB. So, your log-switching frequency
> and the amount of redo
> you generate per unit of time both play a major role
> in the refresh rate of
> the LSB.
>
> I'll send you the PDF of a DG Special I did in Kista
> a few months ago.
>
>
> Regards, Carel-Jan
>
> -- There will allwasy be another 10 last bugs --
>
>
> >Any suggestion would be more helpful.
> >
> >with thanks,
> >Vi.
> >
> >
> >
> >--- Tanel Poder <[EMAIL PROTECTED]> wrote: >
> >
> >Hi All,
> > > >
> > > > can any one let me know kindly the following
> info.
> > > >
> > > > 1) Has any one used the Oracle 9i Data Guard?
> > >
> > > Yes, physical standby and successfully.
> > >
> > > > 2) If yes then,  is there any performance
> impact
> > > on
> > > > Target/Source server database.
> > >
> > > Your database has to be in archivelog mode, but
> when
> > > you are thinking such
> > > solutions as DG, then you probably are already
> > > running archivelog anyway.
> > >
> > > If you run in maximum protection or maximum
> > > availability, yes there is. The
> > > impact depends mainly on network connection
> between
> > > primary and standby(s)
> > > and the speed of redolog disks. You could tune
> these
> > > by using faster
> > > network, enabling jumbo frames and SDU size if
> using
> > > Gbit ethernet, also
> > > setting lgwr and log apply processes priority
> higher
> > > than others.
> > >
> > > > 3) any drawbacks using Data Guard.
> > >
> > > You should set your database or critical
> tablespaces
> > > to force logging mode
> > > in order to transfer all changes to standby in
> > > physical standby. That means,
> > > performance improvements which take advantage of
> > > nologging operations (such
> > > insert append nologging etc), will not run that
> fast
> > > anymore.
> > > In logical standby, I think there's no such
> > > requirement, but I don't
> > > recommend you to use logical stby yet, it's more
> > > like a prototype currently,
> > > not exactly a working product.
> > >
> > > Tanel.
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.net
> > > --
> > > Author: Tanel Poder
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051
> > > http://www.fatcity.com
> > > San Diego, California-- Mailing list and
> web
> > > hosting services
> > >
>

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Carel-Jan Engel]

At 11:59 8-12-03 -0800, you wrote:
Larry Ellison has publicly stated that his goal is to produce a database with
less then 100 tunable parameters. Allegedly, he came rather close with 10g.
Aaargh, that's why LOG_ARCHIVE_DEST_n gets so many options that 
documentation of one parameter takes 56 pages!
The more options, the lesser parameters! or is it the other way around?

Carel-Jan

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: migrate 8.1.7 to 9.2.0

[Bellow, Bambi]

Make sure your ORACLE_SID and ORACLE_HOME are set.

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L


Guys,

I am working through a manual migration from 8i to 9i on Solaris 2.8.  I am
using the guide in Note:  159657.1.

I shutdown the 8.1.7 database, copied network and init files - then run 

sqlplus "/ as sysdba"

or 
sqlplus /nolog
connect sys/jfjfj as sysdba

I get 
ORA-12545:  Connect failed because target host or object does not exist.

What target host - what object

I had to change domain name and set ORA_NLS33 if that matters??

I can't find anything on Metastink that seems relevant although a great deal
of stuff
on this error code.

Help.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Bellow, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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 Data Guard

[Nalla Ravi]

Hi Carel,

That is good help, can you please send me the pdf that
 you implemented there then.

   Tell me one thing I agree that we some
times
(rather most of the time ) generate less redo so  we
should be smooth. Can you tell me is there any
releation  between LSB and Primary keys, I read  like 
LCR(logical Change Request) is based on Primary   keys
as It does not depends on Transaction at that time.


Have you implemnented LSB successfully?

with many thanks,
Vi.

 --- Carel-Jan Engel <[EMAIL PROTECTED]>
wrote: > Comments inline
> 
> At 13:34 8-12-03 -0800, you wrote:
> >Hi  Tanel,
> >
> >
> >Much appreciated, The fact is I am interested in
> >Logical standby rather than physical.
> >
> >   Our 30-50% of our Production data needs to be
> >replicated to another database and where they will
> >have their processing and batches.
> 
> It all depends on the amount of redolog you
> generate. When that's pretty 
> much, you waste some resources by transporting
> online/archived redologs you 
> actually don't need.
> 
> 
> >  Now We didn't go to Snapshot because It is on
> >multiple  tables (where we didnot have PK's and
> many
> >tables) and due to performance issue I didn't want
> to
> >use Snapshots (they did not want  any tables to be
> >truncate before being loaded even via snapshots).
> 
> So, they don't like nologging operations like
> truncate, not even on the 
> standby database?
> 
> 
> >  The best option I think is Logical Standby
> Database.
> >Or Can  you please suggest me any other means.
> >
> >Replication should be quicker like once
> in
> >every 20 minutes, Even Transportable tablespacs
> does
> >not work here since they need all tables to 24*7.
> 
> LSB might work, but do not consider the option of
> failing over to it. Be 
> aware that, altough in maximum protection mode your
> redolog arrives at the 
> SB system within the transaction, it doesn't get
> applied there instantly. 
> SQL Application takes place _after_ the log-switch
> on the Primary. When you 
> take 10 minutes of redolog, and perform a logswitch,
> the SQL Apply process 
> might even take longer than 10 minutes to complete
> processing of the 
> redologfile. There is a risk that not every
> transaction arrives within 20 
> minutes at the LSB. So, your log-switching frequency
> and the amount of redo 
> you generate per unit of time both play a major role
> in the refresh rate of 
> the LSB.
> 
> I'll send you the PDF of a DG Special I did in Kista
> a few months ago.
> 
> 
> Regards, Carel-Jan
> 
> -- There will allwasy be another 10 last bugs --
> 
> 
> >Any suggestion would be more helpful.
> >
> >with thanks,
> >Vi.
> >
> >
> >
> >--- Tanel Poder <[EMAIL PROTECTED]> wrote: >
> >
> >Hi All,
> > > >
> > > > can any one let me know kindly the following
> info.
> > > >
> > > > 1) Has any one used the Oracle 9i Data Guard?
> > >
> > > Yes, physical standby and successfully.
> > >
> > > > 2) If yes then,  is there any performance
> impact
> > > on
> > > > Target/Source server database.
> > >
> > > Your database has to be in archivelog mode, but
> when
> > > you are thinking such
> > > solutions as DG, then you probably are already
> > > running archivelog anyway.
> > >
> > > If you run in maximum protection or maximum
> > > availability, yes there is. The
> > > impact depends mainly on network connection
> between
> > > primary and standby(s)
> > > and the speed of redolog disks. You could tune
> these
> > > by using faster
> > > network, enabling jumbo frames and SDU size if
> using
> > > Gbit ethernet, also
> > > setting lgwr and log apply processes priority
> higher
> > > than others.
> > >
> > > > 3) any drawbacks using Data Guard.
> > >
> > > You should set your database or critical
> tablespaces
> > > to force logging mode
> > > in order to transfer all changes to standby in
> > > physical standby. That means,
> > > performance improvements which take advantage of
> > > nologging operations (such
> > > insert append nologging etc), will not run that
> fast
> > > anymore.
> > > In logical standby, I think there's no such
> > > requirement, but I don't
> > > recommend you to use logical stby yet, it's more
> > > like a prototype currently,
> > > not exactly a working product.
> > >
> > > Tanel.
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.net
> > > --
> > > Author: Tanel Poder
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051
> > > http://www.fatcity.com
> > > San Diego, California-- Mailing list and
> web
> > > hosting services
> > >
>
>-
> > > To REMOVE yourself from this mailing 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
> >

Re: Oracle Data Guard

[Tanel Poder]

With TCP over standard ethernet the maximum transfer unit (MTU) is about
1500 bytes, this means if you want to send 2000 bytes over network, you have
to fragment it in 2 packets and send them separately. This means double
packet headers, double latency etc. Jumbo frames is a capability of some
Gbit ethernet cards which allow them to transfer about 9000 bytes in a
single packet. SDU is session level transfer unit (session data unit). When
you enable jumbo frames and set MTU/SDU to 8192 for example, you'll fit much
more in single packet, thus increasing performance for larger transactions.

Also make sure that TCP.NODELAY is unset in your sqlnet.ora or is set to
true.

More info can be found from:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/troubleshooting.htm#635905

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 11:49 PM


> Hi,
>
> Tanel,
>
> "enabling jumbo frames and SDU size if using
> Gbit ethernet,"
>
> can you elaborate on this?
>
>
>
>
> -Original Message-
> Sent: Monday, December 08, 2003 1:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi  Tanel,
>
>
> Much appreciated, The fact is I am interested in
> Logical standby rather than physical.
>
>   Our 30-50% of our Production data needs to be
> replicated to another database and where they will
> have their processing and batches.
>
>  Now We didn't go to Snapshot because It is on
> multiple  tables (where we didnot have PK's and many
> tables) and due to performance issue I didn't want to
> use Snapshots (they did not want  any tables to be
> truncate before being loaded even via snapshots).
>
>  The best option I think is Logical Standby Database.
> Or Can  you please suggest me any other means.
>
>Replication should be quicker like once in
> every 20 minutes, Even Transportable tablespacs does
> not work here since they need all tables to 24*7.
>
> Any suggestion would be more helpful.
>
> with thanks,
> Vi.
>
>
>
> --- Tanel Poder <[EMAIL PROTECTED]> wrote: > >
> Hi All,
> > >
> > > can any one let me know kindly the following info.
> > >
> > > 1) Has any one used the Oracle 9i Data Guard?
> >
> > Yes, physical standby and successfully.
> >
> > > 2) If yes then,  is there any performance impact
> > on
> > > Target/Source server database.
> >
> > Your database has to be in archivelog mode, but when
> > you are thinking such
> > solutions as DG, then you probably are already
> > running archivelog anyway.
> >
> > If you run in maximum protection or maximum
> > availability, yes there is. The
> > impact depends mainly on network connection between
> > primary and standby(s)
> > and the speed of redolog disks. You could tune these
> > by using faster
> > network, enabling jumbo frames and SDU size if using
> > Gbit ethernet, also
> > setting lgwr and log apply processes priority higher
> > than others.
> >
> > > 3) any drawbacks using Data Guard.
> >
> > You should set your database or critical tablespaces
> > to force logging mode
> > in order to transfer all changes to standby in
> > physical standby. That means,
> > performance improvements which take advantage of
> > nologging operations (such
> > insert append nologging etc), will not run that fast
> > anymore.
> > In logical standby, I think there's no such
> > requirement, but I don't
> > recommend you to use logical stby yet, it's more
> > like a prototype currently,
> > not exactly a working product.
> >
> > Tanel.
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: Tanel Poder
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing 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).
>
> 
> BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer
> ends 21st December 2003. The way the internet was meant to be.
> http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: =?iso-8859-1?q?Nalla=20Ravi?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL

can't see a SQL generated by Crystal Report

[Gene Gurevich]

Hi all:

I'm trying to catch a DDL generated by Crystal report.
I'm using the following query to do that:
select  sql_text
  from v$sqltext
where ( address, hash_value ) in
  (select sql_address, sql_hash_value
 from v$session
   where username = UPPER('&username'))
  order by piece
I am catching a SQL, but that SQL returns different
amount of rows than the report when executed through a
Crystal. Is there something wrong with my query (it is
running under Oracle 817) that makes it miss some
data? 

thanks 

Gene


__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: rebuilding indexes - sure to cause a ruckus

[Paul Baumgartel]

"somewhat on the longish side"???

I'd hate to see a "long" article!  ;-)




--- Richard Foote <[EMAIL PROTECTED]> wrote:
> Hi Yong,
> 
> Saying there are a "few" errors is being a little kind to Don's
> "Inside
> Oracle Indexing" article.
> 
> In part, these are some of the issues I raised directly with Don in a
> number
> of emails (warning somewhat on the longish side ;):


__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: migrate 8.1.7 to 9.2.0

[Paula_Stankus]

Guys,

I am working through a manual migration from 8i to 9i on Solaris 2.8.  I am using the 
guide in Note:  159657.1.

I shutdown the 8.1.7 database, copied network and init files - then run 

sqlplus "/ as sysdba"

or 
sqlplus /nolog
connect sys/jfjfj as sysdba

I get 
ORA-12545:  Connect failed because target host or object does not exist.

What target host - what object

I had to change domain name and set ORA_NLS33 if that matters??

I can't find anything on Metastink that seems relevant although a great deal of stuff
on this error code.

Help.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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 Data Guard

[Carel-Jan Engel]

Comments inline

At 13:34 8-12-03 -0800, you wrote:
Hi  Tanel,

Much appreciated, The fact is I am interested in
Logical standby rather than physical.
  Our 30-50% of our Production data needs to be
replicated to another database and where they will
have their processing and batches.
It all depends on the amount of redolog you generate. When that's pretty 
much, you waste some resources by transporting online/archived redologs you 
actually don't need.


 Now We didn't go to Snapshot because It is on
multiple  tables (where we didnot have PK's and many
tables) and due to performance issue I didn't want to
use Snapshots (they did not want  any tables to be
truncate before being loaded even via snapshots).
So, they don't like nologging operations like truncate, not even on the 
standby database?


 The best option I think is Logical Standby Database.
Or Can  you please suggest me any other means.
   Replication should be quicker like once in
every 20 minutes, Even Transportable tablespacs does
not work here since they need all tables to 24*7.
LSB might work, but do not consider the option of failing over to it. Be 
aware that, altough in maximum protection mode your redolog arrives at the 
SB system within the transaction, it doesn't get applied there instantly. 
SQL Application takes place _after_ the log-switch on the Primary. When you 
take 10 minutes of redolog, and perform a logswitch, the SQL Apply process 
might even take longer than 10 minutes to complete processing of the 
redologfile. There is a risk that not every transaction arrives within 20 
minutes at the LSB. So, your log-switching frequency and the amount of redo 
you generate per unit of time both play a major role in the refresh rate of 
the LSB.

I'll send you the PDF of a DG Special I did in Kista a few months ago.

Regards, Carel-Jan

-- There will allwasy be another 10 last bugs --


Any suggestion would be more helpful.

with thanks,
Vi.


--- Tanel Poder <[EMAIL PROTECTED]> wrote: > >
Hi All,
> >
> > can any one let me know kindly the following info.
> >
> > 1) Has any one used the Oracle 9i Data Guard?
>
> Yes, physical standby and successfully.
>
> > 2) If yes then,  is there any performance impact
> on
> > Target/Source server database.
>
> Your database has to be in archivelog mode, but when
> you are thinking such
> solutions as DG, then you probably are already
> running archivelog anyway.
>
> If you run in maximum protection or maximum
> availability, yes there is. The
> impact depends mainly on network connection between
> primary and standby(s)
> and the speed of redolog disks. You could tune these
> by using faster
> network, enabling jumbo frames and SDU size if using
> Gbit ethernet, also
> setting lgwr and log apply processes priority higher
> than others.
>
> > 3) any drawbacks using Data Guard.
>
> You should set your database or critical tablespaces
> to force logging mode
> in order to transfer all changes to standby in
> physical standby. That means,
> performance improvements which take advantage of
> nologging operations (such
> insert append nologging etc), will not run that fast
> anymore.
> In logical standby, I think there's no such
> requirement, but I don't
> recommend you to use logical stby yet, it's more
> like a prototype currently,
> not exactly a working product.
>
> Tanel.
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing 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).

BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer 
ends 21st December 2003. The way the internet was meant to be. 
http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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

Re: rebuilding indexes - sure to cause a ruckus

[Vladimir Begun]

Tanel Poder wrote:
Ouch, I gotta take a day off to read this one ;)
http://www.netmeister.org/news/learn2quote.html

It's all about optimization...
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: PERL?

[Jesse, Rich]

If the rest works, the JDBC thin client oughtta work, too.

I wonder if anyone's bothered for some unholy reason to try Oracle server in
WineX... :)

Rich

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


-Original Message-
Sent: Monday, December 08, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L


Can you install Oracle 9.2 on a playstation 2?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Who is querying database info using dblink

[Bobak, Mark]

Try this:

Select /*+ ORDERED */
substr(s.ksusemnm,1,10)||'-'|| substr(s.ksusepid,1,10)  "ORIGIN",
substr(g.K2GTITID_ORA,1,35) "GTXID",
substr(s.indx,1,4)||'.'|| substr(s.ksuseser,1,5) "LSESSION" ,
substr(decode(bitand(ksuseidl,11),1,'ACTIVE',0,
decode(bitand(ksuseflg,4096),0,'INACTIVE','CACHED'),
2,'SNIPED',3,'SNIPED', 'KILLED'),1,1) "S",
substr(event,1,10) "WAITING"
  from  x$k2gte g, x$ktcxb t, x$ksuse s, v$session_wait w
 where  g.K2GTDXCB =t.ktcxbxba
   and   g.K2GTDSES=t.ktcxbses
   and  s.addr=g.K2GTDSES
   and  w.sid=s.indx
;
-Original Message-
Sent: Monday, December 08, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L


How do I check who is querying database information via database link?

Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Pete Sharman]

Well, you could have joined the beta program if you were THAT
interested, Mladen!

Ducks and runs.  :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

-Original Message-
Mladen Gogala
Sent: Tuesday, December 09, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L

Larry Ellison has publicly stated that his goal is to produce a database
with 
less then 100 tunable parameters. Allegedly, he came rather close with
10g.
As far as 10g is concerned, I'm rather disappointed with the marketing
hype 
being created with oracle not making an early version available. I don't
plan
on migrating to 10g until I learn it well and if some oracle sales guy
tries to exert pressure on me to migrate, he will get a very stable sign
used by English archers after the battle at Agincourt to signify that
they 
still have all the fingers needed to operate a longbow. I've had my fill
of
white papers and articles and now I want to see the software.

On 12/08/2003 02:24:33 PM, [EMAIL PROTECTED] wrote:
> 
> .. And there used to be all these dc_   parameters that one could set,
> giving the dba control over the dictionary cache, which was not a part
of
> the shared pool. And then came Oracle V7, with the shared_pool_size,
> wresting that control.
> 
> Regards
> 
> 
> 
> 
>

> Mladen Gogala

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

> Sent by: Subject: Re:
dc_used_extents ,dc_free_extents and dc_histogram_defs   
> [EMAIL PROTECTED]

> ity.com

>

>

> 12/08/2003

> 01:29 PM

> Please respond

> to ORACLE-L

>

>

> 
> 
> 
> 
> Well, once upon a time, in a land far, far away, there was Oracle V6
with
> something called "TPO", which was essentially row locking + PL/SQL V1
(no
> stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve
> Feuerstein
> and Howard  Rogers know a thing or two about the Jurassic period in
the
> database
> development. BTW, that was also when buffer hit ratio was invented.
The
> entries that you see are remnants from oracle v6, together with the
table
> called "V$ROWCACHE" and are both religiously maintained for the
> compatibility
> reasons, because Oracle Corp. doesn't want to disappoint all those who
are
> still running V6. Even compatibility with V5 is still maintained. In
Oracle
> 5.1.22,
> dictionary views weren't called "user_tables" and "user_objects", they
were
> called
> "tab" (user_tables) and cat (from "CATALOG", replaced with
"USER_OBJECTS").
> The term
> "CATALOG" was directory command on Apple IIe (6502, later Z80) with
100k
> floppies,
> computer immensly popular at the time, and I believe that is why the
first
> implementation of "user_objects" was called "catalog". Now, let's fast
> forward to the
> present time and Oracle 9.2.0.4.  Do "Select * from tab" and "select *
from
> cat".
> You'll be surprised. For all those still running V5.1.22 with forms
2.0 and
> 2.3,
> the world is not over yet.
> 
> On 12/08/2003 12:39:30 PM, Guang Mei wrote:
> > Hi:
> >
> > I am reading some statspack reports from our 8173 DB (on Sun
Solaris) and
> > found some of "Dictionary Cache Stats" are pretty high (much higher
than
> > 2%). I notice that "Pct Get Miss" for dc_used_extents
,dc_free_extents
> and
> > dc_histogram_defs are high (the second column data below).  Is this
> > something I need to pay attention in terms of doing performance
> > optimization? If yes, what are the things (regarding "Dictionary
Cache")
> > that I should look in order to improve the performance?
> >
> > TIA.
> >
> > Guang
> >
> > ps, here are some "dc_" stats from my reports and a copy of actual
report
> > (partial):
> >
> > --
> > bash-2.03$ grep "dc_used_extents" sp_*
> > sp_681_682.lst:dc_used_extents 136   83.10
> > 136  3,840  100
> > sp_682_683.lst:dc_used_extents 124   81.50
> > 124  3,918   99
> > sp_683_684.lst:dc_used_extents  34   58.80
> > 34  3,924  100
> > sp_684_685.lst:dc_used_extents   0   0
> > 0  3,924  100
> > sp_685_686.lst:dc_used_extents  37   64.90
> > 37  3,935   99
> > sp_686_687.lst:dc_used_extents  12  100.00
> > 12  3,947  100
> > sp_687_688.lst:dc_used_extents  18  100.00
> > 18  3,965  100
> > sp_688_689.lst:dc_used_extents  26  100.00
> > 26  3,991  100
> > sp_689_690.lst:dc_used_extents  14  100.00
> > 14  4,005  100
> > sp_690_691.lst:dc_used_extents  16  100.00
> > 16  4,021  100
> > sp_691_692.lst:dc_used_extents

Re: Oracle Data Guard

[Carel-Jan Engel]

Hi Vijay,

I've done around 20 DG installations at different sites, using Linux, 
Solaris, AIX and W2K.

High speed network isn't always what you need, low latency might be more 
important. I've set up a DG environment between Kuala Lumpur and Rotterdam, 
using a 128KB line. This wasn't for standby reasins, but was about database 
consolidation. As long as the daily Archive Log could be done, everything 
was OK.

For maximum availability/protection mode you get synchronous writes. 
Latency counts very much. See also DocId 233650.1 on Metalink, Titled 9i 
Data Guard Complete Reference. It actually contains a list of interesting 
Data Guard publications on metalink.

Force logging mode is required for Logical Standby. I agree with Tanel, LSB 
isn't for production yet. However, in some situations it might be usefull 
for a reporting database, as long as you do not rely on the standby part. 
Create a PSB for that purpose.

On one site, with a long distance PSB (> 100 km between datacenters), with 
requirements about Zero Data Loss, I advised to setup a PSB/maximum 
availabilty mode locally, and a remote PSB in max. performance mode. This 
minimizes the chance of data loss, and affects performance as little as 
possible.

Regards, Carel-Jan

-- There will allwasy be another 10 last bugs --

At 07:19 8-12-03 -0800, you wrote:
> Hi All,
>
> can any one let me know kindly the following info.
>
> 1) Has any one used the Oracle 9i Data Guard?
Yes, physical standby and successfully.

> 2) If yes then,  is there any performance impact on
> Target/Source server database.
Your database has to be in archivelog mode, but when you are thinking such
solutions as DG, then you probably are already running archivelog anyway.
If you run in maximum protection or maximum availability, yes there is. The
impact depends mainly on network connection between primary and standby(s)
and the speed of redolog disks. You could tune these by using faster
network, enabling jumbo frames and SDU size if using Gbit ethernet, also
setting lgwr and log apply processes priority higher than others.
> 3) any drawbacks using Data Guard.

You should set your database or critical tablespaces to force logging mode
in order to transfer all changes to standby in physical standby. That means,
performance improvements which take advantage of nologging operations (such
insert append nologging etc), will not run that fast anymore.
In logical standby, I think there's no such requirement, but I don't
recommend you to use logical stby yet, it's more like a prototype currently,
not exactly a working product.
Tanel.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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.net
--
Author: Carel-Jan Engel
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: rebuilding indexes - sure to cause a ruckus

[Richard Foote]

Hi Yong,

Saying there are a "few" errors is being a little kind to Don's "Inside
Oracle Indexing" article.

In part, these are some of the issues I raised directly with Don in a number
of emails (warning somewhat on the longish side ;):
  a.. There are no such things as star indexes. Star joins, yes, star
transformations yes, but not star indexes ?
  b.. I still disagree with your description of b-tree indexes being complex
and difficult to understand, but then again this could just be my personal
perception (check out
http://groups.google.com/groups?q=g:thl3498916429d&dq=&hl=en&lr=&ie=UTF-8&se
lm=ant%259.39604%24jM5.100537%40newsfeeds.bigpond.com&rnum=47 where I have a
sample demo on how to investigate the workings of b-tree indexes.)  However,
by understanding them and a how they function, the question of whether or
not they need rebuilding no longer needs to be debated. It becomes easily
apparent under what conditions indexes could benefit from a rebuild. I'll
expand on this later but I would suggest those that "debate", those that
really don't know when a rebuild is justified and just rebuild in the hope
it might do some good are those that really don't understand "how" indexes
function. Knowledge is the key that unlocks the door of doubt and those
without the key fumble aimlessly and prod around in hope...
  c.. Your subsequent quote "There is enough anecdotal evidence that index
rebuilding has helped some systems perform better, and I also have no doubt
that there is no scientific basis for the claim" is a nonsense. Of course
one explain in scientific terms such performance improvements, I can only
suggest that you unfortunately can't. Oracle is not some magic piece of
software and it doesn't run on some magical pieces of hardware. Any
suggestions to the contrary are not helpful to anyone.
  d.. I still disagree with the double the block size, halving the logical
reads must be a good thing argument. It's a path that could lead to a very
disappointing conclusion (read cliff edge). Indexes prefer large block sizes
true but if the underlining storage file-system is not tuned to read (or
write) these larger block sizes efficiently, then the whole thing is counter
productive. You've been warned ...
  e.. Your description of PCTUSED is still wrong. There is no PCTUSED for
indexes so it really shouldn't be misleading to confuse a non-existing index
attribute with the amount of used space as documented in INDEX_STATS...
  f.. Including in your criteria for rebuilding an index "btree_space being
greater than a block"  is redundant when listed with the other criteria. It
is fundamentally impossible for an index with 4 levels or more to consist of
a single block, so why mention it. It just adds confusion and is silly. The
DBA who swears by this criteria (which I noticed has changed in this draft
;), how do they make such a claim? It's one thing to swear, it's quite
another to prove. Your table that lists average rows and blocks per
different index levels shows that those indexes with a leaf row length of
500,000,000 and with 100,000 blocks require 4 levels. How does rebuilding
such indexes with no subsequent change in index level improve performance ?
I mean, large indexes need more levels right, so rebuilding them all the
time and keeping the levels unchanged only to rebuild them again because
they're still 4 or more levels seems like a pointless, never-ending exercise
in futility. To rebuild an index that "actually" results in a reduction in
it's level generally requires a "drastic" reduction in it's data volume due
to the orders of sizing magnitude that a new level represents. More on this
and the other so-called rebuild criteria later but the current level of an
index is not a criteria for a rebuild. A level 3 index could conceivably be
rebuilt to just a level 1 (if there were heaps and heaps of deletions) and a
level 5 index could be rebuilt to stay at level 5. Which index has
benefited .
  g.. Criteria for a rebuild: or the total length of deleted is > 1 block
makes no sense whatsoever. Nearly all indexes would have a total length of
deleted > than 1 block meaning nearly all indexes need rebuilding. I don't
think so ...
  h.. Your discussion on the clustering factor affecting the likelihood of
requiring an index rebuild is still flawed, however interestingly, you've
now given an example on why this is the case. However, you've still come to
the wrong conclusion !! Firstly, you're incorrect in your example to say
that a 1,000,000 row table with a clustering factor of 1,000,000 has it's
rows in the same order as it's index although I guess this could be a typo.
Regardless, if you delete all last_name beginning with a K, you are going to
delete consecutive leaf nodes regardless of the clustering factor. So what
difference does it make to the "index". None. To the table, yes, you either
delete rows from all differing blocks or rows from a small number of blocks
but to the index, it makes no difference, hence

RE: Database management techniques and frameworks

[Bellow, Bambi]

Ah, Steve, thanks for clarifying.  It all becomes clear.

Here...

42!

HTH,
Bambi.

-Original Message-
Sent: Monday, December 08, 2003 3:45 PM
To: Multiple recipients of list ORACLE-L


No Bambi,

No, no, no... This is not what damagement wants. They don't want you to
develop your own tools and scripts so they are dependent on you. They
want to spent lots of money on a GUI tool they can see and they want a
sales drone to show them how easy it is and tell them that anybody can
be a DBA if they just had this GUI tool. That way, if they don't like
you they can get rid of you and just pluggin another warm body. Sort of
like handing a hammer to an unskilled laborer and saying, "Here, you are
now a master carpenter." By all means stop using that geek stuff like
Perl. Stop being subversive to the system by developing your own stuff
and use the GUI wizbang tool that damagement likes. 



-Original Message-
Bellow, Bambi
Sent: Friday, December 05, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Adam --

I've done this more times than I can count.  The answer is "it depends
on your environment, your desired results, and, more often than not,
your corporate structure".  Here's some examples:

1)  Monitoring script pages DBA group if X happens, Unix group if Y
happens, Network group if Z happens.  Simultaneously, XTerm windows are
popped up in both Operations and HelpDesk with the name and pager number
of the person paged (via uucp)

2)  Monitoring script sends messages to centralized Error Management
System. Error Management System handles it

3)  Monitoring script finds problem and corrects problem.  If problem
continues, email is generated

4)  Error Management System has external handles (not APIs) which can be
used to call Monitoring Scripts, which need to be modified to ustilize
System's internal structures (sometimes written in French -- *that* was
fun!)

5)  Monitoring script simply sends emails

6)  Monitoring script keeps track of the errors in log files which are
compared to log files from X time ago and only the differences are
reported

7)  Monitoring script has redundancy built in such that the first X
times a particular problem is encountered, the Monitoring System ignores
it, then generates a page

8)  Monitoring script has redundnacy built in such that after the first
time the problem is encountered, a page is sent, and if there is still a
problem 15 minutes later, someone else is paged and so on up the company
ladder

It goes on and on.  This is largely what I've been doing for the past 8
years.  Note that the words "Monitoring script" as used above is
generally an inherently complicated conglomeration of several different
scripts, generally with a governor and/or one or more driver(s),
infrequently on different operating systems, sometimes in multiple
languages and/or utilizing, or integrating with, or extending the
capabilities of, one or more COTS products, which use different
mechanisms to trigger and synchronize them.  Generally, there is some
kind of "IGNORE" functionality which allows for specified downtime for
maintenance, or "ALTERNATE" functionality for unusual yet definable
situations, and hierarchy of tests (if the database is down, that
implies that a subsequent error that a user cannot connect to it has
already been dealt with) and, occasionally has sniffers on other boxes
to determine whether remote scripts need to be run either dependent upon
remote conditions or independent of them.  Sometimes, there is a process
which kicks off other jobs and manages the security.  I particularly
enjoy those where there is fault tolerance built in such that if
Monitoring script X on Machine Y craps out, Machine Z takes over and
runs the scripts until Y is back, then copies the logs back, kicks off
Y, make sure it runs ok, then shuts itself down.  (note to the Oracle-L
historians who might be curious, this change in my utilization is
largely why my posts from 10 years ago were a lot more DBMS/internals
heavy and my posts nowadays are more OS/script heavy.)

Regardless, I hope this answers your question and shows some of the
complexity of what you're asking for...

Bambi.

-Original Message-
Sent: Friday, December 05, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L


So your approach is to write a series of custom scripts, add them to (I 
assume) oracle's crontab for periodic execution.  Do you have one single

machine (or pair of machines) that monitor remote databases?  Or do you 
install these scripts on each database server?  Do you leverage
dbms_jobs? 
 And relying on email seems kind of iffy -- what happens if you're not 
around to check your email?  Page system?  Escalation matrix in place?

Not trying to ruffle any feathers here, and certainly, I appreciate the 
time requirements in fully answering a question as broad as the one I 
submitted, but I would like to probe further into various strategies.
The 
whole "run scripts to check, install statspack, et

Re: Database management techniques and frameworks

[Mladen Gogala]

Here, of course, you're assuming that such a magical GUI, sort of DBA in an 
ancient oil lamp, tools exist. Well, they do not. Even if you have some useful 
gooey tools, they do require extensive configuration and customization to become 
useful and they do require extensive knowledge from the person doing configuration
and customization. Other then that, I find it quite questionable how useful it is
to fire your own customers and replace them with cheap Elbonian labor. Anyone who
has called Oracle support recently knows exactly what I'm talking about.
On 12/08/2003 04:44:31 PM, "Orr, Steve" wrote:
> No Bambi,
> 
> No, no, no... This is not what damagement wants. They don't want you to
> develop your own tools and scripts so they are dependent on you. They
> want to spent lots of money on a GUI tool they can see and they want a
> sales drone to show them how easy it is and tell them that anybody can
> be a DBA if they just had this GUI tool. That way, if they don't like
> you they can get rid of you and just pluggin another warm body. Sort of
> like handing a hammer to an unskilled laborer and saying, "Here, you are
> now a master carpenter." By all means stop using that geek stuff like
> Perl. Stop being subversive to the system by developing your own stuff
> and use the GUI wizbang tool that damagement likes. 
> 
> 
> 
> -Original Message-
> Bellow, Bambi
> Sent: Friday, December 05, 2003 1:35 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Adam --
> 
> I've done this more times than I can count.  The answer is "it depends
> on your environment, your desired results, and, more often than not,
> your corporate structure".  Here's some examples:
> 
> 1)  Monitoring script pages DBA group if X happens, Unix group if Y
> happens, Network group if Z happens.  Simultaneously, XTerm windows are
> popped up in both Operations and HelpDesk with the name and pager number
> of the person paged (via uucp)
> 
> 2)  Monitoring script sends messages to centralized Error Management
> System. Error Management System handles it
> 
> 3)  Monitoring script finds problem and corrects problem.  If problem
> continues, email is generated
> 
> 4)  Error Management System has external handles (not APIs) which can be
> used to call Monitoring Scripts, which need to be modified to ustilize
> System's internal structures (sometimes written in French -- *that* was
> fun!)
> 
> 5)  Monitoring script simply sends emails
> 
> 6)  Monitoring script keeps track of the errors in log files which are
> compared to log files from X time ago and only the differences are
> reported
> 
> 7)  Monitoring script has redundancy built in such that the first X
> times a particular problem is encountered, the Monitoring System ignores
> it, then generates a page
> 
> 8)  Monitoring script has redundnacy built in such that after the first
> time the problem is encountered, a page is sent, and if there is still a
> problem 15 minutes later, someone else is paged and so on up the company
> ladder
> 
> It goes on and on.  This is largely what I've been doing for the past 8
> years.  Note that the words "Monitoring script" as used above is
> generally an inherently complicated conglomeration of several different
> scripts, generally with a governor and/or one or more driver(s),
> infrequently on different operating systems, sometimes in multiple
> languages and/or utilizing, or integrating with, or extending the
> capabilities of, one or more COTS products, which use different
> mechanisms to trigger and synchronize them.  Generally, there is some
> kind of "IGNORE" functionality which allows for specified downtime for
> maintenance, or "ALTERNATE" functionality for unusual yet definable
> situations, and hierarchy of tests (if the database is down, that
> implies that a subsequent error that a user cannot connect to it has
> already been dealt with) and, occasionally has sniffers on other boxes
> to determine whether remote scripts need to be run either dependent upon
> remote conditions or independent of them.  Sometimes, there is a process
> which kicks off other jobs and manages the security.  I particularly
> enjoy those where there is fault tolerance built in such that if
> Monitoring script X on Machine Y craps out, Machine Z takes over and
> runs the scripts until Y is back, then copies the logs back, kicks off
> Y, make sure it runs ok, then shuts itself down.  (note to the Oracle-L
> historians who might be curious, this change in my utilization is
> largely why my posts from 10 years ago were a lot more DBMS/internals
> heavy and my posts nowadays are more OS/script heavy.)
> 
> Regardless, I hope this answers your question and shows some of the
> complexity of what you're asking for...
> 
> Bambi.
> 
> -Original Message-
> Sent: Friday, December 05, 2003 1:44 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> So your approach is to write a series of custom scripts, add them to (I 
> assume) oracle's crontab for periodic

Who is querying database info using dblink

[Nguyen, David M]

How do I check who is querying database information via database link?

Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nguyen, David M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: rebuilding indexes - sure to cause a ruckus

[Tanel Poder]

Ouch, I gotta take a day off to read this one ;)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 11:29 PM


> Hi Yong,
>
> Saying there are a "few" errors is being a little kind to Don's "Inside
> Oracle Indexing" article.
>
> In part, these are some of the issues I raised directly with Don in a
number
> of emails (warning somewhat on the longish side ;):
>   a.. There are no such things as star indexes. Star joins, yes, star
> transformations yes, but not star indexes ?
>   b.. I still disagree with your description of b-tree indexes being
complex
> and difficult to understand, but then again this could just be my personal
> perception (check out
>
http://groups.google.com/groups?q=g:thl3498916429d&dq=&hl=en&lr=&ie=UTF-8&se
> lm=ant%259.39604%24jM5.100537%40newsfeeds.bigpond.com&rnum=47 where I have
a
> sample demo on how to investigate the workings of b-tree indexes.)
However,
> by understanding them and a how they function, the question of whether or
> not they need rebuilding no longer needs to be debated. It becomes easily
> apparent under what conditions indexes could benefit from a rebuild. I'll
> expand on this later but I would suggest those that "debate", those that
> really don't know when a rebuild is justified and just rebuild in the hope
> it might do some good are those that really don't understand "how" indexes
> function. Knowledge is the key that unlocks the door of doubt and those
> without the key fumble aimlessly and prod around in hope...
>   c.. Your subsequent quote "There is enough anecdotal evidence that index
> rebuilding has helped some systems perform better, and I also have no
doubt
> that there is no scientific basis for the claim" is a nonsense. Of course
> one explain in scientific terms such performance improvements, I can only
> suggest that you unfortunately can't. Oracle is not some magic piece of
> software and it doesn't run on some magical pieces of hardware. Any
> suggestions to the contrary are not helpful to anyone.
>   d.. I still disagree with the double the block size, halving the logical
> reads must be a good thing argument. It's a path that could lead to a very
> disappointing conclusion (read cliff edge). Indexes prefer large block
sizes
> true but if the underlining storage file-system is not tuned to read (or
> write) these larger block sizes efficiently, then the whole thing is
counter
> productive. You've been warned ...
>   e.. Your description of PCTUSED is still wrong. There is no PCTUSED for
> indexes so it really shouldn't be misleading to confuse a non-existing
index
> attribute with the amount of used space as documented in INDEX_STATS...
>   f.. Including in your criteria for rebuilding an index "btree_space
being
> greater than a block"  is redundant when listed with the other criteria.
It
> is fundamentally impossible for an index with 4 levels or more to consist
of
> a single block, so why mention it. It just adds confusion and is silly.
The
> DBA who swears by this criteria (which I noticed has changed in this draft
> ;), how do they make such a claim? It's one thing to swear, it's quite
> another to prove. Your table that lists average rows and blocks per
> different index levels shows that those indexes with a leaf row length of
> 500,000,000 and with 100,000 blocks require 4 levels. How does rebuilding
> such indexes with no subsequent change in index level improve performance
?
> I mean, large indexes need more levels right, so rebuilding them all the
> time and keeping the levels unchanged only to rebuild them again because
> they're still 4 or more levels seems like a pointless, never-ending
exercise
> in futility. To rebuild an index that "actually" results in a reduction in
> it's level generally requires a "drastic" reduction in it's data volume
due
> to the orders of sizing magnitude that a new level represents. More on
this
> and the other so-called rebuild criteria later but the current level of an
> index is not a criteria for a rebuild. A level 3 index could conceivably
be
> rebuilt to just a level 1 (if there were heaps and heaps of deletions) and
a
> level 5 index could be rebuilt to stay at level 5. Which index has
> benefited .
>   g.. Criteria for a rebuild: or the total length of deleted is > 1 block
> makes no sense whatsoever. Nearly all indexes would have a total length of
> deleted > than 1 block meaning nearly all indexes need rebuilding. I don't
> think so ...
>   h.. Your discussion on the clustering factor affecting the likelihood of
> requiring an index rebuild is still flawed, however interestingly, you've
> now given an example on why this is the case. However, you've still come
to
> the wrong conclusion !! Firstly, you're incorrect in your example to say
> that a 1,000,000 row table with a clustering factor of 1,000,000 has it's
> rows in the same order as it's index although I guess this could be a
typo.
> Regardless, if you

RE: Oracle Data Guard

[Josh Collier]

Hi,

Tanel, 

"enabling jumbo frames and SDU size if using
Gbit ethernet,"

can you elaborate on this?




-Original Message-
Sent: Monday, December 08, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L


Hi  Tanel,


Much appreciated, The fact is I am interested in
Logical standby rather than physical.

  Our 30-50% of our Production data needs to be
replicated to another database and where they will
have their processing and batches.

 Now We didn't go to Snapshot because It is on
multiple  tables (where we didnot have PK's and many
tables) and due to performance issue I didn't want to
use Snapshots (they did not want  any tables to be
truncate before being loaded even via snapshots).

 The best option I think is Logical Standby Database.
Or Can  you please suggest me any other means.

   Replication should be quicker like once in
every 20 minutes, Even Transportable tablespacs does
not work here since they need all tables to 24*7.

Any suggestion would be more helpful.

with thanks,
Vi.

 

--- Tanel Poder <[EMAIL PROTECTED]> wrote: > >
Hi All,
> >
> > can any one let me know kindly the following info.
> >
> > 1) Has any one used the Oracle 9i Data Guard?
> 
> Yes, physical standby and successfully.
> 
> > 2) If yes then,  is there any performance impact
> on
> > Target/Source server database.
> 
> Your database has to be in archivelog mode, but when
> you are thinking such
> solutions as DG, then you probably are already
> running archivelog anyway.
> 
> If you run in maximum protection or maximum
> availability, yes there is. The
> impact depends mainly on network connection between
> primary and standby(s)
> and the speed of redolog disks. You could tune these
> by using faster
> network, enabling jumbo frames and SDU size if using
> Gbit ethernet, also
> setting lgwr and log apply processes priority higher
> than others.
> 
> > 3) any drawbacks using Data Guard.
> 
> You should set your database or critical tablespaces
> to force logging mode
> in order to transfer all changes to standby in
> physical standby. That means,
> performance improvements which take advantage of
> nologging operations (such
> insert append nologging etc), will not run that fast
> anymore.
> In logical standby, I think there's no such
> requirement, but I don't
> recommend you to use logical stby yet, it's more
> like a prototype currently,
> not exactly a working product.
> 
> Tanel.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing 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). 


BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer
ends 21st December 2003. The way the internet was meant to be.
http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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.net
-- 
Author: Josh Collier
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Jared . Still]

a) not really, in fact, far less than usual.  going to be *loonnngg* day.  Just needed a diversion.

b) I'm not telling








"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/08/2003 01:04 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: dc_used_extents ,dc_free_extents and dc_histogram_defs


somebody has free time on his hands.  Jared, what's your bosses email addy?
 
Tom Mercadante 
Oracle Certified Professional 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs


Though there has been an average increase in the total number of init parameter of 83% from 
versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38% 
in 7.3.4, to 31%/69% in 9.2.0.4. 

version      undoc  tunable  total  %undoc  %tunable 
- 
7.3.4           97      158    255      38        62     
8.1.7.4        300      204    504      60        40 
9.2.0.4        587      258    845      69        31 

To achieve the stated goal of 100 tunable parameters in 10g, with an expected 
growth rate of 30% ( a guesstimate ) or so in the total number  of parameters, 10g 
should look somthing like this: 

version      undoc  tunable  total  %undoc  %tunable 
- 
10.0.0         999      100   1099      91         9 


;) 

Jared 







Mladen Gogala <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 12/08/2003 11:59 AM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        Re: dc_used_extents ,dc_free_extents and dc_histogram_defs



Larry Ellison has publicly stated that his goal is to produce a database with 
less then 100 tunable parameters. Allegedly, he came rather close with 10g.
As far as 10g is concerned, I'm rather disappointed with the marketing hype 
being created with oracle not making an early version available. I don't plan
on migrating to 10g until I learn it well and if some oracle sales guy
tries to exert pressure on me to migrate, he will get a very stable sign
used by English archers after the battle at Agincourt to signify that they 
still have all the fingers needed to operate a longbow. I've had my fill of
white papers and articles and now I want to see the software.

RE: Database management techniques and frameworks

[Orr, Steve]

No Bambi,

No, no, no... This is not what damagement wants. They don't want you to
develop your own tools and scripts so they are dependent on you. They
want to spent lots of money on a GUI tool they can see and they want a
sales drone to show them how easy it is and tell them that anybody can
be a DBA if they just had this GUI tool. That way, if they don't like
you they can get rid of you and just pluggin another warm body. Sort of
like handing a hammer to an unskilled laborer and saying, "Here, you are
now a master carpenter." By all means stop using that geek stuff like
Perl. Stop being subversive to the system by developing your own stuff
and use the GUI wizbang tool that damagement likes. 



-Original Message-
Bellow, Bambi
Sent: Friday, December 05, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L


Adam --

I've done this more times than I can count.  The answer is "it depends
on your environment, your desired results, and, more often than not,
your corporate structure".  Here's some examples:

1)  Monitoring script pages DBA group if X happens, Unix group if Y
happens, Network group if Z happens.  Simultaneously, XTerm windows are
popped up in both Operations and HelpDesk with the name and pager number
of the person paged (via uucp)

2)  Monitoring script sends messages to centralized Error Management
System. Error Management System handles it

3)  Monitoring script finds problem and corrects problem.  If problem
continues, email is generated

4)  Error Management System has external handles (not APIs) which can be
used to call Monitoring Scripts, which need to be modified to ustilize
System's internal structures (sometimes written in French -- *that* was
fun!)

5)  Monitoring script simply sends emails

6)  Monitoring script keeps track of the errors in log files which are
compared to log files from X time ago and only the differences are
reported

7)  Monitoring script has redundancy built in such that the first X
times a particular problem is encountered, the Monitoring System ignores
it, then generates a page

8)  Monitoring script has redundnacy built in such that after the first
time the problem is encountered, a page is sent, and if there is still a
problem 15 minutes later, someone else is paged and so on up the company
ladder

It goes on and on.  This is largely what I've been doing for the past 8
years.  Note that the words "Monitoring script" as used above is
generally an inherently complicated conglomeration of several different
scripts, generally with a governor and/or one or more driver(s),
infrequently on different operating systems, sometimes in multiple
languages and/or utilizing, or integrating with, or extending the
capabilities of, one or more COTS products, which use different
mechanisms to trigger and synchronize them.  Generally, there is some
kind of "IGNORE" functionality which allows for specified downtime for
maintenance, or "ALTERNATE" functionality for unusual yet definable
situations, and hierarchy of tests (if the database is down, that
implies that a subsequent error that a user cannot connect to it has
already been dealt with) and, occasionally has sniffers on other boxes
to determine whether remote scripts need to be run either dependent upon
remote conditions or independent of them.  Sometimes, there is a process
which kicks off other jobs and manages the security.  I particularly
enjoy those where there is fault tolerance built in such that if
Monitoring script X on Machine Y craps out, Machine Z takes over and
runs the scripts until Y is back, then copies the logs back, kicks off
Y, make sure it runs ok, then shuts itself down.  (note to the Oracle-L
historians who might be curious, this change in my utilization is
largely why my posts from 10 years ago were a lot more DBMS/internals
heavy and my posts nowadays are more OS/script heavy.)

Regardless, I hope this answers your question and shows some of the
complexity of what you're asking for...

Bambi.

-Original Message-
Sent: Friday, December 05, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L


So your approach is to write a series of custom scripts, add them to (I 
assume) oracle's crontab for periodic execution.  Do you have one single

machine (or pair of machines) that monitor remote databases?  Or do you 
install these scripts on each database server?  Do you leverage
dbms_jobs? 
 And relying on email seems kind of iffy -- what happens if you're not 
around to check your email?  Page system?  Escalation matrix in place?

Not trying to ruffle any feathers here, and certainly, I appreciate the 
time requirements in fully answering a question as broad as the one I 
submitted, but I would like to probe further into various strategies.
The 
whole "run scripts to check, install statspack, etc." approach seems
both 
highly unscalable and leaves much to the whim of the individual DBA.  So

what, you've installed statspack?  Do you use it regularly?  Is this a 
manual review, or is som

Re: Oracle Data Guard

[Nalla Ravi]

Hi  Tanel,


Much appreciated, The fact is I am interested in
Logical standby rather than physical.

  Our 30-50% of our Production data needs to be
replicated to another database and where they will
have their processing and batches.

 Now We didn't go to Snapshot because It is on
multiple  tables (where we didnot have PK's and many
tables) and due to performance issue I didn't want to
use Snapshots (they did not want  any tables to be
truncate before being loaded even via snapshots).

 The best option I think is Logical Standby Database.
Or Can  you please suggest me any other means.

   Replication should be quicker like once in
every 20 minutes, Even Transportable tablespacs does
not work here since they need all tables to 24*7.

Any suggestion would be more helpful.

with thanks,
Vi.

 

--- Tanel Poder <[EMAIL PROTECTED]> wrote: > >
Hi All,
> >
> > can any one let me know kindly the following info.
> >
> > 1) Has any one used the Oracle 9i Data Guard?
> 
> Yes, physical standby and successfully.
> 
> > 2) If yes then,  is there any performance impact
> on
> > Target/Source server database.
> 
> Your database has to be in archivelog mode, but when
> you are thinking such
> solutions as DG, then you probably are already
> running archivelog anyway.
> 
> If you run in maximum protection or maximum
> availability, yes there is. The
> impact depends mainly on network connection between
> primary and standby(s)
> and the speed of redolog disks. You could tune these
> by using faster
> network, enabling jumbo frames and SDU size if using
> Gbit ethernet, also
> setting lgwr and log apply processes priority higher
> than others.
> 
> > 3) any drawbacks using Data Guard.
> 
> You should set your database or critical tablespaces
> to force logging mode
> in order to transfer all changes to standby in
> physical standby. That means,
> performance improvements which take advantage of
> nologging operations (such
> insert append nologging etc), will not run that fast
> anymore.
> In logical standby, I think there's no such
> requirement, but I don't
> recommend you to use logical stby yet, it's more
> like a prototype currently,
> not exactly a working product.
> 
> Tanel.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Tanel Poder
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing 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). 


BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st 
December 2003. The way the internet was meant to be. 
http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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).

A brief detour....;-)

[Bobak, Mark]

So, I saw on SlashDot (http://www.slashdot.org/) a story about a guy who has over 100 
different implementations of the Towers of Hanoi solution, each in a different 
language.  Since he didn't have one in PL/SQL, I decided to write one.  

Here it is:
create or replace package hanoi
is
from_peg  constant number := 1;
to_pegconstant number := 3;
using_peg constant number := 2;

procedure play(n number);

end hanoi;
/
create or replace package body hanoi
is

procedure do_hanoi(n number, from_peg number, to_peg number, using_peg number)
is
begin
if(n > 0) then
do_hanoi(n-1,from_peg, using_peg, to_peg);
dbms_output.put_line('move '||from_peg||' --> '||to_peg);
do_hanoi(n-1, using_peg, to_peg, from_peg);
end if;
end;
procedure play(n number)
is
begin
do_hanoi(n, from_peg, to_peg, using_peg);
end;
end;
/

This concludes this public service announcement.  We now return you to our regularly 
scheduled programming.

-Mark

PS  Yes, it's a slow day;-)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Tanel Poder]

10g has about 30 "basic" parameters such are 
db_name and sga_target, a real bunch of "advanced" parameters and the rest 
are undocumented parameters.
 
So, the marketing people can already say you got 
less than 100 tunable params..
 
Tanel.
 

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, December 08, 2003 10:59 
  PM
  Subject: Re: dc_used_extents 
  ,dc_free_extents and dc_histogram_defs
  Though there has been an 
  average increase in the total number of init parameter of 83% from 
  versions 7.3.4 - 9.2.0.4, the 
  percentage of tunable/undocumented parameters has gone from 62%/38% 
  in 7.3.4, to 31%/69% in 9.2.0.4. 
  version      undoc 
   tunable  total  %undoc  %tunable - 
  7.3.4           97 
       158    255      38     
     62     8.1.7.4 
         300      204    504   
     60        40 9.2.0.4        587      258   
   845      69        31 
  To achieve the stated goal of 100 tunable 
  parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number  of 
  parameters, 10g should look somthing 
  like this: version     
   undoc  tunable  total  %undoc  %tunable 
  - 
  10.0.0         999   
     100   1099      91       
    9 ;) 
  Jared 
  


  
  Mladen Gogala 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 12/08/2003 11:59 AM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        Re: dc_used_extents 
,dc_free_extents and 
  dc_histogram_defsLarry Ellison has publicly stated that his goal is 
  to produce a database with less then 100 tunable parameters. Allegedly, he 
  came rather close with 10g.As far as 10g is concerned, I'm rather 
  disappointed with the marketing hype being created with oracle not making 
  an early version available. I don't planon migrating to 10g until I learn 
  it well and if some oracle sales guytries to exert pressure on me to 
  migrate, he will get a very stable signused by English archers after the 
  battle at Agincourt to signify that they still have all the fingers needed 
  to operate a longbow. I've had my fill ofwhite papers and articles and now 
  I want to see the 
software.

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Orr, Steve]

Title: Message



So I 
believe your unstated point is that the only thing that needs to be reduced is 
Mr. E's marketing hype. ;-)
 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:59 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  dc_used_extents ,dc_free_extents and 
  dc_histogram_defsThough 
  there has been an average increase in the total number of init parameter of 
  83% from versions 7.3.4 - 9.2.0.4, the 
  percentage of tunable/undocumented parameters has gone from 62%/38% 
  in 7.3.4, to 31%/69% in 9.2.0.4. 
  version      undoc 
   tunable  total  %undoc  %tunable - 
  7.3.4           97 
       158    255      38     
     62     8.1.7.4 
         300      204    504   
     60        40 9.2.0.4        587      258   
   845      69        31 
  To achieve the stated goal of 100 tunable 
  parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number  of 
  parameters, 10g should look somthing 
  like this: version     
   undoc  tunable  total  %undoc  %tunable 
  - 
  10.0.0         999   
     100   1099      91       
    9 ;) 
  Jared 
  


  
  Mladen Gogala 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 12/08/2003 11:59 AM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        Re: dc_used_extents 
,dc_free_extents and 
  dc_histogram_defsLarry Ellison has publicly stated that his goal is 
  to produce a database with less then 100 tunable parameters. Allegedly, he 
  came rather close with 10g.As far as 10g is concerned, I'm rather 
  disappointed with the marketing hype being created with oracle not making 
  an early version available. I don't planon migrating to 10g until I learn 
  it well and if some oracle sales guytries to exert pressure on me to 
  migrate, he will get a very stable signused by English archers after the 
  battle at Agincourt to signify that they still have all the fingers needed 
  to operate a longbow. I've had my fill ofwhite papers and articles and now 
  I want to see the 
software.

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Mercadante, Thomas F]

somebody has free time on his hands.  Jared, what's your bosses 
email addy?
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 
  3:59 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: dc_used_extents ,dc_free_extents and 
  dc_histogram_defsThough 
  there has been an average increase in the total number of init parameter of 
  83% from versions 7.3.4 - 9.2.0.4, the 
  percentage of tunable/undocumented parameters has gone from 62%/38% 
  in 7.3.4, to 31%/69% in 9.2.0.4. 
  version      undoc 
   tunable  total  %undoc  %tunable - 
  7.3.4           97 
       158    255      38     
     62     8.1.7.4 
         300      204    504   
     60        40 9.2.0.4        587      258   
   845      69        31 
  To achieve the stated goal of 100 tunable 
  parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number  of 
  parameters, 10g should look somthing 
  like this: version     
   undoc  tunable  total  %undoc  %tunable 
  - 
  10.0.0         999   
     100   1099      91       
    9 ;) 
  Jared 
  


  
  Mladen Gogala 
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 
 12/08/2003 11:59 AM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>         cc:       
        
  Subject:        Re: dc_used_extents 
,dc_free_extents and 
  dc_histogram_defsLarry Ellison has publicly stated that his goal is 
  to produce a database with less then 100 tunable parameters. Allegedly, he 
  came rather close with 10g.As far as 10g is concerned, I'm rather 
  disappointed with the marketing hype being created with oracle not making 
  an early version available. I don't planon migrating to 10g until I learn 
  it well and if some oracle sales guytries to exert pressure on me to 
  migrate, he will get a very stable signused by English archers after the 
  battle at Agincourt to signify that they still have all the fingers needed 
  to operate a longbow. I've had my fill ofwhite papers and articles and now 
  I want to see the 
software.

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Jared . Still]

Though there has been an average increase in the total number of init parameter of 83% from 
versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38%
in 7.3.4, to 31%/69% in 9.2.0.4.

version      undoc  tunable  total  %undoc  %tunable
-
7.3.4           97      158    255      38        62    
8.1.7.4        300      204    504      60        40
9.2.0.4        587      258    845      69        31

To achieve the stated goal of 100 tunable parameters in 10g, with an expected
growth rate of 30% ( a guesstimate ) or so in the total number  of parameters, 10g
should look somthing like this:

version      undoc  tunable  total  %undoc  %tunable
-
10.0.0         999      100   1099      91         9


;)

Jared








Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/08/2003 11:59 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: dc_used_extents ,dc_free_extents and dc_histogram_defs


Larry Ellison has publicly stated that his goal is to produce a database with 
less then 100 tunable parameters. Allegedly, he came rather close with 10g.
As far as 10g is concerned, I'm rather disappointed with the marketing hype 
being created with oracle not making an early version available. I don't plan
on migrating to 10g until I learn it well and if some oracle sales guy
tries to exert pressure on me to migrate, he will get a very stable sign
used by English archers after the battle at Agincourt to signify that they 
still have all the fingers needed to operate a longbow. I've had my fill of
white papers and articles and now I want to see the software.

Oracle, GPG, PGP, Java...

[Daniel Hanks]

Hi folks,

I'm looking for some kind of library or such that would allow me to decrypt PGP/GnuPG 
encrypted content from SQL.

Something allowing me to do something like this:

SELECT decrypt([private key passed in from application code], field) from ...

The current solution we have (in Perl) is something like this:

- Select out the encrypted value
- Exec() the gpg command-line utility, supplying the private key
- Do something with the decrypoted data.

We use the GnuPG.pm module, which is really just a wrapper around an exec() (yuk).

I'd like to be able to eliminate all the exec madness, and use something a little 
closer to the database. I was glancing at Chapter 22 in Feuerstein's "Oracle PL/SQL 
Programming" (3rd. ed.), and thought it might not be too hard to find an existing Java 
library that can manage the decryption, and call the Java library from PL/SQL, as 
discussed in that chapter. 

Has anybody else done anything like this? Any Java libraries that can manage PGP 
decryption? I found one here:

http://www.cryptix.org/products/openpgp/index.html#download

but wanted to ask the list's opinion to see if there was anything else out there.

I would assume I could also call native C libraries from PL/SQL via some voodoo which 
I haven't explored yet, and if needed would be open to something like that as well, 
but though Java might be a gentler path to start with.

Thanks for any help,

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Hanks
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: PERL?

[Stephen.Lee]

#!/usr/bin/ksh

sqlplus -s <<-XXX
   joecool/jomama

   var xyz char(50)
   var abc char(50)

   begin
  :xyz := 'HELLO WORLD';
  select :xyz into :abc from dual;
   end;
   /

   print abc

XXX
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: PERL?

[Stephen.Lee]

Don't know why not.  Using the "here document" anything you can type in on
the sqlplus command line can be entered with ksh ... including the defining
of bind variables.

> -Original Message-
> Via shell you can't use bind variables
> which sometimes come in handy.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: PERL?

[Orr, Steve]

One BIG advantage of Perl is DBI. Via shell you can't use bind variables
which sometimes come in handy. An admin dweeb here developed a
monitoring shell script that executed 5500 queries an hour each using
literals instead of bind variables resulting in shared pool
fragmentation and server errors. When the same monitoring was rewritten
in Python the load on the server was dramatically reduced. (It could
have been done in Perl with the same result.) The usage of literals
could have been avoided with PL/SQL but there was also a need for
significant file reads, file writes and email so using shell and PL/SQL
was cumbersome at best. (Besides, the admin dweeb didn't know PL/SQL.)
Another plus is that your oft used routines can be portable between
Windoze and *nix.

I guess the point is this: Many times you need greater programming power
than afforded by shell scripting. If you can easily and productively
perform everything that you can do in shell scripting with a complete
programming language like Perl or Python then you're one step ahead of
the game. Otherwise you may be lamenting limitations. So the remaining
challenge is merely learning a programming language that works for you.


Steve Orr
Bozeman, Montana


-Original Message-
[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L



The difference that has affected me the most in writing utility scripts
is that PERL can talk to the database like using a telephone. Ksh must
talk like using a walkie-talkie; that is, each side of the conversation
must talk then release the push-to-talk (PTT) button before the other
side can talk. Using a small amount of cleverness (which is good,
because that's about how much I have) in ksh, you can program around
most of the communication limitations.  For example, to deal with
sqlplus getting "stuck" for one reason or the other, you can run the
subsection of the script in the background (as a ksh job).  Then you
check on the job later in the script. If the job is still there longer
than it should be, the script can kill the job.  THEN, for good measure,
look for sqlplus (and possible another ksh that got forked by the
script) with parent process ID (PPID) of me and kill them.  This is
similar to the other side failing to release the PTT button. Unlike
PERL, which can maybe yell into to telephone to wake the other side up,
ksh must launch an artillery shell onto the other guy which, in a rather
violent manner, will cause him to release the PTT button (well ...
actually .. the PTT switch kind of got blown up too).  Then, depending
on the situation, retry the sqlplus or conclude that something is wrong.

That being said, ksh is so easy to use and so handy, that I still use it
for automating database management and monitoring.  I'm sure a big part
of that is because I learned shell, sed, awk, etc. programming before
perl was standard equipment on Unix boxes.  I suppose if you are
starting from the beginning, then the way to go would be perl.  But you
can still do a heck of a lot with ksh (the REAL ksh; not the POS public
domain ksh that tends to show up with linux).

For an excellent book on getting started with this, go to Amazon and
search on Mark G. Sobell (or just Sobell).

Here's a tinyurl link to what I think is still must-have book.  Even
though a lot of it is outdated, the sections on getting around in Unix
and shell scripting are still entirely relevant. http://tinyurl.com/y8x6
(Note that the used book sellers are just about giving away the book)

There is also a BSD version of the above book.

And you want to get O'Reilly's book on Sed and Awk.

Those should get you going down the wonderful world of shell scripting
.. which is the ORIGINAL, and still great, Rapid Application
Development.

-Original Message-

I've read a lot about PERL on this list.  And, I am wondering what can
you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell
scripts?


Any information will be greatly appreciated.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Mladen Gogala]

Larry Ellison has publicly stated that his goal is to produce a database with 
less then 100 tunable parameters. Allegedly, he came rather close with 10g.
As far as 10g is concerned, I'm rather disappointed with the marketing hype 
being created with oracle not making an early version available. I don't plan
on migrating to 10g until I learn it well and if some oracle sales guy
tries to exert pressure on me to migrate, he will get a very stable sign
used by English archers after the battle at Agincourt to signify that they 
still have all the fingers needed to operate a longbow. I've had my fill of
white papers and articles and now I want to see the software.

On 12/08/2003 02:24:33 PM, [EMAIL PROTECTED] wrote:
> 
> .. And there used to be all these dc_   parameters that one could set,
> giving the dba control over the dictionary cache, which was not a part of
> the shared pool. And then came Oracle V7, with the shared_pool_size,
> wresting that control.
> 
> Regards
> 
> 
> 
> 
>  
>   
> Mladen Gogala
>   
> <[EMAIL PROTECTED]   To: Multiple recipients of list 
> ORACLE-L <[EMAIL PROTECTED]>   
> ading.com>   cc: 
>   
> Sent by: Subject: Re: dc_used_extents 
> ,dc_free_extents and dc_histogram_defs   
> [EMAIL PROTECTED]
>  
> ity.com  
>   
>  
>   
>  
>   
> 12/08/2003   
>   
> 01:29 PM 
>   
> Please respond   
>   
> to ORACLE-L  
>   
>  
>   
>  
>   
> 
> 
> 
> 
> Well, once upon a time, in a land far, far away, there was Oracle V6 with
> something called "TPO", which was essentially row locking + PL/SQL V1 (no
> stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve
> Feuerstein
> and Howard  Rogers know a thing or two about the Jurassic period in the
> database
> development. BTW, that was also when buffer hit ratio was invented. The
> entries that you see are remnants from oracle v6, together with the table
> called "V$ROWCACHE" and are both religiously maintained for the
> compatibility
> reasons, because Oracle Corp. doesn't want to disappoint all those who are
> still running V6. Even compatibility with V5 is still maintained. In Oracle
> 5.1.22,
> dictionary views weren't called "user_tables" and "user_objects", they were
> called
> "tab" (user_tables) and cat (from "CATALOG", replaced with "USER_OBJECTS").
> The term
> "CATALOG" was directory command on Apple IIe (6502, later Z80) with 100k
> floppies,
> computer immensly popular at the time, and I believe that is why the first
> implementation of "user_objects" was called "catalog". Now, let's fast
> forward to the
> present time and Oracle 9.2.0.4.  Do "Select * from tab" and "select * from
> cat".
> You'll be surprised. For all those still running V5.1.22 with forms 2.0 and
> 2.3,
> the world is not over yet.
> 
> On 12/08/2003 12:39:30 PM, Guang Mei wrote:
> > Hi:
> >
> > I am reading some statspack reports from our 8173 DB (on Sun Solaris) and
> > found some of "Dictionary Cache Stats" are pretty high (much higher than
> > 2%). I notice that "Pct Get Miss" for dc_used_extents ,dc_free_extents
> and
> > dc_histogram_defs are high (the second column data below).  Is this
> > something I need to pay attention in terms of doing performance
> > optimization? If yes, what are the things (regarding "Dictionary Cache")
> > that I should look in order to improve the performance?
> >
> > TIA.
> >
> > Guang
> >
> > ps, here are some "dc_" stats from my reports and a copy of actual report
> > (partial):
> >
> > --
> > bash-2.03$ grep "dc_used_extents" sp_*
> > sp_681_682.lst:dc_used_extents 136   83.1  

RE: RMAN restore on another server

[Josh Collier]

why not use the RMAN duplicate database process. that sounds like what you
are trying to do.  Have you ever let the script run to completion? Maybe its
slow for another reason. I have used duplicate database on Solaris many
times with great success.

Josh

-Original Message-
Sent: Monday, December 08, 2003 8:20 AM
To: Multiple recipients of list ORACLE-L



Dennis and all,

 I have no problem getting the controlfile... I just comment out the SET
commands to change the directories of the dbfs...and I replicate the control
according to the init file specifications.. So This operation actually
extract the controlfile out of the backup piece so I know the location and
connections are working fine.

But since the controlfile is backup and I am restoring it with the same RMan
command I think I should have no problem.. I know other DBAs.. run this same
script and restore the database on another server with no problem if the
controlfile is restored before the database is restored and recovered.

Here is the restore controlfile script and resulting log file

==
Controlfile restore Script
==
connect catalog rman81740/[EMAIL PROTECTED]

connect target /


run

{

allocate channel d1 type disk ;

sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
set until time = '2003-12-02 05:50:00';


#restore controlfile to '/u02/vssppln/restored_cf.ctl';

replicate controlfile from '/u02/vssppln/restored_cf.ctl';

release channel d1;
}

==
Successful Controlfile restore log
==
Recovery Manager: Release 8.1.7.4.0 - Production

RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2>
3> connect target /
4>
5>
6> run
7>
8> {
9>
10> allocate channel d1 type disk ;
11>
12> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
13> set until time = '2003-12-02 05:50:00';
14>
15>
16> restore controlfile to '/u02/vssppln/restored_cf.ctl';
17>
18> replicate controlfile from '/u02/vssppln/restored_cf.ctl';
19>
20> release channel d1;
21> }
22>
23>
RMAN-06008: connected to recovery catalog database

RMAN-06006: connected to target database: vssppln (not mounted)

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=12 devtype=DISK

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT="-MM-DD
HH24:MI:SS"
RMAN-03023: executing command: sql

RMAN-03022: compiling command: set

RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

Recovery Manager complete.


=
Here is the orignal entire script to restore controlfile and database
but it just hangs on the set commands..
=

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Rajesh . Rao]

.. And there used to be all these dc_   parameters that one could set,
giving the dba control over the dictionary cache, which was not a part of
the shared pool. And then came Oracle V7, with the shared_pool_size,
wresting that control.

Regards




   

Mladen Gogala  

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

Sent by: Subject: Re: dc_used_extents 
,dc_free_extents and dc_histogram_defs   
[EMAIL PROTECTED]  
   
ity.com

   

   

12/08/2003 

01:29 PM   

Please respond 

to ORACLE-L

   

   





Well, once upon a time, in a land far, far away, there was Oracle V6 with
something called "TPO", which was essentially row locking + PL/SQL V1 (no
stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve
Feuerstein
and Howard  Rogers know a thing or two about the Jurassic period in the
database
development. BTW, that was also when buffer hit ratio was invented. The
entries that you see are remnants from oracle v6, together with the table
called "V$ROWCACHE" and are both religiously maintained for the
compatibility
reasons, because Oracle Corp. doesn't want to disappoint all those who are
still running V6. Even compatibility with V5 is still maintained. In Oracle
5.1.22,
dictionary views weren't called "user_tables" and "user_objects", they were
called
"tab" (user_tables) and cat (from "CATALOG", replaced with "USER_OBJECTS").
The term
"CATALOG" was directory command on Apple IIe (6502, later Z80) with 100k
floppies,
computer immensly popular at the time, and I believe that is why the first
implementation of "user_objects" was called "catalog". Now, let's fast
forward to the
present time and Oracle 9.2.0.4.  Do "Select * from tab" and "select * from
cat".
You'll be surprised. For all those still running V5.1.22 with forms 2.0 and
2.3,
the world is not over yet.

On 12/08/2003 12:39:30 PM, Guang Mei wrote:
> Hi:
>
> I am reading some statspack reports from our 8173 DB (on Sun Solaris) and
> found some of "Dictionary Cache Stats" are pretty high (much higher than
> 2%). I notice that "Pct Get Miss" for dc_used_extents ,dc_free_extents
and
> dc_histogram_defs are high (the second column data below).  Is this
> something I need to pay attention in terms of doing performance
> optimization? If yes, what are the things (regarding "Dictionary Cache")
> that I should look in order to improve the performance?
>
> TIA.
>
> Guang
>
> ps, here are some "dc_" stats from my reports and a copy of actual report
> (partial):
>
> --
> bash-2.03$ grep "dc_used_extents" sp_*
> sp_681_682.lst:dc_used_extents 136   83.10
> 136  3,840  100
> sp_682_683.lst:dc_used_extents 124   81.50
> 124  3,918   99
> sp_683_684.lst:dc_used_extents  34   58.80
> 34  3,924  100
> sp_684_685.lst:dc_used_extents   0   0
> 0  3,924  100
> sp_685_686.lst:dc_used_extents  37   64.90
> 37  3,935   99
> sp_686_687.lst:dc_used_extents  12  100.00
> 12  3,947  100
> sp_687_688.lst:dc_used_extents  18  100.00
> 18  3,965  100
> sp_688_689.lst:dc_used_extents  26  100.00
> 26  3,991  100
> sp_689_690.lst:dc_used_extents  14  100.00
> 14  4,005  100
> sp_690_691.lst:dc_used_extents  16  100.00
> 16  4,021  100
> sp_691_692.lst:dc_used_extents  29  100.00
> 29  4,050  100
> sp_692_693.lst:dc_used_exte

RE: Exclusive Password file, multiple databases

[April Wells]

Title: Exclusive Password file, multiple databases



Our only sqlnet.ora file is the one in samples, and it is all comments... 
I don't think that's it... 
 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   
>\<  
\  
>\<  \ 
Few people really enjoy the simple 
pleasure of flying a kite Adam 
Wells age 11 

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]Sent: Monday, December 
  08, 2003 12:44 PMTo: '[EMAIL PROTECTED]'Cc: April 
  WellsSubject: RE: Exclusive Password file, multiple 
  databases
  April, 
  I just went thru this.  Look 
  in the sqlnet.ora file.  If :SQLNET.AUTHENTICATION_SERVICES= 
  (NTS)is set, comment it out.  It was the 
  cause of the problems on my 
  machine. 
   
  Good 
  Luck!
   
  Tom Mercadante Oracle Certified Professional 
  

  -Original Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:35 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Exclusive Password file, multiple databases
  Okay, I have been trying Google and Tahiti for 2 days, and 
  I can't for the life of me figure out how to clue in my database.  
  
  9.2.0.2 on AIX 5l 
  I am running multiple databases and am trying to get all 
  of the instances running with remote_login_passwordfile=exclusive.  
  Most of the databases are running fine, but one insists on looking for the 
  default file name, despite my having provided filename= 
  parameter to orapwd.  I can't find anything that is supposed to clue 
  it in in this circumstance, and recreating the password file doesn't 
  really so any good either.  Every time I try to start the database 
  using the pfile, it complains about wanting the orapwd file... 
  All of the other databases are happy enough with what I 
  did.  What am I doing wrong with this one... where do I start 
  looking?  
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   
  \/   >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  


  The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

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


The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

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

RE: Exclusive Password file, multiple databases

[Mercadante, Thomas F]

Title: Exclusive Password file, multiple databases



April, 
I just went thru this.  Look in 
the sqlnet.ora file.  If :SQLNET.AUTHENTICATION_SERVICES= 
(NTS)is 
set, comment it out.  It was the cause of the problems on my 
machine. 
 
Good 
Luck!
 
Tom Mercadante Oracle Certified Professional 

  
-Original Message-From: April Wells 
[mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:35 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Exclusive Password file, multiple databases
Okay, I have been trying Google and Tahiti for 2 days, and I 
can't for the life of me figure out how to clue in my database.  

9.2.0.2 on AIX 5l 
I am running multiple databases and am trying to get all of 
the instances running with remote_login_passwordfile=exclusive.  Most 
of the databases are running fine, but one insists on looking for the 
default file name, despite my having provided filename= 
parameter to orapwd.  I can't find anything that is supposed to clue it 
in in this circumstance, and recreating the password file doesn't really so 
any good either.  Every time I try to start the database using the 
pfile, it complains about wanting the orapwd file... 
All of the other databases are happy enough with what I 
did.  What am I doing wrong with this one... where do I start 
looking?  
April Wells Oracle DBA/Oracle Apps 
DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/ 
  >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite 
Adam Wells age 11 

  
  
The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

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

RE: Exclusive Password file, multiple databases

[Mercadante, Thomas F]

Title: Exclusive Password file, multiple databases



April,
 
I just 
went thru this.  Look in the sqlnet.ora file.  If 
:
 
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: April Wells 
  [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:35 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Exclusive Password file, multiple databases
  Okay, I have been trying Google and Tahiti for 2 days, and I 
  can't for the life of me figure out how to clue in my database.  
  
  9.2.0.2 on AIX 5l 
  I am running multiple databases and am trying to get all of 
  the instances running with remote_login_passwordfile=exclusive.  Most of 
  the databases are running fine, but one insists on looking for the default 
  file name, despite my having provided filename= parameter to 
  orapwd.  I can't find anything that is supposed to clue it in in this 
  circumstance, and recreating the password file doesn't really so any good 
  either.  Every time I try to start the database using the pfile, it 
  complains about wanting the orapwd file... 
  All of the other databases are happy enough with what I 
  did.  What am I doing wrong with this one... where do I start 
  looking?  
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas   /\  /   \ / 
  \ \ /   \/   >\<  \  >\<  \ Few people really enjoy the simple pleasure of flying a kite 
  Adam Wells age 11 
  


  The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

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

Re: PERL?

[Mladen Gogala]

Can you install Oracle 9.2 on a playstation 2?
On 12/08/2003 12:04:26 PM, "Bobak, Mark" wrote:
> It does.
> 
> -Original Message-
> Sent: Monday, December 08, 2003 11:39 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Then PERL should also run on a TIVO box - it uses Linux.
>  
> Ken Janusz, CPIM
> 
> - Original Message - 
> To: Multiple recipients of list ORACLE-L   
> Sent: Monday, December 08, 2003 10:24 AM
> 
> Well I might have disputed your "almost" dispute until I learned that Perl can run 
> on my Sony PlayStation2 via Linux. (see: 
> http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) 
>  
> OT: Anyone on the list ever run PlayStation on Linux? 
>  
> 
>  
> -Original Message-
> Cary Millsap
> Sent: Monday, December 08, 2003 9:00 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> The only thing I think I disagree with is the word "almost."
> 
>  
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Performance   Diagnosis 101: 12/16 
> Detroit, 1/27 Atlanta
> - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
> - Hotsos Symposium   2004: March 7-10 
> Dallas
> - Visit www.hotsos.com for schedule details...
> 
> -Original Message-
> Eric King
> Sent: Monday, December 08, 2003 6:39 AM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> Perl is a full flege programming language, it can do almost anything such as Java or 
> C++ can do. SQL*Plus or Shell is very limited in terms of functionalities.
> 
>  
> 
> Besides, Perl is portable language. Perl code runs on almost any platforms.
> 
> - Original Message - 
> 
> 
> To: Multiple   recipients of list ORACLE-L 
> 
> Sent: Sunday, December 07, 2003 22:34
> 
> 
>  
> 
> I've read a lot about PERL on this list.  And, I am wondering what can you do with 
> PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts?  
> 
>  
> 
> Any information will be greatly appreciated.
> 
>  
> 
> Thanks much,
> 
> Ken Janusz, CPIM
> 
> 

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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).

Exclusive Password file, multiple databases

[April Wells]

Title: Exclusive Password file, multiple databases





Okay, I have been trying Google and Tahiti for 2 days, and I can't for the life of me figure out how to clue in my database.  

9.2.0.2 on AIX 5l


I am running multiple databases and am trying to get all of the instances running with remote_login_passwordfile=exclusive.  Most of the databases are running fine, but one insists on looking for the default file name, despite my having provided filename= parameter to orapwd.  I can't find anything that is supposed to clue it in in this circumstance, and recreating the password file doesn't really so any good either.  Every time I try to start the database using the pfile, it complains about wanting the orapwd file... 

All of the other databases are happy enough with what I did.  What am I doing wrong with this one... where do I start looking?  

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
  /\
 /   \
/ \
\ /
  \/
  >\<
 \
 >\<
 \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

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

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

[Mladen Gogala]

Well, once upon a time, in a land far, far away, there was Oracle V6 with
something called "TPO", which was essentially row locking + PL/SQL V1 (no
stored procedures). My guess is that Cary Millsap, Anjo Kolk, Steve Feuerstein 
and Howard  Rogers know a thing or two about the Jurassic period in the database 
development. BTW, that was also when buffer hit ratio was invented. The
entries that you see are remnants from oracle v6, together with the table 
called "V$ROWCACHE" and are both religiously maintained for the compatibility
reasons, because Oracle Corp. doesn't want to disappoint all those who are
still running V6. Even compatibility with V5 is still maintained. In Oracle 5.1.22,
dictionary views weren't called "user_tables" and "user_objects", they were called
"tab" (user_tables) and cat (from "CATALOG", replaced with "USER_OBJECTS"). The term
"CATALOG" was directory command on Apple IIe (6502, later Z80) with 100k floppies,
computer immensly popular at the time, and I believe that is why the first 
implementation of "user_objects" was called "catalog". Now, let's fast forward to the 
present time and Oracle 9.2.0.4.  Do "Select * from tab" and "select * from cat". 
You'll be surprised. For all those still running V5.1.22 with forms 2.0 and 2.3,
the world is not over yet.

On 12/08/2003 12:39:30 PM, Guang Mei wrote:
> Hi:
> 
> I am reading some statspack reports from our 8173 DB (on Sun Solaris) and
> found some of "Dictionary Cache Stats" are pretty high (much higher than
> 2%). I notice that "Pct Get Miss" for dc_used_extents ,dc_free_extents and
> dc_histogram_defs are high (the second column data below).  Is this
> something I need to pay attention in terms of doing performance
> optimization? If yes, what are the things (regarding "Dictionary Cache")
> that I should look in order to improve the performance?
> 
> TIA.
> 
> Guang
> 
> ps, here are some "dc_" stats from my reports and a copy of actual report
> (partial):
> 
> --
> bash-2.03$ grep "dc_used_extents" sp_*
> sp_681_682.lst:dc_used_extents 136   83.10
> 136  3,840  100
> sp_682_683.lst:dc_used_extents 124   81.50
> 124  3,918   99
> sp_683_684.lst:dc_used_extents  34   58.80
> 34  3,924  100
> sp_684_685.lst:dc_used_extents   0   0
> 0  3,924  100
> sp_685_686.lst:dc_used_extents  37   64.90
> 37  3,935   99
> sp_686_687.lst:dc_used_extents  12  100.00
> 12  3,947  100
> sp_687_688.lst:dc_used_extents  18  100.00
> 18  3,965  100
> sp_688_689.lst:dc_used_extents  26  100.00
> 26  3,991  100
> sp_689_690.lst:dc_used_extents  14  100.00
> 14  4,005  100
> sp_690_691.lst:dc_used_extents  16  100.00
> 16  4,021  100
> sp_691_692.lst:dc_used_extents  29  100.00
> 29  4,050  100
> sp_692_693.lst:dc_used_extents   1  100.00
> 1  4,051   99
> sp_693_694.lst:dc_used_extents   1,118   51.20
> 1,118  4,077  100
> sp_694_695.lst:dc_used_extents   1,294   99.80
> 1,294  5,365  100
> sp_695_696.lst:dc_used_extents   2,031   13.20
> 2,031  3,870   72
> sp_696_697.lst:dc_used_extents   1,195   98.50
> 1,195  5,029   94
> sp_697_698.lst:dc_used_extents  44  100.00
> 44  5,073   94
> sp_698_699.lst:dc_used_extents   0   0
> 0  5,073   94
> sp_699_700.lst:dc_used_extents   1,3598.50
> 1,359568   33
> bash-2.03$ grep "dc_free_extents" sp_*
> sp_681_682.lst:dc_free_extents 395   34.4  166   0.0
> 362  4,071   82
> sp_682_683.lst:dc_free_extents 507   27.2  160   0.0
> 342  4,100   82
> sp_683_684.lst:dc_free_extents  75   32.0   20   0.0
> 64  4,104   82
> sp_684_685.lst:dc_free_extents  120.00
> 0  4,104   82
> sp_685_686.lst:dc_free_extents  95   35.8   24   0.0
> 83  4,114   83
> sp_686_687.lst:dc_free_extents  47   25.5   12   0.0
> 36  4,114   83
> sp_687_688.lst:dc_free_extents  64   23.4   18   0.0
> 52  4,111   82
> sp_688_689.lst:dc_free_extents  93   24.7   32   0.0
> 78  4,108   82
> sp_689_690.lst:dc_free_extents  54   25.9   14   0.0
> 42  4,108   82
> sp_690_691.lst:dc_free_extents  63   23.8   21   0.0
> 48  4,107   82
> sp_691_692.lst:dc_free_extents 109   25.7   42   0.0
> 85  4,106   82
> sp_692_693.lst:dc_free_extents  156.71   0.0
> 3  4,106   82
> sp_693_694.lst:dc_free_extents   1,624   24.0  596   0.0
> 1,574  3,924   79
> sp_694_695.lst:dc_free_extents   3,398   31.31,307   0.0
> 3,288  3,696   74
> 

Re: I/O error offlines a datafile

[Tanel Poder]

Stop complaining.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 7:59 PM


> Actually, I haven't read too much of his posts. Based
> on the one he sent to me, I didn't miss much.
> 
> Gene
> --- Joe Testa <[EMAIL PROTECTED]> wrote:
> > Gene, i thought you'd been around a while and know
> > how Mladen works, geez.
> > 
> > joe
> > 
> > 
> > Gene Gurevich wrote:
> > 
> > >Mladen,
> > >
> > >Thank you very much for your suggestion. I tried
> > >exactly that - offline the tablespace and restore
> > the
> > >datafile and - guess what? - it failed because of
> > the
> > >lock being held against the datafile. That is what
> > >lead me (and the Oracle support guy) to bounce the
> > >database. Now I may be less than "half way
> > competent
> > >member of damanagement" (whatever it means), but 
> > >based on your advice you may be not much better. In
> > >the future if you can't refrain from isults, please
> > do
> > >not reply  to my posts. I'm asking for help and
> > >advice, not an insult.
> > >
> > >Gene
> > >
> > >--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> > >  
> > >
> > >>It's review time, so everything you do is wrong,
> > as
> > >>a cost 
> > >>saving measure. Any half way competent member of
> > >>damagement 
> > >>can tell you that.In this particular case though,
> > >>you could have 
> > >>recovered the datafile online. You should have
> > >>offlined the 
> > >>tablespace, restored the datafile and recovered
> > the
> > >>datafile.
> > >>Restarting the database was not not necessary.
> > Also,
> > >>one of my
> > >>religious rituals is to perform a checkpoint after
> > >>the tablespace 
> > >>has been successfully brought online. The reason
> > is
> > >>to record the
> > >>new timestamp to the control file and make sure
> > that
> > >>all files
> > >>have the same timestamp (checkpoint process
> > updates
> > >>file headers
> > >>during checkpoint).
> > >>
> > >>On 12/08/2003 10:39:32 AM, Gene Gurevich wrote:
> > >>
> > >>
> > >>>Hi I got the following error in an alert.log
> > file.
> > >>>Aparently it was a result of some UNIX issues on
> > a
> > >>>hdisk, which have been resolved some time later
> > ..
> > >>>
> > >>>"Fri Dec  5 18:28:10 2003
> > >>>KCF: write/open error block=0x3571 online=1
> > >>> file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf
> > >>> error=27063 txt: 'IBM AIX RISC System/6000
> > >>>  
> > >>>
> > >>Error:
> > >>
> > >>
> > >>>5: I/O error
> > >>>Additional information: -1
> > >>>Additional information: 16384'
> > >>>Automatic datafile offline due to write error on
> > >>>file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf"
> > >>>
> > >>>The file in question had status = 'RECOVER" in
> > the
> > >>>v$datafile and status  = 'AVAIALBLE' in
> > >>>dba_Data_files. I attempted to restore the file
> > >>>  
> > >>>
> > >>after
> > >>
> > >>
> > >>>taking it offline, but couldn't due to a lock. I
> > >>>  
> > >>>
> > >>ended
> > >>
> > >>
> > >>>up bouncing the database an recovering this file.
> > >>>  
> > >>>
> > >>I'm
> > >>
> > >>
> > >>>wondering whether I should have tired to recover
> > >>>  
> > >>>
> > >>this
> > >>
> > >>
> > >>>file first without bouncing the database. If
> > >>>  
> > >>>
> > >>anyone
> > >>
> > >>
> > >>>has any experience with that issue, could you let
> > >>>  
> > >>>
> > >>me
> > >>
> > >>
> > >>>know whether what I did was wrong or not (and
> > >>>  
> > >>>
> > >>why). Is
> > >>
> > >>
> > >>>there a document that I can read on this?
> > >>>
> > >>>thanks
> > >>>
> > >>>Gene
> > >>>
> > >>>
> > >>>__
> > >>>Do you Yahoo!?
> > >>>Free Pop-Up Blocker - Get it now
> > >>>http://companion.yahoo.com/
> > >>>-- 
> > >>>Please see the official ORACLE-L FAQ:
> > >>>  
> > >>>
> > >>http://www.orafaq.net
> > >>
> > >>
> > >>>-- 
> > >>>Author: Gene Gurevich
> > >>>  INET: [EMAIL PROTECTED]
> > >>>
> > >>>Fat City Network Services-- 858-538-5051
> > >>>  
> > >>>
> > >>http://www.fatcity.com
> > >>
> > >>
> > >>>San Diego, California-- Mailing list and
> > >>>  
> > >>>
> > >>web hosting services
> > >>
> > >>
> >
> >-
> > >  
> > >
> > >>>To REMOVE yourself from this mailing 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
> > >>Oracle DBA
> > >>
> > >>
> > >>
> 

Re: I/O error offlines a datafile

[Gene Gurevich]

Actually, I haven't read too much of his posts. Based
on the one he sent to me, I didn't miss much.

Gene
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> Gene, i thought you'd been around a while and know
> how Mladen works, geez.
> 
> joe
> 
> 
> Gene Gurevich wrote:
> 
> >Mladen,
> >
> >Thank you very much for your suggestion. I tried
> >exactly that - offline the tablespace and restore
> the
> >datafile and - guess what? - it failed because of
> the
> >lock being held against the datafile. That is what
> >lead me (and the Oracle support guy) to bounce the
> >database. Now I may be less than "half way
> competent
> >member of damanagement" (whatever it means), but 
> >based on your advice you may be not much better. In
> >the future if you can't refrain from isults, please
> do
> >not reply  to my posts. I'm asking for help and
> >advice, not an insult.
> >
> >Gene
> >
> >--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> >  
> >
> >>It's review time, so everything you do is wrong,
> as
> >>a cost 
> >>saving measure. Any half way competent member of
> >>damagement 
> >>can tell you that.In this particular case though,
> >>you could have 
> >>recovered the datafile online. You should have
> >>offlined the 
> >>tablespace, restored the datafile and recovered
> the
> >>datafile.
> >>Restarting the database was not not necessary.
> Also,
> >>one of my
> >>religious rituals is to perform a checkpoint after
> >>the tablespace 
> >>has been successfully brought online. The reason
> is
> >>to record the
> >>new timestamp to the control file and make sure
> that
> >>all files
> >>have the same timestamp (checkpoint process
> updates
> >>file headers
> >>during checkpoint).
> >>
> >>On 12/08/2003 10:39:32 AM, Gene Gurevich wrote:
> >>
> >>
> >>>Hi I got the following error in an alert.log
> file.
> >>>Aparently it was a result of some UNIX issues on
> a
> >>>hdisk, which have been resolved some time later
> ..
> >>>
> >>>"Fri Dec  5 18:28:10 2003
> >>>KCF: write/open error block=0x3571 online=1
> >>> file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf
> >>> error=27063 txt: 'IBM AIX RISC System/6000
> >>>  
> >>>
> >>Error:
> >>
> >>
> >>>5: I/O error
> >>>Additional information: -1
> >>>Additional information: 16384'
> >>>Automatic datafile offline due to write error on
> >>>file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf"
> >>>
> >>>The file in question had status = 'RECOVER" in
> the
> >>>v$datafile and status  = 'AVAIALBLE' in
> >>>dba_Data_files. I attempted to restore the file
> >>>  
> >>>
> >>after
> >>
> >>
> >>>taking it offline, but couldn't due to a lock. I
> >>>  
> >>>
> >>ended
> >>
> >>
> >>>up bouncing the database an recovering this file.
> >>>  
> >>>
> >>I'm
> >>
> >>
> >>>wondering whether I should have tired to recover
> >>>  
> >>>
> >>this
> >>
> >>
> >>>file first without bouncing the database. If
> >>>  
> >>>
> >>anyone
> >>
> >>
> >>>has any experience with that issue, could you let
> >>>  
> >>>
> >>me
> >>
> >>
> >>>know whether what I did was wrong or not (and
> >>>  
> >>>
> >>why). Is
> >>
> >>
> >>>there a document that I can read on this?
> >>>
> >>>thanks
> >>>
> >>>Gene
> >>>
> >>>
> >>>__
> >>>Do you Yahoo!?
> >>>Free Pop-Up Blocker - Get it now
> >>>http://companion.yahoo.com/
> >>>-- 
> >>>Please see the official ORACLE-L FAQ:
> >>>  
> >>>
> >>http://www.orafaq.net
> >>
> >>
> >>>-- 
> >>>Author: Gene Gurevich
> >>>  INET: [EMAIL PROTECTED]
> >>>
> >>>Fat City Network Services-- 858-538-5051
> >>>  
> >>>
> >>http://www.fatcity.com
> >>
> >>
> >>>San Diego, California-- Mailing list and
> >>>  
> >>>
> >>web hosting services
> >>
> >>
>
>-
> >  
> >
> >>>To REMOVE yourself from this mailing 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
> >>Oracle DBA
> >>
> >>
> >>
> >>Note:
> >>This message is for the named person's use only. 
> It
> >>may contain confidential, proprietary or legally
> >>privileged information.  No confidentiality or
> >>privilege is waived or lost by any
> mistransmission. 
> >>If you receive this message in error, please
> >>immediately delete it and all copies of it from
> your
> >>system, destroy any hard copies of it and notify
> the
> >>sender.  You must not, directly or indirectly,
> use,
> >>disclose, distribute, print, or copy any part of
> >>this message if you are not the intended
> recipient.
> >>Wa

dc_used_extents ,dc_free_extents and dc_histogram_defs

[Guang Mei]

Hi:

I am reading some statspack reports from our 8173 DB (on Sun Solaris) and
found some of "Dictionary Cache Stats" are pretty high (much higher than
2%). I notice that "Pct Get Miss" for dc_used_extents ,dc_free_extents and
dc_histogram_defs are high (the second column data below).  Is this
something I need to pay attention in terms of doing performance
optimization? If yes, what are the things (regarding "Dictionary Cache")
that I should look in order to improve the performance?

TIA.

Guang

ps, here are some "dc_" stats from my reports and a copy of actual report
(partial):

--
bash-2.03$ grep "dc_used_extents" sp_*
sp_681_682.lst:dc_used_extents 136   83.10
136  3,840  100
sp_682_683.lst:dc_used_extents 124   81.50
124  3,918   99
sp_683_684.lst:dc_used_extents  34   58.80
34  3,924  100
sp_684_685.lst:dc_used_extents   0   0
0  3,924  100
sp_685_686.lst:dc_used_extents  37   64.90
37  3,935   99
sp_686_687.lst:dc_used_extents  12  100.00
12  3,947  100
sp_687_688.lst:dc_used_extents  18  100.00
18  3,965  100
sp_688_689.lst:dc_used_extents  26  100.00
26  3,991  100
sp_689_690.lst:dc_used_extents  14  100.00
14  4,005  100
sp_690_691.lst:dc_used_extents  16  100.00
16  4,021  100
sp_691_692.lst:dc_used_extents  29  100.00
29  4,050  100
sp_692_693.lst:dc_used_extents   1  100.00
1  4,051   99
sp_693_694.lst:dc_used_extents   1,118   51.20
1,118  4,077  100
sp_694_695.lst:dc_used_extents   1,294   99.80
1,294  5,365  100
sp_695_696.lst:dc_used_extents   2,031   13.20
2,031  3,870   72
sp_696_697.lst:dc_used_extents   1,195   98.50
1,195  5,029   94
sp_697_698.lst:dc_used_extents  44  100.00
44  5,073   94
sp_698_699.lst:dc_used_extents   0   0
0  5,073   94
sp_699_700.lst:dc_used_extents   1,3598.50
1,359568   33
bash-2.03$ grep "dc_free_extents" sp_*
sp_681_682.lst:dc_free_extents 395   34.4  166   0.0
362  4,071   82
sp_682_683.lst:dc_free_extents 507   27.2  160   0.0
342  4,100   82
sp_683_684.lst:dc_free_extents  75   32.0   20   0.0
64  4,104   82
sp_684_685.lst:dc_free_extents  120.00
0  4,104   82
sp_685_686.lst:dc_free_extents  95   35.8   24   0.0
83  4,114   83
sp_686_687.lst:dc_free_extents  47   25.5   12   0.0
36  4,114   83
sp_687_688.lst:dc_free_extents  64   23.4   18   0.0
52  4,111   82
sp_688_689.lst:dc_free_extents  93   24.7   32   0.0
78  4,108   82
sp_689_690.lst:dc_free_extents  54   25.9   14   0.0
42  4,108   82
sp_690_691.lst:dc_free_extents  63   23.8   21   0.0
48  4,107   82
sp_691_692.lst:dc_free_extents 109   25.7   42   0.0
85  4,106   82
sp_692_693.lst:dc_free_extents  156.71   0.0
3  4,106   82
sp_693_694.lst:dc_free_extents   1,624   24.0  596   0.0
1,574  3,924   79
sp_694_695.lst:dc_free_extents   3,398   31.31,307   0.0
3,288  3,696   74
sp_695_696.lst:dc_free_extents   2,043   86.3  268   0.0
2,031  5,191   99
sp_696_697.lst:dc_free_extents   1,2091.71,177   0.0
1,197  4,034   77
sp_697_698.lst:dc_free_extents  550.0   44   0.0
44  3,990   76
sp_698_699.lst:dc_free_extents  120.00
0  3,990   79
sp_699_700.lst:dc_free_extents   1,384   90.4  115   0.0
1,371  1,564   94
bash-2.03$ grep "dc_histogram_defs" sp_*
sp_681_682.lst:dc_histogram_defs49   79.60
25128   21
sp_682_683.lst:dc_histogram_defs47   29.80
0142   23
sp_683_684.lst:dc_histogram_defs   186   51.60
119238   39
sp_684_685.lst:dc_histogram_defs 1,756   91.30
1,699  1,841  100
sp_685_686.lst:dc_histogram_defs 2,1911.10
59  1,865  100
sp_686_687.lst:dc_histogram_defs   1440.00
0  1,865  100
sp_687_688.lst:dc_histogram_defs 8,3220.00
18  1,865  100
sp_688_689.lst:dc_histogram_defs 50.00
0  1,865  100
sp_689_690.lst:dc_histogram_defs130.00
0  1,865  100
sp_690_691.lst:dc_histogram_defs360.00
0  1,865  100
sp_691_692.lst:dc_histogram_defs   2121.40
70  1,868  100
sp_692_693.lst:dc_histogram_defs   5590.00
76  1,868  100
sp_693_694.lst:dc_histogram_defs   127,682  

Re: I/O error offlines a datafile

[Jared . Still]

There weren't any insults in Mladens post.

Me thinks you're taking things a bit too seriously.

Jared








Gene Gurevich <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/08/2003 09:14 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: I/O error offlines a datafile


Mladen,

Thank you very much for your suggestion. I tried
exactly that - offline the tablespace and restore the
datafile and - guess what? - it failed because of the
lock being held against the datafile. That is what
lead me (and the Oracle support guy) to bounce the
database. Now I may be less than "half way competent
member of damanagement" (whatever it means), but 
based on your advice you may be not much better. In
the future if you can't refrain from isults, please do
not reply  to my posts. I'm asking for help and
advice, not an insult.

Gene

--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> It's review time, so everything you do is wrong, as
> a cost 
> saving measure. Any half way competent member of
> damagement 
> can tell you that.In this particular case though,
> you could have 
> recovered the datafile online. You should have
> offlined the 
> tablespace, restored the datafile and recovered the
> datafile.
> Restarting the database was not not necessary. Also,
> one of my
> religious rituals is to perform a checkpoint after
> the tablespace 
> has been successfully brought online. The reason is
> to record the
> new timestamp to the control file and make sure that
> all files
> have the same timestamp (checkpoint process updates
> file headers
> during checkpoint).
> 
> On 12/08/2003 10:39:32 AM, Gene Gurevich wrote:
> > Hi I got the following error in an alert.log file.
> > Aparently it was a result of some UNIX issues on a
> > hdisk, which have been resolved some time later ..
> > 
> > "Fri Dec  5 18:28:10 2003
> > KCF: write/open error block=0x3571 >
> >      file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf
> >      error=27063 txt: 'IBM AIX RISC System/6000
> Error:
> > 5: I/O error
> > Additional information: -1
> > Additional information: 16384'
> > Automatic datafile offline due to write error on
> > file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf"
> > 
> > The file in question had status = 'RECOVER" in the
> > v$datafile and status  = 'AVAIALBLE' in
> > dba_Data_files. I attempted to restore the file
> after
> > taking it offline, but couldn't due to a lock. I
> ended
> > up bouncing the database an recovering this file.
> I'm
> > wondering whether I should have tired to recover
> this
> > file first without bouncing the database. If
> anyone
> > has any experience with that issue, could you let
> me
> > know whether what I did was wrong or not (and
> why). Is
> > there a document that I can read on this?
> > 
> > thanks
> > 
> > Gene
> > 
> > 
> > __
> > Do you Yahoo!?
> > Free Pop-Up Blocker - Get it now
> > http://companion.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > -- 
> > Author: Gene Gurevich
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services    -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California        -- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing 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
> Oracle DBA
> 
> 
> 
> Note:
> This message is for the named person's use only.  It
> may contain confidential, proprietary or legally
> privileged information.  No confidentiality or
> privilege is waived or lost by any mistransmission. 
> If you receive this message in error, please
> immediately delete it and all copies of it from your
> system, destroy any hard copies of it and notify the
> sender.  You must not, directly or indirectly, use,
> disclose, distribute, print, or copy any part of
> this message if you are not the intended recipient.
> Wang Trading LLC and any of its subsidiaries each
> reserve the right to monitor all e-mail
> communications through its networks.
> Any views expressed in this message are those of the
> individual sender, except where the message states
> otherwise and the sender is authorized to state them
> to be the views of any such entity.
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051
> http://www.fatcity.com
> San Diego, California        -- Mailing list and web
> hosting services
>
---

RE: Alert Log

[Jesse, Rich]

Regardless of whether or not it works, download it and the other tools like
ntregmon, prcvire, and the almighty FileMonitor.  No installs, no DLLs, no
uninstall crap.  Just extract and run the .exe.  Excellent debugging tools.

Rich

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


-Original Message-
Sent: Monday, December 08, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


If nothing else helps, download procexp or filemon from www.sysinternals.com
and see which files are open by oracle.exe

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 5:04 PM


> Hi List
>
> My database is taking vert long time to startup. so I just wanted to check
alert log file. But I don't see Alert log in either background_dump_dest or
user_dump_dest.
> Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all
directory).
>
>
> SQL> show parameter dump
>
> NAME TYPEVALUE
>  --- -
-
> background_core_dump string  partial
> background_dump_dest string  C:\oracle\RDBMS\trace
> core_dump_dest   string  %ORACLE_HOME%\RDBMS\TRACE
> max_dump_file_size   string  10240
> shadow_core_dump string  partial
> user_dump_dest   string  C:\oracle\RDBMS\trace
> SQL>
>
> Coudl someone shed light on this?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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 error offlines a datafile

[Joe Testa]

Gene, i thought you'd been around a while and know how Mladen works, geez.

joe

Gene Gurevich wrote:

Mladen,

Thank you very much for your suggestion. I tried
exactly that - offline the tablespace and restore the
datafile and - guess what? - it failed because of the
lock being held against the datafile. That is what
lead me (and the Oracle support guy) to bounce the
database. Now I may be less than "half way competent
member of damanagement" (whatever it means), but 
based on your advice you may be not much better. In
the future if you can't refrain from isults, please do
not reply  to my posts. I'm asking for help and
advice, not an insult.

Gene

--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
 

It's review time, so everything you do is wrong, as
a cost 
saving measure. Any half way competent member of
damagement 
can tell you that.In this particular case though,
you could have 
recovered the datafile online. You should have
offlined the 
tablespace, restored the datafile and recovered the
datafile.
Restarting the database was not not necessary. Also,
one of my
religious rituals is to perform a checkpoint after
the tablespace 
has been successfully brought online. The reason is
to record the
new timestamp to the control file and make sure that
all files
have the same timestamp (checkpoint process updates
file headers
during checkpoint).

On 12/08/2003 10:39:32 AM, Gene Gurevich wrote:
   

Hi I got the following error in an alert.log file.
Aparently it was a result of some UNIX issues on a
hdisk, which have been resolved some time later ..
"Fri Dec  5 18:28:10 2003
KCF: write/open error block=0x3571 online=1
file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf
error=27063 txt: 'IBM AIX RISC System/6000
 

Error:
   

5: I/O error
Additional information: -1
Additional information: 16384'
Automatic datafile offline due to write error on
file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf"
The file in question had status = 'RECOVER" in the
v$datafile and status  = 'AVAIALBLE' in
dba_Data_files. I attempted to restore the file
 

after
   

taking it offline, but couldn't due to a lock. I
 

ended
   

up bouncing the database an recovering this file.
 

I'm
   

wondering whether I should have tired to recover
 

this
   

file first without bouncing the database. If
 

anyone
   

has any experience with that issue, could you let
 

me
   

know whether what I did was wrong or not (and
 

why). Is
   

there a document that I can read on this?

thanks

Gene

__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
Please see the official ORACLE-L FAQ:
 

http://www.orafaq.net
   

--
Author: Gene Gurevich
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
 

http://www.fatcity.com
   

San Diego, California-- Mailing list and
 

web hosting services
   

-
 

To REMOVE yourself from this mailing 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
Oracle DBA


Note:
This message is for the named person's use only.  It
may contain confidential, proprietary or legally
privileged information.  No confidentiality or
privilege is waived or lost by any mistransmission. 
If you receive this message in error, please
immediately delete it and all copies of it from your
system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of
this message if you are not the intended recipient.
Wang Trading LLC and any of its subsidiaries each
reserve the right to monitor all e-mail
communications through its networks.
Any views expressed in this message are those of the
individual sender, except where the message states
otherwise and the sender is authorized to state them
to be the views of any such entity.

--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and web
hosting services
   

-
 

To REMOVE yourself from this mailing 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!?
Free Pop-Up Blocker - Get it now
http://c

Re: PERL?

[Mladen Gogala]

 echo "Python is portable"|perl -e '$X=<>;chomp($X); print "$X but it is much harder 
to write obfuscated code in Python\n";'

On 12/08/2003 11:59:35 AM, "Orr, Steve" wrote:
> echo "s='Perl is portable';print s.replace('Perl','Python')+'
> too!'"|python
> 
> 
> -Original Message-
> KENNETH JANUSZ
> Sent: Monday, December 08, 2003 9:39 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Then PERL should also run on a TIVO box - it uses Linux.
> 
> Ken Janusz, CPIM
> - Original Message - 
> To: Multiple recipients of list ORACLE-L 
> Sent: Monday, December 08, 2003 10:24 AM
> 
> 
> Well I might have disputed your "almost" dispute until I learned that
> Perl can run on my Sony PlayStation2 via Linux. (see:
> http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) 
> 
> OT: Anyone on the list ever run PlayStation on Linux? 
> 
> 
> -Original Message-
> Cary Millsap
> Sent: Monday, December 08, 2003 9:00 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> The only thing I think I disagree with is the word "almost."
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
> - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
> - Hotsos Symposium 2004: March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> -Original Message-
> Eric King
> Sent: Monday, December 08, 2003 6:39 AM
> To: Multiple recipients of list ORACLE-L
> 
> Perl is a full flege programming language, it can do almost anything
> such as Java or C++ can do. SQL*Plus or Shell is very limited in terms
> of functionalities.
> 
> Besides, Perl is portable language. Perl code runs on almost any
> platforms.
> - Original Message - 
> To: Multiple recipients of list ORACLE-L 
> Sent: Sunday, December 07, 2003 22:34
> 
> I've read a lot about PERL on this list.  And, I am wondering what can
> you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell
> scripts?  
> 
> Any information will be greatly appreciated.
> 
> Thanks much,
> Ken Janusz, CPIM
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing 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
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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 error offlines a datafile

[Gene Gurevich]

Mladen,

Thank you very much for your suggestion. I tried
exactly that - offline the tablespace and restore the
datafile and - guess what? - it failed because of the
lock being held against the datafile. That is what
lead me (and the Oracle support guy) to bounce the
database. Now I may be less than "half way competent
member of damanagement" (whatever it means), but 
based on your advice you may be not much better. In
the future if you can't refrain from isults, please do
not reply  to my posts. I'm asking for help and
advice, not an insult.

Gene

--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> It's review time, so everything you do is wrong, as
> a cost 
> saving measure. Any half way competent member of
> damagement 
> can tell you that.In this particular case though,
> you could have 
> recovered the datafile online. You should have
> offlined the 
> tablespace, restored the datafile and recovered the
> datafile.
> Restarting the database was not not necessary. Also,
> one of my
> religious rituals is to perform a checkpoint after
> the tablespace 
> has been successfully brought online. The reason is
> to record the
> new timestamp to the control file and make sure that
> all files
> have the same timestamp (checkpoint process updates
> file headers
> during checkpoint).
> 
> On 12/08/2003 10:39:32 AM, Gene Gurevich wrote:
> > Hi I got the following error in an alert.log file.
> > Aparently it was a result of some UNIX issues on a
> > hdisk, which have been resolved some time later ..
> > 
> > "Fri Dec  5 18:28:10 2003
> > KCF: write/open error block=0x3571 online=1
> >  file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf
> >  error=27063 txt: 'IBM AIX RISC System/6000
> Error:
> > 5: I/O error
> > Additional information: -1
> > Additional information: 16384'
> > Automatic datafile offline due to write error on
> > file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf"
> > 
> > The file in question had status = 'RECOVER" in the
> > v$datafile and status  = 'AVAIALBLE' in
> > dba_Data_files. I attempted to restore the file
> after
> > taking it offline, but couldn't due to a lock. I
> ended
> > up bouncing the database an recovering this file.
> I'm
> > wondering whether I should have tired to recover
> this
> > file first without bouncing the database. If
> anyone
> > has any experience with that issue, could you let
> me
> > know whether what I did was wrong or not (and
> why). Is
> > there a document that I can read on this?
> > 
> > thanks
> > 
> > Gene
> > 
> > 
> > __
> > Do you Yahoo!?
> > Free Pop-Up Blocker - Get it now
> > http://companion.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > -- 
> > Author: Gene Gurevich
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing 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
> Oracle DBA
> 
> 
> 
> Note:
> This message is for the named person's use only.  It
> may contain confidential, proprietary or legally
> privileged information.  No confidentiality or
> privilege is waived or lost by any mistransmission. 
> If you receive this message in error, please
> immediately delete it and all copies of it from your
> system, destroy any hard copies of it and notify the
> sender.  You must not, directly or indirectly, use,
> disclose, distribute, print, or copy any part of
> this message if you are not the intended recipient.
> Wang Trading LLC and any of its subsidiaries each
> reserve the right to monitor all e-mail
> communications through its networks.
> Any views expressed in this message are those of the
> individual sender, except where the message states
> otherwise and the sender is authorized to state them
> to be the views of any such entity.
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing 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: PERL?

[Bobak, Mark]

Title: Message



It 
does.

  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 11:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  PERL?
  Then PERL should also run 
  on a TIVO box - it uses Linux.
   
  Ken Janusz, 
  CPIM
  
- Original Message - 
From: 
Orr, Steve 

To: Multiple recipients of list ORACLE-L 

Sent: Monday, December 08, 2003 10:24 
AM
Subject: RE: PERL?

Well I might have disputed your "almost" dispute until I learned 
that Perl can run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) 

 
OT: Anyone on the list ever run PlayStation on Linux? 

 

 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of Cary 
MillsapSent: Monday, December 08, 2003 9:00 AMTo: 
Multiple recipients of list ORACLE-LSubject: RE: 
PERL?

  
  The only thing I 
  think I disagree with is the word "almost."
   
  
  Cary 
  MillsapHotsos 
  Enterprises, Ltd.http://www.hotsos.comUpcoming 
  events:- Performance 
  Diagnosis 101: 12/16 Detroit, 1/27 Atlanta- SQL 
  Optimization 101: 12/8 Dallas, 2/16 Dallas- Hotsos Symposium 
  2004: March 7-10 Dallas- Visit www.hotsos.com for schedule 
  details...
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric KingSent: Monday, December 08, 2003 6:39 
  AMTo: Multiple 
  recipients of list ORACLE-LSubject: Re: PERL?
   
  
  Perl is a full 
  flege programming language, it can do almost anything such as Java or C++ 
  can do. SQL*Plus or Shell is very limited in terms of 
  functionalities.
  
   
  
  Besides, Perl is 
  portable language. Perl code runs on almost any 
  platforms.
  

- Original 
Message - 

From: KENNETH JANUSZ 


To: Multiple 
recipients of list ORACLE-L 

Sent: 
Sunday, December 07, 2003 22:34

Subject: 
PERL?

 

I've read 
a lot about PERL on this list.  And, I am wondering what can you do 
with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell 
scripts?  

 

Any 
information will be greatly appreciated.

 

Thanks 
much,

Ken 
Janusz, 
  CPIM

RE: PERL?

[Orr, Steve]

echo "s='Perl is portable';print s.replace('Perl','Python')+'
too!'"|python


-Original Message-
KENNETH JANUSZ
Sent: Monday, December 08, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L


Then PERL should also run on a TIVO box - it uses Linux.

Ken Janusz, CPIM
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Monday, December 08, 2003 10:24 AM


Well I might have disputed your "almost" dispute until I learned that
Perl can run on my Sony PlayStation2 via Linux. (see:
http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) 

OT: Anyone on the list ever run PlayStation on Linux? 


-Original Message-
Cary Millsap
Sent: Monday, December 08, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L


The only thing I think I disagree with is the word "almost."

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Eric King
Sent: Monday, December 08, 2003 6:39 AM
To: Multiple recipients of list ORACLE-L

Perl is a full flege programming language, it can do almost anything
such as Java or C++ can do. SQL*Plus or Shell is very limited in terms
of functionalities.

Besides, Perl is portable language. Perl code runs on almost any
platforms.
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Sunday, December 07, 2003 22:34

I've read a lot about PERL on this list.  And, I am wondering what can
you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell
scripts?  

Any information will be greatly appreciated.

Thanks much,
Ken Janusz, CPIM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: PERL?

[Mladen Gogala]

I was. Unfortunately, I'm struggling with something called OpenLDAP,
which was determined to be of even higher priority then Python.

On 12/08/2003 11:14:33 AM, "Orr, Steve" wrote:
> Hey Mladen,
> 
> Weren't you going to be taking a look at Python too? (Around
> Thanksgiving as I recall.) I'd be interested in your feedback on it as
> well. 
> 
> My take is that Python is powerful yet easy to learn, it's much more
> productive than Java and is still quite scalable. Like Perl it's a great
> multi-platform scripting/glue language and shares many of its advantages
> but unlike Perl, it's been object oriented from the start. There is some
> looseness to its OO but the Python community touts that as an advantage.
> ;-)
> 
> We have a Python story here where we host our software for the majority
> of our customers. While we perform most of the administration for our
> customers we also allow them to admin some stuff via a web app developed
> in Python. This app was developed under an accelerated schedule with a 3
> man team headed by a brilliant computer science PhD dweeb who really
> doesn't have to work for a living but chose to work with us just for the
> fun of it. One of the things our customers can do is perform upgrades of
> their app and this entails things like creating complete database
> schemas, Oracle backups and creating/dropping tablespaces among other
> things. (Kind of scary from a DBA control freak perspective.) Shortly
> after this web app went production, one of the developers was tragically
> killed, another developer who was an intern went back to school, and the
> PhD dude went on to be a university professor so the app was kind of
> dumped on my department consisting of a dozen admin type dweebs. We had
> to learn Python to maintain this mission critical app in short order.
> Not only were we able to quickly come up to speed to support the app, we
> have since greatly enhanced it to where it's become central to much of
> our SysAdmin/DBA duties. One reason for this successful transitions was
> the virtue of Python. Several in the department (myself included) were
> Perl literate beforehand and there is now unanimous consensus that we
> could not have had as good transition if the app had been written in
> Perl and we are glad Python was forced on us because the readability of
> Python code makes it MUCH more maintainable. Besides being DBA I've now
> done enough in Python that I am part DUHveloper. With socket programming
> and XML I've been able to transact between databases. (Which is
> definitely more sophisticated I/O than PL/SQL is capable of.) I've also
> used Python to develop a web server and I'm even thinking about
> replacing some Apache usage with my own web server code.
> 
> Well that's our story and there's more to Python than I can cover here
> so as soon as hunting season is over I'm going to resume preparation for
> my upcoming IOUW presentation titled, "Python, Oracle and the Meaning of
> Life." Hope to see some of you there.
> 
> 
> Steve Orr
> Bozeman, Montana
> 
> 
> 
> -Original Message-
> Mladen Gogala
> Sent: Sunday, December 07, 2003 10:04 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Perl is a general purpose interpreted programming language, written
> specifically with reporting purpose in mind.  In fact, perl stands for
> "Practical  Extraction/Reporting Language".  That means that perl is
> excellent for producing all kinds of reports. In fact, it has a part
> called "formats" which is, in fact, a small report writer and can be
> used to produce beautiful reports very quickly and with minimal effort.
> The next very useful feature is an extremely versatile regular
> expression engine which can do whatever awk & sed can do and more.
> That, of course, is ideal for parsing all kinds of regular expressions,
> like, for instance, parsing alert.log.  Perl , as I've said before, is
> a general purpose programming language with pointers (all right, all
> right, the name is "references", but those are really pointers) , which
> makes for an exceptionally powerful combination.  Last, but not least,
> there is a huge treasure chest 
> called "CPAN" (http://cpan.perl.org) which contains vast number of
> modules. In case of emergency, it's really easy to find something
> useful. One other thing worth mentioning is that perl has bindings and 
> modules which make it possible to work with  many databases, Tk, Gtk,
> HTML and almost anything conceivable (OLE, ODBC, ADO and other MS
> perversions included). There are two problems with perl. One is that
> perl is a huge language with so many intrinsic and important elements
> that it is really hard to learn the whole language. A title of  a perl
> master should be an equivalent 
> of a PhD. Another problem is a serious inadequacy of perl syntax for OO.
> Perl doesn't have classes, abstract classes, private/protected/public
> interface, templates, exception throw/catch mechanisms or some other
> things 
> that we 

Re: PERL?

[KENNETH JANUSZ]

Title: Message



Then PERL should also run 
on a TIVO box - it uses Linux.
 
Ken Janusz, 
CPIM

  - Original Message - 
  From: 
  Orr, Steve 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, December 08, 2003 10:24 
  AM
  Subject: RE: PERL?
  
  Well 
  I might have disputed your "almost" dispute until I learned that Perl can 
  run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) 
  
   
  OT: 
  Anyone on the list ever run PlayStation on Linux? 
   
  
   
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of Cary 
  MillsapSent: Monday, December 08, 2003 9:00 AMTo: 
  Multiple recipients of list ORACLE-LSubject: RE: 
  PERL?
  

The only thing I 
think I disagree with is the word “almost.”
 

Cary 
MillsapHotsos 
Enterprises, Ltd.http://www.hotsos.comUpcoming 
events:- Performance 
Diagnosis 101: 12/16 Detroit, 1/27 Atlanta- SQL 
Optimization 101: 12/8 Dallas, 2/16 Dallas- Hotsos Symposium 
2004: March 7–10 Dallas- Visit www.hotsos.com for schedule 
details...
-Original 
Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric KingSent: Monday, December 08, 2003 6:39 
AMTo: Multiple recipients 
of list ORACLE-LSubject: 
Re: PERL?
 

Perl is a full flege programming 
language, it can do almost anything such as Java or C++ can do. SQL*Plus or 
Shell is very limited in terms of functionalities.

 

Besides, Perl is portable 
language. Perl code runs on almost any platforms.

  
  - Original 
  Message - 
  
  From: KENNETH JANUSZ 
  
  
  To: Multiple 
  recipients of list ORACLE-L 
  
  Sent: 
  Sunday, December 07, 2003 22:34
  
  Subject: 
  PERL?
  
   
  
  I've read 
  a lot about PERL on this list.  And, I am wondering what can you do 
  with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell 
  scripts?  
  
   
  
  Any 
  information will be greatly appreciated.
  
   
  
  Thanks 
  much,
  
  Ken 
  Janusz, 
CPIM

RE: PERL?

[Orr, Steve]

Title: Message



Well I 
might have disputed your "almost" dispute until I learned that Perl can run 
on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) 

 
OT: 
Anyone on the list ever run PlayStation on Linux? 
 

 
-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cary 
MillsapSent: Monday, December 08, 2003 9:00 AMTo: Multiple 
recipients of list ORACLE-LSubject: RE: PERL?

  
  The only thing I 
  think I disagree with is the word “almost.”
   
  
  Cary 
  MillsapHotsos 
  Enterprises, Ltd.http://www.hotsos.comUpcoming 
  events:- Performance 
  Diagnosis 101: 12/16 Detroit, 1/27 Atlanta- SQL 
  Optimization 101: 12/8 Dallas, 2/16 Dallas- Hotsos Symposium 2004: 
  March 7–10 Dallas- Visit www.hotsos.com for schedule 
  details...
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric KingSent: Monday, December 08, 2003 6:39 
  AMTo: Multiple recipients of 
  list ORACLE-LSubject: Re: 
  PERL?
   
  
  Perl is a full flege programming 
  language, it can do almost anything such as Java or C++ can do. SQL*Plus or 
  Shell is very limited in terms of functionalities.
  
   
  
  Besides, Perl is portable 
  language. Perl code runs on almost any platforms.
  

- Original Message - 


From: KENNETH JANUSZ 


To: Multiple 
recipients of list ORACLE-L 

Sent: Sunday, 
December 07, 2003 22:34

Subject: 
PERL?

 

I've read 
a lot about PERL on this list.  And, I am wondering what can you do 
with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell 
scripts?  

 

Any 
information will be greatly appreciated.

 

Thanks 
much,

Ken 
Janusz, 
CPIM

Re: I/O error offlines a datafile

[Mladen Gogala]

It's review time, so everything you do is wrong, as a cost 
saving measure. Any half way competent member of damagement 
can tell you that.In this particular case though, you could have 
recovered the datafile online. You should have offlined the 
tablespace, restored the datafile and recovered the datafile.
Restarting the database was not not necessary. Also, one of my
religious rituals is to perform a checkpoint after the tablespace 
has been successfully brought online. The reason is to record the
new timestamp to the control file and make sure that all files
have the same timestamp (checkpoint process updates file headers
during checkpoint).

On 12/08/2003 10:39:32 AM, Gene Gurevich wrote:
> Hi I got the following error in an alert.log file.
> Aparently it was a result of some UNIX issues on a
> hdisk, which have been resolved some time later ..
> 
> "Fri Dec  5 18:28:10 2003
> KCF: write/open error block=0x3571 online=1
>  file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf
>  error=27063 txt: 'IBM AIX RISC System/6000 Error:
> 5: I/O error
> Additional information: -1
> Additional information: 16384'
> Automatic datafile offline due to write error on
> file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf"
> 
> The file in question had status = 'RECOVER" in the
> v$datafile and status  = 'AVAIALBLE' in
> dba_Data_files. I attempted to restore the file after
> taking it offline, but couldn't due to a lock. I ended
> up bouncing the database an recovering this file. I'm
> wondering whether I should have tired to recover this
> file first without bouncing the database. If anyone
> has any experience with that issue, could you let me
> know whether what I did was wrong or not (and why). Is
> there a document that I can read on this?
> 
> thanks
> 
> Gene
> 
> 
> __
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Gene Gurevich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing 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
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: RMAN restore on another server

[Spears, Brian]

Dennis and all,

 I have no problem getting the controlfile... I just comment out the SET commands to 
change the directories of the dbfs...and I replicate the control according to the init 
file specifications.. So This operation actually extract the controlfile out of the 
backup piece so I know the location and connections are working fine.

But since the controlfile is backup and I am restoring it with the same RMan command I 
think I should have no problem.. I know other DBAs.. run this same script and restore 
the database on another server with no problem if the controlfile is restored before 
the database is restored and recovered.

Here is the restore controlfile script and resulting log file

==
Controlfile restore Script
==
connect catalog rman81740/[EMAIL PROTECTED]

connect target /


run

{

allocate channel d1 type disk ;

sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
set until time = '2003-12-02 05:50:00';


#restore controlfile to '/u02/vssppln/restored_cf.ctl';

replicate controlfile from '/u02/vssppln/restored_cf.ctl';

release channel d1;
}

==
Successful Controlfile restore log
==
Recovery Manager: Release 8.1.7.4.0 - Production

RMAN>
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2>
3> connect target /
4>
5>
6> run
7>
8> {
9>
10> allocate channel d1 type disk ;
11>
12> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
13> set until time = '2003-12-02 05:50:00';
14>
15>
16> restore controlfile to '/u02/vssppln/restored_cf.ctl';
17>
18> replicate controlfile from '/u02/vssppln/restored_cf.ctl';
19>
20> release channel d1;
21> }
22>
23>
RMAN-06008: connected to recovery catalog database

RMAN-06006: connected to target database: vssppln (not mounted)

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=12 devtype=DISK

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"
RMAN-03023: executing command: sql

RMAN-03022: compiling command: set

RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=/u02/vssppln/restored_cf.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl01.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl02.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl03.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl04.ctl
RMAN-08505: output filename=/u02/vssppln/vsspplncntl05.ctl

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: d1

Recovery Manager complete.


=
Here is the orignal entire script to restore controlfile and database
but it just hangs on the set commands..
=

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index0

RE: PERL?

[Orr, Steve]

Hey Mladen,

Weren't you going to be taking a look at Python too? (Around
Thanksgiving as I recall.) I'd be interested in your feedback on it as
well. 

My take is that Python is powerful yet easy to learn, it's much more
productive than Java and is still quite scalable. Like Perl it's a great
multi-platform scripting/glue language and shares many of its advantages
but unlike Perl, it's been object oriented from the start. There is some
looseness to its OO but the Python community touts that as an advantage.
;-)

We have a Python story here where we host our software for the majority
of our customers. While we perform most of the administration for our
customers we also allow them to admin some stuff via a web app developed
in Python. This app was developed under an accelerated schedule with a 3
man team headed by a brilliant computer science PhD dweeb who really
doesn't have to work for a living but chose to work with us just for the
fun of it. One of the things our customers can do is perform upgrades of
their app and this entails things like creating complete database
schemas, Oracle backups and creating/dropping tablespaces among other
things. (Kind of scary from a DBA control freak perspective.) Shortly
after this web app went production, one of the developers was tragically
killed, another developer who was an intern went back to school, and the
PhD dude went on to be a university professor so the app was kind of
dumped on my department consisting of a dozen admin type dweebs. We had
to learn Python to maintain this mission critical app in short order.
Not only were we able to quickly come up to speed to support the app, we
have since greatly enhanced it to where it's become central to much of
our SysAdmin/DBA duties. One reason for this successful transitions was
the virtue of Python. Several in the department (myself included) were
Perl literate beforehand and there is now unanimous consensus that we
could not have had as good transition if the app had been written in
Perl and we are glad Python was forced on us because the readability of
Python code makes it MUCH more maintainable. Besides being DBA I've now
done enough in Python that I am part DUHveloper. With socket programming
and XML I've been able to transact between databases. (Which is
definitely more sophisticated I/O than PL/SQL is capable of.) I've also
used Python to develop a web server and I'm even thinking about
replacing some Apache usage with my own web server code.

Well that's our story and there's more to Python than I can cover here
so as soon as hunting season is over I'm going to resume preparation for
my upcoming IOUW presentation titled, "Python, Oracle and the Meaning of
Life." Hope to see some of you there.


Steve Orr
Bozeman, Montana



-Original Message-
Mladen Gogala
Sent: Sunday, December 07, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L


Perl is a general purpose interpreted programming language, written
specifically with reporting purpose in mind.  In fact, perl stands for
"Practical  Extraction/Reporting Language".  That means that perl is
excellent for producing all kinds of reports. In fact, it has a part
called "formats" which is, in fact, a small report writer and can be
used to produce beautiful reports very quickly and with minimal effort.
The next very useful feature is an extremely versatile regular
expression engine which can do whatever awk & sed can do and more.
That, of course, is ideal for parsing all kinds of regular expressions,
like, for instance, parsing alert.log.  Perl , as I've said before, is
a general purpose programming language with pointers (all right, all
right, the name is "references", but those are really pointers) , which
makes for an exceptionally powerful combination.  Last, but not least,
there is a huge treasure chest 
called "CPAN" (http://cpan.perl.org) which contains vast number of
modules. In case of emergency, it's really easy to find something
useful. One other thing worth mentioning is that perl has bindings and 
modules which make it possible to work with  many databases, Tk, Gtk,
HTML and almost anything conceivable (OLE, ODBC, ADO and other MS
perversions included). There are two problems with perl. One is that
perl is a huge language with so many intrinsic and important elements
that it is really hard to learn the whole language. A title of  a perl
master should be an equivalent 
of a PhD. Another problem is a serious inadequacy of perl syntax for OO.
Perl doesn't have classes, abstract classes, private/protected/public
interface, templates, exception throw/catch mechanisms or some other
things 
that we know and love. Perl's OO model is based on something called
"module", essentially a program unit and a very weird function named
"bless". This function plays a vital role in object construction and, it
is done from up down to the ground instead of  doing it from  the ground
up. Bless  takes a pointer ("reference") and "blesses" it to the pointer
to a me

RE: PERL?

[Stephen.Lee]

The difference that has affected me the most in writing utility scripts is
that PERL can talk to the database like using a telephone. Ksh must talk
like using a walkie-talkie; that is, each side of the conversation must talk
then release the push-to-talk (PTT) button before the other side can talk.
Using a small amount of cleverness (which is good, because that's about how
much I have) in ksh, you can program around most of the communication
limitations.  For example, to deal with sqlplus getting "stuck" for one
reason or the other, you can run the subsection of the script in the
background (as a ksh job).  Then you check on the job later in the script.
If the job is still there longer than it should be, the script can kill the
job.  THEN, for good measure, look for sqlplus (and possible another ksh
that got forked by the script) with parent process ID (PPID) of me and kill
them.  This is similar to the other side failing to release the PTT button.
Unlike PERL, which can maybe yell into to telephone to wake the other side
up, ksh must launch an artillery shell onto the other guy which, in a rather
violent manner, will cause him to release the PTT button (well ... actually
.. the PTT switch kind of got blown up too).  Then, depending on the
situation, retry the sqlplus or conclude that something is wrong.

That being said, ksh is so easy to use and so handy, that I still use it for
automating database management and monitoring.  I'm sure a big part of that
is because I learned shell, sed, awk, etc. programming before perl was
standard equipment on Unix boxes.  I suppose if you are starting from the
beginning, then the way to go would be perl.  But you can still do a heck of
a lot with ksh (the REAL ksh; not the POS public domain ksh that tends to
show up with linux).

For an excellent book on getting started with this, go to Amazon and search
on Mark G. Sobell (or just Sobell).

Here's a tinyurl link to what I think is still must-have book.  Even though
a lot of it is outdated, the sections on getting around in Unix and shell
scripting are still entirely relevant.
http://tinyurl.com/y8x6
(Note that the used book sellers are just about giving away the book)

There is also a BSD version of the above book.

And you want to get O'Reilly's book on Sed and Awk.

Those should get you going down the wonderful world of shell scripting ...
which is the ORIGINAL, and still great, Rapid Application Development.

-Original Message-

I've read a lot about PERL on this list.  And, I am wondering what can you
do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts?


Any information will be greatly appreciated.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: PERL?

[Cary Millsap]

The only thing I think I disagree with is
the word “almost.”

 



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance
Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004:
March 7–10 Dallas
- Visit www.hotsos.com for schedule
details...



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Eric
King
Sent: Monday, December 08, 2003
6:39 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: PERL?

 



Perl is a full flege programming
language, it can do almost anything such as Java or C++ can do. SQL*Plus or
Shell is very limited in terms of functionalities.





 





Besides, Perl is portable language.
Perl code runs on almost any platforms.







- Original Message - 





From: KENNETH JANUSZ 





To: Multiple
recipients of list ORACLE-L 





Sent: Sunday,
December 07, 2003 22:34





Subject: PERL?





 





I've read a lot about PERL on this list.  And, I am
wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or
Unix shell scripts?  





 





Any information will be greatly appreciated.





 





Thanks much,





Ken Janusz, CPIM

Re: Alert Log

[Tanel Poder]

If nothing else helps, download procexp or filemon from www.sysinternals.com
and see which files are open by oracle.exe

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 5:04 PM


> Hi List
>
> My database is taking vert long time to startup. so I just wanted to check
alert log file. But I don't see Alert log in either background_dump_dest or
user_dump_dest.
> Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all
directory).
>
>
> SQL> show parameter dump
>
> NAME TYPEVALUE
>  --- -
-
> background_core_dump string  partial
> background_dump_dest string  C:\oracle\RDBMS\trace
> core_dump_dest   string  %ORACLE_HOME%\RDBMS\TRACE
> max_dump_file_size   string  10240
> shadow_core_dump string  partial
> user_dump_dest   string  C:\oracle\RDBMS\trace
> SQL>
>
> Coudl someone shed light on this?
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing 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.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Alert Log

[Gary W. Parker]

This is from the Oracle 8i Administrators Guide for Windows:

"Oracle8i for Windows NT background threads use trace files to record occurrences and
exceptions of database operations, as well as errors. Background thread trace files
are created regardless of whether the BACKGROUND_DUMP_DEST parameter is set in the
INIT.ORA initialization parameter file. If BACKGROUND_DUMP_DEST is set, the trace
files are stored in the directory specified. If the parameter is not set, the trace
files are stored in the ORACLE_BASE\ADMIN\DB_NAME\BDUMP directory."

This is the same information from the Oracle 9i Administrators Guide for Windows:

"The alert file is named SIDALRT.LOG and is found in the directory specified by
parameter BACKGROUND_DUMP_DEST in the initialization parameter file. If
parameter BACKGROUND_DUMP_DEST is not set, then file SIDALRT.LOG is
generated in ORACLE_BASE\admin\db_name\bdump. Alert files should be
deleted or archived periodically."

HTH

-Original Message-
[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L


Hi List

My database is taking vert long time to startup. so I just wanted to check alert log
file. But I don't see Alert log in either background_dump_dest or user_dump_dest.
Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all
directory).


SQL> show parameter dump

NAME TYPEVALUE
 --- --
background_core_dump string  partial
background_dump_dest string  C:\oracle\RDBMS\trace
core_dump_dest   string  %ORACLE_HOME%\RDBMS\TRACE
max_dump_file_size   string  10240
shadow_core_dump string  partial
user_dump_dest   string  C:\oracle\RDBMS\trace
SQL>

Coudl someone shed light on this?


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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.net
-- 
Author: Gary W. Parker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Alert Log

[Mladen Gogala]

Shed some light on your dump parameters? They'd look much better if they
had slashes instead of backslashes, but you probably can't help it. Now
that you've told us where are your log and trace files, please tell us
what's in them. My ESP capabilities are damaged by the snow and I need to actually
see the messages to even be able to speculate. Things are bound to improve in
the summer. In the meantime, try checking whether PRE_PAGE_SGA parameter is set
to TRUE. That sometimes may increase the instance startup time. Also, was your
instance shut down regularly or aborted? The instance may have been engaged 
in instance recovery. If my initial advice was followed ("/" instead of "\"),
I could advise you how to change /etc/init.d/oracle, but because of "\", I
can't help you.

On 12/08/2003 10:04:33 AM, [EMAIL PROTECTED] wrote:
> Hi List
> 
> My database is taking vert long time to startup. so I just wanted to check alert log 
> file. But I don't see Alert log in either background_dump_dest or user_dump_dest.
> Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all 
> directory).
> 
> 
> SQL> show parameter dump
> 
> NAME TYPEVALUE
>  --- --
> background_core_dump string  partial
> background_dump_dest string  C:\oracle\RDBMS\trace
> core_dump_dest   string  %ORACLE_HOME%\RDBMS\TRACE
> max_dump_file_size   string  10240
> shadow_core_dump string  partial
> user_dump_dest   string  C:\oracle\RDBMS\trace
> SQL>
> 
> Coudl someone shed light on this?
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing 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
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: PERL?

[Cary Millsap]

By “more sophisticated I/O,” I
mean things like: read and write files anywhere from a byte at a time to a
whole file at a time, do buffered C-like stuff (getc, ungetc), read and write
directly with compressed output, get and set tty attributes, do graphics, and
so on.

 



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance
Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004:
March 7–10 Dallas
- Visit www.hotsos.com for schedule
details...



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Monday, December 08, 2003
7:09 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: RE: PERL?

 

You’ll get much
more comprehensive answers than mine, but a few huge motives for me are…

 

-  You can’t do I/O—especially sophisticated interactive
I/O—conveniently in SQL*Plus or PL/SQL.

-  More generally, SQL restricts your viewpoint to what’s inside
the database. As a performance analyst, I need a language in which I can do
text processing, mathematical processing, and especially experiments with the
same OS calls that Oracle uses. You can even attach directly to the Oracle SGA
with Perl, where you can get x$ information without using SQL. (I don’t
do it, but it can be done.)

-  Perl regular _expression_ processing is spectacular compared to
anything else out there; this is critical for text processing (lexical analysis
and parsing).

-  Perl is more portable, more easily extensible, and better supported
with lots of interesting open source libraries than Unix shells.

 



Cary
Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance
Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004:
March 7–10 Dallas
- Visit www.hotsos.com for schedule
details...



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of KENNETH
JANUSZ
Sent: Sunday, December 07, 2003
9:34 PM
To: Multiple recipients of list
ORACLE-L
Subject: PERL?

 



I've read a lot about PERL on this list.  And, I am
wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or
Unix shell scripts?  





 





Any information will be greatly appreciated.





 





Thanks much,





Ken Janusz, CPIM

RE: RMAN restore on another server

[DENNIS WILLIAMS]

Brian - My sys admin pleads amnesia on the NFS problem. My recollection was
that it was misconfigured or had a default configuration that expected only
a couple of connections and RMAN actually opens MANY file connections. My
specific symptoms is that RMAN would create the first few data files and
then just stop. Oracle Support made me take NFS out of the mix and then
everything worked.
   In your case, I am also concerned about the control file. I was unable to
get 8i to create the control file from the backup although others on this
list reported success with that. I would feel better if you said that you
separately backed up the control file at the end of the RMAN backup, and
manually moved that control file into place on the test system. At least you
would eliminate that as the problem.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, December 08, 2003 8:49 AM
To: Multiple recipients of list ORACLE-L


DENNIS...Thanks for your feedback. Here it is.. (NSF problem??)

1. I am not using Tape only disk backups..
2. I ftp'd the backup pieces to new machine
3. I created a link to duplicate the backup location on the original machine
   and other locations as pfiles...edited the init file for new control
locations
etc.
4. The controlfile was wrapping in the backup piece same backup command
5. It is an NSF mount point. (Netapp) 

 Is there a solution with the NFS issue?

Brian Spears
Database Services
[EMAIL PROTECTED]
Limitedbrands
TECHNOLOGY SERVICES

 



-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
   1. You say you connected to your existing RMAN catalog? How does the
catalog know to recover this new database  and not the one it backed up?
Maybe it is confused. I found it much simpler to recover from the
controlfile even if I used the catalog to perform the backup. Also in a true
disaster, you may not have your RMAN catalog unless you have another tape.
If you can recover from the single tape with the RMAN backup, then your
offsite tape could get you up and running.
   2. Are the backup pieces in the same path as you backed them up? I don't
think that is your problem because that usually gives a clear error.
   3. Are you using NFS? I encountered a problem with NFS very similar to
your symptoms. My sys admin assumed there would be only a connection or two
over NFS, so left some stuff default. Come to find out RMAN opens a bunch of
connections.
 
Sorry, but that is all my brain can think up on Friday.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L


Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
 
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  
 
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...
 
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
 
 
 
 
Here is the command in operation
 
 
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for

RE: CPU Capacity Planning

[Boris Dali]

Thanks a lot, Cary.

Yes, this sentence on p.248: 

"As long the execution of each business function can
be expressed in terms of an LIO count, you can
translate the queueing model's output in terms of
business function response time and throughput" 

was the one I marked as something to go back to, as I
didn't really understand it.

Thanks,
Boris Dali.

 --- Cary Millsap <[EMAIL PROTECTED]> wrote: >
Boris,
> 
> I think I covered this in my response to Ryan. It
> was the "two stages"
> part.
> 
> Note that you can avoid even using queueing theory
> at all if you just
> make sure that utilization stays to the left of the
> knee in the
> performance curve for each resource on the system.
> You can learn the
> location of the knee for a given number of parallel
> service channels
> (for example, CPUs in your case) on Table 9-3 on
> p260 of "Optimizing
> Oracle Performance."
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Performance Diagnosis 101: 12/16 Detroit, 1/27
> Atlanta
> - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
> - Hotsos Symposium 2004: March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> 
> -Original Message-
> Boris Dali
> Sent: Sunday, December 07, 2003 12:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> Thanks for the clarifications, Cary.
> 
> With regards to a hardware sizing - how do LIOs fit
> into queueing theory? Let's say I can come up with
> something like:
> 
> #CPUs required = Sum( LIOs(Bus.Tx i)) / 
> (10,000*clock rate/100)
> 
> where i={Bus.Tx 1..n}
> 
> [on a projected box that haven't been bought yet, it
> might be a little difficult to estimate the
> denominator, ... and on the existing one I guess I
> have to get hold of Jonathan's paper to learn how
> this
> can be done]
> 
> ..but in any event for forecasting purposes, how
> queueing effect might be taken into account here?
> Let's say I measured Sum( LIOs(...)) for a 50 users
> in
> a unit testing environment and I am told that
> production would be 10 times more than that, what do
> I
> do?
> 
> Thanks,
> Boris Dali.
> 
>  --- Cary Millsap <[EMAIL PROTECTED]> wrote: >
> My answers are in-line, preceded with "[Cary
> > Millsap]"...
> > 
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> > 
> > Upcoming events:
> > - Performance Diagnosis 101: 12/16 Detroit, 1/27
> > Atlanta
> > - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
> > - Hotsos Symposium 2004: March 7-10 Dallas
> > - Visit www.hotsos.com for schedule details...
> > 
> > 
> > -Original Message-
> > Boris Dali
> > Sent: Sunday, December 07, 2003 9:54 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > Thanks a lot for the reply, Cary. Yes, your
> > explanation makes all the sense in the world even
> > though it is precisely the weighted average
> approach
> > that I've seen on some capacity planning
> > spreadsheets.
> > 
> > Two additional questions if I may, Cary.
> > Would it be correct to say that when I throw
> > additional users on a system it is only queueing
> > component of a response time that climbs up, while
> > service time stays the same?
> > 
> > [Cary Millsap] "Sort of," but not exactly. There
> are
> > lots of scalability
> > threats that begin to manifest in reality when you
> > crank up the load.
> > For example, you'll see "latch free" waiting on
> > applications that parse
> > too much, but only at higher user volumes (never
> in
> > unit test). You can
> > consider the new appearance of "latch free" events
> > to be a type of
> > queueing if you want, but it's really not queueing
> > in the sense of a
> > simple CPU queueing model. 
> > 
> > If that's true, than does
> > it matter how I measure service time of my Bus.Tx1
> -
> > on a loaded system where hundreds of users run
> this
> > operation or when nobody executes it all? Also is
> it
> > important to have the other two operations -
> Bus.Tx2
> > and Bus.Tx3 - running concurrently (as they would
> in
> > a
> > real life) for the c measurements?
> > 
> > [Cary Millsap] You'll put yourself at risk if you
> > simply try to use a
> > queueing model to extrapolate big-system
> performance
> > from data collected
> > in a unit testing environment. It's because of the
> > potentially
> > out-of-model scalability threats.
> > 
> > In other words assuming I have an identical
> replica
> > of
> > a production environment where I am the only user
> -
> > would service time/rate measured there be
> applicable
> > for a loaded system with heterogeneous workload?
> > 
> > [Cary Millsap] ...Only if you your production
> > environment doesn't
> > trigger any new serialization issues that weren't
> > visible on your unit
> > test env.
> > 
> > And another stupid question.
> > Knowing individual business tx. characteristics
> > (response time, number of CPUs required to comply
> > with
> > SLA requirements, average utilization per CPU,
> etc),
> > how does one go a

I/O error offlines a datafile

[Gene Gurevich]

Hi I got the following error in an alert.log file.
Aparently it was a result of some UNIX issues on a
hdisk, which have been resolved some time later ..

"Fri Dec  5 18:28:10 2003
KCF: write/open error block=0x3571 online=1
 file=68 /u21/ORACLE/pfiat02/isysx01_12.dbf
 error=27063 txt: 'IBM AIX RISC System/6000 Error:
5: I/O error
Additional information: -1
Additional information: 16384'
Automatic datafile offline due to write error on
file 68: /u21/ORACLE/pfiat02/isysx01_12.dbf"

The file in question had status = 'RECOVER" in the
v$datafile and status  = 'AVAIALBLE' in
dba_Data_files. I attempted to restore the file after
taking it offline, but couldn't due to a lock. I ended
up bouncing the database an recovering this file. I'm
wondering whether I should have tired to recover this
file first without bouncing the database. If anyone
has any experience with that issue, could you let me
know whether what I did was wrong or not (and why). Is
there a document that I can read on this?

thanks

Gene


__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Copying stats between/amongst schemas

[Tanel Poder]

Hi!

I checked the Cassandra last time I was in Finland. It's a quite decent
graphical tool for transferring/managing and testing statistics. It's based
on dbms_stats, so it's just a frontend.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 1:39 AM


>
> Although I'm sure that someone (ChangeGroup in Denmark, Abase in Finland)
> would like to tell you about Cassandra:
> http://www.abase.fi/products_cassandra.php?lang=e (a GUI interface (+
more)
> to dbms_stats (sort of)).
>
> :o)
> Michael Garfield Sørensen, CeDeT
>
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 03, 2003 12:24 AM
>
>
> > dbms_stats is the only sanctioned way to do it.
> >
> > Orr, Steve wrote:
> >
> > > 1 database instance, 2 nearly identical schemas. What's the best
> > > sanctioned way to copy stats, (including histograms), from one schema
> > > to another?
> >
> >
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing 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.net
> -- 
> Author: =?iso-8859-1?Q?Michael_Garfield_S=F8rensen?=
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing 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.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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 Data Guard

[Tanel Poder]

> Hi All,
>
> can any one let me know kindly the following info.
>
> 1) Has any one used the Oracle 9i Data Guard?

Yes, physical standby and successfully.

> 2) If yes then,  is there any performance impact on
> Target/Source server database.

Your database has to be in archivelog mode, but when you are thinking such
solutions as DG, then you probably are already running archivelog anyway.

If you run in maximum protection or maximum availability, yes there is. The
impact depends mainly on network connection between primary and standby(s)
and the speed of redolog disks. You could tune these by using faster
network, enabling jumbo frames and SDU size if using Gbit ethernet, also
setting lgwr and log apply processes priority higher than others.

> 3) any drawbacks using Data Guard.

You should set your database or critical tablespaces to force logging mode
in order to transfer all changes to standby in physical standby. That means,
performance improvements which take advantage of nologging operations (such
insert append nologging etc), will not run that fast anymore.
In logical standby, I think there's no such requirement, but I don't
recommend you to use logical stby yet, it's more like a prototype currently,
not exactly a working product.

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Change Manager

[Jamadagni, Rajendra]

There is a nice search feature on asktom page, I usually use that.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Monday, December 08, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L


Raj, Thanks for your response.
Could you or someone in this list give me the url. I did search asktom site but not 
able to locate the actual code.



- Original Message -
Date: Monday, December 8, 2003 7:14 am

> MG, the article does something more than manual ... can you spell 
> 'cut-and-paste' ??? It gives readymade code.
> 
> Raj
> ---
> -
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
> 
> 
> -Original Message-
> Sent: Monday, December 08, 2003 2:14 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> On 2003.12.08 01:49, George Leonard wrote:
> > Hi there
> > 
> > There was a article on asktom.oracle.com a while back of a stored
> > procedure/trigger extension you can add to Oracle with a  
> logging table
> > that record when a table was added or modified or basically any 
> object> was altered.
> > 
> 
> It's called a "database trigger on ddl event". If I'm not 
> mistaken, the syntax is something like
> "create or relace trigger mytrig on scott.schema after 
>  about that article? That stuff is covered in 9i SQL reference manual.
> 
> 
> **
> 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.
> **5
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>  INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---
> --
> To REMOVE yourself from this mailing 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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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 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.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Alert Log

[Jesse, Rich]

Maybe in %ORACLE_HOME%\dbs ?

Rich

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


-Original Message-
Sent: Monday, December 08, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L


Hi List

My database is taking vert long time to startup. so I just wanted to check
alert log file. But I don't see Alert log in either background_dump_dest or
user_dump_dest.
Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all
directory).


SQL> show parameter dump

NAME TYPEVALUE
 ---
--
background_core_dump string  partial
background_dump_dest string  C:\oracle\RDBMS\trace
core_dump_dest   string  %ORACLE_HOME%\RDBMS\TRACE
max_dump_file_size   string  10240
shadow_core_dump string  partial
user_dump_dest   string  C:\oracle\RDBMS\trace
SQL>

Coudl someone shed light on this?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Change Manager

[jaysingh1]

Raj, Thanks for your response.
Could you or someone in this list give me the url. I did search asktom site but not 
able to locate the actual code.



- Original Message -
Date: Monday, December 8, 2003 7:14 am

> MG, the article does something more than manual ... can you spell 
> 'cut-and-paste' ??? It gives readymade code.
> 
> Raj
> ---
> -
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
> 
> 
> -Original Message-
> Sent: Monday, December 08, 2003 2:14 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> On 2003.12.08 01:49, George Leonard wrote:
> > Hi there
> > 
> > There was a article on asktom.oracle.com a while back of a stored
> > procedure/trigger extension you can add to Oracle with a  
> logging table
> > that record when a table was added or modified or basically any 
> object> was altered.
> > 
> 
> It's called a "database trigger on ddl event". If I'm not 
> mistaken, the syntax is something like
> "create or relace trigger mytrig on scott.schema after 
>  about that article? That stuff is covered in 9i SQL reference manual.
> 
> 
> **
> 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.
> **5
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>  INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---
> --
> To REMOVE yourself from this mailing 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.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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).

Alert Log

[jaysingh1]

Hi List

My database is taking vert long time to startup. so I just wanted to check alert log 
file. But I don't see Alert log in either background_dump_dest or user_dump_dest.
Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory).


SQL> show parameter dump

NAME TYPEVALUE
 --- --
background_core_dump string  partial
background_dump_dest string  C:\oracle\RDBMS\trace
core_dump_dest   string  %ORACLE_HOME%\RDBMS\TRACE
max_dump_file_size   string  10240
shadow_core_dump string  partial
user_dump_dest   string  C:\oracle\RDBMS\trace
SQL>

Coudl someone shed light on this?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: rebuilding indexes - sure to cause a ruckus

[Tanel Poder]

Hi!

Yes Yong I agree with you, that rebuilding may be beneficial in some cases,
especially some tables/indexes become either logically or physically read
only (btw, I was not speaking about coalescing in my post, it's a different
story anyway).

But the point I wanted to make is that single query's speed (LIO amount)
right after rebuilding index doesn't usually give us enough information to
determine whether overall system speed will go better in long term. When you
have rebuilt an index, it becomes more compact, causing more recursive
operations for block splits and perhaps index height changes in the future.
Also, in heavily loaded 24x7 environments with no real low-peak time, the
additional CPU, IO and brief exclusive lock usage may cause more harm than
it gives benefit. And often this benefit is only short term in regular OLTP
systems.

But in some cases, as when you've deleted a number of rows from your table
or done a lot of updates and you never expect these keys to be back in the
index, a rebuild can be justified.

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 10:29 PM


> Tanel,
>
> I think you're saying a query almost always runs faster right after the
index
> rebuild and there's no point in finding the criterion whether to rebuild
an
> index. (What is "42"?)
>
> Some time ago I posted a message somewhere else showing a case where
rebuilding
> or coalescing an index may be benefitial. A data warehouse is found to
have
> some data errors. Deletes and updates are done. Then the database goes to
> mostly read-only again, and will last for a month or quarter. Then
shrinking
> frequently used B*Tree indexes is a good idea. Now I'd like to add one
more
> criterion as a result of reading Jonathan Lewis' dbazine article and email
with
> him (errors are mine): the index is full scanned, or if range scanned or
unique
> scanned, the index selectivity has to be fairly low (but not too low for
the
> index to be ignored by CBO).
>
> In a typical working environment, a data warehouse does have plenty of
> relatively quiet period. I worked on a monthly data load project at an
> insurance company. I remember we rebuilt a partitioned IOT (one partition
at a
> time) and fast full index scan (certain partitions) did run faster.
>
> There're some errors in Don Burleson's dbazine article (e.g. pct_used in
> dba_indexes) and Mike Hordila's Oramag article (structurally unbalanced
index).
> But one thing alluded to in there is important: study Oracle performance
> problems as scientific research. You said setting _wait_for_sync to false
> improves performance. That's a fact. We can only explain and analyze it
but not
> deny it. Similarly, when Mike says queries run 10 to 50% faster after
index
> rebuild, we can't deny unless we find his measurement is wrong. Wouldn't
it be
> nice if Oracle researchers write articles with sections like Abstract -
> Experimental - Results - Discussion in that order?
>
> Yong Huang
>
> Tanel Poder wrote:
>
> There's no point of arguing about whether a query ran faster right after
you
> rebuilt your index. Nor there is no point in finding some ultimate
algorithm
> for finding the point of index rebuilding, we all know the answer - it's
> "42".
>
> Instead, a long stress test has to be done, e.g. running 10 millions of
> continous transactions and queries (simulating real life). Do one 10M
> without rebuilding indexes in the meantime, measure total execution time,
IO
> amount, CPU usage, segment sizes etc.
>
> Then restore your database back to starting point and do the same test
again
> with regular index rebuilds during the operations (online or taking
"users"
> offline, depending on environment type). And then measure the same
> statistics, especially total execution time. Note, that statistics and
time
> also for rebuilding indexes should be accounted in totals, because in real
> life they don't just disappear somewhere as in some simple-minded tests.
>
> Tanel.
>
> __
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Yong Huang
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing 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.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5

RE: RMAN restore on another server

[DENNIS WILLIAMS]

Brian - I think that is the problem -- you can't tell RMAN you are on a
different server. The part I'm not getting a clear picture on is your
control file. For this specific recovery, how is it getting a control file?
Did you move one over from production, or are you waiting for RMAN to cough
it up from the backup pieces? On 8i this tends to be a problem.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, December 08, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L


I have ftp'd  the backup pieces into the identical backup location as the
orignal server so I have all the stuff available... Im just wondering if I
have to do something to tell it that I am on a different server...

I've restored the controlfile mannually before but on the same server. I
backup the controlfile and wrap in the backup piece with the normal backup.


Brian

-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L


Janardhana - That's a good point. 
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L



May be you try the following:

 

If you get errors restoring controlfile, You may ftp the controlfiles
manually to the new server and startup mount the database first. Then, Try
your restore database.

 

-- Janardhana

 

-Original Message-
Sent: Friday, December 05, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L

 

Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.

Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.

 

Some of the steps to setup the new machine.

1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over

4) duplicated the Admin directories for the database to be restored

5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on

6) Created a backup mount point to store the RMAN backup pieces and
archivelogs

7) moved the backup pieces and archivelogs to the new machine

8) Setup and confirm connectivity to Rman catalog

9) No mount the database to be on the new machine

10) Launch the Rman command

rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  

 

Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...

 

Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..

 

 

 

 

Here is the command in operation

 

 

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   

 

Recovery Manager: Release 8.1.7.4.0 - Production

 

RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aims

RE: Oracle and Novell eDirectory LDAP

[DENNIS WILLIAMS]

Stephane - Last week the following message was posted. While it relates to
MS AD, rather than Novell, the principles are the same and after all LDAP is
a standard -- right? ;-) So you may want to scan the archives for this
thread. Several people have expressed interest in this topic, and it seems
doable, but nobody has posted a success story. From my meager understanding
of LDAP, I think you will have to install and run Oracle Internet Directory,
at least to get started, then export an LDIF from OID and import it into
eDirectory. Depending on how you intend to use LDAP, you may have to
continue to synchronize the two.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, December 03, 2003 8:39 AM
To: Multiple recipients of list ORACLE-L

Embarrassed by Google/OTN, after stating I had not had time to verify what
version integrates with AD, I spent 10 mins on Google and OTN (Oracle
Technology Network) and hey presto :-

"With Oracle9i Application Server 9.0.4, Oracle will offer prepackaged
connectivity solutions for NT Domains and ADS. These solutions will allow
Oracle customers to perform two-way synchronization of directory data
between the Windows and Oracle environments."

Therefore the answer is any version prior to Oracle 9i Application Server
9.0.4 does not have out-of-the-box integration with Active Directory.

-Original Message-
Sent: Monday, December 08, 2003 8:34 AM
To: Multiple recipients of list ORACLE-L


Hi,

We are in the preliminary analysis of implementing an assurance package
(Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web
Services and Forms on AIX 5.2).

We are using Novell eDirectory as our LDAP.

I looked on Metalink but did not find much thing. The way I understand it is
that you must load the LDAP info into Oracle Internet Directory.

Am I right ?

Anybody using Novell eDirectory integrated with Oracle ?

TIA


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 poste 7470 
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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 Data Guard

[Nalla Ravi]

Hi All,

can any one let me know kindly the following info.

1) Has any one used the Oracle 9i Data Guard?
2) If yes then,  is there any performance impact on
Target/Source server database.
3) any drawbacks using Data Guard.

with many thanks,
Vijay.


BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st 
December 2003. The way the internet was meant to be. 
http://uk.rd.yahoo.com/evt=21064/*http://btyahoo.yahoo.co.uk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Nalla=20Ravi?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: RMAN restore on another server

[Spears, Brian]

DENNIS...Thanks for your feedback. Here it is.. (NSF problem??)

1. I am not using Tape only disk backups..
2. I ftp'd the backup pieces to new machine
3. I created a link to duplicate the backup location on the original machine
   and other locations as pfiles...edited the init file for new control locations
etc.
4. The controlfile was wrapping in the backup piece same backup command
5. It is an NSF mount point. (Netapp) 

 Is there a solution with the NFS issue?

Brian Spears
Database Services
[EMAIL PROTECTED]
Limitedbrands
TECHNOLOGY SERVICES

 



-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
   1. You say you connected to your existing RMAN catalog? How does the
catalog know to recover this new database  and not the one it backed up?
Maybe it is confused. I found it much simpler to recover from the
controlfile even if I used the catalog to perform the backup. Also in a true
disaster, you may not have your RMAN catalog unless you have another tape.
If you can recover from the single tape with the RMAN backup, then your
offsite tape could get you up and running.
   2. Are the backup pieces in the same path as you backed them up? I don't
think that is your problem because that usually gives a clear error.
   3. Are you using NFS? I encountered a problem with NFS very similar to
your symptoms. My sys admin assumed there would be only a connection or two
over NFS, so left some stuff default. Come to find out RMAN opens a bunch of
connections.
 
Sorry, but that is all my brain can think up on Friday.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L


Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
 
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  
 
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...
 
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
 
 
 
 
Here is the command in operation
 
 
==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   
 
Recovery Manager: Release 8.1.7.4.0 - Production
 
RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/a

RE: RMAN restore on another server

[Spears, Brian]

I have ftp'd  the backup pieces into the identical backup location as the orignal 
server so I have all the stuff available... Im just wondering if I have to do 
something to tell it that I am on a different server...

I've restored the controlfile mannually before but on the same server. I backup the 
controlfile and wrap in the backup piece with the normal backup.


Brian

-Original Message-
DENNIS WILLIAMS
Sent: Friday, December 05, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L


Janardhana - That's a good point. 
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, December 05, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L



May be you try the following:

 

If you get errors restoring controlfile, You may ftp the controlfiles
manually to the new server and startup mount the database first. Then, Try
your restore database.

 

-- Janardhana

 

-Original Message-
Sent: Friday, December 05, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L

 

Goal:  To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.

Strategy: To restore the database  from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.

 

Some of the steps to setup the new machine.

1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over

4) duplicated the Admin directories for the database to be restored

5) created a big mount  /u02/vssppln/ point for all the datafiles and
controlfiles and so on

6) Created a backup mount point to store the RMAN backup pieces and
archivelogs

7) moved the backup pieces and archivelogs to the new machine

8) Setup and confirm connectivity to Rman catalog

9) No mount the database to be on the new machine

10) Launch the Rman command

rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log  

 

Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the  "RMAN-03022: compiling command: set "  and just
hangs...adding another line every 1/2 hour or so...

 

Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..

 

 

 

 

Here is the command in operation

 

 

==> rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log   

 

Recovery Manager: Release 8.1.7.4.0 - Production

 

RMAN> 
RMAN> connect catalog rman81740/[EMAIL PROTECTED]
 
2> 
3> connect target /
4> 
5> 
6> 
7> run
8> 
9> {
10> 
11> allocate channel disk_channel1 type disk ;
12> 
13> sql 'alter session set NLS_DATE_FORMAT="-MM-DD HH24:MI:SS"';
14> set until time = '2003-12-02 05:50:00';
15> 
16>  set newname for datafile 1 to
17> '/u02/vssppln/system01.dbf';
18> 
19>  set newname for datafile 2 to
20> '/u02/vssppln/rbs01.dbf';
21> 
22>  set newname for datafile 3 to
23> '/u02/vssppln/rbs02.dbf';
24> 
25>  set newname for datafile 4 to
26> '/u02/vssppln/AIMFACT01.dbf';
27> 
28>  set newname for datafile 5 to
29> '/u02/vssppln/AIMFACT_INDEX01.dbf';
30> 
31>  set newname for datafile 6 to
32> '/u02/vssppln/AIMFACT101.dbf';
33> 
34>  set newname for datafile 7 to
35> '/u02/vssppln/AIMFACT102.dbf';
36> 
37>  set newname for datafile 8 to
38> '/u02/vssppln/aimfact1_index01.dbf';
39> 
40>  set newname for datafile 9 to
41> '/u02/vssppln/aimfact1_index02.dbf';
42> 
43>  set newname for datafile 10 to
44> '/u02/vssppln/aimfact1_index03.dbf';
45> 
46>  set newname for datafile 11 to
47> '/u02/vssppln/aimfact1_index04.dbf';
48> 
49>  set newname for datafile 12 to
50> '/u02/vssppln/aimfact201.dbf';
51> 
52>  set newname for datafile 13 to
53> '/u02/vssppln/aimfact202.dbf';
54> 
55>  set newname for datafile 14 to
56> '/u02/vssppln/aimfact2_index01.dbf';
57> 
58>  set newname for datafile 15 to
59> '/u02/vssppln/aimfact2_index02.dbf';
60> 
61>  set newname for datafile 16 to
62> '/u02/vssppln/aimfact2_index03.dbf';
63> 
64>  set newname for datafile 17 to
65> '/u02/vssppln/aimfact2_index04.dbf';
66> 
67>  set newname for datafile 18 to
68> '/u02/vssppln/aimstruct01.dbf';
69> 
70>  set newname for datafile 19 to
71> '/u02/vssppln/aimstruct_index01.dbf';
72> 
73>  set newname for datafile 20 to
74> '/u02/vssppln/aimstruct101.dbf';
75> 
76>  set newname for datafile 21 to
77> '/u02/vssppln/aimstruct1_index01.dbf';
78> 
79>  set newname for datafile 22 to
80> '/u02/vssppln/aimwork01.dbf';
81> 
82>  set newname for datafile 23 to
83> '/u02/vssppln/mipsdata01.dbf';
84> 
85>  set newname for datafile 24 to
86> '/u02/vssppln/mipsindex01.dbf';
87> 
88>  set newname for datafile 

Oracle and Novell eDirectory LDAP

[Stephane Paquette]

Hi,

We are in the preliminary analysis of implementing an assurance package (Sunguard's 
Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 
5.2).

We are using Novell eDirectory as our LDAP.

I looked on Metalink but did not find much thing. The way I understand it is that you 
must load the LDAP info into Oracle Internet Directory.

Am I right ?

Anybody using Novell eDirectory integrated with Oracle ?

TIA


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 poste 7470 
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: PERL?

[Mladen Gogala]

Say, handling screen forms, sockets and pipes would be considered rather 
sophisticated IO, don't you think? Generally speaking, PL/SQL can only
do simpleton I/O (a.k.a doofus I/O) while perl is much more sophisticated

On 12/08/2003 08:09:25 AM, [EMAIL PROTECTED] wrote:
> what do you mean by sophisticated I/O?
> > 
> > From: "Cary Millsap" <[EMAIL PROTECTED]>
> > Date: 2003/12/07 Sun PM 11:59:25 EST
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: RE: PERL?
> > 
> > You'll get much more comprehensive answers than mine, but a few huge
> > motives for me are.
> > 
> >  
> > 
> > -  You can't do I/O-especially sophisticated interactive
> > I/O-conveniently in SQL*Plus or PL/SQL.
> > 
> > -  More generally, SQL restricts your viewpoint to what's inside
> > the database. As a performance analyst, I need a language in which I can
> > do text processing, mathematical processing, and especially experiments
> > with the same OS calls that Oracle uses. You can even attach directly to
> > the Oracle SGA with Perl, where you can get x$ information without using
> > SQL. (I don't do it, but it can be done.)
> > 
> > -  Perl regular expression processing is spectacular compared to
> > anything else out there; this is critical for text processing (lexical
> > analysis and parsing).
> > 
> > -  Perl is more portable, more easily extensible, and better
> > supported with lots of interesting open source libraries than Unix
> > shells.
> > 
> >  
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> > 
> > Upcoming events:
> > - Performance   Diagnosis
> > 101: 12/16 Detroit, 1/27 Atlanta
> > - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
> > - Hotsos Symposium 2004  :
> > March 7-10 Dallas
> > - Visit www.hotsos.com for schedule details...
> > 
> > -Original Message-
> > KENNETH JANUSZ
> > Sent: Sunday, December 07, 2003 9:34 PM
> > To: Multiple recipients of list ORACLE-L
> > 
> >  
> > 
> > I've read a lot about PERL on this list.  And, I am wondering what can
> > you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell
> > scripts?  
> > 
> >  
> > 
> > Any information will be greatly appreciated.
> > 
> >  
> > 
> > Thanks much,
> > 
> > Ken Janusz, CPIM
> > 
> > 
> > 
> 

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: PERL?

[ryan_oracle]

what do you mean by sophisticated I/O?
> 
> From: "Cary Millsap" <[EMAIL PROTECTED]>
> Date: 2003/12/07 Sun PM 11:59:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: PERL?
> 
> You'll get much more comprehensive answers than mine, but a few huge
> motives for me are.
> 
>  
> 
> -  You can't do I/O-especially sophisticated interactive
> I/O-conveniently in SQL*Plus or PL/SQL.
> 
> -  More generally, SQL restricts your viewpoint to what's inside
> the database. As a performance analyst, I need a language in which I can
> do text processing, mathematical processing, and especially experiments
> with the same OS calls that Oracle uses. You can even attach directly to
> the Oracle SGA with Perl, where you can get x$ information without using
> SQL. (I don't do it, but it can be done.)
> 
> -  Perl regular expression processing is spectacular compared to
> anything else out there; this is critical for text processing (lexical
> analysis and parsing).
> 
> -  Perl is more portable, more easily extensible, and better
> supported with lots of interesting open source libraries than Unix
> shells.
> 
>  
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Performance   Diagnosis
> 101: 12/16 Detroit, 1/27 Atlanta
> - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
> - Hotsos Symposium 2004  :
> March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> -Original Message-
> KENNETH JANUSZ
> Sent: Sunday, December 07, 2003 9:34 PM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> I've read a lot about PERL on this list.  And, I am wondering what can
> you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell
> scripts?  
> 
>  
> 
> Any information will be greatly appreciated.
> 
>  
> 
> Thanks much,
> 
> Ken Janusz, CPIM
> 
> 
> 









You’ll get much more comprehensive
answers than mine, but a few huge motives for me are…

 

- 
You can’t do I/O—especially
sophisticated interactive I/O—conveniently in SQL*Plus or PL/SQL.

- 
More generally, SQL
restricts your viewpoint to what’s inside the database. As a performance
analyst, I need a language in which I can do text processing, mathematical
processing, and especially experiments with the same OS calls that Oracle uses.
You can even attach directly to the Oracle SGA with Perl, where you can get x$
information without using SQL. (I don’t do it, but it can be done.)

- 
Perl regular _expression_ processing
is spectacular compared to anything else out there; this is critical for text
processing (lexical analysis and parsing).

- 
Perl is more portable,
more easily extensible, and better supported with lots of interesting open
source libraries than Unix shells.

 



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Performance
Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004:
March 7–10 Dallas
- Visit www.hotsos.com for schedule
details...



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of KENNETH
JANUSZ
Sent: Sunday, December 07, 2003
9:34 PM
To: Multiple recipients of list
ORACLE-L
Subject: PERL?

 



I've read a lot about PERL on this list.  And, I am
wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or
Unix shell scripts?  





 





Any information will be greatly appreciated.





 





Thanks much,





Ken Janusz, CPIM

RE: PERL?

[Jack van Zanen]

Hi 


I tend to use PHP (and present the results in a browser or via email) for
scripts that fall outside the scope of (PL/)SQL. 
I have never had a serious look at Perl, is there any website(s) that can
give a clear explanation of the pro's con's of both?

The reason I choose PHP was the ease of learning and availability of
resources/examples.


Jack


 
-Original Message-
Sent: Monday, December 08, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L


Perl is a full flege programming language, it can do almost anything such as
Java or C++ can do. SQL*Plus or Shell is very limited in terms of
functionalities.

Besides, Perl is portable language. Perl code runs on almost any platforms.
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Sunday, December 07, 2003 22:34


I've read a lot about PERL on this list.  And, I am wondering what can you
do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts?


Any information will be greatly appreciated.

Thanks much,
Ken Janusz, CPIM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jack van Zanen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: PERL?

[Eric King]

Perl is a full flege programming language, it can 
do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited 
in terms of functionalities.
 
Besides, Perl is portable language. Perl code runs 
on almost any platforms.

  - Original Message - 
  From: 
  KENNETH JANUSZ 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Sunday, December 07, 2003 
  22:34
  Subject: PERL?
  
  I've read a lot 
  about PERL on this list.  And, I am wondering what can you do with PERL 
  that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts?  
  
   
  Any information will be 
  greatly appreciated.
   
  Thanks much,
  Ken Janusz, 
  CPIM

RE: PERL?

[Jamadagni, Rajendra]

Oh ... and one more thing ... you can write code in Perl and not have many people 
understand it, greatly helps in job security if you are the only one at your work to 
know Perl. Okay, it is great, nice and better than many other languages, but now can 
you learn this language to obfuscation? http://compsoc.dur.ac.uk/whitespace/

We just took a class in Perl programming, so go ahead, you'll be glad you learned 
something and then you get addicted to YAPH. It surely does a lot more than sql*plus 
and ksh.
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


**
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.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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: Change Manager

[Jamadagni, Rajendra]

MG, the article does something more than manual ... can you spell 'cut-and-paste' ??? 
It gives readymade code.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Monday, December 08, 2003 2:14 AM
To: Multiple recipients of list ORACLE-L



On 2003.12.08 01:49, George Leonard wrote:
> Hi there
> 
> There was a article on asktom.oracle.com a while back of a stored
> procedure/trigger extension you can add to Oracle with a  logging table
> that record when a table was added or modified or basically any object
> was altered.
> 

It's called a "database trigger on ddl event". If I'm not mistaken, the syntax is 
something like
"create or relace trigger mytrig on scott.schema after http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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).

[no subject]

[Barry Deevey]

SET ORACLE-L MAIL
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barry Deevey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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-02045 on 8.1.7.0.0

[Yechiel Adar]

You may check the distributed_transaction parameter on your databases.

Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 1:54 PM


> Hello @all,
>
> maybe this is a newbie question (at least I am)
>
> I've got an Oracle 8.1.7 installation on Sun Solaris 8 (sparc). We use
some
> database management software which gegerates several select-statements
going
> over ten database users. After some seconds (everytime in another db-user
and
> another table), the system prints out the following error:
>
> ORA-02045: too many local sessions participating in global transaction
> ORA-02063: preceding line from STGTSU
>
> What's up here?
>
>
>
> greetz
> Elmar
>
> --
> +++ GMX - die erste Adresse für Mail, Message, More +++
> Neu: Preissenkung für MMS und FreeMMS! http://www.gmx.net
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Elmar Hartung
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing 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.net
-- 
Author: Yechiel Adar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing 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).