The value of the bind variable has a direct impact on the selectivity of your SQL predicates.  Often it is useful to capture the value of the bind variables to investigate the SQL performance issues.

Here are the steps to capture your Oracle SQL trace file that includes the value of the bind variables.

Alter session set statistics_level=ALL;
Alter session set max_dump_file_size=UNLIMITED;
Alter session set events ’10046 trace name context forever, level 12‘;

var g_city char(20)

begin
:g_city := ‘Toronto‘;
end;
/

select * from customers where cust_city = :g_name;

alter session set events ’10046 trace name context off’;

Open up the trace file and search for string “Bind” and followed by value and of course the value.  Not the prettiest output but it does not the job;

BINDS #2:
Bind#0
oacdty=96 mxl=128(90) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=873 siz=128 off=0
kxsbbbfp=006061e4  bln=128  avl=30  flg=05
value=”Toronto “

Recall that in Oracle 11g you can provide an identifier for for your trace file to ease the pain of locating the right trace file.

Payam Moghtader is a Senior Consultant and currently working in capacities of Oracle Solutions Architect, IT Project Manager (PMP), and Certified Oracle University Instructor.  He also is a contributor to 2Dev.com. Payam has over 17 years of experience in management and implementation of Information Technology solutions. His areas of expertise are Oracle based solutions including Oracle Fusion Middleware, Oracle WebLogic Server, Oracle Application Server, Oracle ADF, Java EE, Oracle Database, SQL Tuning, Server Architecture and Design as well as Project Management.

He managed his own start-up company in the mid 90’s and was responsible for directing the technology needs and modernizing processes in the manufacturing industry. He also worked as a freelance consultant, technical trainer and project manager for a number of small and midsize organizations in the late 90’s.

Payam has been with his current role since 2000 as a senior consultant at DesTech, a highly regarded Professional Services firm in Toronto, Ontario, Canada.

In the past 12 years, through DesTech and other corporate training companies and colleges, Payam has taught many courses for Oracle University across North America with many awards to his name.

Here are some IT Project Management jobs posting for you PMs who are looking for interesting opportunities. These are international IT PM opportunities, for all Canadian postings see Canadian PM opportunities.

