RE: Unable to open the database,Urgent!!!

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 31st March 2001. 

Saroj,

You need to change your kernel parameters to allow extra semaphores, look at
shmmax, semmni, semmns and semmsl
Unfortunately you will need a system reboot before the changes will take
effect

Hope that helps

John



This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Backup for VLDB

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

>From the sites I have worked at recently RMAN seems to be the way to go. It
certainly seems a lot more robust and reliable than it was in its earliest
release.
The 'normal' way of operation I have seen is either
Use a 3 way mirror, shut down the database, start up  then shutdown normal,
then split one mirror. The database can then be restarted (total outage less
than 20 minutes)
The backup then takes place against the 3rd mirror and is a cold backup and
can be written to tape. The 3rd mirror is then synced or re-silvered at your
convenience after the backup is complete (5 hours later?). 
One advantage of using this method is that the 3rd mirror is kept un-synced
all day until just before the backup ( we used EMC BCVs) and then merged.
Therefore there is a good copy of the database almost immediately available
that only needs 1 day's set of archive log applying in the event of  a
recovery.

The other option is for hot backups, again using RMAN. Perhaps back up to
disk and then archive to tape at your leisure. No downtime necessary

For the benefits of RMAn read an execllent essay by Tim Gorman of SageLogix
- Is RMAN really worth the trouble. A link can be found from
www.timonions.com <http://www.timonions.com>  site

HTH


John



John Hallas

*+44 (0) 115 945 6643
*  +44 (0) 115 945 6774


This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 from noarchive db corrected

[Hallas, John]

know someone who can answer the above question?
Forward it to
> them!
> to unsubscribe, send a blank email to
[EMAIL PROTECTED]
> to subscribe send a blank email to
[EMAIL PROTECTED]
> Visit the list archive:
http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
>
> --
> 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).

--
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA
support?
For Sale: Oracle-dba.com domain, its not going cheap but
feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

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


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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 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: Suhen Pather
  INET: [EMAIL PROTECTED]

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


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

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

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


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

RE: Recovery from noarchive db corrected

[Hallas, John]

   support?
For Sale: Oracle-dba.com domain, its not
going cheap but
feel free to
ask :)
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joseph S. Testa
  INET: [EMAIL PROTECTED]

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



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

--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: 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: Suhen Pather
  INET: [EMAIL PROTECTED]

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



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

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

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



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


    This e-mail and any files transmitted with it, are
confidential to Logica
and are intended solely for the use of the individual or
entity to whom they
are addressed.
--
  

RE: RMAN doubts

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

CASE1  - I thought RMAN did not backup TEMP tablespaces (if they are marked
as TEMPORARY). When you do a restore database the TEMP t/s needs manually
re-creating


John Hallas

*+44 (0) 115 945 6643
*  +44 (0) 115 945 6774


-Original Message-
From:   Rahul Dandekar [mailto:[EMAIL PROTECTED]]
Sent:   11 April 2001 21:06
To: Multiple recipients of list ORACLE-L
Subject:RMAN doubts

1. The database is running in NOARCHEVELOG mode :
   Oracle manual says that 'you can skip tablespaces, but
skipped tablespace
   that has not been offline or read-only since its last
backup will be lost
   if the database has to be restored from a backup.'

   Can we skip backing up of TEMP tablespace?
   In case recovery is required then instead of recovering
10GB,
   we could create it by SQL statements.

2. Will following command backup all the archved redo logs
to tape and
delete
   them from the LOG_ARCHIVE_DEST?

   run {
   allocate channel ch1 type 'SBT_TAPE';
   backup
   archivelog all
   delete input;
}

Still more to come...

TIA,

-Rahul
P.S. I have passed OCP 8 Backup and Recovery exam with score
of 58/60.
That's
 why probably I am having so many doubts. Was better
ithout OCP ;-(


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

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


To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Tablespaces

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

I have noted a very minor issue on our AIX 4.3 systems running 8.1.6.0.0
when creating a LMT.
We get the error message ORA-01543 tablespace XXX already exists but it then
goes on to create the tablespace.

This is repeatable on several systems all at the same version.  On an
8.1.6.3 system it does not happen. There is nothing on Metalink.

The command I am using is create tablespace john datafile '' size
100M extent management local uniform size 1M;

Anybody getting this on an 8.1.6.0 system?

John





-Original Message-
From:   Stephen Andert
[mailto:[EMAIL PROTECTED]]
Sent:   18 April 2001 01:03
To: Multiple recipients of list ORACLE-L
Subject:Re: Locally Managed Tablespaces

Patricia, 

FWIW, We have been using them for several months now and
have not seen anything negative as a result.  We decided to start using them
for all new tablespaces and we add a new set of tablespaces every month to
accomodate our partitioning strategy.

Our biggest databases that we are doing this with are over
200MB on Compaq Tru64. Database version was 8.1.6.0 and we have moved to
8.1.6.2 with no noted problems.  

Good luck.

Stephen 

>>> [EMAIL PROTECTED] 04/17 4:35 PM >>>

I am interested in some statistics on Oracle locally managed
tablespaces.  I
have been looking for any bugs or negative info about them.
Are they in use
at alot of sites?  Seems like all the information I have
come across is
positive. Which is great!  But maybe they aren't being used
at alot of
sites.  Can I hear about experiences from others on this
list?  how many
sites are actually using them?
I have several databases that I am getting ready to go
production soon and
would like to create the tablespaces as locally managed, but
need more
statistics.

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

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


To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Stephen Andert
  INET: [EMAIL PROTECTED]

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


To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Temporary Tablespace Design

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 


Kirti Deshpande writes 

"Also, keep SORT_AREA_RETAINED_SIZE the same as SORT_AREA_SIZE. As the
former will be used while fetching data after sort phase is completed."

I thought best advice was to make the retained size smaller (50%?) of
sort_area_size to allow initial sort memory to be released after the first
part of the sort is managed and only the merge phase of a disk sort is left
to do.

I appreciate that a lot depends on the amount of memory available and the
number of concurrent processes that may be performing sorts but surely the
aim is to free memory up as soon as possible down to the
sort_area_retained_size

Thanks

John

(PS I do apologise for the rubbish at the top of this mail but it is
inserted after I have sent the mail into our mail gateway)





This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Temporary Tablespace Design

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

Tim,
You are confirming my original understanding. However Kirti stated that
based on your figures if a sort was used then malloc would be called  4
times to get from 512000 to 2048000. I do not know the answer for certain
but Kirti's view seems logical because sort_area_size is the MAX size and it
is very likely that only the retained is allocated initially and then
increased in increments up to sort_area_retained_size. Any bigger and the
sort is done to the temporary tablespace.

John


-Original Message-
From:   Tim Sawmiller [mailto:[EMAIL PROTECTED]]
Sent:   18 April 2001 17:26
To: Multiple recipients of list ORACLE-L
Subject:RE: Temporary Tablespace Design

Well, not quite.  SORT_AREA_SIZE specifies the maximum
amount, in bytes, of memory to use for a sort.  After the sort is complete
and all that remains to do is to return the rows, the memory is released
down to the size specified by SORT_AREA_RETAINED_SIZE.  After the last row
is returned, all memory is freed.  Temporary disk is used for the
intermediate sort runs only if the SORT_AREA_SIZE isn't large enough to
handle the sort in memory.  The SORT_AREA_RETAINED_SIZE controls the size of
the read buffer which is used to maintain a portion of the sort in memory.
Myself, I use 2048000 for SORT_AREA_SIZE, and 512000 for
SORT_AREA_RETAINED_SIZE.

>>> [EMAIL PROTECTED] 04/18/01 11:36AM >>>
I think you are not correct. First - Oracle allocates memory
for sorting as
needed by 8K chunks up to sort_area_size. Second if your
sort_area_size is
large enough to do sort in memory and your
sort_area_retained_size <
sort_area_size oracle will dump sorted data into temporary
tablespace and
then read from this tablespace. So it is a tradeoff between
late memory
release and temporary tablespace I/O.

Alex Hillman

-Original Message-
Sent: Wednesday, April 18, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L


Hi John,
As you mentioned, it depends on a number of factors. I
believe I replied to
a question about improving performance of index building
after an import.
Anyway, here is the reasoning behind why I said that
When Oracle begins
sorting, it starts with the memory equal to
sort_area_retained_size value
and may eventually acquire memory equal to sort_area_size.
This involves at
OS level, malloc (and may be some other) memory mgmt
routine(s). After the
sort phase is complete, Oracle will trigger memory
de-allocation and the OS
will go at work again. If there are servile sessions
performing sorts, there
can be an increased OS level memory mgmt activity (while
attaining
sort_area_size and releasing it back to
sort_area_retained_size) . But if
the server has *enough* memory keeping
sort_area_retained_size equal to
sort_area_size may actually help. I also assume that these
days most
installations have ample memory. And that the advice of
using 50% (which I
had heard of) of sort area size for sort area retained size
should always be
viewed in light of one's requirements and resource
availability. But I can't
stop wondering... how come it was 50% and not 10% or 20%..
so it's all
relative.  I have been using what I suggested, for a number
of years now
with no problems or complaints. 

Cheers !

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com 

> -----Original Message-
> From: Hallas, John [SMTP:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 18, 2001 6:21 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Temporary Tablespace Design
> 
> 
> Kirti Deshpande writes 
> 
> "Also, keep SORT_AREA_RETAINED_SIZE the same as
SORT_AREA_SIZE. As the
> former will be used while fetching data after sort phase
is completed."
> 
> I thought best advice was to make the retained size
smaller (50%?) of
>

RE: Enqueue timeouts

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

Steve Adams discusses enqueue_resources in some detail in his Oracle 8I
internal services book. A brief subset of what he says is as follows

There is no substance to increasing enqueue_resources to combat
enqueue_waits. Oracle returns a ORA-52 or ORA-53 error if it fails to find a
free slot in the enqueue resources or locks fixed arrays. If you are not
seeing that error message then there is no need to increase
enqueue_resources.

Look at v$resource_limits and adjust enqueue_resources and enqueue_locks
parameters to be > 20% above max utilisation recorded.

Look at the dynamic table X$KSQST to find the type of resource that is being
waited for

Finally the enqueue_timeout statistic is misleading as it does not show
timeouts but rather the number of enqueue requests that have been aborted.
This may be because of timeouts but it may also be because a lock is held on
the rows and the code specifies no wait therefore the call is aborted.

I hope I have summarised what Steve says correctly and it helps

Regards

John


-Original Message-
From:   Nicoll, Iain (Calanais)
[mailto:[EMAIL PROTECTED]]
Sent:   20 April 2001 12:40
To: Multiple recipients of list ORACLE-L
Subject:Enqueue timeouts

Can anyone offer advice on what the problem may be with  the
following from
v$sysstat on one of our databases.

NAME   VALUE
-- -
enqueue timeouts   17499101
enqueue waits446362
enqueue deadlocks 2
enqueue requests   47731729
enqueue conversions 1228500
enqueue releases   30232445

Enqueue_resources is set at 5000, DML_Locks is at 4000 and
sessions at 412
so enqueue_resources looks high already but I came across a
note which
suggested increasing enqueue_resources where timeouts were
occurring.

Would anything else be causing this or is there a way to
calculate what
enqueue_resource should be set at.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicoll, Iain (Calanais)
  INET: [EMAIL PROTECTED]

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


To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ASP Assistance

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

I do not know ASP but shouldn't line 4 read IPCheck not UserIP

John

From:   William Rogge [mailto:[EMAIL PROTECTED]]
Sent:   20 April 2001 14:50
To: Multiple recipients of list ORACLE-L
Subject:OT: ASP Assistance

I apologize for being off topic here, but I am stuck.

I have been struggling for 3 days on what I believe is a
simple script.

Here is the piece of code which is not functioning as I
require:

1  UserIP = Request.ServerVariable("REMOTE_HOST")
2  IPCheck = Left(UserIP,7)
3  If UserIP = "192.168" Then
4 parser.setSingleSessionField "My_Template",
"template_i"
5  Else
6 parser.setSingleSessionField "My_Template",
"template_o"
7  End If

If I comment out all but line 4, I can verify that
My_Template is set to 
'template_i'.  If I comment out all but line 6, I can verify
that 
My_Template is set to 'template_o'.  If I run with now lines
commented, 
My_Template winds up blank.

What am I doing wrong?
-- 
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).


This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Pinning Packages Question

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

Larry, you are quite correct. As the DBMS_SHARED_POOL.(KEEP|UNKEEP)  package
name suggests the package is pinned (or kept) until either it is unpinned or
the instance is restarted. It will be not aged out

John











John Hallas

*+44 (0) 115 945 6643
*  +44 (0) 115 945 6774


-Original Message-
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:   27 April 2001 01:41
To: Multiple recipients of list ORACLE-L
Subject:Pinning Packages Question

Listers,

I was involved in a meeting today, strictly as a listener
(no pun intended).
A consultant made the statement that pinned packages are
subject to being
aged out of the shared pool, using an LRU type of mechanism.
My
understanding is that if you pin a package, it stays pinned
(except maybe if
it gets invalidated? - not sure on that).

From the Oracle documentation on DBMS_SHARED_POOL.KEEP:

This procedure keeps an object in the shared pool. Once an
object has been
kept in the shared pool, it is not subject to aging out of
the pool.

The above statement from the doc's seems to contradict what
the consultant
said.

I am asking this because I am *not* a DBA. I've always been
a developer,
and, was a DBA for a few years a very long time ago. The
DBA's I work with
are kind enough to involve me in meetings and discussions on
DBA topics --
they know that I like to at least try to be somewhat in
touch with the DBA
side of things (even if a little knowledge is more dangerous
than none). It
allows us to work better together. But, I know to not ask
questions in
meetings -- those questions can wait for later. I don't need
to get a
meeting sidetracked. So, I didn't ask about the consultant's
statement that
pinned packages can get aged out, especially in front of
him. And, I never
had the chance the ask about this with the DBA's after the
meeting.

Anyone want to clarify this point? The doc's seem pretty
clear, but, I could
be missing some of the subtle things that aren't in
documents and that only
seasoned DBA's know.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]

-- 
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).


This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Please Advice on Performance Tuning

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

Naba,
Whilst you state that both schemas have the same initial and next etc you
don't so whether they have the same number of extents. One thing I have seen
a couple of times is a table that has a HWM due to rows being added and
deleted. A FTS reads upto the HWM despite the fact there may be only a few
rows in then table. Just a thought.
As David Barbour suggests, tracing is the best option to identify where the
time is going. Perhaps an easier method of putting trace on each piece of
code is to put the sql_trace = true parameter into your init.ora, restart
the database and run the 30 minutes worth of code. Analyze the large trace
file that will be produced (tkprof) and focus on the piece(s) of code with
largest elapsed times .
 
HTH
 
John 

-Original Message-
Sent: 27 April 2001 06:25
To: Multiple recipients of list ORACLE-L


Hi all,
 
We have got a Payroll Application develeoped in-house.
 
It takes 30-34 Minutes to Run this Batch Application.
General feeling is - it should be able to process it
within 10-15 Minutes may be less than that.
 
I am to look into this problem and give a solution to it.
 
Steps I had followed as
 
1. Import the payroll user to another Oracle User in the same database.

2. Removed unnecessary Index , Put parallelism into few
   tables by Alter table tab1 Parallel(DEGREE 5)

3. Analyze the tables with compute statistics;
 
4. Run the payroll without checking any inefficient SQL or 
   wrong programming logic in the those Packages( It has only
   two Package in it no other stand alone Procedure or  function).
 
Payroll under this new Oracle User runs in 22-24 Minutes, 6-9 Minutes
less. So, I asked Payroll Person to remove those unnecessary Index,
asked him to put parallelism into those tables which I had done.
He runs the Payroll with no Improvement at all. I asked again to 
drop those table and recreate it with new storage parameter same 
as the one created at New User.  Still no visible Improvement.
 
At this stage every table in both user has same storage parameter,same
index ,and also analyzed. The question is why in One User 
it runs in 22-24 Min and in another 30-34 Min ?
 
Now Please advice me what do I check or to do, so that the it time takes
to run comes down to 22-24 Min, same as the new user.
 
Oracle 8.1.4
Optimize goal : choose
Biggest table haiving record less than 6 rows.
 
Thanks in Advance
 
Naba



This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Column name

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

Roland
It is quite normal to use the same column name for more than one table in a
schema. In fact when using foreign keys it is almost advisable
John
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   27 April 2001 11:01
To: Multiple recipients of list ORACLE-L
Subject:Column name

Can I use the same column name in the same database and in
the same schema? Could this cause me lots of trouble?

Roland Sköldblom

-- 
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).


This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

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

RE: V$session

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

Funnily enough I have just  been trying to identify rogue processes at the
Unix level and did the following 

Ps -ef|grep oracle | sort -nr +2 

Which gave me a lsit of processes with the 3rd field not set to a genuine
owner process. I removed all the pmon, arch processes etc and was left with
the following line
oracle  22138  1   0 16:52:16  -  0:00 oracleeval
(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

Going into sqlplus I queried V$session with the following query

select sid,serial#,paddr,process from v$session order by 2,4

and determined that the process 22138 was not listed in Oracle and therefore
was defunct. I therefore believe that it is correct to kill -9 the Unix
process.

Is my thinking correct on all this 

John


This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Strange report from 'vmstat'

[Hallas, John]

FOR YOUR INFORMATION

ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has 
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails 
using the old format will continue to be delivered until 30th June 2001. 

Sonja,
The 'fre' column is not exactly as it appears. It appears to show free RAM
memory pages at 4K each. However pages are not given back to the fre list
until needed. In particular when the system uses large amounts of memory
from for I/O caching then these pages are given back only when the free list
is getting empty.
The sum of the 'avm' and 'fre' columns do not need to add up to the real
memory size of the machine. (roughly transcribed from the AIX Survival
Guide)

What exactly is the problem you have identified here?

John

-Original Message-
From:   Sonja Sehovic [mailto:[EMAIL PROTECTED]]
Sent:   02 May 2001 15:20
To: Multiple recipients of list ORACLE-L
Subject:Strange report from 'vmstat'

Hi all!
Oracle 8.1.7 on AIX (8GB RAM (+ swap space 9GB)).
It concerns AIX memory 'problem'.   
When I issue vmstat command, we got following result:

/u01/app/oracle/product/8.1.7.>vmstat 2 4
kthr memory page  faultscpu
- ---   ---
 r  b   avm   fre  re  pi  po  fr   sr  cy  in   sy  cs us sy id wa
 0  0 580556   554   0   0   0  14   34   0 126  137  63 11  5 82  1
 0  2 580556   549   0   0   0   00   0 708  527 206  0  0 99  0
 0  2 580557   548   0   0   0   00   0 829 99854 421  2 10 88
0
 0  2 580557   548   0   0   0   00   0 637  111  35  0  0 99  0
 
Analysing this output, it seams that we have cca 2GB RAM (example:
(580557 +
548)* 4096 = 2,2 GB), while we expected min 8GB.
This gap between 8GB and output from vmstat report, increases in
time. 
The question is if our calculation was right, is this the right way
to
analyse this at all?
Maybe it is important to say, that our Oracle is installed on OFA
using data
files, max size 2GB, in same volume group(not on raw devices).
Do you know of any AIX memory problems which can manifests as
mentioned
above?

TIA,
Sonja

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

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

Taking your time when a crisis occurs

[Hallas, John]

s the remaining logs from the
active system, I'm
> > assuming he is recovering to somewhere other than his
production system.
> > Otherwise his only recourse is OTS.
> >
> > Dick Goulet
> > Oracle Certified 8i DBA
> >
> > Reply Separator
> > Author: Jonathan Gennick <[EMAIL PROTECTED]>
> > Date:   5/1/2001 8:55 PM
> >
> > Fellow list members, I received the following email from
a
> > reader a few minutes ago. If you skip down to where he
talks
> > about backup, you'll see that he's in trouble with a
> > database that won't recover. I've already suggested that
he
> > open a TAR, and that he supply more specifics as to
error
> > messages and the like, but maybe someone on this list
can
> > draw some conclusions from what he's told me so far. If
> > you're good at recovery, have a look at what he says.
I'll
> > post his email address later if he says its ok, and I'll
> > pass on any advice/suggestions I receive in the
meantime.
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> --
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
> San Diego, California-- Public Internet access /
Mailing Lists
>

> To REMOVE yourself from this mailing list, send an E-Mail
message
> to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
> the message BODY, include a line containing: UNSUB
ORACLE-L
> (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 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).


This e-mail and any files transmitted with it, are confidential to Logica and are 
intended solely for the use of the individual or entity to whom they are addressed. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: dropping a database link

[Hallas John]

Title: RE: dropping a database link





I remember raising a TAR on this issue about 5 years ago and the upshot was that it was a known oddity and I should raise an enhancement request. 

I am sure I did raise such a request but never heard anything more about it.


Regards


John


-Original Message-
From: Henry Poras [mailto:[EMAIL PROTECTED]]
Sent: 13 August 01 17:35
To: Multiple recipients of list ORACLE-L
Subject: RE: dropping a database link



Quoting from the Distributed Database Systems Manual (8.1.6)
"You can drop a database link just as you can drop a table or view. If the
link is private, then it must be in your schema."


So yes, a dba cannot drop database links owned by other users unless you use
your power (for good) to switch to the other schema.


Henry


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 11, 2001 12:01 AM
To: Multiple recipients of list ORACLE-L



so a dba cannot drop databaselinks owned by other users.


am i correct?


-Original Message-
Sent: Friday, August 10, 2001 3:47 PM
To: Multiple recipients of list ORACLE-L



drop database link scott.mylink; will only work if the link name is
scott.mylink, not if it is named mylink and owned by scott. If scott
owns
the link (private link), scott must drop the link. ('.' is a valid
character
in a database link name. Schema's cannot be specified).


Henry


-Original Message-
Sent: Friday, August 10, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L



srinvias,
Is the link a [public] or private link.
You must specify or the link will not be found.
ROR mª¿ªm


>>> [EMAIL PROTECTED] 08/10/01 11:00AM >>>
hi lists


when i tried to drop a users database link from sys or system, system is
denying and reporting database link not found.


i used


drop database link scott.mylink;


is there any way to do this. i dont have password for that user.


regards
srinvias
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED] 


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Henry Poras
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Henry Poras
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EX

RE: RAID or NOT to RAID? What's the diff???

[Hallas John]

Title: RE: RAID or NOT to RAID? What's the diff???





I took Jonathan's book on holiday (sad person that I am). I read about 150 pages but I was frustrated because there were ideas I came across that I wanted to try especially re calculations on some of the indexing tips he suggested.

But I agree with Rachel that reading a few pages or a section (not even a chapter) at a time is the best way to get through AND take the  information in at the same time.

It is an excellent book though. Mr Gennick's SQLLoader book is next on my list as I have a requirement to use the utility in some depth over the next few weeks.

John


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: 14 August 01 14:06
To: Multiple recipients of list ORACLE-L
Subject: Re: RAID or NOT to RAID? What's the diff???



time:  here's a trick I learned from my other vocation, writing :)


I used to think that unless I had a block of time, it wasn't worth sitting 
down to write. Then I realized that even if I wrote only a paragraph, that 
was one less I had to write.


So read a page, or two. You don't have to read a chapter at one sitting



>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: RAID or NOT to RAID? What's the diff???
>Date: Mon, 13 Aug 2001 20:25:21 -0800
>
>
>And a number of folks will highly recommend that book.
>
>If I could just get time to read more of it.  :(
>
>Jared
>
>On Monday 13 August 2001 13:06, Jonathan Lewis wrote:
> > And if it does confuse you, my book has
> > a couple of pretty pictures in it that might
> > help.
> >
> > Jonathan Lewis
> >
> > Seminars on getting the best out of Oracle
> > Last few places available for Sept 10th/11th
> > See http://www.jlcomp.demon.co.uk/seminar.html
> >
> >
> >
> >
> > -Original Message-
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Date: 13 August 2001 20:04
> >
> > |Hope this doesn't confuse you more.
> > |
> > |-steve
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California    -- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).



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


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


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

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





**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: rman/standby

[Hallas John]

Title: RE: rman/standby





Ravindra,
Two thoughts


1)  Why not copy the archivelogs as they are created by setting the log_archive_dest_1 parameter in your init.ora. This will make 2 copies of the archivelog file, the 2nd one of which can be either be local or to the remote server.

