Displaying Images in a web browser- Reg

[magesh]

Dear All,
 
Does anyone have any experience with displaying 
images in a web browser that are stored in 8.0.5 Oracle  database. The 
images are stored in Bfile ,i'd like a link for the user to click which would 
then display the image. I wud prefer to use Java servlets & java 
.
 
Any help or leads would be highly appreciated. 

 
Thanks & Regards
Magesh

v$sql.rows_processed

[Rahul]

List, 

is rows_processed a good indicator is the number of rows actually processed
by a statement ? 

i'm running an insert, and want to know how many rows the statement has
inserted already

Regards

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle Learning Network (OLN) and Tech Based Training

[Fowler, Kenneth R]

Hi,


My company has some training credits that are soon going to expire and our
oracle education representative has informed me that we can spend the
credits on 1) Tech Based Training and 2) Oracle Learning Network
Subxscription aside from regular Instructor Led Training courses.  I need
some advice on what is worth while to purchase.


1.  Are the Tech Based Training titles any good?  I was considering the
following...

Oracle 8i Backup and Recovery: Strategies and Backups
Oracle 8i Backup and Recovery: Troubleshooting and Recovery
Oracle 8i Performance Tuning: Managing Memory and Disk I/O
Oracle 8i Performance Tuning: Optimizing Sorts and Minimizing Contention
Oracle 8i Performance Tuning: Strategies and Techniques

What resources are supplied with the titles?  Multimedia CD only? or do they
come with the relevant Oracle manuals (All of my paper manuals are Pre 8i so
new ones would be useful).


2.  Is a subxscription to the Oracle Learning Network worthwhile and what
would I receive?  I checked out the web site and it seems to give access to
a lot of streaming media training etc.  What are the main advantages of an
OLN subxscription.


Thanks,
Ken
_
Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026Fax: (860) 715-8346
Email: [EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fowler, Kenneth R
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Metalink Response ....FYI

[Steve Adams]

Hi Eric,

The one I know best is a chat site. The application is much more sophisticated
than MetaLink. It has seen also seen "unprecedented demand" recently - about
500% growth in the last year. There have been growing pains, mostly caused by
Oracle bugs, but they certainly seem to be able to make their Oracle stuff scale
much better than MetaLink does. Maybe its because of the performance consultant
they use. I understand that Oracle management politely declined an offer of help
from the same consultant.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Wednesday, 4 April 2001 5:22
To: Multiple recipients of list ORACLE-L


Steve,

Thanks for the very interesting comments. Are those webified
apps with similar requirements as metalink?


On 3 Apr 2001, at 7:26, Steve Adams wrote:


> I'd say that there must be something badly wrong with the application if it
> cannot cope with 1,500 concurrent users. I know of sites supporting more than
20
> times that number of active users on a single server with consistent
sub-second
> response times.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OraGeeks$ : SUPPORT FOR SITE

[Steve Adams]

Hi All,

It seems that the technotes written by Roby and his colleagues are still there
(for now). You can get links to 8 of them by searching for "interealm" using the
Ixora search engine, and another one on IIOP setup is still accessible via
Google.

Also, if you were in the habit of using the OraGeeks technote search facility to
find materials elsewhere on the web, then may I recommend the Ixora search
engine as an alternative. Most of the content that was linked to from OraGeeks
is fully indexed at Ixora (plus lots more) and although there is no way of
browsing by category there is a keyword search facility. So its not as good for
browsing, but better if you're searching for something specific.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Wednesday, 4 April 2001 7:07
To: Multiple recipients of list ORACLE-L


Hi Folks ,
I am sure some of you would be remembering
"orageeks " website http://www.interealm.com/orageeks/
Well.the site owner Roby Sherman who is a frequent
poster in this site has closed the site down . When I
asked the reason he sent me the following . I agree
with his sentiments . Thought since this a place real
talent hangs out I thought some of you could chip in .

" Hi Raj:

More or less, I was looking for volunteers to help
maintain the
technical content of the directory. That means helping
me with finding
new resources (that weren't links to some company's
product) to add to
the directory on an ongoing basis, communicating with
me when they
found
a resource that was outdated or inappropriate, help
with the addition /
modification of directory categories, Etc. Heck, even
contributing a
small technical note once in a blue moon wouldn't have
hurt either.

Cheers!
--Roby
"
Cheers
RS


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to remove tablespace frgamentation

[Suhen Pather]

Seema,

Plan what is needed to be defragged.
Determine whether it is framentation on a block, extent, tablespace level.

Having many extents does not necessarily mean that you have fragmention.
Incorrect extent sizing for segments could cause poor performance.

Try to create segments with uniform initial and next extent sizing per
tablespace.


Use extent sizes that are multiple of db_block_size and
db_file_multiblock_read_count parameters
to perform efficient scans for multi block read operations.

Read through the attached whitepaper (SAFE) to give you an idea for
eliminating fragmention.

You can rebuild indexes, change storage clause and move into different
tablespaces.

What version of Oracle are you using?

IF you are on Oracle 8i you can move tables around to different tablespaces
and also 
change storage parameters (initial, next, pctincrease, ...) without import/
export.

Also visit http://www.ixora.com.au/tips/creation/extents.htm for ideas of
planning extent sizes
for your segments.

Regards
Suhen


Hi Gurus
What is the best method to eliminate the tablespace fragmentation.
except EXPORT/CREATE/IMPORT
Suggestion will be appriciated.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


 defrag.pdf

(Fwd) RE: MS-DOS commands - list of ??? / Re: WINNT-L Dig

[Eric D. Pierce]

another good one!

--- Forwarded message follows ---
Date sent:  Tue, 3 Apr 2001 16:31:26 -0400
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>

http://www.computerhope.com/msdos.htm

...
>---
>The WINNT-L list is hosted on a Windows NT(TM) machine running L-Soft
>international's LISTSERV(R) software.  For subscription/signoff info
>and archives, see http://peach.ease.lsoft.com/archives/winnt-l.html .
>
--- End of forwarded message ---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

(Fwd) Re: MS-DOS commands - list of ?

[Eric D. Pierce]

also nice (see URL below) for NT and DOS commands.

   http://www.cotse.com/Ntcommands/ntcmdsCommands_Index1.html


includes info on the metaphoric value of swimming elephants 
and religion (http://www.cotse.com/story.htm).

nothing on metalink, poop or baked goods as far as I can 
tell, but they might be open for suggestions.

regards,
ep


--- Forwarded message follows ---
Date sent:  Tue, 3 Apr 2001 16:51:51 -0400

 for nt try
http://www.cotse.com/Ntcommands/ntcmdsCommands_Index1.html

for dos there are tons of sites

have fun

rob
~~

--- End of forwarded message ---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

How to remove tablespace frgamentation

[Seema Singh]

Hi Gurus
What is the best method to eliminate the tablespace fragmentation.
except EXPORT/CREATE/IMPORT
Suggestion will be appriciated.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: MS-DOS commands - list of ??? / Re: WINNT-L Digest - 29 Mar 2001 - Special issue (#2001-55)

[Eric D. Pierce]

A.B.,

Lots of totally cool stuff, I hope they will be able to use it.

Anyway, today was moanday for me, I should have just gone to:

   http://www.google.com/search?hl=en&lr=&safe=off&q=MS-DOS+command+help

since it shows:

   http://vernon.frazee.net/ms-dos/6.22/help/

regards,
ep

On 3 Apr 2001, at 17:43, Andrew S. Baker scribbled with alacrity and cogency:

> See the following:
>  http://www.ultratech-llc.com/Personal/Files/?File=Scripting.TXT

...

> >Question from another list:
> >
> >(besides going to "DOS" in Win9x and typing "help")
> >
> >does anyone know where there is a list of MS-DOS
> >commands, including syntax/explanations/etc. ?
> >
> >I couldn't (easily) find anything in the public area of
> >tech-support/KB at www.microsoft.com

...


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

(Fwd) RE: MS-DOS commands - list of ??? / Re: WINNT-L Digest -

[Eric D. Pierce]

nice:

--- Forwarded message follows ---
F r o m : " D E   W a l d r o n "   < d e w a l d r o n @ d e w a s s o c . c o m > 
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Date sent:  Tue, 3 Apr 2001 17:07:16 -0400

Try here:

http://www.dewassoc.com/kbase/

Expand "MS-DOS Basics and navigate to DOS Commands

-Original Message-
[mailto:[EMAIL PROTECTED]]On Behalf Of Eric D. Pierce
Sent: Tuesday, April 03, 2001 4:25 PM
To: [EMAIL PROTECTED]
2001 - Special issue (#2001-55)


Question from another list:

(besides going to "DOS" in Win9x and typing "help")

does anyone know where there is a list of MS-DOS
commands, including syntax/explanations/etc. ?

I couldn't (easily) find anything in the public area of
tech-support/KB at www.microsoft.com

thanks,
ep

--
The WINNT-L list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/winnt-l.html .
--- End of forwarded message ---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Max # of Open Files for UTL_FILE in 7.3.4.3

[Khedr, Waleed]

I'm not answering the question but suggesting sorting your data on that date
column and opening, writing to, and closing a file for every unique value
for this date column.

-Original Message-
Sent: Tuesday, April 03, 2001 7:01 PM
To: Multiple recipients of list ORACLE-L


Greetings,

Had an situation today in 7.3.4.3 running on AIX v4.2.  I was extracting
data to several different files based on the date record using
UTL_FILE.  I found I couldn't have more than 10 files open at any given
time.  I know the default in 8i is 50 files, but I looked on OTN and
couldn't find either the default number of files (has to be 10) or any
way to change it for 7.3x.

Does anyone know if it can be increased and how?

Thanks,

David A. Barbour
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

shminfo_shmmax

[Djordje Jankovic]

Hi,

Anybody has any gotchas with setting of shminfo_shmmax on Sun Solaris ? 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Re-compile SYS.DBMS_ASYNCRPC_PUSH and SYS.DBMS_DEFER_SYS_PART

[Jacques Kilchoer]

Title: RE: Re-compile SYS.DBMS_ASYNCRPC_PUSH and SYS.DBMS_DEFER_SYS_PART1?





see answer below.


> -Original Message-
> From: Guang Mei [mailto:[EMAIL PROTECTED]]
> 
> Oracle 8.0.5 on Sun.
> 
> I am trying to re-compile some invalid objects owned by SYS in our db.
> 
> But when I tried I got some error which I am not sure how to 
> resolve (see 
> code below).
> 
> I also tried things such as
> 
> select text
> from dba_source
> where owner='SYS'
> and name = 'DBMS_ASYNCRPC_PUSH'
> and type = 'PACKAGE BODY'
> order by line;
> 
> to look at the package code, but not much luck there.
> 
> So, what could I do to make these objects valid?
> 
> 
> SQL> select owner, object_name,object_type from all_objects
>   2  where status='INVALID'
>   3  and owner = 'SYS'
>   4  order by owner desc, object_type, object_name;
> 
> OWNER  OBJECT_NAME    
> OBJECT_TYPE
> -- -- 
> ---
> SYS    DBMS_ASYNCRPC_PUSH 
> PACKAGE BODY
> SYS    DBMS_DEFER_SYS_PART1   
> PACKAGE BODY
> 
> 
> SQL> alter package sys.DBMS_ASYNCRPC_PUSH compile body;
> 
> Warning: Package Body altered with compilation errors.
> 
> SQL> show errors;
> Errors for PACKAGE BODY SYS.DBMS_ASYNCRPC_PUSH:
> 
> LINE/COL ERROR
>  
> -
> 103/27   PL/SQL: Statement ignored
> 103/49   PLS-00302: component 'RESULT_STARTUP_SECONDS' must 
> be declared
> SQL> alter package sys.DBMS_DEFER_SYS_PART1 compile body;
> 
> Warning: Package Body altered with compilation errors.
> 
> SQL> show errors;
> Errors for PACKAGE BODY SYS.DBMS_DEFER_SYS_PART1:
> 
> LINE/COL ERROR
>  
> -
> 306/7    PL/SQL: Statement ignored
> 306/56   PLS-00302: component 'MISSINGUSER_NUM' must be declared
> 328/5    PL/SQL: Statement ignored
> 328/20   PLS-00302: component 'DELETE_ERROR' must be declared


Without doing a lot of research into the matter:
Have you tried looking in $ORACLE_HOME/*/admin for a ".sql" script that defines the components that are missing?
For example, missinguser_num is defined by $ORACLE_HOME/rdbms/admin/dbmsdefr.sql (see find command below)


$ find $ORACLE_HOME/*/admin -name "*.sql" -exec grep -il missinguser_num {} \;
/oracle/ora32/product/8.1.6/rdbms/admin/dbmsdefr.sql


Also some of the Oracle packages have source text that is "wrapped", meaning encrypted. It looks like DBMS_ASYNCRPC_PUSH has "wrapped" source (at least it does in my 8.1.6 database).

--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

Max # of Open Files for UTL_FILE in 7.3.4.3

[David A. Barbour]

Greetings,

Had an situation today in 7.3.4.3 running on AIX v4.2.  I was extracting
data to several different files based on the date record using
UTL_FILE.  I found I couldn't have more than 10 files open at any given
time.  I know the default in 8i is 50 files, but I looked on OTN and
couldn't find either the default number of files (has to be 10) or any
way to change it for 7.3x.

Does anyone know if it can be increased and how?

Thanks,

David A. Barbour
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Question

[Viktor]

Thanks a lot to everyone who helped.
It's all good!

Special Thanks to William and Regina!


--- William Rogge <[EMAIL PROTECTED]> wrote:
> YES.
> 
> column the_week noprint
> SELECT column_a, column_b,
> to_char(some_date_column,'YYWW') the_week, count(*),
>sum(column_c)
> from table_t
> WHERE some_date_column BETWEEN :start_date and
> :end_date
> group by to_char(some_date_column, 'YYWW')
> 
> 
> -Original Message-
> From: Viktor [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 1:36 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  SQL Question
> 
> 
> Hello all,
> 
> Can someone tell me whether or not there is a way
> do this in SQL?
> I want to select some data given a certain date
> range,i.e  where some_date between start_date and
> end_date.
> Is there a way to group the output by week?
> In other words, something like:
> 
> SELECT column_a, column_b, count(*),
> sum(column_c)
> FROM table_t
> WHERE some_date_column BETWEEN :start_date and
> :end_date
> GROUP BY ...?
> 
> How this be grouped by week?
> 
> Thanks a lot.
> 
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Viktor
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: William Rogge
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Help - How to declare a cursor inside a FOR ... LOOP ?

[Connor McDonald]

A cursor definition always follows a declare, so its
just a case of nesting the appropriate
declare-begin-end where you like in your procedure

hth
connor

--- Wendy Y <[EMAIL PROTECTED]> wrote: > 
> Hey, Guys:
> 
> I need to decalre a cursor inside a FOR .. LOOP,
> because the variables in SELECT statement for the
> CURSOR are coming from FOR .. LOOP. How could I do
> this?
> 
> DECLARE
>   V_AKTIV_NRaktiv.AKTIV_NR%TYPE;
>   V_PROBLEMaktiv.PROBLEM%TYPE;
>   V_ENDDAT   aktiv.ENDDAT%TYPE;
>   V_ENDUHR   aktiv.ENDUHR%TYPE;
>   V_AUSSAGEW   aktiv.AUSSAGEW%TYPE;
>   V_LANGTEXT   aktiv.LANGTEXT%TYPE;
>   V_LONGTEXTVARCHAR2(2);
>   V_LONGTEXT_CUR  VARCHAR2(13000);
>   V_LONGTEXT_TRIM VARCHAR2(2000);
>   p_PROBLEMPROBLEM.PROBLEM%TYPE;  
> 
> # This part need to be inside FOR..
> LOOP, otherwise, I wouldn't get anything.
> 
> CURSOR AKLangTextCur IS 
>  SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' '||
>V_ENDUHR||' '||
>   rtrim(V_AUSSAGEW)||' '||
>   rtrim(V_LANGTEXT)   thisText
> FROM AKTIV
> WHERE V_PROBLEM = p_PROBLEM
> ORDER BY Aktiv_NR; 
> AKLangTextRec   AKLangTextCur%ROWTYPE; 
> 
> ### Above
> BEGIN
>   FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries
> LOOP
> V_AKTIV_NR :=
> pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);
> V_PROBLEM  :=
> pkgFreeText.V_PROBLEM_P(v_LoopIndex);
> V_ENDDAT   :=
> pkgFreeText.V_ENDDAT_P(v_LoopIndex);
> V_ENDUHR   :=
> pkgFreeText.V_ENDUHR_P(v_LoopIndex);
> V_AUSSAGEW :=
> pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);
> V_LANGTEXT :=
> pkgFreeText.V_LANGTEXT_P(v_LoopIndex);
> 
>   SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM;
> 
> ## CURSOR DECLARE should be HERE ##
> 
> BEGIN
>  OPEN AKLangTextCur;
>   LOOP
> FETCH AKLangTextCur into AKLangTextRec;
>  EXIT WHEN AKLangTextCur%NOTFOUND;
> V_LONGTEXT_CUR := V_LONGTEXT_CUR
> ||AKLangTextRec.thisText; 
>  END LOOP;
>  CLOSE AKLangTextCur;
> END;  
>   V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR;   
> 
>   END LOOP;
>V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000);
> 
> Thanks a lot for help
> 
> Wendy
> 
> 
> 
> -
> Do You Yahoo!?
> Yahoo! Mail Personal Address - Get email at your own
> domain with Yahoo! Mail.


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

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


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Locally Managed Tablespace Uniform Extent

[Connor McDonald]

I think its to keep the extents identifiable within
the segment header block - sort of in the same way
that oracle used to do in the earlier versions (which
limited the extents to 121, 249, 505 etc dependent on
block size)

hth
connor

--- Jacques Kilchoer <[EMAIL PROTECTED]>
wrote: > > -Original Message-
> > From: Miller, Jay
> [mailto:[EMAIL PROTECTED]]
> > 
> > My understanding was that the main reason to keep
> the number 
> > of extents down
> > was in case you needed to drop or truncate the
> table it would 
> > take Oracle a
> > long time to clean up the fet$ table.
> > I think, and I emphasize that I am not certain of
> this, that 
> > this is no
> > longer a problem with locally managed tablespaces.
> > I'm sure someone will correct me if I'm wrong...
> 
> As usual, Steve Adams has some sage advice on the
> subject. Check out his
> article "Planning Extents"
> http://www.ixora.com.au (click on Tips then on
> Planning Extents)
> in which he mentions that there are reasons for
> keeping the number of
> extents down even in a locally managed tablespace.
> 


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

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


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re-compile SYS.DBMS_ASYNCRPC_PUSH and SYS.DBMS_DEFER_SYS_PART1?

[Guang Mei]

Hi:

Oracle 8.0.5 on Sun.

I am trying to re-compile some invalid objects owned by SYS in our db.

But when I tried I got some error which I am not sure how to resolve (see 
code below).

I also tried things such as

select text
from dba_source
where owner='SYS'
and name = 'DBMS_ASYNCRPC_PUSH'
and type = 'PACKAGE BODY'
order by line;

to look at the package code, but not much luck there.

So, what could I do to make these objects valid?

TIA

Guang


SQL> select owner, object_name,object_type from all_objects
  2  where status='INVALID'
  3  and owner = 'SYS'
  4  order by owner desc, object_type, object_name;

OWNER  OBJECT_NAMEOBJECT_TYPE
-- -- 
---
SYSDBMS_ASYNCRPC_PUSH PACKAGE BODY
SYSDBMS_DEFER_SYS_PART1   PACKAGE BODY


SQL> alter package sys.DBMS_ASYNCRPC_PUSH compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY SYS.DBMS_ASYNCRPC_PUSH:

LINE/COL ERROR
 -
103/27   PL/SQL: Statement ignored
103/49   PLS-00302: component 'RESULT_STARTUP_SECONDS' must be declared
SQL> alter package sys.DBMS_DEFER_SYS_PART1 compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY SYS.DBMS_DEFER_SYS_PART1:

LINE/COL ERROR
 -
306/7PL/SQL: Statement ignored
306/56   PLS-00302: component 'MISSINGUSER_NUM' must be declared
328/5PL/SQL: Statement ignored
328/20   PLS-00302: component 'DELETE_ERROR' must be declared
SQL> spool off

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Locally Managed Tablespace Uniform Extent

[Jacques Kilchoer]

Title: RE: Locally Managed Tablespace Uniform Extent





> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> 
> My understanding was that the main reason to keep the number 
> of extents down
> was in case you needed to drop or truncate the table it would 
> take Oracle a
> long time to clean up the fet$ table.
> I think, and I emphasize that I am not certain of this, that 
> this is no
> longer a problem with locally managed tablespaces.
> I'm sure someone will correct me if I'm wrong...


As usual, Steve Adams has some sage advice on the subject. Check out his article "Planning Extents"
http://www.ixora.com.au (click on Tips then on Planning Extents)
in which he mentions that there are reasons for keeping the number of extents down even in a locally managed tablespace.

Re: DBA_USERS view

[Rodd Holman]

You can use it to swap out a user's password for diagnostics.  An example is 
listed in the Oracle DBA Handbook.  Basically you can create a temp table to 
store the value:
CREATE TABLE TEMP_USER AS SELECT USERNAME, PASSWORD FROM DBA_USERS WHERE 
USERNAME = 'XYZ';

Then alter the user for whatever:
ALTER USER XYZ IDENTIFIED BY NEWPASSWORD;
CONNECT XYZ/NEWPASSWORD

Do your stuff then reset the password:
ALTER USER XYZ IDENTIFIED BY VALUE (SELECT PASSWORD FROM TEMP_USER WHERE USER 
= 'XYZ');

User's password is reset to what it was and you never needed to get it from 
them.  Why would you do this?  As DBA you have absolute access to everything. 
This lets you see the database from their viewpoint, with their access 
rights.  Could be helpful when trying to recreate a permissions related 
error that you don't get as yourself.

On Tuesday 03 April 2001 16:16, you wrote:
> > -Original Message-
> > From: Stefan Jahnke [ mailto:[EMAIL PROTECTED]
>
>  ]
>
> > what information does the PASSWORD column in the DBA_USERS
> > view provide.
> > I know that it's the encrypted user password, but how can I
> > actually use
> > it ?
> > For example: Can I reassign a password to a user via his encrypted
> > password ?
> > or: Can I test a logon with another user's encrpyted user password to
> > test the logon ?
> > I tried stuff like connect myuser/0CE92663BBC6FC34@MYDB, but that
> > doesn't seem to work.
>
> I forget, did anyone answer this question?
> You can use it with the (undocumented as far as I know) 'identified by
> values' option of the alter user statement. This can be handy if you
> want to sign on as user X without changing their password. Make their
> password something you know, login with that password, then change their
> password back to the old password. Example:
>
> SQL> create user x identified by old_password ;
>
> User created.
>
> SQL> grant create session to x ;
>
> Grant succeeded.
>
> SQL> select password from dba_users where username = 'X' ;
>
> PASSWORD
> --
> D64698D364A3B171
>
> SQL> connect x/old_password
> Connected.
> SQL> alter user x identified by new_password ;
>
> User altered.
>
> SQL> connect x/new_password
> Connected.
> SQL> alter user x identified by values 'D64698D364A3B171' ;
>
> User altered.
>
> SQL> connect x/old_password
> Connected.
> SQL>
>
> > TIA ...
> >
> > --
> > Regards,
> > Stefan Jahnke
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>
> 
>
> > --
> > Author: Stefan Jahnke
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> >
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 


-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: DBA_USERS view

[dgoulet]

Hey folks, try this script that I call the "Skeleton Key":

/*
 *  DBA Skeleton Key
 *
 *  This script will allow one to crash into any Oracle account.
 *  The only restriction is that the invoker must have the
 *  'alter any user' system priviledge.
 */
 
accept usrname char prompt 'Enter account name to crack: '
set verify off
break on name
column gname new_value _name  noprint
select substr(global_name,1,instr(global_name,'.')-1)gname
from global_name;
clear breaks
break on password
column password new_value _pwd noprint
select password from dba_users
where username = upper('&usrname');
alter user &usrname identified by dummy;
connect &usrname/dummy@&_name
alter user &usrname identified by values '&_pwd';
@login


Dick Goulet

Reply Separator
Author: Jacques Kilchoer <[EMAIL PROTECTED]>
Date:   4/3/2001 1:16 PM

> -Original Message-
> From: Stefan Jahnke [mailto:[EMAIL PROTECTED]]
> 
> what information does the PASSWORD column in the DBA_USERS 
> view provide. 
> I know that it's the encrypted user password, but how can I 
> actually use
> it ? 
> For example: Can I reassign a password to a user via his encrypted
> password ?
> or: Can I test a logon with another user's encrpyted user password to
> test the logon ?
> I tried stuff like connect myuser/0CE92663BBC6FC34@MYDB, but that
> doesn't seem to work. 


I forget, did anyone answer this question?
You can use it with the (undocumented as far as I know) 'identified by
values' option of the alter user statement. This can be handy if you want to
sign on as user X without changing their password. Make their password
something you know, login with that password, then change their password
back to the old password. Example:

SQL> create user x identified by old_password ;

User created.

SQL> grant create session to x ;

Grant succeeded.

SQL> select password from dba_users where username = 'X' ;

PASSWORD
--
D64698D364A3B171

SQL> connect x/old_password
Connected.
SQL> alter user x identified by new_password ;

User altered.

SQL> connect x/new_password
Connected.
SQL> alter user x identified by values 'D64698D364A3B171' ;

User altered.

SQL> connect x/old_password
Connected.
SQL> 

> 
> TIA ...
> 
> -- 
> Regards,
> Stefan Jahnke
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 





RE: DBA_USERS view



> -Original Message-
> From: Stefan Jahnke [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]
]
> 
> what information does the PASSWORD column in the DBA_USERS

