Re: archiving redo logs

[Yechiel Adar]

Title: RE: Oracle 9i installation - Basic Qs - HELP!



Why not use this parameter?
I can (on NT but I am sure Unix can do the same) 
define drive letter X as a disk on another machine and the OS works with it as a 
local disk. This way you can use the oracle feature without inventing the wheel 
again.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Bala 
  Regupathy 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, December 10, 2002 11:52 
  PM
  Subject: RE: archiving redo logs
  
  In 
  other words,  I would like to simulate the behavior of 
  :
   
  log_archive_dest_2 = 'SERVICE=PRODSB REOPEN=30'
   
  using unix/sql script.
   
  Bala.
  
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 
Bala RegupathySent: Tuesday, December 10, 2002 2:06 
PMTo: Multiple recipients of list ORACLE-LSubject: 
archiving redo logs
Hi,
 
How can I archive redo logs automatically to a different machine 
?.  Standby database is not an option because the target machine's OS 
is different from the primary.  
 
Primary db is 8.1.7.2 resides on SUN E10k with SunOS 
5.8.
Target server is DEC Alpha 4.0
 
If 
UNIX script is the only option, I appreciate if you can share it 
here.
 
Thanks,
 
Bala.
 

passing parameters to a stored procedure from command prompt

[kranti . pushkarna]

Hi all,
  I am running a batch file through which I am opening SQLPLUS session
and calling a stored procedure. I want to pass parameters to this procedure
from the command prompt. Is it possible? Can anyone on this list will help
me.
 Environment is Oracle 8.1.7 and OS Win2k.

Thanx,
Kranti Pushkarna




This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete the
original.  Any other use of the email by you is prohibited.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Increase size of data files and rollback segments

[Yechiel Adar]

>From bitter experience:

Do not allow your datafile to autoextend across 4GB boundary.
There is a bug that cause this datafile to be unusable.
We had an all night session after this bug hit us.
We had to call Oracle to come with the DUL utility to
recover the data.

Now we define our datafiles to be 1900MB each.
Also each tablespace has an extra datafile with 200MB size
with autoextend up to 1900MB.

Our checks check that each tablespace has datafile with 200MB size.
If not we get an alert and check the situation.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 2:46 AM


> David,
>
> As a start, look up the following commands in the SQL Reference guide:
>
> alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on
maxsize 20480M;
> Read up on the implications of autoextend and whether you want it
>
> alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M;
>
> For rollback datafile - same as any other datafile, eg:
> alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on
maxsize 10240M;
>
> You may then need to add another rollback segment or increase the max
extents of an existing one.  eg to add another rollback segment:
> CREATE PUBLIC ROLLBACK SEGMENT r09_big
>TABLESPACE rollback
>STORAGE
>( minextents 20
>  INITIAL 10M
>  NEXT 10M
>  MAXEXTENTS UNLIMITED)
>
> (you would then need to bring this online - eg "alter rollback segment
r09_big online;")
>
>
> For tempfile (ie LMT temporary tablespaces):
> alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize
10240M;
>
> Remember - don't use the exact sizes I've shown - alter to suit your case
(these were part of a huge load into a new test system)
>
>
> Hope this helps (and willing to learn if some of the above could be
improved).
>
> Regards,
> Bruce
>
> -Original Message-
> Sent: Wednesday, 11 December 2002 8:15 AM
>
> > From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
> >
> > Alright guys, just because you know Jeremiah better than me
> > so you can take
> > his joke.
> I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I
nearly flamed you myself, and I'm just a lowly developer.
> >  My apology to him as I did not recognize it was a
> > joke, however
> > when I am asking for help from the group, I am in a situation
> > to resolve
> > problem ASAP and hope to find a answer not a joke.
> The problem is that if enough people like you refuse to RTFM, then no one
will want to answer questions because it'll be duller'n your resume.
> > If you were in my situation, you would understand.
> I've been in your situation, and been damned ashamed of myself for not
having researched the question first. It ain't all that hard...
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Reardon, Bruce (CALBBAY)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 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.com
-- 
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).

Re: OT: Guidelines/Standards for supporting non-oracle

[Yechiel Adar]

I do not know if this was a configuration error or 
something that is built into access but some time ago a package based on access 
stopped working. We found out that the access database got to 1GB size and 
stopped growing so they could not insert new data into it.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Michael 
  Fontana 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, December 10, 2002 11:44 
  PM
  Subject: Re: OT: Guidelines/Standards for 
  supporting non-oracle
  At 01:15 PM 12/10/2002 -0800, [EMAIL PROTECTED] wrote:
  Hi,We are virtually an 
Oracle shop with 2-3 sql server databases due to3rd-party software 
restrictions.We have been asked about supporting other "small" databases 
such asAccess,etc within our company.  My question is ifyou 
were asked to support "smaller" databases 
whatrestrictions/guidelines/standards are worth considering?Be 
kind-constructive answers only :-)This is a tough 
  nut to crack, and has probably been dealt with by everyone in this business at 
  one timeor another.  Biggest problem I've seen in these situations is 
  that, as a professional, you often don't knowwhat you're being asked to 
  do.  Kind of like a construction contractor bidding on the job without 
  gettingto see it first.I guess it depends what you mean by 
  "support".  A small database such as Access is usually only a 
  single-user or departmental solution at best.Perhaps you could decide 
  not to support these at all, unless they're converted to Oracle or 
  SQL*Server?This would then also give you the ability to 
  redesign/re-engineer these databases for enterprise supportstandards you 
  may already have.  I would really question how someone can implement data 
  integrity andperformance for an application they did not design and have 
  no documentation about.

RE: Finding User sessions = idle > 30 min??

[Denham Eva]

Title: RE: Finding User sessions = idle > 30 min??





Thanks to all who have contributed.
Here is a solution based on Raj's email.
Pls let me know if I am barking up the wrong tree..


SELECT SID, SERIAL#, USERNAME, (LAST_CALL_ET / 60), LAST_CALL_ET, LOGON_TIME
FROM v$session
WHERE username IS NOT NULL
AND (LAST_CALL_ET / 60) > 30
AND STATUS = 'INACTIVE';


Thanks
Denham




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 4:55 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Finding User sessions = idle > 30 min??




Denham,


How about using status='INACTIVE' and last_call_et > 30 minutes?


Regards
Raj





    
    Denham Eva  
    <[EMAIL PROTECTED]    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>    
    .za> cc:    
    Sent by: Subject: Finding User sessions = idle > 30 min??   
    root@fatcity.   
    com 
    
    
    December 10,    
    2002 08:18 AM   
    Please  
    respond to  
    ORACLE-L    
    
    





Hello All,



Please help - I am trying to find/create a script that will return all user
sessions whose Idle time is greater than 30 minutes.



 ie
    SELECT SID, SERIAL#
    FROM V$SESSION
   " WHERE IDLE_TIME > 30 min;"



My forays into the Documentation and searches have not been very
successful.
I don't really want to do this via the roles IDLE_TIME setting, I very much
would like to be able to query directly to the database.



Based on the information I would then make the decision to kill the user
process etc.
Just in case you might be interested it is Oracle 817 DB on Windows 2k.



Best Regards
Denham Eva
Oracle DBA
"UNIX is basically a simple operating system, but you have to be a genius
to understand the simplicity."
Dennis Ritchie.





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).






DISCLAIMER 

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. TFMC, its holding company, and any of its subsidiaries each reserve 
the right to monitor and manage 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 views of any such entity. 





This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - 
For more information please visit  
  www.marshalsoft

Re: Installing 8.1.7.3 along with 8.1.6.0

[Yechiel Adar]

You can install 8.1.7 on a machine that has 8.1.6.
During the install you can just migrate the database
to 8.1.7 and save all the hassle.

The migration process show you a screen with the 8.1.6 databases
installed on the machine and allow you to choose which one you will
migrate.

This way you do not have to export/import/notify users etc.

Yechiel Adar
Mehish
- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 5:33 AM


Hi,
We have 8.1.6.0 installed on a NT server. There are 2
databases(development of size 120MB when FULL export is done) already
running on the system. Now our requirement is to install 8.1.7.4 and
bring one of the DB into this environment.

My plan of approach is as follows, any feedback, comments are most
welcome:
1) Shutdown all the existing databases
2) Install 8.1.7.3 from cd's and apply 8.1.7.4 patch to bring it to ver
8.1.7.4
3) Bring the 8.1.6 databases UP
4) Create a new database in 8.1.7.4 environment
5) Export the 8.1.6 database and import it into 8.1.7.4's database (I
decided to do it with export as the DB was not very large)
6) Update the devolopers with the new DB's SID and etc. details
7) Drop the 8.1.6 database once devolopers are satisfied with the
8.1.7.4 database

Questions:
1) Are there any ramifications of installing 8.1.7.4 engine on the same
system where 8.1.6 is already present? Obviously in a different home.
2) Database migration in this scenario is done using EXP/IMP. Is this
ok? Why? Any better alternatives?
3) Do I have to really shutdown the databases and other oracle services
before starting the 8.1.7.4 installation?

Thanks,
Venu G.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

Re: passing parameters to a stored procedure from command prompt

[Yechiel Adar]

Use &1 &2 for the parameters passed from the command line.
If you had (test.sql) a script like:

select &1 from dual;
exit;

and you write on the command line:
sqlplus Scott/tiger@db @test.sql 'kuku'

It will become:

select 'kuku' from dual;

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 10:39 AM


>
> Hi all,
>   I am running a batch file through which I am opening SQLPLUS session
> and calling a stored procedure. I want to pass parameters to this
procedure
> from the command prompt. Is it possible? Can anyone on this list will help
> me.
>  Environment is Oracle 8.1.7 and OS Win2k.
>
> Thanx,
> Kranti Pushkarna
>
>
>
>
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information.  If you have
> received it in error, please notify the sender immediately and delete the
> original.  Any other use of the email by you is prohibited.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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.com
-- 
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).

Re: arc destination odd behavior

[Yechiel Adar]

Title: arc destination odd behavior



Hi Lisa
 
We do things a little different her and have no 
problems.
Before backup we run a script that set the archive bit 
on
for all the existing archive logs:
attrib *.* +a (they are written with the archive bit 
off).
after BackupExec finished the backup we do:
del *.* /aa (meaning delete all the files with archive bit 
on only).
 
There are parameters in BackupExec jobs for scripts to run 
before and after the job.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, December 10, 2002 11:15 
  PM
  Subject: arc destination odd 
  behavior
  
  Hi all - 
  8.1.7.2, Windows 2000 sp 2 
  I'm working on my backupexec implementation.  
  For some odd reason the backup job that copies the arclogs to tape and deletes 
  them off the disk (what BE calls an 'archive' job) wants to delete the 
  directory too.  Sometimes the directory is deleted, and sometimes it 
  isn't.  
  So I whip together a perl script to fire after the 
  backup to check for the arc directory and recreate it if it isn't there. 
  
  Well, I expected Oracle to crash if it couldn't 
  find the arc directory.  Instead it wrote to the directory where the arc 
  directory used to reside with a different name.  
  Maybe it's platform specific, but doesn't this seem 
  odd?  I would rather have my db crash if the directory doesn't 
  exist.  My backups would be all hosed because the arclogs wouldn't end up 
  being written to tape properly.  In fact I'm betting that BE will err out 
  when looking for that directory.  
  Here's what I see in v$archived_log.  693 and 
  694 are when the directory still existed.  695+ are after the directory 
  got deleted.  Anyone seen this before?
     693  
  480186148 D:\ORACLE\ORADATA\RMANTST\ARC\RMANTST_00428.ARC   
     
  694  480186151 
  D:\ORACLE\ORADATA\RMANTST\ARC\RMANTST_00429.ARC      695  480268708 
  D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00430.ARC    
     
  696  480268709 
  D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00431.ARC    
     
  697  480268711 
  D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00432.ARC    
     
  698  480268715 
  D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00433.ARC    
     
  699  480268718 
  D:\ORACLE\ORADATA\RMANTST\ARCRMANTST_00434.ARC    
  SQL> select value from v$parameter 
    2  where name = 
  'log_archive_dest'; 
  VALUE - D:\oracle\oradata\rmantst\arc 
  SQL> 
  Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 
  Coconut Creek Parkway Ft. Lauderdale, FL, 
  USA  33063 

Re: OT: Guidelines/Standards for supporting non-oracle

[Justin Cave]

At 02:15 PM 12/10/2002, [EMAIL PROTECTED] wrote:


We are virtually an Oracle shop with 2-3 sql server databases due to
3rd-party software restrictions.
We have been asked about supporting other "small" databases such as
Access,etc within our company.  My question is if
you were asked to support "smaller" databases what
restrictions/guidelines/standards are worth considering?


In addition to conditioning your approval on Mr. Reardon's definition of 
"small", I'd look at a few things:.

1) Data Integrity - Are these small databases going to contain just 
read-only snapshots of data in one of your production databases, or are 
there going to want to manipulate the data.  If they say everything's 
read-only, suggest they can point the Access front-end (or Brio or Crystal 
Reports) at a schema you'd be happy to set up with appropriate views on the 
production tables.  If they say they'll want to write to the production 
database, make sure that there are technical and business processes in 
place to manage this.  Make sure they have answers to questions like "what 
happens when information in Jane's database conflict with information in 
Tom's and neither agrees with Production?" that aren't "won't happen".  At 
this point, I'd be inclined to say that they're developing non-trivial 
applications that would probably be better suited to Oracle (or SQL Server).

2) Data cleaning/ validation - Are there any applications out there that 
clean or validate data in the application, rather than in the database?  I 
suspect there are, and I suspect that getting feeds from other sources that 
don't include these checks will cause massive problems.  I would seriously 
consider outlawing more than read-only access to systems where you could 
potentially insert invalid data.

3) Passwords & privs - Access makes it very easy for a user to accidentally 
overwrite a cell in a grid and modify data.  If users know usernames & 
passwords that have non-read only access to the database, they can 
potentially get themselves into trouble.  Many programmers will grant users 
more privs than they absolutely need and rely on their applications to only 
do reasonable things.  Once users are logging on via Access, they may do 
many unreasonable things, often more by ignorance than spite.
Managing access to data also becomes much more complicated.  It's 
at least possible to ensure that people don't see data they ought not see 
in Oracle (or SQL Server).  Doing the same in Access is much more 
difficult.  Ensuring that no one has access to data in Access that they 
wouldn't have in Oracle is very difficult.

