Thursday, July 8, 2021

10 Resume Writing Tips To Help You Land a Job

 Employers use resumes throughout the hiring process to learn more about applicants and whether they might be a good fit. Your resume should be easy to read—summarise your accomplishments and skills and highlight relevant experience.

While there are a few commonly used resume styles, your resume should reflect your unique education, experience and relevant skills. You might consider having multiple versions of your resume tailored to the jobs you’re applying for. Here are a few key resume writing tips that will help you organise and design your resume. Below are 10 tips to help you write a great resume.

1. Look for keywords in the job postings

The best place to start when preparing to write a resume is to carefully read the job postings that interest you. As you apply for different jobs, you should study each job description for keywords that show what the employer is looking for in an ideal candidate. Include those keywords in your resume where relevant.

For example, if you’re applying for a job as a Medical Billing Coder, an employer might list keywords such as “coding,” “claims submission,” “compliance” or “AR management” in the job description. Pay particular attention to anything listed in the sections labelled “Requirements” or “Qualifications”. If you have the skills that employers are looking for, you can add these same terms to your resume in the experience or skills sections.

2. Review resume examples for your industry

When creating your resume, you could study examples of resumes from your industry for inspiration and best practices. While there are many ways you can use resume samples, there are three main takeaways you should look for:

  • Make it simple and easy to read. Resume samples are simple and straightforward. This is because employers have a minimal amount of time to review your resume, so readability is key. This also means selecting a professional, clean font.

  • Make it brief. You’ll notice that each section of the resume sample is short and to-the-point, including the summary and experience descriptions. Including only the most key and relevant information means employers are able to consume more information about you and quickly understand your fitness for the role.

  • Include numbers. You might also notice that there are often metrics included in the experience section of resume samples. This is because employers are highly responsive to measurable proven value. Numbers allow them to better understand the value you may bring to the position. For example, one bullet point under the experience description for an administrative assistant reads, “Executed processing of vendor contracts and implemented a standardised process, reducing contract discrepancies by 90%.”

When using resume samples, you should keep in mind that these are not meant to be copied exactly. While you should avoid using them as a template, samples are useful as examples of high quality resumes in your industry and job title.

3. Use a professional font

Because employers have only a short time to review your resume, it should be as clear and as easy to read as possible. You should use a basic, clean font like Arial or Times New Roman. Keep your font size between 10 and 12 points. Selecting a clear, readable font will help make your resume appear more professional.

You should also make sure that you reduce or eliminate any unnecessary white space. Too much blank space might make your resume seem sparse, distracting the audience and possibly raising a red flag. By reducing extra white space, you make it easier for the resume reader to focus only on the content of your resume instead of the white spaces. You can reduce white space by increasing your font size to 12 points and possibly adding an additional, optional section like “ Skills” or “Awards and Achievements”.

4. Include only the most relevant information and put the most important information first

While you might have extensive work or educational experience, it’s important to keep your resume as brief as possible without leaving out key information. Hiring managers don’t spend a lot of time reading each resume. Research has shown that hiring managers tend to spend only 6 seconds per resume. If your resume includes old or irrelevant information, such as jobs held over 10 years ago or minor degrees and achievements, it may distract from important information.

Try to include only work experience, achievements, education and skills most relevant to the employer. You can find the most relevant attributes by closely reading the job posting. You should prioritise important information higher on your resume to draw attention to key skills and achievements.

5. Use active language

Your resume should be written using active language without irrelevant words. This means using power words such as “achieved,” “earned,” “completed” or “accomplished”. If your resume is too long or seems hard to read, you should consider making sentences shorter or ideas more concise.

For example, you may have a job description that reads:

“During my time at Freedom Private Limited, I ran multiple team-based projects and helped each team member with various tasks associated with each project.”

This example could be shortened and strengthened in the following way:

“Led multiple team-based projects and effectively coordinated group tasks.”

