Gaja is correct. I had big problems recently with a highly concurrent
application selecting from DUAL too many times, resulting in an extremely
hot DUAL table. I wish I had knew this trick a few weeks ago. As it was, an
bit of application tuning sorted it out.
Jim
-Original Message-
Kri
Let the outer-most calling process handle COMMITs
and ROLLBACKs. A stored procedure should concentrate only on
passing back error conditions appropriately.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, April
I think there is a completely different level at which
to view this issue.
If your application is using dual "like there is no tomorrow"
then there is almost certainly something wrong with
your application design or code which is a much
more significant threat to performance - both through
bottl
How do I list all user accounts created in a database? And how do I list
all user table indexes?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505
>-How do I list all user accounts created in a database?
SELECT * FROM DBA_USERS
>-And how do I list all user table indexes?
SELECT INDEX_NAME FROM DBA_INDEXES WHERE OWNER = 'MY_LUSER'
Dave
-Original Message-
Sent: Wednesday, April 24, 2002 11:24 AM
To: Multiple recipients of list ORA
David,
Look at DBA_USERS, DBA_TABLES, DBA_INDEXES and all other DBA_* views. All
the info you are asking about is provided in these views.
User: Select username from dba_users;
Indexes: select table_name,index_name from dba_indexes where owner not in
('SYS','SYSTEM')
Hope this helps.
Tom Mer
So, do you remember the other top 10 items??
Robert
-Original Message-
Sent: Wednesday, April 24, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
please
n
it was also mentioned at the Oracle of Oracles closing session, in the
"top 10 things I learned in San Diego" :)
--- Car
David,
Basic sqlplus as the dba.
Select username from dba_users;
select owner,index_name from dba_indexes there owner not in
('SYS',SYSTEM');
Brush up on your reading skills.
ROR mô¿ôm
>>> [EMAIL PROTECTED] 04/24/02 12:23PM >>>
How do I list all user accounts created in a database? And how do I
Based on documentation, OPTIMIZER_INDEX_COST_ADJ seems to provide additional
comparison information for the CBO in terms of the relative cost of
different types of I/O. To make a long story short, I believe that guidance
can come from examining timing statistics from the wait-events "db file
scat
crontab -e
On Wed, 24 Apr 2002, bill thater wrote:
> [EMAIL PROTECTED] wrote:
>
> > Anyone whom can tell me how to delete a job that is created by crontab.
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
>
> man crontab
>
>
> --
> --
> Bill "Shrek" Thater ORACLE DB
I'm writing a stored procedure to be run by the dba. I want to provide the
ability to manipulate data from a schema specified at runtime. I have the
schema owner as an input variable, but I see three possible way to do this:
1) have the dba verify that all necessary DML privs on that schem
Hello Gaja
I checked the report from YAPP and library cache load lock accounts
only to 0.75% of the wait time. 28 seconds during 6100 seconds between
snaps.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2
Best place to look is probably Tim Gorman's paper
titled something like 'The search for intelligent life'.
To be found on www.evdbt.com
His argument, which I think is very sound, is that
the "most correct" value for the parameter is
the relative cost of a single block read compared
to a multi bl
Do you know of any reason that keeps Oracle implementing dual the way they
have now and its effect on all the other PL/SQL functions?
Also I saw something on the Metalink where some one inserted many records in
dual and when selecting count(*) from dual it returns the right count but
when selecti
Hello
What version of toad are you using.
I downloaded version 7.2 a few days
ago.
Connected as sys, activated schema browser and got
all sys tables in the list.
I also got all the users in the drop list to select
user.
Yechiel Adar
Mehish
- Original Message -
From:
[EMAI
This was posted on Quest/Revealnets DBA Pipeline (by Andrew Simkovsky)...
Sounds like a major security issue. I have tested this on 9.0.1.2 and it is
a real issue:
Someone recently sent me some information regarding a possible security flaw
with Oracle's ANSI-compliant outer join syntax in Orac
Select * from all_users
Volker Schoen
INPLAN RUHR
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 24. April 2002 18:24
An: Multiple recipients of list ORACLE-L
Betreff: SQL question
H
Here's one that answers both questions in one query:
SELECT u.username, i.table_name, i.index_namd
FROM dba_users u, dba_indexes i
WHERE u.username = i.owner (+)
AND u.username not like 'SYS%'
This will show all users and IF they have a table with an index, it will
display these as well.
Hi,
I've worked on loading data into the database. By mistake, I have a typo in table attribute that needs to be fixed.
Please help me how to write an sqlplus to correct my misspelled word or delete the generl_description attribute not the whole table.
Here is an example of my table PART
Part_id
I may be mistaken, but I think this is a few days old already.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
The acess path knows about DUAL and that it will return only 1 row. Create any
dual table under another user and you will see that it returns all rows.
Anjo.
"Khedr, Waleed" wrote:
> Do you know of any reason that keeps Oracle implementing dual the way they
> have now and its effect on all the
Alternatively, you size it until redo_log_space_wait
goes away from v$system_events.
-Original Message-From: Anjo Kolk
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 24, 2002 4:59
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
LOG_BUFFER Parameter QuestionYep,
w
My understanding was that EMC does not stripe its
disks. they just have mirror and RAID S.
--- Sr DBA <[EMAIL PROTECTED]> wrote:
> Why would you software stripe it if you are using
> EMC?
> - Original Message -
> From: "Johnson Poovathummoottil" <[EMAIL PROTECTED]>
> To: "LazyDBA.com Dis
On Wed, Apr 24, 2002 at 10:12:22AM -0800, Gogala, Mladen wrote:
> Alternatively, you size it until redo_log_space_wait goes away from
> v$system_events.
it is v$system_event
>
> -Original Message-
> Sent: Wednesday, April 24, 2002 4:59 AM
> To: Multiple recipients of list ORACLE-L
>
Now they have hardware striping.
Regards,
Waleed
-Original Message-
Sent: Wednesday, April 24, 2002 2:29 PM
To: Multiple recipients of list ORACLE-L
My understanding was that EMC does not stripe its
disks. they just have mirror and RAID S.
--- Sr DBA <[EMAIL PROTECTED]> wrote:
> Why
One I know was "bring a coat to San Diego"
for those of you not at IOUG, San Diego, a city that is supposedly warm
was COLD and everyone was freezing there
they added a "zero" -- when you go to Tijuana, don't drink the water"
I don't remember the rest
--- "Freeman, Robert " <[EMAIL PROTECTED]
Hi All,
I need to write a report on the health of a database.
Please send if any of us have a scripts and any report format for the health
of the database.
Thanks in advance
Praveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Praveen Sahni
INET: [EMAIL PROTECTED]
"man kill"
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 9:29 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Cronjob
>
> Anyone whom can tell me how to delete a job th
Waleed,
That's interesting. I just looked at the emc site and
still do not see anything that would lead me to
believe that they support hardware striping except for
the IBM Sequential Data Striping.
This was for the Symetrix 3000, 5000 & 8000 line.
I would be keenly interested to know as we hav
Look at the attached email message. There was a thread of discussion about
this a month ago.
Anyway I am going to test it on a small scale in one of my projects.
I was told that 1MB (one track) stripe size is the smallest efficient size
we should have b/c EMC will read 1MB anyway (one track) even
Do a search on Google -- you'll find plenty.
-Joe
--- Praveen Sahni <[EMAIL PROTECTED]> wrote:
> Hi All,
> I need to write a report on the health of a database.
> Please send if any of us have a scripts and any report format for
> the health
> of the database.
> Thanks in advance
> Praveen
> --
Try this link:
https://powerlink.emc.com/MediumFreq/21110_Symmetrix_3930_5930_Installation_
Manual.pdf
starting from page 155
Waleed
Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the company
-Original Message-
Se
crontab -r
...
[EMAIL PROTECTED]
Hello Yechiel,
Not sure what you mean...I was referring to the "cache
buffers chains" latch in my note NOT the library cache
load lock.
Gaja
--- Yechiel Adar <[EMAIL PROTECTED]> wrote:
> Hello Gaja
>
> I checked the report from YAPP and library cache
> load lock accounts
> only to 0.75% of the
It's interesting that you should have heard that.
My first interpretation of the optimizer_index_cost_adj
was that it was an estimate of the table logical I/O that
would become physical I/O (and ignore the fact that
this was allowed to go above 100%) - which brings
it into line, somewhat, with th
Title: RE: Currval and buffer gets
On
HP-UX:
model
= 9000/800/N4000-55OS release level= B.11.11processor count = 8clock
speed = 550
MHzmemory = 16384
Mb
SQL> set serveroutput on size
1;SQL> @test.sql 27 /run time using view x_$dual
in centiseconds=600run time u
Personally, I think that many folks go a bit overboard when
it comes to checking the health of a database.
These are the things I like to check for:
* is the database up? this is the most important tech check
* status of jobs in DBA_JOBS
* space issues. Will a table be able to extend N times
sqlplus "/ as sysdba" < -Original Message-
> From: Praveen Sahni [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 3:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Any scripts to check the health of the database
>
>
> Hi All,
> I need to write a report on the heal
> Thats fine for expensive sql...but waits can be a
> whole lot more than that...
Agreed. I'm just asking about "db file scattered read" and "db file
sequential read." What's the purpose of using the wait interface to
investigate these two events?
The accounts I've read of drilling down throug
Can you post this script inline as the list strips attachments.
> -Original Message-
> From: Sergey V Dolgov [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 2:58 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Memory?
>
>
> Hello Clinton,
>
> Here is script fo
Robert,
Jonathan Lewis posted this security issue last week.
Jared
"Freeman, Robert " <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 10:23 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
crontab -e is bad!
1000 points if you can figure out why.
( guess I'm watching too much 'Whose Line Is It Anyway?" )
Jared
Alex <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 10:07 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTE
I'm trying to evaluate tools for pl/sql coding/debugging - main options seem
to be toad, sql navigator (both from quest) and rapid sql (from
embarcadero).
One nice thing I noticed about the embarcadero product is the ability to
debug anonymous blocks . . .but haven't looked seriously into other p
>> I don't remember the rest
Was that because of the water in Tijuana?? :-))
Sorry I missed out on that, but I got otherwise
involved in something.
RF
-Original Message-
Sent: Wednesday, April 24, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
please
n
One I know was "bring a
Ahhh I was at IOUG-A and didn't see itDon't
remember seeing it in the MOUNTAIN (!) of messages
posted here while I was gone...
But anyway, just trying to do my duty as a good
Oracle citizen of the world! :-))
RF
-Original Message-
Sent: Wednesday, April 24, 2002 4:17 PM
To: [EMA
Agreed! No arguments there. I am all for designing and
writing scalable code from the starting block and
avoiding wastage of resources. But sometimes the
problem is much more complex. I am sure you have
inherited "bad application design" or "bad code"
enough times, and may I add "Not by choice". A
Hello all,
Again I am sending this to the list because people on the list in the past
have asked me for job leads in Florida. Jared, If this is not welcome,
please let me know.
I was just contacted about a job posting in Boca Raton for a
Peoplesoft/Oracle DBA. Here's the description:
"They h
On ORACLE 8163/Win2K , I got some interesting results
though...
ONE SESSION ONLY
SYS@ZETA@RSAKTHI>
run time using table dual in centiseconds=400
PL/SQL procedure successfully completed.
Elapsed: 00:00:03.75
SYS@ZETA@RSAKTHI>
SYS@ZETA@RSAKTHI>
TWO CONCURRENT SESSIONS
SYS@ZETA@RSAKTHI>/
run t
Title: RE: Cronjob
A wrong keystroke could blow away the entire crontab file by accident. %:|
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Cronjob
crontab -e is
Hello:
I would like to know if the Oracle Express feature of Financial Function
Calculators
are available with Oracle enterprise Edition 9.0.1.0.0.
If my memory serves me correctly , I think Oracle has incorporated OLAP
services as part of
the 9i database enterprise edition. But I am not cer
So you wipe out a few jobs in the crontab. Big deal! It just means your
sysadmin has to stay up late explaining my backups and payroll didn't run.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:
You'll lose your entire crontab if you do a crontab -e when /var is full?
(I've had this happen to me on HP-UX...)
Marc Cure
Oracle DBA, OCP 8i
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
crontab -e is bad!
10
love it! - this gets my vote -
-Original Message-
Sent: Wednesday, April 24, 2002 4:58 PM
To: Multiple recipients of list ORACLE-L
sqlplus "/ as sysdba" < -Original Message-
> From: Praveen Sahni [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 3:24 PM
> To: Multip
-e Edit the current crontab using the editor specified by the
VISUAL or EDITOR environment variables. The specified editor must
edit the file in place; any editor that unlinks the file and
recreates it cannot be used. After you exit from the editor, the
modified crontab will be installed a
If you crontab -e and a job is scheduled to run during the time that you are
editing, then the job doesn't execute while you are editing. No jobs will
execute while you're in crontab -e. Even if you :w your changes. No cronjobs
will execute while the editor is open so don't forget to close that ed
Greg,
You wrote:
If your goal is to find SQL that does a lot of physical reads, why
not
forget about these two events? Just go to v$sql and sort by
physical reads.
Now you have a comprehensive picture of what's going on.
One of the problems with that is that you assume that 100 I/Os are always
f
Thanks all who replied to my E-mail.
Right now I am still leaning toward having a centralized monitoring script
running in a admin database because -
1. Ease of administration
2. We don't need anything fancy, don't need application level monitorin, so
the requirements for different databases are
> "db file scattered read" (associated with FULL
> table scans) and "db file sequential
> read" (associated with indexed scans)
But see, Tuning 101, p. 35, where a "db file sequential read" is
investigated and the waits are found to be reads from a *table*.
And other examples elsewhere, where
www.evdbt.com/library.htm has a health check script
--
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: (858) 538-5051
San Diego, California-- Public Internet access / Maili
Jared,
You owe me 1000 points. And I know someone who did a crontab -r (so far from
'e' and yet so close!); lots of fun after that deletion.
I always usecrontab -l > crontab.mmdd
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL P
> -e Edit the current crontab using the editor specified by the
>VISUAL or EDITOR environment variables. The specified editor must
>edit the file in place; any editor that unlinks the file and
>recreates it cannot be used. After you exit from the editor, the
>modified crontab will be instal
Come on, Jared, its more fun to:
crontab < /dev/null
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 4:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Cronjob
>
>
Let's see, I do recall that changes made with crontab -e aren't always
applied (think this was Solaris 2.5).
[EMAIL PROTECTED] wrote:
>
> crontab -e is bad!
>
> 1000 points if you can figure out why.
> ( guess I'm watching too much 'Whose Line Is It Anyway?" )
>
> Jared
>
> Alex <[EMAIL P
Hello Seema,
It seems you are trying to run REFRESH every minute (1) instead of very
hour..
Use
start with sysdate next sysdate+ 1/24
Instead of
start with sysdate next sysdate+ 1/(24*60)
HTH
Nikunj
>From: "Seema Singh" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recip
been there done that.
crontab -l > /tmp/c.c
vi /tmp/c.c
crontab /tmp/c.c
joe
Marc Cure wrote:
>You'll lose your entire crontab if you do a crontab -e when /var is full?
>
>(I've had this happen to me on HP-UX...)
>
>Marc Cure
>Oracle DBA, OCP 8i
>
>
>-Original Message-
>[EMAIL PROTE
SORRY
crontab -e
"Ivan Llamoca"
I see a couple of folks who want to
know how to flush the pool or are looking
for a script to do it automatically.
Shouldn't we be asking what is causing
the behavior that got us to this quandry
in the first place ?
Just a stupid question .. I know !
Peace !
Mike
--
Please see the officia
no, the Tijuana trip we were very careful not to drink the water (hm,
that left only alcohol!)
I just didn't write them down, was having too much fun just listening
to them
--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> >> I don't remember the rest
>
> Was that because of the water in Tij
Hi,
I've tried to load data into a table with a data type number(5,3). For any reason, the system just rounded off the decimal number. It inserted the number 2 into the table instead of 1.5. Please direct me how to fix my problem. Your help is greatly appreciated.
Thanks in advance.
TrangDo Y
Friend :
In my opinion, if you will use the ltrim(rtrim(column_char)) , i hope you
solve the problem.
Am i wrong ?
Eriovaldo
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 7:12 PM
> Is there any overhead (ie. inte
I am in the process of loading some image data, and would like to "pack" the
data as best I can.
Version 8.1.7.2.0
Locally managed tablespace with a 3Mb extent.
pctfree=1
pctused=95
After I do an analyze table I get the following results
num_rows*avg_row_len=28896420
bytes by segment=34603008
Hi Glenn :
I just finished to do it today.
I just deleted the temp files, and after it the Universal Installer showed
for me the list of products.
Regards
Eriovaldo
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 5:
The naming of these two wait-events is unfortunate in that they are
counter-intuitive. You would normally think that the phrase "sequential"
implied one thing and the phrase "scattered" implied the opposite. They do,
but not the way one would guess...
"Db file scattered read" is the wait-event
Greg,
As one who has been using the (now (un)officially named) OWI since I read
Anjo's paper in '98, I can speak for its' value. I believe we are
approaching the same problem from two sides, and there is merit for each
approach. The Wait interface provides invaluable information from a
Top-level
Well, Tim did say he was making a long story short.
scattered reads = multiblock reads which are typically
associated with tablescans, but can be index fast full
scans.
sequential reads = single block reads which are typically
associated with index block reads, table blocks
begin rant -
It's *ALWAYS* a good idea to try to understand the underlying causes, for
any and every situation. Too often people attempt to attack new problems
with the same approach that they used before (or heard some "guru" advise),
in a different context, in a different environment,
hm, I wonder if someone will do a "top 20 Unix mistakes" presentation
:)
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> been there done that.
>
>
> crontab -l > /tmp/c.c
> vi /tmp/c.c
>
> crontab /tmp/c.c
>
> joe
>
>
> Marc Cure wrote:
>
> >You'll lose your entire crontab if you do a crontab
I've got it on my list of things I'd like to do (i.e. understand
DBMS_STATS.GATHER_SYSTEM_STATS), but I don't see any time to do it anytime
soon. :-(
It makes sense that the use of this procedure should obsolesce both
OPTIMIZER_INDEX_ parameters...
- Original Message -
To: "Multiple
Anjo,
You wrote:
The problem in Oracle is that wait events are
not broken down per SQL statement (only on the instance and session level).
There are products that out there that do this for you, but that would be
completely different post ;-)
I'll bite. Which products do
this?
Do t
Rachel,
I will be doing some of that on the 'big boat' next week ;) but from the
DBA's viewpoint.
Sounds like a good idea for the next IOUGA (or UKOUG, or both)... :)
Thanks.
- Kirti
-Original Message-
Sent: Wednesday, April 24, 2002 9:18 PM
To: Multiple recipients of list ORACLE-L
h
I wrote a paper/presentation (entitled "SQL Tuning for DBAs") in 1996,
presenting it at several user groups and at Open World Australasia in late
1997. I still have it on my website (www.evdbt.com/library.htm). It
advocated examining the SQL Area on one side (to find "bad" SQL statements)
and ex
I think an excellent Oracle kernel enhancement would be to bias in the
LRU scheme against SQL that uses literals, just like the buffer cache
algorithm biases against blocks that are read via full-table scan. Think
about it... What's the likelihood that a SQL statement that's filthy
with literal va
Its telling you to stop signing in as sys.
-Original Message-
Dolgov
Sent: Wednesday, April 24, 2002 2:58 AM
To: Multiple recipients of list ORACLE-L
Hello ORACLE-L,
I'm connecting to oracle using TOAD under sys account - all works
well. I can select from sys' tables and views,
b
Check out Jeff Holt's "Why are Oracle's Read Events 'Named Backwards'?"
(www.hotsos.com/dnloads/1.Holt2000.02.01-Backwards.pdf) for a
description of why these events are named the way they are.
Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL PROTECTED]
http://www.hotsos.com
-Original Message
Hi Bill
Thanks for your reply.
In fact when I try following SQL i get result (few records available in
table DEPT)
"select * from dept@softek1"
I could not understand the meaning of your statement "You can pull the clear
text
password out of sys.link$ for this puspose.". Please clarify and hel
John,
Agreed.
My comments were specifically about two events, "db file scattered read" and
"db file sequential read."
I'm just a beginner at waits, so maybe I don't get it. My understanding is,
all you need to do is three back flips, a few drill downs, interpret P1 and
P2, analyze what STATE m
That's what the SA's are for. Restore please. They should have never
let /var get full:-)
-Original Message-
Sent: Wednesday, April 24, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L
You'll lose your entire crontab if you do a crontab -e when /var is full?
(I've had this happe
Help needed,
what is the difference with these software.
Legato Networker Module for Oracle, separate product which has to be
purchased from Legato.
And then Legato Software coming with Oracle CD.
BR
keijo
__
Ota itsellesi luotettava kotimainen email http://www.jippii.fi/
Tutustu samalla net
Dear Gurus,
I'm beginning to get into 'Experimenting' - would like to create a
test-bench, measure statistics, develop benchmarks etc.
Specifically, I would like to develop an area where the cost and
other stats values of executing a statement/transaction can be
measured without being distort
Yeah, logged in as root from someone else's workstation,
and no one is watching.
Jared
On Wednesday 24 April 2002 15:08, [EMAIL PROTECTED] wrote:
> Come on, Jared, its more fun to:
>
> crontab < /dev/null
>
> Scott Shafer
> San Antonio, TX
> 210-581-6217
>
> > -Original Message-
> > Fro
Well, no, it isn't.
I didn't realize that particular peculiarity of -e.
The problem with crontab -e is that it's too easy to
remove jobs accidentally, with no record of it.
Myself, I use:
co -l crontab.txt
crontab -l > test.txt
diff crontab.txt test.txt # proceed if there are no differe
This is not the only way.
See my next post on this.
Jared
On Wednesday 24 April 2002 15:08, Alex wrote:
> -e Edit the current crontab using the editor specified by the
> VISUAL or EDITOR environment variables. The specified editor must
> edit the file in place; any editor that unlinks t
On Tuesday 23 April 2002 21:53, Bin Wang wrote:
> Hi,
> Our application uses sqlplus + sqlloader to transfer data between
> databases. It takes nearly four hours to unload to data to flat
> files(1G), which is far too slow. In the application, the query looks
> like the following. All those &3
Tim,
I've had opportunity to tune the database in an attempt to fix
a poorly ( very ) designed application. This app may well
benefit from CURSOR_SHARING=FORCE, but that would
negate the use of histograms on one table that makes good
use of them.
That parameter may also have an effect on the
quite reasonable
-Original Message-
Sent: Thursday, April 25, 2002 9:33 AM
To: Multiple recipients of list ORACLE-L
I think an excellent Oracle kernel enhancement would be to bias in the
LRU scheme against SQL that uses literals, just like the buffer cache
algorithm biases against block
Title: Standby Database-No space on Disk
Hello All
Oracle 8.1.7, WINNT4.
On our standby Database box, we have run out of space on the partition which was holding the Temporary tablespace. Now the problem is that when ever I try to start the recovery, it gives the message that there is no spa
It would make sense,
I would expect Oracle to take a shortcut
with LOB Indexes, simply hard-coding the
fact that access to the LOB should always
be via the LOB index. Consequently there
would be no point in thinking about them
You could run SQL_TRACE prior to the
dbms_stats call, and see if t
Problem solved but the mystery continue.
I tried the describe in TOAD and got 'object x$dual not found'.
The describe works in sqlplus.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 8:23 PM
> Hi Yech
Hi all,
We have two partitioned tables, T1 and T2.
T1 belongs to one user and has 8 partitions, 3 users have a table called T2
with 8 partitions. We are trying to :
1) Alter tables (T1,T2) drop all partitions
2) Take tablespaces holding the partitions offline
3) Drop tablespaces
4) drop users
Tro
Yep,
wrong tree. size it like: redo blocks per tx * tx/sec * 3/2 *
Anjo.
Denham Eva wrote:
Hello,
I have been wondering about how to
work out what the optimal LOG_BUFFER parameter,
compared to the physical size of the
REDOLOG file, for the best optimization and writes from buffer to log.
Or a
1 - 100 of 164 matches
Mail list logo