31 Jul
Resource Manager Enhancements in 11g…
I’ve just put another Oracle 11g new features article live:
Resource Manager Enhancements in Oracle Database 11g Release 1
Cheers
Tim…
Archive for July, 2008
30 Jul
Using mysqld_multi to Manage Multiple Servers
I recently needed to set up multiple MySQL servers on a test computer to simulate a master-slave setup. I had never done this before, so I think it might be useful for others if I documented what occurred. This setup was done on a Linux server, however other platforms should operate similarly. I choose […]
30 Jul
My Dell laptop lives again…
I’ve been having a little trouble with my Dell Inspiron 9400 laptop. Every few minutes the screen would go really dim, like it was in power save mode. Switching it to standby and back or remote desktoping to it would kick it back into gear, but that’s not exactly helpful.
Yesterday I rang Dell to see […]
30 Jul
NOVALIDATE Constraints Part II - Does It Matter ?
As promised, more on NOVALIDATE constraints.
As previously discussed, a Primary Key or a Unique Key constraint that’s not validated is by default policed by a Unique index regardless. If there are no duplicate values, then no worries (yes, I’m Australian), Oracle will create the Unique index and enable the constraint in a NOVALIDATE state. If there […]
30 Jul
July 2008 Critical Patch Update (CPU) is the first to use CVE-ID numbers
One thing I forgot to mention the other day in my post July 2008 Critical Patch Update is out - a remote un-authenticated exploit revealed is that one of the major changes you will notice with this CPU is that….[Read More]
Posted by Pete On 18/07/08 At 10:34 AM
30 Jul
ORA-06544 when performing network expdp between 11g and 10g
When I was trying to perform a network export datapump between 11g and 10g I found an ORA-06544 error.[oracle@alpha admin]$ impdp SCOTT/TIGER tables=emp_10g,dept_10g network_link=db10gImport: Release 11.1.0.6.0 - Production on Tuesday, 29 July, 2008 22…
30 Jul
Sentrigo release Hedgehog vPatch
Sentrigo have released a new version of Hedgehog called vPatch. Basically, itâs the same Hedgehog product but without the ability to create custom policies. After installation, without any configuration by the customer, Hedgehog vPatch will protect the database from known….[Read More]
Posted by Pete On 17/07/08 At 09:15 PM
30 Jul
Streams and Grants
I didn’t blog about streams in a while. Since the last time I blogged about streams our configuration changed a lot, but I’ll write about it another time. Its more fun to write about war stories than about nice clean architectures with ultra easy setup scripts.
Yesterday another happy customer went live on our reporting database. […]
30 Jul
10.2.0.4 Post Mortem
In the end, my 10.2.0.4 SGA problem ended up being the _db_block_cache_protect parameter. Seems as though setting that parameter in 10.2.0.4 maps the SGA to /tmp/shm instead of real memory. The immediate cause of my:
ORA-27102: out of memory
Linux-x86_64 Error: 28: No space left on device
was that I didn’t have enough space mounted at /tmp/shm. When I did allocate enough space, I got an ORA-
30 Jul
Sheeri Cabral Speaks at Oracle Open World
An event truly fitting an “open world” — I will be speaking at Oracle Open World.
How does a wild-mannered MySQL DBA like me get to speak at an Oracle conference? Well, after I received the MySQL Community Award two years in a row, Dan Norris contacted me, and encouraged me to submit a proposal […]