The revised version communicates the same ideas about your accomplishments while reducing the number of words and including more active language.

6. Call attention to important achievements

Instead of listing your job duties under the experience section, select your top three or four most important achievements in each role you’ve held. Where possible, include numbers that measure your success for that particular goal or achievement.
You might also consider including a separate “Achievements” or “Skills” section to specifically highlight relevant achievements in your education, career, volunteer work or other experiences.

7. Only include subheadings and sections you need

Whether you’re using a resume template or creating your own, you may find there are some recommended sections you do not need.
For example, you may need a resume summary or a resume objective, but you should not include both. If you are just graduating from college or high school and have not yet held a professional position, do not include an empty work history section. Instead, you could replace the experience section with relevant coursework, academic achievements and other experiences like internships or extracurricular projects.

Related: Writing a Resume With No Experience

You may also find it useful to combine sections if you are having trouble filling a section with more than two bullet points.

8. Choose appropriate margins

Typically, you should use a one-inch margin size on all sides of your resume with single spaces between the lines. If you have too much white space, you might consider making your lines spaced by 1.15 or 1.5. You can also increase your margins if you find it is difficult to fill your resume but they should stay below two inches.

9. Proofread and edit

Before sending your resume, you should undergo several rounds of proofreading to ensure there are no spelling or grammar errors. While there are several proofreading programmes and tools you can use, it is also helpful to ask trusted friends or colleagues to review your resume. It is helpful for an objective third party to look at your resume as an employer might to find ways you can correct or improve it.

10. Decide whether you need a unique resume for different jobs

Before submitting any application, you should ask yourself, “Have I made it as easy as possible for this employer to see that I’m qualified?” If you’re applying for a job that has unique requirements, you may need another version of your resume to fully demonstrate your qualifications. Decide which resume to use on a case-by-case basis.

Your resume is often the first step to getting an interview with an employer. Make sure you include the most relevant information on your resume, organise it to highlight the most important information and carefully review for errors. Once your resume is polished and finalised, it should help you get more call backs, interviews and job offers.



https://in.indeed.com/career-advice/resumes-cover-letters/10-resume-writing-tips

Sunday, July 4, 2021

How I Create SQL Baseline to fix my EBS query with an Execution Plan | Performance

 I am sharing on creating SQL baseline and force query to use better execution plan (plan hash value). 

I was doing today so thought to share this scenario where the query which was running fine till yesterday now suddenly running long in my EBS instance. So very important  I check the plan for a particular sqlid. 

Note my DB version in 11.2.0.4

Query to check the multiple hash plans for sql id.

select
SQL_ID
, PLAN_HASH_VALUE
, sum(EXECUTIONS_DELTA) EXECUTIONS
, sum(ROWS_PROCESSED_DELTA) CROWS
, trunc(sum(CPU_TIME_DELTA)/1000000/60) CPU_MINS
, trunc(sum(ELAPSED_TIME_DELTA)/1000000/60)  ELA_MINS
from DBA_HIST_SQLSTAT
where SQL_ID in (
'6hxw283cyw0ub') --repalce sqlid with your sqlid
group by SQL_ID , PLAN_HASH_VALUE
order by SQL_ID, CPU_MINS

I find out the best execution plan (Plan_hash_value) and force the query to use that plan. Below are the steps I did to create and fix bad queries by creating SQL baseline.



STEP 1: GENERATE ALL PREVIOUS HISTORY RUN DETAILS OF SQL_ID FROM AWR 

