date:20011026


Jay,

Could you tell me how to do this for SQL*PLUS, I'm too lazy to look now that
I've found someone that knows ;o)

Cheers,
Kev.

hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 17:56
To: Multiple recipients of list ORACLE-L


When running Sql Loader from a Unix script is there a way to code it so that
the password will not be displayed when someone does ps -ef?

I know how to do it for sqlplus, exp and imp but not sql loader.

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

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

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

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

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

RE: Oracle Reports....


Ah, right!

Ok, thanks for that Rachel, I'll have a nosey at them today... ;o)

Kev.
hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 17:56
To: Multiple recipients of list ORACLE-L


Ah but Kevin, that info stays around even if they are not running the
report at that second. so you can do a search in the tables and
look for sql that references the tables that have the reporting data in
them.

won't get you EVERYTHING you need, but it will take you at least one
step closer


--- Thomas, Kevin [EMAIL PROTECTED] wrote:
 Thanks Rachel,
 
 I'll check these tables to see what dets they hold. The problem I
 have is
 that I can't phone the user and say are you running that report,
 because
 they have a big nasty lady who will come and bite my head off if she
 thinks
 we're actually trying to help!!
 
 ;o)
 
 Kev.
 hit any user to continue
 __
 
 Kevin Thomas
 Technical Analyst
 Deregulation Services
 Calanais Ltd.
 (2nd Floor East - Weirs Building)
 Tel: 0141 568 2377
 Fax: 0141 568 2366
 http://www.calanais.com
 
 
 -Original Message-
 Sent: 25 October 2001 14:35
 To: Multiple recipients of list ORACLE-L
 
 
 you should be able to pull the queries out of v$sql, v$sqlarea and/or
 v$sqltext
 
 --- Thomas, Kevin [EMAIL PROTECTED] wrote:
  Hi all,
  
  Sorry about the non-DBA related post...but I reckon you guys will
 be
  able to
  point me in the right direction!
  
  Our client is running some Oracle Reports (v2.5) that are killing
 our
  database, in that the queries contained in them have an average hit
  rate of
  less than 2%!!! Guess what, it get's better, they don't have the
  source code
  anymore!! Is there a way of either a) re-engineering the
 executable,
  or b) a
  third party tool that will extract the queries or show the report
 in
  a text
  version (?!?).
  
  Any thoughts guru-type-people ;o)
  
  Kev.
  
  hit any user to continue
  __
  
  Kevin Thomas
  Technical Analyst
  Deregulation Services
  Calanais Ltd.
  (2nd Floor East - Weirs Building)
  Tel: 0141 568 2377
  Fax: 0141 568 2366
  http://www.calanais.com
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Thomas, Kevin
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing
  Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
 
 
 __
 Do You Yahoo!?
 Make a great connection at Yahoo! Personals.
 http://personals.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Thomas, Kevin
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list,

RE: Oracle Reports....


Thanks Raj,

Part of the problem is we don't know what queries actually belong to which
report (because the source is missing) and there are probably about 150+
users of this particular system at anytime running queries from SQL, FORMS
or REPORTS. 

Cheers,
Kev.
hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 19:11
To: Multiple recipients of list ORACLE-L


Give a try by tracing the session used by the report.

-Original Message-
Sent: 25 October 2001 16:05
To: Multiple recipients of list ORACLE-L


Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say are you running that report, because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- Thomas, Kevin [EMAIL PROTECTED] wrote:
 Hi all,
 
 Sorry about the non-DBA related post...but I reckon you guys will be
 able to
 point me in the right direction!
 
 Our client is running some Oracle Reports (v2.5) that are killing our
 database, in that the queries contained in them have an average hit
 rate of
 less than 2%!!! Guess what, it get's better, they don't have the
 source code
 anymore!! Is there a way of either a) re-engineering the executable,
 or b) a
 third party tool that will extract the queries or show the report in
 a text
 version (?!?).
 
 Any thoughts guru-type-people ;o)
 
 Kev.
 
 hit any user to continue
 __
 
 Kevin Thomas
 Technical Analyst
 Deregulation Services
 Calanais Ltd.
 (2nd Floor East - Weirs Building)
 Tel: 0141 568 2377
 Fax: 0141 568 2366
 http://www.calanais.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Thomas, Kevin
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: INITRANS storage parameter

2001-10-26 Thread Kevin Lange


 Yes you can.   But it will only be that way for new records added.  We had
the same problem on 8.0.5 .

But that should be ok.   Our problem was that , on new records, we had reads
coming thru that appeared to do full table scans while the initial inserts
were coming thru.  This, apparently, caused a problem with the tables
because locks started to build up.  When we changed our initrans to 2 on all
those tables, our locking problem went away.


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/25/01 6:10 PM

Hi,

I have 8.1.7.1 running on HP-UX.  One of my table is heavily being
updated
and I see blocking locks.  I have recalled that if I change the INITRANS
value from 1 to 2, the blocking locks should go away.  Question I have
is
can I modify it in the fly without dropping and recreating the table.

Thanks
Bing

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

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

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

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

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


There is a way of changing the prompt when doing a connect, however it's
done by running a script called connect. 
 
So instead of the usual:
 
 SQL connect user/pass@sid 
 
You would do:
 
SQL @connect user/pass@sid
 
Try this URL:
http://asktom.oracle.com/pls/ask/f?p=4950:8:214627::NO::F4950_P8_DISPLAYID,F
4950_P8_CRITERIA:928829365838,%7Bsqlprompt%7D
http://asktom.oracle.com/pls/ask/f?p=4950:8:214627::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:928829365838,%7Bsqlprompt%7D 
 
Cheers,
Kev.
hit any user to continue 
__ 

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

-Original Message-
Sent: 25 October 2001 21:15
To: Multiple recipients of list ORACLE-L


Thanks to Kevin and all that reply.
 
I noticed when doing a connect inside a session.
 
This will help.
 
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Dominican Republic
809-565-3121

-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Kevin Lange
Enviado el: Thursday, 25 October, 2001 11:10 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Instance Name in Sql Prompt


Ramon;
  In your startup directory on SQL Plus, you can automatically run a script
that will setup the environment like you want it.  Its called LOGIN.SQL.
 
Here is a copy of mine:
 
set termout on
set pagesize 0
set echo off
set feedback off
set sqlprompt ''
spool c:\temp.sql
select 'set sqlprompt '''||name||'  '';' from v$database;
spool off
@c:\temp.sql
set pagesize 35
set feedback on
set termout off

What this does is to take the name of the database from v$database and
create a temporary SQL file, then runs it.  This will set my prompt to 
 
INSTANCE_NAME  
 
where INSTANCE_NAME is the name of the database.
 
For example, if I log onto DEV then the SQLPROMPT will be
 
DEV  
 
Hope you can use it.
 
Kevin
 
p.s. ...  Remember that  this only works for the initialization of SQL Plus.
If you do a connect inside of your session then the prompt will not change.

-Original Message-
Sent: Thursday, October 25, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L


Hi Friends,
 
Excuse me for this dumb question,  how do I display the instance name in the
sql prompt.  Have 3 DB and would like to know to which one I am connected.
 
I mean something like that.
 
DBA1 
DBA2 
DB01 
 
Regards,
 
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
Dominican Republic
809-565-3121
 

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

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

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

RE: Link to DB2

2001-10-26 Thread Kevin Lange


 
Tim;
  Thanks for getting him a link to go to.  I could not find a good one
anywhere.   ALl I could think of doing was sending him the readme's off the
install disks.  

Kevin
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/25/01 6:25 PM

Out of curiosity, is the DB2 database on NT, Unix or a mainframe?  My
DB2 knowledge is more on the mainframe side and the Unix/NT
implementations may be easier to deal with...  But, that being said
 
If you need the data in a real time manner then the Transparent Gateway
may be your best bet...
 
http://technet.oracle.com/products/gateways/content.html
http://technet.oracle.com/products/gateways/content.html 
 
Alternatively, you could connect to the DB2 database from your web app
using DRDA (Basically the Net8 equivalent for DB2...  I think it stands
for Distributed Remote Database Access) and extract the information...
Process it and then store it in the Oracle database...  Last time I
dealt with this there were some third party vendors that offered ODBC
drivers but IBM did not have one that shipped with the product...  I
assume that they have probably come a long way in this area over the
last couple years...
 
Also, if this is a batch task that happens in the background on periodic
intervals, then you may be able to implement another solution...  An
example would be...  Unload the data from DB2 using whatever solutions
you have available ( i.e. a DB2 utility, QMF, a custom program ) and
place it into a flat file...  Then use SQL*Loader to load the
information into a staging table on the Oracle side...  Process the data
and insert it into the real tables and don't forget to cleanup the
staging table... 
 
:-)
 
Hope this helps...
 
Tim

-Original Message-
Sent: Thursday, October 25, 2001 5:26 PM
To: Multiple recipients of list ORACLE-L


Tim,
 
We have an oracle database(8.1.6) on NT2k and we need retrieve some
records from another database DB2 and after some processing on these
records store it in our database, these all will be doing thru an web
base application.
I am looking for the best solution to link the oracle to DB2, don't know
ODBC or JDBC will work or may be we need some gateway or third part
software, I have no idea.
 

-Original Message-
Sent: Thursday, October 25, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L



That probably depends on what you need the link for...  Can you further
define the requirement of what you are trying to do?

Tim 

PS - I have no experience with them but Oracle does offer Transparent
Gateways to other dbms platforms...  I'm not 100% sure but I think DB2
is one of them...  But depending on your needs it may be more or less
then you really need...

-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent: Thursday, October 25, 2001 4:01 PM 
To: Multiple recipients of list ORACLE-L 


List, 

What's the best solution for linking oracle to DB2 
Oracle 8.1.6 on NT2K 




Hamid Alavi 
Office 818 737-0526 
Cell818 402-1987 

The information contained in this message and any attachments is
intended 
only for the use of the individual or entity to which it is addressed,
and 
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from

disclosure under applicable law. If you have received this message in
error, 
you are prohibited from copying, distributing, or using the information.

Please contact the sender immediately by return e-mail and delete the 
original message from your system. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com  
-- 
Author: Hamid Alavi 
  INET: [EMAIL PROTECTED] 

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

The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law. If you have received
this message in error, you are prohibited from copying, distributing, or
using the information. Please contact the sender immediately by return
e-mail and delete the original message from your system.

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

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

To REMOVE

Monitoring Tool with a difference

2001-10-26 Thread Denham Eva

Title: Monitoring Tool with a difference





Hi Gurus,


Ok, I urgently require recommendations for software which can monitor a Oracle Database for a 24Hr period and create 
a report on the health of the system.
Please if anyone has used or is using software for this purpose please let me know.



TIA
Denham

RE: Speaking the same language


Lee,

No problem, I'm going to spend a little more time on this, this afternoon on
a PC with Oracle and SQL7 running side by side.. Just to get my hand in with
SS again really.. Been a while since I used it in anger :)

I think the most important listings will be of the equivalent to the Oracle
performance views, so I'll focus on those later..

-Original Message-
Lee - lerobe
Sent: Friday, October 26, 2001 08:30
To: Multiple recipients of list ORACLE-L


Mark,

If you do get anything I would love a copy please.

Hemmed in by the SQLServer is cheaper brigade.

-Original Message-
Sent: 25 October 2001 18:00
To: Multiple recipients of list ORACLE-L


Hi Djordje,

You are right in saying that the terminology within SQLServer and Sybase are
very similar - in fact I don't know of any differences.. They are both bred
from the same monster back in the days of Ashton Tate :)

I would make one change with your list:

In SQLServer and Sybase, an Oracle Tablespace is called a Database, not a
filegroup. So an Oracle schema is not a Database.

=
Oracle  SqlServer
DB2 Sybase
=
DatabaseServer
Sys schema  Primary File group
Tablespace  Database
SYSTEM tablespace   Master database
other schemas   Data File group
Temp tablespace TempDB database
Redo log file   Log file
Database block  Page
Extent  Extent (8 pages - 64K).
(multiple of blocks)Can be shared by logical objects.
SessionsProcesses
Data dictionary System catalogue
=
Data dictionary views   System catalogue tables
=
dba_objects sysobjects
dba_tab_columns syscolumns
dba_indexes sysindexes
dba_users   sysusers
dba_data_files  sysfiles
v$lock  syslocks
v$session   sysprocesses

There are a few more, but they don't jump to mind at the moment, and I'm off
home now to spend some time with my little girl :)

I'd be interested in a more complete list if you do come up with one. Maybe
I could post it to a web site? hmmm..

HTH

Mark

-Original Message-
Jankovic
Sent: Wednesday, October 24, 2001 23:10
To: Multiple recipients of list ORACLE-L


We need to communicate inside a team made of DBAs that support different
database platforms: oracle, sql*server, Sybase, adabase (Am I wrong that
sql*server and sybase terminology is pretty much the same?).  There are some
terminology differences between different databases (to start with the word
database that means different in oracle and sql*server world).  I have
tried to compile a start terminology difference list.  If you could
contribute to the list you can send an e-mail to me directly, I would
compile the list and send the compiled version to the list.  If you don't
hear back from me that probably means that the list was not very responsive
:-(.  Also, please let me know if you think some terminology is wrong in
this list.

Thanks.

Djordje Jankovic
[EMAIL PROTECTED]


Oracle  SqlServer
DB2

DatabaseServer
Schema  Database
Sys schema  Master database
Tablespace  File group
SYSTEM tablespace   Primary data file
other tablespaces   Secondary data files
Redo log file   Log file
Database block  Page
Extent  Extent (8 pages - 64K).
(multiple of blocks)  Can be shared by logical objects.
Data dictionary System catalog


Data dictionary views   System catalog tables
dba_objects sysobjects
dba_tab_columns syscolumns
dba_indexes sysindexes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Oracle Reports....


Kevin,

Can you not log in as a user yourself and run the reports that you are
interested in, then trace your own session to see what SQL is being
executed?

What I would do:

1) As the report user, run the report you are interested in.
2a) Do a select from v$sqlarea/v$sqltext/v$session to get the SQL for your
particular session.
2b) set a SQL trace up for your own session, and record what order you ran
the reports in, and try to match this up with the SQL in your trace file.

Think this will work?

Mark


-Original Message-
Kevin
Sent: Friday, October 26, 2001 09:45
To: Multiple recipients of list ORACLE-L


Thanks Raj,

Part of the problem is we don't know what queries actually belong to which
report (because the source is missing) and there are probably about 150+
users of this particular system at anytime running queries from SQL, FORMS
or REPORTS.

Cheers,
Kev.
hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 19:11
To: Multiple recipients of list ORACLE-L


Give a try by tracing the session used by the report.

