Amardeep Sidhu's Tech blog

I was just wondering what kind of maintenance OTN forums are undergoing ? It is 2nd day today and still not available. I checked it yesterday morning and now today morning still under maintenance. Is another new design on the way ? ;) What you say ! Just noticed that there is an announcement about the maintenance in Community Feedback forum. Due to maintenance, forums.oracle.com will be in read-only mode between 6pm PT, Aug. 8 and 6pm PT, Aug 10. Search will still be available during that time. ...

Last week i had a chance to conduct my life’s first interview. The guy was a DBA with 2 years of experience and it was supposed to be a telephonic call. I checked out his CV and wrote down around 8 questions on a paper, just to make sure that i myself don’t get confused during the interview ;) . So i called him in the evening and started with introduction and his present job profile. Then i started with the questions from the projects he had done. He was confident about the stuff he was handling and replied all the questions honestly, saying NO at points where he didn’t know or was not involved in something. One of such thing was testing the backups. He said there is no testing done as such. ...

I don’t know a bit about Apache HTTP server but faced one issue in office…so thought about writing it here ;) We are having a 3 tier setup where Oracle Application Server 10g was there on AIX 5.3. It runs Apache HTTP server and we needed to access the files outside DocumentRoot. A bit of googling revealed that we could use Alias for that. Basically we need to add the following small piece of text to httpd.conf file: ...

Our application (3 tier, Front end Forms10g and back end 10gR2) provides user with a front end to refresh the mviews. That form has 2 columns showing mview name and the comment against it. Recently i saw that while opening this front end ORA-01403 NO DATA FOUND was being raised. I opened the fmb and found that it was populating comments from DBA_TAB_COMMENTS. In 10g the comments against mviews are stored in DBA_MVIEW_COMMENTS unlike till 9i where it was in ALL_TAB_COMMENTS. So there was a little modification required. ...

Just upgraded my blog to Wordpress 2.6. There are few new things. This video from Wordpress summarizes the new stuff:

Aman made me aware about not being able to post any comments on my blog. I checked and found that everything was fine with Firefox but in IE 6 it was not possible to post a comment. I was using Did You Pass Math plugin to stop comment spam and it had some problems in IE. I disabled it for the time being and installed WP-SpamFree. Everything seems to be fine except that it doesn’t allow very small comments and i haven’t been able to figure out where that setting is ? (yea…i am really poor with this web stuff :( ). ...

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. ...

I just opened OTN forums and found: High availability live ;)

author: Sidhu category: oracle-general guid: http://amardeepsidhu.com/blog/?p=79 tag: database title: A database - one tablespace & one datafile url: /blog/a-database-one-tablespace-one-datafile/ 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? ...

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. ...