Skip to content

Category Archives: Uncategorized

Changes (Ace Comic)

The Adventures of Ace DBA

This entry is part 19 of 19 in the series Adventures of Ace, DBA It’s the only explanation! Related Ace has dealt with problems before… Default blame accepter?

The post Changes (Ace Comic) appeared first on Steve Karam :: The Oracle Alchemist.

Posted 10 May 2013 † The Oracle Alchemist § Oracle ‡ Comments Off ° Tagged:

MacBook Pro Mid 2009 : Replacing hard drive with SSD…

I’ve had my 13″ MacBook Pro since the mid 2009 refresh and it’s been really reliable. Apart from one brief visit to Apple to replace a noisy fan, I’ve had no worries. A few years ago I upgraded from 4G  to 8G RAM, so I’m not stranger to taking the back off it. Even though [...]

MacBook Pro Mid 2009 : Replacing hard drive with SSD… was first posted on May 10, 2013 at 9:27 am.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Posted 10 May 2013 † Tim... § ‡ Comments Off ° Tagged:

Direct path read and fast full index scans

This is yet another blogpost on Oracle’s direct path read feature which was introduced for non-parallel query processes in Oracle version 11. For full table scans, a direct path read is done (according to my tests and current knowledge) when: – The segment is bigger than 5 * _small_table_threshold. – Less than 50% of the …

Read More

Posted 09 May 2013 † Frits Hoogland § Oracle ‡ Comments Off °

MobaXterm 6.3…

Thanks to Norman Dunbar for pointing out that MobaXterm 6.3 has been released. You can find the download and changelog in the usual place. I’ll be interested to see how the performance improvements to SFTP work out. I’ve seen some issues with this during transfers of large files before. The built in NFS and VNC servers [...]

MobaXterm 6.3… was first posted on May 9, 2013 at 8:17 pm.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Posted 09 May 2013 † Tim... § ‡ Comments Off ° Tagged:

UltraEdit 4.0 for Mac/Linux…

UltraEdit 4.0 has been released for Mac and Linux. The downloads are in the usual place. You can see the latest changelogs here (Mac, Linux). Fun, fun, fun… Cheers Tim…

UltraEdit 4.0 for Mac/Linux… was first posted on May 9, 2013 at 2:25 pm.
©2012 “The ORACLE-BASE Blog“. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Posted 09 May 2013 † Tim... § ‡ Comments Off ° Tagged:

Clustering_factor

Cost Based Oracle – Fundamentals (November 2005) But the most interesting function for our purposes is sys_op_countchg(). Judging from its name, this function is probably counting changes, and the first input parameter is the block ID portion (object_id, relative file number, and block number) of the table’s rowid, so the function is clearly matching our … … Continue reading →

Posted 09 May 2013 † Jonathan Lewis § Oracle ‡ Comments Off °

How to Get 32 Scrabble Points with SEEN

Back in mid-March, I wrote:A week ago, I played a game of Scabble with Veva and scored 32 points by placing the word “SEEN” on the board. Now, every letter in “SEEN” is worth 1 point, making it very difficult to get to 32 points. But I attached “SEEN”…

Posted 08 May 2013 † StevenFeuerstein § ‡ Comments Off °

What I Look Like When Shaving Stops

Haven’t shaved for two weeks. Decided to give my skin a break, and I also wondered: what do I really look like? Shaving my head is, I have come to accept, the “main vain” thing I do in my life (well, that and painting flamboyan flowers on my toenails)….

Posted 08 May 2013 † StevenFeuerstein § ‡ Comments Off °

Online retailers have 3 seconds to make mom happy.

Mothers day is coming up fast. May 12th 2013 is just around the corner and If you have not already done so, make sure you go out and get mom a special gift as soon as possible. If you need a hand picking something great, take a look at this mothers day gift guide by…

Posted 08 May 2013 † Samer Forzley § ‡ Comments Off °

Raw Devices…

A quick request…If you are using RAW devices for your database (no ASM, no filesystem – just ‘raw’) – please drop me a line and let me know.  Include the size of  your database as well please.thanks!

Posted 08 May 2013 † Thomas Kyte § ‡ Comments Off °