check for any jobs running ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 5:39 AM
Our sysadmin tells me he's been experiencing problems sometimes, when
trying
to shutdown an Oracle 8.1.7 instance on a Solaris 64-bit
Hey guys;
Does anyone know where I can look to find the space remaining in an
individual extent ?? I know that you can get the freespace from
dba_free_space but that seems to be based only on unallocated extents. I
have been asked to find out, down to the byte, how much free space is
available
the sad part is that universitied need funding, so government can always
find some professor somewhere who is willing to get paid to do policy
science.
Patrice.
-Original Message-
Sent: Tuesday, May 27, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L
Patrice,
I have
Small correction for SQL Server / Sybase, if anyone cares, of course -:)
Delete table1
from table_a
where column1 = col_a
or column1 = col_b
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
OLLIG
Sent: Tuesday, May 27, 2003 9:35 AM
To: Multiple recipients of list
Has anyone found a practical use for these isolation levels? My impression
is they are mainly offered to:
1. Meet ANSI requirements.
2. Help code port unchanged from other systems.
3. Lure the unwary into using them and causing performance issues in their
system.
My experience has been that Oracle
I heard/read they give 20% discount on ocp exam fee
if u are registered with technet .
Can any body confirm that . How do I get that
discount ?
-ak
-Original Message-
Can someone please suggest if it is a basic database design
flaw which leads to the requirement of such costly technologies
like RAC in the first place?
(I mean if the dataset is huge why not use transportable
tablespaces
and keep 'regularly purging' the
yes they do.
to get it, you register with technet.
otn.oracle.com
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas
You will recognize your own path when you
come upon it, because you will suddenly have all the energy and imagination you
will ever need.
~ Jerry
I agree at 500% with you...Leave oracle isolates the transaction...You,
concentrate on your coding standard instead.
Regis
-Original Message-
Sent: Tuesday, May 27, 2003 5:45 PM
To: Multiple recipients of list ORACLE-L
Has anyone found a practical use for these isolation levels? My
All,
Can anybody please help me on this :
We are trying to find out the bandwidth required for keeping our DR database
updated using Dataguard.
There is an equation the networking guys use for this but I need to give
them the redo generation rate
or redo copy rate in bytes per second. Is there
Hi,
Would the imp speed increase by setting all indexes to NOLOGGING?
I have a schema with 249 tables and 442 indexes and I have a weekly schema
refresh program running as this:
exp schema from Server A (Oracle 8173 on Sun Solaris box)
ftp dump file from Server A to Server B, the dump file size
there are also stupid ones too. I was pointed to a study on a Sybase usenet where they
said sybase was 1000% faster than Oracle when you have 250 users and something like
1TB of data.
They contacted oracle and oracle told them to use shared server. The sybase guys
thought Oracle was pulling
im registered with technet and when i signed up to take my tests with prometric? I was
charged the same $125/test?
From: April Wells [EMAIL PROTECTED]
Date: 2003/05/27 Tue PM 01:04:44 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: ocp discount
yes they do.
Samir,
I find this query useful...
select first_time,
mb,
mb - (avg(mb) over ()) dev_from_avg
from(select trunc(first_time) first_time,
sum(blocks*block_size)/1048576 mb
fromv$archived_log
Have you considered dropping the indexes before import, then rebuilding parallel
nologging?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
Title: RE: RE: ocp discount
when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register for the tests. Don't remember what the code was, off hand, but I remember it was delivered in one
Everything in the schema on Server B is dropped before import, so I have an
empty schema to begin with. I am not sure I understand what you meant by
dropping the indexes before import? Did you mean export/import indexes
separately? I guess I could do that. Right now I just try to keep the
program
OTN20
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 27 May 2003 10:01:44 -0800
when you signed up with technet there should have been an announcement or a
splash screen that gave you a discount code... you have to type that in when
you register
No logging only works for the initial creation of an object. Thereafter Oracle has to
log the changes.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, May 27, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
Have you considered dropping
Hi
Just laidoff due down sizing. Will appreciate good pointers to look for DBA
positions with Oracle Fianancials back ground in New Jersyey and New York,
besides monster, dice and net-temp or any good recruitor.
I shall appreciate your assistance. May be contacted off list.
Regards
Rafiq
This might give you a good idea:
select to_char(first_time,'MM/DD/ HH24:MI') YEEHAA from v$log_history;
We are trying to find out the bandwidth required for
keeping our DR database updated using Dataguard.
There is an equation the networking guys use for this but
I need to give them
When you signed up for the exam, there was a question as to whether you had
any discount codes. It is the same screen that asks if you are an Oracle
employee. If you enter the code on that screen, then you receive the
discount.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL
Cyril,
we need some encouragements on those who has the experiences and also
has ocp. As Rafig said, if I don't continue updated my ocp, I just know
something I have done, limited to my experiences. With ocp, I know
WHAT, then I know HOW
Joan
M Rafiq wrote:
Cyril,
One positive point...
In respone to someone's question about improving
exp/imp speed I had posted the following quite some
time ago. Most of it may help you.
- Kirti
This one is a rather long one.. Sorry..
Prepare scripts to build tables, indexes and
constraints etc.. Prebuild the
tables in the target database. I
Patrice
Take a look at:
http://www.pcmag.com/article2/0,4149,7275,00.asp
It is about a year old, but is the review that comes close to your request.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 27, 2003 10:20 AM
To:
Kevin - Since you haven't received any replies, here goes.
Within an extent, Oracle uses blocks. I haven't seen a way to find the used
space within a block. There are methods to find the number of empty blocks
underneath the high water mark. Analyze does that, but you've ruled that
out. It might
As to what this is for .
I have a request to come up with a way to guage space remaining on an on
going basis i.e.If I look at the space available between 2
different user transactions I will see a difference. Most of the methods I
have seen so far either rely on Analyze or show
Patrice writes
When I took sociology they decried the use of what they
called policy science, where someone has an objective but
wants to find the best way to get there. (e.g. we want the
best education system at a budget reduced by 15 percent.
Then they turn around an talk about
I am trying to issue the following statement. I have SELECT priviledges on the proper
table. I am in Schema A, I am trying to create a table which is owned by Schema B. I
can do this out of SQLPLUS. I cannot figure out what grant Im missing. I have create
table.
Im just doing
execute
Joan
excellent. thanks,
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 27 May 2003 11:09:41 -0800
Cyril,
we need some encouragements on those who has the experiences and also
has ocp. As Rafig said, if I don't continue updated
dbms_space.unused_space will give you the total blocks allocated and
the unused blocks. You get of 300 blocks allocated, unused blocks=45.
It won't give you of used block 10, there are 300 bytes free but I
don't know of anything that does that.
--- Kevin Lange [EMAIL PROTECTED] wrote:
As to
I'm not sure if this is any help:
--block_e_byte.sql
/*
The Oracle blocks used by a given table and the corresponding bytes.
*/
--Inspired by a posting by [EMAIL PROTECTED] on ORACLE-L
--Requires one parameter, the table name.
SELECT COUNT (DISTINCT
DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid)||
I can see you point.
Yet an IO is an IO is an IO. As Gaja's excellent presentation at the
Hotsos Symposium in Dallas documented, there's about eight levels
between the OS and the disk plate.
Yet the disk plate delivers either 50 or about 100 IOPS.
And Oracle requests IO's from the OS.
That's
Kevin Lange wrote:
As to what this is for .
I have a request to come up with a way to guage space remaining on an on
going basis i.e.If I look at the space available between 2
different user transactions I will see a difference. Most of the methods I
have seen so far either
Kevin,
Also look at AVG_SPACE_FREELIST_BLOCKS which is the average freespace of all
blocks on a freelist, and NUM_FREELIST_BLOCKS which is the number of blocks
on the freelist. Of course, this is available after an ANALYZE... This is
available for INSERTs.
John Kanagaraj
Oracle Applications DBA
Kevin - The following may be useful in your quest as well:
Diego Cutrone posted this 1/18/2002
This query will count how many blocks have data (at least one row) and
are below the HWM:
select count(distinct substr(rowid,15,4)||substr(rowid,1,8)) from TABLE;
Dennis Williams
DBA, 80%OCP, 100%
Oooh, that's a keeper. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/27/2003 10:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Redo generation rate
Samir,
I find this query
Kevin,
Is this for capacity planning?
Jared
Kevin Lange [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/27/2003 09:15 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Space Remaining in Current
Kevin,
Unfortunately, there is not a way to find out the space available in
an extent, without doing block dumps. Why is this the only 'accurate'
method?
1) Using rowid will not work because it only records the rowid of
the head piece of a chained/continued row. This makes blocks appear
I'll beg/borrow steal from John Beresniewicz's book on Oracle Built-in Packages by
O'Reilly RevealNet to give you an answer. Here is the script that John provides
with the book. I use it in a somewhat different form, but it appears to tell the
truth.
DECLARE
free_blocks NUMBER;
BEGIN
Is there an Oracle 9i on 32-bit ??
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Leyden, Joseph
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: RE: RE: ocp discount
is it OTN20 ?
-ak
- Original Message -
From:
April Wells
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, May 27, 2003 11:01
AM
Subject: RE: RE: ocp discount
when you signed up with technet there should have been an
hi gurus
i am trying to generate 10053 trace in 9i and have met
with no success.
i used both 'alter session set events' and
'dbms_system.set_ev'.
i used the above two to generate 10053 trace for the
same query in 8i w/o problems.
has anything changed in 9i?
can you please help me on this?
Yes.
What platform are you interested in?
64 is a bigger number than 32. Therefor the human mind tends to like it
better. Man, I can't wait for the 512-bit OS'es. The Law Of Bigger
Numbers (LOB-N) applies everywhere you go. This is just one LOB. There
are other LOBs. LOB-D (Law Of Bigger
Dear Lister:
I'm using one of Steve Adams's scripts to break down
the components of foreground response time.
I found the pmon timer is taking about 63.59% out of other components.
Although some of the tuning documents suggesting ignore this event but
it still took a lots of time.
Any thoughts
This is quite close to what I was thinking of however it doesn't seem to
work for Oracle. Does anyone know if there is similar syntax available in
the Oracle world? I've looked at the Oracle (8.1.7) doco but can't see how
I can achieve what I want to do.
Yes, that's it.
Shamita Singh
AK [EMAIL PROTECTED] wrote:
is it OTN20 ?
-ak
- Original Message -
From: April Wells
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, May 27, 2003 11:01 AM
Subject: RE: RE: ocp discount
when you signed up with technet there should have been
On Tue, May 27, 2003 at 03:19:40PM -0800, Leyden, Joseph wrote:
Is there an Oracle 9i on 32-bit ??
http://otn.oracle.com/software/products/oracle9i/content.html
Oracle9i Release 2 (9.2.0.1)
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition
for Windows Server 2003
Yes.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 27, 2003 7:20 PM
To: Multiple recipients of list ORACLE-L
Is there an Oracle 9i on 32-bit ??
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
What is a predictable corporate environment? I know of no such
thing.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, May 27, 2003 4:50 PM
To: Multiple recipients of list ORACLE-L
Both will do most jobs, with Oracle excelling in
Hi,
I am sorry if I sounded discouraging.
That wasnt the idea.
anyway if the idea or point was missed
I guess it is not anyway worth labouring on it :)
Best Regards
Cyril
On Wed, 28 May 2003 Joan Hsieh wrote :
Cyril,
we need some encouragements on those who has the experiences and
also
Title: RE: what grant am I missing?
as sys
grant select on schemac.table to you;
grant create any table to you;
(optionally) Happy birthday to you !!
Raj
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 27, 2003 4:20 PM
To: Multiple
All those documents are correct.
PMON just waits while there is no work for it to do.
This wait event does not affect database performance.
- Kirti
--- Kevin Tsay [EMAIL PROTECTED] wrote:
Dear Lister:
I'm using one of Steve Adams's scripts to break down
the components of foreground
It has worked for me in 9i as well.
What is it that you are not getting?
Please review Wolfgang's 10053 Events paper at
http://www.centrexcc.com. He may have any 9i specific
information.
- Kirti
--- Sai Selvaganesan [EMAIL PROTECTED] wrote:
hi gurus
i am trying to generate 10053 trace in
At 04:15 PM 5/27/2003 -0800, you wrote:
hi gurus
i am trying to generate 10053 trace in 9i and have met
with no success.
i used both 'alter session set events' and
'dbms_system.set_ev'.
i used the above two to generate 10053 trace for the
same query in 8i w/o problems.
has anything changed in 9i?
hi
thanks for the info.i could make it work for some 9i
sqls but a particular sql is not generating trace.
the 10053 trace file has only the query para but no
other details. the query selects from a simple view
built on a table. will this make a difference?
here is the query
select id from
Sai,
First, make sure you can create and locate a regular SQL Trace file, using
either ALTER SESSION SET SQL_TRACE = TRUE or ALTER SESSION SET EVENTS '10046
trace name context forever, level 1' (preferably the latter, since the
syntax is so similar to 10053)...
Then, make sure you are using the
57 matches
Mail list logo
