RE: Barcode Generation in Forms/Reports

[Sony kristanto]

Hi Kumar,

In my company I have several report that also print the barcode. I think it
isn't big deal if you have font that support the character of barcode.

Rgrds,

Sony

> -Original Message-
> From: Pullikol Kumar [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 06, 2003 12:19 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Barcode Generation in Forms/Reports 
> 
> 
> 
> 
> 
> 
> Hi Lists,
> 
> 
>   How to generate/Read/Print  Barcode using Oracle Forms/Reports ( Windows
> / Unix).
> 
> Please Help.
> 
> Nitheesh
> 
> 
> ***
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Pullikol Kumar
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  INET: [EMAIL PROTECTED]

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

Re: Slightly OT....RAC courses.

[Girijan Puthran]

Mogens,
  Thank You so much  for the information  .Denmark is quite far away indeed but I 
sure can make it if the course is as good as the other courses provided by the miracle 
team.Where do you reckon I can get some more details in this regard.


   
   
  
^^
   
   
  Girijan Reji Puthran
   
   
  Oracle Database administrator
   
   
  Tokyo DBA Team
   
   
   Office Telephone :
81-3-5156-7429
   
   
   Mobile Phone   : 
81-9010419352
   
   
   
^^



--

This e-mail may contain confidential and/or privileged information. If you are not the 
intended recipient (or have received this e-mail in error) please notify the sender 
immediately and destroy this e-mail. Any unauthorized copying, disclosure or 
distribution of the material in this e-mail is strictly forbidden.


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

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

Re: Slightly OT....RAC courses.

[Mogens Nørgaard]

I guess Denmark is a bit far for you to travel? :-). Otherwise, you 
could attend the RAC class Bjorn Engsig does here.

Girijan Puthran wrote:

Are there are good courses available for RAC apart from those offered by Oracle  ? We are planning to implement a RAC setup at our company pretty soon and I would dearly like to take up a course on the subject.


   ^^
   Girijan Reji Puthran
   Oracle Database administrator

^^



--

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.


 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 INET: [EMAIL PROTECTED]

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

RE: Barcode Generation in Forms/Reports

[Abdul Aleem]

Nitheesh,

Please note that bar code is no special thing other than representing
characters in bars.

You can use a font called bar code font that represents characters as bars.
A free version is available to download at www.idautomation.com

The barcode device connected to a computer reads the barcode, and writes its
equivalent numbers at current cursor position. If you cursor is in a text
item in a forms it will display the numbers there, if you cursor is in a
text editor like notepad it will write the numbers there. As if it was typed
in through a keyboard.

Now if you set the font of the field to the barcode font, these characters
will be displayed as a barcode. Both forms and reports support barcode font.

HTH!

Aleem

 -Original Message-
Sent:   Thursday, February 06, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject:Barcode Generation in Forms/Reports 






Hi Lists,


  How to generate/Read/Print  Barcode using Oracle Forms/Reports ( Windows
/ Unix).

Please Help.

Nitheesh


***

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

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

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

RE: Windows 2000 Cluster on oracle

[Bernardus Deddy Hoeydiono]

upto you if you're sure that your Windows is OK.

But, You have to carefull with the service pack in Windows 2K. I suggest if
your O/S (Win2K) running well ,please don't apply the service if not
necessary.

BTW, What kind of server that you used and spec of the server ?

Thank's
Bernardus Deddy Hoeydiono.

-Original Message-
Kirti
Sent: Thursday, February 06, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L


My recent PC runs Win 2000 Server edition. I have two 9i Rel 2 databases
running on it with no problems thus far.
In the past several weeks (since I got it), it has not booted by itself. But
my NT 4.0 Server (3 years old now), did that twice, in the middle of the
night, when no one was watching ;)

- Kirti

-Original Message-
Sent: Wednesday, February 05, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L


As much as I hate defending Windoze, Win2k is in fact rather stable,
at least Win2k server is.  I have one system on Win2k that I reboot,
oh, every 6 months or so.

Death to NT though.

Jared



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

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


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

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

Re: Oracle License for Training

[Maria Aurora VT de la Vega]

Interesting idea! =)
I'll look through the license agreement (OTN) again.
Then find a lawyer who's willing to be a partner...
And who knows...

Thanks a lot to Dennis W, Tim G, Dick G, Stephane F, jeremy P
and Markus R! Thanks to everyone!

I'm still open to any input/ideas/partnerships(?). Feel free to email me.
I'll let you guys know how this little venture goes.

=)

DENNIS WILLIAMS wrote:

> Markus - That is what I call a creative solution! I'm no lawyer either, but
> excellent!
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Wednesday, February 05, 2003 9:34 AM
> To: Multiple recipients of list ORACLE-L
>
> Did you ever consider that your (prospective) trainig candidates get the
> (for testing purposes freely downloadable) oracle software themselves and
> install it themselves (or assisted by you) on a good (linux - one might hope
> ;-)) box and then you assist them by getting along with this?
>
> I think this means, that you would not provide the software yourself - this
> is done by your traning candidates.
>
> As I am neither a jurist nor a lawyer, so I hope this is not pure nonsense -
> especially regarding the license agreement on technet.oracle.com.
>
> Apologies for any typing mistakes I failed to notice
>
> Markus Reger
>
> Oracle Applications DBA
> Webmaster
> MBC
> University for Music and Performing Art
> Vienna
> >>> [EMAIL PROTECTED] 02/05/03 06:15 AM >>>
> A couple of friends and I are thinking of putting up a small training
> company here in the Phils.
> (When we say small...its really small with almost 0
> capitalization...just sheer guts and technical knowhow)
> We have looked at OTN and checked the licensing terms for the use of the
> software for training.
> We have stumbled on this provision:
> You may not:
> ·use the programs to provide third party training;
> I was wondering if any of you know if there is a different licensing for
> training institutions?
> How does a non-oracle partner acquire license to use Oracle DB software
> for training?
> I am looking at partnering with Oracle, but we are just starting and
> partnering costs $$.
> I dare not call Oracle Philippines just yet...If there is a need to
> purchase, and if we have the money, only then will we contact them.
>
> Thanks.
>
> =)
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Maria Aurora VT de la Vega
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Markus Reger
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Maria Aurora VT de la Vega
Oracle DBA
Philippine Stock Exchange, Inc.

"If you don't risk anything, you risk even more."


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, incl

Barcode Generation in Forms/Reports

[Pullikol Kumar]

Hi Lists,


  How to generate/Read/Print  Barcode using Oracle Forms/Reports ( Windows
/ Unix).

Please Help.

Nitheesh


***

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

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

RE: windows application to show sql being executed by a client

[Deshpande, Kirti]

Title: windows application to show sql being executed by a client program



 Pretty cool...
 
 A future Quest product ??? ;) 
 
 
Just wondering...  :)
 
- 
Kirti 
 

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 
  2003 7:59 PMTo: Multiple recipients of list 
  ORACLE-LSubject: windows application to show sql being executed by 
  a client progra
  Hello list members. A colleague of 
  mine has written a small Windows client utility that allows you to view the 
  SQL statements being issued by another client application. The utility has to 
  be running on the same machine as the other client application.
  I use it myself pretty often instead of turning on tracing a 
  session. 
  His description says: - Displays SQL 
  statements that come from processes in real-time, eliminating the necessity to 
  turn on tracing and look into poorly formatted trace file 
  - Allows monitoring NT services - 
  Displays logon attempts, both successful and unsuccessful (username, password, 
  tns alias, success) - Performs syntax highlighting 
  - Displays values of bind variables for SQL statements 
  - Shows even statements that fail to execute. Displays 
  Oracle error code and message for those statements. - 
  Allows to copy and paste statements from the output to one of your SQL 
  analyzing tools (TOAD, SQL Navigator, or even SQL*Plus) 
  - Monitors applications like Import/Export, SQLoader, Server 
  Manager (svrmgrl.exe), as well as applications written with Oracle Forms or 
  Pro*C 
  - Supports Oracle clients starting with version 7.3 
  - It's FREE! 
  He has told me that I can publicize it on the list. All he 
  asks is some feedback / bug reports. Here's the 
  link: http://www.fastalgo.com/ 
  P.S. You should send the feedback to him and not to me. 
  

Oracle DB License - "Named User Multi Server"

[Hemant K Chitale]

When you buy a "Named User" license do you generally
buy a "Named User Single Server" license or a 
"Named User Multi Server" license for the Oracle Database ?

The "Named User Multi Server" license should mean that
a person "A" can connect to any number of databases -- ergo,
as long as the number of users "n" at your site 
does not exceed the "Named User" count, it does not
matter how many databases "m" you create.

The license my organisation had negotiated [when many seperate purchased license 
orders were combined into one] 
a few years ago is "Named User Multi Server".

Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

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

RE: Windows 2000 Cluster on oracle

[Deshpande, Kirti]

My recent PC runs Win 2000 Server edition. I have two 9i Rel 2 databases running on it 
with no problems thus far.
In the past several weeks (since I got it), it has not booted by itself. But my NT 4.0 
Server (3 years old now), did that twice, in the middle of the night, when no one was 
watching ;) 

- Kirti  

-Original Message-
Sent: Wednesday, February 05, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L


As much as I hate defending Windoze, Win2k is in fact rather stable,
at least Win2k server is.  I have one system on Win2k that I reboot,
oh, every 6 months or so.

Death to NT though.

Jared



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

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

Oracle Migration Workbench for Sybase

[Deshpande, Kirti]

Hello Listers,
 Anyone used this tool? What was your experience like? 
 I am planning on using it to move about 20GB of data from a Sybase 11.x database to 
Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp') 
is the alternate solution. I would like see if we could use OMWB for this. The doc 
says I need "Sybase Adaptive Server ODBC driver Release 3.11.00.01".   Searched Sybase 
web site for this driver, but failed to locate it. 
 Any ideas about its source?  

 Thanks.

- Kirti 


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

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

RE: First version with multiple archiver processes?

[Deshpande, Kirti]

I can think of 8.1.3.

- Kirti

-Original Message-
Sent: Wednesday, February 05, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L


What was the first version of Oracle with the ability to start
multiple archiver processes?

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




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

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

RE: How to create a new oracle database from SVRMGRL??

[Jacques Kilchoer]

Title: RE: How to create a new oracle database from SVRMGRL??





If I may be so bold as to add a few details
on a UNIX server you can just fire up sqlplus (or svrmgrl for older versions of Oracle) and issue the create database statement.

On a Windows server you must first create the service with oradim. For example:


%ORACLE_HOME%\bin\oradim -NEW -SID %ORACLE_SID% -startmode m -pfile D:\Oradmin\%ORACLE_SID%\pfile\init%ORACLE_SID%.ora -intpwd my_secret_password -maxusers 4

-startmode m means startmode manual - the instance must be manually started after system reboot.
-intpwd is the password for the sys user
-maxusers 4 is the maximum number of users that can be given SYSDBA capability


Once you've created the database and all the tablespaces, you may want to do the following to avoid annoying warnings everytime you startup SQL*Plus:

create PRODUCT_PROFILE with this script
$ORACLE_HOME/sqplus/admin/pupbld.sql
(I usually create it in the SYSTEM schema)


Create Plus_Trace role
$ORACLE_HOME/sqplus/admin/plustrce.sql


To install SQL*Plus help, look for a file called
%ORACLE_HOME%\bin\helpins.bat on windows
$ORACLE_HOME/bin/helpins on UNIX


Finally, don't forget to change the passwords for SYS, SYSTEM, and other users automatically created by the database creation scripts. And change the TEMPORARY tablespace for users to something other than SYSTEM.

RE: another possibility for running Oracle / UNIX at home

[Jacques Kilchoer]

Title: RE: another possibility for running Oracle / UNIX at home





UNIX is dead? Why does no one tell me these things?
BTW the link I meant to send is this:
http://www.macdevcenter.com/pub/a/mac/2003/01/03/oracle_part3.html
Part 3 goes into the gory details of what is needed for the install.


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
> Damn, nothing like a dead OS that refuses to stay down!!
> 
> Reply Separator
> Author: [EMAIL PROTECTED]
> Date:   2/5/2003 12:54 PM
> 
> See:  http://www.oracle.com/start/apple/intro.html?src="">
> Developer's release of 9iR2 EE for MAC OS X.
> 
> Jacques Kilchoer <[EMAIL PROTECTED]>
> 
> A few days ago someone had asked about what options are available for 
> running Oracle (database) on UNIX at home. 
> I just saw this article: 
> http://www.macdevcenter.com/pub/a/mac/2002/11/12/oracle_part1.html 
> Installing Oracle 9i on Mac OS X, Part 1 
> 

RE: SQL Tuning Help

[DENNIS WILLIAMS]

Sundeep - Have you tried other hints, like FIRST_ROWS? Or are you trying to
avoid hints entirely?

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


-Original Message-
Sent: Wednesday, February 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.7.4 on HP-UX

I am using collections to pass multiple values from client to the
database to gather values for more than input values. The queries
produce the results but the without the RULE hint the response is
dramatically slower. Following is just one of the examples but I have
many many queries which exhibit the same behavior.  

Since RULE based optimization is headed for the chopping block we are
wondering what is the alternative.

SELECT  eqp.equipment_id, 
eqp.manufacturer_code, 
eqp.model_num, 
eqp.equipment_serial_num, 
DECODE(SIGN(eqp.last_pm_performed_at_hrs -
eqp.current_meter_reading_hrs),1,   
'SMU_ADJUSTED',eqp.last_pm_performed_at_hrs) smu_adjusted, 
eqp.productlink_equipment_code, 
ecps.pm_schedule_name, 
epp.performed_datetime, 
DECODE(epp.comment_text,NULL,1,0) comments_available, 
  emr.reading_date, 
emr.meter_reading_value, 
equipment_event_log.event_status(eqp.equipment_id,2), 
equipments_next_pm_due.pms_due_list(eqp.equipment_id) pms_due_list, 
equipments_next_pm_due.perform_at_hrs_cnt(eqp.equipment_id)
next_pm_hrs 
   FROM equipments eqp, 
equipment_meter_readings emr, 
equipment_pm_performed epp, 
equipment_class_pm_schedules ecps, 
TABLE(CAST(id_table_t(100071,100072,100073,100074)
AS id_table_t)) eqp_list 
  WHERE eqp.epp_id_last_pm_performed = epp.epp_id (+) 
AND eqp.emr_id_current_meter_reading = emr.emr_id (+) 
AND epp.ecps_id = ecps.ecps_id (+) 
AND eqp.equipment_id = eqp_list.column_value
/

Plan:
SELECT STATEMENT Hint=CHOOSE8 K 510  
  HASH JOIN OUTER   8 K 582 K   510  
HASH JOIN OUTER 8 K 510 K   497  
  HASH JOIN OUTER   8 K 390 K   489   
HASH JOIN   8 K 279 K   287   
  COLLECTION ITERATOR CONSTRUCTOR FETCH  
  TABLE ACCESS FULL EQUIPMENTS  192 K   6 M 256
TABLE ACCESS FULL   EQUIPMENT_METER_READINGS221 K   2 M
151 
 
  TABLE ACCESS FULL EQUIPMENT_PM_PERFORMED  96  1 K 
TABLE ACCESS FULL   EQUIPMENT_CLASS_PM_SCHEDULES2 K 22 K4  

Following is the Plan with /*+ RULE */ hint has the expected fast
response and the desired plan:

SELECT STATEMENT Hint=HINT: RULE 
  NESTED LOOPS OUTER 
NESTED LOOPS OUTER
  NESTED LOOPS OUTER 
NESTED LOOPS 
  COLLECTION ITERATOR CONSTRUCTOR FETCH  
  TABLE ACCESS BY INDEX ROWID   EQUIPMENTS   
