Active requests on Exadata cell node

Ahmet Duru?z Ahmet Duru?z

Ahmet Duru?z

Senior Oracle , PostgreSQL , MySQL DBA | Instructor | Exadata Administrator | Oracle ACE ??

发布日期: 2023年5月19日
+ 关注

An active request represents a client- or application-centric view of I/O requests handled by the cell node.?You can view active requests on a cell node as follows.

It is possible to view active requests with cellcli on the relevant cellnode.?We can view all active requests with the following command. 

CellCLI> LIST ACTIVEREQUEST

The following command can be used to view active requests in detail.

领英推荐

CellCLI> LIST ACTIVEREQUEST DETAIL

The following command can be used for detailed information about a specific request. 

CellCLI> LIST ACTIVEREQUEST istek_adi DETAIL

The output of the commands will be as follows. 

CellCLI> LIST ACTIVEREQUEST
	 2082	 	 ORCL    	 Datafile	 "BufferCache Read"         	 CacheGet           	 "Queued for Disk Read"
	 2092	 	 ORCL    	 Datafile	 "BufferCache Read"         	 CacheGet           	 "Network Receive"
	 2086	 	 ORCL    	 Datafile	 "BufferCache Read"         	 CacheGet           	 "Queued for Disk Read"
	 2088	 	 ORCL    	 Datafile	 "Selftune Checkpoint Write"	 CachePut           	 "Queued for Disk Write"
	 0   	 	 ORCL    	         	 "Smart scan"               	 "Predicate Pushing"	 "Queued for Predicate Disk"
	 0   	 	 ORCL    	         	 "Smart scan"               	 "Predicate Pushing"	 "Queued for Predicate Disk"
	 0   	 	 TESTDB	         	 	 "Smart scan"               	 "Predicate Pushing"	 "Queued for Predicate Disk"
	 0   	 	 TESTDB	         	     "Smart scan"               	 "Predicate Pushing"	 "Queued for Predicate Disk"
	 0   	 	 TESTDB	         	     "Smart scan"               	 "Predicate Pushing"	 "Queued for Predicate Disk"
	 0   	 	 ORCL    	         	 "Smart scan"               	 "Predicate Pushing"	 "Queued for Predicate Disk"
	 0   	 	 ORCL    	         	 "Smart scan"               	 "Predicate Pushing"	 "Queued for Predicate Disk"
	 0   	 	 ORCL    	         	 "Smart scan"               	 "Predicate Pushing"	 "Queued for Predicate Disk"

CellCLI> LIST ACTIVEREQUEST 2082 DETAIL
	 name:                   2082
	 asmDiskGroupNumber:     1
	 asmFileIncarnation:     943569601
	 asmFileNumber:          366
	 consumerGroupID:        12553
	 consumerGroupName:      
	 dbID:                   2857344077
	 dbName:                 ORCL
	 dbRequestID:            2082
	 fileType:               Datafile
	 id:                     2082
	 instanceNumber:         2
	 ioBytes:                8192
	 ioBytesSofar:           0
	 ioGridDisk:             DATA_EXA1_CD_06_exa1celadm10
	 ioOffset:               3267212432
	 ioReason:               "BufferCache Read"
	 ioType:                 CacheGet
	 objectNumber:           203488
	 parentID:               2082
	 pdbID:                  0
	 requestState:           "Queued for Disk Read"
	 sessionID:              1391
	 sessionSerNumber:       7060
	 sqlID:                  4hjn0cn32ar44
	 tableSpaceNumber:       8

要查看或添加评论，请登录

Ahmet Duru?z的更多文章

  • Exadata - Disk scrubbing
    2023年5月23日

    Exadata - Disk scrubbing

    Disk scrubbing exists on Exadata cell nodes to automatically repair bad sectors of the disk when the system is idle…

  • How to determine the last modified date of tables in Oracle ?
    2023年5月23日

    How to determine the last modified date of tables in Oracle ?

    For each row in a table, ORA_ROWSCN returns the SCN of the most recent change in the row. This pseudo-column can be…

  • Oracle Data Redaction
    2023年5月23日

    Oracle Data Redaction

    Available with the Oracle Advanced Security license, Oracle Data Redaction allows you to mask (redact) data returned…

  • SQL Tuning Health-Check Script (SQLHC)
    2023年5月19日

    SQL Tuning Health-Check Script (SQLHC)

    Also known as SQLHC, this tool is used to check the environment in which a single SQL statement is running, Cost-based…

  • Principle of Least Privilege for Oracle databases
    2023年5月19日

    Principle of Least Privilege for Oracle databases

    An important concept in computer security, the principle of least privilege (POLP) is to limit users' access rights to…

  • Read Only Table Partitions
    2023年5月19日

    Read Only Table Partitions

    As of Oracle version 12.2, partitions or sub-partitions of a table can be marked as read-only.

  • Hybrid Columnar Compression
    2023年5月19日

    Hybrid Columnar Compression

    Hybrid Columnar Compression (HCC) is a feature that comes with Oracle Database 11g Release 2 and can be used with…

  • Usefully My Oracle Support (MOS) documentation on Oracle Exadata Database Machine
    2023年5月19日

    Usefully My Oracle Support (MOS) documentation on Oracle Exadata Database Machine

    There are MOS documents on many topics related to Exadata. You can find the most useful of these documents in the list…

社区洞察

其他会员也浏览了