Oracle and more - Amardeep Sidhu

Just had a glimpse. OTN forums has got a new look. A bunch of new features has also been added. Some of the new things i noticed are:

• That simple editor is now rich text editor. Also supports emoticons.
• You can add tags to a post and it displays the tag cloud (for all the posts) on right side.
• A post can be marked as a question and then there will be some points system based on answers.
• That list of Top users doesn’t show those users n ACEs. It display a new list of people instead.
• Report Abuse button has been added (with each reply).

May be there are some other changes too. That is what i noticed in the very first look.

Nice change indeed ! I am not happy with the font though, it is very small

I just opened OTN forums and found:

High availability live

Came across an image showing Google’s working in 60’s (Obviously its a parody)

Today I was checking OTN forums and came across a thread. OP’s concern was:

One of the db i am supporting has about 3.3 Terabytes capacity and the application is using only 1 huge tablespace with one big file.

the system is linux 4 , 32 bit.
oracle version is 10.2.0.4

Is there a limit of space for a tablespace when you consider insert/delete/query performance?

Single datafile of 3.3 TB

Awesome !

Kudos to the designer

I had got an export of a database and had to import it to a new database. The only difference was that in new database few of the large tables were partitioned. So instead of partitioning it after the import, i thought about pre-creating the tables (with partitioning) and then run import with ignore=Y . Everything went fine. But later on the front end application gave some error and we came to know that default values for columns in some tables were not set. I did some googling and didn’t find much. Then i posted the same to OTN forums and came to know that if the table pre-exists, import doesn’t take care of default values of columns. Metalink note 224727.1 discusses this. So if you are pre-creating the tables and there are some default values for any columns, set it manually, don’t rely on import for this. Same is true for impdp as well.

I just opened the Oracle Community page and :

Today I was searching for an error message in metalink and it was giving strange messages. Then i came to know that the error message contained “%” character and metalink was not really happy searching for it. Rather it showed a confusing message:

Pretty strange…

I recently upgraded my blog to Wordpress 2.5. The manual process is real cumbersome. Today I came across few plugins which help in almost automating the upgrade stuff.

Wordpress Automatic upgrade: As per description this plugin first takes backup and then upgrades. I didn’t try this one, though.

Instant Upgrade: I upgraded one of my blog using this. It doesn’t take care of backup but otherwise the upgrade was super smooth. Just few clicks and you are done.

Happy upgrading !

If you use Gtalk and Winamp simultaneously and tried to set the currently playing track as your status, you might have been faced by Gtalk hanging. I also struggled with this for 2 weeks until  I did a bit of googling and got a link which gives a trick to get rid of the problem.

The trick is to create an empty winamp.m3u file in \Program Files\Winamp folder and you are done.