> view provide. 
> I know that it's the encrypted user password, but how can
I 
> actually use
> it ? 
> For example: Can I reassign a password to a user via his
encrypted
> password ?
> or: Can I test a logon with another user's encrpyted user
password to
> test the logon ?
> I tried stuff like connect myuser/0CE92663BBC6FC34@MYDB,
but that
> doesn't seem to work. 



I forget, did anyone answer this question?
You can use it with the (undocumented as far as I know)
'identified by values' option of the alter user statement. This can be handy if
you want to sign on as user X without changing their password. Make their
password something you know, login with that password, then change their
password back to the old password. Example:

SQL> create user x identified by old_password ;


User created.


SQL> grant create session to x ;


Grant succeeded.


SQL> select password from dba_users where username = 'X'
;


PASSWORD
--
D64698D364A3B171


SQL> connect x/old_password
Connected.
SQL> alter user x identified by new_password ;


User altered.


SQL> connect x/new_password
Connected.
SQL> alter user x identified by values 'D64698D364A3B171'
;


User altered.


SQL> connect x/old_password
Connected.
SQL> 


> 
> TIA ...
> 
> -- 
> Regards,
> Stefan Jahnke
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com" TARGET="_blank">http://www.orafaq.com
> -- 
> Author: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858)
538-5051  FAX: (858) 538-5051
> San Diego,
California    -- Public Internet access /
Mailing Lists
>

> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and i

RE: Slightly OT: Capturing a failed status of an ftp process

[Shari Dishop]

We considered that option but we were transferring between systems with 
different file structures.  IBM mainframe VS. different unix VS. OpenVMS VS ...

We didn't see how to use the file size in a reliable manner.

Since one of the platforms that I was using to run my tests was an OpenVMS 
system, I was even amazed when I would transfer the file to the unix SAP system 
and then transfer it back to the VMS system and it wouldn't be the same size as 
the original system.  I ran the DIFF utility on VMS and was told that the 
contents were the same but the file had a slightly different VMS block size.


Shari Dishop
SAP ABAP - Project Systems Team
Logicon - A Northrop Grumman Company
Baltimore, MD



RE:
Isn't it possible to check size of the source and remote file(s) after ftp.
If they are the same - it is a high probability that transfer was OK.

Alex Hillman

-Original Message-
From:   Shari Dishop [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 03, 2001 3:52 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Slightly OT:  Capturing a failed status of an
ftp process

Terry,
  I worked on what I think is a similar process.  We are running SAP
and need to 
be able to ftp files on and off of our unix SAP servers.  Someone in
the past 
wrote an SAP ABAP program that does all of the set up then calls a
unix shell 
script to perform the ftp.  If the ftp command truely failed to
connect we had 
no problem getting back a failed error message to the SAP program.
But where we 
ran into some problems was when the transfer command would start but
get 
interrupted for some unknown reason and never fully complete the
transfer.  This 
was noticed by accident one day when someone was checking a report
run off of 
one of the data transfers and there were only a few hundred records
in the table 
to be processed instead of a few hundred thousand.

  I was then asked to come up with a solution that would look for an
unexpected 
termination of the ftp connection.  After lots of searching and
getting one of 
our local unix gurus involved (I have worked directly on a unix
platform), we 
implemented the following.  It is not the best but it does seem to
be working.

  We added a step to the ftp script.  This step is a status command
that is 
executed directly after the get or put command.  This returns
information about 
the ftp connection itself.  It also returns a message if it is no
longer 
connected.  This output was passed back to the SAP program and
parsed.  If I had 
a message indicating that the remote host was still connected, I
assumed that 
the get or put executed completely.  If on the other hand I received
the message 
indicating that the remote system was no longer connected I
generated an error 
message from the program so that the user could check the data.


Shari Dishop
SAP ABAP - Project Systems Team
Logicon - A Northrop Grumman Company
Baltimore, MD


RE:

I think I've seen an answer to this, but I never needed it before.
If
anyone can help, I would greatly appreciate it.

We are trying to ftp files from one server to another.  (Archive
logs
   . . . 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shari Dishop
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: function to get GMT time

[Marc Perkowitz]

Terry,
You're missing the point.  There's no built-in knowledge in this function to
determine WHEN to switch from the "S" to the "D".  If you're interactively
doing this and you know you are now on DST, then this will work fine.
However, if you're doing this inside a program, there is no method to
automatically determine whether the source or target has now switched to
DST.  Plus, the time of the switch will vary from year to year.  So, you
will need to build a table to store this switchover points, by country (not
timezone as switchover times vary within timezones -- and some countries do
not have DST) and by year.

The NEW_TIME is just a simplistic function that subtracts or adds hours.
Also, there's a very limited number of timezones supported (mainly US plus
GMT).

Marc Perkowitz

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 4:23 PM


> But all you need to do is substitute the S for a D in the local time.
> select sysdate, new_time(sysdate,'MDT','GMT') from dual;
>
> The D already converts to DST for you.
>
> Terry
>
> Marc Perkowitz wrote:
>
> > Just keep in mind, as I mentioned earlier, DST is not accounted for.  So
you
> > will first need to convert from EDT to EST and then use this function.
> > Otherwise your GMT will be one hour off.  Of course, if you run your
machine
> > on EST and do not switch to EDT, you will be fine.
> >
> > Oh, I've assuming you really mean Universal Time (UT) when you're saying
> > GMT.  If you actually mean the local time for the UK, then you'll need
to
> > take their summer time change into effect also.  Their summer time took
> > effect on March 25th this year, while US DST took effect on April 1st.
So,
> > for one week the time difference was less than usual, but now the
difference
> > is consistent.
> >
> > Marc Perkowitz
> > Senior Consultant
> > TWJ Consulting, LLP
> >
> > 847-256-8866 x15
> > www.twjconsulting.com
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 03, 2001 1:19 PM
> >
> > > This gives GMT. Thanks!  Ruth
> > > - Original Message -
> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, April 03, 2001 1:15 PM
> > >
> > >
> > > > Hi Andreas,
> > > >
> > > >Please try this.
> > > >
> > > >select sysdate, new_time(sysdate,'EST','GMT') from dual;
> > > >
> > > > Thanks,
> > > > Gurdarshan
> > > >
> > > >
> > > > -Original Message-
> > > > [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, April 03, 2001 11:45 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > Hi !
> > > >
> > > > Is there a way to get GMT time within PL/SQL independent from
> > > > the local time(zone), I'm looking for a function similar to SYSDATE,
> > > > but it should return GMT instead of the local time.
> > > >
> > > >
> > > > TIA
> > > >
> > > > Andreas
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Haunschmidt Andreas VASL/FAS
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
Lists
> > > > 
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You may
> > > > also send the HELP command for other information (like subscribing).
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Singh, Gurdarshan (Gurdarshan)** CTR **
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet access / Mailing
Lists
> > > > 
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You may
> > > > also send the HELP command for other information (like subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ruth Gramolini
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
>

RE: 7.3.4 svrmgrl requiring password if called by root user

[Scott . Shafer]

Have you tried running the scripts as 'su - oracle -c '  from
root?  Or is this not possible with your current solution?

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: steve mcclure [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 3:23 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  7.3.4 svrmgrl requiring password if called by root user
> 
> My database backup scripts are failing when run by the
> root user.  I have just had the requirment to add a
> dump of all filesystems to my regular database backup
> routine.  Upon running my modified scripts as the root
> user, required for the dump, I am greeted by a request
> for a password in response to the connect internal
> command.  I can duplicate this by simply running
> svrmgrl from a prompt as the root user.  Again this is
> for Oracle 7.3.4 on DG/UX.
> 
> We are not using OS authentication, and I svrmgrl does
> NOT require a password for the other OS users I have
> tried to use.  I added the root user to the dba and
> oper groups in hopes that might solve my problem, but
> was still prompted for a password.
> 
> 
> Any help with this is appreciated.
> 
> Thanks, Steve McClure
> 
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail. 
> http://personal.mail.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: steve mcclure
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Redo log size MAX = ?

[Scott . Shafer]

True.  ;-)  But considering my foot-in-mouth disease lately, I figured I'd
phrase my response as a question...

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 2:41 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Redo log size MAX = ?
> 
> So, based on the responses I've seen, this statement can be declared to be
> false.
> 
> 
> >>> [EMAIL PROTECTED] 04/03/01 11:05AM >>>
> hi
> forget about recovery from online redo logs
> It doesn't exist in Oracle
> 
> Regards
> Tapiwa
> 
> -Original Message-
> Sent: Tuesday, April 03, 2001 3:01 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> My database = noarchive mode (compulsory for our application)
> In case of instance failure can oracle perform recovery from redo log ? if
> can what will be tne maximum size of the redo log recommended.
> Because I need set that size for whole day transaction currently 512K (3
> redo logs) switched every 15 - 30 minutes.
> Can oracle perform recovery from inactive or "other status" redo log ?
> 
> Thank you.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Locally Managed Tablespace Uniform Extent

[Miller, Jay]

My understanding was that the main reason to keep the number of extents down
was in case you needed to drop or truncate the table it would take Oracle a
long time to clean up the fet$ table.
I think, and I emphasize that I am not certain of this, that this is no
longer a problem with locally managed tablespaces.
I'm sure someone will correct me if I'm wrong...

Jay Miller

-Original Message-
Sent: Wednesday, March 14, 2001 4:59 PM
To: Multiple recipients of list ORACLE-L


Jim,

I'm probably a bit extreme here, but, with all due respect
to Steve Adams (because I really do), I wouldn't worry
terribly much about numbers of extents.

Our 8.1.6 production db on Win2k has 8KB block size and
uniform extent size of 1MB in all tablespaces.  Our largest
segment stores the out-of-line CLOBs of a partition of our
largest table - it has over 22,000 extents.  Another
partition has a CLOB segment of over 18,000 extents.  Since
we hit those segments by RowID during InterMedia Text index
queries, we've had absolutely no performance problems - we
get 1 to 5 second response times.  Actually, the InterMedia
Text index segments have over 1,000 extents.

A bunch of our tables with non-LOB data have hundreds of
extents as well, which probably puts them in line with
Steve's guidelines, but I wouldn't be worried if they got up
into the thousands of extents.

I'm sure there are numerous situations where different
extent sizes in different tablespaces makes sense.  Maybe
I'm just too lazy.  We don't have that many small tables
where 1MB extents waste a lot of space and, like I said, I
don't worry about too many extents, though if extents
approached the hundreds of thousands, I might create a
tablespace or two with large extents for those segments.
I've just not seen really convincing arguments that large
(but not huge) numbers of extents cause significant
performance problems, especially compared to the really BAD
SQL that Duhvelopers seem so fond of writing.   ;-)

A big advantage is that I can't even remember the last time
I worried about coelescing and fragmentation!

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Jim Walski
Sent: Wednesday, March 14, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L


I have to move a 7.3.4 database to 8i and I want to use the
uniform extent
size to reduce fragmentation.  I read the article "stop
defragmenting and
start living" and it indicates to have 3 extent sizes -
128K, 4M, 128M.

I also read an article on Steve Adams site that indicates to
keep the number
of extents under (db_block_size/16) - 7 ( which in my case
 8k block) would
be 505 extents. )

In the database I am moving there are some segments that are
currently 1GB
in size, if i was to put those in the 4M tablespace it would
already have
over 250 extents starting off.  Are there any other
performance type issues
to consider?

Should I create another extent size between 4M and the 128M?
Maybe 64M
increment?

Thanks,
Jim

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Slightly OT: Capturing a failed status of an ftp process

[Shari Dishop]

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

[Akhil Ramani]

Declare the cursor with a variable i.e

CURSOR AKLangTextCur (p_problem varchar)
IS 
 SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' '||
   V_ENDUHR||' '||
  rtrim(V_AUSSAGEW)||' '||
  rtrim(V_LANGTEXT)   thisText
FROM AKTIV
WHERE V_PROBLEM = p_PROBLEM
ORDER BY Aktiv_NR; 

Open the cursor with the variable passed to it. i.e

Open AKLangTextCur (p_problem);

Hope this helps 

>>> "Dasko, Dan" <[EMAIL PROTECTED]> 04/03/01 04:50PM >>>
You're probably right, I think I got stuck on the whole DECLARE BEGIN
EXCEPTION END thing.

-Original Message-
Sent: Tuesday, April 03, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


i speak from ignorance, isn't there implicit and explicit cursor
declarations and usage?  can't you encapsulate that section you have
identified in a loop and it will implicitly opens a cursor?  then all you
have to do is manipulate as needed to generate desired results...
 

===
Lerone Streeter
System Analyst
Abbott LBG
[EMAIL PROTECTED] 
=== 

-Original Message-
Sent: Tuesday, April 03, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L


You can't.  It appears that you want to select all the detailed text extries
related to a specific problem.  You could define a cursor that selects all
the detailed entries, or you could read all the detailed entries into a
pl/sql table and then search through them.  If you use the cursor, then you
have to reopen the cursor for each new problem.
 
Dan

-Original Message-
Sent: Tuesday, April 03, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L



Hey, Guys:

I need to decalre a cursor inside a FOR .. LOOP, because the variables in
SELECT statement for the CURSOR are coming from FOR .. LOOP. How could I do
this?

DECLARE
  V_AKTIV_NRaktiv.AKTIV_NR%TYPE;
  V_PROBLEMaktiv.PROBLEM%TYPE;
  V_ENDDAT   aktiv.ENDDAT%TYPE;
  V_ENDUHR   aktiv.ENDUHR%TYPE;
  V_AUSSAGEW   aktiv.AUSSAGEW%TYPE;
  V_LANGTEXT   aktiv.LANGTEXT%TYPE;
  V_LONGTEXTVARCHAR2(2);
  V_LONGTEXT_CUR  VARCHAR2(13000);
  V_LONGTEXT_TRIM VARCHAR2(2000);
  p_PROBLEMPROBLEM.PROBLEM%TYPE;  

# This part need to be inside FOR.. LOOP, otherwise, I wouldn't
get anything.

CURSOR AKLangTextCur IS 
 SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' '||
   V_ENDUHR||' '||
  rtrim(V_AUSSAGEW)||' '||
  rtrim(V_LANGTEXT)   thisText
FROM AKTIV
WHERE V_PROBLEM = p_PROBLEM
ORDER BY Aktiv_NR; 
AKLangTextRec   AKLangTextCur%ROWTYPE; 

### Above
BEGIN
  FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP
V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);
V_PROBLEM  := pkgFreeText.V_PROBLEM_P(v_LoopIndex);
V_ENDDAT   := pkgFreeText.V_ENDDAT_P(v_LoopIndex);
V_ENDUHR   := pkgFreeText.V_ENDUHR_P(v_LoopIndex);
V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);
V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex);

  SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM;