break off sdate
set lines 2000
set linesize 2000
col SDATE format a10
col STIME format a10
select to_char(begin_interval_time,'YYYY/MM/DD') SDATE,to_char(begin_interval_time,'HH24:MI')  STIME,s.snap_id,
        sql_id, plan_hash_value PLAN,
        ROUND(elapsed_time_delta/1000000,2) ET_SECS,
        nvl(executions_delta,0) execs,
        ROUND((elapsed_time_delta/decode(executions_delta,null,1,0,1,executions_delta))/1000000,2) ET_PER_EXEC,
        ROUND((buffer_gets_delta/decode(executions_delta,null,1,0,1,executions_delta)), 2) avg_lio,
        ROUND((CPU_TIME_DELTA/decode(executions_delta,null,1,0,1,executions_delta))/1000, 2) avg_cpu_ms,
        ROUND((IOWAIT_DELTA/decode(executions_delta,null,1,0,1,executions_delta))/1000, 2) avg_iow_ms,
        ROUND((DISK_READS_DELTA/decode(executions_delta,null,1,0,1,executions_delta)), 2) avg_pio,
        ROWS_PROCESSED_DELTA num_rows
from DBA_HIST_SQLSTAT S,  DBA_HIST_SNAPSHOT SS
where s.sql_id = '&sql_id'
and ss.snap_id  =S.snap_id
and ss.instance_number = S.instance_number
order by sdate,stime;

Enter value for sql_id: 6hxw283cyw0ub



SDATE      STIME    SNAP_ID SQL_ID              PLAN    ET_SECS      EXECS ET_PER_EXEC    AVG_LIO AVG_CPU_MS AVG_IOW_MS    AVG_PIO   NUM_ROWS
---------- ----- ---------- ------------- ---------- ---------- ---------- ----------- ---------- ---------- ---------- ---------- ----------
2021/06/30 19:00      89668 6hxw283cyw0ub 1368916072          0          0           0          0          0          0          0          0
2021/06/30 19:00      89668 6hxw283cyw0ub   40732332     509.74          1      509.74  167517768  284054.61    4066.39     979242          0
2021/06/30 20:00      89669 6hxw283cyw0ub 1368916072          0          0           0          0          0          0          0          0
2021/06/30 20:00      89669 6hxw283cyw0ub   40732332     488.65          1      488.65  167171014  266845.92    7141.55     789809          0
2021/07/01 07:00      89680 6hxw283cyw0ub   40732332     508.51          1      508.51  165308543  265980.54    3566.88     726343          0
2021/07/01 07:00      89680 6hxw283cyw0ub 1368916072          0          0           0          0          0          0          0          0
2021/07/01 08:00      89681 6hxw283cyw0ub   40732332     936.17          2      468.09  165328375  257197.28    3183.58   726323.5          0
2021/07/01 08:00      89681 6hxw283cyw0ub 1368916072          0          0           0          0          0          0          0          0
2021/07/01 09:00      89682 6hxw283cyw0ub   40732332     558.38          1      558.38  165739035  269044.73    5430.59     733766          0
2021/07/01 09:00      89682 6hxw283cyw0ub 1368916072          0          0           0          0          0          0          0          0
2021/07/01 11:00      89684 6hxw283cyw0ub   40732332    1553.27          3      517.76  167407756  266781.05    4228.16  823571.33          0
2021/07/01 15:00      89688 6hxw283cyw0ub   95728747     120.19          1      120.19    3052872   31220.28   10460.06     969074       8738
2021/07/01 15:00      89688 6hxw283cyw0ub  587292616     1372.1          3      457.37 97773871.7  199067.35    1862.32 1019655.67          0


/*In this scenario sql_id=>6hxw283cyw0ub and plan_hash_value for good plan that we want to force is 95728747.*/
Follow below steps to create sql baseline for sql_id

STEP 2: DROP SQL TUNING SET (STS) IF EXISTS

BEGIN
  DBMS_SQLTUNE.DROP_SQLSET(
    sqlset_name > 'SQL_FOR_6hxw283cyw0ub');
END;

STEP 3: CREATE SQL TUNING SET 

BEGIN
  DBMS_SQLTUNE.create_sqlset (
    sqlset_name  > 'SQL_FOR_6hxw283cyw0ub',
    description  > 'SQL tuning set for 6hxw283cyw0ub');
