NoCOUG Journal – Aug 2015

Another edition of NoCOUG journal came out today. In this issue, for the Many Things Oracle column, I talk about Trace File Analyzer Collector (TFA) and my experience updating TFA using latest PSU patch… Read here… This is fourth installment of Many Things Oracle column in NoCOUG journal. The past articles are: NoCOUG Journal 2015 MAY: … Read more

Oracle Tidbits – July 2015 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in July 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Publish Date TidBit 1-Jul #oratidbit … Read more

Oracle Tidbits – May & June 2015

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in May and June 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Date TidBit 11-May … Read more

Oracle #DB12c New – TEMP_UNDO_ENABLED

Global temporary table data is stored in the temporary tablespace (where no redo will be generated on the DML operations). When DML operations are performed on global temporary table, for read consistency undo must be generated. Such undo records are written to undo tablespace, and thus redo generated on the undo writes. If you perform … Read more

FLOAUG15 SunCollaborate – VirtualBox Session

Florida Oracle Application User Group SunCollaborate 2015 just finished. Great conference, kudos to all worked to make this happen. Had a good session talking about VirtualBox. I just uploaded the slides here… http://www.slideshare.net/BijuThomas3/2015-floaug-bijuthomas Earlier Post on VirtualBox here… Pre-Built Oracle Database 12.1.0.2 on VirtualBox

Oracle #DB12c New – MAX_STRING_SIZE

In pre-12c database releases, VARCHAR2, NVARCHAR2 data types were limited to 4000 bytes and RAW data type was limited to 2000 bytes. If there is a need to store more data in VARCHAR2 column, you can in 12c after setting the parameter MAX_STRING_SIZE to EXTENDED. With setting MAX_STRING_SIZE to EXTENDED, you can store up to … Read more