view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

log file switch (archiving needed)

I was running a test in Oracle 11.2 and the SQL below, which usually takes around 1 minute, seemed to be running forever: SQL> begin   2   for a in 1..8 loop   3    insert into tab1 select * from tab1;   4   end loop;   5  end;   6  /

ORA-00942

These examples were tested on Oracle 11.2.

Can't open database

SQL> create controlfile set database TESTDBS
2 logfile group 1 ('/usr/oracle/oradata/dbs005/TESTDBS/redo01.log') size 100m, group 2 ('/usr/oracle/oradata/dbs005/TESTDBS/redo02.log') size 100m
datafile '/usr/oracle/oradata/dbs005/TESTDBS/data_clone_01.dbf' size 30m, '/usr/oracle/oradata/dbs005/TESTDBS/data_clone_02.dbf' size 50m
3 4 character set WE8MSWIN1252;
character set WE8MSWIN1252
*
ERROR at line 4:
ORA-01969: You must specify RESETLOGS or NORESETLOGS

Coincindences

I had another of those odd timing events today that make me think that Larry Ellison has access to a time machine. I found (yet another example of a) bug that had been reported on MoS just a few days before it appeared on an instance I was running. How is it possible that someone keeps doing things that I’m doing, but just a few days before I do them !

For no good reason I happened to browse through a load of background trace files on an 11.2.0.4 instance and found the following in an “m000″ file:

Coincindences

I had another of those odd timing events today that make me think that Larry Ellison has access to a time machine. I found (yet another example of a) bug that had been reported on MoS just a few days before it appeared on an instance I was running. How is it possible that someone keeps doing things that I’m doing, but just a few days before I do them !

For no good reason I happened to browse through a load of background trace files on an 11.2.0.4 instance and found the following in an “m000″ file:

Big Data Oracle NoSQL in No Time - It is time to Load Data for a simple Use Case

Big Data Oracle NoSQL in No Time - It is time to Load Data for a simple Use Case

Index

missing my local conference makes me a little grumpy

Our big event here is a 2 1/2 day conference ( Great Lakes Oracle Conference aka GLOC ) is coming up soon in mid May and I am going to miss the first two days of it.  Not happy exactly but I do have a reasonable excuse.

My oldest daughter finishes her sophomore year at college ( Fordham in NYC ) and needs to get picked up ( and dorm room packed up ) and carted back home to Ohio.  So it is drive there sunday ... pick her up Monday and pack ... drive back Tuesday ...

Three Quick Tips for Better Blogging

Learn how to edit your tagline, customize comment prompts, and schedule posts -- three great tips to have in your blogging back pocket.

Bitmap loading

Everyone “knows” that bitmap indexes are a disaster (compared to B-tree indexes) when it comes to DML. But at an event I spoke at recently someone made the point that they had observed that their data loading operations were faster when the table being loaded had bitmap indexes on it than when it had the equivalent B-tree indexes in place.

view counter