Category: Computers

Killing a “Killed” Session in Oracle

“Killing” a session in Oracle just means that you’ve asked the session to kill itself. That can take time depending on what the session is doing.

If you have sessions with status “KILLED” that you know aren’t doing anything important, you can kill the session immediately by executing :

ALTER SYSTEM KILL SESSION ‘sid,serial#’ IMMEDIATE;

Property Expansion in SOAPUI

From groovyinsoapui.wordpress.com :

Accessing variable values on the go while sending SOAP request to some service, might solve many problems at times. In SOAP UI, there are two ways to accomplish this

i) Using ‘Property Transfer’ step

ii) Using ‘Property Expansion’ accordingly wherever required. Here I am explaining this procedure fo accesing properties.

${#Scope#Property-name[#xpath-expression]}

${Property-name} refers to a Global Property
(example: ${UserName} to a global Property named “UserName”)

${#Project#Property-name}refers to a Project Property
(example: ${#Project#UserName} to a Property on Project level named “UserName”)

${#TestSuite#Property-name} refers to a TestSuite Property
(example: ${#TestSuite#UserName} to a Prop on TestSuite level named “UserName”)

${#TestCase#Property-name} refers to a TestCase Property
(example: ${#TestCase#UserName} to a Prop on TestCase level named “UserName”)

${TestStep-name#Property-name} refers to a property in a named TestStep.

My Buddie’s Loan-Bot Mortgage Calculator

No, this is not a spam post. A friend of mine created his own mortgage calculator and it’s pretty neat. All hail the Loan Bot!

Loan-Bot is a graphical mortgage analyzer and comparison tool.

In addition to basic mortgage calculations and amortization tables, Loan Bot can also graphically illustrate the effect that changing loan parameters has. You can save your mortgage parameters to return to later, or save several and compare them in a chart or in graphs.

Playstation Network Down Due to Intrusion

From the official Playstation blog :

“An external intrusion on our system has affected our PlayStation Network and Qriocity services. In order to conduct a thorough investigation and to verify the smooth and secure operation of our network services going forward, we turned off PlayStation Network & Qriocity services on the evening of Wednesday, April 20th. Providing quality entertainment services to our customers and partners is our utmost priority. We are doing all we can to resolve this situation quickly, and we once again thank you for your patience. We will continue to update you promptly as we have additional information to share.”

If you’ve having issues with your PS3 involving the login to the Playstation network, this is why. It’s incredibly annoying when trying to use Netflix.

SOAPUI – Catching Test Case Completion Time

To capture how long it took a particular test case to complete, use the following property expansion in your DataSink.

${=testRunner.TimeTaken}

The result is in milliseconds. It is the sum of the time taken by all test steps during the execution of your test case.

SOAPUI – Generating a Random Value

By placing the following property expansion in your SOAP request in SOAPUI, a random number between 0 and 50,000 will be inserted in it’s place.

${=(int)(Math.random()*50000)}