2)  In RMAN is it not possible to put a host command in your script prior to the 2nd backup command.This host command can then unix cp the files to an alternate directory or FTP as appropriate

John



-Original Message-
From: Ravindra Basavaraja [mailto:[EMAIL PROTECTED]]
Sent: 15 August 01 02:41
To: Multiple recipients of list ORACLE-L
Subject: rman/standby



I have configured a standby database operating in "manual mode" for our
production database.
I will have to apply the archive logs manually for the standby database.


The Archive logs that are genarated on the production server is backed up by
RMAN/netbackup and deleted after the backup.I have the stopped the deletion
of archive files from the RMAN script.


I want to find the best way of getting both RMAN/netbackup to happen and
also delete
the archive logs.But before they are deleted they need to be copied to a
seperate
directory so that I can apply those backed up files to the standby
database.I want to
make sure that I don't loose any of the archive files that the standby
database needs
to be in sync with the production database inclucing the current archive
logs that
may be backed up on the production database.


The rman script is like this
run {
allocate channel t1 type 'SBT_TAPE';
backup
  incremental level 1
  tag Dialy_Incremental_Backup_Level1
  filesperset 5
  format 'Data_%d_%s_%p_%t'
    (database);
  sql 'alter system archive log current';
backup
  filesperset 20
  format 'Arch_%d_%s_%p_%t'
#  (archivelog all delete input);
   (archivelog all);
}


How do I do it.?


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).





**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: Speed up Truncate tables

[Hallas John]

Title: RE: Speed up Truncate tables





Chuan,


Are you sure you were using the TRUNCATE TABLE command rather than DELETE
It sounds as if you are running a delete, especially if the HWM was not shrunk


John
-Original Message-
From: Chuan Zhang [mailto:[EMAIL PROTECTED]]
Sent: 15 August 01 09:10
To: Multiple recipients of list ORACLE-L
Subject: Speed up Truncate tables



Hi All,


    Is there any way to speed up the truncating a big table with 12 million
rows?


Basically, I implemented truncating that big table on Production, but it
affected the performance much, so I had to stop it in the middle of way. All
the rows were truncated but the HWM was not shrunk at all. I want to do it
again to get the space back. Is there any way to speed up this process?


Platform: Oracle EE8.0.6 and Solaris 2.7


Thanks a lot in advance.


Chuan


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


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

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





**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: Splitting a database: pro and cons

[Hallas John]

Title: RE: Splitting a database: pro and cons





Quick thoughts
Downside
Resource overhead of another instance (system temp tablespace memory etc)
Support requirements
Conectivity between the 2 instances via db_links although if theye are on the same server network traffic is negated


Upside
Upgrade paths can be different which is especially important when different vendors are involved
Service Level Agreements are easier to manage
No performance impact from one application on the other as far as Oracle is concerned (still need to monitor O/S)
Backup strategy - hot cold, archivelog etc can be different as necessary
Tuning can be more specific for each vendor app especially instance wide from the init.ora parameter


I am sure there are lots more


John


-Original Message-
From: Djordje Jankovic [mailto:[EMAIL PROTECTED]]
Sent: 14 August 01 23:52
To: Multiple recipients of list ORACLE-L
Subject: Splitting a database: pro and cons



Hi list,


I have two applications running against one database (in fact I have a few
but for the sake of this question two are enough).  The two apps have
different upgrade patterns and I would like to split them in two databases
that will be on the same unix server.  There are some views that are used
extensively that join data from both apps/schemas, and after the split those
should be made using db links.  I did some tests and comparisons of queries
going through links versus running them directly on the database, and did
not see a lot of difference. 


Does anybody see or know of any downside in splitting the database in two
:-(.  And any advantage :-).  What is the general strategy when installing
different apps (from different vendors) - put them on separate databases or
combining them.


Thanks.


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).





**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: slick looking website - VOUG - Portal

[Hallas John]

Title: RE: slick looking website - VOUG - Portal





I got those error messages twice and thought it was a sarcastic comment re the site but on the  3rd attempt I got in and it looks a useful site

Worth trying again
John


-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: 20 August 01 13:10
To: Multiple recipients of list ORACLE-L
Subject: RE: slick looking website - VOUG - Portal



You're joking, right?


All I see is about a dozen error messages.



Patrice Boivin
Systems Analyst (Oracle Certified DBA)



    -Original Message-
    From:   Paul Drake [SMTP:[EMAIL PROTECTED]]
    Sent:   Saturday, August 18, 2001 5:50 PM
    To: Multiple recipients of list ORACLE-L
    Subject:    slick looking website - VOUG - Portal


    
http://www.crtnet.com/servlet/page?_pageid=262,264&_dad=prod&_schema=PORTAL3
0&_mode=3


    This makes me want to take a whack at Portal.


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


    Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
    San Diego, California    -- Public Internet access / Mailing
Lists
    
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (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).





**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: How do they get the answer?

[Hallas John]

Title: RE: How do they get the answer?





My thoughts are


Typical OCP question.
a)  Could be the answer depending on if both the subjects are taught by the same 2 teachers
b) Cannot be the answer because only 2 subjects are mentioned (102,105)
c) Could be the answer if the 2 subjects are taught by 4 different teachers (not it cannot be more than 4 therefor the 'at least 4' is misleading

d) If a syntax error did occur you would correct and run again so why you should fail the OCP question for that reason is bizarre anyway.

 
John


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 21 August 01 17:26
To: Multiple recipients of list ORACLE-L
Subject: How do they get the answer?



I am taking the Self-Test software test for the SQL exam 
and don't see how they get the answer to this problem.  
They don't explain how it is arrived at.


Any help you can give me will be appreciated.


Thanks,
Ken Janusz, CPIM


--


Examine the structure of the TEACHER table:


Name                Null?       Type
ID              NOT NULL    NUMBER(9)
SALARY                      NUMBER
(7,2)
SUBJECT_ID          NOT NULL    NUMBER(3)
SUBJECT_DESCRIPTION         VARCHAR2(2)


There are 200 teachers and 15 subjects.  Each subject is 
taught
by at least 2 teachers.


Evaluate this PL/SQL block:


DECLARE
    v_pct_raise     number := 1.10;
BEGIN
    UPDATE      teacher
    SET     salary = salary * 1.10
    WHERE       subject_id IN (102, 105);
    COMMIT;
END;


Which result will the PL/SQL block provide?


(A) Only two teachers will receive a 10% salary increase.
(B) All of the teachers will receive a 10% salary 
increase.
(C) At least four teachers will receive a 10% salary 
increase.
(D) A syntax error will occur.


Answer:
(C) 



-- 
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).




**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: ORA-12542 Problem !!

[Hallas John]

Title: RE: ORA-12542 Problem !!





Saroj
I am trying (but failing) to see how you get that message when using sqlloader?
Can you expand please


John
-Original Message-
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: 23 August 01 12:35
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-12542 Problem !!



isn't that what the Action part of the mail I sent you below tells you to do
?




-Original Message-
Sent: 23 August 2001 11:46
To: Multiple recipients of list ORACLE-L



My question is how to resolve this problem.



-Original Message-
Sent: Thursday, August 23, 2001 PM 07:36
To: Multiple recipients of list ORACLE-L



and here you have it !!!


12542, 0, "TNS:address already in use"
// *Cause: Specified listener address is already being used.
// *Action: Start your listener with a unique address.


Regards


Lee



-Original Message-
Sent: 23 August 2001 10:35
To: Multiple recipients of list ORACLE-L





Hello All,


I am getting ora-12542 error while loading the data using sqlloader.


What could be the problem how can i fix this  problem.



Regards,
Saroj.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dash, Saroj  (CAP,CEF)
  INET: [EMAIL PROTECTED]


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

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



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


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

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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]


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

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




**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: tab ascii value

[Hallas John]

Title: RE: tab ascii value





Srinivas,
I have managed the following PL/SQL but I have not worked out how to show the tab and CR return characters etc. Perhaps someone else can help

John
SCRIPT start xx
declare
V_chr   varchar2(3);
ctr number;
begin
    for ctr in  1..255 loop
    select chr(ctr) into V_chr from dual;
--  dbms_output.put_line(V_chr);
    dbms_output.put_line('Chr value '||ctr||' = '||V_chr||' ');
end loop;
end;
SCRIPT ends 
Chr value 1 = 
Chr value 2 = 
Chr value 3 = 
Chr value 4 = 
Chr value 5 = 
Chr value 6 = 
Chr value 7 = 
Chr value 8 = 
Chr value 9 = 
Chr value 10 = 


Chr value 11 = 


Chr value 12 = 