4) Data distribution - No manager wants to have data their organization 
needs being held in dozens of different databases by dozens of other 
organizations.  Often, there's duplication of effort-- often resulting in 
incompatible solutions-- as no one really knows all the data that's 
available.  Centralizing this sort of thing is a lot easier & less 
politically painful up front than years down the line when some VP gets 
upset that the different organizations differ on fundamental things like 
how products are organized or that they can't easily share information 
about what software combinations are certified.

5) Lifecycles - What happens when these "small" systems get popular and 
start growing up.  Inevitably, there will be a few that fill a unique 
niche.  These will get more and more users until the "small" database 
starts to choke.  How will this sort of situation be handled?  Will the 
people that know the small database have the skills to recreate it on 
Oracle (i.e. will they have SQL skills).  Perhaps it's better to bite the 
bullet & teach them SQL to start out.
In addition to product lifecycle, also think about data 
lifecycles.  If there's data in Access that isn't captured in one of your 
production systems, how does that data get identified as sufficiently 
useful to start incorporating into production systems?

If they're looking at "formalizing" reporting systems (i.e. read-only), 
that's probably a good thing.  You may need to bring on some Access/ Brio/ 
Crystal expertise either by diving in or bringing in someone 
experienced.  Most mid-sized organizations could probably have a full-time 
Brio/ Crystal/ Access report writer if they walked around to a few managers 
and asked them about the reports they're assembling by hand now.



Justin Cave
Distributed Database Consulting

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Justin Cave
 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 ma

RE: Finding User sessions = idle > 30 min??

[Naveen Nahata]

Won't 'seconds_in_wait' show the total time waited for the session rather
than the current wait time?

regards
Naveen

-Original Message-
Sent: Tuesday, December 10, 2002 8:05 PM
To: Multiple recipients of list ORACLE-L


Denham - I'm going to make a guess here and someone will probably correct
me. How about
   select sid from v$session_wait where event = 'SQL*Net message from
client' and seconds_in_wait > 1800
You can join to other tables like V$SESSION to get more information.


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

-Original Message-
Sent: Tuesday, December 10, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L



Hello All, 

Please help - I am trying to find/create a script that will return all user
sessions whose Idle time is greater than 30 minutes.

 ie 
SELECT SID, SERIAL# 
FROM V$SESSION 
   " WHERE IDLE_TIME > 30 min;" 

My forays into the Documentation and searches have not been very successful.

I don't really want to do this via the roles IDLE_TIME setting, I very much
would like to be able to query directly to the database.

Based on the information I would then make the decision to kill the user
process etc. 
Just in case you might be interested it is Oracle 817 DB on Windows 2k. 

Best Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 



  _  

DISCLAIMER 



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. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage 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 views of any such entity. 

  _  




  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
 www.marshalsoftware.com 
  _  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  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: Installing 8.1.7.3 along with 8.1.6.0

[Venu Gopal Andem]

Thanks a lot for the info.. Couple of clarifications req...
Will the existing 8.1.6 DB still exist after migration or will it be
changed to 8.1.7.4?
At the time of installation will I have to shutdown the existing DBs??

Thanks,
Venu G.

-Original Message-
Sent: Wednesday, December 11, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L


You can install 8.1.7 on a machine that has 8.1.6.
During the install you can just migrate the database
to 8.1.7 and save all the hassle.

The migration process show you a screen with the 8.1.6 databases
installed on the machine and allow you to choose which one you will
migrate.

This way you do not have to export/import/notify users etc.

Yechiel Adar
Mehish
- Original Message - 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 5:33 AM


Hi,
We have 8.1.6.0 installed on a NT server. There are 2
databases(development of size 120MB when FULL export is done) already
running on the system. Now our requirement is to install 8.1.7.4 and
bring one of the DB into this environment.

My plan of approach is as follows, any feedback, comments are most
welcome:
1) Shutdown all the existing databases
2) Install 8.1.7.3 from cd's and apply 8.1.7.4 patch to bring it to ver
8.1.7.4
3) Bring the 8.1.6 databases UP
4) Create a new database in 8.1.7.4 environment
5) Export the 8.1.6 database and import it into 8.1.7.4's database (I
decided to do it with export as the DB was not very large)
6) Update the devolopers with the new DB's SID and etc. details
7) Drop the 8.1.6 database once devolopers are satisfied with the
8.1.7.4 database

Questions:
1) Are there any ramifications of installing 8.1.7.4 engine on the same
system where 8.1.6 is already present? Obviously in a different home.
2) Database migration in this scenario is done using EXP/IMP. Is this
ok? Why? Any better alternatives?
3) Do I have to really shutdown the databases and other oracle services
before starting the 8.1.7.4 installation?

Thanks,
Venu G.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).


**Disclaimer

Information contained in this E-MAIL being proprietary to Wipro Limited is 
'privileged' and 'confidential' and intended for use only by the individual
 or entity to which it is addressed. You are notified that any use, copying 
or dissemination of the information contained in the E-MAIL in any manner 
whatsoever is strictly prohibited.

***

Re: Increase size of data files and rollback segments

[Jeremiah Wilton]

On Wed, 11 Dec 2002, Yechiel Adar wrote:

> Do not allow your datafile to autoextend across 4GB boundary.
> There is a bug that cause this datafile to be unusable.

I think the 4Gb limit is confined to a handfull of older operating
system versions or older Oracle versions.  For about the last five
years I have been accustomed to creating 16Gb datafiles with no
problem.

Imagine trying to build a 5 terabyte data warehouse out of 1900Mb
datafiles!  It would require 2760 datafiles!

Can anyone confirm that this is no longer a problem after certain
versions of O/S and Oracle?

Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you
specify no size for a datafile, then adds it to the controlfile /data
dictionary in a way that makes it look like it has a ton (like a
terabyte) of free space.  The datafile can't be resized or offline
dropped, and the tablespace must be dropped and recreated (unless you
get the patch).  Let one segment extend into there and watch the
ORA-600s.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Wednesday, December 11, 2002 2:46 AM
> 
> 
> > As a start, look up the following commands in the SQL Reference guide:
> >
> > alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on
> maxsize 20480M;
> > Read up on the implications of autoextend and whether you want it
> >
> > alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M;
> >
> > For rollback datafile - same as any other datafile, eg:
> > alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on
> maxsize 10240M;
> >
> > You may then need to add another rollback segment or increase the max
> extents of an existing one.  eg to add another rollback segment:
> > CREATE PUBLIC ROLLBACK SEGMENT r09_big
> >TABLESPACE rollback
> >STORAGE
> >( minextents 20
> >  INITIAL 10M
> >  NEXT 10M
> >  MAXEXTENTS UNLIMITED)
> >
> > (you would then need to bring this online - eg "alter rollback segment
> r09_big online;")
> >
> >
> > For tempfile (ie LMT temporary tablespaces):
> > alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize
> 10240M;
> >
> > Remember - don't use the exact sizes I've shown - alter to suit your case
> (these were part of a huge load into a new test system)
> >
> >
> > Hope this helps (and willing to learn if some of the above could be
> improved).
> >
> > Regards,
> > Bruce
> >
> > -Original Message-
> > Sent: Wednesday, 11 December 2002 8:15 AM
> >
> > > From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
> > >
> > > Alright guys, just because you know Jeremiah better than me
> > > so you can take
> > > his joke.
> > I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I
> nearly flamed you myself, and I'm just a lowly developer.
> > >  My apology to him as I did not recognize it was a
> > > joke, however
> > > when I am asking for help from the group, I am in a situation
> > > to resolve
> > > problem ASAP and hope to find a answer not a joke.
> > The problem is that if enough people like you refuse to RTFM, then no one
> will want to answer questions because it'll be duller'n your resume.
> > > If you were in my situation, you would understand.
> > I've been in your situation, and been damned ashamed of myself for not
> having researched the question first. It ain't all that hard...
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Reardon, Bruce (CALBBAY)
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 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.com
> -- 
> 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).
> 
> 

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

Fat City Netwo

RE: Finding User sessions = idle > 30 min??

[Jeremiah Wilton]

The last_call_et column of v$session shows the seconds elapsed since
the session last made a database call, regardless of the current wait
event.  This is how I have always identified idle sessions.

And Naveen is right.  The seconds_in_wait column of v$session_wait
shows the actual time spent waiting.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 11 Dec 2002, Naveen Nahata wrote:

> Won't 'seconds_in_wait' show the total time waited for the session rather
> than the current wait time?
> 
> -Original Message-
> Denham - I'm going to make a guess here and someone will probably correct
> me. How about
>select sid from v$session_wait where event = 'SQL*Net message from
> client' and seconds_in_wait > 1800
> You can join to other tables like V$SESSION to get more information.
> 
> -Original Message-
> Please help - I am trying to find/create a script that will return all user
> sessions whose Idle time is greater than 30 minutes.
> 
>  ie 
> SELECT SID, SERIAL# 
> FROM V$SESSION 
>" WHERE IDLE_TIME > 30 min;" 
> 
> My forays into the Documentation and searches have not been very successful.
> 
> I don't really want to do this via the roles IDLE_TIME setting, I very much
> would like to be able to query directly to the database.
> 
> Based on the information I would then make the decision to kill the user
> process etc. 
> Just in case you might be interested it is Oracle 817 DB on Windows 2k. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  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: passing parameters to a stored procedure from command prompt

[Mercadante, Thomas F]

Kranti,

Something like this:


echo exec pl_sql_procedure('%1'); > run.sql
echo exit >> run.sql
%oracle_home%\bin\sqlplus user/pw @run.sql



Hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:39 AM
To: Multiple recipients of list ORACLE-L



Hi all,
  I am running a batch file through which I am opening SQLPLUS session
and calling a stored procedure. I want to pass parameters to this procedure
from the command prompt. Is it possible? Can anyone on this list will help
me.
 Environment is Oracle 8.1.7 and OS Win2k.

Thanx,
Kranti Pushkarna




This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete the
original.  Any other use of the email by you is prohibited.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
Author: Mercadante, Thomas F
  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: passing parameters to a stored procedure from command prompt

[kranti . pushkarna]

Thanx alo Yechiel Adart!! It worked.
Kranti



   

  "Yechiel Adar"   

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

  [EMAIL PROTECTED] Subject: Re: passing parameters to a 
stored procedure from command prompt   
   

   

  12/11/2002 03:39 PM  

  Please respond to

  ORACLE-L 

   

   




Use &1 &2 for the parameters passed from the command line.
If you had (test.sql) a script like:

select &1 from dual;
exit;

and you write on the command line:
sqlplus Scott/tiger@db @test.sql 'kuku'

It will become:

select 'kuku' from dual;

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 10:39 AM


>
> Hi all,
>   I am running a batch file through which I am opening SQLPLUS
session
> and calling a stored procedure. I want to pass parameters to this
procedure
> from the command prompt. Is it possible? Can anyone on this list will
help
> me.
>  Environment is Oracle 8.1.7 and OS Win2k.
>
> Thanx,
> Kranti Pushkarna
>
>
>
>
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information.  If you have
> received it in error, please notify the sender immediately and delete the
> original.  Any other use of the email by you is prohibited.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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.com
--
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).




This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete the
original.  Any other use of the email by you is prohibited.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Increase size of data files and rollback segments

[Yechiel Adar]

Hello Jeremiah

I did some research on metalink and it says:

1) Do not use datafiles more then 4GB on NT systems.
2) There  is a bug on NT, W2K that if you resize datafile (direct command or
autoextend) to 4GB boundary, i.e 4,8,12, then there are two conditions:
2.1) No archive log - database crashes but you can start again and resize
the datafiles.
2.2) Archive log - restore and regenerate to a point in time prior before
the resize.
 This bug was reported also on 9.2.

The work around is to resize to 4.1, 8.1 GB datafiles.

Bug number 1668488.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 12:54 PM


