Which tables are in buffer cache.?

[Bunyamin K.Karadeniz]

Hi all 
gurus,
 
 I want to learn the way to ook 
at 
Which tables are in buffer 
cache./Analyzed?
Is there a system view showing these 
tables??

Thanks to All.

Bunyamin K.Karadeniz Database 
Group / Information Systems Department  HAVELSAN Ankara 
/TURKEY Tel : +903122873565 / 1681 
Mobile Tel : +90 535 3357729

Re: URGENT..not importing previous export!!!!!!!!

[nlzanen1]

Hi,

Error messages???

Not sure if it matters, but could it be that export was done with 8.0.4
binaries, and impirt tried with 8.1.5 binaries?
If I'm not mistaken you can run the catexp.sql that belongs to the 8.0.4
database (List ??)


Jack


   
  
Saurabh   
  
Sharma  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
saurabhs@fcsl   cc:   
  
td.com  Subject: URGENT..not importing previous 
export  
Sent by:   
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
02-05-2001 
  
09:45  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



hi all,
there is an urgent problem that cropped up while i had some problems with
oracle 8(version 8.0.4) database and after taking all the necessary
backups, full database exports, physical copy of database and net8 folder..
deinstalled it.
i then installed oracle 8i (version 8.1.5) and tried to import the exported
files after making the same structue(tablespace and users) as there were in
previous install.
but there is not even a single table import taking place.
will u pls help me in where i'm doing wrong.
and how i could restore the earlier export files in this new database.
here's some info that may help..

earlier version 8.0.4, sid orcl
new version 8.1.5  , sid apex
no/name of tablespace and users are exactly matching.



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

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

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

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

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

URGENT..not importing previous export!!!!!!!!

[Saurabh Sharma]

hi all,
there is an urgent problem that cropped up while 
ihad some problems with oracle 8(version 8.0.4) database and after taking 
all the necessary backups, full database exports, physical copy of database and 
net8 folder.. deinstalled it.
i then installed oracle 8i (version 8.1.5) and 
tried to import the exported files after making the same structue(tablespace and 
users) as there were in previous install.
but there is not even a single table import taking 
place. 
will u pls help me in where i'm doing 
wrong.
and how i could restore the earlier export files in 
this new database. here's some info that may help..

earlier version 8.0.4, sid orcl
new version 8.1.5 , sid apex
no/name of tablespace and users are exactly 
matching.

RE: Which tables are in buffer cache.?

[Suhen Pather]

Bunyamin,
 
You can check how many blocks are in the buffer cache for segments through
the x$bh and v$bh views.
 
Try this query,
 
select count,b.object_name from
(select count(*) count,objd from v$bh
group by objd) a, user_objects b
where a.objd=b.data_object_id 
/
 
Regards
Suhen
 
 
 

 
 Hi all gurus,

I want to learn the way to ook at 

Which tables are in buffer cache./Analyzed?

Is there a system view showing these tables??

 

Thanks to All.
 
Bunyamin K.Karadeniz
Database Group / Information Systems Department 
HAVELSAN Ankara /TURKEY
Tel : +903122873565 / 1681
Mobile Tel : +90 535 3357729
 
 

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

RE: unix command question

[Robertson Lee - lerobe]

from root (or from the starting directory you want to search from) do the
following

find . -type d 2/dev/null

Regards


Lee

 

 



-Original Message-
Sent: 02 May 2001 00:05
To: Multiple recipients of list ORACLE-L


what I would like to see is all directories...not files starting with a 
particular letter but all directories...

ls -d   - doesn't work
ls -ld p*  - doesn't work either



Roy,

You could do say ls -ld p* to list the directories starting with p.

Rgds,

raja 
--

On Tue, 01 May 2001 13:35:46  
 Roy Ferguson wrote:
what is the ls command to view only a list of directories?

ls -la lists both files and directories...I want to view only a list of 
directories...

environment is sun sparc solaris 2.6

thanks in advance

roy

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

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

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




Roy E. Ferguson II
Intel Sacramento
916-854-1123

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

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

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

UTL_FILE_DIR = in init.ora

[John Dunn]

Currectly I have specified UTL_FILE = * in my init.ora file because we
access files from several directories, including directories which are only
created at runtime.

Is it possible to specify UTL_FILE so that it gives access to all files
under a parent directory.

Or is it the case that we must specify each directory individually if we
don't use UTL_FILE= *

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

Re: DB link for nonoracle databases

[paquette stephane]

You have to setup heterogeous services.
Check in the Net8 guide under Configuring connections
to non-Oracle Databases Services.

Here what I've done to have a dblink between Oracle
816/Solaris and SQLServer 6.5 via ODBC MERANT.

Modify listener.ora to listen to hsodbc.
Add en entry in tnsnames.ora to point on hsodbc.

Create a dblink on hsodbc. 
I was able to read/write on tables on SQLServer.
Even if it's not support, I was able to run a stored
proc on SQLServer with 
dbms_hs_passthrough.execute_immediate.

The only bad thing is that all processes were frozen
on SQLServer until I log out. 



--- Deepender Kr Gupta [EMAIL PROTECTED] a
écrit :  Hi All !!
 
 I have a DBA question. Can we make a DB link for
 nonoracle databases ! The
 answer is
 'YES' , I know. But How.
 
 The documentation says you will have to use Oracle
 hetrogeneous services. There is no explaination any
 further.
 
 
 I want my Oracle database to gather data from a SQL
 server . Both are on NT.
 
 Thanks in Advance.
 
 Deepender
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Deepender Kr Gupta
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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

___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED]

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

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

RE: OT -- marketing (was Windows vs. UNIX)

[Robertson Lee - lerobe]

At the moment they are doing and I kid you not, a range of Indian themed
burgers.

Lamb Korma
Chicken Tikka Masala 
and another one.

Apart from the veggie burger, chicken sandwich and the filet-o-fish which
have been around for years and years the non-beef burgers are usually
special promotions (Chinese, Italian etc...) and are advertised for a couple
of months at a time.

Bloody cannot stand them myself..


-Original Message-
Sent: 01 May 2001 19:37
To: Multiple recipients of list ORACLE-L



Actually, Lee, you should enlighten us.  The last time I was in the U.K.
for any length of time (1998) the McD's there had far more non-beef and
even vegetarian options, which are only now catching on here.  So what can
we expect in the next few years from the enlightened McD's of Europe?

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
P: 919.466.7337
F: 919.466.7427
E: [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).


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

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

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

RE: unix command question

[Robertson Lee - lerobe]

oops, I missed off the -exec bit.

find . -type d -exec ls -ld {} \; 2/dev/null

Cheers

Lee




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

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

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

RE: X$ tables ??

[Suhen Pather]

Bunyamin,

You should be able 
to view these tablesfrom the SYS 
schema.
Regards
Suhen

  I see that there is no X$ tables in my 
  database or I can not view them . My O.S. is NT . 
  How can I view them.??
   
  Thanks
  
  
  Bunyamin K.Karadeniz 
  Database Group / Information Systems Department  
  HAVELSAN Ankara /TURKEY Tel : +903122873565 / 
  1681 Mobile Tel : +90 535 3357729
  
  

Strange report from 'vmstat'

[Sonja ehovi]

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

