Title: alert log suppression
Is it possible to suppress successful DDL within the alter log?
For example, I have a cron job that coalesces 300+ tablespaces
which creates a couple line entry for each. I would like to
get feedback only if the DDL has actually failed.
TIA
Title: RE: Sun Solaris
sunhelp.org for general.
sunmanagers.org for critical. requires summary post and is more restrictive.
-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L
Subject
mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: alert log suppression
The obvious question being why you are coalescing tablespaces
--- "Markham, Richard" <[EMAIL PROTECTED]>
wrote: > Is it possible t
PROTECTED]
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 1:00
PM
Subject: RE: alert log
suppression
ok. They are LMT's with PCTINCREASE 0. I'm
r
and allocation type "USER" for dictionary
managed tablespaces.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 2:09
Title: RE: backup controlfile to trace
a non-full proof method that I use is
T_FILE=$(ls -1rt /$ORACLE_HOME/admin/udump | tail -1)
this will assign $T_FILE to the newest file existing in UDUMP.
-Original Message-
From: Ray Stell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, Sept
are
either of you or any one on this list working with 11i applications? I am
curious as to how the load balancing works against the hard
coding
of web service infomation in the FND profile options which seems to only
provide configuration for one application tier. Does
the
second
tier o
Title: RE: Estat Bstat
you could always have the utl*stat report output interpreted by oraperf.com for free.
-Original Message-
From: Ora NT DBA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Estat Bstat
Title: RE: log_file_sync io wait question
well if you have mirrored members that exist on the same disk thats an
issue, if this same disk houses the currently used datafiles that would
add to the situation. I placed my redo on a seperate raid-1 and dropped
the member mirrors and see better st
Title: RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my
i had the same issue where all my data files were moved to the same slice
which fortunately i had a large slice. i ended up doing the manual upgrade
steps through the Migration manual.
-Original Message-
From:
Title: moving non system segments
I was playing around with Tim Gorman's hc.sql (health check) and
would like to move these objects into the USER tablespace. I would
like assistance in additional things to consider.
I haven't actualy used the command but believe I would use:
ALTER . MOVE
Title: RE: DBA work load
yea I was going to add that as much as the hardware trend
has demanded redundancy for failover so it would make sense
that a "production" shop would apply that to its personnel
as well.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
S
Title: RE: rebuilding an instance from a cpio file?
here's an excellent link that will give you more than you asked
for.
http://www.onlamp.com/pub/a/bsd/2002/07/11/FreeBSD_Basics.html
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 2:54 PM
To
Title: migrating 8.x->9i and charsets
Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:<>
the character set at the time was AMERICAN_AMERICA
to anyone who has any input.
-Original Message-
From: Markham, Richard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 9:28 PM
To: Multiple recipients of list ORACLE-L
Subject: migrating 8.x->9i and charsets
Ron I was reading your response about converting to UTF8 and i
Title: RE: Degrade a database??
I can't think of any better way to back out of anything other than
a restore from disk or tape.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 2:48 PM
To: Multiple recipients of list ORACLE-
Title: RE: how to find out the patch applied on different env.
FILENAME adphrept.sql
DESCRIPTION
SQL script that creates a report file showing the patching history
of all patches
also can be used in conjuction with the following SQL, this tends to be more granular:
SELECT * FROM AD_PATCH_D
Title: RE: Oracle D.B.A. required in M.A.
Is it that or is it a new goal to get a developer than can play part time DBA
or vice versa and reap all the benefits for the price of one?
-Original Message-
From: ltiu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 1:15 PM
To:
Title: RE: Backups
It would be interesting to see how you would explain how either
cp or dd (which know nothing of archive log mode, or the concept
of hot backup, itself, none the less) is going to keep things
consistent, when these utilities themselves are for point in
time operations.
-
that I am
spoiled .
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 1:38 PM
To: Markham; Richard; Multiple recipients of list ORACLE-L
Subject: Re:RE: Backups
I've used cpio, dd, and fbackup to do hot and cold backups before, but
Title: RE: DBA place in the business (was RE: DBA work load)
you can write down the known heiarchy, then encompass that within a circle.
add a picture of the DBA holding the sphere in his hand or better yet if you
really want to get creative, place it on his back and have him poised like
Atlas
Title: RE: Is it possible to copy one db to another if the SID is differ
or consider note: 174625.1
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is it possible to copy
Title: RE: 8.1.7.2 or 8.1.7.4
Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably
be 9iR2 starting with a test db, then from there, onto the least important db upwards.
Of course I'm stalling to let all the venturous customers test thease new realeases
(and abund
Title: RE: Advice needed on move to Sun 15K (losing spindles)
Lets say a guy only has one finger on each hand to tie his
shoe (mirroring). If he had five fingers (striping) he can
accomplish the job quite a bit faster. Now give him 1000
shoes to tie and listen to him bitch about how he could u
Joe are you on UNIX? you could pipe the
stdout to a program called tee
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 11:14
AMTo: Multiple recipients of list ORACLE-LSubject:
stupid RMAN question
Ok i've been thru all of the 817
Title: Phew ... Finally Migrated
I
appreciate the feedback Raj.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002
11:24 AMTo: Multiple recipients of list ORACLE-LSubject:
Phew ... Finally Migrated
Over the weekend we migra
is
Forms 6i Server not an option?
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 23, 2002 6:14
PMTo: Multiple recipients of list ORACLE-LSubject:
Deploying a 6i Form to the web
One of our
developers (not a duhveloper) has asked if I
Title: Archive files and their Management
I'm up
for my backup and recovery class here soon, but this conversation has
brought up questions
that I think some of you wouldn't mind discussing
anyway. I see
where implementing archive logs
requires that you modify the database startup
procedur
Title: RE: Archive files and their Management
ok thanks for the info. The following was MISLEADING:
http://www.orafaq.com/faqdbabr.htm
Section: "How does one put a database into ARCHIVELOG mode?"
"To enable ARCHIVELOG mode, simple change your database startup command script, and bounce the da
I'm a little confused when one is talking about putting indexes and
tables into seperate TABLESPACES and the other is talking about seperate
DISKS. To any extent, I cant imagine how seperating
IO types across physical controllers could be anything but
rewarding. Yet, splitting across "DIS
Tim,
point well said. Thank you.
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 11:15
AMTo: Multiple recipients of list ORACLE-LSubject: Fw:
oraperf comment
...resending, as the original send encountered
some kind of "lock
Title: RE: LOCALLY MANAGED TABLESPACE
Metalink Note: 93771.1
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 24, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: LOCALLY MANAGED TABLESPACE
Hi
I am thinking to change our few dic
Title: RE: RMAN - It's Here
do list members get a "I post where you post" discount? =)
-Original Message-
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 24, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RMAN - It's Here
Just a note that
I'm
curious how you get sendmail/mailx to send a file as an attachment? I
suppose it can be done.
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 11:59
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
How to zip a file on
Title: SNP acronym?
What does the background job queue acronym SNP stand for ?
Title: RE: OEM can't seem to discover 1 instance
John I had the same issue recently where before the same instance
had been discovered. I had deleted the node after having removed
one instance from the server. Before it discovered all three and
now it discovers only one of two. Go figure. I
Title: disable SNP job processing temporarily
I have job_queue_processes 5 and job_queue_interval 3
I need to release locks on packages for a recompile
but ALTER SYSTEM ENABLE RESTRICTED SESSION; is not
always an option for me. Does anyone know what I can
do to suspend job processing (with
Title: RE: Re Raid 5+
Jared
raid 5 is good over a single disk for the read speed and the fact
you can rebuild if a disk is lost. A raid 5 write includes the
additional overhead of calculating parity, no question about it.
My raid 1+0 spindles are faster than my raid 5 when it comes to
wri
Title: RE: Oracle DBA with SAP Needed
What does "Base Salary is 55K-to maybe high 60s Firm." mean? You can
throw the possibility of a raise out the window? =)
-Original Message-
From: OraStaff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 9:49 AM
To: Multiple recipie
Title: full exp/imp of user to new tablespace; same user
I have a full export of user to where I need to import all his objects/grants
but into a NEW tablespace. What's the easiest way I can assure that
~everything~ is imported. Will I need to use a combination of INDEXFILE
and other proced
Title: RE: Out of procee memory problem ..
what is 4,50,000 ?
-Original Message-
From: Satyendra K Khare [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002 8:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Out of procee memory problem ..
This is the error message
Title: RE: SPIN_COUNT - 8i obsolete? What now?
additional factors:
log_checkpoint_timeout log_checkpoint_interval fast_start_io_target90% size of smallest redo
log
alter system
checkpoint
-Original Message-From: Jack van Zanen
[mailto:[EMAIL PROTECTED]]Sent: T
Title: RE: full exp/imp of user to new tablespace; same user
well now I can say I'm spoiled. I was given more than enough information to
to accomplish the task (done) and a new tool to boot! =)
Thanks alot everyone.
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Title: RE: System Tablespace and Autoextend
I have read complaints about SYS.IDL% objects having PCTINCREASE 50 and
space problems when they extend, in the forums. I went to check and
mine are already set to 0 along with 2147483645 MAXEXTENTS. I created
a TAR and verified with Oracle that a
nning the
script
7) save the file!
8) run the script to create all the
indexes
HTH
bill
-Original
Message-From: Markham, Richard
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07,
2002 8:59 AMTo: Multipl
Title: sqlplus ~no~output
for the sake of select * against a pinned table I want row output totally turned off.
in the past I thought set serveroutput off, set termout off, set pagesize 0 was
sufficient, but its still dumping row data on me. What have I forgotten ?
TIA
Title: need to compare long data against varchar2
I need to devise a method of comparing the TEXT column of dba_views against varchar2.
End result I want to find the views that reference a particular table within its text.
example (which ~obviously~ will not work):
select view_name
from dba_
te(l_cursor);
if (dbms_sql.fetch_rows(l_cursor)>0)
then
dbms_sql.column_value_long(l_cursor, 1, l_buflen, l_curpos ,
l_long_val, l_long_len );
end if;
dbms_sql.close_cursor(l_cursor);
return l_long_val;
end getlong;
-Original Mess
Title: os date, sysdate & time synchronization
I am considering ntpd to synchronize my server times but I wanted to check if there are any issues with actively synchronizing the system time when there is an oracle database involved. Does the db maintain its own time clock after its started so
Title: RE: arg list too long in unix
go into the "top dir" and run
find . -name "cz-session-*" | xargs rm -f
or
find . -name "cz-session-*" -exec rm -f {} \;
the first runs faster but keep in mind that
in other scenarios xargs splits stdin into
file names on space and newline.
-
Title: RE: ROWNUM strangeness?
show the full sql please, perhaps its how you are grouping your
conditions
Paul Baumgartel wrote:
>I've been given a query to investigate. The performance varies
>extremely depending on whether the entire result set is fetched or a
>ROWNUM < n clause is a
Title: RE: ALTER TABLE MOVE command causes table to grow
you didn't mention the PCT_INCREASE of this segment.
-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: ALTER TABLE MOVE
Title: RE: ALTER TABLE MOVE command causes table to grow
just to be certain we are on the same page,
you mention uniform sizing which is on
the tablespace level, so I want to make
sure the PCT_INCREASE you provided was pulled
from dba_segments. if so then i'd say a bit
more info would need t
Title: connection output on clone instance
can anyone guide me in changing the connect output:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
Where "Production" will be replaced with "TEST"
what are the drawbacks with such a trigger,
what if the code went invalid and would not compile is
it possible that you could lock yourself
out, or would the base login functionality still work regardless
or the status of this trigger?
-Original Message-From: Mercadante, Thomas F
Title: RE: Oracle Version on Unix
Chapter 7 Section "Changing the Word-Size of your Current Release"
within the Oracle 9i Database Migration Manual.
I dont see why you couldn't do: file ${ORACLE_HOME}/bin/oracle to
determine the word size.
-Original Message-
From: Mercadante, Tho
Title: RE: Decode
an example straight from 9i SQL Reference should do
SELECT product_id,
DECODE (warehouse_id, 1, 'Southlake',
2, 'San Francisco',
3, 'New Jersey',
4, 'Seattle',
57 matches
Mail list logo