Coskan’s Approach to Oracle

April 30, 2009

What I learned from AOT by Tanel Poder

Filed under: Basics, Blogroll, Diary, Performance — coskan @ 8:28 pm

Guys who personally knows me, knows also that I am a very big fan of Tanel Poder and his work. I have been following him, since he started blogging in 2007 and after reading all his stuff,  at UKOUG 2008 Conference I found chance to have his masterclass about Advanced Oracle Troubleshooting. When I saw how he uses the things he wrote on his blog, all my approach to troubleshooting oracle had changed, but something was still missing. Blog and masterclass session wasn’t enough for me, I wanted more and more everytime I read a post from him. God must have heard my wishes and sent him to Edinburgh for his Advance Oracle Troubleshooting seminar and gave me the chance to fill the missing part.

After nearly 8 Oracle trainings ( 3 of them were celebrity seminars), I can personally say, If you love Oracle, if you love performance tuning and troubleshooting, if you look for a method to troubleshoot, if you want to learn something systematic and also practical   this is the best one you can attend to find what you are looking for. What makes this training unique is not just his methodology and knowledge, it is also his instructing skills. I don’t really enjoy sessions of  the instructors who are strict about their agenda and who don’t allow questions before they finish the topic but Tanel was always open to questions and I think he is aware that off-topic questions can lead to cover an upcoming topic too, so he doesn’t say, “I will see it next chapters” (which might not be covered because of the time limit. ) he answers them all. I asked as many questions as I can and none of them were remained without an answer not just by talk also by proof. Maybe he couldn’t finish all the chapters totally, but he nearly covered all in the middle of other chapters, by allowing questions. To get more benefit from this training, I strongly recommend you to read all the posts on his blog and try them before you come. Believe me you will focus more and benefit as much as I did. One more confession is that this one was the only training I never lost concentration 🙂

After all this voluntarily marketing, let me tell you tiny bits about what I learned from this young (it was a big shock to hear his IT experience is nearly 18 years at my age I think thats why Jonathan Lewis said that he saw his youth on him 🙂 ), %100 geek and genius evangelist.

*If the session state is WAITING it means waiting, otherwise no matter what is written on state column of v$session it is on the CPU as simple as this. (sw script)

*On ideal world, if the session is running, session stats (snapper script) will show you some increasing stats

* For short intervals of snapping with snapper scripts DBTime and DB CPU might show non realistic values ideal is 5 and over I think, not less

*Oracle does not immediately put a line to an event trace, it does it when the call finishes.

* on solaris kill -STOP SPID suspends the process without killing it and you can resume it again by PRUN. check manual page for you operation system.

*using wireshark , snoop (solaris) tcpdump (linux) to check network related issues

*Oracle might lie about a process but OS wont. What OS says on process stack is always the most reliable one.

*sed.sql is the simple but life and time saver script to check the P1 P2 P3 value definitions of a wait event.

*procmon is a life saver tool for dodgy errors with “unknown error” message on Microsoft OS.

* on a dump trace file you can ignore function calls at the top of stack they are related with dumping process

* If you see sqlid sqltext but no plan for the running sql. dont get shocked there can be an ongoing hard parse.

* vmstat on unix/solaris sr which is scan rate column needs to be 0 for healthy monitoring

*on linux swappiness is an important memory setting which isnt referenced in online documents or metalink officially.

* good practice if you can take the dump of the process if you need to kill it. for finding the problem

*there is an hang analyze analyzer on EM. Never took my attention.

* v$wait_chain is similar with hang analyze dump but available after 11G

* Finding latch related problems are not a big issue any more after latchprof and latchprofx. Wont tell anything here everything is on his blog.

* root block is the next block after the block header. useful info for latch buffer cache chain issues. (might be leaf block on very tiny tables)

* quest spotlight has session _spin_count autotuner in it . (see Tanels comment below. )

*To drink more by Working less , you should be practical and script the things you use most in addition to his scripts