Anybody getting ORA-00600 [729] [space leak] on a regular base?`

[Nuno Souto]

In the alert log?
HP9K, HP-UX, Oracle 8.0.6.0.
I'm getting about 6 a day.
No apparent harm to the DB.
Metalink as usual says: can't reproduce
problem to most of these bugs.
Couldn't find a concrete fix to this anywhere.
Nope, I'm not using direct export.

TIA for any feedback.
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den

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

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

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

OFF-TOPIC: comp.databases.oracle.server

[Danisment Gazi Unal (Unal Bilisim)]

Hi,

As I understand, deja had been acquired by a company.

How to read/post messages to new usenet  including web based or Netscape
Messenger ? I could not read by Netscape Messenger.

thanks...

--
Use itrprof SQL Analyzer.

It formats SQL_TRACE/Event10046 traces and gives tuning advises.

It's web based, no download, no configuration.
Just click
http://www.unal-bilisim.com/products/itrprof/itrprof_index.html


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

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

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

Enterprise VS. Standard???

[Fred Smith]

Does anyone out there know what the best method would be to migrate from Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? It appears from the docs that the only way to migrate from Enterprise to Standard is to do an entire rebuild of the database. (Export, de-install, re-install, Build all tablespaces, etc. and Import). Is this correct? OS: Windows NT 4.0 DB: Oracle 8.1.6 Enterprise (going to Standard) Thank you. -Fred Smith Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fred Smith
  INET: [EMAIL PROTECTED]

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

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

Q: WILLING_TO_WAIT_COPY 1%

[Schoen Volker]

Hi list,

I have a problem with one of my customers databases. The value of
WILLING_TO_WAIT_COPY = 100. I have read that this value should be smaller
than 1. Parameter LOG_SIMULTANEOUS_COPIES is set to 4 in init.ora. Database
is Oracle 8.0.5 under Windows NT 4.0. Hardware is a 2 CPU machine.

Now my question:
What should I do so that WILLING_TO_WAIT_COPY  1%?

Here is the select which gives me the values.

SELECT round(a.misses/(a.gets + 0.01)*100,2) willing_to_wait_copy
FROM v$latch a, v$latchname b
WHERE b.name = 'redo copy' AND b.latch# = a.latch#;

TIA

Regards

Volker Schön
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de


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

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

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

[Koivu, Lisa]

Title: RE: V$session





It's in v$process. Here's a script that displays it that I got off this list a while ago


set linesize 2000
column logon_time format a17
column username format a16
column unix_pid format a8
column machine format a20
column client_Program format a20
set pagesize 200
select
 s.username,
 s.sid,
 s.serial#,
 to_char(p.spid) unix_pid,
 s.status,
 to_char(logon_time, 'mm/dd/yy hh24:mi:ss') logon_time,
 -- idle time
 -- days added to hours
 --( trunc(LAST_CALL_ET/86400) * 24 ) || ':' ||
 -- days separately
 substr('0'||trunc(LAST_CALL_ET/86400),-2,2) || ':' ||
 -- hours
 substr('0'||trunc(mod(LAST_CALL_ET,86400)/3600),-2,2) || ':' ||
 -- minutes
 substr('0'||trunc(mod(mod(LAST_CALL_ET,86400),3600)/60),-2,2) || ':' ||
 --seconds
 substr('0'||mod(mod(mod(LAST_CALL_ET,86400),3600),60),-2,2) idle_time,
 substr(s.program,1,20) client_program,
 s.machine,
 s.process client_process,
 s.osuser,
 substr(p.program,1,20) server_program
from v$session s, v$process p
where s.username is not null
 and p.addr = s.paddr
order by username, 2
/







Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess


[EMAIL PROTECTED]

NeoMedia

2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com http://www.neom.com 
www.paperclick.com http://www.paperclick.com 
www.qode.com http://www.qode.com 

P a p e r C l i c k . c o m http://www.paperclick.com/home.htm 




Enter Your PaperClick Code Here!






-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L
Subject: V$session



Hi
Which column in v$session indicate os process?
Thanks
-seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com


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


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

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

running unix commands from java stored procedure

[John Dunn]

Does anyone have any examples of how to run a unix command from a java
stored procedure, and returning the exit code of the unix command?

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

off topic: c, c++ and java list

[Li, Xiangli]

Title: off topic: c, c++ and java list





Hi, all
Could anyone tell me there is any list regarding C, C++ and Java ?


thanks
li

_ROW_CACHE_BUFFER_SIZE

[Mohan, Ross]

Performance/Internals Wizards!


Anyone ever play with _row_cache_buffer_size?

I am having trouble with a crappy application and out of control
packages ( too big ) and public synonyms out the ying yang. 

My 734 instance has DD cache size swells that remind me of
A Perfect Storm, except I bear zero resemblance to George Clooney.

It may be a derived parameter ( depending on shpool size, processes, etc)
but, if so, I cannot find the root parameter.

I would like to apply an init.ora bandaid to the DD cache without having
to touch the crApplication yet. Yes, it would be an indirect fix at best, 
especially given that V$LATCH_MISSES indicates it is the DD find obj
that is the problem, not the parse. sigh  How I despise public synonyms, 
developers, and  and  and sputtering into silence .

If you've played with _row_cache_buffer_size, please let me know. 

I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively
that the space/size is due to Public Synonyms. Any guidance there would
be most welcome, as well. 

Thanks!

- Ross

p.s.  I have set _row_cache_cursors to 200 ( range is 10-3300, default is
10, 
and yes i know (a) oracle says the default is fine, and (b) using
undocumented
parameters is bad ) 

|| -Original Message-
|| From: Steve Adams [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 11:00 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Oracle What savepoints are active for a given session?
|| 
|| 
|| Hi Venkata,
|| 
|| There is no V$ view or X$ table that contains this 
|| information. The only
|| solution that occurs to me is to dump the savepoints to the 
|| process trace file
|| with
|| 
|| alter session set events 'immediate trace name savepoints';
|| 
|| and then use UTL_FILE to read and parse the trace file 
|| information. Here is an
|| example of what you might get:
|| 
|| SAVEPOINT FOR CURRENT PROCESS
|| --
||flag: 0x3
||name: S3
||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082
||status: VALID, next: 3822f60
||name: S2
||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046
||status: VALID, next: 37f63ec
||name: S1
||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602
||status: VALID, next: 0
|| 
|| This process has three savepoints named S1, S2 and S3 respectively.
|| 
|| @   Regards,
|| @   Steve Adams
|| @   http://www.ixora.com.au/
|| @   http://www.christianity.net.au/
|| 
|| 
|| -Original Message-
|| Sent: Tuesday, 1 May 2001 18:20
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| HI  PLEASE SEND ME ANSWER
|| Question Title: Oracle What savepoints are active for a 
|| given session?
|| 
|| Detailed Question: Does anybody know IF and HOW can I get a list of
|| active savepoints for the current session? I need a native way, not
|| solutions based on additional application-level 
|| housekeeping. Some query
|| on the V$ tables/views would be the kind of answer I'm looking for.
|| Details: Within one stored proc I'd like to obtain a list 
|| (in any form)
|| of the savepoints issued currently in the current 
|| transaction. Example:
|| Proc A issues savepoint svA; then proc B issues savepoint 
|| svB; and then
|| proc C builds and uses a cursor having 'svA' and 'svB' as rows, or
|| something like that. Of course, there are no intervening commits or
|| rollbacks.
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Steve Adams
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
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).

RE: WILLING_TO_WAIT_COPY 1%

[Gupta, Brijesh]

Title: RE: WILLING_TO_WAIT_COPY  1%





I had the same problem. Its shows 56% on 8.0.5 database. 
But here is a thought. When I upgraded to 8.1.6 it shows 0%.


I still have one database on 8.0.5 where it shows 57%


Also this parameter LOG_SIMULTANEOUS_COPIES is gone in 8.1.6


Brijesh


-Original Message-
From: Schoen Volker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 9:24 AM
To: Multiple recipients of list ORACLE-L
Subject: Q: WILLING_TO_WAIT_COPY  1%



Hi list,


I have a problem with one of my customers databases. The value of
WILLING_TO_WAIT_COPY = 100. I have read that this value should be smaller
than 1. Parameter LOG_SIMULTANEOUS_COPIES is set to 4 in init.ora. Database
is Oracle 8.0.5 under Windows NT 4.0. Hardware is a 2 CPU machine.


Now my question:
What should I do so that WILLING_TO_WAIT_COPY  1%?


Here is the select which gives me the values.


SELECT round(a.misses/(a.gets + 0.01)*100,2) willing_to_wait_copy
FROM v$latch a, v$latchname b
WHERE b.name = 'redo copy' AND b.latch# = a.latch#;


TIA


Regards


Volker Schön
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de



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


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

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

[Dasko, Dan]

You hit the nail on the head here:

Or is it the case that we must specify each directory individually if we
don't use UTL_FILE= *

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

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

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

[Winnie_Liu]

Sound to me the same thing had happened.

He did not force a log switch after he finished back up all the datafiles
to tape.

If the required log (probably archive log) which is generated during the
hot backup of the database can no longer be found. Part of that hot backup
will be unusable.


--

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



   
 
David A.  
 
Barbour  To: Multiple recipients of list ORACLE-L 
 
dbarbour@nuce[EMAIL PROTECTED]   
 
ntrix.netcc:  
 
Sent by:  Subject: Re: Fwd: please help
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
05/02/01 07:24 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Bill,

Did you force a log switch before and after the hot backup?  Did you
backup your archive logs (or alternatively, are they available)?  Sounds
to me like you need to run
ALTER DATABASE SID RECOVER UNTIL (CANCEL, TIME, CHANGE, USING
BACKUP CONTROLFILE);

If you didn't force the log switch, be mindful that you may have to
specify one or more of the redo logs to get the requested SCN.  Did you
backup the controlfile? redo logs? initSID.ora?  orapasswd?

These are some generalities, which may or may not apply to your specific
situation.  However, given the information at hand, it's probably where
I'd start looking.

Regards.

David A. Barbour
Oracle DBA, OCP



Jonathan Gennick wrote:

 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.

 --
 Best regards,

 Jonathan Gennick
 mailto:[EMAIL PROTECTED] * 906.387.1698
 http://Gennick.com * http://MichiganWaterfalls.com *
http://MetalDrums.org

 Tuesday, May 01, 2001, 10:27:51 PM, X wrote:
 BC Hi Jonathan,

 BC I always read and like your articles in the Oracle
 BC Magazine.

 BC Could you please give me a moment of your time ..
 BC I have some couple of pressing problems and questions
 BC if you don't mind as i am under fire at work ..

 BC I have trouble with some of the Oracle databases that
 BC i manage on Sun Solaris platform, sometimes i have my
 BC shutdowns hanging and this takes a very long time to
 BC complete. Also, hanging problems with some of the sql
 BC statements. Could you lend a hand about any possible
 BC clues as to what i should do or where i should look
 BC for answers.

 BC My last question is about hotback.

 BC I ran a hot backup yesterday and tried recovering
 BC today. I was faced with an Oracle error saying system
 BC tablespace needs more recovery and that open resetlogs
 BC will get an error after automatically applying the
 BC redo logs.

 BC My backup strategy went this way,

 BC i created a backup shell script and
 BC i put all tablespaces in hotbackup mode at the same
 BC time with this syntax..

 BC select 'alter tablespace' || tablespace_name ||'begin
 BC 

RE: URGENT..not importing previous export!!!!!!!!

[Gupta, Brijesh]

" import the exported files after making the same 
structue(tablespace and users) as there were in previous 
install."

You 
don't have to create the users. The import will create it for you. Also in your 
case you don't have to create the database as the same path already exists as 
old database. 

It may 
be not importing because you have already created the users and when import file 
tries to create the user it fails and skips it.

Try 
this
-- 
create fresh 8.1.5 database
-- run 
catexp.sql
and 
import complete database.

Brijesh

  -Original Message-From: Saurabh Sharma 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 02, 2001 2:46 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  URGENT..not importing previous export
  hi all,
  there is an urgent problem that cropped up while 
  ihad some problems with oracle 8(version 8.0.4) database and after 
  taking all the necessary backups, full database exports, physical copy of 
  database and net8 folder.. deinstalled it.
  i then installed oracle 8i (version 8.1.5) and 
  tried to import the exported files after making the same structue(tablespace 
  and users) as there were in previous install.
  but there is not even a single table import 
  taking place. 
  will u pls help me in where i'm doing 
  wrong.
  and how i could restore the earlier export files 
  in this new database. here's some info that may help..
  
  earlier version 8.0.4, sid orcl
  new version 8.1.5 , sid apex
  no/name of tablespace and users are exactly 
  matching.

Re: DB link for nonoracle databases

[TCarlson]

'Oracle heterogeneous services' are purchased separately. They are services
that run on the target systems that allow Oracle to talk to them through
Net*8. We use an Oracle gateway to talk to our AS400s. For the most part,
this works well. Call your rep.


Todd Carlson
Oracle 8i Certified DBA
Bunge Corporation



   
 
Deepender Kr  
 
Gupta   To: Multiple recipients of list 
ORACLE-L   
deepender.gupta@[EMAIL PROTECTED]
 
wipro.com   cc:   
 
Sent by: Subject: DB link for nonoracle 
databases   
[EMAIL PROTECTED]   
 
   
 
   
 
05/02/2001 12:05   
 
AM 
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Hi All !!

I have a DBA question. Can we make a DB link for nonoracle databases ! The
answer is
'YES' , I know. But How.

The documentation says you will have to use Oracle
hetrogeneous services. There is no explaination any
further.


I want my Oracle database to gather data from a SQL
server . Both are on NT.

Thanks in Advance.

Deepender

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

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

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




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

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

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

RE: No listner and tns packet error

[Brijesh Lal]

Everything u have specified set correctly it was
network problem as specified by jared and I was able
to solve the problem.
Thanks for ur help

Brijesh
--- Behar, Rivaldi
[EMAIL PROTECTED] wrote:
 If ping is Ok and listener is running, try using IP
 address 
 in your tnsnames.ora instead of machine name.
 
 Rivaldi
 
 -Original Message-
 Sent: Tuesday, May 01, 2001 3:10 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Did you include this database in your listener.ora
 file? 
 
 Just a thot,
 Ruth
 - Original Message - 
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Tuesday, May 01, 2001 12:30 PM
 
 
  Hi
   I am facing one funny oracle failure. If i try to
  connect the client machine to linux oracle8i
 server I
  receive the error no listner. However when I see
 at
  linux server the listner is altready running.Again
  after sometime when I try to connect to oracle
 server
  I get same error for some time and then I get TNS
  packet failure error. After sometime I get
 connected
  to oracle server and then get disconenct after few
  minutes and again I get the same error no listner.
 I
  am totally puzzled with this problem can anyone
 help
  me in solving me this problem
  
  Looking forward for response from u all
  
  Brijesh
  
  __
  Do You Yahoo!?
  Yahoo! Auctions - buy the things you want at great
 prices
  http://auctions.yahoo.com/
  -- 
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  -- 
  Author: Brijesh Lal
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


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


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


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brijesh Lal
  INET: [EMAIL PROTECTED]

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

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

[Diana_Duncan]

Lisa,

This is unfortunately quite difficult -- and if you have any circular
dependencies it's pretty much impossible.  Otherwise, what you need to do
is follow the dependencies in the dba_constraints view.

For the drop order.
 1) Drop all of the tables for which their PK constraint is not
referenced by any FK constraints
  select constraint_name
  from user_constraints c1
  where not exists (select constraint_name
   from user_constraints c2
   where c2.r_constraint_name = c1.constraint_name)
 2) Now that you've dropped the first group, you can do the same query
again.  If you are just creating a drop script, you'll need to keep track
of the ones you've dropped so you can restrict the query.

The creation order is simpler -- you need to create all of the primary key
constraints first, then the foreign keys.

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
P: 919.466.7337
F: 919.466.7427
E: [EMAIL PROTECTED]


   

Yttri, Lisa  

lisa.yttri@cTo: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
nh.com  cc:   

Sent by: Fax to:   

root@fatcity.Subject: Constraint dependencies  

com

   

   

05/01/2001 

05:50 PM   

Please 

respond to 

ORACLE-L   

   

   





Hi -


When dropping and/or re-applying constraints for an entire schema, is there
a dictionary table that can be queried (or some other way) to determine
constraint dependencies - or do you just keep running the script until you
do not get those errors?  I would like to be able to identify the order
that the constraints should be dropped (or added) so that I can write a
script to be automated ( for example, to refresh test data from
production).


If anyone has any good ideas on how to do this, I'd really be interested in
hearing from you.


Thanks -
Lisa







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

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

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

Re: unix command question

[Dennis Taylor]

ls -ld `find * -type d -prune`

note that those are back-quotes around the find command.

If you're worried about blowing your command-line buffer, if you've got a
*lot* of directories, use:

find * -type d -prunt | xargs ls -ld


At 03:05 PM 5/1/01 -0800, you wrote:
what I would like to see is all directories...not files starting with a 
particular letter but all directories...

ls -d   - doesn't work
ls -ld p*  - doesn't work either



Roy,

You could do say ls -ld p* to list the directories starting with p.

Rgds,

raja 
--

On Tue, 01 May 2001 13:35:46  
 Roy Ferguson wrote:
what is the ls command to view only a list of directories?

ls -la lists both files and directories...I want to view only a list of 
directories...

environment is sun sparc solaris 2.6

thanks in advance

roy

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

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

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




Roy E. Ferguson II
Intel Sacramento
916-854-1123

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

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

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



Dennis Taylor

It was a book to kill time for those who liked it better dead.

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

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

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

RE: URGENT..not importing previous export!!!!!!!!

[Winnie_Liu]

What kind of error you are getting from the import?

Since you already have created the tablespaces and users in your new
database, did you put IGNORE=Y when you perform the import?

Winnie

--

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



   
   
Gupta, Brijesh   
   
Brijesh.Gupta@AirliTo: Multiple recipients of list 
ORACLE-L  
quide.com  [EMAIL PROTECTED] 
   
Sent by:cc:
   
[EMAIL PROTECTED]Subject: RE: URGENT..not importing 
previous   
export 
   
   
   
05/02/01 11:06 AM  
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   





 import the exported files after making the same  structue(tablespace and
users) as there were in previous  install.

You  don't have to create the users. The import will create it for you.
Also in your  case you don't have to create the database as the same path
already exists as  old database.

It may  be not importing because you have already created the users and
when import file  tries to create the user it fails and skips it.

Try  this
--  create fresh 8.1.5 database
-- run  catexp.sql
and  import complete database.

Brijesh
-Original Message-
Sent: Wednesday, May 02, 2001 2:46  AM
To: Multiple recipients of list ORACLE-L


hi all,
there is an urgent problem that cropped up while  i had some problems with
oracle 8(version 8.0.4) database and after  taking all the necessary
backups, full database exports, physical copy of  database and net8
folder.. deinstalled it.
i then installed oracle 8i (version 8.1.5) and  tried to import the
exported files after making the same structue(tablespace  and users) as
there were in previous install.
but there is not even a single table import  taking place.
will u pls help me in where i'm doing  wrong.
and how i could restore the earlier export files  in this new database.
here's some info that may help..

earlier version 8.0.4, sid orcl
new version 8.1.5  , sid apex
no/name of tablespace and users are exactly  matching.



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

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

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

Re: unix command question

[Dennis Taylor]

At 07:20 PM 5/1/01 -0800, you wrote:

Haven't seen this one mentioned yet:

find . -type d -print | xargs ls -ld

Jared


This one does a recursive list. The one I posted only does the current
directory. Not sure which variation the poster wanted.


Dennis Taylor

It was a book to kill time for those who liked it better dead.

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

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

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

Os block size

[Mujeeb Chowdhry]

Could someone please tell what is OS block size on solaris 8
Mujeeb 
Oracle DBA

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

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

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

Sample Scripts

[Fred Collington]

Hi, We recently lost our DBA, and as I was standing
too close to our IT manager, now I'm it. As I get
started on reading and studying, I quickly need some
scripts to monitor 'normal' stuff on 7.3.4. I'm used
to SQL as a developer, so that helps. So, do you know
of a source where I can download some quality scripts?

TIA,
Rick

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fred Collington
  INET: [EMAIL PROTECTED]

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

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

[Mark Leith]

I'm starting to feel my signature is inadequate!

Mark
(plain and simple boring me)

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 06:57
To: Multiple recipients of list ORACLE-L



Sound to me the same thing had happened.

He did not force a log switch after he finished back up all the datafiles
to tape.

If the required log (probably archive log) which is generated during the
hot backup of the database can no longer be found. Part of that hot backup
will be unusable.


--

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




David A.
Barbour  To: Multiple recipients of
list ORACLE-L
dbarbour@nuce[EMAIL PROTECTED]
ntrix.netcc:
Sent by:  Subject: Re: Fwd: please help
[EMAIL PROTECTED]
om


05/02/01 07:24
AM
Please respond
to ORACLE-L






Bill,

Did you force a log switch before and after the hot backup?  Did you
backup your archive logs (or alternatively, are they available)?  Sounds
to me like you need to run
ALTER DATABASE SID RECOVER UNTIL (CANCEL, TIME, CHANGE, USING
BACKUP CONTROLFILE);

If you didn't force the log switch, be mindful that you may have to
specify one or more of the redo logs to get the requested SCN.  Did you
backup the controlfile? redo logs? initSID.ora?  orapasswd?

These are some generalities, which may or may not apply to your specific
situation.  However, given the information at hand, it's probably where
I'd start looking.

Regards.

David A. Barbour
Oracle DBA, OCP



Jonathan Gennick wrote:

 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.

 --
 Best regards,

 Jonathan Gennick
 mailto:[EMAIL PROTECTED] * 906.387.1698
 http://Gennick.com * http://MichiganWaterfalls.com *
http://MetalDrums.org

 Tuesday, May 01, 2001, 10:27:51 PM, X wrote:
 BC Hi Jonathan,

 BC I always read and like your articles in the Oracle
 BC Magazine.

 BC Could you please give me a moment of your time ..
 BC I have some couple of pressing problems and questions
 BC if you don't mind as i am under fire at work ..

 BC I have trouble with some of the Oracle databases that
 BC i manage on Sun Solaris platform, sometimes i have my
 BC shutdowns hanging and this takes a very long time to
 BC complete. Also, hanging problems with some of the sql
 BC statements. Could you lend a hand about any possible
 BC clues as to what i should do or where i should look
 BC for answers.

 BC My last question is about hotback.

 BC I ran a hot backup yesterday and tried recovering
 BC today. I was faced with an Oracle error saying system
 BC tablespace needs more recovery and that open resetlogs
 BC will get an error after automatically applying the
 BC redo logs.

 BC My backup strategy went this way,

 BC i created a backup shell script and
 BC i put all tablespaces in hotbackup mode at the same
 BC time with this syntax..

 BC select 'alter tablespace' || tablespace_name ||'begin
 BC backup;'
 BC from dba_tablespaces
 BC where status  'INVALID';

 BC I copied my datafiles to backup using the syntax below
 BC ...

 BC !cp /u02/oradata/prod/system01.dbf/backup/prod
 BC !cp 
 BC !cp 
 BC !cp 
 BC !cp 

 BC then ended backup the same way as i began backup
 BC with the ||'end backup;'

 BC I backed up my controlfile

 BC and everything went well. Today, I restored my
 BC datafiles from backup and i was greeted with the
 BC problem i just expalined to you.

 BC I am the only dba DBA at this location
 BC and i need some advise on what to do as this is a
 BC serious issue with my supervisor.

 BC Thanks,

 BC Bill

 BC __
 BC Do You Yahoo!?
 BC Yahoo! Auctions - buy the things you want at great prices
 BC http://auctions.yahoo.com/

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

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

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

Re: V$session

[Tim Sawmiller]

The column named PROCESS.

 [EMAIL PROTECTED] 05/02/01 12:00PM 
Hi
Which column in v$session indicate os process?
Thanks
-seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com 

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

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

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

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

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

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

Virus Found in Attachment (Subject: Uniquely Weird - duplicate

[Tim Sawmiller]

Lisa, your attachment had a virus in it.  My local server detected it.  Everyone, DO 
NOT OPEN THE ATTACHMENT in emails with the Subject: Uniquely Weird - duplicate rows.

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

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

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

Re: Constraint dependencies

[Tim Sawmiller]

Basically you should drop the constraints of type 'R' first, then drop the constraints 
of type 'P' and 'U'.  See the CONSTRAINT_TYPE in the USER_CONSTRAINTS view.

 [EMAIL PROTECTED] 05/01/01 05:50PM 
Hi -

When dropping and/or re-applying constraints for an entire schema, is there
a dictionary table that can be queried (or some other way) to determine
constraint dependencies - or do you just keep running the script until you
do not get those errors?  I would like to be able to identify the order that
the constraints should be dropped (or added) so that I can write a script to
be automated ( for example, to refresh test data from production).

If anyone has any good ideas on how to do this, I'd really be interested in
hearing from you.

Thanks -
Lisa

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

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

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

RE: URGENT..not importing previous export!!!!!!!!

[William Beilstein]

Remember use ignore=yes to ignore create errors on existing tables, users. If you 
don't, the import will probably fail.

 [EMAIL PROTECTED] 05/02/01 02:06PM 
 import the exported files after making the same structue(tablespace and
users) as there were in previous install.
 
You don't have to create the users. The import will create it for you. Also
in your case you don't have to create the database as the same path already
exists as old database. 
 
It may be not importing because you have already created the users and when
import file tries to create the user it fails and skips it.
 
Try this
-- create fresh 8.1.5 database
-- run catexp.sql
and import complete database.
 
Brijesh

-Original Message-
Sent: Wednesday, May 02, 2001 2:46 AM
To: Multiple recipients of list ORACLE-L


hi all,
there is an urgent problem that cropped up while i had some problems with
oracle 8(version 8.0.4) database and after taking all the necessary backups,
full database exports, physical copy of database and net8 folder..
deinstalled it.
i then installed oracle 8i (version 8.1.5) and tried to import the exported
files after making the same structue(tablespace and users) as there were in
previous install.
but there is not even a single table import taking place. 
will u pls help me in where i'm doing wrong.
and how i could restore the earlier export files in this new database.
here's some info that may help..
 
earlier version 8.0.4, sid orcl
new version 8.1.5  , sid apex
no/name of tablespace and users are exactly matching.


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

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

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

Re: Anybody getting ORA-00600 [729] [space leak] on a regular base?`

