Title: RE: ORACLE 8i DBA
hi
Thanks alot I will Pick that Book today.
Have a nice day
with warm regards,
deewaker g v
-Original Message-
From: Brijesh Lal [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 11:47 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:
Thanks for your reply about the Reports parameter
Reg
G.SEnthil kumar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Senthil Ganapathi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Hi,
Within your *.sql script you can jump to the OS and give OS commands.
e.g: host sqlldr. (start with host).
I have used it with import and it works.
Jack
select *
from user_segments
is a good start..
hth
connor
--- Viraj Luthra [EMAIL PROTECTED] wrote: Hello
all,
How do I come to what tables are present in a
particular tablespace and then when I found the
table, can I come to know what amount of space it
consumes?
eg. I want to know
Hi Gurus,
I tried to drop unique index using ALTER TABLE table_name DROP UNIQUE
(column_name); unsuccessfully. How should I drop the unique index ? Please
advise. Thanks.
SQL SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT';
INDEX_NAME TABLE_NAME
From a money perspective - yes
From a resource perspective - no, using the
obfuscation toolkit does add lots of cpu to your
processing (if you're handling lots of rows)
hth
connor
--- [EMAIL PROTECTED] wrote:
We are in the process of upgrading most of our
databases to 8.1.7.1
(Enterprise
How can I find the logical or physical I/O size on a Sun Solaris machine ?
Thanks,
~aslam
application/ms-tnef
Hello if there any testing tools for QA staff / developer to test on bulk
data which can measure it performance,efficient.of the
program/PLSQL/sqlscript ???
The function of the tools is , prepare bulk data , testing , generate
report .
If no such tools , what might be an advice ?
Title: Number Vs. Varchar2 Datatype
Hi list,
We are in the design phase of our new database and eventually there a number of feilds which are actually numeric say DEPARTMENT NUMBER or EMPLOYEE CODE (they dont contain any alphabat or special character) ,
The main decision to be made right
HI ALL,
We have to load almost 3 millions records of average row size of 150 bytes.
We are importing data using sqloader with ROWS=4000 and bindsize=845 .
We have adjusted the rollback segment to almost 10 m with 8 extents enough
for single transaction size and considering 30% rollback
Title: Number Vs. Varchar2 Datatype
this always a better decision to
decide the datatypes of such columns keeping in mind the future
requirements.
u may come to a certain point where
u think, number datatype to be better and somewhere to varchar2.
u said number datatype which is not
always
Suggestion given by Magesh should work for a non-constraint index. If it is
index created by Oracle during the time when you created your unique
constraint you won't be able to get rid of that index until you eliminate
your constraint.
- Original Message -
To: Multiple recipients of
That's a laugh, I went to a continuing education seminar once at Carleton
University, in Ottawa.
The seminar was called Effective Living.
The teacher was a social worker, and he emphatically told everyone NEVER to
ask why, just adapt to life and keep moving...
I had unreconcilable
Hi,
Did you try :
SQL drop index index_name ;
??
HIH,
Antonio Belloni
CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]@fatcity.com on
30/05/2001 05:50:25
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Quick question..
ALL of my experience has been on UNIX platforms... Recently, I have been
asked to work on an Oracle DB that runs on NT.. My scripting capability in
the NT world is weak at best. So I am trying to compare ksh type
activities with the NT world. SO I was wondering if any of you
When you use privileges in stored procedures, you need to have the privilege
explicitly. In other words, you cannot get the privilege from a role.
If you do a grant create user to MyRole.
Grant myRole to myUser.
Then try to create user as myUser it will work, but if you try to create
user from
I have built Novell boxes that have 2100+ days of uptime :)
Now that is stability that I have yet to see even unix have.
Granted it is only Novell 3.12.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
Yes,
table is exclusively locked when ANALYZE ... VALIDATE. Until 9i, I
believe.
Vadim
Gorbounov
Oracle
DBA
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 7:22
AMTo: Multiple recipients of list ORACLE-LSubject:
There isn't any known bug under NT. But there are many memory leaks and
poor drivers, that tend to lead to early rebooting. In my experience.
I think the worst problem with NT is not the os but the drivers, even though
Even though I hate NT, for the money, it works well. But if you try to get
just my input.
where are the load metrics documented, meaning where does it say 5M or more
per session? i want to know for future reference.
we're putting in a solution, oracle 8i on windows 2000/windows 2000 advanced
server ~4-to-8G of RAM so there are options if you need additional RAM in
Hi Lee,
Compute option locks a table, but 'estimate' doesn't
Regards,
Ed
-Original Message-
Sent: 30 ??? 2001 ?. 15:22
To: Multiple recipients of list ORACLE-L
All,
Just a quicky !!
Anyone know if there are any locking issues while analyzing statistics for
objects ??
TIA
Ok, now I'm confused
One reply
-
It depends. For instance, 'analyze index validate structure' takes out
'shared' lock on the table (preventing inserts/deletes/updates), while
'analyze index compute/estimate statistics' does not.
Another
---
Compute option locks a
If it is an unique index that enforces unique constraint you cannot simply
drop it
You have to drop unique constraint
alter table tablename drop constraint constraintname;
an example follows
SQL desc qaqa1
NameNull?Type
---
I think thats the reason why we have two options - Estimate and Compute Statistics.
Rajaram.
-Original Message-
From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 7:22 AM
To: Multiple recipients of list ORACLE-L
Subject:Analyze table and
shouldn't be any problems running apache on the same server. at least
i've set up oracle on solaris 7 with apache installed.
Jon Baker
Database Engineer (1/5)
[EMAIL PROTECTED]
Rukmini Devi wrote:
Hi List,
SunOS
This person was actually allowed to teach. Never ask why, yes that's a
super philosophy on life.
-Original Message-
Patrice J
Sent: Wednesday, May 30, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L
That's a laugh, I went to a continuing education seminar once at Carleton
Azhar,
I agree with the other responses (more RAM, don't use OPTIMAL on your
RBS's) but would also suggestdropping all indexes except PK until the load
is done, therebuild them. Also, does this table have any
triggers? If so, if can you disable them during the load, that will help
speed
I would not recommend using optimal as it will cause the segment to have to
shrink. Your better of doing it manually on lulls of activity and size the
segments bigger if need be. Segments should not be frequently shrinking.
Walking on water and developing software from a specification are
It depends.
For instance, 'analyze index validate structure' takes out
'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze
index compute/estimate statistics' does not.
For more info see 'Practical Oracle 8i' by Jonathan Lewis -
very good book.
Igor Neyman, OCP
This is totally NOT accurate.
Yes there are performance gains storing index data ordered. Perhaps great
on range scans. Yes you can reorder tables and indexes.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
Title: RE: Creating a sorted table
That
is version specific, but you can use an index hint to do this in older
versions.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original
Uptime yes... BUT was there anything running on them as complex as a database?
Just joking. I have used Novell in the past ver 2.something and it served the purpose
very well. At my current work location we use 4.12 and it is okay at best. Upgrading
to 5.1 this year before we install a
that's not dropping a unique index, that's dropping a column!
to drop an index:
drop index indexname;
doesn't matter if it is unique or not.
If you are trying to drop a unique constraint, that's different.
first find the name of the unique constraint on that table
select constraint_name
On Wed, May 30, 2001 at 05:01:22AM -0800, Christopher Spence wrote:
I have built Novell boxes that have 2100+ days of uptime :)
Now that is stability that I have yet to see even unix have.
Granted it is only Novell 3.12.
Novell uptime:
http://www.theregister.co.uk/content/5/18265.html
Analyze index validate structure takes shared lock on the table disallowing any changes to the table or indexes. That's the only way to validate the structures.
In earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks. From 8 onwards, compute or estimate does not take any
Peter is right. Look at your SGA it's 285M. If you only have 128M on
the machine you are running your at least 75% of your db in swap. I
would recommend 512M MINIMUM on this system push for more if you can.
RAM is relatively cheap right now for intel machines get some. After
that you
Azhar,
Just two thoughts off the top of my head to improve loading of records:
1. Put database in noarchivelog mode to avoid redo generation (if
possible).
2. Drop all indexes on target tables (if possible), then load data, then
recreate all indexes on target tables.
Jim
Jim Hawkins
Lead
If you every try and knock a cat off of something when she really
does not want to go you will see that quite clearly. It really is quite
amazing (and annoying).
-Original Message-
Sent: Tuesday, May 29, 2001 7:12 PM
To: Multiple recipients of list ORACLE-L
NT-Domain\NT-User ?
Eric,
Yeah If you use compute statistics your table get locked and will take long
time, But If you use estimate statistics it will be fast But not as
accurate as before. Better to analyze at nights by setting time.
Raghu.
From: Robertson Lee - lerobe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Hi Bruce
As I understand ur server uptime is 242 days.Right!If this is the case then
Please reboot the server would solve this problem.The similar kind of
problem I faced in past.
Hope this will help u.If you would like to more information then please
visit metalink.
Thanks
-Seema
From:
Why putting DB in noarchivelog will avoid redo generation? There will be no
archiving, but redo will continue to be generated.
Alex Hillman
-Original Message-
Sent: Wednesday, May 30, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
Azhar,
Just two thoughts off the top of my
Ya, but I can keep a NT box for a long time to, if I don't touch it.
-Original Message-
Sent: Wednesday, May 30, 2001 6:01 AM
To: Multiple recipients of list ORACLE-L
I have built Novell boxes that have 2100+ days of uptime :)
Now that is stability that I have yet to see even unix
Diana,
You might wanna check out www.kx.com Those guys have
a lightning rocket of a dbms, and it is based, in part,
on storing data in search/sort-dependent order. (There is
a bunch of background data on the site itself.)
In any case, reading up on other dbms technologies has
a place in
Six years? No downtime in any way? That would be...uh.unusual.
I am sure the details are fascinating...do tell.
|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 9:01 AM
|| To: Multiple recipients of list ORACLE-L
||
Are you trying to find maximum size of the IO possible in Sun/Solaris ?
Kernel parameter maxphys parameter determines the maximum size of the IO
possible from the OS. By default, it is around 128k depending upon what
hardware you use(sun4d=124k, sun4u=128ketc ). If you user veritas volume
Not necessarily. 8i+ DOESN'T require _ANY_ lock to COMPUTE while collecting
statistics (99.99% of total operation time). It needs short lock to start
and complete analyze.
Regards
Vadim
-Original Message-
Sent: Wednesday, May 30, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L
Hi
On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get
Oracle db to work off of the tns_admin key. Only forms would work off of
the tns_admin, and without that key forms would not connect to the dbs.
Just thought I would mention that.
Kev
-Original Message-
Sent:
On 30 May 2001, at 8:10, Christopher Spence wrote:
This is totally NOT accurate.
http://www.amazon.com/exec/obidos/ASIN/B5BYQH
---excerpt---
Tales of the Arabian Nights Barbie and Ken
Our Price: $99.99
This item will be
mainekoon cats. Almost as big as dogs, and do pull sleds.
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, May 30, 2001 1:21 AM
To: Multiple recipients of list
Reminds me of a bad joke...
What did the farmer say when his tractor broke?
-Original Message-
Sent: Wednesday, May 30, 2001 12:03 PM
To: Kevin Kostyszyn; [EMAIL PROTECTED]
Just because!
Reply Separator
Author: Kevin Kostyszyn [EMAIL PROTECTED]
John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I
believe. RAID 5 will require additional writes by DBWR which is going to be
huge overhead during a dataload.
- Ethan Post
-Original Message-
Sent: Wednesday, May 30, 2001 6:51 AM
To: Multiple recipients of list
Hey, NT could be up for 2100+ days, I mean, by the time you get there it
won't even be able to play solitaire, but it will be up.
-Original Message-
Spence
Sent: Wednesday, May 30, 2001 9:01 AM
To: Multiple recipients of list ORACLE-L
I have built Novell boxes that have 2100+ days of
http://www.ultratech-llc.com/KB/Scripts/?File=Scripting.BAT
(also see bottom of this message for more URLs)
http://www.ultratech-llc.com/KB/?File=!Contents.TXT
--forwarded message follows--
[Date sent: Wed, 30 May 2001 10:32:11 -0400
To: Recipients of WINNT-L digests [EMAIL
Yeah, I'd say that proportion would have worked in my group too.
And when I interviewed others, I rarely got any great people
applying, and it's almost solely because at that level, dollars
were so much better as independents, and the only people who
wanted to come were visa-sponsors or relative
On Wed, 30 May 2001,Christopher Spence scribbled on the wall in glitter crayon:
-mainekoon cats. Almost as big as dogs, and do pull sleds.
and like laps. and if you don't make one for them, they just tangle your feet
till you fall down and then climb in your lap.;-)
--
Bill Thater
Many
thanks
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: 30 May 2001
17:10To: Multiple recipients of list ORACLE-LSubject:
RE: Analyze table and lockingAnalyze index validate structure takes shared lock on the table
disallowing any changes
If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple
folders, like:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1
then you have to create TNS_ADMIN string value (not key) in each of those
folders pointing to your master tnsnames.ora file.
We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6.
My manager needs a definitive answer. Is DBMS_OBFUSCATION
free with this version of Enterprise Edition server or is it part of an
extra-cost add-on.
All definitive answers welcome. I have a call in to Oracle but they
have not yet
Hi all
Can someone help me out here? I am getting this error when I try to run this
PL/SQL code from an ASP page.
The error manual just says to check speeling. I DID. Is there anything I am
missing? The DB is V7.3 I am trying to
return the resultset to the page.
PLS-00306: wrong number or
On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote:
should i give it all four arguments. but it still not executing saying
ora-06512
There are always other error messages accompanying an ORA-6512.
What are they?
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Its not a general Oracle or Unix thing because we had out AIX boxes up and
running Oracle 7.3.4 and 8.1.6 for many months at a time with no reboots.
-Original Message-
Sent: Wednesday, May 30, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L
Hi Bruce
As I understand ur server
Actually I say:
You know what the farmer said when the cow died?
Geesh, it never did that before.
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, May 30, 2001
I had the same problem. First, i realized that - it seems -
there are other things that will bump the PGA. For me it was
insert /*+ append */. However, after upgrading from 8.1.5 to
8.1.7 the problem went away.
Hope this helps, and your mileage may vary.
Good luck,
Yosi
-Original
Yeah, I think they've got a retention problem, since the money is
better outside, and consultants have a good idea of what they're
being billed for. But the internal resources are great, as are
their internal email lists.
Of course, now we've got much of their internal stuff on metalink -
if you
Ours is not to wonder why, ours is just to do or die!!
Reply Separator
Author: Kevin Kostyszyn [EMAIL PROTECTED]
Date: 5/30/2001 7:02 AM
This person was actually allowed to teach. Never ask why, yes that's a
super philosophy on life.
-Original
My suggestion would be to install cygwin
(http://sources.redhat.com/cygwin/).
-Original Message-
From: GLoughmiller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 8:25 AM
To: ORACLE-L
Cc: GLoughmiller
Subject: Script examples for NT. (yuk!)
Quick question..
ALL
Raid 5 can consume as much as 60% overhead for writes.
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, May 30, 2001 12:51 PM
To: Multiple recipients of list
Try changing to VARCHAR2(31) instead of VARCHAR(31). Although I know there
is no difference in varchar and varchar2 definition.
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
Isn't that sort of like Taoism? Accept your lot, there must be good in it
somewhere...
Also, it seems to be the basis of many major religions to essentially never
ask why. So, I guess it's a pretty popular philosophy.
(Oh no, I feel a discourse by Eric coming on...)
Diana Duncan
TITAN
Sean,
The indexfile parameter shows only the create table
statements (REM'd out) and the additional indexes (i.e
not indexes used to enforce PK constraints).
To see all the DDL, use the SHOW=Y parameter along
with LOG=filename.
HTH,
-- Anita
--- O'Neill, Sean [EMAIL PROTECTED] wrote:
I have used compute statistics since version 7.3.2 up through 8.1.6, and never
had it hold a table lock for the duration of the analyze. I don't know where
people are getting the idea that compute statistics holds a lock and estimate
doesn't. That just doesn't make sense. Why would compute
DBAs,
As a keyboard lover, hate to do this. But I need to study OEM.
Any good Books / URLs / DOCs / PDFs
Thanks in advance,
-Rahul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul Dandekar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Redo generation will not change. Just the archiving process, which on
improperly laid out file system can be very painful process.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original
I am using this parameter on 8.1.6.2 for the same bug: 1210242: CURSORS NOT
SHARED WHEN TIMED_STATISTICS=TRUE DESPITE FIX FOR BUG 918002.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 29 May 2001, Jerry C wrote:
Anybody have experience setting this parameter? It references a
Sure, and thanks. I appreciate the corrections, as one problem with doing
this for a while is the aggregation of useless and no longer true facts,
which I'm finding I have more and more of. They feel like barnacles. :)
I've finally decided to go get my OCP, which I hope will help scrape some
Cherie, I have no idea if this could be the case, but I noticed that the
type is based on the datatype VARCHAR, not VARCHAR2. According to the
docs, this shouldn't make a difference, but they've been warning since the
introduction of VARCHAR2 that they may do something different with VARCHAR
at
Either MS ODBC or Oracle driver can do the connectivity. I found out that MS
ODBC is more user-friendly.
Just my $0.02.
-Original Message-
Sent: Wednesday, May 30, 2001 4:30 AM
To: Multiple recipients of list ORACLE-L
Hish,
Crack out some manuals double quick - get some RDBMS
Indeses are not critical for the application to run..It just helps them run faster at
times. You could build you indexes with the no logging or unrecoverable option
and that will save on the archivelog creation. Just be sure to take a backup after the
indexes are rebuilt because you will not
It's free.
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
And then prepare to go bleary eyed reading it :)
while an indexfile produces a runnable sql text, show=y does not.
Lines are wrapped in the middle of words, appear everywhere.
But it will get you what you want to see
Rachel
From: A. Bardeen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Halo,
Windoz 2000/SQL Server 2000
Bringing an axuliary MS SQL db online. Trying to setup archiving. Am I
reading documentation right, SQL does NOT automatically archive transaction
log? This process must be setup via backup routine, which truncates the log
upon completion?
Lemme try some
Sorry - that's what I meant. No archive log generation. NOT no redo log
generation. Thanks for pointing that out. Is it Friday yet?
Jim
Why putting DB in noarchivelog will avoid redo generation? There will be
no
archiving, but redo will continue to be generated.
Alex Hillman
David,
What I'd want to see is the actual call you are making in the ASP code. Your
package is fine, the problem is with the variables (you have defined in the
ASP code), that are used when this procedure is being called.
If you can ensure that the variables have been declared as following you
It is a good point that it's a string, I actually knew that, but it still
doesn't explain why i can't get it to work. Not that it's that big of a
deal. I'll try again, no harm in that.
Kev
-Original Message-
Sent: Wednesday, May 30, 2001 12:36 PM
To: Multiple recipients of list ORACLE-L
David,
How are you calling this procedure? Into what structures are you receiving
the PL/SQL Out Arguments, which are PL/SQL tables? I'll bet that's your
problem.
Show us the code that calls this procedure and handles the output.
BTW, if you checked the speeling of your PL/SQL as well as you
Here is the ASP code
ccyy = 2001
set cn = server.CreateObject(adodb.connection)
set cmd = server.CreateObject(adodb.command)
set rs = server.CreateObject(adodb.recordset)
cn.ConnectionTimeout = 120
cn.CommandTimeout=30
cn.ConnectionString=DSN=db;UID=user;Password=pwd
cn.Open
Since Data is being loaded in development environment. that is why we have
128 meg ram. (Regarding RAM i have no other choice) i have the NT
performance monitor and it shows that it is not using swap heavily.
NT swaps heavily with 128Mb ram running office, you must have some sort of
magical
We use Clones of databases all the time. Its much faster than the
Export/import run. We simply take the DB down, copy the data files to a
new server in the same file layouts (i.e. ... same directory tree), copy
over and change the init file for the new DB name, and bring it up. Then
you have
Actually, I think following the Tao has more to do with being true, i.e.
being who you are, which also naturally meshes with where nature is heading.
Similar to other religions that tell you that if you follow certain
precepts, you will be purer and therefore will be closer to heaven, God,
Bruce, Jared folks,
See below for the info I was looking for yesterday (I gave
you the wrong site, sorry).
regards,
ep
cc: [EMAIL PROTECTED]
http://www.co-i-l.com/coil/knowledge-garden/vcfaq/facfaq1.shtml
version 0.9
FAQ Editor: George Pór
About this FAQ
Kim,
Did you hear the one about the NT box
that ran for SEVEN YEARS, playing solitaire?
Yea, me neither, but it's a good story, just
like the Novell one.
:)
|| -Original Message-
|| From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 12:36 PM
|| To:
Title: RE: Your views on Quest - Shareplex
-Original Message-
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
We are looking into the product as well, but have yet to even
toy with the product. There is a no chained rows
restriction.
I'm not sure what that statement
I think the error is in the call to the procedure, not in the procedure
itself -- the procedure looks fine at a glance. Could you post the ASP
code that makes the call?
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F:
http://www.cfainc.org/breeds/profiles/articles/maine.html
---excerpt---
The Maine Coon Standard
The Maine Coon Cat is a massive, broad chested cat with a long
rectangular body and the fur is long and flowing. The males
average around 12 to 15 pounds, with some going 20 pounds or
You can download CyGWin from Redhat for free that will give you a very nice
cloned shell of linux environment, full compatable with Bash/Sh scripting.
Wish i could find a ksh shell for it, but it has ALOT of the tools normally
available with Unix. ps, kill, grep, tail, head, piping, shell
Rahul !
I have not seen any **books** on OEM. But you can
check in to OLN (!!) Oracle Learning Network and there
are some classes on OEM.
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
No to be overly pedantic, but RAID5 does not change the number of write()
calls made by DBWR. It will change the number of disk operations done by
your hardware controller or your software raid drivers, but that's slightly
different.
- Original Message -
To: Multiple recipients of list
Yeah, but just because something is popular doesn't meen it is good. If we
all lived our lives that way everyday I am not so sure we would get much
accomplished?
Oh no, the Database is down!!
Why?
I don't know, who cares.
hehehe
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, May
I don't know what is causing this, but I would keep an eye on physical
memory available vs. commit charge in Task Manager, I strongly recommend
your commit charge never exceed your physical memory.
I found that Oracle sometimes refuses to even start services when it runs
out of physical memory,
And thus you discover the inane mechanism that SQL Server
inherited from Sybase, by which both try to do concurrency.
Guess what happens when a long running transaction marks
the log near the end, and not too long afterward the log
needs truncated?
If memory serves, ( hasn't worked too well
1 - 100 of 202 matches
Mail list logo