-Original Message-
Sent: 25 October 2001 16:05
To: Multiple recipients of list ORACLE-L


Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say are you running that report, because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- Thomas, Kevin [EMAIL PROTECTED] wrote:
 Hi all,

 Sorry about the non-DBA related post...but I reckon you guys will be
 able to
 point me in the right direction!

 Our client is running some Oracle Reports (v2.5) that are killing our
 database, in that the queries contained in them have an average hit
 rate of
 less than 2%!!! Guess what, it get's better, they don't have the
 source code
 anymore!! Is there a way of either a) re-engineering the executable,
 or b) a
 third party tool that will extract the queries or show the report in
 a text
 version (?!?).

 Any thoughts guru-type-people ;o)

 Kev.

 hit any user to continue
 __

 Kevin Thomas
 Technical Analyst
 Deregulation Services
 Calanais Ltd.
 (2nd Floor East - Weirs Building)
 Tel: 0141 568 2377
 Fax: 0141 568 2366
 http://www.calanais.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Thomas, Kevin
   INET: [EMAIL PROTECTED]

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

RE: Concealing SQL Loader password from ps -ef

2001-10-26 Thread Disser, Arno


Rather simple. Use an OPS$ account.

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

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

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

2001-10-26 Thread G . Plivna



Maybe You could find useful such approach:

where_clause = '';
comma = ' WHERE ';
LOOP
  where_clause = comma || new_condition;
  comma = ' AND ';
END LOOP;

So in this case You don't need always WHERE in your select especially such
interesting construction like 1=1

BUT as always IT DEPENDS...

Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/



   
  
Iulian.ILIES@mob   
  
il-rom.com To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
Sent by:   cc: 
  
[EMAIL PROTECTED]   Subject: RE: Where 1 = 1
  
   
  
   
  
2001.10.26 09:55   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




I sometime used this kind of aproach when I dinamically build the WHERE
expression.
Something like this:

where_condition := ' WHERE 1 = 1 '
LOOP
   where_condition := ' AND ' || new_condition
END LOOP
The point is if there are any condition to add the first condition is
always
true so it won't affect the final where_condition. The same is when there
aren't any condition to add.
And in some cases there are really no conditions to add, thus your final
query will have only a condition like ' WHERE 1 = 1 '.

If you need to connect all the intermediate condition by OR operator
probably you will use the
WHERE 1 = 0.

I hope I'll make my point clear enough and of course is any related to your
case. Maybe if you show us the entire query, someone can tell you more
about
it.

Regards
Iulian Ilies



-Original Message-
Sent: Friday, October 26, 2001 2:20 AM
To: Multiple recipients of list ORACLE-L


**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Network Department.
**

I was monitoring a load test of my company's new
application when I came across something interesting.
One of the more monstrous queries had the following as
part of its WHERE clause: 'AND 1 = 1'

Has anyone seen this used before?  What is it supposed
to achieve?

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed Bittel
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 and
may be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking action in
reliance of the contents of this information is strictly prohibited and
may be unlawful. Mobil Rom is neither liable for the proper, complete
transmission of the information contained in this communication nor
any delay in its receipt.
**

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

RE: i need check fragmentation of index


Alex,

This script is based around an analyze index . validate structure as
mentined by Deepak

---

set verify off
set pagesize 35
set linesize 132
set pause on
set pause 'Hit enter to continue'
set feedback off
set showmode off
set echo off

set space 0
set heading off

set termout off pause off
column blsk new_value BLOCK_SIZE_K
select value / 1024 blsk
from v$parameter
where name = 'db_block_size';
set termout on pause off

PROMPT
ACCEPT USER_INPUT1 CHAR PROMPT 'Please enter a index to analyze:'
ACCEPT USER_INPUT2 CHAR PROMPT 'Please enter a owner to analyze:'
PROMPT
PROMPT Working, Please wait.
PROMPT

analyze index USER_INPUT2..USER_INPUT1 validate structure;

col ROWS_PER_KEY  format 999.99 heading '  '
col BLKS_GETS_PER_ACCESS  format 99,999.99  heading ' '

select

'Name of the index = ' || NAME,
' Height of the b-tree = ' || HEIGHT,
'Blocks allocated to the index = ' || BLOCKS,
'Number of leaf rows (values in the index) = ' || LF_ROWS,
'  Number of leaf blocks in the b-tree = ' || LF_BLKS,
'  Sum of the lengths of all the leaf rows = ' || LF_ROWS_LEN,
'Useable space in a leaf block = ' || LF_BLK_LEN,
'Number of branch rows = ' || BR_ROWS,
'Number of branch blocks in the b-tree = ' || BR_BLKS,
'Sum of lengths of all the branch blocks in the b-tree = ' || BR_ROWS_LEN,
'  Useable space in a branch block = ' || BR_BLK_LEN,
' Number of deleted leaf rows in the index = ' || DEL_LF_ROWS,
'Total length of all deleted rows in the index = ' ||
DEL_LF_ROWS_LEN,
' Number of distinct keys in the index = ' || DISTINCT_KEYS,
' How many times the most repeated key is repeated = ' ||
MOST_REPEATED_KEY,
'Total space currently allocated in the b-tree = ' || BTREE_SPACE,
'Totl space that is currently being used in the b-tree = ' || USED_SPACE,
'% of space allocated in the b-tree that is being used = ' || PCT_USED,
'  Average number of rows per distinct key = ' || ROWS_PER_KEY,
'Expected number of consistent mode block gets per row = ' ||
BLKS_GETS_PER_ACCESS
from index_stats;

col NAME format a30   fold_after
col dummy_col_0   fold_after
col dummy_col_1   fold_after
col dummy_col_2   fold_after
col LF_ROWS  format 9,999,990heading ' '
col DEL_LF_ROWS  format 9,999,990heading ' '
col BR_ROWS  format 9,999,990heading ' '
col DISTINCT_KEYSformat 9,999,990heading ' '
col MOST_REPEATED_KEYformat 9,999,990heading ' '
col ROWS_PER_KEY format 9,999,990heading ' '
col HEIGHT   format 0 fold_after heading '  '
col BLKS_GETS_PER_ACCESS format 99,999.99 fold_after heading ' '
col LF_BLK_LEN   format 9,990 fold_after heading ' '
col lf_row_size  format 990   fold_after heading '  '
col lf_row_per_blk   format 990   fold_after heading '  '
col BR_BLK_LEN   format 9,990 fold_after heading ' '
col br_row_size  format 990   fold_after heading '  '
col br_row_per_blk   format 990   fold_after heading '  '

col meg  format 999.90fold_after heading '  '
col lf_meg   format 999.90   heading '  '
col lf_meg_pct   format 99.90 fold_after heading '  '
col br_meg   format 999.90   heading '  '
col br_meg_pct   format 99.90 fold_after heading '  '
col uu_meg   format 999.90   heading '  '
col uu_meg_pct   format 99.90 fold_after heading '  '
col bt_meg   format 999.90   heading '  '
col bt_meg_pct   format 99.90 fold_after heading '  '
col btu_meg  format 999.90   heading '  '
col btu_meg_pct  format 99.90 fold_after heading '  '
col btuu_meg format 999.90   heading '  '
col btuu_meg_pct format 99.90 fold_after heading '  '
col btuub_megformat 999.90   heading '  '
col btuub_meg_pctformat 99.90 fold_after heading '  '

set pause on

select
  dummy_col_0,
 'Index Name.', NAME, ' ' dummy_col_1,
 'Leaf Rows..', LF_ROWS, ' ',
 'Leaf Block Size', LF_BLK_LEN,
 'Deleted Leaf Rows..', DEL_LF_ROWS, ' ',
 'Leaf Row Size..', LF_ROWS_LEN / LF_ROWS lf_row_size,
 'Branch Rows', BR_ROWS, ' ',
 'Leaf Rows Per Block', LF_BLK_LEN /

Oracle9i-Download

2001-10-26 Thread Nirmal Kumar Muthu Kumaran

Title: Oracle9i-Download





Hi guru's


anybody had an exp of downloading oracle 9i for nt/2000 from oracle site?


I downloaded 3 winzip files. But i'm not able open the 2nd zip file, 
i got winzip error Cannot openfile: it does not appear tobe a valid archive however 1st and 3rd are perfect.


I downloaded 2nd file(558m) itself, 3 times... i had the same problem


What shall i do, to successfully download it.


I have very eagar to practice, 9i features.


Rgds,
Nirmal.

RE: Oracle Reports....


Mark,

Yip, this sounds like a plan. As I mentioned earlier though, I don't want to
awaken the Kracken! So being sneaky and trying to get the reports is key. As
they are the client, I don't actually have access to any of there servers
that they hold the reports on, or acccess to PVCS (not that I think they
would actually have them in PVCS!!).

Kev.
hit any user to continue
__

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


-Original Message-
Sent: 26 October 2001 11:20
To: Multiple recipients of list ORACLE-L


Kevin,

Can you not log in as a user yourself and run the reports that you are
interested in, then trace your own session to see what SQL is being
executed?

What I would do:

1) As the report user, run the report you are interested in.
2a) Do a select from v$sqlarea/v$sqltext/v$session to get the SQL for your
particular session.
2b) set a SQL trace up for your own session, and record what order you ran
the reports in, and try to match this up with the SQL in your trace file.

Think this will work?

Mark


-Original Message-
Kevin
Sent: Friday, October 26, 2001 09:45
To: Multiple recipients of list ORACLE-L


Thanks Raj,

Part of the problem is we don't know what queries actually belong to which
report (because the source is missing) and there are probably about 150+
users of this particular system at anytime running queries from SQL, FORMS
or REPORTS.

Cheers,
Kev.
hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 19:11
To: Multiple recipients of list ORACLE-L


Give a try by tracing the session used by the report.

-Original Message-
Sent: 25 October 2001 16:05
To: Multiple recipients of list ORACLE-L


Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say are you running that report, because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- Thomas, Kevin [EMAIL PROTECTED] wrote:
 Hi all,

 Sorry about the non-DBA related post...but I reckon you guys will be
 able to
 point me in the right direction!

 Our client is running some Oracle Reports (v2.5) that are killing our
 database, in that the queries contained in them have an average hit
 rate of
 less than 2%!!! Guess what, it get's better, they don't have the
 source code
 anymore!! Is there a way of either a) re-engineering the executable,
 or b) a
 third party tool that will extract the queries or show the report in
 a text
 version (?!?).

 Any thoughts guru-type-people ;o)

 Kev.

 hit any user to continue
 __

 Kevin Thomas
 Technical Analyst
 Deregulation Services
 Calanais Ltd.
 (2nd Floor East - Weirs Building)
 Tel: 0141 568 2377
 Fax: 0141 568 2366
 http://www.calanais.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Thomas, Kevin
   INET: [EMAIL PROTECTED]

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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle9i-Download

2001-10-26 Thread Cale, Rick T (Richard)

Title: Oracle9i-Download



I had 
the same problem and gave up, submitted a tar to client relations and they sent 
complete 9i CD suite within a week.

Rick

  -Original Message-From: Nirmal Kumar Muthu Kumaran 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 7:45 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle9i-Download
  Hi guru's 
  anybody had an exp of downloading oracle 9i for 
  nt/2000 from oracle site? 
  I downloaded 3 winzip files. But i'm not able open 
  the 2nd zip file, i got winzip error" 
  Cannot openfile: it does not appear tobe a valid archive" however 1st and 
  3rd are perfect. 
  I downloaded 2nd file(558m) itself, 3 times... i 
  had the same problem 
  What shall i do, to successfully download 
  it. 
  I have very eagar to practice, 9i 
  features. 
  Rgds, Nirmal.

RE: ORA-04031, how to prevent fragmentation?


You can either issue an alter system flush shared pool, or increase the
value of your shared_pool_size. Another option would be to pin some or your
most used/larger packeges in to your shared pool.

HTH

Mark

-Original Message-
Sent: Friday, October 26, 2001 10:55
To: Multiple recipients of list ORACLE-L


Dear list,

we have a small database with very few users, Oracle 8.1.7, NT 4 SP5. A
NT-service holds a permanent connection and checks, if some data export are
about to be done. The database had now an uptime of several months and each
new connect raises ORA-04031. Seems to be a fragmentation problem of the
shared pool. How can I prevent that?

Thanx very much

Mit freundlichen Grüßen

i.A. Marc Blum

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

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

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


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

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

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

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

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

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

Base table of materialized views

2001-10-26 Thread Sherrie . Kubis



I have posed this question to Oracle support and have yet to receive an
understandable answer, so I thought it best to ask the experts.

I used to run under 8.1.5 with compatibility set to 8.0.  Whenever I
created a snapshot I had an underlying table snap$_ that was the physical
table residing in Oracle.  This was great because it allowed me to alter
the data with DML when I needed to (believe me, I have my reasons!).

After upgrading to 8.1.6 I set compatibility to 8.1 so that I could take
advantage of the HTML generation from SQL and probably some other features
that I can't remember immediately.   There is no longer a SNAP$_ table, but
the materialized view is actually a table with the same name.  Even though
the object is listed as a table in the data dictionary, when I try to
perform DML I get an error stating that I can't update this view.

Oracle has taken away a feature that I have come to depend on.  Does anyone
know of a workaround for this problem?

Any insights would be appreciated.

---
Sherrie Kubis
Southwest Florida Water Management District
2379 Broad Street
Brooksville FL 34604-6899

Phone:  (352) 796-7211, Ext. 4033
Fax: (352) 754-6776
Email:  Mailto:[EMAIL PROTECTED]

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

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

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


PL/SQL.
Java code only on Tomcat-Jakarta (Apache).

JP

On Thu 25. October 2001 19:16, you wrote:
 Out of curiosity, is anyone using the java engine for procedural code, or
 are most people still using PL/SQL?

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

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

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

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

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

Re: ORA-04031, how to prevent fragmentation?

2001-10-26 Thread nlzanen1



Hi,


*Pin packages into the shared pool
*enlarge the shared pool
*flush the shared pool at regular intervals
*use bind variables i.s.o hardcoded values

or a combination of those


Jack





Blum, Marc [EMAIL PROTECTED]@fatcity.com on 26-10-2001 11:55:18

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:

Dear list,

we have a small database with very few users, Oracle 8.1.7, NT 4 SP5. A
NT-service holds a permanent connection and checks, if some data export are
about to be done. The database had now an uptime of several months and each
new connect raises ORA-04031. Seems to be a fragmentation problem of the
shared pool. How can I prevent that?

Thanx very much

Mit freundlichen Grüßen

i.A. Marc Blum

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

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

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


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

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

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




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

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

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

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

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





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

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

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

Re: Oracle9i-Download

2001-10-26 Thread Rachel Carmichael


it may not be zipped -- just copy it to the name you want to use


--- Nirmal Kumar  Muthu Kumaran [EMAIL PROTECTED] wrote:
 Hi guru's
 
 anybody had an exp of downloading oracle 9i for nt/2000 from oracle
 site?
 
 I downloaded 3 winzip files. But i'm not able open the 2nd zip file, 
 i got winzip error Cannot openfile: it does not appear tobe a valid
 archive however 1st and 3rd are perfect.
 
 I downloaded 2nd file(558m) itself, 3 times... i had the same
 problem
 
 What shall i do, to successfully download it.
 
 I have very eagar to practice, 9i features.
 
 Rgds,
 Nirmal.
 


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Where is the debugger package in oracle 7 and how is it called?

2001-10-26 Thread Szecsy Tamas


Hi,

we are using TOAD for debugging Oracle PL/SQL packages. I would like to ask
if some one knows how to bringt TOAD to debug Oracle 7 PL/SQL packages.
According to the Help it can do this, on the other hand I can not seem to
find the dbms_debug package neigther in the database, nor in the
orant\rdbms73\admin directory.