INDEX UNIQUE SCAN   EQP_PK   
TABLE ACCESS BY INDEX ROWID EQUIPMENT_PM_PERFORMED   
  INDEX UNIQUE SCAN EPP_PK   
  TABLE ACCESS BY INDEX ROWID   EQUIPMENT_CLASS_PM_SCHEDULES 
INDEX UNIQUE SCAN   ECPMS_PK 
TABLE ACCESS BY INDEX ROWID EQUIPMENT_METER_READINGS  
  INDEX UNIQUE SCAN EMR_PK

I have tried both versions IN (TABLE(CAST( as a predicate and as a
pseudo-table in FROM (as in the query above) and it made no
difference to the plan. I searched askTOM and heard similar
sentiments about performance being echoed by other users but no
solutions.  

Any tips or insights as to how to avoid the full table scans (all of
which are 10-100M in size) of the large table without the RULE hint.
A more thorough explanation of what is happening and why would be a
bonus.

TIA


=

Sundeep Maini 
Consultant 
Currently on Assignement at Caterpillar Peoria
[EMAIL PROTECTED] 

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: sundeep maini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
als

oracle log file at redhat 7.3

[pomin]

hi all,
how I know where the log directory in oracle 
on redhat 7.3 ?
because I have a problem with my server, I was 
installed redhat 7.3 and oracle 9.0.1 in Dell Power 2650. but after 2 week I get 
a problem is the computer "HANG".
anyone can help me..
please I very appreciate
 
 
Regards,
 
 
Pomin
 

SAN, Heterogenous environments, Backups

[Hemant K Chitale]

We are considering implementing a SAN,
using Sun StorEdge SS9970 [OEM from Hitachi], where database
servers will be a mix of Sun Solaris and HP HPUX
running Oracle 8i, 9i, 9iRAC [in phase-2].

As the database files will be on File Systems [Sun or HP],
the solutions provider says that backups of the
HP file systems cannot be done by the backup server
running Solaris.
The proposal is to use "shadow copies". The Sun Engineer
says that the "shadow copy" must be mounted as a file
system on the backup server and as the backup server is
a Sun server it wouldn't be able to mount the HP file system.

How are Heterogenous implementations on a SAN done ?  How are backups done ?

Hemant K Chitale
http://hkchital.tripod.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

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

Re:Can logminer be used against 7.3 databases?

[Kaing, Leng]

Mogens,

Dick is right. Metalink Note 74988.1: "LogMiner analyzes redo log files from any 
version 8.0 or later database that uses the same database character set and runs on 
the same hardware platform as the analyzing instance"

Rgs,

Leng.

---
 From: [EMAIL PROTECTED]
 Date: Tue, 4 Feb 2003 08:56:35 -0500
 Subject: Re:Can logminer be used against 7.3 databases?

I went to a seminar on Logminer about a year ago.  As I remember you can only
use it against 8.0 or better database logfiles due to the change in rowid's that
occurred.

Dick Goulet

Reply Separator
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= <[EMAIL PROTECTED]>
Date:   2/3/2003 6:13 PM


Friends,

Can logminer be used against 7.3 databases (or rather: 7.3 logfiles) 
like it can be used against 8.0?

Best regards,

Mogens

--
Leng Kaing
Email: [EMAIL PROTECTED]
Phone: +61-417-371-348

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

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

RE: VMware

[Richard Ji]

Not in 
a production environment, but I have been using VMWare Workstation since 2.0 
with Oracle
as my 
test, development platform.  I run various Linux (RH, SuSE) with 
Oracle without much problems.
I have 
found occassionally simutanously start Opera and VMware cause my machine to 
freeze.
 
Now, I 
wouldn't want to run a production Oracle under VMware.  Running Oracle is 
as complex as it
is, 
why add another component to the mix?  You will now have to deal with 
Windows + VMware + Windows + Oracle.  You will have to deal with patching, 
upgrading VMware.  To me, it's not worth it.  It's not 
like
you 
are consolidating 100+ database servers, or are you?
 
Richard Ji

  -Original Message-From: SusanK 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 6:30 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  VMware 
  All,
  I was wondering if anyone has any experience (good or bad) with the use of 
  VMware on Oracle database servers? I am hearing rumors within my company that 
  management is looking to utilize VMware to consolidate our WindowsNT/2000 
  database servers (test, development, and production). At this point I have not 
  been able to find much information relating to the use of VMware in an Oracle 
  environment and I am curious if it is widely used. Any information would be 
  greatly appreciated.
  Thanks!
  Susan Kersting
  [EMAIL PROTECTED]
  
  
  Do you Yahoo!?Yahoo! Mail 
  Plus - Powerful. Affordable. Sign up 
  now

RE: SQL Tuning Help

[Deshpande, Kirti]

Sundeep,
 Have you reviewed Tim Gorman's paper titled: 'The Search For Intelligent Life In The 
Cost-Based Optimizer'? Check it out at http://www.evdbt.com. It may help. 

- Kirti
 

-Original Message-
Sent: Wednesday, February 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L


Oracle 8.1.7.4 on HP-UX

I am using collections to pass multiple values from client to the
database to gather values for more than input values. The queries
produce the results but the without the RULE hint the response is
dramatically slower. Following is just one of the examples but I have
many many queries which exhibit the same behavior.  

Since RULE based optimization is headed for the chopping block we are
wondering what is the alternative.

SELECT  eqp.equipment_id, 
eqp.manufacturer_code, 
eqp.model_num, 
eqp.equipment_serial_num, 
DECODE(SIGN(eqp.last_pm_performed_at_hrs -
eqp.current_meter_reading_hrs),1,   
'SMU_ADJUSTED',eqp.last_pm_performed_at_hrs) smu_adjusted, 
eqp.productlink_equipment_code, 
ecps.pm_schedule_name, 
epp.performed_datetime, 
DECODE(epp.comment_text,NULL,1,0) comments_available, 
  emr.reading_date, 
emr.meter_reading_value, 
equipment_event_log.event_status(eqp.equipment_id,2), 
equipments_next_pm_due.pms_due_list(eqp.equipment_id) pms_due_list, 
equipments_next_pm_due.perform_at_hrs_cnt(eqp.equipment_id)
next_pm_hrs 
   FROM equipments eqp, 
equipment_meter_readings emr, 
equipment_pm_performed epp, 
equipment_class_pm_schedules ecps, 
TABLE(CAST(id_table_t(100071,100072,100073,100074)
AS id_table_t)) eqp_list 
  WHERE eqp.epp_id_last_pm_performed = epp.epp_id (+) 
AND eqp.emr_id_current_meter_reading = emr.emr_id (+) 
AND epp.ecps_id = ecps.ecps_id (+) 
AND eqp.equipment_id = eqp_list.column_value
/

Plan:
SELECT STATEMENT Hint=CHOOSE8 K 510  
  HASH JOIN OUTER   8 K 582 K   510  
HASH JOIN OUTER 8 K 510 K   497  
  HASH JOIN OUTER   8 K 390 K   489   
HASH JOIN   8 K 279 K   287   
  COLLECTION ITERATOR CONSTRUCTOR FETCH  
  TABLE ACCESS FULL EQUIPMENTS  192 K   6 M 256
TABLE ACCESS FULL   EQUIPMENT_METER_READINGS221 K   2 M 151
 
 
  TABLE ACCESS FULL EQUIPMENT_PM_PERFORMED  96  1 K 
TABLE ACCESS FULL   EQUIPMENT_CLASS_PM_SCHEDULES2 K 22 K4  

Following is the Plan with /*+ RULE */ hint has the expected fast
response and the desired plan:

SELECT STATEMENT Hint=HINT: RULE 
  NESTED LOOPS OUTER 
NESTED LOOPS OUTER
  NESTED LOOPS OUTER 
NESTED LOOPS 
  COLLECTION ITERATOR CONSTRUCTOR FETCH  
  TABLE ACCESS BY INDEX ROWID   EQUIPMENTS   
INDEX UNIQUE SCAN   EQP_PK   
TABLE ACCESS BY INDEX ROWID EQUIPMENT_PM_PERFORMED   
  INDEX UNIQUE SCAN EPP_PK   
  TABLE ACCESS BY INDEX ROWID   EQUIPMENT_CLASS_PM_SCHEDULES 
INDEX UNIQUE SCAN   ECPMS_PK 
TABLE ACCESS BY INDEX ROWID EQUIPMENT_METER_READINGS  
  INDEX UNIQUE SCAN EMR_PK

I have tried both versions IN (TABLE(CAST( as a predicate and as a
pseudo-table in FROM (as in the query above) and it made no
difference to the plan. I searched askTOM and heard similar
sentiments about performance being echoed by other users but no
solutions.  

Any tips or insights as to how to avoid the full table scans (all of
which are 10-100M in size) of the large table without the RULE hint.
A more thorough explanation of what is happening and why would be a
bonus.

TIA


=

Sundeep Maini 
Consultant 
Currently on Assignement at Caterpillar Peoria
[EMAIL PROTECTED] 

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

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

RE: Sql query

[Sony kristanto]

Hi Roland,

I make a little modification to your query below,

SELECT distinct PBK.VARUKORGEANREL_ULAG.ean, 0, 0, 0,
rik2.vare.varenavn, rik2.vare.str,
  PBK.VARUKORGEANREL_ULAG.lagstapris,
rik2.vare.hylletxt2, rik2.art_hierarki.vgrp, rik2.hierarki_tekst.tekst,
  '0', '0', 0, pbk.underlag.period,
'rsm',pbk.sortiment_vgrp.sortiment,rik2.art_hierarki.art_grp,rik2.art_hierar
ki.art_ugrp
FROM PBK.UNDERLAG, PBK.VARUKORGEANREL_ULAG, rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki,
  pbk.sortiment_vgrp
WHERE PBK.underlag.underlagid=1100
AND   PBK.underlag.varukorgid=PBK.varukorgeanrel_ulag.varukorgid
ANDPBK.VARUKORGEANREL_ulag.varutyp=0

I think you miss to join another four tables,
AND   RIK2.VARE = RIK2.HIERARKI_TEKST
AND   RIK2.HIERARKI_TEKST = RIK2.ART_HIERARKI
AND   RIK2.ART_HIERARKI = PBK..SOTIMENT_VGRP;

Hope this is what you mean.

Rgrds,

Sony


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 05, 2003 9:53 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Sql query
> 
> 
> I have  this sql query. I am wondering why this query takes so long time,
> Do I need more conditions to make it run, or it it just that this query
> take so long time to run? Anything wrong with the query?
> 
> Please help me with this.
> 
>  SELECT distinct PBK.VARUKORGEANREL_ULAG.ean, 0, 0, 0, rik2.vare.varenavn,
> rik2.vare.str, PBK.VARUKORGEANREL_ULAG.lagstapris, rik2.vare.hylletxt2,
> rik2.art_hierarki.vgrp, rik2.hierarki_tekst.tekst, '0', '0', 0,
> pbk.underlag.period,
> 'rsm',pbk.sortiment_vgrp.sortiment,rik2.art_hierarki.art_grp,rik2.art_hier
> arki.art_ugrp
>  FROM PBK.UNDERLAG, PBK.VARUKORGEANREL_ULAG, rik2.vare,
> rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp
>  WHERE PBK.underlag.underlagid=1100
>  AND PBK.underlag.varukorgid=PBK.varukorgeanrel_ulag.varukorgid
>  AND PBK.VARUKORGEANREL_ulag.varutyp=0;
> 
> 
> Thanks in advance
> 
> 
> Roland
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  INET: [EMAIL PROTECTED]

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

windows application to show sql being executed by a client progra

[Jacques Kilchoer]

Title: windows application to show sql being executed by a client program





Hello list members.
A colleague of mine has written a small Windows client utility that allows you to view the SQL statements being issued by another client application. The utility has to be running on the same machine as the other client application.

I use it myself pretty often instead of turning on tracing a session.


His description says:
- Displays SQL statements that come from processes in real-time, eliminating the necessity to turn on tracing and look into poorly formatted trace file 

- Allows monitoring NT services 
- Displays logon attempts, both successful and unsuccessful (username, password, tns alias, success) 
- Performs syntax highlighting 
- Displays values of bind variables for SQL statements 
- Shows even statements that fail to execute. Displays Oracle error code and message for those statements. 
- Allows to copy and paste statements from the output to one of your SQL analyzing tools (TOAD, SQL Navigator, or even SQL*Plus) 

- Monitors applications like Import/Export, SQLoader, Server Manager (svrmgrl.exe), as well as applications written with Oracle Forms or Pro*C 

- Supports Oracle clients starting with version 7.3 
- It's FREE! 


He has told me that I can publicize it on the list. All he asks is some feedback / bug reports.
Here's the link:
http://www.fastalgo.com/


P.S. You should send the feedback to him and not to me.

RE: Windows 2000 Cluster on oracle

[DENNIS WILLIAMS]

Stephen - I appreciate your comments. One of the hard things for me to
understand is that if you're going to be working on W2K, better plan on
being the administrator. At Unix sites we tend to have DBAs supported by sys
admins. Some shops may indeed treat W2K that way. But usually if you are
always asking the NT administrator to do tasks that the sys admins always
insisted they do on Unix, you end up being viewed as some sort of novice or
old crank that isn't self-sufficient like everyone else. 
   At our company, to get around some issues of developers just messing
around with production W2K servers like it was their own PC, we are looking
to the ITIL standards and creating a staging server between test and
production. This will be a mirror of production. Software and installation
instructions will be provided by developers. A test install will be
performed on staging, and some tests performed. If everything is okay, then
it will be scheduled for a production install. If problems are encountered,
it will be bounced back to the developers to get their act together. Has
anyone tried this? Overkill/impractical?

-Original Message-
Sent: Wednesday, February 05, 2003 4:42 PM
To: Multiple recipients of list ORACLE-L



> -Original Message-
> 
> As much as I hate defending Windoze, Win2k is in fact rather stable,
> at least Win2k server is.  I have one system on Win2k that I reboot,
> oh, every 6 months or so.
> 
> Death to NT though.
> 

The biggest problem that I have seen is (to me anyway) not one of stability
(I'll leave that to the bare-metal boys to argue about) but that it is not
really multi-user.  I think it only supports two users.

1. You're an administrator and can do anything you want.
2. You're not an administrator and can't do squat.

The idea of an application owner, somewhere in between -- someone who needs
to stop and start the app; install patches and upgrades to the app; but only
have access to his/her stuff and nobody else's stuff -- doesn't seem to be
well supported.  So the person who has a web app on the same box as your
database has complete access (or can take it) to any of your stuff.

Then there is the issue of all the missing Unix scripting utilities ...
which I suppose you can install ... if you are *THE* administrator and not
just *AN* administrator ... because we sure don't want *AN* administrator
pissing off *THE* administrator ... which the Oracle DBA in a company of any
size probably is not.  And you have to listen to *THE* administrators
constantly whine about the Oracle DBA being *AN* administrator, and
"accidentally" revoking the DBA's admin privileges from time to time.

Then there is the issue of doing all your admin stuff on a 28K dial-up line
after hours; NOT where you want to use a GUI!  But *THE* administrators have
only made provision for their easy dial-up access; and screw anyone who
might only be *AN* administrator.

> Windows is cheaper than SUN. Linux is cheaper than Windows.

Try comparing prices for a large Dell Xeon box versus a Sun V880 box.  The
bigger you get, the more competitive the mainline Unix boys get.

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

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

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

RE: Hanging query puzzle

[Deshpande, Kirti]

Jeff,

If you see the SEQ# field in the v$session_wait view not incrementing, then something 
else, other than Oracle, is causing a hang up... 

On AIX, if you have AIO enabled, try running 'aiostat'. It will show if there are any 
pending AIO requests. The difficult part would be to relate those pending calls to 
your session. It is quite likely that a particular AIO server may show waits on I/O, 
if this hang up is IO related. You can try 'pstat' to find out AIO server processes 
and associated 'pid' to dig deeper.  

If you do not have 'aiostat', ring up IBM Support. It is a nice utility to have, and 
it is free. 


For those on AIX 5L, can you please check if 'aiostat' is available as a standard 
distribution? I was told by IBM Support that 'aiostat' was going to be available with 
AIX 5L.  

- Kirti  

-Original Message-
Sent: Wednesday, February 05, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L



It looks like your process really is stuck
in a way that has nothing to do with the
Oracle code directly.

You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU.  Perhaps truss (or the AIX
equivalent) might show your process
spinning on whatever call equates to
'has the async read completed yet'.


You could try doing three processstate
dumps with 5 second intervals to see if
the processstate shows any changes
which might give you a hint - but again
I'd GUESS that you'll find nothing happening.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 05 February 2003 21:05


>Still sitting there, while we try to figure out exactly why it's
waiting.
>
>
>  SID Username EVENT
>WAIT_TIME STATE   SECONDS_IN_WAIT
>-  --

>-- --- ---
>1  pmon timer
>0 WAITING   79579
>5  smon timer
>0 WAITING  80
>   12  slave wait
>0 WAITING 199
>   13  slave wait
>0 WAITING 199
>   14  slave wait
>0 WAITING 262
>   15  slave wait
>0 WAITING 199
>   28 NIK  db file scattered read
>0 WAITING   20119
>
>-Original Message-
>Sent: Wednesday, February 05, 2003 2:58 PM
>To: [EMAIL PROTECTED]
>Cc: Thomas Jeff
>



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

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

RE: Windows 2000 Cluster on oracle

[Richard Ji]

Oh yeah, the thing I hate most about Windows as a server.
Try to do remote administration from any machine regardless of the OS.

Richard Ji

-Original Message-
Sent: Wednesday, February 05, 2003 5:42 PM
To: Multiple recipients of list ORACLE-L



> -Original Message-
> 
> As much as I hate defending Windoze, Win2k is in fact rather stable,
> at least Win2k server is.  I have one system on Win2k that I reboot,
> oh, every 6 months or so.
> 
> Death to NT though.
> 

The biggest problem that I have seen is (to me anyway) not one of stability
(I'll leave that to the bare-metal boys to argue about) but that it is not
really multi-user.  I think it only supports two users.

1. You're an administrator and can do anything you want.
2. You're not an administrator and can't do squat.

The idea of an application owner, somewhere in between -- someone who needs
to stop and start the app; install patches and upgrades to the app; but only
have access to his/her stuff and nobody else's stuff -- doesn't seem to be
well supported.  So the person who has a web app on the same box as your
database has complete access (or can take it) to any of your stuff.

Then there is the issue of all the missing Unix scripting utilities ...
which I suppose you can install ... if you are *THE* administrator and not
just *AN* administrator ... because we sure don't want *AN* administrator
pissing off *THE* administrator ... which the Oracle DBA in a company of any
size probably is not.  And you have to listen to *THE* administrators
constantly whine about the Oracle DBA being *AN* administrator, and
"accidentally" revoking the DBA's admin privileges from time to time.

Then there is the issue of doing all your admin stuff on a 28K dial-up line
after hours; NOT where you want to use a GUI!  But *THE* administrators have
only made provision for their easy dial-up access; and screw anyone who
might only be *AN* administrator.

> Windows is cheaper than SUN. Linux is cheaper than Windows.

Try comparing prices for a large Dell Xeon box versus a Sun V880 box.  The
bigger you get, the more competitive the mainline Unix boys get.

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

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

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

RE: Drop datafile.

[Sony kristanto]

Hi Sesi,

Have restart your Oracle ?

Rgrds,

Sony

> -Original Message-
> From: Sesi Odury [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 05, 2003 9:53 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Drop datafile.
> 
> Hi,
> 
> I restored the database from cold backup. There seems to be a problem with
> one of the datafiles. Since there is no useful data in it, I tried
> dropping it using...
> 
> SQL> ALTER DATABASE DATAFILE '' OFFLINE DROP;
> 
> Database altered.
> 
> 
> I also deleted the physical file by going to that location and deleting
> it.
> However I still find the datafile existing. 
> 
> SQL> select name, status from v$datafile;
> I still find the datafile.
> 
> Can someone suggest me something??
> 
> Thanks a lot...
> Sesi
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Sesi Odury
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  INET: [EMAIL PROTECTED]

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

RE: 7.3.4 upgrade

[Deshpande, Kirti]

Hmm... there was nothing in that attachment... :(

When I did this, I followed the Migration Utility Guide. Those steps always worked... 
:) 

- Kirti 

-Original Message-
Sent: Wednesday, February 05, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L


Wow, never thought I'd see a request like this. :)
Nothing wrong to ask though, who knows, someone here might
have the time and resource to do it.

Let me know the kind soul who will do this.  I have a list
of my own test to give out.

:)

Richard Ji

-Original Message-
Sent: Wednesday, February 05, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


Hi Listers,

I've prepared a small list of steps to follow for
an upgrade of 7.3.4 database to 9.2

However unfortunately I do not have access to a 7.3.4 database

Can one of you who has access to 7.3.4 database, try these steps
out and give me your 'honest' feedback?

Thanks a lot

Cyril


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

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

First version with multiple archiver processes?

[Jeremiah Wilton]

What was the first version of Oracle with the ability to start
multiple archiver processes?

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

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

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

VMware

[SusanK]

All,
I was wondering if anyone has any experience (good or bad) with the use of VMware on Oracle database servers? I am hearing rumors within my company that management is looking to utilize VMware to consolidate our WindowsNT/2000 database servers (test, development, and production). At this point I have not been able to find much information relating to the use of VMware in an Oracle environment and I am curious if it is widely used. Any information would be greatly appreciated.
Thanks!
Susan Kersting
[EMAIL PROTECTED]Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

RE: Hanging query puzzle

[Thomas Jeff]

Title: RE: Hanging query puzzle





Jonathan, Charlie, Denny:   Thanks for the replies.    Our SA's claim that there's
nothing wrong with the EMC SAN/disk.   Finally, made them give me errpt access (they 
had shut off execute privs from all but them) and got a lot of output like below.  


The SAs are saying that this is only a sporadic 'repathing' error, as we have
4 channels to the SAN, and does not affect the data in anyway, except for possibly
some 'speed'.    Now, 'sporadic' exactly describes the problem.    I tracked down the
dates on this errpt and they do correlate to the dates when we encountered hang
problems in the database.


What exactly would they mean by 'repathing'?   Possibly related to Jonathan's hint 
on spinning on 'has the async read completed yet'?


[indysdb02][/home/tmm_dbas/u26905]>errpt
IDENTIFIER TIMESTAMP  T C RESOURCE_NAME  DESCRIPTION
79B0DF89   0205091603 P H hdisk7 DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk8 DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk13    DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk13    DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk12    DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk11    DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk9 DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk5 DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk3 DISK OPERATION ERROR
79B0DF89   0205091603 P H hdisk6 DISK OPERATION ERROR


-Original Message-
From: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Hanging query puzzle




It looks like your process really is stuck
in a way that has nothing to do with the
Oracle code directly.


You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU.  Perhaps truss (or the AIX
equivalent) might show your process
spinning on whatever call equates to
'has the async read completed yet'.



You could try doing three processstate
dumps with 5 second intervals to see if
the processstate shows any changes
which might give you a hint - but again
I'd GUESS that you'll find nothing happening.



Regards


Jonathan Lewis
http://www.jlcomp.demon.co.uk


Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )


UK___March 19th
USA_(FL)_May 2nd



Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )


USA_(CA, TX)_August



The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 05 February 2003 21:05



>Still sitting there, while we try to figure out exactly why it's
waiting.
>
>
>  SID Username EVENT
>WAIT_TIME STATE   SECONDS_IN_WAIT
>-  --

>-- --- ---
>    1  pmon timer
>0 WAITING   79579
>    5  smon timer
>0 WAITING  80
>   12  slave wait
>0 WAITING 199
>   13  slave wait
>0 WAITING 199
>   14  slave wait
>0 WAITING 262
>   15  slave wait
>0 WAITING 199
>   28 NIK  db file scattered read
>0 WAITING   20119
>
>-Original Message-
>Sent: Wednesday, February 05, 2003 2:58 PM
>To: [EMAIL PROTECTED]
>Cc: Thomas Jeff
>



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


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

SQL Tuning Help

[sundeep maini]

Oracle 8.1.7.4 on HP-UX

I am using collections to pass multiple values from client to the
database to gather values for more than input values. The queries
produce the results but the without the RULE hint the response is
dramatically slower. Following is just one of the examples but I have
many many queries which exhibit the same behavior.  

Since RULE based optimization is headed for the chopping block we are
wondering what is the alternative.

SELECT  eqp.equipment_id, 
eqp.manufacturer_code, 
eqp.model_num, 
eqp.equipment_serial_num, 
DECODE(SIGN(eqp.last_pm_performed_at_hrs -
eqp.current_meter_reading_hrs),1,   
'SMU_ADJUSTED',eqp.last_pm_performed_at_hrs) smu_adjusted, 
eqp.productlink_equipment_code, 
ecps.pm_schedule_name, 
epp.performed_datetime, 
DECODE(epp.comment_text,NULL,1,0) comments_available, 
  emr.reading_date, 
emr.meter_reading_value, 
equipment_event_log.event_status(eqp.equipment_id,2), 
equipments_next_pm_due.pms_due_list(eqp.equipment_id) pms_due_list, 
equipments_next_pm_due.perform_at_hrs_cnt(eqp.equipment_id)
next_pm_hrs 
   FROM equipments eqp, 
equipment_meter_readings emr, 
equipment_pm_performed epp, 
equipment_class_pm_schedules ecps, 
TABLE(CAST(id_table_t(100071,100072,100073,100074)
AS id_table_t)) eqp_list 
  WHERE eqp.epp_id_last_pm_performed = epp.epp_id (+) 
AND eqp.emr_id_current_meter_reading = emr.emr_id (+) 
AND epp.ecps_id = ecps.ecps_id (+) 
AND eqp.equipment_id = eqp_list.column_value
/

Plan:
SELECT STATEMENT Hint=CHOOSE8 K 510  
  HASH JOIN OUTER   8 K 582 K   510  
HASH JOIN OUTER 8 K 510 K   497  
  HASH JOIN OUTER   8 K 390 K   489   
HASH JOIN   8 K 279 K   287   
  COLLECTION ITERATOR CONSTRUCTOR FETCH  
  TABLE ACCESS FULL EQUIPMENTS  192 K   6 M 256
TABLE ACCESS FULL   EQUIPMENT_METER_READINGS221 K   2 M 151
 
 
  TABLE ACCESS FULL EQUIPMENT_PM_PERFORMED  96  1 K 
TABLE ACCESS FULL   EQUIPMENT_CLASS_PM_SCHEDULES2 K 22 K4  

Following is the Plan with /*+ RULE */ hint has the expected fast
response and the desired plan:

SELECT STATEMENT Hint=HINT: RULE 
  NESTED LOOPS OUTER 
NESTED LOOPS OUTER
  NESTED LOOPS OUTER 
NESTED LOOPS 
  COLLECTION ITERATOR CONSTRUCTOR FETCH  
  TABLE ACCESS BY INDEX ROWID   EQUIPMENTS   
INDEX UNIQUE SCAN   EQP_PK   
TABLE ACCESS BY INDEX ROWID EQUIPMENT_PM_PERFORMED   
  INDEX UNIQUE SCAN EPP_PK   
  TABLE ACCESS BY INDEX ROWID   EQUIPMENT_CLASS_PM_SCHEDULES 
INDEX UNIQUE SCAN   ECPMS_PK 
TABLE ACCESS BY INDEX ROWID EQUIPMENT_METER_READINGS  
  INDEX UNIQUE SCAN EMR_PK

I have tried both versions IN (TABLE(CAST( as a predicate and as a
pseudo-table in FROM (as in the query above) and it made no
difference to the plan. I searched askTOM and heard similar
sentiments about performance being echoed by other users but no
solutions.  

Any tips or insights as to how to avoid the full table scans (all of
which are 10-100M in size) of the large table without the RULE hint.
A more thorough explanation of what is happening and why would be a
bonus.

TIA


=

Sundeep Maini 
Consultant 
Currently on Assignement at Caterpillar Peoria
[EMAIL PROTECTED] 

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: sundeep maini
  INET: [EMAIL PROTECTED]

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

Re: Hanging query puzzle

[Denny Koovakattu]

  Thanks. Didn't know that. See you in Dallas next Sunday ;)

Regards,
Denny

Quoting Jonathan Lewis <[EMAIL PROTECTED]>:

> 
> Just a warning for the future - this is no longer true
> on all versions of Oracle 9 because the wait_time
> column is a copy of the underlying x$ timing
> column rounded from microseconds to hundredths.
> Hence the wait_time can show a zero when the
> actual time is non-zero.
> 
> You should depend only on the STATE column
> which is a decode of the basic microsecond value,
> and shows 'WAITING' if and only if the microsecond
> time is zero.
> 
> 
> Regards
> 
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
> 
> Coming soon one-day tutorials:
> Cost Based Optimisation
> Trouble-shooting and Tuning
> Indexing Strategies
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
> 
> UK___March 19th
> USA_(FL)_May 2nd
> 
> 
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
> 
> USA_(CA, TX)_August
> 
> 
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> 
> 
> -Original Message-
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: 05 February 2003 20:50
> 
> 
> >
> >  What is the value for WAIT_TIME ? This may not be an IO problem
> > if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME'
> is 0.
> >
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jonathan Lewis
>   INET: [EMAIL PROTECTED]

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

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

RE: Windows 2000 Cluster on oracle

[Stephen Lee]

> -Original Message-
> 
> As much as I hate defending Windoze, Win2k is in fact rather stable,
> at least Win2k server is.  I have one system on Win2k that I reboot,
> oh, every 6 months or so.
> 
> Death to NT though.
> 

The biggest problem that I have seen is (to me anyway) not one of stability
(I'll leave that to the bare-metal boys to argue about) but that it is not
really multi-user.  I think it only supports two users.

1. You're an administrator and can do anything you want.
2. You're not an administrator and can't do squat.

The idea of an application owner, somewhere in between -- someone who needs
to stop and start the app; install patches and upgrades to the app; but only
have access to his/her stuff and nobody else's stuff -- doesn't seem to be
well supported.  So the person who has a web app on the same box as your
database has complete access (or can take it) to any of your stuff.

Then there is the issue of all the missing Unix scripting utilities ...
which I suppose you can install ... if you are *THE* administrator and not
just *AN* administrator ... because we sure don't want *AN* administrator
pissing off *THE* administrator ... which the Oracle DBA in a company of any
size probably is not.  And you have to listen to *THE* administrators
constantly whine about the Oracle DBA being *AN* administrator, and
"accidentally" revoking the DBA's admin privileges from time to time.

Then there is the issue of doing all your admin stuff on a 28K dial-up line
after hours; NOT where you want to use a GUI!  But *THE* administrators have
only made provision for their easy dial-up access; and screw anyone who
might only be *AN* administrator.

> Windows is cheaper than SUN. Linux is cheaper than Windows.

Try comparing prices for a large Dell Xeon box versus a Sun V880 box.  The
bigger you get, the more competitive the mainline Unix boys get.

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

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

RE: 7.3.4 upgrade

[Richard Ji]

Wow, never thought I'd see a request like this. :)
Nothing wrong to ask though, who knows, someone here might
have the time and resource to do it.

Let me know the kind soul who will do this.  I have a list
of my own test to give out.

:)

Richard Ji

-Original Message-
Sent: Wednesday, February 05, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L


Hi Listers,

I've prepared a small list of steps to follow for
an upgrade of 7.3.4 database to 9.2

However unfortunately I do not have access to a 7.3.4 database

Can one of you who has access to 7.3.4 database, try these steps
out and give me your 'honest' feedback?

Thanks a lot

Cyril


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

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

RE: RH AS2.1 (was: RAC on linux)

[Jesse, Rich]

Right.  Sorry for the misnomenclature.  Whoops, that's not actually a word.
:)  I associated "raw" with "FS", instead of "volume".  My faux pas.

I wanted to determine the need for RHAS for a test setup, and if there were
any differences in the RHAS' purchase levels that would affect a production
box.

Thx!
Rich


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


-Original Message-
Sent: Wednesday, February 05, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L


OCFS = Oracle Cluster File System.  An open source project lead
by Wim Coekaerts from Oracle.  There is no such thing as raw FS,
it's just raw (without any file system).  And I just learned about
this NBD (Network Block Device) from this list.  So that's a third
option.

Richard Ji

-Original Message-
Sent: Wednesday, February 05, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


OFCS?  If not that, then it's left to a raw FS, correct?

Just trying to get some config possibilities here for an upcoming test
(hopefully)...

Rich

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

-Original Message-
Sent: Monday, February 03, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L


I think it's just the support that's different in base vs standard and
premium.
RH made the source RPM available for download, there are litertlly thousands
of
them.

And to answer your previous e-mail, you don't necessarily need RHAS to play
with
RAC.  The only reason you need RHAS is if you want to use OCFS.

-Original Message-
Sent: Monday, February 03, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L


In the same vane, does anyone know the difference between the "Base",
"Standard", and "Premium" versions of RH AS2.1?  And will any of these work
with 9i RAC (if the difference is more than just support)?  And I don't
suppose it's available for download anywhere for testing, is it?

The RedHat site isn't very helpful here...

TIA!
Rich
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re: How to dump UGA ??

[Jonathan Lewis]

Too easy ;)

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


Next Seminar dates: 
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 05 February 2003 20:09


>Jonathan:
>
>How about calling the DBMS_SYSTEM.READ_EV procedure?
>I think this is simpler than going to the UGA dumps..
>


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

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

RE: RMAN - questions.. Rob Freeman?

[Freeman Robert - IL]

Take a look at this link, it might be helpful...

http://portal1.legato.com/resources/whitepapers/W012.pdf

Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 2:16 PM


I am considering doing an rman to disk backup and recovery solution for
a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent
users

This rman would be the secondary recovery solution (Timefinder is
the
first).

 Anybody know time frames I might be able to restore/backup 500Gig to
1terabyte
of database from disk?  

  I will perform it before it goes live but I would like get a
ball park idea of restore times before hand so we can determine if it
can
fit 
in the SLA requirements. 

Any parameters to focus on to improve performance other than
 allocating channels?


Thanks for any help
Brian Spears


-Original Message-
Sent: Wednesday, February 05, 2003 9:53 AM
To: Multiple recipients of list ORACLE-L


Check out the doc's at tahiti.oracle.com and look up the parameter
noprompt.

Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 5:48 AM

Hello List,

I think my question is very simple...

How to execute RMAN command DELETE OBSOLETE from script without
confirmation question to remove obsolete backups
automatically?

Many thanks for your help.
-- 
Best regards,
Alex  mailto:[EMAIL PROTECTED]

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

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

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

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

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

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

RE: Size of a Long Field

[Jamadagni, Rajendra]

Using pl/sql convert long column to clob and then use 
dbms_lob.get_length().
 
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: Janardhana Babu Donga 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 2:30 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Size of a Long Field
  Try 
  this,
   
  Select 
  table_name,column_name,data_length,data_type 
  from 
  dba_tab_columns 
  where 
  owner = '' 
  and 
  data_type='LONG' ;
   
  -- 
  Babu
  
-Original Message-From: Ed Bittel 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 
2003 6:53 AMTo: Multiple recipients of list 
ORACLE-LSubject: Size of a Long Field

How do you determine the size, 
in bytes, of a long field?
 
Please. No tape measure 
jokes.
 
Ed
 
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:RE: Size of a Long Field

[dgoulet]

Dennis,

Vsize does not like longs!!

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   2/5/2003 11:29 AM

Ed - Look up the function VSIZE in the documentation.



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

-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L



How do you determine the size, in bytes, of a long field?

 

Please. No tape measure jokes.

 

Ed

 

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

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

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

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

RE: Size of a Long Field

[Richard Ji]

This is for LONG.  For LONG RAW, you could use utl_raw.length
or use a C or Java program to read it and calculate the length.

CREATE OR REPLACE FUNCTION l_length(cTabName varchar2,
cColName varchar2,
cRowid   varchar2)
RETURN NUMBER
IS
   cur_id integer;
   buff   varchar2(32767);
   leninteger;
   offset integer;
   v_length integer;
   stmt varchar2(500);
   retinteger;
BEGIN
  stmt :=  ' SELECT  '|| cColName || ' FROM  ' || cTabName ||
   ' WHERE rowid = '||||cRowid||;
  cur_id := dbms_sql.open_cursor;
  dbms_sql.parse(cur_id, stmt, dbms_sql.NATIVE);
  dbms_sql.define_column_long(cur_id, 1);
  ret := dbms_sql.execute(cur_id);
  IF (dbms_sql.fetch_rows(cur_id) > 0 )
  THEN
offset := 0;
  len := 0;
LOOP
 dbms_sql.column_value_long(cur_id, 1,32767, offset,
 buff,  v_length);
 len := len + v_length;
EXIT  WHEN v_length < 32767;
  offset := offset + v_length;
END LOOP;
  END IF;
  dbms_sql.close_cursor(cur_id);
  return( len );
END;
/

-Original Message-
Sent: Wednesday, February 05, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L


Not easy. If your LONG is shorter than 32767, then you can, in a PL/SQL
function, fetch it into a VARCHAR2 of this size (allowed in PL/SQL) and
aplly LENGTH() to this VARCHAR2. Assuming the suitable Oracle version, I
think there is somewhere a function to convert LONGs to CLOBs - to which
you can apply a function. With Pro*C or the OCIs, you can derived the
length from the error you get when fetching into too small a buffer ...
-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

RE: Size of a Long Field

[DENNIS WILLIAMS]

Oops, my bad. Well I have limited experience with longs because I hate them
with a passion. Whenever one of the developers says they are going to use
long, I say "not on my database". You people are only making me feel better
about that philosophy.

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


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L



Dennis,

Using VSize on a Long results in:
  ORA-00997: illegal use of LONG datatype

Just tried in on Trigger_Body in DBA_Triggers.  (8.1.7.0.0 on HP-UX).

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]



 

  DENNIS WILLIAMS

<[EMAIL PROTECTED]>

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  RE: Size of a Long
Field  
 

 

  02/05/2003 01:29

  PM

  Please respond to

  ORACLE-L

 

 





Ed - Look up the function VSIZE in the documentation.

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

-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L


How do you determine the size, in bytes, of a long field?



Please. No tape measure jokes.



Ed


--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]





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

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

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

RE: RMAN - questions.. Rob Freeman?

[Freeman Robert - IL]

Is this all live OLTP type data, or might some of the data be made
read-only? How much will the data be growing and changing (if not a great
deal then look into incrementals). I can't begin to guess at the time
required those numbers are all factors of:

1. # of backup devices you will be backing up to (I'd suggest several,
minimum of probably 6).

2. Speed of backup devices.

3. Speed of infrastructure from DB to the backup devices.

Given a best case, lots of backup devices to backup to in parallel, fast
fast infrastructure and really fast (and expensive) equipment, you could
backup 1TB in an hour or two... Realisticly, much much longer, perhaps
upwards of 10-12+ hours at a moderate price range. You could stagger these
backups over the week, backup some tablespaces and all archived redo logs on
day one, other tablespaces and archived redo logs on day two and so on. This
staggered approach will reduce the overhead associated with a large, long
lasting backup.

Recovery of a TB will take a while of course, be prepared for that when
negotiating your SLA's.

A product like BMC's timefinder makes a good primary backup/recovery
solution.

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 2:16 PM


I am considering doing an rman to disk backup and recovery solution for
a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent
users

This rman would be the secondary recovery solution (Timefinder is
the
first).

 Anybody know time frames I might be able to restore/backup 500Gig to
1terabyte
of database from disk?  

  I will perform it before it goes live but I would like get a
ball park idea of restore times before hand so we can determine if it
can
fit 
in the SLA requirements. 

Any parameters to focus on to improve performance other than
 allocating channels?


Thanks for any help
Brian Spears


-Original Message-
Sent: Wednesday, February 05, 2003 9:53 AM
To: Multiple recipients of list ORACLE-L


Check out the doc's at tahiti.oracle.com and look up the parameter
noprompt.

Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 5:48 AM

Hello List,

I think my question is very simple...

How to execute RMAN command DELETE OBSOLETE from script without
confirmation question to remove obsolete backups
automatically?

Many thanks for your help.
-- 
Best regards,
Alex  mailto:[EMAIL PROTECTED]

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

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

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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing l

Re[2]: another possibility for running Oracle / UNIX at home

[dgoulet]

Damn, nothing like a dead OS that refuses to stay down!!

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   2/5/2003 12:54 PM

Very cool!  I was wondering about this the other day.

See:  http://www.oracle.com/start/apple/intro.html?src=1439096&Act=5

Developer's release of 9iR2 EE for MAC OS X.

Jared






Jacques Kilchoer <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/05/2003 11:30 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:another possibility for running Oracle / UNIX at home


A few days ago someone had asked about what options are available for 
running Oracle (database) on UNIX at home. 
I just saw this article: 
http://www.macdevcenter.com/pub/a/mac/2002/11/12/oracle_part1.html 
Installing Oracle 9i on Mac OS X, Part 1 


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

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

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

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

RE: Size of a Long Field

[Jamadagni, Rajendra]

Title: RE: Size of a Long Field





I have this code that is used to search within a trigger body ... you can maybe adapt this to get length ... you have to just change dbms_lob.instr to dbms_lob.getlength() maybe.

CREATE OR REPLACE FUNCTION long_contains
( row_id ROWID,
VALUE VARCHAR2) RETURN NUMBER
IS
--
ret_val NUMBER;
--
/* Table details */
OWN VARCHAR2(30);
tab VARCHAR2(30);
col VARCHAR2(30);
/* DBMS_SQL variables */
cur PLS_INTEGER := DBMS_SQL.OPEN_CURSOR;
res PLS_INTEGER := 0;
pos PLS_INTEGER := 0;
len PLS_INTEGER := 0;
pce VARCHAR2(32767);
/* Temp CLOB to hold long data */
tmp CLOB;
--
BEGIN
/* Fetch the table name and long column name */
SELECT u.NAME
,o.NAME
,c.NAME
INTO OWN
,tab
,col
FROM sys.obj$ o
,sys.col$ c
,sys.USER$ u
WHERE u.USER# = o.owner#
AND c.TYPE# = 8
AND c.obj# = o.obj#
AND o.obj# = DBMS_ROWID.ROWID_OBJECT(row_id);
--
/* Fetch the long column into a temporary CLOB */
DBMS_LOB.CREATETEMPORARY(tmp,TRUE,DBMS_LOB.CALL);
DBMS_SQL.PARSE(cur, ' SELECT '||col|| ' FROM '||OWN||'.'||tab|| ' WHERE ROWID = :row_id',DBMS_SQL.NATIVE);
DBMS_SQL.BIND_VARIABLE(cur,':row_id',row_id);
DBMS_SQL.DEFINE_COLUMN_LONG(cur, 1);
res := DBMS_SQL.EXECUTE_AND_FETCH(cur);
LOOP
DBMS_SQL.COLUMN_VALUE_LONG(cur,1,32767,pos,pce,len);
EXIT WHEN len = 0;
pce := UPPER(pce);
DBMS_LOB.WRITE(tmp,len,pos+1,pce);
pos := pos + len;
END LOOP;
--
DBMS_SQL.CLOSE_CURSOR(cur);
--
/* Now use DBMS_LOB funcs. to examine */
IF DBMS_LOB.INSTR(tmp,UPPER(VALUE)) > 0 THEN
ret_val := 1;
ELSE
ret_val := 0;
END IF;
--
RETURN ret_val;
END;
/


HTH
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: Ed Bittel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 6:53 AM
To: Multiple recipients of list ORACLE-L
Subject: Size of a Long Field



How do you determine the size, in bytes, of a long field?


Please. No tape measure jokes.


Ed



*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: Windows 2000 Cluster on oracle

[Jared . Still]

As much as I hate defending Windoze, Win2k is in fact rather stable,
at least Win2k server is.  I have one system on Win2k that I reboot,
oh, every 6 months or so.

Death to NT though.

Jared





"Bernardus Deddy Hoeydiono" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/05/2003 12:48 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Windows 2000 Cluster on oracle


SUN to Windows ?. Why do you want to used Windows. I think SUN more 
more
better than Windows.
I suggest please don't used Windows. As you you known the Windows system 
is
not stable. SUN more more stable than Windows.

I think you have to think more than twice for using Windows.

-Original Message-
Sent: Wednesday, February 05, 2003 6:29 AM
To: Multiple recipients of list ORACLE-L


Sun to Windoz ..h ... are u sure ?

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 04, 2003 2:34 PM


> Hi,
> We are looking from migration from Sun box to Windows box.
> Is anyone used Windows clustering with oracle8i?
> Is this clustering stable or more frequent creating problem?
> Please advice
> Thx
> -Seema
>
>
>
>
>
> _
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Seema Singh
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: BigP
  INET: [EMAIL PROTECTED]

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

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

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




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

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

RE: RMAN - questions.. Rob Freeman?

[DENNIS WILLIAMS]

Brian - Hopefully Robert will have a chance to respond to your question, but
if I might make some suggestions, I think your recovery time has two
components:
  1. If the backup files are not on disk, the time to locate the tape, load
the files.
  2. RMAN recovery time. I think you will just have to perform some tests on
your equipment. There are several tunable RMAN parameters that will make a
great deal of difference (or not), depending on your hardware. There are
many different types of recovery. Some recoveries may require very little
data from RMAN, others may require a lot. You need to outline (and
eventually test) for the different types of recovery scenarios. 
   Overall, my experience has been that RMAN offers very fast performance,
usually limited just by disk speeds. But what impresses me may not meet your
needs. I'm easily impressed.

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


-Original Message-
Sent: Wednesday, February 05, 2003 2:16 PM
To: Multiple recipients of list ORACLE-L



I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users

This rman would be the secondary recovery solution (Timefinder is the
first).

 Anybody know time frames I might be able to restore/backup 500Gig to
1terabyte
of database from disk?  

  I will perform it before it goes live but I would like get a
ball park idea of restore times before hand so we can determine if it can
fit 
in the SLA requirements. 

Any parameters to focus on to improve performance other than
 allocating channels?


Thanks for any help
Brian Spears


-Original Message-
Sent: Wednesday, February 05, 2003 9:53 AM
To: Multiple recipients of list ORACLE-L


Check out the doc's at tahiti.oracle.com and look up the parameter
noprompt.

Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 5:48 AM

Hello List,

I think my question is very simple...

How to execute RMAN command DELETE OBSOLETE from script without
confirmation question to remove obsolete backups
automatically?

Many thanks for your help.
-- 
Best regards,
Alex  mailto:[EMAIL PROTECTED]

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

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

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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You 

Re: Determine how many used and free blocks in an extent.

[Jonathan Lewis]

There is a script (last updated Nov 2000) on my
website that gets you part way.  But there is no
way you can find out about the contiguity of free blocks
(at least not the ones below the HWM) as you  have
to walk every freelist to find all the free blocks, then
sort them into physical order.  It is possible, of course, 
but not realistic

Check the Miscellaneous menu, then search
for "free space"


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


Next Seminar dates: 
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html




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

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

RE: RMAN - questions.. Rob Freeman?

[Peter . McLarty]

You will only know what your system is capable of

It is very dependant on the disk arrays and no of scsi or fibre channels 
you have to support those disks

Also RAID level will be a big contributor 


How long does it take to copy say a 500MB file from location to location. 
check it out this way. see what throughput you are reporting in sar or 
glance or similar

Test this between the filesystem your db is on and where you want to put 
the backup to disk


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

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

=

This transmission is for the intended addressee only and is confidential 
information. If you have received this transmission in error, please 
delete it and notify the sender. The contents of this e-mail are the 
opinion of the writer only and are not endorsed by the Mincom Group of 
companies unless expressly stated otherwise. 






"Spears, Brian" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06-02-2003 06:16 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: RMAN - questions.. Rob Freeman?



I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent 
users

This rman would be the secondary recovery solution (Timefinder is the
first).

 Anybody know time frames I might be able to restore/backup 500Gig to
1terabyte
of database from disk? 

  I will perform it before it goes live but I would like get a
ball park idea of restore times before hand so we can determine if it can
fit 
in the SLA requirements. 

Any parameters to focus on to improve performance other than
 allocating channels?


Thanks for any help
Brian Spears


-Original Message-
Sent: Wednesday, February 05, 2003 9:53 AM
To: Multiple recipients of list ORACLE-L


Check out the doc's at tahiti.oracle.com and look up the parameter
noprompt.

Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 5:48 AM

Hello List,

I think my question is very simple...

How to execute RMAN command DELETE OBSOLETE from script without
confirmation question to remove obsolete backups
automatically?

Many thanks for your help.
-- 
Best regards,
Alex  mailto:[EMAIL PROTECTED]

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

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

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

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be re

Re: Hanging query puzzle

[Jonathan Lewis]

It looks like your process really is stuck
in a way that has nothing to do with the
Oracle code directly.

You might look at the CPU usage of your
session and its shadow using an O/S
utility, but I suspect it would show
zero CPU.  Perhaps truss (or the AIX
equivalent) might show your process
spinning on whatever call equates to
'has the async read completed yet'.


You could try doing three processstate
dumps with 5 second intervals to see if
the processstate shows any changes
which might give you a hint - but again
I'd GUESS that you'll find nothing happening.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 05 February 2003 21:05


>Still sitting there, while we try to figure out exactly why it's
waiting.
>
>
>  SID Username EVENT
>WAIT_TIME STATE   SECONDS_IN_WAIT
>-  --

>-- --- ---
>1  pmon timer
>0 WAITING   79579
>5  smon timer
>0 WAITING  80
>   12  slave wait
>0 WAITING 199
>   13  slave wait
>0 WAITING 199
>   14  slave wait
>0 WAITING 262
>   15  slave wait
>0 WAITING 199
>   28 NIK  db file scattered read
>0 WAITING   20119
>
>-Original Message-
>Sent: Wednesday, February 05, 2003 2:58 PM
>To: [EMAIL PROTECTED]
>Cc: Thomas Jeff
>


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

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

RE: Oracle License for Training

[DENNIS WILLIAMS]

Jeremy - I should probably have been more specific. :-) Years ago I worked
for a software vendor. They wanted to port their product to Oracle. They
expected to receive complimentary licenses in order to do this. Most vendors
bend over backwards to have you port to their product. Oracle expected that
they would buy licenses just like everybody else. We developers sort of
ended up in the middle, since Oracle Support didn't consider us to exist and
wouldn't allow us to file TARs. Again, this was one experience, and someone
else might have had a different experience.



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

-Original Message-
Sent: Wednesday, February 05, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L



> From: DENNIS WILLIAMS [ mailto:[EMAIL PROTECTED]
 ] 
> 
> 
> Maria - Actually, I would think the best time to contact 
> Oracle sales is when you don't have money. Good sales people 
> can smell money. ;-) 

Heh. 

>Some software companies are very liberal about providing 
> their product for development and training purposes. My 
> impression has been that Oracle is NOT one of those 
> companies. 

Um, no. 

For development they can't be beat; the only thing I miss out on is
Metalink, but my clients usually provide a (legal) access path for that. OTN
is fantastic for developers.

However, for training this statement is true. I ran into this in a big way
when working for a smallish SW company. We developed a slick method of
rolling out the product to a large-scale enterprise, partially using some
proprietary Oracle objects (sequences, PL/SQL, etc). Oracle had no problem
with this. The problem occurred, however, when we wanted to hold private
classes to train our consultants and implementation partners on this method.
We ended up having to buy licenses, and eventually moving the tool to a
non-platform specific means.

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

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

RE: Windows 2000 Cluster on oracle

[Lyndon Tiu]

Windows is cheaper than SUN. Linux is cheaper than Windows.

Quoting Tony Johnson <[EMAIL PROTECTED]>:

> We have had an excellent experience with our Windows2000 clusters.
> Since moving to a clustered environment
> on our Test, Beta and Production systems over 18 months ago we have
> had 0 ( Zero ) outages due to 
> Windows. in fact I have yet to see a BSOD on over 20 database
> servers since going to Windows2000.
> 
> Saying Windows is unstable shows a lack of understanding of what
> Windows2000 is today. Carrying the
> baggage of WindowsNT forward is a disservice.
> 
> I say go for it. In fact we will be moving to 9i RAC by the end of
> this year and we are planning
> on using Windows as our Oracle platform.
> 
> -Original Message-
> Sent: Wednesday, February 05, 2003 1:49 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> SUN to Windows ?. Why do you want to used Windows. I think SUN
> more more
> better than Windows.
> I suggest please don't used Windows. As you you known the Windows
> system is
> not stable. SUN more more stable than Windows.
> 
> I think you have to think more than twice for using Windows.
> 
> -Original Message-
> Sent: Wednesday, February 05, 2003 6:29 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Sun to Windoz ..h ... are u sure ?
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 04, 2003 2:34 PM
> 
> 
> > Hi,
> > We are looking from migration from Sun box to Windows box.
> > Is anyone used Windows clustering with oracle8i?
> > Is this clustering stable or more frequent creating problem?
> > Please advice
> > Thx
> > -Seema
> >
> >
> >
> >
> >
> >
> _
> > STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Seema Singh
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You
> may
> > also send the HELP command for other information (like
> subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: BigP
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
> services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You
> may
> also send the HELP command for other information (like
> subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Bernardus Deddy Hoeydiono
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
> services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You
> may
> also send the HELP command for other information (like
> subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tony Johnson
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting
> services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You
> may
> also send the HELP command for other information (like
> subscribing).
> 
> 


-- 
Lyndon Tiu

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

RE: Determine how many used and free blocks in an extent.

[Stephen Lee]

Do you mean something like this:

select max(bytes) from dba_free_space where tablespace_name = 'NAME';

> -Original Message-
> I would like to determine the maximum # of contiguous
> free blocks within an extent
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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

Re: OT: Hotsos Symposium - Dallas

[Jared . Still]

Unfortunately, I am not attending.

Having to choose between IOUG and HOTSOS, I opted for IOUG
as I haven't been since 2000.

I feel fortunate at that, as I know a number of folks that won't
be able to attend any conference this year.

Jared






Denny Koovakattu <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/05/2003 10:49 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:OT: Hotsos Symposium - Dallas




  OK, here's the list of people who said are attending. I am not including 
the 
presenters ;) Anybody else attending ?

Larry G. Elkins
Kirti Deshpande
Rajendra Jamadagni
Charlie Mengler
Ethan Post

Jared are you attending ? It was a maybe couple of weeks back.

Regards,
Denny
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Denny Koovakattu
  INET: [EMAIL PROTECTED]

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




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

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

RE: Partition and primary key

[Janardhana Babu Donga]

Title: Partition and primary key



You need 
to have 15 to 20gig temp space to do this, assuming you are 
equipartitioning the primary key index.

  -Original Message-From: NGUYEN Philippe (Cetelem) 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 
  2003 6:53 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Partition and primary key
  Hi List, We are using Oracle 8.1.7 (64 
  bits) with Solaris 8 
  I have a big table with over 300 millions rows (10 Go), 
  We have partinionned this table by range of date. 
  When we try to create a constraint primary key (with 
  dedicated tablespace), we fail each time because the database was unable to 
  extend temp segment. 
  1/ Instead of enlarging the temp tablespace undefinatly , is 
  it possible to create this constraint for each partition so that it would 
  reduce the amount of temp segment required ?
  2/ If not, creating an unique will also be efficient for 
  join  ? 
  Thanks in advance! Philippe 

   

RE: 9i "Reliability" means ?

[Sherman, Edward]

Do Standby Databases & Database Replication come under the subject
"Reliability" ? 

Yes, this would come under the topic of "High Availability"

Heres a ppt that might give you some more ideas:


http://www.darc.com/ncoaug/presentations/2001-summer/Bondra.ppt

HTH

Ed



-Original Message-
Sent: Wednesday, February 05, 2003 9:53 AM
To: Multiple recipients of list ORACLE-L


Folks 

We are looking to present a Talk on :-

"Reliability" with respect to Oracle 9i DB

How does one even approach this subject ? 
What Sub-Topics would this envisage other than the following ? 

1) Oracle Architecture of Data Storage 
2) Backup & Recovery 
Do Standby Databases & Database Replication come under the subject
"Reliability" ? 

Using our Application Product we have Experience on Hybrid Oracle Databases
in :-

1) High End Database Performance Benchmarks
2) Regular Database Recoveries from Block Corruptions , Crashes 
3) Keeping Production Databases of sizes upto 1 TB working optimally .