## CURSOR DECLARE should be HERE ##

BEGIN
 OPEN AKLangTextCur;
  LOOP
FETCH AKLangTextCur into AKLangTextRec;
 EXIT WHEN AKLangTextCur%NOTFOUND;
V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText;

 END LOOP;
 CLOSE AKLangTextCur;
END;  
  V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR;   

  END LOOP;
   V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000);

Thanks a lot for help

Wendy




  _  

Do You Yahoo!?
Yahoo! Mail   Personal
Address - Get email at your own domain with Yahoo! Mail. 
_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center. However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses. 



_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center. However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses. 


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

[William Beilstein]

It's actually easy. Following is an example

declare
cursor first is select work_id from my_table;

cursor second is select my_desc from my_desc_table where work_id = hold_work_id;

hold_work_id number(15);

begin
for rec in first loop
  hold_work_id := rec.work_id;
  for pnt in second loop
  code to display desc line by referencinf pnt.my_desc 
  end loop;
end loop;
end;




>>> [EMAIL PROTECTED] 04/03/01 04:50PM >>>
You're probably right, I think I got stuck on the whole DECLARE BEGIN
EXCEPTION END thing.

-Original Message-
Sent: Tuesday, April 03, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


i speak from ignorance, isn't there implicit and explicit cursor
declarations and usage?  can't you encapsulate that section you have
identified in a loop and it will implicitly opens a cursor?  then all you
have to do is manipulate as needed to generate desired results...
 

===
Lerone Streeter
System Analyst
Abbott LBG
[EMAIL PROTECTED] 
=== 

-Original Message-
Sent: Tuesday, April 03, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L


You can't.  It appears that you want to select all the detailed text extries
related to a specific problem.  You could define a cursor that selects all
the detailed entries, or you could read all the detailed entries into a
pl/sql table and then search through them.  If you use the cursor, then you
have to reopen the cursor for each new problem.
 
Dan

-Original Message-
Sent: Tuesday, April 03, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L



Hey, Guys:

I need to decalre a cursor inside a FOR .. LOOP, because the variables in
SELECT statement for the CURSOR are coming from FOR .. LOOP. How could I do
this?

DECLARE
  V_AKTIV_NRaktiv.AKTIV_NR%TYPE;
  V_PROBLEMaktiv.PROBLEM%TYPE;
  V_ENDDAT   aktiv.ENDDAT%TYPE;
  V_ENDUHR   aktiv.ENDUHR%TYPE;
  V_AUSSAGEW   aktiv.AUSSAGEW%TYPE;
  V_LANGTEXT   aktiv.LANGTEXT%TYPE;
  V_LONGTEXTVARCHAR2(2);
  V_LONGTEXT_CUR  VARCHAR2(13000);
  V_LONGTEXT_TRIM VARCHAR2(2000);
  p_PROBLEMPROBLEM.PROBLEM%TYPE;  

# This part need to be inside FOR.. LOOP, otherwise, I wouldn't
get anything.

CURSOR AKLangTextCur IS 
 SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' '||
   V_ENDUHR||' '||
  rtrim(V_AUSSAGEW)||' '||
  rtrim(V_LANGTEXT)   thisText
FROM AKTIV
WHERE V_PROBLEM = p_PROBLEM
ORDER BY Aktiv_NR; 
AKLangTextRec   AKLangTextCur%ROWTYPE; 

### Above
BEGIN
  FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP
V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);
V_PROBLEM  := pkgFreeText.V_PROBLEM_P(v_LoopIndex);
V_ENDDAT   := pkgFreeText.V_ENDDAT_P(v_LoopIndex);
V_ENDUHR   := pkgFreeText.V_ENDUHR_P(v_LoopIndex);
V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);
V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex);

  SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM;

## CURSOR DECLARE should be HERE ##

BEGIN
 OPEN AKLangTextCur;
  LOOP
FETCH AKLangTextCur into AKLangTextRec;
 EXIT WHEN AKLangTextCur%NOTFOUND;
V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText;

 END LOOP;
 CLOSE AKLangTextCur;
END;  
  V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR;   

  END LOOP;
   V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000);

Thanks a lot for help

Wendy




  _  

Do You Yahoo!?
Yahoo! Mail   Personal
Address - Get email at your own domain with Yahoo! Mail. 
_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center. However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses. 



_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center. However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses. 


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Slightly OT: Capturing a failed status of an ftp process

[Terry Ball]

Would it be possible for you to send me a copy of how you are using the status
command?  I have tried, but I am obviously doing it wrong, as I am not getting what
I expect.

Terry

Shari Dishop wrote:

> Terry,
>   I worked on what I think is a similar process.  We are running SAP and need to
> be able to ftp files on and off of our unix SAP servers.  Someone in the past
> wrote an SAP ABAP program that does all of the set up then calls a unix shell
> script to perform the ftp.  If the ftp command truely failed to connect we had
> no problem getting back a failed error message to the SAP program.  But where we
> ran into some problems was when the transfer command would start but get
> interrupted for some unknown reason and never fully complete the transfer.  This
> was noticed by accident one day when someone was checking a report run off of
> one of the data transfers and there were only a few hundred records in the table
> to be processed instead of a few hundred thousand.
>
>   I was then asked to come up with a solution that would look for an unexpected
> termination of the ftp connection.  After lots of searching and getting one of
> our local unix gurus involved (I have worked directly on a unix platform), we
> implemented the following.  It is not the best but it does seem to be working.
>
>   We added a step to the ftp script.  This step is a status command that is
> executed directly after the get or put command.  This returns information about
> the ftp connection itself.  It also returns a message if it is no longer
> connected.  This output was passed back to the SAP program and parsed.  If I had
> a message indicating that the remote host was still connected, I assumed that
> the get or put executed completely.  If on the other hand I received the message
> indicating that the remote system was no longer connected I generated an error
> message from the program so that the user could check the data.
>
> Shari Dishop
> SAP ABAP - Project Systems Team
> Logicon - A Northrop Grumman Company
> Baltimore, MD

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

[Jacques Kilchoer]

Title: RE: Help - How to declare a cursor inside a FOR ... LOOP ?





I must say that I am confused by the previous answers. It looks to me that the COLUMN NAMES are changing for the SQL statement. If so, you need to use dynamic SQL. Here's a short example below. You can read all about the dbms_sql procedure for dynamic SQL in the excellent Feuerstein, Dye and Beresniewicz book "Oracle Built-in Packages" (O'Reilly).

set serveroutput on
declare
   c_dynsql pls_integer ;
   ignore pls_integer ;
   num_rows pls_integer ;
   v_emp_no emp.emp_no%type ;
   v_emp_name emp.emp_name%type ;
   v_emp_name_len constant pls_integer := 30 ;
   col1_name varchar2 (30) ;
   col2_name varchar2 (30) ;
begin
   col1_name := 'emp_no' ;
   col2_name := 'emp_name' ;
   c_dynsql := dbms_sql.open_cursor ;
   dbms_sql.parse (c_dynsql,
   'select ' || col1_name || ', '
  || col2_name
  || ' from emp where rownum < 3',
   dbms_sql.native) ;
   dbms_sql.define_column (c_dynsql, 1, v_emp_no) ;
   dbms_sql.define_column (c_dynsql, 2, v_emp_name, v_emp_name_len) ;
   ignore := dbms_sql.execute (c_dynsql) ;
   num_rows := 1 ;
   while num_rows > 0
   loop
 num_rows := dbms_sql.fetch_rows (c_dynsql) ;
 if num_rows > 0
 then
   dbms_sql.column_value (c_dynsql, 1, v_emp_no) ;
   dbms_sql.column_value (c_dynsql, 2, v_emp_name) ;
   dbms_output.put_line ('Emp#: ' || to_char (v_emp_no)
 || '  Name: ' || v_emp_name) ;
 end if ;
   end loop ;
   dbms_sql.close_cursor (c_dynsql) ;
exception
   when others then
 if dbms_sql.is_open (c_dynsql)
 then
    dbms_sql.close_cursor (c_dynsql) ;
 end if ;
 raise ;
end ;
/


>-Original Message-
>From: Wendy Y [mailto:[EMAIL PROTECTED]]
>
>Hey, Guys:
>I need to decalre a cursor inside a FOR .. LOOP,
> because the variables in SELECT statement
>for the CURSOR are coming from FOR .. LOOP.
> How could I do this?
>DECLARE
>  V_AKTIV_NR    aktiv.AKTIV_NR%TYPE;
>  V_PROBLEM    aktiv.PROBLEM%TYPE;
>  V_ENDDAT   aktiv.ENDDAT%TYPE;
>  V_ENDUHR   aktiv.ENDUHR%TYPE;
>  V_AUSSAGEW   aktiv.AUSSAGEW%TYPE;
>  V_LANGTEXT   aktiv.LANGTEXT%TYPE;
>  V_LONGTEXT    VARCHAR2(2);
>  V_LONGTEXT_CUR  VARCHAR2(13000);
>  V_LONGTEXT_TRIM VARCHAR2(2000);
>  p_PROBLEM    PROBLEM.PROBLEM%TYPE;  
># This part need to be inside FOR.. LOOP, otherwise, I wouldn't get anything.
>    CURSOR AKLangTextCur IS 
> SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' '||
>   V_ENDUHR||' '||
>  rtrim(V_AUSSAGEW)||' '||
>  rtrim(V_LANGTEXT)   thisText
>    FROM AKTIV
>    WHERE V_PROBLEM = p_PROBLEM
>    ORDER BY Aktiv_NR; 
>    AKLangTextRec   AKLangTextCur%ROWTYPE; 
>### Above
>BEGIN
>  FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP
>    V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);
>    V_PROBLEM  := pkgFreeText.V_PROBLEM_P(v_LoopIndex);
>    V_ENDDAT   := pkgFreeText.V_ENDDAT_P(v_LoopIndex);
>    V_ENDUHR   := pkgFreeText.V_ENDUHR_P(v_LoopIndex);
>    V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);
>    V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex);
>  SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM;
>## CURSOR DECLARE should be HERE ##
>    BEGIN
> OPEN AKLangTextCur;
>  LOOP
>    FETCH AKLangTextCur into AKLangTextRec;
> EXIT WHEN AKLangTextCur%NOTFOUND;
>    V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText; 
> END LOOP;
> CLOSE AKLangTextCur;
>    END;  
>  V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR;   
>  END LOOP;
>   V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000);

Re: A problem to ponder

[William Beilstein]

Have you tried rebuilding your indexes to balance them. If you are running cost based, 
have you rebuilt your statistics recently? Is this report using a table that is being 
used as a work table by other processes?

>>> [EMAIL PROTECTED] 04/03/01 05:07PM >>>
V7.3.4.5 on V2.6 Solaris, if it matters.