[Riyaj_Shamsudeen]

Hi
 We had ORA-00600 [729] problem on a regular basis too. I am not sure
about your database errors, but in out database these errors are due to
audit_trail being turned on. In the PGA Ptvt. Audit Info memory chunks are
not being considered and they are being falsely identified as space leak.
If you look at the trace file and add up all the chunk sizes for the Prvt.
Audit Info chunks, you could see that they match to the bytes reported in
the ORA-600 parameter.

grep Pvt. audit info  otmxp02_ora_10424.trc |awk '{sum+=$4}END {print
sum}'

25256

From the trace file:

*** 2001.04.17.09.29.42.000
*** SESSION ID:(30.22436) 2001.04.17.09.29.42.000
 ERROR: UGA memory leak detected 25256 
**

Hope this helps!

Thanks
Riyaj Re-yas Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com


   

Nuno Souto   

[EMAIL PROTECTED]To: Multiple recipients of list 
ORACLE-L  
nd.net.au   [EMAIL PROTECTED]

Sent by: cc:   

[EMAIL PROTECTED] Subject: Anybody getting ORA-00600 
[729] [space leak] on a
 regular base?`

   

05/02/01 09:19 AM  

Please respond to  

ORACLE-L   

   

   





In the alert log?
HP9K, HP-UX, Oracle 8.0.6.0.
I'm getting about 6 a day.
No apparent harm to the DB.
Metalink as usual says: can't reproduce
problem to most of these bugs.
Couldn't find a concrete fix to this anywhere.
Nope, I'm not using direct export.

TIA for any feedback.
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den

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

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

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




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

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

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

Re: Anybody getting ORA-00600 [729] [space leak] on a regular base?`