Do you believe we can give a Talk on the Subject "Reliability" ?

The presentation might have in attendance some of the Leading Oracle minds .

Thanks

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

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

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

DB character set

[Boris Dali]

Dear List,

Life was pretty easy here before they came up with
this euro symbol :-( We had WE8ISO8859P1 (the default
I bevieve) as a char set on all Unix and MS (sorry we
have those as well) DBs accross the board.
That was also the client side char set (part of
NLS_LANG) - most clients here are on MS (code page
1252), some browser based.

Well, with euro it looks like they went different
directions:
- On MS: it's recommended to have WE8MSWIN1252 (super
set of good old WE8ISO8859P1)
- On Unix: it's WE8ISO8859P15

My question is:
1. if I want to stick with one char set accross the
board (as we have now) for all DBs on Unix and MS  AND
2. avoid (automatic, but not free) conversion on
DB-Client Net communication AND
3. we need euro symbol

is there a painless solution out there? 

Thanks,
Boris Dali

__ 
Post your free ad now! http://personals.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boris Dali
  INET: [EMAIL PROTECTED]

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

RE: Problem with LONG column

[Jared . Still]

Dennis,

PL/SQL cannot directly deal with longs > 32k.

There *is* a way to do with global temporary tables
and the to_lob() function, but it won't be nearly as 
fast as just using 'copy'.

