Brian Peasland

Author's posts

May 07

SQL Developer 4.1 Released

SQL Developer 4.1 was released on Monday. Here is the link to download the latest/greatest version.   ThatJeffSmith has a nice recap of the new features on his blog. I like the new formatting options and the Multi-Cursor Support is awesome! The Instance Viewer is cool, but I typically have a session on in EM12c which …

Continue reading

Apr 23

Oracle RAC on my Laptop with Virtual Box

This really isn’t a new topic. I’m not first one to publish something like this. But I had a need to get these instructions posted on my blog. So here is how I created a two-node Oracle RAC testbed on my laptop. An earlier blog post shows why I think testbeds are important. When I …

Continue reading

Apr 09

SQL Server Missing Log File

We recently had one of our SQL Server instances experience a very large volume of change. Not suprisingly, the transaction log grew really big and was very close to filling up the disk. I had our SysAdmins add more space to the transaction log disk. The process that generated the large volume of transactions is …

Continue reading

Apr 06

EM12c Now Allows DB12c for Repos

It is now possible to use Oracle 12c as a repository database for Enterprise Manager 12c Cloud Control. Oracle 12c is almost 2 years old and the first patch set is almost 1 year old. Many medicines and treatments such as beta-blockers, anti-depressants, etc tadalafil cialis come with great risk of ED. Oweing to the …

Continue reading

Mar 02

GWFG in Oracle RAC

I have a deadlock being reported in my 3-node Oracle RAC database (version 11.2.0.4) as can be seen in the Alert Log. Being that this is an Oracle RAC database, resources are managed globally and the Lock Manager Daemon (LMD) gets involved. The message in the alert log pointed me to a LMD trace file …

Continue reading

Feb 12

Oracle RAC Performance Tuning

I am proud to announce that my book is now available for purchase! Please order Oracle RAC Performance Tuning today! http://www.amazon.com/Oracle-RAC-Performance-Tuning–Focus/dp/0986119415/ref=sr_1_2?ie=UTF8&qid=1423756491&sr=8-2&keywords=peasland   Generic drugs and meds are buy tadalafil in australia as safe and effective as the original medication. On the buy levitra http://mouthsofthesouth.com/wp-content/uploads/2020/02/MOTS-03.07.20-Dixon-.pdf contrary, in acidic condition, they stop working. Basing the actual treatment …

Continue reading

Jan 27

Sample Schemas on GitHub

Oracle’s sample schemas are an extra download. For Oracle 12c, the sample schemas are in file 7 of 8 of the downloads. So if you want the sample schemas, you have to go to OTN or Metalink for the patchset version and download the file. Someone also posted the sample schemas on GitHub here: https://github.com/oracle/ Despite …

Continue reading

Jan 27

SQLT and Partitioning

I was made aware of this today: Note 1951018.1 SQLT Utility and Partitioning Tables The person who pointed this out was afraid that they would be violating licensing if they used SQLT, which would create partitioned tables. If you read the note carefully, SQLT buy sildenafil no prescription Further, the pressure of satisfying the partner …

Continue reading

Jan 23

SEC_CASE_SENSTIVE_LOGON in 12c

Oracle 12c deprecates the SEC_CASE_SENSITIVE_LOGON parameter. It is still there for backwards compatibility. But Oracle would like to see everyone use case sensitive logons in the future. The one thing that did surprise me was when I recently upgraded a test db from 11.2.0.4 to 12.1.0.1 using the DBUA. At the end of the DBUA, …

Continue reading

Jan 22

Deprecation of non-CDB

The rumors started flying shortly after Oracle 12c was released with its new multi-tenant architecture that someday, there would be no Oracle databases that were not multi-tenant. Today, the Twitterverse has had a number of posts that reference this part of the Oracle documentation: https://docs.oracle.com/database/121/UPGRD/deprecated.htm#BABDBCJI   So the non-CDB architecture is deprecated now. Better start learning …

Continue reading