We generate a bunch 200+ reports (plz don't ask if they are all necessary)
nightly via a series of tasks linked togther via shell scripts.

In February & many, many months before that this one report was
averaging 20 minutes plus/minus 4 minutes to complete; night in
and night out. Around  5 March this single report would either
"never" finish, take 1 - 3 HOURS to complete or complete in 
about 20 minutes; WITHOUT any apparent reason for the change in
elapsed run times.

As far as we can tell "nothing has changed"!
We've been unable to discern what is different between the nights
where it completes in 20 minutes and nights where it does not. On
those nights where it "never completes" if the session is KILLED
and then re-run manually is ALWAYS completes in about 20 minutes.

At this point in time this report is an annoyance and a mystery.
We can live with the strange behavior, but would like to better
understand why the elapsed times are so erratic. Running bstat/
estat while the report was on the system did not reveal any 
meaninful results.

I'm asking for ideas and suggestions as I'm at a loss.

TIA & HAND!
Charlie M.

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
The future is here. It is just not evenly distributed.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Command to view stored procedure

[Jacques Kilchoer]

Title: RE: SQL Command to view stored procedure





>-Original Message-
>From: Webber Valerie H [mailto:[EMAIL PROTECTED]]
>
>What is the SQL command, v$ table or SQL*Plus command to
>see the contents of a stored
>procedure? 
>I looked at DBA_SOURCE but it stored the code in
> separate rows based on the owner and procedure name.


You can use dba_source
select text
from dba_source
where owner = 'PROCEDURE_OWNER'
  and name = 'PROCEDURE_NAME'
order by type, line ;

RE: Recovery Manager vs. SQL Back Track

[Claudio Roca]

I'm using RMAN also, it works very good.
By the way:
any way to automate delete obsolete backuppieces?
I'm doing backup to disk with RMAN, and want to delete backuppieces from
obsolete backupsets.
If i do a crosscheck, it won't mark files as expired because files are still
on disk.
Cannot also use CHANGE DELETE command, because i need to know the obsolete
pieces firstthat's what i'm trying to automate. Besides, we have 142
remote db being backed up with a local RMAN catalog, and it's a lil' complex
to manually monitor all the obsolete backupsets.

Any script/idea willbe appreciated.
RDBMS 8.1.6.0
RMAN 8.1.6.0
Solaris 2.6


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 3:26 PM


> You cannot send a PDF attachment thru the list as far as I know.
>
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 03, 2001 2:07 PM
>
>
> Send it through the list.  I would like to see it also.  Thanks.
>
> >>> [EMAIL PROTECTED] 04/03/01 11:56AM >>>
> I have used rman exclusively since I became an Oracle DBA because it was
> there and I needed a backup strategy.  It has gotten better with later
> releases.  We are now on 8.0.6.  It used Oracle internals so that is an
> advantage. It comes free with Oracle so that is another advantage.
>
> I can send you a paper on why to love rman written by Francis Sanchez of
> Oracle Corp.  if you need it.  I can't send an attachment through the
list.
>
> Regards,
> Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 03, 2001 10:45 AM
>
>
> > Hi everyone -
> >
> > Currently we are doing backups manually, periodic cold backups, and hot
> > backups in between - we are running in archivelog mode.  We are running
> > 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris.  Today there are only
a
> > few small production servers (2 - 5 GB), but we are anticipating a
couple
> > large ones (~200GB), and a data warehouse (anticipated to be around
> 500GB).
> >
> > We have started playing around with Recovery Manager.  Our Sybase DBAs
are
> > telling us we should look at SQL BackTrack instead.
> >
> > For those of you who are using either one, I'd appreciate your comments
on
> > how well you like / don't like it and any "gotcha's" that you have run
> into.
> > Other than the cost factor, what would you recommend?
> >
> > Thanks very much -
> > Lisa
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gene Sais
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'List

Re: function to get GMT time

[Terry Ball]

But all you need to do is substitute the S for a D in the local time.
select sysdate, new_time(sysdate,'MDT','GMT') from dual;

The D already converts to DST for you.

Terry

Marc Perkowitz wrote:

> Just keep in mind, as I mentioned earlier, DST is not accounted for.  So you
> will first need to convert from EDT to EST and then use this function.
> Otherwise your GMT will be one hour off.  Of course, if you run your machine
> on EST and do not switch to EDT, you will be fine.
>
> Oh, I've assuming you really mean Universal Time (UT) when you're saying
> GMT.  If you actually mean the local time for the UK, then you'll need to
> take their summer time change into effect also.  Their summer time took
> effect on March 25th this year, while US DST took effect on April 1st.  So,
> for one week the time difference was less than usual, but now the difference
> is consistent.
>
> Marc Perkowitz
> Senior Consultant
> TWJ Consulting, LLP
>
> 847-256-8866 x15
> www.twjconsulting.com
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 03, 2001 1:19 PM
>
> > This gives GMT. Thanks!  Ruth
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 03, 2001 1:15 PM
> >
> >
> > > Hi Andreas,
> > >
> > >Please try this.
> > >
> > >select sysdate, new_time(sysdate,'EST','GMT') from dual;
> > >
> > > Thanks,
> > > Gurdarshan
> > >
> > >
> > > -Original Message-
> > > [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, April 03, 2001 11:45 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hi !
> > >
> > > Is there a way to get GMT time within PL/SQL independent from
> > > the local time(zone), I'm looking for a function similar to SYSDATE,
> > > but it should return GMT instead of the local time.
> > >
> > >
> > > TIA
> > >
> > > Andreas
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Haunschmidt Andreas VASL/FAS
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Singh, Gurdarshan (Gurdarshan)** CTR **
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing Lists
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Marc Perkowitz
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX:

RE: DBA_USERS view

[Jacques Kilchoer]

Title: RE: DBA_USERS view





> -Original Message-
> From: Stefan Jahnke [mailto:[EMAIL PROTECTED]]
> 
> what information does the PASSWORD column in the DBA_USERS 
> view provide. 
> I know that it's the encrypted user password, but how can I 
> actually use
> it ? 
> For example: Can I reassign a password to a user via his encrypted
> password ?
> or: Can I test a logon with another user's encrpyted user password to
> test the logon ?
> I tried stuff like connect myuser/0CE92663BBC6FC34@MYDB, but that
> doesn't seem to work. 



I forget, did anyone answer this question?
You can use it with the (undocumented as far as I know) 'identified by values' option of the alter user statement. This can be handy if you want to sign on as user X without changing their password. Make their password something you know, login with that password, then change their password back to the old password. Example:

SQL> create user x identified by old_password ;


User created.


SQL> grant create session to x ;


Grant succeeded.


SQL> select password from dba_users where username = 'X' ;


PASSWORD
--
D64698D364A3B171


SQL> connect x/old_password
Connected.
SQL> alter user x identified by new_password ;


User altered.


SQL> connect x/new_password
Connected.
SQL> alter user x identified by values 'D64698D364A3B171' ;


User altered.


SQL> connect x/old_password
Connected.
SQL> 


> 
> TIA ...
> 
> -- 
> Regards,
> Stefan Jahnke
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

OraGeeks$ : SUPPORT FOR SITE

[Raj Sakthi]

Hi Folks ,
I am sure some of you would be remembering 
"orageeks " website http://www.interealm.com/orageeks/
Well.the site owner Roby Sherman who is a frequent
poster in this site has closed the site down . When I
asked the reason he sent me the following . I agree
with his sentiments . Thought since this a place real
talent hangs out I thought some of you could chip in .

" Hi Raj:

More or less, I was looking for volunteers to help
maintain the 
technical content of the directory. That means helping
me with finding 
new resources (that weren't links to some company's
product) to add to 
the directory on an ongoing basis, communicating with
me when they 
found 
a resource that was outdated or inappropriate, help
with the addition / 
modification of directory categories, Etc. Heck, even
contributing a 
small technical note once in a blue moon wouldn't have
hurt either.

Cheers!
--Roby
"
Cheers
RS

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Sakthi
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RevealNet

[Veronica Levin]

Hi, 
I've been using it for a while and I find it very useful to do my work, I
saves time!

Saludos,

Verónica Levin Enríquez
Administrador AIX
Compañía Cervecera de Nicaragua
Teléfono: 505-2493779
Fax: 505-2443979
Beeper: 2784800- Unidad 8507
Celular: 088-63244
Email: [EMAIL PROTECTED] 
http://www.victoria.com.ni



-Mensaje original-
De: Dwayne Cox [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes 2 de Abril de 2001 9:31 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: RevealNet


I have been using RevealNet Knowledgebase and Instant Messages for a 
couple years now I find them indispensible.  IMHO, I think its what the
Oracle online docs should be.

Ravindra Basavaraja wrote:
> 
> Gurus,
> 
> I wanted some inputs on Revealnet knowledge base.If anyone is using this,i
> want to how
> useful has it been.
> 
> Are there any other tools that I can look in.


__
Dwayne Cox
DBA, Development Dept.
Info Tech, Inc.
[EMAIL PROTECTED]
http://www.infotech.com
___
The opinions expressed are the author's own unless otherwise stated
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Veronica Levin
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Metalink Response ....FYI

[Mohan, Ross]

Title: RE: Metalink Response FYI





Ruth, 


Thanks, your perception matches mine. See, in particular,(3) below. 
And although I certainly appreciate your expression of concern/support,
it is Metalink's job, not mine that I am sharply disappointed with. 


Fortunately, it is still politically correct to express sharp
disappointment at the foibles of big business!  


Thanks again!


Regards, 


- Ross



##


1 Having or being a taste that is sharp, acrid, and unpleasant. 


2 Causing a sharply unpleasant, painful, or stinging sensation; harsh: 
    enveloped in bitter cold; a bitter wind.  


3 Difficult or distasteful to accept, admit, or bear: the bitter truth; bitter sorrow. 


4 Proceeding from or exhibiting strong animosity: a bitter struggle; bitter foes. 


5 Resulting from or expressive of severe grief, anguish, or disappointment: cried bitter tears. 


6 Marked by resentment or cynicism: "He was already a bitter elderly man with a gray face" (John Dos Passos). 


<==>   -Original Message-
<==>   From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
<==>   Sent: Tuesday, April 03, 2001 4:36 PM
<==>   To: Multiple recipients of list ORACLE-L
<==>   Subject: Re: Metalink Response FYI
<==>   
<==>   
<==>   Ross,
<==>   You sound bitter...just remember it is only your job, 
<==>   not your life.  Let
<==>   them founder, you will still have a job.
<==>   
<==>   Ruth
<==>   - Original Message -
<==>   To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
<==>   Sent: Tuesday, April 03, 2001 4:10 PM
<==>   
<==>   
<==>   > Randy Baker left, yes...and another fellow...forced 
<==>   out, virtually.
<==>   >
<==>   > Then, the cost cutting began. People attrited or let 
<==>   go...cheaper
<==>   > monitors and equipment...reduced training budgets.
<==>   >
<==>   > "We Saved a Billion Dollars Last Year" by not doing their job.
<==>   >
<==>   >
<==>   > <==>   -Original Message-
<==>   > <==>   From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
<==>   > <==>   Sent: Tuesday, April 03, 2001 3:22 PM
<==>   > <==>   To: Multiple recipients of list ORACLE-L
<==>   > <==>   Subject: RE: Metalink Response FYI
<==>   > <==>
<==>   > <==>
<==>   > <==>   Steve,
<==>   > <==>
<==>   > <==>   Thanks for the very interesting comments. Are 
<==>   those webified
<==>   > <==>   apps with similar requirements as metalink?
<==>   > <==>
<==>   > <==>   Also, didn't the VP in charge of support leave 
<==>   Oracle about a
<==>   > <==>   year or so ago?
<==>   > <==>
<==>   > <==>
<==>   > <==>   regards,
<==>   > <==>   ep
<==>   > <==>
<==>   > <==>   On 3 Apr 2001, at 7:26, Steve Adams wrote:
<==>   > <==>
<==>   > <==>
<==>   > <==>   > I'd say that there must be something badly wrong with
<==>   > <==>   the application if it
<==>   > <==>   > cannot cope with 1,500 concurrent users. I know of
<==>   > <==>   sites supporting more than 20
<==>   > <==>   > times that number of active users on a single server
<==>   > <==>   with consistent sub-second
<==>   > <==>   > response times.
<==>   > <==>
<==>   > <==>   ...
<==>   > <==>
<==>   > <==>   --
<==>   > <==>   Please see the official ORACLE-L FAQ: 
http://www.orafaq.com
> <==>   --
> <==>   Author: Eric D. Pierce
> <==> INET: [EMAIL PROTECTED]
> <==>
> <==>   Fat City Network Services    -- (858) 538-5051  FAX:
> <==>   (858) 538-5051
> <==>   San Diego, California    -- Public Internet access /
> <==>   Mailing Lists
> <==>   -
> <==>   ---
> <==>   To REMOVE yourself from this mailing list, send an E-Mail message
> <==>   to: [EMAIL PROTECTED] (note EXACT spelling of
> <==>   'ListGuru') and in
> <==>   the message BODY, include a line containing: UNSUB ORACLE-L
> <==>   (or the name of mailing list you want to be removed
> <==>   from).  You may
> <==>   also send the HELP command for other information (like
> <==>   subscribing).
> <==>
>


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 7.3.4 svrmgrl requiring password if called by root user

[Claudio Roca]

Are you using password files?
1) Check if some orapwSID file exists.
if exists, then, internal user will always be required to authenticate
in order to login. (except that
'dba' group is granted at os level.
2) Check $ORACLE_HOME/rdbms/lib/config.s file for some  string
like:
/* 0x0008 15 */ .ascii  "dba\0"

The 'dba' string indicates that group DBA must be asigned to the user that
will be used to connect as internal.
If other string is used, then, you must use that os group as DBA role, and
you must grant that
group at os level.

Hope it helps

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 5:23 PM


> My database backup scripts are failing when run by the
> root user.  I have just had the requirment to add a
> dump of all filesystems to my regular database backup
> routine.  Upon running my modified scripts as the root
> user, required for the dump, I am greeted by a request
> for a password in response to the connect internal
> command.  I can duplicate this by simply running
> svrmgrl from a prompt as the root user.  Again this is
> for Oracle 7.3.4 on DG/UX.
>
> We are not using OS authentication, and I svrmgrl does
> NOT require a password for the other OS users I have
> tried to use.  I added the root user to the dba and
> oper groups in hopes that might solve my problem, but
> was still prompted for a password.
>
>
> Any help with this is appreciated.
>
> Thanks, Steve McClure
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: steve mcclure
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQL Command to view stored procedure

[Ron Rogers]

Valerie,
The text for the procedures are stored in the dba_source tables. Set your environment 
to a longer line and select the text where name = procedure.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 04/03/01 04:35PM >>>
What is the SQL command, v$ table or SQL*Plus command to see the contents of
a stored procedure?

I looked at DBA_SOURCE but it stored the code in separate rows based on the
owner and procedure name. Is there any way to see the source code for OEM
view of the procedures? It displays what I want to see but developer doesn't
have access to OEM.

Thanks in advance.
Val

Valerie H. Webber 
Management Systems Designers, Inc
Database Administrator 
[EMAIL PROTECTED] 
704-566-5321 



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Slightly OT: Capturing a failed status of an ftp process

[Hillman, Alex]

Isn't it possible to check size of the source and remote file(s) after ftp.
If they are the same - it is a high probability that transfer was OK.

Alex Hillman

-Original Message-
From:   Shari Dishop [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 03, 2001 3:52 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Slightly OT:  Capturing a failed status of an
ftp process

Terry,
  I worked on what I think is a similar process.  We are running SAP
and need to 
be able to ftp files on and off of our unix SAP servers.  Someone in
the past 
wrote an SAP ABAP program that does all of the set up then calls a
unix shell 
script to perform the ftp.  If the ftp command truely failed to
connect we had 
no problem getting back a failed error message to the SAP program.
But where we 
ran into some problems was when the transfer command would start but
get 
interrupted for some unknown reason and never fully complete the
transfer.  This 
was noticed by accident one day when someone was checking a report
run off of 
one of the data transfers and there were only a few hundred records
in the table 
to be processed instead of a few hundred thousand.

  I was then asked to come up with a solution that would look for an
unexpected 
termination of the ftp connection.  After lots of searching and
getting one of 
our local unix gurus involved (I have worked directly on a unix
platform), we 
implemented the following.  It is not the best but it does seem to
be working.

  We added a step to the ftp script.  This step is a status command
that is 
executed directly after the get or put command.  This returns
information about 
the ftp connection itself.  It also returns a message if it is no
longer 
connected.  This output was passed back to the SAP program and
parsed.  If I had 
a message indicating that the remote host was still connected, I
assumed that 
the get or put executed completely.  If on the other hand I received
the message 
indicating that the remote system was no longer connected I
generated an error 
message from the program so that the user could check the data.


Shari Dishop
SAP ABAP - Project Systems Team
Logicon - A Northrop Grumman Company
Baltimore, MD


RE:

I think I've seen an answer to this, but I never needed it before.
If
anyone can help, I would greatly appreciate it.

We are trying to ftp files from one server to another.  (Archive
logs
for Oracle).  We want to be able to capture the status when the ftp
fails, so that we can notify the DBAs to check the process out.
This is
all being done within a shell script that compress the log file
first,
then calls another script to do the actual ftp.  But when the child
script executes, it returns a successful status to the parent
script.  I
don't know any way to tell the script that is doing the ftp to send
the
message, because any non-ftp command within that script fails.  (Of
course, that could just be because I don't know how to do what I
want to
do).

If anybody has invented this wheel before, or has any tips on where
to
look for more info on how to do what I need to do, please let me
know.

TIA,

Terry

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be r

A problem to ponder

[Charlie Mengler]

V7.3.4.5 on V2.6 Solaris, if it matters.

We generate a bunch 200+ reports (plz don't ask if they are all necessary)
nightly via a series of tasks linked togther via shell scripts.

In February & many, many months before that this one report was
averaging 20 minutes plus/minus 4 minutes to complete; night in
and night out. Around  5 March this single report would either
"never" finish, take 1 - 3 HOURS to complete or complete in 
about 20 minutes; WITHOUT any apparent reason for the change in
elapsed run times.

As far as we can tell "nothing has changed"!
We've been unable to discern what is different between the nights
where it completes in 20 minutes and nights where it does not. On
those nights where it "never completes" if the session is KILLED
and then re-run manually is ALWAYS completes in about 20 minutes.

At this point in time this report is an annoyance and a mystery.
We can live with the strange behavior, but would like to better
understand why the elapsed times are so erratic. Running bstat/
estat while the report was on the system did not reveal any 
meaninful results.

I'm asking for ideas and suggestions as I'm at a loss.

TIA & HAND!
Charlie M.

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
The future is here. It is just not evenly distributed.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

[Dasko, Dan]

You're 
probably right, I think I got stuck on the whole DECLARE BEGIN EXCEPTION END 
thing.

  -Original Message-From: Streeter, Lerone A LBX 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 4:36 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Help - How to declare a cursor inside a FOR ... LOOP ?
  i 
  speak from ignorance, isn't there implicit and explicit cursor declarations 
  and usage?  can't you encapsulate that section you have identified in a 
  loop and it will implicitly opens a cursor?  then all you have to do is 
  manipulate as needed to generate desired results...
   
  ===Lerone 
  StreeterSystem AnalystAbbott 
  LBG[EMAIL PROTECTED]=== 
  
  
-Original Message-From: Dasko, Dan 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 3:41 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Help - How to declare a cursor inside a FOR ... LOOP ?
You can't.  It appears that you want to select 
all the detailed text extries related to a specific problem.  You could 
define a cursor that selects all the detailed entries, or you could read all 
the detailed entries into a pl/sql table and then search through them.  
If you use the cursor, then you have to reopen the cursor for each new 
problem.
 
Dan

  -Original Message-From: Wendy Y 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 2:51 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Help - How to declare a cursor inside a FOR ... LOOP 
?
  Hey, Guys:
  I need to decalre a cursor inside a FOR .. LOOP, because the 
  variables in SELECT statement for the CURSOR are coming from FOR .. 
  LOOP. How could I do this?
  DECLARE  V_AKTIV_NR    
  aktiv.AKTIV_NR%TYPE;  V_PROBLEM    
  aktiv.PROBLEM%TYPE;  V_ENDDAT   
  aktiv.ENDDAT%TYPE;  V_ENDUHR   
  aktiv.ENDUHR%TYPE;  V_AUSSAGEW   
  aktiv.AUSSAGEW%TYPE;  V_LANGTEXT   
  aktiv.LANGTEXT%TYPE;  V_LONGTEXT    
  VARCHAR2(2);  V_LONGTEXT_CUR  VARCHAR2(13000);  
  V_LONGTEXT_TRIM VARCHAR2(2000);  p_PROBLEM    
  PROBLEM.PROBLEM%TYPE;  
  # This part need to be 
  inside FOR.. LOOP, otherwise, I wouldn't get anything.
      CURSOR AKLangTextCur 
  IS  SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' 
  '||   V_ENDUHR||' '||  rtrim(V_AUSSAGEW)||' 
  '||  rtrim(V_LANGTEXT)   
  thisText    FROM 
  AKTIV    WHERE V_PROBLEM = 
  p_PROBLEM    ORDER BY 
  Aktiv_NR; AKLangTextRec   
  AKLangTextCur%ROWTYPE; 
  ### AboveBEGIN  FOR v_LoopIndex IN 
  1..pkgFreeText.v_NumEntries LOOP    V_AKTIV_NR := 
  pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);    
  V_PROBLEM  := 
  pkgFreeText.V_PROBLEM_P(v_LoopIndex);    
  V_ENDDAT   := 
  pkgFreeText.V_ENDDAT_P(v_LoopIndex);    
  V_ENDUHR   := 
  pkgFreeText.V_ENDUHR_P(v_LoopIndex);    V_AUSSAGEW := 
  pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);    V_LANGTEXT := 
  pkgFreeText.V_LANGTEXT_P(v_LoopIndex);
    SELECT PROBLEM INTO p_PROBLEM FROM 
  PROBLEM;
  ## CURSOR DECLARE should be 
  HERE ##
      BEGIN OPEN 
  AKLangTextCur;  
  LOOP    
  FETCH AKLangTextCur into 
  AKLangTextRec;    
   EXIT WHEN 
  AKLangTextCur%NOTFOUND;    
  V_LONGTEXT_CUR := V_LONGTEXT_CUR 
  ||AKLangTextRec.thisText; 
       END 
  LOOP; CLOSE 
  AKLangTextCur;    
  END;V_LONGTEXT 
  := V_LONGTEXT || V_LONGTEXT_CUR;   
    END LOOP;   V_LONGTEXT_TRIM := 
  RTRIM(V_LONGTEXT, 2000);
  Thanks a lot for help
  Wendy
  
  
  Do You Yahoo!?Yahoo! Mail 
  Personal Address - Get email at your own domain with Yahoo! Mail. 
  _This 
  e-mail message has been scanned for the presence of all known computer 
  viruses by the MessageLabs Virus Control Center. However, it is still 
  recommended that you use local virus scanning software to monitor for the 
  presence of viruses. 
  _This 
  e-mail message has been scanned for the presence of all known computer viruses 
  by the MessageLabs Virus Control Center. However, it is still recommended that 
  you use local virus scanning software to monitor for the presence of viruses. 
  

Re: Metalink Response ....FYI

[Ruth Gramolini]

Ross,
You sound bitter...just remember it is only your job, not your life.  Let
them founder, you will still have a job.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 4:10 PM


> Randy Baker left, yes...and another fellow...forced out, virtually.
>
> Then, the cost cutting began. People attrited or let go...cheaper
> monitors and equipment...reduced training budgets.
>
> "We Saved a Billion Dollars Last Year" by not doing their job.
>
>
> <==>   -Original Message-
> <==>   From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> <==>   Sent: Tuesday, April 03, 2001 3:22 PM
> <==>   To: Multiple recipients of list ORACLE-L
> <==>   Subject: RE: Metalink Response FYI
> <==>
> <==>
> <==>   Steve,
> <==>
> <==>   Thanks for the very interesting comments. Are those webified
> <==>   apps with similar requirements as metalink?
> <==>
> <==>   Also, didn't the VP in charge of support leave Oracle about a
> <==>   year or so ago?
> <==>
> <==>
> <==>   regards,
> <==>   ep
> <==>
> <==>   On 3 Apr 2001, at 7:26, Steve Adams wrote:
> <==>
> <==>
> <==>   > I'd say that there must be something badly wrong with
> <==>   the application if it
> <==>   > cannot cope with 1,500 concurrent users. I know of
> <==>   sites supporting more than 20
> <==>   > times that number of active users on a single server
> <==>   with consistent sub-second
> <==>   > response times.
> <==>
> <==>   ...
> <==>
> <==>   --
> <==>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
> <==>   --
> <==>   Author: Eric D. Pierce
> <==> INET: [EMAIL PROTECTED]
> <==>
> <==>   Fat City Network Services-- (858) 538-5051  FAX:
> <==>   (858) 538-5051
> <==>   San Diego, California-- Public Internet access /
> <==>   Mailing Lists
> <==>   -
> <==>   ---
> <==>   To REMOVE yourself from this mailing list, send an E-Mail message
> <==>   to: [EMAIL PROTECTED] (note EXACT spelling of
> <==>   'ListGuru') and in
> <==>   the message BODY, include a line containing: UNSUB ORACLE-L
> <==>   (or the name of mailing list you want to be removed
> <==>   from).  You may
> <==>   also send the HELP command for other information (like
> <==>   subscribing).
> <==>
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: "AT" scheduler

[David Messer]

I've gotten similarly odd performance from AT.  I find that it, among other
issues, doesn't do well if there are gaps in the list of job ids.  For
instance, if jobs are 1,2,3,19,20,21 (as a result of deleting and re-adding
jobs) then jobs 1,2,and 3 run but not the others.  Restarting the Schedule
service seems to prompt a renumbering that seems to solve that problem.
I've yet to see any documentation that explains the odd behavior.

David

-Original Message-
Patrice J
Sent: Tuesday, April 03, 2001 11:22 AM
To: Multiple recipients of list ORACLE-L


If you are running on NT, I strongly recommend you obtain crontab for
Windows.

AT will run 99.99% of the time... but not 100% of the time.  On one of the
servers here AT failed to run the very night that we were changing the time
last Fall, very suspicious in my opinion.

In any case for AT just do:

at hh24:mm /every:M,T,W,Th,F,S,Su cmd /c pointer_to_my_script_or_program

e.g.
at 22:00 /every:M,T,W,Th,F cmd /c c:\pat\coldbackup.cmd

That will create an entry:
Added a new job with Job ID = 

To see the listing, just type AT [enter]

To remove an entry,

at ID_num /delete
e.g.
at 12 /delete

Don't try to keep your jobs listing in any particular order, NT shuffles
them around sometimes when you do maintenance on the server or when you
reboot.

For AT jobs to run, of course the Scheduler service must be running.  The
service has a couple of different names, depending on which service pack you
installed on your server.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada


> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 1:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  "AT" scheduler
>
>
> Can anyone tell me how to schedule a batch job to run every 5 minutes
> using
> the "AT" scheduler?
>
> Thanks!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQL Command to view stored procedure

[Webber Valerie H]

Title: SQL Command to view stored procedure





What is the SQL command, v$ table or SQL*Plus command to see the contents of a stored procedure?


I looked at DBA_SOURCE but it stored the code in separate rows based on the owner and procedure name. Is there any way to see the source code for OEM view of the procedures? It displays what I want to see but developer doesn't have access to OEM.

Thanks in advance.
Val


Valerie H. Webber
Management Systems Designers, Inc
Database Administrator
[EMAIL PROTECTED]
704-566-5321 

Re: Slightly OT: Capturing a failed status of an ftp process

[Terry Ball]

I tried this, but the exit from the ftp is successful, so the return code ends up 
being successful also.

Terry

Gene Sais wrote:

> i find the easiest thing to do is put the ftp code in a function within the shell 
>script.  call the function from the shell script and check the return code ($?) or 
>you could output to a file and grep the file for errors.  got to play with it to see 
>what works best for you.
>
> >>> [EMAIL PROTECTED] 04/03/01 02:12PM >>>
> Terry,
> If I remember correctly the ftp supplies a return code. You could capture the return 
>code and have a second script act accordingly on the return code. I think code 220 is 
>successfull.
> ROR mª¿ªm
>
> >>> [EMAIL PROTECTED] 04/03/01 01:30PM >>>
> I think I've seen an answer to this, but I never needed it before.  If
> anyone can help, I would greatly appreciate it.
>
> We are trying to ftp files from one server to another.  (Archive logs
> for Oracle).  We want to be able to capture the status when the ftp
> fails, so that we can notify the DBAs to check the process out.  This is
> all being done within a shell script that compress the log file first,
> then calls another script to do the actual ftp.  But when the child
> script executes, it returns a successful status to the parent script.  I
> don't know any way to tell the script that is doing the ftp to send the
> message, because any non-ftp command within that script fails.  (Of
> course, that could just be because I don't know how to do what I want to
> do).
>
> If anybody has invented this wheel before, or has any tips on where to
> look for more info on how to do what I need to do, please let me know.
>
> TIA,
>
> Terry
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Terry Ball
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Rogers
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gene Sais
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

[Streeter, Lerone A LBX]

i 
speak from ignorance, isn't there implicit and explicit cursor declarations and 
usage?  can't you encapsulate that section you have identified in a loop 
and it will implicitly opens a cursor?  then all you have to do is 
manipulate as needed to generate desired results...
 
===Lerone 
StreeterSystem AnalystAbbott 
LBG[EMAIL PROTECTED]=== 


  -Original Message-From: Dasko, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 3:41 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Help - How to declare a cursor inside a FOR ... LOOP ?
  You 
  can't.  It appears that you want to select all the detailed text extries 
  related to a specific problem.  You could define a cursor that selects 
  all the detailed entries, or you could read all the detailed entries into a 
  pl/sql table and then search through them.  If you use the cursor, then 
  you have to reopen the cursor for each new problem.
   
  Dan
  
-Original Message-From: Wendy Y 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 2:51 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Help - How to declare a cursor inside a FOR ... LOOP ?
Hey, Guys:
I need to decalre a cursor inside a FOR .. LOOP, because the 
variables in SELECT statement for the CURSOR are coming from FOR .. 
LOOP. How could I do this?
DECLARE  V_AKTIV_NR    
aktiv.AKTIV_NR%TYPE;  V_PROBLEM    
aktiv.PROBLEM%TYPE;  V_ENDDAT   
aktiv.ENDDAT%TYPE;  V_ENDUHR   
aktiv.ENDUHR%TYPE;  V_AUSSAGEW   
aktiv.AUSSAGEW%TYPE;  V_LANGTEXT   
aktiv.LANGTEXT%TYPE;  V_LONGTEXT    
VARCHAR2(2);  V_LONGTEXT_CUR  VARCHAR2(13000);  
V_LONGTEXT_TRIM VARCHAR2(2000);  p_PROBLEM    
PROBLEM.PROBLEM%TYPE;  
# This part need to be 
inside FOR.. LOOP, otherwise, I wouldn't get anything.
    CURSOR AKLangTextCur 
IS  SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' 
'||   V_ENDUHR||' '||  rtrim(V_AUSSAGEW)||' 
'||  rtrim(V_LANGTEXT)   
thisText    FROM 
AKTIV    WHERE V_PROBLEM = 
p_PROBLEM    ORDER BY 
Aktiv_NR; AKLangTextRec   
AKLangTextCur%ROWTYPE; 
### AboveBEGIN  FOR v_LoopIndex IN 
1..pkgFreeText.v_NumEntries LOOP    V_AKTIV_NR := 
pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);    V_PROBLEM  
:= pkgFreeText.V_PROBLEM_P(v_LoopIndex);    
V_ENDDAT   := 
pkgFreeText.V_ENDDAT_P(v_LoopIndex);    
V_ENDUHR   := 
pkgFreeText.V_ENDUHR_P(v_LoopIndex);    V_AUSSAGEW := 
pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);    V_LANGTEXT := 
pkgFreeText.V_LANGTEXT_P(v_LoopIndex);
  SELECT PROBLEM INTO p_PROBLEM FROM 
