oracletechlovers.blogspot.com
oracle technology lovers blog: oracle technology lovers blog: OS Watcher (OSW
http://oracletechlovers.blogspot.com/2012/11/oracle-technology-lovers-blog-os.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Friday, November 23, 2012. Oracle technology lovers blog: OS Watcher (OSW. Oracle technology lovers blog: OS Watcher (OSW. OS Watcher (OSW) is a collection of UNIX shell scripts intended to collect and archive operating system and network metrics to aid support. July 6, 2015 at 2:54 AM. Is one of the best idea to make a bright career.
oracletechlovers.blogspot.com
oracle technology lovers blog: Difference between Oracle Single instance and Oracle RAC
http://oracletechlovers.blogspot.com/2012/11/difference-between-oracle-single.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Thursday, November 22, 2012. Difference between Oracle Single instance and Oracle RAC. Single instance accessing database. Multiple instances accessing same database. Database can be local or shared. Database must be on shared. Minimum one node is Required. Minimum two node required. Clusterware software is not required. Modern business r...
oracletechlovers.blogspot.com
oracle technology lovers blog: May 2011
http://oracletechlovers.blogspot.com/2011_05_01_archive.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Monday, May 30, 2011. Temporary tablespace usage for each user. COLUMN tablespace FORMAT A20. COLUMN temp size FORMAT A20. COLUMN sid serial FORMAT A20. COLUMN username FORMAT A20. COLUMN program FORMAT A40. SELECT b.tablespace,. ROUND( (b.blocks*p.value)/1024/1024),2) 'M' AS temp size,. Asid ',' a.serial# AS sid serial,. FROM v$session a,.
oracletechlovers.blogspot.com
oracle technology lovers blog: April 2011
http://oracletechlovers.blogspot.com/2011_04_01_archive.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Sunday, April 10, 2011. Oracle RAC: restoring lost OCR file. Shutdown everything oracle instances then run. Rootsh this will create OCR. Links to this post. Subscribe to: Posts (Atom). Oracle RAC: restoring lost OCR file. Collect DB info from Script. View Free space from temporary tablespace. Get DDL command from SQL query. In the previou...
oracletechlovers.blogspot.com
oracle technology lovers blog: ASM: Difference's between CORSE and FINE Striping
http://oracletechlovers.blogspot.com/2012/06/asm-differences-between-corse-and-fine.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Sunday, June 24, 2012. ASM: Difference's between CORSE and FINE Striping. It is used for all voluminous input/output, e.g. input/output operations on datafiles. It is used for all small input/output, e.g. input/output operations on online redolog files and control files. The size of the coarse grained data stripes is large. ASM: Differenc...
oracletechlovers.blogspot.com
oracle technology lovers blog: January 2012
http://oracletechlovers.blogspot.com/2012_01_01_archive.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Thursday, January 26, 2012. Steps to reset original password. Use below steps to reset original password:. Look at the example:. Schema name is : OASTOLTP. SQL set lines 9999. Set long 90000000SQL SQL. SQL select dbms metadata.get ddl('USER','OASTOLTP') from dual;. DBMS METADATA.GET DDL('USER','OASTOLTP'). TEMPORARY TABLESPACE "TEMP 0".
oracletechlovers.blogspot.com
oracle technology lovers blog: August 2010
http://oracletechlovers.blogspot.com/2010_08_01_archive.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Tuesday, August 31, 2010. Col first load time format a20. Col client info format a20. Col username format a20. Col last load time format a20. Col sql text format a30. Select a.sid,a.serial#,a.client info,a.username,a.logon time,a.status,b.sql text,a.last call et,b.first load time,b.last load time. From v$session a ,v$sql b. Extra Redo gen...
oracletechlovers.blogspot.com
oracle technology lovers blog: March 2010
http://oracletechlovers.blogspot.com/2010_03_01_archive.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Friday, March 5, 2010. Quicktune database - Collect DB info from Script. Change location of spool file as per directory. Execute Reportingquicktune.sql file on SQL prompt. SET FEEDBACK OFF;. SET HEADING ON;. SET ECHO OFF;. SET PAGESIZE 50000;. SET LINESIZE 122;. Prompt = = = = = = = Start Time = = = = = = =. FROM DUAL ;. SET LINESIZE 300;.
oracletechlovers.blogspot.com
oracle technology lovers blog: November 2012
http://oracletechlovers.blogspot.com/2012_11_01_archive.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Friday, November 23, 2012. Oracle technology lovers blog: View Free space from temporary tablespace. Oracle technology lovers blog: View Free space from temporary tablespace. Select substr(a.tablespace name,1,20) "TS name", substr(a.file name,1,35) "File Name", round(sum(a.bytes)/1024/1024,2) "Size MB",sum(NVL(b.b. Links to this post.
oracletechlovers.blogspot.com
oracle technology lovers blog: September 2010
http://oracletechlovers.blogspot.com/2010_09_01_archive.html
Oracle technology lovers blog. A place for people who love Oracle technology and want to learn Oracle more and more. Pune, Maharashtra, India. View my complete profile. Tuesday, September 14, 2010. Silent mode Oracle RAC installation. Install Oracle clusterware and database software using response file as below. 1 To create a response file, start the OUI with the following command and perform an installation as normal. RunInstaller -record -destinationFile /tmp/10gR2.rsp. Links to this post. How can the ...