Oracle and more - Amardeep Sidhu

My experiences with technology…

Archive for the 'Oracle General' Category


OTN forums get a new look

Posted by Sidhu on 29th June 2008

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 :(

Posted in Oracle General | 1 Comment »

A database - one tablespace & one datafile

Posted by Sidhu on 10th June 2008

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 ;)

Posted in Oracle General | No Comments »

Have you searched “%” in metalink ?

Posted by Sidhu on 18th April 2008

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…

Posted in Oracle General | No Comments »

OTN forums etiquettes

Posted by Sidhu on 4th April 2008

Finally finally finally a small sticky has been posted on OTN Database forums homepage. But its there only on Database forums page not on PL/SQL. It reads like:

Posters, please mind these common-sense rules when participating here:

- When asking a question, provide all the details that someone would need to answer it. Consulting documentation first is highly recommended. (See http://blogs.oracle.com/shay/2007/03/02 for more hints.)
- When answering a question, please be courteous; there are different levels of experience represented here. A poorly worded question is better ignored than flamed - or better yet, help the poster ask a better question.

Thanks for doing your part to make this community as valuable as possible for everyone!

- OTN

That means Database forum enjoys most number of flames ;)

Posted in Oracle General | 3 Comments »

Howard’s decision…

Posted by Sidhu on 23rd October 2007

Howard Rogers has done a post on his blog that is the site Dizwell worth it ? Do post your opinion. If he plans to close it down, we will miss a great resource for Oracle.

Sidhu

Posted in Oracle General | 1 Comment »

Asking Tom ? Read this !

Posted by Sidhu on 16th October 2007

Tom Kyte did a post on his blog about posting of reviews of questions on Asktom. In a nutshell the reviews not related to the original question will be ignored/deleted (not decided yet, as Tom said).

As other people said in the comments, personally I too like this idea very much. Earlier, many times, there were questions which started with someone asking about appropriate SGA size, then there were some other twists and discussions and then the thread ended in discussion about good or bad authors or something similar light years away from the original topic.

Now this action will make the discussions flow in a very controlled and neat & clean manner, all about the original topic. Hoping to see all the “great content” in a very orderly manner :)

Sidhu

Posted in Oracle General | No Comments »

Official Oracle wiki

Posted by Sidhu on 15th October 2007

Today I was checking Eddie Awad’s blog. From there I came to know that Oracle has started Official Oracle Wiki hosted by Wetpaint. Check out. I just made my login. Hoping to contribute whatever little I can

Sidhu

Posted in Oracle General | 2 Comments »

Google friendliness of …

Posted by Sidhu on 19th September 2007

Being a new kid on the block, I think, my post will not fire any serious and “scary” discussion as it has happened many times in the past. Just writing my experience. Whenever I search something related to Oracle in Google there are few sites that are bound to come up in the very first results ( No surety about the relevance and completeness of the content, though). Today I was searching about scheduling new jobs in oracle and I was, sort of, surprised to see the results [Though, I got from there, what I was looking for & I would like to say Thanks for that]. Many other times also, I have seen these websites pop up like anything.

When I had started my job and after that put the CV on few job sites. Everybody used to say: put more number of keywords in the CV as their search bots select the resumes on the basis of keywords only. Perhaps same thing applies here also. They have included each and every possible keyword in Oracle on their websites [& I think in a better way than it's been done in Oracle documentation ;)]. If its not one of their own websites then some books website (that also their own, obviously) will come up [& the keywords matched here are from table of contents or some portion from some chapter Ctrl+C'ed and Ctrl+V'ed there] with advertisement all around imitating the big bang universe theory. Some special experience, with making websites Google friendly, they have got ;)

Sidhu

Posted in Oracle General | No Comments »

Being an Oracle trainer…

Posted by Sidhu on 19th August 2007

Few days back, I had to give Oracle DBA training to a group of about 20-25 semi-technical people (Semi-technical, because most of them were not really DBA kinda folks doing all the techie stuff with Oracle, but in-fact having learned some bits & bytes of Oracle sometime back and these days looking into application functionality from technical perspective). I, having just about 10 months of experience with DBA profile, had to cover, everything about Oracle starting from creating database and up to performance tuning :) Its really an interesting job if the audience is good. But not an easy game. You have to know everything and have to be ready to answer people’s queries (some stupid & dumb questions also :) I had to cover a total of about 350 slides in a day or less. So at times, really went fast and skipping some of things. It was a nice experience as a whole :)

& in the end when I finished it, was dead tired :(

Hats off to the trainers, who stand for the full day and that too for many days continuously :)

Sidhu

Posted in Oracle General | 7 Comments »

Oracle 11g…

Posted by Sidhu on 13th August 2007

The day when Oracle 11g was made available for download on OTN, there was sort of, flood of posts in the Oracle blogsphere. Here is a quick recap of few of the posts (Whatsoever I could find through OraNA and my Netvibes)

Eddie Awad about 11g, I think he was the first one to post

Then Doug Burns here

Howard on installing 11g

Another interesting article from Howard

Tim Hall about 11g

Tim Hall on installing 11g

Then Laurent

An article on ADR by Virag Sharma on his blog

Jaffar about Active Standby database

A 11g PL/SQL article on AMIS blog

Well, if you don’t want to get into any hassles and just want to download Oracle 11g, you can get it here. (As of now its available for Linux x86 only).

Sidhu

Posted in Oracle General | 1 Comment »