Posts

AWR Report Reading

Image
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 ...

Convert Chrome recording to Vugen Script

Image
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.

VBA Code to Copy Files from one folder to another

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...

Performance Testing prep

TCP vs HTTP TCP and UDP are the "trucks" on the highway, and the "load" they are carrying are protocols such as HTTP , File Transfer Protocol (FTP) and more. As you can understand, TCP and UDP are transport protocols used by protocols such as FTP, HTTP, and SMTP. While both TCP and UDP are used to transport other protocols, they have one significant difference; TCP offers guaranteed data transportation, whereas UDP doesn't. What this means is that TCP has a special mechanism that ensures data is safely transferred without errors from one point to another, whereas UDP doesn't provide any such insurance. HTTP (HyperText Transfer Protocol) is a protocol that utilizes TCP to transfer its information between computers (usually Web servers and clients). The client makes an HTTP request to the Web server using a Web browser, and the Web server sends the requested information (website) to the client. -------------------------------------------------...

Install Mac OS on Windows Virtual Machine

PreRequiste: Latest preview: 10.13 Final (17A365). September 25, 2017. Google Drive (One Full):  https://goo.gl/ZEB4vB Google Drive (6 of 6):  https://goo.gl/dJe4CV Fix Download Limit:  https://techsviewer.com/fix-download-limit Code for VirtualBox (New):  https://goo.gl/GvhfVS VirtualBox:  https://goo.gl/MztVe5 Steps to Install macOS 10.13 High Sierra on VirtualBox on Windows Step 1: Extract Virtual Machine Image File Step 2: Install VirtualBox Step 3: Create New Virtual Machine Name: macOS 10.13 High Sierra Type: Mac OS X Version: macOS 10.13 or 10.12 Memory size: 3GB to 6GB ( 65% of your Ram) Virtual disk file: macOS high Sierra 10.13.vmdk Select Expert mode Choose OS file location  Choose RAM and all. Step 5: Add Code to VirtualBox with Command Prompt (cmd) Code for Virtualbox 5.x: cd "C:\Program Files\Oracle\VirtualBox\" VBoxManage.exe modifyvm " Your VM Name " --cpuidset 00000001 000106e5 00100800 0098e3fd bfebfbff...

Enable LAN Setting via registery

under HKEY_LOCAL_MACHINE>SOFTWARE>POLICIES>INTERNET EXPLORER>CONTROL PANEL there were AutoConfig Reg_DWord 1, and Proxy REG_DWord 1.  If these are set to 1 they grey out both options and the user whether an administrator or not cannot change them.  This prevent a novice user from messing up the selections.  I deleted both of these reg_dwords and the options were then selectable/changeable. 

Jmeter Authorization | NTLM

While Testing with Jmeter, you might be trying to script a application which do not have a login page. But it does authenticate the user by Single Sign on (SSO) or Through a pop up. SSO: When Your Request is transferred to some 3rd party application to validate your credentials through which you have logged into your device . Example : Your Intranet application in your company which authorizes and display your personalized homepage for the person who has logged into the device. Pop-UP : While working with Loadrunner you might be using web_set_user function to fulfill your need. Whereas in Jmeter, it is done using HTTP Authorization manager. where you mention the external server link, User name, password and domain. Although just adding this part and executing the Homepage still might return 401 unauthorized. Well now you have to look if your request need some Authorization Key, which is generated by HTTP Authorization manager. It might be requiring that in header of th...