*there is a tool called trcsess which can be used to bring tracefiles together.

* he also say it is pointless to check statspack for something still going on.
I personally used statspack/awr only 3 times and one was at a job interview. Some stupid guy before doing rman online backup to 7/24 system, tried to test me what is wrong with that statspack report. Was totally crap.
To be honest Purely or initially statspack oriented problem solving is something like gues from your .ss type problem solving. Thanks Tanel for this term 🙂 And his perfsheet tool makes statspack more useful to check what has happened last week type problems on a graphical interface. Having your own ASH if you don’t have Diagnostic Pack is far more better than getting lost on system wide reports.

* If you cant sleep on the plane, sleep enough before the flight and fly during office hours and work during the flight. systematic approach from a man who flys nearly 2 times a week.

* if you are googling an about oracle internal functions put .ch or .ru  domains for some better results (yes you need google translate to understand the page)

*BEST ONE I asked him how do you learn all these interesting stuff. He gave me a perfect clue. Sign up for metalink headlines mailing list. Bugs docs they are all there after they are created. Perfect resource.

There are two things, I don’t agree with him, about his approach. First is , I want to see the sql first about a session I am troubleshooting. If I know the system this will give me a basic idea, it can also lead wrong way but still SQL is something worth to see before starting other steps.
Write one script run on all versions idea is another thing I am not very keen to follow. I prefer to have 3 different script home to benefit from new columns added to tables. The only thing I need to do is call the right home in a bat file before I connect.

These were just my tiny highlights, from a big training. If you need more just attend his class, you wont regret.

I heard that he will come to London for seminar possibly after UKOUG 2009. If I were you, I won’t miss it.

Thank you very much Tanel for sharing your knowledge with us. You are the rising sun over Oracle Performance World.

One special thanks is coming for Thomas C. Presslie from PISEC who was the organizator of this event. Venue, environment and all training package and his hospitality  was wonderfull. I wish I could come for the upcoming ones 😦


January 16, 2008

I am tagged, so lets continue. Here is my life

Filed under: Diary — coskan @ 11:31 pm

Tonguc who is a milestone for my Oracle career, tagged me in his blog. What I understand from tagging is, after you give 8 information about yourlife, you tag someone else but I won’t tag anyone because I am always the last stop of forwarding 🙂

Here are my secrets.

1- I was born in Turkey years ago. Nobody in my life related with IT and to be honest, I touched computer for the first time in University when I was 18. My childhood dream was to be a James Bond, but now I am a DBA with only one gadget named Oracle… Maybe it is the only magical gadget I should need to be James Bond 🙂

2- if I am not dealing with databases, My life is mostly in gym . If I have to make a choice I should choose to go gym. I am addicted to endorphine and gym makes me secrete endorphine more than the databases make.

3- I am the fan of Galatasaray the only football team of Turkey which is known by real success, not by transfers:)

4- I moved to London this year and I think I will live here forever. Yes, I love dark weather.

5- I will engage with my girlfriend on this Saturday. Sometimes you have to disable your firewall against marriage 🙂 My old release Coskan_28_m will be replaced by Coskan_28_m_m (male_married) in first quarter of 2008.

