I hope you're right.

 I hope you're right.

I hope it's just overblown, breathless nonsense concocted by the liberal media.

I hope this is all a hoax that the libtards cooked up when they got bored with peddling climate change.

I hope it's a Machiavellian plot by the DNC to get the mighty Trump out of office.

I hope that it's no worse than the flu.

I hope that Biden goes to jail and the world acknowledges that the election was stolen and Trump gets back in office and can can put everything right with the world again.

I hope that Obama was born in Kenya.

I hope he's a Muslim and a terrorist and a radical.

I hope that the 2008 bailout really was a government takeover of the auto industry and we've all just failed to see it.

I hope that Sharia law takes over. No, wait. I hope that it was really going to, but then was somehow thwarted by Rush Limbaugh as his last, heroic, dying act. Or something.

I hope that Fox News announces an investigative report of all the people that were killed by the death panels in the healthcare bill.

I hope that Elvis is still alive, that he's happily married to a mermaid, and that they're living in the sound studio that was used to film the moon landings.

Honestly, I'm not even joking. I really hope that, because it's the last hope we have.

You'd better be right. You have to be right. Because there is no opportunity for any other course than the one we're on.

I've never wanted more to be wrong, because it looks to me like people are lying to you and laughing all the way to the bank.

... Again ...

It looks to me like the vaccine is way < 100% effective.

It looks to me like ain't nobody gonna be wearing no goddam masks to make sure they don't give a deadly respiratory infection to their friends and neighbors - a respiratory infection that is even more serious than last year; that took at least 6 people I knew in 2020, and that hospitalized four others. (2 of which still haven't "bounced back")

You guys are in charge. Seriously. You on the right. You run the world, or at least the part I live in.

You'd better be right.

You'd better be right, or this is going to get really ugly really fast.

Edit: Nope. You were wrong, and people I love died. Because what else could possibly have happened? Oh, well. At least you're Pwning the libs.

Finding SQL Statements in an Oracle Trc File

It often comes to pass that I have received an oracle alert file indicating deadlocks along with a .trc file from one of our customers.

As we all know, deadlocks are an *APPLICATION* problem, not a database problem.
Still, the developers are my team, my posse, my *PEOPLE*, yo, and imma help 'em out. ;-)

So, to make their analysis easier, one of the things I like to do is give them a consolidated list of SQL Statements from the .trc file. This helps them to understand what the application is doing when the deadlock  occurrs.

To find any lines that contain select, insert, update, or delete, you can do the following search. (NOTE: This could easily be expanded to include Merge, etc.  )


Using Notepad ++ ,  I search for

\b(?:select|insert|update|delete)\b .*?$

I then use Notepad++'s bookmark feature to bookmark each line that matches the search.

Finally, I use Search -> Bookmark -> Remove Unmarked Lines

This will remove everything but the Select, Insert, Update, and Delete statements.

Change font for "Connections", "Reports", etc in Oracle SQL Developer

NOTE: These instruction apply to the connections, reports, menus, etc in Oracle SQL Developer. If you are looking to change the font of your PL/SQL Code, these instructions in StackOverflow are for you.

I found instructions here for changing fonts in Oracle SQL Developer (OSD) menus and trees, but being sloppy caused me to struggled a bit.

 (Story of my life ¯\_(ツ)_/¯ ) 

A couples things that should probably have been obvious, but were cheerfully ignored by the idiot with a laptop (Dr. Who Reference) :
1) Before making any changes, shut down Oracle SQL Developer.
    This is important because the file gets overwritten when OSD is closed.
2) Make the recommended changes to the file at:

C:\Users\\AppData*\Roaming\SQL Developer\system19.2.1.247.2212\o.sqldeveloper\ide.properties

NOTE*: AppData is a hidden file.
      In Windows Explorer, go to view and make sure hidden files are enabled.
     
NOTE: This was true for OSD  Version 19.2.1.247, Build 247.2212
      The system19* folder details may change for previous or subsequent releases

3) Start OSD and enjoy not having to squint at your connection data ;-)

Another quick note: If Oracle would open-source OSD, I would be happy to add a menu item that would set this font. This is an example of the ways in which OSD, which is a FANTASTIC TOOL all things considered, nonetheless feels just sort of unfinished.

Big thanks to Jeff Smith for publishing instructions on this topic. :-D

WebSphere Application Server - DB2 RS Transaction Isolation Level is Default

In WebSphere, the default transaction level is set to something very restrictive.

It’s likely that they haven’t changed this in their app server configuration.

Have them check the webSphereDefaultIsolationLevel custom property on their data sources.

https://www.ibm.com/support/pages/determining-and-changing-isolation-level

“If the database connection is obtained in a servlet, JSP, or session bean, TRANSACTION_REPEATABLE_READ is used by default.”

JDBC Isolation Level

              

DB2 Isolation Level

TRANSACTION_SERIALIZABLE      Repeatable Read (RR)

TRANSACTION_REPEATABLE_READ           Read Stability (RS)  ← Deafult

TRANSACTION_READ_COMMITTED          Cursor Stability (CS) ← What we want

TRANSACTION_READ_UNCOMMITTED    Uncommitted Read (UR)

“In WebSphere Application Server V6.1 and above, the webSphereDefaultIsolationLevel custom property can be set on a data source to change the default isolation level that is used even if indirect JNDI lookups and resource references are not used by the application.”

Procedure for changing this setting in WAS 8.5.5 can be found here:
https://www.ibm.com/support/knowledgecenter/en/SSWLGF_8.5.6/com.ibm.sr.doc/twsr_setwebspheredefaultisolationlevelproperty.html

Changing SGA & PGA memory for Oracle

The following can give good info on target memory advice after your system has been running for some time. It is cleared during restart
 select * from V$MEMORY_TARGET_ADVICE ;

BACKUP your SPFILE before doing any radical changes.
Example location ~ D:\oracle\product\12.1.0\dbhome_1\database

To set pga to 1 gb and sga to 3 g, enter the following commands:

ALTER SYSTEM SET pga_aggregate_target=1G SCOPE = SPFILE;
ALTER SYSTEM SET sga_target=3G SCOPE = SPFILE;

You will need to restart your Oracle database.

And, Bob's your uncle, you should have your PGA and SGA set to the new target values.

WebSphere Application Server Network Deployment 7.0 security.xml corrupted.

On one of our internal WebSphere application server network deployment v7 environments, I hit the following error.

The error was: com.ibm.websphere.ssl.SSLException: Cannot get security object from WCCM

Security.xml appeared to have been corrupted. The security.xml file was blank.

To resolve this, I had to copy a security.xml file from another server, and then edit it to 

1. replace the original server name with the name of my corrupted server 
2. change it to disable security altogether as instructed here.
1. NOTE: I had to use the 2nd method mentioned, since my Dmgr was stopped. 

Thanks so much to Chandan Kumar of GeekFlare for posting this very useful procedure :-) 

In case something should happen to GeekFlare,  I am copying it below. Please attribute all credit to Chandan for this!