Chr value 13 = 
Chr value 14 = 
Chr value 15 = 
Chr value 16 = 
Chr value 17 = 
Chr value 18 = 
Chr value 19 = 
Chr value 20 = 
Chr value 21 = 
Chr value 22 = 
Chr value 23 = 
Chr value 24 = 
Chr value 25 = 
Chr value 26 =  
Chr value 27 = 
hr value 28 = 
Chr value 29 = 
Chr value 30 = 
Chr value 31 = 
Chr value 32 =
Chr value 33 = !
Chr value 34 = "
Chr value 35 = #
Chr value 36 = $
Chr value 37 = %
Chr value 38 = &
Chr value 39 = '
Chr value 40 = (
Chr value 41 = )
Chr value 42 = *
Chr value 43 = +
Chr value 44 = ,
Chr value 45 = -
Chr value 46 = .
Chr value 47 = /
Chr value 48 = 0
Chr value 49 = 1
Chr value 50 = 2
Chr value 51 = 3
Chr value 52 = 4
Chr value 53 = 5
Chr value 54 = 6
Chr value 55 = 7
Chr value 56 = 8
Chr value 57 = 9
Chr value 58 = :
Chr value 59 = ;
Chr value 60 = <
Chr value 61 = =
Chr value 62 = >
Chr value 63 = ?
Chr value 64 = @
Chr value 65 = A
Chr value 66 = B
Chr value 67 = C
Chr value 68 = D
Chr value 69 = E
Chr value 70 = F
Chr value 71 = G
Chr value 72 = H
Chr value 73 = I
Chr value 74 = J
Chr value 75 = K
Chr value 76 = L
Chr value 77 = M
Chr value 78 = N
Chr value 79 = O
Chr value 80 = P
Chr value 81 = Q
Chr value 82 = R
Chr value 83 = S
Chr value 84 = T
Chr value 85 = U
Chr value 86 = V
Chr value 87 = W
Chr value 88 = X
Chr value 89 = Y
Chr value 90 = Z
Chr value 91 = [
Chr value 92 = \
Chr value 93 = ]
Chr value 94 = ^
Chr value 95 = _
Chr value 96 = `
Chr value 97 = a
Chr value 98 = b
Chr value 99 = c
Chr value 100 = d
Chr value 101 = e
Chr value 102 = f
Chr value 103 = g
Chr value 104 = h
Chr value 105 = i
Chr value 106 = j
Chr value 107 = k
Chr value 108 = l
Chr value 109 = m
Chr value 110 = n
Chr value 111 = o
Chr value 112 = p
Chr value 113 = q
Chr value 114 = r
Chr value 115 = s
Chr value 116 = t
Chr value 117 = u
Chr value 118 = v
Chr value 119 = w
Chr value 120 = x
Chr value 121 = y
Chr value 122 = z
Chr value 123 = {
Chr value 124 = |
Chr value 125 = }
Chr value 126 = ~
Chr value 127 = 
Chr value 128 = ?
Chr value 129 = ?
Chr value 130 = ?
Chr value 131 = ?
Chr value 132 = ?
Chr value 133 = ?
Chr value 134 = ?
Chr value 135 = ?
Chr value 136 = ?
Chr value 137 = ?
Chr value 138 = ?
Chr value 139 = ?
Chr value 140 = ?
Chr value 141 = ?
Chr value 142 = ?
Chr value 143 = ?
Chr value 144 = ?
Chr value 145 = ?
Chr value 146 = ?
Chr value 147 = ?
Chr value 148 = ?
Chr value 149 = ?
Chr value 150 = ?
Chr value 151 = ?
Chr value 152 = ?
Chr value 153 = ?
Chr value 154 = ?
Chr value 155 = ?
Chr value 156 = ?
Chr value 157 = ?
Chr value 158 = ?
Chr value 159 = ?
Chr value 160 =
Chr value 161 = !
Chr value 162 = ?
Chr value 163 = #
Chr value 164 = ?
Chr value 165 = Y
Chr value 166 = |
Chr value 167 = ?
Chr value 168 = ?
Chr value 169 = ?
Chr value 170 = ?
Chr value 171 = <
Chr value 172 = ?
Chr value 173 = -
Chr value 174 = ?
Chr value 175 = ?
Chr value 176 = ?
Chr value 177 = ?
Chr value 178 = ?
Chr value 179 = ?
Chr value 180 = '
Chr value 181 = ?
Chr value 182 = ?
Chr value 183 = ?
Chr value 184 = ?
Chr value 185 = ?
Chr value 186 = ?
Chr value 187 = >
Chr value 188 = ?
Chr value 189 = ?
Chr value 190 = ?
Chr value 191 = ?
Chr value 192 = A
Chr value 193 = A
Chr value 194 = A
Chr value 195 = ?
Chr value 196 = A
Chr value 197 = ?
Chr value 198 = ?
Chr value 199 = C
Chr value 200 = E
Chr value 201 = E
Chr value 202 = E
Chr value 203 = E
Chr value 204 = I
Chr value 205 = I
Chr value 206 = I
Chr value 207 = I
Chr value 208 = ?
Chr value 209 = ?
Chr value 210 = O
Chr value 211 = O
Chr value 212 = O
Chr value 213 = ?
Chr value 214 = O
Chr value 215 = ?
Chr value 216 = ?
Chr value 217 = U
Chr value 218 = U
Chr value 219 = U
Chr value 220 = U
Chr value 221 = Y
Chr value 222 = ?
Chr value 223 = ?
Chr value 224 = a
declare
V_chr   varchar2(3);
ctr number;
begin
    for ctr in  1..255 loop
    select chr(ctr) into V_chr from dual;
--  dbms_output.put_line(V_chr);
    dbms_output.put_line('Chr value '||ctr||' = '||V_chr||' ');
end loop;
end;
Chr value 225 = a
Chr value 226 = a
Chr value 227 = ?
Chr value 228 = a
Chr value 229 = ?
Chr value 230 = ?
Chr value 231 = c
Chr value 232 = e
Chr value 233 = e
Chr value 234 = e
Chr value 235 = e
Chr value 236 = i
Chr value 237 = i
Chr value 238 = i
Chr value 239 = i
Chr value 240 = ?
Chr value 241 = ?
Chr value 242 = o
Chr value 243 = o
Chr value 244 = o
Chr 

RE: special caracter

[Hallas John]

Title: RE: special caracter





See Metalink Note 137127.1 Character sets, code pages, fonts and the NLS_LANG value
Essentiall all Oracle V8 is Euro compliant but you have to use the NLS_LANG settings more


John 


-Original Message-
From: Djaroud Salim [mailto:[EMAIL PROTECTED]]
Sent: 28 August 01 15:45
To: Multiple recipients of list ORACLE-L
Subject: special caracter



I want to insert a simple caracter in my database 'EUR'.
is there any to do that because i have this caracter ''.


any suggestion will be very appreciate!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]


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

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




**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: Oracle Applications patches

[Hallas John]

Title: RE: Oracle Applications patches





I presume that is 500 per module and there must be about 30 modules by now, with perhaps an average of 7 or 8 modules on each installation

The normal method is to install a full patchset which is a collection of a number of patches (i.e GL Patchset J etc). 
At sites where I have worked adding a patch is usually the last resort and it has to be a significant problem before the patch is applied. A new patchset install normally involves a lot of testing if there has been any form of customisation of the application.

Adpatch will become your best friend :)


John


-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: 28 August 01 16:37
To: Multiple recipients of list ORACLE-L
Subject: Oracle Applications patches



I did a quick search in Metalink for Oracle Applications patches... and
Metalink returned 500 items!


Are there patches that are more critical than others?


I have a copy of Oracle Applications for NT, I just want to learn to install
it, configure, and play with it a little.


(500!  Unbelievable).


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services    | Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO


E-Mail: [EMAIL PROTECTED]  


-- 
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).




**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: OPS on a single machine ?

[Hallas John]

Title: RE: OPS on a single machine ?





That's an interesting concept. Won't there be problems with file sharing. Once the first instance has started will the 2nd one be allowed access to the datafiles?. I don't know much about raw files but I suspect that would be the problem area.

-Original Message-
From: Stefan Jahnke [mailto:[EMAIL PROTECTED]]
Sent: 04 September 01 08:40
To: Multiple recipients of list ORACLE-L
Subject: OPS on a single machine ?



Hi,


I was wondering if it is possible to set up OPS on a single machine.
Maybe like this: 
1 disk as a raw device, then set up an instance to use the raw device
and set up parallel server's second instance to use the raw device, too. 
Before I go through the hassle just to find out that it doesn't work,
did anybody try this before ?


(I'm on SuSE 7.2, Oracle 8.1.7 with OPS option)


-- 
 
| Regards,   |
| Stefan Jahnke  |
| BOV AG |
| @:D2 Vodafone, Abt.: FBOM  |
| Tel.: 0211/533-4893    |
 
-- 
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).




**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: sqlloader-bad file

[Hallas John]

Title: RE: sqlloader-bad file





Try the folling as the calling file load.sh (chmod 555 or similar before running)
sqlldr control=ABS_Load.ctl log=abs.log bad=abs.bad userid=user/pwd rows=2 bindsize=500 direct=true errors=5000


John



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 September 01 10:45
To: Multiple recipients of list ORACLE-L
Subject: sqlloader-bad file



Hallo all you gurus,


How should l I write in the controlfile(.ctl-file) if i want to get a logfile, with all the explanation of the errors.?



Roland


-- 
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).




**
This email and any attachments may be confidential and the subject of 
legal professional privilege.  Any disclosure, use, storage or copying 
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended 
recipient and then delete the email from your inbox and do not 
disclose the contents to another person, use, copy or store the 
information in any medium. 
**

RE: ORAxxxx & trace files.

[Hallas John]

Title: RE: ORA & trace files.





Hi Mark,


I wrote the following bit of code (not good enough to call a script!) to check our alert log for deadlock trace files


awk -f j.awk -v DateStr="Nov" -v SearchStr="info" alert.log > a.lis


numberOfLines=`grep info a.lis |wc -l`
if  [ $numberOfLines -gt 0 ]
then 


cat a.lis|mailx -s "Trace files detected" [EMAIL PROTECTED]


else 
cat a.lis|mailx -s "No problems" [EMAIL PROTECTED] 
fi


output looks something like this



Mon Nov 05 10:04:09 2001 ORA-00060: Deadlock detected. More info in file e:\ora.
Mon Nov 05 11:10:28 2001 ORA-00060: Deadlock detected. More info in file e:\ora.
Mon Nov 05 11:10:38 2001 ORA-00060: Deadlock detected. More info in file e:\ora.
Mon Nov 05 11:46:55 2001 ORA-00060: Deadlock detected. More info in file e:\ora.



Not perfect but almost there. Searching for Nov or Dec etc and the word info and then pulling the next line out


a.awk looks like


$2==DateStr{ oldline=$0
    getline
    if (match($0,SearchStr) >0){
    print oldline,$0
    }
}



 
I am sure there will be better examples provided but at least I wrote this myself and I am learning from it. It still needs something doing with the date. I am trying to translate this into a perl script as well but even less progress on that.

John







-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 15 November 2001 10:00
To: Multiple recipients of list ORACLE-L
Subject: ORA & trace files.



Hi list,


Does anybody have a good list of all the ORA errors that will cause a trace
file to be generated? We have a user of our tools that wants to monitor for
any trace files/dumps being generated. I can think of two ways:


1) monitor the alert log as above for specific errors
2) monitor the directories that these are generated in (bdump/cdump etc.)
for any new files generated in the timeframe..


Anybody already doing this - or have any scripts to save me re-inventing the
wheel?


Cheers


Mark


===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance



-- 
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).




**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: Connecting 8.0 to 8.1

[Hallas John]

Title: RE: Connecting 8.0 to 8.1





I am not sure you are correct Dave. We use 8.0.5 clients on NT PC's to connect to 8.1.7 instances on various flavours of Unix and VMS.

John


-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: 15 November 2001 12:52
To: Multiple recipients of list ORACLE-L
Subject: RE: Connecting 8.0 to 8.1



You might have install the 8.1 client.  I may be wrong but I think with the
8.1 client you can connect to 8.1 and any version lower but with the 8.0
client you cannot connect to a higher version.  If you don't have the 8.1
client CD you can download the client at Oracle's site.


Dave


-Original Message-
Sent: Thursday, November 15, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L




Forgive me if this is a RTFM question - I have not been able to find the
right bit of the FM.


Can someone please tell me how to Net8 connect an 8.0 NT client to an 8.1
Linux server.


Everything was working fine until a second Oracle instance was installed on
the server.  I now get 


ERROR:
ORA-12545: Connect failed because target host or object does not exist



My tnsnames.ora looks like this...


ORANGE.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 123.456.798.101)(PORT = 1521))
    (CONNECT_DATA = (SID = ORANGE))
  )


The server listener.ora looks like this


# LISTENER.ORA Network Configuration File:
/opt/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 1521))
  )
    )
    (DESCRIPTION =
  (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
  )
  (ADDRESS = (PROTOCOL = TCP)(HOST = abc123defghi)(PORT = 2481))
    )
  )


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (PROGRAM = extproc)
    )
    (SID_DESC =
  (GLOBAL_DBNAME = TEST.abc123de)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = TEST)
    )
    (SID_DESC =
  (GLOBAL_DBNAME = ORANGE.acn032hq)
  (ORACLE_HOME = /opt/oracle/product/8.1.7)
  (SID_NAME = ORANGE)
    )
  )


I anonymised the data (obviously)


Many thanks to anyone who understands this stuff.


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Farnsworth, Dave
  INET: [EMAIL PROTECTED]


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

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




**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

VMS equivalent of ls -lrt

[Hallas John]

Title: VMS equivalent of ls -lrt





A user has asked me about identifying most recently created trace files on a VMS system. I have shown him where they are and how to do a DIR/SIN=TODAY command to get todays files.

However he was complaining that there was no equivalent on VMS to ls -lrt to list all files oldest first.


I have looked at PIPE DIR *.TRC |SORT commands but you need a key and it is not to obvious how to do it easily. 


Does anybody know an easy way of doing it. 


I have never needed to do it because I have always find the date parameter to DIR to be sufficient but it would be nice to help a user out for a change !!!

John


Oracle DBA
BTcellnet
* [EMAIL PROTECTED]
( 0113 388 6062    Desk
) 07713 066194  BT Mobile






**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: ora 24314 service handle not initialized

[Hallas John]

Title: RE: ora 24314 service handle not initialized





Well that is one way of migrating a database that I had never considered :).
If you have already created a 8.1.7 instance with empty datafiles etc I think the easiest way is to export the full database from 8.1.6 and import it into the 8.1.7 instance.

Otherwise start it up with Oracle_Home set to 8.1.7 and run the upgrade scripts. Check the documentation out but they will be something like U000816.sql etc. Really you need to follow the documentation and take 1 approach to upgrading rather than a mix & match approach

John


-Original Message-
From: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2001 13:20
To: Multiple recipients of list ORACLE-L
Subject: ora 24314 service handle not initialized



Hello all,
I was working with an 8.1.6 DB and I needed to migrate to 8.1.7. As I
was newbie (And i keep on being that) I copied all the files related
with the DB (control, dbf..). I created a new DB with the same name and
path as the 81.6 one and replaced its files with the one I saved
previously.
Maybe it´s a madness solution...
My problem now is that I get the 'ora 24314 service handle not
initialized' error. I have read something in metalink, note 122183.1,
just the point in which it sais 'If the ORACLE_HOME points to the 8.1.7
software yet the database
  was created with 8.1.6 or 8.1.5, then this error can occur' is my
problem.
I don´t know how could I resolve it. Could somebody orient me? Or if you
think it´s impossible to recover, please, tell me?
A lot of thanks




**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: VMS equivalent of ls -lrt

[Hallas John]

Title: RE: VMS equivalent of ls -lrt





Top Man Rich.


Works well and a satisfied user for the first time in my career!!
Nice bit of coding, especially the line formatting bit


DCL is a nice language to work in I always found. Once you know what lexicals are available it is amazing what you can do with them.


Much appreciated


John


-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2001 18:05
To: Multiple recipients of list ORACLE-L
Subject: RE: VMS equivalent of ls -lrt



Ah...VMS and DCL.  


I couldn't find an easy way to do this without possibly screwing up other
things, so you'll need to do this from a DCL command procedure ("shell
script"), because the date format displayed in the DIRECTORY command depends
on where in the world you are (I think it's the LIB$DT_DATE_FORMAT logical,
but I forget).  So, try this:


1)  Copy the following into a file called "LSLRT.COM" on your VMS box.


$!---  START CUT HERE 
$   ON WARNING THEN GOTO end
$   ON CONTROL_Y THEN GOTO end
$!
$   in_dirspec = F$PARSE(p1,"*.*;*",,,"SYNTAX_ONLY")
$   IF F$EDIT(P1,"UPCASE,COLLAPSE").EQS."-D"
$   THEN
$       sortorder = ",DESC"
$       in_dirspec = F$PARSE("","*.*;*",,,"SYNTAX_ONLY")
$   ENDIF
$!
$   IF F$EDIT(P2,"UPCASE,COLLAPSE").EQS."-D"
$   THEN
$       sortorder = ",DESC"
$   ELSE
$       sortorder = ""
$   ENDIF
$!
$   wso := WRITE SYS$OUTPUT
$   wsf := WRITE schn
$   delete := delete
$   DateStamp = F$CVTIME("",,"YEAR")+F$CVTIME("",,"MONTH")+ -
        F$CVTIME("",,"DAY")
$   TimeStamp = F$CVTIME("",,"HOUR")+F$CVTIME("",,"MINUTE")+ -
        F$CVTIME("",,"SECOND")
$   sortspec = "SYS$SCRATCH:LSLRT_" + DateStamp + TimeStamp + -
        F$GETJPI("","PID") + ".TMP"
$   CREATE 'sortspec'
$   OPEN/READ/WRITE schn 'sortspec'
$!
$   dirspec = F$PARSE(in_dirspec,,,"DEVICE") + -
        F$PARSE(in_dirspec,,,"DIRECTORY")
$!
$DirLoop:
$   ON WARNING THEN GOTO DirLoop
$   nextfile = F$SEARCH("''in_dirspec'")
$   IF nextfile.EQS."" THEN GOTO EndDirLoop
$   filename = F$PARSE(nextfile,,,"NAME") + F$PARSE(nextfile,,,"TYPE") +
-
        F$PARSE(nextfile,,,"VERSION")
$   filesize = F$FILE_ATTRIBUTES(nextfile,"EOF")
$   filedate = F$FILE_ATTRIBUTES(nextfile,"RDT")
$   sortdate = F$CVTIME(filedate)
$   wsf F$FAO("!47  !6UL  !23",filename,filesize,sortdate)
$   goto DirLoop
$EndDirLoop:
$   IF F$TRNLNM("schn").NES."" THEN CLOSE schn
$   SORT/KEY=(POS:57,SIZE:23'sortorder') 'sortspec' 'sortspec'2
$   wso "Directory ",dirspec
$   wso ""
$   FileTot = 0
$   SizeTot = 0
$   OPEN/READ schn 'sortspec'2
$ReadLoop:
$   READ/ERROR=End schn srec
$   FileTot = FileTot + 1
$   SizeTot = SizeTot + F$INTEGER(F$EXTRACT(49,6,srec))
$   wso srec
$   GOTO ReadLoop
$!
$End:
$   SET NOON
$   WSO ""
$   WSO F$FAO("Total of !UL file!1%C!%Es!%F, !UL block!1%C!%Es!%F", -
        FileTot,SizeTot)
$   IF F$TRNLNM("schn").NES."" THEN CLOSE schn
$   IF F$SEARCH("''sortspec'*;*").NES."" THEN -
        DELETE/NOLOG/NOCONFIRM 'sortspec'*;*
$   EXIT
$!---  END CUT HERE 


2)  Create an "alias" in VMS:


    LSLRT :== @my_device:[my_dir]LSLRT


    ...where "my_device:[my_dir]" is the location where you created the
    LSLRT.COM file.  For best results, also put this command in your
    SYS$LOGIN:LOGIN.COM (".profile or .login in Unix"), so the "alias"
    will work the next time you login.


3)  To use:


    LSLRT [-d] [filespec]


    If you specify "-d", the sort order will be descending.


This is a quick'n'dirty DCL procedure, so USE AT YOUR OWN RISK!!!  I tried
to make the best use of DCL (some error trapping and formatting) and also
to make this procedure readable and maintainable, but don't hold me or my
employer accountable for it use or misuse.  (I hate the legal stuff!)


CAVEATS:


You may get some "file access conflict" errors if it looks at open files.
Sorry, I didn't have time to code around this.  Also, if you get stars for
the filesize, you can increase the "6" in the "!6UL" for the filesize, 
and decrease the "47" for the filesize in the same line.  And, the date
displayed is the revision date.  If you would like other dates displayed,
type "HELP LEX F$FILE ARG" and select the appropriate replacement argument
for the "filedate" symbol's call to F$FILE_ATTRIBUTE.  And, finally, this
code won't handle stepping through some VMS structures like nested logicals
and the like.


That being said, I hope this helps!  If I had time, I'd code one for ya in
BASIC or C...


Enjoy!   :)


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

RE: SQL query tuning problem

[Hallas John]

Title: Blank



I have the first edition which is an 
excellent book but I cannot justify buying the later version - pity 
really

  -Original 
  Message-From: SARKAR, Samir 
  [mailto:[EMAIL PROTECTED]]Sent: 16 November 2001 
  15:50To: Multiple recipients of list ORACLE-LSubject: 
  RE: SQL query tuning problem
  Well Greg..I just ordered 
  the SQL Tuning book by Guy Harrison from Amazon
  hope it is real good as u 
  recommend :) 
  Thanks and Cheers 
  !!
   
  Samir Sarkar 
  Oracle DBA - Lennon 
  Team SchlumbergerSema Email :  
  [EMAIL PROTECTED]     
  [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 
  EPABX : +44 (0) 115 - 957 
  6418 Ext. 76217 Fax : +44 (0) 115 - 957 
  6018    
  
  
-Original Message-From: Greg Moore 
[mailto:[EMAIL PROTECTED]]Sent: 08 November 2001 
18:28To: SARKAR, SamirSubject: Re: SQL query tuning 
problem
>> syntax for having multiple tables in the hint
 
/*+ full( a b ) */
 
Look in the Oracle documentation, in the Tuning Guide.  There is a 
complete chapter on Hints.  
 
If you are interested in tuning, get Guy Harrison's book.  It's 
available on Amazon.  It's one of the best Oracle books ever 
written.

  - Original Message - 
  From: 
  SARKAR, Samir 
  To: 'Greg 
  Moore' 
  Cc: '[EMAIL PROTECTED]' 
  Sent: Thursday, November 08, 2001 
  2:04 AM
  Subject: RE: SQL query tuning 
  problem
  
  Greg,
   
  Thanks a bunch for ur 
  detailed reply. I am trying out all the options enumerated by you and 
  
  I will hopefully get some 
  results.
  I was doing a mistake 
  with the hint to disable indexes.I was using the table name instead of 
  the 
  alias in the hint. 
  
  Could u please tell me 
  the syntax for having multiple tables in the hint ?? Tahat is, if I want 
  
  the query to run by 
  disabling the indexes in all the joined tables, what would the syntax be 
  ??
   
  Thanks 
  again,
  Samir Sarkar 
  Oracle DBA - Lennon 
  Team SchlumbergerSema 
  Email :  
  [EMAIL PROTECTED]     
  [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 
  EPABX : +44 (0) 115 - 
  957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 
  6018    
  
  
-Original Message-From: Greg Moore 
[mailto:[EMAIL PROTECTED]]Sent: 07 November 2001 
20:09To: SARKAR, SamirSubject: Re: SQL query 
tuning problem
Samir,
 
To disable an index, use the hint FULL in the SQL.  
 
select /*+ full(e) */ ename, phone, address
from emp e
where ename = 'Smith'
 
This will cause a full table scan on the emp table (instead of 
using an index).  Note you must give the table an alias in the FROM 
clause, and you must use that alias in the hint.  Also, the hint 
must have no errors.  If it contains errors you won't get an error 
message.  So after putting in a hint, be sure to run an explain 
plan to see if your hint worked.  For the FULL hint, obviously, 
your explain plan should show a full table scan and should not show use 
of an index.
 
The explain plan you sent is very interesting.  The words 
"MERGE JOIN (CARTESIAN)" are very interesting.  Normally a 
Cartesian join is a mistake, because the programmer forgot to include a 
join between two tables in the WHERE clause.  In your case, 
however, the tables appear to be all properly joined.
 
Oracle enhanced the optimizer for data warehouses, where there is 
usually one big table an many smaller ones.  The smaller tables 
can't be joined to each other, only to the large table.  However, 
the most efficient solution is for Oracle to first join all the small 
tables, and since they can't be linked with primary and foreign keys, 
Oracle just does a Cartesian join.  This produces lots of results, 
but not too many because the tables are all small.  Then, for the 
last step, Oracle finally joins the results from these small tables to 
the big table.
 
The idea is to put off dealing with the big table until the end, 
and then only deal with it once.  This is faster than joining each 
small table to the big table, one at a time.
 
Although this was meant for data warehouses, sometimes Oracle will 
create a plan like this simply because it sees that one table is very 
big and the others are small.  I think that is what is happening 
with your SQL and explain plan.
 
I am sorry to report that even with the proper indentation, I 
cannot fully understand your explain plan.  It is simply diff

RE: renaming Constraints

[Hallas John]

Title: renaming Constraints



Presumably if it is development then the developers 
should be preparing proper scripts to create the objects once the names and 
definitions are finalised.
Just 
ask them for the latest set of scripts and then write some dynamic sql to drop 
the constraints and then run the scripts to recreate the 
objects.
 
I 
would not start updating the data dictionary directly if I were you. Totally 
unsupported, undesirable and unnecessary in this (and most ) 
cases.
 
John

  -Original Message-From: Arslan Dar 
  [mailto:[EMAIL PROTECTED]]Sent: 19 November 2001 
  11:11To: Multiple recipients of list ORACLE-LSubject: 
  renaming Constraints
  Hi list, is there any easiar way to rename a constraint other 
  then dropping and then recreating it, cuz in our environment, developers mess up the constraints with naming 
  them using system assigned names and then after finilizing the tables and 
  relations, i have to drop/recreate all the constraints following the naming 
  convetion for them.
  is there any easiar way, like updating the 
  data dictionary directly, any harm in that, if not, which are the key tables i 
  am supposed to play with? 
  Thanks in Advance 
  Arslan 

**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: set_sql_trace_in_session

[Hallas John]

Title: RE: set_sql_trace_in_session





It is in the 8.1.6 documentation I have just looked at
(Oracle8i Supplied PL/SQL Packages Reference
Release 2 (8.1.6) A76936-01


However I have a page on my website which shows how to put various bits of tracing on
try http://www.hcresources.co.uk for the home page or http://www.hcresources.f2s.com/trace.htm
to go direct.


John


-Original Message-
From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]
Sent: 19 November 2001 15:05
To: Multiple recipients of list ORACLE-L
Subject: set_sql_trace_in_session



DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION isn't documented in the 8.1.6/7
doc sets.  The package (and the procedure) exists, though even the
package spec source code is wrapped.  What gives?  Is this package
about to be desupported?  Is there an alternative way of setting trace
on in another session?


__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]


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

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




**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: set_sql_trace_in_session

[Hallas John]

Note 
134940.1 on Metalink indicates that it is still available. It is created by the 
dbmsutil.sql script.
 
Found 
the following, never heard of it before but it seems to do the same thing as 
dbms_system.set_sql_trace_in_session

DBMS_ORACLE_TRACE_AGENT, 2 of 
2 



Summary of 
Subprograms
This package contains only one subprogram: 
SET_ORACLE_TRACE_IN_SESSION. 
SET_ORACLE_TRACE_IN_SESSION 
Procedure
This procedure collects Oracle Trace data for a database session 
other than your own. It enables Oracle TRACE in the session identified by 
(sid, serial#). These value are taken from 
v$session. 
SyntaxDBMS_ORACLE_TRACE_AGENT.SET_ORACLE_TRACE_IN_SESSION ( 
   sidNUMBER   DEFAULT 0,
   serial#NUMBER   DEFAULT 0,
   on_off IN  BOOLEAN  DEFAULT false,
   collection_name IN VARCHAR2 DEFAULT '',
   facility_name   IN VARCHAR2 DEFAULT '');

Parameters
Table 
27-1 SET_ORACLE_TRACE_IN_SESSION Procedure 
Parameters 

  
  
Parameter 
Description 
  
  
sid
 

  Session ID. 
  
serial#
 

  Session serial number. 
  
on_off
 

  TRUE or FALSE. Turns tracing on or 
  off. 
  
collection_name
 

  The Oracle TRACE collection name to be used. 
  
facility_name
 

  The Oracle TRACE facility name to be 
  used. -Original Message-From: Paul 
Baumgartel [mailto:[EMAIL PROTECTED]]Sent: 19 November 2001 
16:25To: Multiple recipients of list ORACLE-LSubject: RE: 
set_sql_trace_in_session
Thanks. I'm looking at the online version of that manual, 
  same part number, and DBMS_SYSTEM doesn't even appear on the list of packages: 
  
  52 
  DBMS_STATS
  

  Using 
  DBMS_STATS 
  Types 
  
  
Summary of Subprograms 

  Setting 
  or Getting Statistics 
  PREPARE_COLUMN_VALUES 
  Procedure 
  SET_COLUMN_STATS 
  Procedure 
  SET_INDEX_STATS 
  Procedure 
  SET_TABLE_STATS 
  Procedure 
  CONVERT_RAW_VALUE 
  Procedure 
  GET_COLUMN_STATS 
  Procedure 
  GET_INDEX_STATS 
  Procedure 
  GET_TABLE_STATS 
  Procedure 
  DELETE_COLUMN_STATS 
  Procedure 
  DELETE_INDEX_STATS 
  Procedure 
  DELETE_TABLE_STATS 
  Procedure 
  DELETE_SCHEMA_STATS 
  Procedure 
  DELETE_DATABASE_STATS 
  Procedure 
  Transferring 
  Statistics 
  CREATE_STAT_TABLE 
  Procedure 
  DROP_STAT_TABLE 
  Procedure 
  EXPORT_COLUMN_STATS 
  Procedure 
  EXPORT_INDEX_STATS 
  Procedure 
  EXPORT_TABLE_STATS 
  Procedure 
  EXPORT_SCHEMA_STATS 
  Procedure 
  EXPORT_DATABASE_STATS 
  Procedure 
  IMPORT_COLUMN_STATS 
  Procedure 
  IMPORT_INDEX_STATS 
  Procedure 
  IMPORT_TABLE_STATS 
  Procedure 
  IMPORT_SCHEMA_STATS 
  Procedure 
  IMPORT_DATABASE_STATS 
  Procedure 
  Gathering 
  Optimizer Statistics 
  GATHER_INDEX_STATS 
  Procedure 
  GATHER_TABLE_STATS 
  Procedure 
  GATHER_SCHEMA_STATS 
  Procedure 
  GATHER_DATABASE_STATS 
  Procedure 
  GENERATE_STATS 
  Procedure 
  Example 
  
  53 
  DBMS_TRACE
  Do you find it in the printed manual?
  --- Hallas John <[EMAIL PROTECTED]> wrote: > It is 
  in the 8.1.6 documentation I have just looked at > (Oracle8i Supplied 
  PL/SQL Packages Reference > Release 2 (8.1.6) A76936-01 > 
  > However I have a page on my website which shows how to put various 
  > bits of > tracing on > try http://www.hcresources.co.uk 
  for the home page or > http://www.hcresources.f2s.com/trace.htm 
  > to go direct. > > John > > -Original 
  Message- > Sent: 19 November 2001 15:05 > To: Multiple 
  recipients of list ORACLE-L > > > 
  DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION isn't documented in the 8.1.6/7 > 
  doc sets. The package (and the procedure) exists, though even the > 
  package spec source code is wrapped. What gives? Is this package > 
  about to be desupported? Is there an alternative way of setting > trace 
  > on in another se! ! ssion? > > 
  __ > Do You Yahoo!? 
  > Find the one for you at Yahoo! Personals > 
  http://personals.yahoo.com > -- > Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul 
  Baumgartel > INET: [EMAIL PROTECTED] > > Fat City 
  Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, 
  California -- Public Internet access / Mailing > Lists > 
   > 
  To REMOVE yourself from this mailing list, send an E-Mail message > to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the 
  message BODY, include 

RE: Long Column

[Hallas John]

Title: RE: Long Column





Alter table move is not allowed with long data types. We are migrating our LONG RAW to become BLOBs .
The method will be to recreate and populate table using CTAS converting BLOB column from the LONG using TO_LOB() function.

John


-Original Message-
From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Sent: 19 November 2001 16:35
To: Multiple recipients of list ORACLE-L
Subject: Long Column



Hi List,
I have a question regarding moving a table with Long Column from one
tablespace to another tablespace, any idea appreciate.
I have tried this but doesn't work:  ALTER TABLE TAB1 MOVE TABLESPACE NEW;
Thanks in advance





Hamid Alavi
Office 818 737-0526
Cell    818 402-1987


The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]


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

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




**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: SQL query tuning problem

[Hallas John]

Title: Blank



Henry,
 
I remember reading some reviews of it when 
it came out and thinking I would like it. I presume it includes function based 
indexes (indices?), more on partitioning etc.
I also recall the book being about £40 UK 
whereas other comparable sized books such as Jonathan Lewis's one are normally 
around £33 UK. 
Looking at Amazon now both books are still 
available.
In the review section somebody has commented 
about the tools provided on CD as being pretty non-robust. That reminds me that 
I never managed to get any of them working which was a bit of a shame. Thinggs 
have moved on since then and I have found alternative tools or scripts to do the 
same job.
 
 
 
John

  -Original 
  Message-From: Henry Poras 
  [mailto:[EMAIL PROTECTED]]Sent: 19 November 2001 
  14:25To: Multiple recipients of list ORACLE-LSubject: 
  FW: SQL query tuning problem
  John,
  What has changed? I think we have both 
  versions floating around here somewhere (unless one of the books left with 
  some of our people). I'll try to take a stroll through the Table of 
  Contents.
   
  Henry
  
-Original Message-From: Hallas John 
[mailto:[EMAIL PROTECTED]]Sent: Monday, November 19, 2001 
5:45 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: SQL query tuning 
problem
I have the first edition which is an 
excellent book but I cannot justify buying the later version - pity 
really

  -Original 
  Message-From: SARKAR, Samir 
  [mailto:[EMAIL PROTECTED]]Sent: 16 November 
  2001 15:50To: Multiple recipients of list 
  ORACLE-LSubject: RE: SQL query tuning 
  problem
  Well Greg..I just 
  ordered the SQL Tuning book by Guy Harrison from 
  Amazon
  hope it is real good as u 
  recommend :) 
  Thanks and Cheers 
  !!
   
  Samir Sarkar 
  Oracle DBA - Lennon 
  Team SchlumbergerSema 
  Email :  
  [EMAIL PROTECTED]     
  [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 
  EPABX : +44 (0) 115 - 
  957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 
  6018    
  
  
-Original Message-From: Greg Moore 
[mailto:[EMAIL PROTECTED]]Sent: 08 November 2001 
18:28To: SARKAR, SamirSubject: Re: SQL query 
tuning problem
>> syntax for having multiple tables in the hint
 
/*+ full( a b ) */
 
Look in the Oracle documentation, in the Tuning Guide.  There 
is a complete chapter on Hints.  
 
If you are interested in tuning, get Guy Harrison's book.  
It's available on Amazon.  It's one of the best Oracle books ever 
written.

  - Original Message - 
  From: 
  SARKAR, Samir 
  To: 'Greg 
  Moore' 
  Cc: '[EMAIL PROTECTED]' 
  Sent: Thursday, November 08, 2001 
  2:04 AM
  Subject: RE: SQL query tuning 
  problem
  
  Greg,
   
  Thanks a bunch for ur 
  detailed reply. I am trying out all the options enumerated by you and 
  
  I will hopefully get 
  some results.
  I was doing a mistake 
  with the hint to disable indexes.I was using the table name 
  instead of the 
  alias in the hint. 
  
  Could u please tell 
  me the syntax for having multiple tables in the hint ?? Tahat is, if I 
  want 
  the query to run by 
  disabling the indexes in all the joined tables, what would the syntax 
  be ??
   
  Thanks 
  again,
  Samir Sarkar 
  Oracle DBA - Lennon 
  Team SchlumbergerSema 
  Email :  
  [EMAIL PROTECTED]     
  [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 
  EPABX : +44 (0) 115 
  - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 
  6018    
  
  
-Original Message-From: Greg Moore 
[mailto:[EMAIL PROTECTED]]Sent: 07 November 2001 
20:09To: SARKAR, SamirSubject: Re: SQL query 
tuning problem
Samir,
 
To disable an index, use the hint FULL in the SQL.  
 
select /*+ full(e) */ ename, phone, address
from emp e
where ename = 'Smith'
 
This will cause a full table scan on the emp table (instead of 
using an index).  Note you must give the table an alias in the 
FROM clause, and you must use that alias in the hint.  Also, 
the hint must have no errors.  If it contains errors you won't 
get an error message.  So after putting in a hint, be sure to 
run an explai

RE: Find DBA users

[Hallas John]

Title: Find DBA users




Try
select grantee from dba_role_privs where granted_role = 
'DBA'
John
 

  -Original Message-From: Daiminger, Helmut 
  [mailto:[EMAIL PROTECTED]]Sent: 26 November 2001 
  12:10To: Multiple recipients of list ORACLE-LSubject: 
  Find DBA users
  Hi! 
  Is there a data dictionary view that gives me all 
  users who have geen granted the DBA role? 
  This is 8.1.7 on Sun Solaris. 
  Thanks, Helmut 

**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: Listener problems

[Hallas John]

Title: RE: Listener problems





The following script is one I pulled off from the list a few months ago and added a few lines. It is proving pretty useful. Note it uses the set option to redirect to a new output file

John


#!/bin/ksh
# Script to copy out listener.log and compress it.
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/8.1.6
export ORACLE_HOME


PATH=$ORACLE_HOME/bin:/usr/local/bin:/bin:/usr/bin


export PATH


COMPRESSED_FILE=/u01/app/oracle/product/8.1.6/network/log/listener`date
+%Y%m%d%H%M`.log


lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener2.log
mv /u01/app/oracle/product/8.1.6/network/log/listener.log $COMPRESSED_FILE
mv /u01/app/oracle/product/8.1.6/network/log/listener2.log
/u01/app/oracle/product/8.1.6/network/log/listener.log
lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener.log
compress $COMPRESSED_FILE
#
# now remove all compressed listener logs older than 10 days
#
find /u01/app/oracle/product/8.1.6/network/log/list*.Z -mtime +10 -print
-exec rm {} \;



A suitable crontab entry for the oracle account would be


00 19 * * * /home/oracle/tidy_listener_log.sh  >
/home/oracle/tidy_listener_log.log 2>&1





-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: 26 November 2001 09:30
To: Multiple recipients of list ORACLE-L
Subject: Re: Listener problems



once clients are connected, you can shut down the listener... all that
means is that no one else can connect once it is down.


size of listener.log is OS dependent, it's just  a file on disk. You
can recreate it by 


shutting down the listener
renaming or deleting the listener.log file
starting up the listener



--- "Tatireddy, Shrinivas (MED, Keane)"
<[EMAIL PROTECTED]> wrote:
> Hi lists,
> 
> I have some problem with my listener.  That is resolved with the help
> of
> metalink. But I have a doubt in this regard.
> 
> When I try to see the status, lsnrctl status 816LISTENER
> 
> the statement hung for 10 minutes. I checked metalink and found the
> solution was,
> probably the size of listener.log is very big. So archive/remove it.
> 
> In the mean time , this was resolved by another group of DBAs.
> 
> In such a situations how to create another listener.log.
> 
> If I stop/start the listener, this will affect the clients who are
> running trnx.
> 
> how do i create another log.
> 
> And how to know the size of listener.log (There is no parameter for
> this)
> is is o/s dependent?
> 
> Thnx and regards,
> Srinivas
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tatireddy, Shrinivas (MED, Keane)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).



__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]


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

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




**
This email and any attachments may be confidential and the subject of
legal professional privilege.  Any disclosure, use, storage or copying
of this email without the consent of the sender is strictly prohibited.
Please notify the sender immediately if you are not the intended
recipient and then delete the email from your inbox and do not
disclose the contents to another person, use, copy or store the
information in any medium.
**

RE: Delete slowing..

[Hallas John]

Title: RE: Delete slowing..





Mark, something else to add to your list of things to check
Does a FTS of the table take a long time as well? 
If so I would try re-creating the table to remove the space left by previously deleted rows.


John


-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2001 19:55
To: Multiple recipients of list ORACLE-L
Subject: Re: Delete slowing..



Mark Leith wrote:
> 
> Hi list people :)
> 
> We have a customer who has been running a particular delete statement
> against a table for a while now, which usually ran within minutes. All of a
> sudden this table has suddenly gone from a few minutes right up to 50! He
> wants to diagnose why..
> 
> Where would you start?
> 
> I have a few ideas of my own - like stale stats, small rollback segments
> etc. - but am after some of your advice also before I get back to him
> tomorrow morning.. Not sure on the Oracle version, OS, or even amount of
> rows he is deleting or size of the table (yet, I'll find this out tomorrow),
> but there has to be a pretty standard way of diagnosing this..
> 
> All help appreciated.
> 
> Mark
> 
> ===
>  Mark Leith | T: +44 (0)1905 330 281
>  Sales & Marketing  | F: +44 (0)870 127 5283
>  Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
> ===


'We have done nothing and suddenly it's slow' is a well known tune.
Usual suspects :
    1) Stats, computed or deleted
    2) Dropped index
    3) Newly created trigger
    4) Locks. Nobody doing DML on the same table during the delete ?
-- 
Regards,


Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]


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

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




>>
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
>>

RE: Alternatives to Pathworks?

[Hallas John]

Title: RE: Alternatives to Pathworks?





Marc,
What transport protocol are you using at the moment if not TCP, Decnet I presume
The 2 things that spring to mind are 


1) Look at using Samba. That certainly works on VMS and allows file movement between VMS,Unix and NT. I have seen it grab a lot of CPU on VMS systems and I think it requires restarting frequently but that can all be scripted

2) What limits are reached on the VMS server. I cannot imagine UCX or whatever they call it now (services for TCP possibly) radically changing resource usage. Get a 30 day trial from Compaq and see what it affects

John



-Original Message-
From: Blum, Marc [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 07:01
To: Multiple recipients of list ORACLE-L
Subject: Alternatives to Pathworks?



Dear list,


we have a 8.1.7 running on NT4. A NT-service copies flatfiles from a VAX/VMS
and starts a batch, which imports the data into the DB. VMS is reached via
Pathworks. Now, when Pathworks is installed an the machine running the
instance, the instance seems to become instable and dies under some
circumstances. Is there any alternative to pathworks? Our customer don't
want to install TCP on VMS, because the machine is at it's limit. 


Thanks in advance 


Mit freundlichen Grüßen


i.A. Marc Blum


SOPTIM AG
Grüner Weg 22-24
D-52070 Aachen


Telefon:    +49 241 / 9 18 79-33
Fax:    +49 241 / 15 40 38


mailto:[EMAIL PROTECTED]
http://www.soptim.de



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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
>>

RE: Script to Disable Constraint, Change Value, then Enable Const

[Hallas John]

Well 
said Mark.
David, 
you could also re-able the constraint 'novalidate' if you wanted to ignore the 
validity of any new input. 
If 
that was the case then why have an integrity constraint in the first 
place?
 
John

  -Original Message-From: Mark Leith 
  [mailto:[EMAIL PROTECTED]]Sent: 28 November 2001 
  10:20To: Multiple recipients of list ORACLE-LSubject: 
  RE: Script to Disable Constraint, Change Value, then Enable 
  Constrain
  How 
  could this be user proof? You are essentially disabling the constraint that 
  WILL enforce data integrity, then letting the user input whatever rubbish he 
  wants to, and are then going to try and enable the constraint 
  afterwards?
   
  Not 
  a good approach.. How can you ensure that the user hasn't put a duplicate
  value in (unique constraint) or something else that might break the constraint 
  rule? The only way you are going to know is when you try and re-enable the 
  constraint it will fail.. 
   
  I 
  struggle to see why you would want to do this - do you have any 
  more info?
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent: 
27 November 2001 21:30To: Multiple recipients of list 
ORACLE-LSubject: Script to Disable Constraint, Change Value, then 
Enable Constrain

Listers,
 
Does 
anyone have a script that will do the 
following:
 

  Accept 
  user input for old data value 
  Accept 
  user input for new data value 
  Disable 
  table constraint 
  Update 
  record with new data value 
  Enable 
  constraint 
 
A 
script like this would help ensure that constraints are not left “off” after 
updates, allowing “illegal” data into the tables.  Good user-proof script I would 
think.
 
 
TIA,
 
david
 
David 
B. Wagoner
Database 
Administrator
Arsenal 
Digital Solutions Worldwide Inc.
4815 
Emperor Blvd., Suite 110
Durham, 
NC 27703
Tel. 
(919) 941-4645
Fax 
(919) 474-0735
Email 
mailto:[EMAIL PROTECTED]
Web 
http://www.arsenaldigital.com/
 
  
***  NOTICE  ***
This 
e-mail message is confidential, intended only for the named recipient(s) 
above and may contain information that is privileged, work product or exempt 
from disclosure under applicable law.  
If you have received this message in error, or are not the named
recipient(s), please immediately notify the sender at (919) 941-4645 and 
delete this e-mail message from your computer.  Thank you.
 

>>
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
>>

RE: Crontabs and Oracle

[Hallas John]

Title: RE: Crontabs and Oracle





I don't know if it is relevant but on Compaq Tru64 we have to su - oracle even within the oracle cron 
so a sample entry looks looks as follows. 


10 19 * * * su - oracle -c '/usr/local/bin/tidy_listener_log.sh'  > etc etc


Your message_is mentions Sun in which case I am sure this does not need to be done (nor HP). Hope it is useful, probably not


John 


-Original Message-
From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 11:00
To: Multiple recipients of list ORACLE-L
Subject: Crontabs and Oracle



Guys,


I have a Unix shell script that runs and does some things with sqlplus. The
script runs fine when I start it up manually just using the command


$ host_startup.sh


However, If I try to start this host_startup.sh from the Crontab I get this
error logged in my mail.


From apt2 Wed Nov 28 08:15:01 2001
Date: Wed, 28 Nov 2001 08:15:01 GMT
Message-Id: <[EMAIL PROTECTED]>
To: apt2
Content-Length: 143


Your "cron" job on phys-ki-sun4k2
/ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh 


produced the following output:


sqlplus: Command not found



Any ideas? I've specifically said in the shell script where to find the
sqlplus binaries, so I'm not sure?! Any help would be much appreciated.


Cheers,
Kev.


"I put instant coffee in a microwave oven and almost went back in time. "
__


Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com





-Original Message-
Sent: 21 November 2001 12:20
To: Multiple recipients of list ORACLE-L




Have a look at Categoric Xalerts.


It is a general purpose Alerting system, not just for DBA and SYSADMs.


Their new Java based system is just out.


www.categoric.com


Steve Parker
Technical Consultant
LIS


 --
Logistics & Internet Systems Ltd.
E Mail: [EMAIL PROTECTED]
 --




 


    Kumanan Balasundaram


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


    Sent by:   Subject: Reliable
alerting system that is not so costly?? 
    [EMAIL PROTECTED]


 


 


    21/11/2001 11:50


    Please respond to


    ORACLE-L


 


 






Hi  there,


Any of you using or have come across a reliable alert system that can also
escalate
to different persons based on criteria such as how important that system
is?


We are looking to invest in such a software.


Kumanan Balasundaram
Database Administrator, IT
QXL ricardo plc
www.qxl.com
P: +44 (0)208 962 7409


> QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge
Road,
> London W6 9EJ
> Registered in England No 3430894 VAT number - GB 701 8915 43
>
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material.  Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited.   If you
> received  this in error, please contact the sender and delete the
material
> from any computer
>



**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]


This footnote also confirms that this email message has been swept by
MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer
viruses.


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:

RE: OCP tests

[Hallas John]

Title: RE: OCP tests





Hi Samir,
I think the Exam Cram books from Coriolus are OK. They do not cover everything, they are slightly inaccurate sometimes but they compress and summarise what you need and they are relatively cheap (£21 UKP) compared with others.

I have an article on my web site http://www.hcresources.co.uk which covers my foray into the OCP world. You may find it interesting (there again you may not... ). There are lots of resources on the web which are useful.The brainbuzz site has some good stuff as well in the cramsession pages http://.brainbuzz.com 


John


-Original Message-
From: SARKAR, Samir [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 15:31
To: Multiple recipients of list ORACLE-L
Subject: OCP tests



Tom,


Am thinking of taking the OCP tests early next year..could u please
suggest
me a really good and comprehensive guide book for the same ?? There r quite
a 
few of them available on Amazon but I am confused now as to which of these 
is really good. 


Thanks and Regards,


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




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


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

___


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


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

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




>>
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
>>

RE: Connection question?

[Hallas John]

Title: RE: Connection question?





Harry,
I am not sure that BEQ connections use the standard listener at all. In fact on VMS systems you cannot make an internal connection if the bequeath listener is not started (BEQLSNR START|STOP|STATUS). Once you start that listener then you can connect internal even if the normal listener LSNRCTL START|STOP|STATUS) is not running.

I think you are probably correct in what you say but the term listener is used slightly inaccurately.


John 


-Original Message-
From: Lowes, Harry (NESL-IT)
[mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 15:31
To: Multiple recipients of list ORACLE-L
Subject: RE: Connection question?



Afternoon Lisa,
 
I thought that BEQ and (for example) IPC protocols both used the listener to
spawn a server-side process. The difference is in the protocol used in the
communication between the remote and local processes. IPC uses Unix Domain
Sockets to communicate between the client-side and server-side processes,
where BEQ uses Unix pipes. I had assumed that this was why BEQ connections
had to be local. This is the view expounded in Note: 1014940.6. If I've got
it wrong, it'd be nice to know. Any comments, Gurus?
 




Thanks, 


Harry Lowes 
Database Administrator, 
npower Northern Limited 
mailto:[EMAIL PROTECTED]
  


 


-Original Message-
Sent: 28 November 2001 14:00
To: Multiple recipients of list ORACLE-L




Hi Deepak 


Here's what the doco says 


The Bequeath protocol  enables clients that exist on the same
machine as the server to retrieve information from the database without
using the listener. The Bequeath protocol internally spawns a dedicated
server process for each client applications. In a sense, it does the same
operation that a remote network listener does for your connection, yet
locally. 


Bequeath is used for local connections where an Oracle client application,
such as SQL*Plus, communicates with an Oracle server running on the same
machine 


Tell me if I'm wrong but here's my take on it:  When I connect from my pc,
there's a process on my PC and there's a corresponding process on the
database, say on a Unix server.  Though the connection was initiated
remotely, the process itself on the db server is still a local process that
exists to communicate with the database.  


Am I wrong?  If so let me know. 


    -Original Message- 
Sent:   Tuesday, November 27, 2001 5:25 PM 
To: Multiple recipients of list ORACLE-L 


    hey lisa 


    Thats what i was temted to reply as well {lol} .. but 
if you look closely .. both her conn are bequeth .. i 
was under the impression that bequeth was used only 
for local and not remote .. thats why we chose beq 
over tcp for db's that resided in same box for 
performance reasons .. or so i thought until now ;) 


    thoughts ..? 


    Thx 
Deepak 
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: 
> One is LOCAL=YES and one is LOCAL=NO 
> 
> One is Local, one isn't. 
> 
> Lisa Koivu 
> Oracle Database Monkey 
> Fairfield Resorts, Inc. 
> 954-935-4117 
> 
> 
> > -Original Message- 
> > From:   Seema Singh [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Tuesday, November 27, 2001 1:05 PM 
> > To: Multiple recipients of list ORACLE-L 
> > Subject:    Connection question? 
> > 
> > Hi 
> > WHen I execute ps -ef |grep LOCAL on Solaris 
> server the following output i 
> > 
> > see in 
> > 
> 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) 
> > 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) 
> > What is the diffrence between 1 and 2. 
> > 
> > Thanks 
> > Seema 
> > 
> > 
> 
_ 
> > Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp   
> > 
> > -- 
> > 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). 
> 



    __ 
Do You Yahoo!? 
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. 
http://geocities.yahoo.com/ps/info1   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Deepak Thapliyal 
  INET: [EMAIL PROTECTED] 


    Fat City Netw

RE: Export/Import Job

[Hallas John]

Exporting an individual schema within APPS (GL /PA etc) 
is not recommended due to the number of constraints that cross schemas (to fnd 
tables for instance).
So 
changing the block size is essentially non Apps specific and is just a straight 
export /import.
Depending on your hardware and plan I would have 
expected you to be able to start on a Saturday and complete on Sunday 
(sometime).
Run as 
much archiving/purging as you can (certainly tables like fnd_requests should be 
tidied down as much as possible).
Have a 
few dummy runs so that the the scripts are all fully tested and you have a good 
checklist of all the scripts and expected timings.
Most 
importantly of all ensure that you can revert back from your backup safely and 
as quickly as possible.
Hopefully you will have the space to pre-create the 
instance (dummy sid) and then rename it once you have completed the export of 
live (Come to think of it, if you have that space you can retain both instances 
and that certainly helps if you decide to abandon the build or revert for any 
reason)
 
 
PS 
Unless the database really needs re-building what other benefits do you expect 
from changing the block size?
 
HTH
 
John
 
 

  -Original Message-From: Nick Wagner 
  [mailto:[EMAIL PROTECTED]]Sent: 30 November 2001 
  21:05To: Multiple recipients of list ORACLE-LSubject: 
  Export/Import Job
  If anyone out 
  there has a good time estimate for the following export/import job I would 
  appreciate it.  The goal is to change the DB_BLOCK_SIZE.  
  
   
  Application: 
  Oracle Apps 11i
  Database Size: 
  100GB, actually only about 80GB is used space.
  2 CPU HP L-Class 
  machine.  
   
  I just need a 
  couple of good estimates of how many days/hours this will take.   
  I'm guessing around 3 days...  but I have never done anything this large 
  before. 
   
  Thanks!! 
  
   
  Nick

>>
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
>>

RE: Export/Import Job

[Hallas John]

Re-reading my e-mail I had better jump in and correct 
the first line to read exporting/importing rather than exporting!!. Obviosuly 
exporting a schema is fully supported
 
John

  -Original Message-From: Hallas John 
  [mailto:[EMAIL PROTECTED]]Sent: 03 December 2001 
  12:10To: Multiple recipients of list ORACLE-LSubject: 
  RE: Export/Import Job
  Exporting an individual schema within APPS (GL /PA 
  etc) is not recommended due to the number of constraints that cross schemas 
  (to fnd tables for instance).
  So 
  changing the block size is essentially non Apps specific and is just a 
  straight export /import.
  Depending on your hardware and plan I would have 
  expected you to be able to start on a Saturday and complete on Sunday 
  (sometime).
  Run 
  as much archiving/purging as you can (certainly tables like fnd_requests 
  should be tidied down as much as possible).
  Have 
  a few dummy runs so that the the scripts are all fully tested and you have a 
  good checklist of all the scripts and expected timings.
  Most 
  importantly of all ensure that you can revert back from your backup safely and 
  as quickly as possible.
  Hopefully you will have the space to pre-create the 
  instance (dummy sid) and then rename it once you have completed the export of 
  live (Come to think of it, if you have that space you can retain both 
  instances and that certainly helps if you decide to abandon the build or 
  revert for any reason)
   
   
  PS 
  Unless the database really needs re-building what other benefits do you expect 
  from changing the block size?
   
  HTH
   
  John
   
   
  
-Original Message-From: Nick Wagner 
[mailto:[EMAIL PROTECTED]]Sent: 30 November 2001 
21:05To: Multiple recipients of list ORACLE-LSubject: 
Export/Import Job
If anyone out 
there has a good time estimate for the following export/import job I would 
appreciate it.  The goal is to change the DB_BLOCK_SIZE.  

 
Application: 
Oracle Apps 11i
Database Size: 
100GB, actually only about 80GB is used space.
2 CPU HP L-Class 
machine.  
 
I just need a 
couple of good estimates of how many days/hours this will take.   
I'm guessing around 3 days...  but I have never done anything this 
large before. 
 
Thanks!! 

 
Nick>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>This 
  electronic message contains information from the mmO2 plc Group which may 
  be privileged or confidential. The information is intended to be for the 
  use of the individual(s) or entity named above. If you are not the 
  intended recipient be aware that any disclosure, copying, distribution or 
  use of the contents of this information is prohibited. If you have 
  received this electronic message in error, please notify us by telephone 
  or email (to the numbers or address above) 
  immediately.>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

RE: Parallel Server

[Hallas John]

Title: RE: Parallel Server





We are using OPS quite intensively here. Not necessarily for the correct reasons.
OPS certainly assists in maintaining uptime under a lot of circumstances. It is excellent for spreading workload between nodes/instances but you still have to design access to point to different nodes (judicious use of tnsnames entries).

My main reservations re OPS (and the way we have implemented it) are the following
1) The datafiles are still a single point of failure. If a file is corrupt, deleted or whatever then the whole system is effectively down (dependant upon which datafile of course)

2)Even worse if a table is dropped or rows deleted etc there is no easy recovery without loosing uptime
3) OPS was applied to a non OPS application which means that key tables are being accessed all the time by multi nodes, again a key failure issue as well as a performance one. 

4) Some schema updates and new releases require downtime which is difficult in a 24*7*365 system !
5) We have found that a lot of effort was required from an OS level (Compaq Tru64 5.1) to get the patches right
6) I think the maintenenace of a cluster and OPS is an expensive option, both in licensing,support costs and manaeagability

Correct me if I am wrong but I always thought that OPS was initially brought out when a 4 CPU node was the maximum and it was a way of hranessing a number of niodes to achieve greater processing power. That is not the case now. I know there are other advantages but as I say I am sure that was the original purpose.

If I had a preference I think I would be tempted to go for 2 servers with a database replicated across each of them. I know that is not an easy solution, but it does provide full resilience as well as the means of taking one server down for maintenance without loosing the system. I think the cost of managing the system is also reduced. Upgrades can be tested on the 2nd server and a fallback position is always available.

As to the original question standby v OPS. I don;t think it is comparing like with like. You really ned to sit down and list what you need, what you would like, how much you have to spend in time, effort and money and then compare standy and OPS against that list

HTH


John



-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Sent: 05 December 2001 19:35
To: Multiple recipients of list ORACLE-L
Subject: Parallel Server



Is anyone using Oracle Parallel Server?  It that the best solution for a
standby server?
Any idea what it would cost?  Are there any classes covering implementation?


Ron Smith



-- 
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).




>>
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
>>

RE: LUHN formula

[Hallas John]

Title: RE: LUHN formula





LUHN? 
-Original Message-
From: Joe LaCascio [mailto:[EMAIL PROTECTED]]
Sent: 06 December 2001 18:29
To: Multiple recipients of list ORACLE-L
Subject: LUHN formula




Hey folks,


I don't want to reinvent the wheel if I don't have to.


Does anyone have a LUHN function they'd be willing to share?


Thanks,
Joe


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Change sysdate in database to a future date

[Hallas John]

Title: RE: Change sysdate in database to a future date 





Or use the init.ora parameter FIXED_DATE to set the database time only.
John


-Original Message-
From: kranti pushkarna [mailto:[EMAIL PROTECTED]]
Sent: 07 December 2001 04:30
To: Multiple recipients of list ORACLE-L
Subject: RE: Change sysdate in database to a future date 



change the date of the system on which the database resides


-Original Message-
Sent: Friday, December 07, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L



Hi Gurus,


I need to change the sysdate in the database to a future date. Does anyone
know the command to do it ? Please advise. Thanks.


Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: kranti pushkarna
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: sysdba and sysoper

[Hallas John]

Title: RE: sysdba and sysoper





SYSDBA can do more than start/stop the database. It has a lot more functionality that sysoper (Operator mode) which is normally used for basic database functions such as start/stop.

SYSOPER privilege allows operations such as:
    Instance startup, mount & database open ;
    Instance shutdown, dismount & database close ;
    Alter database BACKUP, ARCHIVE LOG, and RECOVER.
    This privilege allows the user to perform basic operational tasks 
    without the ability to look at user data.


SYSDBA privilege includes all SYSOPER privileges plus full system privileges
    (with the ADMIN option), plus 'CREATE DATABASE' etc..
    This is effectively the same set of privileges available when 
    previously connected INTERNAL.



-Original Message-
From: Sajid Iqbal [mailto:[EMAIL PROTECTED]]
Sent: 07 December 2001 10:10
To: Multiple recipients of list ORACLE-L
Subject: sysdba and sysoper



Hi


Can anyone tell me the difference between sysdba and sysoper.. in the book
it says :- 


sysdba - A priviliged role granted to database users allowed to start and
stop the Oracle Database


sysoper - A priviliged role granted to database users allowed to start and
stop the Oracle Database


The same explanation ?


Also whats a tempfile in oracle ?


Regards


-- 
Sajid Iqbal






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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: tablespace in backup mode

[Hallas John]

Title: RE: tablespace in backup mode





Charlie
Select status from V$backup. If status  = 'ACTIVE' then tablespace in hot backup mode


HTH


John


-Original Message-
From: Charlie Mengler [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2001 14:26
To: Multiple recipients of list ORACLE-L
Subject: tablespace in backup mode



Which table/view do I query to determine if any tablespace
has been left in hot backup mode?


-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  6041 Scripps Summit Ct.
858-831-2229  San Diego, CA 92131    
Rose are red. Violets are blue. I'm schizophrenic & I am too!
-- 
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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

Serial# changes when rolling back

[Hallas John]

Title: Serial# changes when rolling back 





Jared,Deepak
I did not see a reply on this. From a brief experiment I don't see the serial# changing when rolling back a transaction.

The code posted by Jared certainly works as the number of blocks to rollback reduces as the job nears completion.
If the serial# changes I would be interetsed to understand why and to what purpose


John
-Original Message-
From: Deepak Thapliyal [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2001 17:55
To: Multiple recipients of list ORACLE-L
Subject: Re: killing system user



Hi Jared


why does the serial# have to change due to rollback?
lots of us would be curious for a brief expln ...


Thx
Deepak
--- Jared Still <[EMAIL PROTECTED]> wrote:
> 
> The session is rolling back, you can't kill it.
> 
> This is why the serial# is changing.
> 
> The following query can be used to track its
> progress.
> 
> select s.osuser
>   ,s.username
>   ,s.sid
>   ,r.segment_name
>   ,t.space
>   ,t.recursive
>   ,t.noundo
>   ,t.used_ublk
>   ,t.used_urec
>   ,t.log_io
>   ,t.phy_io
>   ,substr(sa.sql_text,1,200) txt
> from v$session s,
>  v$transaction t,
>  dba_rollback_segs r,
>  v$sqlarea sa
> where s.taddr=t.addr
> and   t.xidusn=r.segment_id(+)
> and   s.sql_address=sa.address(+);
> 
> Jared
> 
> 
> On Sunday 02 December 2001 22:55, Tatireddy,
> Shrinivas (MED, Keane) wrote:
> > Hi lists,
> >
> > Solaris 2.7
> > oracle 8i
> >
> > I have a session "SYSTEM" doing import into a
> table. (logged into server
> > thru telnet from win 98 PC)
> >
> > Suddenly the power outage occurred to my PC.
> >
> > When I logged into the server thru telnet, I found
> that the session is
> > active.
> > By mistake, I killed the process at o/s level.
> >
> > For somereasons,I tried to drop the table. But I
> failed to do it, as it
> > is locked by import process.
> >
> > I tried to kill the user "SYSTEM". But the oracle
> is giving  error that
> > there is not user with such sid and serial number.
> >
> > The serial# number is often getting changed when I
> query from v$session.
> >
> > Is there a way to kill this user, without shutting
> down the database.
> >
> > And why different serial# number each time, I
> query v$SESSION.?
> >
> > Any clues?
> >
> > Thnx and Regards,
> >
> > Srinivas
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California    -- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: The Oracle List Archive?

[Hallas John]

Title: The Oracle List Archive?



Hi 
Eva,
Try 
the following link to access the archives. http://www.fatcity.com/ListGuru/login.php
I 
can't remember where you get the password from (I think it might be blank) - it 
validates on your e-mail address I believe
 
John

  -Original Message-From: Denham Eva 
  [mailto:[EMAIL PROTECTED]]Sent: 11 December 2001 12:00To: 
  Multiple recipients of list ORACLE-LSubject: The Oracle List 
  Archive?
  Hi, 
  Forgive the rather dumb newbie question. 
  However I regularly see people on this list refer 
  to the archive. How can I access this? I 
  have poked around at fatcity.com and not found much help! 
  TIA Denham 
  
  This e-mail message has been scanned for Viruses and Content and cleared by 
  MailMarshal - For more information 
  please visit www.marshalsoftware.com 
  
  


=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: nomount

[Hallas John]

Title: RE: nomount





Is this some sort of OCP test for us listers??


-Original Message-
From: Sajid Iqbal [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2001 12:20
To: Multiple recipients of list ORACLE-L
Subject: nomount



Hi


Anyone now which 2 V$ views can be accessed while in nomount mode ?


Also what is a tempfile ?


TIA


Saj Iqbal






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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Anybody have an opinion on!

[Hallas John]

Title: RE: Anybody have an opinion on!





Dick,
Your boss wasn't having a dig at you was he :-)
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 13:00
To: Multiple recipients of list ORACLE-L
Subject: Anybody have an opinion on!



Folks,


    I found an e-mail in my inbox this morning from my boss about a product
called Lecco DB Expert(http://www.leccotech.com/).  Anybody ever use this one or
have an opinion?


Mark,


    Since this is a competitor to Cool-Tools your welcome to get up on the soap
box.


Dick Goulet
-- 
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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Deinstalling JServer

[Hallas John]

Title: RE: Deinstalling JServer





Cherie - see the post below from sunilshivappa -  12/11/01 
John


+++
rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.
 
If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql has to be run. Unfortunately it does not remove all the components. Following workaround has to be used to get over the bugs.

1. Restart the database.


2. Start a different session other than the one that started the database.


3. Run initjvmaux.sql


4. Run rmjvm.sql


5. Run following SQL queries, LOG on as SYS.


--The minimum action to remove JIS trigger is running the following sql.


drop trigger JIS$ROLE_TRIGGER$;


delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED';


delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService';


delete from aurora$dyn$reg;


 


Regards,


sunil s.
+++
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 17 December 2001 15:13
To: Multiple recipients of list ORACLE-L
Subject: RE: Deinstalling JServer



Cherie,


I'm not entirely sure, as I've never done this before - but there is a
package in ORACLE_HOME/RDBMS/ADMIN called utljavarm.sql, which seems to do
the kind of thing you want. Maybe there is another that fits your needs
better, as this one has a warning note about only using it to
upgrade/downgrade to 8.1.5..


Rem
Rem $Header: utljavarm.sql 12-jan-99.17:10:39 rshaikh Exp $
Rem
Rem utljavarm.sql
Rem
Rem  Copyright (c) Oracle Corporation 1999. All Rights Reserved.
Rem
Rem    NAME
Rem  utljavarm.sql - Remove all java objects
Rem
Rem    DESCRIPTION
Rem  This removes all the java objects from the data dictionary.
Rem
Rem    NOTES
Rem  WARNING:  This script is highly destructive.  It should
Rem     only be run if you upgrading to or downgrading
Rem     from 8.1.5.  Once this script is run all of your
Rem     java objects will be gone unless you have a backup!!!
Rem
Rem  This script requires a significant amount of rollback
Rem  to execute.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    rshaikh 01/12/99 - Created (for mjungerm)
Rem


Hopefully the list can point to one that fits your needs more precisely.


Regards


Mark


-Original Message-
[EMAIL PROTECTED]
Sent: 17 December 2001 14:20
To: Multiple recipients of list ORACLE-L




Does anyone know how to deinstall JServer?   I accidentally installed it
and I don't
see anywhere in the documentation where it talks about how to remove the
objects
from the database.   This is for Sun Solaris 2.6 Oracle version 8.1.7.2.


Please reply directly to [EMAIL PROTECTED]


Thanks,


Cherie
Oracle DBA
Gelco Information Network


--
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: 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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: unused blocks BELOW HWM - Thanks

[Hallas John]

Title: RE: unused blocks BELOW HWM - Thanks





I agree with your reasoning Dennis. I have long felt that one of the problems with the list is that the original raiser of the question should have some sort of responsibility for summarising the various responses and posting a short summarised reply showing the solutions(s) that worked for him/her

This type of question where various solutions were proposed is the ideal candidate for this type of summarised response. I used to be on a Unix list and that strategy was used quite well there.

John


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2001 19:10
To: Multiple recipients of list ORACLE-L
Subject: RE: unused blocks BELOW HWM - Thanks



Naaah, I'm just the proverbial lazy DBA. Gene received many replies,
including "it can't be done". Since he happened to point out that two of
them worked and produced the same results (an excellent sanity check), I
thought it would benefit everyone by telling us which ones worked. I realize
that we could have each tried each of the strategies and discovered the two
for ourselves, but my principle is if there is an easier way, why not?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Tuesday, December 18, 2001 11:35 AM
To: Multiple recipients of list ORACLE-L



Uh, amen. Isn't that the purpose of the list?


Or is there a *third* list, one "on topic", a second 
"off topic", and a third where all the answers really
are?


-Original Message-
Sent: Tuesday, December 18, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L



Gene - Now that you've gotten your answer, would you mind to post both of
the methods that you found to work so that the rest of us could learn?
Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Tuesday, December 18, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L



Hi.


This is just to thank all who replied to my post.
Based on what I read, I have got two different ways of
calculating that number and they seem to produce the
same result. 


thank you all (you know who you are)



=



__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]


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

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


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

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


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

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


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

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

RE: online backup help

[Hallas John]

Title: RE: online backup help





Jain,
This is not really an Oracle issue, rather a sys admin one. 
Hot backup is Oracle method of ensuring that a datafile can be copied whilst still in use. So just issue the command to put it into backup mode, backup the file by whatever means and then take the datafile out of backup mode.

You will have to experiment as to whether you can secure files to a remote tape device. If you have a locally mounted tape drive you should not have a problem at all. If you have not it may be best to copy the datafile(s) (when in backup mode) to a disk drive and then copy them to tape later.

John 


-Original Message-
From: Anand Jain [mailto:[EMAIL PROTECTED]]
Sent: 24 December 2001 08:35
To: Multiple recipients of list ORACLE-L
Subject: online backup help




Dear All,
We are in the planning/testing stage right now. I wanted to know if it is possible to backup the Oracle database online, i.e. at the time Oracle database is running. This is also called hot backup. If yes, do I have to install the backup tape device to the same server where the Oracle is installed? Or can I install tape drive to any other server and from there also can I take online/hot backup of the oracle database?

Regards
Jain Anand 


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Exp / Imp Utility Questions

[Hallas John]

Title: RE: Exp / Imp Utility Questions





1) You cannot have read the docs to well not to know the answer to Q1
Hint  - look at the ignore parameter to imp
2) It all depends if the triggers have been run once to change the data that is now in the conversion db.
You may have a trigger that adds 1 to a field. If the data has been populated into a table with the trigger enabled it will have  value of field + 1. If you then import the data into your test db with a trigger enabled it will action the trigger and the field will then have the value of field +1 +1. Remember import is only a fancy way of typing insert into for each row of data

3)  As you say, it is a test database, experiment with a couple of tables and find out the answers for yourself. That is the best way of learning

John




-Original Message-
From: Ken Janusz [mailto:[EMAIL PROTECTED]]
Sent: 28 December 2001 12:45
To: Multiple recipients of list ORACLE-L
Subject: Exp / Imp Utility Questions



I'm doing a DB conversion to 8.1.7 on W2000.  I have converted the old
tables / data to the new application on my conversion server.  Now I have to
load it onto a test server at a different site.  I will be using tables=
parameter to a select group of tables / data.  I have not found the answers
to my questions in the documentation.


    1. Can I use Exp / Imp to just move the data?  Or, does this utility
move the data and the table structures?


    2. The conversion DB that I have only has the tables, PK's, FK's,
and indexes and no triggers, functions, cursors, etc. (they are created by
another script).  There is no application code attached to this DB.  The DB
I will be loading to is fully functional - all the PK's, FK's, triggers,
functions, et al.  Will loading the data from my conversion DB cause
problems with the test DB?


    3. I know I will have to disable the FK's on the test DB.  But, what
about the triggers on the applicable tables?  Should they be disabled?


    Anything else I need to know before I get rolling on this?


    Thanks,


    Ken Janusz, CPIM 
    Database Conversion Lead 
    Sufficient Systems, Inc. 
    Minneapolis, MN



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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: XP Professional & 9i

[Hallas John]

Title: RE: XP Professional & 9i





I think it is our problem actually because the majority of questions you ask could be answered quite easily by looking at the manual or using Metalink.

Is your company just a one or 2 man band or is it a reasonably sized company. If so I would have thought that having Oracle support was a  necessity rather than a nice to have.

I once turned down a contract at a company because they did not have 24 hour support and I was expected to do out of hours support for which any call was made would be charged for. I and I am sure many others have got into a situation where we are on our own/tired/stuck/confused whatever and a call to support has been very helpful, not just for the answer but more as someone to talk to, ensure that you are not about to do anyuhing stupid (too late for me :-)). 

Knowadays there is a lot more on-line resource available and this list is getting better all the time but I personally think Metalink is invaluable both for resolving immediate problems and digging deeper into areas of interest.

John


-Original Message-
From: Ken Janusz [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2001 17:55
To: Multiple recipients of list ORACLE-L
Subject: RE: XP Professional & 9i



Jared:


We are not on MetaStink because my company won't pay for it.  It's their
problem not mine.


Ken


 -Original Message-
Sent:   Saturday, December 29, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L
Subject:    Re: XP Professional & 9i



That brings rise to the question "Why aren't you
a member of MetaStink?"


Have you purchased Oracle Support?  If so, you likely
have access to MetaLink.  If not, you need to.


You'll never be able to successfully implement an Oracle
based application on 9i without support.  You at least need
to have access to patches.


Jared


On Saturday 29 December 2001 06:25, Ken Janusz wrote:
> We are not a member of metastink.  I looked at OTN an it's only certified
> up to W2000.  So, I was wondering if anyone knew if it is cert. for XP
> Prof. or when it will be?
>
> Thanks,
> Ken
>
>  -Original Message-
> Sent: Saturday, December 29, 2001 7:50 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: XP Professional & 9i
>
> Ken, go to metalstink and look for the certification matrix.
>
> joe
>
> Ken Janusz wrote:
> > Will 9i run on XP Professional client?  And, no I am not interested in
> > putting Linux on my home PC at this time.
> >
> > Thanks,
> > Ken Janusz, CPIM
> > Database Conversion Lead
> > Sufficient Systems, Inc.
> > Minneapolis, MN
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ken Janusz
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Problem Granting Roles

[Hallas John]

Title: RE: Problem Granting Roles





What exactly is the error message - if it is table or view does not exist (ORA-904) then I suspect that it is synonyms that are not working/created.

get the user to select from the full table name sys.x and see what happens.


-Original Message-
From: Ken Janusz [mailto:[EMAIL PROTECTED]]
Sent: 02 January 2002 12:30
To: Multiple recipients of list ORACLE-L
Subject: Problem Granting Roles



I granted myself roles via SYS.  I have another user on our server (W2000 /
8.1.7) and I have gone through the same process of granting the new user
roles via SYS.  However, when she connects to the DB she gets the message
that the objects don't exist.  The owner of the DB is me.  What am I doing
wrong?  Should I grant her roles from my user name or from SYS?


Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Criteria for handoff from development

[Hallas John]

Title: RE: Criteria for handoff from development





Taking a slight diversion away from data modelling issues a set of Production type issues need to be addressed prior to going live

These could include


Signed off user acceptance testing,
Backup strategy, devised, tested and signed-off
Expected performance targets and response times (part of an SLA really)
Signed off volumetric testing. Some of the major issues when going live appear when real volumes of data have been entered and a query that ran well against 500 rows in developmenbt does not do quite as well against 500,000 in live.

Network impact assesment
Data archiving and houskeeping routines agreed and tested
I am sure there are many others items that listers can supply


John




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 13:50
To: Multiple recipients of list ORACLE-L
Subject: RE: Criteria for handoff from development



I agree with the column naming comments.  I would find it hard to
over-emphasize the need for a column naming convention that allows you to
know what table a column belongs to, whether it's a primary or foreign key,
and ,if it's a foreign key, then what the name of the base table and column
are.  I also agree with the comments on choosing a primary key.  If the
database is never going to by synched with an outside database then the
best choice for a primary key is a sequence generated number.


Personally, I wouldn't worry too much about normalization problems if
they're deliberately done.  It's easy to gong developers over
normalization, but sometimes a denormalized table is necessary for
performance.  In fact, if the data model is perfect 3rd normal form then
you'll probably have to do some denormalization.


All that being said, it's silly to have the developers present you with a
data model.  You should have been involved in developing the data model
from the very beginning.  But life, or management, is always presenting us
with new "opportunities."  Good luck.




   
    "Mercadante,   
    Thomas F"    To: Multiple recipients of list ORACLE-L  
        
    @labor.state.    cc:   
    ny.us>   Subject: RE: Criteria for handoff from    
    Sent by: root    development   
   
   
    01/04/2002 
    03:50 PM   
    Please 
    respond to 
    ORACLE-L   
   
   





Dennis,


First of all, I would tell your manager that 90% of tuning is in writing
good queries no matter what the data model looks like.


Unfortunately, you receiving a data model and expecting to perform miracles
is pretty naive of the organization.  This is a classic example of how NOT
to do things.


Saying that, I would look closely at the model and check for the following:


Look closely for normalization problems.  If you see repeating fields in a
table, reject it and tell them to change it.


Look for column-naming standards.  If they do not have them, make some up
and enforce them.  Some common naming standards would use a suffix to
indicate the type of data the column is holding.  Things like _DATE _NBR
_FNAME _LNAME _ID and _CODE would indicate date, number, standard length
first and last name, Id type columns indicating it is a primary key
(possibly) an integer value, and a Code column indicating that this is a
foreign key to another table.  This is s important for report-writing
people on the back-end of the project.  They can implicitly see that the
column has a certain value by the name.


Ask how they determined primary key values for all tables.  Specifically,
how do they KNOW that the values will be unique.  Question everything you
see.  This is probably the biggest area of concern that I would have.
Non-db designers will always make a mistake here.  I developed a db once
that used the soc-sec as the pk.  WRONG!  The db was at a college.  Want to
know how many parents use thei

RE: Becoming a DBA questions

[Hallas John]

Title: RE: Becoming a DBA questions





Mark,
Why do you sound so  suprised Mark? £120 / hour - wouldn't get out of bed for that. 
As Lee says he is either very lucky, specialised or both.


Wherever the job is in the UK I will undercut by £10/hour :-)


John


-Original Message-
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 16:06
To: Multiple recipients of list ORACLE-L
Subject: RE: Becoming a DBA questions



Mark,


Is this in the UK ??


Those sorts of rates were being bandied around a while ago but even some of
the better ones these days (and they are few and far between) are round
about the 70 per hour tops. Up here in the N.E that drops to something
around 50. Mind you they are about as rare as rocking horse dung !!!


Lee



-Original Message-
Sent: 07 January 2002 15:57
To: Multiple recipients of list ORACLE-L



We actually heard in the office today that one of our contacts is currently
forking ?120 PER HOUR for an Oracle contractor that has experience on UNIX /
AIX based systems. This guy is working on a 40 hour per week basis - and the
cash is paid directly to him! He is supposedly a very competent DBA.


With this in mind:


Per week = ?4,800
Per Month = ?19,200
Per Year = ?249,600 ()


I know these numbers may not be "true" as this guys is a contractor, and may
not have 52 weeks of the year booked up - but..


For you guys an' gals in the US that equates to:


Per Hour = $172
Per Week = $6,900
Per Month = $27,600
Per Year = $358,775


Now THAT'S what I call making REAL money!


-Original Message-
[EMAIL PROTECTED]
Sent: 07 January 2002 03:30
To: Multiple recipients of list ORACLE-L




Yeh, I thought wow as well
My question is this is it really possible to earn that sort of money as a
DBA in the US?, and no I aint looking for a job over there. Just curious if
this is total bull


We hear rumours routinely about salary levels in the US and they tend to
contradict themselves sometimes figures such as this and then sometimes a
lot, lot less. But then the same applies to the market here. There is
probably a couple of key DBA's in Sydney and Melbourne that are 6 figures
and then there is a lot of DBA's over here that earn more like midddle to
high 5 figure incomes. Sydney figures always are or should be higher



Cheers


--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical Consultant    WWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  Australia    Mobile: +61 (0)402 094 238
   Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.


   - Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"


=






"Sinard Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/01/2002 11:40 AM
Please respond to ORACLE-L


    To:    Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
    cc:
    Fax to:
    Subject:    RE: Becoming a DBA questions




200K US$ ??? Wow


-Original Message-
[EMAIL PROTECTED]
Sent: 05 January 2002 02:16
To: Multiple recipients of list ORACLE-L




Lemme get this right.


This guy is a *new* DBA.  He's making 150k and he's not
even a senior DBA, where he can make 200k?


That's all from me.  I'm gonna go sulk now.


Jared





   DENNIS WILLIAMS
   
list ORACLE-L <[EMAIL PROTECTED]>
   TOUCH.COM>    cc:
   Sent by:  Subject: RE: Becoming a DBA
questions
   [EMAIL PROTECTED]
   m



   01/04/02 09:05
   AM
   Please respond
   to ORACLE-L







The following eweek article might be of interest. If the link gets mangled,
the article is at http://www.eweek.com Following the Data to a DBA Job by
Jeff Moad.
http://www.eweek.com/article/0,3658,s%253D703%2526a%253D20563,00.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
 INET: [EMAIL PROTECTED]


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

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





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


Fat City Network Services    --

RE: login/exit problems

[Hallas John]

Title: RE: login/exit problems





There was a problem with  Oracle Trace being set in some V7 instances. A couple of files grew quite large.
STOP PRESS just checked on Metalink and found note 45482.1 
This suggest checking the $ORACLE_HOME/otrace/admin directory for a file process.dat and see if it growing (recently written to).

-Original Message-
From: afa2 [mailto:[EMAIL PROTECTED]]
Sent: 08 January 2002 19:20
To: Multiple recipients of list ORACLE-L
Subject: login/exit problems



We have an Oracle 7.3.4 database that has been stable for a number of
years but has started having problems during logon and exit with both
sqlplus and remote logins. It hangs for up to a minute before connecting
to Oracle server after you get


$ sqlplus ***/***


SQL*Plus: Release 3.3.4.0.1 - Production on Tue Jan  8 19:06:28 2002


Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.  





and similarly following an exit from Oracle server after disconnecting 


Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication, parallel query and Spatial Data
options PL/SQL Release 2.3.4.0.0 - Production 





before returning to OS command line prompt


lsnrctl, tnsping, etc suggest port is okay. Stopping and restarting
database make no difference. Any advice or help will be much
appreciated.


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: pinning objects

[Hallas John]

Title: RE: pinning objects





I wrote a database tuning document a while ago and the notes below are from the section on pinning. I do recall that the final comment re the difference betwen pinning and keeping was from a Steve Adams response to a question on this list.

The library cache forms part of the shared pool area. An important part of managing the library cache efficiently is to ensure that any frequently used packages are kept in the shared pool and not aged out. Oracle provides the dbms_shared_pool package to keep (or pin) packages, procedures, triggers and cursors. The object is never flushed out of memory until either an instance shutdown or it is explicitly unpinned. Objects that are accessed frequently are the best candidates for pinning. Pin packages as user SYS.

It is recommended that the following packages are pinned in memory at instance startup.


SYS.STANDARD
SYS.DBMS_STANDARD
SYS.DBMS_DESCRIBE
SYS.DBMS_UTILITY
SYS.DBMS_LOCK
SYS.DBMS_PIPE
SYS.DBMS_OUTPUT


The syntax to pin and then unpin a package is


EXECUTE DBMS_SHARED_POOL.KEEP ('sys.dbms_output');
EXECUTE DBMS_SHARED_POOL.UNKEEP ('sys.dbms_output');


1)  Note that when the shared pool is flushed (ALTER SYSTEM FLUSH SHARED_POOL) kept packages are NOT flushed out.
2)  Note that pinning and keeping are technically not the same. In the library cache a pin is a lock held by a particular session on one or more heaps of an object. With regard to the shared pool, a pin is a bitmap in the header of a recreatable chunk indicating whether it is eligible to be aged out or flushed from the shared pool. Library cache object heaps that are marked for keeping may not be pinned in either sense.

A script to identify suitable objects is :- 


Col owner format a10
Col name format a25
Set lines 200
Rem 
rem  Look for high number of loads 
rem
select owner,name,loads,executions,kept
from v$db_object_cache
where type like 'PACK%'
and loads > 1
order by loads
/



HTH 


John




-Original Message-
From: John Dunn [mailto:[EMAIL PROTECTED]]
Sent: 11 January 2002 09:40
To: Multiple recipients of list ORACLE-L
Subject: pinning objects



I am investigating pinning some of the developers packages into memory.


Could you please clarify how this is done. 


Also how can I identify which packages would beefit from pinning?


John


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

pinning objects

[Hallas John]

Title:  pinning objects







I wrote a database tuning document a while ago and the notes below are from the section on pinning. I do recall that the final comment re the difference betwen pinning and keeping was from a Steve Adams response to a question on this list.

The library cache forms part of the shared pool area. An important part of managing the library cache efficiently is to ensure that any frequently used packages are kept in the shared pool and not aged out. Oracle provides the dbms_shared_pool package to keep (or pin) packages, procedures, triggers and cursors. The object is never flushed out of memory until either an instance shutdown or it is explicitly unpinned. Objects that are accessed frequently are the best candidates for pinning. Pin packages as user SYS.

It is recommended that the following packages are pinned in memory at instance startup.


SYS.STANDARD
SYS.DBMS_STANDARD
SYS.DBMS_DESCRIBE
SYS.DBMS_UTILITY
SYS.DBMS_LOCK
SYS.DBMS_PIPE
SYS.DBMS_OUTPUT


The syntax to pin and then unpin a package is


EXECUTE DBMS_SHARED_POOL.KEEP ('sys.dbms_output');
EXECUTE DBMS_SHARED_POOL.UNKEEP ('sys.dbms_output');


1)  Note that when the shared pool is flushed (ALTER SYSTEM FLUSH SHARED_POOL) kept packages are NOT flushed out.
2)  Note that pinning and keeping are technically not the same. In the library cache a pin is a lock held by a particular session on one or more heaps of an object. With regard to the shared pool, a pin is a bitmap in the header of a recreatable chunk indicating whether it is eligible to be aged out or flushed from the shared pool. Library cache object heaps that are marked for keeping may not be pinned in either sense.

A script to identify suitable objects is :- 


Col owner format a10
Col name format a25
Set lines 200
Rem 
rem  Look for high number of loads 
rem
select owner,name,loads,executions,kept
from v$db_object_cache
where type like 'PACK%'
and loads > 1
order by loads
/



HTH 


John




-Original Message-
From: John Dunn [mailto:[EMAIL PROTECTED]]
Sent: 11 January 2002 09:40
To: Multiple recipients of list ORACLE-L
Subject: pinning objects



I am investigating pinning some of the developers packages into memory.


Could you please clarify how this is done. 


Also how can I identify which packages would beefit from pinning?


John


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Sqlloader

[Hallas John]

Title: RE: Sqlloader





See the following note sent on 4/12/01 - it should assist
John



Try the following example:


TMD=`date '+%Y/%m/%d'`
TMS=`date '+%Y%m%d%H%M%S'`
sqlplus -s internal <
set verif off pages 0 echo off feed off term off lines 200
spool $SHELLSRCDIR/dbcontents.$TMS.log
select  'alter database rename file '''||name||''' to '''||name||''';'
from    v\$datafile;
column member format a50
select 'alter database rename file '''||member||''' to '''||member||''';'
from
v\$logfile;
spool off
whisky



Regards 
Peter Lomax (Oracle DBA) 
Expertise Oracle 
SG/DSI/SIMBAD/AT&P 
OrangeFrance 
Bureau: 
*: - [EMAIL PROTECTED] 
(:  (+33) (0)1 55 22 59 13 
fax: (+33) (0)1 55 22 39 69 
+++
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2002 08:45
To: Multiple recipients of list ORACLE-L
Subject: Sqlloader



Hallo all you gurus,


Anyone who can help me with this:


I have this  unix script: In the script I wamt to create a logfile for every day that I run this script so that thel logfile will look like:

2002-02-22laddabsg.log
and when i run the script tomorrow I want it to be:


2002-02-23laddabsg.log


anyone who can help me to complete this unix script



This line executes the sqlloader command and it is this logfile I want to have the runningdate in too.


sqlldr userid=konto/icakort control=/d31/appl/konto/bat/laddabsg.ctl log=/d31/appl/konto/log/laddabsg.log




(See attached file: loadfast.sh)



Thanks in advance


Roland




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Re: How can I tell if a procedure/package is running?

[Hallas John]

Title: RE: Re: How can I tell if a procedure/package is running?





Sinardy,
This only tells you if an object exists not if it is running - or even if it is valid unless status is elected from dba_objects as well.

There was a thread around 30/10/01 with the appropriate title 'How can I tell if a procedure/package is running?'  - I am not sure if it is the same thread that we are on now. The following quote came from a reply by Steve Adams

You can look at the mode in which the stored procedure or package is pinned in the library cache. This information is in

X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in shared mode by one or more sessions. If necessary,

you can join to X$KGLPN to find the sessions holding the pins. See "executing_packages.sql" at
http://www.ixora.com.au/scripts/misc.htm#executing_packages for an example.



HTH 


John



-Original Message-
From: Sinard Xing [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2002 08:40
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: How can I tell if a procedure/package is running?



Hi,


You can do


Select object_name, object_type, status
from dba_objects
where object_type like '%PACK%' or
    object_type like '%PROCE%'
order by 2,1;




Sinardy



-Original Message-
[EMAIL PROTECTED]
Sent: 22 January 2002 15:10
To: Multiple recipients of list ORACLE-L




Can anyone give me a good example on how this works?
Thanks in advance


Roland









Connor McDonald <[EMAIL PROTECTED]>@fatcity.com den 2001-10-25 01:45 PST


Sänd svar till [EMAIL PROTECTED]


Sänt av:  [EMAIL PROTECTED]



Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:


I would say that the best way is in its coding
typically by adding calls to dbms_application_info -
which is great way of tying SQL to its owning PL/SQL
as well.


You might be lucky to catch it in sql_address in
v$session (depending on what its actually doing at the
time).  Similarly, you could possibly glean some info
from V$SQL via USERS_EXECUTING


You could always try modify the proc which would
probably hang on library cache pin or similar - hardly
a recommended way of course :-)


hth
connor


 --- Doug C <[EMAIL PROTECTED]> wrote: > How can I tell
if a stored procedure or package is
> in the middle of execution?
> (for lack of doing what it does)..    I've heard of
> parse locks, is that a way?
>
> Thanks,
> D
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Doug C
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California    -- Public Internet
> access / Mailing Lists
>

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


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


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



Nokia Game is on again.
Go to http://uk.yahoo.com/nokiagame/ and join the new
all media adventure before November 3rd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]


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

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










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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sinard Xing
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet a

RE: More Rman q's

[Hallas John]

Title: RE: More Rman q's





Jack,


TEST3 instance should be exactly as you stated, an Oracle instance with no datafiles as yet.
What I think I was meaning regarding the names of the objects is that the format is


Rman catalogue = catalogue
Source database  = target
new database   = auxilliary.


To my mind that is wrong and the new database should be target. It is of no importance but I do think it can be confusing.

What is even odder is requirement to connect to the target database in the first place. A live database has been copied to disk/tape. We want to make a new copy on a development server. But we still have to connect to the original live database. I once had a reason from Oracle for this in a tar dialogue however it did not sound very convincing to me at the time.

John


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2002 10:10
To: Multiple recipients of list ORACLE-L
Subject: RE: More Rman q's




Hi,


Am I misreading all this, but should the auxiliary database be in existence
before I can Clone to it?


I created the init.ora and all directories and started TEST3 in nomount. I
created the password file and can connect to it with a connect string no
problem.


Another point is. Did you mean that the auxilliary database is the database
that needs to be cloned (source)?


Jack





"Jay Hostetter" <[EMAIL PROTECTED]> on 23-01-2002 15:41:35


To:   <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:


John and Jack,


  I guess I didn't read Jack's info closely enough, since he states that
his auxiliary database is already started nomount.  I wonder if the three
separate connect statements are the issue?  When I duplicate a database, I
use the following commands from the OS:


>rman target internal/xxx@original catalog rman/xxx@rman1 auxiliary /
rman>@prod_to_test
rman>exit


My ORACLE_HOME and SID are set for the auxiliary database.  I have started
the auxiliary database NOMOUNT, which basically just starts the background
processes.    Password files are required for the remote login (this is on
a different server).  I don't use db_file_name_convert or
log_file_name_convert, because I group the data files differently on this
server (I don't have the exact same number of file systems as production).
After I have RMAN started, I do the following:


run {
#set until time "to_date('0108200220','mmddhh24miss')";
set until scn 316498395;
#set until logseq 1389 thread 1;
allocate auxiliary channel ch1 type disk;
set newname for datafile 1 to '/u03/oradata/BSCST/system01.dbf';
set newname for datafile 2 to '/u03/oradata/BSCST/rbs01.dbf';
...
...yadda yadda yadda...
...
set newname for datafile 49 to '/u04/oradata/BSCST/bill_image_data06.dbf';
set newname for datafile 50 to '/u04/oradata/BSCST/process_data03.dbf';
duplicate target database to BSCST
logfile
group 1 ('/u03/oradata/BSCST/redo1a.log','/u04/oradata/BSCST/redo1b.log')
size 2m,
group 2 ('/u03/oradata/BSCST/redo2a.log','/u04/oradata/BSCST/redo2b.log')
size 2m,
group 3 ('/u03/oradata/BSCST/redo3a.log','/u04/oradata/BSCST/redo3b.log')
size 2m;
}



Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA  USA


>>> [EMAIL PROTECTED] 01/23/02 03:20AM >>>
Jay,Jack
I don't understand here how RMAN connects to auxilliary when Jack seems to
be saying that the database does not exist it all.
When I tested a duplicate database session I made the following notes which
indicated I need a remote_login_password file setting up. I assume you
didn't do this then Jack as the database was not created at this point in
time
Please correct me if I  have misunderstood


John
My notes follow
+++


To allow this connection a remote_login_password file needs to be in place.
This can be created running the orapwd command


$ORACLE_HOME/bin/orapwd file$ORACLE_HOME/dbs/ orapwSID password = xx
entries=10


Then add the line remote_login_passwordfile=exclusive to the init.ora and
start the database in exclusive mode (using the initSID_excl.ora file in
the
pfile directory).
Ensure that this works by performing a sqlplus internal @tnsnames_alias
with
the correct password and ensuring that a connection has been made.


This needs to be set up on the target environment as well as on the
auxillary server. Ensure that a connection can be made both locally and
remotely


sqlplus internal/password@tnsnames_alias










===
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-m

RE: Query

[Hallas John]

Title: RE: Query





Short for machine


John


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2002 12:50
To: Multiple recipients of list ORACLE-L
Subject: RE: Query



What is: m/c ???



Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]


> -Original Message-
> From: Ghadge,Sameer [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, January 28, 2002 1:55 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Query
> 
> Hi all,
> Can we have the multiple databases on the same m/c running at the same
> time.
> 
> thx
> Sameer
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Ghadge,Sameer
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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 was scanned by the eSafe Mail Gateway 
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: COPY vs. OCOPY on NT

[Hallas John]

Title: RE: COPY vs. OCOPY on NT





Try http://www.speakeasy.org/~jwilton/oracle/hot-backup.html for a view on this


John


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2002 09:20
To: Multiple recipients of list ORACLE-L
Subject: RE: COPY vs. OCOPY on NT



I seem to miss something here.
We are talking about backups that run after: alter tablespace XXX begin
backup.
There are no writes to the tablespace in this situation.



Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]


> -Original Message-
> From: Thomas B. Cox [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, January 28, 2002 6:35 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  COPY vs. OCOPY on NT
> 
> 
> Your point is (I believe) that the Oracle data files are
> opened writeable by Oracle at instance startup time.  When
> you use the NT command "COPY" it will prevent additional
> writers, but not those writers that are already holding
> write locks.
> 
> My comments and questions are:
> 
> 1. This used to fail with an error in previous versions
> of Oracle and NT that I've worked with.
> 
> 2. I'd be curious if multiple DB writers could cause
> a problem with your setup.
> 
> 3. If a COPY fails/dies holding its lock, can I re-start
> either the COPY of Oracle without rebooting or manually
> clearing the lock?
> 
> 4. You have demonstrated that the statement "COPY will
> always fail" is false.  But we're not yet at "COPY will
> always work" -- and that could be a problem.
> 
> Cheers.
>  -Tom
> 
> 
> --- Igor Neyman <[EMAIL PROTECTED]> wrote:
> > Now, from my other message to the list (don't know, if Eric forwarded
> > it to
> > you), it answers your questions about my experience recovering from
> > online
> > backup and why I don't like MetaLink Note explanation in regard to
> > advantages of "Ocopy" versus "Copy":
> > 
> > 
> > Couple years ago, when we were preparing first release of our
> > product, I
> > read of course about "NT Copy" versus "Oracle Ocopy".
> > Still I decided to test it, because not always I trust what I read,
> > and I
> > like to get proof myself.
> > Testing of online ("hot") backup/recovery scenario showed, that using
> > "NT
> > Copy" command in backup scripts is perfectly fine, when creating
> > backup set
> > of files on the disk.  And there is no problem restoring from this
> > backup.
> > Now this "disk backup" set of files could be saved on tape, using
> > NTBACKUP
> > (that's the one, that really can not copy file, if it's opened by
> > some other
> > program.  But that's not the case with prepared in advance "disk
> > backup").
> > "NT Copy" has no problems copying files opened already by Oracle, and
> > backup
> > is consistent, as long of course as I am using "alter tablespace
> > 
> > begin backup" before copying relevant files and "alter tablespace
> >  end
> > backup" after finishing files copy.
> > So, those scripts (using "NT Copy") were put into production, and now
> > have
> > been used for more than two years on more than hundred
> > installations/sites
> > (the number keeps growing).
> > From time to time, our field engineers are bringing back to me sets
> > of
> > online (can not use "cold" backup - our systems should run 24*7, I'm
> > not
> > saying they are, but we are trying to minimize downtime) backed up
> > files (db
> > files and archived RedoLog files), and I recover them with no problem
> > (we
> > need this, to test how the upgrade to next release of our product
> > will run
> > against "real" customers data).
> > 
> > Now, about MetaLink Note:139327.1
> > It says:
> > 
> > Ocopy  opens the file using CreateFile() with the FILE_SHARE_READ and
> > FILE_SHARE_WRITE  flags. This allows writing to continue while we
> > take the
> > backup.  Inconsistencies in the backup are repaired by applying
> > archived
> > redo  during  recovery. The 'copy' command from NT doesn't use these
> > flags
> > since it  wants to  prevent writes to the file while the copy is
> > taking
> > place.
> > 
> > 
> > I don't think, it's very accurate, and here is why:
> > When during online backup I run "NT copy" against db file, the file
> > is
> > already opened by Oracle (at moment, when I "open" the database).
> > So, even if "NT copy" opens file without FILE_SHARE_READ and
> > FILE_SHARE_WRITE  flags, all it means is that "Subsequent open
> > operations on
> > the object will fail" (quote from NT docs).  I want you to notice, it
> > says
> > "Subsequent open operations" not "Subsequent write/read operations". 
> > So,
> > all it does is prohibiting some other program/process from "opening"
> > the
> > file.  But Oracle, as I mentioned, has this file already opened, and
> > it is
> > perfectly capable of reading/writing this file.
> > Of course, the image of the saved file will be "fuzzy", and that's
> > why when
> > recovering from online backup we are applying archived RedoLog files
> > (which
> > getting written much more intensely during onlin

RE: RMAN and ORA 8.1.7 on NT/W2K

[Hallas John]

Title: RE: RMAN and ORA 8.1.7 on NT/W2K





Allen,
I am sure you can continue in the same manner as before if you wish. I am no NT expert but we are using hot backups on a variety of Unix and NT servers using 8.1.7. We also have some RMAN backups as well.

Carry on with the hot backups and then perhaps use RMAN on a test database until you are familiar with it


John


-Original Message-
From: Allen R. Lucas [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2002 15:11
To: Multiple recipients of list ORACLE-L
Subject: RMAN and ORA 8.1.7 on NT/W2K



I am looking at upgrading our ORA 8.0.5 databases to ORA 8.1.7.  In
preparation, I am reading the 8i administrators guide for NT.  Chapter 11,
Backing up and Recovering Database Files, states that one can use Oracle
Enterprise Manager DBA Management Pack, or Line Command RMAN, or OCopy.


Currently, we backup using a homemade batch file which varies the
tablespace offline, does a host copy, then varies the tablespace back
online.  We also copy the controlfiles, password files, etc...  The process
is continually tested and works.  We hotbackup daily and cold backup once a
week.


Anyway the question is whether I will be able to continue backing up a
8.1.7 DB the same way, or am I finally going to be forced into RMAN?




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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Unix script

[Hallas John]

Title: RE: Unix script





Basis of a script added into yours below. Note I am only checking to see if there is a PMON proces up - maybe best to make a sqlplus connection and read v$instance or something and exit if it fails.

Really very poor but will give you something to work on.


What I don't see from your sample script is the end marker for the << ! command
I normally use  << EOF and then at the end of the sql statements I have a line with EOF in. I do not see your ! marker


To get a log file call the shell script and > to log_file or set that up in your cron routine


HTH 


John



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2002 14:31
To: Multiple recipients of list ORACLE-L
Subject: Unix script



Hallo,


I have this unix script. I would like to include code which checks if the oracle database is up and running so the procedure konto.fillbotables.anrop doesnt start at all.. I also want an errorlog file to be created. Please tell me how to write the

code and where to include it in this shell script.



#!/bin/sh
. /usr/bin/orasetup.sh
. /d31/appl/konto/bat/movefiles.sh


numberOfLines=`ps -ef|grep pmon wc -l`  grep for sid or ora_pmon_sid or whatever
if  [ $numberOfLines -lt 2 ]  # ie database not running
then 
cat dummy_file |mailx -s "No database running loader not started" [EMAIL PROTECTED]
else 
fi



sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl
log=/d31/appl/konto/log/ehbgrupp.log
sqlplus -s konto/icakort << !
set heading off
set verify off
set feedback off
set termout off
set pages 0
begin
konto.fillbilbotables.anrop;
END;
/
EXIT


fi





sqlldr userid=konto/icakort control=/d31/appl/konto/bat/ehbgrupp.ctl
log=/d31/appl/konto/log/ehbgrupp.log
sqlplus -s konto/icakort << !
set heading off
set verify off
set feedback off
set termout off
set pages 0
begin
konto.fillbilbotables.anrop;
END;
/
EXIT




Thanks in advance



Roland



-- 
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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: auditing tables

[Hallas John]

Title: RE: auditing tables





Auditing is a definite overhead but the degree varies depending on what auditing is set up and how many transactions you have.

Auditing can tell you who did what to a table (IUD etc). What it will not do is store before and after values.
If that is what you want then triggers are required. Obviously if a new record is going to be written to an audit table every time a record in the master table is changed then that can cause significant database activity which will have an overhead on performance and possibly space as well depending on the volumes.

Another workround could be to use Logminer to check what a user has done and when. This is perhaps more suitable for a one off security check that a method of tracing every change by any user at any time.

Realy it is a matter of negotiating requirements v performance v implementation time/costs and identifying which solution (or mixture of the above) provides the necessary facilities

HTH


John



-Original Message-
From: Foelz.Frank [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2002 14:11
To: Multiple recipients of list ORACLE-L
Subject: auditing tables



Hi all,


does anyone have experience in using Oracle's possibilities of auditing
a database ??


I am interested in performance questions i.e. is it a hughe loss of
performance
when auditing tables Inserts/Updates/Deletes. Should I use triggers instead
?


any hints (comments, websites, etc...) are welcome.


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Rman again. Long screen output removed

[Hallas John]

Title: RE: Rman again. Long screen output removed





Jack, 
Your date format is 
 set until time  'to_date(''29012002094700'',''ddmmhh24miss'')';
whereas one that works for me and matches the documentation is 
 set until time "to_date('18-SEP-2001 01:00:00','dd-mon- HH24:MI:SS')";


Note the difference in quotation marks which is what the RMAN error message refers to


Try my format and see what happens 


HTH


John


    
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 14:25
To: Multiple recipients of list ORACLE-L
Subject: RE: Rman again. Long screen output included





Hi,


That only works if the format mask is set correctly, ergo not very
flexible.



Jack





אדר יחיאל <[EMAIL PROTECTED]>@fatcity.com on 29-01-2002 14:15:22


Please respond to [EMAIL PROTECTED]


Sent by:  [EMAIL PROTECTED]



To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:    (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Subject:  RE: Rman again. Long screen output included


Hello Jack


The RMAN command  recover database;
is changed to be recover database until time '1999-03-05:11:33:00';




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Web site of messages

[Hallas John]

Title: RE: Web site of messages





I also found this site by searching Google for Oracle-L
http://faqchest.dynhost.com/prgm/oracle-l/


-Original Message-
From: Marin Dimitrov [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 08:00
To: Multiple recipients of list ORACLE-L
Subject: Re: Web site of messages




- Original Message -


> Hi,
>
> Is there a website, which keeps all the messages posted to this forum,
which
> can be accessed without subscribing to the forum?
>


try http://www.fatcity.com/ListGuru/my.php and
http://www.mail-archive.com/oracle-l%40fatcity.com/


hth,


    Marin



"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "





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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

Alter system check datafiles

[Hallas John]

Title: Alter system check datafiles





Paul Sherman wrote 'I tried an 'alter system check datafiles' 


I had never come across that command before and looked at the documentation which states that 'in a distributed database system, such as an Oracle Parallel Server environment, updates an instance's SGA from the database control file to reflect information on all online datafiles'. Global actions against all nodes , local against the current instance only.  

I did check out the OPS install/config guide but did not found anything more in there. I was failing to understand in which circumstances the command would be required, knowing that we are running a number of OPS set ups and I had never used it. Looking further on Metalink I found the following note (Note:1071756.6)

When running "ALTER SYSTEM CHECK DATAFILES" it delivers a "STATEMENT PROCESSED" 
but there is no recorded activity. There is no alert file even though the book says there is. 
 You can do an ALTER SYSTEM CHECK DATAFILES if the database is only mounted. 
But the command does not return an error if a datafile is missing.
Solution Description:
=
The ALTER SYSTEM CHECK DATAFILES command was designed to solve a
particular problem of file accessibility.  This most often has to do
with OPS, and disks that are shared among several machines.  There are
cases where a disk may be accessible on one machine, but not another,
because of configuration or OS problems.
Imagine that you have a datafile that is marked OFFLINE.  If the disk
where that datafile lives is accessible to a particular machine in an
OPS installation, then you can bring it ONLINE.  If, however, another
machine can't get to that disk at the time you bring it ONLINE, then
that instance won't be able to verify the datafile.  Hence in that
instance, the controlfile will have the datafile listed as ONLINE, but
the datafile still will not be properly accessible and entered in the SGA.  
Explanation:

The ALTER SYSTEM CHECK DATAFILES command was designed to allow
you to correct the problem from the OS perspective and make the disk
accessible. This would then trigger the instance into recognizing this fact,
verifying the datafile, and thereby making it available to Oracle in that instance.
So the command does not quite do what might be implied by the current
documentation.  It does not verify access to all online datafiles,rather, 
it only looks at those that are now online, but which were not previously 
verified.  Once a datafile has been verified, it is considered verified for all
time, until you OFFLINE the file or until the database is dismounted in that 
instance.


I hope someone founds that useful, at least I have learnt a bit more by checking it out.
Thanks Paul for mentioning it, if only in passing.


John 



Oracle DBA
MMO2
* [EMAIL PROTECTED]
( 0113 388 6062    Desk
) 07713 066194  BT Mobile






=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: RTFM questions (formally RE: PL/SQL)

[Hallas John]

Title: RE: RTFM questions (formally RE: PL/SQL)





Kevin, 
I am afraid your post shows a distinct lack of ambition. :-)
No flames please
John


-Original Message-
From: Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 08:50
To: Multiple recipients of list ORACLE-L
Subject: RE: RTFM questions (formally RE: PL/SQL)



Don't stop posting. I'm not a DBA either. Don't have any intention of being
one. I'm an Oracle duhveloper (as people sometimes point out..LOL). I read
this list to get a better understanding of how databases 'hang together'. I
never profess to being an expert in DBA related stuff...I'm far, far from
that.


-Original Message-
Sent: 29 January 2002 22:29
To: Multiple recipients of list ORACLE-L



Thank you all for your kind replies, and I now definitely know the correct
answer to this.


Please let me reiterate that I am *not* yet an Oracle dba.  I've only been
to one class so far, for crying out loud!  Obviously it would be better for
me to just not post for a while, in any event.


No need to keep on responding to this thread.


Cheers,
JoJo



-Original Message-
Walt
Sent: Tuesday, January 29, 2002 1:46 PM
To: Multiple recipients of list ORACLE-L



I strongly suggest you not experiment with this on your production database.


--Walt


-Original Message-
Sent: Tuesday, January 29, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L



I'm a complete newbie, so I may be off-base here, but I believe that
truncating a table does not delete any data from the table.  It moves the
cursor up, thereby closing up the "empty space" where data has previously
been deleted.


--JoJo



-Original Message-
Sent: Tuesday, January 29, 2002 10:46 AM
To: Multiple recipients of list ORACLE-L



To our resident Oracle Expert who just 6 months (July 26 2001) ago posted
the following e-mail



If I remember rightly, deleting rows from the table does NOT free up
tablespace. In order to do that you have to trunctate the table (although
this of course deletes all data from the table)...I can't for the life of me
remember how you adjust the space the table is actually using after doing a
delete...(to everyone else) would an analyze work?


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


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

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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Thomas, Kevin
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Rman again. Long screen output removed/SOLVED

[Hallas John]

Title: RE: Rman again. Long screen output removed/SOLVED





Jack,
We are on 8.1.7.1 on Compaq Tru64 (5.1) and we are sure that we have done both a duplicate database and a restore using PITR

(format to_date('18-SEP-2001 01:00:00','dd-mon- HH24:MI:SS')"; 


I am not really in a position to retest at the moment but we are reasonably certain. What bug no is it and on which platform

John



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 10:10
To: Multiple recipients of list ORACLE-L
Subject: RE: Rman again. Long screen output removed/SOLVED





Hi All,


It was an Oraclebug.


The only , very workable, workaround Oracle could come up with is to set
NLS_DATE_FORMAT at Unix level and use :
set time until 'string';  (STRING BEING IN THE FORMAT OF NLS-DATE_FORMAT AT
UNIX LEVEL)


9.0.2 is supposedly fixed.



Jack





Hallas John <[EMAIL PROTECTED]>@fatcity.com on 30-01-2002 10:25:18


Please respond to [EMAIL PROTECTED]


Sent by:  [EMAIL PROTECTED]



To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:    (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Subject:  RE: Rman again. Long screen output removed


Jack,
Your date format is
 set until time  'to_date
(''29012002094700'',''ddmmhh24miss'')';
whereas one that works for me and matches the documentation is
 set until time "to_date('18-SEP-2001 01:00:00','dd-mon-
HH24:MI:SS')";



Note the difference in quotation marks which is what the RMAN error message
refers to



Try my format and see what happens



HTH



John




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 14:25
To: Multiple recipients of list ORACLE-L
Subject: RE: Rman again. Long screen output included








Hi,



That only works if the format mask is set correctly, ergo not very
flexible.






Jack








אדר יחיאל <[EMAIL PROTECTED]>@fatcity.com on 29-01-2002 14:15:22



Please respond to [EMAIL PROTECTED]



Sent by:  [EMAIL PROTECTED]






To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:    (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Subject:  RE: Rman again. Long screen output included



Hello Jack



The RMAN command  recover database;
is changed to be recover database until time '1999-03-05:11:33:00';





=
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended to be
for the use of the individual(s) or entity named above. If you are not the
intended recipient be aware that any disclosure, copying, distribution or
use of the contents of this information is prohibited. If you have received


this electronic message in error, please notify us by telephone or email
(to the numbers or address above) immediately.
=








==
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 com

OPS DBA work (was dumb question)

[Hallas John]

Title: Message



Shreeni,
 
The 
mangement of a OPS system does not require any extra skills or facilities. Areas 
that are different or need more attention from a standalone instance include the 
following :
 
Management and tuning of internode communication. 
Specifically reducing the level of pinging  - use of GC% init.ora 
variables
Requirement for different start up scripts (exclusive 
and shared modes)
Some 
additional work when duplicating databases using RMAN
Perhaps more involvement with application and sys admin 
teams to determine load balancing factors
 
I am sure there are others (probably ones I should 
be doing that I am not)
 

The 
simplest thing to remember about OPS is that there is only 1 set of datafiles 
and therefore tables, despite the number of instances that may be using those 
datafiles. This point is occasionally made to those whob
 elieve that we have a fully resilient set 
up.
 
HTH
 
John

  -Original Message-From: Shreeni 
  [mailto:[EMAIL PROTECTED]]Sent: 04 February 2002 
  00:40To: Multiple recipients of list ORACLE-LSubject: 
  Dumb question
  Hi 
  List,
   
  To ask a 
  dumb question, is there any special way to run exp/imp on Oracle Parallel
  server on Solaris ?? Is parallel server DBA different than a "regular" DBA ?? 
  :)
   
  TIA
   
  Shreeni
  Shreenivasa Raoe-Zing 
  Technologies,
  Inc..41-43 Beekman Street, 3rd FloorNew York, NY 10038.Tel:
  (212)233-9861 xt.241Fax: (212)233-9862Cell:(917)861-4966lsama@e-zingtech.com 
  *Your IT Solutions
  Provider*** *** http://www.e-zingtech.com  
  ***Under Bill s.1618 
  Title III passed by the 105th U.S. Congress this mail cannot be considered 
  spam as long as we include contact information and a remove link for removal 
  from our mailing list. To be removed from our mailing list reply with remove 
  in the subject heading and your email address in the body. Include complete 
  address and/or domain to be 
  removed.
  

 

=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: How to find out what caused job to fail?

[Hallas John]

Title: How to find out what caused job to fail?



How 
bizarre. 
Roland 
asked a question about where does he find alert log & trace files 

 
(answer  = select 
name,value from v$parameter where name like '%dest%') or check your init.ora 
file
 
at least 10 minutes before this message came to me. I 
have noticed before that I can post a message that I see on the list in about 20 
minutes , at other times it can be well over an 
hour.
 
It can be quite frustrating because you see a message 
and post a reply and then see 5 other responses at least 30 minutes before 
your's appears
John

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: 04 February 2002 
  09:05To: Multiple recipients of list ORACLE-LSubject: 
  RE: How to find out what caused job to fail?
  Hi, 
  you can find the reason in alert log or trace files.
  
-Original Message-From: Daiminger, Helmut 
[mailto:[EMAIL PROTECTED]]Sent: Monday, February 
04, 2002 4:40 PMTo: Multiple recipients of list 
ORACLE-LSubject: How to find out what caused job to 
fail?
Hi! 
Is there a way to find out, why a database job 
failed? in dba_jobs (or user_jobs), I can only see that it failed, but no 
indication of the reason why it failed. Any ideas?
This is 8.1.7 on Solaris. 
Thanks, Helmut 

=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: OPS DBA work (was dumb question)

[Hallas John]

Title: Message



Bjorn, 

I 
don't have any issues with what you say - in fact it really agrees mostly with 
what I stated. You have added 2 important factors though, better application 
knowledge and use of raw file systems.
I use 
Compaq Tru64 so that does not require raw files systems but other o/s certainly 
do.
 
I 
think you were a bit unfair to suggest that I meant you 
only needed to check a few init.ora parameters out  ( 'it is far more than 
knowing the GC_ parameters' ). I am fully aware of the need to look at freelists 
and freelist groups  -  I encompassed that in my statement 

'Management and tuning of internode communication. 
Specifically reducing the level of pinging  - use of GC% init.ora 
variables'
 
Anyway 
I don't think we are that far away from each 
other
 
Regards
 
John
 
 
 
 -Original Message-From: 
Bjørn Engsig [mailto:[EMAIL PROTECTED]]Sent: 05 February 20021
 2:25To: Multiple recipients of list ORACLE-LSubject: Re: 
OPS DBA work (was dumb question)
With the caveat, that I am a consultant and not actually a 
  DBA, I would argue very strongly, that the OPS DBA needs quite some extra
  understanding, knowledge and experience compared to one managing a single
  instance Oracle.  In particular:- Performance problems, primarily 
  due to poor application design/development, that are seen in single instance 
  are likely to be one to two orders of magnitude worse in OPS.  Hence, the 
  DBA needs a much better application understanding.- There are Oracle 
  features (e.g. free list groups) that must be used with OPS and which rarely 
  are needed single instance.- Recovery scenarios are more 
  complex- You must use raw devices (except on platforms with inhertance 
  from Digital Corp), which can add complexity- A frequent requirement 
  of OPS systems is better uptimes than for single instance, which is a very 
  non-trivial task.  The whole stack is far more complex, and even though 
  the possibility to have two or more independent nodes sound really great in 
  theory, the practical assurance, that they are in fact completely independent 
  is difficult.  And if they aren't independent, they are likely to have 
  worse uptimes than the single instance! - And I probably forgot 
  something, so it is far more than knowing the GC_ parameters, which, BTW, by 
  itself isn't that simple!- Also, BTW, note that except for a few
  things, RAC doesn't make your life easier than OPS!Thanks, 
  Bjørn.Shreeni wrote:
  





 
Hi 
John,
 
Thx for 
the input. I really appreciate it. I was just kind of stumped when I was 
asked not once but several times and places, to point out the diff between 
an OPS DBA and a "regular" DBA that I am.
 
Thanks 
again
 
Shreeni
Shreenivasa 
Raoe-Z 
ing Technologies, 
Inc..41-43 Beekman Street, 3rd FloorNew York, NY 10038.Tel:
(212)233-9861 xt.241Fax: 
(212)233-9862Cell:(917)861-4966lsama@e-zingtech.com 
*Your IT Solutions
Provider*** *** http://www.e-zingtech.com   ***Under Bill s.1618 Title III passed by the 105th U.S. 
Congress this mail cannot be considered spam as long as we include
contact information and a remove link for removal from our mailing list. To 
be removed from our mailing list reply with remove in the subject heading 
and your email address in the body. Include complete address and/or domain 
to be 
removed.

  -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf 
  Of Hallas JohnSent: Monday, February 04, 2002 4:05 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  OPS DBA work (was dumb question)
  Shreeni,
   
  The mangement of a OPS system does not require 
  any extra skills or facilities. Areas that are different or need more
  attention from a standalone instance include the following 
  :
   
  Management and tuning of internode communication. 
  Specifically reducing the level of pinging  - use of GC% init.ora 
  variables
  Requirement for different start up scripts
  (exclusive and shared modes)
  Some additional work when duplicating databases 
  using RMAN
  Perhaps more involvement with application and sys 
  admin teams to determine load balancing factors
   
  I am sure there are others (probably ones I 
  should be doing that I am not)
   
  
  The simplest thing to remember about OPS is that 
  there is only 1 set of datafiles and therefore tables, despite the number 
  of instances that may be using those datafiles. This point is 
  occasionally made to those whob elieve that we have a fully
  resilient set up.
   
  HTH
   
  John
  
-Original Message-From: Shreeni [mailto:[EMAIL PROTECTED]]Sent: 

RE: Woopeee and TWO ORA-600's!

[Hallas John]

Title: RE: Woopeee and TWO ORA-600's!





Mark
The ora600 lookup  tool on Metalink states that there is no description for this code
John
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2002 09:34
To: Multiple recipients of list ORACLE-L
Subject: Woopeee and TWO ORA-600's!



Hi Ladies and Gents,


I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an
un-named monitoring tool against it this morning, the instance crashed with
a bunch of ORA-600's in the alert log. Below are the two that appeared,
though the first turned up about 10 times concurrently:


Fri Feb 22 09:22:28 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [],
[], []


Fri Feb 22 09:22:34 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC:
ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], []


Anyone ever seen these before? I'm not going to call support as this is only
a sandbox database, so please don't tell me to call them or log a tar.. I
have enough to do today already! :(


Any feedback on these is, however, much appreciated!


Thanks


Mark


===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance



-- 
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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Woopeee and TWO ORA-600's!

[Hallas John]

Title: RE: Woopeee and TWO ORA-600's!





Mark,
Here are a couple of notes I saved on the subject


John


rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.
 
If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql has to be run. Unfortunately it does not remove all the components. Following workaround has to be used to get over the bugs.

1. Restart the database.


2. Start a different session other than the one that started the database.


3. Run initjvmaux.sql


4. Run rmjvm.sql


5. Run following SQL queries, LOG on as SYS.


--The minimum action to remove JIS trigger is running the following sql.


drop trigger JIS$ROLE_TRIGGER$;


delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED';


delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService';


delete from aurora$dyn$reg;


.


Are you sure its hanging.  Documents have said it can take up to an hour and its that statement
that tends to take the longest.  I have seen quite the variation in time depending on the system 
I am on.
-Original Message-
From: Saravana Kumar [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 11:25 PM
To: Multiple recipients of list ORACLE-L
Subject: initjvm.sql



Hi friends,
   I have problem during execution of initjvm.sql
 
The step's which i have followed.
 
1)Increased system tablespace 200 mb
2)increased the shared pool size 50mb
3)increased the java  pool size to 50mb
4)ran rmjvm.sql
5)initjvm.sql
 
While runnig initjvm.sql the script hangs while i get the
statement create or replace java system;
 


-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2002 11:08
To: Multiple recipients of list ORACLE-L
Subject: RE: Woopeee and TWO ORA-600's!



Ahh well!


I have another question following this:


I am also getting the following error on startup:


Fri Feb 22 09:33:04 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC:
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
pool","unknown object","joxs heap init","ioc_allocate_pal")


Fri Feb 22 09:33:10 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
pool","unknown object","joxs heap init","ioc_allocate_pal")
ORA-06512: at "SYS.DBMS_JAVA", line 216
ORA-06512: at line 2


Completed: alter database open


This is because I set the java_pool to 0 in my init file (we don't use
anything java related against our databases). Does anybody know how to
disable or de-install java from the database? I've taken a look at the
jvmrm.sql in RDBMS/Admin:


-- Remove some portion of the Java related data dictionary objects


-- This script must be run as a subscript of a script which sets the
-- variable jvmrmaction.
-- Possible values are
--  FULL_REMOVAL:    remove all java related objects


But can't find anything of a script that will call this? Anyone have any
ideas?


Cheers


Mark (Why do I bother?) Leith


-Original Message-
Sent: 22 February 2002 10:18
To: Multiple recipients of list ORACLE-L



Mark
The ora600 lookup  tool on Metalink states that there is no description for
this code
John
-Original Message-
Sent: 22 February 2002 09:34
To: Multiple recipients of list ORACLE-L



Hi Ladies and Gents,
I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an
un-named monitoring tool against it this morning, the instance crashed with
a bunch of ORA-600's in the alert log. Below are the two that appeared,
though the first turned up about 10 times concurrently:
Fri Feb 22 09:22:28 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC:
ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [],
[], []
Fri Feb 22 09:22:34 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC:
ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], []
Anyone ever seen these before? I'm not going to call support as this is only
a sandbox database, so please don't tell me to call them or log a tar.. I
have enough to do today already! :(
Any feedback on these is, however, much appreciated!
Thanks
Mark
===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance



--
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

RE: 8i and Veritas NetBackup

[Hallas John]

Title: RE: 8i and Veritas NetBackup





The folloiwng is a good post from Samir which I kept. It seems to cover your environment well. Hope it helps John


Hi,


In order for RMAN to work with a third party backup product the third party
vendor writes an interface to an Oracle supplied API and supplies this in
the form of a library.
Oracle supplies a default copy of the library as $ORACLE_HOME/lib/libobk.so
which has the RMAN default functionality of writing to disk only.
Installation of an RMAN media management product logically replaces this
library. How this logical replacement is done depends on several Oracle
documents and one netbackup document, most of which contradict each other.
As long as it is clear how the library is logically presented to Oracle it
doesn't matter how it is done.
The library that Oracle currently uses can be established by executing:
ldd $ORACLE_HOME/bin/oracle
This will list the libraries linked to the Oracle executable, specifically
libobk.so.
The Veritas supplied file is called libobk.so.1. Oracle thinks it is called
libobk.so, which it looks for in LD_LIBRARY_PATH. Therefore a soft link is
needed from libobk.so somewhere in LD_LIBRARY_PATH to the Netbackup supplied
libobk.so.1. This can be done with:
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
and then either:
ln -s /opt/openv/netbackup/bin/libobk.so.1 $ORACLE_HOME/lib/libobk.so
or:
cp /opt/openv/netbackup/bin/libobk.so.1 $ORACLE_HOME/lib/libobk.so.1
ln -s $ORACLE_HOME/lib/libobk.so.1 $ORACLE_HOME/lib/libobk.so
Other combinations of these links are obviously possible, but the important
thing is to be consistent. With several ORACLE_HOME's the former is
preferable, the latter becomes more relevant if a version dependency had
been discovered between RMAN and Netbackup such that each ORACLE_HOME needed
a different copy of the library.
Additionally, Oracle 8.0.5 statically links the library into the Oracle
executable, so once the executable is relinked it doesn't matter what
happens to the original library file. At 8.1.6 however the library is
THEORETICALLY dynamically linked and so always depends on finding a copy on
LD_LIBRARY_PATH. A bug in 8.1.6 (1252142) means this dynamic linking does
not work and the library still has to be statically linked to the Oracle
executable. The bug is fixed at 8.1.7.


Hope this helps.




Hi Listers,


I have a question regarding using 8i RMAN with Netbackup 3.4.
I remember on 8i one no longer needs to relink the oracle executable
when intergrate with a 3rd party backup software.  All I have to
do it change the symbolic link $ORACLE_HOME/lib/libobk.so to point
to the media management library.


Now from the Netbackup 3.4 for Oracle manual, it says on Solaris
for 8.1.6, you need to relink the oracle executable by doing:


make -f ins_rdbms.mk ioracle LLIBOBK=-lobk


So the question is should I relink or not?


Thanks for your feedback.


Rich



Nice answer Samir. As an additional note... after linking I've used the 
sbttest utility from Oracle to verify a working installation. (We're using
Netbackup with Linux and have encountered problems which Veritas is 
working on.)


The sbttest program is nice but for complete backup installation testing I
believe in performing test recoveries. I've created small test databases 
on production servers and have scripted several recovery scenarios. For our 
current situation it turns out that we can get a successful backup but 
restores are a problem. Since backups aren't any good if you can't restore 
the backup is suspect. We can restore files from tape to disk but finishing 
the recovery requires getting out of RMAN and recovering from the SQL 
prompt. We can also restore from RMAN as long as we don't have more than 2 
commands in the run { commands... } syntax. Of course this could get quite 
tedious in a multiple datafile restore scenario so we're insisting that 
Veritas fix the communication problems between RMAN, Netbackup and our tape
robot.


So I guess the object lesson from all this is that, regardless of "apparent"


linking success, it pays to be anal and thorough when it comes to validating


your backup implementation and the best way to do this is to perform some
actual recoveries.


Hi Listers,


I have a question regarding using 8i RMAN with Netbackup 3.4.
I remember on 8i one no longer needs to relink the oracle executable
when intergrate with a 3rd party backup software.  All I have to
do it change the symbolic link $ORACLE_HOME/lib/libobk.so to point
to the media management library.


Now from the Netbackup 3.4 for Oracle manual, it says on Solaris
for 8.1.6, you need to relink the oracle executable by doing:


make -f ins_rdbms.mk ioracle LLIBOBK=-lobk


So the question is should I relink or not?


Thanks for your feedback.


Rich



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2002 14:38
To: Multiple recipients of list ORACLE-L
Subject: 8i and Veritas NetBackup



Is anyone using this combinat

RE: SQL Loader:How to load data with carriage return embedded

[Hallas John]

Arul,
Interesting problem. We had a similar situation and used 
AWK instead after a bit of head-scratching.
The 
following code worked for us
 

  BEGIN{
      
  FS="`"
      
  first=0
  }
  {
      if 
  (substr($1,1,3)=="KB0"){  
  -- to identify each new record which starts with those 
  letters
      if 
  (first==1)
      
  printf("\n")
      
  printf("%s", $0)
  }
      
  else
      
  printf("%s", $0)
      if 
  (first==0)
      
  first=1
  }
  END{
      
  printf("\n")
  }