TIA,

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

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

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

RE: Where 1 = 1

2001-10-26 Thread Rachel Carmichael


thanks, you sparked my memory, I KNEW I'd seen it somewhere :)

we had built a system where the users submitted the information they
wanted to select on through a form and we dynamically built the sql
statement. Since the program to build the statement always included
WHERE, by hard-coding WHERE 1=1 we were able to add the remainder of
the where clause as AND ... If there was nothing in the form, the
query still worked.


--- [EMAIL PROTECTED] wrote:
 
 Maybe You could find useful such approach:
 
 where_clause = '';
 comma = ' WHERE ';
 LOOP
   where_clause = comma || new_condition;
   comma = ' AND ';
 END LOOP;
 
 So in this case You don't need always WHERE in your select especially
 such
 interesting construction like 1=1
 
 BUT as always IT DEPENDS...
 
 Gints Plivna
 IT Sistçmas, Meríeïa 13, LV1050 Rîga
 http://www.itsystems.lv/gints/
 
 
 
  

 Iulian.ILIES@mob 

 il-rom.com To: Multiple
 recipients of list ORACLE-L [EMAIL PROTECTED]   
 Sent by:   cc:   

 [EMAIL PROTECTED]   Subject: RE: Where 1 =
 1  
  

  

 2001.10.26 09:55 

 Please respond   

 to ORACLE-L  

  

  

 
 
 
 
 I sometime used this kind of aproach when I dinamically build the
 WHERE
 expression.
 Something like this:
 
 where_condition := ' WHERE 1 = 1 '
 LOOP
where_condition := ' AND ' || new_condition
 END LOOP
 The point is if there are any condition to add the first condition is
 always
 true so it won't affect the final where_condition. The same is when
 there
 aren't any condition to add.
 And in some cases there are really no conditions to add, thus your
 final
 query will have only a condition like ' WHERE 1 = 1 '.
 
 If you need to connect all the intermediate condition by OR operator
 probably you will use the
 WHERE 1 = 0.
 
 I hope I'll make my point clear enough and of course is any related
 to your
 case. Maybe if you show us the entire query, someone can tell you
 more
 about
 it.
 
 Regards
 Iulian Ilies
 
 
 
 -Original Message-
 Sent: Friday, October 26, 2001 2:20 AM
 To: Multiple recipients of list ORACLE-L
 
 

**
 This email has been tested for viruses by F-Secure Antivirus
 administered by IT Network Department.

**
 
 I was monitoring a load test of my company's new
 application when I came across something interesting.
 One of the more monstrous queries had the following as
 part of its WHERE clause: 'AND 1 = 1'
 
 Has anyone seen this used before?  What is it supposed
 to achieve?
 
 __
 Do You Yahoo!?
 Make a great connection at Yahoo! Personals.
 http://personals.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ed Bittel
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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 and
 may be legally privileged. It is intended solely for the use of the
 individual or entity to whom it is addressed and others authorised to
 receive it. If you are not the intended recipient you are hereby
 notified that any disclosure, copying, distribution

negative value in v$shared_server

2001-10-26 Thread Adams, Matthew (GEA, 088130)

Title: negative value in v$shared_server





Does Oracle still show negative numbers in some
of the v$ tables if the values go above 2 billion
in version 8.0.5? 
(the old signed vs. unsigned 32 bit integer problem)


I though they fixed all those issues in 7.3 or 8.0.3,
but I'm getting reports of the BUSY column in v$shared_server
coming up negative.


Anybody else seen it?


Matt 'I'm off to investigate' Adams

Matt Adams - GE Appliances - [EMAIL PROTECTED]
It will make sense when you stop thinking logically,
and start thinking Oracle-ly - Jim Droppa

RE: Unable to rebuild database from hot backup

2001-10-26 Thread Robert Pegram


Tim,

 You can not simply cancel a recover
 database using backup
 controlfile since Oracle is expecting you perform a
 complete recovery (
 since your not using the UNTIL CANCEL/TIME/CHANGE )
 and canceling a complete
 recovery leaves the stop SCN in the controlfile at
 infinity...  Therefore,
 the recovery is never complete and you will always
 receive the needs media
 recovery message...  

I don't think this is 100% true for every situation. 
I am no recovery expert, but I just did this the other
day, and to verify it, I ran the test again this
morning.  

1.  Shutdown abort
2.  Delete all current controlfiles
3.  Replaced the binary controlfiles from last hot
backup (they were copied as part of the backup script)
4.  Startup mount
5.  Recover database using backup controlfile
6.  Kept applying logs - only trick was that the last
log was an online redo log, so I had to type in that
log explicitly.  There I received the message Media
Recover Complete.
7.  Alter database open resetlogs.

Rob Pegram
Oracle Certified DBA

SVRMGR shutdown abort
ORACLE instance shut down.
SVRMGR startup mount
ORACLE instance started.

SVRMGR alter database open
 2 ;
alter database open
*
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
ORA-01207: file is more recent than controlfile - old
controlfile

SVRMGR recover database using backup controlfile;
ORA-00279: change 546459 generated at 10/26/2001
06:59:20 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\ORADATA\ORCL\ARCHIVE\ORCLT001S00015.ARC
ORA-00280: change 546459 for thread 1 is in sequence
#15
Specify log: {RET=suggested | filename | AUTO |
CANCEL}

Log applied.

.. cut ...

ORA-00280: change 566491 for thread 1 is in sequence
#21
Specify log: {RET=suggested | filename | AUTO |
CANCEL}
c:\oracle\oradata\orcl\redo02.log
Log applied.
Media recovery complete.

SVRMGR alter database open resetlogs;
Statement processed.


--- Johnston, Tim [EMAIL PROTECTED] wrote:
 My understanding the when you perform a recover
 database using backup
 controlfile, the stop SCN in the controlfile is set
 to infinity...
 Therefore, you never finish media recovery since
 you never encounter the
 stop SCN...  You can not simply cancel a recover
 database using backup
 controlfile since Oracle is expecting you perform a
 complete recovery (
 since your not using the UNTIL CANCEL/TIME/CHANGE )
 and canceling a complete
 recovery leaves the stop SCN in the controlfile at
 infinity...  Therefore,
 the recovery is never complete and you will always
 receive the needs media
 recovery message...  But, if you recover using
 backup controlfile until
 cancel and then cancel, that is the signal to
 Oracle that your are
 performing an incomplete recovery and the stop SCN
 in the controlfile is set
 to the SCN you have recovered through...  At this
 point you can do an alter
 open resetlogs to open the database ( as long as you
 have applied enough
 logs to insure a consistent database )...
 
 Tim
 
 -Original Message-
 Sent: Thursday, October 25, 2001 10:15 PM
 To: Multiple recipients of list ORACLE-L
 
 
 maybe the problem was never in the file but in the
 controlfile in the
 backup?
 
 standby assumes that the scn in the datafile header
 will be out of date
 and that you will be recovering up to or past the
 scn in the standby
 controlfile and that that is okay.
 
 
 --- Miller, Jay [EMAIL PROTECTED]
 wrote:
  Another piece of information:
  
  On the basis of it couldn't hurt to try I
 recopied everything but
  instead
  of using the regular control file I used the
 standby control file.  I
  then
  mounted it in standby mode, issued the recover
 standby database
  command,
  activated the standby, shutdown, and opened the
 database.  It worked
  fine.
  
  Why would it work with a standby controlfile and
 not with the regular
  control file?  I have my QC database working but
 I'm really puzzled.
  
  Jay Miller
  
  -Original Message-
  Sent: Thursday, October 25, 2001 7:05 PM
  To: Multiple recipients of list ORACLE-L
  
  
  Okay, this is weird.
  
  I'm trying to rebuilding my QC database from a hot
 backup.  As
  always, I
  copied all the hot backup files, all the archive
 logs from the period
  of the
  hot backup and the control files.
  
  After doing
  recover database using backup controlfile;
  
  I got 
  SVRMGR alter database open resetlogs;
  alter database open resetlogs
  *
  ORA-01113: file 1 needs media recovery
  ORA-01110: data file 1:
 '/data1/nyccp/systnyccp.dbf
  
  Thinking that perhaps I just needed to apply more
 logs I went on to
  apply
  another 12 hours worth of archive logs.  I still
 get the same error. 
  
  
  Now I'm really concerned that my hot backup is
 invalid for some
  reason.
  Does anyone have any suggestions for what else I
 can look at?
  
  TIA,
  Jay Miller
  -- 
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
  -- 
  Author:

Re: Where 1 = 1

2001-10-26 Thread tday6


I've never used it with a monster query but I do use it's inverse all the
time.

Create table test1 as (select * from test2 where 1=0);

This creates a copy of the structure of the original.  Leave off the where
and you also copy the data.  Maybe they just want to make explicit that
which is implicit.



   

Ed Bittel  

bitlist To: Multiple recipients of list ORACLE-L  

@yahoo.com  [EMAIL PROTECTED]

Sent by: rootcc:   

 Subject: Where 1 = 1  

   

10/25/2001 

08:20 PM   

Please 

respond to 

ORACLE-L   

   

   





I was monitoring a load test of my company's new
application when I came across something interesting.
One of the more monstrous queries had the following as
part of its WHERE clause: 'AND 1 = 1'

Has anyone seen this used before?  What is it supposed
to achieve?

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed Bittel
  INET: [EMAIL PROTECTED]

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

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

2001-10-26 Thread tday6


Simplest way is not to enter the password on the same line with the userid.
If you wait for SQLPlus to prompt you for the password, it doesn't show up
with ps -ef.

On the other hand, doing this in a script is more problematical.  Anyone
have any examples?



   

Thomas,   

Kevin   To: Multiple recipients of list ORACLE-L  

Kevin.Thomas[EMAIL PROTECTED]

@calanais.comcc:   

Subject: RE: Concealing SQL Loader 
password   
Sent by: rootfrom ps -ef   

   

   

10/26/2001 

04:40 AM   

Please 

respond to 

ORACLE-L   

   

   





Jay,

Could you tell me how to do this for SQL*PLUS, I'm too lazy to look now
that
I've found someone that knows ;o)

Cheers,
Kev.

hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 17:56
To: Multiple recipients of list ORACLE-L


When running Sql Loader from a Unix script is there a way to code it so
that
the password will not be displayed when someone does ps -ef?

I know how to do it for sqlplus, exp and imp but not sql loader.

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

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

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

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

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


-- 
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: Java in the database

2001-10-26 Thread Jim Conboy




Jan-

I've heard some concerns about the scalability of Tomcat as an app 
server. Of course, some of those concerns are voiced by guys like Oracle 
and BEA who have a nice little Java engine to sell you for $10-20K per 
CPU. I know a lot of people use Tomcat for prototypes and such, then go 
with one of the big boys for the production system. Have you - or anyone 
else - hadTomcat working in a production environment with, say, 100-200 
concurrent users? Thanks.

Jim [EMAIL PROTECTED] 10/26/01 08:35AM 

PL/SQL. Java code only on Tomcat-Jakarta 
(Apache). 
JP 
On Thu 25. October 2001 19:16, you wrote:  Out of curiosity, is anyone using the java engine for procedural 
code, or  are most people still using PL/SQL? 
  Regards,  Patrice Boivin  Systems Analyst (Oracle 
Certified DBA)   Systems 
Admin  Operations | Admin. et Exploit. des syst?mes  Technology Services | 
Services technologiques  Informatics 
Branch | Direction de 
l'informatique  Maritimes Region, 
DFO | Région des Maritimes, MPO   E-Mail: [EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED] 
-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com -- Author: Jan Pruner  INET: [EMAIL PROTECTED] 
Fat City Network Services -- (858) 
538-5051 FAX: (858) 538-5051 San Diego, 
California -- Public Internet access / 
Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (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: [Q] what difference between count(0), count(1) and count(*)

2001-10-26 Thread O'Neill, Sean


--- aaa aaa [EMAIL PROTECTED] wrote:
 Can anyone tell me what is difference between :

   select count(*) ... from ..

   select count(0) ...

   select coun (1) ...
   select count(2) ...

For other insights take a look at 
http://www.oracledba.co.uk/tips/count_speed.htm

There is also some fun to be had with using select count(*) from within a
PL/SQL programming unit then when selecting from SQL*Plus.  See MetaLink Doc
ID: 1013985.102

I have an e-mail from an Oracle exponent which contains stats showing that
the various count() theories are in fact just legend and that your session
performs the same amount of work no matter which method you choose.

Where this leaves us all is...


BTW: If you're into Oracle trivia see can you find out how and where the
DUAL table got it's name.

PS: What's your name.  Anonymity is not a pre-requisite around here AFAIK.

-
Sean O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  INET: [EMAIL PROTECTED]

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

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

2001-10-26 Thread dist cash


Does their has way on NT to check folowing ORACLE relate staff:

  1. how many clients sql*net connection on server?  (if my memory correct
their has tool from NT resource kit can check threads, I forget the name.)

  2. how to check each client connection  memory usage?

  3. how to check each client connection spend how much cpu time?

  4. how to check each client when it  connect?



Thanks.


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

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

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

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

2001-10-26 Thread Igor Neyman


Small addition to the instruction below:

Sometimes, when trying to delete Oracle home directory (say D:\Ora8i), you
may get an error, saying could not delete some oracle .dll (don't remember
the exact name) from d:\Ora8i\bin directory - file is in use.
This may happen, because MSDTC (Microsoft Distributed Transactions
Coordinator service) when running (and by default it is set to startup
automatically on system boot) is loading before mentioned oracle .dll into
memory for some reason (or without any reasons?:).  Thus, you may get this
error, when trying to delete the .dll.  So, stopping this service will allow
to delete the file.
In fact, if you know, that you are not using this service (or any other
service set to startup automatically) change it's settings to startup
manually.  Why wasting system resources?

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 9:00 PM



Gotta love Microsoft.  Here's some instructions I got off this list from
Novice DBA a while back on how to properly delete an Oracle Database on
NT/2000:

Clearing up the System after an incomplete or improper installation of
Oracle


-

Database Installation involves a set of procedures which need to be
followed
in order to have a proper working installation. If we follow these
procedures the Installation will be fine and usually problems related to
improper installation do not arise. But it is not always possible to get a
proper installation for the first time. This document is a troubleshooting
guide which would help to clear off the mess created by an improper
installation in a WindowsNT system.

First we need to know that During installation Oracle writes into certain
directories (which we would have specified during installation) and also
into the WindowsNT registry. WindowsNT registry is a repository of
information about all the installed products and configurations on that
system. When we are installing Oracle a directory is created in the
registry
which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/

In the case of an improper installation the problems faced are
· We may not be able to uninstall the incomplete installation
· We may succeed in uninstalling the incomplete installation but yet face
problems with WindowsNT Services.
· Every time we log into WindowsNT we may get an error 'at least one system
service failed to start' which may be an Oracle service from the earlier
installation.
· We may get an error while creating a database 'the database with the name
you specified already exists please chose another name' which again may be
attributed to an improper un-installation.(I am not pretty  comfortable
with
the Oracle's Un-installation utility because I feel it does not uninstall
everything)


Keeping the above points in mind it would be better if we know where
exactly
to look in case we are faced with such problems. When oracle is installed
it
makes entries in the following places
1. The first and the foremost- the directory in which we install the Oracle
database (say D:\Ora8i)
2. The second is the inventory it maintains in the directory c:\program
files\oracle
3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry
4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there
are three nodes controlset1,controlset2 and currentcontrolset. These nodes
in turn have 4 nodes out of which 2 are important to us. They are Enum and
Services. The Enum node has got two nodes out of which the 'root' node is
of
great interest to us because it stores details about all the services that
are running on a WindowsNT system. The other node of interest from the
controlsets is Services. The services node has got a list of services
running on a WindowsNT system.

In case we need to clean up the system after an incomplete installation we
can follow the following steps
Delete the home directory where Oracle is installed
Delete the folder C:\program files\oracle Note:- This clears off
information
about any other Oracle utility installed on that system.
Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:- This
clears off information about any other Oracle utility installed on that
system and you may not be able to run those programs again.
Delete the Oracle Related services from
HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/ENUM/ROOT/ . They will be named with
a
prefix LEGACY_ORACLE... Note:- You will have to use regedt32.exe to invoke
registry editor and not regedit. You will have to use the security menu and
give permissions to yourself before deleting these entries. Else it will
not
work . It is to be noted that there are three control sets and all the
three
(in reality any 2) need to be cleared off these un-necessary entries.
Delete the Oracle Related services from

Re: Monitoring Tool with a difference

2001-10-26 Thread Connor McDonald


Anything against using statspack ?

hth
connor

 --- Denham Eva [EMAIL PROTECTED] wrote:  Hi Gurus,
 
 Ok, I urgently require recommendations for software
 which can monitor a
 Oracle Database for a 24Hr period and create 
 a report on the health of the system.
 Please if anyone has used or is using software for
 this purpose please let
 me know.
 
 
 TIA
 Denham
  

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

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


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

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

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

Re: Java in the database


:-)
Wait 2 weeks and I will tell you how is it running up to 500 people.

