Schemas
A
Schema is Required for Some Tuning Categories. Because Oracle Expert Is Not A
Schema Editor, IT Does Not Keep 100% of A User's
Schema, Nor Does It Provide Editing Capabilities for ALL POSSIBLE
Schema Information. in General, Oracle Expert Manages ONLY
Schema Objects That Are Necessary to the Tuning process.
WIOIN ORACLE EXPERT, You Can Edit Data For All The Schemas You CAN Access in Your Database. The Objects Withnin A
Schema That You Can Edit Are: Tables (Including Columns, Indexes, and constraines), Clusters, and Synynyms.
IF a
Schema Object Is Missing or Incomplete for a Tuning Session That Expects
Schema Data, Oracle Expert Will NOT Attempt To Make Recommendations ON Objects Related To The MISSING
Schema object.
The accuracy of the necessary data is very important. When Oracle Expert attempts to form tuning strategies, it assumes that the input data is accurate. If that is not the case, the quality of the recommendations may be unreliable. For example, cardinality is a critical attribute in both tables and columns. Oracle Expert relies heavily on the cardinality values to predict sizing and index formation. If the cardinality values are incorrect or missing, Oracle Expert may recommend very poor index structures or no index structures at all.
Schema:
Collection of Database Objects, Including Logical Structures Such As Tables, Views, Sequences, Stored Procedures, Synynyms, Indexes, Clusters, And Database Links. A
Schema Has The Name of The User WHO Controls IT.
