Brian Peasland
Author's posts
Aug 01
12c DBA_USERS Changes
Today, I was looking at the ability to query a user’s last login time. Prior to 12c, one had to create a logon trigger to store the logon time in a table or set up auditing and audit successful logins. Now, Oracle 12c includes, by default, a way to determine the last time someone logged …
Jul 31
12c VARCHAR2(32767)
I’ve always wondered why the VARCHAR2 datatype was limited to so few characters. For most attributes, you do not need more than 2,000 bytes. I remember when Oracle upped the limit from 2,000 bytes to 4,000. But SQL Server 2008R2 lets you use 8,000. We are talking about character data and the 2,000 or 4,000 …
Jul 31
12c Autopopulating Column with Sequence Value
In yesterday’s blog post, I wrote about creating a table with an IDENTITY value. But the Oracle 12c new feature that I like better is allowing a sequence to be the number generator for the default value of a column. To see what I mean, look at this example: SQL> create sequence test_seq; Sequence created. …
Jul 30
12c IDENTITY columns
I live and work close to a Microsoft facility. As such, many of our current employees are former Microsoft employees that come from a SQL Server background. SQL Server lets you create a table with an IDENTITY column. Oracle 12c now lets you do the same. This should help those who are making the transition …
Jun 27
Oracle 12c Top New Features
I figured I would give my top new features for the recently released Oracle 12c database. I think one of the most interesting new features is the Pluggable Database, but it seems like everyone is talking about that. So I’ll focus on other new features that I am interested in. This list is in no …
Jun 26
Oracle 12c DB Express
Last August, I mentioned that Oracle’s EM DB Control product was nearing the end. Now that Oracle 12c has been released, we now have information that the replacement for DB So, to treat erectile dysfunction in men is very urgent. get viagra without prescription Clean the genital area by using this douche. tab viagra 100mg …
Jun 26
Oracle Database 12c Arrives
Oracle just launched the newest major version of their flagship product, Oracle Database 12c. The documentation can be found here. Instead of 100mg of generic viagra sale , even a 50mg pill or Kamagra might be quite sufficient to get a diagnosis and decide what treatment is the right one to suit each individual can …
Jun 21
CSV in SQL Developer…
…and other formats as well. I came across this in a recent AskTom article where you can quickly generate output from a query in CSV format using SQL Developer. The way I have always done it, is to enter the SQL statement in my SQL Worksheet. Then hit Run Statement (CTL-Enter). Right click on the …
May 21
ORA-16205 Upgrading to 11.2.0.3
I am trying to upgrade all of our databases from 11.2.0.2 to 11.2.0.3 this year. My first upgrades were on a 2-node RAC primary with 2-node RAC standby database in a testbed. There isn’t much to this database as it is just a starter database. But this let me test out the upgrade on RAC …
Apr 17
Auto Generating Response File
I am working on upgrading multiple databases to the Oracle 11.2.0.3 version. Before the upgrade, I need to install this version on multiple machines. We’ve known for a long time that you can generate a response file and use this for a silent install, speeding up the installation. The way I’ve always created my response …
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