6- I still cannot use English effectively , but as you see, this is not secret, it is just a confess to myself:) Anyway, I could not write in Turkish too. None of my teachers gave good grade to my essays :(((.

I dream a world on which only demonstrations talks on blogs 🙂

7- I was an ex fan of Definitive Oracle Guru till 2006 the year that I started to test what I read.

8- Sometimes I think to sell my non-existent ferrari, but I think, first I have to be a monk and after that get permission from my future wife to go Tailand for education. (I started to think like a married man I think I am ready 🙂 )

Thank you for following this blog. It is nice to be read by people around the world. I was’t expecting over 50000 hit in one year but I reached despite my English 🙂 I hope you you get something from this blog.

August 22, 2007

Internship Diaries from a newbie

Filed under: Diary — coskan @ 4:07 pm

GSM Giant Turkcell has a  very nice internship program about Oracle. Hasan Tonguc, who is working very hard to widen True Oracle Usage  in Turkey, is leading to this program. Hasan and his collegues prepare a schedule and teach Oracle to the newbies in both theorical and practical way. One of the interns,  Bilal Hatipoglu shares  his experiences about this internship in his own blog (in Turkish) . After digging his blog,  I started to think to go back his ages and try to participate  this internship program.  If I had a chance to learn Oracle that much at the beginning of my twenties, I might be nominated for ACE award now.  Bilal’s blog is a fruit of real internship and I wish every student has a chance to participate this kind of fully utilized internships.  Thanks Hasan and his friends for teaching Oracle to newbies , encouraging them to share what they learn and I wish good luck to Bilal  in his professional life.

July 27, 2007

UK will be my new home

Filed under: Diary — coskan @ 10:38 am

 I was thinking of going , living and working in UK, since 1992 .  Yesterday, I got the news of having HSMP Visa approved and my childhood dream became true. It will be very hard for me to change my whole life, but  I need a fresh start after 28 years. I will be in UK in October and I hope I can get used to UK daily and business life asap.  I did not find any employer yet, nevertheless I hope to find one before I go to UK.  I will quit my recent job in September and I wish Oracle 11g will be available before  September and I can try the new features of 11g and share my experiences with you for one month.

July 11, 2007

Oracle 11g is launched

Filed under: Diary — coskan @ 4:47 pm

I watched the launch of Oracle New release 11g 20 minutes ago. I couldn’t catch all of the presentations, but I caught some highlights about what Oracle 11g promises us.

1- Partitioning advisor: Oracle 11g will give us advises for partitioning tables on which column and what type of partitioning.

2- Automated partitioning: You will not have to worry about the creating new partitions for upcoming dates . Oracle 11g will do it or you.

3- Business driven partitioning: Oracle 11g enlarge the composite partition capabilities. Prior to 11g we can only do hash over range partitioning or list over range partitioning. Now we have 3 more composite partitioning options.

  1. Range over range partitioning
  2. range over list partitioning
  3. list over list partitioning

4- Information Lifecycle Management (ILM): ILM will help you about management of your mature, less active data.
5- Advanced compression: By advanced compression we can compress our data up to 3X and this will ease our life about archiving our database

6- Rolling online upgrade with data guard: You will do your upgrade on your standby database then switchover to standby database and upgrade your primary database by this way Oracle 11g can promise us no downtime for upgrading process. From now on, you do not need to have a RAC database to make online upgrades, what you only need is to have a standby database which is according to me a must for high availability . (If you don’t have yet start to Think more to have a standby database).

7- Real application testing: if it work as it said to be, I think this feature is a revolution for testing. You capture the workload from your database and apply it to your test environment which is replicated from your database. Think about how much time you save when this happens (minimum test environment preparation time and minimum testing duration minimum effort for creating stress scenarios)

I saw so many enhancements about spatial and streams which are not my main topics, but I hear that the guest CIO s, told how much they liked those features.

you can find more about Oracle 11g from official site

I cross my fingers and start to wait to download the new release for trying new features.

July 4, 2007

Database users vs Database Admins

Filed under: Diary — coskan @ 7:31 am

Today I read the great, funny post of

  1. Database users are just like women, they will always want more.
    (I am not a misogynist, do not hate me, I never met a woman who doesn’t want more 🙂 )
  2. If you ever run a sql 100 times and 99 of them lasts only 1 second and only one of them lasts 5 minutes, then they would nevertheless come up with the idea that the database is slow. They will never look at the bright side 😦 When they experience any slowness for just only one time, it would be very hard for you to erase this experience from their minds.
  3. This is the reality of DBA business. Do not get angry to the “others”, do what Jeff did (Say them “I need to get back to my office, call me if you have any problems.” :)) )

June 15, 2007

Log Buffer #49: a Carnival of the Vanities for DBAs

Filed under: Diary — coskan @ 11:16 am

Here comes the 49th edition of Log Buffer. Thanks to Dave Edwards from Pythian Group for giving this nice opportunity. I hope I won’t let him and the readers down with this post 🙂

I want to categorize the entries with vendors for helping the readers to focus on their interests. To be honest I can’t find enough time to follow non-oracle blogs so I must thank again to Dave for sending me the non-oracle blog links of this week.

Lets start the Carnival with Oracle Blog entries captured by my RSS feed reader, Sage.

Lewis Cunningham (Oracle ACE) listed his mini-tip series on his Mini-tip Aggregate List entry. These tips are very helpful for both developers and DBAs.

Writers of Eye on Oracle blog community wrote very interesting entries about Oracle world. Tim DiChiara asked a provoking question “Is Database administration for suckers ? In my opinion being DBA is for the ones who really loves to devote himself to database technologies. Please don’t forget to read the comments of this post, I bet you will enjoy them. Another Eye on Oracle writer Mark Brunelli summarized the thoughts of other bloggers about upcoming Oracle release 11g. Read them to be ready, when your boss ask “tell me my dba what does 11g promise us”. Believe me they will ask :)) . Finally Elisa Gabbert wrote about some headlines from Oracle blogosphere agenda.