> On Wed, 11 Dec 2002, Yechiel Adar wrote:
>
> > Do not allow your datafile to autoextend across 4GB boundary.
> > There is a bug that cause this datafile to be unusable.
>
> I think the 4Gb limit is confined to a handfull of older operating
> system versions or older Oracle versions.  For about the last five
> years I have been accustomed to creating 16Gb datafiles with no
> problem.
>
> Imagine trying to build a 5 terabyte data warehouse out of 1900Mb
> datafiles!  It would require 2760 datafiles!
>
> Can anyone confirm that this is no longer a problem after certain
> versions of O/S and Oracle?
>
> Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you
> specify no size for a datafile, then adds it to the controlfile /data
> dictionary in a way that makes it look like it has a ton (like a
> terabyte) of free space.  The datafile can't be resized or offline
> dropped, and the tablespace must be dropped and recreated (unless you
> get the patch).  Let one segment extend into there and watch the
> ORA-600s.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Wednesday, December 11, 2002 2:46 AM
> >
> >
> > > As a start, look up the following commands in the SQL Reference guide:
> > >
> > > alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend
on
> > maxsize 20480M;
> > > Read up on the implications of autoextend and whether you want it
> > >
> > > alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize
10240M;
> > >
> > > For rollback datafile - same as any other datafile, eg:
> > > alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on
> > maxsize 10240M;
> > >
> > > You may then need to add another rollback segment or increase the max
> > extents of an existing one.  eg to add another rollback segment:
> > > CREATE PUBLIC ROLLBACK SEGMENT r09_big
> > >TABLESPACE rollback
> > >STORAGE
> > >( minextents 20
> > >  INITIAL 10M
> > >  NEXT 10M
> > >  MAXEXTENTS UNLIMITED)
> > >
> > > (you would then need to bring this online - eg "alter rollback segment
> > r09_big online;")
> > >
> > >
> > > For tempfile (ie LMT temporary tablespaces):
> > > alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on
maxsize
> > 10240M;
> > >
> > > Remember - don't use the exact sizes I've shown - alter to suit your
case
> > (these were part of a huge load into a new test system)
> > >
> > >
> > > Hope this helps (and willing to learn if some of the above could be
> > improved).
> > >
> > > Regards,
> > > Bruce
> > >
> > > -Original Message-
> > > Sent: Wednesday, 11 December 2002 8:15 AM
> > >
> > > > From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
> > > >
> > > > Alright guys, just because you know Jeremiah better than me
> > > > so you can take
> > > > his joke.
> > > I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I
> > nearly flamed you myself, and I'm just a lowly developer.
> > > >  My apology to him as I did not recognize it was a
> > > > joke, however
> > > > when I am asking for help from the group, I am in a situation
> > > > to resolve
> > > > problem ASAP and hope to find a answer not a joke.
> > > The problem is that if enough people like you refuse to RTFM, then no
one
> > will want to answer questions because it'll be duller'n your resume.
> > > > If you were in my situation, you would understand.
> > > I've been in your situation, and been damned ashamed of myself for not
> > having researched the question first. It ain't all that hard...
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Reardon, Bruce (CALBBAY)
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 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

RE: OT: Guidelines/Standards for supporting non-oracle

[Whittle Jerome Contr NCI]

Title: RE: OT: Guidelines/Standards for supporting non-oracle






Yechiel,


Access 1 had a limit of 100MB. Access 97 had a limitation of 1GB per mdb file. Newer versions are up to 2GB per mdb file. There are ways around it like compacting or splitting the database into multiple MDB files. Of course more detailed discussion should be on Access-L.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   Yechiel Adar [SMTP:[EMAIL PROTECTED]]


I do not know if this was a configuration error or something that is built into access but some time ago a package based on access stopped working. We found out that the access database got to 1GB size and stopped growing so they could not insert new data into it.

 

Yechiel Adar
Mehish

Re: RMAN framework.

[Ruth Gramolini]

Joe,

I will give it a try.  I use oem to schedule unix jobs for backups to disc
and do an OS copy to tape.
If it can help me with this, I can try it out.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 2:45 PM


hello all,

Is there anyone who has written a front end(unix is all i'm looking at now)
for using RMAN?

I've got a ~50 shell script framework written for doing RMAN backups to/from
disk, catalog maintenance, control file backups, archive log backups, some
of the report commands.

I'm looking for a few beta testers of it(of course its freeware so no
warranties implied, and all of that legal mumbo jumbo).

to be released as source shell scripts via GPL.

Any takers want to help me with it.

I've got the programs, all internall documented and am working on external
document now.

If interested please email [EMAIL PROTECTED]

joe


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: "Memory issues" on HPUX --- docs on MetaLink

[Hemant K Chitale]

In my emails of the last two days I had mentioned that I had compiled a
list of docs on Metalink.

If you'd like to see the docs, I've placed them at
http://hkchital.tripod.com/HPUX_Notes_from_Oracle.zip

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
 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 9i installation - Basic Qs - HELP!

[Hemant K Chitale]

Is "clientip" the Unix server or or [Windows] client ?
If it is the Unix server, you need to run "xhost
+"
e.g. if you have logged in to the Unix server through a
telnet session and set DISPLAY=client:0.0, prior to
do so, you must run "xhost +clientip" from your Unix server

X console.
If "clientip" is your Windows client, you must be running
Reflection X [or eXceed ?] on your PC --- I am talking of
the X-server program, not the telnet client.
Hemant
At 11:01 AM 10-12-02 -0800, you wrote:
Guys, 

I followed the instructions but still got: 
Xlib: connection to "clientip:0.0" refused by server    
Xlib: Client is not authorized to connect to Server    
xhost:  unable to open display "clientip:0.0"   
I think I am missing one of the e-mails.  Tried running to root, changing exceed configuration (xfile).  Do I need to just do this at console?

-Original Message- 
From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 27, 2002 4:24 AM 
To: Multiple recipients of list ORACLE-L 
Subject: RE: Oracle 9i installation - Basic Qs 
Agreed Jared. I was playing the percentages for the sake of a quick, clear 
answer. In my experience most of the time it's going to be root. 

Cheers, 
Mike 
-Original Message- 
Sent: 26 November 2002 17:44 
To: Multiple recipients of list ORACLE-L 
Mike, 
Not necessarily. 

It depends on who started the Xsession. 

I regularly run 'xhost' on my workstation as a non-root user. 
Root is unable to do so on the same machine. 
Jared 


"Hately, Mike (NESL-IT)" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 11/26/2002 07:54 AM 
 Please respond to ORACLE-L 
  
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
    cc: 
    Subject:    RE: Oracle 9i installation - Basic Qs 
Hi, 
you'll need to be signed in as root in order to run the "xhost +" command. 
The rest of that looks fine so : 
as root : 
  xhost + 
as oracle_user : 
  export DISPLAY=:0.0 
  xclock    (to test yopur X config) 
NB Exceed has its own array of bugs when used with the Oracle installer. 
Good luck and I hope the 9i instaler handles Exceed better. 
regards, 
Mike Hately 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Hately, Mike (NESL-IT) 
  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). 

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  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: Daily job to populate table in another database

[Hemant K Chitale]

Catherine,
No, SNPs, per-se don't degrade the performance.  What would be at issue is
what job you are actually running.  Treat it just like any user session 
connecting
to the database and firing off the procedure/package/sql-statements defined
in the job.

I am using DBMS_JOB in 8.1.7.2 and 8.1.7.3 instances.  The only problem
I've had is with a job to sync an Intermedia Index in Oracle iFS through 
DBMS_JOB
-- there seems to be a memory leak [this is 8.1.7.3 on Solaris].  I had a TAR
open for a couple of weeks.  The analyst agreed with me that the issue would
be more of an Intermedia Index problem rather than DBMS_JOB.  Once the
list of docs pending indexing (or rather index-syncing) grew too large, the
SNP process would crash frequently.  I changed the Index DEFAULT_MEMORY
and MAX_MEMORY parameters and began running optimize frequently
on the Intermedia Index and the DBMS_JOB stopped dying -- but it's process
size kept growing slowly.  I know manually kill the SNP process in that
particular instance every few days [Oracle Development, as I had a Bug
logged for this issue, wanted me to upgrade to 8.1.7.4 and try to simulate
the issue.  I didn't have time and the resources to clone and upgrade my 
35GB production
database to 8.1.7.4 and left it at that.  The Support analyst agreed that
as my "workaround"  [increasing the Intermedia Index Memory parameters
and periodically killing the SNP process] was working he could close the
TAR and Bug.

Hemant

At 05:04 PM 10-12-02 -0800, you wrote:
Hi Hemant,

Thanks for the tips.

Does anyone know whether SNP process .ie. DBMS_JOB will degrade the database
performance ? Please advise. Thanks.

Regds,
New Bee

This communication (including any attachment) is meant only for the
recipient(s) named above and may contain confidential or legally privileged
information. If you are not an intended recipient, this communication has
been sent to you in error and you must delete all copies of this
communication from your computer system and notify the sender immediately by
reply email. Unauthorised use, disclosure, dissemination, distribution,
retention, copying or reliance on this communication is prohibited and may
attract civil and/or criminal penalties. Thank you.

-Original Message-
From:   Hemant K Chitale [mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, December 10, 2002 11:04 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Daily job to populate table in another
database


See Note #1068369.6  on MetaLink.

Hemant
At 01:28 AM 10-12-02 -0800, you wrote:
>Hi Gurus,
>
>If you need to copy data (after some manipulations) from
database A to
>another table in database B, how do you achieve that ?
>Our current practice is to use crontab (schedule daily job)
and sqlplus
>(procedure to copy the data over to another database via
dblink).
>
>Do you think it's more efficient to use DBMS_JOB ? Can
DBMS_JOB call the
>procedure at the same time daily ? Any sample? Please
advise. Thanks.
>
>Regds,
>new bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
  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).


Hemant K Chitale
My web site page is :  http://hkchital.tripod.com


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
 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: Guidelines/Standards for supporting non-oracle databases

[DENNIS WILLIAMS]

Rick - Since you didn't say how these Access databases are populated, I will
assume that they may be stand-alone, i.e. not necessarily associated with
your Oracle/SQL Server databases. 
   My immediate reaction is that this is a "political" type of question.
That is, somebody thinks this would be potentially useful. Usually IS
management is astute enough to ward off these ideas, realizing that their
valuable (expensive) IS talent would be frittered away on less important
projects. But sometimes you get a new IS manager that thinks this would be a
cool way to make his group seem more valuable to the business groups. Here
are some ideas:
   1. To your IS management, offer your willingness to be as helpful as
possible. Ask for training in Access. Ask for a breakdown of the ratio of
your time you should spend on these databases versus Access.
   2. Suggest that the PC techs should cover this area, but offer to be a
second-level resource to them (with training, of course).
   3. Offer to put on a class in database design. Usually the problems
encountered with Access databases occur because of ignorance.
   4. Suggest the power users be sent to Access class.
Like most organizations, our policy toward Access is the same as Excel,
Word, etc. Our PC techs will install it, but past that the users are on
their own. As an Oracle DBA, I know nothing about Access, that's my story
and I'm sticking to it.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, December 10, 2002 3:15 PM
To: Multiple recipients of list ORACLE-L


Hi,

We are virtually an Oracle shop with 2-3 sql server databases due to
3rd-party software restrictions.
We have been asked about supporting other "small" databases such as
Access,etc within our company.  My question is if
you were asked to support "smaller" databases what
restrictions/guidelines/standards are worth considering?
Be kind-constructive answers only :-)

Thanks
Rick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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.com
-- 
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).

RE: RMAN framework.

[Orr, Steve]

Title: RE: RMAN framework.





> If interested please email [EMAIL PROTECTED]
I got undeliverable errors on this.


I've got the beginnings of a shell script (bash/bourne/korn) "front end" to RMAN. It handles just a few contingencies but I never took it the next step to make it a complete "framework" so I'd be glad to give yours a spin.


Steve Orr
Bozeman, Montana




-Original Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 6:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RMAN framework.



Joe,


I will give it a try.  I use oem to schedule unix jobs for backups to disc
and do an OS copy to tape.
If it can help me with this, I can try it out.


Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 2:45 PM



hello all,


Is there anyone who has written a front end(unix is all i'm looking at now)
for using RMAN?


I've got a ~50 shell script framework written for doing RMAN backups to/from
disk, catalog maintenance, control file backups, archive log backups, some
of the report commands.


I'm looking for a few beta testers of it(of course its freeware so no
warranties implied, and all of that legal mumbo jumbo).


to be released as source shell scripts via GPL.


Any takers want to help me with it.


I've got the programs, all internall documented and am working on external
document now.


If interested please email [EMAIL PROTECTED]


joe



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: passing parameters to a stored procedure from command prompt

[Yechiel Adar]

HTH, But your cut & paste still need some help :-)

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 2:19 PM


>
>
> Thanx alo Yechiel Adart!! It worked.
> Kranti
>
>
>
>
>   "Yechiel Adar"
>   <[EMAIL PROTECTED]>To:  Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>   Sent by: cc:
>   [EMAIL PROTECTED] Subject: Re: passing
parameters to a stored procedure from command prompt
>
>
>   12/11/2002 03:39 PM
>   Please respond to
>   ORACLE-L
>
>

>
>
>
> Use &1 &2 for the parameters passed from the command line.
> If you had (test.sql) a script like:
>
> select &1 from dual;
> exit;
>
> and you write on the command line:
> sqlplus Scott/tiger@db @test.sql 'kuku'
>
> It will become:
>
> select 'kuku' from dual;
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Wednesday, December 11, 2002 10:39 AM
>
>
> >
> > Hi all,
> >   I am running a batch file through which I am opening SQLPLUS
> session
> > and calling a stored procedure. I want to pass parameters to this
> procedure
> > from the command prompt. Is it possible? Can anyone on this list will
> help
> > me.
> >  Environment is Oracle 8.1.7 and OS Win2k.
> >
> > Thanx,
> > Kranti Pushkarna
> >
> >
> >
> >
> > This message is for the designated recipient only and may contain
> > privileged, proprietary, or otherwise private information.  If you have
> > received it in error, please notify the sender immediately and delete
the
> > original.  Any other use of the email by you is prohibited.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > 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.com
> --
> 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).
>
>
>
>
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information.  If you have
> received it in error, please notify the sender immediately and delete the
> original.  Any other use of the email by you is prohibited.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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.com
-- 
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).

RE: Oracle 9i installation - Basic Qs - HELP!

[Paula_Stankus]

Apparently there are some problems running eXceed and Oracle 9i V2 Oracle 
installer.  I went back to using a Xwindows from a Unix console to do the 
install.  Now I am trying to find a way to run dbca from Windows for Unix 
database - must be a way - huh.

  -Original Message-From: Hemant K Chitale 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 
  9:54 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle 9i installation - Basic Qs - HELP!Is 
  "clientip" the Unix server or or [Windows] client ?If it is the Unix 
  server, you need to run "xhost 
  +"e.g. if you have 
  logged in to the Unix server through atelnet session and set 
  DISPLAY=client:0.0, prior todo so, you must run "xhost +clientip" from 
  your Unix server X console.If "clientip" is your Windows client, 
  you must be runningReflection X [or eXceed ?] on your PC --- I am talking 
  ofthe X-server program, not the telnet client.HemantAt 11:01 
  AM 10-12-02 -0800, you wrote:
  Guys, 
I followed the instructions but still got: 
Xlib: connection to "clientip:0.0" refused by 
server    Xlib: Client is not 
authorized to connect to Server    
xhost:  unable to open display 
"clientip:0.0"   
I think I am missing one of the e-mails.  Tried 
running to root, changing exceed configuration (xfile).  Do I need to 
just do this at console?-Original 
Message- From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 27, 2002 4:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9i installation - Basic Qs Agreed Jared. I was playing the percentages for the sake of a quick, 
clear answer. In my experience most of the time it's 
going to be root. Cheers, Mike -Original Message- 
Sent: 26 November 2002 17:44 To: 
Multiple recipients of list ORACLE-L Mike, Not necessarily. 
It depends on who started the Xsession. 
I regularly run 'xhost' on my workstation as a 
non-root user. Root is unable to do so on the 
same machine. Jared 
"Hately, Mike (NESL-IT)" 
<[EMAIL PROTECTED]> Sent by: 
[EMAIL PROTECTED]  11/26/2002 07:54 AM 
 Please respond to ORACLE-L       
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>     cc:     
Subject:    RE: Oracle 9i 
installation - Basic Qs Hi, you'll need to be signed in as root in order to run the "xhost +" 
command. The rest of that looks fine so : 
as root :   xhost + 
as oracle_user :   export 
DISPLAY=:0.0   
xclock    (to test yopur X config) NB Exceed has its own array of bugs when used with the Oracle 
installer. Good luck and I hope the 9i instaler 
handles Exceed better. regards, Mike Hately -- Please 
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) 
  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). 
  Hemant K ChitaleMy web site page is :  http://hkchital.tripod.com-- Please see the 
  official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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: Recovery Scenarios

[Ruth Gramolini]

All you have to do is drop a couple of tables and try to get them back.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 7:00 PM


Hi,

Could you please suggest me how to corrupt a data file, for testing
recovery.

I am trying to test Block Recovery with my Personal Oracle 9i on Windows Me.
I am not able to open or overwrite the files because oracle.exe locks them.

Thanks, Krishna



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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).

SQLPLUS spool file question

[Willett, Mark]