END;
/

/* Populate STS from AWR by specifying snapshot for a desired plan which we found using the above query.
In this scenario snap id's are 89684 and 89688 and change plan_hash_value accordingly.*/

DECLARE
  l_cursor  DBMS_SQLTUNE.sqlset_cursor;
BEGIN
  OPEN l_cursor FOR
    SELECT VALUE(p)
    FROM   TABLE (DBMS_SQLTUNE.select_workload_repository (
                    23483,  -- begin_snap
                    23484,  -- end_snap
                    q'<sql_id in ('6hxw283cyw0ub') and plan_hash_value in (95728747)>',  -- basic_filter 
                    NULL, -- object_filter
                    NULL, -- ranking_measure1
                    NULL, -- ranking_measure2
                    NULL, -- ranking_measure3
                    NULL, -- result_percentage
                    100)   -- result_limit
                  ) p;

  DBMS_SQLTUNE.load_sqlset (
    sqlset_name     > 'SQL_FOR_6hxw283cyw0ub',
    populate_cursor > l_cursor);
END;
/

STEP 4: CHECK SQL SET DETAILS 

column text format a20
select sqlset_name, sqlset_owner, sqlset_id, sql_id,substr(sql_text,1,20) text,elapsed_time,buffer_gets,
parsing_schema_name, plan_hash_value, bind_data from dba_sqlset_statements where sqlset_name ='SQL_FOR_6hxw283cyw0ub';

STEP 5: LOAD DESIRED PLAN FROM STS AS SQL PLAN BASELINE

DECLARE
  L_PLANS_LOADED  PLS_INTEGER;
BEGIN
  L_PLANS_LOADED : DBMS_SPM.LOAD_PLANS_FROM_SQLSET(
    SQLSET_NAME > 'SQL_FOR_6hxw283cyw0ub');
END;

STEP 6: CHECK SQL PLAN BASELINE DETAILS 

SELECT sql_handle, plan_name,enabled,accepted,fixed FROM dba_sql_plan_baselines
WHERE signature IN (SELECT exact_matching_signature FROM v$sql WHERE sql_id='&SQL_ID')
order by accepted,enabled;

STEP 7: ENABLE FIXED=YES

var pbsts varchar2(30);
exec :pbsts : dbms_spm.alter_sql_plan_baseline('SQL_64e76e773c55f1c4','SQL_PLAN_69tvffwy5bwf480a6275e','FIXED','YES');

STEP 8: PURGE OLD EXECUTION PLAN FROM SHARED POOL 

Find below two parameter which are required to purge specific sql from the shared pool.

select address||','||hash_value from gv$sqlarea where sql_id ='6hxw283cyw0ub';

ADDRESS||','||HASH_VALUE
----------------------------------------------------------------------------------------
00000001C966CDA0,3656254283

Now use below command to purge sql from shared pool.

exec sys.dbms_shared_pool.purge('00000001C966CDA0,3656254283','C',1);

Re-run query or program to test


https://www.funoracleapps.com/2021/07/how-i-create-sql-baseline-to-fix-query.html

Saturday, July 3, 2021

Oracle E-Business Suite Performance Guides

 How to Use AWR Reports to Diagnose Database Performance Issues (Doc ID 1359094.1)

Troubleshooting Oracle Applications Performance Issues (Doc ID 169935.1)

Performance Diagnosis with Automatic Workload Repository (AWR) (Doc ID 1674086.1)

Oracle E-Business Suite Performance Guide (Doc ID 1672174.1)

Oracle E-Business Suite Performance Best Practices (Doc ID 2528000.1)


Express Diagnosis of Oracle E-Business Suite Release 12.2.n Upgrade Performance Issues (Doc ID 1583752.1)

ewallet p12 vs cwallet sso

The  ewallet.p12  stores credentials and certificates protected by a user password, while  cwallet.sso  provides an obfuscated, random passw...