Oracle and BEA who have a nice little Java engine to sell you 
It has only other product name, but inside is it the same

Oracle App Server = Apache + Tomcat

JP

On Fri 26. October 2001 15:50, you wrote:
 Jan-

 I've heard some concerns about the scalability of Tomcat as an app server. 
 Of course, some of those concerns are voiced by guys like Oracle and BEA
 who have a nice little Java engine to sell you for $10-20K per CPU.  I know
 a lot of people use Tomcat for prototypes and such, then go with one of the
 big boys for the production system.  Have you - or anyone else - had Tomcat
 working in a production environment with, say, 100-200 concurrent users? 
 Thanks.

 Jim

  [EMAIL PROTECTED] 10/26/01 08:35AM 

 PL/SQL.
 Java code only on Tomcat-Jakarta (Apache).
 JP

 On Thu 25. October 2001 19:16, you wrote:
  Out of curiosity, is anyone using the java engine for procedural code, or
  are most people still using PL/SQL?
 
  Regards,
  Patrice Boivin
  Systems Analyst (Oracle Certified DBA)
 
  Systems Admin  Operations | Admin. et Exploit. des syst?mes
  Technology Services| Services technologiques
  Informatics Branch | Direction de l'informatique
  Maritimes Region, DFO  | Région des Maritimes, MPO
 
  E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]


Content-Type: text/html; charset=iso-8859-1; name=Pøíloha: 1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

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

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

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

2001-10-26 Thread Jenkins, Michael


Here's how to do it from a UNIX script for SQL*Plus:

sqlplus -s /nologEOF
connect system/manager


exit
EOF

-Original Message-
Sent: Friday, October 26, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L


Simplest way is not to enter the password on the same line with the userid.
If you wait for SQLPlus to prompt you for the password, it doesn't show up
with ps -ef.

On the other hand, doing this in a script is more problematical.  Anyone
have any examples?



 

Thomas,

Kevin   To: Multiple recipients of list
ORACLE-L  
Kevin.Thomas[EMAIL PROTECTED]

@calanais.comcc:

Subject: RE: Concealing SQL
Loader password   
Sent by: rootfrom ps -ef

 

 

10/26/2001

04:40 AM

Please

respond to

ORACLE-L

 

 





Jay,

Could you tell me how to do this for SQL*PLUS, I'm too lazy to look now
that
I've found someone that knows ;o)

Cheers,
Kev.

hit any user to continue
__

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


-Original Message-
Sent: 25 October 2001 17:56
To: Multiple recipients of list ORACLE-L


When running Sql Loader from a Unix script is there a way to code it so
that
the password will not be displayed when someone does ps -ef?

I know how to do it for sqlplus, exp and imp but not sql loader.

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

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

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

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

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


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

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

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

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

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

2001-10-26 Thread Jesse, Rich


Is this recovery method valid?  The loss of controlfiles is supposed to be
recovered using the trace file generated from a previous BACKUP CONTROLFILE
TO TRACE, isn't it?  At least according to the Oracle8 Backup and Recovery
class it is.

The part that concerns me is that you are recovering using an ONLINE redo
log (don't know if it was the active one or not).  Could be the paranoid in
me, but that just doesn't seem right.  The admission that I don't think
this is 100% true for every situation would seem to suggest that you agree
that this method shouldn't be used for backup/recovery on production
databases.

My $.02.

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

-Original Message-
Sent: Friday, October 26, 2001 08:30
To: Multiple recipients of list ORACLE-L


Tim,

 You can not simply cancel a recover
 database using backup
 controlfile since Oracle is expecting you perform a
 complete recovery (
 since your not using the UNTIL CANCEL/TIME/CHANGE )
 and canceling a complete
 recovery leaves the stop SCN in the controlfile at
 infinity...  Therefore,
 the recovery is never complete and you will always
 receive the needs media
 recovery message...  

I don't think this is 100% true for every situation. 
I am no recovery expert, but I just did this the other
day, and to verify it, I ran the test again this
morning.  

1.  Shutdown abort
2.  Delete all current controlfiles
3.  Replaced the binary controlfiles from last hot
backup (they were copied as part of the backup script)
4.  Startup mount
5.  Recover database using backup controlfile
6.  Kept applying logs - only trick was that the last
log was an online redo log, so I had to type in that
log explicitly.  There I received the message Media
Recover Complete.
7.  Alter database open resetlogs.

Rob Pegram
Oracle Certified DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Hiding tkprof password from ps -ef

2001-10-26 Thread Hallas John

Title: Hiding tkprof password from ps -ef





Now we have identified how to call sqlloader and sqlplus without showing the password on a ps -ef anybody know how to do it for a tkprof run?

John


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





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

RE: Java in the database

2001-10-26 Thread Boivin, Patrice J


Thanks Jan, I was just curious because here, we are using PL/SQL and the New
Features course for 8i made such a big deal out of Java in the database.  I
took the course when 8.1.5. had been released and no patches were yet
available.

I don't know how the economic slump will affect new projects like those
that would convert apps to Java or adding new Java apps to database servers.
Here we seem to be continuing along the same line we were following for the
past couple of years.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

-Original Message-
From:   Jan Pruner [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, October 26, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Java in the database

:-)
Wait 2 weeks and I will tell you how is it running up to 500 people.

Oracle and BEA who have a nice little Java engine to sell you 
It has only other product name, but inside is it the same

Oracle App Server = Apache + Tomcat

JP

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

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

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

cleaning up the OEM 2.2 repository

2001-10-26 Thread Boivin, Patrice J


How often have you had to de-register all events, remove all nodes, shut
down the OMS, re-start the OMS, and then rediscover all nodes?
Or rebuild the repository?

I received a parent key violation error this time, asked Oracle Support if I
could just go into the child table to delete the bad records, but I have to
de-register and re-register.

So far I had to rebuild the repository twice, and had to de-register and
re-register everything twice.

I wish there was a simpler (read: not GUI-based) way  of getting in there
and cleaning up the repository.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

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

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

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

Re: Java in the database

2001-10-26 Thread Marc Perkowitz


We have a production application using Tomcat and Oracle, but it's primarily
long-running batch processes with a small number of web users (3-4).  For
the second phase, completed in a couple of weeks, we will have 200-300 users
but they will be doing light work with displaying a simple report screen.

As far as Oracle App Server, it can be implemented with Java in Tomcat or
more commonly, Java in the database.  So the equation below is only one
approach.  The usual approach is actually using a special purpose database
on the App Server that runs all the Java.  It's somewhat disguised, but
that's the way it really works.

Marc Perkowitz

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 26, 2001 9:50 AM


 :-)
 Wait 2 weeks and I will tell you how is it running up to 500 people.

 Oracle and BEA who have a nice little Java engine to sell you 
 It has only other product name, but inside is it the same

 Oracle App Server = Apache + Tomcat

 JP

 On Fri 26. October 2001 15:50, you wrote:
  Jan-
 
  I've heard some concerns about the scalability of Tomcat as an app
server.
  Of course, some of those concerns are voiced by guys like Oracle and BEA
  who have a nice little Java engine to sell you for $10-20K per CPU.  I
know
  a lot of people use Tomcat for prototypes and such, then go with one of
the
  big boys for the production system.  Have you - or anyone else - had
Tomcat
  working in a production environment with, say, 100-200 concurrent users?
  Thanks.
 
  Jim
 
   [EMAIL PROTECTED] 10/26/01 08:35AM 
 
  PL/SQL.
  Java code only on Tomcat-Jakarta (Apache).
  JP
 
  On Thu 25. October 2001 19:16, you wrote:
   Out of curiosity, is anyone using the java engine for procedural code,
or
   are most people still using PL/SQL?
  
   Regards,
   Patrice Boivin
   Systems Analyst (Oracle Certified DBA)
  
   Systems Admin  Operations | Admin. et Exploit. des syst?mes
   Technology Services| Services technologiques
   Informatics Branch | Direction de l'informatique
   Maritimes Region, DFO  | Région des Maritimes, MPO
  
   E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

 
 Content-Type: text/html; charset=iso-8859-1; name=Pøíloha: 1
 Content-Transfer-Encoding: quoted-printable
 Content-Description: HTML
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jan Pruner
   INET: [EMAIL PROTECTED]

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


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

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

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

RE: Instance Name in Sql Prompt

2001-10-26 Thread Ramon Estevez


Now it works correct for the both cases,

Thanks, that's what I was looking for,

Gracias,

Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de
[EMAIL PROTECTED]
Enviado el: Friday, 26 October, 2001 2:35 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Instance Name in Sql Prompt





Hi,


To overcome the connect within a session not changing the prompt  a created
a script (connect.sql) and put it in the directory from SQL_PATH registry
entry. When I want to change the connection i type @connect i.s.o connect




accept username prompt Type username :;
accept password prompt Type Password (hidden) : hide;
accept sid prompt Type instance name (SID) :;
connect username/password@sid;
@d:\oracle\ora80\Plus80\glogin.sql;
undefine username;
undefine password;
undefine sid;
rem CLEAR SCREEN;



Jack




Ramon Estevez [EMAIL PROTECTED]@fatcity.com on 25-10-2001
22:15:21

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Thanks to Kevin and all that reply.

I noticed when doing a connect inside a session.

This will help.