Title: SQLPLUS spool file question





I'm creating a spool file of SQL commands based on several "select...from" statements.  When I "vi" my output file, I see a "^L" character as the first character after each of my select statements.  I remember a solution being presented a few years ago that allowed you to eliminate the "^L" on this list but I've managed to loose it.  I seem to remember that you must use silent mode (-s) and the proper setting of several of the SQLPlus environment variables.  Any help would be appreciated

Mark Willett
Sunnen Products Company

RE: archiving redo logs

[Stephen Lee]

After the subconscious worked on this a bit, a solution that I should have
thought of, right at the beginning, popped into my head.  Unix has a
wonderful utility called rdist that is intended for just this sort of thing.
If you read the man page, it will talk about a distfile which contains
commands for the utility.  I rarely use a distfile, and when I do, I have to
re-read the man page s-l-o-w-l-y to relearn the syntax for the distfile.  I
usually use rdist to copy an entire directory tree to another box.  A
command for this is:

cd /directory/to/copy
rdist -wc * other_box:/where/to/copy

The spiffy thing about rdist is that it will only copy what is new or has
been updated on the source box.  By default, I think the decision about what
to update is done on the basis of time, but you can tell rdist to perform a
binary comparison of files -- a process I think would be a bit time
consuming for large files.

In the case of your archived logs, this would certainly work, but I think
rdist would try to copy any archive that was currently being written.  I
don't think this would be a problem since, at the next invocation, it would
detect that the log that was being written at the previous invocation has
been updated and would copy it again.  However, if you wanted to avoid this,
you could do something like:

 go.ksh --

#!/usr/bin/ksh

## Check that we can rsh to the other box.
rsh other_box '/usr/bin/date' > /dev/null 2>&1
if [ $? -ne 0 ]; then
echo "Something broke"
exit 1
fi

cd /the/source/directory

COUNT=0
for FILE in `ls -1t *.xyz 2> /dev/null`; do

COUNT=$(( $COUNT + 1 ))
if [ $COUNT -gt 2 ]; then
rdist -wc $FILE other_box:/the/destination/directory
fi

done



The script will attempt to rdist all but the most recent two archived logs
(adjust this in the "if" condition).  Any logs that have already been copied
will not get copied again, so this will save you from trying to keep track
of that (although, when I was thinking about this, one solution for doing
that would be to create a soft link to point to last file you copied in the
previous invocation).

You will need to have a .rhosts file set up on the other box to use rdist.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  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: Recovery Scenarios

[Stephen Lee]

-Original Message-
Could you please suggest me how to corrupt a data file, for testing
recovery.
--

How corrupt do you want the file to be?

vi the file?
copy /usr/bin/ksh on top of the file.  That ought to corrupt it real good!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  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: STATSPACK

[Eriovaldo Andrietta]

Title: RE: STATSPACK



 
Friends :
 
What does it mean : STATSPACK ?
 
Regards 
 
Eriovaldo
 
 
 

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, December 09, 2002 3:24 
  PM
  Subject: RE: STATSPACK
  
  Wow that does sound way 
  cool  Thanks for sending this Barbara. 
  
-Original Message- From:   Barbara Baker [SMTP:[EMAIL PROTECTED]] Sent:   Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject:    Re: STATSPACK 
Seema: 
Head to Tim Gorman's site ( www.evdbt.com 
) and 
find his sppurpkg.sql download.  It uses dbms_jobs to run with a purge 
each set number of days. 
It's really slick. 
Barb 
 Seema Singh 
<[EMAIL PROTECTED]> wrote: 


  HiHow to clean all old STATSPACK 
  data?Thx-Seema_STOP 
  MORE SPAM with the new MSN 8 and get 2 months FREE*http://join.msn.com/?page=features/junkmail--Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com--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] (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 
  comm! and for other information (like 
subscribing).
  _ Do you Yahoo!?Yahoo! 
Mail Plus  - Powerful. Affordable. Sign up now 

Is the personal version of RH 8.0 good for Oracle 9.2?

[Khedr, Waleed]

Thanks

Waleed
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  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: STATSPACK

[Naveen Nahata]

Title: RE: STATSPACK



Now 
this is going to get some real cruel answers i know :-)
 
 

  -Original Message-From: Eriovaldo Andrietta 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 
  9:45 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: STATSPACK
   
  Friends :
   
  What does it mean : STATSPACK ?
   
  Regards 
   
  Eriovaldo
   
   
   
  
- Original Message - 
From: 
Koivu, Lisa 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, December 09, 2002 3:24 
PM
Subject: RE: STATSPACK

Wow that does sound way 
cool  Thanks for sending this Barbara. 

  -Original Message- From:   Barbara Baker [SMTP:[EMAIL PROTECTED]] Sent:   Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject:    Re: STATSPACK 
  Seema: 
  Head to Tim Gorman's site ( www.evdbt.com 
  ) and find his sppurpkg.sql download.  It uses dbms_jobs 
  to run with a purge each set number of days. 
  It's really slick. 
  Barb 
   Seema Singh 
  <[EMAIL PROTECTED]> 
  wrote: 
  
HiHow to clean all old STATSPACK 
data?Thx-Seema_STOP 
MORE SPAM with the new MSN 8 and get 2 months FREE*http://join.msn.com/?page=features/junkmail--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--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] (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 comm! and for other information (like 
subscribing).
    _ Do you Yahoo!?Yahoo! Mail Plus  - Powerful. Affordable. Sign up now 

Re: Is the personal version of RH 8.0 good for Oracle 9.2?

[Lyndon Tiu]

Why not?

-- 
Lyndon Tiu


Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>:

> Thanks
> 
> Waleed
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Khedr, Waleed
>   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.com
-- 
Author: Lyndon Tiu
  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: STATSPACK

[Farnsworth, Dave]

Title: RE: STATSPACK



I 
think it's a new way of packaging beer.  Either that or it's an Oracle 
tuning utility.  I like the beer idea better though.
 
Dave

  -Original Message-From: Eriovaldo Andrietta 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 
  10:15 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: STATSPACK
   
  Friends :
   
  What does it mean : STATSPACK ?
   
  Regards 
   
  Eriovaldo
   
   
   
  
- Original Message - 
From: 
Koivu, Lisa 
To: Multiple 
recipients of list ORACLE-L 
Sent: Monday, December 09, 2002 3:24 
PM
Subject: RE: STATSPACK

Wow that does sound way 
cool  Thanks for sending this Barbara. 

  -Original Message- From:   Barbara Baker [SMTP:[EMAIL PROTECTED]] Sent:   Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject:    Re: STATSPACK 
  Seema: 
  Head to Tim Gorman's site ( www.evdbt.com 
  ) 
  and find his sppurpkg.sql download.  It uses dbms_jobs to run with a 
  purge each set number of days. 
  It's really slick. 
  Barb 
   Seema Singh 
  <[EMAIL PROTECTED]> 
  wrote: 
  
HiHow to clean all old STATSPACK 
data?Thx-Seema_STOP 
MORE SPAM with the new MSN 8 and get 2 months FREE*http://join.msn.com/?page=features/junkmail--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--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] (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 comm! and for other information (like 
subscribing).
    _ Do you Yahoo!?Yahoo! Mail Plus  - Powerful. Affordable. Sign up now 

RE: SQLPLUS spool file question

[DENNIS WILLIAMS]

Mark - A control-L is an ASCII form feed, if that helps. You could use the
Unix command "tr" to remove them.


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

-Original Message-
Sent: Wednesday, December 11, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L



I'm creating a spool file of SQL commands based on several "select...from"
statements.  When I "vi" my output file, I see a "^L" character as the first
character after each of my select statements.  I remember a solution being
presented a few years ago that allowed you to eliminate the "^L" on this
list but I've managed to loose it.  I seem to remember that you must use
silent mode (-s) and the proper setting of several of the SQLPlus
environment variables.  Any help would be appreciated

Mark Willett
Sunnen Products Company


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

RE: STATSPACK

[DENNIS WILLIAMS]

Eriovaldo - STATSPACK is Oracle's new utility to replace utlbstat/utlestat.
Available in Oracle8i and upwards. If you are using Oracle8i or Oracle9i,
you should learn about STATSPACK. It is included in your Oracle, so you may
as well make use of it. Let me know if you are interested in more
information.



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

-Original Message-
Sent: Wednesday, December 11, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L


 
Friends :
 
What does it mean : STATSPACK ?
 
Regards 
 
Eriovaldo
 
 
 

- Original Message - 
To: Multiple   recipients of list ORACLE-L 
Sent: Monday, December 09, 2002 3:24 PM


Wow that does sound way cool  Thanks for sending this Barbara. 

-Original Message- 
Sent:   Monday, December 09, 2002 12:04 PM 
To: Multiple recipients of list ORACLE-L 

Seema: 

Head to Tim Gorman's site ( www.evdbt.com   <
http://www.evdbt.com  >) and find his sppurpkg.sql
download.  It uses dbms_jobs to run with a purge each set number of days. 

It's really slick. 

Barb 

 Seema Singh <[EMAIL PROTECTED]> wrote: 

Hi
How to clean all old STATSPACK data?
Thx
-Seema





_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
 
--
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 comm! and for other information (like subscribing).




  _ 

Do you Yahoo!?
Yahoo! Mail Plus <
http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com
 > - Powerful.
Affordable. Sign up now <
http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com
 >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

RE: STATSPACK

[Farnsworth, Dave]

Title: RE: STATSPACK



Read, 
Read, and Read some more.  Her is a good link to get you 
going.
 
http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html
 
Dave

  -Original Message-From: Eriovaldo Andrietta 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 
  10:15 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: STATSPACK
   
  Friends :
   
  What does it mean : STATSPACK ?
   
  Regards 
   
  Eriovaldo
   
   
   
  
- Original Message - 
From: 
Koivu, Lisa 
To: Multiple 
recipients of list ORACLE-L 
Sent: Monday, December 09, 2002 3:24 
PM
Subject: RE: STATSPACK

Wow that does sound way 
cool  Thanks for sending this Barbara. 

  -Original Message- From:   Barbara Baker [SMTP:[EMAIL PROTECTED]] Sent:   Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject:    Re: STATSPACK 
  Seema: 
  Head to Tim Gorman's site ( www.evdbt.com 
  ) 
  and find his sppurpkg.sql download.  It uses dbms_jobs to run with a 
  purge each set number of days. 
  It's really slick. 
  Barb 
   Seema Singh 
  <[EMAIL PROTECTED]> 
  wrote: 
  
HiHow to clean all old STATSPACK 
data?Thx-Seema_STOP 
MORE SPAM with the new MSN 8 and get 2 months FREE*http://join.msn.com/?page=features/junkmail--Please 
see the official ORACLE-L FAQ: http://www.orafaq.com--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] (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 comm! and for other information (like 
subscribing).
    _ Do you Yahoo!?Yahoo! Mail Plus  - Powerful. Affordable. Sign up now 

RE: SQLPLUS spool file question

[Vergara, Michael (TEM)]

Title: SQLPLUS spool file question



Mark:
 
Here is what I usually set in a SQL*Plus script where I 
will
want to spool the output:
   set echo off pause off termout on feedback 
on   set pagesize 55 linesize 95 tab off trimspool on
 
I rarely use 'sqlplus -s', and I do not get the '^L'
character in my spool files.  I also have a shell script 

that I use to trim off excess spaces and ^L 
characters
from other folk's scripts.  Here it is:
 
#!/usr/bin/ksh
# This is for HP-UX ksh.
mv ${1} trim.tempif [ $? != 0 ] ;  then  echo 
''  echo Error opening ${1} for move  echo 
Aborting...  echo ''  exitfi#/ /' | sed '1,$s/ 
*$//g' > ${1}rm trim.temp
 
#   #EOF#
HTH,
Mike
 
 
 

  -Original Message-From: Willett, Mark 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 8:04 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  SQLPLUS spool file question
  I'm creating a spool file of SQL commands based on several 
  "select...from" statements.  When I "vi" my output file, I see a "^L" 
  character as the first character after each of my select statements.  I 
  remember a solution being presented a few years ago that allowed you to 
  eliminate the "^L" on this list but I've managed to loose it.  I seem to 
  remember that you must use silent mode (-s) and the proper setting of several 
  of the SQLPlus environment variables.  Any help would be 
  appreciated
  Mark WillettSunnen Products 
Company

RE: SQLPLUS spool file question

[Vergara, Michael (TEM)]

D'Oh!  I saw Mark's original message say '^L', and my brain
read that as '^M'!  The '^L' comes from the value of NEWPAGE.
"Set NEWPAGE 0" is what adds the '^L';  "set newpage n" makes
SQL*Plus throw 'n' linefeeds between pages.

Sorry 'bout any confusion!

Mike

-Original Message-
Sent: Wednesday, December 11, 2002 8:54 AM
To: Multiple recipients of list ORACLE-L


Mark - A control-L is an ASCII form feed, if that helps. You could use the
Unix command "tr" to remove them.


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

-Original Message-
Sent: Wednesday, December 11, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L



I'm creating a spool file of SQL commands based on several "select...from"
statements.  When I "vi" my output file, I see a "^L" character as the first
character after each of my select statements.  I remember a solution being
presented a few years ago that allowed you to eliminate the "^L" on this
list but I've managed to loose it.  I seem to remember that you must use
silent mode (-s) and the proper setting of several of the SQLPlus
environment variables.  Any help would be appreciated

Mark Willett
Sunnen Products Company


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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: STATSPACK

[Orr, Steve]

Title: RE: STATSPACK



I 
think it's a special ESPN package (right Raj?) where you get a six pack and all 
the statistics for major league baseball on a CDROM... or was that Ari who had 
the baseball stats?
 
Steve
 

  -Original Message-From: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 
  11, 2002 9:39 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: STATSPACK
  I 
  think it's a new way of packaging beer.  Either that or it's an Oracle 
  tuning utility.  I like the beer idea better though.
   
  Dave
  
-Original Message-From: Eriovaldo Andrietta 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 
10:15 AMTo: Multiple recipients of list 
ORACLE-LSubject: Re: STATSPACK
 
Friends :
 
What does it mean : STATSPACK 
?
 
Regards 
 
Eriovaldo
 
 
 

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, December 09, 2002 3:24 
  PM
  Subject: RE: STATSPACK
  
  Wow that does sound way 
  cool  Thanks for sending this Barbara. 
  
