Oracle Common fool question 1000 Q (13)

oracle| problem Oracle Common fool question 1000 Q (13)
Author: ccbzzp

Oracle9i's Data dictionary.

901. Chained_rows

Stores the output of the Analyze command with the list CHAINED rows clause.

902. chainge_sources

Allows publishers to view existing change resources.

903. Change_sets

Allows publishers to view existing change settings.

904. Change_tables

Allows publishers to view existing change tables.

905. code_pieces

Oracle Access this view is used to create a view about the size of an object.

906. Code_size

Oracle Access this view is used to create a view about the size of an object.

907. COLS

User_tab_columns synonyms.

908. Column_privileges

Lists the authorization status on the column.

909. database_properties

Lists the name of the currently default temporary table space.

910. Dbms_alert_info

Describes a warning that is registered.

911. dbms_lock_allocated

Describes a user-assigned lock.

912. Deptree

There is utldtree.sql to create, package the object dependency tree information.

913. Dict_columns

Contains a description of the data dictionary table and view columns.

914. DICTIONARY

Contains a description of the data dictionary table and view columns.

915. Error_size

Oracle Access this view is used to create a view about the size of an object.

916. Exceptions

Contains the complete constraint's violation information.

917. File_locks

The real-time application cluster view shows the PCM lock image of the specified data file in Gc_files_to_locks.

918. file_ping

Apply the cluster view in real time, showing the number of blocks per data file connection.

919. Global_name

The global name of the current database.

920. Hs_all_caps

Contains all the compatibility information about non-Oracle (FDS) data stores.

921. Hs_all_dd

Contains data dictionary information about non-Oracle (FDS) data stores.

922. hs_all_inits

Contains information about initialization parameters for non-Oracle (FDS) data stores.

923. Hs_base_caps

Contains basic performance information about non-Oracle (FDS) data storage.

924. Hs_base_dd

Displays information about the basic data dictionary translation table.

925. hs_class_caps

Contains classes that are part of a non-Oracle (FDS) data store to specify performance information.

926. Hs_class_init

Contains information about specifying initialization parameters for non-Oracle (FDS) classes.

927. Hs_external_object_privileges

Contains information about the privileges on the object to which the user is granted.

928. hs_external_objects

Contains information about all distributed external objects that are accessible to Oracle servers.

929. Hs_fds_class

Contains information about legitimate non-Oracle (FDS) classes.

930. Hs_fds_inst

Contains information about legitimate non-Oracle (FDS) instances.

931. Hs_inst_caps

Contains the performance information specified by the instance.

932. Hs_inst_dd

Displays information about the translation of a non-Oracle (FDS) instance-specific data dictionary.

933. Hs_inst_init

Displays information for initialization parameters specified by non-Oracle (FDS) instances.

934. Ideptree

Lists the dependent trees.

935. Index_histogram

Contains the ANALYZE INDEX ... VALIDATE information about the structure command.

936. Index_stats

Contains analyze INDEX ... VALIDATE information about the structure command.

937. Nls_database_prameters

Lists the persistent NLS parameter information in the database.

938. Nls_instance_parameters

Lists the persistent NLS parameter information in the instance.

939. Nls_session_parameters

Lists the permanent NLS parameter information in the session.

940. parsed_pieces

Oracle Access this view is used to create a view about the size of an object.

941. parsed_size

Oracle Access this view is used to create a view about the size of an object.

942. plan_table

Is the result table of the Explan plan statement.

943. Pluggable_set_check

Contains the pluggable settings check.

944. product_component_version

Contains the version and status information that makes up the product.

945. Proxy_users

Describes users who can assume the identity of another user.

946. Pstubtbl

Contains information on the root generated by the Pstub program so that Oracle FORM3.0 customers can invoke stored procedures in the Oracle database.

947. public_deptendency

Lists the dependencies of the object.

948. Pubucsyn

Contains information on a public synonym.

949. Queue_privileges

Displays the advanced query objects that are granted to the session by those privileges.

950. Resource_cost

Lists the cost of each resource.

951. Resource_map

Contains a description of the resource.

952. Role_role_privs

Contains role information that is granted to other roles.

953. Role_sys_privs

Contains information about the system privileges granted to the role.

954. Role_tab_privs

Contains information about the privileges of the table granted to the role.

955. Session_context

Lists the properties and value settings for the current session.

956. Session_privs

Lists the privileges currently available to users.

957. Session_roles

Lists the roles currently enabled for the user.

958. Source_size

Oracle Access this view is used to create a view about the size of an object.

959. Stmt_audit_option_map

Contains information about the Audit option type code.

960. Syscatalog

This view is used to maintain compatibility with the ORACLE5 version and is not recommended for use.

961. Sysfiles

This view is used to maintain compatibility with the ORACLE5 version and is not recommended for use.

962. Syssegobj

This view is used to maintain compatibility with the ORACLE5 version and is not recommended for use.

963. System_privilege_map

Contains information about the system privileged code.

964. sys_objects

Maps object IDs to object types and segment data block addresses.

965. Table_privilege_map

Contains information about accessing privileged code.

966. Table_privileges

Contains privileged information on an object.

967. Tabquotas

This view is used to maintain compatibility with the ORACLE5 version and is not recommended for use.

968. Trusted_servers

Shows whether the server is trusted or not trusted.

969. Ts_pitr_check

Provides dependency or constraint information that may prevent tablespaces from resuming at a point in time.

970. ts_pitr_objects_to_be_dropped

Lists all objects that are lost as a result of a point-in-time recovery in the execution of tablespace.

971. Uni_pluggable_set_check

Protects pluggable inspection information.





Cond...