DBA_TAB_MODIFICATIONS - Performance impact?
Title: DDL alter in execute immediate pl/sql procedure - dynamic sql Anybody using the "ALTER TABLE tablename MONITORING;" functionality? Just wondering what the performance impact of implementing the features outlined in MetaLink Doc 102334.1 was. Or is this another performance debate like setting "timed_sadistics= true" was/is? http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=102334.1
RE: backup unix script
I believe the it is as follows: Run SQL*Plus | THIS SHOULD NOT BE HERE | | database username | | | database password | | | | Redirect output to file filename.dat | | | | | Read input up to the next line starting with !, | | | | | | this is what is called a here-document, for more | | | | | | on here-documents see any man page for sh or ksh | | | | | | sqlplus - sys/msd filename.dat ! -Original Message- Sent: Thursday, November 29, 2001 1:10 AM To: Multiple recipients of list ORACLE-L grace wrote: hi gurus, I found this unix script ... can any tell me what this means? sqlplus - sys/msd filename.dat ! does anyone have a unix script to perform a database backups? Best Regards, Grace Lim Suy Sing Comm'l Corp. (632)-2474134 Your Unix script seems to take as input the output from another process and spooling its own output to filename.dat ... There should be Korn shell Unix scripts to perform both cold and hot backups on the Oriole site, in the toolkit section, and on probably many other sites as well. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian MacLean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Destination address unreachable
The utility is not included with Solaris until 2.8. You'll have to get it from http://www.sunfreeware.com/ Solaris 2.6 - http://www.sunfreeware.com/programlist.html#gzip Solaris 2.7 - http://www.sunfreeware.com/programlistsparc7.html#gzip -Original Message- Sent: Tuesday, November 27, 2001 4:47 PM To: Multiple recipients of list ORACLE-L -- From: Baker, Barbara Sent: Tuesday, November 27, 2001 4:42 PM To: '[EMAIL PROTECTED]' Subject: FW: unzip utility information You might have a pathing problem (i.e., unzip is there, but you have to specify the full directory path to execute it.) at the command line, type which unzip This should find the unzip utility down the correct path. If it returns a result, try specifying the full path name, for example /usr/bin/unzip OEM204_1.zip Good luck! Barb -- From: hari babu gottipati[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Subject: unzip utility information hi friends if anyone knows about the unzip command in solaris 2.6/2.7 .please mail me.ex.OEM204_1.zip file.and i am not getting unzip command by using man pages.can i needed to down load any unzip file. pl. mail command as early thanking to all -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian MacLean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
25 words or less - ETL's - opinions (best of) and nightmares (my
Come on everyone. In 25 words or less. What I like or dislike about my ETL tool. The ETL feature I like most is __. The ETL feature I wish I had most is __. If I had it to do all over again I would . The SOB that bought ___ should be nailed to a ___ and left to _. Buying ___ was the best decision I ever made because . IMAO __. (More than 25 words if ya want to, I just didn't want to pressure anyone. Ranters, please feel free to go on for days) TIA Brian Petronius on Reorganization --- We trained hard -- but it seemed that every time we were beginning to form up into teams, we would be reorganized. I was to learn that later in life we tend to meet any new situation by reorganizing, and the wonderful method it can be for creating the illusion of progress while producing confusion, inefficiency and demoralization. -- Petronius Arbiter, 66 CE -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian MacLean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: date format in ksh
Use the /usr/sadm/bin/valdate command and
check the return status. Examples:
--GOOD DATE--
12322:oracle@e6500a valdate -f "%e-%b-%Y"
1-jan-200112322:oracle@e6500a echo $?0
--BAD DATE--
12322:oracle@e6500a valdate -f "%e-%b-%Y"
41-JaN-200112322:oracle@e6500a echo $?1
The valdate command doesn't seam to like leading 0's
(zero's) so you can just use sed to strip it off. This example should do
most of what ya need:
12322:oracle@e6500a cat
dateck.ksh#!/bin/ksh
vDATE="${1}"if valdate -f "%e-%b-%Y" $(echo
"${vDATE}" | sed "s/^0//")then echo "Good date
${vDATE}"else echo "Bad date ${vDATE}"fi
12322:oracle@e6500a dateck.ksh 41-mar-2001Bad
date 41-mar-200112322:oracle@e6500a dateck.ksh 01-Mar-2001Good date
01-Mar-2001
-Original Message-From: Suhen Pather
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25,
2001 8:00 PMTo: Multiple recipients of list
ORACLE-LSubject: date format in ksh
List,
Sorry to deviate from the topic,
but
I am writing a korn shell script
that would exit if the date format is
incorrect.
I just need something to compare
the date format passed in with
DD-MON-.
Eg.
I am passing an argument to my ksh
script being the date.
If the date is in any other format
but DD-MON- the ksh must exit.
Eg. sh test.ksh 02/05/1999
It must
exit.
The only format excepted should be
sh test.ksh
02-MON-
TIA
Regards
Suhen
RE: sequence pool
Why not have the sequence increment by 20 (or something to your liking) and then in the application use the number from the sequence and the 19 numbers the sequence will skip. -Original Message- Sent: Wednesday, October 24, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Hi, is there a smart way to generate IDs in chunks? getting an ID with nextval is perfectly ok most of the time, but sometimes the application would need to generate a pool of IDs and keep them for later use as I can't manipulate the currval of the sequence, I wander what the best solution would be thanx, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian MacLean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to detect transactions being rolled back?
TRANS, vr.curext, vr.curblk, vts.sid ef, vts.start_time, vts.start_uext, vts.start_ubablk, vts.used_ublk, (vts.used_ublk * (vp.value / 1024)) SUK, vts.used_urec from v$parameter vp, v$rollstat vr, dba_segments ds, dba_rollback_segs drs, ( select vt.xidusn, vs.sid, vt.start_time, vt.start_uext, vt.start_ubablk, vt.used_ublk, vt.used_urec from v$transaction vt, v$session vs where vt.addr = vs.taddr ) vts, ( select vt.xidusn, sum(vt.used_ublk) s_used_ublk, sum(vt.used_urec) s_used_urec from v$transaction vt group by vt.xidusn ) vtss where ds.segment_type = 'ROLLBACK' and ds.segment_name = drs.segment_name and drs.segment_id = vr.usn and drs.segment_id = vts.xidusn (+) and drs.segment_id = vtss.xidusn (+) and vp.name = 'db_block_size' order by ds.segment_name, drs.initial_extent / 1048576, drs.next_extent / 1048576, ds.extents, (ds.blocks * (vp.value / 1024)) / 1024, vr.optsize / 1048576, vr.hwmsize / 1048576, (vtss.s_used_ublk * (vp.value / 1024)) / 1024, (vtss.s_used_ublk / ds.blocks) * 100, vr.shrinks, vr.xacts, vr.curext, vr.curblk; prompt ttitle '* USERS WITH ACTIVE TRANSACTIONS ' col bb heading Unix|User format a10 col cc heading Oracle|User|Name format a10 col dd heading Pgm|Unix|Pid format a6 col ee heading Oracle|Unix|Pid format a6 col ef heading Oracle|Session|ID format 99 col eg heading Serial# format 99 col ff heading TTY# format a7 col gg heading Program Name format a48 col hh heading Server|Type format a9 col ii heading Statusformat a9 col jj heading Rollback|Segment format a10 col kk heading Current SQL Statement format a160 select unique vs.osuser bb, vs.username cc, vs.process dd, vp.spid ee, vs.sid ef, vs.serial# eg, vs.terminal ff, vs.program gg, vs.status ii, vr.name jj, vsql.sql_text kk from v$rollname vr, v$transaction vt, v$sql vsql, v$process vp, v$session vs where vs.paddr = vp.addr and vs.sql_address = vsql.address (+) and vs.sql_hash_value = vsql.hash_value (+) and vs.taddr = vt.addr and vt.xidusn = vr.usn; exit; REM END OF FILE === -Original Message- From: Lau, John [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 9:00 AM To: Multiple recipients of list ORACLE-L Subject: How to detect transactions being rolled back? Is there a way to detect if a transaction is currently being rolled back? ie. If it fails part way thru or is cancelled by the user? Thanks in advance, John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian MacLean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on OS390/MVS
Call this guy, tell him he owes me for continuing to refer people (lol) http://www.oramain.com/ -Original Message- Sent: Friday, September 14, 2001 11:36 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! We're looking at possibly running Oracle on our mainframe, but the perception exists that a more optimum solution would be DB2. I would appreciate hearing from anyone that is running Oracle on OS390, and/or made a decision between DB2 and Oracle. Thanks - Kim Thompson City and County of San Francisco -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian MacLean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Licensing cost for 1000 concurrent users?
Title: RE: Licensing cost for 1000 concurrent users? Yes you are getting screwed, but for that matter we all are. Oracle licensing always reminds me of an acronym I learned in the military...BOHICA...You can get the definition at either of the following links. http://ase.isu.edu/ase01_07/ase01_07/bookcase/ref_sh/foldoc/79/10.htm http://www.acronymfinder.com/af-query.asp?String=exact=BOHICA=Find One thing you may want to look at is term licensing. A 2 year term (license) is 35% of a normal license, and a 4 year is 65%. Another option is to run only SE on a max 4 cpu box and divide your db's onto multiple 4 cpu boxes. The savings are bigtime as long as you don't need any of the EE features. If you need more info call me and I can explain the details. Brian 480.551.3750 -Original Message- From: Thomas Jeff [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 4:26 PM To: Multiple recipients of list ORACLE-L Subject: Licensing cost for 1000 concurrent users? We are in the process of negotiating our contract with Oracle. I've been asked to inquire as to how much other sites are paying for a license for 1000 concurrent users. We are looking in the ballpark of $400-$500k according to the Oracle negotiators. I would appreciate if you either tell me how much you are paying for such a license, or simply inform me as to whether we are below, par, or higher then what you pay now. We'd just like to determine whether we are getting screwed or at least comparable to other sites. Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
RE: Oracle license costs
Title: Oracle license costs se/wg 15K web license per cpu( 4 cpu's must buy ee) ee 40k web license per cpu strait names user license, 400 per user on se/wg, 800 per user on ee If you want to save $$ for now, do term licensing, 35% of total for 2 year license, 65% of total for 4 year license -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 23, 2001 2:40 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle license costs Hi - I'm sorry to bring this up again - I know it was discussed fairly recently .. Where can I find information on Oracle's new pricing structure? We are looking for additional licenses to run on a new Sun Solaris machine. I seem to remember that license costs were related directly to number of CPUs(?) If someone can point me to a web url for this information, I would greatly appreciate it. Thank you - Lisa
Tuning an Oracle/Unix file system - Sun/OS 5.6 Oracle v8.1.7.2
Title: Tuning an Oracle/Unix file system - Sun/OS 5.6 Oracle v8.1.7.2 Anybody play with tuning a UFS containing only Oracle datafiles? I'm interested particularly in the tunefs -m minfree ... and the mount forcedirectio ... command options, but if you have other suggestions please note them. TIA Brian
RE: 2 Gb file limit problem
How about using a pipe and the split command if necessary? Ifyour unix machine can handle files greaterthan 2 gig's but just SQL*Plus can't, then: 1) mknod pipe.lst p 2) cat pipe.lst mybigfile 3) sqlplus u/p spool pipe.lst @my_commands.lst spool off exit 4) rm pipe.lst If the unix machine also has a 2 gig limit, then: 1) mknod pipe.lst p 2) split -b 1073741824 pipe.lst mybigfile_ 3) sqlplus u/p spool pipe.lst @my_commands.lst spool off exit 4) rm pipe.lst These examples should give you enough to work with. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Monday, July 30, 2001 12:52 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 2 Gb file limit problem how about this: (avg_row_size +delimiters)* number_of_rows = total bytes. total bytes / 19 = number of pieces. number_of_rows / number_of_pieces = number of rows per piece select number of rows needed multiple times, spooling each one individually. then sqlldr all the pieces. joe [EMAIL PROTECTED] 07/30/01 02:20PM Hi List, I need to transport few tables from one instance to another and of course found the sqlldr method much faster than the exp/imp. But the problems is for large tables .When I spool such input tables to a flat file , it stops spooling into it afterabout 2 Gb.Any possible solutions to get around it.I am on AIX 4.3.3/8.1.5 My ulimits on AIX are time(seconds) unlimitedfile(blocks) unlimiteddata(kbytes) unlimitedstack(kbytes) unlimitedmemory(kbytes) unlimitedcoredump(blocks) unlimitednofiles(descriptors) 2000 Thanks Satish
RE: Year of Unix file
Title: RE: Year of Unix file
save the following as fstat.c, compile it with cc -o fstat fstat.c, then run it as fstat myfile
#include stdio.h
#include sys/types.h
#include sys/stat.h
#include errno.h
#include time.h
int rtn;
struct stat buf_st;
struct tm *tm_st;
main( argc, argv, envp)
int argc;
char **argv, **envp;
{
time_t now;
if( argc != 2 )
{
fprintf( stderr, Error: number of args\n );
exit( 1 );
}
rtn = stat( argv[1], buf_st );
if( rtn != 0 )
{
fprintf( stderr, stat() return code=%d\n, rtn );
perror( error text= );
exit(1);
}
fprintf( stderr, FILE=%s\n, argv[1] );
fprintf( stderr, SIZE=%d\n, buf_st.st_size );
fprintf( stderr, MODE=%d\n, buf_st.st_mode );
tm_st = localtime( buf_st.st_mtime );
fprintf( stderr, MTIME=%10.10d - %2.2d/%2.2d/%2.2d %2.2d:%2.2d:%2.2d -%s,
buf_st.st_mtime,
tm_st-tm_mon + 1, tm_st-tm_mday, tm_st-tm_year - 100,
tm_st-tm_hour, tm_st-tm_min, tm_st-tm_sec,
ctime( buf_st.st_mtime ) );
tm_st = localtime( buf_st.st_atime );
fprintf( stderr, ATIME=%10.10d - %2.2d/%2.2d/%2.2d %2.2d:%2.2d:%2.2d -%s,
buf_st.st_atime,
tm_st-tm_mon + 1, tm_st-tm_mday, tm_st-tm_year - 100,
tm_st-tm_hour, tm_st-tm_min, tm_st-tm_sec,
ctime( buf_st.st_atime ) );
tm_st = localtime( buf_st.st_ctime );
fprintf( stderr, CTIME=%10.10d - %2.2d/%2.2d/%2.2d %2.2d:%2.2d:%2.2d -%s,
buf_st.st_ctime,
tm_st-tm_mon + 1, tm_st-tm_mday, tm_st-tm_year - 100,
tm_st-tm_hour, tm_st-tm_min, tm_st-tm_sec,
ctime( buf_st.st_ctime ) );
time( now );
tm_st = localtime( now );
fprintf( stderr, NOW =%10.10d - %2.2d/%2.2d/%2.2d %2.2d:%2.2d:%2.2d -%s,
now,
tm_st-tm_mon + 1, tm_st-tm_mday, tm_st-tm_year - 100,
tm_st-tm_hour, tm_st-tm_min, tm_st-tm_sec,
ctime( now ) );
now = 0;
tm_st = localtime( now );
fprintf( stderr, EPOCH=%10.10d - %2.2d/%2.2d/%2.2d %2.2d:%2.2d:%2.2d -%s,
now,
tm_st-tm_mon + 1, tm_st-tm_mday, tm_st-tm_year,
tm_st-tm_hour, tm_st-tm_min, tm_st-tm_sec,
ctime( now ) );
}
-Original Message-
From: prasad maganti [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 4:11 AM
To: Multiple recipients of list ORACLE-L
Subject: Year of Unix file
Hi dba's
when i list the unix file (solaris), with ls -lt
command , i am able to see the time, month, date that
is created.
is there any way to see the year that is created.
any commands
prasad.
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: prasad maganti
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: how much ram per oracle process?
Title: RE: how much ram per oracle process?
I have included a bit of text from the Oracle8i Administrator's Reference Release 3 (8.1.7) for Sun SPARC Solaris Part Number A85349-01. Note the script that is about 40 lines down.
Oracle8i Memory Requirements and Usage
Calculate memory usage requirements to determine the number of users that can be on the system. This will also help in determining the physical memory and swap space requirements. To calculate the memory requirements, use the following formula:
size of the oracle executable text
+ size of the SGA
+ n * ( size of tool executables private data section
+ size of oracle executables uninitialized data section
+ 8192 bytes for the stack
+ 2048 bytes for the processes user area)
where n = number of background processes.
For each client-server connection, use the following formula to estimate virtual memory requirements:
size of oracle executable data section
+ size of oracle executables uninitialized data section
+ 8192 bytes for the stack
+ 2048 bytes for processes user area
+ cursor area needed for the application
Use the size command to estimate an executable's text size, private data section size, and uninitialized data section size (or DSS). Program text is only counted once, no matter how many times the program is invoked, because Oracle executable text is shared.
To calculate the Oracle physical memory (background and shadow processes) usage while the database is up and users are connected to it, use the pmap command. Sum the shared sections (indicated by read/write/exec/shared and read/exec) for the pmon process. Sum the private section (indicated by read/write/exec) for each shadow and background process, including pmon. Background process names begin with ora_, and end with the SID. Shadow process names begin with oracleSID.
Calculating acutal memory usage
Use the following script to show the actual memory usage.
#!/usr/bin/sh
# Copyright 2000 Oracle Corporation
#
# modification history:
# date by comments
# --
# 07/15/2000 rgulledg original program
#
usage()
{
echo Usage: $0 [ SB ]
echo Usage: $0 [ P pid ]
echo Usage: $0 [ h ]
echo
echo specify 'S' for Oracle shadow processes
echo specify 'B' for Oracle background processes (includes shared
memory SGA)
echo specify 'h' for help
echo
}
echo
#
# check usage
#
if [ $# = 0 ];then
usage;exit 1
fi
if [ $1 = h ];then
echo This script uses the Sun Solaris pmap command to determine
memory usage
echo for Oracle server [B]ackground processes and/or [S]hadow
processes.
echo An individual [P]rocess can also be specified.
echo
echo Although the Oracle server background processes memory usage
should
echo remain fairly constant, the memory used by any given shadow
process
echo can vary greatly. This script shows only a snapshot of the
current
echo memory usage for the processes specified.
echo
echo The 'B' option shows the sum of memory usage for all Oracle server
echo background processes, including shared memory like the SGA.
echo
echo The 'S' option shows the sum of private memory usage by all
echo shadow processes. It does not include any shared memory like the
echo SGA since these are part of the Oracle server background processes.
echo
echo The 'P' option shows memory usage for a specified process, broken
echo into two categories, private and shared. If the same executable
echo for this process was invoked again, only the private memory
echo would be allocated, the rest is shared with the currently running
echo process.
echo
usage;exit 1
fi
echo $1|grep [SBP] /dev/null
ParmFound=$?
if [ $ParmFound != 0 ];then
usage;exit 1
fi
echo $1|grep P /dev/null
ParmFound=$?
if [ $ParmFound = 0 ];then
if [ $1 != P ];then
usage;exit 1
fi
if [ X$2 = X ];then
usage;exit 1
fi
echo $2|grep [0-9] /dev/null
ParmFound=$?
if [ $ParmFound != 0 ];then
usage;exit 1
fi
PidOwner=`ps -ef | grep -v grep | grep $2 | grep -v $0 | awk '{print \
$1}'`
CurOwner=`/usr/xpg4/bin/id -un`
if [ X$PidOwner != X$CurOwner ];then
echo Not owner of pid $2, or pid $2 does not exist
echo
usage;exit 1
fi
else
if [ X${ORACLE_SID} = X ];then
echo You must set ORACLE_SID first
usage;exit1
fi
fi
#
# initialize variables
#
Pmap=/usr/proc/bin/pmap
SharUse=/tmp/omemuseS$$
PrivUse=/tmp/omemuseP$$
ShadUse=/tmp/omemuseD$$
PidPUse=/tmp/omemusePP$$
PidSUse=/tmp/omemusePS$$
TotalShad=0
TotalShar=0
TotalPriv=0
PidPriv=0
PidShar=0
#
# shadow processes
#
echo $1|grep S /dev/null
ParmFound=$?
if [ $ParmFound = 0 ];then
ShadPrc=`ps -ef|grep -v grep|grep oracle$ORACLE_SID|awk '{print $2}'`
echo $ShadUse
for i in $ShadPrc;do
$Pmap $i | grep read/write | grep -v shared | \
awk '{print $2}' | awk -FK '{print $1}' $ShadUse
done
for i in `cat $ShadUse`;do
TotalShad=`expr $TotalShad + $i`
done
TotalShad=`expr $TotalShad * 1024`
echo Total Shadow (bytes) : $TotalShad
/bin/rm $ShadUse
fi
#
# non-shared portion of
RE: Auto Extend
Title: RE: Auto Extend See Note:62427.1, 2Gb or Not 2Gb - File limits in Oracle http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT_id=62427.1 -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Auto Extend Depends is the standard answer. Oracle can handle files over 2g, some unixes can, some unixes cannot, some say they can but cannot etc etc... To compound things, in some versions, Oracle will let the file go beyond 2g, only then to complain because the unix won't let Oracle get to the bits after 2G - thus corrupt db. Unless you're on raw, I'd recommend a ceiling of 2g on any datafile - just to be safe hth connor --- Smith, Ron L. [EMAIL PROTECTED] wrote: I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: About parallel server
Title: RE: About parallel server Several things: You will have to re-license (your honest aren't you) for the faster machines and OPS; Build the new database on raw and export/import. Maybe dd would get your datafiles from cooked ufs to raw but it's to much FUD for me; You can backup using the dd command, SQLBackTrack (BMC), or RMAN (I think RMAN now support OPS but you will need to check); If you do not build your application with OPS in mind you will be slower on two machines with 4 cpu's each than you would be with one machine with 4 cpu's. Read up on block pinging, reverse key indexes, PCM locks, and free lists. You MUST take the OPS course from Oracle Education. The instructor is Scott Hiesey who is the best damn instructor Oracle has. He is also an infrequent contributor to this list. Read it, learn it, know it, live it - http://www.oreilly.com/catalog/oraclepp/ and http://www.oradoc.com/ora817/paraserv.817/index.htm I'm sure some people use and like OPS (my hats of to you) but I have and from a business point of view would never do it again. If after all that you still want to use OPS, then...go...right...ahead. BOL -Original Message- From: Fernando Papa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 3:07 PM To: Multiple recipients of list ORACLE-L Subject: About parallel server Hi everybody! I have some questions about parallel server. Now we have only one instance stand-alone (no parallel), but we are thinking to switch to parallel server because we have a couple of sparc 3500 and nobody are using it, and we think it's good for increase our processing power. The problem is I didn't work with parallel server and I have a lot of questions about it: 1) Is mandatory to use raw devices for control files, redo logs data files? 2) How we transfer our cooked data files to raw devices data files? import/export? or exist another better (fast) method? 3) If I start with only one node, performance will be the same of one single instance (no parallel)? 4) Somebody know how to work with raw devices under solaris? any link? I try to found someting in metalink but there's no samples... 5) What about backup? I can't put tablespaces in backup mode and copy with cp... maybe it's time to use rman? Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: About parallel server
Title: RE: About parallel server Your point 1: Unless things have changed redo and controlfiles must be raw. When I took the OPS course several years ago and worked with OPS we needed the redo/controlfiles to be on raw so that one instance could recover when another instance failed. Your point 5: The Unix command dd will do raw. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 3:48 PM To: Multiple recipients of list ORACLE-L Subject: Re:About parallel server Fernando, Replies included in your original mail, but in addition: Parallel server is a separately priced option from Oracle and it is pricey. Second you may need specific software from you OS vendor to coordinate the file sharing between the servers, again an additional expense. Dick Goulet Reply Separator Author: Fernando Papa [EMAIL PROTECTED] Date: 5/30/2001 2:07 PM Hi everybody! I have some questions about parallel server. Now we have only one instance stand-alone (no parallel), but we are thinking to switch to parallel server because we have a couple of sparc 3500 and nobody are using it, and we think it's good for increase our processing power. The problem is I didn't work with parallel server and I have a lot of questions about it: 1) Is mandatory to use raw devices for control files, redo logs data files? -- Data files yes, redo and control files can be on cooked file system. 2) How we transfer our cooked data files to raw devices data files? import/export? or exist another better (fast) method? -- To the best of my knowledge your going to have to rebuild the database from scratch so imp/exp is your only option. 3) If I start with only one node, performance will be the same of one single instance (no parallel)? -- Yes and NO, raw devices run a little faster than cooked files since the OS's buffer cache is not in the middle. 4) Somebody know how to work with raw devices under solaris? any link? I try to found someting in metalink but there's no samples... -- Working with raw devices is very different from cooked file systems. If you don't have an experienced Unix admin you could be in serious trouble. 5) What about backup? I can't put tablespaces in backup mode and copy with cp... maybe it's time to use rman? -- Rman can handle the backups, but a file system level backup is different. CP does not work anymore, nor does fbackup, or tar. You'll need specialized software for the purpose. Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Your views on Quest - Shareplex
Title: RE: Your views on Quest - Shareplex As of a year ago it was single threaded and didn't handle long columns. -Original Message- From: Rao, Maheswara [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 10:17 AM To: Multiple recipients of list ORACLE-L Subject: Your views on Quest - Shareplex List, My company is considering Quest - Shareplex. We are considering to use this in our dataware house. Basically, this will pull all the transactions from OLTP database and populate staging area in the dataware house. Could you please give your experiences and the pros and cons of this Shareplex product. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Index fragmentation
Title: RE: Index fragmentation This old script might work: set verify off set pagesize 35 set linesize 132 set pause on set pause 'Hit enter to continue' set feedback off set showmode off set echo off set space 0 set heading off set termout off pause off column blsk new_value BLOCK_SIZE_K select value / 1024 blsk from v$parameter where name = 'db_block_size'; set termout on pause off PROMPT ACCEPT USER_INPUT1 CHAR PROMPT 'Please enter a index to analyze:' ACCEPT USER_INPUT2 CHAR PROMPT 'Please enter a owner to analyze:' PROMPT PROMPT Working, Please wait. PROMPT analyze index USER_INPUT2..USER_INPUT1 validate structure; col ROWS_PER_KEY format 999.99 heading ' ' col BLKS_GETS_PER_ACCESS format 99,999.99 heading ' ' select '**', ' Name of the index = ' || NAME, ' Height of the b-tree = ' || HEIGHT, ' Blocks allocated to the index = ' || BLOCKS, ' Number of leaf rows (values in the index) = ' || LF_ROWS, ' Number of leaf blocks in the b-tree = ' || LF_BLKS, ' Sum of the lengths of all the leaf rows = ' || LF_ROWS_LEN, ' Useable space in a leaf block = ' || LF_BLK_LEN, ' Number of branch rows = ' || BR_ROWS, ' Number of branch blocks in the b-tree = ' || BR_BLKS, 'Sum of lengths of all the branch blocks in the b-tree = ' || BR_ROWS_LEN, ' Useable space in a branch block = ' || BR_BLK_LEN, ' Number of deleted leaf rows in the index = ' || DEL_LF_ROWS, ' Total length of all deleted rows in the index = ' || DEL_LF_ROWS_LEN, ' Number of distinct keys in the index = ' || DISTINCT_KEYS, ' How many times the most repeated key is repeated = ' || MOST_REPEATED_KEY, ' Total space currently allocated in the b-tree = ' || BTREE_SPACE, 'Totl space that is currently being used in the b-tree = ' || USED_SPACE, '% of space allocated in the b-tree that is being used = ' || PCT_USED, ' Average number of rows per distinct key = ' || ROWS_PER_KEY, 'Expected number of consistent mode block gets per row = ' || BLKS_GETS_PER_ACCESS from index_stats; col NAME format a30 fold_after col dummy_col_0 fold_after col dummy_col_1 fold_after col dummy_col_2 fold_after col LF_ROWS format 9,999,990 heading ' ' col DEL_LF_ROWS format 9,999,990 heading ' ' col BR_ROWS format 9,999,990 heading ' ' col DISTINCT_KEYS format 9,999,990 heading ' ' col MOST_REPEATED_KEY format 9,999,990 heading ' ' col ROWS_PER_KEY format 9,999,990 heading ' ' col HEIGHT format 0 fold_after heading ' ' col BLKS_GETS_PER_ACCESS format 99,999.99 fold_after heading ' ' col LF_BLK_LEN format 9,990 fold_after heading ' ' col lf_row_size format 990 fold_after heading ' ' col lf_row_per_blk format 990 fold_after heading ' ' col BR_BLK_LEN format 9,990 fold_after heading ' ' col br_row_size format 990 fold_after heading ' ' col br_row_per_blk format 990 fold_after heading ' ' col meg format 999.90 fold_after heading ' ' col lf_meg format 999.90 heading ' ' col lf_meg_pct format 99.90 fold_after heading ' ' col br_meg format 999.90 heading ' ' col br_meg_pct format 99.90 fold_after heading ' ' col uu_meg format 999.90 heading ' ' col uu_meg_pct format 99.90 fold_after heading ' ' col bt_meg format 999.90 heading ' ' col bt_meg_pct format 99.90 fold_after heading ' ' col btu_meg format 999.90 heading ' ' col btu_meg_pct format 99.90 fold_after heading ' ' col btuu_meg format 999.90 heading ' ' col btuu_meg_pct format 99.90 fold_after heading ' ' col btuub_meg format 999.90 heading ' ' col btuub_meg_pct format 99.90 fold_after heading ' ' set pause on select '' dummy_col_0, 'Index Name.', NAME, ' ' dummy_col_1, 'Leaf Rows..', LF_ROWS, ' ', 'Leaf Block Size', LF_BLK_LEN, 'Deleted Leaf Rows..', DEL_LF_ROWS, ' ', 'Leaf Row Size..', LF_ROWS_LEN / LF_ROWS lf_row_size, 'Branch Rows', BR_ROWS, ' ', 'Leaf Rows Per Block', LF_BLK_LEN / (LF_ROWS_LEN / LF_ROWS) lf_row_per_blk, 'Distinct Keys..', DISTINCT_KEYS, ' ', 'Branch Block Size..', BR_BLK_LEN, 'Max Common Key.', MOST_REPEATED_KEY, ' ', 'Branch Row Size', BR_ROWS_LEN / (BR_ROWS + 1) br_row_size, 'Avg Common Key.', ROWS_PER_KEY, ' ', 'Branch Rows Per Block..', BR_BLK_LEN / ((BR_ROWS_LEN / (BR_ROWS + 1)) + 1) br_row_per_blk, 'Height Of B-Tree...', HEIGHT, 'Reads Per Access...', BLKS_GETS_PER_ACCESS, ' ' dummy_col_2, 'Index Meg', (BLOCKS * BLOCK_SIZE_K) / 1024 meg, 'Leaf Meg/Pct.', (LF_BLKS * BLOCK_SIZE_K) / 1024 lf_meg, ' /', (LF_BLKS / BLOCKS) * 100 lf_meg_pct, 'Branch Meg/Pct...', (BR_BLKS * BLOCK_SIZE_K) / 1024 br_meg, ' /', (BR_BLKS / BLOCKS) * 100 br_meg_pct, 'Unused Meg/Pct...', ((BLOCKS - (LF_BLKS + BR_BLKS)) * BLOCK_SIZE_K) / 1024 uu_meg, ' /', ((BLOCKS - (LF_BLKS + BR_BLKS)) / BLOCKS) * 100 uu_meg_pct, 'B-Tree Meg/Pct...', ((LF_BLKS + BR_BLKS) * BLOCK_SIZE_K) / 1024 bt_meg, ' /', ((LF_BLKS + BR_BLKS) / BLOCKS) * 100 bt_meg_pct,
RE: Listener.log....writing to renamed file
Title: RE: Listener.logwriting to renamed file
Reload doesn't close/reopen the file. Here is a couple solutions
How's about a fast cat/clear solution:
#!/bin/ksh
cat listener.log listener.log.hist
ex listener.log EOF
1,\$d
wq
EOF
Or if you wish to purge 90% of the file:
#!/bin/ksh
wc -l listener.log | read v_lines junk
v_keep=$(($((${v_lines} * 10)) / 100))
v_purge=$((${v_lines} - ${v_keep}))
ex listener.log EOF
1,${v_purge}d
wq
EOF
-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 7:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Listener.logwriting to renamed file
On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon:
-Hi List,
-As a regular maintainance work,I have moved the listener.log file to
-listener.log.old
-and 'touch'ed the listener.log, expecting the logging into this new file.
-But I am observing the logging being done to listener.log.old, instead.
-I could not recall any such previous experience.
-FYI, I cannot do any 'experiments' as far as this system is concerned as I
-have to deal with
-desupported HP-UX(10.01), Oracle (7.2.2.3).
-I have my logging being done to default path($ORACLE_HOME/network/log), as
-no parameter settings in listener.ora.
-Has anybody experienced this?
-
-TIA,
-
-Suren
-Oracle DBA
-Sony Electronics Ltd.
-
-
The file handle listener is using is still pointed at the old file. To fix this you need to stop and start the listener. This will not affect anybody who is already connected. I'm not sure if a reload will do the same thing.
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc. [EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
No program done by an undergrad will work after she graduates.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: memory question again ???
Title: RE: memory question again ???
Here is a little C program that works on Solaris:
$ sysconf
Memory-total=5120M free=1596M pct=31 pagesize=8K CPU-total=6 online=6
$ cat sysconf.c
#include stdio.h
#include sys/unistd.h
main()
{
int wk1, wk2, wk3, wk4;
long total_pages, free_pages, pagesize, total_cpus, total_cpus_online;
total_pages = sysconf(_SC_PHYS_PAGES);
free_pages = sysconf(_SC_AVPHYS_PAGES);
pagesize = sysconf(_SC_PAGESIZE);
total_cpus = sysconf(_SC_NPROCESSORS_CONF);
total_cpus_online = sysconf(_SC_NPROCESSORS_ONLN);
wk1 = (total_pages * (pagesize / 1024)) / 1024;
wk2 = (free_pages * (pagesize / 1024)) / 1024;
wk3 = (free_pages * 100) / total_pages;
wk4 = (pagesize / 1024);
printf(Memory-total=%dM free=%dM pct=%d pagesize=%dK CPU-total=%d online=%d\n,
wk1, wk2, wk3, wk4, total_cpus, total_cpus_online );
}
-Original Message-
From: Janet Linsy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L
Subject: memory question again ???
Hi,
Thank you all for showing me how to check the Unix
memory. Is there a way to show how much is used and
how much is free?
Thank you!
Janet
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RedHat and Oracle
Title: RedHat and Oracle Funny how this is going since Oracle invested in Red Hat a few years ago. Remember -http://news.cnet.com/news/0,1,0-1003-200-339689,00.html -Original Message-From: Marianne Brooks [mailto:[EMAIL PROTECTED]]Sent: Friday, May 18, 2001 10:21 AMTo: Multiple recipients of list ORACLE-LSubject: RedHat and Oracle Looks like RedHat and Oracle are in a pissing match. Support just informed me that Oracle was withdrawing certification for the Apps on all Red Hat platforms.sigh
RE: Hi need some please
Title: RE: Hi need some please Is what your trying to do as simple as?... delete from TAB_B B where exists (select 'x' from TAB_A A where A.col1 = B.col1 and A.col2 = B.col2 and A.etc = B.etc ); -Original Message- From: Bill Conner [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Subject: Hi need some please Hi All, Does anyone have a script that will compare table_a to table_b and delete the dups in table_b, or a site that might have one? Thanks Very Much for any ideas. -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: job offer from SAUDI ARABIA
Title: RE: job offer from SAUDI ARABIA God I live in an awful country. I'm sorry for all the tyranny my country has put the world through. I guess I'll just shoot myself. Seriously. I encourage the individual that is looking at working in Saudi Arabia to do so if that is the experiences he wishes to have. I am the first to scream from the highest mountain all the things that are wrong with America, and if it's okay with you, what is right with America. The point being that in America, I CAN if I want to. Have a nice day and I hope you enjoy your move to Saudi Arabia. -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: job offer from SAUDI ARABIA Many professional women in the USA have found it necessary to purchase handguns to protect themselves from criminal elements in public places. Children are constantly under psychological assault being exposed to media violence. The liberal education system is devoted to indoctrinating children with mindless PC relativism, materialism/consumerism and hatred of God (or at least arrogant dismissal). Western freedoms can be seen from a variety of perspectives. Conditions cut both ways - depends on how you see it... Loss of religious, social and cultural freedom against the possibility of earning (and saving because you can't spend) lots of $$. Having said that, as long as you stick to the straight and narrow path (as defined by the Saudi authorities) you will be on the safest place on earth as far as crime goes. (E.g. stealing is punishable by cutting off your arm/fingers!!) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: job offer from SAUDI ARABIA
I'm sorry but I can help but laugh out loud that you took a job and didn't research this.At a minimum your new employer should have informed you of what to expect. I too at one time looked into taking a job in Saudi Arabia. I have known several people who have worked and/or visited on business and all have been glad to leave andwillNOTbe going back again. Being an American citizen I could make a few statements about personal freedoms here and the lack of the the same there but.nuff' said. Read the following excerpt and follow the links, and "Be Very Very Afraid". CUSTOMS REGULATIONS: Saudi customs authorities enforce strict regulations concerning importation into Saudi Arabia of such banned items as alcohol products, weapons and any item that is held to be contrary to the tenets of Islam. This includes non-Islamic religious materials, pork products, and pornography. Saudi customs and postal officials broadly define what is contrary to Islam, and therefore prohibited. Christmas decorations, fashion magazines, and "suggestive" videos may be confiscated and the owner subject to penalties and fines. It is advisable to contact the Embassy of Saudi Arabia in Washington or one of Saudi Arabia's consulates in the United States for specific information regarding customs requirements. http://www.amnesty-usa.org/countries/saudi_arabia/ http://www.transatlanticpub.com/cat/travel/livi1520.html http://travel.state.gov/saudi.html -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 16, 2001 5:50 AMTo: Multiple recipients of list ORACLE-LSubject: job offer from SAUDI ARABIA Hi all , I have taken an offer from a company in Europe to work in Saudi Arabia for 2 years. But I must learn the living conditions there. f there is an Arabian here , can you answer these.. 1) How are the living conditions?Expensive? 2) Will my wife have to cover her hair? Is it mandatory there? 3) How are the social activities like cinema? Thanks.
RE: BMC Patrol - 2nd Wave
Title: RE: BMC Patrol - 2nd Wave My experience is that BMC leaves a big footprint on the systems it monitors. So unless you have a system with 6+ cpu's the hogs reported are BMC related or the slow system is caused by BMC. And the $$ it costs, ouch. I have seen better results in shops using Big Brother (http://bb4.com/) or NetSaint (http://netsaint.sourceforge.net/). Maybe Patrol works for some people. But my advise is to stay away so that when the project dies and they try to decide who is to blame for spending $$ on a POS you will not be within ear shot. That's just my opinion, I could be wrong. -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 1:03 PM To: Multiple recipients of list ORACLE-L Subject: BMC Patrol - 2nd Wave So my boss calls me over yesterday and tells me he needs two servers for 2nd Wave to install BMC on to monitor the databases. I say, huh? Apparently the CIO decided to have a consulting company (2nd Wave) install and configure BMC to monitor all the databases (Oracle and SQL Server) in the company. I met with them briefly today (only because I asked to, it hadn't been deemed necessary before that) and I'll admit it doesn't look too bad so far, even if we already get all the information they provide (plus more) from various sql scripts and statspack. Does anyone have any gotchas, warnings, send out your resume NOW recommendations for working with the BMC Patrol product? Any experience with 2nd Wave? Thanks in advance! Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can I partition my primary key constraint index?
Title: RE: Can I partition my primary key constraint index? I don't know. I made the non-unique index by mistake and noticed that the index did not drop when I was correcting the mistake. -Original Message- From: paquette stephane [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: Can I partition my primary key constraint index? What is the behavior difference of using a non-unique index to enforce a unique/primary key constraint when inserting a duplicate value ? Index range scan ? --- Brian MacLean [EMAIL PROTECTED] a écrit : ahhh, mostly right. I found in v8.1.6 that if I use a non-unique index to enforce a unique/primary key constraint that the index does not drop when you drop the constraint. -Original Message- Sent: Friday, May 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Hello, Cherie, Short note first - when you drop primary key the associated index will be dropped too. To partition the index you will create this index first and then alter table table name add constraint index name primary key(column list); HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original Message- Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Oracle will automatically create an index for your primary key constraint. I have a lot of large partitioned tables in my data warehouse. All of my primary key indexes are non-partitioned. I would like them to be partitioned. When I drop the constraint and re-enable it, can I specify at that time that I want the index to be partitioned? Or do I need to drop my index and rebuild it to be partitioned after the fact? Is there any problem with having partitioned primary key indexes? Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: cdump, bdump, udump
Title: RE: cdump, bdump, udump I used to be of the same school of thought as you. But on Solaris 2.7 with Oracle v8.1.7 I have seen the various processes hang on to the old log for days if I mv alertSID.log alertSID.log.old ; touch alertSID.log 7113:oracle@e6500a ls -Fla /dw01/app/oracle/admin/BART/bdump/alert_BART.log -rw-r--r-- 1 oracle oinstall 484498 May 14 16:12 /dw01/app/oracle/admin/BART/bdump/alert_BART.log 7113:oracle@e6500a fuser /dw01/app/oracle/admin/BART/bdump/alert_BART.log /dw01/app/oracle/admin/BART/bdump/alert_BART.log: 28913o 28911o 28909o 28907o 28905o 28902o 28900o 28898o 28896o 7113:oracle@e6500a ps -ef | egrep PID|28913|28911|28909|28907|28905|28902|28900|28898|28896 | grep -v grep UID PID PPID C STIME TTY TIME CMD oracle 28898 1 0 15:55:56 ? 0:00 ora_dbw0_BART oracle 28905 1 0 15:55:57 ? 0:00 ora_smon_BART oracle 28911 1 0 15:55:58 ? 0:00 ora_p000_BART oracle 28909 1 0 15:55:57 ? 0:00 ora_arc0_BART oracle 28907 1 0 15:55:57 ? 0:00 ora_reco_BART oracle 28902 1 0 15:55:56 ? 0:00 ora_ckpt_BART oracle 28913 1 0 15:55:58 ? 0:00 ora_p001_BART oracle 28900 1 0 15:55:56 ? 0:00 ora_lgwr_BART oracle 28896 1 0 15:55:56 ? 0:00 ora_pmon_BART -Original Message- From: Terry Ball [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Subject: Re: cdump, bdump, udump With the alert.log you are incorrect. Oracle only get a handle on the file when it writes to it. The rest of the time, it does not need nor keep a handle on the alert.log. You can move or delete the file and neither Oracle nor the OS care. A new alert.log will be created as soon as Oracle needs to write to one. Terry Ron Rogers wrote: Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't see. The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null alert.log. Just a house keeping note. ROR mª¿ªm [EMAIL PROTECTED] 04/24/01 09:21AM Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of RTFM emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel From: Sinardy Xing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: cdump, bdump, udump Date: Tue, 24 Apr 2001 03:40:27 -0800 Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Can I partition my primary key constraint index?
Title: RE: Can I partition my primary key constraint index? ahhh, mostly right. I found in v8.1.6 that if I use a non-unique index to enforce a unique/primary key constraint that the index does not drop when you drop the constraint. -Original Message- From: Vadim Gorbounov [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject: RE: Can I partition my primary key constraint index? Hello, Cherie, Short note first - when you drop primary key the associated index will be dropped too. To partition the index you will create this index first and then alter table table name add constraint index name primary key(column list); HTH Vadim Gorbounov Brainbench Master Oracle DBA www.brainbench.com -Original Message- Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Oracle will automatically create an index for your primary key constraint. I have a lot of large partitioned tables in my data warehouse. All of my primary key indexes are non-partitioned. I would like them to be partitioned. When I drop the constraint and re-enable it, can I specify at that time that I want the index to be partitioned? Or do I need to drop my index and rebuild it to be partitioned after the fact? Is there any problem with having partitioned primary key indexes? Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dbms_space.free_blocks does not report correctly ?
I can't answer your question directly but I would like to point out a few things. Your select count on rowid will miss chained blocks, the first block of the first segment which is used for freelist chains, and as I learned some time ago that oracle used more blocks to keep track of the extra freelists that became available with the "maxextents unlimited" option. Remember years ago when we where bound by 121 extents for 2k block, and 225 for 4k, and 505 for 8k (something like that), anyway, oracle had to put the extra info somewhere, so that take extra blocks to store it all. Lastly, I just can't see spending time looking for a few blocks. 1000's maybe. That's just myopinion, I could be wrong. -Original Message-From: Diego Cutrone [mailto:[EMAIL PROTECTED]]Sent: Friday, April 20, 2001 1:46 PMTo: Multiple recipients of list ORACLE-LSubject: dbms_space.free_blocks does not report correctly ? Hi list, I'm checking space usage in some objects. Type Name TBlocks Unused Used FBlocks HWM TABLE FND_CONCURRENT_REQUESTS 21,075 70 3,557 20,225 21,005 TABLE GL_BALANCES 126,233 220 125,987 4 126,013 I've used the followingquery to calculate Used blocks (I mean blocks where there're rows, at least one). SELECT COUNT(DISTINCT SUBSTR(rowid,15,4)||SUBSTR(rowid,1,8))FROM segment; --- "Used" And I've used dbms_space.free_blocks to calculate "FBlocks". And dbms_space.unused_blocks to calculate "Unused" (blocks above HWM), "TBlocks" (Total blocks of the object). And HWM=TBlocks-Unused So, check this out Table GL_BALANCES, I've got 126233 blocks and 220 blocks unused, so we can say that HWM is 126013 (126233-220). And I've got 125987 blocks with some data in them, so 126013-125987= 26 blocks. This means that these 26 blocks were used some time ago (because they are below HWM) but they're not holding any rows now. right? So here's my question: why does dbms_space.free_blocks report only 4 blocks ? that means that below HWM there are 4 blocks that are candidate for inserts, what happened with the 26 blocks !?? shouldn't it be reporting at least 26 blocks ? Please help me out with this. Thanks
RE: Recovery Manager vs. SQL Back Track
Title: RE: Recovery Manager vs. SQL Back Track I have worked with manual scripting, EBU, RMAN, and SQLBackTrack. If you can afford it, use SQLBackTrack. It's idiot proof for both backup and restore if you set it up right. (trust me). If you have other questions email me direct. Brian P. Mac Lean Oracle DBA/OCP v8/OMC Vcommerce Corp. 6262 N. Scottsdale Rd., Suite 110 Scottsdale, AZ 85250 480.922.9922 - Main 480.778.8449 - Direct 480.922.9921 - Fax [EMAIL PROTECTED] - Email vc_bmaclean - Yahoo Messenger http://www.vcommerce.com -Original Message- From: Yttri, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 7:46 AM To: Multiple recipients of list ORACLE-L Subject: Recovery Manager vs. SQL Back Track Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). We have started playing around with Recovery Manager. Our Sybase DBAs are telling us we should look at SQL BackTrack instead. For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any gotcha's that you have run into. Other than the cost factor, what would you recommend? Thanks very much - Lisa
RE: Unix question
this
is ksh93 syntax (at least on Sun):
1453:oracle@e6500b ksh1453:oracle@e6500b
var=tester1453:oracle@e6500b echo ${var//e/o}ksh: ${var//e/o}: bad
substitution
1453:oracle@e6500b
dtksh1453:oracle@e6500b var=tester1453:oracle@e6500b echo
${var//e/o}tostor1453:oracle@e6500b
-Original Message-From: Mandar Ghosalkar
[mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 8:05
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Unix question
check this question from korn faq at
http://www.kornshell.com/doc/faq.html
Q24. How do I do global substitutions on
the contents of shell variables?A24. Use // instead of / for global
substitution, ${var//aa/bb} willexpand to the value of with each
"aa" replace by "bb".
so i
tried
$
var=tester$ echo $vartester$ echo ${var//e/o}bad
substitution$
anyone out there :)
-Mandar
-Original Message-From: Big Planet
[mailto:[EMAIL PROTECTED]]Sent: Friday, March 23, 2001 7:56
PMTo: Multiple recipients of list ORACLE-LSubject:
Unix question
Hi geeks ,
How can I do substr and instr kind of operaion
in unix shell script . is it possible ?
like i have one paramter as "hostname" .. I
want to trim quotes surrounding the hostname .
One more question , is possible to read another
text file line by line using a shel script and then edit that file
.
Actually I have this configuration file for my
system which have keywords like $HOSTNAME$ , $SCHEMA$ which I want to
replace with actual values at the time of installation by asking questions
to the user.
TIA
--Big planet
RE: OFF TOPIC: How to find lib search order for executable under
ldd -s $ORACLE_HOME/bin/oracle -Original Message-From: KC [mailto:[EMAIL PROTECTED]]Sent: Thursday, March 01, 2001 5:50 AMTo: Multiple recipients of list ORACLE-LSubject: OFF TOPIC: How to find lib search order for executable under Sun solaris Dear list, In HP-UX, one can do a chatr to find out the lib search order of an executable, is there a corresponding command under Sun Solaris. Also, can someone tell me how nmliblist is used when relink Oracle under Sun?? Thanks Kam
RE: Hit Ratio fallen through the floor at 31% since a db crash ye
Title: Hit Ratio fallen through the floor at 31% since a db crash yesterday Checkforlostorinvalidindexes -Original Message-From: Barbra Hale [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 08, 2001 12:02 PMTo: Multiple recipients of list ORACLE-LSubject: Hit Ratio fallen through the floor at 31% since a db crash yester We are running 8.1.5 on Solaris. We can't seem to find the cause - everything is up and running fine, just extremely slow. What should we be looking at? TIA, Barb
