oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: January 2009
http://oracleshare.blogspot.com/2009_01_01_archive.html
Tips, information and some real-time experiences in Oracle, UNIX. Friday, January 30, 2009. Shell Scripts and ways to run a shell script. What is a Shell Script? A script, or file that contains shell commands, is a shell program. You can create a shell script using the editor supplied with your operating system such as vi editor. Different ways to run as shell script:. A Ex: $ . yourscript.ksh. This method of running a script is called the " dot. Method of running a script. The " dot. Makes the command r...
oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: July 2011
http://oracleshare.blogspot.com/2011_07_01_archive.html
Tips, information and some real-time experiences in Oracle, UNIX. Thursday, July 14, 2011. Here is the SQL to find sessions causing UNDO Latch Contention:. V$session wait history swh. Sesssid = swh.sid. SEQ# SID USERNAME EVENT P1 P2. 1 798 ORCL latch free 5.0440E 17 127. 2 798 ORCL latch free 5.0440E 17 127. 3 798 ORCL latch free 5.0440E 17 127. 4 798 ORCL latch free 5.0440E 17 127. 5 798 ORCL latch: cache buffers chains 5.0440E 17 122. Links to this post. WHERE sid = ' session id. WHERE sid = '769';.
oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: How to rename or unzip or untar and vice-versa all files in a directory with same file extension - UNIX
http://oracleshare.blogspot.com/2013/08/how-to-rename-or-unzip-or-untar-and.html
Tips, information and some real-time experiences in Oracle, UNIX. Wednesday, August 21, 2013. How to rename or unzip or untar and vice-versa all files in a directory with same file extension - UNIX. To rename or unzip or untar and vice-versa all files in a directory use below commands. For i in `ls -latr *.txt.2013 awk '{print $9}'`. Mv $i `basename $i .2013`. All lines after $ symbol line together form the command. A similar command can be used to unzip or untar all files in a directory.
oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: August 2013
http://oracleshare.blogspot.com/2013_08_01_archive.html
Tips, information and some real-time experiences in Oracle, UNIX. Wednesday, August 21, 2013. To add up column values in a file - UNIX. To all up all the values in a particular column of a file in unix use below command. Ex: sample.txt contains below data. Now I want to add all values in column two of above file sample.txt. Cat sample.txt awk -F' ' '{print $2}' awk '{total = total $1}END{print total}'. Links to this post. For i in `ls -latr *.txt.2013 awk '{print $9}'`. Mv $i `basename $i .2013`. Echo $O...
oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: SQL Query to find top SQL's with two specific AWR Snapshots
http://oracleshare.blogspot.com/2013/08/sql-query-to-find-top-sqls-with-two.html
Tips, information and some real-time experiences in Oracle, UNIX. Wednesday, August 21, 2013. SQL Query to find top SQL's with two specific AWR Snapshots. FROM (SELECT s.sql id,. SUM(nvl(s.executions delta, 0) execs,. SUM(round(s.elapsed time delta / 1000000, 3) exec time,. SUM(round(s.buffer gets delta) io logical,. SUM(round(s.cpu time delta / 1000000, 3) cpu time,. SUM(nvl(s.parse calls delta, 0) parse calls,. SUM(round(s.iowait delta / 1000000, 3) io wait,. WHERE s.snap id BETWEEN start snap id.
oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: February 2009
http://oracleshare.blogspot.com/2009_02_01_archive.html
Tips, information and some real-time experiences in Oracle, UNIX. Saturday, February 14, 2009. ORA-00600 while creating an Index. ORA error while executing CREATE INDEX Statement of type:. CREATE INDEX TABLE NAME ON INDEX NAME (COLUMN). TABLESPACE PSDEMO STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING. ORA-00600: internal error code, arguments: [kcbz check objd typ 3], [3], [0], [16], [], [], [], []. Steps to resolve the error:. Links to this post.
johnsmiley.com
C# Links
http://www.johnsmiley.com/csharp/links.htm
Professor Smiley's nearly free articles. CNET article on C#. MSDN Magazine Artcle about C#. Check out the world's greatest Certification Exam test simulator. You can also buy Transcender from me directly, at a significatnt discount, by clicking here :). Download the .Net Framework. Includes the C# compiler). Http:/ msdn2.microsoft.com/en-us/vcsharp/aa336809.aspx. C# IDE'S and Editors. Microsoft C# Frequently Asked Questions. Professor Smiley's C# Frequently Asked Questions. CSharp Stuff by Don Jagger.
oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: August 2010
http://oracleshare.blogspot.com/2010_08_01_archive.html
Tips, information and some real-time experiences in Oracle, UNIX. Monday, August 30, 2010. Temporary Tablespace Space Monitoring. Here are some quick SQL's to monitor the usage of TEMP Tablespace:. Space Usage of TEMP Tablespace:. SELECT A.tablespace name tablespace, D.mb total,. SUM (A.used blocks * D.block size) / 1024 / 1024 mb used,. Dmb total - SUM (A.used blocks * D.block size) / 1024 / 1024 mb free. FROM v$sort segment A,. FROM v$tablespace B, v$tempfile C. WHERE B.ts#= C.ts#. ORDER BY sid serial;.
oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: How to print or trim end characters of a string/line in UNIX
http://oracleshare.blogspot.com/2013/08/how-to-print-or-trim-end-characters-of.html
Tips, information and some real-time experiences in Oracle, UNIX. Wednesday, August 21, 2013. How to print or trim end characters of a string/line in UNIX. The commands below help in printing end characters of a line or a string. I assume that ORACLE SID is set to "TESTDB" for examples below. Print last one character from ORACLE SID:. Echo $ORACLE SID sed -e "s/ .* (. )$/1/". Print last two characters:. Echo $ORACLE SID sed -e "s/ .* (. )$/1/". Print last three characters:. Trims last one character:.
oracleshare.blogspot.com
Tips, information and some real-time experiences in Oracle, UNIX: April 2010
http://oracleshare.blogspot.com/2010_04_01_archive.html
Tips, information and some real-time experiences in Oracle, UNIX. Monday, April 12, 2010. Resize/Add/Move/Rename/Drop datafile and temporary datafile in Oracle. Resize a datafile and tempfile:. SQL alter database datafile '/u10/oradata/TEST/test.tst tbspace.data.01.dbf' resize 50M;. SQL alter database tempfile '/u09/oradata/TEST/test.tmp tbspace.data.01.dbf' resize 50M;. SQL alter tablespace tst tbspace1 add datafile '/u10/oradata/TEST/test.tst tbspace.data.02.dbf' size 2000M;. Ex: SQL startup mount.