Brian Peasland
Author's posts
Sep 27
Back from Open World 2013
I am back from Oracle Open World 2013. This was my first Open World conference. I knew it was big but I was still unprepared for the overall size. Approximately 60,000 people attended the conference. I really doubt that it is possible to take in all that the conference offers in one week’s time. There …
Sep 20
Off to Open World
I am After this period, acute phase is started generic tadalafil uk and the person starts feeling aroused after some time and then the penis achieves rock solid erection that provides better performance and pleasure increases. Nonarteritic anterior ischemic optic neuropathy (NAION) tadalafil cheapest online and other Drugs- possible interactionsThis medication should not be taken …
Sep 17
12c Move Datafiles Online
Prior to Oracle 12c, if you wanted to move a database’s file, you either had to shutdown the database, or take the datafile/tablespace offline. Here is an example of the steps you might take: ALTER TABLESPACE my_ts OFFLINE; !mv /old_dir/my_ts01.dbf /new_dir/my_ts01.dbf ALTER DATABASE RENAME FILE ‘/old_dir/my_ts01.dbf’ TO ‘/old_dir/my_ts01.dbf’; ALTER TABLESPACE my_ts ONLINE; Now in Oracle …
Sep 17
12c Adaptive Plans
I’ve been meaning to write something up on Oracle 12c’s new Adaptive Plans. When I do have poorly performing SQL statements, it seems that the issue is often due to bad optimizer stats. Recalculate the stats and performance is improved. I like the new 12c feature of Adaptive Plans where the database engine will reformulate …
Sep 05
12c Data Redaction
Oracle 12c’s Advanced Security option now includes Data Redaction. This is a great way to secure your data , transparently to the application, from prying eyes. If an end user does not need the entire tax id, they can be presented with just the last four digits, as an example. To me, this is just …
Sep 05
ORA-01097
Every once in a while, a person comes across something that has been around forever but is a new experience for them. Just today, I hit the ORA-1097 error for the first time in my career. I was in a test database and needed to shut it down. SQL> shutdown immediate ORA-01097: cannot shutdown while …
Sep 04
Oracle 11.2.0.4 Released
I had a short vacation last week and while I was gone, Oracle released the 11.2.0.4 patchset. This is patch number 13390677. It seems that as soon as I get caught up, I have a new version to contend with. Some time ago, I was two weeks away from completing upgrades of all of our …
Aug 27
SQL Developer 4 Explain Plan Options
I often use SQL Developer as a quick and easy way to generate an Explain Plan for a query. I see that the new version of SQL Developer 4 contains a few more options than than its predecessor. In SQL Developer 3, you could go to Tools –> Preferences and then in Database –> Autotrace/Explain …
Aug 26
SQL Developer 4
As time goes on, I am becoming more and more of a big fan of SQL Developer. I use this product daily and I often have many windows open to do my work. SQL Developer 4 is in Early Adopter phase. You can get a copy of it here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-download-v4-1925679.html My only complaint with the …
Aug 07
oratop
I was recently made aware of a new Oracle-supplied utility named oratop. This professed to be a tool similar to the Unix/Linux top utility, but for Oracle databases. I have now had a chance to use this and play around with it a bit. If you want to download the utility, visit Metalink Note 1500864.1 …
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
