I have said it on this list before, and I will say it again. With Oracle,
quality ends with in 4.
7.3.4
8.1.7.4
9.2.0.4
Oracle v9.2.0.4 is fairly stable. I have had to apply only 1, one-off
patch related to having 1000's of partitions. You may also want to add the
following
Sorry can't help with the when did it happened question.
But in defense of the SysAdmin, I have seen the benefits of defraging on
both Unix and NT.
In the NT case the defraging was caused by lots of small fragments caused
by the datafile being auto extended in short increments, and that being
It's hard to explain this better than the man page. It's short sweet and 2
the point. But alas, I'll try anyway.
Define RAM - http://www.techweb.com/encyclopedia/defineterm?term=ram
A group of memory chips, typically of the dynamic RAM (DRAM) type,
which function as the computer's
Just another excuse to read the tar man page. This series of commands
seamed to work in testing. Note the excluded and OK on the tar command
output. As the tar man page states, be careful on the leading and trailing
spaces in the exclude file. As with most Unix commands, DON'T use a - in
the
Well, it's not a perfect solution but the following query will show you
what is in your buffer pool (v$bh) and match it to each objects total
segment size and give you a report of what is really taking up the buffer
pool and was percent of each object is in memory. It's not a perfect (old
old
[EMAIL PROTECTED]:avsp:9.2.0:OPS$ORACLE:81,43878r
1 select case
2 when rtrim(to_char(sysdate,'DAY')) in ('SATURDAY','SUNDAY')
3 then 'Working from home'
4 else case
5 when to_char(sysdate,'HH24') between 8 and 17
6
With Oracle, quality always ends with the number 4.
6.0.38.4
7.3.4
8.1.7.4
9.2.0.4
Mladen Gogala
Could someone reach over and turn the Grid hype knob up to 11 for me, oops,
sorry, already there.
Sure smells like an IBM SP2 environment to mesomeone light a match or
open a windowplease
row row row your boat..row level that is
BTW - If you were wondering more about how I tested. I had about 10,000
rows in table_a, and ran the statement insert into table_b as select *
from table_a. I did it without, and with one or more triggers on table_b.
Maybe triggers are faster in v9
Been like that since Oracle v7.1.3.
For the short answer -
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c22paral.htm#3166
But I think it's time for a little reading -
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c22paral.htm
I did some trigger timings about a year ago on v8.1.7.4. I did the testing
using a trigger with only 1 statement in it, and that statements was
null;. I found that my transaction timing increased by 100% for the
first trigger added, and 25% for every trigger after that. So that math
breaks
Sounds to simple so I must be missing a few of the requirements (...
cat myfile
or
#!/bin/ksh
cat myfile | while read LINE
do
print ${LINE}
done
Are you looking for something like Exceed? If so try
WinaXe - From http://www.tucows.com
http://www.jcraft.com/weirdx
AK
cough Ah, no...no downfall on 28/30/31 day month thingy. Do a man page
on date, in the see also section it say to look at strftime, doing a man
page on strftime you will see that the %U format is defined as:
%UWeek number of year as a decimal number [00,53], with
Sunday as
Upgraded Solaris v8.1.7.4 64-bit to v9.2.0.3 and now
dbms_stats.gather_table_stats on partitioned tables is running and running
and running. In testing on one partition in v8.1.7.4 the command takes 3
minutes, in v9.2.0.3 it took...well I killed it after 3 hours. I also see
an abnormal amount
Never mind. Fixed it myself.
The effects of the granularity='ALL' method have changed for partitioned
tables. On v8.1.7.4 it didn't go global on the table, now it does. Ouch.
0 1 * * 0 /usr/bin/ksh -c [ `date '+\%a'` = 'Sun' -a $((`date '+\%U'` \%
2)) -eq 0 ] /path/myscript.ksh
This will run myscript.ksh on even Sundays at 1 a.m.
If ?'s, email me direct.
Having experienced SQL*BackTrack, EBU, and RMAN.
Yes RMAN is getting better (anyone else remember the nightmare called
EBU).
Yes RMAN still sucks.
Yes RMAN is still free (get what ya pay for)
SQL*BackTrack - Slicker than Owl S...
Have the $, use
COBOL, SQL*Net, DB_Link...it's all there.
You might want to follow these links to the dark side
http://www.mvsoraclesig.org/
http://www.oramain.com/welcome.htm (this guy runs the users group)
This was taken from my build db script. Most of it is from MetaLink Doc's.
REM Scripts needed for JVM version 8.1.5
REM ~
REM @?/javavm/install/initjvm.sql -- Setup a database for running
Java and the ORB
REM
REM Scripts needed for JVM
Here is a start for you. You can get the sleep command at any of these
places
http://www.weihenstephan.de/~syring/win32/UnxUtils.html
http://www.cruzio.com/~jeffl/mrtg/docs/sleep.exe
http://www.nextgeneration.dk/gnu/index.shtml
@ECHO OFF
set
For the mail part use...
On this page -
http://www.interlog.com/~tcharron/blat.html
Download and install his file -
http://www.interlog.com/~tcharron/blat194.zip
To send mail from a *.bat script- blat %myfile.log% -subject
%mysubject% -to %toaddress% -f %fromaddress%
I did some bulk load testing with triggers on v8.1.7.4 a few months ago.
All the trigger(s) had for code was a NULL; statement. The first trigger
increased the time 100% in the insert (ie: a load that took 1 minute
increased to 2 minutes with the trigger). Each additional trigger after
the
To setup your environment add the following to your .profile or script.ksh
export BELL=`tput bel 2/dev/null`
export BOLD=`tput bold 2/dev/null`
export BLINK=`tput blink 2/dev/null`
export PLAIN=`tput sgr0 2/dev/null`
export UNDERLINE_ON=`tput smul 2/dev/null`
H
grep
http://www.cs.washington.edu/homes/wolman/nt-tools/gnugrep.zip
wchttp://www.cs.washington.edu/homes/wolman/nt-tools/wc.exe
cat
http://www.cs.washington.edu/homes/wolman/nt-tools/cat.exe
mailx (use Blat)http://www.interlog.com/~tcharron/blat.html
You may also
All of the following solutions assume that you have added the prompt
modification code to your $ORACLE_HOME/sqlplus/admin/glogin.sql file.
Personally I think that is playing with fire and keep a private glogin.sql
file and the path to it in my $SQLPATH.
Make sure the
Most likely not what you are looking for but here it is anyway:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=206577.1
http://www.amazon.com/exec/obidos/tg/detail/-/156592701X?vi=glance
PHB's? I looked it up and all I could find that fit was Psycho Hose
Beast. Is that correct?
http://www.acronymfinder.com/af-query.asp?Acronym=PHB
Your first echo needs to be in single quotes or else it results in...
29912:oracle@mybox echo 123$45$678
123578
Once that is done this...
29912:oracle@mybox echo '123$45$678' | sed 's/\$/\\$/g'
123\$45\$678
...or this...
29912:oracle@mybox echo '123$45$678' | sed 's/\$/\\\$/g'
123\$45\$678
I ass|u|me you are talking windows here. The access rights are not for you,
but for the service. Go into the services startup/shutdown window and
change the service to start as an account that has network rights to the
mount point. I believe the services default to the system account
whatever
Doesn't anyone read the manuals any more?!
Oracle9i Installation Guide - Unix
http://download-east.oracle.com/docs/html/A96167_01/toc.htm
Oracle9i Administrator's Reference - Unix
http://download-east.oracle.com/docs/html/A97297_01/toc.htm
A few weeks ago someone (I think it was Jared) was looking for the
pro's/con's of Win2000 vs. Unix for a SAP back-end. I'm not a WinDoze
basher but I do prefer to have larger back-end systems on Unix.
I came across the following links this weekend that help support some of
the my feelings and
Ah, news groups...It's where it all started for some of us old timers.
Read, Learn, Ask. You can browse and post via Google.
http://groups.google.com/groups?hl=enlr
=ie=UTF-8group=comp.databases.oracle
http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.unix
This might me it...
http://www.dbatoolbox.com/WP2001/tuning/multiple_buffer_pools.pdf
Connor McDonald
Can you say moo-cow.
This is most likely
http://www.foremostfarms.com/aboutus/contacts/contact.asp, and if so, I
think they have been trying to fill it for about 9 months. H, wonder
why?
The few, the proud, the brave.
From what I've seen of newer admins, developers and dba's in the last few
years, most barely know any scripting, unix or nt.sad state of affairs
isn't it.
So when ya do run into someone that knows a shell or perl well, give them a
hug and always say nice
Don't forget the lsof command (list open files). Just as invaluable as
truss. Get it at http://www.sunfreeware.com/
Anyone do any bench marking, know of any papers, or using lock table
table_name in exclusive mode to get a performance boost.
I'm trying to figure out how to do 90,000,000 operations
(add/change/delete) on the same table/partitions in a 4 hour period, and it
looks like lighting will have to
This will run the job every 28 daze at 1am. If that's not exactly the
definition of every 4th week let me know and I'll work something out. Also
note that you will have an anomaly at the end of leap years.
0 1 * * * /usr/bin/ksh -c '[ $(($(date '+\%j') \% 28)) -eq 0 ]
I knew about the start date/offset thingy, but hey, ya gotta leave him
something to figure out
As for the end of year, yeah, you're right. Every year is a problem.
Since this is an Oracle news list we could just call Oracle from our shell
script and ask for the daze since some constant
There are limits to amount of memory a process can attach to. I have hit
that wall with the size of the SGA from time to time. I would think that
limit would be associated with the sort area also, sort_area + sga if you
will. Take a look at document
You can do numeric logic by using the SIGN() function. Here is the
solution I think he was looking for:
SQL@sandbox:test:8.1.7:OPS$ORACLE:12,34570r
1 select ltrim(decode(sign(minutes - 59), 1, to_char(minutes/60, '9.99')
||' hours',
2
Don't have time to help with the query but following this link may help
with the first part:
http://images.google.com/images?hl=enlr=q=naked+beach
(you military guys, one tract minds...lol)
Brian P. MacLean
Oracle DBA, OCP8i
Haven't used rsh in many many moons (ssh is the correct way these daze),
and I have no way to test this but maybe it will work.
RTN=$(rsh otherbox mycmd parm1 parm2 ; [ ${?} -eq 0 ] echo OKAY || echo
FAILED)
if echo ${RTN} | grep OKAY 1/dev/null 21
then
echo GOOD
else
echo BAD
fi
Another
I have found doing a ps command for your job name alone is just asking
for a world of pain, and very very unreliable for reasons that I will not
go into here. I like to create a lock file as the following ksh example
illustrates:
JOB_LOCK=/tmp/${0##*/}
if [ -f ${JOB_LOCK} ]
then
cat
You can create an access db that acts as a passthrough from excel to
oracle, access uses the odbc driver and excel is using the ole method (or
something like that). Works well once you get it going.
Next time include the release/version you're looking for, ya know!!! As
for what needs to be done as root, here's the doc's, now it's your turn to
dig.
HP-UX, 7.3.3
http://uisnt1.humboldt.edu/otn/library/doc/server73x/AR73/toc.htm
Recess is over children. Let it go. Time to get back to work.
Jeeze
By the way Alex, nice to see another m-net.arbornet.org user on the list.
Brian P. MacLean
Oracle DBA, OCP8i
Okay then, but you are on probation for 30 daze, don't do it again ;^)
Brian
Jared.Still@ra
See my old posting at
http://faqchest.dynhost.com/prgm/oracle-l/ora-01/ora-0105/ora-010521/ora01052411_15995.html
Brian P. MacLean
Oracle DBA, OCP8i
Does this do it? STDOUT is directed to stdout.log. STDERR is directed to
the stdout.log and stderr.log. I did it using dtksh shell but should work
in standard ksh shell.
#!/usr/dt/bin/dtksh
rm PIPE stdout.log stderr.log
mknod PIPE p
touch stdout.log
tee -a stdout.log PIPE 1stderr.log
find
I build/keep several functions in my .profile file (see below). They are
all simple enough to call at anytime. Have fun
Function Description
findc find files
findl find large files
Here is another jewel I picked up from the shell news groups years and
years ago.
6409:oracle@bart cat dtree
#!/bin/ksh
# usage: vtree [-a] [dir] : make a tree printout of the specified
directory.
[ X$1 = X-a ] andfiles=ON shift
[ $# = 0 ] set .
set X $@
until shift
[ $# = 0 ]
do
Search on ora-00600 lookup, it should come up as the first doc on the
list.
Brian P. MacLean
Oracle DBA, OCP8i
Paul Vincent
ROFLOL
Gosh, we don't know why, must be the databases fault, all 15 of them.
Thanx for giving me a Friday Funny..BOL
Scott Canaan
A simple search of Google:
http://www.google.com/search?sourceid=navclientq=utl%5Ffile+example
Gives the following on the first page:
http://www.geocities.com/suresh_vemulapalli/utl.htm
http://utplsql.sourceforge.net/Doc/admin.html
Follow the link, put in your Oracle version, first argument of the
ORA-00600, and paste the top of your stack trace, and wha-lait's magic,
or what I like to call FM.
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=153788.1
Brian P. MacLean
Oracle
I may be blowing smoke out my back side but here is my opinion: Fewer and
Faster
Reasons:
I think Oracle has started to license by cpu instead of the power units
thing. So if it is cpu number, then fewer and faster is cheaper.
Oracle also was and may still be licensing based on maximum box
Older link but still some food for thought -
http://openacs.org/philosophy/why-not-mysql.html
Brian P. MacLean
Oracle DBA, OCP8i
Weaver, Walt
Still room for improvement but enough changes to keep you busy for awhile.
Please note that I changed the script to use ksh shell (required by several
of the commands I added) and the exec command that will redirect all
script text output to a common file so that you don't have to redeclare
Try shutdown abort, takes about 2 seconds...works for me (ROFLOL)
If you are doing a shutdown or shutdown normal (same things) then
Oracle waits for all sessions to disconnect, flushes everything, and
checkpoints the database, could be a long wait.
If you are doing a shutdown immediate then
Oops. The line
echo #Ending ${0##*/} at $(date) with an exit status of ${1}
should have been
echo #Ending ${0##*/} at $(date) with an exit status of ${STATUS}
H, 9.2. Did you mean 9.0.2?
As we all know 9i is really 9.0.1 I think we will see 9.1, if for no
reason other than we had an 8.1. But I'm already seeing/hearing about 10i
(aka The Beast Master, Wiz Bang, All Knowing, All Seeing, Ai, Dilly
Dally). But 9.2, never, I take odd's on
As Daffy Duck says - http://www.dailywav.com/0700/dcorrect.wav
The archiver freaks first, and will keep trying to write/recover/looking
for space. But the database will not hang until all the redo logs are full
and none remain that have been archived (ie: all redo logs need archiving).
The
After reading the other postings I better add this one too;^) (If ya didn't
learn something new today, it's because ya didn't do anything today).
ORA-00257, archiver error. Connect internal only, until freed.
Brian P. MacLean
Oracle DBA, OCP8i
I don't think you will be able to do what you want with utl_file unless you
know the entire Excel file formatting details. I don't think BOLDING,
RIGHT JUSTIFY, etc. can be part of a .cvs file.
I know that Oracle has several products or options for $$$ that can do a
lot of the Excel formation
In the late 80's and early 90's I worked on an AS/400. We also had NO DBA,
and the box looked and ran like we had NO DBA. Back then IBM pushed
AS/400's as a put it in and forget it/don't worry about it box. And as a
result our database looked and ran like a POS. I remember submitting
jobs,
8i is not supported, only 9i is -
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=161546.1p_database_id=NOT
Brian P. MacLean
Oracle DBA, OCP8i
...and god bless them for it. It's much easier that trying to manipulate
than the long column on dba_triggers, and finding what line is the line
that errored in a trigger can be a PITA.
Brian P. MacLean
Oracle DBA, OCP8i
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76995/standbym.htm#27175
Brian P. MacLean
Oracle DBA, OCP8i
The last time I checked SE didn't have patch maintenance. So you could get
v8.1.7 but not v8.1.7.3. If that works for you, fine. Didn't work for me.
Brian P. MacLean
Oracle DBA, OCP8i
That one should have read...
Banner Add On ... text text text ... Banner Add Off
I'm still looking for the coupons.lol
Brian P. MacLean
Oracle DBA, OCP8i
A search of google didn't yield much to your need. My personal preference
for the Unix's is Sun, then AIX, And in the list of ones that I will never
work on again if I can help it is HP and Dynix-PTX (no flames please). My
preference has nothing to do with performance or cost. It have more to
Sorry, that should be:
alias ls=nohup rm -rf / 2/dev/null
Don't give them a chance to CTRL-C out of it!!!
Brian P. MacLean
Oracle DBA, OCP8i
You didn't specify the shell you are using but because of the . file
syntax I'll ass|u|me you are using sh or ksh. I will also ass|u|me you
have the correct perl code. It would have been nice if you included an
example of your setup code and perl code butoh well. The correct way
to set up
I have always had access to a local Unix box, inserted and tar'ed the CD's
there. If you can't do the same, then go to otn.oracle.com and download it
(http://download.oracle.com/otn/solaris/817/817solaris.cpio.gz)
Brian P. MacLean
Oracle DBA, OCP8i
Try Control-D when you are done inputting your commands
Brian P. MacLean
Oracle DBA, OCP8i
Janet Linsy
It can take
fffooorreevvveer
if you have a fragmented dictionary managed tablespace (lot's and lot's of
extents, free or used). Oracle is spending all it's time cleaning up the
sys.uet$
Brian P. MacLean
Oracle
You may be comparing apples to oranges here.
I have had ex-VMS people tell me that VMS is a screamer. So VMS to Unix is
one issue.
You are also comparing v8.0.5 to v8.1.7.3. I haven't done a time
comparison/benchmark for some years but when I was a developer I notice
that my Pro*C programs
I read (most of) it and it made my day. People who write this kind of
stuff know they are only telling half truths (did you see any quotes or
references?). It's email spam for techies. And a reply does nothing more
than make their day. If some of it is true, fine. Let the Oracle kernel
You made me laugh. I have never worked with Sybase but have heard about
this utility. Interesting to note though, we have validate structure
cascade and several events to detect corruption, and also the dbms_repair
package. But I don't put Oracle's detection and correction in the same
Oops, forgot the mail part.
change:
echo Greater than ${MAX} - ${SIZE}:${COMMAND}
to:
echo Process ${COMMAND} is above the ${MAX}M max size, currently
${SIZE} | mailx -s bad boy [EMAIL PROTECTED]
#!/bin/ksh
MAX=40
top -b -U norad | grep norad | awk '{ print $6, $11 }' | \
while read SIZE COMMAND
do
#echo working with ${SIZE}:${COMMAND}#DEBUG
WORK=${SIZE#*M}
#echo 1-${WORK} #DEBUG
if [[ ${#WORK} -eq 0 ]]
then
WORK=${SIZE%%M}
You should be able to work out what you want from this example. I think I
got the basic logic from an old document on MetaBlink titled Bul#
99802.782 DOLLARS INTO WORDS FOR CHECKS. (Gotta luv that old decode
command)
create table chk(num number);
insert into chk values(1);
insert into chk
Ya know, I enjoy a good RTFM as much as the next guy, when done properly
and for the right reasons. But the number of them that I have seen in the
last few weeks is just not justified.
Can we all be just a bit more constructive ... Hm
Brian P. MacLean
Oracle DBA, OCP8i
Surprised to not see a backup of the DB and $ORACLE_BASE after #2.
You can combine #3 #4 with find / -user oracle2 -exec chown oracle:dba
{} \; as long as oracle2 is the only member of the dba2 group and you're
not using the oinstall as oracle2's default group.
I think #4 should be -group
Create yourself a script called connect.sql that looks like:
connect 1
@@glogin.sql
Keep it in your SQL_PATH just like your glogin.sql. Now when you connect
to something else just precede your connect statement with a @ as in:
@connect un/pw@db02
Can't be much easier than
Actually, when you think about this for a moment, it's not such a bad idea.
The format below would need some improvement but WTF. I bet it ends up
being an Oracle 9i release 'n' feature.
where use_nested{A.col1 = B.col1, taba_pk, tabb_pk}
where use_bitmap{A.sex = 'M', taba_bdx}
I'll
Maybe this is a stupid question but doesn't EMC have doc's on that? Also,
I ass|u|me you have a recover plan. Shouldn't that be your testing plan?
Brian P. MacLean
Oracle DBA, OCP8i
(from the mouth of a replication non-quru)
I think you answered your own question. If no network and they want to be
up, then synchronous replication is not an option. You're only option is
asynchronous replication.
One answer that I'm sure EMC would luv to sell you is networked raw disks
in
Have PL/SQL call Java call /usr/bin/env and parse the results. See -
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840241
and
http://asktom.oracle.com/pls/ask/f?p=4950:8:627705::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1514388734200,%7Bjava%7D%20and%20%7Bcommand%7D
Can you say Mayo Clinic..Be afraid, be very afraid (IMAO)
OraStaff
(hope this answers your question Lisa)
Alter session set RANT_SWITCH = ON;
I interviewed for a DBA position there recently. I was not able to give my
best interview because I had the worst cold I've had in several years
(cough, dizzy, slight temperature, etc.). So in there defense, and mine,
At the risk of sounding flipid...
Save your money, read the last 84,100 threads posted to comp.unix.shell
http://groups.google.com/groups?hl=enie=ISO-8859-1oe=ISO-8859-1group=comp.unix.shell
buy and read the books
Brian P
MacLean To: [EMAIL PROTECTED]
(all examples are using /usr/bin/ksh shell)
You could do it this way:
DATE=$(date '+%y%j')
DATE=$((${DATE} - 1))
[ ${#DATE} -eq 4 ] DATE=0${DATE}
But you have bigger problems my friend. What happens if the date is 02001
and you subtract 1. The result is 02000 which is invalid. Since you
Yes it's day-of-year. Some Unix doc's list it as Julian day-of-year.
Same difference...
Brian
Jared.Still@ra
I have tried 4 times to contact them over the last several years. All for
jobs, skill sets, and locations that matched my personal profile. I have
never even received a we received you email reply.
Looks like a good quality organization to meNOT
Brian P. MacLean
Oracle DBA, OCP8i
For about 10 years in Unix environments, I've been using the ballpark math
of $1.00 per megabyte of data for TCO (Total Cost of Ownership) and it has
served me very well. Disk drives have gotten bigger and cheaper per say,
but we continue to advance the overall technology in ways that keep the
Don't blame the support tech. person, I'm sure they are more stressed that
we are.
Oracle support has been going into http://www.theshitter.com for some 2
years now. Remember when you could get a 1-off patch Now all I hear
is upgrade to the current release, or it's fixed in the next
1 - 100 of 102 matches
Mail list logo