Another Example of Asking Too Much

In this case, asking just about everything.

What is the appropriate response to a forum question such as:

What are the backup strategies of ur org?
1. How you recover when one datafile of system tablespace is corrupted.
2. How to clone the database.
3. Tell me About rollforward and rollback.
4. Which command is used in linux to change the owner of the file.
5. To see the process which is running, which command you use in linux.
6. About LMT is 9i concept and DMT is 8i concept.
7. From where you find which datafiles are corrupted and how do you recover.
8. How you spread your datafiles in 4 layouts(4 different disks).
9. Command to resize the datafile.
10. If you add one datafile by mistaken, how you drop that datafile.
11. How you connect with the database as a sysdba with out listener.
12. What is the easiest way to get the execution plain.
13. Syntax for Expain plain.
14. About pga_aggregate_target.
15. What are the diagnostic tools and about statspack(its level)
Recovery cinerio if data file is lost without a backup how u recover.
What sort of tuning have u done.
I took a clod back up at mid night 12.00 the data base is running in archive log mode, I created a new table space at morning 7.00 am the data base crashed at 9.00 am can I reover the data base
Ans : no
There is a user schema which is 8GB in size I need to export it to a disc that has 2 GB of free space.

Q1.What is your database size?
Q2.What is your RMAN size?
Q3. What is your sga component size? like db_cache_size, sga_max_size & shared_pool_size
Q4.How much memory is required to use RMAN, oracle suggest?
Q5.What will happen if archive log is full?
Q6.How do u connect your remote database?
Q7.What is your hard disk size?
Q8.What are the optimizers available?
Q9.How do u find the table size?
Q10.How to u find out how many sessions are connected?
Q11.Which view helps you to get the instance information?
Q12.How do u get the datafile is auto extend or not?
Q13.How do u get the tablespace contents is temporary / permanent?
Q14.Contents column of dba_tablespace
Q15.How to get the temporary tablespace temp file information?
Q16.What is the use of index and its contents?
Q17.When will we use the temporary segment?
Q18.Shall we create the temporary segment?
Q19. What is the use of undotablespace?
Q20. What is the diff between temporary and permanent tablespace?
Q21. Shall we move the permanent to temporary tablespace?
Q22. Today, we have a well tunned query running daily usually will take 10minutes, after 10 days user telling its still running for the past 40 minutes? what is the problem? how to tune the statement?
Hint: PGA
Q23. How to increase the db_cache_size? what are the steps to follow?
Q24. We have a two online redo log file? our database is closed. one redo log file is corrupted? when we start next time, we will get redo log file is corrupted? how to recover?
Q25. RMAN architecture?
Q26. What is start scn or stop scn?
Q27. Where will u get the scn number?
Q28. What are the types of point in time recovery?
Q29. I have a yesterday backup, but today time is 1am. I want to put the database around 10am. u should not issue time, scn to recover the database?
Q30. which parameter is used to specify the size of buffer in exp utility?
Q31. How to add a datafile to tablespace?
Q32. What is the difference between cold backup & hot backup?
Q33. Shall we take a cold backup in rman?
Q34. What is the difference between rman and hot backup?
Q35. How to manually defragment the tablespace?
Q36. What is logical and physical structure of database?
Q37. What is pga?
Q38. What is sga?
Q39. Why the log switch is more, when we do the hot backup?
Q40. What will happen, when we issue the begin backup?
Q41. When datafile will synchronize? checkpoint
Q42. Where checkpoint information to be stored?
Q43. What is scn?
Q44. What will happen internally when we are collecting statics?
Q45. How do u check instance is running or not in unix?
Q46. How do u check the status of hot backup? and what stage is it?
Q47. What is the use of awk command?
Q48. Do u know shell scripting?
Q49. How to create a dataguard?
Q50. What are the advantages of dataguard?
Q51. How to find out the cpu usage?
Q52. How to find out the rman size in unix?
Q53. How long ur backup runs?
Q54. What are the parameters u are using to export?
Q55. How do u check oracle utility is fine or not?
Q56. Suppose yesterday, u took a cold backup? today morning u added a tablespace and ur database is running in archive log?
Q57. Which optimizer is best? how choose based optimizer works?
Q58. Is it possible to force the select statement to use index.
Q59. What are the features of oracle 9i?
Q60. What is undo_suppress parameter?
Q61. What is ora-01555 error? how can we avoid?

Performance Tuning Questions:

When Temporary tablespace is going to be used? Means which types of sort.
How will you tune the sql query?
How to create controlfile when all control files are lost?
What is difference between RMAN & USER MANAGED Backup?
What is going on while Hot backup is going on?
How to create user in UNIX?
What is difference between LOCK & LATCH?
What is Latch? What types of latch are there in oracle?
What is shared pool? Database buffer cache? When will you tune shared pool?
What is UGA? What is it use ? where is it in dedicated server and shared server?
What is PGA?
What is Large pool? What is it’s use when it is configured? Which parameter is used to configure it?
Which utility are u using in
What is dead locks, primary and stand by database
*How do u design the Data base.
*batch updates
*backup scenarios

I’m sure I don’t know. I wonder whether this is a list of questions submitted to a job candidate? My favourite question is number 48. Oh wait, 57 is pretty good as well. You know, it really does help to read and think about every question in order to grasp the enormity of the posting.

I’m am absolutely stunned by this.


21 thoughts on “Another Example of Asking Too Much

  1. >> How did you manage to read until Q57 anyway?

    Oh, they’re well worth reading. Not just for the WTF factor but also because it is sometimes worth thinking about the individual questions: “Is it possible to force the select statement to use index.” … that’s worth thinking about and you’ll get different opinions from different people. It’s worth considering why that is (IMHO because optimizer hints and their effect on the CBO are not documented well enough). So there’s the occasional thought-provoking gem in there, if you can get over the enormity of the scope that a complete answer to the question would have to cover.

  2. “*How do u design the Data base.”

    this one is just the best! :-)
    I can think of enough material right there for a reply of a few hours if not a few days.

    “What is difference between LOCK & LATCH?”
    this one is getting soooooo old…

    Others are just plain bad English:
    “Why the log switch is more, when we do the hot backup?”

  3. I took a clod back up at mid night 12.00 the data base is running in archive log mode, I created a new table space at morning 7.00 am the data base crashed at 9.00 am can I reover the data base
    Ans : no

    Clod, indeed.

  4. Pingback: Other people’s problems are great « Viral Publishing

  5. Late reply I know, but I like (just before Q1): I took a clod back up…. Maybe that’s where it all started going pear shaped. And when he talks about Expain plain it seems clear to me that he’s got the L in the wrong place and really wants you to Explain pain.


  6. Pingback: Other people’s problems are great « OraStory

  7. It depends. Do you want the size of the data in it? (Hey, look at the size of schema exports or google for scripts). Do you need to account for all backups and standbys? (You’d better if you are buying disks). How about rate of increase? Do you just need to know the data file sizes? (Just use OS utilities like dir or ls) Do you need to know how much room is taken within data files?

    So many questions from one simple question!

  8. SQL> select OPTIMIZER_MODE from v$sqlarea where cpu_time=(select max(cpu_time) from v$sqlarea);


    Might be because of this… errupted the Q.57

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s