[Mohammad Rafiq]

It is relating to incomplete/terminated export of database or any large 
table. You may check this happening to your systemOracle patch 7.3.4.5 
claims that it is fixed but it is still the problem...
Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 02 May 2001 06:19:31 -0800

In the alert log?
HP9K, HP-UX, Oracle 8.0.6.0.
I'm getting about 6 a day.
No apparent harm to the DB.
Metalink as usual says: can't reproduce
problem to most of these bugs.
Couldn't find a concrete fix to this anywhere.
Nope, I'm not using direct export.

TIA for any feedback.
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den

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

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

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

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

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

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

RE: Fwd: please help

[Glasrot, Nechama]

would it be reasonable, then to alter system archive log current, and then
back up all archived logs ... are there any pitfalls? ... thanks you

Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd. 
Boca Raton, Florida 33487 
nglasrot @seisint.com mailto:[EMAIL PROTECTED]  
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695
 


-Original Message-
Sent: Wednesday, May 02, 2001 10:25 AM
To: Multiple recipients of list ORACLE-L


Jonathan,

It would appear that your friend has hit upon one of the problems of hot
backups that everyone misses and actually Oracle recommends against.  That
is
backing up your online redo log files and doing that LAST.  The reason is
that
there are more than likely active transactions that were recorded therein
and
those logs are not available.  Can he complete the recovery, maybe if he has
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.

-- 
Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

Tuesday, May 01, 2001, 10:27:51 PM, X wrote:
BC Hi Jonathan,

BC I always read and like your articles in the Oracle
BC Magazine. 

BC Could you please give me a moment of your time ..
BC I have some couple of pressing problems and questions
BC if you don't mind as i am under fire at work ..

BC I have trouble with some of the Oracle databases that
BC i manage on Sun Solaris platform, sometimes i have my
BC shutdowns hanging and this takes a very long time to
BC complete. Also, hanging problems with some of the sql
BC statements. Could you lend a hand about any possible
BC clues as to what i should do or where i should look
BC for answers.

BC My last question is about hotback.

BC I ran a hot backup yesterday and tried recovering 
BC today. I was faced with an Oracle error saying system
BC tablespace needs more recovery and that open resetlogs
BC will get an error after automatically applying the
BC redo logs.

BC My backup strategy went this way,

BC i created a backup shell script and 
BC i put all tablespaces in hotbackup mode at the same
BC time with this syntax..

BC select 'alter tablespace' || tablespace_name ||'begin
BC backup;'
BC from dba_tablespaces
BC where status  'INVALID';

BC I copied my datafiles to backup using the syntax below
BC ...