about truncating partitions. Data geek Beth continued to her data quality posting series with Standardizing Product Attributes post.

Alejandro Vargas , One of my favorite technical Oracle Bloggers, who has no story but so much technical useful information on his blog, wrote Production Upgrade from to guide for the ones who still find it risky to upgrade their 8i servers. Atul Kumar who totally deserves his ACE title by guiding the application DBA’s , started his Oracle SOA Suite Installation Series with database installation part. Another Oracle ACE Syed Jaffar Hussain mentioned the importance of creating password file to solve ORA-16191 Error for Standby Databases.

Dominic Brooks wrote about his approach to use Thomas Kytes famous runstats (try it I am sure that you wont leave it) script for performance tuning. Alex Gorbachev wrote about what will happen when you leave database in backup mode with a real story. Another stylish DBA of Pythian Group Christo Kutrovsky wrote about his experience as a Beta Tester of Oracle 11G . Jeremy Schneider wrote about Monitoring Oracle on NFS again with an excellent article. Kevin Closson responded to the previous Log Buffer #48 entry by Powel Barut about his Oracle over NFS approach and asserted that it is not so weird according to his I/O performance estimations while admitting the current superior performance of the FCP.

Top notch PL/SQL guru of the Oracle World, Steven Feuerstein continued his Queusiful (Quick and Useful tip on how to write programs in the Oracle PL/SQL language more effectively) series on his another blog at TOAD World community with Quseful #3: Don’t put COMMIT; in your code! post. Hampus Linden wrote about reclaiming Lob spaces by alter table shrink command. Mennan Tekbir’s
new post about shortest path algorithm demonstration on Oracle interesting is worthy to read for planning your trips 🙂 .

Last advice about Oracle is not a blog entry, but it is colloquy with author of Oracle Hackers Handbook David Litchfield. He claims that SQL Server 2005 is more secure than Oracle.

Lets talk about what was written about IBM DB2 this week;

Craig Mullins told about tips of managing performance tuning on DB2 applications. Sheryl Larsen also wrote Extreme SQL Performance Techniques for DB2 on DB2 Magazine. On DB2 News & Tips blog I came into an entry which guides, where to find information about new DB2 releases.

MSSQL’s upcoming new release SQL Server 2008 with code name Katmai was the main topic of the MSSQL Server bloggers. Rafik Robeal wrote about Katmai’s strength for building offline applications. SQL Server MVP Brian Knight wrote his favorite BI features of Katmai . I think war on BI market will be escalated next year.

