Brian Peasland

Author's posts

Web Site Down and Twitter Feed

My web site was down for the last 4 days. My apologies. I had to spend a lot of time going back and forth between my ISP and my domain registrar. But it seems to be sorted out now. So the good news, depending on your perspective, is that once my site came back up, …

Continue reading

Who is using my swap space?

Most of the time, I post entries in this blog to share knowledge with others. Sometimes, I post an entry so that in the future, I can quickly find an answer to something I know I forgot. This is one of those times. If other’s find this useful, great! I’ve been working on a Linux …

Continue reading

TNS-12519 w/o Max Processes Reached

I got a call from someone that they were getting TNS-12519 errors in their application. Sure enough, those messages were in the listener.log file as well. TNS-12519: TNS:no appropriate service handler found For those that aren’t familiar with this error, it typically means one of two things. Either the service name is not registered with …

Continue reading

ADDM on SearchOracle.com

Here is another article I wrote for SearchOracle.com in case you missed it. This one focuses on how to use ADDM to quickly diagnose a performance problem. http://searchoracle.techtarget.com/tip/Oracle-ADDM-helps-resolve-SQL-performance-problems The muscle becomes tough and contracts due to purchase generic levitra irregular and low blood levels which are necessary to continue the lovemaking acts smoothly. Philadelphia 76ers …

Continue reading

Which Linux Partition?

I’m trying to upgrade a system’s Grid Infrastucture to the latest/greatest version. The OUI says that I need 7GB of free space and I’m a little short. This is on virtual machines so we can grow the disk easily enough. Everything is installed in the root partition (this isn’t production) and my SysAdmin is asking …

Continue reading

Oracle Certifications

I ran into a question on the forums today asking how to obtain certification information. Oracle includes this if you have a paid support contract. This blog post will show how to see certification information for an Oracle product on http://support.oracle.com for those that have access. After you sign on to My Oracle Support, click …

Continue reading

SCP Client on Windows

Most of my Oracle databases run on Linux. And prior to that, one form of Unix or another. I’ve grown quite accustomed to using scp to quickly transfer a file between systems. While my databases may live in a *nix world, my workstation is normally a Windows OS. Natively, Windows has ftp, but not scp …

Continue reading

SQL Monitoring in SQL Developer

In my last article for SearchOracle (referenced in my last post to this blog) I showed an example of how I quickly got to the root cause of a poor performing query using SQL Monitoring in Enterprise Manager. Today, That Jeff Smith of SQL Developer These phones have made human lives easier and include much …

Continue reading

Proper Tools Make Tuning Fast Work

I am starting to write articles for publishing on SearchOracle.com. I have been loosely affiliated with them since 2001, mostly in their Ask The Experts section. My first article is on the benefits that tools can play in making your tuning life much easier. Jelly is only a soft and suppler form of viagra in …

Continue reading

SEC_CASE_SENSITIVE_LOGON Deprecated in 12c

I’m working on getting my companies databases upgraded to Oracle 12.1.0.2 before our 11.2.0.4 databases lose free Extended Support in Jan 2016. One of the “gotchas” for us is that the SEC_CASE_SENSITIVE_LOGON parameter is deprecated in 12c. It’s still there, but who knows for how long. Before I arrived at this company, they upgraded to Oracle …

Continue reading