Ramon E. Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121
 -Mensaje original-
 De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Kevin Lange
 Enviado el: Thursday, 25 October, 2001 11:10 AM
 Para: Multiple recipients of list ORACLE-L
 Asunto: RE: Instance Name in Sql Prompt

 Ramon;
   In your startup directory on SQL Plus, you can automatically run a
 script that will setup the environment like you want it.  Its called
 LOGIN.SQL.

 Here is a copy of mine:

 set termout on
 set pagesize 0
 set echo off
 set feedback off
 set sqlprompt ''
 spool c:\temp.sql
 select 'set sqlprompt '''||name||'  '';' from v$database;
 spool off
 @c:\temp.sql
 set pagesize 35
 set feedback on
 set termout off
 What this does is to take the name of the database from v$database and
 create a temporary SQL file, then runs it.  This will set my prompt to

 INSTANCE_NAME 

 where INSTANCE_NAME is the name of the database.

 For example, if I log onto DEV then the SQLPROMPT will be

 DEV 

 Hope you can use it.

 Kevin

 p.s. ...  Remember that  this only works for the initialization of SQL
 Plus.  If you do a connect inside of your session then the prompt will
 not change.
  -Original Message-
  From: Ramon Estevez [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 25, 2001 9:35 AM
  To: Multiple recipients of list ORACLE-L
  Subject: Instance Name in Sql Prompt

  Hi Friends,

  Excuse me for this dumb question,  how do I display the instance
  name in the
  sql prompt.  Have 3 DB and would like to know to which one I am
  connected.

  I mean something like that.

  DBA1 
  DBA2 
  DB01 

  Regards,

  Ramon E. Estevez
  [EMAIL PROTECTED]
  Dominican Republic
  809-565-3121




=
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

RE: Hiding tkprof password from ps -ef

2001-10-26 Thread Gogala, Mladen


Simple.  USe OPS$ account.

-Original Message-
Sent: Friday, October 26, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L



Now we have identified how to call sqlloader and sqlplus without showing the
password on a ps -ef anybody know how to do it for a tkprof run?

John 

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




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


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

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

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

RE: URGENT -- db already exist ???

2001-10-26 Thread Guidry, Chris


I've found having Oracle\bin in your environment path will
prevent you from deleting some .DLLs. Remove it and reboot.

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

 -Original Message-
 From: Igor Neyman [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, October 26, 2001 08:00 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: URGENT -- db already exist ???
 
 Small addition to the instruction below:
 
 Sometimes, when trying to delete Oracle home directory (say D:\Ora8i), you
 may get an error, saying could not delete some oracle .dll (don't
 remember
 the exact name) from d:\Ora8i\bin directory - file is in use.
 This may happen, because MSDTC (Microsoft Distributed Transactions
 Coordinator service) when running (and by default it is set to startup
 automatically on system boot) is loading before mentioned oracle .dll
 into
 memory for some reason (or without any reasons?:).  Thus, you may get this
 error, when trying to delete the .dll.  So, stopping this service will
 allow
 to delete the file.
 In fact, if you know, that you are not using this service (or any other
 service set to startup automatically) change it's settings to startup
 manually.  Why wasting system resources?
 
 Igor Neyman, OCP DBA
 Perceptron, Inc.
 (734)414-4627
 [EMAIL PROTECTED]
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, October 25, 2001 9:00 PM
 
 
 
 Gotta love Microsoft.  Here's some instructions I got off this list from
 Novice DBA a while back on how to properly delete an Oracle Database on
 NT/2000:
 
 Clearing up the System after an incomplete or improper installation of
 Oracle
 --
 --
 
 -
 
 Database Installation involves a set of procedures which need to be
 followed
 in order to have a proper working installation. If we follow these
 procedures the Installation will be fine and usually problems related to
 improper installation do not arise. But it is not always possible to get a
 proper installation for the first time. This document is a troubleshooting
 guide which would help to clear off the mess created by an improper
 installation in a WindowsNT system.
 
 First we need to know that During installation Oracle writes into certain
 directories (which we would have specified during installation) and also
 into the WindowsNT registry. WindowsNT registry is a repository of
 information about all the installed products and configurations on that
 system. When we are installing Oracle a directory is created in the
 registry
 which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/
 
 In the case of an improper installation the problems faced are
 · We may not be able to uninstall the incomplete installation
 · We may succeed in uninstalling the incomplete installation but yet face
 problems with WindowsNT Services.
 · Every time we log into WindowsNT we may get an error 'at least one
 system
 service failed to start' which may be an Oracle service from the earlier
 installation.
 · We may get an error while creating a database 'the database with the
 name
 you specified already exists please chose another name' which again may be
 attributed to an improper un-installation.(I am not pretty  comfortable
 with
 the Oracle's Un-installation utility because I feel it does not uninstall
 everything)
 
 
 Keeping the above points in mind it would be better if we know where
 exactly
 to look in case we are faced with such problems. When oracle is installed
 it
 makes entries in the following places
 1. The first and the foremost- the directory in which we install the
 Oracle
 database (say D:\Ora8i)
 2. The second is the inventory it maintains in the directory c:\program
 files\oracle
 3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry
 4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there
 are three nodes controlset1,controlset2 and currentcontrolset. These nodes
 in turn have 4 nodes out of which 2 are important to us. They are Enum and
 Services. The Enum node has got two nodes out of which the 'root' node is
 of
 great interest to us because it stores details about all the services that
 are running on a WindowsNT system. The other node of interest from the
 controlsets is Services. The services node has got a list of services
 running on a WindowsNT system.
 
 In case we need to clean up the system after an incomplete installation we
 can follow the following steps
 Delete the home directory where Oracle is installed
 Delete the folder C:\program files\oracle Note:- This clears off
 information
 about any other Oracle utility installed on that system.
 Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:-
 This
 clears off information about any other Oracle utility installed on that
 system and you may not be able to run

Re: Java in the database

2001-10-26 Thread Jim Conboy




Jan-
Please do let us know how you do with 500 users.
"Oracle App Server = Apache + Tomcat"
Is this true? Iknow that "Oracle HTTP Server" (ha ha) is 
basically Apache. And I know that the Oracle Jserver was basically the 
Jserv precursor to Tomcat. But I thought 8.1.7 and 9i came with a new 
servlet. I looked on Metalink and couldn't tell, is that 'new' java 
servlet really Tomcat?

Jim
 [EMAIL PROTECTED] 10/26/01 10:50AM 
:-) Wait 2 weeks and I will tell you how 
is it running up to 500 people. 
"Oracle and BEA who have a nice little Java engine to sell you 
" It has only other product name, but inside is it the 
same 
Oracle App Server = Apache + Tomcat 
JP

RE: i need check fragmentation of index

2001-10-26 Thread Stephen Andert




Watch out though! From the 8.1.6 
documentation:

"Validating the structure of an object prevents SELECT, INSERT, UPDATE, and 
DELETEstatements from concurrently accessing the object. Therefore, do not 
use this clause on thetables, clusters, and indexes of your production 
applications during periods of highdatabase activity."
I didn't realize that until users started complaining when I tried this 
a while back.

Stephen 
 [EMAIL PROTECTED] 10/26/01 04:10AM 
Alex,This script is based around an analyze index . 
validate structure asmentined by 
Deepak---set 
verify offset pagesize 35set linesize 132set pause onset pause 
'Hit enter to continue'set feedback offset showmode offset echo 
offset space 0set heading offset termout off pause 
offcolumn blsk new_value BLOCK_SIZE_Kselect value / 1024 blskfrom 
v$parameterwhere name = 'db_block_size';set termout on pause 
offPROMPTACCEPT USER_INPUT1 CHAR PROMPT 'Please enter a index to 
analyze:'ACCEPT USER_INPUT2 CHAR PROMPT 'Please enter a owner to 
analyze:'PROMPTPROMPT Working, Please 
wait.PROMPTanalyze index USER_INPUT2..USER_INPUT1 
validate structure;col 
ROWS_PER_KEY format 
999.99 heading ' 'col 
BLKS_GETS_PER_ACCESS format 99,999.99 heading 
' 
'select' 
Name of the index = ' || 
NAME,' 
Height of the b-tree = ' || 
HEIGHT,' 
Blocks allocated to the index = ' || 
BLOCKS,' 
Number of leaf rows (values in the index) = ' || 
LF_ROWS,' 
Number of leaf blocks in the b-tree = ' || 
LF_BLKS,' 
Sum of the lengths of all the leaf rows = ' || 
LF_ROWS_LEN,' 
Useable space in a leaf block = ' || 
LF_BLK_LEN,' 
Number of branch rows = ' || 
BR_ROWS,' 
Number of branch blocks in the b-tree = ' || BR_BLKS,'Sum of lengths of all 
the branch blocks in the b-tree = ' || 
BR_ROWS_LEN,' 
Useable space in a branch block = ' || 
BR_BLK_LEN,' 
Number of deleted leaf rows in the index = ' || 
DEL_LF_ROWS,' Total length of all 
deleted rows in the index = ' 
||DEL_LF_ROWS_LEN,' 
Number of distinct keys in the index = ' || 
DISTINCT_KEYS,' How many times the most repeated key 
is repeated = ' 
||MOST_REPEATED_KEY,' Total 
space currently allocated in the b-tree = ' || BTREE_SPACE,'Totl space that 
is currently being used in the b-tree = ' || USED_SPACE,'% of space 
allocated in the b-tree that is being used = ' || 
PCT_USED,' 
Average number of rows per distinct key = ' || ROWS_PER_KEY,'Expected number 
of consistent mode block gets per row = ' ||BLKS_GETS_PER_ACCESSfrom 
index_stats;col 
NAME 
format a30 fold_aftercol 
dummy_col_0 
fold_aftercol 
dummy_col_1 
fold_aftercol 
dummy_col_2 
fold_aftercol 
LF_ROWS 
format 
9,999,990 
heading ' 'col 
DEL_LF_ROWS format 
9,999,990 
heading ' 'col 
BR_ROWS 
format 
9,999,990 
heading ' 'col 
DISTINCT_KEYS format 
9,999,990 
heading ' 'col 
MOST_REPEATED_KEY format 
9,999,990 
heading ' 'col 
ROWS_PER_KEY format 
9,999,990 
heading ' 'col 
HEIGHT 
format 0 fold_after heading 
' 'col 
BLKS_GETS_PER_ACCESS format 99,999.99 fold_after heading 
' 'col 
LF_BLK_LEN format 
9,990 fold_after heading ' 
'col lf_row_size 
format 990 fold_after heading 
' 'col 
lf_row_per_blk format 
990 fold_after heading 
' 'col 
BR_BLK_LEN format 
9,990 fold_after heading ' 
'col br_row_size 
format 990 fold_after heading 
' 'col 
br_row_per_blk format 
990 fold_after heading 
' 'col 
meg 
format 999.90 fold_after heading 
' 'col 
lf_meg 
format 
999.90 
heading ' 'col 
lf_meg_pct format 
99.90 fold_after heading ' 
'col 
br_meg 
format 
999.90 
heading ' 'col 
br_meg_pct format 
99.90 fold_after heading ' 
'col 
uu_meg 
format 
999.90 
heading ' 'col 
uu_meg_pct format 
99.90 fold_after heading ' 
'col 
bt_meg 
format 
999.90 
heading ' 'col 
bt_meg_pct format 
99.90 fold_after heading ' 
'col 
btu_meg 
format 
999.90 
heading ' 'col 
btu_meg_pct format 
99.90 fold_after heading ' 
'col 
btuu_meg 
format 
999.90 
heading ' 'col 
btuu_meg_pct format 
99.90 fold_after heading ' 
'col 
btuub_meg 
format 
999.90 
heading ' 'col 
btuub_meg_pct format 
99.90 fold_after heading ' 
'set pause onselect dummy_col_0,'Index 
Name.', NAME, ' ' dummy_col_1,'Leaf Rows..', LF_ROWS, 
' ','Leaf Block Size', 
LF_BLK_LEN,'Deleted Leaf Rows..', DEL_LF_ROWS, ' 
','Leaf Row Size..', LF_ROWS_LEN / LF_ROWS lf_row_size,'Branch 
Rows', BR_ROWS, ' ','Leaf Rows Per 
Block', LF_BLK_LEN / (LF_ROWS_LEN / LF_ROWS)lf_row_per_blk,'Distinct 
Keys..', DISTINCT_KEYS, ' ','Branch Block 
Size..', BR_BLK_LEN,'Max Common Key.', MOST_REPEATED_KEY, 
' ','Branch Row Size', BR_ROWS_LEN / 
(BR_ROWS + 1) br_row_size,'Avg Common Key.', ROWS_PER_KEY, 
' ','Branch Rows Per Block..', BR_BLK_LEN / 
((BR_ROWS_LEN / (BR_ROWS + 1)) + 1)br_row_per_blk,'Height Of B-Tree...', 
HEIGHT,'Reads Per Access...', BLKS_GETS_PER_ACCESS,' ' 
dummy_col_2,'Index Meg', (BLOCKS * BLOCK_SIZE_K) / 1024 
meg,'Leaf Meg/Pct.', (LF_BLKS * BLOCK_SIZE_K) / 1024 
lf_meg, ' 
/',

RE: Unable to rebuild database from hot backup

2001-10-26 Thread Robert Pegram


Luckily I have never had this situation in production,
and what I have read also suggests using the ascii
file created from 'BACKUP CONTROLFILE TO TRACE' for
recovery.  I just had a little time on my hands and
decided to give it a try.  As I stated, I am by no
means an expert in recovery (more like a novice), I
was just stating what I observed.  Maybe someone else
will let us know their opinion.

Thanks for your input.

Rob Pegram

--- Jesse, Rich [EMAIL PROTECTED] wrote:
 Is this recovery method valid?  The loss of
 controlfiles is supposed to be
 recovered using the trace file generated from a
 previous BACKUP CONTROLFILE
 TO TRACE, isn't it?  At least according to the
 Oracle8 Backup and Recovery
 class it is.
 
 The part that concerns me is that you are recovering
 using an ONLINE redo
 log (don't know if it was the active one or not). 
 Could be the paranoid in
 me, but that just doesn't seem right.  The admission
 that I don't think
 this is 100% true for every situation would seem to
 suggest that you agree
 that this method shouldn't be used for
 backup/recovery on production
 databases.
 
 My $.02.
 
 Rich Jesse  System/Database
 Administrator
 [EMAIL PROTECTED] Quad/Tech
 International, Sussex, WI USA
 
 -Original Message-
 Sent: Friday, October 26, 2001 08:30
 To: Multiple recipients of list ORACLE-L
 
 
 Tim,
 
  You can not simply cancel a recover
  database using backup
  controlfile since Oracle is expecting you perform
 a
  complete recovery (
  since your not using the UNTIL CANCEL/TIME/CHANGE
 )
  and canceling a complete
  recovery leaves the stop SCN in the controlfile at
  infinity...  Therefore,
  the recovery is never complete and you will always
  receive the needs media
  recovery message...  
 
 I don't think this is 100% true for every situation.
 
 I am no recovery expert, but I just did this the
 other
 day, and to verify it, I ran the test again this
 morning.  
 
 1.  Shutdown abort
 2.  Delete all current controlfiles
 3.  Replaced the binary controlfiles from last hot
 backup (they were copied as part of the backup
 script)
 4.  Startup mount
 5.  Recover database using backup controlfile
 6.  Kept applying logs - only trick was that the
 last
 log was an online redo log, so I had to type in that
 log explicitly.  There I received the message Media
 Recover Complete.
 7.  Alter database open resetlogs.
 
 Rob Pegram
 Oracle Certified DBA
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Jesse, Rich
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

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

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

RE: ORA-04031, how to prevent fragmentation?

2001-10-26 Thread Orr, Steve


Regarding flushing the shared pool... 
A couple of weeks ago I had hard copies of 2 Metalink docs side by side on
my desk and I highlighted paragraphs on each which were completely
contradictory. One said flushing did absolutely no good and the other said
it could help. In practice it doesn't seem to do much for severe 4031 type
fragmentation. Pinning large stuff at db start up can help but if you've got
a lot of SQL with literals then consider setting cursor_sharing = TRUE as
well. With a small db just enlarging the shared pool may be enough. Of
course if you have control over the code then I think using bind variables
is still the preferred solution.


Steve Orr


-Original Message-
Sent: Friday, October 26, 2001 6:05 AM
To: Multiple recipients of list ORACLE-L


You can either issue an alter system flush shared pool, or increase the
value of your shared_pool_size. Another option would be to pin some or your
most used/larger packeges in to your shared pool.

HTH

Mark

-Original Message-
Sent: Friday, October 26, 2001 10:55
To: Multiple recipients of list ORACLE-L


Dear list,

we have a small database with very few users, Oracle 8.1.7, NT 4 SP5. A
NT-service holds a permanent connection and checks, if some data export are
about to be done. The database had now an uptime of several months and each
new connect raises ORA-04031. Seems to be a fragmentation problem of the
shared pool. How can I prevent that?

Thanx very much

Mit freundlichen Grüßen

i.A. Marc Blum

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

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

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


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

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

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

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

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

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

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

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

Re: Oracle Installer line mode

2001-10-26 Thread DBarbour



AFAIK you MUST use the Java Installer.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
 
Daiminger, Helmut
 
Helmut.Daiminger@Kirch   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]   
Gruppe.decc:  
 
Sent by:  Subject: Oracle Installer line 
mode   
[EMAIL PROTECTED]   
 
   
 
   
 
10/25/2001 06:40 AM
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Hi!


Is it possible to run an 8.1.7 installation in line mode on Sun Solaris? Or
is it mandatory to use the Java installer?


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: INITRANS storage parameter

2001-10-26 Thread Wong, Bing


So the existing data blocks that were assigned to INITRANS=1 would not have
any negative impact, right?

Now I remember that was you had the problem and I read your note and kept
for reference.  Now I am facing the same problem. 

Thank you.
Bing



-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/26/01 2:30 AM

 Yes you can.   But it will only be that way for new records added.  We
had
the same problem on 8.0.5 .

But that should be ok.   Our problem was that , on new records, we had
reads
coming thru that appeared to do full table scans while the initial
inserts
were coming thru.  This, apparently, caused a problem with the tables
because locks started to build up.  When we changed our initrans to 2 on
all
those tables, our locking problem went away.


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/25/01 6:10 PM

Hi,

I have 8.1.7.1 running on HP-UX.  One of my table is heavily being
updated
and I see blocking locks.  I have recalled that if I change the INITRANS
value from 1 to 2, the blocking locks should go away.  Question I have
is
can I modify it in the fly without dropping and recreating the table.

Thanks
Bing

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

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

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

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

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

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

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


Do you mean Oracle Database Cache?

JP

On Fri 26. October 2001 18:25, you wrote:
 We have a production application using Tomcat and Oracle, but it's
 primarily long-running batch processes with a small number of web users
 (3-4).  For the second phase, completed in a couple of weeks, we will have
 200-300 users but they will be doing light work with displaying a simple
 report screen.

 As far as Oracle App Server, it can be implemented with Java in Tomcat or
 more commonly, Java in the database.  So the equation below is only one
 approach.  The usual approach is actually using a special purpose database
 on the App Server that runs all the Java.  It's somewhat disguised, but
 that's the way it really works.

 Marc Perkowitz

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Friday, October 26, 2001 9:50 AM

  :-)
 
  Wait 2 weeks and I will tell you how is it running up to 500 people.
 
  Oracle and BEA who have a nice little Java engine to sell you 
  It has only other product name, but inside is it the same
 
  Oracle App Server = Apache + Tomcat
 
  JP
 
  On Fri 26. October 2001 15:50, you wrote:
   Jan-
  
   I've heard some concerns about the scalability of Tomcat as an app

 server.

   Of course, some of those concerns are voiced by guys like Oracle and
   BEA who have a nice little Java engine to sell you for $10-20K per CPU.