Jared






DENNIS WILLIAMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/05/2003 06:52 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Problem with LONG column


Babu - There are two ways I can think of to do this. 
  1. Write a small PL/SQL procedure.
  2. Use the SQL*Plus COPY command.
You will probably use the method that is more familiar to you. Have you 
used
either PL/SQL or SQL*Plus COPY before?



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

-Original Message-
Sent: Wednesday, February 05, 2003 4:24 AM
To: Multiple recipients of list ORACLE-L


Hi everyone
 
One of my development team is working on ORACLE 8 on NT (Because of client
requirement they are working on that version). One Table was created with
wrong column name. Now they wanted me to correct the column name. But real
problem is one column of that table is LONG data type. So I was unable to
use 
Insert into ... Select  statement. Any suggestions in this regard
highly appreciated.
 
thanks
Banarasi Babu T
OCP, DBA
 
 
 
 

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

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




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

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

7.3.4 upgrade

[Cyril Thankappan]

Hi Listers,

I've prepared a small list of steps to follow for
an upgrade of 7.3.4 database to 9.2

However unfortunately I do not have access to a 7.3.4 database

Can one of you who has access to 7.3.4 database, try these steps
out and give me your 'honest' feedback?

Thanks a lot

Cyril

Re: Hanging query puzzle