-Original Message- 
From:   Barbara Baker [SMTP:[EMAIL PROTECTED]] 
Sent:   Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L 
Subject:    
Re: STATSPACK 
Seema: 
Head to Tim Gorman's site ( www.evdbt.com ) 
and find his sppurpkg.sql download.  It uses dbms_jobs to run with 
a purge each set number of days. 
It's really slick. 
Barb 
 Seema Singh 
<[EMAIL PROTECTED]> 
wrote: 

  HiHow to clean all old STATSPACK 
  data?Thx-Seema_STOP 
  MORE SPAM with the new MSN 8 and get 2 months FREE*http://join.msn.com/?page=features/junkmail--Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com--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] (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 comm! and for other information (like 
  subscribing).
  
_ Do you 
Yahoo!?Yahoo! Mail Plus 
 - Powerful. Affordable. Sign up now 

Re: STATSPACK

[Joan Hsieh]

I remember that I delete from stats$snapshot where snap_time < sysdate
-? works too.

Joan

Yechiel Adar wrote:
> 
> Simple.
> run statsdrp and statscre.
> 
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Monday, December 09, 2002 6:14 PM
> 
> > Hi
> > How to clean all old STATSPACK data?
> > Thx
> > -Seema
> >
> >
> >
> >
> >
> > _
> > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > 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).
> >
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  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: STATSPACK

[Weaver, Walt]

Title: RE: STATSPACK



Ayup. 
I go to the store every Friday afternoon and pick up a statspack of Stroh's 
Lite.
 
--Walt 
Weaver
  
Bozeman, Montana

  -Original Message-From: Farnsworth, Dave 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 
  11, 2002 9:39 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: STATSPACK
  I 
  think it's a new way of packaging beer.  Either that or it's an Oracle 
  tuning utility.  I like the beer idea better though.
   
  Dave
  
-Original Message-From: Eriovaldo Andrietta 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 
10:15 AMTo: Multiple recipients of list 
ORACLE-LSubject: Re: STATSPACK
 
Friends :
 
What does it mean : STATSPACK 
?
 
Regards 
 
Eriovaldo
 
 
 

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, December 09, 2002 3:24 
  PM
  Subject: RE: STATSPACK
  
  Wow that does sound way 
  cool  Thanks for sending this Barbara. 
  
-Original Message- 
From:   Barbara Baker [SMTP:[EMAIL PROTECTED]] 
Sent:   Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L 
Subject:    
Re: STATSPACK 
Seema: 
Head to Tim Gorman's site ( www.evdbt.com ) and find his sppurpkg.sql download.  It uses dbms_jobs 
to run with a purge each set number of days. 
It's really slick. 
Barb 
 Seema Singh 
<[EMAIL PROTECTED]> 
wrote: 

  HiHow to clean all old STATSPACK 
  data?Thx-Seema_STOP 
  MORE SPAM with the new MSN 8 and get 2 months FREE*http://join.msn.com/?page=features/junkmail--Please 
  see the official ORACLE-L FAQ: http://www.orafaq.com--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] (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 comm! and for other information (like 
  subscribing).
  
_ Do you 
Yahoo!?Yahoo! Mail Plus 
 - Powerful. Affordable. Sign up now 

RE: Is the personal version of RH 8.0 good for Oracle 9.2?

[Khedr, Waleed]

Any limitations on the personal version or lack of features that exist in
the pro/advanced server version that will impact Oracle.

-Original Message-
Sent: Wednesday, December 11, 2002 11:37 AM
To: [EMAIL PROTECTED]; Khedr, Waleed


Why not?

-- 
Lyndon Tiu


Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>:

> Thanks
> 
> Waleed
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Khedr, Waleed
>   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.com
-- 
Author: Khedr, Waleed
  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: STATSPACK

[DENNIS WILLIAMS]

If you are on 8.1.6, that is pretty much what you have to do. I check the
snap_id's first, since the delete can run a LONG time per row.

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


-Original Message-
Sent: Wednesday, December 11, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L


I remember that I delete from stats$snapshot where snap_time < sysdate
-? works too.

Joan

Yechiel Adar wrote:
> 
> Simple.
> run statsdrp and statscre.
> 
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Monday, December 09, 2002 6:14 PM
> 
> > Hi
> > How to clean all old STATSPACK data?
> > Thx
> > -Seema
> >
> >
> >
> >
> >
> > _
> > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > 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).
> >
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  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.com
-- 
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).

RE: Recovery Scenarios

[DENNIS WILLIAMS]

Stephen - I don't think that will work on Windows. I don't work on Windows,
but I recall someone saying that Oracle locks the file while it is used.

Ruth - If you drop a table, I don't think a recovery will be automatically
triggered. You'd probably need to do a TSPITR, and I'm not sure that was the
question.


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


-Original Message-
Sent: Wednesday, December 11, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L



-Original Message-
Could you please suggest me how to corrupt a data file, for testing
recovery.
--

How corrupt do you want the file to be?

vi the file?
copy /usr/bin/ksh on top of the file.  That ought to corrupt it real good!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  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.com
-- 
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).

Active sessions chewing up a huge amount of RAM

[Jeremy Pulcifer]

Title: Active sessions chewing up a huge amount of RAM





I have a customer that is reporting that each of the connections our Weblogic appserver uses is using something on the order of 100+MB of RAM on the db server, ostentatiously the Snnn processes are frickin' HUGE. I've never seen that kind of issue, and not real comfortable vouching for the accuracy of this, but I gotta at least ask:

Is there some setting/confluence of circumstances where this is even remotely sensical?


Thanks... We're dealing with Oracle 8.1.6, Weblogic 5.1, running on NT 4.0.

RE: Is the personal version of RH 8.0 good for Oracle 9.2?

[Lyndon Tiu]

The biggest impact to Oracle will be the available glibc libraries which Oracle
uses. These ibraries are all pretty much standard in all recent Linux distros. I
have Oracle 9.2i on RH 8.0 and Mandrake 9.0 and things look fine to me.

Personal version is simply a reference to the packaging. Everything is still in
there. Whatever that's not in there you can down load from www.rpmfind.net

-- 
Lyndon Tiu


Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>:

> Any limitations on the personal version or lack of features that exist in
> the pro/advanced server version that will impact Oracle.
> 
> -Original Message-
> Sent: Wednesday, December 11, 2002 11:37 AM
> To: [EMAIL PROTECTED]; Khedr, Waleed
> 
> 
> Why not?
> 
> -- 
> Lyndon Tiu
> 
> 
> Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>:
> 
> > Thanks
> > 
> > Waleed
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Khedr, Waleed
> >   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.com
> -- 
> Author: Khedr, Waleed
>   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.com
-- 
Author: Lyndon Tiu
  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: Recovery Scenarios

[Yechiel Adar]

Hello Krishna
 
I just tried to open a datafile using textpad and got 
sharing violation.
I tried opening using notepad and it worked.
 
For obvious reasons (not trying to test recovery) I did 
not change and save the file with notepad.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Krishna 
  Rao Kakatur 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, December 11, 2002 2:00 
  AM
  Subject: Recovery Scenarios
  
  Hi,
   
  Could you please suggest me how to corrupt a data 
  file, for testing recovery.
   
  I am trying to test Block Recovery with my 
  Personal Oracle 9i on Windows Me. I am not able to open or overwrite the files 
  because oracle.exe locks them.
   
  Thanks, 
Krishna

RMAN Reporting?

[Walter K]

Is there no way to produce a report from the RMAN 
views/tables that lists the date and duration of the 
backups for each database? I have pored through the RC 
views and can produce such a report at the backup set 
level but not at the database level.

Am I missing something? Any suggestions?

Thanks.
-w

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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: STATSPACK

[Orr, Steve]

Title: RE: STATSPACK





There's some cascade delete action going on but you can start by deleting the dependent child rows and work your way up. Reverse-engineering the statspack datamodel with an ER diagramming tool is cool.


Steve Orr
Bozeman, Montana



-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: STATSPACK



If you are on 8.1.6, that is pretty much what you have to do. I check the
snap_id's first, since the delete can run a LONG time per row.


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



-Original Message-
Sent: Wednesday, December 11, 2002 11:19 AM
To: Multiple recipients of list ORACLE-L



I remember that I delete from stats$snapshot where snap_time < sysdate
-? works too.


Joan


Yechiel Adar wrote:
> 
> Simple.
> run statsdrp and statscre.
> 
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Monday, December 09, 2002 6:14 PM
> 
> > Hi
> > How to clean all old STATSPACK data?
> > Thx
> > -Seema
> >
> >
> >
> >
> >
> > _
> > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > 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).
> >
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  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.com
-- 
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).

RE: Active sessions chewing up a huge amount of RAM

[Jesse, Rich]

How big is the SGA?  On Unix at least, each DB process appears to be taking
a huge chunk'o'virtual memory (as seen from Glance on HP/UX), but in reality
most of that is just the shared mem of the SGA.  I don't know how that would
look on NT, though...

Just a thought.

Rich

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

-Original Message-
Sent: Wednesday, December 11, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


I have a customer that is reporting that each of the connections our
Weblogic appserver uses is using something on the order of 100+MB of RAM on
the db server, ostentatiously the Snnn processes are frickin' HUGE. I've
never seen that kind of issue, and not real comfortable vouching for the
accuracy of this, but I gotta at least ask:
Is there some setting/confluence of circumstances where this is even
remotely sensical? 
Thanks... We're dealing with Oracle 8.1.6, Weblogic 5.1, running on NT 4.0. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: STATSPACK

[Yechiel Adar]

You may be right if you want to delete part of the accumulated stats.
He asked about removing ALL the old stats.
Drop and recreate seems to me a good and fast way.

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


> If you are on 8.1.6, that is pretty much what you have to do. I check the
> snap_id's first, since the delete can run a LONG time per row.
> 
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> 
> -Original Message-
> Sent: Wednesday, December 11, 2002 11:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I remember that I delete from stats$snapshot where snap_time < sysdate
> -? works too.
> 
> Joan
> 
> Yechiel Adar wrote:
> > 
> > Simple.
> > run statsdrp and statscre.
> > 
> > Yechiel Adar
> > Mehish
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Monday, December 09, 2002 6:14 PM
> > 
> > > Hi
> > > How to clean all old STATSPACK data?
> > > Thx
> > > -Seema
> > >
> > >
> > >
> > >
> > >
> > > _
> > > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > > http://join.msn.com/?page=features/junkmail
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > 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).
> > >
> > 
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > 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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Joan Hsieh
>   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.com
> -- 
> 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).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

RE: Active sessions chewing up a huge amount of RAM

[Jeremy Pulcifer]

Title: RE: Active sessions chewing up a huge amount of RAM





> From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
> 
> 
> How big is the SGA?


Dunno specifics, but it's on the order of a gig.


>  On Unix at least, each DB process 
> appears to be taking
> a huge chunk'o'virtual memory (as seen from Glance on HP/UX), 
> but in reality
> most of that is just the shared mem of the SGA.


Ahhh...


I misspoke, this is on Solaris (too many customers on too many different platforms); the appserver is on NT, but that isn't relavent. This may be the (non)issue; it at least is a fun story to try and float over to the customer...

They've not reported actual "problems", and this customer has been whining pretty hard about us opening a buncha connections and caching them (Weblogic does this pretty well in my experience; however old client-server trained DBA's freak out).

RE: Is the personal version of RH 8.0 good for Oracle 9.2?

[Khedr, Waleed]

Sounds good. Will do.

Thanks,

Waleed

-Original Message-
Sent: Wednesday, December 11, 2002 1:00 PM
To: Multiple recipients of list ORACLE-L


The biggest impact to Oracle will be the available glibc libraries which
Oracle
uses. These ibraries are all pretty much standard in all recent Linux
distros. I
have Oracle 9.2i on RH 8.0 and Mandrake 9.0 and things look fine to me.

Personal version is simply a reference to the packaging. Everything is still
in
there. Whatever that's not in there you can down load from www.rpmfind.net

-- 
Lyndon Tiu


Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>:

> Any limitations on the personal version or lack of features that exist in
> the pro/advanced server version that will impact Oracle.
> 
> -Original Message-
> Sent: Wednesday, December 11, 2002 11:37 AM
> To: [EMAIL PROTECTED]; Khedr, Waleed
> 
> 
> Why not?
> 
> -- 
> Lyndon Tiu
> 
> 
> Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>:
> 
> > Thanks
> > 
> > Waleed
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Khedr, Waleed
> >   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.com
> -- 
> Author: Khedr, Waleed
>   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.com
-- 
Author: Lyndon Tiu
  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.com
-- 
Author: Khedr, Waleed
  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).

ora-01031 error

[Darlene Marley]

Hi Folks,

Forgive me if this is a stupid question, but I've consulted the esteem
manuals and my brain appears to be dysfunctional today.

I'm trying to create some views from within a package of stored
procedures using dynamic sql.  If I run the scripts in sqlplus all is
well.  If I try it inside a package of stored procedures using execute
immediate I get the ORA 01031 insufficient privs error.  All objects
addressed are owned by the schema authoring and executing the package of
stored procedures.  What am I missing?

Thanks,
D

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Darlene Marley
  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 Reporting?

[Ruth Gramolini]

Did you try running a query against rman.bp.  It has a column called
completion_time.

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


> Is there no way to produce a report from the RMAN
> views/tables that lists the date and duration of the
> backups for each database? I have pored through the RC
> views and can produce such a report at the backup set
> level but not at the database level.
>
> Am I missing something? Any suggestions?
>
> Thanks.
> -w
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Walter K
>   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.com
-- 
Author: Ruth Gramolini
  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: Active sessions chewing up a huge amount of RAM

[Khedr, Waleed]

Title: Active sessions chewing up a huge amount of RAM



In 
many O/S the more SGA blocks the Oracle processes touch, the bigger amount of 
memory gets reported in use.
 
So 
it's not private memory it's usually the SGA memory.
 
You 
have to use a good tool to diagnose memory issues ( I think there is memtool for 
Solaris).
 
Waleed

  -Original Message-From: Jeremy Pulcifer 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 
  2002 12:39 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Active sessions chewing up a huge amount of 
  RAM
  I have a customer that is reporting that each of the 
  connections our Weblogic appserver uses is using something on the order of 
  100+MB of RAM on the db server, ostentatiously the Snnn processes are frickin' 
  HUGE. I've never seen that kind of issue, and not real comfortable vouching 
  for the accuracy of this, but I gotta at least ask:
  Is there some setting/confluence of circumstances where this 
  is even remotely sensical? 
  Thanks... We're dealing with Oracle 8.1.6, Weblogic 5.1, 
  running on NT 4.0. 

RE: RMAN Reporting?

[DENNIS WILLIAMS]

