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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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:
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
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
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
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
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
SORRY
crontab -e
"Ivan Llamoca"
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
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
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
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
>
>
> -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
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
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
> "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
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
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
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
-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
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
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
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:
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
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
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
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
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
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
>> 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
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
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
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:
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
> 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
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
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
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
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
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
crontab -r
...
[EMAIL PROTECTED]
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
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
> --
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
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
"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
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]
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]
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
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
>
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
>-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
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
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
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
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
Ok...ok...ok...enough talk... can somebody PLEASE publish a
reference location of this script?
Thanks,
Mike
-Original Message-
Sent: Wednesday, April 24, 2002 8:39 AM
To: Multiple recipients of list ORACLE-L
please
n
it was also mentioned at the Oracle of Oracles closing session, in t
Title: RE: Currval and buffer gets
Waleed, Kevin, Jonathan, Alexander
8.1.7.0 on Windows 2000
run
time using view x$dual in centiseconds=494run time using table
dual in centiseconds=896run time using direct
:= in centiseconds=1007
Ramon
-Original Message-From: [EMAIL PR
I
don't know if this is related to what we are going through here, apparently
Oracle treats transactions via db link as 2-phase commit transactions unless SET
TRANSACTION READ ONLY is used.
Check
dba_2pc_pending to see if you have hung 2-phase commit
transactions.
If you
do, do a searc
it was also mentioned at the Oracle of Oracles closing session, in the
"top 10 things I learned in San Diego" :)
--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> Might have been Dave too, but I mentioned it in my "Misunderstandings
> About Oracle Internals" talk at IOUG on Tuesday...
>
>
> Car
[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 DBA
[EMAIL PROTECTED]
--
1 - 100 of 164 matches
Mail list logo