I

 know

   a lot of people use Tomcat for prototypes and such, then go with one of

 the

   big boys for the production system.  Have you - or anyone else - had

 Tomcat

   working in a production environment with, say, 100-200 concurrent
   users? Thanks.
  
   Jim
  
[EMAIL PROTECTED] 10/26/01 08:35AM 
  
   PL/SQL.
   Java code only on Tomcat-Jakarta (Apache).
   JP
  
   On Thu 25. October 2001 19:16, you wrote:
Out of curiosity, is anyone using the java engine for procedural
code,

 or

are most people still using PL/SQL?
   
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
   
Systems Admin  Operations | Admin. et Exploit. des syst?mes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO  | Région des Maritimes, MPO
   
E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 
  
  Content-Type: text/html; charset=iso-8859-1; name=P?íloha: 1
  Content-Transfer-Encoding: quoted-printable
  Content-Description: HTML
  
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Jan Pruner
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

Re: ORACLE-L Digest -- Volume 2001, Number 299

2001-10-26 Thread Eric D. Pierce


sorry if this is a duplicate

ORACLE-L Digest -- Volume 2001, Number 299
  -Original Message-
  Sent: Thursday, October 25, 2001 10:25 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Are there any issues with Oracle that I should know about when the
  clocks roll back this weekend?
  
  Rick Stephenson
  Oracle/Sybase Database Administrator
  [EMAIL PROTECTED]
  Ovid Technologies, Inc.
  9350 South 150 East, Suite 300
  Sandy, UT 84070
  (801) 304-3000 ext. 2593





http://metalink.oracle.com

Doc ID: Note:1013279.6
Creation Date: 18-OCT-1995
Last Revision Date: 23-OCT-1998

 Problem Description: 
  
 When the system clock is changed, forward in spring or back in fall, does this 
 have any potentially harmful effects for the database? 
  
 Search Words: time date change timestamp saving

 Solution: ONLY AFFECTS TIME-BASED RECOVERY


 WARNINGS: 
 = 
 None. 
  
 Solution Description: 
 = 
 Because Oracle tracks the sequence of events in the database using the System 
 Commit Number (SCN), changing the system clock for daylight savings time will 
 have no effect on database operation.  The only point where the time change 
 can have potentially harmful effect is during time-based recovery. 
  
 Time based recovery requires checking of the actual time the transaction was 
 recorded in the logfile.  Every log record has a time stamp associated with 
 it.  If the system manager for some reason changes the system clock, Oracle 
 Support recommends shutting down the database and taking a cold backup ( or a 
 hot backup if preferred).  If for some reason a dba has to go back to a backup 
 which was taken prior to the system clock change and rollforward, recovery 
 works just fine except for time based recovery (Note that time based recovery 
 works fine if the system clock is moved forward in time).  When the system 
 clock is changed backwards, its possible that there could be two redo records 
 with the same time stamp.  If time based recovery is done in this scenario, 
 since ORACLE applies only redo entries that were written prior to a specified 
 time, ecovery stops when it finds the first redo record which has that 
 specified time. 
  
 The following example will illustrate the problem: 
  
  
 3pm4pm 4.154.30  5pm--4pm   4.16pm  4.30   5pm 
 |--|---|---|---|-|---|--| 
 cold/hot  T1  T2  T3 clock   T4 T5  T6 
 backup   change 
  
|--R1--| 
  
 A cold backup was taken at 3pm. A transaction T1 was done at 4pm.  So the redo 
 record has a time stamp of 4pm. Transaction T2 was done at 4.15pm and 
 transaction T3 at 4.30pm. 
  
 At 5pm the system clock was changed backward, one hour. 16 minutes later (i.e; 
 at time 4.16pm) transaction T4 was done.  Later on, the disk crashed and we 
 lost the databasefiles. 
  
 Any recovery done to recover data upto certain time in the range R1 will not 
 recover the data in the range R1 but recovers only until corresponding time 
 before the system clock change. 
  
 Say if the DBA decides to recover until T5(4:30pm) which is in time range R1. 
 DBA restores the backup from 3pm and does a recovery until 4:30 thinking it 
 would recover until T5. Actually the recovery is done until T3 and not T5. So 
 all the trasanctions entered after T3 will be lost. Recovery beyond 5pm or say 
 beyond range R1 should not cause any lose of data. 
  
 Note:
   Although specifying a time in the interval 'clock change' to 'T6' will
   result in incomplete recovery to the first occurrence of the specified
   time it is still possible to recover to any point in time in this range
   using SCN based recovery (using the RECOVER UNTIL CHANGE clause).

 Conclusion:
   Following a time change where the clocks go back in time there is a 
   window where INCOMPLETE recovery using TIME BASED recovery is affected.
   Recovery to a point in time within this window can be achieved using
   SCN (or CHANGE) based recovery.
   Recovery to a point in time after this window requires no special action.
 .


   Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and
   Terms of Use.



---end---

Re: Java in the database


I don't know details about Oracle App server 'cause I'm no Java freak :-)

I have purchased Oracle 9i App Server v.1.0.2.1 for developing
and our developers told me don't purchase Oracle App Server for production, 
because it's Apache with Tomcat and we are not using special features of OAS.

I have to ask them to know more details.

JP

On Fri 26. October 2001 18:40, you wrote:
 Jan-
 Please do let us know how you do with 500 users.
 Oracle App Server = Apache + Tomcat
 Is this true?  I know that Oracle HTTP Server (ha ha) is basically
 Apache.  And I know that the Oracle Jserver was basically the Jserv
 precursor to Tomcat.  But I thought 8.1.7 and 9i came with a new servlet. 
 I looked on Metalink and couldn't tell, is that 'new' java servlet really
 Tomcat?

 Jim

  [EMAIL PROTECTED] 10/26/01 10:50AM 
 :
 :-)

 Wait 2 weeks and I will tell you how is it running up to 500 people.
 Oracle and BEA who have a nice little Java engine to sell you 
 It has only other product name, but inside is it the same
 Oracle App Server = Apache + Tomcat
 JP


Content-Type: text/html; charset=iso-8859-1; name=Pøíloha: 1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

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

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

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

2001-10-26 Thread Kevin Lange


We had no negative impact from those blocks left with initrans=1.   And it
truely did stop our locks. 

I hope it works for you as well.

Kevin

-Original Message-
Sent: Friday, October 26, 2001 11:32 AM
To: 'Kevin Lange '; 'Multiple recipients of list ORACLE-L '


So the existing data blocks that were assigned to INITRANS=1 would not have
any negative impact, right?

Now I remember that was you had the problem and I read your note and kept
for reference.  Now I am facing the same problem. 

Thank you.
Bing



-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/26/01 2:30 AM

 Yes you can.   But it will only be that way for new records added.  We
had
the same problem on 8.0.5 .

But that should be ok.   Our problem was that , on new records, we had
reads
coming thru that appeared to do full table scans while the initial
inserts
were coming thru.  This, apparently, caused a problem with the tables
because locks started to build up.  When we changed our initrans to 2 on
all
those tables, our locking problem went away.


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/25/01 6:10 PM

Hi,

I have 8.1.7.1 running on HP-UX.  One of my table is heavily being
updated
and I see blocking locks.  I have recalled that if I change the INITRANS
value from 1 to 2, the blocking locks should go away.  Question I have
is
can I modify it in the fly without dropping and recreating the table.

Thanks
Bing

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

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

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

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

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

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

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

2001-10-26 Thread Jared . Still



date +%d-%b-%Y

man date.

You may have to look at the man page on a system with more
recent documentation, such as linux.  The man page on
Solaris is incomplete.

JARed




   
 
Suhen Pather   
 
Suhen.Pather@strandba   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
gs.com.au   cc:   
 
Sent by: Subject: date format in ksh   
 
[EMAIL PROTECTED]   
 
   
 
   
 
10/25/01 08:00 PM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




List,





Sorry to deviate from the topic, but


I am writing a korn shell script that would exit if the date format is


incorrect.





I just need something to compare the date format passed  in with
DD-MON-.





Eg.


I am passing an argument to my ksh script being the date.


If the date is in any other format but DD-MON- the ksh must exit.





Eg.  sh test.ksh 02/05/1999





It must exit.





The only format excepted should be


sh test.ksh 02-MON-





TIA





Regards


Suhen













--
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: Hiding tkprof password from ps -ef

Title: RE: Hiding tkprof password from ps -ef





John, it runs so fast, isn't this overkill? Just curious. Of course I have never been responsible for a system that had anal-type security implemented, either. 

Lisa Koivu
Oracle Database Potato currently in Replication Mode.
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From: Hallas John [SMTP:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Hiding tkprof password from ps -ef


Now we have identified how to call sqlloader and sqlplus without showing the password on a ps -ef anybody know how to do it for a tkprof run?

John 


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





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

v$sql and v$sqlarea

2001-10-26 Thread Greg Moore


I want to understand the difference between v$sql and v$sqlarea.  Apparently
they are both views of the same x$ table.  Does anyone know where I can view
the code that creates these two views?

Thanks.

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

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

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

2001-10-26 Thread Mohan, Ross

Title: RE: Hiding tkprof password from ps -ef



never 
been responsible for a fully sphincter-ized system, eh Lisa?

Love 
the sig, btw!


bona 
fide oracle question: anyone personally using a doc scanner and 
InterMedia to manage their tech data?

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 
  2:26 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Hiding tkprof password from ps -ef
  John, it runs so fast, isn't this 
  overkill? Just curious. Of course I have never been responsible 
  for a system that had anal-type security implemented, either. 
  Lisa Koivu Oracle Database 
  Potato currently in Replication Mode. Fairfield 
  Resorts, Inc. 954-935-4117

RE: Java in the database

2001-10-26 Thread Christopher Spence


So a huge Trading exchange written in Perl?  
Not sure about that.  Perl is cool, but I couldn't see it used for
everything.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 25, 2001 7:35 PM
To: Multiple recipients of list ORACLE-L


PL/SQL in the database, Perl everywhere else.

Jared



 

Boivin, Patrice

J  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]   cc:

mpo.gc.ca  Subject: Java in the
database  
Sent by:

[EMAIL PROTECTED]

 

 

10/25/01 10:16 AM

Please respond to

ORACLE-L

 

 





Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

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

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

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




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

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

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

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

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

2001-10-26 Thread Christopher Spence










Take a look at OrionServer (www.orionserver.com)  at $1,500 / server and 5x faster than Web
Logic, I would wonder why people would use others.  And OAS9i uses Orion as the core now.







Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes.

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax: (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
 



-Original Message-
From: Jim Conboy
[mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 26, 2001
9:50 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Java in the database





Jan-











I've heard some concerns about the
scalability of Tomcat as an app server. Of course, some of those concerns
are voiced by guys like Oracle and BEA who have a nice little Java engine to
sell you for $10-20K per CPU. I know a lot of people use Tomcat for
prototypes and such, then go with one of the big boys for the production
system. Have you - or anyone else - hadTomcat working in a production
environment with, say, 100-200 concurrent users? Thanks.











Jim

 [EMAIL PROTECTED] 10/26/01 08:35AM 



PL/SQL. 
Java code only on Tomcat-Jakarta (Apache). 

JP 

On Thu 25. October 2001 19:16, you wrote: 
 Out of curiosity, is anyone using the java engine for procedural code, or 
 are most people still using PL/SQL? 
 
 Regards, 
 Patrice Boivin 
 Systems Analyst (Oracle Certified DBA) 
 
 Systems Admin  Operations | Admin. et Exploit. des syst?mes 
 Technology Services | Services
technologiques 
 Informatics Branch |
Direction de l'informatique 
 Maritimes Region, DFO | Région des
Maritimes, MPO 
 
 E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author: Jan Pruner 
 INET: [EMAIL PROTECTED] 

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

backup of large databases

2001-10-26 Thread Ed Lewis




Hello,
 I'm curious how people handle 
the backups for
 large/very large databases; 
200gb or greater.
 
 My questions are not targeted 
towards any
 specific hardware platform, but 
we are using
 Oracle 8.1.7. I'm assuming that 
archiving is enabled.

Are backupsdone 
nightly, or because of
 time constraints are they done 
weekly ?
If weekly, do you feel 
comfortablehaving to possibly
 apply a week of archives, inthe case of a recovery ?

 Do you use disk or tape 
?

Do you use RMAN or other 
backup tools ?

What are 
thecustomer's expections for recovery and
how do they effect your 
backup strategy ?

 I appreciate your 
input.

 
ed

RE: Hiding tkprof password from ps -ef

2001-10-26 Thread Gogala, Mladen


Well, Lisa, you're forgetting that some shells leave history of commands in 
files like $HOME/.sh_history and that username and password can be pisked up
from 
there.

-Original Message-
Sent: Friday, October 26, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L



John, it runs so fast, isn't this overkill?  Just curious.  Of course I have
never been responsible for a system that had anal-type security implemented,
either. 

Lisa Koivu 
Oracle Database Potato currently in Replication Mode. 
Fairfield Resorts, Inc. 
954-935-4117 


-Original Message- 
Sent:   Friday, October 26, 2001 12:20 PM 
To: Multiple recipients of list ORACLE-L 

Now we have identified how to call sqlloader and sqlplus without
showing the password on a ps -ef anybody know how to do it for a tkprof run?

John 

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





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


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

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

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

Dead connection detection(DCD)

2001-10-26 Thread Seema Singh


Hi
I found some of when client reboot or application server reboot the 
connection with DB still available at DB end.
I want to implement SQLNET.EXPIRE_TIME=10 value at DB server .Please help me 
to clarify following query
a)What will be effect to create sqlnet.ora file on solaris DB SERVER box if 
that file doesn't exist.?
b)what will be content of sqlnet.ora file?
like names.directory_path=tnsnames,onames,hostname)
c)Can I have sqlnet.ora file with
SQLNET.EXPIRE_TIME=10 entry only?

With regards
-Seema

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

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

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

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

RE: Java in the database

2001-10-26 Thread Christopher Spence


Actually I believe it will be, in 9i they clearly made some improvements
(very notable ones) in PL/SQL.  I would suspect it will be around for a
while.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Thursday, October 25, 2001 2:23 PM
To: Multiple recipients of list ORACLE-L

