Oracle Tidbits – August 2015 #oratidbit
“Oracle *daily* TidBits” (#oratidbit) published on weekdays in August 2015
Mastering the Oracle Stack, One Post at a Time.
“Oracle *daily* TidBits” (#oratidbit) published on weekdays in August 2015
The article/blog is published on my company website… Improve Performance using Oracle Smart Flash Cache
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 *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 *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
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
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
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