Month: January 2013

DataBase

Querying Oracle DB: Formatting and saving results from SQlPlus in TXT & CSV

SQL*Plus: Release 8.1.7.0.0 – Production on Thu Jan 24 14:25:37 2013 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production With the Partitioning option JServer Release 8.1.6.0.0 – Production SQL> SQL> SET UNDERLINE OFF SQL> SET COLSEP ‘,’ SQL> SET LINES 100 PAGES 100 SQL> SET FEEDBACK off SQL> SET LINESIZE 1000 SQL> SPOOL C:TestFolderMyUsers-DeletedData.txt SQL>Select * from EmpData where usergroup = 11771 SQL> SPOOL OFF   Open the C:TestFolderMyUsers-DeletedData.txt file  and verify that data is the one you are looking for Open an Excel Sheet and Import   Setting up SQLPlus […]

Read more
Server

PingDom analyzes/indexes/crawls all of your web pages

While evaluating pingdom for website monitoring, I noticed that it tries to crawl over all of our web servers, for a given url and then seem to be further analyzing/indexing/crawling all of web pages.  This has increased load on the web servers and their user agent "Pingdom.com_bot_version_1.4_(http://www.pingdom.com/)" is causing constant failure/error logs in web server.   Created a new empty Vendor Vendor: quiz = 0 Create RunSession new runssn.getId() == xxxxxxx ip= RunFront: trying to load skin config from database RunFront: Found with base path Weblog addRequest start addRequest: type=start Weblog2.addRequest(start) WelogEntry failed: action=launch remote=xxxxxxxxx ref=null agent=Pingdom.com_bot_version_1.4_(http://www.pingdom.com/) java.sql.SQLException: ORA-01653: unable […]

Read more