[Jonathan Lewis]

Just a warning for the future - this is no longer true
on all versions of Oracle 9 because the wait_time
column is a copy of the underlying x$ timing
column rounded from microseconds to hundredths.
Hence the wait_time can show a zero when the
actual time is non-zero.

You should depend only on the STATE column
which is a decode of the basic microsecond value,
and shows 'WAITING' if and only if the microsecond
time is zero.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 05 February 2003 20:50


>
>  What is the value for WAIT_TIME ? This may not be an IO problem
> if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME'
is 0.
>

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

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

RE: Where is result set maintained?

[Richard Ji]

Stole right from asktom.  Thanks Tom. :)

We do not build the result set anywhere in general.

If you do select * from one_billion_row_table -- we fetch the data from the
table as needed -- the results start coming back IMMEDIATELY not after we've
fetched the last row.

For certain types of queries we might build part of the result set or all of
it
(depends).  This would take place in RAM upto sort_area_size bytes and then
we
would start paging that out to TEMP.

We find rows 100 to 115 by maintaining a state, called a cursor, on the
server. 
It tells us where we left off and where to begin.

Richard Ji

-Original Message-
Sent: Wednesday, February 05, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L


When one executes a query, the result set is identified.  Fetching the
rows in the result set can be done over a period of time.  In what form
does Oracle maintain the result set, and where?

TIA

Paul Baumgartel


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

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

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

Determine how many used and free blocks in an extent.

[Rick_Cale]

Does any have a script that shows actual # of used and free blocks in an
extent? I would like to determine the maximum # of contiguous
free blocks within an extent

Thanks
Rick

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

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

Re: another possibility for running Oracle / UNIX at home

[Jared . Still]

Very cool!  I was wondering about this the other day.

See:  http://www.oracle.com/start/apple/intro.html?src=1439096&Act=5

Developer's release of 9iR2 EE for MAC OS X.

Jared






Jacques Kilchoer <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/05/2003 11:30 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:another possibility for running Oracle / UNIX at home


A few days ago someone had asked about what options are available for 
running Oracle (database) on UNIX at home. 
I just saw this article: 
http://www.macdevcenter.com/pub/a/mac/2002/11/12/oracle_part1.html 
Installing Oracle 9i on Mac OS X, Part 1 


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

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

RE: RH AS2.1 (was: RAC on linux)

[Richard Ji]

OCFS = Oracle Cluster File System.  An open source project lead
by Wim Coekaerts from Oracle.  There is no such thing as raw FS,
it's just raw (without any file system).  And I just learned about
this NBD (Network Block Device) from this list.  So that's a third
option.

Richard Ji

-Original Message-
Sent: Wednesday, February 05, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


OFCS?  If not that, then it's left to a raw FS, correct?

Just trying to get some config possibilities here for an upcoming test
(hopefully)...

Rich

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

-Original Message-
Sent: Monday, February 03, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L


I think it's just the support that's different in base vs standard and
premium.
RH made the source RPM available for download, there are litertlly thousands
of
them.

And to answer your previous e-mail, you don't necessarily need RHAS to play
with
RAC.  The only reason you need RHAS is if you want to use OCFS.

-Original Message-
Sent: Monday, February 03, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L


In the same vane, does anyone know the difference between the "Base",
"Standard", and "Premium" versions of RH AS2.1?  And will any of these work
with 9i RAC (if the difference is more than just support)?  And I don't
suppose it's available for download anywhere for testing, is it?

The RedHat site isn't very helpful here...

TIA!
Rich
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

Re: Drop datafile.

[Suzy Vordos]

This command is used to put a datafile in recovery mode, not for
dropping the datafile.  Now you either need to do recovery, or drop the
tablespace completely and re-create it.  

Simply put, you cannot drop a datafile.

Suzy

Sesi Odury wrote:
> 
> Hi,
> 
> I restored the database from cold backup. There seems to be a problem with one of 
>the datafiles. Since there is no useful data in it, I tried dropping it using...
> 
> SQL> ALTER DATABASE DATAFILE '' OFFLINE DROP;
> 
> Database altered.
> 
> I also deleted the physical file by going to that location and deleting it.
> However I still find the datafile existing.
> 
> SQL> select name, status from v$datafile;
> I still find the datafile.
> 
> Can someone suggest me something??
> 
> Thanks a lot...
> Sesi
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sesi Odury
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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