PROBLEM;
## CURSOR DECLARE should be HERE 
##
    BEGIN OPEN 
AKLangTextCur;  
LOOP    
FETCH AKLangTextCur into 
AKLangTextRec;    
 EXIT WHEN 
AKLangTextCur%NOTFOUND;    
V_LONGTEXT_CUR := V_LONGTEXT_CUR 
||AKLangTextRec.thisText; 
     END 
LOOP; CLOSE AKLangTextCur;    
END;V_LONGTEXT 
:= V_LONGTEXT || V_LONGTEXT_CUR;   
  END LOOP;   V_LONGTEXT_TRIM := 
RTRIM(V_LONGTEXT, 2000);
Thanks a lot for help
Wendy


Do You Yahoo!?Yahoo! Mail 
Personal Address - Get email at your own domain with Yahoo! Mail. 
_This 
e-mail message has been scanned for the presence of all known computer 
viruses by the MessageLabs Virus Control Center. However, it is still 
recommended that you use local virus scanning software to monitor for the 
presence of viruses. 

RE: "AT" scheduler

[Gogala, Mladen]

Even more, if you are running crontab on NT, I strongly suggest
to take a look at www.SuSe.com or alike.

-Original Message-
Sent: Tuesday, April 03, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L


If you are running on NT, I strongly recommend you obtain crontab for
Windows.

AT will run 99.99% of the time... but not 100% of the time.  On one of the
servers here AT failed to run the very night that we were changing the time
last Fall, very suspicious in my opinion.

In any case for AT just do:

at hh24:mm /every:M,T,W,Th,F,S,Su cmd /c pointer_to_my_script_or_program

e.g.
at 22:00 /every:M,T,W,Th,F cmd /c c:\pat\coldbackup.cmd

That will create an entry:
Added a new job with Job ID = 

To see the listing, just type AT [enter]

To remove an entry, 

at ID_num /delete
e.g.
at 12 /delete

Don't try to keep your jobs listing in any particular order, NT shuffles
them around sometimes when you do maintenance on the server or when you
reboot.

For AT jobs to run, of course the Scheduler service must be running.  The
service has a couple of different names, depending on which service pack you
installed on your server.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada


> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 1:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  "AT" scheduler
> 
> 
> Can anyone tell me how to schedule a batch job to run every 5 minutes
> using
> the "AT" scheduler?
> 
> Thanks!
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Script to reverse engineer all objects in a schema to DDL?

[Andy Duncan]

Hi Chris,

You could use Richard Sutherland's exciting Perl work, with his new DDL::Oracle
Perl module, and it's associated scripts, which you can find here:

=> http://www.perl.com/CPAN-local/modules/by-authors/id/R/RV/RVSUTHERL/

Richard and I have also started embedding this automatically too within the
Orac Perl/Tk Perl DBI program, which now has Oracle development options, as
well as DBA login options, which you can find here:

=> http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/

You do have to load Perl, Perl/Tk, Perl DBI and DBD::Oracle (on Windows, Linux,
Solaris etc), but once you have all that (and why would you not want to? :),
Orac should just run straight up, with a host of scripts to reverse engineer
many/all? parts of the Oracle database (and now updated by Richard to work with
Oracle 8.1.7, parallel servers etc) or at least it hopefully will when you run
it, as we're still very ALPHA at the moment 8)

Orac is still very much a DBA tool, but we are progressing as rapidly as we can
with the developer options.

Rgds,
AndyD

=
[EMAIL PROTECTED]

O'Reilly's "Oracle and Open Source": 
=> http://www.oreilly.com/catalog/oracleopen/

Orac, Perl/Tk and Perl DBI Database DBA & Development Tool: 
=> http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andy Duncan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: function to get GMT time

[Marc Perkowitz]

Just keep in mind, as I mentioned earlier, DST is not accounted for.  So you
will first need to convert from EDT to EST and then use this function.
Otherwise your GMT will be one hour off.  Of course, if you run your machine
on EST and do not switch to EDT, you will be fine.

Oh, I've assuming you really mean Universal Time (UT) when you're saying
GMT.  If you actually mean the local time for the UK, then you'll need to
take their summer time change into effect also.  Their summer time took
effect on March 25th this year, while US DST took effect on April 1st.  So,
for one week the time difference was less than usual, but now the difference
is consistent.

Marc Perkowitz
Senior Consultant
TWJ Consulting, LLP

847-256-8866 x15
www.twjconsulting.com

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 1:19 PM


> This gives GMT. Thanks!  Ruth
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, April 03, 2001 1:15 PM
>
>
> > Hi Andreas,
> >
> >Please try this.
> >
> >select sysdate, new_time(sysdate,'EST','GMT') from dual;
> >
> > Thanks,
> > Gurdarshan
> >
> >
> > -Original Message-
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 03, 2001 11:45 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi !
> >
> > Is there a way to get GMT time within PL/SQL independent from
> > the local time(zone), I'm looking for a function similar to SYSDATE,
> > but it should return GMT instead of the local time.
> >
> >
> > TIA
> >
> > Andreas
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Haunschmidt Andreas VASL/FAS
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Singh, Gurdarshan (Gurdarshan)** CTR **
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

7.3.4 svrmgrl requiring password if called by root user

[steve mcclure]

My database backup scripts are failing when run by the
root user.  I have just had the requirment to add a
dump of all filesystems to my regular database backup
routine.  Upon running my modified scripts as the root
user, required for the dump, I am greeted by a request
for a password in response to the connect internal
command.  I can duplicate this by simply running
svrmgrl from a prompt as the root user.  Again this is
for Oracle 7.3.4 on DG/UX.

We are not using OS authentication, and I svrmgrl does
NOT require a password for the other OS users I have
tried to use.  I added the root user to the dba and
oper groups in hopes that might solve my problem, but
was still prompted for a password.


Any help with this is appreciated.

Thanks, Steve McClure

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: steve mcclure
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Metalink Response ....FYI

[Mohan, Ross]

Title: RE: Metalink Response FYI





Randy Baker left, yes...and another fellow...forced out, virtually. 


Then, the cost cutting began. People attrited or let go...cheaper 
monitors and equipment...reduced training budgets. 


"We Saved a Billion Dollars Last Year" by not doing their job. 



<==>   -Original Message-
<==>   From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
<==>   Sent: Tuesday, April 03, 2001 3:22 PM
<==>   To: Multiple recipients of list ORACLE-L
<==>   Subject: RE: Metalink Response FYI
<==>   
<==>   
<==>   Steve,
<==>   
<==>   Thanks for the very interesting comments. Are those webified
<==>   apps with similar requirements as metalink?
<==>   
<==>   Also, didn't the VP in charge of support leave Oracle about a
<==>   year or so ago?
<==>   
<==>   
<==>   regards,
<==>   ep
<==>   
<==>   On 3 Apr 2001, at 7:26, Steve Adams wrote:
<==>   
<==>   
<==>   > I'd say that there must be something badly wrong with 
<==>   the application if it
<==>   > cannot cope with 1,500 concurrent users. I know of 
<==>   sites supporting more than 20
<==>   > times that number of active users on a single server 
<==>   with consistent sub-second
<==>   > response times.
<==>   
<==>   ...
<==>   
<==>   -- 
<==>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
<==>   -- 
<==>   Author: Eric D. Pierce
<==> INET: [EMAIL PROTECTED]
<==>   
<==>   Fat City Network Services    -- (858) 538-5051  FAX: 
<==>   (858) 538-5051
<==>   San Diego, California    -- Public Internet access / 
<==>   Mailing Lists
<==>   -
<==>   ---
<==>   To REMOVE yourself from this mailing list, send an E-Mail message
<==>   to: [EMAIL PROTECTED] (note EXACT spelling of 
<==>   'ListGuru') and in
<==>   the message BODY, include a line containing: UNSUB ORACLE-L
<==>   (or the name of mailing list you want to be removed 
<==>   from).  You may
<==>   also send the HELP command for other information (like 
<==>   subscribing).
<==>   

RE: SQL Question

[Jacques Kilchoer]

Title: RE: SQL Question





> -Original Message-
> From: Viktor [mailto:[EMAIL PROTECTED]]
> 
> I want to select some data given a certain date
> range,i.e  where some_date between start_date and
> end_date.
> Is there a way to group the output by week?



I saw several suggestions to use the "to_char" function. I personally prefer to use the trunc function in the group by, because in a test once I found that the trunc function was a little faster. Of course I'm no performance guru so I might be incorrect. You can use the trunc function with the following "formats" for weeks:

WW Same day of the week as the first day of the year.  
IW Same day of the week as the first day of the ISO year.  
 W Same day of the week as the first day of the month.  
 
e.g.
SQL> select to_char (trunc (last_ddl_time, 'IW'), '/IW'),
  2 count (*)
  3  from dba_objects
  4  group by trunc (last_ddl_time, 'IW') ;


TO_CHAR   COUNT(*)
--- --
2001/01  21783
2001/04 21
2001/05  2
2001/07    671
2001/08  7
2001/09 17
2001/10    511
2001/12  1
2001/13  5
2001/14  1
 1


--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: "AT" scheduler

[Guidry, Chris]

Hello,
If you have the NT resource kit you can use the SOON.EXE utility.

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 10:30 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  "AT" scheduler
> 
> 
> Can anyone tell me how to schedule a batch job to run every 5 minutes
> using
> the "AT" scheduler?
> 
> Thanks!
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, Chris
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

[Toepke, Kevin M]

Wendy:

Actually, you don't need to declare the cursor inside the for loop, you just
need to open it inside the loop and pass a parameter to the cursor.

DECLARE
  V_AKTIV_NRaktiv.AKTIV_NR%TYPE;
  V_PROBLEMaktiv.PROBLEM%TYPE;
  V_ENDDAT   aktiv.ENDDAT%TYPE;
  V_ENDUHR   aktiv.ENDUHR%TYPE;
  V_AUSSAGEW   aktiv.AUSSAGEW%TYPE;
  V_LANGTEXT   aktiv.LANGTEXT%TYPE;
  V_LONGTEXTVARCHAR2(2);
  V_LONGTEXT_CUR  VARCHAR2(13000);
  V_LONGTEXT_TRIM VARCHAR2(2000);
  p_PROBLEMPROBLEM.PROBLEM%TYPE;  

CURSOR AKLangTextCur (p_problem IN VARCHAR2) IS 
   SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' '|| V_ENDUHR||' '||
   rtrim(V_AUSSAGEW)||' '|| rtrim(V_LANGTEXT)   thisText
   FROM AKTIV
   WHERE V_PROBLEM = p_PROBLEM
   ORDER BY Aktiv_NR; 
AKLangTextRec   AKLangTextCur%ROWTYPE; 

BEGIN
  FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP
V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);
V_PROBLEM  := pkgFreeText.V_PROBLEM_P(v_LoopIndex);
V_ENDDAT   := pkgFreeText.V_ENDDAT_P(v_LoopIndex);
V_ENDUHR   := pkgFreeText.V_ENDUHR_P(v_LoopIndex);
V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);
V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex);
SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM;

OPEN AKLangTextCur(v_problem);
LOOP
  FETCH AKLangTextCur into AKLangTextRec;
  EXIT WHEN AKLangTextCur%NOTFOUND;
  V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText;

END LOOP;
CLOSE AKLangTextCur;
V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR;   
  END LOOP;
  V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000);
END;
/

Kevin

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Redo log size MAX = ?

[Tim Sawmiller]

So, based on the responses I've seen, this statement can be declared to be false.



>>> [EMAIL PROTECTED] 04/03/01 11:05AM >>>
hi
forget about recovery from online redo logs
It doesn't exist in Oracle

