ruạṛ
a ���f� � @ s8 d dl mZmZmZ d dlmZ eG dd� de��ZdS )� )�formatted_flat_dict� NONE_SENTINEL�#value_allowed_none_or_none_sentinel)� init_model_state_from_kwargsc @ s� e Zd ZdZdd� Zedd� �Zejdd� �Zedd� �Zejd d� �Zed d � �Z e jd d � �Z ed d� �Z e jdd� �Z edd� �Z e jdd� �Z edd� �Z e jdd� �Z edd� �Z e jdd� �Z edd� �Zejdd� �Zed d � �Zejd d � �Zed d � �Zejd!d � �Zed"d#� �Zejd$d#� �Zed%d&� �Zejd'd&� �Zed(d)� �Zejd*d)� �Zed+d,� �Zejd-d,� �Zed.d/� �Zejd0d/� �Zed1d2� �Zejd3d2� �Zed4d5� �Zejd6d5� �Zed7d8� �Zejd9d8� �Zed:d;� �Zejd<d;� �Zed=d>� �Zejd?d>� �Zed@dA� �ZejdBdA� �ZedCdD� �Z e jdEdD� �Z edFdG� �Z e jdHdG� �Z edIdJ� �Z e jdKdJ� �Z edLdM� �Z e jdNdM� �Z edOdP� �Z e jdQdP� �Z edRdS� �Z!e!jdTdS� �Z!edUdV� �Z"e"jdWdV� �Z"edXdY� �Z#e#jdZdY� �Z#ed[d\� �Z$e$jd]d\� �Z$ed^d_� �Z%e%jd`d_� �Z%edadb� �Z&e&jdcdb� �Z&eddde� �Z'e'jdfde� �Z'edgdh� �Z(e(jdidh� �Z(edjdk� �Z)e)jdldk� �Z)edmdn� �Z*e*jdodn� �Z*edpdq� �Z+e+jdrdq� �Z+edsdt� �Z,e,jdudt� �Z,edvdw� �Z-e-jdxdw� �Z-edydz� �Z.e.jd{dz� �Z.ed|d}� �Z/e/jd~d}� �Z/edd�� �Z0e0jd�d�� �Z0ed�d�� �Z1e1jd�d�� �Z1ed�d�� �Z2e2jd�d�� �Z2ed�d�� �Z3e3jd�d�� �Z3ed�d�� �Z4e4jd�d�� �Z4ed�d�� �Z5e5jd�d�� �Z5ed�d�� �Z6e6jd�d�� �Z6ed�d�� �Z7e7jd�d�� �Z7ed�d�� �Z8e8jd�d�� �Z8ed�d�� �Z9e9jd�d�� �Z9ed�d�� �Z:e:jd�d�� �Z:ed�d�� �Z;e;jd�d�� �Z;ed�d�� �Z<e<jd�d�� �Z<ed�d�� �Z=e=jd�d�� �Z=ed�d�� �Z>e>jd�d�� �Z>ed�d�� �Z?e?jd�d�� �Z?ed�d�� �Z@e@jd�d�� �Z@ed�d�� �ZAeAjd�d�� �ZAed�d�� �ZBeBjd�d�� �ZBed�d�� �ZCeCjd�d�� �ZCed�d�� �ZDeDjd�d�� �ZDed�d�� �ZEeEjd�d�� �ZEed�d �ZFeFjd�d �ZFed�dń �ZGeGjd�dń �ZGed�dȄ �ZHeHjd�dȄ �ZHd�d˄ ZId�d̈́ ZJd�dτ ZKd�S )��SqlStatsz Sql Stats type object. c C K s� ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd�B| _ ddddd d d d d ddddddddddddddd d d d d d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFd�B| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _ dG| _ dG| _ dG| _ dG| _ dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _dG| _ dG| _ dG| _ dG| _ dG| _ dG| _!dG| _"dG| _#dG| _$dG| _%dG| _&dG| _'dG| _(dG| _)dG| _*dG| _+dG| _,dG| _-dG| _.dG| _/dG| _0dG| _1dG| _2dG| _3dG| _4dG| _5dG| _6dG| _7dG| _8dG| _9dG| _:dG| _;dG| _<dG| _=dG| _>dG| _?dG| _@dG| _AdG| _BdG| _CdGS )HaG( Initializes a new SqlStats object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class): :param sql_identifier: The value to assign to the sql_identifier property of this SqlStats. :type sql_identifier: str :param plan_hash_value: The value to assign to the plan_hash_value property of this SqlStats. :type plan_hash_value: int :param time_collected: The value to assign to the time_collected property of this SqlStats. :type time_collected: datetime :param instance_name: The value to assign to the instance_name property of this SqlStats. :type instance_name: str :param last_active_time: The value to assign to the last_active_time property of this SqlStats. :type last_active_time: str :param parse_calls: The value to assign to the parse_calls property of this SqlStats. :type parse_calls: int :param disk_reads: The value to assign to the disk_reads property of this SqlStats. :type disk_reads: int :param direct_reads: The value to assign to the direct_reads property of this SqlStats. :type direct_reads: int :param direct_writes: The value to assign to the direct_writes property of this SqlStats. :type direct_writes: int :param buffer_gets: The value to assign to the buffer_gets property of this SqlStats. :type buffer_gets: int :param rows_processed: The value to assign to the rows_processed property of this SqlStats. :type rows_processed: int :param serializable_aborts: The value to assign to the serializable_aborts property of this SqlStats. :type serializable_aborts: int :param fetches: The value to assign to the fetches property of this SqlStats. :type fetches: int :param executions: The value to assign to the executions property of this SqlStats. :type executions: int :param avoided_executions: The value to assign to the avoided_executions property of this SqlStats. :type avoided_executions: int :param end_of_fetch_count: The value to assign to the end_of_fetch_count property of this SqlStats. :type end_of_fetch_count: int :param loads: The value to assign to the loads property of this SqlStats. :type loads: int :param version_count: The value to assign to the version_count property of this SqlStats. :type version_count: int :param invalidations: The value to assign to the invalidations property of this SqlStats. :type invalidations: int :param obsolete_count: The value to assign to the obsolete_count property of this SqlStats. :type obsolete_count: int :param px_servers_executions: The value to assign to the px_servers_executions property of this SqlStats. :type px_servers_executions: int :param cpu_time_in_us: The value to assign to the cpu_time_in_us property of this SqlStats. :type cpu_time_in_us: int :param elapsed_time_in_us: The value to assign to the elapsed_time_in_us property of this SqlStats. :type elapsed_time_in_us: int :param avg_hard_parse_time_in_us: The value to assign to the avg_hard_parse_time_in_us property of this SqlStats. :type avg_hard_parse_time_in_us: int :param concurrency_wait_time_in_us: The value to assign to the concurrency_wait_time_in_us property of this SqlStats. :type concurrency_wait_time_in_us: int :param application_wait_time_in_us: The value to assign to the application_wait_time_in_us property of this SqlStats. :type application_wait_time_in_us: int :param cluster_wait_time_in_us: The value to assign to the cluster_wait_time_in_us property of this SqlStats. :type cluster_wait_time_in_us: int :param user_io_wait_time_in_us: The value to assign to the user_io_wait_time_in_us property of this SqlStats. :type user_io_wait_time_in_us: int :param plsql_exec_time_in_us: The value to assign to the plsql_exec_time_in_us property of this SqlStats. :type plsql_exec_time_in_us: int :param java_exec_time_in_us: The value to assign to the java_exec_time_in_us property of this SqlStats. :type java_exec_time_in_us: int :param sorts: The value to assign to the sorts property of this SqlStats. :type sorts: int :param sharable_mem: The value to assign to the sharable_mem property of this SqlStats. :type sharable_mem: int :param total_sharable_mem: The value to assign to the total_sharable_mem property of this SqlStats. :type total_sharable_mem: int :param type_check_mem: The value to assign to the type_check_mem property of this SqlStats. :type type_check_mem: int :param io_cell_offload_eligible_bytes: The value to assign to the io_cell_offload_eligible_bytes property of this SqlStats. :type io_cell_offload_eligible_bytes: int :param io_interconnect_bytes: The value to assign to the io_interconnect_bytes property of this SqlStats. :type io_interconnect_bytes: int :param physical_read_requests: The value to assign to the physical_read_requests property of this SqlStats. :type physical_read_requests: int :param physical_read_bytes: The value to assign to the physical_read_bytes property of this SqlStats. :type physical_read_bytes: int :param physical_write_requests: The value to assign to the physical_write_requests property of this SqlStats. :type physical_write_requests: int :param physical_write_bytes: The value to assign to the physical_write_bytes property of this SqlStats. :type physical_write_bytes: int :param exact_matching_signature: The value to assign to the exact_matching_signature property of this SqlStats. :type exact_matching_signature: str :param force_matching_signature: The value to assign to the force_matching_signature property of this SqlStats. :type force_matching_signature: str :param io_cell_uncompressed_bytes: The value to assign to the io_cell_uncompressed_bytes property of this SqlStats. :type io_cell_uncompressed_bytes: int :param io_cell_offload_returned_bytes: The value to assign to the io_cell_offload_returned_bytes property of this SqlStats. :type io_cell_offload_returned_bytes: int :param child_number: The value to assign to the child_number property of this SqlStats. :type child_number: int :param command_type: The value to assign to the command_type property of this SqlStats. :type command_type: int :param users_opening: The value to assign to the users_opening property of this SqlStats. :type users_opening: int :param users_executing: The value to assign to the users_executing property of this SqlStats. :type users_executing: int :param optimizer_cost: The value to assign to the optimizer_cost property of this SqlStats. :type optimizer_cost: int :param full_plan_hash_value: The value to assign to the full_plan_hash_value property of this SqlStats. :type full_plan_hash_value: str :param module: The value to assign to the module property of this SqlStats. :type module: str :param service: The value to assign to the service property of this SqlStats. :type service: str :param action: The value to assign to the action property of this SqlStats. :type action: str :param sql_profile: The value to assign to the sql_profile property of this SqlStats. :type sql_profile: str :param sql_patch: The value to assign to the sql_patch property of this SqlStats. :type sql_patch: str :param sql_plan_baseline: The value to assign to the sql_plan_baseline property of this SqlStats. :type sql_plan_baseline: str :param delta_execution_count: The value to assign to the delta_execution_count property of this SqlStats. :type delta_execution_count: int :param delta_cpu_time: The value to assign to the delta_cpu_time property of this SqlStats. :type delta_cpu_time: int :param delta_io_bytes: The value to assign to the delta_io_bytes property of this SqlStats. :type delta_io_bytes: int :param delta_cpu_rank: The value to assign to the delta_cpu_rank property of this SqlStats. :type delta_cpu_rank: int :param delta_execs_rank: The value to assign to the delta_execs_rank property of this SqlStats. :type delta_execs_rank: int :param sharable_mem_rank: The value to assign to the sharable_mem_rank property of this SqlStats. :type sharable_mem_rank: int :param delta_io_rank: The value to assign to the delta_io_rank property of this SqlStats. :type delta_io_rank: int :param harmonic_sum: The value to assign to the harmonic_sum property of this SqlStats. :type harmonic_sum: int :param wt_harmonic_sum: The value to assign to the wt_harmonic_sum property of this SqlStats. :type wt_harmonic_sum: int :param total_sql_count: The value to assign to the total_sql_count property of this SqlStats. :type total_sql_count: int �str�intZdatetime)B�sql_identifier�plan_hash_value�time_collected� instance_name�last_active_time� parse_calls� disk_reads� direct_reads� direct_writes� buffer_gets�rows_processed�serializable_aborts�fetches� executions�avoided_executions�end_of_fetch_count�loads� version_count� invalidations�obsolete_count�px_servers_executions�cpu_time_in_us�elapsed_time_in_us�avg_hard_parse_time_in_us�concurrency_wait_time_in_us�application_wait_time_in_us�cluster_wait_time_in_us�user_io_wait_time_in_us�plsql_exec_time_in_us�java_exec_time_in_us�sorts� sharable_mem�total_sharable_mem�type_check_mem� io_cell_offload_eligible_bytes�io_interconnect_bytes�physical_read_requests�physical_read_bytes�physical_write_requests�physical_write_bytes�exact_matching_signature�force_matching_signature�io_cell_uncompressed_bytes� io_cell_offload_returned_bytes� child_number� command_type� users_opening�users_executing�optimizer_cost�full_plan_hash_value�module�service�action� sql_profile� sql_patch�sql_plan_baseline�delta_execution_count�delta_cpu_time�delta_io_bytes�delta_cpu_rank�delta_execs_rank�sharable_mem_rank� delta_io_rank� harmonic_sum�wt_harmonic_sum�total_sql_countZ sqlIdentifierZ planHashValueZ timeCollectedZ instanceNameZlastActiveTimeZ parseCallsZ diskReadsZ directReadsZ directWritesZ bufferGetsZ rowsProcessedZserializableAbortsr r ZavoidedExecutionsZendOfFetchCountr Z versionCountr Z obsoleteCountZpxServersExecutionsZ cpuTimeInUsZelapsedTimeInUsZavgHardParseTimeInUsZconcurrencyWaitTimeInUsZapplicationWaitTimeInUsZclusterWaitTimeInUsZuserIoWaitTimeInUsZplsqlExecTimeInUsZjavaExecTimeInUsr' Z sharableMemZtotalSharableMemZ typeCheckMemZioCellOffloadEligibleBytesZioInterconnectBytesZphysicalReadRequestsZphysicalReadBytesZphysicalWriteRequestsZphysicalWriteBytesZexactMatchingSignatureZforceMatchingSignatureZioCellUncompressedBytesZioCellOffloadReturnedBytesZ childNumberZ commandTypeZ usersOpeningZusersExecutingZ optimizerCostZfullPlanHashValuer; r< r= Z sqlProfileZsqlPatchZsqlPlanBaselineZdeltaExecutionCountZ deltaCpuTimeZ deltaIoBytesZ deltaCpuRankZdeltaExecsRankZsharableMemRankZ deltaIoRankZ harmonicSumZ wtHarmonicSumZ totalSqlCountN)DZ swagger_typesZ attribute_map�_sql_identifier�_plan_hash_value�_time_collected�_instance_name�_last_active_time� _parse_calls� _disk_reads� _direct_reads�_direct_writes� _buffer_gets�_rows_processed�_serializable_aborts�_fetches� _executions�_avoided_executions�_end_of_fetch_count�_loads�_version_count�_invalidations�_obsolete_count�_px_servers_executions�_cpu_time_in_us�_elapsed_time_in_us�_avg_hard_parse_time_in_us� _concurrency_wait_time_in_us� _application_wait_time_in_us�_cluster_wait_time_in_us�_user_io_wait_time_in_us�_plsql_exec_time_in_us�_java_exec_time_in_us�_sorts� _sharable_mem�_total_sharable_mem�_type_check_mem� _io_cell_offload_eligible_bytes�_io_interconnect_bytes�_physical_read_requests�_physical_read_bytes�_physical_write_requests�_physical_write_bytes�_exact_matching_signature�_force_matching_signature�_io_cell_uncompressed_bytes� _io_cell_offload_returned_bytes� _child_number� _command_type�_users_opening�_users_executing�_optimizer_cost�_full_plan_hash_value�_module�_service�_action� _sql_profile� _sql_patch�_sql_plan_baseline�_delta_execution_count�_delta_cpu_time�_delta_io_bytes�_delta_cpu_rank�_delta_execs_rank�_sharable_mem_rank�_delta_io_rank� _harmonic_sum�_wt_harmonic_sum�_total_sql_count)�self�kwargs� r� �=/usr/lib/python3.9/site-packages/oci/opsi/models/sql_stats.py�__init__ s� �F�EzSqlStats.__init__c C s | j S )z� **[Required]** Gets the sql_identifier of this SqlStats. Unique SQL_ID for a SQL Statement. :return: The sql_identifier of this SqlStats. :rtype: str �rK �r� r� r� r� r � s zSqlStats.sql_identifierc C s || _ dS )z� Sets the sql_identifier of this SqlStats. Unique SQL_ID for a SQL Statement. :param sql_identifier: The sql_identifier of this SqlStats. :type: str Nr� )r� r r� r� r� r � s c C s | j S )z� **[Required]** Gets the plan_hash_value of this SqlStats. Plan hash value for the SQL Execution Plan :return: The plan_hash_value of this SqlStats. :rtype: int �rL r� r� r� r� r s zSqlStats.plan_hash_valuec C s || _ dS )z� Sets the plan_hash_value of this SqlStats. Plan hash value for the SQL Execution Plan :param plan_hash_value: The plan_hash_value of this SqlStats. :type: int Nr� )r� r r� r� r� r s c C s | j S )z� **[Required]** Gets the time_collected of this SqlStats. Collection timestamp Example: `"2020-03-31T00:00:00.000Z"` :return: The time_collected of this SqlStats. :rtype: datetime �rM r� r� r� r� r s zSqlStats.time_collectedc C s || _ dS )z� Sets the time_collected of this SqlStats. Collection timestamp Example: `"2020-03-31T00:00:00.000Z"` :param time_collected: The time_collected of this SqlStats. :type: datetime Nr� )r� r r� r� r� r * s c C s | j S )z� **[Required]** Gets the instance_name of this SqlStats. Name of Database Instance Example: `"DB10902_1"` :return: The instance_name of this SqlStats. :rtype: str �rN r� r� r� r� r 7 s zSqlStats.instance_namec C s || _ dS )z� Sets the instance_name of this SqlStats. Name of Database Instance Example: `"DB10902_1"` :param instance_name: The instance_name of this SqlStats. :type: str Nr� )r� r r� r� r� r D s c C s | j S )z� Gets the last_active_time of this SqlStats. last_active_time Example: `"0000000099CCE300"` :return: The last_active_time of this SqlStats. :rtype: str �rO r� r� r� r� r Q s zSqlStats.last_active_timec C s || _ dS )z� Sets the last_active_time of this SqlStats. last_active_time Example: `"0000000099CCE300"` :param last_active_time: The last_active_time of this SqlStats. :type: str Nr� )r� r r� r� r� r ^ s c C s | j S )z� Gets the parse_calls of this SqlStats. Total integer of parse calls Example: `60` :return: The parse_calls of this SqlStats. :rtype: int �rP r� r� r� r� r k s zSqlStats.parse_callsc C s || _ dS )z� Sets the parse_calls of this SqlStats. Total integer of parse calls Example: `60` :param parse_calls: The parse_calls of this SqlStats. :type: int Nr� )r� r r� r� r� r x s c C s | j S )z� Gets the disk_reads of this SqlStats. Number of disk reads :return: The disk_reads of this SqlStats. :rtype: int �rQ r� r� r� r� r � s zSqlStats.disk_readsc C s || _ dS )z� Sets the disk_reads of this SqlStats. Number of disk reads :param disk_reads: The disk_reads of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the direct_reads of this SqlStats. Number of direct reads :return: The direct_reads of this SqlStats. :rtype: int �rR r� r� r� r� r � s zSqlStats.direct_readsc C s || _ dS )z� Sets the direct_reads of this SqlStats. Number of direct reads :param direct_reads: The direct_reads of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the direct_writes of this SqlStats. Number of Direct writes :return: The direct_writes of this SqlStats. :rtype: int �rS r� r� r� r� r � s zSqlStats.direct_writesc C s || _ dS )z� Sets the direct_writes of this SqlStats. Number of Direct writes :param direct_writes: The direct_writes of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the buffer_gets of this SqlStats. Number of Buffer Gets :return: The buffer_gets of this SqlStats. :rtype: int �rT r� r� r� r� r � s zSqlStats.buffer_getsc C s || _ dS )z� Sets the buffer_gets of this SqlStats. Number of Buffer Gets :param buffer_gets: The buffer_gets of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the rows_processed of this SqlStats. Number of row processed :return: The rows_processed of this SqlStats. :rtype: int �rU r� r� r� r� r � s zSqlStats.rows_processedc C s || _ dS )z� Sets the rows_processed of this SqlStats. Number of row processed :param rows_processed: The rows_processed of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the serializable_aborts of this SqlStats. Number of serializable aborts :return: The serializable_aborts of this SqlStats. :rtype: int �rV r� r� r� r� r � s z SqlStats.serializable_abortsc C s || _ dS )z� Sets the serializable_aborts of this SqlStats. Number of serializable aborts :param serializable_aborts: The serializable_aborts of this SqlStats. :type: int Nr� )r� r r� r� r� r s c C s | j S )z� Gets the fetches of this SqlStats. Number of fetches :return: The fetches of this SqlStats. :rtype: int �rW r� r� r� r� r s zSqlStats.fetchesc C s || _ dS )z� Sets the fetches of this SqlStats. Number of fetches :param fetches: The fetches of this SqlStats. :type: int Nr� )r� r r� r� r� r ! s c C s | j S )z� Gets the executions of this SqlStats. Number of executions :return: The executions of this SqlStats. :rtype: int �rX r� r� r� r� r - s zSqlStats.executionsc C s || _ dS )z� Sets the executions of this SqlStats. Number of executions :param executions: The executions of this SqlStats. :type: int Nr� )r� r r� r� r� r 9 s c C s | j S )a Gets the avoided_executions of this SqlStats. Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine :return: The avoided_executions of this SqlStats. :rtype: int �rY r� r� r� r� r E s zSqlStats.avoided_executionsc C s || _ dS )a Sets the avoided_executions of this SqlStats. Number of executions attempted on this object, but prevented due to the SQL statement being in quarantine :param avoided_executions: The avoided_executions of this SqlStats. :type: int Nr� )r� r r� r� r� r Q s c C s | j S )z� Gets the end_of_fetch_count of this SqlStats. Number of times this cursor was fully executed since the cursor was brought into the library cache :return: The end_of_fetch_count of this SqlStats. :rtype: int �rZ r� r� r� r� r ] s zSqlStats.end_of_fetch_countc C s || _ dS )a Sets the end_of_fetch_count of this SqlStats. Number of times this cursor was fully executed since the cursor was brought into the library cache :param end_of_fetch_count: The end_of_fetch_count of this SqlStats. :type: int Nr� )r� r r� r� r� r i s c C s | j S )z� Gets the loads of this SqlStats. Number of times the object was either loaded or reloaded :return: The loads of this SqlStats. :rtype: int �r[ r� r� r� r� r u s zSqlStats.loadsc C s || _ dS )z� Sets the loads of this SqlStats. Number of times the object was either loaded or reloaded :param loads: The loads of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the version_count of this SqlStats. Number of cursors present in the cache with this SQL text and plan :return: The version_count of this SqlStats. :rtype: int �r\ r� r� r� r� r � s zSqlStats.version_countc C s || _ dS )z� Sets the version_count of this SqlStats. Number of cursors present in the cache with this SQL text and plan :param version_count: The version_count of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the invalidations of this SqlStats. Number of times this child cursor has been invalidated :return: The invalidations of this SqlStats. :rtype: int �r] r� r� r� r� r � s zSqlStats.invalidationsc C s || _ dS )z� Sets the invalidations of this SqlStats. Number of times this child cursor has been invalidated :param invalidations: The invalidations of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the obsolete_count of this SqlStats. Number of times that a parent cursor became obsolete :return: The obsolete_count of this SqlStats. :rtype: int �r^ r� r� r� r� r � s zSqlStats.obsolete_countc C s || _ dS )z� Sets the obsolete_count of this SqlStats. Number of times that a parent cursor became obsolete :param obsolete_count: The obsolete_count of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )a Gets the px_servers_executions of this SqlStats. Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel) :return: The px_servers_executions of this SqlStats. :rtype: int �r_ r� r� r� r� r � s z SqlStats.px_servers_executionsc C s || _ dS )a/ Sets the px_servers_executions of this SqlStats. Total number of executions performed by parallel execution servers (0 when the statement has never been executed in parallel) :param px_servers_executions: The px_servers_executions of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the cpu_time_in_us of this SqlStats. CPU time (in microseconds) used by this cursor for parsing, executing, and fetching :return: The cpu_time_in_us of this SqlStats. :rtype: int �r` r� r� r� r� r � s zSqlStats.cpu_time_in_usc C s || _ dS )z� Sets the cpu_time_in_us of this SqlStats. CPU time (in microseconds) used by this cursor for parsing, executing, and fetching :param cpu_time_in_us: The cpu_time_in_us of this SqlStats. :type: int Nr� )r� r r� r� r� r � s c C s | j S )z� Gets the elapsed_time_in_us of this SqlStats. Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching. :return: The elapsed_time_in_us of this SqlStats. :rtype: int �ra r� r� r� r� r s zSqlStats.elapsed_time_in_usc C s || _ dS )a Sets the elapsed_time_in_us of this SqlStats. Elapsed time (in microseconds) used by this cursor for parsing, executing, and fetching. :param elapsed_time_in_us: The elapsed_time_in_us of this SqlStats. :type: int Nr� )r� r r� r� r� r s c C s | j S )z� Gets the avg_hard_parse_time_in_us of this SqlStats. Average hard parse time (in microseconds) used by this cursor :return: The avg_hard_parse_time_in_us of this SqlStats. :rtype: int �rb r� r� r� r� r s z"SqlStats.avg_hard_parse_time_in_usc C s || _ dS )z� Sets the avg_hard_parse_time_in_us of this SqlStats. Average hard parse time (in microseconds) used by this cursor :param avg_hard_parse_time_in_us: The avg_hard_parse_time_in_us of this SqlStats. :type: int Nr� )r� r r� r� r� r ) s c C s | j S )z� Gets the concurrency_wait_time_in_us of this SqlStats. Concurrency wait time (in microseconds) :return: The concurrency_wait_time_in_us of this SqlStats. :rtype: int �rc r� r� r� r� r! 5 s z$SqlStats.concurrency_wait_time_in_usc C s || _ dS )z� Sets the concurrency_wait_time_in_us of this SqlStats. Concurrency wait time (in microseconds) :param concurrency_wait_time_in_us: The concurrency_wait_time_in_us of this SqlStats. :type: int Nr� )r� r! r� r� r� r! A s c C s | j S )z� Gets the application_wait_time_in_us of this SqlStats. Application wait time (in microseconds) :return: The application_wait_time_in_us of this SqlStats. :rtype: int �rd r� r� r� r� r" M s z$SqlStats.application_wait_time_in_usc C s || _ dS )z� Sets the application_wait_time_in_us of this SqlStats. Application wait time (in microseconds) :param application_wait_time_in_us: The application_wait_time_in_us of this SqlStats. :type: int Nr� )r� r" r� r� r� r" Y s c C s | j S )z� Gets the cluster_wait_time_in_us of this SqlStats. Cluster wait time (in microseconds). This value is specific to Oracle RAC :return: The cluster_wait_time_in_us of this SqlStats. :rtype: int �re r� r� r� r� r# e s z SqlStats.cluster_wait_time_in_usc C s || _ dS )a Sets the cluster_wait_time_in_us of this SqlStats. Cluster wait time (in microseconds). This value is specific to Oracle RAC :param cluster_wait_time_in_us: The cluster_wait_time_in_us of this SqlStats. :type: int Nr� )r� r# r� r� r� r# q s c C s | j S )z� Gets the user_io_wait_time_in_us of this SqlStats. User I/O wait time (in microseconds) :return: The user_io_wait_time_in_us of this SqlStats. :rtype: int �rf r� r� r� r� r$ } s z SqlStats.user_io_wait_time_in_usc C s || _ dS )z� Sets the user_io_wait_time_in_us of this SqlStats. User I/O wait time (in microseconds) :param user_io_wait_time_in_us: The user_io_wait_time_in_us of this SqlStats. :type: int Nr� )r� r$ r� r� r� r$ � s c C s | j S )z� Gets the plsql_exec_time_in_us of this SqlStats. PL/SQL execution time (in microseconds) :return: The plsql_exec_time_in_us of this SqlStats. :rtype: int �rg r� r� r� r� r% � s z SqlStats.plsql_exec_time_in_usc C s || _ dS )z� Sets the plsql_exec_time_in_us of this SqlStats. PL/SQL execution time (in microseconds) :param plsql_exec_time_in_us: The plsql_exec_time_in_us of this SqlStats. :type: int Nr� )r� r% r� r� r� r% � s c C s | j S )z� Gets the java_exec_time_in_us of this SqlStats. Java execution time (in microseconds) :return: The java_exec_time_in_us of this SqlStats. :rtype: int �rh r� r� r� r� r& � s z SqlStats.java_exec_time_in_usc C s || _ dS )z� Sets the java_exec_time_in_us of this SqlStats. Java execution time (in microseconds) :param java_exec_time_in_us: The java_exec_time_in_us of this SqlStats. :type: int Nr� )r� r& r� r� r� r& � s c C s | j S )z� Gets the sorts of this SqlStats. Number of sorts that were done for the child cursor :return: The sorts of this SqlStats. :rtype: int �ri r� r� r� r� r' � s zSqlStats.sortsc C s || _ dS )z� Sets the sorts of this SqlStats. Number of sorts that were done for the child cursor :param sorts: The sorts of this SqlStats. :type: int Nr� )r� r' r� r� r� r' � s c C s | j S )z� Gets the sharable_mem of this SqlStats. Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan :return: The sharable_mem of this SqlStats. :rtype: int �rj r� r� r� r� r( � s zSqlStats.sharable_memc C s || _ dS )z� Sets the sharable_mem of this SqlStats. Total shared memory (in bytes) currently occupied by all cursors with this SQL text and plan :param sharable_mem: The sharable_mem of this SqlStats. :type: int Nr� )r� r( r� r� r� r( � s c C s | j S )a4 Gets the total_sharable_mem of this SqlStats. Total shared memory (in bytes) occupied by all cursors with this SQL text and plan if they were to be fully loaded in the shared pool (that is, cursor size) :return: The total_sharable_mem of this SqlStats. :rtype: int �rk r� r� r� r� r) � s zSqlStats.total_sharable_memc C s || _ dS )aE Sets the total_sharable_mem of this SqlStats. Total shared memory (in bytes) occupied by all cursors with this SQL text and plan if they were to be fully loaded in the shared pool (that is, cursor size) :param total_sharable_mem: The total_sharable_mem of this SqlStats. :type: int Nr� )r� r) r� r� r� r) s c C s | j S )z� Gets the type_check_mem of this SqlStats. Typecheck memory :return: The type_check_mem of this SqlStats. :rtype: int �rl r� r� r� r� r* s zSqlStats.type_check_memc C s || _ dS )z� Sets the type_check_mem of this SqlStats. Typecheck memory :param type_check_mem: The type_check_mem of this SqlStats. :type: int Nr� )r� r* r� r� r� r* s c C s | j S )z� Gets the io_cell_offload_eligible_bytes of this SqlStats. Number of I/O bytes which can be filtered by the Exadata storage system :return: The io_cell_offload_eligible_bytes of this SqlStats. :rtype: int �rm r� r� r� r� r+ % s z'SqlStats.io_cell_offload_eligible_bytesc C s || _ dS )a Sets the io_cell_offload_eligible_bytes of this SqlStats. Number of I/O bytes which can be filtered by the Exadata storage system :param io_cell_offload_eligible_bytes: The io_cell_offload_eligible_bytes of this SqlStats. :type: int Nr� )r� r+ r� r� r� r+ 1 s c C s | j S )a Gets the io_interconnect_bytes of this SqlStats. Number of I/O bytes exchanged between Oracle Database and the storage system. Typically used for Cache Fusion or parallel queries :return: The io_interconnect_bytes of this SqlStats. :rtype: int �rn r� r� r� r� r, = s z SqlStats.io_interconnect_bytesc C s || _ dS )a3 Sets the io_interconnect_bytes of this SqlStats. Number of I/O bytes exchanged between Oracle Database and the storage system. Typically used for Cache Fusion or parallel queries :param io_interconnect_bytes: The io_interconnect_bytes of this SqlStats. :type: int Nr� )r� r, r� r� r� r, I s c C s | j S )a Gets the physical_read_requests of this SqlStats. Number of physical read I/O requests issued by the monitored SQL. The requests may not be disk reads :return: The physical_read_requests of this SqlStats. :rtype: int �ro r� r� r� r� r- U s z SqlStats.physical_read_requestsc C s || _ dS )a Sets the physical_read_requests of this SqlStats. Number of physical read I/O requests issued by the monitored SQL. The requests may not be disk reads :param physical_read_requests: The physical_read_requests of this SqlStats. :type: int Nr� )r� r- r� r� r� r- a s c C s | j S )z� Gets the physical_read_bytes of this SqlStats. Number of bytes read from disks by the monitored SQL :return: The physical_read_bytes of this SqlStats. :rtype: int �rp r� r� r� r� r. m s z SqlStats.physical_read_bytesc C s || _ dS )z� Sets the physical_read_bytes of this SqlStats. Number of bytes read from disks by the monitored SQL :param physical_read_bytes: The physical_read_bytes of this SqlStats. :type: int Nr� )r� r. r� r� r� r. y s c C s | j S )z� Gets the physical_write_requests of this SqlStats. Number of physical write I/O requests issued by the monitored SQL :return: The physical_write_requests of this SqlStats. :rtype: int �rq r� r� r� r� r/ � s z SqlStats.physical_write_requestsc C s || _ dS )z� Sets the physical_write_requests of this SqlStats. Number of physical write I/O requests issued by the monitored SQL :param physical_write_requests: The physical_write_requests of this SqlStats. :type: int Nr� )r� r/ r� r� r� r/ � s c C s | j S )z� Gets the physical_write_bytes of this SqlStats. Number of bytes written to disks by the monitored SQL :return: The physical_write_bytes of this SqlStats. :rtype: int �rr r� r� r� r� r0 � s z SqlStats.physical_write_bytesc C s || _ dS )z� Sets the physical_write_bytes of this SqlStats. Number of bytes written to disks by the monitored SQL :param physical_write_bytes: The physical_write_bytes of this SqlStats. :type: int Nr� )r� r0 r� r� r� r0 � s c C s | j S )z� Gets the exact_matching_signature of this SqlStats. exact_matching_signature Example: `"18067345456756876713"` :return: The exact_matching_signature of this SqlStats. :rtype: str �rs r� r� r� r� r1 � s z!SqlStats.exact_matching_signaturec C s || _ dS )z� Sets the exact_matching_signature of this SqlStats. exact_matching_signature Example: `"18067345456756876713"` :param exact_matching_signature: The exact_matching_signature of this SqlStats. :type: str Nr� )r� r1 r� r� r� r1 � s c C s | j S )z� Gets the force_matching_signature of this SqlStats. force_matching_signature Example: `"18067345456756876713"` :return: The force_matching_signature of this SqlStats. :rtype: str �rt r� r� r� r� r2 � s z!SqlStats.force_matching_signaturec C s || _ dS )z� Sets the force_matching_signature of this SqlStats. force_matching_signature Example: `"18067345456756876713"` :param force_matching_signature: The force_matching_signature of this SqlStats. :type: str Nr� )r� r2 r� r� r� r2 � s c C s | j S )a Gets the io_cell_uncompressed_bytes of this SqlStats. Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells :return: The io_cell_uncompressed_bytes of this SqlStats. :rtype: int �ru r� r� r� r� r3 � s z#SqlStats.io_cell_uncompressed_bytesc C s || _ dS )a) Sets the io_cell_uncompressed_bytes of this SqlStats. Number of uncompressed bytes (that is, size after decompression) that are offloaded to the Exadata cells :param io_cell_uncompressed_bytes: The io_cell_uncompressed_bytes of this SqlStats. :type: int Nr� )r� r3 r� r� r� r3 � s c C s | j S )z� Gets the io_cell_offload_returned_bytes of this SqlStats. Number of bytes that are returned by Exadata cell through the regular I/O path :return: The io_cell_offload_returned_bytes of this SqlStats. :rtype: int �rv r� r� r� r� r4 s z'SqlStats.io_cell_offload_returned_bytesc C s || _ dS )a Sets the io_cell_offload_returned_bytes of this SqlStats. Number of bytes that are returned by Exadata cell through the regular I/O path :param io_cell_offload_returned_bytes: The io_cell_offload_returned_bytes of this SqlStats. :type: int Nr� )r� r4 r� r� r� r4 s c C s | j S )z� Gets the child_number of this SqlStats. Number of this child cursor :return: The child_number of this SqlStats. :rtype: int �rw r� r� r� r� r5 s zSqlStats.child_numberc C s || _ dS )z� Sets the child_number of this SqlStats. Number of this child cursor :param child_number: The child_number of this SqlStats. :type: int Nr� )r� r5 r� r� r� r5 % s c C s | j S )z� Gets the command_type of this SqlStats. Oracle command type definition :return: The command_type of this SqlStats. :rtype: int �rx r� r� r� r� r6 1 s zSqlStats.command_typec C s || _ dS )z� Sets the command_type of this SqlStats. Oracle command type definition :param command_type: The command_type of this SqlStats. :type: int Nr� )r� r6 r� r� r� r6 = s c C s | j S )z� Gets the users_opening of this SqlStats. Number of users that have any of the child cursors open :return: The users_opening of this SqlStats. :rtype: int �ry r� r� r� r� r7 I s zSqlStats.users_openingc C s || _ dS )z� Sets the users_opening of this SqlStats. Number of users that have any of the child cursors open :param users_opening: The users_opening of this SqlStats. :type: int Nr� )r� r7 r� r� r� r7 U s c C s | j S )z� Gets the users_executing of this SqlStats. Number of users executing the statement :return: The users_executing of this SqlStats. :rtype: int �rz r� r� r� r� r8 a s zSqlStats.users_executingc C s || _ dS )z� Sets the users_executing of this SqlStats. Number of users executing the statement :param users_executing: The users_executing of this SqlStats. :type: int Nr� )r� r8 r� r� r� r8 m s c C s | j S )z� Gets the optimizer_cost of this SqlStats. Cost of this query given by the optimizer :return: The optimizer_cost of this SqlStats. :rtype: int �r{ r� r� r� r� r9 y s zSqlStats.optimizer_costc C s || _ dS )z� Sets the optimizer_cost of this SqlStats. Cost of this query given by the optimizer :param optimizer_cost: The optimizer_cost of this SqlStats. :type: int Nr� )r� r9 r� r� r� r9 � s c C s | j S )z� Gets the full_plan_hash_value of this SqlStats. Total Number of rows in SQLStats table :return: The full_plan_hash_value of this SqlStats. :rtype: str �r| r� r� r� r� r: � s z SqlStats.full_plan_hash_valuec C s || _ dS )z� Sets the full_plan_hash_value of this SqlStats. Total Number of rows in SQLStats table :param full_plan_hash_value: The full_plan_hash_value of this SqlStats. :type: str Nr� )r� r: r� r� r� r: � s c C s | j S )z� Gets the module of this SqlStats. Module name :return: The module of this SqlStats. :rtype: str �r} r� r� r� r� r; � s zSqlStats.modulec C s || _ dS )z� Sets the module of this SqlStats. Module name :param module: The module of this SqlStats. :type: str Nr� )r� r; r� r� r� r; � s c C s | j S )z� Gets the service of this SqlStats. Service name :return: The service of this SqlStats. :rtype: str �r~ r� r� r� r� r< � s zSqlStats.servicec C s || _ dS )z� Sets the service of this SqlStats. Service name :param service: The service of this SqlStats. :type: str Nr� )r� r< r� r� r� r< � s c C s | j S )a Gets the action of this SqlStats. Contains the name of the action that was executing when the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_ACTION :return: The action of this SqlStats. :rtype: str �r r� r� r� r� r= � s zSqlStats.actionc C s || _ dS )a Sets the action of this SqlStats. Contains the name of the action that was executing when the SQL statement was first parsed, which is set by calling DBMS_APPLICATION_INFO.SET_ACTION :param action: The action of this SqlStats. :type: str Nr� )r� r= r� r� r� r= � s c C s | j S )z� Gets the sql_profile of this SqlStats. SQL profile used for this statement, if any :return: The sql_profile of this SqlStats. :rtype: str �r� r� r� r� r� r> � s zSqlStats.sql_profilec C s || _ dS )z� Sets the sql_profile of this SqlStats. SQL profile used for this statement, if any :param sql_profile: The sql_profile of this SqlStats. :type: str Nr� )r� r> r� r� r� r> � s c C s | j S )z� Gets the sql_patch of this SqlStats. SQL patch used for this statement, if any :return: The sql_patch of this SqlStats. :rtype: str �r� r� r� r� r� r? s zSqlStats.sql_patchc C s || _ dS )z� Sets the sql_patch of this SqlStats. SQL patch used for this statement, if any :param sql_patch: The sql_patch of this SqlStats. :type: str Nr� )r� r? r� r� r� r? s c C s | j S )z� Gets the sql_plan_baseline of this SqlStats. SQL plan baseline used for this statement, if any :return: The sql_plan_baseline of this SqlStats. :rtype: str �r� r� r� r� r� r@ ! s zSqlStats.sql_plan_baselinec C s || _ dS )z� Sets the sql_plan_baseline of this SqlStats. SQL plan baseline used for this statement, if any :param sql_plan_baseline: The sql_plan_baseline of this SqlStats. :type: str Nr� )r� r@ r� r� r� r@ - s c C s | j S )z� Gets the delta_execution_count of this SqlStats. Number of executions for the cursor since the last AWR snapshot :return: The delta_execution_count of this SqlStats. :rtype: int �r� r� r� r� r� rA 9 s z SqlStats.delta_execution_countc C s || _ dS )z� Sets the delta_execution_count of this SqlStats. Number of executions for the cursor since the last AWR snapshot :param delta_execution_count: The delta_execution_count of this SqlStats. :type: int Nr� )r� rA r� r� r� rA E s c C s | j S )z� Gets the delta_cpu_time of this SqlStats. CPU time (in microseconds) for the cursor since the last AWR snapshot :return: The delta_cpu_time of this SqlStats. :rtype: int �r� r� r� r� r� rB Q s zSqlStats.delta_cpu_timec C s || _ dS )z� Sets the delta_cpu_time of this SqlStats. CPU time (in microseconds) for the cursor since the last AWR snapshot :param delta_cpu_time: The delta_cpu_time of this SqlStats. :type: int Nr� )r� rB r� r� r� rB ] s c C s | j S )a Gets the delta_io_bytes of this SqlStats. Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot :return: The delta_io_bytes of this SqlStats. :rtype: int �r� r� r� r� r� rC i s zSqlStats.delta_io_bytesc C s || _ dS )a Sets the delta_io_bytes of this SqlStats. Number of I/O bytes exchanged between the Oracle database and the storage system for the cursor since the last AWR snapshot :param delta_io_bytes: The delta_io_bytes of this SqlStats. :type: int Nr� )r� rC r� r� r� rC u s c C s | j S )z� Gets the delta_cpu_rank of this SqlStats. Rank based on CPU Consumption :return: The delta_cpu_rank of this SqlStats. :rtype: int �r� r� r� r� r� rD � s zSqlStats.delta_cpu_rankc C s || _ dS )z� Sets the delta_cpu_rank of this SqlStats. Rank based on CPU Consumption :param delta_cpu_rank: The delta_cpu_rank of this SqlStats. :type: int Nr� )r� rD r� r� r� rD � s c C s | j S )z� Gets the delta_execs_rank of this SqlStats. Rank based on number of execution :return: The delta_execs_rank of this SqlStats. :rtype: int �r� r� r� r� r� rE � s zSqlStats.delta_execs_rankc C s || _ dS )z� Sets the delta_execs_rank of this SqlStats. Rank based on number of execution :param delta_execs_rank: The delta_execs_rank of this SqlStats. :type: int Nr� )r� rE r� r� r� rE � s c C s | j S )z� Gets the sharable_mem_rank of this SqlStats. Rank based on sharable memory :return: The sharable_mem_rank of this SqlStats. :rtype: int �r� r� r� r� r� rF � s zSqlStats.sharable_mem_rankc C s || _ dS )z� Sets the sharable_mem_rank of this SqlStats. Rank based on sharable memory :param sharable_mem_rank: The sharable_mem_rank of this SqlStats. :type: int Nr� )r� rF r� r� r� rF � s c C s | j S )z� Gets the delta_io_rank of this SqlStats. Rank based on I/O Consumption :return: The delta_io_rank of this SqlStats. :rtype: int �r� r� r� r� r� rG � s zSqlStats.delta_io_rankc C s || _ dS )z� Sets the delta_io_rank of this SqlStats. Rank based on I/O Consumption :param delta_io_rank: The delta_io_rank of this SqlStats. :type: int Nr� )r� rG r� r� r� rG � s c C s | j S )z� Gets the harmonic_sum of this SqlStats. Harmonic sum based on ranking parameters :return: The harmonic_sum of this SqlStats. :rtype: int �r� r� r� r� r� rH � s zSqlStats.harmonic_sumc C s || _ dS )z� Sets the harmonic_sum of this SqlStats. Harmonic sum based on ranking parameters :param harmonic_sum: The harmonic_sum of this SqlStats. :type: int Nr� )r� rH r� r� r� rH � s c C s | j S )z� Gets the wt_harmonic_sum of this SqlStats. Weight based harmonic sum of ranking parameters :return: The wt_harmonic_sum of this SqlStats. :rtype: int �r� r� r� r� r� rI � s zSqlStats.wt_harmonic_sumc C s || _ dS )z� Sets the wt_harmonic_sum of this SqlStats. Weight based harmonic sum of ranking parameters :param wt_harmonic_sum: The wt_harmonic_sum of this SqlStats. :type: int Nr� )r� rI r� r� r� rI s c C s | j S )z� Gets the total_sql_count of this SqlStats. Total number of rows in SQLStats table :return: The total_sql_count of this SqlStats. :rtype: int �r� r� r� r� r� rJ s zSqlStats.total_sql_countc C s || _ dS )z� Sets the total_sql_count of this SqlStats. Total number of rows in SQLStats table :param total_sql_count: The total_sql_count of this SqlStats. :type: int Nr� )r� rJ r� r� r� rJ s c C s t | �S �N)r r� r� r� r� �__repr__) s zSqlStats.__repr__c C s |d u r dS | j |j kS )NF)�__dict__�r� �otherr� r� r� �__eq__, s zSqlStats.__eq__c C s | |k S r� r� r� r� r� r� �__ne__2 s zSqlStats.__ne__N)L�__name__� __module__� __qualname__�__doc__r� �propertyr �setterr r r r r r r r r r r r r r r r r r r r r r r r! r" r# r$ r% r& r' r( r) r* r+ r, r- r. r/ r0 r1 r2 r3 r4 r5 r6 r7 r8 r9 r: r; r< r= r> r? r@ rA rB rC rD rE rF rG rH rI rJ r� r� r� r� r� r� r� r s ^ r N)Zoci.utilr r r Zoci.decoratorsr �objectr r� r� r� r� �<module> s
cải xoăn