Walter - Can you explain your goal in a little more detail? RMAN has some
standard reports for listing the date of backups. What do you mean by
duration? The time interval that RMAN was backing up your data? I doubt that
RMAN stores that, probably just the completion time.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


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


Is there no way to produce a report from the RMAN 
views/tables that lists the date and duration of the 
backups for each database? I have pored through the RC 
views and can produce such a report at the backup set 
level but not at the database level.

Am I missing something? Any suggestions?

Thanks.
-w

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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.com
-- 
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).

RE: Active sessions chewing up a huge amount of RAM

[DENNIS WILLIAMS]

Jeremy - How many connections is Weblogic creating? I'm also wondering what
the SQL looks like. Is it possible your transactions are very large (not
committing often enough)? Are you using Oracle MTS?


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

-Original Message-
Sent: Wednesday, December 11, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L



I have a customer that is reporting that each of the connections our
Weblogic appserver uses is using something on the order of 100+MB of RAM on
the db server, ostentatiously the Snnn processes are frickin' HUGE. I've
never seen that kind of issue, and not real comfortable vouching for the
accuracy of this, but I gotta at least ask:

Is there some setting/confluence of circumstances where this is even
remotely sensical? 

Thanks... We're dealing with Oracle 8.1.6, Weblogic 5.1, running on NT 4.0. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

RE: RMAN Reporting?

[Stephen Lee]

Perhaps looking at the last update time on the log files?
And I assume you know what time the backup started ... ?

> Is there no way to produce a report from the RMAN
> views/tables that lists the date and duration of the
> backups for each database?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  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-01031 error

[Mercadante, Thomas F]

Darlene,

Make sure the schema running the package has the "Create View" priv directly
assigned to it (not thru a role - even the DBA role).

this should clear it up.  (I sound like a doctor!)

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 11, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L


Hi Folks,

Forgive me if this is a stupid question, but I've consulted the esteem
manuals and my brain appears to be dysfunctional today.

I'm trying to create some views from within a package of stored
procedures using dynamic sql.  If I run the scripts in sqlplus all is
well.  If I try it inside a package of stored procedures using execute
immediate I get the ORA 01031 insufficient privs error.  All objects
addressed are owned by the schema authoring and executing the package of
stored procedures.  What am I missing?

Thanks,
D

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Darlene Marley
  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.com
-- 
Author: Mercadante, Thomas F
  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: Is the personal version of RH 8.0 good for Oracle 9.2?

[Yechiel Adar]

In a seminar about three months ago they told us that the advance server
version does not contain anything that you can not put together yourself by
downloading and compiling.

But - this is a lot of hard work.

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


> Any limitations on the personal version or lack of features that exist in
> the pro/advanced server version that will impact Oracle.
>
> -Original Message-
> Sent: Wednesday, December 11, 2002 11:37 AM
> To: [EMAIL PROTECTED]; Khedr, Waleed
>
>
> Why not?
>
> --
> Lyndon Tiu
>
>
> Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>:
>
> > Thanks
> >
> > Waleed
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Khedr, Waleed
> >   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.com
> --
> Author: Khedr, Waleed
>   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.com
-- 
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).

Re: ora-01031 error

[Igor Neyman]

If, "All objects addressed are owned by the schema authoring and executing
the package", then my guess,
it should have to do something with granting privileges (like "create any
view") directly to schema owner (not through role).

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 2:00 PM


> Hi Folks,
>
> Forgive me if this is a stupid question, but I've consulted the esteem
> manuals and my brain appears to be dysfunctional today.
>
> I'm trying to create some views from within a package of stored
> procedures using dynamic sql.  If I run the scripts in sqlplus all is
> well.  If I try it inside a package of stored procedures using execute
> immediate I get the ORA 01031 insufficient privs error.  All objects
> addressed are owned by the schema authoring and executing the package of
> stored procedures.  What am I missing?
>
> Thanks,
> D
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Darlene Marley
>   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.com
-- 
Author: Igor Neyman
  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 Reporting?

[Walter K]

Sure. If I have three databases (AAA, BBB and CCC), I 
would like to see a report that says database AAA was 
backed up on 10-DEC-2002 starting at 21:00 and ended 
at 23:07.

I can produce such a report if AAA was ONLY backed up 
once for a given day but not if it was backed up 
multiple times in a day. 

This seems like a pretty basic report a lot of people 
would want but it doesn't look like the schema was 
designed with much in the way of reporting/trending in 
mind.

Thanks.
-w


--- Original Message ---
To: Multiple recipients of list ORACLE-L 

>Walter - Can you explain your goal in a little more 
detail? RMAN has some
>standard reports for listing the date of backups. 
What do you mean by
>duration? The time interval that RMAN was backing up 
your data? I doubt that
>RMAN stores that, probably just the completion time.
>Dennis Williams
>DBA, 40%OCP
>Lifetouch, Inc.
>[EMAIL PROTECTED] 
>
>
>-Original Message-
>Sent: Wednesday, December 11, 2002 12:11 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Is there no way to produce a report from the RMAN 
>views/tables that lists the date and duration of the 
>backups for each database? I have pored through the 
RC 
>views and can produce such a report at the backup set 
>level but not at the database level.
>
>Am I missing something? Any suggestions?
>
>Thanks.
>-w
>
>-- 
>Please see the official ORACLE-L FAQ: 
http://www.orafaq.com
>-- 
>Author: Walter K
>  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.com
>-- 
>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).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walter K
  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-01031 error

[Ruth Gramolini]

Whatevcer user running the package does not have the rught privileges to run
the sql.  Try giving that user more privileges.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 2:00 PM


> Hi Folks,
>
> Forgive me if this is a stupid question, but I've consulted the esteem
> manuals and my brain appears to be dysfunctional today.
>
> I'm trying to create some views from within a package of stored
> procedures using dynamic sql.  If I run the scripts in sqlplus all is
> well.  If I try it inside a package of stored procedures using execute
> immediate I get the ORA 01031 insufficient privs error.  All objects
> addressed are owned by the schema authoring and executing the package of
> stored procedures.  What am I missing?
>
> Thanks,
> D
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Darlene Marley
>   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.com
-- 
Author: Ruth Gramolini
  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 Reporting?

[Walter K]

Yes. The completion_time is available for the backup 
piece (BP) and the backup set (BS) but not for the 
entire backup. That would be fine if there was a way 
of relating the "pieces" or "sets" to a single backup 
but I see no way of doing this.


--- Original Message ---
To: Multiple recipients of list ORACLE-L 

>Did you try running a query against rman.bp.  It has 
a column called
>completion_time.
>
>Ruth
>- Original Message -
>To: "Multiple recipients of list ORACLE-L" 
>Sent: Wednesday, December 11, 2002 1:11 PM
>
>
>> Is there no way to produce a report from the RMAN
>> views/tables that lists the date and duration of the
>> backups for each database? I have pored through the 
RC
>> views and can produce such a report at the backup 
set
>> level but not at the database level.
>>
>> Am I missing something? Any suggestions?
>>
>> Thanks.
>> -w
>>
>> --
>> Please see the official ORACLE-L FAQ: 
http://www.orafaq.com
>> --
>> Author: Walter K
>>   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.com
>-- 
>Author: Ruth Gramolini
>  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.com
-- 
Author: Walter K
  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: Active sessions chewing up a huge amount of RAM

[Jeremy Pulcifer]

Title: RE: Active sessions chewing up a huge amount of RAM





> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
> 
> 
> Jeremy - How many connections is Weblogic creating?


20-30 per appserver. 4 appservers.


> Are you using Oracle MTS?


No. At least they're not supposed to be.


> I'm also 
> wondering what
> the SQL looks like. Is it possible your transactions are very 
> large (not
> committing often enough)?


The transactional data isn't real significant, however there is a huge amount of selects that the OO structures (poorly designed, I might add) query, and the reports use a funky system of "temporary tables" that are never committed. So, the SGA and PGA get pretty worked; there's not a great deal of data involved, however, so it's usually a matter of getting enough CPU's on the db, and (to a lesser extent) enough RAM.

Thanks...

RE: RMAN Reporting?

[Walter K]

I agree. I can get what I want by looking at time 
stamps on log files, grepping, etc. but that can be a 
lot of work to put together. I have a need to do some 
trending analysis and was expecting that I could get 
this info out of the RMAN tables but it's looking like 
that's just wishful thinking.

-w

--- Original Message ---
To: Multiple recipients of list ORACLE-L 

>
>Perhaps looking at the last update time on the log 
files?
>And I assume you know what time the backup 
started ... ?
>
>> Is there no way to produce a report from the RMAN
>> views/tables that lists the date and duration of the
>> backups for each database?
>-- 
>Please see the official ORACLE-L FAQ: 
http://www.orafaq.com
>-- 
>Author: Stephen Lee
>  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.com
-- 
Author: Walter K
  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).

Netbackup 4.5 Oracle Agent on Windows 2000 Cluster/Oracle Failsaf

[Panicker, Thankam S.]

Hi All

I am trying to create a template on a Oracle Failsafe Database
using Netbackup 4.5 Oracle Agent GUI. I try expanding the
database node and after I enter the username and password I get the 
ora-12514 error. I am at a loss. I can tnsping the database and also connect
to it using sql*plus. Do you have to do anything special to make netbackup
connect to a clustered  database.

I have Netbackup working on non-clustered databases.

TIA
Sumathy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Panicker, Thankam S.
  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).

Netbackup 4.5 Oracle Agent on Windows 2000 Cluster/Oracle Failsaf

[Panicker, Thankam S.]

Hi All

I am trying to create a template on a Oracle Failsafe Database
using Netbackup 4.5 Oracle Agent GUI. I try expanding the
database node and after I enter the username and password I get the 
ora-12514 error. I am at a loss. I can tnsping the database and also connect
to it using sql*plus. Do you have to do anything special to make netbackup
connect to a clustered  database.

I have Netbackup working on non-clustered databases.

TIA
Sumathy


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Panicker, Thankam S.
  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).

Function-based Index

[Cherie_Machler]

I have the following statement that I would like to create a function-based
index for:

SELECT MIN(tran_dt)
FROM ach_tran
WHERE cnfr_no = :b1


I'd like the index to include columns cnfr_no and tran_dt (in that order).
The examples I've seen are
just single-column indexes.   Is it possible to have this  additional
column in a function-based index that
is not involved in the actual function?   If yes, what would the index
creation statement look like?

This is version 9.2.0.1 on Sun Solaris 2.6.


Thanks in advance for any assistance.

Cherie Machler
Gelco DBA


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

Alteon and Oracle

[David Turner]

Would someone send me some pointers to using load balancers such as and Alteon
and Oracle for serving up primarily readonly data?

Thanks, Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Turner
  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).

Common PL/SQL package to truncate tables

[Thomas Jeff]

Title: Common PL/SQL package to truncate tables





We have a DSS database containing numerous datamarts, each stored in it's own schema.
Each datamart schema has a corresponding OPS$ batch account, which does the ETL work.   
DML privs on all tables within a schema are granted to a {schema}_LOAD_ROLE, which
in turn is granted to the pertinent batch account.  


Previously, each schema has it's own copy of a common utilty package, which provided
among other things, a routine to truncate a specified table.   The batch account would
call this routine to perform all truncates.   As the number of datamarts grew it started 
becoming a pain to maintain and compile the same package in multiple schemas.


So,  the idea is to use a database-wide common utility package which would be compiled 
under a DBA ID, with execute granted to the OPS$ batch accounts.   This package's truncate 
routine would verify a truncate request by checking the calling USER against DBA_ROLE_PRIVS 
to ensure it had the requisite {schema}_LOAD_ROLE for the {schema}.table_name passed as
a parameter.


Any security holes or caveats with this idea?   Or maybe a more elegant way to accomplish this?


Thanks.



Jeffery D Thomas
DBA
Thomson Information Services
Thomson, Inc.


Email: [EMAIL PROTECTED]


Indy DBA Master Documentation available at:
http://gkmqp.tce.com/tis_dba
Select 'Indy DBA' then 'DBA Web Pages'

ora_sql_txt system defined event attribute

[Casey Dyke]

Title: ora_sql_txt system defined event attribute





hiya folks,


just curious whether anyone is successfully using this attribute w/servererror trigger to capture the sql for a failed transaction -- say for a 1555 error?

it would appear to be new to 9i as i can see it in the doco for 9.2 and not 8i.  furthermore, the event is simply not defined in dbms_system w/in my 8i rdbms/admin dir (dbmsstdx.sql/dbmstrig.sql).

after an admittedly brief faff about w/v$session/v$open_cursor & prev_sql_addr/prev_hash_value in 8i (ie: not this fancy new function) it would appear that i capture code from the servererror trigger itself (say something like 'select userenv('sessionid') ...) - rather than the offending sql code.  not exactly what i am looking for. but maybe i ain't working hard enough ...

also, how many out there use dbms_system.ksdwrt in prod?  works fine in dev for me ...


cheers,


casey ...

sql with bind variable in stored procedure doesnt use stored outlines

[orafaq]

All,
 
I am unable to make stored outlines work for sql 
statements with bind variable in stored procedures. Please see following sample 
code and tell me what am I doing wrong.
 
Thanks in Advance
 
create table emp (num number,sal number);insert 
into emp values(1,1); create or replace procedure t(num_i number) 
astotal number;cursor c1(p1 number) is select sal from emp where 
num=p1;beginfor i in c1(num_i) 
looptotal:=total+i.sal;dbms_output.put_line('total salary is 
$'||total);end loop;end;/ alter session set 
sql_trace=true;exec t(1);alter session set 
sql_trace=false; create outline on select sal from emp where 
num=:b1;select used from dba_outlines;
 
alter session set 
QUERY_REWRITE_ENABLED=true;alter session set 
STAR_TRANSFORMATION_ENABLED=true;alter session set 
use_stored_outlines=true;exec t(2);select used from 
dba_outlines;
 
variable b1 number;exec :b1:=1;select sal 
from emp where num=:b1;select used from dba_outlines;
 
Thanks
Shaleen

RE: Increase size of data files and rollback segments

[Reardon, Bruce (CALBBAY)]

Yechiel,

Thanks for pointing out the potential issues with autoextending onto an exact 4 Gb 
boundary (as I forgot to include them).

Reading the bug you referenced (at 
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_id=1668488)
it says:
"...
Does not reproduce on 8.1.7 Sun Solaris. 
...
Rediscovery Information:  Resize a datafile file to [exactly] 4GB, 8G, 12G, 16G, etc.
After resizing a datafile to 4G, alter system checkpoint was failing with ORA-27069
...
This fix is in 8.1.7.4.1 and 9.0.1.4.0 but not in 9.2.0.2.1"

I am on 8.1.7.4.5 and so am not affected by this issue - I can't remember the version 
the original poster was on.

Anyone using 817x may also want to check note 120607.1 
(http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=120607.1)
titled "Support Status and Alerts for Oracle8i Release 3 (8.1.7.X)" for information on 
this and other issues.

This refers you to Note 148894.1 
(http://metalink.oracle.com/metalink/plsql/showdoc?db=Not&id=148894.1)
titled "ALERT: Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 
Platforms"

This contains the information "...  A fix is now available in 8.1.7.1.4  
and will be included in8.1.7.3  ..."

For general Oracle information on 2Gb files see 
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=62427.1&p_database_id=NOT
titled "2Gb or not 2Gb - File limits in Oracle".
This contains links to other notes with Port specific information.

I hope this helps.

Regards,
Bruce Reardon


-Original Message-
Sent: Wednesday, 11 December 2002 11:19 PM

Hello Jeremiah

I did some research on metalink and it says:

1) Do not use datafiles more then 4GB on NT systems.
2) There  is a bug on NT, W2K that if you resize datafile (direct command or
autoextend) to 4GB boundary, i.e 4,8,12, then there are two conditions:
2.1) No archive log - database crashes but you can start again and resize
the datafiles.
2.2) Archive log - restore and regenerate to a point in time prior before
the resize.
 This bug was reported also on 9.2.