Regards
Tapiwa

-Original Message-
Sent: Tuesday, April 03, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L


Hi,

My database = noarchive mode (compulsory for our application)
In case of instance failure can oracle perform recovery from redo log ? if
can what will be tne maximum size of the redo log recommended.
Because I need set that size for whole day transaction currently 512K (3
redo logs) switched every 15 - 30 minutes.
Can oracle perform recovery from inactive or "other status" redo log ?

Thank you.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Metalink Response ....FYI

[Mohan, Ross]

Title: RE: Metalink Response FYI





Sadly, I do not. I am not a TV watcher these days


<==>-Original Message-
<==>From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
<==>Sent: Tuesday, April 03, 2001 3:17 PM
<==>To: Multiple recipients of list ORACLE-L
<==>Subject: RE: Metalink Response FYI
<==>
<==>
<==>
<==>
<==>On 3 Apr 2001, at 7:50, Mohan, Ross scribbled with alacrity 
<==>and cogency:
<==>
<==>> ... I am
<==>> supposed to believe these guys when they say "We'll scale
<==>> all the way to Andromeda!".
<==>
<==>
<==>You mean the SciFi show called "Andromeda"?
<==>
<==>regards,
<==>ep
<==>
<==>
<==>-- 
<==>Please see the official ORACLE-L FAQ: http://www.orafaq.com
<==>-- 
<==>Author: Eric D. Pierce
<==>  INET: [EMAIL PROTECTED]
<==>
<==>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
<==>San Diego, California    -- Public Internet access / 
<==>Mailing Lists
<==>
<==>To REMOVE yourself from this mailing list, send an E-Mail message
<==>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
<==>the message BODY, include a line containing: UNSUB ORACLE-L
<==>(or the name of mailing list you want to be removed from).  You may
<==>also send the HELP command for other information (like subscribing).
<==>

RE: Help - How to declare a cursor inside a FOR ... LOOP ?

[Dasko, Dan]

You 
can't.  It appears that you want to select all the detailed text extries 
related to a specific problem.  You could define a cursor that selects all 
the detailed entries, or you could read all the detailed entries into a pl/sql 
table and then search through them.  If you use the cursor, then you have 
to reopen the cursor for each new problem.
 
Dan

  -Original Message-From: Wendy Y 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 2:51 
  PMTo: Multiple recipients of list ORACLE-LSubject: Help 
  - How to declare a cursor inside a FOR ... LOOP ?
  Hey, Guys:
  I need to decalre a cursor inside a FOR .. LOOP, because the variables 
  in SELECT statement for the CURSOR are coming from FOR .. LOOP. How could 
  I do this?
  DECLARE  V_AKTIV_NR    
  aktiv.AKTIV_NR%TYPE;  V_PROBLEM    
  aktiv.PROBLEM%TYPE;  V_ENDDAT   
  aktiv.ENDDAT%TYPE;  V_ENDUHR   aktiv.ENDUHR%TYPE;  
  V_AUSSAGEW   aktiv.AUSSAGEW%TYPE;  V_LANGTEXT   
  aktiv.LANGTEXT%TYPE;  V_LONGTEXT    
  VARCHAR2(2);  V_LONGTEXT_CUR  VARCHAR2(13000);  
  V_LONGTEXT_TRIM VARCHAR2(2000);  p_PROBLEM    
  PROBLEM.PROBLEM%TYPE;  
  # This part need to be inside 
  FOR.. LOOP, otherwise, I wouldn't get anything.
      CURSOR AKLangTextCur 
  IS  SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' '||  
   V_ENDUHR||' '||  rtrim(V_AUSSAGEW)||' 
  '||  rtrim(V_LANGTEXT)   
  thisText    FROM 
  AKTIV    WHERE V_PROBLEM = 
  p_PROBLEM    ORDER BY 
  Aktiv_NR; AKLangTextRec   
  AKLangTextCur%ROWTYPE; 
  ### AboveBEGIN  FOR v_LoopIndex IN 
  1..pkgFreeText.v_NumEntries LOOP    V_AKTIV_NR := 
  pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);    V_PROBLEM  
  := pkgFreeText.V_PROBLEM_P(v_LoopIndex);    
  V_ENDDAT   := 
  pkgFreeText.V_ENDDAT_P(v_LoopIndex);    
  V_ENDUHR   := 
  pkgFreeText.V_ENDUHR_P(v_LoopIndex);    V_AUSSAGEW := 
  pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);    V_LANGTEXT := 
  pkgFreeText.V_LANGTEXT_P(v_LoopIndex);
    SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM;
  ## CURSOR DECLARE should be HERE 
  ##
      BEGIN OPEN 
  AKLangTextCur;  
  LOOP    
  FETCH AKLangTextCur into 
  AKLangTextRec;    
   EXIT WHEN 
  AKLangTextCur%NOTFOUND;    
  V_LONGTEXT_CUR := V_LONGTEXT_CUR 
  ||AKLangTextRec.thisText; 
       END 
  LOOP; CLOSE AKLangTextCur;    
  END;V_LONGTEXT 
  := V_LONGTEXT || V_LONGTEXT_CUR;   
    END LOOP;   V_LONGTEXT_TRIM := 
  RTRIM(V_LONGTEXT, 2000);
  Thanks a lot for help
  Wendy
  
  
  Do You Yahoo!?Yahoo! Mail Personal 
  Address - Get email at your own domain with Yahoo! Mail. 
  _This 
  e-mail message has been scanned for the presence of all known computer viruses 
  by the MessageLabs Virus Control Center. However, it is still recommended that 
  you use local virus scanning software to monitor for the presence of viruses. 
  

RE: Slightly OT: Capturing a failed status of an ftp process

[Shari Dishop]

Terry,
  I worked on what I think is a similar process.  We are running SAP and need to 
be able to ftp files on and off of our unix SAP servers.  Someone in the past 
wrote an SAP ABAP program that does all of the set up then calls a unix shell 
script to perform the ftp.  If the ftp command truely failed to connect we had 
no problem getting back a failed error message to the SAP program.  But where we 
ran into some problems was when the transfer command would start but get 
interrupted for some unknown reason and never fully complete the transfer.  This 
was noticed by accident one day when someone was checking a report run off of 
one of the data transfers and there were only a few hundred records in the table 
to be processed instead of a few hundred thousand.

  I was then asked to come up with a solution that would look for an unexpected 
termination of the ftp connection.  After lots of searching and getting one of 
our local unix gurus involved (I have worked directly on a unix platform), we 
implemented the following.  It is not the best but it does seem to be working.

  We added a step to the ftp script.  This step is a status command that is 
executed directly after the get or put command.  This returns information about 
the ftp connection itself.  It also returns a message if it is no longer 
connected.  This output was passed back to the SAP program and parsed.  If I had 
a message indicating that the remote host was still connected, I assumed that 
the get or put executed completely.  If on the other hand I received the message 
indicating that the remote system was no longer connected I generated an error 
message from the program so that the user could check the data.


Shari Dishop
SAP ABAP - Project Systems Team
Logicon - A Northrop Grumman Company
Baltimore, MD


RE:

I think I've seen an answer to this, but I never needed it before.  If
anyone can help, I would greatly appreciate it.

We are trying to ftp files from one server to another.  (Archive logs
for Oracle).  We want to be able to capture the status when the ftp
fails, so that we can notify the DBAs to check the process out.  This is
all being done within a shell script that compress the log file first,
then calls another script to do the actual ftp.  But when the child
script executes, it returns a successful status to the parent script.  I
don't know any way to tell the script that is doing the ftp to send the
message, because any non-ftp command within that script fails.  (Of
course, that could just be because I don't know how to do what I want to
do).

If anybody has invented this wheel before, or has any tips on where to
look for more info on how to do what I need to do, please let me know.

TIA,

Terry

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: function to get GMT time

[Ruth Gramolini]

I know, it works!  RBG
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 2:57 PM


> Ruth:
> 
> Just reverse the logic...this converts Eastern Daylight Time to GMT:
> SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual;
> 
> SQL> SELECT sysdate FROM dual;
> 
> SYSDATE
> 
> 03-APR-2001 13:51:35
> 
> SQL> SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual;
> 
> NEW_TIME(SYSDATE,'ED
> 
> 03-APR-2001 17:52:06
> 
> Kevin Toepke
> 
> -
> The information in this electronic mail message is Cendant Confidential
> and may be legally privileged. It is intended solely for the
> addressee(s). Access to this Internet electronic mail message by anyone
> else is unauthorized. If you are not the intended recipient, any
> disclosure, copying, distribution or action taken or omitted to be taken
> in reliance on it is prohibited and may be unlawful.
> -
> The sender believes that this E-mail and any attachments were free of
> any virus, worm, Trojan horse, and/or malicious code when sent. This
> message and its attachments could have been infected during
> transmission. By reading the message and opening any attachments, the
> recipient accepts full responsibility for taking protective and remedial
> action about viruses and other defects. Cendant Corporation is not
> liable for any loss or damage arising in any way from this message or
> its attachments.
> -
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Toepke, Kevin M
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: "AT" scheduler

[Szecsy Tamas]

My Computer/Scheduled Task might fit your needs better, since it has got a
Windows GUI. It's easier to handle than the AT command. The GUI in some
places is illogial, but still it might be usefull for you.

Tamas Szecsy



-Original Message-
Sent: 2001.04.03. 8:22 PM
To: Multiple recipients of list ORACLE-L


If you are running on NT, I strongly recommend you obtain crontab for
Windows.

AT will run 99.99% of the time... but not 100% of the time.  On one of the
servers here AT failed to run the very night that we were changing the time
last Fall, very suspicious in my opinion.

In any case for AT just do:

at hh24:mm /every:M,T,W,Th,F,S,Su cmd /c pointer_to_my_script_or_program

e.g.
at 22:00 /every:M,T,W,Th,F cmd /c c:\pat\coldbackup.cmd

That will create an entry:
Added a new job with Job ID = 

To see the listing, just type AT [enter]

To remove an entry, 

at ID_num /delete
e.g.
at 12 /delete

Don't try to keep your jobs listing in any particular order, NT shuffles
them around sometimes when you do maintenance on the server or when you
reboot.

For AT jobs to run, of course the Scheduler service must be running.  The
service has a couple of different names, depending on which service pack you
installed on your server.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada


> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 1:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  "AT" scheduler
> 
> 
> Can anyone tell me how to schedule a batch job to run every 5 minutes
> using
> the "AT" scheduler?
> 
> Thanks!
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Szecsy Tamas
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: HP environment - standby db?

[Gene Sais]

At a previous employer, I've used HP MC ServiceGuard w/ EMC and it worked great.  
Don't know about Storedge, but can compliment EMC on their storage solution as the 
best in the business.  Of course thats my opinion.
Also, used the standby box as a staging db for prototyping new applications.  This 
worked out well b/c the box was being used while waiting for the moment of disaster :)

Gene

>>> [EMAIL PROTECTED] 04/03/01 02:00PM >>>
Anybody out there using 2 HP servers attached to a single StoreEdge (AutoRaid) and 
setting up Oracle for a hot-standby db?  Or are you running OPS instead of the 
hot-standby?

Management thinking is to attach a N4000 and a L2000 servers to a 12H StoreEdge.  I 
understand that a "HP Service Card" is required that will allow the L2000 to be the 
"fail to" server for the N4000.  We would be starting with a 500G Oracle db, growing 
up to 9T at the end of 2 years.  Oracle would be setup so that the L2000 would be 
serving the "hot standby" database.  Or, should we toss the "hot standby" idea and go 
directly to Oracle Parallel Server?

Would you care to comment on the good, the bad or the ugly to this idea?  Yes, the 12H 
becomes the weak link in this idea, but there are budget constraints in this fiscal 
year that are forcing that config.  In the next 2 fiscal years are monies to address 
the single storage device problem.


Thx.

[EMAIL PROTECTED] 
Portland OR USA


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

(Fwd) [Kent Graziano] ODTUG Meets with Oracle!

[Eric D. Pierce]

--- Forwarded message follows ---
Date sent:  Mon, 02 Apr 2001 15:01:46 -0800
S e n d   r e p l y   t o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m
F r o m :   Oracle Development Tools User Group

Dear List Users:

I am pleased to report to you that the ODTUG board had a fantastic kick-off
meeting for 2001 that included a session with some your favorite Oracle
Corporation VPs. We were pleased to have Sohaib Abbasi (Senior VP), Marco
Tilli, Ian Fisher, Bill Dwight, and Daryl Porter in attendance to discuss how
the user group and the Tools division can work together this year. As a result
of this meeting, you can expect to see the following:

·   Participation by Oracle in our conference, with most of the above VPs
giving at least one   presentation.

·   Participation in the ODTUG enhancement request (ER) system by the
Oracle
VPs and their  product managers. The VPs enthusiastically pledged to become
active in reviewing the ERssubmitted by our members using our new
Oracle
Portal-based system.

·   Distribution of JDeveloper 9i beta CDs to our members (probably
midyear,
details pending).

·   Creation of a white paper/case study on using the new SCM features of
Designer, to be written   by the Oracle U.K. Repository team.

·   Development of surveys throughout the year from the various Oracle
product teams about how  you, our members, are using the tools. These
surveys will be distributed by ODTUG.

We were all in agreement that these results will provide a win-win for Oracle
and ODTUG. ODTUG members will get tools to demo and information on how to more
effectively use those tools. Oracle, in return, will get valuable information
(via the ER system and surveys) to help them in their product direction and
development.

Even with all the recent turmoil in the market, it looks to be a great year for
ODTUG. If you want to be part of all this and you are not a member, let me take
this opportunity to invite you join now so you can use your discount to go to
this year's conference in San Diego, California. Go to our Web site at
www.odtug.com to sign up online for both a membership and the conference.

See you in San Diego!

Kent Graziano
President, ODTUG

--- End of forwarded message ---
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Metalink Response ....FYI

[Eric D. Pierce]

On 3 Apr 2001, at 7:50, Mohan, Ross scribbled with alacrity and cogency:

> ... I am
> supposed to believe these guys when they say "We'll scale
> all the way to Andromeda!".


You mean the SciFi show called "Andromeda"?

regards,
ep


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQL Question

[Regina Harter]

You can do something like

select to_char(date_column,'YYWW'), count(*), sum(other_column)
from table
where date_column between date1 and date 2
group by to_char(date_column,'YYWW')

where WW returns the week of the year ( 1 to 53)
keeping in mind, of course, that you must include in the group by any 
column in the select which does not have a group function on it (sum, max, 
min, avg, etc).

At 09:35 AM 4/3/01 -0800, you wrote:

>Hello all,
>
>Can someone tell me whether or not there is a way
>do this in SQL?
>I want to select some data given a certain date
>range,i.e  where some_date between start_date and
>end_date.
>Is there a way to group the output by week?
>In other words, something like:
>
>SELECT column_a, column_b, count(*),
>sum(column_c)
>FROM table_t
>WHERE some_date_column BETWEEN :start_date and
>:end_date
>GROUP BY ...?
>
>How this be grouped by week?
>
>Thanks a lot.
>
>
>__
>Do You Yahoo!?
>Get email at your own domain with Yahoo! Mail.
>http://personal.mail.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Viktor
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Generating Forms through API or Designer

[Szecsy Tamas]

Hi Listers,

I have the following questions:

1. I would like to generate Developer Forms fmb files through my C++
application. Is it difficult? Did any of you do similar things? I know Forms
have an API for this, but I don't know how complex is it. I have pretty
simple Forms. Should I try or should I forget it?
2. Does Oracle Designer 6i's Forms generator's revers engineering engine
preserve or recapture the Form layout modifications I make on the generated
Forms?

TIA,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Metalink Response ....FYI

[Eric D. Pierce]

Steve,

Thanks for the very interesting comments. Are those webified
apps with similar requirements as metalink?

Also, didn't the VP in charge of support leave Oracle about a
year or so ago?


regards,
ep

On 3 Apr 2001, at 7:26, Steve Adams wrote:


> I'd say that there must be something badly wrong with the application if it
> cannot cope with 1,500 concurrent users. I know of sites supporting more than 20
> times that number of active users on a single server with consistent sub-second
> response times.

...

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Recovery Manager vs. SQL Back Track

[Brian MacLean]

Title: RE: Recovery Manager vs. SQL Back Track





I have worked with manual scripting, EBU, RMAN, and SQLBackTrack.


If you can afford it, use SQLBackTrack.  It's idiot proof for both backup and restore if you set it up right.  (trust me).

If you have other questions email me direct.


Brian P. Mac Lean
Oracle DBA/OCP v8/OMC
Vcommerce Corp.
6262 N. Scottsdale Rd., Suite 110
Scottsdale, AZ  85250
480.922.9922 - Main
480.778.8449 - Direct
480.922.9921 - Fax
[EMAIL PROTECTED] - Email
vc_bmaclean - Yahoo Messenger








-Original Message-
From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 7:46 AM
To: Multiple recipients of list ORACLE-L
Subject: Recovery Manager vs. SQL Back Track



Hi everyone - 
Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode.  We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris.  Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). 

We have started playing around with Recovery Manager.  Our Sybase DBAs are telling us we should look at SQL BackTrack instead.

For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any "gotcha's" that you have run into.  Other than the cost factor, what would you recommend?

Thanks very much - 
Lisa 

RE: FOOT-AND-MOUTH

[Mohan, Ross]

Title: RE: FOOT-AND-MOUTH 





Yea, it sure spreads more viruses than ORACLE's EMAIL SOLUTION.
ahem, well...what i meant to say was.


Criminy, Oracle can't even run a 1500 user support site for it's
paying freaking customers.



Oracle support is as well-thought out as asking Ed Hazelton to captain the Ehime Maru.


Ross


p.s. Oxymorons for the day:


"Military Intelligence"
"Jumbo Shrimp"
"Oracle Support"




