Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "Oracle 11g's new special and new detailed explanation". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

When you report a problem to Oracle Support personnel, it is often difficult to collect and regenerate the scenarios in which the problem occurs. The new SQL Test Case Builder allows you to easily capture information about a SQL problem and upload it to Oracle Support so that Oracle Support can regenerate the problem and test it. SQL Test Case Builder collects information such as details of SQL queries, object definitions, storage code (such as packages), initialization parameters, and optimizer statistics. It does not collect the actual data used by the query.

You can access SQL Test Case Builder using Database Control or the new DBMS_SQLDIAG package. The following is the key process for handling SQL Test Case Builder functionality in the DBMS_SQLDIAG package:

Explain_sql_testcase function interprets SQL test case

The get_sql function imports the SQL test case

The export_sql_testcase process exports SQL test cases to a directory

The export_sql_testcase_dir_by_inc function generates a SQL test case corresponding to an unexpected event ID

The export_sql_testcase_dir_by_txt function generates a SQL test case corresponding to a SQL statement.

It is easy to create SQL test cases with Database Control. Note that SQL Test Case Builder can only be used from SQL when unexpected events related to Database Control occur. Here are the steps to access SQL Test Case Builder from Database Control.

(1) on the Database Control home page, click Advisor Central under Related Links to access the Advisor Central page. Click SQL Advisors, and then click the link Click Here to Go to Support Workbench.

(2) to investigate a specific problem, click an accident ID.

(3) Click Oracle Support in the Investigate and Resolve section.

(4) click Generate Additional Dumps and Test Cases.

(5) run SQL Test Case Builder for an unexpected event and click the icon in the Go To Task column.

You must provide the output with a name and a directory to save it. The output consists of commands that are used to re-establish the environment and objects for testing problematic SQL queries.

This is the end of the introduction of "New Special and New details of Oracle 11g". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.