Antw: RE: select distinct values
Hi Rich, same for me. Just one diference: my table is named surrogate_brain ;-) Greetings, Guido [EMAIL PROTECTED] 24.09.2003 00.29 Uhr Man, every time I think I have a handle on the analytic functions, someone bowls me over with it's power and simplicity. I was trying to do this using the FIRST function of 9i. Oh well. INSERT INTO saved_messages ... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke 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).
Tuning help required
Hi All,
I need help in tuning the following query. It takes around 6-7 minutes to run. I hope that someone will be able to go through the details and give me a few pointers.
I have gathered a few statistics, but don't know where to go from here.
Please view the mail in a fixed size font e.g. courier to preserve the formatting. If the lines wrap over copying and pasting in a text editor might help, though I'm not sure.
I apologize for the long message in advance.
Following is the query:
SELECT UNIQUE MEPAI.MPAI_NAV_MOD ,MEPAI.MPAI_NAV_MODS,MEPAI.MPAI_SYS_NO,MEPAI.MPAI_PAI_SYS_NO,MEPAI.MPAI_AS_OF_DATE,PRODUCTS.ISS_INSTR_ID PRODUCT_INSTR_ID,CUR.CUR_CURRENCY_NAME,CUR.CUR_CURRENCY_CODE,CUR.CUR_SYS_NOFROMEPR_CURRENCIES CUR,EPR_GEOGRAPHIES GEO,EPR_PRODUCTS PRODUCTS,MOD_EPR_PRICING_ASSET_INFO MEPAIWHERE!
sp;
MEPAI.MPAI_ISS_SYS_NO = PRODUCTS.ISS_SYS_NOANDMEPAI.MPAI_GEO_SYS_NO = GEO.GEO_SYS_NOANDMEPAI.MPAI_CUR_SYS_NO = CUR.CUR_SYS_NOANDMEPAI.MPAI_AS_OF_DATE IN ( to_date('03/01/2003','MM/DD/'), to_date('03/02/2003','MM/DD/'), to_date('03/03/2003','MM/DD/'), to_date('03/04/2003','MM/DD/'), to_date('03/05/2003','MM/DD/'), to_date('03/06/2003','MM/DD/'), to_date('03/07/2003','MM/DD/'), to_date('03/08/2003','MM/DD/'), to_date('03/09/2003','MM/DD/'), to_date('03/10/2003','MM/DD/'), to_date('03/11/2003','MM/DD/'), to_date('03/12/2003','MM/DD/'), to_date('03/13/2003','MM/DD/'), to_date('03/14/2003','MM/DD/'), to_date('03/15/2003','MM/DD/'), to_date('03/16/2003','MM/DD/'), to_date('03/17/2003','MM/DD/'), to_date('03/18/2003','MM/DD/')!
;,
to_date('03/19/2003','MM/DD/'), to_date('03/20/2003','MM/DD/'), to_date('03/21/2003','MM/DD/'), to_date('03/22/2003','MM/DD/'), to_date('03/23/2003','MM/DD/'), to_date('03/24/2003','MM/DD/'), to_date('03/25/2003','MM/DD/'), to_date('03/26/2003','MM/DD/'), to_date('03/27/2003','MM/DD/'), to_date('03/28/2003','MM/DD/'), to_date('03/29/2003','MM/DD/'), to_date('03/30/2003','MM/DD/'), to_date('03/31/2003','MM/DD/')) ANDPRODUCTS.ISS_INSTR_ID in (1321,1339,1344,1342,1343,1341,1340) ANDCUR.CUR_SYS_NO in (200,226)Order By MEPAI.MPAI_SYS_NO
Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=515 Card=122 Bytes=8296) 1 0 SORT (UNIQUE) (Cost=503 Card=122 Bytes=8296) 2 1 CONCATENATION 3 2 NESTED LOOPS (Cost=223 Card=61 Bytes=4148) 4 3 HASH JOIN (Cost=223 Card=61 Bytes=3965) 5 4 INLIST ITERATOR 6 5 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_PRODUCTS' (Cost=3 Card=16 Bytes=128) 7
6 INDEX (RANGE SCAN) OF 'ISS_ISS_INSTR_ID' (NON-UNIQUE) (Cost=2 Card=16) 8 4 NESTED LOOPS (Cost=219 Card=4415 Bytes=251655) 9 8 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_CURRENCIES' (Cost=1 Card=1 Bytes=21) 10 9 INDEX (UNIQUE SCAN) OF 'CUR_PK' (UNIQUE) 11 8 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'MOD_EPR_PRICING_ASSET_INFO' (Cost=218 Card=92720 Bytes=3337920) 12 11 INDEX (RANGE SCAN) OF
'MPAI_CUR_FK_I' (NON-UNIQUE) (Cost=217 Card=92720) 13 3 INDEX (UNIQUE SCAN) OF 'GEO_PK' (UNIQUE) 14 2 NESTED LOOPS (Cost=223 Card=61 Bytes=4148) 15 14 HASH JOIN (Cost=223 Card=61 Bytes=3965) 16 15 INLIST ITERATOR 17 16 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_PRODUCTS' (Cost=3 Card=16 Bytes=128) 18 17 INDEX (RANGE SCAN) OF 'ISS_ISS_INSTR_ID' (NON-UNIQUE) (Cost=2 Card=16) 19 15 NESTED LOOPS (Cost=219 Card=4415
Bytes=251655) 20 19 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_CURRENCIES' (Cost=1 Card=1 Bytes=21) 21 20 INDEX (UNIQUE SCAN) OF 'CUR_PK' (UNIQUE) 22 19 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'MOD_EPR_PRICING_ASSET_INFO' (Cost=218 Card=92720 Bytes=3337920) 23 22 INDEX (RANGE SCAN) OF 'MPAI_CUR_FK_I' (NON-UNIQUE) (Cost=217 Card=92720) 24 14 INDEX (UNIQUE SCAN) OF 'GEO_PK' (UNIQUE)
The output of the following query before running the SQL and after running the SQL are as follows:
SQL select names.name, stats.value 2 from v$session sessions, v$sesstat stats, v$statname names 3 where stats.statistic# = names.statistic# 4 and stats.sid = sessions.sid 5 and sessions.audsid = userenv('SESSIONID') 6 and value != 0 7 order by value desc;
Before running the problem query:
NAME VALUE- --bytes sent via SQL*Net to client 3640bytes received via SQL*Net from client 2587SQL*Net roundtrips to/from client 40user
calls 38recursive calls 37session logical reads 29opened cursors
cumulative 17buffer is not pinned count 17db block gets 16execute count
15parse count (total) 15consistent gets 13no work - consistent read gets 10calls to get snapshot scn: kcmgss 9table fetch by
rowid 7table scans (short tables) 4opened cursors current 3table scan rows gotten 2free buffer
requested 2parse time cpu 2parse time elapsed 2physical
reads 2table scan blocks gotten 2logons cumulative 1parse count
(hard) 1enqueue requests 1hot buffers moved to head of LRU 1CPU used when call started 1CPU used by this
session 1total file opens 1enqueue
RE: YEAAAAAAAAAAAAAAAAAAA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!, drop in number
A, these Yanks... such citizens of the world community, ain't they? Bless. -Original Message- Sent: 23 September 2003 21:50 To: Multiple recipients of list ORACLE-L in number I'll be happier when I see hi-tech workers arguing for a ban on Nike footwear unless made in the US and a pledge to avoid oil from the mid-east and an utmost commitment not to work for companies using foreign imports - no SAP consultants for example. :( Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: Paul Vincent 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: Tuning help required
Before checking stats, execution plans and the like take a look at your query. I
presume that it is generated, otherwise you would probably say that a date belongs to
a month by using a BETWEEN the first and the thirty first rather than listing all the
31 days, would you ? Now perhaps the generator could generate a BETWEEN if you are
always interested by consecutive days?
Note that the GEO table is totally useless in the FROM clause. You return no data from
it, and it is not needed to join together two tables you return data from. If you need
it to check some data consistency, it should be in a subquery (IN or EXISTS, depending
on the volumes of data to process), but best of all the problem should have been
tackled at the root with referential integrity constraints. Even if you may have
(always those b***y generators) it should be better located in a subquery - by the
way, it might help you dispose of the UNIQUE (calling DISTINCT UNIQUE doesn't make it
better :-)).
The condition of CUR_SYS_NO should be applied to the column from MEPAI, which you will
encounter first, rather than the column from CUR, since they are equal.
Now you have to decide which of MEPAI or PRODUCTS should be the table you search
first. It depends on the selectivity of your data. Be certain that your table and
index statistics are up-to-date. If you still feel that Oracle processes it badly, try
playing on the optimizer goal (FIRST_ROWS/ALL_ROWS) and if you get a result which
satisfies you add it as a hint.
SF
- --- Original Message --- -
From: New DBA [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 23 Sep 2003 23:39:44
Hi All,
I need help in tuning the following query. It takes
around 6-7 minutes to run. I hope that someone will
be able to go through the details and give me a few
pointers.
I have gathered a few statistics, but don't know
where to go from here.
Please view the mail in a fixed size font e.g.
courier to preserve the formatting. If the lines
wrap over copying and pasting in a text editor
might help, though I'm not sure.
I apologize for the long message in advance.
Following is the query:
SELECT UNIQUE
MEPAI.MPAI_NAV_MOD ,
MEPAI.MPAI_NAV_MODS,
MEPAI.MPAI_SYS_NO,
MEPAI.MPAI_PAI_SYS_NO,
MEPAI.MPAI_AS_OF_DATE,
PRODUCTS.ISS_INSTR_ID PRODUCT_INSTR_ID,
CUR.CUR_CURRENCY_NAME,
CUR.CUR_CURRENCY_CODE,
CUR.CUR_SYS_NO
FROM
EPR_CURRENCIESCUR,
EPR_GEOGRAPHIES GEO,
EPR_PRODUCTS PRODUCTS,
MOD_EPR_PRICING_ASSET_INFOMEPAI
WHERE MEPAI.MPAI_ISS_SYS_NO =
PRODUCTS.ISS_SYS_NO
AND MEPAI.MPAI_GEO_SYS_NO = GEO.GEO_SYS_NO
AND MEPAI.MPAI_CUR_SYS_NO = CUR.CUR_SYS_NO
AND MEPAI.MPAI_AS_OF_DATE IN
(
to_date('03/01/2003','MM/DD/'),
to_date('03/02/2003','MM/DD/')
, to_date('03/03/2003','MM/DD/'),
to_date('03/04/2003','MM/DD/')
, to_date('03/05/2003','MM/DD/'),
to_date('03/06/2003','MM/DD/')
, to_date('03/07/2003','MM/DD/'),
to_date('03/08/2003','MM/DD/')
, to_date('03/09/2003','MM/DD/'),
to_date('03/10/2003','MM/DD/')
, to_date('03/11/2003','MM/DD/'),
to_date('03/12/2003','MM/DD/')
, to_date('03/13/2003','MM/DD/'),
to_date('03/14/2003','MM/DD/')
, to_date('03/15/2003','MM/DD/'),
to_date('03/16/2003','MM/DD/')
, to_date('03/17/2003','MM/DD/'),
to_date('03/18/2003','MM/DD/')
, to_date('03/19/2003','MM/DD/'),
to_date('03/20/2003','MM/DD/')
, to_date('03/21/2003','MM/DD/'),
to_date('03/22/2003','MM/DD/')
, to_date('03/23/2003','MM/DD/'),
to_date('03/24/2003','MM/DD/')
, to_date('03/25/2003','MM/DD/'),
to_date('03/26/2003','MM/DD/')
, to_date('03/27/2003','MM/DD/'),
to_date('03/28/2003','MM/DD/')
, to_date('03/29/2003','MM/DD/'),
to_date('03/30/2003','MM/DD/')
, to_date('03/31/2003','MM/DD/')
)
AND PRODUCTS.ISS_INSTR_ID in
(1321,1339,1344,1342,1343,1341,1340)
AND CUR.CUR_SYS_NO in (200,226)
Order By MEPAI.MPAI_SYS_NO
--
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: Oracle8i, Failsafe and patchset 12
Jared The URL refers to an alert for NT 4.0, Patrice is talking about Windows 2000 (which is also the MS flavour I'm having problems on), am I being blind here but those are 2 different products? If there is a similar alert for Windows2000 I'd certainly like to hear about it. If anybody is interested in the original Failsafe issue then I can tell you that this morning Oracle have acknowledged it as being a bug (failsafe is looking for Oracle9 libraries!). Fix is "being worked on". T¬ -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 23 September 2003 18:45To: Multiple recipients of list ORACLE-LSubject: RE: Oracle8i, Failsafe and patchset 12 You would be well advised to *not* install SP4. It will destroy network performance. Supposedly this can be corrected: http://tinyurl.com/odlwor http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q249/7/99.aspNoWebContent=1 Jared "Boivin, Patrice J" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 06:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle8i, Failsafe and patchset 12The latest service pack for Win2K is SP4. Patrice. -Original Message-From: Tim Onions [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle8i, Failsafe and patchset 12Good question, it's an Oracle8i patchset not a Windows one. _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: 23 September 2003 12:50To: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: Oracle8i, Failsafe and patchset 12Tim, Just curious - is Patchset 12 for Windows 2000, or for Oracle? Sorry if it's a dumb question, but I am lost in the context. thanks! Tom Mercadante Oracle Certified Professional -Original Message-From: Tim Onions [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 8:40 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle8i, Failsafe and patchset 12To anybody using Oracle8i and failsafe, After implementing 8.1.7.4 patchset 12 on my Windows 2000 adv server failsafe configuration failsafe (and MS Cluster administrator) stopped being able to control the Oracle service (it can stop it but not start it again - saying things like "file not found"!). All the due diligence exercises have been done and I am convinced the patching was no flawed on my part. I suspect a bug in the patch set and Oracle support are indicating that others may be having the same problem. My database runs fine but has had to be removed from failsafe. So two things: 1 - if you are using failsafe and Oracle8i think very carefully before applying patch set 12 2 - if you have applied patch set 12 either successfully or unsuccessfully with failsafe I'd love to hear from you so I can either put pressure on Oracle for a fix or share some thoughts on what is going on. Many thanks T¬
RE: Tuning help required
In addition, since you're using the cost-based optimizer (CBO), make sure
that you've used dbms_stats to gather statistics on all the objects
involved in the query recently. If you have any columns where histograms
would be useful, make sure you've gathered histograms for those columns.
Justin Cave
At 02:49 AM 9/24/2003, you wrote:
Before checking stats, execution plans and the like take a look at your
query. I presume that it is generated, otherwise you would probably say
that a date belongs to a month by using a BETWEEN the first and the thirty
first rather than listing all the 31 days, would you ? Now perhaps the
generator could generate a BETWEEN if you are always interested by
consecutive days?
Note that the GEO table is totally useless in the FROM clause. You return
no data from it, and it is not needed to join together two tables you
return data from. If you need it to check some data consistency, it should
be in a subquery (IN or EXISTS, depending on the volumes of data to
process), but best of all the problem should have been tackled at the root
with referential integrity constraints. Even if you may have (always those
b***y generators) it should be better located in a subquery - by the way,
it might help you dispose of the UNIQUE (calling DISTINCT UNIQUE doesn't
make it better :-)).
The condition of CUR_SYS_NO should be applied to the column from MEPAI,
which you will encounter first, rather than the column from CUR, since
they are equal.
Now you have to decide which of MEPAI or PRODUCTS should be the table
you search first. It depends on the selectivity of your data. Be certain
that your table and index statistics are up-to-date. If you still feel
that Oracle processes it badly, try playing on the optimizer goal
(FIRST_ROWS/ALL_ROWS) and if you get a result which satisfies you add it
as a hint.
SF
- --- Original Message --- -
From: New DBA [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 23 Sep 2003 23:39:44
Hi All,
I need help in tuning the following query. It takes
around 6-7 minutes to run. I hope that someone will
be able to go through the details and give me a few
pointers.
I have gathered a few statistics, but don't know
where to go from here.
Please view the mail in a fixed size font e.g.
courier to preserve the formatting. If the lines
wrap over copying and pasting in a text editor
might help, though I'm not sure.
I apologize for the long message in advance.
Following is the query:
SELECT UNIQUE
MEPAI.MPAI_NAV_MOD ,
MEPAI.MPAI_NAV_MODS,
MEPAI.MPAI_SYS_NO,
MEPAI.MPAI_PAI_SYS_NO,
MEPAI.MPAI_AS_OF_DATE,
PRODUCTS.ISS_INSTR_ID PRODUCT_INSTR_ID,
CUR.CUR_CURRENCY_NAME,
CUR.CUR_CURRENCY_CODE,
CUR.CUR_SYS_NO
FROM
EPR_CURRENCIESCUR,
EPR_GEOGRAPHIES GEO,
EPR_PRODUCTS PRODUCTS,
MOD_EPR_PRICING_ASSET_INFOMEPAI
WHERE MEPAI.MPAI_ISS_SYS_NO =
PRODUCTS.ISS_SYS_NO
AND MEPAI.MPAI_GEO_SYS_NO = GEO.GEO_SYS_NO
AND MEPAI.MPAI_CUR_SYS_NO = CUR.CUR_SYS_NO
AND MEPAI.MPAI_AS_OF_DATE IN
(
to_date('03/01/2003','MM/DD/'),
to_date('03/02/2003','MM/DD/')
, to_date('03/03/2003','MM/DD/'),
to_date('03/04/2003','MM/DD/')
, to_date('03/05/2003','MM/DD/'),
to_date('03/06/2003','MM/DD/')
, to_date('03/07/2003','MM/DD/'),
to_date('03/08/2003','MM/DD/')
, to_date('03/09/2003','MM/DD/'),
to_date('03/10/2003','MM/DD/')
, to_date('03/11/2003','MM/DD/'),
to_date('03/12/2003','MM/DD/')
, to_date('03/13/2003','MM/DD/'),
to_date('03/14/2003','MM/DD/')
, to_date('03/15/2003','MM/DD/'),
to_date('03/16/2003','MM/DD/')
, to_date('03/17/2003','MM/DD/'),
to_date('03/18/2003','MM/DD/')
, to_date('03/19/2003','MM/DD/'),
to_date('03/20/2003','MM/DD/')
, to_date('03/21/2003','MM/DD/'),
to_date('03/22/2003','MM/DD/')
, to_date('03/23/2003','MM/DD/'),
to_date('03/24/2003','MM/DD/')
, to_date('03/25/2003','MM/DD/'),
to_date('03/26/2003','MM/DD/')
, to_date('03/27/2003','MM/DD/'),
to_date('03/28/2003','MM/DD/')
, to_date('03/29/2003','MM/DD/'),
to_date('03/30/2003','MM/DD/')
, to_date('03/31/2003','MM/DD/')
)
AND PRODUCTS.ISS_INSTR_ID in
(1321,1339,1344,1342,1343,1341,1340)
AND CUR.CUR_SYS_NO in (200,226)
Order By MEPAI.MPAI_SYS_NO
--
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
Re: Tuning help required
Well, I'd start by writing the date part as :
MEPAI.MPAI_AS_OF_DATE between to_date('03/01/2003','MM/DD/') and
to_date('03/31/2003','MM/DD/')
It will at the very least make the query easier to read and understand
(also for the optimizer : it will know it's filtering on a range instead
of distinct values).
regards
Jo
New DBA [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/24/2003 09:39
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Tuning help required
Hi All,
I need help in tuning the following query. It takes around 6-7 minutes to
run. I hope that someone will be able to go through the details and give
me a few pointers.
I have gathered a few statistics, but don't know where to go from here.
Please view the mail in a fixed size font e.g. courier to preserve the
formatting. If the lines wrap over copying and pasting in a text editor
might help, though I'm not sure.
I apologize for the long message in advance.
Following is the query:
SELECT UNIQUE
MEPAI.MPAI_NAV_MOD ,
MEPAI.MPAI_NAV_MODS,
MEPAI.MPAI_SYS_NO,
MEPAI.MPAI_PAI_SYS_NO,
MEPAI.MPAI_AS_OF_DATE,
PRODUCTS.ISS_INSTR_ID PRODUCT_INSTR_ID,
CUR.CUR_CURRENCY_NAME,
CUR.CUR_CURRENCY_CODE,
CUR.CUR_SYS_NO
FROM
EPR_CURRENCIESCUR,
EPR_GEOGRAPHIES GEO,
EPR_PRODUCTS PRODUCTS,
MOD_EPR_PRICING_ASSET_INFOMEPAI
WHERE nb! sp; MEPAI.MPAI_ISS_SYS_NO = PRODUCTS.ISS_SYS_NO
AND MEPAI.MPAI_GEO_SYS_NO = GEO.GEO_SYS_NO
AND MEPAI.MPAI_CUR_SYS_NO = CUR.CUR_SYS_NO
AND MEPAI.MPAI_AS_OF_DATE IN
(
to_date('03/01/2003','MM/DD/'), to_date('03/02/2003','MM/DD/')
, to_date('03/03/2003','MM/DD/'), to_date('03/04/2003','MM/DD/')
, to_date('03/05/2003','MM/DD/'), to_date('03/06/2003','MM/DD/')
, to_date('03/07/2003','MM/DD/'), to_date('03/08/2003','MM/DD/')
, to_date('03/09/2003','MM/DD/'), to_date('03/10/2003','MM/DD/')
, to_date('03/11/2003','MM/DD/'), to_date('03/12/2003','MM/DD/')
, to_date('03/13/2003','MM/DD/'), to_date('03/14/2003','MM/DD/')
, to_date('03/15/2003','MM/DD/'), to_date('03/16/2003','MM/DD/')
, to_date('03/17/2003','MM/DD/'), to_date('03/18/2003','MM/DD/')
! ;, to_date('03/19/2003','MM/DD/'),
to_date('03/20/2003','MM/DD/')
, to_date('03/21/2003','MM/DD/'), to_date('03/22/2003','MM/DD/')
, to_date('03/23/2003','MM/DD/'), to_date('03/24/2003','MM/DD/')
, to_date('03/25/2003','MM/DD/'), to_date('03/26/2003','MM/DD/')
, to_date('03/27/2003','MM/DD/'), to_date('03/28/2003','MM/DD/')
, to_date('03/29/2003','MM/DD/'), to_date('03/30/2003','MM/DD/')
, to_date('03/31/2003','MM/DD/')
)
AND PRODUCTS.ISS_INSTR_ID in (1321,1339,1344,1342,1343,1341,1340)
AND CUR.CUR_SYS_NO in (200,226)
Order By MEPAI.MPAI_SYS_NO
Execution Plan
--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=515 Card=122 Bytes=8296)
10 SORT (UNIQUE) (Cost=503 Card=122 Bytes=8296)
21 CONCATENATION
32 NESTED LOOPS (Cost=223 Card=61 Bytes=4148)
43 HASH JOIN (Cost=223 Card=61 Bytes=3965)
54 INLIST ITERATOR
65 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_PRODUCTS'
(Cost=3 Card=16 Bytes=128)
76 INDEX (RANGE SCAN) OF 'ISS_ISS_INSTR_ID'
(NON-UNIQUE) (Cost=2 Card=16)
84 NESTED LOOPS (Cost=219 Card=4415 Bytes=251655)
98 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_CURRENCIES'
(Cost=1 Card=1 Bytes=21)
109 INDEX (UNIQUE SCAN) OF 'CUR_PK' (UNIQUE)
118 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF
'MOD_EPR_PRICING_ASSET_INFO' (Cost=218 Card=92720 Bytes=3337920)
12 11 INDEX (RANGE SCAN) OF 'MPAI_CUR_FK_I' (NON-UNIQUE)
(Cost=217 Card=92720)
133 INDEX (UNIQUE SCAN) OF 'GEO_PK' (UNIQUE)
142 NESTED LOOPS (Cost=223 Card=61 Bytes=4148)
15 14 HASH JOIN (Cost=223 Card=61 Bytes=3965)
16 15 INLIST ITERATOR
17 16 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_PRODUCTS'
(Cost=3 Card=16 Bytes=128)
18 17 INDEX (RANGE SCAN) OF 'ISS_ISS_INSTR_ID'
(NON-UNIQUE) (Cost=2 Card=16)
19 15 NESTED LOOPS (Cost=219 Card=4415 Bytes=251655)
20 19 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_CURRENCIES'
(Cost=1 Card=1 Bytes=21)
21 20 INDEX (UNIQUE SCAN) OF 'CUR_PK' (UNIQUE)
22 19 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF
'MOD_EPR_PRICING_ASSET_INFO' (Cost=218 Card=92720 Bytes=3337920)
23 22 INDEX (RANGE SCAN) OF 'MPAI_CUR_FK_I' (NON-UNIQUE)
(Cost=217 Card=92720)
24 14 INDEX (UNIQUE SCAN) OF 'GEO_PK' (UNIQUE)
The output of the following query before running the SQL and after running
the SQL are
RE: Tuning help required
Hi New DBA, Further to what Stephane has said below, the following two stats in your initial post are interesting ... consistent gets 559985 table fetch continued row 212027 That suggests that there is a fair amount of row chaining or migration in one of the tables. If it's migration, rather than chaining, you'll get a ~37% reduction in logical reads if you fix it. The following script can often be used to distinguish between chaining and migration. It counts the number of rows for which the first column is not able to be returned from the first row piece. Although it is possible for that to be the case with row chaining, it's more likely a symptom of migration. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all accept OwnerName prompt Owner Name: accept TableName prompt Table Name: prompt set termout off delete from chained_rows where owner_name = 'OwnerName' and table_name = 'TableName' / @utlchain column column_name new_value ColumnName select column_name from dba_tab_columns where owner = 'OwnerName' and table_name = 'TableName' and rownum = 1 / set termout on prompt Analyzing table. Please wait ... analyze table OwnerName . TableName list chained rows into chained_rows / select count(*) continued_rows from chained_rows where owner_name = 'OwnerName' and table_name = 'TableName' / prompt Checking continued rows for migration ... set termout off column start_value new_value StartValue select m.value start_value from sys.v_$mystat m, sys.v_$statname n where n.name = 'table fetch continued row' and n.statistic# = m.statistic# / select /*+ ordered */ sum(vsize(t.ColumnName)) from chained_rows c, TableNamet where c.owner_name = 'OwnerName' and c.table_name = 'TableName' and t.rowid = c.head_rowid / set termout on select m.value - StartValue migrated_rows from sys.v_$mystat m, sys.v_$statname n where n.name = 'table fetch continued row' and n.statistic# = m.statistic# / -Original Message- Stephane Faroult Sent: Wednesday, 24 September 2003 6:50 PM To: Multiple recipients of list ORACLE-L Before checking stats, execution plans and the like take a look at your query. I presume that it is generated, otherwise you would probably say that a date belongs to a month by using a BETWEEN the first and the thirty first rather than listing all the 31 days, would you ? Now perhaps the generator could generate a BETWEEN if you are always interested by consecutive days? Note that the GEO table is totally useless in the FROM clause. You return no data from it, and it is not needed to join together two tables you return data from. If you need it to check some data consistency, it should be in a subquery (IN or EXISTS, depending on the volumes of data to process), but best of all the problem should have been tackled at the root with referential integrity constraints. Even if you may have (always those b***y generators) it should be better located in a subquery - by the way, it might help you dispose of the UNIQUE (calling DISTINCT UNIQUE doesn't make it better :-)). The condition of CUR_SYS_NO should be applied to the column from MEPAI, which you will encounter first, rather than the column from CUR, since they are equal. Now you have to decide which of MEPAI or PRODUCTS should be the table you search first. It depends on the selectivity of your data. Be certain that your table and index statistics are up-to-date. If you still feel that Oracle processes it badly, try playing on the optimizer goal (FIRST_ROWS/ALL_ROWS) and if you get a result which satisfies you add it as a hint. SF - --- Original Message --- - From: New DBA [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 23 Sep 2003 23:39:44 Hi All, I need help in tuning the following query. It takes around 6-7 minutes to run. I hope that someone will be able to go through the details and give me a few pointers. I have gathered a few statistics, but don't know where to go from here. Please view the mail in a fixed size font e.g. courier to preserve the formatting. If the lines wrap over copying and pasting in a text editor might help, though I'm not sure. I apologize for the long message in advance. Following is the query: SELECT UNIQUE MEPAI.MPAI_NAV_MOD , MEPAI.MPAI_NAV_MODS, MEPAI.MPAI_SYS_NO, MEPAI.MPAI_PAI_SYS_NO, MEPAI.MPAI_AS_OF_DATE, PRODUCTS.ISS_INSTR_ID PRODUCT_INSTR_ID, CUR.CUR_CURRENCY_NAME, CUR.CUR_CURRENCY_CODE, CUR.CUR_SYS_NO FROM EPR_CURRENCIESCUR, EPR_GEOGRAPHIES GEO, EPR_PRODUCTS PRODUCTS, MOD_EPR_PRICING_ASSET_INFOMEPAI WHERE MEPAI.MPAI_ISS_SYS_NO = PRODUCTS.ISS_SYS_NO AND MEPAI.MPAI_GEO_SYS_NO = GEO.GEO_SYS_NO AND MEPAI.MPAI_CUR_SYS_NO = CUR.CUR_SYS_NO AND
Re: Offshore protests
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Hyderabad. USS Enterprise will have to be renamed to USS Utar Pradesh, with captain Sanjay and Mr. Spock at the helm. I can definitely see a value there. 'sOK. But I swear the first time I see anyone suggesting we outsource driving taxis or milking cows to Mars via Internet, I'll spew!... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Cary's book -- Out of stock !
I ordered my copy from Bookpool on September 18 and it was out-of-stock at that time. I'm waiting patiently. -Original Message- Sent: Wednesday, September 24, 2003 1:40 AM To: Multiple recipients of list ORACLE-L i placed my order at bookpool on 20-09-2003. ...anxiously waiting for my copy i wonder when i will have it in my hand ?!!! have anyone experienced any delay with bookpool ? hope it's better than Amazon, isn't it ? wolfgang,hope u misunderstood me. i asked Tom about the vendor he chose. thanx for the link anyway.let me go thro' chapter 1 online. Jp. 24-09-2003 14:14:45, Mladen Gogala [EMAIL PROTECTED] wrote: I believe this should answer your question: Barnes Noble.com Your Order Has Been Shipped Dear MLADEN GOGALA: Your order has been shipped, and the details appear below. Within 24 hours of receiving this email, you may track the delivery status of your order at http://www.dropshipexpress.com/tracking/tracking.asp?DCN=42006611910212 6 The book, which isn't available, according to Amazon, has been shipped by B N. It will probably be a big surprise, but my recommendation is definitely Barnes Noble. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Rothouse, Michael 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: Hiding passwords
Jared, You said: "One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable." This is true. But to accomplish the same functionality, you can dynamically create a temporary .bat file that creates the environmental and then execute that bat file. Unfortunately on Windows, anything that you do can be repeated by someone else who logs onto the system. I guess you could secure a folder that only the Oracle account could see, and have these scripts placed in those folders so that the other users cannot get into them without rebooting the machine and bringing it up in DOS mode. That (I think) would prevent snooping. Not sure though. Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 6:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hiding passwordsPaul, Any chance these scripts could be run from Cygwin, Uwin, MKS Toolkit, or anything that will let you use a korn shell? That would simplify things tremendously. One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. That ability would make this task simple from command.com. Another possibility is to put your passwords in the registry, restrict that portion of the registry, ( or the whole thing ), and use a Perl script to retrieve the passwords and kick off the other jobs. What I do in linux is use a password server ( as seen in "Perl for Oracle DBA's") and retrieve the password across the network, encrypted of course. This works on windows as well, though you're there restricted to doing this strictly from within the Perl script. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 01:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwordsTom, As Dave Barry would say, Har! Unfortunately, we are talking about 3rd-party people who have the 'right' to log in for support (debugging their ^%(^#@ products, and installing updates). I've got them under local admin accounts (as opposed to domain accounts), so they can only get to their own servers. BUT... that's as far as I can go to secure things except at the folder level (and Oracle loves it (!) when you try and do folder security on the datafiles, controlfiles, etc.). I appreciate the thought, but you did not go far enough... Kill them all, and save on security hardware. Any workable ideas? Desperately yours,Paul R. ShermanDBA/Sr. Appl. AnalystBacou-Dallozoffice - 401-232-1200 x200cell - 401-935-2802 "Mercadante, Thomas F" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwordsPaul, It's simple really. Do not allow them to log-on to the Win2k server - don't give them an account; keep the passwords secret; and keep the machine in a locked room. Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 4:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Hiding passwordsHello, If you do that in Win2k, then you have more env variables for 'authorized' people to see when they do a SET cr. Now, to be frank, I have an ulterior (a 'maxed-out' interior or exterior) motive in this reply. I have yet to see an intelligent (never mind elegant) of protecting system variables from someone's view when they do a SET in a DOS session. You can keep them out of Control Panel/System/Advanced/Environmental Variables, but you can't keep them out of DOS, so whaddya do? That's what I want to know. Has anyone confronted this issue and won? Thank you,Paul R. ShermanDBA/Sr. Appl. AnalystBacou-Dallozoffice - 401-232-1200 x200cell - 401-935-2802 "M.Godlewski" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 02:15 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: Hiding passwordsYou could set up environment variables and then reference the environment variable in your script. HTH M.[EMAIL PROTECTED] wrote: There is a good discussion in asktom website on this topic.Here is the link
RE: suggestion
hmmm... here is what I did ... change user_dump_dest to a file system which has lots of space, 100G in our case modify a logon trigger and for a certain group of people (based on a role) "execute dbms_support.start_trace"; Create a logoff trigger that raises a alert user_logoff and sends a trace file string (actual name of the trace file). I had a SQR report running on both sides of RAC waiting to respond to this alert. As soon as this alert came, it waited 1 second and then went to system and verified that it owned the trace file (based on the instance) and then gzipped it and based on the date moved to a directory. When we got tired of collecting trace files, we stopped the process. All of this is fairly easy to do, it took me about an hour to put this all together. If you just want sql text, you may want to use "dbms_support.start_trace(false,true)" .. it will avoid wait events listing but will give you bind variables. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Binley Lim [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 9:10 PMTo: Multiple recipients of list ORACLE-LSubject: Re: suggestion Actually, you can capture SQLs relatively inexpensively by using FGA - simply add the "audit_condition = '1=1'" when adding a policy toeach table. For OLTP, this wouldn't make much sense. For ad-hoc (DSS), what you are going to do with all those captured SQLs is another story. - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 11:09 AM Subject: Re: suggestion For statistics, logon logofftriggers +v$mystat + autonomous transactions. If you want to capture all sql, it will be hard very resource hungry, you either enable trace for given session (which slows stuff down enormously) or poll v$sql or v$open_cursor frequently. This isn't a good idea either. You might want to look at fine grained auditing if you want to track which data is viewed by anybody. Tanel. - Original Message - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 1:39 AM Subject: suggestion hi there is a requirement for capturing sqls and cpu consumed by any session logging into the database . this info should be stored in the database. can you please give me suggestions as to how i do this? thanks sai 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: Hiding passwords
In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Patrice. -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Hiding passwords Jared, You said: "One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable." This is true. But to accomplish the same functionality, you can dynamically create a temporary .bat file that creates the environmental and then execute that bat file. Unfortunately on Windows, anything that you do can be repeated by someone else who logs onto the system. I guess you could secure a folder that only the Oracle account could see, and have these scripts placed in those folders so that the other users cannot get into them without rebooting the machine and bringing it up in DOS mode. That (I think) would prevent snooping. Not sure though. Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 6:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hiding passwordsPaul, Any chance these scripts could be run from Cygwin, Uwin, MKS Toolkit, or anything that will let you use a korn shell? That would simplify things tremendously. One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. That ability would make this task simple from command.com. Another possibility is to put your passwords in the registry, restrict that portion of the registry, ( or the whole thing ), and use a Perl script to retrieve the passwords and kick off the other jobs. What I do in linux is use a password server ( as seen in "Perl for Oracle DBA's") and retrieve the password across the network, encrypted of course. This works on windows as well, though you're there restricted to doing this strictly from within the Perl script. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 01:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwordsTom, As Dave Barry would say, Har! Unfortunately, we are talking about 3rd-party people who have the 'right' to log in for support (debugging their ^%(^#@ products, and installing updates). I've got them under local admin accounts (as opposed to domain accounts), so they can only get to their own servers. BUT... that's as far as I can go to secure things except at the folder level (and Oracle loves it (!) when you try and do folder security on the datafiles, controlfiles, etc.). I appreciate the thought, but you did not go far enough... Kill them all, and save on security hardware. Any workable ideas? Desperately yours,Paul R. ShermanDBA/Sr. Appl. AnalystBacou-Dallozoffice - 401-232-1200 x200cell - 401-935-2802 "Mercadante, Thomas F" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:Subject: RE: Hiding passwordsPaul, It's simple really. Do not allow them to log-on to the Win2k server - don't give them an account; keep the passwords secret; and keep the machine in a locked room. Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 23, 2003 4:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Hiding passwordsHello, If you do that in Win2k, then you have more env variables for 'authorized' people to see when they do a SET cr. Now, to be frank, I have an ulterior (a 'maxed-out' interior or exterior) motive in this reply. I have yet to see an intelligent (never mind elegant) of protecting system variables from someone's view when they do a SET in a DOS session. You can keep them out of Control Panel/System/Advanced/Environmental Variables, but you can't keep them out of DOS, so whaddya do? That's what I want to know. Has anyone confronted this issue and won? Thank you,Paul R. ShermanDBA/Sr. Appl.
RAC for download
Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks No banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com
RE: suggestion
How did you go about determining the tracefile name within the trigger? I don't think I've ever seen an example for this... -Original Message- Sent: Wednesday, September 24, 2003 8:05 AM To: Multiple recipients of list ORACLE-L hmmm... here is what I did ... change user_dump_dest to a file system which has lots of space, 100G in our case modify a logon trigger and for a certain group of people (based on a role) execute dbms_support.start_trace; Create a logoff trigger that raises a alert user_logoff and sends a trace file string (actual name of the trace file). I had a SQR report running on both sides of RAC waiting to respond to this alert. As soon as this alert came, it waited 1 second and then went to system and verified that it owned the trace file (based on the instance) and then gzipped it and based on the date moved to a directory. When we got tired of collecting trace files, we stopped the process. All of this is fairly easy to do, it took me about an hour to put this all together. If you just want sql text, you may want to use dbms_support.start_trace(false,true) .. it will avoid wait events listing but will give you bind variables. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, September 23, 2003 9:10 PM To: Multiple recipients of list ORACLE-L Actually, you can capture SQLs relatively inexpensively by using FGA - simply add the audit_condition = '1=1' when adding a policy to each table. For OLTP, this wouldn't make much sense. For ad-hoc (DSS), what you are going to do with all those captured SQLs is another story. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 11:09 AM For statistics, logon logoff triggers + v$mystat + autonomous transactions. If you want to capture all sql, it will be hard very resource hungry, you either enable trace for given session (which slows stuff down enormously) or poll v$sql or v$open_cursor frequently. This isn't a good idea either. You might want to look at fine grained auditing if you want to track which data is viewed by anybody. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 1:39 AM hi there is a requirement for capturing sqls and cpu consumed by any session logging into the database . this info should be stored in the database. can you please give me suggestions as to how i do this? thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] 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: shared server connections
Well, to successfully use connection pooling, you need connection manager. My information is that pooling by the instance is rather buggy and slow. Here is an excerpt from the oracle documentation: Oracle Connection Manager, an Oracle Net Services component, enables multiple client network sessions to be multiplexed, or funneled, through a single network connection to a database. The session multiplexing feature reduces the demand on resources needed to maintain multiple network sessions between two processes by enabling the server to use fewer network connection endpoints for incoming requests. This enables you to increase the total number of network sessions that a server can handle. With multiple Oracle Connection Managers, thousands of concurrent users can connect to a server. Figure 1-12 shows how session multiplexing can be used in a Web architecture. When Oracle Connection Manager is run on the same computer as an application Web server, the application Web server can route multiple client sessions through Oracle Connection Manager to ensure that those sessions have continuous access to an Oracle database server. This functionality is especially useful for Web applications where session availability and response time are major concerns. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 7:25 PM To: Multiple recipients of list ORACLE-L Subject: shared server connections Hello list, I am using 9.2.0.1.0 enterprise edition on windows. I have a database in shared server mode. Every time any one tries to use a shared server connection , I find that after the execution of any query the processor usage shoots up to 95-98%. I have two dispatchers configured , and whenever I specify pool=on , I see the following : As long as the shared server connection is maintained the processor usage remains high and the v$dispatcher_rate(CUR_LOOP_RATE) and v$dispatcher_rate( CUR_EVENT_RATE ) values for the concerned dispatcher go on increasing steadily even though there is only one user and he is sitting idle. If this user logs off, cpu usage falls down to normal. This happens with any user who tries to use a shared server connection. No such problem if a dedicated connection is used. If I restart the instance after setting pool=off then there is no such problem. Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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 patch to fix ORA-00000
ORA-00 is a normal, successful completion. I can give you some suggestions how to get ora-0001 or ora-0942. If I do my best, I can probably even successfully generate ora-01555. If you are not afraid of tinkering with the data dictionary, we can even generate some ora-00600 and ora-01578. I can assure you that you will never see normal, successful completion again on that database. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oracle DBA Sent: Tuesday, September 23, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Subject: Oracle patch to fix ORA-0 Hi List, Version= 8.1.7.3 OS: Sun Solaris Metalink suggested to apply the following patch set to avoid ORA-0 error after failover. Does anyone applied this patch set? Apply patch for bug 2618453. This is available on Metallink also. Do a simple search under New metalilnk patch search, and plug in #2618453. You will get to Description PLACEHOLDER FOR MERGE OF BUGS 2542693 2556273 (1643402 1650909) === Any feedback would be really appreciated. TIA Sami __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
Upgrade Plans
Would like to know where I can find some detailed plans on upgrading server, O/S, DB and applications to their new releases. Something like a TO DO list would be helpful. Any help will be greatly appreciated. Thanks much, Ken Janusz, CPIM
RE: how to check 32 or 64 bit?
Perhaps it is even simpler to describe V$session The first column SADDR is raw(8) on 64 bit and is raw(4) on 32 bit databases John -Original Message- Sent: 23 September 2003 22:25 To: Multiple recipients of list ORACLE-L Oracle DBA wrote: Also how to check whether my DB is 32 or 64 bit SQL SELECT dbms_utility.port_string FROM dual; PORT_STRING SVR4-be-64bit-8.1.0 SQL SELECT paddr FROM v$session WHERE rownum 2; PADDR 00038A57CA28 SQL connect ... Connected. SQL / PORT_STRING SVR4-be-8.1.0 SQL SELECT paddr FROM v$session WHERE rownum 2; PADDR 902B51D8 -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun 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: Hallas, John, Tech Dev 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: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to
Tanel,
Thanks ! Yes, your suggestion was the right fix. {I can't upgrade ALL the
clients
and remote databases to 9.2.0.3} I set event 10499.
I referred to Note 241355.1 and Bugs 2235818 and 2960493
and set 10499 at level 4 [although any non-zero value should suffice]
The Support Analyst had asked me to rerun catalog.sql and catproc.sql but
I referred back to the Note and Bugs when I closed the TAR.
Thanks again !
Hemant
At 01:39 PM 22-09-03 -0800, you wrote:
Hi!
Try to set event 10499 at level 1 in your remote server. Or upgrade the
client to at least 9.2.0.3.
You get more information from metalink when searching for this event in
metalink, it's about float scale representation change in 10i (which was
backported to 9.2.0.3).
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 6:34 PM
I face this peculiar behaviour when I connect from my 9.2.0.1/Tru64
database
to a 9.2.0.4/Solaris [upgraded from 9.2.0.1 to 9.2.0.2 to 9.2.0.4]
database
through a Database Link.
{I use the 9.2.0.1/Tru64 Database to monitor a number of other
8.0--9.2.0.2/NT-Solaris-Tru64
databases using the DBSNMP account, with some additonal custom views}
Here @HRDM is a DB-Link to the 9.2.0.4/Solaris Database :
When querying across a DB-Link I get no errors if the query is an SQL
query.
However, I get ORA-4052 and other errors when I put the query in a
PLSQL
block.
SQL :
SQL l
1 select count(*)
2 from [EMAIL PROTECTED] dtbs,
3 [EMAIL PROTECTED] ddfs
4 where dtbs.tablespace_name = ddfs.tablespace_name
5* and ddfs.status = 'AVAILABLE'
SQL /
COUNT(*)
--
7
SQL
PLSQL :
SQL get X1.sql
1 declare
2 cnt number;
3 begin
4 select count(*) into cnt
5 from [EMAIL PROTECTED] dtbs,
6 [EMAIL PROTECTED] ddfs
7 where dtbs.tablespace_name = ddfs.tablespace_name
8 and ddfs.status = 'AVAILABLE';
9 dbms_output.put_line('Cnt is '||cnt);
10* end;
SQL /
select count(*) into cnt
*
ERROR at line 4:
ORA-06550: line 4, column 1:
PL/SQL: ORA-04052: error occurred when looking up remote object
[EMAIL PROTECTED]
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and
126
ORA-06553: PLS-623: FLOAT precision constraint must be bet
ORA-06550: line 4, column 1:
PL/SQL: SQL Statement ignored
SQL
I've logged a Priority-2 TAR with Support currently but wonder if someone
else can reproduce this {I can reproduce it on the only 2 9.2.0.4
instances
I have,
both Solaris, connecting from the 9.2.0.1 instance}
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
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).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : 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
Re: Hiding passwords
- Original Message - In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Here is a little known trick of NTFS file systems. It's called data streams. D:\del file.txt D:\echo Some stuff file.txt D:\echo and its password file.txt:pwd D:\dir Volume in drive D is OS Volume Serial Number is A4BA-68F3 Directory of D:\ 24/09/2003 11:19p 13 file.txt (note the file size!) D:\type file.txt Some stuff D:\type file.txt:pwd The filename, directory name, or volume label syntax is incorrect. D:\more file.txt:pwd and its password D:\ I'm sure there are some interesting uses to be explored here to hide Oracle passwords! ;) Note: the hidden data stream name can be ANY filename string and is subject to security. This was used initially in NTFS to support the Mac resource fork file format in file servers. It is still there and won't go away any time soon as IIS uses it. MS Knowledge base article 105763 discusses this in detail. You can also search google for some details. Use alternate data streams. Careful: this is used by some virus writers!!! Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Upgrade Plans
http://metalink.oracle.com/metalink/plsql/ml2_gui.startup metalink top tech docs upgrade and migration KENNETH JANUSZ [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Upgrade Plans .com 09/24/2003 10:24 AM Please respond to ORACLE-L Would like to know where I can find some detailed plans on upgrading server, O/S, DB and applications to their new releases. Something like a TO DO list would be helpful. Any help will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan 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: maturing monitoring scheme
Some random thoughts, with examples 1) Tracks historical information to determine when a value is out of normal range or when a value has suddenly increased. ex. - SQL*Net messages consume 85-95% of wait time. If this value drops to 75% or rises to 99% alarm. - AR_DATA tablespace is at 90%, but has been there for 180 days. 2) Offers insight into possible root causes. ex. - SQL*Net message count has not changed, but average wait time has increased 25%. Possible network latency problem. - INVOICE_HEADER table has allocated 10 new extents in the past 5 days, which is 5000% above normal 3) Includes the latest proven optimization techniques ex. - Focuses on wait times and not ratios 4) Includes all events, even idle ones, so that the dba can decide what is and is not important. Daniel Josh Collier wrote: Greetings, What are the characteristics of a mature monitoring scheme? I am trying to tighten up the monitoring at my shop. What are the things and actions which a mature monitoring scheme watches and does? thanks, Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier 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). begin:vcard n:Fink;Daniel x-mozilla-html:FALSE org:Sun Microsystems, Inc. adr:;; version:2.1 title:Lead, Database Services x-mozilla-cpt:;9168 fn:Daniel W. Fink end:vcard
RE: RAC for download
Title: Message RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of quriyat Sent: Wednesday, September 24, 2003 10:05 AMTo: Multiple recipients of list ORACLE-LSubject: RAC for download Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks No banners. No pop-ups. No kidding.Introducing My Way - http://www.myway.com Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re: Upgrade Plans
Thanks Mike, but this won't work. I'm not a member of Metalink. Ken - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:44 AM http://metalink.oracle.com/metalink/plsql/ml2_gui.startup metalink top tech docs upgrade and migration KENNETH JANUSZ [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Upgrade Plans .com 09/24/2003 10:24 AM Please respond to ORACLE-L Would like to know where I can find some detailed plans on upgrading server, O/S, DB and applications to their new releases. Something like a TO DO list would be helpful. Any help will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan 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: KENNETH JANUSZ 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: RAC for download
If the question is about price [referring to oraclestore], remember that RAC is an option and is generally at a 50% premium on the EE cost. However, Mladen is right in that RAC is on the same CDs as the Enterprise Edition. If your servers are cluster-ready, the OUI automatically includes RAC as an installation option, else, RAC does not apear in the Oracle product list when you run the Installer. Hemant At 06:54 AM 24-09-03 -0800, you wrote: RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of quriyat Sent: Wednesday, September 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RAC for download Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : 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: Cary's book -- Out of stock !
I've never had any problem of any sort with a half dozen or so orders from bookpool.com. It looks like they're just out of stock, for which I'm partly to blame. :) I ordered mine on the morning of the 16th and received an e-mail the night of the 16th that it shipped. GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Prem Khanna J [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 12:40 AM To: Multiple recipients of list ORACLE-L Subject: Re:Cary's book -- Out of stock ! i placed my order at bookpool on 20-09-2003. ...anxiously waiting for my copy i wonder when i will have it in my hand ?!!! have anyone experienced any delay with bookpool ? hope it's better than Amazon, isn't it ? wolfgang,hope u misunderstood me. i asked Tom about the vendor he chose. thanx for the link anyway.let me go thro' chapter 1 online. Jp. 24-09-2003 14:14:45, Mladen Gogala [EMAIL PROTECTED] wrote: I believe this should answer your question: Barnes Noble.comYour Order Has Been Shipped Dear MLADEN GOGALA: Your order has been shipped, and the details appear below. Within 24 hours of receiving this email, you may track the delivery status of your order at http://www.dropshipexpress.com/tracking/tracking.asp?DCN=4200 66119102126 The book, which isn't available, according to Amazon, has been shipped by B N. It will probably be a big surprise, but my recommendation is definitely Barnes Noble. -- 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: suggestion
Title: RE: suggestion
this is the format instancename_ora_ospid.trc
perhaps this might help ...
SELECT c.VALUE || '/' || LOWER(INSTANCE) || '_ora_' ||
LTRIM(TO_CHAR(a.spid,'fm999')) || '.trc'
FROM v$process a, v$session b, v$parameter c, v$thread c
WHERE a.addr = b.paddr
AND b.audsid = USERENV('sessionid')
AND c.NAME = 'user_dump_dest'
/
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
From: Norris, Gregory T [ITS] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 24, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: suggestion
How did you go about determining the tracefile name within the trigger? I don't think I've ever seen an example for this...
-Original Message-
Sent: Wednesday, September 24, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L
hmmm... here is what I did ...
change user_dump_dest to a file system which has lots of space, 100G in our case
modify a logon trigger and for a certain group of people (based on a role) execute dbms_support.start_trace;
Create a logoff trigger that raises a alert user_logoff and sends a trace file string (actual name of the trace file).
I had a SQR report running on both sides of RAC waiting to respond to this alert.
As soon as this alert came, it waited 1 second and then went to system and verified that it owned the trace file (based on the instance) and then gzipped it and based on the date moved to a directory.
When we got tired of collecting trace files, we stopped the process. All of this is fairly easy to do, it took me about an hour to put this all together.
If you just want sql text, you may want to use dbms_support.start_trace(false,true) .. it will avoid wait events listing but will give you bind variables.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Tuesday, September 23, 2003 9:10 PM
To: Multiple recipients of list ORACLE-L
Actually, you can capture SQLs relatively inexpensively by using FGA - simply add the audit_condition = '1=1' when adding a policy to each table.
For OLTP, this wouldn't make much sense. For ad-hoc (DSS), what you are going to do with all those captured SQLs is another story.
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 24, 2003 11:09 AM
For statistics, logon logoff triggers + v$mystat + autonomous transactions.
If you want to capture all sql, it will be hard very resource hungry, you either enable trace for given session (which slows stuff down enormously) or poll v$sql or v$open_cursor frequently. This isn't a good idea either. You might want to look at fine grained auditing if you want to track which data is viewed by anybody.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 24, 2003 1:39 AM
hi
there is a requirement for capturing sqls and cpu consumed by any session logging into the database . this info should be stored in the database.
can you please give me suggestions as to how i do this?
thanks
sai
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Norris, Gregory T [ITS]
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).
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
Java for Alpha Linux
I'm looking for Java for Linux on an Alpha box. This really isn't OT because I need it in order to connect my Perl programs on the Alpha to Oracle via DBI/DBD::JDBC, which requires Java. I had downloaded it from www.compaq.com at one point, but it's gone from www.hp.com ( http://h18012.www1.hp.com/java/alpha/ ), ftp.alphalinux.org doesn't seem to be available anymore and I don't think it's ever been on http://java.sun.com Anyone? I'll trade a nice home build of Mozilla Firebird 0.6 for Alpha Linux (RH 7.2) for a 1.3.1 SDK/JDK for Alpha Linux! TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- 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: maturing monitoring scheme
Josh One idea for you to consider. Buy the book Oracle9i High-Performance Tuning with STATSPACK by Don Burleson. His book is chock full of ideas about overall database monitoring, regardless of whether you decide to use STATSPACK or not. As an example, he points out that the database sits atop a computer system and you can be deceived if you only look at the database. You must monitor the system itself and then review the Oracle statistics in light of what was going on with the system. He provides lots of ideas of what you can monitor on the system. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 24, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Some random thoughts, with examples 1) Tracks historical information to determine when a value is out of normal range or when a value has suddenly increased. ex. - SQL*Net messages consume 85-95% of wait time. If this value drops to 75% or rises to 99% alarm. - AR_DATA tablespace is at 90%, but has been there for 180 days. 2) Offers insight into possible root causes. ex. - SQL*Net message count has not changed, but average wait time has increased 25%. Possible network latency problem. - INVOICE_HEADER table has allocated 10 new extents in the past 5 days, which is 5000% above normal 3) Includes the latest proven optimization techniques ex. - Focuses on wait times and not ratios 4) Includes all events, even idle ones, so that the dba can decide what is and is not important. Daniel Josh Collier wrote: Greetings, What are the characteristics of a mature monitoring scheme? I am trying to tighten up the monitoring at my shop. What are the things and actions which a mature monitoring scheme watches and does? thanks, Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier 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: 10g: SQL Plus
Losing the pseudo-GUI version would be a a drag, because it's so easy to copy and paste text in it (not so easy in a Windows command prompt). Try right click - paste or click the upper left icon and choose paste To copy - choose mark then enter -its then in the clipboard Ive actually began to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: download metalink articles - save target as
The grueling method is... grab the header, copy paste it into notepad.exe. That strips the weird formatting out of it. Grab the body text, but not all the way down, try to guess where the body text frame ends and stop just before that. It may take a few tries to find exactly where. copy paste into Wordpad.exe. Hehehe.. amazing what we have to go through. An easier method I use it to view source - then chop out any erroneous html and save as mydoc.html Then you can view the html and copy out nicely... That's my workaround bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: Upgrade Plans
You want to start an extensive product like switching to the new version and platform without support? Have you ever heard of the word kamikaze? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of KENNETH JANUSZ Sent: Wednesday, September 24, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: Re: Upgrade Plans Thanks Mike, but this won't work. I'm not a member of Metalink. Ken - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 9:44 AM http://metalink.oracle.com/metalink/plsql/ml2_gui.startup metalink top tech docs upgrade and migration KENNETH JANUSZ [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Upgrade Plans .com 09/24/2003 10:24 AM Please respond to ORACLE-L Would like to know where I can find some detailed plans on upgrading server, O/S, DB and applications to their new releases. Something like a TO DO list would be helpful. Any help will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan 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: KENNETH JANUSZ 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: OFA and Shared Storage
EMC storage is very reliable, no question. However, I have personally seen terrible SAN disasters on many vendors' SANs, but most of them on EMC (since I worked for them). Without going into specifics, the SAN problems I've seen were caused by (in rough order): 1) human error - changing SANs tends to be a heavily manual operations, with a huge margin for error. Plus the portion of the IT population that understands the care and feeding of SANs is negligible. 2) Firmware bugs in hardware - there have been some truly horrific firmware bugs in storage equipment, especially fibre channel switches. 3) Operating system/driver bugs - there's a lot of crummy code out there in general, I suppose As an aside, this is also almost the identical list that I have for the major reasons I've seen organizations instantiate Disaster Recovery procedures - an actual disaster is almost never the reason. The moral of the story is, while YMMV, I would always keep copies of truly critical things like redo logs, control files, etc. elsewhere, ideally on something completely disparate. Of course, the more disparate the something is, the harder it is to manage and while less prone to hardware error, is more prone to human error. So maybe the moral of the story is that you can't win? :) Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mercadante, Thomas F Sent: Tuesday, September 23, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: OFA and Shared Storage except that in the 5 years I have been using EMC SAN, we have *never* experienced an outage. never had to perform a recovery because of SAN errors. never anything. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, September 22, 2003 6:05 PM To: Multiple recipients of list ORACLE-L EMC SAN disk has such an incredible uptime, that worrying about losing things like control files are (almost) a thing of the past. Uptime is only one thing, there are several other errors that might occur, like IO controller errors, memory/CPU glitches and file system corruptions like Matthew already said.. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Mercadante, Thomas F 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: Matthew Zito 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).
Multiple block sizes
Title: Message Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: 10g: SQL Plus
Ive actually began to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell And it can be minimized or moved out of the way while a query is active. -- This post may contain anti-SCO content sponsored secretly by IBM. Ssh! Don't tell anyone! Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] 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: Java for Alpha Linux
Have you tried jikes? That is IBM implementation of Java2 platform which was not checked by SUN, so it can't use name Java. It is the result of the same dispute that caused MS to stop supporting Java. Allegedly, jikes is much better software then the original sun's JDK. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jesse, Rich Sent: Wednesday, September 24, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: Java for Alpha Linux I'm looking for Java for Linux on an Alpha box. This really isn't OT because I need it in order to connect my Perl programs on the Alpha to Oracle via DBI/DBD::JDBC, which requires Java. I had downloaded it from www.compaq.com at one point, but it's gone from www.hp.com ( http://h18012.www1.hp.com/java/alpha/ ), ftp.alphalinux.org doesn't seem to be available anymore and I don't think it's ever been on http://java.sun.com Anyone? I'll trade a nice home build of Mozilla Firebird 0.6 for Alpha Linux (RH 7.2) for a 1.3.1 SDK/JDK for Alpha Linux! TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: 10g: SQL Plus
Will they have UFI in 10g? I'm sort of nostalgic. I cannot install my 3 360k 5.25 floppies with oracle 4.1 on any PC. How about oralink? Remarkably, it all used to run in 512k of RAM, which is less then the L3 cache size on any decent P4 system. How many hundreds of megabytes of RAM will I need for 10g? Don't tell me that RAM is cheap. EDO capable SDRAM for PCI/233 is NOT cheap. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Metelsky Sent: Wednesday, September 24, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: 10g: SQL Plus Losing the pseudo-GUI version would be a a drag, because it's so easy to copy and paste text in it (not so easy in a Windows command prompt). Try right click - paste or click the upper left icon and choose paste To copy - choose mark then enter -its then in the clipboard Ive actually began to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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[2]: 10g: SQL Plus
Wednesday, September 24, 2003, 11:44:44 AM, you wrote: BM Ive actually began to like sqlplus (opposed to sqlplusw). One good BM feature is you have your command history using the up arrow like regular BM shell Scrolling back to see what you've done is a bit more problematic, though you can configure a DOS window to retain some history. You have to think to configure it first though. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Multiple block sizes
Title: Message Dont have experience with that. But, dont forget to configure memory subcaches for multiple block sizes (along with specifying new block size for the tablespace). Check Oracle 9i New Features by R.Freeman (p.13). Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: Wednesday, September 24, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Subject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: Upgrade Plans
Ken Having gone through this numerous times, I don't think there is such a thing as a detailed plan that has any use beyond the immediate task. I would concentrate first of all on your philosophical approach, the principles on which you work. Here are some ideas: - Create a staging/QA server for each production server that is identical as possible to production. I like to create the Oracle database from backups so I get a chance to verify my backups at the same time. - Have a complete set of data for the staging database. I've seen several problems that were not replicated with only a portion of the data. - Perform the exact steps in staging that you will be performing in production and take careful notes. Repeat if any problems are encountered. - Always have a backout plan for any production action. I find a lot of comfort in a cold backup of the entire system. - As much as possible, change only one component at a time. That is, only upgrade the O.S., give the system a few weeks to shake out, then upgrade the DB, and so on. Then when a strange problem arises you know which vendor to go to first. - Stick to versions certified by the vendors. Only use an Oracle version certified for that version of the O.S. and application. - Decide your approach to applying patches. Typically patches are tested much less thoroughly than overall releases. So some sites only apply patches if they are experiencing problems the patch will fix. Other sites believe in applying all patches as soon as they are released. - Then there will be a bunch of steps related to your specific situation. All I know is to get as many people involved as possible to minimize the chance that something is overlooked. And if something does get overlooked, people won't get nearly as upset if you kept them in the loop so they had a chance to raise issues as if you left them out. - Promise the users that the downtime will be more than you expect. Better to underpromise and overperform. -Original Message- Sent: Wednesday, September 24, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Would like to know where I can find some detailed plans on upgrading server, O/S, DB and applications to their new releases. Something like a TO DO list would be helpful. Any help will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- 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: Re[2]: 10g: SQL Plus
Hi! Press F7 in windows command line sqlplus to see history of your sql commands (it's actually cmd.exe feature). And particularily nice feature is that you can search the F7 history list, by pressing the first letter of a command - you'll be navigate to alter command for example if you press a in history list, one more a will navigate to previous command starting with a. Pressing enter will execute the command again, pressing right arrow will just put the command to prompt where you can edit it before executing. This is one of the reasons why I'm staying on windows with my desktop :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 7:29 PM Wednesday, September 24, 2003, 11:44:44 AM, you wrote: BM Ive actually began to like sqlplus (opposed to sqlplusw). One good BM feature is you have your command history using the up arrow like regular BM shell Scrolling back to see what you've done is a bit more problematic, though you can configure a DOS window to retain some history. You have to think to configure it first though. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Tanel Poder 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: IBM AIX 32-Bit
I think 64 bit application have to run on a 64 bit hardware. but can be booted as 32 bit mode. That at least apply to oracle 9i version. Joan -- 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: Multiple block sizes
Title: Message That part is done. Thanks. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor NeymanSent: Wednesday, September 24, 2003 12:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes Dont have experience with that. But, dont forget to configure memory subcaches for multiple block sizes (along with specifying new block size for the tablespace). Check Oracle 9i New Features by R.Freeman (p.13). Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen GogalaSent: Wednesday, September 24, 2003 11:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
how to generate unique file names on Windows.
Hello, I am trying to write a script on windows that would export the db every night. Can someone tell me how to generate unique file names on windows... What I am looking for is the windows equivalent of echo `date +%m%d%y` Thanks in advance. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[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: Multiple block sizes
Title: Message I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but youcanthink about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
Re: RAC for download
I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale wrote: If the question is about price [referring to oraclestore], remember that RAC is an option and is generally at a 50% premium on the EE cost. However, Mladen is right in that RAC is on the same CDs as the Enterprise Edition. If your servers are cluster-ready, the OUI automatically includes RAC as an installation option, else, RAC does not apear in the Oracle product list when you run the Installer. Hemant At 06:54 AM 24-09-03 -0800, you wrote: RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of quriyat Sent: Wednesday, September 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RAC for download Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com 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). -- 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: 10g: SQL Plus
Well, we have a good, working 5.25 floppy drive installed on our Oracle Museum PC (486, 25 MHz) now, and we're planning on installing WordPerfect 4.2, Lotus 1-2-3 (with the plug-in for Oracle, which Cary will bring over for the Database Forum next week), and other goodies. We have 5.1 running, and it's very, very fast to start up. Oh, and exports from 5.1 are fine to import in 9i. We haven't tested 10g yet. We're showcasing this wonder - and the rest of the Oracle Museum for which some of you have so generously helped - at the 10g launch days next week here in Denmark. Now, Mladen, would it be possible somehow to get hold of eg a zip of those 4.1 floppies? We have of course ordered another 486 PC, and we intend to give it all of 4 MB of RAM like the other one. The guy that sells all these things has a shop called Dinotech, and he still has about 9 new 5.25 drives from way back then. He'll sell for about 100 kroner each. We paid 200 kroner for the IBM DOS 5 in its original wrap. Mogens Mladen Gogala wrote: Will they have UFI in 10g? I'm sort of nostalgic. I cannot install my 3 360k 5.25 floppies with oracle 4.1 on any PC. How about oralink? Remarkably, it all used to run in 512k of RAM, which is less then the L3 cache size on any decent P4 system. How many hundreds of megabytes of RAM will I need for 10g? Don't tell me that RAM is cheap. EDO capable SDRAM for PCI/233 is NOT cheap. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Metelsky Sent: Wednesday, September 24, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: 10g: SQL Plus Losing the pseudo-GUI version would be a a drag, because it's so easy to copy and paste text in it (not so easy in a Windows command prompt). Try right click - paste or click the upper left icon and choose paste To copy - choose mark then enter -its then in the clipboard Ive actually began to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- 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: Tuning help required
In addition to the excellent advice you have already received,
let me congratulate you on taking the time to format your
code and trace data so that it is readable.
There are folks that are known to skip long posts such as
this when poorly formatted and difficult to read. ;)
Jared
New DBA [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/24/2003 12:39 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Tuning help required
Hi All,
I need help in tuning the following query. It takes around 6-7 minutes to run. I hope that someone will be able to go through the details and give me a few pointers.
I have gathered a few statistics, but don't know where to go from here.
Please view the mail in a fixed size font e.g. courier to preserve the formatting. If the lines wrap over copying and pasting in a text editor might help, though I'm not sure.
I apologize for the long message in advance.
Following is the query:
SELECT UNIQUE
MEPAI.MPAI_NAV_MOD ,
MEPAI.MPAI_NAV_MODS,
MEPAI.MPAI_SYS_NO,
MEPAI.MPAI_PAI_SYS_NO,
MEPAI.MPAI_AS_OF_DATE,
PRODUCTS.ISS_INSTR_ID PRODUCT_INSTR_ID,
CUR.CUR_CURRENCY_NAME,
CUR.CUR_CURRENCY_CODE,
CUR.CUR_SYS_NO
FROM
EPR_CURRENCIESCUR,
EPR_GEOGRAPHIESGEO,
EPR_PRODUCTS PRODUCTS,
MOD_EPR_PRICING_ASSET_INFO MEPAI
WHERE MEPAI.MPAI_ISS_SYS_NO = PRODUCTS.ISS_SYS_NO
AND MEPAI.MPAI_GEO_SYS_NO = GEO.GEO_SYS_NO
AND MEPAI.MPAI_CUR_SYS_NO = CUR.CUR_SYS_NO
AND MEPAI.MPAI_AS_OF_DATE IN
(
to_date('03/01/2003','MM/DD/'), to_date('03/02/2003','MM/DD/')
, to_date('03/03/2003','MM/DD/'), to_date('03/04/2003','MM/DD/')
, to_date('03/05/2003','MM/DD/'), to_date('03/06/2003','MM/DD/')
, to_date('03/07/2003','MM/DD/'), to_date('03/08/2003','MM/DD/')
, to_date('03/09/2003','MM/DD/'), to_date('03/10/2003','MM/DD/')
, to_date('03/11/2003','MM/DD/'), to_date('03/12/2003','MM/DD/')
, to_date('03/13/2003','MM/DD/'), to_date('03/14/2003','MM/DD/')
, to_date('03/15/2003','MM/DD/'), to_date('03/16/2003','MM/DD/')
, to_date('03/17/2003','MM/DD/'), to_date('03/18/2003','MM/DD/')
! ;, to_date('03/19/2003','MM/DD/'), to_date('03/20/2003','MM/DD/')
, to_date('03/21/2003','MM/DD/'), to_date('03/22/2003','MM/DD/')
, to_date('03/23/2003','MM/DD/'), to_date('03/24/2003','MM/DD/')
, to_date('03/25/2003','MM/DD/'), to_date('03/26/2003','MM/DD/')
, to_date('03/27/2003','MM/DD/'), to_date('03/28/2003','MM/DD/')
, to_date('03/29/2003','MM/DD/'), to_date('03/30/2003','MM/DD/')
, to_date('03/31/2003','MM/DD/')
)
AND PRODUCTS.ISS_INSTR_ID in (1321,1339,1344,1342,1343,1341,1340)
AND CUR.CUR_SYS_NO in (200,226)
Order By MEPAI.MPAI_SYS_NO
Execution Plan
--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=515 Card=122 Bytes=8296)
1 0 SORT (UNIQUE) (Cost=503 Card=122 Bytes=8296)
2 1 CONCATENATION
3 2NESTED LOOPS (Cost=223 Card=61 Bytes=4148)
4 3 HASH JOIN (Cost=223 Card=61 Bytes=3965)
5 4 INLIST ITERATOR
6 5 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_PRODUCTS' (Cost=3 Card=16 Bytes=128)
7 6INDEX (RANGE SCAN) OF 'ISS_ISS_INSTR_ID' (NON-UNIQUE) (Cost=2 Card=16)
8 4 NESTED LOOPS (Cost=219 Card=4415 Bytes=251655)
9 8 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_CURRENCIES' (Cost=1 Card=1 Bytes=21)
10 9INDEX (UNIQUE SCAN) OF 'CUR_PK' (UNIQUE)
11 8 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'MOD_EPR_PRICING_ASSET_INFO' (Cost=218 Card=92720 Bytes=3337920)
12 11INDEX (RANGE SCAN) OF 'MPAI_CUR_FK_I' (NON-UNIQUE) (Cost=217 Card=92720)
13 3 INDEX (UNIQUE SCAN) OF 'GEO_PK' (UNIQUE)
14 2NESTED LOOPS (Cost=223 Card=61 Bytes=4148)
15 14 HASH JOIN (Cost=223 Card=61 Bytes=3965)
16 15 INLIST ITERATOR
17 16 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_PRODUCTS' (Cost=3 Card=16 Bytes=128)
18 17INDEX (RANGE SCAN) OF 'ISS_ISS_INSTR_ID' (NON-UNIQUE) (Cost=2 Card=16)
19 15 NESTED LOOPS (Cost=219 Card=4415 Bytes=251655)
20 19 TABLE ACCESS (BY INDEX ROWID) OF 'EPR_CURRENCIES' (Cost=1 Card=1 Bytes=21)
21 20INDEX (UNIQUE SCAN) OF 'CUR_PK' (UNIQUE)
22 19 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'MOD_EPR_PRICING_ASSET_INFO' (Cost=218 Card=92720 Bytes=3337920)
23 22INDEX (RANGE SCAN) OF 'MPAI_CUR_FK_I' (NON-UNIQUE) (Cost=217 Card=92720)
24 14 INDEX (UNIQUE SCAN) OF 'GEO_PK' (UNIQUE)
The output of the following query before running the SQL and after running the SQL are as follows:
SQL select names.name, stats.value
2 from v$session sessions, v$sesstat stats, v$statname names
3 where stats.statistic# = names.statistic#
4 and stats.sid = sessions.sid
5 and sessions.audsid = userenv('SESSIONID')
6 and value != 0
7 order by value desc;
Before running the problem query:
RE: Apps 11.5.8 and 9i
My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i =) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into Program Files It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows. Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has changed since 10.7 all the way around. Oh, and you will need mks toolkit and Visual C++ compiler (not .net though) and java... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L 22 CDs huh? Any one know where to get free trial software for Apps? Anyone want to burn me 22 CDs? Just kidding... I haven't work with Financials since 10.7 and feel like I am rapidly losing my financials skills. I want to set this up at home. I figure I would use it for my personal accounting (I know overkill) but I need SOME reason to use it. It looks like I can order this from the Oracle store for a nominal price, however, I need some help in figuring out what to order. Based on the URL: http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=1153 6 http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11536 , Here are the things I think I require: Oracle 9i Database (9.2.0.1) CD Pack for MS Windows $0 (downloaded this software previously) $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows $13.93 Oracle Applications 11i Release 9 Update CD Pack for MS windows And probably one of (but which one?): - Oracle 9i Application Server, Release 2 (9.2.0.1) CD Pack for MS Windows - Oracle 9i Application Server, Version 1.0.2.2.2a CD Pack for MS Windows Does this look right or are there other components I will also need? Thanks in Advance - Babette Also at home at: [EMAIL PROTECTED] The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Hiding passwords
Yes, I could to that, but I won't. I really don' like writing passwords out to a temp file. Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 05:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwords Jared, You said: One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. This is true. But to accomplish the same functionality, you can dynamically create a temporary .bat file that creates the environmental and then execute that bat file. Unfortunately on Windows, anything that you do can be repeated by someone else who logs onto the system. I guess you could secure a folder that only the Oracle account could see, and have these scripts placed in those folders so that the other users cannot get into them without rebooting the machine and bringing it up in DOS mode. That (I think) would prevent snooping. Not sure though. Tom Mercadante Oracle Certified Professional -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 6:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Hiding passwords Paul, Any chance these scripts could be run from Cygwin, Uwin, MKS Toolkit, or anything that will let you use a korn shell? That would simplify things tremendously. One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. That ability would make this task simple from command.com. Another possibility is to put your passwords in the registry, restrict that portion of the registry, ( or the whole thing ), and use a Perl script to retrieve the passwords and kick off the other jobs. What I do in linux is use a password server ( as seen in Perl for Oracle DBA's) and retrieve the password across the network, encrypted of course. This works on windows as well, though you're there restricted to doing this strictly from within the Perl script. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 01:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwords Tom, As Dave Barry would say, Har! Unfortunately, we are talking about 3rd-party people who have the 'right' to log in for support (debugging their ^%(^#@ products, and installing updates). I've got them under local admin accounts (as opposed to domain accounts), so they can only get to their own servers. BUT... that's as far as I can go to secure things except at the folder level (and Oracle loves it (!) when you try and do folder security on the datafiles, controlfiles, etc.). I appreciate the thought, but you did not go far enough... Kill them all, and save on security hardware. Any workable ideas? Desperately yours, Paul R. Sherman DBA/Sr. Appl. Analyst Bacou-Dalloz office - 401-232-1200 x200 cell - 401-935-2802 Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwords Paul, It's simple really. Do not allow them to log-on to the Win2k server - don't give them an account; keep the passwords secret; and keep the machine in a locked room. Tom Mercadante Oracle Certified Professional -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Hiding passwords Hello, If you do that in Win2k, then you have more env variables for 'authorized' people to see when they do a SET cr. Now, to be frank, I have an ulterior (a 'maxed-out' interior or exterior) motive in this reply. I have yet to see an intelligent (never mind elegant) of protecting system variables from someone's view when they do a SET in a DOS session. You can keep them out of Control Panel/System/Advanced/Environmental Variables, but you can't keep them out of DOS, so whaddya do? That's what I want to know. Has anyone confronted this issue and won? Thank you, Paul R. Sherman DBA/Sr. Appl. Analyst Bacou-Dalloz office - 401-232-1200 x200 cell - 401-935-2802 M.Godlewski [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 02:15 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Hiding passwords You could set up environment variables and then reference the environment variable in your script. HTH M. [EMAIL PROTECTED] wrote: There is a good discussion in asktom website on this topic. Here is the link :
RE: Hiding passwords
Yes, I could do that, but I won't. It's fraught with security problems. Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwords Jared, Not saying this is elegant or does the same thing yet but couldn't you do something like this: C:\Tempcopy con: pwd.txt orcl tiger !my Orcl instance ^Z 1 file(s) copied. C:\Temptype pwd.txt orcl tiger !my Orcl instance C:\Tempget_pwd Instance is [orcl] pwd is [tiger] C:\Temp C:\Temptype get_pwd.bat @ECHO OFF FOR /F tokens=1-2 delims= eol=! %%i IN (pwd.txt) DO call :get_pwd %%i %%j GOTO :end :get_pwd (SET theinst=%1) (SET thepwd=%2) ECHO Instance is [%theinst%] ECHO pwd is [%thepwd%] :end (SET theinst=) (SET thepwd=) C:\Temp Enhance the batch to take some parameters and enhance get_pwd subroutine to search for that which matches the parameters. Anyway hope this is of use to some. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 24 September 2003 9:45 AM there is no command.com equivalent for this: MY_PASSWORD=$(pwc.pl -instance dv01 -username scott) Simple in ksh, impossible in un-enhanced Windohs. That previous bit is something I use in several cron jobs for retrieving passwords, as well as command line logins to several databases as many different users. To do this in Windohs, you must embed the entire job in Perl. HTH Jared -- Wolfgang Breitling [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 03:29 PM I don't quite get that. Why can't you set a local environment variable from a script? If you could, where do you propose to get the value that you want to put into an environment variable? At 01:59 PM 9/23/2003 -0800, you wrote: Paul, Any chance these scripts could be run from Cygwin, Uwin, MKS Toolkit, or anything that will let you use a korn shell? That would simplify things tremendously. One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. That ability would make this task simple from command.com. Another possibility is to put your passwords in the registry, restrict that portion of the registry, ( or the whole thing ), and use a Perl script to retrieve the passwords and kick off the other jobs. What I do in linux is use a password server ( as seen in Perl for Oracle DBA's) and retrieve the password across the network, encrypted of course. This works on windows as well, though you're there restricted to doing this strictly from within the Perl script. Jared Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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: Hiding passwords
Thanks, this bears investigating. Nuno Souto [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 07:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Hiding passwords - Original Message - In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Here is a little known trick of NTFS file systems. It's called data streams. D:\del file.txt D:\echo Some stuff file.txt D:\echo and its password file.txt:pwd D:\dir Volume in drive D is OS Volume Serial Number is A4BA-68F3 Directory of D:\ 24/09/2003 11:19p 13 file.txt (note the file size!) D:\type file.txt Some stuff D:\type file.txt:pwd The filename, directory name, or volume label syntax is incorrect. D:\more file.txt:pwd and its password D:\ I'm sure there are some interesting uses to be explored here to hide Oracle passwords! ;) Note: the hidden data stream name can be ANY filename string and is subject to security. This was used initially in NTFS to support the Mac resource fork file format in file servers. It is still there and won't go away any time soon as IIS uses it. MS Knowledge base article 105763 discusses this in detail. You can also search google for some details. Use alternate data streams. Careful: this is used by some virus writers!!! Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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 generate unique file names on Windows.
for /F tokens=2,3,4 delims=/ %I in ('date /t') do @set today=%K-%I-%J
example:
c:\date /t
Wed 09/24/2003
c:\for /F tokens=2,3,4 delims=/ %I in ('date /t') do @set today=%K-%I-%J
c:\echo %TODAY%
2003-09-24
c:\
At 09:44 AM 9/24/2003 -0800, you wrote:
Hello,
I am trying to write a script on windows that would export the db every
night. Can someone tell me how to generate unique file names on windows...
What I am looking for is the windows equivalent of echo `date +%m%d%y`
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/[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).
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
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: Apps 11.5.8 and 9i
on Windows... the product is supposed to INSTALL without MKS, but once you get it installed you can't run a bunch of the utilities. C++, I believe, is required to be there for the install. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 1:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9iMy question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i=) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into "Program Files" It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows. Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has changed since 10.7 all the way around. Oh, and you will need mks toolkit and Visual C++ compiler (not .net though) and java... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \\ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L 22 CDs huh? Any one know where to get free trial software for Apps? Anyone want to burn me 22 CDs? Just kidding... I haven't work with Financials since 10.7 and feel like I am rapidly losing my financials skills. I want to set this up at home. I figure I would use it for my personal accounting (I know overkill) but I need SOME reason to use it. It looks like I can order this from the Oracle store for a nominal price, however, I need some help in figuring out what to order. Based on the URL: http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=1153 6 http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11536 , Here are the things I think I require: Oracle 9i Database (9.2.0.1) CD Pack for MS Windows $0 (downloaded this software previously) $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows $13.93 Oracle Applications 11i Release 9 Update CD Pack for MS windows And probably one of (but which one?): - Oracle 9i Application Server, Release 2 (9.2.0.1) CD Pack for MS Windows - Oracle 9i Application Server, Version 1.0.2.2.2a CD Pack for MS Windows Does this look right or are there other components I will also need? Thanks in Advance - Babette Also at home at: [EMAIL PROTECTED] The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain
RE: URGENT REPORTS
Title: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: Hiding passwords
Apparently my Windoze Command scripting skills are woefully inadequate.
The past several years have been ksh heavy and windoze shell poor, not
that I regret this in any way. :)
Thanks Wolfgang, I'll have to play with this.
Jared
Wolfgang Breitling [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/23/2003 06:44 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Hiding passwords
How about:
setlocal pushd
@echo off
call oraenv stats
@for /f %%I in ('pwc.pl') do (
set MY_PASSWORD=%%I
)
@sqlplus scott/%MY_PASSWORD% @test.sql
popd endlocal
I don't have the password server configured, so my pwc.pl simply is
hardcoded to return tiger:
#!c:\perl\bin\perl.exe -w
print tiger;
and test.sql is just select user from dual;
C:\tmptest
C:\tmpsetlocal pushd
Environment variable oracle_home not defined
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Sep 23 18:32:24 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
scott September 23, 2003
define (hex 26)
USER
--
SCOTT
1 row selected.
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
With the Partitioning option
JServer Release 8.1.7.4.1 - Production
C:\tmp
granted, it is not quite as elegant as MY_PASSWORD=$(pwc.pl ... but it
gets the job done.
And it does not work in Windows (95/98) Dos, but in NT and W2K, which you
need to run Oracle server anyways.
At 03:44 PM 9/23/2003 -0800, you wrote:
there is no command.com equivalent for this: MY_PASSWORD=$(pwc.pl
-instance dv01 -username scott)
Simple in ksh, impossible in un-enhanced Windohs.
That previous bit is something I use in several cron jobs for retrieving
passwords,
as well as command line logins to several databases as many different users.
To do this in Windohs, you must embed the entire job in Perl.
HTH
Jared
Wolfgang Breitling [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/23/2003 03:29 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Hiding passwords
I don't quite get that. Why can't you set a local environment variable from
a script? If you could, where do you propose to get the value that you want
to put into an environment variable?
At 01:59 PM 9/23/2003 -0800, you wrote:
Paul,
Any chance these scripts could be run from Cygwin, Uwin, MKS Toolkit,
or anything that will let you use a korn shell?
That would simplify things tremendously.
One of the problems with Windohs is that you cannot execute a script
or program so that it can return a value to a local environment variable.
That ability would make this task simple from command.com.
Another possibility is to put your passwords in the registry, restrict that
portion of the registry, ( or the whole thing ), and use a Perl script to
retrieve
the passwords and kick off the other jobs.
What I do in linux is use a password server ( as seen in Perl for Oracle
DBA's)
and retrieve the password across the network, encrypted of course.
This works on windows as well, though you're there restricted to doing this
strictly from within the Perl script.
Jared
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
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: Apps 11.5.8 and 9i
Title: Message Yep, on Windows platforms -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9iMy question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i=) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into "Program Files" It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows. Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has changed since 10.7 all the way around. Oh, and you will need mks toolkit and Visual C++ compiler (not .net though) and java... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \\ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L 22 CDs huh? Any one know where to get free trial software for Apps? Anyone want to burn me 22 CDs? Just kidding... I haven't work with Financials since 10.7 and feel like I am rapidly losing my financials skills. I want to set this up at home. I figure I would use it for my personal accounting (I know overkill) but I need SOME reason to use it. It looks like I can order this from the Oracle store for a nominal price, however, I need some help in figuring out what to order. Based on the URL: http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=1153 6 http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11536 , Here are the things I think I require: Oracle 9i Database (9.2.0.1) CD Pack for MS Windows $0 (downloaded this software previously) $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows $13.93 Oracle Applications 11i Release 9 Update CD Pack for MS windows And probably one of (but which one?): - Oracle 9i Application Server, Release 2 (9.2.0.1) CD Pack for MS Windows - Oracle 9i Application Server, Version 1.0.2.2.2a CD Pack for MS Windows Does this look right or are there other components I will also need? Thanks in Advance - Babette Also at home at: [EMAIL PROTECTED] The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in
RE: Apps 11.5.8 and 9i
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
RE: Oracle8i, Failsafe and patchset 12
Yes I posted the wrong link. Now I can't recall where I saw this info, and cannot find it. Though SP4 on Win2k is supposed to cause some serious network latencies. I will post the info if I come across it again. Jared Tim Onions [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 02:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle8i, Failsafe and patchset 12 Jared The URL refers to an alert for NT 4.0, Patrice is talking about Windows 2000 (which is also the MS flavour I'm having problems on), am I being blind here but those are 2 different products? If there is a similar alert for Windows2000 I'd certainly like to hear about it. If anybody is interested in the original Failsafe issue then I can tell you that this morning Oracle have acknowledged it as being a bug (failsafe is looking for Oracle9 libraries!). Fix is being worked on. T¬ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 23 September 2003 18:45 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle8i, Failsafe and patchset 12 You would be well advised to *not* install SP4. It will destroy network performance. Supposedly this can be corrected: http://tinyurl.com/odlw or http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q249/7/99.aspNoWebContent=1 Jared Boivin, Patrice J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 06:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle8i, Failsafe and patchset 12 The latest service pack for Win2K is SP4. Patrice. -Original Message- From: Tim Onions [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 9:55 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle8i, Failsafe and patchset 12 Good question, it's an Oracle8i patchset not a Windows one. _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: 23 September 2003 12:50 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: Oracle8i, Failsafe and patchset 12 Tim, Just curious - is Patchset 12 for Windows 2000, or for Oracle? Sorry if it's a dumb question, but I am lost in the context. thanks! Tom Mercadante Oracle Certified Professional -Original Message- From: Tim Onions [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 8:40 AM To: Multiple recipients of list ORACLE-L Subject: Oracle8i, Failsafe and patchset 12 To anybody using Oracle8i and failsafe, After implementing 8.1.7.4 patchset 12 on my Windows 2000 adv server failsafe configuration failsafe (and MS Cluster administrator) stopped being able to control the Oracle service (it can stop it but not start it again - saying things like file not found!). All the due diligence exercises have been done and I am convinced the patching was no flawed on my part. I suspect a bug in the patch set and Oracle support are indicating that others may be having the same problem. My database runs fine but has had to be removed from failsafe. So two things: 1 - if you are using failsafe and Oracle8i think very carefully before applying patch set 12 2 - if you have applied patch set 12 either successfully or unsuccessfully with failsafe I'd love to hear from you so I can either put pressure on Oracle for a fix or share some thoughts on what is going on. Many thanks T¬
RE: how to generate unique file names on Windows.
You can use sqlplus to generate the script for you. -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:45 PM To: Multiple recipients of list ORACLE-L Hello, I am trying to write a script on windows that would export the db every night. Can someone tell me how to generate unique file names on windows... What I am looking for is the windows equivalent of echo `date +%m%d%y` Thanks in advance. Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[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: Khedr, Waleed 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: Apps 11.5.8 and 9i
They are required for installation and running 11i successfully on windows. As someone mentioned here, if relinking is needed for example. Also some concurrent jobs interacting with OS might be using MKS. IIRC, you can't even pass prerequisite checking part in installation process if you're missing those. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 9:49 PM Subject: RE: Apps 11.5.8 and 9i My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i=) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into "Program Files" It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows. Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has changed since 10.7 all the way around. Oh, and you will need mks toolkit and Visual C++ compiler (not .net though) and java... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \\ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L 22 CDs huh? Any one know where to get free trial software for Apps? Anyone want to burn me 22 CDs? Just kidding... I haven't work with Financials since 10.7 and feel like I am rapidly losing my financials skills. I want to set this up at home. I figure I would use it for my personal accounting (I know overkill) but I need SOME reason to use it. It looks like I can order this from the Oracle store for a nominal price, however, I need some help in figuring out what to order. Based on the URL: http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=1153 6 http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11536 , Here are the things I think I require: Oracle 9i Database (9.2.0.1) CD Pack for MS Windows $0 (downloaded this software previously) $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows $13.93 Oracle Applications 11i Release 9 Update CD Pack for MS windows And probably one of (but which one?): - Oracle 9i Application Server, Release 2 (9.2.0.1) CD Pack for MS Windows - Oracle 9i Application Server, Version 1.0.2.2.2a CD Pack for MS Windows Does this look right or are there other components I will also need? Thanks in Advance - Babette Also at home at: [EMAIL PROTECTED] The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information.
RE: Multiple block sizes
Title: Message Great! You're exactly the guy that I was looking for. Any problems encountered/advice to give? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but youcanthink about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re: Re[2]: 10g: SQL Plus
This can be done with ksh as well. Someone else may have a link to the script that a rather good ksh coder put together and posted here a few years ago. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Re[2]: 10g: SQL Plus Hi! Press F7 in windows command line sqlplus to see history of your sql commands (it's actually cmd.exe feature). And particularily nice feature is that you can search the F7 history list, by pressing the first letter of a command - you'll be navigate to alter command for example if you press a in history list, one more a will navigate to previous command starting with a. Pressing enter will execute the command again, pressing right arrow will just put the command to prompt where you can edit it before executing. This is one of the reasons why I'm staying on windows with my desktop :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 7:29 PM Wednesday, September 24, 2003, 11:44:44 AM, you wrote: BM Ive actually began to like sqlplus (opposed to sqlplusw). One good BM feature is you have your command history using the up arrow like regular BM shell Scrolling back to see what you've done is a bit more problematic, though you can configure a DOS window to retain some history. You have to think to configure it first though. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Tanel Poder 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: Apps 11.5.8 and 9i
Sounds like OiD. You can't install it on Windows unless you have a Unixish shell to do it in because of the command line utils like ldifwrite. As usual, this was on v9.0.1... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, September 24, 2003 2:10 PM To: Multiple recipients of list ORACLE-L Yep, on Windows platforms -Original Message- Sent: Wednesday, September 24, 2003 1:50 PM To: Multiple recipients of list ORACLE-L My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared -- 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: Apps 11.5.8 and 9i
You can fake it out, though, if you get the free version of Unix on Windows... I forget what it is... and just pretend it is MKS I understand it doesn't do real deep brand or version checking only does a which to see if that returns with valid information. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Apps 11.5.8 and 9i They are required for installation and running 11i successfully on windows. As someone mentioned here, if relinking is needed for example. Also some concurrent jobs interacting with OS might be using MKS. IIRC, you can't even pass prerequisite checking part in installation process if you're missing those. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 9:49 PM Subject: RE: Apps 11.5.8 and 9i My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i=) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into "Program Files" It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows. Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has changed since 10.7 all the way around. Oh, and you will need mks toolkit and Visual C++ compiler (not .net though) and java... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \\ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L 22 CDs huh? Any one know where to get free trial software for Apps? Anyone want to burn me 22 CDs? Just kidding... I haven't work with Financials since 10.7 and feel like I am rapidly losing my financials skills. I want to set this up at home. I figure I would use it for my personal accounting (I know overkill) but I need SOME reason to use it. It looks like I can order this from the Oracle store for a nominal price, however, I need some help in figuring out what to order. Based on the URL: http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=1153 6 http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11536 , Here are the things I think I require: Oracle 9i
RE: Apps 11.5.8 and 9i
Title: Message Probably meaning cygwin. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9i You can fake it out, though, if you get the free version of Unix on Windows... I forget what it is... and just pretend it is MKS I understand it doesn't do real deep brand or version checking only does a which to see if that returns with valid information. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Apps 11.5.8 and 9i They are required for installation and running 11i successfully on windows. As someone mentioned here, if relinking is needed for example. Also some concurrent jobs interacting with OS might be using MKS. IIRC, you can't even pass prerequisite checking part in installation process if you're missing those. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 9:49 PM Subject: RE: Apps 11.5.8 and 9i My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i=) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into "Program Files" It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows. Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has changed since 10.7 all the way around. Oh, and you will need mks toolkit and Visual C++ compiler (not .net though) and java... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 23, 2003 12:55 PM To: Multiple recipients of list ORACLE-L 22 CDs huh? Any one know where to get free trial software for Apps? Anyone want to burn me 22 CDs? Just kidding... I haven't work with Financials since 10.7 and feel like I am rapidly losing my financials skills. I want to set this up at home. I figure I would use it
RE: how to generate unique file names on Windows.
Title: RE: how to generate unique file names on Windows.
IIRC (this is from memory)
type somefile.bat
for /f tokens=1-4 delims=/ %%a in ('date /t') do set newdate=%%b%%c%%d
rename abc.txt abc.txt_%newdate%
this will append mmdd to the file but it will work in batch file only.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 24, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: how to generate unique file names on Windows.
You can use sqlplus to generate the script for you.
-Original Message-
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]]
Sent: Wednesday, September 24, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L
Hello,
I am trying to write a script on windows that would export the db every
night. Can someone tell me how to generate unique file names on windows...
What I am looking for is the windows equivalent of echo `date +%m%d%y`
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/[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: Khedr, Waleed
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).
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: shared server connections
Mladen, aren't you talking about connection multiplexing and not connection pooling ? Isn't pooling is supposed to carried out by the dispatchers themselves. Let me know if I should rtfm. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 19:44 Well, to successfully use connection pooling, you need connection manager. My information is that pooling by the instance is rather buggy and slow. Here is an excerpt from the oracle documentation: Oracle Connection Manager, an Oracle Net Services component, enables multiple client network sessions to be multiplexed, or funneled, through a single network connection to a database. The session multiplexing feature reduces the demand on resources needed to maintain multiple network sessions between two processes by enabling the server to use fewer network connection endpoints for incoming requests. This enables you to increase the total number of network sessions that a server can handle. With multiple Oracle Connection Managers, thousands of concurrent users can connect to a server. Figure 1-12 shows how session multiplexing can be used in a Web architecture. When Oracle Connection Manager is run on the same computer as an application Web server, the application Web server can route multiple client sessions through Oracle Connection Manager to ensure that those sessions have continuous access to an Oracle database server. This functionality is especially useful for Web applications where session availability and response time are major concerns. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 7:25 PM To: Multiple recipients of list ORACLE-L Subject: shared server connections Hello list, I am using 9.2.0.1.0 enterprise edition on windows. I have a database in shared server mode. Every time any one tries to use a shared server connection , I find that after the execution of any query the processor usage shoots up to 95-98%. I have two dispatchers configured , and whenever I specify pool=on , I see the following : As long as the shared server connection is maintained the processor usage remains high and the v$dispatcher_rate(CUR_LOOP_RATE) and v$dispatcher_rate( CUR_EVENT_RATE ) values for the concerned dispatcher go on increasing steadily even though there is only one user and he is sitting idle. If this user logs off, cpu usage falls down to normal. This happens with any user who tries to use a shared server connection. No such problem if a dedicated connection is used. If I restart the instance after setting pool=off then there is no such problem. Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
RE: RAC for download
My dear friend, you're wrong. That practice has stopped with 8i. Partitioning option *is* an integral part of 9iEE without an additional check to sign. I got a verbal confirmation from my oracle sales rep and I'll try getting a written (email) one as well. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Wednesday, September 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: RAC for download I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale wrote: If the question is about price [referring to oraclestore], remember that RAC is an option and is generally at a 50% premium on the EE cost. However, Mladen is right in that RAC is on the same CDs as the Enterprise Edition. If your servers are cluster-ready, the OUI automatically includes RAC as an installation option, else, RAC does not apear in the Oracle product list when you run the Installer. Hemant At 06:54 AM 24-09-03 -0800, you wrote: RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of quriyat Sent: Wednesday, September 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RAC for download Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks -- -- No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com 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). -- 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to
RE: Apps 11.5.8 and 9i
Title: Message Yeah... that's the one. I have it on good authority that if you install that, it will get past the installer April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 2:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9i Probably meaning cygwin. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9i You can fake it out, though, if you get the free version of Unix on Windows... I forget what it is... and just pretend it is MKS I understand it doesn't do real deep brand or version checking only does a which to see if that returns with valid information. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Apps 11.5.8 and 9i They are required for installation and running 11i successfully on windows. As someone mentioned here, if relinking is needed for example. Also some concurrent jobs interacting with OS might be using MKS. IIRC, you can't even pass prerequisite checking part in installation process if you're missing those. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 9:49 PM Subject: RE: Apps 11.5.8 and 9i My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Apps 11.5.8 and 9i=) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into "Program Files" It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows. Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has changed since 10.7 all the way around. Oh, and you will need mks toolkit and Visual C++ compiler (not .net though) and java...
ROW CACHE HIGH - Priority 1
Hi, I have Oracle 9.2.0.2.0 RAC (two nodes) on IBM AIX. Currently I am seeing very high number for ROW CACHE LOCK in statspack. Top 5 Timed Events ~~ % Total Event WaitsTime (s) Ela Time --- row cache lock11,310 5,44186.97 CPU time 522 8.34 global cache cr request32,513 711.14 global cache null to x 21,507 5791 log file sync22,689 49.78 - Get Spin Latch Name Requests Misses SleepsSleeps 1-4 -- -- --- --- library cache 7,094,208 31,499 1,480 30031/1456/12/0/0 shared pool 2,385,408 6,739 527 6212/527/0/0/0 ges enqueue table freelist 1,492,275 1,903 1241780/122/1/0 /0 library cache pin 3,201,008 1,437 130 1307/130/0/0/0 row cache objects1,400,498 1,020 56 964/56/0/0/0 row cache enqueue latch 1,292,843 715 19 696/19/0/0/0 It is holding row cache lock (v$session_wait), other sessions are in the queuedue to this, number of concurrent sessions will increase from 100 to 350 sessions on each node. In less than one minute everything will be cleared ( OLTP database) I have already opened a TAR with Priority 1. Do you have any suggestions. Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed 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: Apps 11.5.8 and 9i
Title: Message Aha, thats a good idea. But Apps loses support probably if you're using cygwin or anything else than MKS. (Btw, I wouldn't call it Unix on windows, it's just a unix toolset runnable on windows). Tanel. - Original Message - From: Nelson, Allan To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 10:34 PM Subject: RE: Apps 11.5.8 and 9i Probably meaning cygwin. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9i You can fake it out, though, if you get the free version of Unix on Windows... I forget what it is... and just pretend it is MKS I understand it doesn't do real deep brand or version checking only does a which to see if that returns with valid information. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Apps 11.5.8 and 9i They are required for installation and running 11i successfully on windows. As someone mentioned here, if relinking is needed for example. Also some concurrent jobs interacting with OS might be using MKS. IIRC, you can't even pass prerequisite checking part in installation process if you're missing those. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 9:49 PM Subject: RE: Apps 11.5.8 and 9i My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Apps 11.5.8 and 9i=) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into "Program Files" It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a Database, Babette... you probably can't use the update... I would say... $55.93 Oracle Applications 11i Release 9 CD Pack for MS Windows. Do a single tier install and be prepared for one hour install to take the biggest part of a day... A lot has changed since 10.7 all the way around. Oh, and you will need mks toolkit and Visual C++ compiler (not .net though) and java... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \
RE: URGENT REPORTS
Title: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: shared server connections
Connection multiplexing is, at least how I understand it, the same thing. Both names mean that several client sessions can simultaneously use the same connection. Anyway, I didn't see any effect from turning POOL=ON in MTS_DISPATCHERS parameter and I did see sharing when pooling was activated in CMAN.ORA. Connection manager is meant to be a communication controller. It unites firewall and load balancing functions. If pooling is what you want, use connection manager. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 3:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: shared server connections Mladen, aren't you talking about connection multiplexing and not connection pooling ? Isn't pooling is supposed to carried out by the dispatchers themselves. Let me know if I should rtfm. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 19:44 Well, to successfully use connection pooling, you need connection manager. My information is that pooling by the instance is rather buggy and slow. Here is an excerpt from the oracle documentation: Oracle Connection Manager, an Oracle Net Services component, enables multiple client network sessions to be multiplexed, or funneled, through a single network connection to a database. The session multiplexing feature reduces the demand on resources needed to maintain multiple network sessions between two processes by enabling the server to use fewer network connection endpoints for incoming requests. This enables you to increase the total number of network sessions that a server can handle. With multiple Oracle Connection Managers, thousands of concurrent users can connect to a server. Figure 1-12 shows how session multiplexing can be used in a Web architecture. When Oracle Connection Manager is run on the same computer as an application Web server, the application Web server can route multiple client sessions through Oracle Connection Manager to ensure that those sessions have continuous access to an Oracle database server. This functionality is especially useful for Web applications where session availability and response time are major concerns. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 7:25 PM To: Multiple recipients of list ORACLE-L Subject: shared server connections Hello list, I am using 9.2.0.1.0 enterprise edition on windows. I have a database in shared server mode. Every time any one tries to use a shared server connection , I find that after the execution of any query the processor usage shoots up to 95-98%. I have two dispatchers configured , and whenever I specify pool=on , I see the following : As long as the shared server connection is maintained the processor usage remains high and the v$dispatcher_rate(CUR_LOOP_RATE) and v$dispatcher_rate( CUR_EVENT_RATE ) values for the concerned dispatcher go on increasing steadily even though there is only one user and he is sitting idle. If this user logs off, cpu usage falls down to normal. This happens with any user who tries to use a shared server connection. No such problem if a dedicated connection is used. If I restart the instance after setting pool=off then there is no such problem. Any ideas ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries
RE: Tuning help required
This probably doesn't apply to the original question, but I would like to point out
that
MEPAI.MPAI_AS_OF_DATE between to_date('03/01/2003','MM/DD/') and
to_date('03/31/2003','MM/DD/')
is not the same as
MEPAI.MPAI_AS_OF_DATE in (to_date('03/01/2003','MM/DD/'), ...,
to_date('03/31/2003','MM/DD/'))
unless all the dates have 0:0:0 for the time portion, for example because of a before
insert or update trigger that sets :new.mpai_as_of_date := trunc (:new.mpai_as_of_date)
Try this and see the difference.
create table orders (order_id number (4), order_date date) ;
begin
for i in 1..24
loop
for j in 1..30
loop
insert into orders (order_id, order_date)
values (j + 30 * (i - 1),
to_date ('200309' || to_char (j, 'FM09') || to_char (i - 1, 'FM09'),
'MMDDHH24')
) ;
end loop ;
end loop ;
commit ;
end ;
/
select count (*) from orders
where order_date between to_date ('20030901', 'MMDD')
and to_date ('20030930', 'MMDD') ;
select count (*) from orders
where order_date in
(to_date ('20030901', 'MMDD'),
to_date ('20030902', 'MMDD'),
to_date ('20030903', 'MMDD'),
to_date ('20030904', 'MMDD'),
to_date ('20030905', 'MMDD'),
to_date ('20030906', 'MMDD'),
to_date ('20030907', 'MMDD'),
to_date ('20030908', 'MMDD'),
to_date ('20030909', 'MMDD'),
to_date ('20030910', 'MMDD'),
to_date ('20030911', 'MMDD'),
to_date ('20030912', 'MMDD'),
to_date ('20030913', 'MMDD'),
to_date ('20030914', 'MMDD'),
to_date ('20030915', 'MMDD'),
to_date ('20030916', 'MMDD'),
to_date ('20030917', 'MMDD'),
to_date ('20030918', 'MMDD'),
to_date ('20030919', 'MMDD'),
to_date ('20030920', 'MMDD'),
to_date ('20030921', 'MMDD'),
to_date ('20030922', 'MMDD'),
to_date ('20030923', 'MMDD'),
to_date ('20030924', 'MMDD'),
to_date ('20030925', 'MMDD'),
to_date ('20030926', 'MMDD'),
to_date ('20030927', 'MMDD'),
to_date ('20030928', 'MMDD'),
to_date ('20030929', 'MMDD'),
to_date ('20030930', 'MMDD')
) ;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: mercredi, 24. septembre 2003 02:20
To: Multiple recipients of list ORACLE-L
Subject: Re: Tuning help required
Well, I'd start by writing the date part as :
MEPAI.MPAI_AS_OF_DATE between
to_date('03/01/2003','MM/DD/') and
to_date('03/31/2003','MM/DD/')
It will at the very least make the query easier to read and
understand
(also for the optimizer : it will know it's filtering on a
range instead
of distinct values).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
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: ROW CACHE HIGH - Priority 1
General answer: upgrade to 9.2.0.4 and hope that the bug has been fixed. Row cache locks are data dictionary locks. You can see the contents of row cache by inspecting v$rowcache. You may need to increase shared pool. Last but not least, how fast is your private network connection between the two nodes? 100mbit/sec is not nearly fast enough. You need at least a gigabit switch. Also check your SQL for hard parsing (see the executions and invalidations in v$sqlarea), ad-hoc DDL and that kind of stuff. And no, it's not my priority 1. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Muqthar Ahmed Sent: Wednesday, September 24, 2003 3:50 PM To: Multiple recipients of list ORACLE-L Subject: ROW CACHE HIGH - Priority 1 Hi, I have Oracle 9.2.0.2.0 RAC (two nodes) on IBM AIX. Currently I am seeing very high number for ROW CACHE LOCK in statspack. Top 5 Timed Events ~~ % Total Event Waits Time (s) Ela Time --- row cache lock11,310 5,441 86.97 CPU time 522 8.34 global cache cr request32,513 71 1.14 global cache null to x 21,507 57 91 log file sync22,689 49 .78 - Get Spin Latch Name Requests Misses SleepsSleeps 1-4 -- -- --- --- library cache 7,094,208 31,499 1,480 30031/1456/12/0/0 shared pool 2,385,408 6,739 5276212/527/0/0/0 ges enqueue table freelist 1,492,275 1,903 1241780/122/1/0 /0 library cache pin 3,201,008 1,437 1301307/130/0/0/0 row cache objects1,400,498 1,020 56 964/56/0/0/0 row cache enqueue latch 1,292,843 715 19 696/19/0/0/0 It is holding row cache lock (v$session_wait), other sessions are in the queuedue to this, number of concurrent sessions will increase from 100 to 350 sessions on each node. In less than one minute everything will be cleared ( OLTP database) I have already opened a TAR with Priority 1. Do you have any suggestions. Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
RE: URGENT REPORTS
Title: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it willaccomplish what you are looking for... HTH Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 3:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: how to generate unique file names on Windows.
-Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: September 24, 2003 1:45 PM To: Multiple recipients of list ORACLE-L Subject: how to generate unique file names on Windows. Hello, I am trying to write a script on windows that would export the db every night. Can someone tell me how to generate unique file names on windows... What I am looking for is the windows equivalent of echo `date +%m%d%y` Thanks in advance. Murali. Dynamically generated timestamp is what you want. Be warned though that this works only on Win2K and 'better': C:\set zdate=_%date:~-4%%date:~7,2%%date:~4,2% C:\set ztime=_%time:~0,2%%time:~3,2%%time:~6,2% C:\echo %zdate%%ztime% _20030924_152452 On (not so) good ole NT4 this has to be done: :: === Create and initialize TIMESTAMP and NOW environment vars: :: set TIMESTAMP=_MMDD_HHMMSS :: set NOW=DD Month HH:MM:SS if EXIST SetTIMESTAMP.bat del /f /q SetTIMESTAMP.bat MakSetTIMESTAMPbat.wsf if exist SetTIMESTAMP.bat ( call SetTIMESTAMP.bat del /f /q SetTIMESTAMP.bat ) MakSetTIMESTAMPbat.wsf script dynamically creates SetTIMESTAMP.bat script. Execute that to create and initialize TIMESTAMP environment variable (mail me off-line if you want this script making script). Sooo much simpler/easier, more logical wouldn't you say than having to remember/worry about meaning of backticks in shell? Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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: Re[2]: 10g: SQL Plus
http://www.orafaq.net/faqscrpt.htm #12 under Unix Shell Scripts - Kirti --- [EMAIL PROTECTED] wrote: This can be done with ksh as well. Someone else may have a link to the script that a rather good ksh coder put together and posted here a few years ago. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Re[2]: 10g: SQL Plus Hi! Press F7 in windows command line sqlplus to see history of your sql commands (it's actually cmd.exe feature). And particularily nice feature is that you can search the F7 history list, by pressing the first letter of a command - you'll be navigate to alter command for example if you press a in history list, one more a will navigate to previous command starting with a. Pressing enter will execute the command again, pressing right arrow will just put the command to prompt where you can edit it before executing. This is one of the reasons why I'm staying on windows with my desktop :) Tanel. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: 10g: SQL Plus
In nt cmd shell , you could make copy pasting easy by going into properties and selecting 'quick edit mode' . In fact you could make this behaviour the default by choosing 'save properties for future windows with same title'. Then you need not select mark and copy , etc . Just use the right and left mouse buttons. I prefer the cmd shell because of its excellent command history using arrow keys. In fact using the F7 key allows me to choose the command i want . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 21:14 Losing the pseudo-GUI version would be a a drag, because it's so easy to copy and paste text in it (not so easy in a Windows command prompt). Try right click - paste or click the upper left icon and choose paste To copy - choose mark then enter -its then in the clipboard Ive actually began to like sqlplus (opposed to sqlplusw). One good feature is you have your command history using the up arrow like regular shell bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky 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: [EMAIL PROTECTED] 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: Multiple block sizes
Title: Message Mladen/Avinish, I would just be a little careful about keeping 'hot' indexes in 32K blocks. The chances of encountering buffer busy waits during multiple, simultaneous INSERTs and DELETEs would be higher as root blocks and branch blocks that need to be updated would now hold a larger number of entries and thus be more likely candidates for block contention Same is the case with more chances of running out of ITL space/entries in hot data blocks. IMHO, DSS type applications benefit most from larger block sizes and support for multiple block sizes in 9i was provided so that 'large-blocksize' tablespaces that contain transaction history can be transported from a 'otherwise-small blocksize' based OLTP database into DSS databases that traditionally have large block sizes. For e.g. in a 9i Db, you might have the OLTP tables based on 8K blocksized tablespaces, create monthly history from these transaction tablesinto a 32K blocksize based tablespace in the same 9i database so that you can Tablespace-Transport it to a 9i, 32k blocksized DSS database. Back to imbibing a thick, black brew after writing this complicated note :) John KanagarajDB Soft IncPhone: 408-970-7002 (W)Grace - Getting something we do NOT deserveMercy - NOT getting something we DO deserveClick on 'http://www.needhim.org' for Grace and Mercy that is freely available!** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 12:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes Great! You're exactly the guy that I was looking for. Any problems encountered/advice to give? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but youcanthink about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged
Re: Hiding passwords
In ntfs you can set permissions on a file . But that wouldn't stop a member of the adminstrator group. What you need to do is to aditionally encrypt the file or folder as well. Then no one else can even list the contents of the folder, not even another administrator. In xp its as easy as right clicking the file/folder , select properties , advanced, 'encrypt contents to secure data'. Now every time you need access just double click the file/folder. Decryption is allowed only for you and occurs on the fly and transparently. But make sure you backup your certificates just in case the system crashes and you have to reinstall. You can then import your certificates and decrypt this folder. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 18:49 In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Patrice. -Original Message- Sent: Wednesday, September 24, 2003 9:55 AM To: Multiple recipients of list ORACLE-L Jared, You said: One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. This is true. But to accomplish the same functionality, you can dynamically create a temporary .bat file that creates the environmental and then execute that bat file. Unfortunately on Windows, anything that you do can be repeated by someone else who logs onto the system. I guess you could secure a folder that only the Oracle account could see, and have these scripts placed in those folders so that the other users cannot get into them without rebooting the machine and bringing it up in DOS mode. That (I think) would prevent snooping. Not sure though. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 23, 2003 6:00 PM To: Multiple recipients of list ORACLE-L Paul, Any chance these scripts could be run from Cygwin, Uwin, MKS Toolkit, or anything that will let you use a korn shell? That would simplify things tremendously. One of the problems with Windohs is that you cannot execute a script or program so that it can return a value to a local environment variable. That ability would make this task simple from command.com. Another possibility is to put your passwords in the registry, restrict that portion of the registry, ( or the whole thing ), and use a Perl script to retrieve the passwords and kick off the other jobs. What I do in linux is use a password server ( as seen in Perl for Oracle DBA's) and retrieve the password across the network, encrypted of course. This works on windows as well, though you're there restricted to doing this strictly from within the Perl script. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 01:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwords Tom, As Dave Barry would say, Har! Unfortunately, we are talking about 3rd-party people who have the 'right' to log in for support (debugging their ^%(^#@ products, and installing updates). I've got them under local admin accounts (as opposed to domain accounts), so they can only get to their own servers. BUT... that's as far as I can go to secure things except at the folder level (and Oracle loves it (!) when you try and do folder security on the datafiles, controlfiles, etc.). I appreciate the thought, but you did not go far enough... Kill them all, and save on security hardware. Any workable ideas? Desperately yours, Paul R. Sherman DBA/Sr. Appl. Analyst Bacou-Dalloz office - 401-232-1200 x200 cell- 401-935-2802 Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Hiding passwords Paul, It's simple really. Do not allow them to log-on to the Win2k server - don't give them an account; keep the passwords secret; and keep the machine in a locked room. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 23, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Hello, If you do that in Win2k, then you have more env variables for 'authorized' people to see when they do a SET cr. Now, to be frank, I have an ulterior (a 'maxed-out' interior or exterior) motive in this reply. I have yet to see an intelligent (never mind elegant) of protecting system variables from someone's view when they do a SET in a DOS session. You can keep them out of Control Panel/System/Advanced/Environmental Variables, but you can't keep them out of DOS, so whaddya do? That's what
guidance
List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: URGENT REPORTS
Title: RE: URGENT REPORTS Thanks. -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 4:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it willaccomplish what you are looking for... HTH Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 3:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: guidance
Give or take the exam? Makes a big difference ;-) Is this your first OCP module? If not, which other modules have you taken? What are you using as study materials? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 24, 2003 4:05 PM To: Multiple recipients of list ORACLE-L List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: URGENT REPORTS
Title: RE: URGENT REPORTS Setting up vnc server and directing DISPLAY to that is easier, I think.I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. - Original Message - From: Johnston, Tim To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 11:09 PM Subject: RE: URGENT REPORTS Check out Xvfb... It the virtual frame buffer... I think it willaccomplish what you are looking for... HTH Tim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 3:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT REPORTS Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- From: Stankus, Paula G Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' Subject: RE: URGENT REPORTS REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'.
RE: Multiple block sizes
Title: Message Not really, except to watch closely your hit ratio for no default cache other than that we used alter table move and alter index rebuild online option to move tables/indexes. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 12:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes Great! You're exactly the guy that I was looking for. Any problems encountered/advice to give? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but youcanthink about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: Apps 11.5.8 and 9i
Title: Message granted... but Babette was just trying to install this on her pc and use it for learning... not sure how much supportthat support would be in her circumstance... and MKS is a little pricey if you are just trying to learn. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Apps 11.5.8 and 9i Aha, thats a good idea. But Apps loses support probably if you're using cygwin or anything else than MKS. (Btw, I wouldn't call it Unix on windows, it's just a unix toolset runnable on windows). Tanel. - Original Message - From: Nelson, Allan To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 10:34 PM Subject: RE: Apps 11.5.8 and 9i Probably meaning cygwin. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Apps 11.5.8 and 9i You can fake it out, though, if you get the free version of Unix on Windows... I forget what it is... and just pretend it is MKS I understand it doesn't do real deep brand or version checking only does a which to see if that returns with valid information. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Apps 11.5.8 and 9i They are required for installation and running 11i successfully on windows. As someone mentioned here, if relinking is needed for example. Also some concurrent jobs interacting with OS might be using MKS. IIRC, you can't even pass prerequisite checking part in installation process if you're missing those. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 9:49 PM Subject: RE: Apps 11.5.8 and 9i My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Apps 11.5.8 and 9i=) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into "Program Files" It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL
RE: URGENT REPORTS
You can't. As of about a year or so ago, there must be a buffer available for reports. vnc works nicley for this. Many notes/articles on Metalink concerning this. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] state.fl.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: URGENT REPORTS com 09/24/2003 01:54 PM Please respond to ORACLE-L Never mind. Was a bad rep_mdmdmd.conf file. However, does anyone know if there is a way to run reports services without have a DISPLAY variable set? We don't have a dedicated machine for this one purpose. -Original Message- Sent: Wednesday, September 24, 2003 1:56 PM To: '[EMAIL PROTECTED]' REP-110: Unable to open file 'alc4.rep'. REP-1070: Error while opening or saving a document. REP-0110: Unable to open file 'alc4.rep'. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas 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: guidance
Realx and feel the force. Only if you open your mind, you can master the force. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: guidance List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Apps 11.5.8 and 9i
I think the product you are talking about is Cygwin. http://www.cygwin.com/ On Wed, 2003-09-24 at 14:24, April Wells wrote: You can fake it out, though, if you get the free version of Unix on Windows... I forget what it is... and just pretend it is MKS I understand it doesn't do real deep brand or version checking only does a which to see if that returns with valid information. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Apps 11.5.8 and 9i They are required for installation and running 11i successfully on windows. As someone mentioned here, if relinking is needed for example. Also some concurrent jobs interacting with OS might be using MKS. IIRC, you can't even pass prerequisite checking part in installation process if you're missing those. Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 9:49 PM Subject: RE: Apps 11.5.8 and 9i My question was not clear. I realize what MKS et al are, but what I really wanted to know is this: Are these things *required* for the installation of Apps 11.5.8 on Oracle 9i? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 04:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Apps 11.5.8 and 9i =) Sorry... MKS makes Windows think it is Unix based. There is a free version ... similar to MKS but another name... that is supposed to be useable, but I have never used it. It lets you use all of the Unix commands, and lets cloning and patching work. Installation also has heartburn if there isn't something somewhere that lets it work unix like in the installation. C++ (NOT .net last I saw... it has compatiblity issues) for the relinking of the products and libraries. You might not need it for the install (although it gets real bent if it isn't there) but for adrelink, it is a must. BIG hint here... make the directory name as short as possible in the install (C:\CPP is what ours is). It keeps the path as short as possible, and there can be no spaces in the path, so don't let anything go into Program Files It is totally way easier if you are on a unix based platform... and the concurrent managers (job scheduling) really don't like being on Windows. -Original Message- To: [EMAIL PROTECTED] Cc: April Wells Sent: 9/23/2003 3:44 PM Importance: High April, please enlighten us ignorant SAP folk. Why are C++ and MKS required? Jared April Wells [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/23/2003 11:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Apps 11.5.8 and 9i Comes with a
Storage Frust....
Group, After another run-in with Storage, need to Vent Some frustrations: BAARF Thank you. While I'm at it, let me add some other RAD ideas: Frustrated by vendors and manuals, we were about to turn BAARF into: battle against any Raw Filesystems (Yes, Yes, I know, a raw-dev is not a FS). But, not wanting to thread on other ppls turf, we thought CCCP: for Compulsory use of a Clustered Computing Platform, whose mission should be to elimiate all usage of Mulitple, In-duh-vidual, ORACLE_BASE/HOMEs and to enforce the use of single-installed Oracle software on Clustered file systems. And to stay in the same retro-atmosphere, we looked at: USSR: for Usage of Single System Rollout: to proclaim the use of sinle-installed ORACLE_BASE/HOMEs, partly inspired by OpenSSI.org More ideas anyone ? Don't start me on: the RAC party : Ridiculous Acronym Creators followed by the RAW devices: Ridiculous Acronym Worshippers or just plain: FAD : Funny Acronym Department ? No harm, no offence intended anywhere (except for some storage ppl, maybe) Getting Late... Tomorrow is 10G lanch-Europe, and all these ideas will be legacy. Regards, PdV -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser 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: guidance
Forget the modern tuning skills and when you're asked what shows the best that your database works optimally; 1) Buffer cache hit ratio is 99% 2) Buffer cache hit ratio is 99,999% 3) Buffer cache hit ratio is 99% 4) Users aren't complaining Then answer 3 for sure ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:04 AM List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Tanel Poder 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: Storage Frust....
Piet de Visser wrote: CCCP: USSR: :) -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun 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: guidance
In US it is called take the exam while in INDIA it is give the exam . ug need ANSI english . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 2:14 PM Give or take the exam? Makes a big difference ;-) Is this your first OCP module? If not, which other modules have you taken? What are you using as study materials? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 24, 2003 4:05 PM To: Multiple recipients of list ORACLE-L List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK 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: guidance
Is that where questions are answered before they are asked? I need a database like that on the stock market. -Original Message- Sent: Wednesday, September 24, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Forget the modern tuning skills and when you're asked what shows the best that your database works optimally; 1) Buffer cache hit ratio is 99% 2) Buffer cache hit ratio is 99,999% 3) Buffer cache hit ratio is 99% 4) Users aren't complaining Then answer 3 for sure ;) Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve 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: URGENT REPORTS
If y'all do choose a VNC route, I'd highly recommend the free and GPL'd TightVNC from http://www.tightvnc.com/ Better compression, better security, and better performance then other RFB-compliant VNC flavors. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, September 24, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Setting up vnc server and directing DISPLAY to that is easier, I think. I have a Apps reports server setup which has run for few years for now with vnc server. Tanel. -- 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: RAC for download
Um... I'd definitely get that in writing... I just looked at the oracle store and it looks like partitioning is still an extra cost item... I also checked the price guide... http://www.oracle.com/corporate/pricing/ePLext.PDF This also listed partitioning as an Enterprise Edition Option... Tim -Original Message- Sent: Wednesday, September 24, 2003 3:45 PM To: Multiple recipients of list ORACLE-L My dear friend, you're wrong. That practice has stopped with 8i. Partitioning option *is* an integral part of 9iEE without an additional check to sign. I got a verbal confirmation from my oracle sales rep and I'll try getting a written (email) one as well. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Wednesday, September 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: RAC for download I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale wrote: If the question is about price [referring to oraclestore], remember that RAC is an option and is generally at a 50% premium on the EE cost. However, Mladen is right in that RAC is on the same CDs as the Enterprise Edition. If your servers are cluster-ready, the OUI automatically includes RAC as an installation option, else, RAC does not apear in the Oracle product list when you run the Installer. Hemant At 06:54 AM 24-09-03 -0800, you wrote: RAC is a part of the EE version, for whichever OS you have. You will still need to purchase the hardware. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of quriyat Sent: Wednesday, September 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RAC for download Hello all Where can i get RAC for download? I don't see one in OTN. Oracle store puts a high tag? Thanks -- -- No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com 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). -- 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is
RE: URGENT REPORTS
What I like about VNC, is that all you need for a client is a browser. http://ip.address:5800 gets you a nice java client connection. Gene [EMAIL PROTECTED] 09/24/03 06:14PM If y'all do choose a VNC route, I'd highly recommend the free and GPL'dTightVNC from http://www.tightvnc.com/Better compression, better security, and better performance then otherRFB-compliant VNC flavors.RichRich Jesse System/Database Administrator[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message-Sent: Wednesday, September 24, 2003 4:20 PMTo: Multiple recipients of list ORACLE-LSetting up vnc server and directing DISPLAY to that is easier, I think. Ihave a Apps reports server setup which has run for few years for now withvnc server.Tanel.-- 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
