What all i learnt today

Understanding Linux CPU Load - when should you be worried? BY ANDRE You might be familiar with Linux load averages already. Load averages are the three numbers shown with the  uptime  and  top  commands - they look like this: load average: 0.09, 0.05, 0.01 Most people have an inkling of what the load averages mean: the three numbers represent averages over progressively longer periods of time (one, five, and fifteen minute averages), and that lower numbers are better. Higher numbers represent a problem or an overloaded machine. But, what's the the threshold? What constitutes "good" and "bad" load average values? When should you be concerned over a load average value, and when should you scramble to fix it ASAP? First, a little background on what the load average values mean. We'll start out with the simplest case: a machine with one single-core processor. The traffic analogy A single-core CPU is like a single lane of traffic. Imagine you are...

1.  VLOOKUP Cannot Look to its Left What this means is if the data you are matching for is not in the left side column,  i.e. you want to match a data which is in 2nd column and 1st column value is required to be displayed then It will not be working. Solution: 1. Keep the matching column in first or left most column of the table/selection area. 2.  The solution to this involves not using VLOOKUP at all. Using a combination of the INDEX and MATCH functions of Excel is a common alternative to VLOOKUP. It is far more versatile. 2.  Your Table Contains Duplicates Ok, so your list should have duplicates. In this case a VLOOKUP is not what you need. A PivotTable would be perfect to select a value and list the results instead. 3. The Table has got Bigger update your table reference Source:  https://www.ablebits.com/office-addins-blog/2014/04/09/why-excel-vlookup-not-working/

How to save the desired data out of the log. package com.qa.pt.conf; import jdk.internal.org.xml.sax.InputSource; import org.apache.commons.io.FileUtils; import org.apache.commons.io.filefilter.DirectoryFileFilter; import org.apache.commons.io.filefilter.WildcardFileFilter; import org.w3c.dom.Document; import org.w3c.dom.NodeList; import org.xml.sax.SAXException; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.xml.parsers.ParserConfigurationException; import javax.xml.xpath.*; import java.io.*; import java.text.SimpleDateFormat; import java.util.*; import java.util.regex.Pattern; public class LogParser_GTMOutBound { private static String Folder_path = "C: \\ s2hs \\ Projects \\ Performance \\ Conf \\ Logs \\ " ; // this is for 569 private static String Log_Name = "adaptor.log_prod" ; private static int i = 1 ; private static int j = 1 ; private static int k = 1 ; private static H...

Hello All, below is the program in java to parse a log : /* ############################## Program Name: Log parser ###### ############################## Craete Date: 27-March-2018 ###### ############################## Auther: Surender Sharma ###### ############################## Description: Parse the Adpater and transformation log to find the time taken to process messages / files ###### */ package LogParsers; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Row; import java.io.*; import java.util.Hashtable; import java.util.Scanner; import java.util.regex.Pattern; public class LogParser_Cash_Adapter { ...

Introduced in Oracle 10g and having evolved from the Statspack functionality of Oracle 8i/9i, the Automatic Workload Repository report or AWR report (as it is more commonly known as) is a vital tool to collect historical performance statistics of an Oracle Database by DBAs and System Performance engineers. An AWR report is primarily useful in gathering data on the Wait Events, Active Session History (ASH) Statistics, Object Usage Statistics and Resource hungry SQL Queries, which together help in identifying, analyzing and resolving performance bottlenecks of the database. Apart from this, ADDM (Automatic Database Diagnostic Monitor), the self-diagnosis utility of Oracle DB relies on the stats contained in AWR reports for accurately identifying root causes of performance issues. The AWR report in itself runs into hundreds of metrics and can be quite overwhelming to analyze at once, for someone not making a living out of doing so! This article is intended to call out the ...

Hello All, Today we will learn how we can convert a chrome recording to VuGen script. Simply turn on the F12 [developer tools] in chrome and go to network Click Record [Auto turned on] Record your steps Now Right click on any of the request in dev tools and say save a HAR. the content will be saved in JSON format as HAR file open the HAR file in vugen Script ready. ----------------------------------------------------------------------------------------------------------------- Even you can read the data in easy format  by following below steps: Use any tool to convert JSON format to XML format. and you can now easily read all the request and their response.

FilesPath=inputbox("Enter Sourcepath for  files to be copied as C:\RootFilesPath") FileToCopyPath=inputbox("Enter destination  folderpath to copy files Sample as C:\ODC Data Compare\ODC File Compare\Prod Data") Set FileObj=createobject("Scripting.FileSystemObject") If  FileObj.FolderExists(FIlesPath) Then Set oFolder=FileObj.GetFolder(FIlesPath) Set oFiles=oFolder.Files For each oFile in oFiles FileName=oFile.name FLName=split(FileName,"-") FName=trim(FindRecid(FLName(0))) If FileObj.FolderExists(FileToCopyPath) Then Set DestRootFolder=FileObj.GetFolder(FileToCopyPath) Set SubFolder=DestRootFolder.SubFolders For each oFolder in SubFolder SubFolderName=trim(oFolder.Name) If  SubFolderName=FName  Then SourcePath=FIlesPath & "\" &  FileName DestinationPath=FileToCopyPath & "\" & SubFolderName & "\" FileObj.CopyFile SourcePat...