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 …
Category: Oracle
Jun 17
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 …
May 21
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 …
May 19
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 …
May 15
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 …
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 …
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 …
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 …
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 …
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, …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