Jeff Smith explained, how to use group by statement to avoid self joins, by clear examples . It would be very useful if I should have learned this trick when I was a SQL Server DBA. MS SQL Master wrote about how to view backup and restore performance info and how to get blockers info from dynamic management views (DMV) of SQL Server 2005. Curt Monash wrote about how you can use MSSQL Server 2005 behind a Massively MultiPlayer Role-Playing Game .

MySQL bloggers were very fruitful this week. It was very hard to choose between them because of my unfamiliarity with MySQL technology, but thanks to my colleague Orhan Biyiklioglu who helped me in the decision process. It seems that the MySQL blogosphere was mostly busy with the The 12 Days of Scaleout campaign of the MySQL AB as pointed out by Zak Greant. Ronald Bradford summarized some of the tips he found useful about Wikipedia’s use of MySQL replication to scale-out their database infrastructure on his article MySQL – Wikipedia. Giuseppe Maxia has provided a tip on using MySQL 5.1 Beta on production systems to benefit from its new Partitioning features without risking your data. Peter Zaitsev’s article explaining the problems about using stored procedures in MySQL is very noteworthy. MySQL guys should think twice before using them. MySQL Cluster SQL Tips by Brian Moon seems also to be useful for using joins on a MySQL cluster. Xaprb published a fast, three part, series on Archive strategies for OLTP servers. 1, 2, 3 well worth a reading by the serious MySQL guys.

Chris Brown wrote about how much he likes the HA option on Sybase Adaptive Server Enterprise edition. Despite all his wishes for not to write a marketing related post, he wrote marketing related and he accepted that he wrote 🙂 Fernando Nunes showed how to create multiple triggers on the same table for the same event on IBM Informix.

Peter K wrote his thoughts with a great post, about IT businesses never ending debate “Are Job Interviews and resumes useful or not ?

I think it is a little long, I hope you did not get bored. It was a great pleasure for me to feel like an editor of all blogs 🙂 . I finished my turn and start to wait for the 50th edition of Log buffer on 22th of June.

April 19, 2007

Io Exception: the network adapter could not establish the connection (Enterprise Manager)

Filed under: Diary, Tips — coskan @ 12:31 pm

Yesterday I gave my decision to upgrade my 10G OCA certificate to OCP. For preperation I need an EE or PE 10G database and I have two database installed (XE and EE (SID= ORACOS) )on my Windows XP Pro Machine. The installation order was first XE next EE and after installation I configured the listener of with another port rather than 1521 because of the port conflicts. Moreover I configure the listener start from the XE home and I didn’t configure EM for database from the installation till today.

When I need EE what i did is firts I changed the ORACLE_HOME to home from XE home and I changed the ORACLE_SID to ORACOS then I started EM with

>emctl start

Enterprise manager started but when I went to EM page database status was unavailable and needs recovery.

I said recover database and this button took me the host and database credential entry page. I gave local administrator for host and sys for database unfortunately I took the error “RemoteOperationException: ERROR: Wrong password for user”. I changed the password for the local administrator bu nothing has changed after googling I found a solution at an orafaq forum thread . The solution is below and worked well and took me to the next trouble 🙂
Solution for “RemoteOperationException: ERROR: Wrong password for user” error :

If you are on windows: Go to Control Panel–>Administrative Tools–>Local Security Policy–>Local Policies–>User Rights Assignment–>U will see in the policy as “Log on as a batch Job–>right click–>Properties–>add user or groups–>give your OS username.

The next trouble was Io exception: The Network Adapter could not establish the connection”

I checked the listener_oracos it was working well. For a try I restarted both dbconsole and listener but the error was there again. What could be the problem ?

Here comes the solution from the survivor Metalink. Note:273758.1 . The problem is that I did a default installation for database and made changes to default listener configuration but I did not reflect it to other hard coded configuration files such as enterprise manager config files.