RE: 9i "Reliability" means ?

[DENNIS WILLIAMS]

Vivek
   To me "reliability" means "won't break". Difficult to get hard data.
   You might consider changing the name to "availability", which to me
covers not just reliability, but all aspects of my application being
available to my users. Things like dynamic parameters can be very important
because I may be able to avoid a database "bounce" just to change a
parameter. We've all been there, done that. Oracle nicely divides Oracle9i
features up into those that contribute to a higher availability.
Take a look at the following paper under "Availability":
http://technet.oracle.com/products/oracle9i/pdf/9idb_rel2_features.pdf
The Student Guide for the Oracle9i New Features for Administrators class has
a chapter titled "General High Availability Technology". 
   Just some thoughts for you to consider.

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

-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L


Folks 

We are looking to present a Talk on :-

"Reliability" with respect to Oracle 9i DB

How does one even approach this subject ? 
What Sub-Topics would this envisage other than the following ? 

1) Oracle Architecture of Data Storage 
2) Backup & Recovery 
Do Standby Databases & Database Replication come under the subject
"Reliability" ? 

Using our Application Product we have Experience on Hybrid Oracle Databases
in :-

1) High End Database Performance Benchmarks
2) Regular Database Recoveries from Block Corruptions , Crashes 
3) Keeping Production Databases of sizes upto 1 TB working optimally .

Do you believe we can give a Talk on the Subject "Reliability" ?

The presentation might have in attendance some of the Leading Oracle minds .

Thanks

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

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

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

Re: info on toplink?

[Jared . Still]

> I am attempting to RTF google on this

RTFG?

Yeah, I like it.  ;)

Jared






"Sarnowski, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/05/2003 08:33 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:info on toplink?



I am attempting to RTF google on this, but am not coming up
with much. Does anyone have any suggestions on how to tune/manage
toplink from an Oracle DBA perspective?
"Make them stop" doesn't seem to be an option, sadly.

So far the problems I've run into are that it doesn't use
bind variables (and apparently Toplink support - now Oracle!
- asked "why does your DBA want to use bind variables?" )
and I haven't been able to get the Java people to call 
dbms_application_info so I know which servlet/procedure/
method/whatever is associated with a given query. I don't
know if the difficulty is the toplink interface, or the
DBA/Java developer interface (lots of impedance mismatch: I'm sure
it's all my fault because I'm stuck in obsolete "relational" mode).
So I need to learn more about this beast.

I'm trying to load the toplink forum from otn.oracle.com but
the page is just hanging.

thanks in advance for any pointers,


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

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

Re: Partition and primary key

[Jared . Still]

What is the exact error message, including text?

It could be failing on the temp segment initially created in
the index tablespace, and not necessarily running out
of sort space.

Jared






"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 02/05/2003 06:52 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Partition and primary key


Hi List, 
We are using Oracle 8.1.7 (64 bits) with Solaris 8 
I have a big table with over 300 millions rows (10 Go), 
We have partinionned this table by range of date. 
When we try to create a constraint primary key (with dedicated 
tablespace), we fail each time because the database was unable to extend 
temp segment. 
1/ Instead of enlarging the temp tablespace undefinatly , is it possible 
to create this constraint for each partition so that it would reduce the 
amount of temp segment required ?
2/ If not, creating an unique will also be efficient for join  ? 
Thanks in advance! 
Philippe 
  


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

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

SQL*NET timeout with database link

[Smith, Ron L.]

If I try to connect to a database from server a to server b using sqlplus
and a database link and that database does not exist the connection attempt
seems to hang.  Is there a way to set the timeout so it will not hang?

R. Smith 
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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

RE: Hanging query puzzle

[Denny Koovakattu]

  Did you try tracing it from the OS ? Any error messages in the OS system 
log ? Is it always one datafile/mount point ? A while back, I had seen a 
similar problem when an array had gone bad. You may want to try using "dd" to 
read and write some files and check the timing.

Regards,
Denny

Quoting Thomas Jeff <[EMAIL PROTECTED]>:

> Still sitting there, while we try to figure out exactly why it's
> waiting.
> 
> 
>   SID Username EVENT
> WAIT_TIME STATE   SECONDS_IN_WAIT
> - 
> --
> -- --- ---
> 1  pmon timer
> 0 WAITING   79579
> 5  smon timer
> 0 WAITING  80
>12  slave wait
> 0 WAITING 199
>13  slave wait
> 0 WAITING 199
>14  slave wait
> 0 WAITING 262
>15  slave wait
> 0 WAITING 199
>28 NIK  db file scattered read
> 0 WAITING   20119   
> 
> -Original Message-
> From: Denny Koovakattu [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 05, 2003 2:58 PM
> To: [EMAIL PROTECTED]
> Cc: Thomas Jeff
> Subject: Re: Hanging query puzzle
> 
> 
> 
> 
>   What is the value for WAIT_TIME ? This may not be an IO problem 
> if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME' is
> 0. I 
> would suggest running some utility like tusc (HP), truss (Sun), strace
> (Linux) 
> and check it from the OS side. Since this is a third party tool, it
> could be
> 
> performing some CPU only operation which is not reflected in
> v$session_wait.
> 
> Regards,
> Denny
> 
> Quoting Thomas Jeff <[EMAIL PROTECTED]>:
> 
> > We have a query from a 3rd-party tool that seems to either run very
> > quick or
> > crawls to a complete stop.   
> > 
> > We can find no patterns to this behavior.The hang can be
> > experienced
> > even when there are no other 
> > processes active in the database. Checking waits, we see a db
> file
> > scattered read.
> > 
> > SID EVENTP1TEXT P1
> P2TEXT
> > P2 P3TEXT P3
> > -  -- --
> > -- -- -- --
> > 1 pmon timer   duration  300
> > 0 0
> >12 slave wait   msg ptr5.0440E+17
> > 0 0
> >13 slave wait   msg ptr5.0440E+17
> > 0 0
> >14 slave wait   msg ptr5.0440E+17
> > 0 0
> >15 slave wait   msg ptr5.0440E+17
> > 0 0
> >28 db file scattered read   file#  12
> > block#
> > 21047 blocks  2
> > 5 smon timer   sleep time300
> > failed
> > 0 0 
> > 
> > Then going to v$sess_io, we see the process is comletely stuck, no
> > activity
> > going on at all, and it's the
> > only active process in the database.
> > 
> >   SID BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS BLOCK_CHANGES
> > CONSISTENT_CHANGES
> > - -- --- -- -
> > --
> >28623358260812023   36589516   4076353
> > 115   
> > 
> > The query looks like this:
> > 
> > SELECT PRAssignment.*, SRM_RESOURCES.RESOURCE_TYPE 
> > FROM PRAssignment,  SRM_RESOURCES  
> > WHERE  prModTime > TIMESTAMP '2003-02-05 09:23:56.0' 
> > AND PRAssignment.prResourceID=SRM_RESOURCES.ID 
> > 
> > If I check the file/block values for the wait I get the prassignment
> > table.
> > Prassignment has 5K rows
> > while srm_resources has 300 rows.   Prassignment also has a LONG RAW
> > column,
> > consequently we
> > see a high chain count, with the result that it's taking up 135
> extents
> > to
> > cover those 5K rows.   
> > 
> > I'm at a loss to explain why we see such inconsistent results with
> > this
> > query.Thoughts?
> > 
> > Thanks.
> > 
> > 
> > Jeffery D Thomas
> > DBA
> > Thomson Information Services
> > Thomson, Inc.
> > 
> > Email: [EMAIL PROTECTED]
> 

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
th

Re: Size of a Long Field

[Stephane Faroult]

Not easy. If your LONG is shorter than 32767, then you can, in a PL/SQL
function, fetch it into a VARCHAR2 of this size (allowed in PL/SQL) and
aplly LENGTH() to this VARCHAR2. Assuming the suitable Oracle version, I
think there is somewhere a function to convert LONGs to CLOBs - to which
you can apply a function. With Pro*C or the OCIs, you can derived the
length from the error you get when fetching into too small a buffer ...
-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

RE: Size of a Long Field

[JApplewhite]

Dennis,

Using VSize on a Long results in:
  ORA-00997: illegal use of LONG datatype

Just tried in on Trigger_Body in DBA_Triggers.  (8.1.7.0.0 on HP-UX).

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]



   

  DENNIS WILLIAMS  

<[EMAIL PROTECTED]> 

  Sent by: cc: 

  [EMAIL PROTECTED] Subject:  RE: Size of a Long Field  

   

   

  02/05/2003 01:29 

  PM   

  Please respond to

  ORACLE-L 

   

   





Ed - Look up the function VSIZE in the documentation.

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

-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L


How do you determine the size, in bytes, of a long field?



Please. No tape measure jokes.



Ed


--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]





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

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

RE: Connecting to Non Oracle databases from Oracle

[Sunil . Kumar . Gompa]

i was successfull in connecting to a Non oracle database from Oracle on unix
through the Listener on Win NT.
this situation arose b'cos we did not have a ODBC setup on Unix.
So we had to do the ODBC as well as the Heterogeneous services setup on Win
NT. and then try to connect from databse on Unix machine to this Listener on
NT.


Regards,
Sunil Gompa



-Original Message-
Sent: Wednesday, February 05, 2003 3:05 PM
To: [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L


NO, you have to do it the otherway around with Heterogenous services. Namely
ODBC on the Unix platform.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   2/5/2003 1:58 AM

Hi,

I am trying to connect to a Non Oracle database from the Oracle database (
Version 8.1.7.4).
i want to do some thing like this :
i have my ODBC set up on an Win NT machine. I have created a heterogeneous
connection set up on Win NT.
Now i want to connect from a Unix machine to the Listener entry that i have
done on the Win NT server, there by connecting to the Non Oracle database.



SqlServer ---odbc setup on NT> Win NT ( LIstener Entry: pubs)
> Unix (Tnsnames entry : pubs.world)

can this be done ??

Regards,
Sunil Gompa


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

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

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

Re: Where is result set maintained?

[Stephane Faroult]

Paul Baumgartel wrote:
> 
> When one executes a query, the result set is identified.  Fetching the
> rows in the result set can be done over a period of time.  In what form
> does Oracle maintain the result set, and where?
> 
> TIA
> 
> Paul Baumgartel
> 

If I understand well your question, I don't think that a 'result set'
(as, say, a collection of rowids or whatever) really is identified. If
you have a sort, then yes, you have a kind of 'result set' in temporary
segments. Otherwise all you need is the SCN at the beginning of the
query, and everything you need is either in regular blocks or 'undo'
blocks. Would you have ora-1555 otherwise ?

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

Re: Oracle License for Training

[Stephane Faroult]

DENNIS WILLIAMS wrote:
> 
> Maria - Actually, I would think the best time to contact Oracle sales is
> when you don't have money. Good sales people can smell money. ;-)
>Some software companies are very liberal about providing their product
> for development and training purposes. My impression has been that Oracle is
> NOT one of those companies. They are the top database company, so they
> realize you will need to interface with Oracle, so they are happy to have
> you buy Oracle licenses to develop a product. That is development. With
> training, it is worse because you are competing with Oracle, so there is
> even less incentive for Oracle to be cooperative. I'm assuming that Oracle
> Education provides training courses in your country.
>With some activities, you have the opportunity to keep quiet and hope
> Oracle doesn't notice what you are up to. But I'm sure you will be
> advertising your classes, so Oracle may notice your company and come check
> you out.
>These are just some random thoughts for you to consider. A better idea
> would be for you to contact other training facilities and see what they do
> for Oracle licensing.
>Even better, many participants on this list have been involved in
> providing training and may have insights they will share with you, either on
> this forum or privately -- How about it people?
> 
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> 
> -Original Message-
> Sent: Tuesday, February 04, 2003 10:24 PM
> To: Multiple recipients of list ORACLE-L
> 
> A couple of friends and I are thinking of putting up a small training
> company here in the Phils.
> (When we say small...its really small with almost 0
> capitalization...just sheer guts and technical knowhow)
> We have looked at OTN and checked the licensing terms for the use of the
> software for training.
> We have stumbled on this provision:
> You may not:
> ·use the programs to provide third party training;
> I was wondering if any of you know if there is a different licensing for
> training institutions?
> How does a non-oracle partner acquire license to use Oracle DB software
> for training?
> I am looking at partnering with Oracle, but we are just starting and
> partnering costs $$.
> I dare not call Oracle Philippines just yet...If there is a need to
> purchase, and if we have the money, only then will we contact them.
> 
> Thanks.
> 
> =)
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --

Things which may be considered are :

   - Providing on-site training. If you target a big enough company,
with enough people to train, you can probably get a machine and a
fully-licensed test or development database.
   - Providing MySQL or Postgres training ...

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

Question on "set autotrace on statistics"

[gmei]

Hi:

I am trying to understand why sqlplus did not display stats when I run
"analyze table ..." and "create index ..."?

TIA.

Guang

--

SQL> set autotrace on statistics
SQL> analyze table gene_upr compute statistics;

Table analyzed.

SQL> desc gene_upr;
 Name  Null?Type
 -  

 ID NUMBER
 NAME   VARCHAR2(128)
 NAME_UPR   VARCHAR2(128)
 SPECIESID  NUMBER

SQL> CREATE index gene_upr_id_index
  2  ON gene_upr(id)
  3  TABLESPACE INDEXES  nologging
  4  STORAGE (INITIAL 1500 NEXT 1500 pctincrease 0);

Index created.

SQL> select count(*) from plan_table;

  COUNT(*)
--
 0


Statistics
--
  0  recursive calls
  4  db block gets
  1  consistent gets
  0  physical reads
  0  redo size
187  bytes sent via SQL*Net to client
311  bytes received via SQL*Net from client
  2  SQL*Net roundtrips to/from client
  0  sorts (memory)
  0  sorts (disk)
  1  rows processed

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

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

Re: Size of a Long Field

[JApplewhite]

Ed,

Perhaps you could use the DBMS_SQL Define_Column_Long and Column_Value_Long
procedures to manipulate the Long?

Converting the Long to a LOB using To_LOB function, then manipulating it
with the DBMS_LOB package might do, too.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]



   

  "Ed Bittel"  

<[EMAIL PROTECTED]> 

  Sent by: cc: 

  [EMAIL PROTECTED] Subject:  Size of a Long Field  

   

   

  02/05/2003 08:53 

  AM   

  Please respond to

  ORACLE-L 

   

   





How do you determine the size, in bytes, of a long field?

Please. No tape measure jokes.

Ed





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

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

RE: How to dump UGA ??

[Jamadagni, Rajendra]

Title: RE: How to dump UGA ??





KG,


That's what I am looking for ... which sessions have trace enabled ...?


Developers *forget* to disable tracing in their code when they move it to production ... so I have to investigate ...
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: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to dump UGA ??



Jonathan:


How about calling the DBMS_SYSTEM.READ_EV procedure?
I think this is simpler than going to the UGA dumps..


THe restriction with DBMS_SYSTEM is, you can not get 
the event settings of the other sessions. But Dumps
can.



Best Regards,
K Gopalakrishnan



*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: Oracle License for Training

[DENNIS WILLIAMS]

Markus - That is what I call a creative solution! I'm no lawyer either, but
excellent!

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


-Original Message-
Sent: Wednesday, February 05, 2003 9:34 AM
To: Multiple recipients of list ORACLE-L


Did you ever consider that your (prospective) trainig candidates get the
(for testing purposes freely downloadable) oracle software themselves and
install it themselves (or assisted by you) on a good (linux - one might hope
;-)) box and then you assist them by getting along with this? 

I think this means, that you would not provide the software yourself - this
is done by your traning candidates.