||-Original Message-
||From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
||Sent: Tuesday, April 03, 2001 2:51 PM
||To: Multiple recipients of list ORACLE-L
||Subject: FOOT-AND-MOUTH 
||
||
||For all of you MicroSoft supporters out there!
||
||Sorry Jared!
||
||Dick Goulet
||
||Forward Header_
||
||FOOT-AND-MOUTH BELIEVED TO BE FIRST VIRUS UNABLE TO SPREAD THROUGH 
||MICROSOFT OUTLOOK
||
||Researchers Shocked to Finally Find Virus That Email App Doesn't Like
||
||Atlanta, Ga. (GPS) Scientists at the Centers for Disease Control and 
||Symantec's AntiVirus Research Center today confirmed that 
||foot-and-mouth 
||disease cannot be spread by Microsoft's Outlook email application, 
||believed to be the first time the program has ever failed to propagate
||a major virus.
||
||"Frankly, we've never heard of a virus that couldn't spread through 
||Microsoft Outlook, so our findings were, to say the least, 
||unexpected," 
||said Clive Sarnow, director of the CDC's infectious disease unit.
||
||The study was immediately hailed by British officials, who 
||said it will 
||save millions of pounds and thousands of man hours.  "Up until now we 
||have, quite naturally, assumed that both foot-and-mouth and 
||mad cow were 
||spread by Microsoft Outlook," said Nick Brown, Britain's Agriculture 
||Minister. "By eliminating it, we can focus our resources elsewhere."
||
||However, researchers in the Netherlands, where foot-and-mouth has 
||recently appeared, said they are not yet prepared to 
||disqualify Outlook, 
||which has been the progenitor of viruses such as "I Love You," 
||"Bubbleboy," "Anna Kournikova," and "Naked Wife," to name but a few.
||
||Said Nils Overmars, director of the Molecular Virology Lab at Leiden 
||University, "It's not that we don't trust the research, it's 
||just that 
||as scientists, we are trained to be skeptical of any finding 
||that flies 
||in the face of established truth.  And this one flies in the face
||like a blind drunk sparrow."
||
||Executives at Microsoft, meanwhile, were equally skeptical, insisting 
||that Outlook's patented Virus Transfer Protocol (VTP) has proven 
||virtually pervious to any virus.  The company, however, will issue a 
||free VTP patch if it turns out the application is not vulnerable to 
||foot-and-mouth.
||
||Such an admission would be embarrassing for the software giant, but 
||Symantec virologist Ariel Kologne insisted that no one is more 
||humiliated by the study than she is.  "Only last week, I had 
||a reporter 
||ask if the foot-and-mouth virus spreads through Microsoft 
||Outlook, and I 
||told him, 'Doesn't everything?'" she recalled. "Who would've thought?"
||
||-- 
||Please see the official ORACLE-L FAQ: http://www.orafaq.com
||-- 
||Author: 
||  INET: [EMAIL PROTECTED]
||
||Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
||San Diego, California    -- Public Internet access / Mailing Lists
||
||To REMOVE yourself from this mailing list, send an E-Mail message
||to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
||the message BODY, include a line containing: UNSUB ORACLE-L
||(or the name of mailing list you want to be removed from).  You may
||also send the HELP command for other information (like subscribing).
||

Re: Recovery Manager vs. SQL Back Track

[Terry Ball]

We currently use SQL BackTrack on both Solaris boxes where our interface
to tape software is netware.  To put it mildly, netware sucks.  When we
were going to disk SQL BackTrack worked like a charm.  On our other
system - AIX - our interface is ADSM.  It too has worked like a charm.
If you can stay away from using SQL BackTrack with netware's obsi
interface, go for it.   Otherwise, stay as far away as you can.

Terry

"Yttri, Lisa" wrote:

>
>
> Hi everyone -
>
> Currently we are doing backups manually, periodic cold backups, and
> hot backups in between - we are running in archivelog mode.  We are
> running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris.  Today
> there are only a few small production servers (2 - 5 GB), but we are
> anticipating a couple large ones (~200GB), and a data warehouse
> (anticipated to be around 500GB).
>
> We have started playing around with Recovery Manager.  Our Sybase DBAs
> are telling us we should look at SQL BackTrack instead.
>
> For those of you who are using either one, I'd appreciate your
> comments on how well you like / don't like it and any "gotcha's" that
> you have run into.  Other than the cost factor, what would you
> recommend?
>
> Thanks very much -
> Lisa

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Rollback seg for an entire session, not just per tran

[Gogala, Mladen]

I hate to disagree with people, but SYSTEM rollback segment is actually
not used at all if there are other rollback segments available. Those
"dictionary transactions" are a myth, the same as that oracle is trying
to "cache extents". Simply not true.

-Original Message-
Sent: Tuesday, April 03, 2001 2:01 PM
To: Multiple recipients of list ORACLE-L


Raj,

OH, I hate to contradict people, but several months ago we had a couple
of
very long running jobs that accidentally filled all of the rollback segment
space with the exception of SYSTEM.  The processes all crashed with an
Oracle
error that said the SYSTEM rollback segment was strictly for changes in the
data
dictionary.  Therefore NO it does not get used for user session transactions
outside of data dictionary stuff which we all know does an autocommit.

Dick Goulet

Reply Separator
Author: Raj Gopalan <[EMAIL PROTECTED]>
Date:   4/3/2001 8:50 AM

Dana

1. System rollback segment will be used for user session transactions.

2. The only way I think of assinging a rollback segment is by using SET
TRANSACTION COMMAND.

3. There wont be any implict commits in a PL/SQL procedure and on exit of
the PL/SQL will also not commit the data. You need to explicitly specify the
commit.

-Original Message-
Sent: 03 April 2001 15:55
To: Multiple recipients of list ORACLE-L
Implicit commits in PL/SQL?



A colleague wants to do a large load using multiple PL/SQL programs;
she typically (has the DBA) turns off all rollback segments except for
SYSTEM and one large rollback segment.

Some questions:

Will the rollback segment called SYSTEM in the SYSTEM tablespace never
be used for user session transactions?

Is there any way to specify which rollback segment to use for an entire
session versus per transaction? I'm not sure if her PL/SQL code
performs implicit commits so I'm not sure doing one commit + set
transaction before executing the procedure(s) will have the desired
effect. Will Oracle ever do an implicit commit inside a PL/SQL
procedure or is a commit performed only with the commit command or when
exiting a procedure?

Thanks very much.

 - Dana






__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Gopalan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: function to get GMT time

[Toepke, Kevin M]

Ruth:

Just reverse the logic...this converts Eastern Daylight Time to GMT:
SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual;

SQL> SELECT sysdate FROM dual;

SYSDATE

03-APR-2001 13:51:35

SQL> SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual;

NEW_TIME(SYSDATE,'ED

03-APR-2001 17:52:06

Kevin Toepke

-
The information in this electronic mail message is Cendant Confidential
and may be legally privileged. It is intended solely for the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful.
-
The sender believes that this E-mail and any attachments were free of
any virus, worm, Trojan horse, and/or malicious code when sent. This
message and its attachments could have been infected during
transmission. By reading the message and opening any attachments, the
recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation is not
liable for any loss or damage arising in any way from this message or
its attachments.
-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Metalink Response ....More News!

[Mohan, Ross]

Title: RE: Metalink Response More News!





I just got backdoor page hit information from support.microsoft.com. 


In March, they had  13, 000, 000, 000  page hits. Yes, Thirteen BILLION. 


Now, think about how you use a support site: You flip through a few pages, 
maybe twenty in rapid order, find an article you need, and read it. For at 
least a few minutes, maybe up to half an hour on screen. So, assuming an 
average page-dwell per user at one minute...


...well, YOU go ahead and figure out what the AVERAGE concurrent
user load at support.microsoft.com is. Go ahead, do the arithmetic.


Oh My God. 


Oracle should outsource MetaLink to Microsoft. 

RE: Multi Threaded Server

[Hillman, Alex]

My experience  (it was on 7.3.4 on Solaris, do not know current behavior))
that when number of requests > max_shared_servers Oracle create dedicated
connection and writes record in the alert.log file.

Alex Hillman

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 03, 2001 2:19 PM
To: Multiple recipients of list ORACLE-L
Subject:Re:Multi Threaded Server

Jack,

I use MTS of any instance were the company intranet gets
involved for
similar reasons.  There are two problems that I've run into with MTS
over the
years.  The first is running out of shared pool space.  With MTS the
query and
resulting data get stored in the shared pool, so at least one should
increase
this setting in init.ora.  The second gets into the basics of
configuring MTS. 
First, make sure there are a minimum of at least 2 shared servers
per
dispatcher.  If you've for 3 dispatchers then you need a minimum of
6 shared
servers.  The DB will not complain on startup if this is wrong, but
it will at
some time thereafter, by crashing.  The second has to do with the
number of
shared servers there are during normal operations.  Remember that
once a user
submits a transaction to the database that it will sit in the shared
pool
awaiting processing until a server becomes available.  This very
much a FIFO
operation, so if all of the servers are busy then it may wait for a
long time. 
My rule of thumb is to set MTS_MAX_SERVERS equal to 75% of max
expected
connections.  The actual number running at any time will vary
between the
minimum and maximum which is what it's suppose to do.  Also,
configure at least
one connection method that will use a dedicated server.  Helps an
awful lot with
batch data loads, actually an Oracle recommendation.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   4/3/2001 7:32 AM

Hi All,

We have about 400-500 connections to our database and are now
considering
going to MTS.

Can anybody share their experience? pitfalls? things to take care
of?
performance issues?

Any help appreciated.

Our main objective is to lower the amount of RAM consumed by the
Oracle
sessions.


Jack

(Oracle DBA) Informatie Systemen

Ernst & Young
Informatie & Communicatie Technologie

Kantoor Gouda
Tel.: 0182 575316 (intern: 923 316)
Fax: 0182 536311
E-mail: [EMAIL PROTECTED]



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

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

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

=
The information contained in this communication is confidential and
is
intended solely for the use of the individual or entity to whom it
is
addressed. You should not copy, disclose or distribute this
communication
without the authority of Ernst & Young. Ernst & Young is neither
liable for
the proper and complete transmission of the information contained in
this
communication nor for any delay in its receipt. Ernst & Young does
not
guarantee that the integrity of this communication has been
maintained nor
that the communication is free of viruses, interceptions or
interference.

If you are not the intended recipient of this communication please
return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms
and
con

Re: Recovery Manager vs. SQL Back Track

[Ruth Gramolini]

You cannot send a PDF attachment thru the list as far as I know.

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 2:07 PM


Send it through the list.  I would like to see it also.  Thanks.

>>> [EMAIL PROTECTED] 04/03/01 11:56AM >>>
I have used rman exclusively since I became an Oracle DBA because it was
there and I needed a backup strategy.  It has gotten better with later
releases.  We are now on 8.0.6.  It used Oracle internals so that is an
advantage. It comes free with Oracle so that is another advantage.

I can send you a paper on why to love rman written by Francis Sanchez of
Oracle Corp.  if you need it.  I can't send an attachment through the list.

Regards,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 10:45 AM


> Hi everyone -
>
> Currently we are doing backups manually, periodic cold backups, and hot
> backups in between - we are running in archivelog mode.  We are running
> 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris.  Today there are only a
> few small production servers (2 - 5 GB), but we are anticipating a couple
> large ones (~200GB), and a data warehouse (anticipated to be around
500GB).
>
> We have started playing around with Recovery Manager.  Our Sybase DBAs are
> telling us we should look at SQL BackTrack instead.
>
> For those of you who are using either one, I'd appreciate your comments on
> how well you like / don't like it and any "gotcha's" that you have run
into.
> Other than the cost factor, what would you recommend?
>
> Thanks very much -
> Lisa
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Slightly OT: Capturing a failed status of an ftp process

[Gene Sais]

i find the easiest thing to do is put the ftp code in a function within the shell 
script.  call the function from the shell script and check the return code ($?) or you 
could output to a file and grep the file for errors.  got to play with it to see what 
works best for you.

>>> [EMAIL PROTECTED] 04/03/01 02:12PM >>>
Terry,
If I remember correctly the ftp supplies a return code. You could capture the return 
code and have a second script act accordingly on the return code. I think code 220 is 
successfull.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 04/03/01 01:30PM >>>
I think I've seen an answer to this, but I never needed it before.  If
anyone can help, I would greatly appreciate it.

We are trying to ftp files from one server to another.  (Archive logs
for Oracle).  We want to be able to capture the status when the ftp
fails, so that we can notify the DBAs to check the process out.  This is
all being done within a shell script that compress the log file first,
then calls another script to do the actual ftp.  But when the child
script executes, it returns a successful status to the parent script.  I
don't know any way to tell the script that is doing the ftp to send the
message, because any non-ftp command within that script fails.  (Of
course, that could just be because I don't know how to do what I want to
do).

If anybody has invented this wheel before, or has any tips on where to
look for more info on how to do what I need to do, please let me know.

TIA,

Terry

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Help - How to declare a cursor inside a FOR ... LOOP ?

[Wendy Y]

Hey, Guys:
I need to decalre a cursor inside a FOR .. LOOP, because the variables in SELECT statement for the CURSOR are coming from FOR .. LOOP. How could I do this?
DECLARE  V_AKTIV_NR    aktiv.AKTIV_NR%TYPE;  V_PROBLEM    aktiv.PROBLEM%TYPE;  V_ENDDAT   aktiv.ENDDAT%TYPE;  V_ENDUHR   aktiv.ENDUHR%TYPE;  V_AUSSAGEW   aktiv.AUSSAGEW%TYPE;  V_LANGTEXT   aktiv.LANGTEXT%TYPE;  V_LONGTEXT    VARCHAR2(2);  V_LONGTEXT_CUR  VARCHAR2(13000);  V_LONGTEXT_TRIM VARCHAR2(2000);  p_PROBLEM    PROBLEM.PROBLEM%TYPE;  
# This part need to be inside FOR.. LOOP, otherwise, I wouldn't get anything.
    CURSOR AKLangTextCur IS  SELECT  TO_CHAR(V_ENDDAT, 'MMDD')||' '||   V_ENDUHR||' '||  rtrim(V_AUSSAGEW)||' '||  rtrim(V_LANGTEXT)   thisText    FROM AKTIV    WHERE V_PROBLEM = p_PROBLEM    ORDER BY Aktiv_NR; AKLangTextRec   AKLangTextCur%ROWTYPE; 
### AboveBEGIN  FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP    V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex);    V_PROBLEM  := pkgFreeText.V_PROBLEM_P(v_LoopIndex);    V_ENDDAT   := pkgFreeText.V_ENDDAT_P(v_LoopIndex);    V_ENDUHR   := pkgFreeText.V_ENDUHR_P(v_LoopIndex);    V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex);    V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex);
  SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM;
## CURSOR DECLARE should be HERE ##
    BEGIN OPEN AKLangTextCur;  LOOP    FETCH AKLangTextCur into AKLangTextRec;     EXIT WHEN AKLangTextCur%NOTFOUND;    V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText;      END LOOP; CLOSE AKLangTextCur;    END;V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR;   
  END LOOP;   V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000);
Thanks a lot for help
WendyDo You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

Re: Multi Threaded Server

[Charlie Mengler]

Oracle V7.3.4.5 on V2.6 Solaris

My primary Production Oracle server runs with about 1200 concurrent sessions
at HWM. I've migrate FROM MTS to dedicated connections on a box with 6GB RAM.
I did this because I've repeatedly measured 4 - 6 TIMES performance gains on
using a dedicated connection instead of connecting via MTS.

HTH & MYYV!

[EMAIL PROTECTED] wrote:
> 
> Hi All,
> 
> We have about 400-500 connections to our database and are now considering
> going to MTS.
> 
> Can anybody share their experience? pitfalls? things to take care of?
> performance issues?
> 
> Any help appreciated.
> 
> Our main objective is to lower the amount of RAM consumed by the Oracle
> sessions.
> 
> Jack
> 
> (Oracle DBA) Informatie Systemen
> 
> Ernst & Young
> Informatie & Communicatie Technologie
> 
> Kantoor Gouda
> Tel.: 0182 575316 (intern: 923 316)
> Fax: 0182 536311
> E-mail: [EMAIL PROTECTED]
> 
> =
> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
> derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
> voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
> verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
> 
> Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
> en het origineel en eventuele kopieën te verwijderen en te vernietigen.
> 
> Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
> voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> =
> The information contained in this communication is confidential and is
> intended solely for the use of the individual or entity to whom it is
> addressed. You should not copy, disclose or distribute this communication
> without the authority of Ernst & Young. Ernst & Young is neither liable for
> the proper and complete transmission of the information contained in this
> communication nor for any delay in its receipt. Ernst & Young does not
> guarantee that the integrity of this communication has been maintained nor
> that the communication is free of viruses, interceptions or interference.
> 
> If you are not the intended recipient of this communication please return
> the communication to the sender and delete and destroy all copies.
> 
> In carrying out its engagements, Ernst & Young applies general terms and
> conditions, which contain a clause that limits its liability. A copy of
> these terms and conditions is available on request free of charge.
> =
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct   
858-831-2229  San Diego, CA 92131
The future is here. It is just not evenly distributed.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL Question

[William Rogge]

YES.

column the_week noprint
SELECT column_a, column_b, to_char(some_date_column,'YYWW') the_week, count(*),
   sum(column_c)
from table_t
WHERE some_date_column BETWEEN :start_date and :end_date
group by to_char(some_date_column, 'YYWW')


