Oracle common problem 1000 questions complete works (10)

xiaoxiao2021-03-06  145

901. CHAINED_ROWS

The output of the Analyze command with the list chained rows clause.

902. chainge_sources

Allow the issuer to view existing changes resources.

903. Change_Sets

Allow the issuer to view an existing change setting.

904. Change_Tables

Allow the issuer to view an existing change table.

905. Code_PIECES

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

906. Code_Size

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

907. COLS

User_tab_columns synonym.

908. Column_Privileges

List the authorization status on the column.

909. Database_Properties

List the name of the currently default temporary table space.

910. DBMS_Alert_info

Describe the registered warning.

911. DBMS_LOCK_ALLOCATED

Describe the lock assigned by the user.

912. DePtree

There are UTLDTree.sql creation, enclose the object dependent tree.

913. dict_columns

A description of the data dictionary table and view column.

914. Dictionary

A description of the data dictionary table and view column.

915. Error_Size

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

916. EXCEPTIONS

A violation of the full constraint.

917. File_locks

Real-time application cluster view, display the PCM lock image of the specified data file in GC_FILES_TO_LOCKS.

918. File_Ping

Real-time application cluster view, display the number of blocks connected to each data file.

919. Global_name

The global name of the current database.

920. HS_ALL_CAPS

Contains all compatibility information related to non-Oracle (FDS) data storage.

921. HS_All_DD

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

922. HS_ALL_INITS

Contains an initialization parameter information about non-Oracle (FDS) data storage.

923. HS_BASE_CAPS

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

924. HS_BASE_DD

Show information about the basic data dictionary.

925. HS_CLASS_CAPS

Contains class specified performance information belonging to non-Oracle (FDS) data store.

926. HS_CLASS_INIT

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

927. HS_EXTERNAL_OBJECT_PRIVILEGES

The information containing privileges on objects granted to the user.

928. HS_EXTERNAL_OBJECTS

The information containing all distributed external objects that Oracle servers can access.

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 translation of non-Oracle (FDS) instance specific data dictionary.

933. HS_INST_INIT

Displays information about the initialization parameters specified by the non-Oracle (FDS) instance.

934. Ideptree

List the dependent tree.

935. INDEX_HISTOGRAM

The information containing the analyzeindex ... validate structure command.

936. INDEX_STATS

The information containing the Analyze Index ... Validate structure command.

937. NLS_DATABASE_PRAMETERS

List the permanent NLS parameter information in the database.

938. NLS_INSTANCE_PARAMETERS

List the permanent NLS parameter information in the instance.

939. NLS_SESSION_PARAMETERS

List the permanent NLS parameter information in the session.

940. Parsed_piecesoracle Access This view is used to create a view about an object size.

941. parse_size

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

942. Plan_Table

The result table of the Explan PLAN statement.

943. Pluggable_set_check

Contains an insertable setting check.

944. Product_component_version

Contains version and status information that make up the product.

945. Proxy_Users

Describe those users who can assume other user identities.

946. Pstubtbl

Contains the stored procedure in the letter generated by the PSTUB program. Interest, so that Oracle Form3.0 customers can call Oracle Databases

947. Public_Deptendency

List the dependence of the object.

948. PubucSyn

Contains information on the common synonym.

949. Queue_Privileges

Show those privilege awarded high-level query objects to the session.

950. Resource_Cost

List the overhead of each resource.

951. Resource_map

A description of the resource.

952. Role_Role_Privs

Contains role information to grant other roles.

953. role_sys_privs

The information that includes system privileges granted to the role.

954. role_tab_privs

Contains information about granting characters.

955. Session_Context

List the properties and value settings of the current session.

956. Session_privs

List the privileges available to users.

957. session_roles

List the roles currently enabled by the user.

958. Source_size

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

959. STMT_AUDIT_OPTION_MAP

Contains information about the audit option type code.

960. syscatalog

This view is used to remain compatible with Oracle5 versions, and it is recommended not to use.

961. Sysfiles

This view is used to remain compatible with Oracle5 versions, and it is recommended not to use.

962. Syssegobj

This view is used to remain compatible with Oracle5 versions, and it is recommended not to use.

963. SYSTEM_PRIVILEGE_MAP

Information containing system privilege code.

964. SYS_OBJECTS

Map the object ID to the object type and segment data block address.

965. TABLE_PRIVILEGE_MAP

Contains information about accessing privilege code.

966. Table_Privileges

Contains privilege information on the object.

967. TabQuotas

This view is used to remain compatible with Oracle5 versions, and it is recommended not to use.

968. Trusted_Servers

The display server is trust or does not trust.

969. TS_PITR_CHECK

Provide possible prohibiting table spaces to restore continued dependent or constraints.

970. TS_PITR_Objects_to_be_dropped

All objects that are lost as the result of time-to-date recovery as a table space.

971. UNI_PLUGGABLE_SET_CHECK

Protect the pluggable check information.

转载请注明原文地址:https://www.9cbs.com/read-127655.html

New Post(0)