Ah, so you must have got the truncated list then !!
That was in the same catergory as the beaver cheese eating, mouseherd
baiting, weevil racing, bed wetters of the UK colonies.
-Original Message-
Sent: 23 May 2001 19:16
To: Multiple recipients of list ORACLE-L
yes, but i was sad that
Title: RE: Database Down
Woo
Hoo, well done and have a virtual (drink of your choice) on
me.
I know
it is really scary when you get thrown in at the deep end like this but if you
are anything like me, after this happened to me for the first time and I had, by
all means at my disposal, got
Similar to the one below. This can be mucked about with so it doesn't
prompt.
Regards
Lee
SCRIPT STARTS HERE
==
set heading off feedback off verify off
clear columns
clear buffer
accept ts_name prompt 'Enter TableSpace Name : '
col ord noprint
col res format a90
spool cr_tbls
ROFLMAO!
-Original Message-
Sent: 23 May 2001 23:02
To: Multiple recipients of list ORACLE-L
that was great
-Original Message-
Sent: Wednesday, May 23, 2001 5:36 PM
To: Multiple recipients of list ORACLE-L
I think we've stumbled on to something...
SQL> desc MICROSOFTDPRO
Title: Another Database Down
Have
you tried removing/moving the lk file in the $ORACLE_HOME/dbs
directory ??
Lee
-Original
Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: 24 May 2001 00:27To:
Multiple recipients of list ORACLE-LSubject: Another Databas
How can I generate from my schema, the SQL to re-create sequences, tables,
procedures, etc etc.i.e, not using import/export.
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Hi,
As I remember, there was a bug on Sun-A1000 with CPU utilizitation. There should
be an article of Erhan Odok on metalink which gives Sun's bug number.
regards...
Jared Still wrote:
> Run 'top' and see what the CPU hogs are. If they are
> Oracle shadow processes, check with the user that
>
Can you remove the comma between date and time to make it 1 field?
Simon Fox
Room 205, CRH
01270 533997
-Original Message-
Sent: 23 May 2001 22:41
To: Multiple recipients of list ORACLE-L
I am trying to load a file that has the fields comma-delimited,
variable length. A sample l
Hi,
has anyone encounted errors for the post built-in when the form is run
against 8i db?
I have a situation here, wherein, if I run forms 4.5 generated .fmx against
oracle 7.3 db, it works fine. But when I run the same form against 8i db,
the post built-in is generating the error "frm 40501: ora
Hi,
To rebuild the unixware kernel use idbuild -B and then restart your system.
Its been a while, but won't osh raise your ulimit?
HTH
tom
-Original Message-
Sent: Thursday, May 24, 2001 3:20 AM
To: Multiple recipients of list ORACLE-L
Kirti,
I have used ULIMIT=unlimited, ULIMIT=5
Thank you to everyone who responded to my request. I guess it's just a
limitation of sqlldr that it can't handle this without modifying the data.
Unfortunately, I can't have the source change their download, so I have to deal
with the data as I get it.
I did come up with a way to get arou
Hi,
Does anyone know how to determine how many times an index has been used or
if it has been used at all? I have seen previous attempts by taking
snapshots of v$sqlarea and then automating an explain plan and extracting
the information that way. I would have thought that there must be an x$
tabl
Since those are the last two fields in the data file, I think you can
use TERMINATED BY WHITESPACE on the field definition. Something like:
trans_date date(14) "mm/dd/yy,hh:mi" terminated by whitespace
> -Original Message-
> From: srcdco [mailto:[EMAIL PROTECTED]]
> Sent: Wedne
FYI,
Oracle Support responded as follows:
23-MAY-01 15:16:30
It looks to me that there are some misunderstanding regarding Oracle product
and components. Let me try to explain it to you.
- We don't have ideal pairs for any products from the usage point of view.
Forms and reports product manager
Hi Deepak,
I'd go with TOAD, why? well I have been using it since it was a freeware (we
bought it finally) and am very comfortable with what it does and how easy it
makes things.
Hats off to TOADMAN !
HTH
Raj
__
Rajendra Jamadagni
Glenn,
Oracle Apps is a very complex animal. It is extremely finicky and
hard to administer. A lot of stuff like flexfields are not intuitive at
all.
I don't blame them for wanting to find at least one very experienced
apps DBA to administer their apps.
Having said that, if you're interested
Chris,
It's just my opinion, but that regular blue font on blue background is a
little hard to focus.
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline
> -Original Message-
> From: Christopher Spence [SMTP:[EMAIL PROTECTED]
Viraj,
I do not recall if you need to rebuild the kernel to make the new ulimit
setting effective. Probably not, please check the system docs to make sure?
Is the ulimit set in any of the profiles for the user id (/etc/profile, or
.profile)? Also, have you tried to change it after logging in as o
I think PL/SQL Developer blows away Toad especially since it is only
$150-$50 depending on how many you buy compared to $750 buying toad.
AllAround Automations sells it. Anyone I have shown it to (SQL Nav users,
Toad) and they have "seen the light".
"Walking on water and developing software fro
Yesterday I went to add a new datafile and the command failed because I
already had datafiles = db_files value. No problem, I increased the
parameter and waited until this morning since this database is shut down
every night.
I ran the command this morning and discovered that the file was in in f
Hello,
Hi Ranganath,
This bug is specific to Sun E1 models when USE_ISM is set. It's
Note#77604.1. anyway, setting USE_ISM gains performance. But, if you are using
E1 models, see Note#77604.1. This bug causes Oracle block corruptions.
from Note#77604.1:
**
There are also cases
Ravindra,
Check out the supplied package DBMS_LOB.
The DBMS_LOB.GetLength function should give you the info. you want.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(
Rich,
If you do an export of the database FULL=Y DATA=N you will get a file that
contains the tablespace info and the storage info. You can then use this info to
create the new tablespace in the new database. This just lists the size information
and not the size consumed.
ROR mª¿ªm
>>> [EMAIL
Cool! Just the way cholesterol works when there is not
enough Vitamin C to make collagen to repair cracks in
blood vessels!
www.paulingtherapy.com
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 23, 2001 6:57 PM
|| To: Multiple recipients
If anyone receives mail from this individual, please scan any attatchments
as it contains the W32/BadTrans@MM vi*us...
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you tra
couple of things to check before you do anything with this file:
first, select from dba_data_files to see if Oracle thinks the file is in the
database.
second, at the OS level (this is Unix, yes?) go to that directory and do an
fuser on that file. If no processes show up, the file is not bein
Scott,
Suggestion, instead of exporting & dropping the table, rename it. Takes
much less time in either direction and provides the same end results.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 5/23/2001 1:15 PM
The developer cr
Too be safe, rename it to datafile.old. Add your datafile. Later, after you tested
shutdown/startup, etc. of your db, then delete your old datafile.
>>> [EMAIL PROTECTED] 05/24/01 10:15AM >>>
Yesterday I went to add a new datafile and the command failed because I
already had datafiles = db_fil
You can combine two data fields into one column with sqlldr, but I think both
fields have to be in the table.
Example:
SQL> desc x
Name Type
-
TRANS_DATEDATE
F1CHAR(8)
LOAD DATA
INFI
Hi List,
As a regular maintainance work,I have moved the listener.log file to
listener.log.old
and 'touch'ed the listener.log, expecting the logging into this new file.
But I am observing the logging being done to listener.log.old, instead.
I could not recall any such previous experience.
FYI, I c
This is a test.
* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman
Laura,
Seems like you've gotten one suggestion on the lk file(s). The other that I
would suggest, and this has worked for me in the past with OTS's help, is:
shutdown abort
startup mount
recover database until cancel
alter database open resetlogs
shutdown
Dick
Title: Virus Warning
I received an email from Bunyamin K. Karadeniz in response to an earlier 'Database Down' message that I had sent to the list. The email from him had an attachment to it. I opened it (I know this was not wise) and our virus scan had deleted the file and left a message sta
Hi All,
This is more of a network admin question, but I figured I would toss it out
there and see what everyone thought. I currently have a Dell Precision 410
PIII 600 being used as a sort of file server. It basically houses a shared
drive (IDE) and some other IDE drives used for DB back
On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon:
->Hi List,
->As a regular maintainance work,I have moved the listener.log file to
->listener.log.old
->and 'touch'ed the listener.log, expecting the logging into this new file.
->But I am observing the logging being d
Test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Francis,
I'm going to make the assumption that your using a DBMS_PIPE and not
something else (not much of a JAVA programmer here) because you stated that
shutting the database down "fixed the problem" at least for the time being. In
my use of pipes inside Oracle, I have never seen one "break
That's true, It also will not work for 8i temp tablespaces using the
tempfile syntax. I just checked it against a small 8.0.5 system.
> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 10:00 PM
> To: Multiple recipients of list ORAC
Hi Rachel,
As mentioned, I had checked DBA_DATA_FILES and it wasn't there. Hadn't
thought to use fuser, that also showed no one accessing it so I just issued
the command with REUSE and it worked fine.
Thanks!
Jay
-Original Message-
Sent: Thursday, May 24, 2001 10:51 AM
To: Multiple re
I would like to ask the list any good books available on Apps db
installations, Concurrent Managers etc,
Suren
-Original Message-
Sent: Thursday, May 24, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L
Glenn,
Oracle Apps is a very complex animal. It is extremely finicky and
ha
Title: troubleshoot broken pipe
is this the sort of message created if the remote network interface
oracle is listening to is shutdown?
rf
-Original Message-From: Francis, Rick
Sent: Wednesday, May 23, 2001 5:21 PMTo: Multiple
recipients of list ORACLE-LSubject: troubleshoot
I think it is only safe to restart the listener when using dedicated not mts. I know
on OpenVMS, you have to restart the db when restarting the listener using mts. Never
tested on unix. I prefer dedicated, never use mts, too many problems. Just buy more
RAM :).
>>> [EMAIL PROTECTED] 05/24/
Hi Deepak,
This is a good one, we use SQL* NAVIGATOR and TOAD, 2 cents are that on the
developer side SQL*Navigator would be a more complete tool, specially if you
buy all the bells and whistles available (SQL formatter, Knowledge Base
...), and TOAD would be a better tool on the DBA side of
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
I know it is not very significant but the
I believe the virus on his system is sending response mails without his
knowledge. I posted two messages to the list yesterday afternoon and got
two messages from him. By looking at the headders these are coming directly
from his system not from the list. I have e-mailed him directly to have hi
I would take a look at my controlfile first. Issue a "alter database backup
controlfile to trace;".
Take a look at two things:
1. What is your maxdatafiles set to?
2. Does this new datafile appear in the datafile list?
If it doesn't, I would not delete this datafile, but just rename it so you
What is this mythical PL/SQL Developer and who makes it. We currently use
TOAD and sqlnav and LOVE'em, i would be interested in a comparison
Kev
-Original Message-
Spence
Sent: Thursday, May 24, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L
I think PL/SQL Developer blows away
Yes, either will work. I would personally prefer the reuse option, but that is
just
my preferance.
Terry
"Miller, Jay" wrote:
> Yesterday I went to add a new datafile and the command failed because I
> already had datafiles = db_files value. No problem, I increased the
> parameter and waited
Selectively, to individual email addresses. Or is everyone getting hit?
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer
9iAS is a royal pain in the keister. Course I just spent 2 16 hour days
trying to uninstall the Forms and Reports piece and reinstall it from the
9iAS CDs (can't be done from what I can see, have to uninstall all of 9iAS),
so it's not my favorite thing. We have it installed on Solaris. I didn't
Yes it will fail, which is why I was looking for a script, which Paul Drake
had kindly sent me. Thx Paul!
Now all I need is for us to find out which disk on our test box RAID has
failed so we can recreate the DB.
Rich Jesse System/Database Administrator
[EMAIL PROTECT
Title: Another Database Down
No, I
did not know about this. Could you explain or tell me where I can find
info on this?
Laura
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 3:51
AMTo: Multiple recipients of list
Title: Virus Warning
I had
a feeling that was a virus. I received two of them this morning as well,
the first thing that caught my eye was that there was no time stamp in the
"sent" field, I was immediately sketchy. Then I noticed that it was also
sent directly to me and not to the list, a
fyi, see below for how Trend Micro's Viruswall (SMTP gateway scanner)
handles things:
( www.trendmicro.com , http://www.antivirus.com/products/isvw )
> Received: from SpoolDir by DSS_486 (Mercury 1.46); 24 May 01 00:50:16 -0700
> Return-path: <[EMAIL PROTECTED]>
> Received: from cliff.csus.edu (
I have created a trigger on a table to write information to a history table,
and I've run into some behavior that's confusing me...some clarification
would be greatly appreciated.
My trigger code is as follows:
CREATE OR REPLACE TRIGGER endb.budget_total_amt_hist_trg
BEFORE UPDATE of tot
I did not understand why but my computer
started to send messages to people which are virused.
Sorry from everyone.
Bunyamin
The command that worked was
ALTER TABLE table MODIFY column NULL;
This removed the NULL constraint but did not affect the data in the
column.
Chris
"Deshpande, Kirti" wrote:
>
> Kevin,
> I don't think so. Here is what happens with a 8.1.7 database.
> SQL> create table t (ca varchar2(2) not n
On Thu, 24 May 2001,Gene Sais scribbled on the wall in glitter crayon:
->I think it is only safe to restart the listener when using dedicated not mts. I
know on OpenVMS, you have to restart the db when restarting the listener using mts.
Never tested on unix. I prefer dedicated, never use mts
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Try the following which is a slightly ame
Title: MS access
Hi, List
Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true?
thanks
Li
Hello all,
My mini-me (aka
Junior DBA) noticed a core dump this morning. Good, attention to
detail. However, there's no unusual errors in the alert log for either
databases on this host and there's no errors in the listener log at all.
The core dump says something about pseudo cursor
Title: Another Database Down
From Metalink,
In Oracle releases before 7.3.3 on Unix it was possible for
two instances to mount the same database using different values for
ORACLE_SID when not running in Parallel Server mode. This could cause
database corruption as two independent inst
Oracle responded as follows, when I asked them about that statement re. the
Oracle home:
If you are going to install 9iAS-Enerprise edition on Unix then there is no
problem but if you are going to install it on windows then it should be in a
separate Oracle_home as documented in the release note
I have been knowned throughout many areas by that handle, I registered the
site so I had it. Eventually I am ordering two other names that will link
as well.
It is actually really my home page although I put more focus on the oracle
piece of it than the personal. Those who look at it depite the
Title: MS access
If
it's true use an Oracle Database...hehehhhehhh...Just
kidding...sorry:(
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Li, XiangliSent:
Thursday, May 24, 2001 11:57 AMTo: Multiple recipients of list
ORACLE-LSubject: MS a
Hi,
Thank you all for showing me how to check the Unix
memory. Is there a way to show how much is used and
how much is free?
Thank you!
Janet
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
http://www.allroundautomations.nl
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday, May 24, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L
What is this m
Kevin,
Should work just fine. I've been using an old HP with a P11/100 for the
same purpose these last two years.
Dick Goulet
Reply Separator
Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
Date: 5/24/2001 7:56 AM
Hi All,
This is more of
MTS is quite stable from 8.0.5 up. One persistent limitation is the fact that
SQL*Trace output for a session is scattered across the various shared server
processes. Oracle's developers say that they eventually will provide a solution
for this limitation, but it is not forthcoming in 9.x.
As of
sar -r reports available memory, averaged for today.
You can add start/end times also.
Or you can run it right now: sar -r 2 10,
tells sar to return memory information every 2 seconds,
and do that 10 times.
Sar also provides cpu utilization and disk activity data. Take a look at
the sar
Title: RE: Maximo
Thanks
Chris,
Did
you turn on MTS on your production server? Is that
recommended?
In our
environment, the system was fine on dev server which is not using
MTS, another DBA who is in charge of production server turned MTS on
and found the performance is 4 times slower.
How many people
opened the apology from Bunyamin ??
:-)
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereb
Title: MS access
Li,
1GB
for Access would be huge...and cause very poor performance. The only way
to overcome the size limitation is to upgrade to a real database...preferably
Oracle, but that SQL Server thing would work as well for a DB that
size.
Ed
Haskins
Oracle
DBA
Verizon Wirele
Title: RE: Listener.logwriting to renamed file
Reload doesn't close/reopen the file. Here is a couple solutions
How's about a fast cat/clear solution:
#!/bin/ksh
cat listener.log >>listener.log.hist
ex listener.log <
1,\$d
wq
EOF
Or if you wish to purge 90% of the file:
#!/bin/
Title: MS access
Hi,
Favour
me in suggest a hint in writing a sql for following
scenaio:
Table
A has 2 columns ord_id and line_id
example rows are:
ord_id
line_id
17
null
null 42
Table B has columns ord_id and
line_id
ord_id
line_id
Never used EasySQL unfortunately.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday, May 24, 2001 11:23 AM
To: Multiple recipients of list ORACLE-L
how might you c
Li,
I haven't worked with MS Access, but I did work on a
few projects converting MS Access application to
Oracle application exactly because MS Access can't
handle large amounts of data. The anser to you
question may very well be - move to Oracle (or any
other more powerful tool)
HTH
G
--- "Li,
Migrate to ORACLE !
< sorry could not resist t>
"Li, Xiangli" wrote:
Hi, List
Is there anyone happen to know what's
the database size limitation for MS access97? I heard it's 1 gigabytes,
how to overcome it if that's true?
thanks
Li
begin:vcard
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
Hello Gurus
Please help me in dropping and recreating the
snapshots. what happened was.
I had connection down between we adn the destination,
when the connection came alive , I tried to do
following to refresh the snapshots.
1- exec dbms_job.run(153)
This did not do any good so I tried.
Kevin!!!
Li,
In reality Access does have a file size limit, but I believe it is much
lower than 1GB. Regrettably there is no way around it, except as Kevin stated
to use a pass through query to Oracle. One should understand that Access is
designed as a single user system that gets bastardiz
Title: RE: memory question again ???
Here is a little C program that works on Solaris:
$ sysconf
Memory->total=5120M free=1596M pct=31 pagesize=8K CPU->total=6 online=6
$ cat sysconf.c
#include
#include
main()
{
int wk1, wk2, wk3, wk4;
long total_pages, free_pages, pagesize, total_
In 8.1.6, you don't have to have the one column in the database. Use
'FILLER' as the data type.
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]
Title: MS access
I
believe it is 2gb.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: Li, Xiangli
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 11:57
A
hey now
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jake MacGruder
INET: [EMAIL PROTECTED]
Fat City Network Ser
A coworker of mine discovered this a few weeks ago on a Sun box. No
difference there!
> -Original Message-
> From: Gsais [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 11:36 AM
> To: ORACLE-L
> Cc: Gsais
> Subject: Re: Listener.logwriting to renamed file
>
>
> I think i
Yes it is very much so. I am redoing a new interface, unfortuntely although
I am stupid, I have no creativity. I think too logically.
I have a few friends of mine that will help, I have left the color scheme
for now until I get some better idea.
Been playing with Photoshop and ImageReady trying
Hi Gene,
>However, when FTP'ing using the oracle user id, it aborts at
>1gb. I guessed the ftp daemon used some other user id for
>this. Wrong ( well maybe). I changed the default limits to
>unlimited for all users (i.e. default) and deleted the oracle
>user id from /etc/security/limits fi
I love the fact that you corrected the
spelling in your sig.
There is hope!
:)
|| -Original Message-
|| From: [EMAIL PROTECTED]
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 24, 2001 12:56 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: BUNYAMIN POSTS HAVE A VIRU
Title: RE: MS access
Hi , DBAs
Thank you veyr much for all replies. I think I have to go for oracle.
rgds,
Li
-Original Message-
From: Haskins, Ed [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: MS
Yes, this is exactly the error that occurs when you run a version of 4.5
that has not been patched to work with 8i. This is because of the rowid
format change in 8i -- the rowid is used for locking in forms.
You need to upgrade your version of 4.5 or convert to 6i. I believe there
is also a way
I would like to know how to obtain a trial or developer version of the
Oracle Applications Suite...
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch
Janet,
I'll try to show you with one of our larger Hp's:
VMSTAT takes a number of parameters, my favorite are:
Report memory status every 5 minutes for 5 reports. The AVM column gives
available real memory. The FREE column indicates the amount of real and virtual
memory that us available.
Officially there is no max, but realistically, as you
get close to a gig you start having serious issues. MAJOR performance
problems, increased crashes, a nightmare. Time to consider something more
robust, and honestly SQLServer is probably the way to go
<_BLASPHEMY>. The syntax matches
wait, where are my boots ?
Dilbert's "Mission Statement" generator:
http://www.dilbert.com/comics/dilbert/career/bin/ms2.cgi
"The customer can count on us
to completely maintain
market-driven meta-services
in order to competently
engineer inexpensive data
because that is what the
Lisa,
I would at least do a stack trace to find out what is causing the core
dumps. Then you will be able to see if they are really benign. We have core
dumps that happened in 8.0.6 that OWS said would go away with 8.0.6.3.
This was the reason I needed to apply the patch. The developers didn't
James,
In general I notice that MTS can slow things down IF there are not enough
shared servers running so that at least one server is constantly idle.
Dick Goulet
Reply Separator
Author: "James Xing" <[EMAIL PROTECTED]>
Date: 5/24/2001 9:36 AM
Title: RE: Listener.logwriting to renamed file
May I know how to clear the content of listener.log without restart listener on NT platform ?
thanks.
Li
-Original Message-
From: Brian MacLean [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 1:42 PM
To: Multiple rec
Kevin,
I'm confused, are you talkin' file server or db server,
or both on one machine? is this NT or Win2K?
If db server, what are you using it for? prod, dev, test...?
(& what backup/restore hardware is going to be used?)
regards,
ep
On 24 May 2001, at 7:56, Kevin Kostyszyn wrote:
> T
Brain, thank you very much , your scripts worked well.
Also thanks to all who responded/responding to my question.
Suren
-Original Message-
Sent: Thursday, May 24, 2001 1:42 PM
To: Multiple recipients of list ORACLE-L
Reload doesn't close/reopen the file. Here is a couple solutions
1 - 100 of 166 matches
Mail list logo