Still PL/SQL.
Hope, it will be supported long enough. (till my retirement? :)

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 1:16 PM


Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

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

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

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

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

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

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

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

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

2001-10-26 Thread Jacques Kilchoer

Title: RE: v$sql and v$sqlarea





 -Original Message-
 From: Greg Moore [mailto:[EMAIL PROTECTED]]
 
 I want to understand the difference between v$sql and 
 v$sqlarea. Apparently
 they are both views of the same x$ table. Does anyone know 
 where I can view
 the code that creates these two views?



v$fixed_view_definition


LQS select view_definition from v$fixed_view_definition
 2 where view_name = 'GV$SQL' ;


VIEW_DEFINITION

select inst_id,kglnaobj, kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+k
globhs6+kglobt16, kglobt08+kglobt11, kglobt10, kglobt01, decode(kglobhs6,0,0,1),
decode(kglhdlmd,0,0,1), kglhdlkc, kglhdexc, kglobpc6, kglhdldc, substr(to_char(
kglnatim,'-MM-DD/HH24:MI:SS'),1,19), kglhdivc, kglobt12, kglobt13, kglobt14,
kglobt15, kglobt02, decode(kglobt32, 0, 'NONE', 1, 'ALL_ROWS',
 2, 'FIRST_ROWS', 3, 'RULE', 4, 'CHOOSE', 'UNKNOWN')
, kglobtn0, kglobt17, kglobt18, kglhdkmk, kglhdpar, kglobtp0, kglnahsh, kglobt09
, kglobts0, kglobt19, kglobts1, kglobt20, kglobt21, kglobts2 from x$kglcursor w
here kglhdadr != kglhdpar and kglobt02 != 0



LQS c/GV$SQL/GV$SQLAREA/
 2* where view_name = 'GV$SQLAREA'
LQS run
 1 select view_definition from v$fixed_view_definition
 2* where view_name = 'GV$SQLAREA'


VIEW_DEFINITION

select inst_id,kglnaobj, sum(kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobh
s5+kglobhs6), sum(kglobt08+kglobt11), sum(kglobt10), sum(kglobt01), count(*)-1,
sum(decode(kglobhs6,0,0,1)), decode(sum(decode(kglhdlmd,0,0,1)),0,0,sum(decode(k
glhdlmd,0,0,1))-1), sum(kglhdlkc)/2, sum(kglhdexc), sum(kglobpc6), sum(kglhdldc)
-1, substr(to_char(kglnatim,'-MM-DD/HH24:MI:SS'),1,19), sum(kglhdivc), sum(k
globt12), sum(kglobt13), sum(kglobt14), sum(kglobt15), sum(decode(kglobt09,0,kgl
obt02,0)) , decode(count(*)-1, 1, decode(sum(decode(kglobt09,
0, kglobt32, 0)), 0, 'NONE',
 1, 'ALL_ROWS', 2, 'FIRST_ROWS',
 3, 'RULE', 4, 'CHOOSE',
 'UNKNOWN'), 'MULTIPLE CHILDREN PRESENT'), sum(deco


VIEW_DEFINITION

de(kglobt09,0,kglobt17,0)), sum(decode(kglobt09,0,kglobt18,0)), decode(sum(decod
e(kglhdkmk,0,0,1)),0,0,sum(decode(kglhdkmk,0,0,1))-1), kglhdpar, kglnahsh, kglob
ts0, kglobt19, kglobts1, kglobt20, sum(kglobt21) from x$kglcursor group by ins
t_id,kglnaobj,kglhdpar,kglnahsh,kglnatim, kglobts0,
kglobt19, kglobts1, kglobt20 having sum(decode(kglobt09,0,kglobt02,0)) != 0globt19, kglobts1, kglobt20 having sum(decode(kglobt09,0,kglobt02,0)) != 0

RE: Java in the database

2001-10-26 Thread Jamadagni, Rajendra


In a recent class, the instructor mentioned that since JAVA came into
picture, there is an internal race between pl/sql team and java team. One
example of that can be seen at pl/sql native compilation facility. He said,
there is more to come. So don't throw away your pl/sql knowledge, it's in
for the long run.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !



*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

Re: v$sql and v$sqlarea


check out  V$FIXED_VIEW_DEFINITION


--- Greg Moore [EMAIL PROTECTED] wrote:
 I want to understand the difference between v$sql
 and v$sqlarea.  Apparently
 they are both views of the same x$ table.  Does
 anyone know where I can view
 the code that creates these two views?
 
 Thanks.
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Greg Moore
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

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

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

Re: backup of large databases

2001-10-26 Thread Cherie_Machler



Ed,

We have a 180 Gig database on Sun Solaris 2.6, version 8.0.4 of Oracle.

We use RMAN and Veritas to back up to tape.  Archiving is turned on.

Full hot backups are done once a week.  Incremental backups are
done at mid-week.  It takes about eight hours to do the full backup to
tape.

We used to run an hourly RMAN job that would back up our archive files
to tape and then delete them from disk.We found that with the few
recoveries
that we've had to do, the part that took the most time was the robot
finding and mounting
the tapes that contained the archive files.  Our goal is to decrease the
number
of archive files that we have to get off of tape, thereby decreasing our
mean time to recover.

We requested additional disk in order to be able to keep a weeks
worth of archives on hand.   The reality is that we have occasssional
peaks of activity that have frequently caused us to run through most of
our archive directory in a single day.   We're still trying to tweak the
interval
between archive backup jobs.

Our agreement with the users of this database is that we will complete a
database recovery within 12 hours.  To this point, we've been successful
in doing so with the three recoveries that we've had to do.

We've told the users that if they want a faster recovery time, we will need
to implement BCVs (we have EMC disk) or some other, more expensive
solution.

We also do a weekly logical backup using export piped to split UNIX files.
We have not had to do a logical recovery on this database yet.   Since it
is a data warehouse, it is probably faster for them to reload a day's worth
of
data than it us for us to truncate some of the larger tables and re-import
the
data from a dump.

We also do a daily export of just the structure of the data objects without
the
rows of data.

We do not do cold backups on this database.

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
Ed Lewis 
  
eglewis@hotma   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
il.com  cc:   
  
Sent by: Subject: backup of large databases
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
10/26/01 01:51 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Hello,
I'm curious how people handle the backups for
large/very large databases; 200gb or greater.

My questions are not targeted towards any
specific hardware platform, but we are using
Oracle 8.1.7. I'm assuming that archiving is enabled.

Are backups done nightly, or because of
time constraints are they done weekly ?
If weekly, do you feel comfortable having to possibly
apply a week of archives, in the case of a recovery ?

Do you use disk or tape ?

Do you use RMAN or other backup tools ?

What are the customer's expections for recovery and
how do they effect your backup strategy ?

I appreciate your input.

ed




-- 
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: Java in the database


feels good to be re-assured .. even if its a friday.
anyways with the .com bubble burst, java seems back in
the coffe pot for now at least.

hope pl/sql is around too;

Deepak