The work around is to resize to 4.1, 8.1 GB datafiles.

Bug number 1668488.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 12:54 PM


> On Wed, 11 Dec 2002, Yechiel Adar wrote:
>
> > Do not allow your datafile to autoextend across 4GB boundary.
> > There is a bug that cause this datafile to be unusable.
>
> I think the 4Gb limit is confined to a handfull of older operating
> system versions or older Oracle versions.  For about the last five
> years I have been accustomed to creating 16Gb datafiles with no
> problem.
>
> Imagine trying to build a 5 terabyte data warehouse out of 1900Mb
> datafiles!  It would require 2760 datafiles!
>
> Can anyone confirm that this is no longer a problem after certain
> versions of O/S and Oracle?
>
> Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you
> specify no size for a datafile, then adds it to the controlfile /data
> dictionary in a way that makes it look like it has a ton (like a
> terabyte) of free space.  The datafile can't be resized or offline
> dropped, and the tablespace must be dropped and recreated (unless you
> get the patch).  Let one segment extend into there and watch the
> ORA-600s.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Wednesday, December 11, 2002 2:46 AM
> >
> >
> > > As a start, look up the following commands in the SQL Reference guide:
> > >
> > > alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend
on
> > maxsize 20480M;
> > > Read up on the implications of autoextend and whether you want it
> > >
> > > alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize
10240M;
> > >
> > > For rollback datafile - same as any other datafile, eg:
> > > alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on
> > maxsize 10240M;
> > >
> > > You may then need to add another rollback segment or increase the max
> > extents of an existing one.  eg to add another rollback segment:
> > > CREATE PUBLIC ROLLBACK SEGMENT r09_big
> > >TABLESPACE rollback
> > >STORAGE
> > >( minextents 20
> > >  INITIAL 10M
> > >  NEXT 10M
> > >  MAXEXTENTS UNLIMITED)
> > >
> > > (you would then need to bring this online - eg "alter rollback segment
> > r09_big online;")
> > >
> > >
> > > For tempfile (ie LMT temporary tablespaces):
> > > alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on
maxsize
> > 10240M;
> > >
> > > Remember - don't use the exact sizes I've shown - alter to suit your
case
> > (these were part of a huge load into a new test system)
> > >
> > >
> > > Hope this helps (and willing to learn if some of the above could be
> > improved).
> > >
> > > Regards,
> > > Bruce

Re: Common PL/SQL package to truncate tables

[Paul Baumgartel]

What about creating the package with invoker rights?  I haven't checked
to see whether there are restrictions that might apply here, but it
seems like a natural.  The success of the procedure's execution would
depend on the invoker having the required privileges.


--- Thomas Jeff <[EMAIL PROTECTED]> wrote:
> We have a DSS database containing numerous datamarts, each stored in
> it's
> own schema.
> Each datamart schema has a corresponding OPS$ batch account, which
> does the
> ETL work.   
> DML privs on all tables within a schema are granted to a
> {schema}_LOAD_ROLE,
> which
> in turn is granted to the pertinent batch account.  
> 
> Previously, each schema has it's own copy of a common utilty package,
> which
> provided
> among other things, a routine to truncate a specified table.   The
> batch
> account would
> call this routine to perform all truncates.   As the number of
> datamarts
> grew it started 
> becoming a pain to maintain and compile the same package in multiple
> schemas.
> 
> So,  the idea is to use a database-wide common utility package which
> would
> be compiled 
> under a DBA ID, with execute granted to the OPS$ batch accounts.  
> This
> package's truncate 
> routine would verify a truncate request by checking the calling USER
> against
> DBA_ROLE_PRIVS 
> to ensure it had the requisite {schema}_LOAD_ROLE for the
> {schema}.table_name passed as
> a parameter.
> 
> Any security holes or caveats with this idea?   Or maybe a more
> elegant way
> to accomplish this?
> 
> Thanks.
> 
> 
> Jeffery D Thomas
> DBA
> Thomson Information Services
> Thomson, Inc.
> 
> Email: [EMAIL PROTECTED]
> 
> Indy DBA Master Documentation available at:
> http://gkmqp.tce.com/tis_dba
> Select 'Indy DBA' then 'DBA Web Pages'
> 
> 
> 
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Function-based Index

[Babu Nagarajan]

why would you want to create function based index on a column that you are
not using in the where clause.

for your sql statement a index on cnfr_no would work great...

babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 11, 2002 4:09 PM


>
> I have the following statement that I would like to create a
function-based
> index for:
>
> SELECT MIN(tran_dt)
> FROM ach_tran
> WHERE cnfr_no = :b1
>
>
> I'd like the index to include columns cnfr_no and tran_dt (in that order).
> The examples I've seen are
> just single-column indexes.   Is it possible to have this  additional
> column in a function-based index that
> is not involved in the actual function?   If yes, what would the index
> creation statement look like?
>
> This is version 9.2.0.1 on Sun Solaris 2.6.
>
>
> Thanks in advance for any assistance.
>
> Cherie Machler
> Gelco DBA
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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.com
-- 
Author: Babu Nagarajan
  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: Common PL/SQL package to truncate tables

[Babu Nagarajan]

Title: Common PL/SQL package to truncate tables



Of the top of my head, 
there is a way where you can run a procedure under the invoker's rights rather 
than the procedure owner's rights. if u create it that way, you need not bother 
checking if the user who is calling the procedure has the rights to truncate the 
table - oracle will do it for you
 
babu

  - Original Message - 
  From: 
  Thomas Jeff 

  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, December 11, 2002 4:23 
  PM
  Subject: Common PL/SQL package to 
  truncate tables
  
  We have a DSS database containing numerous 
  datamarts, each stored in it's own schema. Each datamart schema has a corresponding OPS$ batch account, which does 
  the ETL work.   DML privs 
  on all tables within a schema are granted to a {schema}_LOAD_ROLE, 
  which in turn is granted to the 
  pertinent batch account.  
  Previously, each schema has it's own copy 
  of a common utilty package, which provided among other things, a routine to truncate a specified 
  table.   The batch account would call this routine to perform all truncates.   As the number 
  of datamarts grew it started becoming a pain to maintain and compile the same package in multiple 
  schemas. 
  So,  the idea is to use a 
  database-wide common utility package which would be compiled under a DBA ID, with execute granted to the OPS$ 
  batch accounts.   This package's truncate routine would verify a truncate request by checking 
  the calling USER against DBA_ROLE_PRIVS to ensure it had the requisite {schema}_LOAD_ROLE for the 
  {schema}.table_name passed as a 
  parameter. 
  Any security holes or caveats with this 
  idea?   Or maybe a more elegant way to accomplish this? 
  Thanks. 
   Jeffery D Thomas DBA Thomson Information 
  Services Thomson, Inc. 
  Email: [EMAIL PROTECTED] 
  Indy DBA Master Documentation available 
  at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages' 
   

RE: Single-task message waits

[Jesse, Rich]

After filing a TAR on this, Oracle Support says "It's Internal...out of
user's control."  The problem with that response is that the 75-minute
process is spending 30 minutes waiting for "single-task message" according
to my grep'ing and SQL*Loading of waits of the 10046 traces.  Aside from
that, I've got a 10-minute wait on "db file sequential read", which for
various reasons, I think I'm stuck with.  The 30 minutes isn't really that
bad, except this load needs to run 24 times (one for each month in the past
two years).

If I ever meet the genius who decided to bury key G/L data in a free-format
CHAR column...  :\

Rich


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


> -Original Message-
> From: Jesse, Rich 
> Sent: Wednesday, December 04, 2002 2:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Single-task message waits
> 
> 
> Hey Cary,
> 
> No magic bullet?  I was afraid you were going to say that.  :)
> 
> I see that there are some parsing issues from the first of many 10046
> traces.  Most of these high-parsing statements are generated 
> by Oracle when
> a Context index is used in a query.  The good news, if TKPROF 
> output can be
> believed, is that the total time spent in all parses is 35 
> seconds out of 52
> minutes elapsed, so I hadn't planned on spending any more time here.
> 
> As for the one-row-at-a-time manipulation part, well...  
> Implicit cursors
> within cursors within cursors.  We've removed a few where we 
> could, but
> unfortunately a rewrite probably isn't going to happen for 
> this project.
> We're still learning to be good SQL coders while dealing with 
> crappy data
> layouts from the 80s.
> 
> Thanks for your input!  And thanks for the 10046 paper on 
> hotsos.com!  :)
> Rich
> 
> 
> Rich Jesse   System/Database Administrator
> [EMAIL PROTECTED]  Quad/Tech International, 
> Sussex, WI USA
> 
> > -Original Message-
> > From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, December 04, 2002 12:54 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Single-task message waits
> > 
> > 
> > Rich,
> > 
> > Well, at least we've cleared up the "whether." Now the 
> > question turns to
> > the "why."
> > 
> > Once you have identified a program's dominant response time 
> > contributor,
> > solving any optimization problem degenerates to a very simple 
> > strategy:
> > 
> > 1. Reduce the number of times the dominant contributor's 
> services are
> > required.
> > 2. Reduce the duration per service call of the dominant contributor.
> > 
> > I expect that #2 will be difficult to do in this case, because I'd
> > expect that the single-task driver is probably the fastest 
> conceivable
> > way that two pieces of client-server code can communicate 
> > (they're after
> > all in the same executable). Your leverage is probably #1. 
> > It's the old
> > adage:
> > 
> > Q: What's the fastest way to do X?
> > 
> > A: Don't.
> > 
> > Find out whether your process is making more database calls than it
> > needs to be making. Investigate the usual suspects: SQL that 
> > doesn't use
> > bind variables and therefore has to be parsed more often than 
> > it should
> > be parsed, one-row-at-a-time manipulation instead of using 
> arrays and
> > bulk features, and so on.
> > 
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> > 
> > Upcoming events:
> > - Hotsos Clinic, Dec 9-11 Honolulu
> > - Hotsos Clinic 101, Jan 7-9 Knoxville
> > - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
> > - 2003 Hotsos Symposium, Feb 9-12 Dallas
> > 
> > 
> > -Original Message-
> > Rich
> > Sent: Wednesday, December 04, 2002 10:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > Hey Cary,
> > 
> > "Yes" and "Yes".  Which brings me back to my original 
> > question:  How do
> > I go
> > about tracking down "single-task message" waits?
> > 
> > Thanks!
> > Rich
> > 
> > 
> > Rich Jesse   System/Database Administrator
> > [EMAIL PROTECTED]  Quad/Tech International, 
> > Sussex, WI
> > USA
> > 
> > > -Original Message-
> > > From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, December 04, 2002 10:14 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Single-task message waits
> > > 
> > > 
> > > If...
> > > 
> > > 1) you're collecting time consumption data for ONLY the 
> > > session you care
> > > about, AND
> > > 
> > > 2) you're collecting the data for a time interval [t0,t1] 
> > > that includes
> > > ONLY response time that you care about eliminating,
> > > 
> > > ...then the waits are worth investigating.
> > > 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San

RE: Function-based Index

[Whittle Jerome Contr NCI]

Title: RE: Function-based Index






Cherie,


AFAIK, a plain old index works just fine with Min and Max functions. However, you might need tran_dt first in the index or have its own index.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145


-Original Message-

From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]


I have the following statement that I would like to create a function-based

index for:


SELECT MIN(tran_dt)

FROM ach_tran

WHERE cnfr_no = :b1


I'd like the index to include columns cnfr_no and tran_dt (in that order).

The examples I've seen are

just single-column indexes.   Is it possible to have this  additional

column in a function-based index that

is not involved in the actual function?   If yes, what would the index

creation statement look like?


This is version 9.2.0.1 on Sun Solaris 2.6.


Thanks in advance for any assistance.


Cherie Machler

Gelco DBA

RE: Common PL/SQL package to truncate tables

[Thomas Jeff]

Title: RE: Common PL/SQL package to truncate tables





We thought about that initially, but it won't work as the batch accounts
won't have the privs to truncate the tables, we'd have to grant
DROP ANY TABLES to them.



-Original Message-
From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 5:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Common PL/SQL package to truncate tables



What about creating the package with invoker rights?  I haven't checked
to see whether there are restrictions that might apply here, but it
seems like a natural.  The success of the procedure's execution would
depend on the invoker having the required privileges.



--- Thomas Jeff <[EMAIL PROTECTED]> wrote:
> We have a DSS database containing numerous datamarts, each stored in
> it's
> own schema.
> Each datamart schema has a corresponding OPS$ batch account, which
> does the
> ETL work.   
> DML privs on all tables within a schema are granted to a
> {schema}_LOAD_ROLE,
> which
> in turn is granted to the pertinent batch account.  
> 
> Previously, each schema has it's own copy of a common utilty package,
> which
> provided
> among other things, a routine to truncate a specified table.   The
> batch
> account would
> call this routine to perform all truncates.   As the number of
> datamarts
> grew it started 
> becoming a pain to maintain and compile the same package in multiple
> schemas.
> 
> So,  the idea is to use a database-wide common utility package which
> would
> be compiled 
> under a DBA ID, with execute granted to the OPS$ batch accounts.  
> This
> package's truncate 
> routine would verify a truncate request by checking the calling USER
> against
> DBA_ROLE_PRIVS 
> to ensure it had the requisite {schema}_LOAD_ROLE for the
> {schema}.table_name passed as
> a parameter.
> 
> Any security holes or caveats with this idea?   Or maybe a more
> elegant way
> to accomplish this?
> 
> Thanks.
> 
> 
> Jeffery D Thomas
> DBA
> Thomson Information Services
> Thomson, Inc.
> 
> Email: [EMAIL PROTECTED]
> 
> Indy DBA Master Documentation available at:
> http://gkmqp.tce.com/tis_dba
> Select 'Indy DBA' then 'DBA Web Pages'
> 
> 
> 
> 