-Original Message-
From:   Viktor [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 03, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L
Subject:SQL Question


Hello all,

Can someone tell me whether or not there is a way
do this in SQL?
I want to select some data given a certain date
range,i.e  where some_date between start_date and
end_date.
Is there a way to group the output by week?
In other words, something like:

SELECT column_a, column_b, count(*),
sum(column_c)
FROM table_t
WHERE some_date_column BETWEEN :start_date and
:end_date
GROUP BY ...?

How this be grouped by week?

Thanks a lot.


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: William Rogge
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Redo log size MAX = ?

[William Beilstein]

That  is true. The archive logs are nothing more then copies of the redo logs before 
they are reused.

>>> [EMAIL PROTECTED] 04/03/01 01:10PM >>>
Is this true?  
I thought that if the transactions needed for recovery are in the online
redo logs, and the online logs are available, then the RECOVER DATABASE
statement will read from the online logs.  Just did it this morning on a
noarchivelog database, Oracle 7.3.3.  If however, the data needed for
recovery in the online logs has been overwritten, then the database will be
unrecoverable.

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: Zhou, Tapiwanashe [SMTP:[EMAIL PROTECTED]] 
> Sent: Tuesday, April 03, 2001 10:05 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Redo log size MAX = ?
> 
> hi
> forget about recovery from online redo logs
> It doesn't exist in Oracle
> 
> Regards
> Tapiwa
> 
> -Original Message-
> Sent: Tuesday, April 03, 2001 3:01 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> My database = noarchive mode (compulsory for our application)
> In case of instance failure can oracle perform recovery from redo log ? if
> can what will be tne maximum size of the redo log recommended.
> Because I need set that size for whole day transaction currently 512K (3
> redo logs) switched every 15 - 30 minutes.
> Can oracle perform recovery from inactive or "other status" redo log ?
> 
> Thank you.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Zhou, Tapiwanashe
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: "AT" scheduler

[Boivin, Patrice J]

If you are running on NT, I strongly recommend you obtain crontab for
Windows.

AT will run 99.99% of the time... but not 100% of the time.  On one of the
servers here AT failed to run the very night that we were changing the time
last Fall, very suspicious in my opinion.

In any case for AT just do:

at hh24:mm /every:M,T,W,Th,F,S,Su cmd /c pointer_to_my_script_or_program

e.g.
at 22:00 /every:M,T,W,Th,F cmd /c c:\pat\coldbackup.cmd

That will create an entry:
Added a new job with Job ID = 

To see the listing, just type AT [enter]

To remove an entry, 

at ID_num /delete
e.g.
at 12 /delete

Don't try to keep your jobs listing in any particular order, NT shuffles
them around sometimes when you do maintenance on the server or when you
reboot.

For AT jobs to run, of course the Scheduler service must be running.  The
service has a couple of different names, depending on which service pack you
installed on your server.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada


> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 1:30 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  "AT" scheduler
> 
> 
> Can anyone tell me how to schedule a batch job to run every 5 minutes
> using
> the "AT" scheduler?
> 
> Thanks!
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

FOOT-AND-MOUTH

[dgoulet]

For all of you MicroSoft supporters out there!

Sorry Jared!

Dick Goulet

Forward Header_

FOOT-AND-MOUTH BELIEVED TO BE FIRST VIRUS UNABLE TO SPREAD THROUGH 
MICROSOFT OUTLOOK

Researchers Shocked to Finally Find Virus That Email App Doesn't Like

Atlanta, Ga. (GPS) Scientists at the Centers for Disease Control and 
Symantec's AntiVirus Research Center today confirmed that foot-and-mouth 
disease cannot be spread by Microsoft's Outlook email application, 
believed to be the first time the program has ever failed to propagate
a major virus.

"Frankly, we've never heard of a virus that couldn't spread through 
Microsoft Outlook, so our findings were, to say the least, unexpected," 
said Clive Sarnow, director of the CDC's infectious disease unit.

The study was immediately hailed by British officials, who said it will 
save millions of pounds and thousands of man hours.  "Up until now we 
have, quite naturally, assumed that both foot-and-mouth and mad cow were 
spread by Microsoft Outlook," said Nick Brown, Britain's Agriculture 
Minister. "By eliminating it, we can focus our resources elsewhere."

However, researchers in the Netherlands, where foot-and-mouth has 
recently appeared, said they are not yet prepared to disqualify Outlook, 
which has been the progenitor of viruses such as "I Love You," 
"Bubbleboy," "Anna Kournikova," and "Naked Wife," to name but a few.

Said Nils Overmars, director of the Molecular Virology Lab at Leiden 
University, "It's not that we don't trust the research, it's just that 
as scientists, we are trained to be skeptical of any finding that flies 
in the face of established truth.  And this one flies in the face
like a blind drunk sparrow."

Executives at Microsoft, meanwhile, were equally skeptical, insisting 
that Outlook's patented Virus Transfer Protocol (VTP) has proven 
virtually pervious to any virus.  The company, however, will issue a 
free VTP patch if it turns out the application is not vulnerable to 
foot-and-mouth.

Such an admission would be embarrassing for the software giant, but 
Symantec virologist Ariel Kologne insisted that no one is more 
humiliated by the study than she is.  "Only last week, I had a reporter 
ask if the foot-and-mouth virus spreads through Microsoft Outlook, and I 
told him, 'Doesn't everything?'" she recalled. "Who would've thought?"

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sql query

[Ravindra Basavaraja]

Though I had some fair idea of what it was, but now things are very clear
after all the replies.

Thanks for all the reply.

Ravindra

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2001 3:21 AM
To: Multiple recipients of list ORACLE-L



sysdate - 1 is sysdate minus one day
sysdate - 1/24 is sysdate minus 1 hour
sysdate - 1/24/60 is sysdate minus 1 minute = sysdate -1/(24*60)
sysdate - 1/24/60/60 is sysdate minus 1 second = sysdate - 1/(24*60*60) =
sysdate - 1/(24*3600)



"Ravindra
Basavaraja"  To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
 Subject: sql query
Sent by:
[EMAIL PROTECTED]
om


03-04-2001
06:00
Please respond
to ORACLE-L





I found a query to get the time 5 seconds less than the current time as

select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual;

I am really not sure as to why 24*3600 is used for.

Can anyone tell me why it is used.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




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

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

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

RE: Slightly OT: Capturing a failed status of an ftp process

[Gogala, Mladen]

Mounting the target file system with NFS, Samba or Sharity would also
be an option.

-Original Message-
Sent: Tuesday, April 03, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


I think I've seen an answer to this, but I never needed it before.  If
anyone can help, I would greatly appreciate it.

We are trying to ftp files from one server to another.  (Archive logs
for Oracle).  We want to be able to capture the status when the ftp
fails, so that we can notify the DBAs to check the process out.  This is
all being done within a shell script that compress the log file first,
then calls another script to do the actual ftp.  But when the child
script executes, it returns a successful status to the parent script.  I
don't know any way to tell the script that is doing the ftp to send the
message, because any non-ftp command within that script fails.  (Of
course, that could just be because I don't know how to do what I want to
do).

If anybody has invented this wheel before, or has any tips on where to
look for more info on how to do what I need to do, please let me know.

TIA,

Terry

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: function to get GMT time

[Ruth Gramolini]

This gives you the current sysdate from your server and calls it GMT. 

Ruth
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 1:21 PM


> Hi Andreas,
> 
> You can do this with the NEW_TIME date funntion:
> 
> SQL> alter session set NLS_DATE_FORMAT = 'DD-MM-YYY HH24:MI:SS';
> 
> Session altered.
> 
> SQL> select sysdate "GMT" from dual;
> 
> GMT
> --
> 03-04-001 17:05:25
> 
> SQL> select new_time(sysdate, 'GMT', 'AST') "AST" from dual;
> 
> AST
> --
> 03-04-001 13:08:41
> 
> This shows Atlantic Standard Time, there are a list of the time zones
> available, and description of the funciton in the SQL Reference Manaual -
> page 185
> 
> HTH
> 
> Mark
> 
> 
> 
> -Original Message-
> Andreas VASL/FAS
> Sent: Tuesday, April 03, 2001 04:45
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi !
> 
> Is there a way to get GMT time within PL/SQL independent from
> the local time(zone), I'm looking for a function similar to SYSDATE,
> but it should return GMT instead of the local time.
> 
> 
> TIA
> 
> Andreas
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Haunschmidt Andreas VASL/FAS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mark Leith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:Multi Threaded Server

[dgoulet]

Jack,

I use MTS of any instance were the company intranet gets involved for
similar reasons.  There are two problems that I've run into with MTS over the
years.  The first is running out of shared pool space.  With MTS the query and
resulting data get stored in the shared pool, so at least one should increase
this setting in init.ora.  The second gets into the basics of configuring MTS. 
First, make sure there are a minimum of at least 2 shared servers per
dispatcher.  If you've for 3 dispatchers then you need a minimum of 6 shared
servers.  The DB will not complain on startup if this is wrong, but it will at
some time thereafter, by crashing.  The second has to do with the number of
shared servers there are during normal operations.  Remember that once a user
submits a transaction to the database that it will sit in the shared pool
awaiting processing until a server becomes available.  This very much a FIFO
operation, so if all of the servers are busy then it may wait for a long time. 
My rule of thumb is to set MTS_MAX_SERVERS equal to 75% of max expected
connections.  The actual number running at any time will vary between the
minimum and maximum which is what it's suppose to do.  Also, configure at least
one connection method that will use a dedicated server.  Helps an awful lot with
batch data loads, actually an Oracle recommendation.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   4/3/2001 7:32 AM

Hi All,

We have about 400-500 connections to our database and are now considering
going to MTS.

Can anybody share their experience? pitfalls? things to take care of?
performance issues?

Any help appreciated.

Our main objective is to lower the amount of RAM consumed by the Oracle
sessions.


Jack

(Oracle DBA) Informatie Systemen

Ernst & Young
Informatie & Communicatie Technologie

Kantoor Gouda
Tel.: 0182 575316 (intern: 923 316)
Fax: 0182 536311
E-mail: [EMAIL PROTECTED]


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

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

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

Fat City Network Services-- (858) 538-5051  FAX: (

RE: "AT" scheduler

[Gogala, Mladen]

echo "0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/bin/myjob">
/tmp/crontab
crontab /tmp/crontab

-Original Message-
Sent: Tuesday, April 03, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L



Can anyone tell me how to schedule a batch job to run every 5 minutes using
the "AT" scheduler?

Thanks!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Slightly OT: Capturing a failed status of an ftp process

[Gogala, Mladen]

Why don't you use rcp or rdist instead?

-Original Message-
Sent: Tuesday, April 03, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


I think I've seen an answer to this, but I never needed it before.  If
anyone can help, I would greatly appreciate it.

We are trying to ftp files from one server to another.  (Archive logs
for Oracle).  We want to be able to capture the status when the ftp
fails, so that we can notify the DBAs to check the process out.  This is
all being done within a shell script that compress the log file first,
then calls another script to do the actual ftp.  But when the child
script executes, it returns a successful status to the parent script.  I
don't know any way to tell the script that is doing the ftp to send the
message, because any non-ftp command within that script fails.  (Of
course, that could just be because I don't know how to do what I want to
do).

If anybody has invented this wheel before, or has any tips on where to
look for more info on how to do what I need to do, please let me know.

TIA,

Terry

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Script to reverse engineer all objects in a schema to DDL?

[dana]

> There are other programs such as SQL Navigator, DB Artisan, EZSQL are
> available but requires you to purchase a copy.


SQL Programmer from Sylvain-Faust, another commercial product, will do
this as well; at least on a per-object basis. It's a terrific tool all
around:

http://www.sfi-software.com/
 
 - Dana



__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Slightly OT: Capturing a failed status of an ftp process

[Ron Rogers]

Terry,
If I remember correctly the ftp supplies a return code. You could capture the return 
code and have a second script act accordingly on the return code. I think code 220 is 
successfull.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 04/03/01 01:30PM >>>
I think I've seen an answer to this, but I never needed it before.  If
anyone can help, I would greatly appreciate it.

We are trying to ftp files from one server to another.  (Archive logs
for Oracle).  We want to be able to capture the status when the ftp
fails, so that we can notify the DBAs to check the process out.  This is
all being done within a shell script that compress the log file first,
then calls another script to do the actual ftp.  But when the child
script executes, it returns a successful status to the parent script.  I
don't know any way to tell the script that is doing the ftp to send the
message, because any non-ftp command within that script fails.  (Of
course, that could just be because I don't know how to do what I want to
do).

If anybody has invented this wheel before, or has any tips on where to
look for more info on how to do what I need to do, please let me know.

TIA,

Terry

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Metalink Response ....FYI

[Dasko, Dan]

But if everyone gives up on Metastink, then they'll be very interested in 9i
because it eliminates the need for a dba or a developer or an iTAR.

Listen to me now or hear me later.
Dan

-Original Message-
Sent: Tuesday, April 03, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L


Ranting on...
They say there is unexpected demand.  They created it by refusing to talk to
anyone without their opening an iTar so how can they say it was unexpected.
Maybe they are counting on everyone giving up on Metalink thereby reducing
demand ..
End of ranting...

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 11:50 AM


> 
> 1500 users?  And ORACLE FREAKING CORPORATION is having
> trouble meeting the demand? Geez Louise, this is *exactly*
> the type of thing companies get roasted alive for. I am
> supposed to believe these guys when they say "We'll scale
> all the way to Andromeda!".
>
> Sheesh, we run multiple databases around here with 1500+
> active users from a base of 40,000 with nowhere near
> the response problems.  We have had two unsked outages
> a year, on average.
>
> Oracle really needs to hire some system engineers and DBAs.
>
> What a freaking joke.
> 
>
> Thanks for the news, Raj. Now I feel better about Metalink.
>
>
>
>
> ||-Original Message-
> ||From: Raj Sakthi [mailto:[EMAIL PROTECTED]]
> ||Sent: Tuesday, April 03, 2001 10:35 AM
> ||To: Multiple recipients of list ORACLE-L
> ||Subject: Metalink Response FYI
> ||
> ||
> ||Hi Folks ,
> ||I know lot of Metastink info floating around...so I
> ||thought I would post this for fun/info .
> ||I got this response from Metastink ..
> ||
> ||"Thank you for your comments on Metalink, the more
> ||feedback we get the better we
> ||here at Oracle Corporation will be able to service
> ||your needs.  We have seen
> ||tremendous increase in customer usage of Metalink over
> ||the past 6 months.
> ||There are now about 240,000 registered users and at
> ||times we have over 1,500 active users.
> ||We know that the service does not meet our or
> ||customers expectations.  With this in mind we
> ||have added capacity to our database servers and have
> ||also increased the number of middle
> ||tier application servers.  Our experience is that the
> ||demand for online services has become
> ||so strong that as soon as we bring in more capacity,
> ||it is quickly consumed.  We have also
> ||experience intermittent network and architecture
> ||problems that have caused several failovers
> ||from one server to the other resulting in slower
> ||performance than we expect. When these events
> ||occur, we strive to understand root cause and take
> ||corrective and preventive action.
> ||Sometime before summer, we exp!!ect to migrate the
> ||online services to Oracle's Customer
> ||Relationship Management (CRM) suite enabling us to
> ||deliver more to our customers.This is
> ||a global issue for us and it has great attention
> ||within Oracle management.  We recognize
> ||how valuable our customers are to us and understand
> ||the immense value that Metalink can
> ||bring to them.  We are working to meet your needs as
> ||fast as we can. Thank you for your
> ||patience as we continue to work to bring you the best
> ||in online support services."
> ||
> ||Interesting.won't you say..: )
> ||RS
> ||
> ||__
> ||Do You Yahoo!?
> ||Get email at your own domain with Yahoo! Mail.
> ||http://personal.mail.yahoo.com/
> ||--
> ||Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ||--
> ||Author: Raj Sakthi
> ||  INET: [EMAIL PROTECTED]
> ||
> ||Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> ||San Diego, California-- Public Internet access / Mailing Lists
> ||
> ||To REMOVE yourself from this mailing list, send an E-Mail message
> ||to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> ||the message BODY, include a line containing: UNSUB ORACLE-L
> ||(or the name of mailing list you want to be removed from).  You may
> ||also send the HELP command for other information (like subscribing).
> ||
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

_
This e-mail

RE: Slightly OT: Capturing a failed status of an ftp process

[Wolfe, Charles]

Try using expect to script the ftp session. 

http://expect.nist.gov/


-Original Message-
Sent: Tuesday, April 03, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L


I think I've seen an answer to this, but I never needed it before.  If
anyone can help, I would greatly appreciate it.

We are trying to ftp files from one server to another.  (Archive logs
for Oracle).  We want to be able to capture the status when the ftp
fails, so that we can notify the DBAs to check the process out.  This is
all being done within a shell script that compress the log file first,
then calls another script to do the actual ftp.  But when the child
script executes, it returns a successful status to the parent script.  I
don't know any way to tell the script that is doing the ftp to send the
message, because any non-ftp command within that script fails.  (Of
course, that could just be because I don't know how to do what I want to
do).

If anybody has invented this wheel before, or has any tips on where to
look for more info on how to do what I need to do, please let me know.

TIA,

Terry

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wolfe, Charles
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: function to get GMT time

[Gogala, Mladen]

You can always build qan external function to do so.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L


Hi !

Is there a way to get GMT time within PL/SQL independent from
the local time(zone), I'm looking for a function similar to SYSDATE,
but it should return GMT instead of the local time.


TIA

Andreas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Haunschmidt Andreas VASL/FAS
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: function to get GMT time

[Ruth Gramolini]

This gives GMT. Thanks!  Ruth
- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 1:15 PM


> Hi Andreas,
> 
>Please try this.
> 
>select sysdate, new_time(sysdate,'EST','GMT') from dual;
> 
> Thanks,
> Gurdarshan
> 
> 
> -Original Message-
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 11:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi !
> 
> Is there a way to get GMT time within PL/SQL independent from
> the local time(zone), I'm looking for a function similar to SYSDATE,
> but it should return GMT instead of the local time.
> 
> 
> TIA
> 
> Andreas
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Haunschmidt Andreas VASL/FAS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Singh, Gurdarshan (Gurdarshan)** CTR **
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: Rollback seg for an entire session, not just per tran

[Raj Gopalan]

Oops.. That was typo :-)

-Original Message-
Sent: 03 April 2001 17:01
To: Raj Gopalan; Multiple recipients of list ORACLE-L


Raj,

OH, I hate to contradict people, but several months ago we had a couple
of
very long running jobs that accidentally filled all of the rollback segment
space with the exception of SYSTEM.  The processes all crashed with an
Oracle
error that said the SYSTEM rollback segment was strictly for changes in the
data
dictionary.  Therefore NO it does not get used for user session transactions
outside of data dictionary stuff which we all know does an autocommit.

Dick Goulet

Reply Separator
Author: Raj Gopalan <[EMAIL PROTECTED]>
Date:   4/3/2001 8:50 AM

Dana

1. System rollback segment will be used for user session transactions.

2. The only way I think of assinging a rollback segment is by using SET
TRANSACTION COMMAND.

3. There wont be any implict commits in a PL/SQL procedure and on exit of
the PL/SQL will also not commit the data. You need to explicitly specify the
commit.

-Original Message-
Sent: 03 April 2001 15:55
To: Multiple recipients of list ORACLE-L
Implicit commits in PL/SQL?



A colleague wants to do a large load using multiple PL/SQL programs;
she typically (has the DBA) turns off all rollback segments except for
SYSTEM and one large rollback segment.

Some questions:

Will the rollback segment called SYSTEM in the SYSTEM tablespace never
be used for user session transactions?

Is there any way to specify which rollback segment to use for an entire
session versus per transaction? I'm not sure if her PL/SQL code
performs implicit commits so I'm not sure doing one commit + set
transaction before executing the procedure(s) will have the desired
effect. Will Oracle ever do an implicit commit inside a PL/SQL
procedure or is a commit performed only with the commit command or when
exiting a procedure?

Thanks very much.

 - Dana






__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Gopalan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raj Gopalan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OCI

[Morton, Ronald D]

Lee,

Our implementation of OCI makes use of the .h files in
$ORACLE_HOME/rdbms/public and also the shared library libclntsh.so in
$ORACLE_HOME/lib.  These have to exist as part of the client installation.
If I'm not mistaken, I had to select the programmer option from the list of
installable pieces during the 8.0.5 client install.

Hope this helps.

Ron Morton
Database Architect / Administrator
Union Switch & Signal Inc
[EMAIL PROTECTED]

> -Original Message-
> From: lerobe - Lee Robertson [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 10:45 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OCI
> 
> All,
>  
> Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f
>  
> One of the duhvelopers here wants to use OCI. I am sure it is installed as
> part of the server installation but where do all the relevant files live
> for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is
> this normal. ??
>  
> Regards
> 
> Lee Robertson 
> Acxiom 
> Tel:0191 525 7344 
> Fax:0191 525 7007 
> Email: [EMAIL PROTECTED] 
> 
>  
> 
> 
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader 
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited. 
> If you have received this communication in error, please 
> re-send this communication to the sender and delete the 
> original message or any copy of it from your computer
> system.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Morton, Ronald D
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: function to get GMT time

[Singh, Gurdarshan (Gurdarshan)** CTR **]

Hi Andreas,

   Please try this.

   select sysdate, new_time(sysdate,'EST','GMT') from dual;

Thanks,
Gurdarshan


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L


Hi !

Is there a way to get GMT time within PL/SQL independent from
the local time(zone), I'm looking for a function similar to SYSDATE,
but it should return GMT instead of the local time.


TIA

Andreas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Haunschmidt Andreas VASL/FAS
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Singh, Gurdarshan (Gurdarshan)** CTR **
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).