To solve the problem I change the default entries (oracle_listener,Port,LsnrName,ListenerOraDir ) on the file ORACLE_HOME/hostname_sid/sysman/emd/targets.xml and port entries for the parameter oracle.sysman.eml.mntr.emdRepPort, oracle.sysman.eml.mntr.emdRepConnectDescriptor on the file ORACLE_HOME/hostname_sid/sysman/config/

and restart the dbconsole. Guess what happened ? I started to sing the song “Yesterday All my troubles seems so far away …..”

Moral of the story; If you make a configuration change, reflect the change to all of the files related with your change.

Now it is time to prepare for OCP exam. I hope In 2-3 weeks time i will take the exam and will write the interesting OCP topics here.

April 17, 2007

Who is an Invalid DBA ?

Filed under: Diary — coskan @ 10:16 am

When i got errors from database and complaining about “what happened again” my colleagues start joking and saying “Coskan got Invalid DBA exception” :).

I googled internet and found no entry about term “Invalid DBA” so I want to explain what it is.

Lets look at who can be called Invalid DBA in my point of view;

  • Invalid DBA’s are the ones who don’t like to read Concepts guide of the RDBMS they work on. (DBA job Kick off must be always concepts guide because it is the big picture. Without seeing the whole you can’t focus on parts)
  • Invalid DBA’s are the ones who don’t have a good understanding on importance of Backup/Recovery. (If you don’t backup you can’t recover this is as simple as this)
  • Invalid DBA’s are the ones who don’t have test databases. (the ones who try on production server first.) Once one of Oracle Educators told us a story about a DBA who tried block corruption examples of training material on production database ….
  • Invalid DBA’s are the ones who say “I know OS , I can watch monitors of EM or QUEST and I can write shell scripts I dont need deep knowledge about SQL”. Without SQL knowledge you are system admin, not database admin please do not call yourself a DBA. Tuning SQL starts with writing SQL.
  • Invalid DBA’s are the ones who advice buying cpu instead of investigating bottlenecks.
  • Invalid DBA’s are the ones who are still using ratio-based methodology instead of oracle wait interface for performance optimization. (Oracle special, invalid dba exception)
  • Invalid DBA’s are the ones who say “I am behind the firewall i do not need to focus on security”. (Firewalls are good but history of world is full with conquered iron castles)
  • Invalid DBA’s are the ones who don’t have a maintenance routine for their databases. (If you take you car to service after some miles then you have to do the same for your database too. This is a must)
  • Invalid DBA’s are the ones who don’t care, about business needs or what is the business of the company. I don’t mean know it as much as the core developers know, but knowing the big picture takes you one step further for the bottlenecks.
  • Invalid DBA’s don’t like asking questions to their senior DBA’s. (Don’t forget there is always possibility of a shortest path. If there is a senior DBA in your organization feel free to consult him. This can avoid reinventing the wheel.)
  • Invalid DBA’s are the ones who always ask everything instead of reading. Is this a confliction with the above one ? No 🙂 First you must RTFM then metalink/msdn then google and then ask.
  • Invalid DBA’s are the ones who don’t try what he learns. Guru’s can write something but it doesn’t mean it is true even the guru’s name is Thomas Kyte or Jonathan Lewis. Don’t forget! every book has an errata and every release can behave different.
  • Invalid DBA’s are the ones who put commit before running the command. Think about the wrong or forgotten where clause.
  • Invalid DBA’s are the ones who are not nerveless. Don’t forget, In a crisis environment the only thing you can lose is your job and you can always find another one, so you don’t have to worry as much as you managers. They are worried because they can’t find a new position as high as recent one after an inconsistent recovery which caused loss of millions. Stay calm.
  • Invalid DBA’s are the ones who refuse to read new features guide. Time changes and developers try to work for the better. Keep yourself up-to-date for saving time.
  • Special Invalid DBA award comes for the ones who does not read installation guides before installing. (My early career is full with this award 🙂 )