--- Christopher Spence [EMAIL PROTECTED] wrote:
 Actually I believe it will be, in 9i they clearly
 made some improvements
 (very notable ones) in PL/SQL.  I would suspect it
 will be around for a
 while.
 
 Do not criticize someone until you walked a mile in
 their shoes, that way
 when you criticize them, you are a mile a way and
 have their shoes.
 
 Christopher R. Spence 
 Oracle DBA
 Phone: (978) 322-5744
 Fax:(707) 885-2275
 
 Fuelspot
 73 Princeton Street
 North, Chelmsford 01863
  
 
 
 -Original Message-
 Sent: Thursday, October 25, 2001 2:23 PM
 To: Multiple recipients of list ORACLE-L
 
 Still PL/SQL.
 Hope, it will be supported long enough. (till my
 retirement? :)
 
 Igor Neyman, OCP DBA
 Perceptron, Inc.
 (734)414-4627
 [EMAIL PROTECTED]
 
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Thursday, October 25, 2001 1:16 PM
 
 
 Out of curiosity, is anyone using the java engine
 for procedural code, or
 are most people still using PL/SQL?
 
 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)
 
 Systems Admin  Operations | Admin. et Exploit. des
 systèmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de
 l'informatique
 Maritimes Region, DFO  | Région des Maritimes,
 MPO
 
 E-Mail: [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Boivin, Patrice J
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


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


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

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

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

8.1.7.2 and AQ

2001-10-26 Thread Richard Ji


Just a FYI,

For anyone who is going to patch to 8.1.7.2 and are using AQ should check out Note 
151613.1.

Richard

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

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

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

Title: RE: Hiding tkprof password from ps -ef





Ah, thanks for the reminder Mladen.


-Original Message-
From: Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Hiding tkprof password from ps -ef


Well, Lisa, you're forgetting that some shells leave history of commands in 
files like $HOME/.sh_history and that username and password can be pisked up
from 
there.


-Original Message-
Sent: Friday, October 26, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L




John, it runs so fast, isn't this overkill? Just curious. Of course I have
never been responsible for a system that had anal-type security implemented,
either. 


Lisa Koivu 
Oracle Database Potato currently in Replication Mode. 
Fairfield Resorts, Inc. 
954-935-4117 



 -Original Message- 
Sent: Friday, October 26, 2001 12:20 PM 
To: Multiple recipients of list ORACLE-L 


 Now we have identified how to call sqlloader and sqlplus without
showing the password on a ps -ef anybody know how to do it for a tkprof run?


 John 


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





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



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


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

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

RE: backup of large databases

2001-10-26 Thread DENNIS WILLIAMS


150-gig. Cold backups weekly, archivelog. Uncomfortable with that.
Moving toward RMAN and Veritas for tape.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Friday, October 26, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L


Hello,
I'm curious how people handle the backups for
large/very large databases; 200gb or greater.
  
My questions are not targeted towards any
specific hardware platform, but we are using
Oracle 8.1.7. I'm assuming that archiving is enabled.
 
Are backups done nightly, or because of
time constraints are they done weekly ?
If weekly, do you feel comfortable having to possibly
apply a week of archives, in the case of a recovery ?
  
Do you use disk or tape ?
  
Do you use RMAN or other backup tools ?
 
What are the customer's expections for recovery and
how do they effect your backup strategy ? 
 
I appreciate your input.
 
ed 
 

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

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

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

Re: event= to capture deadlock debug info

2001-10-26 Thread Praveen S


Hello,

I am facing a similar situation which occurs sometimes.  We have some
clients who either due to power or network problems drop their connections.
The problem is that once this happens other clients also have problems in
accessing the particular tables.  There are no ORA-600 nor trace files.
There are no locks either.  The process is still listed as active.  And
after some time, sometimes about an hour, the process stops being shown and
its back to business as usual.

I do need help on this urgently,   please help.

We are using oracle 8.0.3 on NT.

TIA,

Praveen.
--
PS.  Please mail me offline as well.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 4:35 AM


Hi Deepak,

Thanks for the info. The situation may not be a deadlock. I checked the
alert log, no entries when the lock occured. Also no trace file was
generated. On Friday we were unable to simulate the lock condition (proved
the database was pretty indestructable). At this point I'm not sure what may
have caused the situation. I guess I'll have to wait until it happens again
and get the users to wait until I can gather more info befor I fix it.

...JIM...

 [EMAIL PROTECTED] 10/19/01 1:02:35 PM 
Hi James,

setting an event at init/session level would basically
dump the error state into an trc file. ora-60 or
deadlock by defualt writes a message in alert file and
also dumps a large trace in udump.

so why do you want to explicitly set this event? The
default behaviour mimicks the same anyways.

hth
Deepak

--- James Howerton [EMAIL PROTECTED] wrote:
 DBA's

 Does anyone know of an event= to set to capture a
 deadlock condition?

 On two occasions now a user's session has locked up
 due to a network problem or three finger salute or
 who knows what(???) blocking other users from adding
 records to the system. I have to get it fixed
 quickly to get them working again so I don't have
 time to study everything in the locked state before
 killing the offending users session. It has only
 happened twice, once at night and once on a
 holliday. I don't have all of my toys at home to get
 a quick look.

 TIA

 ...JIM...

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

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


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

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

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

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

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

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

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

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

OMW

2001-10-26 Thread Gene Gurevich


Hi all:

I'm having problems using OMW to migrate from mysql
to Oracle8i. If a date field in mysql database has
a default date, OMW doesn't seem to add the to_date
to convert to date from character. Also the numbers
are being converted to oracle numbers with precision
250 which is higher than max precicion allowed in 
Oracle. Does anyone have any experience with that tool
who can shed some light on this?

thanks

=


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

Execution time for export/import vs. alter table move tablespace command

2001-10-26 Thread Cherie_Machler



I am doing a cost justification for upgrading a data warehouse from 8.0.4
to 8.1.7.

I need to submit it today and don't have time to do a test on a very large
table.

Does anyone have anecdotal evidence or experience in the time difference
required to reorg a tablespace using the export/import table method versus
alter table move to a new tablespace method?

Thanks for any time quotes you can provide.   I'm especially interested in
very large tables and tablespaces.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

RE: Execution time for export/import vs. alter table move tablesp

2001-10-26 Thread DENNIS WILLIAMS


Just listened to a talk by Kevin Loney (noted Oracle author). Table-table
data movement (alter table move) is the fastest way to move data in Oracle.
How much faster depends on your system. My experience says twice as fast is
a safe guess. Cost justifying an upgrade?? What ogres do you work for?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, October 26, 2001 2:55 PM
To: Multiple recipients of list ORACLE-L
tablespace command



I am doing a cost justification for upgrading a data warehouse from 8.0.4
to 8.1.7.

I need to submit it today and don't have time to do a test on a very large
table.

Does anyone have anecdotal evidence or experience in the time difference
required to reorg a tablespace using the export/import table method versus
alter table move to a new tablespace method?

Thanks for any time quotes you can provide.   I'm especially interested in
very large tables and tablespaces.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

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

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

RE: OMW

2001-10-26 Thread YTTRI Lisa


Contact Oracle Migration Workbench Support [[EMAIL PROTECTED]].

They were very helpful to me on my conversion from MS SQL Server to Oracle.

-Original Message-
Sent: Friday, October 26, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L


Hi all:

I'm having problems using OMW to migrate from mysql
to Oracle8i. If a date field in mysql database has
a default date, OMW doesn't seem to add the to_date
to convert to date from character. Also the numbers
are being converted to oracle numbers with precision
250 which is higher than max precicion allowed in 
Oracle. Does anyone have any experience with that tool
who can shed some light on this?

thanks

=


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Gurevich
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: backup of large databases

2001-10-26 Thread Richard Ji


We are using RMAN with EDM doing BCV copy of the database.

 [EMAIL PROTECTED] 10/26/01 02:51PM 
Hello,
I'm curious how people handle the backups for
large/very large databases; 200gb or greater.
  
My questions are not targeted towards any
specific hardware platform, but we are using
Oracle 8.1.7. I'm assuming that archiving is enabled.

Are backups done nightly, or because of
time constraints are they done weekly ?
If weekly, do you feel comfortable having to possibly
apply a week of archives, in the case of a recovery ?
  
Do you use disk or tape ?
  
Do you use RMAN or other backup tools ?

What are the customer's expections for recovery and
how do they effect your backup strategy ? 

I appreciate your input.

ed 


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

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

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

2001-10-26 Thread Jim Conboy

Christopher-

Do you have first-hand experience with the performance of Orion, either
within iAS or as a stand-alone servlet engine? The '5x faster' seems to
come from an Oracle source, which I suspect is referring to Java stored and
executed within Oracle. I'm not sure whether Orion as a stand-alone
product can make the same claim. Then again I'm a DBA, not an experienced
Java developer, and am finding ita bit confusingto wade thru the
alphabet soup.

I have a 3rd-party app to install that needs 'any J2EE-compliant' java
servlet engine. I'm looking for something that will provide good
scalability at a good price. The price is right, if Orion scales well then
maybe I won't need iAS for this server since I don't need all the other goodies
that comes along with it. If you have any real-world indications of
scalability I'd appreciate hearing from you. Thanks.

Jim
[EMAIL PROTECTED] 10/26/01 02:51PM

Take a look at
OrionServer (www.orionserver.com)
at $1,500 / server and 5x faster
than Web Logic, I would wonder why people would use others. And OAS9i uses Orion as the core
now.

"Do not criticize
someone until you walked a mile in their shoes, that way when you criticize
them, you are a mile a way and have their shoes."
Christopher
R. Spence Oracle
DBA
Phone:
(978) 322-5744 Fax:
(707) 885-2275
Fuelspot 73
Princeton Street North,
Chelmsford 01863

-Original
Message-From: Jim Conboy
[mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 9:50
AMTo: Multiple recipients of
list ORACLE-LSubject: Re: Java
in the database

Jan-

I've heard some concerns about the
scalability of Tomcat as an app server. Of course, some of those concerns
are voiced by guys like Oracle and BEA who have a nice little Java engine to
sell you for $10-20K per CPU. I know a lot of people use Tomcat for
prototypes and such, then go with one of the big boys for the production
system. Have you - or anyone else - hadTomcat working in a
production environment with, say, 100-200 concurrent users?
Thanks.

Jim
[EMAIL PROTECTED] 10/26/01 08:35AM
PL/SQL.
Java code only on Tomcat-Jakarta (Apache).
JP
On Thu 25. October 2001 19:16, you
wrote: Out of curiosity, is anyone using the java engine for procedural
code, or are most people still using PL/SQL? Regards,
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des syst?mes
Technology Services |
Services technologiques Informatics
Branch | Direction de
l'informatique Maritimes Region, DFO |
Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan
Pruner INET: [EMAIL PROTECTED]
Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051 San
Diego, California -- Public Internet
access / Mailing Lists
To
REMOVE yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
you want to be removed from). You may also send the HELP command for
other information (like subscribing).

pl/sql cd bookshelf book

Title: pl/sql cd bookshelf book





Hello all, 


Does anyone have this book? It says it has the entire PL/SQL Programming Book on it but it doesn't say if it's specifically Feuerstein's book, either on Amazon or on O'Reilly's site. Can anyone confirm that it is Feuerstein's book? 

Thanks


Lisa Koivu
Oracle Database Potato in Replication Mode.
Fairfield Resorts, Inc.
954-935-4117

RE: backup of large databases

2001-10-26 Thread Hand, Michael T




Ed,
We 
have a 550Gb database which we backup nightly via a disk mirror set split. 
The mirror set is then mounted on our failover/reporting hardward and written to 
tape. Archived redo logs are written to tape twice daily and kept on disk 
for 3 days.

8063 
on Compaq Tru64

Mike 
Hand
Polaroid Corp

  -Original Message-From: Ed Lewis 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 2:51 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  backup of large databases
  Hello,
   I'm curious how people handle 
  the backups for
   large/very large databases; 
  200gb or greater.

Re: backup of large databases


We use rman with veritas netbackup.

generally schedule backup everyday .. (incremental)
and weekly full backups .. backups run in night time
and pump data into tapes located on east for databases
located in east coast data center and tape libraries
on west for other set of db's located in west data
center

Deepak


--- Richard Ji [EMAIL PROTECTED] wrote:
 We are using RMAN with EDM doing BCV copy of the
 database.
 
  [EMAIL PROTECTED] 10/26/01 02:51PM 
 Hello,
 I'm curious how people handle the backups for
 large/very large databases; 200gb or greater.
   
 My questions are not targeted towards any
 specific hardware platform, but we are using
 Oracle 8.1.7. I'm assuming that archiving is
 enabled.
 
 Are backups done nightly, or because of
 time constraints are they done weekly ?
 If weekly, do you feel comfortable having to
 possibly
 apply a week of archives, in the case of a
 recovery ?
   
 Do you use disk or tape ?
   
 Do you use RMAN or other backup tools ?
 
 What are the customer's expections for recovery
 and
 how do they effect your backup strategy ? 
 
 I appreciate your input.
 
 ed 
 
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Richard Ji
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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

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

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

SAP and Oracle


Does anyone know if we need to buy our licenses separate for Oracle when
using SAP?  Sometimes, when a vendor product runs on top of a database they
supply that but I do not think SAP is one.  

Thanks a head of time.


Kimberly Smith
GMD Fujitsu
Database Administrator
(503) 669-6050

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly 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: pl/sql cd bookshelf book

Title: pl/sql cd bookshelf book



Yes 
and yes. 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 
  1:35 PMTo: Multiple recipients of list ORACLE-LSubject: 
  pl/sql cd bookshelf book
  Hello all, 
  Does anyone have this book? It says it has the 
  entire PL/SQL Programming Book on it but it doesn't say if it's specifically 
  Feuerstein's book, either on Amazon or on O'Reilly's site. Can anyone 
  confirm that it is Feuerstein's book? 
  Thanks 
  Lisa Koivu Oracle Database 
  Potato in Replication Mode. Fairfield Resorts, 
  Inc. 954-935-4117

Re: Execution time for export/import vs. alter table move tablespace command


you can tweak export import better i feel as move
does not give you too many options. 

we recently did a export of ~60Gb that took us about
45 minutes to complete. This speed was mainly due to
hacking of parameters like buffer etc. however this
was on a high end sun box(not 10K) .. ymmv

Deepak
--- [EMAIL PROTECTED] wrote:
 
 I am doing a cost justification for upgrading a data
 warehouse from 8.0.4
 to 8.1.7.
 
 I need to submit it today and don't have time to do
 a test on a very large
 table.
 
 Does anyone have anecdotal evidence or experience in
 the time difference
 required to reorg a tablespace using the
 export/import table method versus
 alter table move to a new tablespace method?
 
 Thanks for any time quotes you can provide.   I'm
 especially interested in
 very large tables and tablespaces.
 
 Thanks,
 
 Cherie Machler
 Oracle DBA
 Gelco Information Network
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: 
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


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


__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Re:SAP and Oracle

2001-10-26 Thread dgoulet


Kimberley,

I believe you are correct.  PeopleSoft does not either, although they will
for an added premium which is above  beyond Oracle's licensing.

Dick Goulet

Reply Separator
Author: Kimberly Smith [EMAIL PROTECTED]
Date:   10/26/2001 12:35 PM

Does anyone know if we need to buy our licenses separate for Oracle when
using SAP?  Sometimes, when a vendor product runs on top of a database they
supply that but I do not think SAP is one.  

Thanks a head of time.


Kimberly Smith
GMD Fujitsu
Database Administrator
(503) 669-6050

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

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

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

FW: Oracle Training from InterTrain SPAM

Title: FW: Oracle Training from InterTrain SPAM





Anyone else get this spam? 


-Original Message-
From: Cindy Connors [SMTP:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 6:47 PM
To: Bambi Bellows; Brian Norrell; Charlie Mengler; Cherie Machler; Chris Guidry; Danny Hughes; Dave Farnsworth; Don Bricker; Greg Moore; Jack Applewhite; Jacques Kilchoer; James Howerton; Jared Still; Jim Conboy; Joe Testa; Kathy Duret; Kenneth Janusz; Kimberly Smith; Kirti Deshpande; Lisa Koivu; Martin Brown; Mohan Ross; Ramon Estevez; Rick Stephenson; Ron Yount; Ruth Gramolini; Scott Canaan; Shari Dishop; Steve Adams; Steven Lembark; Thomas Mercadante; Val Gamerman

Subject: Oracle Training from InterTrain 


The InterTrain Group is an International IT Training Company specializing in Oracle Training Services. Having established our reputation in the UK with over 6 years of commitment to quality, InterTrain has expanded its highly regarded services into the US, Europe and Australia.

Our training strategy is to provide independent business focused training for the following: 



Oracle Financials - Customized Financials training using your data and developed around your business process. 
Oracle Technical Products - Training on the entire Oracle Suite including Oracle8i, Designer 6i, Discoverer, DBA, Oracle 9iAS, Oracle Portal. 
Legacy Products - Continued training support for Oracle legacy products 




If you would like to know more about our training please visit our web site (be sure and click on the US flag) or call me at our Secaucus, NJ location.

Cindy Connors
National Sales Manager
The InterTrain Group
Office: 201-223-4990
Mobile: 201-965-5982
Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

RE: Java in the database

2001-10-26 Thread Jared . Still



I use Perl.  A lot.  The only thing it can't do is wash my car.

I'm working on that. :)

How about 200k sessions per hour?  2.5 million pages per hour?

http://www.perl.com/pub/a/2001/10/17/etoys.html

Jared



   
 
Christopher
 
Spence   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
cspence@FuelS   cc:   
 
pot.com Subject: RE: Java in the database 
 
Sent by:   
 
[EMAIL PROTECTED] 
 
om 
 
   
 
   
 
10/26/01 11:51 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




So a huge Trading exchange written in Perl?
Not sure about that.  Perl is cool, but I couldn't see it used for
everything.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Thursday, October 25, 2001 7:35 PM
To: Multiple recipients of list ORACLE-L


PL/SQL in the database, Perl everywhere else.

Jared





Boivin, Patrice

J  To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]   cc:

mpo.gc.ca  Subject: Java in the
database
Sent by:

[EMAIL PROTECTED]





10/25/01 10:16 AM

Please respond to

ORACLE-L









Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

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

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

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




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

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

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

RE: pl/sql CD bookshelf book

2001-10-26 Thread Jamadagni, Rajendra

Title: pl/sql cd bookshelf book



Yes,

I have 
it and I love it. It actually has 6 books in it, searchable and definitely nice 
to have.

Raj
__ 
Rajendra 
Jamadagni 
 MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com 
Any opinion expressed here is 
personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an 
art ! 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 
  4:35 PMTo: Multiple recipients of list ORACLE-LSubject: 
  pl/sql cd bookshelf book
  Hello all, 
  Does anyone have this book? It says it has the 
  entire PL/SQL Programming Book on it but it doesn't say if it's specifically 
  Feuerstein's book, either on Amazon or on O'Reilly's site. Can anyone 
  confirm that it is Feuerstein's book? 
  Thanks 
  Lisa Koivu Oracle Database 
  Potato in Replication Mode. Fairfield Resorts, 
  Inc. 954-935-4117 



*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

Re: pl/sql cd bookshelf book

2001-10-26 Thread Bill Conner


At 12:35 PM 10/26/2001 -0800, you wrote:
Hello all,


Does anyone have this book? It says it has the
entire PL/SQL Programming Book on it but it doesn't say if it's
specifically Feuerstein's book, either on Amazon or on O'Reilly's
site. Can anyone confirm that it is Feuerstein's book?

It has all the O'Reilly PL/SQL books on it.

Thanks

Lisa Koivu 
Oracle Database Potato in Replication Mode. 
Fairfield Resorts, Inc. 
954-935-4117

RE: Execution time for export/import vs. alter table move tablesp

2001-10-26 Thread Cherie_Machler



Dennis,

Cost-justifying bringing in an outside resource to perform the required QA
test
cycle.   There is no money or resource currently to do that.  Otherwise,
we'll have
to wait until next year when they can bundle the QA effort for the Oracle
upgrade
in with the next release cycle of our product.

It's kind of weird that the QA schedule and priorities here drive almost
all of
the other schedules and projects.

Thanks for your reply.   On a personal note, are you at the Lifetouch in
Eden Prairie?

Cherie Machler
Oracle DBA
Gelco Information Network


   
   
DENNIS WILLIAMS
   
DWILLIAMS@LIFE   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
TOUCH.COMcc:  
   
Sent by:  Subject: RE: Execution time for 
export/import vs. alter table move  
[EMAIL PROTECTED]tablesp 
   
m  
   
   
   
   
   
10/26/01 03:10 
   
PM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Just listened to a talk by Kevin Loney (noted Oracle author). Table-table
data movement (alter table move) is the fastest way to move data in Oracle.
How much faster depends on your system. My experience says twice as fast is
a safe guess. Cost justifying an upgrade?? What ogres do you work for?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, October 26, 2001 2:55 PM
To: Multiple recipients of list ORACLE-L
tablespace command



I am doing a cost justification for upgrading a data warehouse from 8.0.4
to 8.1.7.

I need to submit it today and don't have time to do a test on a very large
table.

Does anyone have anecdotal evidence or experience in the time difference
required to reorg a tablespace using the export/import table method versus
alter table move to a new tablespace method?

Thanks for any time quotes you can provide.   I'm especially interested in
very large tables and tablespaces.

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

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

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

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

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

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




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to:

RE: backup of large databases




What 
OS are you running Mike? I was thinking of implementing that for some of 
our bigger databases
as the 
IO is brutal during backups.

  -Original Message-From: Hand, Michael T 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 1:35 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  backup of large databases
  Ed,
  We 
  have a 550Gb database which we backup nightly via a disk mirror set 
  split. The mirror set is then mounted on our failover/reporting hardward 
  and written to tape. Archived redo logs are written to tape twice daily 
  and kept on disk for 3 days.
  
  8063 
  on Compaq Tru64
  
  Mike 
  Hand
  Polaroid Corp
  
-Original Message-From: Ed Lewis 
[mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 2:51 
PMTo: Multiple recipients of list ORACLE-LSubject: 
backup of large databases
Hello,
 I'm curious how people 
handle the backups for
 large/very large databases; 
200gb or greater.

RE: Oracle Training from InterTrain SPAM

2001-10-26 Thread Jamadagni, Rajendra

Title: FW: Oracle Training from InterTrain SPAM



I did 
...

Raj
__ 
Rajendra 
Jamadagni 
 MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com 
Any opinion expressed here is 
personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an 
art ! 

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, October 26, 2001 
  4:50 PMTo: Multiple recipients of list ORACLE-LSubject: 
  FW: Oracle Training from InterTrain SPAM
  Anyone else get this spam? 
  


*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

RE: SAP and Oracle

2001-10-26 Thread Todd Carlson


Your SAP license comes with a 'limited-use' Oracle license, which means
you can use it for SAP only. 

Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 ext. 3246

-Original Message-
Smith
Sent: Friday, October 26, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L

Does anyone know if we need to buy our licenses separate for Oracle when
using SAP?  Sometimes, when a vendor product runs on top of a database
they
supply that but I do not think SAP is one.  

Thanks a head of time.


Kimberly Smith
GMD Fujitsu
Database Administrator
(503) 669-6050

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

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

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

# of concurrent connections