BC !cp /u02/oradata/prod/system01.dbf/backup/prod
BC !cp 
BC !cp 
BC !cp 
BC !cp 

BC then ended backup the same way as i began backup
BC with the ||'end backup;'

BC I backed up my controlfile

BC and everything went well. Today, I restored my
BC datafiles from backup and i was greeted with the
BC problem i just expalined to you.

BC I am the only dba DBA at this location
BC and i need some advise on what to do as this is a
BC serious issue with my supervisor.

BC Thanks,

BC Bill 







BC __
BC Do You Yahoo!?
BC Yahoo! Auctions - buy the things you want at great prices
BC http://auctions.yahoo.com/


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

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

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

Re: Anybody getting ORA-00600 [729] [space leak] on a regular base?`

[Mohammad Rafiq]

That error is in their knowledge and they can check in patchset note for 
7.3.4.5 for fixes and they claim it is fixed but problem still exist
while terminating export while database goes down. We have this problem
with HP-10.20 and version 7.3.4.5

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
base?`
Date: Wed, 02 May 2001 09:30:28 -0800


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



Oracle rep told us to report ORA-600 to Oracle which would inturn help them in developing bug fixes.
HTH.
JyotiGet Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jyoti Randive
  INET: [EMAIL PROTECTED]

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

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

[Yexley Robert D SSgt AFIT/SCA]

Metalink has some really good scripts.  I'd try that (it's actually been
running half-way decent lately, you might get lucky =).

-::YEX::-
)))

-Original Message-
Sent: Wednesday, 02 May, 2001 11:37 AM
To: Multiple recipients of list ORACLE-L


Hi, We recently lost our DBA, and as I was standing
too close to our IT manager, now I'm it. As I get
started on reading and studying, I quickly need some
scripts to monitor 'normal' stuff on 7.3.4. I'm used
to SQL as a developer, so that helps. So, do you know
of a source where I can download some quality scripts?

TIA,
Rick

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fred Collington
  INET: [EMAIL PROTECTED]

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

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

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

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

OCI drivers

[Ravindra Basavaraja]

Where can I download the OCI drivers from ?I need the drivers
for Unix and NT.

Should I install the Oracle client to install the oci drivers.?

I was told that OCI drivers with JDBC connection pooling helps
to improve the performance.

Can pls anyone comment or contirubute their experience on this
topic.

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

Re: _ROW_CACHE_BUFFER_SIZE

[Jared Still]

Ross,

Is this OPS?

According to Steve Adams ( this is  how you make mail show up
in his mailbox :) that is for OPS.

Sorry, that's all I have to offer.

http://www.ixora.com.au/q+a/0008/31163237.htm

Jared

On Wednesday 02 May 2001 11:01, Mohan, Ross wrote:
 Performance/Internals Wizards!


 Anyone ever play with _row_cache_buffer_size?

 I am having trouble with a crappy application and out of control
 packages ( too big ) and public synonyms out the ying yang.

 My 734 instance has DD cache size swells that remind me of
 A Perfect Storm, except I bear zero resemblance to George Clooney.

 It may be a derived parameter ( depending on shpool size, processes, etc)
 but, if so, I cannot find the root parameter.

 I would like to apply an init.ora bandaid to the DD cache without having
 to touch the crApplication yet. Yes, it would be an indirect fix at best,
 especially given that V$LATCH_MISSES indicates it is the DD find obj
 that is the problem, not the parse. sigh  How I despise public synonyms,
 developers, and  and  and sputtering into silence .

 If you've played with _row_cache_buffer_size, please let me know.

 I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively
 that the space/size is due to Public Synonyms. Any guidance there would
 be most welcome, as well.

 Thanks!

 - Ross

 p.s.  I have set _row_cache_cursors to 200 ( range is 10-3300, default is
 10,
 and yes i know (a) oracle says the default is fine, and (b) using
 undocumented
 parameters is bad )

 || -Original Message-
 || From: Steve Adams [mailto:[EMAIL PROTECTED]]
 || Sent: Tuesday, May 01, 2001 11:00 AM
 || To: Multiple recipients of list ORACLE-L
 || Subject: RE: Oracle What savepoints are active for a given session?
 ||
 ||
 || Hi Venkata,
 ||
 || There is no V$ view or X$ table that contains this
 || information. The only
 || solution that occurs to me is to dump the savepoints to the
 || process trace file
 || with
 ||
 || alter session set events 'immediate trace name savepoints';
 ||
 || and then use UTL_FILE to read and parse the trace file
 || information. Here is an
 || example of what you might get:
 ||
 || SAVEPOINT FOR CURRENT PROCESS
 || --
 ||flag: 0x3
 ||name: S3
 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082
 ||status: VALID, next: 3822f60
 ||name: S2
 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046
 ||status: VALID, next: 37f63ec
 ||name: S1
 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602
 ||status: VALID, next: 0
 ||
 || This process has three savepoints named S1, S2 and S3 respectively.
 ||
 || @   Regards,
 || @   Steve Adams
 || @   http://www.ixora.com.au/
 || @   http://www.christianity.net.au/
 ||
 ||
 || -Original Message-
 || Sent: Tuesday, 1 May 2001 18:20
 || To: Multiple recipients of list ORACLE-L
 ||
 ||
 || HI  PLEASE SEND ME ANSWER
 || Question Title: Oracle What savepoints are active for a
 || given session?
 ||
 || Detailed Question: Does anybody know IF and HOW can I get a list of
 || active savepoints for the current session? I need a native way, not
 || solutions based on additional application-level
 || housekeeping. Some query
 || on the V$ tables/views would be the kind of answer I'm looking for.
 || Details: Within one stored proc I'd like to obtain a list
 || (in any form)
 || of the savepoints issued currently in the current
 || transaction. Example:
 || Proc A issues savepoint svA; then proc B issues savepoint
 || svB; and then
 || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or
 || something like that. Of course, there are no intervening commits or
 || rollbacks.
 ||
 || --
 || Please see the official ORACLE-L FAQ: http://www.orafaq.com
 || --
 || Author: Steve Adams
 ||   INET: [EMAIL PROTECTED]
 ||
 || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 || San Diego, California-- Public Internet access /
 || Mailing Lists
 || 
 || To REMOVE yourself from this mailing list, send an E-Mail message
 || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 || the message BODY, include a line containing: UNSUB ORACLE-L
 || (or the name of mailing list you want to be removed from).  You may
 || also send the HELP command for other information (like subscribing).
-- 
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 

standby database in managed recovery mode

[Richard Huntley]

Suggestions anyone??  I'm attempting to get a standby database to run in
managed recovery mode, so that the archived logs 
are automatically applied, however, when running the command 'recover
managed standby database' I receive the following error message:
SVRMGR recover managed standby database;
ORA-00308: cannot open archived log
'/u03/apps/oracle/admin/db/arch/1_194.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

This is after I've brought the primary and standby up to the same max recid
number in the v$log_history.  I have attempted to rebuild the standby
database and also to execute the command 'recover standby database until
cancel' after confirming that all archived log files were in the proper
location, however I'm always prompted for the next archive log which doesn't
exist yet and I can't get into managed recovery mode.  I've also went to
the primary database, forced a log switch and then applied the newest
archived log file, but that hasn't worked either.  


Richard Huntley
Software Developer
Phone: (800) 223-3732  (614) 880-1817
E-mail: [EMAIL PROTECTED]
MindLeaders (www.mindleaders.com)

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

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

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

[Steve Adams]

Hi All,

Yes, '_row_cache_buffer_size' does nothing for single instance Oracle.

There is a tip on setting '_row_cache_cursors' at
http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm on the Ixora web site.

Ross, unless you can get an ALTER SESSION SET CURRENT_SCHEMA statement in there,
the best thing for you to do would be to create private synonyms.

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


-Original Message-
Sent: Thursday, 3 May 2001 7:26
To: Multiple recipients of list ORACLE-L



Ross,

Is this OPS?

According to Steve Adams ( this is  how you make mail show up
in his mailbox :) that is for OPS.

Sorry, that's all I have to offer.

http://www.ixora.com.au/q+a/0008/31163237.htm

Jared