As I am neither a jurist nor a lawyer, so I hope this is not pure nonsense -
especially regarding the license agreement on technet.oracle.com.



Apologies for any typing mistakes I failed to notice


Markus Reger

Oracle Applications DBA
Webmaster
MBC
University for Music and Performing Art
Vienna
>>> [EMAIL PROTECTED] 02/05/03 06:15 AM >>>
A couple of friends and I are thinking of putting up a small training
company here in the Phils.
(When we say small...its really small with almost 0
capitalization...just sheer guts and technical knowhow)
We have looked at OTN and checked the licensing terms for the use of the
software for training.
We have stumbled on this provision:
You may not:
·use the programs to provide third party training;
I was wondering if any of you know if there is a different licensing for
training institutions?
How does a non-oracle partner acquire license to use Oracle DB software
for training?
I am looking at partnering with Oracle, but we are just starting and
partnering costs $$.
I dare not call Oracle Philippines just yet...If there is a need to
purchase, and if we have the money, only then will we contact them.

Thanks.

=)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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


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

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

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

RE: Size of a Long Field

[DENNIS WILLIAMS]

Ed - Look up the function VSIZE in the documentation.



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

-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L



How do you determine the size, in bytes, of a long field?

 

Please. No tape measure jokes.

 

Ed

 

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

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

RE: Hanging query puzzle

[Thomas Jeff]

Title: RE: Hanging query puzzle





Still sitting there, while we try to figure out exactly why it's waiting.



  SID Username EVENT   WAIT_TIME STATE   SECONDS_IN_WAIT

-  -- -- --- ---

    1  pmon timer  0 WAITING   79579

    5  smon timer  0 WAITING  80

   12  slave wait  0 WAITING 199

   13  slave wait  0 WAITING 199

   14  slave wait  0 WAITING 262

   15  slave wait  0 WAITING 199

   28 NIK  db file scattered read  0 WAITING   20119   

-Original Message-
From: Denny Koovakattu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 2:58 PM
To: [EMAIL PROTECTED]
Cc: Thomas Jeff
Subject: Re: Hanging query puzzle





  What is the value for WAIT_TIME ? This may not be an IO problem 
if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME' is 0. I 
would suggest running some utility like tusc (HP), truss (Sun), strace (Linux) 
and check it from the OS side. Since this is a third party tool, it could be 
performing some CPU only operation which is not reflected in v$session_wait.


Regards,
Denny


Quoting Thomas Jeff <[EMAIL PROTECTED]>:


> We have a query from a 3rd-party tool that seems to either run very
> quick or
> crawls to a complete stop.   
> 
> We can find no patterns to this behavior.    The hang can be
> experienced
> even when there are no other 
> processes active in the database. Checking waits, we see a db file
> scattered read.
> 
> SID EVENT    P1TEXT P1 P2TEXT
> P2 P3TEXT P3
> -  -- --
> -- -- -- --
> 1 pmon timer   duration  300
> 0 0
>    12 slave wait   msg ptr    5.0440E+17
> 0 0
>    13 slave wait   msg ptr    5.0440E+17
> 0 0
>    14 slave wait   msg ptr    5.0440E+17
> 0 0
>    15 slave wait   msg ptr    5.0440E+17
> 0 0
>    28 db file scattered read   file#  12
> block#
> 21047 blocks  2
> 5 smon timer   sleep time    300
> failed
> 0 0 
> 
> Then going to v$sess_io, we see the process is comletely stuck, no
> activity
> going on at all, and it's the
> only active process in the database.
> 
>   SID BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS BLOCK_CHANGES
> CONSISTENT_CHANGES
> - -- --- -- -
> --
>    28    6233582    60812023   36589516   4076353
> 115   
> 
> The query looks like this:
> 
> SELECT PRAssignment.*, SRM_RESOURCES.RESOURCE_TYPE 
> FROM PRAssignment,  SRM_RESOURCES  
> WHERE  prModTime > TIMESTAMP '2003-02-05 09:23:56.0' 
> AND PRAssignment.prResourceID=SRM_RESOURCES.ID 
> 
> If I check the file/block values for the wait I get the prassignment
> table.
> Prassignment has 5K rows
> while srm_resources has 300 rows.   Prassignment also has a LONG RAW
> column,
> consequently we
> see a high chain count, with the result that it's taking up 135 extents
> to
> cover those 5K rows.   
> 
> I'm at a loss to explain why we see such inconsistent results with
> this
> query.    Thoughts?
> 
> Thanks.
> 
> 
> Jeffery D Thomas
> DBA
> Thomson Information Services
> Thomson, Inc.
> 
> Email: [EMAIL PROTECTED]

another possibility for running Oracle / UNIX at home

[Jacques Kilchoer]

Title: another possibility for running Oracle / UNIX at home





A few days ago someone had asked about what options are available for running Oracle (database) on UNIX at home.
I just saw this article:
http://www.macdevcenter.com/pub/a/mac/2002/11/12/oracle_part1.html
Installing Oracle 9i on Mac OS X, Part 1

Re: Problem with LONG column

[Jared Still]

Create the new table, and then use the sqlplus 'copy' command,
as it can handle longs.

Jared

On Wednesday 05 February 2003 02:23, BanarasiBabu Tippa wrote:
> Hi everyone
>
> One of my development team is working on ORACLE 8 on NT (Because of client
> requirement they are working on that version). One Table was created with
> wrong column name. Now they wanted me to correct the column name. But real
> problem is one column of that table is LONG data type. So I was unable to
> use
> Insert into ... Select  statement. Any suggestions in this regard
> highly appreciated.
>
> thanks
> Banarasi Babu T
> OCP, DBA


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

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

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

Re: Hanging query puzzle

[Denny Koovakattu]

  What is the value for WAIT_TIME ? This may not be an IO problem 
if 'WAIT_TIME' is not 0. A session is waiting only when 'WAIT_TIME' is 0. I 
would suggest running some utility like tusc (HP), truss (Sun), strace (Linux) 
and check it from the OS side. Since this is a third party tool, it could be 
performing some CPU only operation which is not reflected in v$session_wait.

Regards,
Denny

Quoting Thomas Jeff <[EMAIL PROTECTED]>:

> We have a query from a 3rd-party tool that seems to either run very
> quick or
> crawls to a complete stop.   
> 
> We can find no patterns to this behavior.The hang can be
> experienced
> even when there are no other 
> processes active in the database. Checking waits, we see a db file
> scattered read.
> 
> SID EVENTP1TEXT P1 P2TEXT
> P2 P3TEXT P3
> -  -- --
> -- -- -- --
> 1 pmon timer   duration  300
> 0 0
>12 slave wait   msg ptr5.0440E+17
> 0 0
>13 slave wait   msg ptr5.0440E+17
> 0 0
>14 slave wait   msg ptr5.0440E+17
> 0 0
>15 slave wait   msg ptr5.0440E+17
> 0 0
>28 db file scattered read   file#  12
> block#
> 21047 blocks  2
> 5 smon timer   sleep time300
> failed
> 0 0 
> 
> Then going to v$sess_io, we see the process is comletely stuck, no
> activity
> going on at all, and it's the
> only active process in the database.
> 
>   SID BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS BLOCK_CHANGES
> CONSISTENT_CHANGES
> - -- --- -- -
> --
>28623358260812023   36589516   4076353
> 115   
> 
> The query looks like this:
> 
> SELECT PRAssignment.*, SRM_RESOURCES.RESOURCE_TYPE 
> FROM PRAssignment,  SRM_RESOURCES  
> WHERE  prModTime > TIMESTAMP '2003-02-05 09:23:56.0' 
> AND PRAssignment.prResourceID=SRM_RESOURCES.ID 
> 
> If I check the file/block values for the wait I get the prassignment
> table.
> Prassignment has 5K rows
> while srm_resources has 300 rows.   Prassignment also has a LONG RAW
> column,
> consequently we
> see a high chain count, with the result that it's taking up 135 extents
> to
> cover those 5K rows.   
> 
> I'm at a loss to explain why we see such inconsistent results with
> this
> query.Thoughts?
> 
> Thanks.
> 
> 
> Jeffery D Thomas
> DBA
> Thomson Information Services
> Thomson, Inc.
> 
> Email: [EMAIL PROTECTED]

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

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

Re: Oracle License for Training

[Markus Reger]

Did you ever consider that your (prospective) trainig candidates get the (for testing 
purposes freely downloadable) oracle software themselves and install it themselves (or 
assisted by you) on a good (linux - one might hope ;-)) box and then you assist them 
by getting along with this? 

I think this means, that you would not provide the software yourself - this is done by 
your traning candidates.

As I am neither a jurist nor a lawyer, so I hope this is not pure nonsense - 
especially regarding the license agreement on technet.oracle.com.



Apologies for any typing mistakes I failed to notice


Markus Reger

Oracle Applications DBA
Webmaster
MBC
University for Music and Performing Art
Vienna
>>> [EMAIL PROTECTED] 02/05/03 06:15 AM >>>
A couple of friends and I are thinking of putting up a small training
company here in the Phils.
(When we say small...its really small with almost 0
capitalization...just sheer guts and technical knowhow)
We have looked at OTN and checked the licensing terms for the use of the
software for training.
We have stumbled on this provision:
You may not:
·use the programs to provide third party training;
I was wondering if any of you know if there is a different licensing for
training institutions?
How does a non-oracle partner acquire license to use Oracle DB software
for training?
I am looking at partnering with Oracle, but we are just starting and
partnering costs $$.
I dare not call Oracle Philippines just yet...If there is a need to
purchase, and if we have the money, only then will we contact them.

Thanks.

=)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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


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

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

RE: Sql query

[Nicoll, Iain]

Roland,

A quick look suggest you have cartesian joins unless rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp all have only one
row.

Iain Nicoll

-Original Message-
Sent: 05 February 2003 14:53
To: Multiple recipients of list ORACLE-L



I have  this sql query. I am wondering why this query takes so long time, Do
I need more conditions to make it run, or it it just that this query take so
long time to run? Anything wrong with the query?

Please help me with this.

 SELECT distinct PBK.VARUKORGEANREL_ULAG.ean, 0, 0, 0, rik2.vare.varenavn,
rik2.vare.str, PBK.VARUKORGEANREL_ULAG.lagstapris, rik2.vare.hylletxt2,
rik2.art_hierarki.vgrp, rik2.hierarki_tekst.tekst, '0', '0', 0,
pbk.underlag.period,
'rsm',pbk.sortiment_vgrp.sortiment,rik2.art_hierarki.art_grp,rik2.art_hierar
ki.art_ugrp
 FROM PBK.UNDERLAG, PBK.VARUKORGEANREL_ULAG, rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp
 WHERE PBK.underlag.underlagid=1100
 AND PBK.underlag.varukorgid=PBK.varukorgeanrel_ulag.varukorgid
 AND PBK.VARUKORGEANREL_ulag.varutyp=0;


Thanks in advance


Roland



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

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

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

RE: Hanging query puzzle

[Thomas Jeff]

Sorry,  running 8.1.7.2 on AIX 
4.3.3.    
 
 
-Original 
Message-From: John Shaw 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 
2003 2:09 PMTo: Multiple recipients of list 
ORACLE-LSubject: Re: Hanging query puzzleWhat version 
are you running - I have a similar problem on 9.2.0.2 on Solaris 9 that I've had 
an open tar on since November - Support has finally called up and said other 
people are having the same kind of problem - especially in regards to parallel 
processes. I am supposedly getting  a test scenario from them to check out. 
I'll post the results if and when I get any.>>> 
[EMAIL PROTECTED] 02/05/03 11:59AM >>>
We have a query from a 3rd-party tool that seems to 
either run very quick or crawls to a complete stop.   
We can find no patterns to this 
behavior.    The hang can be experienced even when there are no 
other processes active in the 
database. Checking waits, we see a db file scattered 
read. 
SID 
EVENT    
P1TEXT 
P1 
P2TEXT 
P2 
P3TEXT 
P3
-  
-- -- -- -- -- 
--
    1 pmon 
timer   
duration  
300 
0 
0
   12 slave 
wait   
msg ptr    
5.0440E+17 
0 
0
   13 slave 
wait   
msg ptr    
5.0440E+17 
0 
0
   14 slave 
wait   
msg ptr    
5.0440E+17 
0 
0
   15 slave 
wait   
msg ptr    
5.0440E+17 
0 
0
   28 db file scattered 
read   
file#  
12 
block#  
21047 
blocks  
2
    5 smon 
timer   
sleep 
time    
300 
failed  
0 
0 
Then going to v$sess_io, we see the process is 
comletely stuck, no activity going on at all, and it's the only active process in the database. 
  SID BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS 
BLOCK_CHANGES CONSISTENT_CHANGES - 
-- --- -- - 
--    
28    6233582    
60812023   
36589516   
4076353    
115   
The query looks like this: 
SELECT PRAssignment.*, SRM_RESOURCES.RESOURCE_TYPE 
FROM PRAssignment,  SRM_RESOURCES  
WHERE  prModTime > TIMESTAMP 
'2003-02-05 09:23:56.0' AND 
PRAssignment.prResourceID=SRM_RESOURCES.ID 
If I check the file/block values for the wait I get 
the prassignment table.  Prassignment has 5K rows while srm_resources has 300 rows.   Prassignment 
also has a LONG RAW column, consequently we see a high chain count, with the result that it's taking up 
135 extents to cover those 5K rows.   
I'm at a loss to explain why we see such 
inconsistent results with this query.    Thoughts? 
Thanks. 
 
Jeffery D Thomas DBA Thomson Information 
Services Thomson, Inc. 
Email: [EMAIL PROTECTED] 
Indy DBA Master Documentation available at: 
http://gkmqp.tce.com/tis_dba 
Select 'Indy DBA' then 'DBA Web Pages' 
 

RE: RMAN - questions.. Rob Freeman?

[Spears, Brian]

I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users

This rman would be the secondary recovery solution (Timefinder is the
first).

 Anybody know time frames I might be able to restore/backup 500Gig to
1terabyte
of database from disk?  

  I will perform it before it goes live but I would like get a
ball park idea of restore times before hand so we can determine if it can
fit 
in the SLA requirements. 

Any parameters to focus on to improve performance other than
 allocating channels?


Thanks for any help
Brian Spears


-Original Message-
Sent: Wednesday, February 05, 2003 9:53 AM
To: Multiple recipients of list ORACLE-L


Check out the doc's at tahiti.oracle.com and look up the parameter
noprompt.

Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 5:48 AM

Hello List,

I think my question is very simple...

How to execute RMAN command DELETE OBSOLETE from script without
confirmation question to remove obsolete backups
automatically?

Many thanks for your help.
-- 
Best regards,
Alex  mailto:[EMAIL PROTECTED]

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

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

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

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

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

RE: Oracle License for Training

[Jeremy Pulcifer]

Title: RE: Oracle License for Training





> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
> 
> 
> Maria - Actually, I would think the best time to contact 
> Oracle sales is when you don't have money. Good sales people 
> can smell money. ;-)


Heh.


>    Some software companies are very liberal about providing 
> their product for development and training purposes. My 
> impression has been that Oracle is NOT one of those 
> companies.


Um, no.


For development they can't be beat; the only thing I miss out on is Metalink, but my clients usually provide a (legal) access path for that. OTN is fantastic for developers.

However, for training this statement is true. I ran into this in a big way when working for a smallish SW company. We developed a slick method of rolling out the product to a large-scale enterprise, partially using some proprietary Oracle objects (sequences, PL/SQL, etc). Oracle had no problem with this. The problem occurred, however, when we wanted to hold private classes to train our consultants and implementation partners on this method. We ended up having to buy licenses, and eventually moving the tool to a non-platform specific means.

RE: Size of a Long Field

[Jeremy Pulcifer]

Title: Message



