About Naming Requirements for Repository Objects. Changing Icons for Repository Objects. Sorting Objects in the Administration Tool. Do not open the Administration Tool by double-clicking a repository file. The resulting Administration Tool window is not initialized to your Oracle instance, resulting in errors.
Automatically tiles the layer panes of the repository when you resize the Administration Tool. When this option is selected, the Cascade and Tile options are not available in the Windows menu of the Administration Tool.
For example, selecting this option displays "B - Sample Fcst Data" Selecting this option can help identify objects by including the name of the parent database or business model, but it can also make the diagram harder to read because the fully qualified names are longer.
If you choose not to select this option, you can still see fully qualified names by moving the cursor over an object in the diagram, or by selecting an object in the diagram and then viewing the text in the status bar. Displays the names of original physical tables rather than the names of alias tables in the Physical diagram. Select this option when you want to identify the original table rather than the alias table name.
Displays the Calculation Wizard introduction page. The introduction page also contains an option to suppress its display in the future. Use the Calculation Wizard to create new calculation columns that compare two existing columns and to create metrics in bulk aggregated , including existing error trapping for NULL and divide by zero logic. See Using the Calculation Wizard.
Automatically checks out an object when you double-click it. If you do not select this option, you are prompted to check out objects before you can edit them. This option only applies when the Administration Tool is open in online mode. See Editing Repositories in Online Mode.
Displays row counts for physical tables and columns in the Physical layer. Row counts are not initially displayed until they are updated. Row counts are not shown for items that are stored procedure calls from the Table Type list in the General tab of the Physical Table dialog.
When you are working in online mode, you cannot update row counts on any new objects until you check them in. Executes a utility to clean the repository of unused physical objects. It might make the resulting repository smaller. When selected, the Import from Repository option on the File menu becomes available.
By default, the Import from Repository option on the File menu is disabled and this option will not be supported in the future.
It is recommended that you create projects in the repository that contain the objects that you want to import, and then use repository merge to bring the projects into your current repository.
See Merging Repositories. When selected, provides the capability to create logical foreign key joins with the Joins Manager. This option is provided for compatibility with previous releases and is generally not recommended. When selected, excludes Gen 1 levels when you drag and drop Essbase cubes or dimensions from the Physical layer to the Business Model and Mapping layer.
Often, Gen 1 levels are not needed for analysis, so they can be excluded from the business model. See Working with Essbase Data Sources. By default, the Replace Wizard shows all logical table sources, even ones that are not valid for replacement. When this option is selected, unusable logical table sources are hidden in the Replace Wizard screens. Click Info for details on why a logical table source that maps to that column does not appear in the list.
Selecting this option might result in the Wizard page loading more quickly, especially for large repositories. By default, when you select a connection pool for an initialization block, the first connection pool under the database object in the Physical layer does not display as available for selection.
This behavior ensures that you cannot use the same connection pool for initialization blocks that you use for queries. If the same connection pool is used for initialization blocks and for queries, then queries might be blocked whenever initialization blocks run. Alternatively, initialization blocks used for authentication might be blocked by long-running queries, causing delayed or hanging logins.
EM Express also provides an interface for performance advisors. Oracle also offers separately licensed Oracle Enterprise Manager management packs, management plug-ins, and other products you can purchase to enhance the capabilities of Oracle Enterprise Manager in specific environments. It is available in the default installation of Oracle Database. Table describes the Enterprise Manager home pages that might be used as a starting point when you first browse to the Application Server Control Console.
The Application Server home page is the first page you see if you have installed a single application server instance that is not using an OracleAS Metadata Repository. The OracleAS Farm page is the first page you see if you have installed one or more application server instances that use a common set of OracleAS Infrastructure 10 g —or more specifically, a common file-based or database-based OracleAS Metadata Repository.
From the Application Server Home page Figure , you can start and stop the application server instance, monitor the overall performance of the server, and review the components of the server.
You can also drill down and examine the performance of a particular component and configure the component. The Application Server Home page provides a table that lists the components of the application server. From this table, you can also get a snapshot of how each individual component is performing.
From the System Components table, you can display a home page for each component of the application server. Click Ports to view a list of all the ports currently in use by the various Oracle Application Server components.
You can also modify many of the port assignments when necessary. When a component is disabled, it does not consume any system resources and you can always enable it later. For more information, click Help after selecting an option on the Application Server Home page. Standalone instances are application server instances that are not part of an OracleAS Cluster. For more information, see the Enterprise Manager online help. Component home pages vary from one component to another because each component has different monitoring and configuration requirements.
However, most of the component home pages have the following common elements:. A general information section that includes an icon to indicate the current state of the component and buttons for starting and stopping the component if applicable. Status information, including CPU and memory usage information, so you can get a snapshot of how the component is performing. Links to administrative functions where appropriate, so you can modify the configuration of selected components.
In many cases, this means you can use a graphical user interface to modify complex configuration files. The Application Server Control Console is designed to encourage a top-down approach to your monitoring and diagnostic activities.
For example, you can start by reviewing the basic characteristics of your application server and then drill down to examine the performance of individual components of the server. You can use this viewer to better understand the component relationships of the application server.
The Topology Viewer identifies each component of the application server with an icon. The position of each icon on the page and the connections between the icons represent the relationships between each component. Visual clues in the Topology Viewer help you quickly identify components that are down or performing poorly. If you are managing multiple application servers as part of an OracleAS Farm, the viewer also shows the relationships between the application server instances, including any OracleAS Cluster you have created.
The Application Server home page provides general information about the status of your server, including the name, location, and application server availability. The home page also provides high-level information about CPU and Memory usage. If you suspect that the application server is using too many resources, review the list of components to confirm that each component is up and running and to review the resource usage by each component Figure Consider disabling any components that you are not currently using as part of this application server instance.
Disabled components are not started when you start the application server and as a result do not consume system resources. You can always enable a disabled application server component at a later time. Many performance or configuration issues are directly related to a lack of available resources on the host.
Before you drill down to analyze the performance and resource usage of the individual application server components, review the resources and characteristics of the application server host. Click the host name in the General section of the Application Server home page to display the Host home page. The Host home page provides a summary of the operating system, memory, and disk capacity.
The Load section of the page provides a CPU chart that breaks down the CPU usage into categories of usage; the load metrics beneath the chart provide details about system memory usage Figure Scroll to the bottom of the page to view a set of links to real-time performance metrics. If you are concerned about the CPU and Memory usage on the system, click Top Processes to display tables listing the processes that are using the most resources on the host.
Click Filesystems to display a bar chart that reveals the amount of disk space available on the application server host Figure After you review the high-level performance metrics and the resources available on the application server host computer, you can then begin to look for potential issues within the individual application server components.
To diagnose problems with individual application server components, click the component name in the System Components table on the Application Server home page. This technique of "drilling down" to obtain more detail can help you isolate problems in a particular component or area of the application server. The Application Server Control Console provides you with selected performance metrics that you can use to determine the overall performance of your application server. In some cases, the metrics are shown as performance charts; in other cases, you can monitor the real-time value of the metrics in numeric format.
For a comprehensive list of the metrics that are monitored by Enterprise Manager, you can view the All Metrics page. Click Expand All to see all the application server metrics in each of the metric categories.
Figure shows the Application Server All Metrics page after you have expanded all the metric categories. Consistency Check The Oracle Business Intelligence Server Administration Guide discusses consistency checks that you must perform on repository metadata before you make the repository available for queries. Initialization Blocks The system uses initialization blocks to initialize dynamic repository variables, system session variables, and nonsystem session variables.
URI B. Global Dimensions Global dimensions are used by more than one mart within a functional warehouse, and across functional warehouses, to provide you with a consistent view of the data. Business Model and Mapping Layer The Business Model and Mapping layer represents the logical structure of the information in the repository.
Dimensional Hierarchies Some of the results that appear in the Fusion Campus Solutions Intelligence application represent hierarchical data structures. Degenerate Dimensions A fact table may contain columns that cannot be aggregated, such as application number, application program number, and student career number that act as dimension attributes. Presentation Layer The Presentation layer simplifies the business model and makes it easy for users to understand and query.
Call Interface. Data Source Name. Shared Logon. User Name. Enable Connection Pooling. Parameters Supported. Admission Application PIA page. Dynamic Repository. Job Summary PIA page. Journal Entries PIA page. None, defaulted to
0コメント