On Wednesday 02 May 2001 11:01, Mohan, Ross wrote:
 Performance/Internals Wizards!


 Anyone ever play with _row_cache_buffer_size?

 I am having trouble with a crappy application and out of control
 packages ( too big ) and public synonyms out the ying yang.

 My 734 instance has DD cache size swells that remind me of
 A Perfect Storm, except I bear zero resemblance to George Clooney.

 It may be a derived parameter ( depending on shpool size, processes, etc)
 but, if so, I cannot find the root parameter.

 I would like to apply an init.ora bandaid to the DD cache without having
 to touch the crApplication yet. Yes, it would be an indirect fix at best,
 especially given that V$LATCH_MISSES indicates it is the DD find obj
 that is the problem, not the parse. sigh  How I despise public synonyms,
 developers, and  and  and sputtering into silence .

 If you've played with _row_cache_buffer_size, please let me know.

 I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove conclusively
 that the space/size is due to Public Synonyms. Any guidance there would
 be most welcome, as well.

 Thanks!

 - Ross

 p.s.  I have set _row_cache_cursors to 200 ( range is 10-3300, default is
 10,
 and yes i know (a) oracle says the default is fine, and (b) using
 undocumented
 parameters is bad )

 || -Original Message-
 || From: Steve Adams [mailto:[EMAIL PROTECTED]]
 || Sent: Tuesday, May 01, 2001 11:00 AM
 || To: Multiple recipients of list ORACLE-L
 || Subject: RE: Oracle What savepoints are active for a given session?
 ||
 ||
 || Hi Venkata,
 ||
 || There is no V$ view or X$ table that contains this
 || information. The only
 || solution that occurs to me is to dump the savepoints to the
 || process trace file
 || with
 ||
 || alter session set events 'immediate trace name savepoints';
 ||
 || and then use UTL_FILE to read and parse the trace file
 || information. Here is an
 || example of what you might get:
 ||
 || SAVEPOINT FOR CURRENT PROCESS
 || --
 ||flag: 0x3
 ||name: S3
 ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082
 ||status: VALID, next: 3822f60
 ||name: S2
 ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046
 ||status: VALID, next: 37f63ec
 ||name: S1
 ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602
 ||status: VALID, next: 0
 ||
 || This process has three savepoints named S1, S2 and S3 respectively.
 ||
 || @   Regards,
 || @   Steve Adams
 || @   http://www.ixora.com.au/
 || @   http://www.christianity.net.au/
 ||
 ||
 || -Original Message-
 || Sent: Tuesday, 1 May 2001 18:20
 || To: Multiple recipients of list ORACLE-L
 ||
 ||
 || HI  PLEASE SEND ME ANSWER
 || Question Title: Oracle What savepoints are active for a
 || given session?
 ||
 || Detailed Question: Does anybody know IF and HOW can I get a list of
 || active savepoints for the current session? I need a native way, not
 || solutions based on additional application-level
 || housekeeping. Some query
 || on the V$ tables/views would be the kind of answer I'm looking for.
 || Details: Within one stored proc I'd like to obtain a list
 || (in any form)
 || of the savepoints issued currently in the current
 || transaction. Example:
 || Proc A issues savepoint svA; then proc B issues savepoint
 || svB; and then
 || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or
 || something like that. Of course, there are no intervening commits or
 || rollbacks.
 ||
 || --
 || Please see the official ORACLE-L FAQ: http://www.orafaq.com
 || --
 || Author: Steve Adams
 ||   INET: [EMAIL PROTECTED]
 ||
 || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 || San Diego, California-- Public Internet access /
 || Mailing Lists
 || 
 || To REMOVE yourself from this mailing list, send an E-Mail message
 || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 || the message BODY, include a line containing: UNSUB ORACLE-L
 || (or the name of mailing list you want to be removed from).  You may
 || also send the HELP command for other information (like 

RE: Sample Scripts

[Marianne Brooks]

Title: RE: Sample Scripts





He was the one between Rick and Rick's IT manager.


-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Sample Scripts



I'm sorry to hear that about your DBA. How did he die?


--Walt Weaver
 Bozeman, Montana, USA


-Original Message-
Sent: Wednesday, May 02, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L


Hi, We recently lost our DBA, and as I was standing
too close to our IT manager, now I'm it. As I get
started on reading and studying, I quickly need some
scripts to monitor 'normal' stuff on 7.3.4. I'm used
to SQL as a developer, so that helps. So, do you know
of a source where I can download some quality scripts?


TIA,
Rick


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fred Collington
 INET: [EMAIL PROTECTED]


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

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

[Jared Still]

Thanks Steve.

The only useful reference to this parameter is on your web site.  :)

Jared