Man, 
what a buzz-kill you are.

  
  -Original Message-From: Ed Bittel 
  [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 
  6:53 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Size of a Long Field
  
  How do you determine the size, in 
  bytes, of a long field?
   
  Please. No tape measure 
  jokes.
   
  Ed
   

TOAD

[Ehresmann, David]

List,

I have a developer that I want to grant access to change another schema
owner's packages in TOAD.  I have granted connect, resource, and roles which
incorporate DML on the tables and execute on the packages.  When he goes
into TOAD he can see the package spec but not the package body.  How do I
set up his privs to allow him to make changes to another's package bodies
thru TOAD?

thanks,


David Ehresmann   

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

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

Re: Hanging query puzzle

[John Shaw]

What version 
are you running - I have a similar problem on 9.2.0.2 on Solaris 9 that I've had 
an open tar on since November - Support has finally called up and said other 
people are having the same kind of problem - especially in regards to parallel 
processes. I am supposedly getting  a test scenario from them to check out. 
I'll post the results if and when I get any.>>> 
[EMAIL PROTECTED] 02/05/03 11:59AM >>>
We have a query from a 3rd-party tool that 
seems to either run very quick or crawls to a complete stop.   

We can find no patterns to this 
behavior.    The hang can be experienced even when there are no 
other processes active in the 
database. Checking waits, we see a db file scattered 
read. 
SID 
EVENT    
P1TEXT 
P1 
P2TEXT 
P2 
P3TEXT 
P3
-  
-- -- -- -- -- 
--
    1 pmon 
timer   
duration  
300 
0 
0
   12 slave 
wait   
msg ptr    
5.0440E+17 
0 
0
   13 slave 
wait   
msg ptr    
5.0440E+17 
0 
0
   14 slave 
wait   
msg ptr    
5.0440E+17 
0 
0
   15 slave 
wait   
msg ptr    
5.0440E+17 
0 
0
   28 db file scattered 
read   
file#  
12 
block#  
21047 
blocks  
2
    5 smon 
timer   
sleep 
time    
300 
failed  
0 
0 
Then going to v$sess_io, we see the process 
is comletely stuck, no activity going on at all, and it's the only active process in the database. 
  SID BLOCK_GETS CONSISTENT_GETS 
PHYSICAL_READS BLOCK_CHANGES CONSISTENT_CHANGES - -- --- -- 
- --    28    
6233582    
60812023   
36589516   
4076353    
115   
The query looks like this: 
SELECT PRAssignment.*, 
SRM_RESOURCES.RESOURCE_TYPE FROM 
PRAssignment,  SRM_RESOURCES  WHERE  prModTime > TIMESTAMP '2003-02-05 09:23:56.0' 
AND 
PRAssignment.prResourceID=SRM_RESOURCES.ID 
If I check the file/block values for the wait 
I get the prassignment table.  Prassignment has 5K rows while srm_resources has 300 rows.   
Prassignment also has a LONG RAW column, consequently we see a high chain count, with the result that it's 
taking up 135 extents to cover those 5K rows.   
I'm at a loss to explain why we see such 
inconsistent results with this query.    Thoughts? 
Thanks. 
 Jeffery D Thomas DBA Thomson Information 
Services Thomson, Inc. 
Email: [EMAIL PROTECTED] 
Indy DBA Master Documentation available 
at: http://gkmqp.tce.com/tis_dba 
Select 'Indy DBA' then 'DBA Web 
Pages'  

Re:Oracle License for Training

[dgoulet]

Maria,

You found the fly in the ointment.  Since training is your business then you
end up paying for the software just like the rest of us.  Now if your doing
training in-house, for your own company, then things are different.

Dick Goulet

Reply Separator
Author: Maria Aurora VT de la Vega <[EMAIL PROTECTED]>
Date:   2/4/2003 8:23 PM

A couple of friends and I are thinking of putting up a small training
company here in the Phils.
(When we say small...its really small with almost 0
capitalization...just sheer guts and technical knowhow)
We have looked at OTN and checked the licensing terms for the use of the
software for training.
We have stumbled on this provision:
You may not:
·use the programs to provide third party training;
I was wondering if any of you know if there is a different licensing for
training institutions?
How does a non-oracle partner acquire license to use Oracle DB software
for training?
I am looking at partnering with Oracle, but we are just starting and
partnering costs $$.
I dare not call Oracle Philippines just yet...If there is a need to
purchase, and if we have the money, only then will we contact them.

Thanks.

=)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

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


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

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

RE: 9i "Reliability" means ?

[Paula_Stankus]

Title: RE: 9i "Reliability" means ?





Reliability would have to include Standby, Data Guard, RAC - pros/cons of all and when you might use one versus the other.  Also, go to the Freeman book as a start on new options and look through the new features and decide what could lead to more "reliable" systems.  I would say anything that makes admin./maint. easier - like undo segments (I AM HOPING) 

Good luck.


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 9i "Reliability" means ?





-Original Message-
Sent: Wednesday, February 05, 2003 8:53 AM
To: Multiple recipients of list ORACLE-L



Folks 


We are looking to present a Talk on :-


"Reliability" with respect to Oracle 9i DB


How does one even approach this subject ? 
What Sub-Topics would this envisage other than the following ? 


1) Oracle Architecture of Data Storage 
2) Backup & Recovery 
Do Standby Databases & Database Replication come under the subject
"Reliability" ? 


Using our Application Product we have Experience on Hybrid Oracle Databases
in :-


1) High End Database Performance Benchmarks
2) Regular Database Recoveries from Block Corruptions , Crashes 
3) Keeping Production Databases of sizes upto 1 TB working optimally .


Do you believe we can give a Talk on the Subject "Reliability" ?


The presentation might have in attendance some of the Leading Oracle minds .


Thanks


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


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


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

RE: How to dump UGA ??

[K Gopalakrishnan]

Jonathan:

How about calling the DBMS_SYSTEM.READ_EV procedure?
I think this is simpler than going to the UGA dumps..

THe restriction with DBMS_SYSTEM is, you can not get 
the event settings of the other sessions. But Dumps
can.



Best Regards,
K Gopalakrishnan

 


-Original Message-
Lewis
Sent: Wednesday, February 05, 2003 10:10 AM
To: Multiple recipients of list ORACLE-L



If you want to see if tracing is on:

alter session set events 'immediate trace name events level 1';

(level 2 for process level events, level 4 for system).

You can obviously use the oradebug equivalent, or
the dbms_support package to fire this at another
session.

However - if you can read the session's trace file
to find out the result of this command, then you will
be able to see from the content of the trace file that
it is (or isn't) tracing anyway.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

UK___March 19th
USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 04 February 2003 20:10


>Thanks Jonathan,
>
>I was trying to find where (and how) does it show that sql trace (or
event
>10046) is enabled in the session. Any pointers??
>
>TIA
>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-
>Sent: Tuesday, February 04, 2003 2:14 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>If you use oradebug you can do:
>oradebug dump heapdump 4
>or
>oradebug dump heapdump 4100
>
>These options dump the UGA heap.  The first is structure only, the
second
>includes content and could get quite large.
>
>

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

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


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

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

Re: How to create a new oracle database from SVRMGRL??

[Joan Hsieh]

forgot couple things, add this database to your oratab and added it to
your tnsnames.ora

Joan Hsieh wrote:
> 
> Majid,
> 
> 1. Create ini.ora, link this ini.ora to your oracle_home/dbs
> 2.  startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora
> 
> create database   TESTDB
> maxdatafiles  1021
> maxinstances  1
> maxlogfiles   8
> maxlogmembers 4
> character set WE8ISO8859P15
> datafile
> '/testdb/system01.dbf'  size 400M
> logfile
> '/redo1/testdb/log01.dbf' size 20M,
> '/redo1/testdb/log02.dbf' size 20M,
> '/redo1/testdb/log03.dbf' size 20M;
> 
> 3. run
> @$ORACLE_HOME/rdbms/admin/catalog.sql
> @$ORACLE_HOME/rdbms/admin/catproc.sql
> 4. Create rollback tablespace
> 5. Create your rollback segment
> 6. Create all your tablespaces
> 7. enjoy
> 
> Joan
> 
> majid wrote:
> >
> > 1)how can I create a new database frm SVRMGRL ?
> >
> > 2)can I have more than one database running in
> > oracle8i?
> >
> > thanks
> > --- [EMAIL PROTECTED] wrote:
> > > You can use DBCA(Database Config Assistant) to
> > > create a new Oracle DB or
> > > issue the
> > > commands starting from Create database . from
> > > SVRMGRL.
> > >
> > >
> > >
> > >
> > >
> > > majid <[EMAIL PROTECTED]>
> > > Sent by: [EMAIL PROTECTED]
> > > 02/04/03 08:43 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <[EMAIL PROTECTED]>
> > > cc:
> > > Subject:How to create a new oracle
> > > database 
> > >
> > >
> > > Hi, I am new to oracle, I just installed oracle8i in
> > > windows2000, durring the installation I called the
> > > default database "test", I wrote a small java class
> > > using the JDBC, everything is working fine, my
> > > question please :
> > >
> > > 1)can I create another database in oracle (leave the
> > > database "test")so I will have two databases in
> > > oracle
> > > ?
> > >
> > > 2)How can I create a database ?
> > >
> > > Thanks, your help is appreciated.
> > >
> > > __
> > > Do you Yahoo!?
> > > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > > now.
> > > http://mailplus.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.net
> > > --
> > > Author: majid
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051
> > > http://www.fatcity.com
> > > San Diego, California-- Mailing list and web
> > > hosting services
> > >
> > -
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from).  You may
> > > also send the HELP command for other information
> > > (like subscribing).
> > >
> > >
> > >
> > >
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: majid
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

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

Re: Sql query

[Igor Neyman]

There is no "join" condition between first two tables (PBK.UNDERLAG,
PBK.VARUKORGEANREL_ULAG) and last four tables (rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp).

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 05, 2003 9:52 AM


>
> I have  this sql query. I am wondering why this query takes so long time,
Do I need more conditions to make it run, or it it just that this query take
so long time to run? Anything wrong with the query?
>
> Please help me with this.
>
>  SELECT distinct PBK.VARUKORGEANREL_ULAG.ean, 0, 0, 0, rik2.vare.varenavn,
rik2.vare.str, PBK.VARUKORGEANREL_ULAG.lagstapris, rik2.vare.hylletxt2,
rik2.art_hierarki.vgrp, rik2.hierarki_tekst.tekst, '0', '0', 0,
pbk.underlag.period,
>
'rsm',pbk.sortiment_vgrp.sortiment,rik2.art_hierarki.art_grp,rik2.art_hierar
ki.art_ugrp
>  FROM PBK.UNDERLAG, PBK.VARUKORGEANREL_ULAG, rik2.vare,
rik2.hierarki_tekst, rik2.art_hierarki, pbk.sortiment_vgrp
>  WHERE PBK.underlag.underlagid=1100
>  AND PBK.underlag.varukorgid=PBK.varukorgeanrel_ulag.varukorgid
>  AND PBK.VARUKORGEANREL_ulag.varutyp=0;
>
>
> Thanks in advance
>
>
> Roland
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

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

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

Re: How to create a new oracle database from SVRMGRL??

[Joan Hsieh]

Majid,

1. Create ini.ora, link this ini.ora to your oracle_home/dbs
2.  startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora

create database   TESTDB
maxdatafiles  1021
maxinstances  1
maxlogfiles   8
maxlogmembers 4
character set WE8ISO8859P15
datafile
'/testdb/system01.dbf'  size 400M
logfile
'/redo1/testdb/log01.dbf' size 20M,
'/redo1/testdb/log02.dbf' size 20M,
'/redo1/testdb/log03.dbf' size 20M;

3. run
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
4. Create rollback tablespace 
5. Create your rollback segment
6. Create all your tablespaces
7. enjoy

Joan

majid wrote:
> 
> 1)how can I create a new database frm SVRMGRL ?
>
> 2)can I have more than one database running in
> oracle8i?
> 
> thanks
> --- [EMAIL PROTECTED] wrote:
> > You can use DBCA(Database Config Assistant) to
> > create a new Oracle DB or
> > issue the
> > commands starting from Create database . from
> > SVRMGRL.
> >
> >
> >
> >
> >
> > majid <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 02/04/03 08:43 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc:
> > Subject:How to create a new oracle
> > database 
> >
> >
> > Hi, I am new to oracle, I just installed oracle8i in
> > windows2000, durring the installation I called the
> > default database "test", I wrote a small java class
> > using the JDBC, everything is working fine, my
> > question please :
> >
> > 1)can I create another database in oracle (leave the
> > database "test")so I will have two databases in
> > oracle
> > ?
> >
> > 2)How can I create a database ?
> >
> > Thanks, your help is appreciated.
> >
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > now.
> > http://mailplus.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: majid
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> >
> >
> >
> >
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: majid
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joan Hsieh
  INET: [EMAIL PROTECTED]

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

RE: Size of a Long Field

[Janardhana Babu Donga]

Try 
this,
 
Select 
table_name,column_name,data_length,data_type 
from 
dba_tab_columns 
where 
owner = '' 
and 
data_type='LONG' ;
 
-- 
Babu

  -Original Message-From: Ed Bittel 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 05, 2003 
  6:53 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Size of a Long Field
  
  How do you determine the size, in 
  bytes, of a long field?
   
  Please. No tape measure 
  jokes.
   
  Ed
   

Re:RE: How to create a new oracle database from SVRMGRL??

[dgoulet]

Sony,

Don't you mean Database Configuration Assistant?  Not only does it create
the database, but configures the listener as required and the registry.

Dick Goulet

Reply Separator
Author: Sony kristanto <[EMAIL PROTECTED]>
Date:   2/4/2003 7:08 PM

Hi Majid,

1)how can I create a new database frm SVRMGRL ?
Use DATABASE MIGRATION ASSISTANT, it is more easy to use.

2)can I have more than one database running in
oracle8i?
Yes you can.

Hope this helps.

Rgrds,

Sony

  

> -Original Message-
> From: majid [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 04, 2003 10:50 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  How to create a new oracle database from SVRMGRL??
> 
> 1)how can I create a new database frm SVRMGRL ?
>  
> 2)can I have more than one database running in
> oracle8i?
> 
> thanks
> --- [EMAIL PROTECTED] wrote:
> > You can use DBCA(Database Config Assistant) to
> > create a new Oracle DB or 
> > issue the 
> > commands starting from Create database . from
> > SVRMGRL.
> > 
> > 
> > 
> > 
> > 
> > majid <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 02/04/03 08:43 AM
> > Please respond to ORACLE-L
> > 
> >  
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc: 
> > Subject:How to create a new oracle
> > database 
> > 
> > 
> > Hi, I am new to oracle, I just installed oracle8i in
> > windows2000, durring the installation I called the
> > default database "test", I wrote a small java class
> > using the JDBC, everything is working fine, my
> > question please :
> > 
> > 1)can I create another database in oracle (leave the
> > database "test")so I will have two databases in
> > oracle
> > ?
> > 
> > 2)How can I create a database ?
> > 
> > Thanks, your help is appreciated.
> > 
> > __
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > now.
> > http://mailplus.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: majid
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> > 
> > 
> > 
> > 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: majid
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  INET: [EMAIL PROTECTED]

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

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

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

RE: HPUX SCSI Performance

[david hill]

Title: RE: HPUX SCSI Performance





HPUX 11i version 1.6 for itanium on vxfs


-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 05, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: HPUX SCSI Performance


What OS?  What filesystem?


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


-Original Message-
Sent: Wednesday, February 05, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L



Hi Guys
I'm hoping there is sysadmin in the list that can help me.
 
We just received a brand new Itanium Server to play with
It has 2  U320 disk not striped or mirrored or anything 
 
Doing test and monitoring them through glance, is giving me a transfer rate
of about 15Megs a sec
These should be up around 60 - 80 megs right?
 
My sysadmin says there is nothing he can do.
Can someone tell if there is some sort setting he hasn't set or a config
somewhere?
 
Thanks.
David Hill
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]


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