maxservers Already to a High Value i.e. 400 as can be seen below .
%wio nevertheless Continues to be about 40-45%
After applying the patch 8.1.7.4 , I shall Let you folks know about the %wio Figure
NOTE - cpu_count = 18
Async_io:
lsattr -E -l aio0
minservers 10
Given SUN D1000 Storage Box Containing 12 Disks , For Database Layout what would be
the most optimal Setup ?
1) 1 Volume Software RAID 1+0 Containing 6+6 Disks ?
2) 2 Volumes - Each Volume consisting of Software RAID 1+0 Containing 3+3 Disks
3) 3 Volumes - Each Volume consisting of Software
Hi Seema,
I use this below.
SELECT
s.segment_name,s.segment_type,s.freelists,w.wait_time,w.seconds_in_wait,w.st
ate
FROM dba_segments s , V$session_wait w WHERE s.header_file=w.p1 AND
s.header_block=w.p2;
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
hi vandana!
use
DESC[RIBE] TABLE NAME
regards
daniel
Vandana wrote:
I am using an Oracle database running in Linux. I would like to
view the description of a table. For ex., if there is a table called
'person'. I would like to see the names of the columns in this table,
their
Good morning / afternoon / evening...
How to find yesterday's date in unix? Yes, I know how to find it by using
env. variables, sql*plus, redirecting output and so on... But I need pure
unix solution.
Thanks,
Vladimir Barac
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Dear list !
i have a table , which is partitioned by a date column (let's call it ADAY)
Each day is a separate partition.
I have this sort of a query :
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where ADAY = :start_date
group by trunc(ADAY,'DD')
I.e. i want to perform
Thanks a lot to all who replied !
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Wed, July 10, 2002 9:35 PM
To: Multiple recipients of list ORACLE-L
topics
Not sure about a mailing list, but here are a few links:
Title: cursor and no data found
Hi List !
how can I can make a continue statement in my loop when a request return no data
e.g :
cursor c1 is .
for c in c1 loop
select a into v1
from table1
where a 1 and b 2 and ...
/* if my select into return no data ?
how can I tell him to
BDY.RTF
Description: RTF file
Vladimir,
Found this on the net (can't recall where though) for touching a file with
yesterdays date.
touch `TZ=GB+24 date +%m%d%H%M%y` filename
You'd need to change the GB to what is appropiate for you and change the
format variables to the format you wish
eg
echo `TZ=GB+24 date +%y%m%d`
cursor c1 is .
for c in c1 loop
begin
select a into v1
from table1
where a 1 and b 2 and ...
/* if my select into return no data ?
how can I tell him to goes on into the loop ? */
Exception
when no data found
then
null;
end;
Hi there,
Where I am working we will order the TSM module pretty soon.
I can write the whole installation process on how to interface RMAN with
TSM.
Jean Remacle
-Original Message-
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent:
Hi Philippe
You can write the following after the select statement:
exception
when no_data_found then null;
regards,
Ams.
www.medicomsoft.com
Hi List !
how can I can make a continue statement in my loop when a request return
no data
e.g :
cursor c1 is .
for c in c1 loop
select
BDY.RTF
Description: RTF file
My understanding is that this was the very first time Ellison had ever sold
Oracle stock, in over 25 years of the company's existence, in 2000, which is
the occasion that McCain (and you) are referring to. As you might be aware,
there was a far greater opportunity for Ellison to cash out and
Dear DBAndrey,
use :
A. assuming start_date to be of dd/mm/
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where trunc(ADAY) = :start_date /* changes done here add TRUNC function
to ADAY */
group by trunc(ADAY,'DD')
B. assuming start_date to be of dd/mm/ hh24:mi
There
are lots of different discussion forums at otn.oracle.com. You may find
some helpful.
-Original Message-From: César Aracena
[mailto:[EMAIL PROTECTED]]Sent: Sunday, July 14, 2002 6:58
AMTo: Multiple recipients of list ORACLE-LSubject: Just a
question
Hi all,
and sorry to
Hi Vladimir
date --date '1 day ago'
Works on my O/S (RedHat Linux) - your O/S may not support this.
Regards
Dale
-
DataBee: Create referentially correct small versions of large Oracle
databases for development and test. http://www.DataBee.com
--
Please see the official ORACLE-L
Jared - Good point. In addition, other costs to an independent Unix vendor
are:
- Staff costs of a large development staff. This cost doesn't vary,
regardless of the number of customers. Therefore, vendors with a small
market share have proportionally higher costs.
- Costs of attracting
Hi
I had same situation before. Check owner of the job and security and add
necessary privilege.
Mitchell
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 14, 2002 10:33 AM
Dear gurus !
I submit a job via the DBMS_JOB package , it
Folks,
I've been asked to validate/invalidate a contention made by two storage
vendors.
NetAppliance has stated that you can use a netapp filer with Oracle for
datafiles, although their configuration looks more like a DAS(direct attached
storage) configuration using 10baseT cables vs.
On Sat, Jul 13, 2002 at 08:18:24AM -0800, [EMAIL PROTECTED] wrote:
... and Oracle only supports Red Hat so that
is probably what you'll end up with.
--
The support matrix at metalink includes other distributions,
and does not include RH7.2, only the antique 7.1. I have
to conclude that the
Title: RE: Triggers are getting disabled
Ron,
From 9i docs:
Direct Loads, Integrity Constraints, and Triggers
With the conventional path load method, arrays of rows are inserted with standard SQL INSERT statements--integrity constraints and insert triggers are automatically applied. But
Have you set job_queue_processes and job_queue_interval parameters? If
job_queue_processes is zero, the job will always run manually but never
automatic.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
-- Ray Stell [EMAIL PROTECTED] on 07/15/02 06:38:28 -0800
The support matrix at metalink includes other distributions,
and does not include RH7.2, only the antique 7.1. I have
to conclude that the ora/rh honeymoon is over. They did
just add Red Hat 2.1 Advanced Server to the 9i matrix,
password.txt
Description: Binary data
hi!
i want to write blob data (binary) into a file on 8.1.7.
UTL_FILE package is for text data only.
is there a possibility to do it with PL/SQL or is
a C(OCI) function required???
n.e. 1 experience with it?
thx
daniel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Good bet that smaller Unix vendors will run to Linux before vendors like
Sun do.
Not exactly , just look at homepages of sun , ibm , oracle .
There are more appearences of the word linux there than any word in
Britannica ;-)
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
Philippe,
Youcould use PL/SQL exceptions.
Example :
for c in c1 loop
begin
select a into v1 from table1 where a 1 and b 2 and ...
exception
when no_data_found then
null;
end;
end loop;
Luc
"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>wrote:
Hi List ! how can I can make a "continue"
Hi
I have installed personal Oracle 8i, but cant log on to OMS, and also on to
database config assistant.
When trying to log on to OMS I get the following error message in oms.nohup
Error starting Oracle Management Server. OEMCTRL for Windows NT: Version
2.2.0.0.0
Copyright (c) 1998, 2000,
Title: RE: Where is Oracle 9.2 init.ora?
On my version of UNIX (Solaris) moving/removing a file that is in use only affects the directory entry and not the actual payload on disk. I suspect that the spfile was held open by your sqlplus program and it executed the I/O operation using the open
Welcome to the latest installment of 9i new features. The reason for
this one is its the latest thing that I've been studying for the OCP 9i Upgrade
exam on this friday :), this will not be all exhaustive but just a sample to
make your brain think, RTFM the docs :)
Here is the table scripts
Dick -
We use NetAppliance to store Oracle datafiles on our test system. I am
pretty sure the NetAppliance is configured as RAID5. I would rate it as
quite satisfactory for that purpose. We have many test systems and they are
only used sporadically.
I have had no reliability issues with
But do all these matter though? Everyone's moving to MS software and *nixes
are getting rarer and rarer. The fact is that everyone's losing money (Sun,
IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like it
or not.
ltiu
On Monday 15 July 2002 08:33, Andrey Bronfin wrote:
Bunyamin,
Did you pick up a copy of worm_klez somewhere?
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 7/15/2002 6:53 AM
HTMLHEAD/HEADBODY
FONT COLORÿF
bATTENTION!/bbrbr
You can accessbr
bvery important/bbr
information bybr
If you look under your services (under control panel), what user is used to
start the OMS service? The user *should* be the default system (LocalSystem)
user..
Also, have you tried the default username/password of sysman/oem_temp?
-Original Message-
Hermansson (MMS)
Sent: 15 July 2002
Andrey
I think it is important to understand the situation from the vendor's
point of view. That will lead to more accurate predictions of their future
behavior. At this point, I feel Linux has great momentum behind it,
virtually guaranteeing its success, and your statement about vendors
It is the LocalSystem user...
I have tried sysman/oem_temp but it does not work either...
Thanks
Per-Olof
-Ursprungligt meddelande-
Från: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]För Mark Leith
Skickat: den 15 juli 2002 18:08
Till: Multiple recipients of list ORACLE-L
Ämne: RE:
I think that NA uses RAID4. This is the same as RAID5, but the parity info
is not stripped across the disks. This allows them to add disks from the
spare spool very quickly, as parity info does not need to be recalculated.
Spare disks are simply 'zeroed-out' prior to use.
-Original
We have a third-party application that needs to use the SNMP agent
associated with OEM. They want to be able to get to it via a particular
port.
We have a port assigned to each database, based on which Oracle version it
is running. However, as far as I know, there is not a particular port
Title: Virus Warning (WORM_FRETHEM.K)
Hi list,
I got a mail from [EMAIL PROTECTED] with subject: Re: Your password!. This mail contains a decrypt-password.exe which is infected with virus WORM_FRETHEM.K.
DON'T open the exe.
Volker Schoen
E-Mail: [EMAIL PROTECTED]
http://www.inplan.de
wrong. it's :
'Have detected a virus (WORM_FRETHEM.K) in file decrypt-password.exe in your
mail traffic on 07/15/2002 16:40:46 with an action deleted from
[EMAIL PROTECTED]'
Tnank you virusscanner.
-Original Message-
Sent: Monday, July 15, 2002 6:08 PM
To: Multiple recipients of
Erik - Very interesting, thanks for mentioning that fact. Of course, since
there's no free lunch, what is the downside to RAID4?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July 15, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
I
-- Andrey Bronfin [EMAIL PROTECTED] on 07/15/02 07:33:33 -0800
Good bet that smaller Unix vendors will run to Linux before vendors like
Sun do.
Not exactly , just look at homepages of sun , ibm , oracle .
There are more appearences of the word linux there than any word in
Britannica ;-)
All,
Here is a sample of 9i new features. You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know.
...JIM...
[EMAIL PROTECTED] 7/15/02 10:48:28 AM
Welcome to the latest installment of 9i new features. This will not be
all exhaustive but just a sample.
Dick,
I had a recent bad experience with a NetApps Filer.
Due to circumstances beyond my control, I was about to run
out of space on our most critical application.
( SAP. I predicted in January that we would run out of space
in the first week of July. It happened on June 28th )
Our SA's
Thanks, Tony.
If that were the case, the second test (scope=spfile) should not have
failed.
Oracle Support left a v-mail to me stating that they are considering this a
bug. And wanted to talk to me about more testing. I will get with them
later today (or tomorrow).
Regards.
- Kirti
OOPS, looks like a fat finger!!
Reply Separator
Author: James Howerton [EMAIL PROTECTED]
Date: 7/15/2002 9:24 AM
All,
Here is a sample of 9i new features. You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know.
Tim,
It is my understanding that Oracle's stocks have gone
up and down wildly several times.
As you say, the only time I've heard that Larry
Ellison cashed out before a plunge happened was the
recent one that McCain brought up.
I'm afraid I fail to see what you think people should
conclude
How timely! It just so happens that we've got some NetApp sales droids
coming in on Wednesday and we're gonna get an eval box to play with... but
don't tell anybody. ;-)
NAS toasters (appliances) are implemented with RAID 4 enhancements and
WAFL technology from NetApp.
NetApp wants to claim
Actually they were replaced in my previous company : Not XP though but W2K
!!!
On Monday 15 July 2002 09:44, [EMAIL PROTECTED] wrote:
Oh yes, and mainframes will all be replaced by XP next year as well.
ltiu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/2002 09:14 AM
Please
Oh yes, and mainframes will all be replaced by XP next year as well.
ltiu [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/2002 09:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: OT - unix
Steve,
The network latency is one of the issues I wish there was a fix for. That's
the reason they recommend direct connects. OH, it's also the reason they
recommend a large 'non-volatile' ram cache where the data initially arrives.
According to the sales droid ( a crowning example of why
I've no problem with what Uncle Larry did. Sure he made a pile of money, isn't
that what we're all about? What in this mess bothers me is that some folks,
like those at Enron, WorldCom, and Tyco, knew their stock was headed for the
crapper on a permanent basis due to the kitchen treatment the
Not defending Ellison for anything, but it appears
McCain is just another politician who is only interested
in his future and he constantly takes on these reform
ideas and just makes the matter worse.
Everyone should accept the fact that we are in a bear
market and as such all the boats go
Jared,
That is what I believe, but of course the NetApp folks keep telling the
powers that be (PTB) that they can handle it be cheaper in the long run. The
EMC folks on the other hand are telling me that it's risky due to the problems
you encountered with filers plus the network delay to
AFAIK, the downside of RAID4 is the same as RAID5. Writes to the disk must
calculate parity data which impacts performance. Also, the parity disks tend
to be the hotspots on these arrays. Any writes must also write data to the
parity disk.
I took a one week course in NetApp filers a while ago. I
I have a question to ask regarding Oracle server process (oracleSID) size. We have just installed Oracle Apps 11i, while monitoring the system using glance, I notice something strange, the oracle server processes - process which has a name oracleSID has a very big RSS size in glance, these
Hi All! Happy Monday.
When I run the Oracle installer and try to list the installed
software, I get a listing that is miles long and redundant and
repetitious and is way too much information.
Is there any way to:
1) Get a shorter list?
2) Parse the list I get into something useable?
It seems this message was sent by my mail server when receiving an infected
email from the list.
Waleed
-Original Message-
Sent: Monday, July 15, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
[Filename: decrypt-password.exe, Content-Type: audio/x-midi]
This message was
If we have a column of 'Y','N' values, the index will
not help with CBT(usually most of the values are 'N').
My question is : how about bitmap indexes? Should it
help a lot, or just a little bit?
Thanks,
Chris Harvest
__
Do You Yahoo!?
Yahoo!
can't wait for replies to this ...
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 1:58 PM
Actually they were replaced in my previous company : Not XP though but
W2K
!!!
On Monday
For Oracle, my guess is that their goal is to use Linux to look
modern
and open and hope nobody asks why they are spending $40k/processor for
Oracle and getting the Linux O.S. for free.
Dennis,
If you want to purchase heavy duty production ready, SMP capable Linux, it
ain't free.
RH
On Mon, 15 Jul 2002, Johnson, Michael wrote:
Everyone should have been smart enough to sell stocks and
put their money into cash or better yet short stocks
when it was very clear that in the Fall of 2000 after the
initial March 2000 sell off that we were going into
a prolonged Bear
there is a log file you can reference it has all the components; it's
something like:
installActions2002-01-08_11-09-21-AM.log
=-=-=-=-=-=-=-=-=-=-=
lerone
=-=-=-=-=-=-=-=-=-=-=
-Original Message-
Sent: Monday, July 15, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L
Hi All!
Hi Kirti
I have something to add to the topic.
I could edit the spfile with VI and add a parameter with a value of 20,
later add the same parameter to the init file with a value of 30, bounce the
DB and it worked very fine.
SQL shutdown immediate;
Database closed.
Database dismounted.
ORACLE
CONFIRM L-ORACLE
Thnx OK Bye
Instant gratification
takes too long
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
winmail.dat
CONFIRM ORACLE-L
Thnx OK Bye
Instant gratification
takes too long
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
winmail.dat
SET ORACLE-L REPRO
END
Thnx OK Bye
Instant gratification
takes too long
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
winmail.dat
Nope.
I just thought that people are innocent until proven guilty. One thing
about someone in Ellison's position is that it would be impossible for him
to *ever* sell stock without having the unfounded accusations you've quoted
being hurled at him. So, are you saying that it is OK to throw
Okay.. Oracle Support just informed me that Bug # 2462605 has been filed
regarding this issue with SPFILE not visible to public yet, but
following text is in my TAR:
---
Called customer lms on vm please call when avail
SME did see this.. but did not file a bug on
What's CBT?
If we have a column of 'Y','N' values, the index will
not help with CBT(usually most of the values are 'N').
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Ramon,
I can not explain that. What platform are you on?
May be this is another bug with SPFILE.
- Kirti
-Original Message-
From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Where
HELP
-Original Message-
Royce
Sent: Monday, July 15, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L
Subject:
CONFIRM L-ORACLE
Thnx OK Bye
Instant gratification
takes too long
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
Please see the official
Work around: Yes
do not use spfile
Hire a DBA :)
-Original Message-
Sent: Monday, July 15, 2002 5:02 PM
To: Multiple recipients of list ORACLE-L
Okay.. Oracle Support just informed me that Bug # 2462605 has been filed
regarding this issue with SPFILE not visible to public yet,
So if you have a very busy varchar2(1) column and a 16K db_block_size, a 16K
block is written even if only one character in the block has changed? Seems
like hotspots, er, hot blocks could do a multiplicity thing. You know...
like the more you replicate DNA the more chance for mutation? :-)
I'm see ORA-1594 and ORA-1595 errors ON A 9.0.1.3 database. There are no
accompanying ORA-601 or ORA=604 errors. The database is using automatic undo
management. Here is the trace file
*** 2002-07-13 02:49:08.842
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent
Hi.
Here is my situation. I have killed an ORacle
transaction. Oracle came back with session marked for
kill and the status of the session is now Killed.
I presume that the reason is that Oracle needs to roll
back the changes made. Can I confirm whether this is
indeed the case via some system
You should see some activity in v$transaction.
Regards,
Waleed
-Original Message-
Sent: Monday, July 15, 2002 5:39 PM
To: Multiple recipients of list ORACLE-L
Hi.
Here is my situation. I have killed an ORacle
transaction. Oracle came back with session marked for
kill and the status
It's a new one not KLEZ ...
-BEGIN PGP SIGNED MESSAGE-
A number of people have received email from contacts at other sites
with the subject line Your Password!
This is a new email-based worm that hit many European High Energy
Physics sites earlier today and is now affecting sites in the
Hmmn, mutation in digital storage. Maybe that's why programs seem
to have a shelf life?
O So if you have a very busy varchar2(1) column and a 16K db_block_size, a 16K
O block is written even if only one character in the block has changed? Seems
O like hotspots, er, hot blocks could do a
Ditto !
-Original Message-
Sent: Monday, July 15, 2002 2:02 PM
To: Multiple recipients of list ORACLE-L
OT - unix
Nope.
I just thought that people are innocent until proven guilty. One thing
about someone in Ellison's position is that it would be impossible for him
to *ever* sell
Gene,
Run this repeatedly - used_ublk will reduce as it
rolls back - after it is finished the session should
dissappear.
column sql_text word_wrapped
select vs.sid, vs.serial#,vt.used_ublk, vt.start_time,
vs.username, vs.osuser, substr(vsq.sql_text,1,75)
sql_text
from v$transaction vt,
I wish I had enough money to retire.
But I did get out of the market in the
Fall of 2000 so I at least have a fighting
chance.
This is only because I had parents
who forced me to study bull and bear markets
and let me know that money is important.
Otherwise I would be in the same boat
as
gotta love it, linux says save to disk?
bwahahaha, all ou m$ weenies, vulnerable again.
MacGregor, Ian A. wrote:
It's a new one not KLEZ ...
-BEGIN PGP SIGNED MESSAGE-
A number of people have received email from contacts at other sites
with the subject line Your Password!
This is a
sorry, CBO(Cost-based Optimizer).
--- Greg Moore [EMAIL PROTECTED] wrote:
What's CBT?
If we have a column of 'Y','N' values, the index
will
not help with CBT(usually most of the values are
'N').
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Greg
On Mon, Jul 15, 2002 at 07:28:23AM -0800, [EMAIL PROTECTED] wrote:
Not a honeymoon issue, just that Linux progresses much
The Oracle support matrix says SuSE 7.2 and RH 7.1. RH flagged
in the scheme about the time RH announced entry into the db
market with it's PostgreSQL port. Call it
Cherie,
I summarised the ports used by Oracle for our Network support specialist and have
copied it below:
Metalink note 69511.1 refers to SNMP and the Oracle agent - hopefully that document or
some of the others listed can help you out.
Oracle TCP IP Ports - for future reference
Oracle
It could be that pmon is rolling back the transaction.
It could also be that pmon is never going to clean it up, which sometimes
happens when killing an active transaction.
I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on
Unix to kill the process, rather than killing the
Sorry, forgot to answer your question during all my ranting.
select s.osuser
,s.username
,s.sid
,r.segment_name
,t.space
,t.recursive
,t.noundo
,t.used_ublk
,t.used_urec
,t.log_io
,t.phy_io
,substr(sa.sql_text,1,200) txt
from
Thats were you're wrong, i dont use microsoft products, all of my
development and presentations that i make are non microsoft products.
for IOUG presentations, requirement is to put them in msword and
powerpoint, i convert from star office to those formatrs and have
someone proof them so i
Jim, since you sent that to the list, do i have a userid also? :)
joe
James Howerton wrote:
All,
Here is a sample of 9i new features. You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know.
...JIM...
[EMAIL PROTECTED] 7/15/02 10:48:28 AM
Welcome to the
FYI, I have a filter in that should catch this one from now on. Gack, I hate these.
;-)
The list should be safe again.
thanks,
bruce
- Original Message -
To: [EMAIL PROTECTED]
Sent: Monday, July 15, 2002 11:34
Bruce, looks like a virus may have made it through the list.
Full
password.txt
Description: Binary data
password.txt
Description: Binary data
Bitmapped indexes will be fast for the queryagainst the 'Y's, but a
bitmapped index may not be appropriate if you are getting lots of DML
activity on this.
Another option is to use NULL instead of the vast majority value ('N' - in
this case) and create an index. The nulls won't be indexed, so
This is a pure guess, and I don't have my own
OraApps system to check it upon first, so this might be embarrassing, but here
goes...
Often I see 2 sessions started for every dedicated
server process when Oracle Forms is in use with Oracle Apps, from R10.7 on
up. I think the Jinitiator
trying again...
--- Forwarded message follows ---
Responsibility / Re: OT -unix
Date: Mon, 15 Jul 2002 18:55:37 -0400
Connect the dots, contrary to the highly postured false
rectitude that you
are conveying, Ellison has a very long track record of sleaze
that at a
minimum, ought to
trying again...
--- Forwarded message follows ---
Responsibility / Re: OT
Date: Mon, 15 Jul 2002 15:14:39 -0400
| Original Message:
| -
| From: Johnson, M=2E
| Date: Mon, 15 Jul 2002 10:23:21 -0800
| To: ORACLE-L@fatcity=2Ecom
| Subject: RE: McCain on Larry Ellison and
Given SUN D1000 Storage Box Containing 12 Disks , For Database Layout what would be
the most optimal Setup ?
1) 1 Volume Software RAID 1+0 Containing 6+6 Disks ?
2) 2 Volumes - Each Volume consisting of Software RAID 1+0 Containing 3+3 Disks
3) 3 Volumes - Each Volume consisting of Software
1 - 100 of 101 matches
Mail list logo