On Wednesday 02 May 2001 14:22, Steve Adams wrote:
 Hi All,

 Yes, '_row_cache_buffer_size' does nothing for single instance Oracle.

 There is a tip on setting '_row_cache_cursors' at
 http://www.ixora.com.au/tips/tuning/row_cache_cursors.htm on the Ixora web
 site.

 Ross, unless you can get an ALTER SESSION SET CURRENT_SCHEMA statement in
 there, the best thing for you to do would be to create private synonyms.

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


 -Original Message-
 From: Jared Still [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, 3 May 2001 7:26
 To: Multiple recipients of list ORACLE-L
 Subject: Re: _ROW_CACHE_BUFFER_SIZE



 Ross,

 Is this OPS?

 According to Steve Adams ( this is  how you make mail show up
 in his mailbox :) that is for OPS.

 Sorry, that's all I have to offer.

 http://www.ixora.com.au/q+a/0008/31163237.htm

 Jared

 On Wednesday 02 May 2001 11:01, Mohan, Ross wrote:
  Performance/Internals Wizards!
 
 
  Anyone ever play with _row_cache_buffer_size?
 
  I am having trouble with a crappy application and out of control
  packages ( too big ) and public synonyms out the ying yang.
 
  My 734 instance has DD cache size swells that remind me of
  A Perfect Storm, except I bear zero resemblance to George Clooney.
 
  It may be a derived parameter ( depending on shpool size, processes, etc)
  but, if so, I cannot find the root parameter.
 
  I would like to apply an init.ora bandaid to the DD cache without having
  to touch the crApplication yet. Yes, it would be an indirect fix at best,
  especially given that V$LATCH_MISSES indicates it is the DD find obj
  that is the problem, not the parse. sigh  How I despise public
  synonyms, developers, and  and  and sputtering into silence .
 
  If you've played with _row_cache_buffer_size, please let me know.
 
  I have done a ROW_CACHE dump via ORADEBUG, but I cannot prove
  conclusively that the space/size is due to Public Synonyms. Any guidance
  there would be most welcome, as well.
 
  Thanks!
 
  - Ross
 
  p.s.  I have set _row_cache_cursors to 200 ( range is 10-3300, default is
  10,
  and yes i know (a) oracle says the default is fine, and (b) using
  undocumented
  parameters is bad )
 
  || -Original Message-
  || From: Steve Adams [mailto:[EMAIL PROTECTED]]
  || Sent: Tuesday, May 01, 2001 11:00 AM
  || To: Multiple recipients of list ORACLE-L
  || Subject: RE: Oracle What savepoints are active for a given session?
  ||
  ||
  || Hi Venkata,
  ||
  || There is no V$ view or X$ table that contains this
  || information. The only
  || solution that occurs to me is to dump the savepoints to the
  || process trace file
  || with
  ||
  || alter session set events 'immediate trace name savepoints';
  ||
  || and then use UTL_FILE to read and parse the trace file
  || information. Here is an
  || example of what you might get:
  ||
  || SAVEPOINT FOR CURRENT PROCESS
  || --
  ||flag: 0x3
  ||name: S3
  ||dba: 0x831408, sequence #: 964, record #: 12, savepoint #: 19082
  ||status: VALID, next: 3822f60
  ||name: S2
  ||dba: 0x831408, sequence #: 964, record #: 11, savepoint #: 19046
  ||status: VALID, next: 37f63ec
  ||name: S1
  ||dba: 0x831408, sequence #: 964, record #: 10, savepoint #: 18602
  ||status: VALID, next: 0
  ||
  || This process has three savepoints named S1, S2 and S3 respectively.
  ||
  || @   Regards,
  || @   Steve Adams
  || @   http://www.ixora.com.au/
  || @   http://www.christianity.net.au/
  ||
  ||
  || -Original Message-
  || Sent: Tuesday, 1 May 2001 18:20
  || To: Multiple recipients of list ORACLE-L
  ||
  ||
  || HI  PLEASE SEND ME ANSWER
  || Question Title: Oracle What savepoints are active for a
  || given session?
  ||
  || Detailed Question: Does anybody know IF and HOW can I get a list of
  || active savepoints for the current session? I need a native way, not
  || solutions based on additional application-level
  || housekeeping. Some query
  || on the V$ tables/views would be the kind of answer I'm looking for.
  || Details: Within one stored proc I'd like to obtain a list
  || (in any form)
  || of the savepoints issued currently in the current
  || transaction. Example:
  || Proc A issues savepoint svA; then proc B issues savepoint
  || svB; and then
  || proc C builds and uses a cursor having 'svA' and 'svB' as rows, or
  || something like that. Of course, there are no intervening commits or
  || rollbacks.
  ||
  || --
  || Please see the official ORACLE-L FAQ: http://www.orafaq.com
  || --
  || Author: Steve Adams
  ||   INET: [EMAIL PROTECTED]
  ||
  || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  || San Diego, California-- Public Internet access /
  || Mailing Lists
  || 

9iAS Forms Server Stability

[elkinsl]

Listers,

6i Forms Server in a test environment is crashing quite frequently, 3 to 4
times a day.

I'm relaying this question, and I'm not real familiar with the back end
configuration details, so I might be off on some things. They have an 8.1.7
test environment with 9iAS 1.0.2. Platform is HP-UX 11. 9iAS 1.0.2, I
believe that would be using Forms 6i patch 2. They are using JInitiator.
Access is via NT (sp4) clients using IE 5.5. The servlet, not CGI, approach
is being used. They are specifying connectmode as HTTP. In the test
environment, DB and 9iAS are on the same box. In production, they will be
using 4 dedicated HP D class boxes for the forms servers just as they
currently do.

Anyway, the Forms Server is going down quite a bit in the test environment,
3 or 4 times a day. They currently use Forms 5.0 in a production web
deployed environment. While there are some things that are a bit of a pain
when web deploying forms, the 5.0 Forms Server has been very stable for
them. So, there is some concern about the stability when using 9iAS with the
included Apache server along with the Forms Server for 6i.

Anyone have success or horror stories they would like to relay? Their
current thinking is to wipe everything clean, do a clean re-install (they
ran into a few road bumps during the install and wonder if a clean install
would help), and see what happens from there.

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

Re: Anybody getting ORA-00600 [729] [space leak] on a regular base?`

[Jared Still]

Space leaks = Oracle malloced memory and did not free it when done.

There is actually an init.ora event that can be set to ignore memory leaks so
you don't have to see them in your alert log.

10262, 0, Don't check for memory leaks
// *Cause:Setting this event to level one causes memory leak checking to
//be disabled.  Setting this event to any other non-zero number
//allows that number to be used as a threshold value when checking
//for memory leaks in the PGA, SGA, and UGA heaps.

Jared

On Wednesday 02 May 2001 07:19, Nuno Souto wrote:
 In the alert log?
 HP9K, HP-UX, Oracle 8.0.6.0.
 I'm getting about 6 a day.
 No apparent harm to the DB.
 Metalink as usual says: can't reproduce
 problem to most of these bugs.
 Couldn't find a concrete fix to this anywhere.
 Nope, I'm not using direct export.

 TIA for any feedback.
 Cheers
 Nuno Souto
 [EMAIL PROTECTED]
 http://www.users.bigpond.net.au/the_Den
-- 
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).

Re: Enterprise VS. Standard???

[Jared Still]

Please change the settings in your mail software so
that mail is sent out as plain text, at least for this list.

Jared

On Wednesday 02 May 2001 09:20, Fred Smith wrote:
 htmlDIV
 PFONT face=Courier NewDoes anyone out there know what the best method
 would be to migrate from BROracle 8.1.6 Enterprise Edition to Oracle
 8.1.6 Standard Edition? BRBRIt appears from the docs that the only way
 to migrate from Enterprise to BRStandard is to do an entire rebuild of
 the database.nbsp; (Export, de-install, BRre-install, Build all
 tablespaces, etc. and Import).nbsp; Is this correct? BRBROS:nbsp;
 Windows NT 4.0 BRDB:nbsp; Oracle 8.1.6nbsp; Enterprise (going to
 Standard) BRBRThank you. BR-Fred Smith /FONTBR/P/DIVbr
 clear=allhrGet your FREE download of MSN Explorer at a
 href=http://explorer.msn.com;http://explorer.msn.com/abr/p/html
-- 
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).

RE: Performance of views

[elkinsl]

Helmut,

Oracle *can* push the criteria down into the view definition in many
situations. Certain operations, though, will not allow this to happen. You
can find some info on Metalink, and, in the Oracle 8i Designing and Tuning
for Performance manual. There are other source as well. Here is a little
snippet from the Oracle 8i Designing and Tuning for Performance manual:

start
To merge the view’s query into a referencing query block in the accessing
statement, the optimizer replaces the name of the view with the names of its
base
tables in the query block and adds the condition of the view’s query’s WHERE
clause
to the accessing query block’s WHERE clause.

This optimization applies to select-project-join views, which are views that
contain
only selections, projections, and joins—that is, views that do not contain
set
operators, aggregate functions, DISTINCT, GROUP BY, CONNECT BY, and so on
(as
described in Mergeable and Non-mergeable Views on page 4-77).
end

Your best bet is to do explain plans on queries against the view(s) and
verify the access paths are optimal.

Lots more to say but I'm trying to keep this brief.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]

 Hi!

 Some of our developers are having concerns about using views in the
 application. So they approached me and wanted to clarify some of their
 issues.

 When I issues a select * from viewname, Oracle executes the underlying
 select statement of the view. This underlying statement should be
 optimized
 (using availabale indexes on tables etc.)

 If I issue a select * from viewname where condition  3 or the
 like, will
 the indexes still be used. Or how is this statement executed? Does Oracle
 first run the underlying select statement and then apply the where
 condition  3 to the returned result set? Or is the statement being
 rewritten internally?

 The Oracle documentation is not very clear on this. Any ideas would be
 appreciated.

 This is 8.1.6 on Win2k.

 Thanks,
 Helmut

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

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

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

Re: 9iAS Forms Server Stability

[Jared Still]

Larry, I haven't worked with 9iAS yet, but have set up the previous
version of iAS on Solaris with Forms 6i.

This also uses the Apache server,  Jakarta, etc, and we did not
experience the problems that you are.

Could be that 9iAS is still a bit on the bleeding edge.  :)

Also, I was using the CGI method.

Jared


On Wednesday 02 May 2001 17:05, [EMAIL PROTECTED] wrote:
 Listers,

 6i Forms Server in a test environment is crashing quite frequently, 3 to 4
 times a day.

 I'm relaying this question, and I'm not real familiar with the back end
 configuration details, so I might be off on some things. They have an 8.1.7
 test environment with 9iAS 1.0.2. Platform is HP-UX 11. 9iAS 1.0.2, I
 believe that would be using Forms 6i patch 2. They are using JInitiator.
 Access is via NT (sp4) clients using IE 5.5. The servlet, not CGI, approach
 is being used. They are specifying connectmode as HTTP. In the test
 environment, DB and 9iAS are on the same box. In production, they will be
 using 4 dedicated HP D class boxes for the forms servers just as they
 currently do.

 Anyway, the Forms Server is going down quite a bit in the test environment,
 3 or 4 times a day. They currently use Forms 5.0 in a production web
 deployed environment. While there are some things that are a bit of a pain
 when web deploying forms, the 5.0 Forms Server has been very stable for
 them. So, there is some concern about the stability when using 9iAS with
 the included Apache server along with the Forms Server for 6i.

 Anyone have success or horror stories they would like to relay? Their
 current thinking is to wipe everything clean, do a clean re-install (they
 ran into a few road bumps during the install and wonder if a clean install
 would help), and see what happens from there.

 Regards,

 Larry G. Elkins
 [EMAIL PROTECTED]
-- 
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).

Re:Fwd: please help

[Jared Still]

Dick,

Backing up the redo logs can have some serious consequences.

Let's say you are restoring the database files, and a number of
archived logs to roll forward through.

Following that, you are going to roll forward through all archived logs
that are still online, and then through your current redo logs for a 
complete recovery.

Restoring old redo logs would render this strategy ineffective.

Backing them up can be a good thing, but it would be very easy
to inadvertently wipe out the current ones when restoring from tape.

Best practice of course is to make a backup of your database in
it's current condition prior to restoring it.

It would also be prudent to make copies of the redo logs locally
so you don't have to restore them from tape.

Jared

On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote:
 Jonathan,

 It would appear that your friend has hit upon one of the problems of
 hot backups that everyone misses and actually Oracle recommends against. 
 That is backing up your online redo log files and doing that LAST.  The
 reason is that there are more than likely active transactions that were
 recorded therein and those logs are not available.  Can he complete the
 recovery, maybe if he has 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).

Re: X$ tables ??

[Jared Still]

On Wednesday 02 May 2001 08:30, Mark Leith wrote:
 You will need to either be connected as SYS or SYSDBA:

Well, you can easily remedy that.

http://www.ixora.com.au/scripts/sql/create_xviews.sql

Courtesy of Steve Adams.

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

Re: truncate a table

[Jared Still]

On Wednesday 02 May 2001 12:50, Behar, Rivaldi wrote:
 Hi,
 I want to grant to Scott to Truncate my Emp
 table (not to truncate all table).
 How can I do that ?

 Rivaldi

2 ways.

1.  grant DROP ANY TABLE to the user.  This is not recommended.

2.  create a stored procedure to truncate the table, write a wrapper for
the specific table, grant execute on the wrapper.

Below are 2 pieces of code.  The first is the simple script to set this
up and test it.  Below that is the trunc_tab procedure code, which you
will actually need to create first.

Jared

  test code for truncate wrapper


create table test_names ( name varchar2(30));

insert into test_names values( 'jared');
insert into test_names values( 'scott');

commit;

create procedure truncate_test_names
as
begin
trunc_tab('TEST_NAMES','JKSTILL');
end;
/

grant execute on truncate_test_names to scott;

  trtab.prc ---


-- jkstill 10/28/97
-- added 'towner' to specify object owner
-- this allows other users the ability to execute 
-- the 'truncate' if so desired
-- eg.  
-- create or replace procedure ced_detail_truncate
-- as
-- begin
--  ced.trunc_tab('CED_DETAIL','CED');
-- end;
-- grant execute on ced_detail_truncate to ced_dev
--

create or replace procedure trunc_tab 
   (tname varchar2, towner user_constraints.r_owner%TYPE default user,reuz 
boolean default false) as
/*-\
| Name:  Trunc_tab
| Description:   Given a table name will truncate the table.  The table is 
|assumed to be in the users schema.  As a possible
|enhancement add a table which has user table mapping,
|and check the table before any processing if the current user
|has rights to truncate the said (tname) table.
| Parameters:tname  ---  Varchar2, In ; table to be truncated
|towner ---  varchar2, In ; owner of table - default to USER 
function
|reuz   ---  Boolean,  In ; Option to reause space
| Date Written:  12-Feb-95
| Written By:Raj Pande
|---
| Mod History:
| 12-Feb-95Date Written
| 12-Feb-96Given a table, Check dependencies, disable Fk's truncate 
|  Table and then enable Fk constraints.
|  
\*-*/
lv_chld_tableuser_constraints.table_name%TYPE;
lv_chld_ownr user_constraints.r_owner%TYPE;
lv_chld_cons user_constraints.constraint_name%TYPE;
lv_parnt_consuser_constraints.r_constraint_name%TYPE;
--lv_ownr  user_constraints.r_owner%TYPE := user;
lv_ownr  user_constraints.r_owner%TYPE;
src_cursor   integer;
stmt_string  varchar2(800) ;
temp_str varchar2(200);
rc   integer;
lv_cons_countinteger;
type str_tab is table of varchar2(800)
index by binary_integer;
enb_cons_tab str_tab;
dsbl_cons_tabstr_tab;
CURSOR C_CHILD_TABS is 
 select chld.owner ownr, chld.table_name tabl, chld.constraint_name ccon,
chld.r_constraint_name crcon 
 from user_constraints parnt, all_constraints chld
 where  chld.constraint_type = 'R'
  and chld.r_constraint_name = parnt.constraint_name
  and chld.r_owner = parnt.owner
  and chld.status = 'ENABLED'
  and parnt.table_name = upper(trunc_tab.tname);
CURSOR C_CHILD_COLS is 
 SELECT column_name from all_cons_columns
 WHERE owner = lv_chld_ownr
   and table_name = lv_chld_table
   and constraint_name = lv_chld_cons;
/*\
| Subroutine: DO_DDL_DSQL
| Description: Subroutine to actually execute the dynamic sql(ddl)
\*/
PROCEDURE DO_DDL_DSQL is 
  BEGIN
dbms_output.put_line('DDL Execute ' || stmt_string);
dbms_sql.parse(src_cursor, stmt_string, dbms_sql.native);
rc := dbms_sql.execute(src_cursor);
dbms_output.put_line('Return code (DDL) is ' || rc);
  END;
/*\
| Subroutine: DO_DML_DSQL
| Description: Subroutine to actually execute the dynamic sql(ddl)
\*/
FUNCTION DO_DML_DSQL return Number is 
  BEGIN
rc := 0;
dbms_output.put_line(' DML Execute ' || stmt_string);
dbms_sql.parse(src_cursor, stmt_string, dbms_sql.native);
rc := dbms_sql.execute(src_cursor);
rc := dbms_sql.fetch_rows(src_cursor);
dbms_output.put_line('Return code (DML) is ' || rc);
return rc;
  END;
/*\
| Subroutine:   BLD_DSBL_CON.
| Description:  A subroutine to build the disabled foreign key definitions 

Re: Windows vs. UNIX (you are so ready for B*LLSH*T marketing, *!NOT!*)

[Jared Still]

On Wednesday 02 May 2001 12:51, Eric D. Pierce wrote:
 Jared,

 Apparently there are super geniuses at IBM may have invented a time
 machine (along with free underground golf planners) that explains
 the 90 days business.


The fact that these 'super geniuses' have hitched their carts
to Win2K makes them suspect.

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

Re: unix command question

[Jared Still]

Lee,

If you quit using -exec you will do yourself a big favor.

That line will fork a shell for each directory found by find.

It can be rewritten as:
  find . -type d | xargs ls -ld

Jared


On Wednesday 02 May 2001 02:05, Robertson Lee - lerobe wrote:
 oops, I missed off the -exec bit.

 find . -type d -exec ls -ld {} \; 2/dev/null

 Cheers

 Lee




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

Question re listener

[Bill Wagman]

On system A I am running oracle 8.1.7 on Solaris 5.7. I have a listener.ora 
file which specifies port 1521. I start the listener. After about 1 to 2 
minutes the PMON process registers the second listener and things look like 
this...

LSNRCTL services
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=dbis2.ucdavis.edu))
Services Summary...
dbis2 has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
dbis2 has 2 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:1022 state:ready
D000 machine: regulus, pid: 19474
(ADDRESS=(PROTOCOL=tcp)(HOST=regulus)(PORT=46895))
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The command completed successfully
LSNRCTL

The tnsnames file on system B running 8.1.6 on solaris 7 specifies port 
1521 on system A. From system B in sqlplus connect scott@dbis2 (dbis2 is on 
system a) will allow a connection immediately after the listener on system 
A is started. After the listener on system A has been running for a minute 
or two and the second listener has been started I receive the following...

SQL  connect scott@dbis2
   Enter password:
   ERROR:
   ORA-12451: TNS:nolistener
   Warning: You are no longer connected to ORACLE.

If however I now change the specified port in the tnsnames on system B to 
46895 I am able to connect.

I don't understand why the services are starting as they are and why, once 
the second service is started I am unable to connect via sqlplus. On other 
systems I look at each listener only has one service handler. The 2 service 
handlers on the second listener seems to be the problem.

I don't understand what is going on here and any help would be greatly 
appreciated.

Thanks.

Bill Wagman
Univ. of California at Davis
Information Resources
[EMAIL PROTECTED]
(530) 754-6208

-
I like to pick up hitchhikers. When they get in the car I say, 'Put on your 
seat belt. I want to try something. I saw it once in a cartoon, but I think 
I can do it.'
- Steven Wright

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

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

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

question: create schema ?

[Leslie Lu]

Hi all,

Do you have a handy way or some scripts to create a
schema which is identical to an existing schema (has
the same objects, data, grants, etc)?  Thank you.

Leslie

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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

Performance of multi datafile tablespaces

[Reardon, Bruce (CALBBAY)]

Hi,

We have a number of large tables that we want to increase the performance of
queries against.

This will be using 8171 on NT utilising the Parallel query option (PQO) on a
server with 4 CPUs.

Ideally we would like to partition the tables but due to the cost of the
partitioning option (hundreds of thousands of dollars across our 3 sites) we
have all but ruled this out for the moment.

So, what is being considered is manual striping of datafiles within
tablespaces.

That is, each tablespace will consist of multiple datafiles (4 is being
considered) with each datafile on separate hardware mirror sets.  Locally
Managed Tablespaces (LMTs) will also be used.

I am interested in feedback on this option - eg past experiences, comments,
other alternatives etc.

Also, do you know of any references / whitepapers on this topic?

So far I have found the following:
http://www.revealnet.com/newsletter/disk_io_distribution.doc
which suggests Physically stripe the temporary tablespace across multiple
disks by allocating multiple datafiles with sizes mapped to the tablespace's
extent size (so each datafile contains exactly one extent).

Metalink articles suggesting using minextent clause on tables / indexes and
the need to ensure that the objects don't fit into just 1 extent - or in our
case that the objects will require at least 4 extents.

Chapter 20 of the Oracle8i Designing and Tuning for Performance manual
(8.1.7) under Striping Disks Manually.
and such commands as ALTER TABLE ... ALLOCATE EXTENT DATAFILE '...'  but
the manual reference only refers to when the datafiles are filled by 1
object.

Thanks,
Bruce Reardon
mailto:[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

RE: Enterprise VS. Standard???

[Fred Smith]

Same exact box, same instance. On NT, I found that I can do an ORADIM -delete, deinstall the software, reinstall the new software, do and ORADIM -new, and then run u0801050.sql. Problem is it leave all of the remnants of enterprise options such as MDSYS,CTXSYS, and AURORA$ORB$UNAUTHENTICATED users. 

From: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Enterprise VS. Standard??? 
Date: Wed, 02 May 2001 08:56:54 -0800 
 
On the same box or different box? That is how I did it, of course it was a 
really small schema. 
 -Original Message- 
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Fred Smith 
 Sent: Wednesday, May 02, 2001 12:20 PM 
 To: Multiple recipients of list ORACLE-L 
 Subject: Enterprise VS. Standard??? 
 
 
 Does anyone out there know what the best method would be to migrate from 
 Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? 
 
 It appears from the docs that the only way to migrate from Enterprise to 
 Standard is to do an entire rebuild of the database. (Export, de-install, 
 re-install, Build all tablespaces, etc. and Import). Is this correct? 
 
 OS: Windows NT 4.0 
 DB: Oracle 8.1.6 Enterprise (going to Standard) 
 
 Thank you. 
 -Fred Smith 
 
 
 
 
 
-- 
 Get your FREE download of MSN Explorer at http://explorer.msn.com 
 
 
 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
Fred Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 
538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access 
/ Mailing 
Lists  
To REMOVE yourself from this mailing list, send an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
BODY, include a line containing: UNSUB ORACLE-L (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
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fred Smith
  INET: [EMAIL PROTECTED]

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

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

[Weaver, Walt]

I'm sorry to hear that about your DBA. How did he die?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Wednesday, May 02, 2001 9:37 AM
To: Multiple recipients of list ORACLE-L

Hi, We recently lost our DBA, and as I was standing
too close to our IT manager, now I'm it. As I get
started on reading and studying, I quickly need some
scripts to monitor 'normal' stuff on 7.3.4. I'm used
to SQL as a developer, so that helps. So, do you know
of a source where I can download some quality scripts?

TIA,
Rick

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fred Collington
  INET: [EMAIL PROTECTED]

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

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


 shousers.sql
 space_check.sql

RE: Enterprise VS. Standard???

[Thompson, Troy]

Hi Fred,
 
On Friday, April 20, 2001 4:21 PM,  [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  answered the same question for version 8.1.7
 
I actually did this yesterday and I seems to have worked fine on Windows
2000 for Oracle 8.1.7. I don't know if you can do this for 8.1.6 though.
 
 
Here are the instructions from [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] 
 
 
I got the following answers from Oracle support:

You can convert from Enterprise Edition to standard edition.

You need to shutdown and backup the database and software.

-- De-install 817 Enterprise Edition.

-- install 817 Standard Editon

-- start the database and run catalog.sql and catproc.sql

 
 
Hope this helps
Troy

-Original Message-
Sent: Wednesday, May 02, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L



Does anyone out there know what the best method would be to migrate from 
Oracle 8.1.6 Enterprise Edition to Oracle 8.1.6 Standard Edition? 

It appears from the docs that the only way to migrate from Enterprise to 
Standard is to do an entire rebuild of the database.  (Export, de-install, 
re-install, Build all tablespaces, etc. and Import).  Is this correct? 

OS:  Windows NT 4.0 
DB:  Oracle 8.1.6  Enterprise (going to Standard) 

Thank you. 
-Fred Smith 



  _  

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




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

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

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