I can not cover all but Mr Chris Foot (Oracle ACE ) has a good series about The Non-Technical Art of Being a Successful DBA . I suggest you to take a look at what he says, maybe the opposite of his thoughts can lead you about how can an Invalid DBA be :).

The Non-Technical Art of Being a Successful DBA

The Non-Technical Art of Being a Successful DBA – Database Recovery Best Practices

The Non-Technical Art of Being a Successful DBA – Application Change Management Best Practices

The Non-Technical Art of Being a Successful DBA – Application Change Management Best Practices

The Non-Technical Art of Being a Successful DBA Continues

The Non-Technical Art of Being a Successful DBA – Paranoid DBA Best Practices

The Non-Technical Art of Being a Successful DBA – A Preview of Future Blogs

The Non-Technical Art of Being a Successful DBA – Third Party Product Evaluations

The Non-Technical Art of Being a Successful DBA – Obtaining the Most Benefit From Oracle Training

The Non-Technical Art of Being a Successful DBA – Excelling at Verbal and Written Communications

One more recommended reading and editing is Oracle Best and Worst practices wikipedia prepared by Eddie Awad

April 5, 2007

Questions to a new graduate (Are you ready to be a DBA)

Filed under: Diary — coskan @ 11:11 am

There are always questions in mail group threads from new graduates, like why should I choose to be DBA? or tell my about pros/cons of DBA job. I asked them the questions below and say them If you have a little hesitation on any of these questions be something else rather than DBA . Here are the questions that must be answered with Yes to give decision to be a DBA.

1- would you like to work when all of the others are on holiday ? (because of SLA’s you can do maintenance only on national holiday times mostly)

2-Would you like to wake up at 4 AM with the voice of the operator who says there is something wrong in the DB ? (no matter when you left the building for going home if you must be called then you will be called). Believe me there will always be  something wrong with the DB because database is not an install and forget system.

3- Are you calm enough to work under pressure?? This stress is not like every pressure it is the pressure comes from the distress of a man (usually your boss or his representative) who is loosing a lot money every second because of a DB fault. They can look like a monster in that crisis times.

4- Do you like to work when there are many people especially the boss or general manager (with telephone listening the boss) and his/her flatterers looking at your screen and asking when will it recover or when will the problem be solved ? For example in crisis times when you are a unix admin you will work with you primary manager, when you are a network engineer you will work with your colleagues, when you are a developer you will work with your project leader but if it is something about DB you will work in front of the ones who has great balls.

5- Are you ready not to get  of reading ?? Every oracle release has over 10 thousands of pages official documents and zillion articles and as a bad news Oracle announce new releases almost every 3 years.

6- Do you like overtimes ? Due to the fact that DB is at the center of everything (network, system, application etc) many times you will stay at office even if there is someone working on something. If there is a network work you should stay if there is a unix work you should stay if there is an update you should stay because every work can effect the DB.

7 – Would you see the database as a lover or more than a lover? DB is something like a lover or a kid. You have to show your interest every time and look after DB in 7/24 time period. Your lover or kid may thank you with a kiss or hug for your effort but DB wont 🙂 This love and interest to DB is something like unrequited love.

8- Are you ready to stay calm over against meaningless requests of a developer who has a black box approach to DB and who believes that he is only responsible for writing code not performance ? (I want to kill the ones who wrote that is independent from DB pufffffffffff)

9- Are you careful enough?. You will play with real data and it is very easy to drop a database just like the 2 word command “drop database”. A simple where clause could change everything.

10-Are you ready to be blamed every time ? No matter what the problem is you will always be blamed first. Everyone will calumniate the DB and its Administrator because it is at the center of everything.

Again if you have hesitation to answer YES to any of these questions don’t think be a DBA . Be something else because this is the DBA’s life.

Will it worthy enough to stand all those?? I don’t know but i am happy to be an Oracle DBA.

« Newer PostsOlder Posts »

Blog at