Why don't u do this during off peak hours.
Anyways what u can do is take a Lock on the table and wait till the lock is
obtained and then alter tahe table.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
I want to alter a table and add a new column on our
production database.
I am getting the following error
ERROR at line 1:ORA-00054: resource busy and
acquire with NOWAIT specified
Some user/process is holding the lock on this
table.I have tried at different times
and still cannot get it
I wish I can work for you beside learning Oracle I can be a wiser man.
-Original Message-
From: Don Granaman [mailto:[EMAIL PROTECTED]]
Sent: 11 May 2002 00:38
To: Multiple recipients of list ORACLE-L
Subject: Re: Good HR vs. Bad HR...
Actually, I don't think the company is all
Anybody knows what percentage of production databases are 7.3, 8.0 and 8.1
and prognosys in an year.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex Hillman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Hum, I have to fight a bit more for mine suggestions to go through. That's
not fair. I guess its good for me as its helping my debating skills:-) It
does not help that the folks I work with are half way across the country.
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, May 10, 2002
-- Henry Poras <[EMAIL PROTECTED]>
>> From what I remember, one of the main advantages of a normalized
>> database is
> a certain level of data integrity and flexibility. The integrity comes
> from foreign keys, lack of duplicate data, and generally a data design
> based on characteristics of t
>From what I remember, one of the main advantages of a normalized database is
a certain level of data integrity and flexibility. The integrity comes from
foreign keys, lack of duplicate data, and generally a data design based on
characteristics of the data. The flexibility comes from the ablility
> Each morning I produce graphs...
I think this is key. Having historical data graphically presented helps to
establish the norm and when there may be performance issues to investigate.
This follows step 2 of Gaja's "Oracle Performance Tuning 101 Methodology"
which says, "Measure and document curr
Tim,
Don't *ever* apologize for long threads when
they are full of useful content. :)
Jared
"Tim Gorman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 02:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Trang: I think that you missed the step of "alter database archivelog" while
the database is mounted but not open.
Here is the precise steps for you to review:
Modify the init.ora file with log_archive_start = true (you've already done
that)
Shutdown the database.
STARTUP MOUNT
ALTER DATAB
You probably received an error in your alert log and Oracle disabled archiving. Make
sure yuou have these 3 parameters in your init.ora and set accordingly:
log_archive_dest = /oracle/data/arc//
log_archive_format = _%s.arc
log_archive_start = true
hth,
Gene
>>> [EMAIL PROTECTED] 05/10/02 06:
I did switch a database's archiving mode from NOARCHIVELOG to ARCHIVELOG. I then enabled automatic archiving of filled groups by setting
log_archive_start=true
in the database's parameter file. Finally I used
alter system archive log start;
to enable automatic archiving of filled online redo
See, they do listen. Now if we could only get them to move faster than Molasses
going up hill in the middle of an Alaskan winter!!
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 5/10/2002 4:22 PM
yeah it's sweet. they finally got aro
A DW stores data in a denormalised fashion, that's one
point that every body knows but it is also subject
oriented. It is also developped one subject at a time.
A DW is multi-subjects as a datamart is on one
subject.
>From Bill Inmon
>From the data warehouse data flows to various
departments f
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> The key point is your users. A typical normalized
> design means a lot of
> tables. These tables must be joined in specific
> manners. Non-I.S. users find
> this intimidating. So they don't use it. So you've
> spent a lot of time
> creating a DW on
New feature in 9i, default temporary tablespaces. Now you don't have to state
what a users temporary tablespace is and have them end up in system. It covers
sys and system at the same time since it's declared in the create database
command.
Dick Goulet
Reply Separator__
The distinction between a data mart and a data warehouse is not size ("Size
doesn't matter"). It just works out that way usually...
The distinction between a DM and a DW is its function within the entire
decision-support strategy. A data warehouse is the consolidation point for
all data from al
That's CORRECT... no one other than SYS should have the SYSTEM tablespace as the
default tablespace. No one should have SYSTEM as the temporary tablespace.
for years oracle would say "change the default tablespace". Now they do it for
you (and about bloodly time!)
|+
Dennis,
It's possible the version you have was corrected. I know that it was the first
printing that had some serious, unintentinal omissions I think only in the
first few chapters.
What really hurts the author is when they catch the error, send the correction
in in time to be fixed for th
-- Gurelei <[EMAIL PROTECTED]> on 05/10/02 12:13:27 -0800
> Jared,
>
> Thanks for the answer. I must admit my ignorance in
> terminology as for me data warehouse and data mart a
> pretty much the same thing except for size. I
> understand that data mart is smaller. The database I'm
> referring
There are many things that you could check:
1) size of the shared pool
2) fragmentation of the shared pool
3) free space in the shared pool (together with 2)
check also the application for parsing (also soft parses).
Check v$rowcache to see access to the rowcache.
Anjo.
"Reddy, Madhusudana"
One philosophy of DW states that you build a DW that is
fairly normalized, much like an OLTP database, albeit one
with a temporal component and complete logging of transactions
within the data.
This is then used as a warehouse. The data from the DW is used
to assemble data marts. These data mart
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 5:03 AM
> Hi ALL,
>
> 1.
> How do I get know memory usage by karnel,application
> programs,Filesystem Cache etc in SunOS 5.6 . I do not
> have the RMC package installed in my m/c
Jared,
Thanks for the answer. I must admit my ignorance in
terminology as for me data warehouse and data mart a
pretty much the same thing except for size. I
understand that data mart is smaller. The database I'm
referring to could probably be described as data mart
as it is going to be rather sm
Thanks Rachel. To choose between speedy publication (copyright 2002) and
waiting another 6 months for an error-free book, I'll choose speedy.
Especially since I've become increasingly desperate for a good RMAN tutorial
over the past months. And after all, this book is designed to teach you to
BACK
Hi,
I resisted, but I decided to join in this thread after reading some indirect
comments about our products.
- As said by others, trace file format is documented. But, there are many-many
traps in raw trace files. Reading them by eyes or by a simple script may give
wrong results. In other words
-- Gurelei <[EMAIL PROTECTED]> on 05/10/02 10:43:23 -0800
> Hi.
>
> We are designing a small database using a data
> warehousing desing. We have created a 3rd normal form
> and are now debating whether and how to denormalize
> it. I see the pluses of denormalization - easier
> queries creation
Let's see . . . disadvantages . . . hmmm. scorn of anyone that understands
data warehousing? On your resume putting "created a completely normalized
DW" and wondering why everyone giggles when they read it.
Actually, a normalized schema will probably use less space than
denormalized.
The key poin
supposedly no additional cost in 9i, but when I checked Oracle's store, there
was a $20 charge for each. Considering that for 7.3 and 8.0 they were $100 for
EVERY NAMED USER, regardless of how many people were actually going to use them,
that's "no cost" :)
|+--->
Doh!
I forgot to mention services.
Thanks Thomas.
Thomas Day <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 11:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Server upgrade NT4
Chris,
Well, dang, it does work!
Guess I should have tried it myself first.
It will only work from SQL Plus though, or other
tools that capture DBMS_OUTPUT.
Oracle must send it to the big bit bucket in the
sky otherwise.
Jared
"Grabowy, Chris" <[EMAIL PROTECTED]>
05/10/2002 11:25 AM
Limited yes, but invaluable when debugging a trigger, and other possible
uses.
Chris
-Original Message-
Sent: Friday, May 10, 2002 2:33 PM
To: [EMAIL PROTECTED]
Cc: Grabowy, Chris
Chris,
Well, dang, it does work!
Guess I should have tried it myself first.
It will only work from SQL
Thanks, so I can survive with 8.1.7.0 specially for development Env.
-Original Message-
Sent: Friday, May 10, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L
I have 23 Oracle databases running 8.1.7.0 (knock on wood) w/out a problem.
I patch only when its broke. Or for a new in
Anyone know why, when using DBCA, it configures user SYSTEM to have a
default tablespace of TOOLS and not SYSTEM?
This is a separate script it runs at the end, after the db and data
dictionary are both created.
thought system should have system tablespace as default, no?
thanks
--
Please see t
Folks, just a word of warning. Through NO FAULT of the authors, there are a
number of errata in the first edition of the book.
There is a complete errata list on the Osborne site:
http://shop.osborne.com/cgi-bin/oraclepress/errata.html
Page proofing is one of the worst tasks on earth (I know
Actually...
SQL> create or replace trigger test
2 after insert on test_table
3 begin
4 dbms_output.put_line ('Hello from trigger!!!');
5 end;
6 /
Trigger created.
Elapsed: 00:00:00.02
SQL> insert into test_table values ('Hello');
Hello from trigger!!!
1 row created.
Elapsed: 00
I hope you will all forgive this slightly off topic post.
You may find it a bit interesting. There's also a punch
line for all the codgers among us. ;)
Jared
-
Joys of having an intern
If you have ever had the privilege of having a fresh faced
intern at you
Hello All,
Here is the result I have got from the v$session_event
SID EVENT
TIME_WAITED
---
22 direct path read
109
20 db file scattered read
125
24 db file scattered read
160
26 SQL*Net more data to client
1
I'm upgrading a couple of boxes to 8.1.7.2 simply because
that is the earliest version in which Oracle Names checkpoints
actually work.
Jared
"Miller, Jay" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002 08:58 AM
Please respond to ORACLE-L
To: Multiple recipients of
ok - thanks
i edited the trigger to insert a row into a dummy table, just to see if it
works, and all works fine.
Now - the next piece.
I want this trigger to call a stored procedure that runs as an autonomous
txn and creates a public synonym for the newly-created table.
I've verified independen
I have 23 Oracle databases running 8.1.7.0 (knock on wood) w/out a problem. I patch
only when its broke. Or for a new install, e.g. waiting for 9i rel 2 w/ its patches
before I start the upgrade process.
FWIW,
Gene
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gen
Bill,
A trigger cannot display output.
Where would it go? A trigger does not run in an interactive
session, it runs in the database independently, regardless
of the presence or absence of a SQL Plus session.
Jared
"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/10/2002
Hi.
We are designing a small database using a data
warehousing desing. We have created a 3rd normal form
and are now debating whether and how to denormalize
it. I see the pluses of denormalization - easier
queries creation and tuning. What are the
disadvantages that we should be aware of? Wasted
We've go them & I think so.
Dick Goulet
Reply Separator
Author: "Schauss; Peter" <[EMAIL PROTECTED]>
Date: 5/10/2002 7:58 AM
Are these addons to OEM worth buying?
Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
--
Please see
Kitri - Thanks so much for pointing this book out. I have purchased it and
worked through almost all the examples. It is excellent. It was exactly what
I needed. I had found it difficult to get started with RMAN. I had read the
Oracle manual, and taken the Oracle 8i Backup & Recovery class (briefl
Recreating the C: drive will definitely destroy your Oracle registry
entries and your Oracle and listener services. Doing an in-place upgrade
should not and will also give you a more stable server. Ghosting is much
easier but it can produce an unstable machine that will intermittently
suffer a
Title: RE: Asinine security workarounds in Oracle, Part III
Paul,
Does that mean some of the films I have at home are sequels with 29 other episodes?
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Paul
For around the same money (I think...maybe before the pricing restructure),
I like Spotlight On Oracle from Quest. Excellent drilldown capabilities,
MUCH better GUI, and for management, it's cooler-looking too.
Trials are free. Just expect a call from a salesman.
Rich Jesse
Peter,
I guess it depends on whether you have any other monitoring and/or
performance tuning tools that you use.If you do, there may be quite a
bit of duplication of features provided.If you don't have any other
automated tools that provide performance monitoring and tuning
capabilities,
On Thu, May 09, 2002 at 03:23:24PM -0800, MacGregor, Ian A. wrote:
> I have learned some rudimentary gnuplot skills. Each morning I
produce graphs of what went on the in the databases the previous day on
and hour by hour basis. If something is really askew I break the
hour down into ten minut
Peter - It depends. If you are a big user of OEM today, then you'll probably
want them. In the long run they are probably a little like OEM itself.
Excellent for getting novices into the Oracle game, but eventually you must
learn what is beneath the tool. I found that STATSPACK offered better
info
I don't have an answer, but I do wish to point out that your ""
should be "XL". Roman numeral innumeracy: a growing problem?
__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
--
Please see the official
Where've you been? According to Oracle, customers haven't
needed a DBA since version 7.
-Original Message-
Sent: Friday, May 10, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L
choice
ROFL over here over this one. Wish I could have been
there.
I hear that in 9i you won't need a
Actually, I don't think the company is all that bad now. In fact, I would have
preferred to keep
the company name out of it.
Also, I should have put this into a context. At the time this was written, upper
management had
started an intimidation campaign. They were doing some layoffs, but rat
ROFL over here over this one. Wish I could have been
there.
I hear that in 9i you won't need a DBA anymore!
jack
--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> Is this surprising? I still remember an Oracle
> presentation when 8i was
> first coming out and the Oracle rep answered a
> questi
A la Ned Flanders, absolu-tiv-tiv-tively! Especially if you plan on usingem.
Thank you,
Paul Sherman
DBAElcom, Inc.
email - [EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 10, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Are these addons to OEM worth buying?
Tha
Amol - I think that you are on the right track, looking at LD_LIBRARY_PATH.
Possibly you don't have that variable set just quite right, or it isn't set
when you issue the lsnrctl. You can check the setting by entering "env" just
before you issue lsnrctl. Try to check for extra characters or non-pr
I'm creating an AFTER CREATE ddl trigger:
CREATE OR REPLACE TRIGGER after_create_trg
after create
on lwdev.schema
begin
if sys.dictionary_obj_type='TABLE'
OR sys.dictionary_obj_type='SEQUENCE'
then
begin
dbms_output.put_line ('TEST');
Hello,
Sorry about the screw-up in the subject. It should be "locks". Dreaming
about the week-end, I suppose.
Thank you,
Paul Sherman
DBAElcom, Inc.
voice - 781-501-4143 (direct #)
fax- 781-278-8341 (secure)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 10,
Is this surprising? I still remember an Oracle presentation when 8i was
first coming out and the Oracle rep answered a question about hints by
saying that no one should use hints any more because the optimizer always
used the best path.
Half the room burst out laughing :).
Jay Miller
-Orig
Well, I'd take a look at the fixed bug list for the 8.1.7.2 (since several
people have said there are unspecified problems with 8.1.7.3). It's about a
hundred pages long :), but if nothing there affects you you might be all
right. I have 2 8.1.7.0 databases that have been running without problem
Great minds think alike? Either that or we are the
borg and just don't know that we are part of the
collective yet.
--- [EMAIL PROTECTED] wrote:
>
>
> How is this essentially different than what you can
> get from utldtree.sql?
>
> when Kevin Loney and I were writing the Annotated
> Archives
Are these addons to OEM worth buying?
Thanks
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Schauss, Peter
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
That was it - thanks!
Forgot there were two distinct system privs - CREATE ANY SYNONYM and CREATE
PUBLIC SYNONYM
-Original Message-
Sent: Friday, May 10, 2002 10:38 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Bill,
Does the OWNER of the proc have CREATE PUBLIC SYNONYM system p
Bill,
Does the OWNER of the proc have CREATE PUBLIC SYNONYM system priv?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, May 10, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
I've developed a procedure that will create a public synonym on an obj
>> So far, it does not look to be like that here. I have reviewed and made
>> suggestions in the past two weeks and the response has been "she's right,
>> let's do it". And it gets done. I might actually like it here :)
Careful... they will slap you down when you least expect it! :-)
RF
-O
Hello,
Has anyone ever tried setting dml_locks to zero or disabling table locks on
an OPS (2-node, 8.1.7.2.1, 32-bit; HP 11.0, 64-bit) as a way of reducing
contention and freeing up resources ? We currently use 7,250
dml_locks/instance. Oracle's OPS Admin manual (8i) had the following to say:
Ob
I've developed a procedure that will create a public synonym on an object,
which I'd eventually like to call from a ddl "after create on schema"
trigger.
But I'm first working on this piece - I get an INSUFFICIENT PRIVILEGES error
(ORA-1031) on the EXECUTE IMMEDIATE line. The user running the pr
Wow, it's a small world. My first DBA position was at CSG Systems! And
yes, the company broke off of First Data and became its own publicly traded
company. By the way, nice letter :)
-Original Message-
Sent: Friday, May 10, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Don,
Don,
And, of course, since it was a resignation letter, the company probably just
filed it away. I'll give you the "Brass Cajones" award though, for setting
the record straight.
Just curious, is the company still around? Need to make sure to avoid it in
the future! :)
Tom Mercadante
Oracle C
Sankar,
1) How many indexes does this table have?
2) How many rows currently exist?
3) Are there ANY triggers on this table?
4) Are there any column constraints other than NOT NULL?
5) Is there a foreign key on from this table to another?
6) How many rows are in the master
Don - Excellent letter! Wonder what happened after you left? Did anything change?
>>> [EMAIL PROTECTED] 05/09/02 06:37PM >>>
I think enough has been said already - I didn't intend to name the company at all.
Actually, I
don't think that I said that all the managers were incompetent. (A selec
Where can I find the output of the Solaris run control scripts? I am trying
to debug a database startup problem and would like to view the output of the
echo commands in these scripts.
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET:
Don,
Next time I need to resign, will you help me write the letter?
Having worked at several large and not-so large companies, all I can say is, the
problems you documented seem to be ubiquitous throughout most management. I have
found it nearly impossible in some places to do my job with any
Title: Oracle and Character formatting
Hello All,
We want some text to be stored in our database, entered through a Dev6 Form. Is it possible that formatted data can be stored in the database in the form it is written, i.e. with different fonts or special characters or numeric values with pow
How is this essentially different than what you can get from utldtree.sql?
when Kevin Loney and I were writing the Annotated Archives a few years ago, I
tried to write a script that would show the dependencies, because part of the
reason for the book was to provide "home-grown" scripts that wre
And I respectfully agree that I was wrong :)It happens, I think I already
posted a note to the list apologizing and correcting my error.
This is what happens when I post from memory without double checking
obviously I had done a "flush" of my shared_pool!
Rachel
|+---
[EMAIL PROTECTED] wrote:
> I think enough has been said already - I didn't intend to name the company at all.
>Actually, I
> don't think that I said that all the managers were incompetent. (A select few in
>the wrong places
> perhaps.) Since the cat is out of the bag though, I will try to en
Sean,
We did a straight upgrade of an NT box to Win2K (some time ago) that held an
Oracle 8.1.6 database.. The database was fine after the upgrade.. What is
the choice for recreating rather than upgrading?
Mark
-Original Message-
Adar
Sent: 10 May 2002 12:29
To: Multiple recipients of l
1) Oracle uses the registry also to register some staff in other places
except the oracle entry.
2) Oracle also use c:\program files\oracle for some stuff (install log
etc.).
Why do not upgrade the machine without recreating C partition.
(I know that upgrade is more work then ghosting a new C dri
Torben Holm from Miracle created the Trace File Repository, which is a neat
little utility to put data from the 10046 output files into a couple of tables.
Then it's entirely up to you to either use one of Torbens pre-created output
formats or create your own. Torben - where can these guys get i
I remember once a designer package compiled forever, it just hang up ...
I looked in the previous release of Designer and found that the code has
been changed although the meaning was really the same. So I took some 5-10
lines from previous version and voila! - it worked. Later this was
register
Hi ALL,
1.
How do I get know memory usage by karnel,application
programs,Filesystem Cache etc in SunOS 5.6 . I do not
have the RMC package installed in my m/c
2.
How do I know if the ORACLE is using Raw/UFS ?
3.
If I set _filesystemio_options='directIO' instead of
'async' will that save memory
On Thu, May 09, 2002 at 02:53:19PM -0800, MacGregor, Ian A. wrote:
>
> * The way it fails:
>
> * If the schema is required, OCIDirPathPrepare() should fail with an error. A
>crash/core dump is an ... unconventional way of indicating an
>
> error.
Sadly not very unconventional for OCI :(
Ti
You have my sympathy, as I've been in a similar situation after getting a
designer install thrown at me.
I can only offer general advice, as we hit a series of different bugs that
eventually led to abandoning designer, you've probably heard it all from Oracle
support already...
Make sure you're
Sam,
I think this will work. Can you please try it out and
let me know if I understood your problem correctly.
select t1.c2,t1.c4,t23.c2,t23.c3,t4.c4
from t1,t4,( select t2.c2 c2 ,t2.c3 c3 from t2,t3
where t2.c3=t3.c3) t23
where t1.c4=t4.c4(+)
andt1.c2=t23.c2(+)
and exists
(
select 1
Sorry
I meant to say partitioning is not available in SE - not replication.
Yechiel Adar
Mehish
- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 3:21 PM
Yechiel - Do you have more information (9i and replication)? Previously
there was a document on Oracle's web
87 matches
Mail list logo