1. Sr. Program Manager | John Ryan - US - MN - Minneapolis, Required Education and Experience *A minimum of five successful years of Project Management required *4-year degree required, MBA preferred *Related experience desired. Ideally a retail, financial
2. Consulting Project Manager | Resources Global Professionals - IL - Chicago, Join our worldwide community of information management professionals.Lend your talent, skills and experience to a world-class company, and enjoy the freedom and flexibility to choose your engagements
3. Project Manager / Project Coordinator | Resources Global Professionals - NY - New York, Project Managers / Project Coordinators  to join our Tri-state Information Management practice. The ideal candidate has 4-12 years of experience. Four-year bachelor degree required.  Abilit
4. Senior Business Systems Analyst | Resources Global Professionals - CA - Walnut Creek, Join our worldwide community of information management professionals.Lend your talent, skills and experience to a world-class company, and enjoy the freedom and flexibility to choose your engagements
5. Project Manager / Project Coordinator | Resources Global Professionals - NJ - Princeton, Project Managers / Project Coordinators  to join our Tri-state Information Management practice. The ideal candidate has 4-12 years of experience. Four-year bachelor degree required.  Abilit
6. Information Management Professionals | Resources Global Professionals - CA - San Francisco, Join our worldwide community of information management professionals.Lend your talent, skills and experience to a world-class company, and enjoy the freedom and flexibility to choose your engagements
7. Project Manager / Project Coordinator | Resources Global Professionals - CT - Hartford, Project Managers / Project Coordinators  to join our Tri-state Information Management practice. The ideal candidate has 4-12 years of experience. Four-year bachelor degree required.  Abilit
8. Project Manager / Project Coordinator | Resources Global Professionals - CT - Stamford, Project Managers / Project Coordinators  to join our Tri-state Information Management practice. The ideal candidate has 4-12 years of experience. Four-year bachelor degree required.  Abilit
9. Senior Database Analysts | Resources Global Professionals - CA - San Francisco, Join our worldwide community of accounting and finance professionals.Lend your talent, skills and experience to a world-class company, and enjoy the freedom and flexibility to choose your engagements
10. Project Managers, Senior - Mid-Level | Resources Global Professionals - CA - San Francisco, Join our worldwide community of information management professionals.Lend your talent, skills and experience to a world-class company, and enjoy the freedom and flexibility to choose your engagements
11. Project Manager / Project Coordinator | Resources Global Professionals - NJ - Parsippany, Project Managers / Project Coordinators  to join our Tri-state Information Management practice. The ideal candidate has 4-12 years of experience. Four-year bachelor degree required.  Abilit
12. Senior Database Analysts | Resources Global Professionals - CA - Walnut Creek, Join our worldwide community of accounting and finance professionals.Lend your talent, skills and experience to a world-class company, and enjoy the freedom and flexibility to choose your engagements
13. Project Managers, Senior - Mid-Level | Resources Global Professionals - CA - Walnut Creek, Join our worldwide community of information management professionals.Lend your talent, skills and experience to a world-class company, and enjoy the freedom and flexibility to choose your engagements
14. Senior Business Systems Analyst | Resources Global Professionals - CA - San Francisco, Join our worldwide community of information management professionals.Lend your talent, skills and experience to a world-class company, and enjoy the freedom and flexibility to choose your engagements
15. Computer Forensics Analyst | Resources Global Professionals - CA - San Francisco, Turn experience into opportunity. Leverage your accomplishments to get the kind of employment youve always wanted: a self-directed career with work/life balance, world class clients and high-level i
16. Senior Project Manager | Jacobs Canada Inc. - CAN - AB, Qualifications A minimum of 20 years of project management experience BS or MS degree, significant technical expertise, and desire to stay in a PM position on projects Possess an expert level
17. IT Project Manager | Koch Business Solution, LP - US - KS - Wichita, Work Experience/Skills REQUIRED: * 4 + years of experience as a project manager managing Technology and Application projects * Proven ability to apply project management skills to reach successful
18. Recruiting Manager | Resources Global Professionals - IL - Chicago, Reporting to the Senior Director of Recruiting, the Recruiting Manager will coordinate activities related to the recruiting process including, but not limited to, the sourcing, screening, and schedul
19. Hyperion Product Professionals | Resources Global Professionals - NJ - Princeton, Resources Global Professionals is currently seeking dynamic and highly motivated information management professionals with strong Hyperion Product expertise (i.e., Hyperion Financial Management (HFM)
20. Software Project Manager (multiple positions/ multiple locations) | Harland Financial Solutions - US - FL - Lake Mary, • 3-6 years experience in Project Management or similar experience. • 3+ years experience leading technical and non-technical resources. • Experience assisting teams with identification of action it

Good luck.
Do you find this posting helpful? Please leave a comment.

Here are some Project Management jobs posting for you PMs who are looking for career advancement and better opportunities.

1. Senior Project Manager | Jacobs Canada Inc. - CAN - AB, Qualifications A minimum of 20 years of project management experience BS or MS degree, significant technical expertise, and desire to stay in a PM position on projects Possess an expert level
2. Director, Planning and Production Control | Seaspan Marine Corporation - CAN - BC - North Vancouver, Competencies required: • 10-15 years experience in planning and production control, preferably in the shipbuilding industry, or alternatively in a large manufacturing or engineering-to-order indust
3. Project Manager | Oil Country Engineering - CAN - AB - Edmonton, Qualifications: Experience in Project Managing Engineering Projects. Diploma or Degree from Recognised Institution in a relevant field. Experience in a manufacturing/fabrication environment will be
4. Business Project Managers - Contact Centre and eServices | Workplace Safety & Insurance Board - CAN - ON - Toronto, The ideal candidate will have: PMP certification and/or extensive project management experience in business process reengineering or eClaims/eServices Solid understanding of technologies and best
5. Program Manager - MRP | Seaspan - CAN - BC - North Vancouver, Competencies required: • A degree in information technology, engineering, business or other related discipline. • 10-15 years’ experience with implementation of MRP/ ERP systems, preferably in a shi
6. Enterprise Risk Management Program Manager | The City of Edmonton - CAN - AB - Edmonton, In order to be considered for this role, you will have business continuity management knowledge and hold or are working towards a professional designation in business continuity such as a Canadian Ris
7. Deposit & Liquidity Services, Technical Consultant (Infrastructure & Development) | International Financial Data Services - CAN - ON - Toronto, •4 year, post-secondary education in a computer-related discipline (e.g., Computer Science, Computer Information Systems, Management Information Systems, Mathematics, Engineering, etc.) •More than 1
8. Project Manager - Clinical Tools Adoption | Centre for Family Medicine - CAN - ON - Waterloo Region, The Project Manager resource will be required to have: • Their own computers with licensed copies of MS Office 2007, MS Project 2003, and MS Visio 2007 or more recent editions of these software prog
9. Project Coordinator | International Financial Data Services - CAN - ON - Toronto, Competencies: (Behavioral and Functional) Critical: •Experience with MS Project, Word, Excel, Visio, and NIKU •Experience with MS Access and NIKU would be an asset •Knowledge of business pr
10. Senior Gating & Compliance Analyst | Enbridge - CAN - AB, A degree with a minimum of 7 to 10 years of related experience, or an equivalent combination of education and experience. Must be a proactive self starter and have high attention to detail. Ex
11. Project Risk Specialist | Enbridge - CAN - AB, Qualifications: Bachelor degree in engineering and Licensing as a Professional Engineer is preferred. A minimum of 10 years of progressively increasing responsibility in a project management
12. Senior Buyer | Enbridge Pipelines - CAN - AB - Sherwood Park, Education/Experience: - Minimum of 10 years supply chain/procurement/contract experience preferably within the oil & gas industry. - Completion of a Business degree or diploma with specific educ
13. Director, Project Management | International Financial Data Services - CAN - ON - Toronto, Critical •Results oriented – strives to achieve short-term goals, level of performance but not at expense of long-term objectives. •Developer or People – takes time to provide assignments, guidanc
14. Contractor: Project Management | Enbridge - CAN - AB, - 6-10 years relevant work experience, with project, plant or field construction exposure (prefer major projects in pipelines, oil and gas, or power). - Hands on job experience related to risk o
15. Administrative Support II | Enbridge Pipelines - CAN - AB - Edmonton, Qualifications An Office Administration or equivalent program diploma is desirable. A High School diploma supplemented by continuing education courses and 5 - 7 years experience in progressively
16. Project Controller | MAN Diesel & Turbo Canada Ltd. - CAN - ON - Oakville, EXPERIENCE AND SKILLS REQUIRED: • Post Secondary Education in Engineering, Business, or Construction Management preferred or equivalent combination of education or experience • 5-7 years of experi
17. Project Manager | TMC - CAN - SK - Regina, - Direct IT project management experience - Proven track records of managing medium to large size projects, programs, portfolios successfully - Knowledge and experience with project management best
18. Director, Project Management | Halton Healthcare - CAN - ON - Oakville, The qualifications of the Director, Project Management include: • Baccalaureate degree in Business or a health-related profession • Master’s level preparation in the Business or Healthcare fie
19. Associate Project Manager | Monster.ca - CAN - QC, At least 3 years of Project Management experience Strong written and verbal communication and presentation skills (French and English) Ability to gather and analyze information, define problems a
20. Business Analyst, Regulatory and Tax | International Financial Data Services - CAN - ON - Toronto, Competencies: (Behavioral and Functional) Critical Requirements: •A Subject Matter Expert in areas related to the understanding of industry, industry standards, regulatory and legislative mat

Good luck.
Do you find this posting helpful? Please leave a comment.

Well, we employ project management processes in every project. Simply this is to increase the quality of our work, have a more predictable outcome for our project. More complex is your project, the more attention you need to pay to these processes.

If you believe that the passing the PMP exam can be treated as a project, then you can only increase your chance of passing this exam by following project management processes. You can read the full details about this approach on the paper listed below.

A Project Managment Approach to Passing The PMP Exam, By Marcos Cubric & Payam Moghtader