__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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).

Oracle Advanced Replication

[Winnie_Liu]

To all,

I have a 5-way multi-master replication set up on Oracle 817 and Sun Solaris
2.7.

In the replication group, we would like to add a new column to a replicated
table.

Not only that, we would like to add this new column to the primary key of this
replicated table.

What are the steps that I would need to do?

I seems to remember that if we add any new columns in the replicated object, we
would need to
1) quieced the whole environment
2) drop this object from the replication group
3) add the new column in the MDS as well as all other master sites
4) add this table back to the replication group
5) generate replication support
6) resume replication again

Would some replication expert tell me if I am correct or not? (I did try to look
in the doc, but I can't find it any where)

Thanks for your help!

Winnie


--

<\ />~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
   (@ @)  @}-`-,-`-,---   Winnie Liu  ---'-,-'-,-{@`~`~
   /   V  \   Oracle Database Administrator`~`~
  o--m-m--o  Infonet Services Corporation `~`~
   #   mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Oracle Advanced Replication

[Paul Baumgartel]

Is there some reason that you can't use DBMS_REPCAT.EXECUTE_DDL?  See
the Supplied PL/SQL Packages reference; here's the description:


EXECUTE_DDL Procedure

This procedure supplies DDL that you want to have executed at some or
all master sites. You can call this procedure only from the master
definition site. 


This package is intended to replicate changes made to objects that
belong to a replication group, so it should be suitable for use here,
as well as being a whole lot simpler than the approach you'd otherwise
have to take.

HTH.


--- [EMAIL PROTECTED] wrote:
> 
> To all,
> 
> I have a 5-way multi-master replication set up on Oracle 817 and Sun
> Solaris
> 2.7.
> 
> In the replication group, we would like to add a new column to a
> replicated
> table.
> 
> Not only that, we would like to add this new column to the primary
> key of this
> replicated table.
> 
> What are the steps that I would need to do?
> 
> I seems to remember that if we add any new columns in the replicated
> object, we
> would need to
> 1) quieced the whole environment
> 2) drop this object from the replication group
> 3) add the new column in the MDS as well as all other master sites
> 4) add this table back to the replication group
> 5) generate replication support
> 6) resume replication again
> 
> Would some replication expert tell me if I am correct or not? (I did
> try to look
> in the doc, but I can't find it any where)
> 
> Thanks for your help!
> 
> Winnie
> 
> 
> --
> 
> <\ />~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
>(@ @)  @}-`-,-`-,---   Winnie Liu  ---'-,-'-,-{@`~`~
>/   V  \   Oracle Database Administrator`~`~
>   o--m-m--o  Infonet Services Corporation `~`~
>#   mailto:[EMAIL PROTECTED]`~`~
> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> 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).
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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: Oracle Advanced Replication

[Winnie_Liu]

The only reason is that we have to change the primary key constraint. That's
mean, we got to drop and recreate the primary key constraint. And if the
replicated object is still in the replication group, it probably won't allow me
to drop the primary key though. (or maybe I got it all wrong?)

Thanks for your help anyway,

Winnie
--

<\ />~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
   (@ @)  @}-`-,-`-,---   Winnie Liu  ---'-,-'-,-{@`~`~
   /   V  \   Oracle Database Administrator`~`~
  o--m-m--o  Infonet Services Corporation `~`~
   #   mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~



   

  Paul Baumgartel  

 
  .com>cc: 

  Sent by: Subject:  Re: Oracle Advanced 
Replication   
  [EMAIL PROTECTED] 

   

   

  12/11/02 04:58 PM

  Please respond to

  ORACLE-L 

   

   





Is there some reason that you can't use DBMS_REPCAT.EXECUTE_DDL?  See
the Supplied PL/SQL Packages reference; here's the description:


EXECUTE_DDL Procedure

This procedure supplies DDL that you want to have executed at some or
all master sites. You can call this procedure only from the master
definition site.


This package is intended to replicate changes made to objects that
belong to a replication group, so it should be suitable for use here,
as well as being a whole lot simpler than the approach you'd otherwise
have to take.

HTH.


--- [EMAIL PROTECTED] wrote:
>
> To all,
>
> I have a 5-way multi-master replication set up on Oracle 817 and Sun
> Solaris
> 2.7.
>
> In the replication group, we would like to add a new column to a
> replicated
> table.
>
> Not only that, we would like to add this new column to the primary
> key of this
> replicated table.
>
> What are the steps that I would need to do?
>
> I seems to remember that if we add any new columns in the replicated
> object, we
> would need to
> 1) quieced the whole environment
> 2) drop this object from the replication group
> 3) add the new column in the MDS as well as all other master sites
> 4) add this table back to the replication group
> 5) generate replication support
> 6) resume replication again
>
> Would some replication expert tell me if I am correct or not? (I did
> try to look
> in the doc, but I can't find it any where)
>
> Thanks for your help!
>
> Winnie
>
>
> --
>
> <\ />~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
>(@ @)  @}-`-,-`-,---   Winnie Liu  ---'-,-'-,-{@`~`~
>/   V  \   Oracle Database Administrator`~`~
>   o--m-m--o  Infonet Services Corporation `~`~
>#   mailto:[EMAIL PROTECTED]`~`~
> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> 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).
>


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul

Re: Alteon and Oracle

[Stephane Paquette]

In 2000, I've worked at a web site (houra.fr) that was
using 4 Alteon switches.
It took several weeks (days and nights) before the
were fine tuned. 
They caused me some ora-3113 that drove me crazy. 

I hoped that, at the end of 2002, things are better.


 --- David Turner <[EMAIL PROTECTED]> a écrit : >
Would someone send me some pointers to using load
> balancers such as and Alteon
> and Oracle for serving up primarily readonly data?
> 
> Thanks, Dave
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: David Turner
>   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).
>  

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

__
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Stephane=20Paquette?=
  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: "Memory issues" on HPUX --- docs on MetaLink

[hkchital]

Hmm..
I was able to download the file at both my
employer's Intranet and my Singnet broadband account
till last night.

Apparently, Tripod discourages file downloads from 
user's home pages.


Those who would like the file, please send me a seperate
email and I will send the file across.

Hemant


- Forwarded message from Cyril  Thankappan 
Date: 12 Dec 2002 01:35:16 -
Reply-To: Cyril  Thankappan Subject: Re: RE: "Memory issues" on HPUX  --- docs on 
MetaLink
To: Hemant K Chitale <[EMAIL PROTECTED]>

Hi

I get the error

"This file is hosted by Tripod, a Lycos®Network Site, and is not
available for download. Please check out Tripod's Help system for
more information about Remote Loading and our Remote Loading
policy.


"

When I try to download the zip file...

Kindly advise

Cyril

On Wed, 11 Dec 2002 Hemant K Chitale wrote :
>
>In my emails of the last two days I had mentioned that I had
>compiled a
>list of docs on Metalink.
>
>If you'd like to see the docs, I've placed them at
>http://hkchital.tripod.com/HPUX_Notes_from_Oracle.zip
>
>Hemant K Chitale
>My web site page is :  http://hkchital.tripod.com
>
>
>-- Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- Author: Hemant K Chitale
>  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).
>



- End forwarded message -



Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: hkchital
  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).

Issues/Cautions Migrating Oracle DB across platforms

[Hemant K Chitale]

We are considering migrating some Oracle Databases
across platforms -- from Solaris to HPUX.
We'll, of course, be using Export-Import.

I've been asked to come up with a list of issues / cautions
to consider.

e.g. I can think of 

Pre-Requisites :
1.  The right [same or higher] version of  the Oracle RDBMS + Patchset Release 
must be installed.
2.  The database should be created with a minimum block-size of 4K, preferably 
8K.
3.  The database character-set should preferably be the same or a higher 
character-set.  [eg US7ASCII or WE8ISO8859P1 or UTF8]
4.  The NLS_LANG settings during the Export and Import must be complaint.


Potential Issues :

1.  BFILE references will become invalid as BFILEs are stored outside the 
database.
2.  If there are tables containing LOBs, the import can be slower.  [There was 
an 8i bug requiring COMMIT=Y to improve Import performance but commiting at every 
record, instead of at every buffer-size].


Recommendations / experiences appreciated.

Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  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: Common PL/SQL package to truncate tables

[Deshpande, Kirti]

Title: RE: Common PL/SQL package to truncate tables



Here 
is how we did it:
 A special id with 'drop any table' privs, it owns a table, 
'truncate_clearance'. The table has calling_user, table_owner, table_name. The 
calling user has exec privs on a special package (dbms_custom) with a 
'truncate_table' procedure. The procedure accepts table owner and table 
name as parameters, and checks the truncate_clearance table for the existence 
of a row with calling user, supplied table owner and supplied table 
name. If found, table is truncated else, an error is returned. We 
are now thinking of adding some sort of auditing to this procedure to track 
how often a table gets truncated and by who. 
This 
process was developed back when the db was running on 7.3. 
 
- 
Kirti  
 
-Original Message-From: Thomas Jeff 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 11, 2002 4:59 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Common PL/SQL package to truncate tables
We thought about that initially, but it won't work as the batch 
accounts won't have the privs to truncate the tables, 
we'd have to grant DROP ANY TABLES to them. 

-Original Message- From: Paul 
Baumgartel [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 11, 2002 5:24 PM To: Multiple recipients of list ORACLE-L Subject: 
Re: Common PL/SQL package to truncate tables 
What about creating the package with invoker rights?  I 
haven't checked to see whether there are restrictions 
that might apply here, but it seems like a 
natural.  The success of the procedure's execution would depend on the invoker having the required privileges. 
 

Need help Reformatting output

[Sergei]

Title: RE: Active sessions chewing up a huge amount of RAM









I am looking for a way to display rows as columns.

For example:

Id name    value

1  a  5

1  b  10

2  a  15

2  b  20

 

I need it as:

name    1  2

a  
5 15

    b  10 20

 

Thank you in advance

Sergei.

Re: sql with bind variable in stored procedure doesnt use stored outlines

[orafaq]

I tried this even without bind variable and could 
not make it work from a stored procedure. ANy help over here will be very 
appreciated
Folllowing is the testcase.
 
Thanks
Shaleen
 
create table emp (num number,sal number);insert 
into emp values(1,1); create or replace procedure t astotal 
number:=0;cursor c1 is select sal from emp;beginfor i in c1 
looptotal:=total+i.sal;dbms_output.put_line('total salary is 
$'||total);end loop;end;/ exec 
outln_pkg.drop_by_cat('DEFAULT');create outline on select sal from 
emp;select used from dba_outlines;alter session set 
QUERY_REWRITE_ENABLED=true;alter session set 
STAR_TRANSFORMATION_ENABLED=true;alter session set 
use_stored_outlines=true;exec t;select used from dba_outlines;select 
sal from emp;select used from dba_outlines;
- Original Message - 

  From: 
  orafaq 
  To: [EMAIL PROTECTED] 
  Sent: Wednesday, December 11, 2002 2:08 
  PM
  Subject: sql with bind variable in stored 
  procedure doesnt use stored outlines
  
  All,
   
  I am unable to make stored outlines work for sql 
  statements with bind variable in stored procedures. Please see following 
  sample code and tell me what am I doing wrong.
   
  Thanks in Advance
   
  create table emp (num number,sal 
  number);insert into emp values(1,1); create or replace 
  procedure t(num_i number) astotal number;cursor c1(p1 number) is 
  select sal from emp where num=p1;beginfor i in c1(num_i) 
  looptotal:=total+i.sal;dbms_output.put_line('total salary is 
  $'||total);end loop;end;/ alter session set 
  sql_trace=true;exec t(1);alter session set 
  sql_trace=false; create outline on select sal from emp where 
  num=:b1;select used from dba_outlines;
   
  alter session set 
  QUERY_REWRITE_ENABLED=true;alter session set 
  STAR_TRANSFORMATION_ENABLED=true;alter session set 
  use_stored_outlines=true;exec t(2);select used from 
  dba_outlines;
   
  variable b1 number;exec :b1:=1;select sal 
  from emp where num=:b1;select used from dba_outlines;
   
  Thanks
  Shaleen

Oracle Personal and enterprise endition

[Walid Alkaakati]

Hi List ,

I have one question please,what is main difference between oracle personal
edition DB and Enterprise edition,
Iam considering this for purpose of training on RMAN,DB installarto
prepare for DBA Exams.

Thanks for any help.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Walid Alkaakati
  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: Recovery Scenarios -> Consolidated

[Krishna Rao Kakatur]

 
Finally, I have figured out a Freeware Hex editor 
at http://www.hhdsoftware.com/hexeditor.html. 
Using this freeware, I could open Oracle data files (while database is shutdown) 
and corrupt them (for testing, of course).
 
1. BBED (Block Editor) did not work as I do not 
have password. I believe only Oracle support will have this 
password.
2. We can't corrupt/ alter the data files on 
Windows, because Oracle.exe locks these files, while database is 
open.
 
I have developed a script to alert me of 
corruptions, which I have started using right now. Let me know if it is useful 
to you.
 
HTH, Krishna
 
- Original Message - 

  From: 
  Yechiel 
  Adar 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, December 11, 2002 10:14 
  AM
  Subject: Re: Recovery Scenarios
  
  Hello Krishna
   
  I just tried to open a datafile using textpad and got 
  sharing violation.
  I tried opening using notepad and it 
worked.
   
  For obvious reasons (not trying to test recovery) I did 
  not change and save the file with notepad.
   
  Yechiel AdarMehish
  
- Original Message - 
From: 
Krishna 
Rao Kakatur 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, December 11, 2002 2:00 
AM
Subject: Recovery Scenarios

Hi,
 
Could you please suggest me how to corrupt a 
data file, for testing recovery.
 
I am trying to test Block Recovery with my 
Personal Oracle 9i on Windows Me. I am not able to open or overwrite the 
files because oracle.exe locks them.
 
Thanks, 
Krishna


alert_corruption.ksh
Description: Binary data