I am still interested in a sqlloader resolution to this 
problem if anyone else has one
 
John

  -Original Message-From: Arul kumar 
  [mailto:[EMAIL PROTECTED]]Sent: 23 February 2002 
  07:33To: Multiple recipients of list ORACLE-LSubject: 
  SQL Loader:How to load data with carriage return 
  embeddedHi DBAs, 
  I have a flat file with Varchar2 data spread across lines with carriage 
  return.. 
  I have tried using the following but in vain. 
  =  LOAD DATA  INFILE 
  'test.dat' "str X'0c0a'"  INTO TABLE arul.test1 FIELDS 
  TERMINATED BY "~" optionally enclosed by '"' trailing nullcols ( 
  no    , descr ) 
  = 
  where descr - Varchar2(4000) field.. 
  There is no error message(!)?? 
  Note - With the above spec. able to load only the first record with 
  carriage returns embedded. Rest of the records are skipped as bad records(!) . 

  Can anyone suggest the ways of loading it thru SQL Loader? 
  Thank you. 
  regards, Arul. 
  *DisclaimerThis 
  message (including any attachments) contains confidential information 
  intended for a specific individual and purpose, and is protected by law. 
  If you are not the intended recipient, you should delete this message 
  and are hereby notified that any disclosure, copying, or distribution of 
  thismessage, or the taking of any action based on it, is strictly 
  prohibited.*Visit 
  us at http://www.mahindrabt.com

