Hi all,
But they other group will unable to read.
Like for example in DOS we can make our *.bat file to *.exe
changing the ascii (readable) to binary file.
Is this possible?
thank you
-Original Message-
Sent: Wednesday, 1 August 2001 12:25 PM
To: Multiple recipients of list ORACLE-L
Qs. Will COST Based Optimizer (CBO) or Rule Based Optimizer (RBO) be
used for the PARTITIONED Table in the Following Query ?
NOTE OPTIMIZER_MODE is Set Explicitly to RULE , Run the Following SQL :-
SELECT Some Columns
FROM Partition Table , NON-Partitioned Table
where Partition Table.Column =
Compilation will not make the password unreadable.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 31, 2001 8:30 PM
To: Multiple recipients of list ORACLE-L
Hi all,
How make unix script and Oracle sql script not readable or
Should be okay if you you use it only for plsql variables, which Oracle
version do you have?
Maximum size of a varchar2 plsql variable is 32000
Maximum size of a varchar2 column in a table is 4000 bytes
see more about variable sizes in
http://www.itsystems.lv/gints/oracle_limits.htm
Gints
look in application developers guide or plsql user's guide for more info
I've succesfully created for testing purposes them as follows
create or replace trigger ON_ALTER
AFTER ALTER ON DATABASE
BEGIN
INSERT INTO sys_aud_table (
event
,id
,timestamp
,login_user
Use the plan stability of Oracle 8i. In this u have to capture plans for the sqls. A
init parameter has to be added use_plan_stability=true(pls chk with manuals for more
info).
Ref to Oracle performance tuning manual. It is explained well there.
HTH
Regards
Venkat
--
On Tue, 31 Jul 2001
Well at least that explains my empty inbox. I thought they didn't want me :)
From: John Kanagaraj [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: OT: OOW - notification of selection - Dates moved to Aug 6th
Date: Tue, 31 Jul
Sorry, but maybe you refer to the outlines and the
parameter use_stored_outlines. Read the notes
1071358.6 and 92202.1
Regards.
--- C.S.Venkata Subramanian [EMAIL PROTECTED]
wrote:
Use the plan stability of Oracle 8i. In this u have
to capture plans for the sqls. A init parameter has
to be
John,
Greenmarket=Farmer's market. We have several all over the city, I love the
neighborhood we moved our offices to not just because it is a fun, funky
area to explore but because the best of the markets is within walking
distance and is there M, W, F and Sat.
I haven't gone and
its been at least a year since this wa sstated but i believe i read(have
not tried it), that you could have totally erase your redo logs(like you
had a serious failure in which all copies were lost) and a open
restelogs would have recreated them. I think that was explained by
someone on the
Andrea asked about removing NT services.
What about Oracle homes? The Oracle Universal Installer appears to be doing
a poor job of cleaning those up when we de-install Oracle software.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
I noticed on www.dice.com http://www.dice.com that the number of job
postings is way down.
Is this because of the recession / dot-com collapse, or because DBAs are no
longer in demand?
I notice that most postings emphasize that they need U.S. residents or
citizens, green cards, but nobody
read the migration guide, near the end, its ALOT easier than that, look
for changing word-size.
joe
Adrian Roe wrote:
Hi All,
Can anybody give a quick overview of what's involved in downgrading from
64bit Oracle (AIX) to 32bit. Is it straightforward ie. export/import,
anything to watch
Patrice:
If you're talking about the filesystem, everything should be under the
%ORACLE_HOME% directory (usually c:\oracle\ora81 or the like). The registry
entries are all in HKLM\Software\Oracle. Just run regedit and delete this
key to remove all the Oracle registry keys. Also, the OUI will not
u can also remove specific or all oracle home from ur system.
go to registry editor.. local machine/software/oracle and remove what u
want..
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
- Original Message -
To: Multiple recipients of list ORACLE-L
Hello all,
I had more than I thought requests for the soft copy of the book Teach
yourself perl 5 in 21 days . For that reason, I put them at my box for
download. Sorry for the delay but it has been a busy day for me...
I do not want any personal information nor any charges for download. Just
I think it is all of the above. Mainly the recession and Dot-bomb.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Wednesday, August 01, 2001 8:10 AM
To: Multiple
What dvd's are you using? They are generally 4.7Gb per side, and 9.4Gb if
they are duel layered.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, July 31, 2001 6:26
Dear All,
We are in process of migrating some appln from WindowsNT to Unix. Our prgs are written
in Pro*c. We need some suggestions reg the same.
TIA
Regards
Venkata
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ:
Is this because of the recession / dot-com collapse,
Yep. The dot-com collapse freed up a lot of DBAs and they finally decided that moving
east was better than living on the streets of San Francisco. There are still a few
openings out there, but nobody wants to move to Memphis since Elvis
Title: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
Ohh,
very clever indeed!
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 31, 2001
9:20 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: OT about to peeve off
Ya I got the name correctly. Thanks for pointing it out.
Venkat
--
On Wed, 01 Aug 2001 03:01:19
Christian Trassens wrote:
Sorry, but maybe you refer to the outlines and the
parameter use_stored_outlines. Read the notes
1071358.6 and 92202.1
Regards.
--- C.S.Venkata Subramanian [EMAIL
I highly recommend the O'Reilly library of books for Perl.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Monday, July 30, 2001 10:00 PM
To: Multiple recipients of list
The A1000 has a max of 12 disks.
I would recommend against Raid 5 for performance reasons, although the
write-back cache covers some of the drawbacks.
A1000 is knowned to have slow cache, and consistency errors when they are
pushed to the brink of saturation.
But yes, Raid 5 with 4 disks will
I broke oracle on NT one time by messing with them, i thought
i'd do it manually, so i tinkered with registry entries, etc, eventually had to
blow away all of the oracle stuff and start over.
:(
joe
[EMAIL PROTECTED] 08/01/01 09:10AM
I don't want to remove all the oracle homes, just one
Kevin,
An hour is 3600 seconds, a minute is 60 seconds oracle date addition is
a pure number ... so you convert hours to number of seconds, add that to
number of seconds for minutes. This will give you total number of seconds.
Divide that by 86400 and add this result to sysdate (or whatever
Dear All,
Is it possible to create a view where I will pass the condition to the where clause
dynamically.
eg)
Create view v1 as select ename,empno,sal from emp where deptno=:a
The value of 'a' I will pass the value dynamically when I do the select.
eg) select * from v1.
Now I'll pass the
Patrice,
You will also notice the same on monster.com , computerjobs.com , headhunter.net, and
a lot of the individual headhunter home sites. Some of the sites are running the same
ads for the same job but with different headhunters.
It is definitely a different market than it was 12 months
A drive down the turnpike is NEVER worth it:)
KK
-Original Message-
Kanagaraj
Sent: Wednesday, August 01, 2001 2:35 AM
To: Multiple recipients of list ORACLE-L
Rachel,
Do you have the 'Farmer's markets' in NY like we have here in CA? (where
farmers freight and sell their farm-grown
Did you run all the scripts suggested as post-upgrade
operation.(like utlrp)
HTH,
Rajesh
-Original Message-
Fawzia
Sent: Wednesday, August 01, 2001 5:51 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have just upgraded 8.0.5.2 to 8.1.6 and some of my objects are
invalid.
Sinardy schrieb:
Hi all,
But they other group will unable to read.
Like for example in DOS we can make our *.bat file to *.exe
changing the ascii (readable) to binary file.
Is this possible?
thank you
-Original Message-
Sent: Wednesday, 1 August 2001 12:25 PM
To: Multiple
I don't know how you would tell if someone died of heart failure from a
fossil. One of the problems is that the cavemen and cavewomen didn't live
long enough for some of the modern diseases to afflict them.
|| LoLi guess they warmed up one of those petrified ice cavemen they
found
I don't know how you would tell if someone died of heart
failure from a fossil.
Heart problems show up in the bones due to poor circulation of nutrients. There has
been a few fossils found with some evidence, but not very many. Since they ate more
wild meat, their diet had a lot less fat
MacGregor, Ian A. schrieb:
Compilation will not make the password unreadable.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
Hi,
if you want to hide the connect strings, place them in an extra
directory, only x-able and readable by privileged users. Then have your
If I understand your statement correctly. The RAID5 drives will be considered as one
large logical drive and they are setting it up as one mount point. With the RAID5
configuration you loose the ability to use each individual physical drive separately.
4 drives of 10 GIG each in RAID5
CURSOR_SHARING is 8.1.6.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Wednesday, July 25, 2001 10:13 AM
To: Multiple recipients of list ORACLE-L
Set your
Hi,
I have just upgraded 8.0.5.2 to 8.1.6 and some of my objects are invalid. I
have tried to recompile them to no avail. I did the upgrade manually running
the script :u0800050. Is there anything else I needed to run???
Rgds
Fawzia
This message is confidential and is intended for
Venkata,
Yes.
Create a public variable in a PL/SQL package stored in the database.
Reference that public variable in the where clause of your view and populate
that variable before you select from the view. Since each session gets its
own instantiation of the packaged variable, each session
Rachel,
This is indeed harder than one would expect.
It is simple in the case of userA still working on the locking transaction,
which I've put together a script for:
select u.name Owner,
o.name Object,
l.sid SID,
s.username Username,
t.sql_text SQL,
l.type
Try this site...
http://www.mysql.com/information/crash-me.php
On Mon, 30 Jul 2001 13:29:28 -0800
Ravindra Basavaraja [EMAIL PROTECTED] wrote:
Does anyone have any doc or links that compares oracle and ms sql.
Also what are the equivalent data types in ms sql for oracle's lobs.
Thanks
Venkata,
the way to do this is to return the column you wish to use in the WHERE
clause.
Example:
Create view v1 as select ename,empno,sal,deptno from emp;
Then, when you access the view, you can say:
select * from v1 where deptno={some value}
I do this all the time, and it works just fine.
Ravindra Basavaraja schrieb:
We are planning to move our database to Sun 4500 with A1000(RAID 5).Our
system admin group has been
working on this setup and I was told that the A1000 which is having 4 disks
will be seen as just as
one mount point after configuration.Is this the correct way
C.S.Venkata Subramanian schrieb:
Dear All,
We are in process of migrating some appln from WindowsNT to Unix. Our prgs are
written in Pro*c. We need some suggestions reg the same.
TIA
Regards
Venkata
Hi,
what kind of input do you need ? Regarding the Precompiler, it's
available on
There are dvd burners. I know someone who has one tho I've never seen it.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 9:16 AM
What dvd's are you using? They are generally 4.7Gb per side, and 9.4Gb if
they are
what did the migration guide tell you?
maybe utlrp??
joe
[EMAIL PROTECTED] 08/01/01 09:50AM
Hi,I have just upgraded 8.0.5.2
to 8.1.6 and some of my objects are invalid. Ihave tried to recompile them
to no avail. I did the upgrade manually runningthe script :u0800050. Is
there
Title: RE: RULE vs. CHOOSE
From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2001 08:05
Subject: RULE vs. CHOOSE
Qs. Will COST Based Optimizer (CBO) or Rule Based Optimizer (RBO) be
used for the PARTITIONED Table in the Following Query ?
NOTE OPTIMIZER_MODE is Set
[EMAIL PROTECTED] schrieb:
Preferable solution:
ORADIMxx -DELETE -SID SID
xx will depend on your version or Oracle
or
ORADIMxx -DELETE -SRVC service_name
service_name is your service name
Alternative solution:
In your registry settings.
Open
No where.It just seemed like an extra step since you needed partial days
as the additive to the date string. Thanks for explaining what I should
have seen.
-Original Message-
Sent: Wednesday, August 01, 2001 8:17 AM
To: Multiple recipients of list ORACLE-L
Kevin,
An hour is 3600
Run utlrp.sql fro $ORACLE_HOME/rdbms
-Original Message-
Sent: Wednesday, August 01, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have just upgraded 8.0.5.2 to 8.1.6 and some of my objects are invalid. I
have tried to recompile them to no avail. I did the
One way should work : DUL
You'll get this by phoning Oracle WWS and cost quite a few dollars but
could well be worth it.
But maybe Oracle WWS can solve it some other way. I have heard of stories
where they go in and change bits/bytes in datafiles (hexeditor) to combat
corruption or just to make
doesn't write performance kind of suck too?
KK
-Original Message-
Jahnke
Sent: Wednesday, August 01, 2001 10:02 AM
To: Multiple recipients of list ORACLE-L
Ravindra Basavaraja schrieb:
We are planning to move our database to Sun 4500 with A1000(RAID 5).Our
system admin group has
Another sign of the times is that ITI is closing its US schools.
For those who don't know - it is a computer training school. They started years
ago as a school in Atlantic Canada offering a 10 month course. Later they
expanded to few Canadian and US cities. Last year they advertised on TV and
I don't know how you would tell if someone died of heart
failure from a fossil.
Heart problems show up in the bones due to poor circulation of nutrients. There has
been a few fossils found with some evidence, but not very many. Since they ate more
wild meat, their diet had a lot less fat
I don't know how you would tell if someone died of heart
failure from a fossil.
Heart problems show up in the bones due to poor circulation of nutrients.
There has been a few fossils found with some evidence, but not very many.
Since they ate more wild meat, their diet had a lot less fat in
This is why I have chosen to live in a rural community so that I can have a
huge garden and many fruit trees. And for the meat eaters, you can hunt
Deer, turkey, pheasant and many other critters. This way I know that my
produce has no chemicals and does not get picked until ripe. I just picked
There are DVD burners, for creating your own DVD's. I hate to say it, but
Mac has a nice one:( Anyway, I'll give a year or two before I buy one of
those, the price is still like 600+.
But, I don't think that you could use it to make a copy of a DVD?
KK
--
Please see the official
Rachel Carmichael [EMAIL PROTECTED] on 07/31/2001 11:48:02 AM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim Katz/Completions/Bombardier)
Rachel,
I don't know how to retreive the locking sql either, but reading
Does anyone know of a link to Gaja's wite paper on tuning that he
presented at OOW 2000?
I'm running into some fun tuning thins and I can't seem to find my notes
from the session.
TIA
Rodd Holman
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Mark,
mark,
Yep, it ain't a walk in the park... as I said. I've been thinking/working on
this for a number of years, haven't found a solution yet.
The problem with taking so many snapshots is that I am afraid that they will
affect performance.
I don't do easy questions... those I answer
Hi,
From Oracle 8i onwards ,it is ORADIM without any numbers like in the previous versions(ORADIMxx) .
HTH.
Jyoti
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jyoti N
INET: [EMAIL PROTECTED]
Interesting site...
Since I am not familiar with some of the other databases, are all the ones listed
there 3 versions old or just Oracle? I noticed DB2 was 2 versions old.
-Original Message-
From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 9:56 AM
To:
I am so incredibally jealous of you!!! That's my little dream, land and
sweet smelling air and trees and animals and privacy. I want to go home
after work, sit on a large porch that wraps around my house, put my feet up,
listen to some sweet James Taylor, smoke a grit and drink an ice cold
I lost the battle. We have Hitachi raid 5 hooked-up to a Sun E10K and write
performance does SUCK!!!
Maybe THEY will listen next time;-)...
...JIM...
[EMAIL PROTECTED] 8/1/01 10:36:01 AM
doesn't write performance kind of suck too?
KK
-Original Message-
Jahnke
Sent: Wednesday,
About 60% because of the additional reads/writes generated with the parity
data.
With 4 disks, I would do 0+1 and use same if you cannot get the additional 8
disks.
If you can afford the additional spindle space loss, performance will
greatly appreciate it.
Do not criticize someone until you
The specs I gave are just that. Specifications from the DVD MPEG group.
Most DVDs pressed today are dual-layered (due to all the extra content and
features). You can usually see the layer switch, unless you have a second
or third generation DVD player (they have large buffers for this). I can
Lyuda,
What are your settings (BINDSIZE, ROWS, etc)?
Also how big and how many rollback segments do you have? How big is
their tablespace?
If you have any questions, please feel free to drop me a note.
Stephen Andert [EMAIL PROTECTED] 07/31/01
04:30PM I could do it but the trick it to
Oracle Data Administrator
Years Exp: 6+ years
Location: Milwaukee, WI
Salary $6 - $9 ..D.O.E.
Prod Offered: Financial Services
* Candidates local to the Greater Milwaukee area only.
Job Description:
Outstanding opportunity to join a leading company in the financial services
industry.
What type errors are you getting? That may help in determing if you need to
run some Oracle scripts.
Rick
-Original Message-
Sent: Wednesday, August 01, 2001 9:51 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have just upgraded 8.0.5.2 to 8.1.6 and some of my objects are
One thing to note is the 60% degragation of write performance when using
Raid5, that is why oracle strictly recommends against it. But to repeat
something said many times in the past, read only systems or very low writes
are great candiates for Raid 5.
Do not criticize someone until you walked
Hi all,
Thanks for responding. I did run the script outlined below. The invalid
objects are triggers. If I try to compile manually I get the following:
SQL alter TRIGGER SCER10.VRSS_BRI compile ;
alter TRIGGER SCER10.VRSS_BRI compile
*
ERROR at line 1:
ORA-00604: error occurred at recursive
Fawzia
You may have to run this script for couple of times(atleast 2) due
dependancies and then see the results. You can also try to compile it
manually. If still there are invalid call Oracle Support and they might
advise you to drop most of them as some of them are product related which
The comparisons look good for MySQL...
not bad for others, but better for
mySQL than some comments by some
folks on the list would have led me
to believe.
Anyone here have major gripes about
mySQL that oracle solved?
-Original Message-
Sent: Wednesday, August 01, 2001 12:01 PM
To:
The weight in ounces of the Sunday San Jose Mercury News Classifieds is a
valid measure of economic activity. At one point it was around 24 pages for
IT jobs but it recently has been down to 1-2 pages.
A few years ago, despite the positive outlook for careers in computer
science, students
Thanks for all the replies. I download a copy of DVD Decrypter from
www.flexion.org. It works great to get a
copy of the DVD on your hard drive. Trouble is, the files are all 6-8 gig.
So they can't be put back on a
normal CD. Nice try anyway. Guess I'll just buy an extra copy next time.
Probably not, but MAN is it delicious!!!
-Original Message-
Sent: Wednesday, August 01, 2001 12:11 PM
To: Multiple recipients of list ORACLE-L
I don't know how you would tell if someone died of heart
failure from a fossil.
Heart problems show up in the bones due to poor circulation
Yes, but you have to understand that those animals, trees, and garden take
lots of work! You have considerably less time to sit on your porch and
drink an ice cold beer! Of course, it's just that much better when you do!
Seriously, I'm in the same boat as Dave, and the benefits greatly
Title: Help, processes won't die
I need some assistance ASAP. Our nightly batch process seems to have hung up for some strange reason (ok no biggie my boss says kill it and start it again). The problem is I have killed the processes both in oracle (sid, serial#) and also in unix. Now I can't
You can't do subqueries in mySQL
You can't use derived tables in mySQL
The foreign key support is defined as not being Full, don't know what that
means.
Dave
-Original Message-
Sent: Wednesday, August 01, 2001 11:48 AM
To: Multiple recipients of list ORACLE-L
The comparisons look good
As one who has searched these boards of late, I concur.
Someone posted a while back a good summary that went something
like this:
... The postings are the same ones that have been there for months,
but they get a new date on them every three days, the jobs that the
postings are for don't exist,
And be sure to hand out some beatings if you see DVD's flying through the
air:)
KK
-Original Message-
L.
Sent: Wednesday, August 01, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
Thanks for all the replies. I download a copy of DVD Decrypter from
www.flexion.org. It works
Hi,
After upgrading from 8.0.6 to 8.1.7 this weekend, we are experiencing
sporadic failures in some end-user MS Access 2000 queries. We are using the
MS for Oracle ODBC driver v2.573.xxx.xx instead of the Oracle supplied
version because the MS version allows the retrieval of zero dates (instead
AFAIK on big thing 'missing' in mySQL is that it
has no journalling (transaction logging) capabilities.
So there's no transaction mgt.. rollbacks...etc..
if things bozo in the middle of a process.. you're dead.
Restore from last backup and hope for the best.
So you wouldn't want to use
Title: Help, processes won't die
I
believe that I read somewhere that issuing a kill session will NOT free up the
memory from that session.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]Sent: Wednesday, August 01, 2001
Hi everyone,
Can anyone recommend some email discussion lists that are related to certification.
Thanks in advance,
Kevin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
You know the other problem is that geek tools are becoming more and more
cool!! Palm Pilots and cell phones and such, everyone wants to play with
these things. I agree, full on geekness is the only solution!
KK
-Original Message-
Sent: Wednesday, August 01, 2001 12:52 PM
To: Multiple
I'll get out my pocket protector and glasses that are taped on the nose
piece!! [o)
-Original Message-
Sent: Wednesday, August 01, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L
The weight in ounces of the Sunday San Jose Mercury News Classifieds is a
valid measure of economic
What about like amateur radio(aka ham radio, not to be
confused with radio controlled pigs), alot of those geek heads do radio
stuff(well ok a few of us) :)
joe
[EMAIL PROTECTED] 08/01/01 12:52PM The
weight in ounces of the Sunday San Jose Mercury News Classifieds is avalid
measure of
Chaim,
That could work. Logminer wasn't around when I first had this problem, and I
haven't spent time working with it.
From what I know from listening to Joe present on it though, it would be a
more complicated process than I want. I'd have to be sure that the
dictionary map was always up
I asked about this a ways back when I wanted to
remove only one version of Oracle. I ended up hosing up the registry and having
to completely wipe the hard drive and start over. Reinstall NT, etc,
etc. Be very careful with deleting registry entries :) But, now I
have a nice clean NT machine
Work? Yes a well trimmed lawn is a lot of work. I don't need tons of land,
just some trees and privacy and peace and quiet. I hate city living and
could never do it, I have friends that live in Jersey City and Hoboken and I
just don't understand why they would want to. You could get a house
Mcpmag talks ad nauseam about MS certs. Don't expect an unbiased discussion
there, though.
Computerworld has an interesting article on which certifications to pursue
right now - the top level java certification seems to be the hot one now.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Rachel,
I did that when I worked at a bank where smokers took 2 10-15 minute breaks
in the am and at least 2 in the pm. I went out with a buddy. One day
my mgr walked in and said "Steve, I didn't know you smoked. What are you
doing out here?" I said I was taking my second-hand smoke break
Hi all,
Are there any size limitation for import file? I got
a dmp file Amin.dmp with 9706720291 bytes, when I
imported it, I got:
IMP-2: failed to open Amin.dmp for read
IMP-00021: operating system error - error code (dec
79, hex 0x4F)
Is the file corrupted or the file is too big?
Hi, Ross,
I've got some experience with both
1. You dont have transaction (until the very recent versions, at least)
2. You dont have fererential integrity (FK is declared but not enforced)
3. Dont have views
4. Noting like PL/SQL
5. Reader blocks writer
6. Weak type support, for example can put
Title: Help, processes won't die
It
could be rolling back. If so, you really do have to
wait.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 01,
2001 10:02 AMTo: Multiple recipients of list
ORACLE-LSubject: Help, processes won't
Title: Help, processes won't die
Ivan:
The problem is that there is no way to "wake up"
PMON. PMON is cleaning up and rolling back all uncommitted transactions every 3
minutes and this isn't configurable. If this is 8i, you could have used alter
session ... kill session immediate, although
sometimes the only recourse is to bounce the instance.
joe
[EMAIL PROTECTED] 08/01/01 01:01PM
I need some assistance ASAP. Our nightly batch process
seems to have hung up for some strange reason (ok no biggie my boss says kill it
and start it again). The problem is I have killed the
Fawzia,
Looks like you need to increase your SHARED_POOL_SIZE parameter.
These errors are on indication that Oracle is starving for memory, not that
the trigger will not compile.
My development DB is set at 80M. Try increasing your's to at least this,
higher if you have many people on the
Yeah, how about basic transaction support? Table locking is a problem when
the database/web site starts to experience a modest number of hits. We
migrate customers from MySQL to Oracle when there are performance problems
and they instantly disappear with Oracle.
MySQL is not ANSI SQL compliant
If you had SQL trace available - you would be able to find SQL for the
session. One time on this list I heard mention about x$trace - like it has
all data of the event 10046 trace only not in the trace file but in memory.
Anumbody has some infp about it?
Alex Hillman
-Original Message-
1 - 100 of 202 matches
Mail list logo