saivamsi.blogspot.com

NISCHAL's DBA WORLD

Tuesday, November 25, 2014. To find out impdp/expdp OS pid. Wednesday, November 7, 2012. As a normal user how to check SID. Select sys context('USERENV','SID') from dual;. Select sid from v$mystat where rownum =1;. Tuesday, May 22, 2012. Shell script for Tablespace alert via email. For sid in `ps -ef grep pmon awk '{print $8}' egrep -i "ora pmon" sed 's/ora pmon / '`. U01/oracle/bin/oraenv /dev/null 2 &1. Sqlplus -s '/ as sysdba' EOF. SET LINESIZE 130 PAGES 0 verify off heading off feedback off. Round( (...

http://saivamsi.blogspot.com/

OVERVIEW OF saivamsi.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SAIVAMSI.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.4 out of 5 with 14 reviews

5 star

8

4 star

3

3 star

3

2 star

0

1 star

0

Hey there! Start your review of saivamsi.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

2 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SAIVAMSI.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

21

SITE IP

216.58.219.193

LOAD TIME

1.956 sec

SCORE

6.2

PAGE TITLE

NISCHAL's DBA WORLD | saivamsi.blogspot.com Reviews

<META> DESCRIPTION

Tuesday, November 25, 2014. To find out impdp/expdp OS pid. Wednesday, November 7, 2012. As a normal user how to check SID. Select sys context('USERENV','SID') from dual;. Select sid from v$mystat where rownum =1;. Tuesday, May 22, 2012. Shell script for Tablespace alert via email. For sid in `ps -ef grep pmon awk '{print $8}' egrep -i ora pmon sed 's/ora pmon / '`. U01/oracle/bin/oraenv /dev/null 2 &1. Sqlplus -s '/ as sysdba' EOF. SET LINESIZE 130 PAGES 0 verify off heading off feedback off. Round( (...

<META> KEYWORDS

1 posted by

2 pvs vamsi

3 db=${sid}

4 oraenv ask=no

5 oracle sid=$db

6 oraenv ask=yes

7 output log

8 output1 log

9 spool output log

10 spool off;

CONTENT

Page content here

KEYWORDS ON PAGE

posted by,pvs vamsi,db=${sid},oraenv ask=no,oracle sid=$db,oraenv ask=yes,output log,output1 log,spool output log,spool off;,spool output1 log,exit,done,dbms workload repository,syntax,parameters,parameter description,retention,interval,dbid,examples

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

NISCHAL's DBA WORLD | saivamsi.blogspot.com Reviews

https://saivamsi.blogspot.com

Tuesday, November 25, 2014. To find out impdp/expdp OS pid. Wednesday, November 7, 2012. As a normal user how to check SID. Select sys context('USERENV','SID') from dual;. Select sid from v$mystat where rownum =1;. Tuesday, May 22, 2012. Shell script for Tablespace alert via email. For sid in `ps -ef grep pmon awk '{print $8}' egrep -i "ora pmon" sed 's/ora pmon / '`. U01/oracle/bin/oraenv /dev/null 2 &1. Sqlplus -s '/ as sysdba' EOF. SET LINESIZE 130 PAGES 0 verify off heading off feedback off. Round( (...

INTERNAL PAGES

saivamsi.blogspot.com

1

NISCHAL's DBA WORLD: February 2009

http://saivamsi.blogspot.com/2009_02_01_archive.html

Wednesday, February 11, 2009. To get user name and connect string as your SQL prompt:-. Add below line to $ORACLE HOME/sqlplus/admin/glogin.sql file. Set sqlprompt "& USER@& CONNECT IDENTIFIER SQL ". Instance has crashed and resources were not released:-. IPC Resources for ORACLE SID "orcl":. Oracle Instance not alive for sid "orcl". Remove ipc resources for sid "orcl" (y/n)? Done removing ipc resources for sid "orcl". To find a free space in datafile wise: -. Column file name format a50. Select 'alter s...

2

NISCHAL's DBA WORLD: DBMS_WORKLOAD_REPOSITORY

http://saivamsi.blogspot.com/2011/02/dbmsworkloadrepository.html

Saturday, February 5, 2011. MODIFY SNAPSHOT SETTINGS Procedure. This procedure controls two aspects of snapshot generation. The INTERVAL setting affects how often snapshots are automatically captured while the RETENTION setting affects how long snapshots are retained in the Workload Repository. DBMS WORKLOAD REPOSITORY.MODIFY SNAPSHOT SETTINGS(. Retention IN NUMBER DEFAULT NULL,. Interval IN NUMBER DEFAULT NULL,. Dbid IN NUMBER DEFAULT NULL);. The database id (default to local DBID. Extract( hour from re...

3

NISCHAL's DBA WORLD: January 2009

http://saivamsi.blogspot.com/2009_01_01_archive.html

Thursday, January 29, 2009. Access your Alert Log via SQL with External Tables. Starting in Oracle9i you can map external flat files to Oracle tables. This is especially useful for reading the Oracle alert log and mapping a Excel spreadsheet making the Oracle alert log accessible via SQL from Oracle:. Mapping the Oracle alert log is easy and once defined, all you have to do is query it with standard SQL syntax:. Create directory BDUMP as '/u01/app/oracle/admin/orcl/bdump';. Alert log ( msg varchar2(80) ).

4

NISCHAL's DBA WORLD: August 2008

http://saivamsi.blogspot.com/2008_08_01_archive.html

Monday, August 11, 2008. SQL create table stu. 3 sno number(5),. 4 sname varchar2(15),. Vamsi@vamsi]$ vi stu.txt. Vamsi@vamsi]$ vi c1.ctl. Insert into table stu. Fields terminated by ','. Vamsi@vamsi]$ sqlldr userid=a1/a1 control=c1.ctl. SQL*Loader: Release 9.2.0.1.0 - Production on Tue Apr 15 12:28:13 2008. Commit point reached - logical record count 6. Vamsi@vamsi sqlldr]$ sqlplus '/as sysdba'. SQL*Plus: Release 9.2.0.1.0 - Production on Tue Apr 15 12:30:26 2008. SQL select * from stu;. Sql grant execu...

5

NISCHAL's DBA WORLD: Getting TNS strings from tnsnames.ora file in Linux

http://saivamsi.blogspot.com/2012/05/getting-tns-strings-from-tnsnamesora.html

Monday, May 14, 2012. Getting TNS strings from tnsnames.ora file in Linux. Grep ' [A-Za-z]' tnsnames.ora sed 's/=.*/ ;s/,.*/ '. Getting TNS strings from tnsnames.ora file in Linu. Shell script for Tablespace alert via email. Picture Window template. Powered by Blogger.

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: September 2009

http://sethur4linux.blogspot.com/2009_09_01_archive.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Friday, September 25, 2009. Prepare url dynamically in Javascript. String url = window.location.protocol ":/ " window.location.hostname "/". Posted by Suresh Raja Bollipo. Wednesday, September 23, 2009. Creating Cookie in a Session. Http:/ publib.boulder.ibm.com/infocenter/wchelp/v6r0m0/index.jsp? If ( commandContext instanceof com.ibm.commerce.command.ViewCo...Posted by Sur...

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: June 2009

http://sethur4linux.blogspot.com/2009_06_01_archive.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Sunday, June 14, 2009. Deleting all objects in a Schema. CREATE OR REPLACE PROCEDURE DROP OBJECTS(P Owners varchar2) IS. Cursor obj crs is. Select owner, object name, object type. Where owner = upper(P Owners) AND object name. Obj REC obj CRS%ROWTYPE;. L grants objects varchar2(500);. Dbms output.put line('Begining to drop all objects');. FOR obj REC IN obj CRS LOOP. WHEN 'I...

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: May 2011

http://sethur4linux.blogspot.com/2011_05_01_archive.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Saturday, May 14, 2011. IBM Learning video, audio and pdf available for free. This is a free site, any body can access and go through the learning sessions provided by them. For WebSphere Commerce Suite learning, please visit the following url. Http:/ publib.boulder.ibm.com/infocenter/ieduasst/v1r1m0/index.jsp? Topic=/com.ibm.iea.wcs/plugin coverpage.html. Private String get...

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: November 2011

http://sethur4linux.blogspot.com/2011_11_01_archive.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Tuesday, November 22, 2011. Facebook Like/Share button in your site. Reference page http:/ developers.facebook.com/docs/reference/plugins/like/. Include the JavaScript SDK on your page once, ideally right after the opening body tag. Place the code for your plugin wherever you want the plugin to appear on your page. Posted by Suresh Raja Bollipo. Thursday, November 17, 2011.

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: March 2010

http://sethur4linux.blogspot.com/2010_03_01_archive.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Monday, March 22, 2010. Enabling cross-site scripting protection. Http:/ publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/index.jsp? Topic=/com.ibm.commerce.admin.doc/tasks/tsecsssp.htm. Posted by Suresh Raja Bollipo. Subscribe to: Posts (Atom). Enabling cross-site scripting protection. Links for nice sites. King of WCS: Bipin. Venki the great DBA.

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: Converting special Characters in properties file to UTF8 using native2ascii

http://sethur4linux.blogspot.com/2011/04/converting-special-characters-in.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Tuesday, April 26, 2011. Converting special Characters in properties file to UTF8 using native2ascii. Eg: Converting poland special charectres to native language. 1 Rename the file provided by the customer (i.e., storetext.properties) to storetext.nta. 3 Target properties file is your converted file. Posted by Suresh Raja Bollipo. Subscribe to: Post Comments (Atom).

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: Changing ORACLE LISTENER port number

http://sethur4linux.blogspot.com/2009/11/changing-oracle-listener-port-number.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Thursday, November 12, 2009. Changing ORACLE LISTENER port number. Change the port number in the following path:. D: oracle product 10.1.0 Db 1 NETWORK ADMIN listener.ora. Change the port number to desired port number and save. Run the following statement in the SQL prompt as sys dba. Check the status of listener, it should pick up your service name. Links for nice sites.

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: Configuring proxy settings in Java

http://sethur4linux.blogspot.com/2011/11/configuring-proxy-settings-in-java.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Thursday, November 17, 2011. Configuring proxy settings in Java. System.getProperties().put("http.proxyPort", "someProxyPort");. System.getProperties().put("http.proxyUser", "someUserName");. System.getProperties().put("http.proxyPassword", "somePassword");. System.getProperties().put("http.proxyHost", "someProxyURL");. Posted by Suresh Raja Bollipo. Links for nice sites.

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: September 2012

http://sethur4linux.blogspot.com/2012_09_01_archive.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Friday, September 28, 2012. Function for accessing URL variables in HTML. Function for accessing URL variables in HTML:. Var result = new RegExp(key "=([ &]*)", "i").exec(window.location.search);. Return result & unescape(result[1]) " ;. URL: http:/ blog.com? You have to use the function like this getUrlVal('name') you will get the result as 'suresh'. Links for nice sites.

sethur4linux.blogspot.com

World is open now, who needs gates and windows..: December 2009

http://sethur4linux.blogspot.com/2009_12_01_archive.html

World is open now, who needs gates and windows. WebSphere Commerce Suite, WebSphere Application server, IBM HTTP Server and Oracle. Wednesday, December 2, 2009. Delete the Web server definition in a standalone application server. The uninstaller program for the Web server plug-ins for WebSphere Application Server does not delete Web server definitions. However, you can delete a Web server definition from admin console OR by using the following wsadmin commands:. Posted by Suresh Raja Bollipo. Delete the ...

UPGRADE TO PREMIUM TO VIEW 11 MORE

TOTAL LINKS TO THIS WEBSITE

21

OTHER SITES

saivam.org

சித்தர் பாட்டு

நட டகல ல த த ய வம ன ற ந ல ப ஷ பந ச த த ய. ச ற ற வந த ம ணம ண ன ற ச ல ல மந த ரம ஏதட. நட டகல ல ம ப ச ம ந தன ள ள ர க க ய ல. ச ட டசட ட சட ட வம கற ச ச வ அற ய ம. ச வவ க க யர. ச வ ம க ந த உணவ ப பத ர த தங கள ச சம த த சட ட ய னத . அந த உணவ ன ர ச ய உணர ந த க ள ள தத ப லவ. மனக க ய ல ன ள இற வன இர ப பத அற ய மல. வ ற ம கல ல நட ட வ த த த ய வ ம ன ற ப யர ட ட ப க கள ல ம மந த ரங கள ல ம வழ ப ட ச ய வத.

saivam.org.uk

Saivam, Hindu , Sanathana Dharma , Aum

Welcome To Saiva (Hindu) Siddhandha Page. Best Viewable in Internet Explorer Only(any version). Security issues, viewable. By Netscape, Mozilla and Firebox browsers have been diasbled. Best viewable with Screen Resolution Size 1280 * 1024 / 1024 * 768. Help for more info. Javascript must be enabled.

saivamangaiyarvidyalayam.lk

www.mangaiyarkalagam.org , Saiva Mangaiyar Kalagam - Colombo

To help the younger generation of girls the would be mothers of tomorrow to face the challenges of life by providing through education the wisdom of our ancient Hindu faith and culture enabling them to be positive contributors to Society. To promote the three Rs. and contribute towards the fulfilment of life, our Mission is to pursue education in the service and spirit of religion and moral values in an atmosphere of Hindu spiritual traditions. BSc, Dip in Ed and M.Ed). Many indoor games were introduced.

saivaminfo.org

Under Construction

saivamseeprojects.com

Sai Vamsee Projects

Vamsee Valley View Residency. There is nothing like. Staying at home for real comfort. Contemporary way of life. Sai Vamsee's Signature - Gachibowli. Situated at the epicentre of hyderabad IT hub Sai Vamee's Signature provides spacious living with spectacular view and luxurious amenities. With excellent connectivity, Sai Vamsee's Signature close to every convenience. Contact Us 040 - 27635357. For detailed view of Sai Vamsee's Signature. Sarojini Residency - Hitech City. Contact Us 040 - 27635357. Spearh...

saivamsi.blogspot.com

NISCHAL's DBA WORLD

Tuesday, November 25, 2014. To find out impdp/expdp OS pid. Wednesday, November 7, 2012. As a normal user how to check SID. Select sys context('USERENV','SID') from dual;. Select sid from v$mystat where rownum =1;. Tuesday, May 22, 2012. Shell script for Tablespace alert via email. For sid in `ps -ef grep pmon awk '{print $8}' egrep -i "ora pmon" sed 's/ora pmon / '`. U01/oracle/bin/oraenv /dev/null 2 &1. Sqlplus -s '/ as sysdba' EOF. SET LINESIZE 130 PAGES 0 verify off heading off feedback off. Round( (...

saivamt.com

Welcome To SAIVA

saivamudaliar.com

Welcome to Saivamudaliar.com - Saivamudaliar Matrimony, Saivamudaliyar Matrimony, SaivaMudhaliar Matrimony, SaivaMudhaliyar Marimony,SaivaMuthaliyar Matrimony, SaivaMuthaliar Matrimony, Best SaivaMuthaliar Matrimony website, Best SaivaMuthaliyar Matrimony

Saivamudaliar.com is an exclusive matrimony website for Saivamudaliar Community and the Subcastes like Saiva pillai,Saiva vellalar,Sengunthar Thondai mandala saiva, etc . Our world wide Net work You can find our profile collection centre at near to your place. New Registration Click Here. Powered By : J B Soft System.

saivamunnettasangam.com

Saiva Munnetta Sangam UK | Community Service Through Saiva (Hindu) Concern

Saiva Munnetta Sangam UK. Community Service Through Saiva (Hindu) Concern`. ச வ சமய பர ட ச 2015. பர ட ச க க ன வ த ம ற கள. பர ட ச நட ப ற ம இடம :. Saiva Munnetta Sangam UK, 2 Salisbury Road, Manor Park, London E12 6AB. பர ட ச நட ப ற ம த கத :. 05092015 க ல 10.00 மண ம தல. பர ட ச வ ண ணப ப ம ட வ த கத :. பர ட ச க க ன ப ர வ கள ம அவற ற க க ன வ பரங கள ம பர ட ச பற ற ய ம லத க வ பரங கள ப ற வ ர ம ப ன ல ப ன வர ம இலக கங கள டன த டர ப க ள ளல ம :. பர ட ச ச ச யல ளர : த ர . வ . ஜ கந த ரப ஸ - 0795 615 0580. பர ட ச வ ண ணப பட வம.

saivana.com

Indian garment exporter - Top Indian Garment Exporter | Kenzo

saivanarpani.org

Saivanarpani.org | Malaysia Saiva Narpani Kalagam

இலக க / ந க க. இலக க / ந க க. கட ட ர கள. த ர மந த ரம. த ர வ சகம. ப ர யப ர ணம. அறத த ப ப ல. ப ய ரவ யல. ந ழற படப ப ழ. த ர த தலம. ந கழ ச ச கள. நட ப ற இர ப பவ. நட ப ற றவ. கட ட ர கள. த ர மந த ரம. த ர வ சகம. ப ர யப ர ணம. அறத த ப ப ல. ப ய ரவ யல. ந ழற படப ப ழ. த ர த தலம. ந கழ ச ச கள. நட ப ற இர ப பவ. நட ப ற றவ. ப ழ யர க ன வ ப ப ழ த த ப கல யர க ன கழல ப ற ற! ஆழ ம ச க கல ம தப ப ல அண ந த ப ர ன அட ப ற ற! வ ழ த ர ந வல ர வன த ண டர பதம ப ற ற! ஊழ மல த ர வ த வ ரர த ர த த ள ப ற ற! த ர வ சகம - ச வப ர ணம. த ர மந த ரம. அக ட பர...