992419 wrote:Read and practice and keep track of your practice in a file for your need.
Hi Experts, I am very new to Oracle Forms and PL/SQL. I have been doing development in Forms (mostly in 10g but I also in 6i) and PL/SQL for little over 2 years.
My problem is, I don't know much about how to progress up the ladder to be an Oracle Forms & PL/SQL expert.
My other big problem is trying to find out how to keep pace with the latest development in Forms and PL/SQL.
For example, my manager asked me how to print a file in a client printer. I could not give him a solution at once. Only after couple of hours of searching did I find the solution using WebUtil.Not really that. If someone follow my first advice.. and he/she needs any topic common in his practice, it's easy to give answer and solution. But if you don't know exactly, you can post here, search on the web.
Another instance a manger asked me how to encrypt data in Oracle forms. Again I had to do an extensive search on the web.
Can an "expert" give a solution at once, without going to the web?
Another time I was asked to do a performance tuning and could not do it since I have not done before. I tried to follow the method found in this site using a personal DB in my machine but could not simulate a situation.I read this forum answered problem and solution and if i think important i keep track in my file.
How do you keep track of latest developments?
Are their any sites to go to?
Is there a routine you can follow?
Do you have to do R&D regularly? How often?
How many hours of reading web-sites (on Forms, PL/SQL stuff) should you do for a week?base on free time.
How do YOU experts do it?One more thing, you know how to drive a car by reading books/manual. But you didn't drive not a single day ? Are you expert driver ?
Can an "expert" give a solution at once, without going to the web?Frankly I hardly know how to write a file using text_io or utl_file, or use some other somewhat regular-use supplied packages without looking them up in the documentation. Well I somehow know, but the code will most certainly throw compile errors. This is due to the fact that the entire oracle documentation is huge, and there are version dependend manuals, and I never liked memorizing things I could easily look up. It just doesn't make sense to memorize entire documentations when you can look them up. So even for basics I go to the web...
For example, my manager asked me how to print a file in a client printer. I could not give him a solution at once. Only after couple of hours of searching did I find the solution using WebUtil.So in the end you found a solution yourself didn't you?
Another instance a manger asked me how to encrypt data in Oracle forms. Again I had to do an extensive search on the web.I am around forms a few years, and I don't know an ad-hoc answer to that. I might have a clue, but for a advice I'd have to try and most certainly consult google.
Another time I was asked to do a performance tuning and could not do it since I have not done before. I tried to follow the method found in this site using a personal DB in my machine but could not simulate a situation.And you know at least where to start now even if you didn't solve the problem, don't you?
992419 wrote:Well, describe the problem, maybe someone here will recognize a situation and be able to help you out.
Thank you all for the replies. Appreciate it.
I am really interested in getting into performance tuning.
I was assigned a performance tuning task. However, we had no access to the live DB which had the actual problem. So, I tried got the table structures and put data and try to simulate the situation in a DB in my machine, but couldn't.If they don't give you access to the live system then they might be willing to give you trace files and query plans of bad performing SQL statements? If you can identify the bad performing SQL Statements you could request a SQL Testcase using dbms_sqldiag which bascially analyzes the dependend objects of your query and exports them via datapump. You then could go ahead, import it in another database and see if you can tune your querys.