=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: ORA-27072

[Hallas John]

Have a 
word with your sysadmin. See if I can find out what/who is using that 
file
Are 
all datafiles/control files and redo log etc owned by the same user (Oracle) and 
with the same permissions
Seems 
odd that it appears to be random across a number of files
 
HTH 

 
John

  -Original Message-From: Shibu 
  [mailto:[EMAIL PROTECTED]]Sent: 23 February 2002 
  06:18To: Multiple recipients of list ORACLE-LSubject: 
  ORA-27072
  Hi all..
   
  My database is going down frequently  
  showing this error in alertfile . This  is happening to different 
  datafiles and controlfiles.
  What are the possibilities that cause this error 
  ? How can i avoid this error ?
   
  oracle 8.1.7 in win2k 
   
   
  Errors in file 
  C:\oracle\admin\acusis\bdump\acusisCKPT.TRC:ORA-00206: error in writing 
  (block 3, # blocks 1) of controlfileORA-00202: controlfile: 
  'D:\ORADATA\CONTROL01.CTL'ORA-27072: skgfdisp: I/O errorOSD-04008: 
  WriteFile() failure, unable to write to fileO/S-Error: (OS 33) The process 
  cannot access the file because another process has locked a portion of the 
  file.
   
  regards,
   
  shibu

=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Pinning Packages in the Shared Pool??

[Hallas John]

Title: RE: Pinning Packages in the Shared Pool??





John,
I understand this still to be true or at least I have never heard anything to oppose it.
Looking at the latest book I have purchased (101 Performance Tuning) the authors do talk about the principle and state 
"many database administrators recommend pinning the key system packages as soon as the instance starts"  which whilst not written in the style of the 10 commandments does imply that they see no reason not to.

There is also a warning to balance what you load against the likelyhood of ageing other objects quicker as there is less free memory to use.

So all in all I would continue to pin large, frequently used objects subject to sufficient space in the shared_pool.


Someone else recently asked if that is the case why don't Oracle automatically pin some of these packages. I think that is a fair question but I suppose the argument against is that Oracle have no idea how much memory you have available on the server and how much you allocate to Oracle and then how much you allocate to the shared pool and so it is safer to leave it to the DBA who knows the system to manage it.

HTH


John


-Original Message-
From: orantdba [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 20:34
To: Multiple recipients of list ORACLE-L
Subject: Pinning Packages in the Shared Pool??



Hi all,


There used to be a piece of wisdom that indicated that you should
pin Large, frequently used objects in the shared pool at startup of
the database where large was defined as > 5000 bytes.  


Is this still true


There was also a list of  "Oracle Packages" that were recommended
to be pinned. That included diutil, dbms_sql, dbms_utility, and standard.
Is this still good advice?


Thanks,
John


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Function based indexes

[Hallas John]

Sergey,
 
I did 
a quick test which indicates that no special path is mentioned when using a FBI, 
instead the execution plan will show that an index is being used, which it would 
not do if a FBI had not been set up.
The 
example below shows what I mean
 
HTH
 
John
 
 

  SQL> create index john_idx1 on 
  john(spid_type);
  SQL> select spid_type from john 
  where upper(substr(spid_type,2,1)) = 'Y'
  SQL> /
  SPID_TYPE
  ---
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  Symphony 
   
  Execution Plan
  --
  0 SELECT STATEMENT 
  Optimizer=CHOOSE
  1 0 TABLE ACCESS (FULL) OF 
  'JOHN'
   
  SQL> drop index 
  john_idx1;
  Index dropped.
  SQL> create index john_idx1 on 
  john(upper(substr(spid_type,2,1)));
  Index created.
  SQL> analyze table john compute 
  statistics;
  Table analyzed.
   
  SQL> select spid_type from john 
  where upper(substr(spid_type,2,1)) = 'Y';
  SPID_TYPE
  ---
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  Symphony 
  8 rows selected.
   
  Execution Plan
  --
  0 SELECT STATEMENT 
  Optimizer=FIRST_ROWS (Cost=7 Card=96 Bytes=
  1344)
  1 0 TABLE ACCESS (BY 
  INDEX ROWID) OF 'JOHN' (Cost=7 Card=96 By  
  *FBI in 
  use
  tes=1344)
  2 1 INDEX (RANGE SCAN) 
  OF 'JOHN_IDX1' (NON-UNIQUE) (Cost=1 C  
  *FBI in 
  use
  ard=96)
   
-Original Message-From: Babich , Sergey 
[mailto:[EMAIL PROTECTED]]Sent: 26 February 2002 
20:51To: Multiple recipients of list ORACLE-LSubject: 
Function based indexes

Hi, everyone,
This may seem very simple to you, 
but what's the best way to see if a fresh FBI (sorry!) is used during the 
execution? Are they reported in the same manner to the SQL trace as other ones? 

Regards,
Sergey

=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: vxfs File System full - it's not, and it's not Oracle (I don'

[Hallas John]

Title: RE: vxfs File System full - it's not, and it's not Oracle (I don't think)





David,
Why does the SA say it is an Oracle issue? 
The error message shown refers to a LV that is full (allegedly) that happens to contain some files owned by the oracle user.

Sorry if I am being a bit dense but I am doing my best :-)


John



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 28 February 2002 16:39
To: Multiple recipients of list ORACLE-L
Subject: vxfs File System full - it's not, and it's not Oracle (I don't
think)




My sysadmin is complaining about an Oracle(?) error on our HP9000, HP_UX
v11.0, running three Oracle 8.1.7.0 instances.  His error message is as
follows:


vxfs: mesg 001: vx_nospace - /dev/vgt001/lvol1 file system full (1 block
extent)


This file system has my /u001/app/oracle.. OFA compliant stuff
on it.  A df -k shows me the following:


qe2l1:oracle /u001/app/oracle/admin/sasidist/bdump>>df -k .
/u001  (/dev/vgt001/lvol1 ) :  7096543 total allocated
Kb
   1729572 free allocated
Kb
   5366971 used allocated
Kb
    75 % allocation
used


Nothing in any of the alert logs, the databases are up and functioning with
several hundred users logged in and working away.  The sysadmin has told
damagement that it's Oracle's fault the backups aren't working (I don't
trust the tape setup, and let them think they're backing up the DBs, but
backups are run to disk and they get the compressed TAR'd result on tape -
I hope).  I have my doubts, but am thinking the error might have something
to do with OmniBack, absent Oracle.


Metalink doesn't have anything on this, and there are some questions I've
found on Google, but no answers yet.  Any input (well...almost any input)
would be appreciated


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


-- 
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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

How's the job market - UK - (slightly OT)

[Hallas John]

Title: How's the job market  - UK  - (slightly OT)





Here in the UK it has been pretty bad but from all accounts I understand there to be a bit of light at the end of the tunnel

As I have just been given notice I would appreciate anyone on the list in the UK or Europe who knows of DBA vacancies to get in touch

Thanks


John


[EMAIL PROTECTED]





Oracle DBA
MMO2
* [EMAIL PROTECTED]
( 0113 388 6062    Desk
) 07713 066194  BT Mobile






=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Number / 0

[Hallas John]

Title: RE: Number / 0






Sinardy


You are trying to create a function based index. To do so you need the query rewrite privilege
The index will still fail with a divide by 0 error (don't know why you are dividing by zero) 



AS USER 
create index wrong_logic on john(income/0)  *
ERROR at line 1:
ORA-01031: insufficient privileges


AS SYS
SQL> connect internal
Connected.
SQL> grant query rewrite to user;


AS USER
SQL> create index wrong_logic on john(income/0);
create index wrong_logic on john(income/0)
   *
ERROR at line 1:
ORA-01476: divisor is equal to zero



 1* create index wrong_logic on john(income/4)
SQL> /


Index created.


HTH


John


-Original Message-
From: Sinard Xing [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002 08:38
To: Multiple recipients of list ORACLE-L
Subject: Number / 0



Hi guys,



This is my test:



SQL> desc emp
 Name  Null?    Type
 -  

 EMPNO NOT NULL CHAR(3)
 NAME   VARCHAR2(10)
 INCOME NUMBER(5)


SQL> create index no_logic on emp(income);


Index created.


SQL> drop index no_logic;


Index dropped.


SQL> create index wrong_logic on emp(income/0);
create index wrong_logic on emp(income/0)
   *
ERROR at line 1:
ORA-01031: insufficient privileges




I don't understand why Oracle throw such exception (reply).
Do you have any idea what is Oracle doing when Oracle find out number / 0




Sinardy




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: local partition index question

[Hallas John]

Title: RE: local partition index question





This subject nicely raises an question(s) I have.


We have some tables complete with PK and FK's referencing them. We have now added a create_timestamp column to the tables and wish to partition the tables using the range (create_timestamp). No problems. 

However we canot create a PK index because, as you state Cherie, the PK does not contain the column that we have partitioned on.

What workarounds are there. I can create a unique index on the PK columns (name,id for example)but it also affects the FK that other tables use to reference this table.

How do other people sites work around this


John



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 11 March 2002 15:38
To: Multiple recipients of list ORACLE-L
Subject: Re: local partition index question




Yes, that is true.  I've seen that to be the case in our warehouse
database.


Cherie Machler
Oracle DBA
Gelco Information Network



 
    "oracle dba" 
     
    mail.com>    cc: 
    Sent by: Subject: local partition index question 
    [EMAIL PROTECTED]   
    om   
 
 
    03/11/02 08:58   
    AM   
    Please respond   
    to ORACLE-L  
 
 





Hi all,


I am new to partition and I was told the following statement and
I couldn't verify it in the doc.  Could someone please tell me if
it's true or not?


"The partition column must be included in the primary key for the resulting


unique index to be locally partitioned."


Thanks


_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx


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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: problem in creating control file?

[Hallas John]

Are you sure the sid is 
set to the new sid (TEST2) and also add a SET command in the first 
line
CREATE CONTROLFILE SET 
DATABASE "TEST2" RESETLOGS ARCHIVELOG    
 
HTH
 
John

  -Original Message-From: Bunyamin K. Karadeniz 
  [mailto:[EMAIL PROTECTED]]Sent: 12 March 2002 
  11:48To: Multiple recipients of list ORACLE-LSubject: 
  problem in creating control file?
   
  I try to clone my database . I have the datafiles on D:\yedek123 and want 
  to create the control files . 
  What I do is : 
  set oracle_sid=new_sid
   
  svrmgrl internal/
  startup nomount pfile=new_pfile
   
  CREATE CONTROLFILE  DATABASE "TEST2" RESETLOGS 
  ARCHIVELOG    MAXLOGFILES 32    
  MAXLOGMEMBERS 2    MAXDATAFILES 254    
  MAXINSTANCES 1    MAXLOGHISTORY 1815LOGFILE  
  GROUP 1 'D:\yedek123\REDO01.LOG'  SIZE 1M,  GROUP 2 
  'D:\yedek123\REDO02.LOG'  SIZE 1M,  GROUP 3 
  'D:\yedek123\REDO03.LOG'  SIZE 1MDATAFILE  
  'D:\yedek123\SYSTEM01.DBF',  'D:\yedek123\RBS01.DBF',  
  'D:\yedek123\USERS01.DBF',  'D:\yedek123\TEMP01.DBF',  
  'D:\yedek123\TOOLS01.DBF',  'D:\yedek123\INDX01.DBF',  
  'D:\yedek123\DR01.DBF'CHARACTER SET WE8ISO8859P9;
   
  But When I run the create control file script , I am encountering the 
  error below.
  CREATE CONTROLFILE  DATABASE "TEST2" RESETLOGS 
  ARCHIVELOG*ORA-01503: CREATE CONTROLFILE failedORA-01161: database 
  name TESTDB in file header does not match given name of 
  TEST2ORA-01110: data file 1: 'D:\yedek123\SYSTEM01.DBF'
  TESTDB is the original database . 
  TEST2 is new DB. 
   
  What is the problem ? 
  Thank you.
   
   
   
  Bunyamin K. 
  Karadeniz   
  Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. 
  Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 
  1217Mobile : +90 535 3357729
   
  The degree of normality in a database is inversely proportional to 
  that of its DBA.
  

=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Free scripts

[Hallas John]

Title: RE: Free scripts 





I use Tim Onion's site which has a comprehensive listing of basic DBA scripts and there is also a zip file to download the lot in one go.

www.timonions.com


John


-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: 12 March 2002 22:54
To: Multiple recipients of list ORACLE-L
Subject: Free scripts 



I try to find some scripts (PL/SQL package) to monitor my oracle database
such as tablespace, rollback segment, etc.  Does someone know a website that
has this?


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




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

RE: Poll & Questions

[Hallas John]

Title: RE: Poll & Questions





I agree the work involved in creating a representative subset of data , complete with full RI in place can be quite significant. I know there are tools in place that do some of the work (Checkmate by BitybyBit and Quest have one  - data factory I think) but these also require significant input and knowledge of the schemas.

More importantly is the performance testing aspect. I have never seen a production system that has been implemented without some unknown/unexpected bottleneck because code has not been tested with realistic volumes. I know there are options available to asisst these days  (outlines and stats to name 2) but a full size dev database is not the overhead it may seem. Disk is cheap , time is not. 

John


-Original Message-
From: Gene Sais [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2002 13:13
To: Multiple recipients of list ORACLE-L
Subject: Re: Poll & Questions



Tracy - 75 gb is nothing.  Lets see: dba hourly rate to create test from data subset of production vs. cost of 75gb disks?  Hmm, seems like a no brainer.

>>> [EMAIL PROTECTED] 03/12/02 05:43PM >>>
We currently have a production, system and development database here.  The
system and development databases are purged periodically and reloaded with
lookup data.  The developers are then responsible for entering transactional
data in both regions.  I am looking to follow the same practice for
development, however I would like to clone my production database directly to
the system test database.  The production database is ~75G.  Management does
not want to commit $ to a full sized system database.  Costs outweigh the
benefits.  I would like to sway them.  HOW?  Please give me your costs/benefits
of doing this.  In addition, what is the norm (if there can be one) in other
shops.  Does utopia exist?


ps.  One of the biggest reasons for this database would be for benchmarking,
timings, stress-testing.  I realize I can copy the production stats, but that
won't give me a good execution time.  Do others load a subset of data (say 25%)
and then extrapolate to a total time?  Is that even necessarily accurate to do?
I have my doubts.  Thanks



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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=