Oracle trace日志报错:Warning: lio_listio returned EAGAIN

解决Oracle AIX性能警告
最新推荐文章于 2024-09-03 09:29:55 发布
原创 最新推荐文章于 2024-09-03 09:29:55 发布 · 950 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#oracle #system #aix #存储 #google #数据库

本文针对Oracle在AIX系统上出现的性能警告问题进行了解析，并提供了具体的参数调整方案来提升异步IO请求处理效率。

Oracle Trace日志报错，如下：

Warning: lio_listio returned EAGAIN
Performance degradation may be seen.
Warning: lio_listio returned EAGAIN
Performance degradation may be seen.
Warning: lio_listio returned EAGAIN
Performance degradation may be seen.
Warning: lio_listio returned EAGAIN

 

平台：AIX 5300-08-03-0831

数据库：Version 11.1.0.6.0

使用了aio：处理异步IO请求的核心进程.

以前没有出现过，只是最近增加了HDS存储，10块lun导致，google，发现高人指点出的aio参数问题

 

IBMg

 If the maxreqs value is too low, then the following Oracle warning message might be returned: Warning: lio_listio returned EAGAIN. This warning message indicates a need to increase the maxreqs value. When performing file system I/O, a maxservers value that is too low can also indirectly cause this warning message

 

修改参数：maxservers=(10 * number of logical disks / number of processors)

 

可能需要修改aio参数，察看现在的aio配置：

lsattr -El aio0

autoconfig available STATE to be configured at system restart True
fastpath   enable    State of fast path                       True
kprocprio  39        Server PRIORITY                          True
maxreqs    8192      Maximum number of REQUESTS               True
maxservers 20        MAXIMUM number of servers per cpu        True
minservers 1         MINIMUM number of servers                True

 

加上HDS存储后，lun的个数是25，cpu 8颗

lsdev -Cc processor
proc0  Available 00-00 Processor
proc2  Available 00-02 Processor
proc4  Available 00-04 Processor
proc6  Available 00-06 Processor
proc8  Available 00-08 Processor
proc10 Available 00-10 Processor
proc12 Available 00-12 Processor
proc14 Available 00-14 Processor

 

所以修改aio0参数如下：

chdev -l aio0 -P -a maxservers=40

 

在lio_sam中融入GPS
如果想成为中心，那么就到中心去吧。
12-05 958
在LIO（激光惯性里程计）系统中，将GPS信息融合到里程计中，借助GTSAM（Georgia Tech Smoothing and Mapping）库进行因子图优化，可以有效提升全局定位精度。当进入到GPS信号不好或缺失的环境中，需要借助融合后的里程计反算经纬度，来获取高精度的定位信息。利用GeographicLib第三方库将经纬度投影到局部笛卡尔坐标系中。
Oracle第十五节---Oracle中的日志
shanshan3003的专栏
09-18 2306
例如：10046：0，1，4，8，12。默认redo日志有三个，大小为50M，循环覆盖使用。redo log再覆盖之前，会被归档，形成归档日志。答：不同事件，不同级别。trace的不同级别？
Oracle EBS SQL Trace日志收集的方法
数据库天地
06-19 283
Raw Trace的收集方法 1. 打开Trace，Help > Diagnostics > Trace > Trace > Trace with Binds and Waits Trace项代表的意思 No Trace – turns trace off. Regular Trace – generates a regular SQL trace by perfo...
ORACLE中的日志
05-29 1520
Redo Log      除了与表空间联系紧密的数据文件外， Oracle还有另一个与其相关的称作Online Redo Log的操作系统文件。Redo Log也称作事务日志( Transaction Log)，Orcle在这些特殊的操作系统文件中记录针对数据库进行的修改操作或事务。对数据库所做的所有修改工作都在内存中进行， Oracle这样的处理主要是出于性能方面的考虑，因为在磁盘I／O 中操
oracle trace日志 自动查询并转换脚本
weishuxiao1的专栏
06-25 694
#!/bin/sh #oracle sql search trace file sqlplus / as sysdba startup spool /home/oracle/spool.txt SELECT value FROM v\$diag_info WHERE name='Default Trace File'; spool off exit EOF #
oracle 清理trace日志,oracle使用adrci清理日志文件（trace文件，incident文件，listener log文件）...
weixin_31001855的博客
04-10 3589
oracle中通常有好多日志文件，遇到异常情况会产生大量日志，造成磁盘空间紧张。故需要清理对应文件。包括trace文件，incident文件，listener log文件等11g中oracle提供了一个ADRCI的命令行工具来查看ADR中的alert日志和trace信息，可以批量删除对应的日志文件。adrci的位置在$ORACLE_HOME/bin目录下详细adrci介绍1.删除incident文...
oracle的trace日志迁移
alexander_phper的博客
03-04 899
#!/bin/bash #------------------------------------------------------------- # 将oracle产生的trace日志迁移至数据硬盘 #------------------------------------------------------------- # @author alexander #---------------
ubuntu@aimo-master:~/workspace/slam_map/install$ source setup.bash ubuntu@aimo-master:~/workspace/slam_map/install$ roslaunch lio_sam run.launch ... logging to /home/ubuntu/.ros/log/a20c91e0-6b8b-11f0-a519-0007328879dc/roslaunch-aimo-master-11741.log Checking log directory for disk usage. This may take a while. Press Ctrl-C to interrupt WARNING: disk usage in log directory [/home/ubuntu/.ros/log] is over 1GB. It's recommended that you use the 'rosclean' command. xacro: in-order processing became default in ROS Melodic. You can drop the option. started roslaunch server http://aimo-master:34233/ SUMMARY ======== PARAMETERS * /ekf_gps/base_link_frame: base_link * /ekf_gps/frequency: 100 * /ekf_gps/imu0: /imu * /ekf_gps/imu0_config: [False, False, Fa... * /ekf_gps/imu0_differential: False * /ekf_gps/imu0_queue_size: 50 * /ekf_gps/imu0_remove_gravitational_acceleration: True * /ekf_gps/map_frame: map * /ekf_gps/odom0: odometry/gps * /ekf_gps/odom0_config: [True, True, True... * /ekf_gps/odom0_differential: False * /ekf_gps/odom0_queue_size: 10 * /ekf_gps/odom_frame: odom * /ekf_gps/process_noise_covariance: [1.0, 0, 0, 0, 0,... * /ekf_gps/publish_tf: False * /ekf_gps/sensor_timeout: 0.01 * /ekf_gps/two_d_mode: False * /ekf_gps/world_frame: odom * /lio_sam/Horizon_SCAN: 1800 * /lio_sam/N_SCAN: 16 * /lio_sam/baselinkFrame: base_link * /lio_sam/basex: 0.0 * /lio_sam/basey: 0.0 * /lio_sam/basez: 0.0 * /lio_sam/downsampleRate: 1 * /lio_sam/edgeFeatureMinValidNum: 10 * /lio_sam/edgeThreshold: 1.0 * /lio_sam/extrinsicRPY: [1, 0, 0, 0, 1, 0... * /lio_sam/extrinsicRot: [1, 0, 0, 0, 1, 0... * /lio_sam/extrinsicTrans: [0, 0.0, 0.0] * /lio_sam/globalMapVisualizationLeafSize: 1.0 * /lio_sam/globalMapVisualizationPoseDensity: 10.0 * /lio_sam/globalMapVisualizationSearchRadius: 1000.0 * /lio_sam/gpsCovThreshold: 0.25 * /lio_sam/gpsTopic: /gps_odom * /lio_sam/historyKeyframeFitnessScore: 0.3 * /lio_sam/historyKeyframeSearchNum: 50 * /lio_sam/historyKeyframeSearchRadius: 15.0 * /lio_sam/historyKeyframeSearchTimeDiff: 60.0 * /lio_sam/imuAccBiasN: 0.000668232277397 * /lio_sam/imuAccNoise: 0.0127916818168 * /lio_sam/imuGravity: 9.80511 * /lio_sam/imuGyrBiasN: 4.43906245089e-05 * /lio_sam/imuGyrNoise: 0.000924516165897 * /lio_sam/imuRPYWeight: 0.01 * /lio_sam/imuTopic: /imu * /lio_sam/lidarFrame: base_link * /lio_sam/lidarMaxRange: 1000.0 * /lio_sam/lidarMinRange: 1.0 * /lio_sam/loopClosureEnableFlag: True * /lio_sam/loopClosureFrequency: 1.0 * /lio_sam/mapFrame: map * /lio_sam/mappingCornerLeafSize: 0.2 * /lio_sam/mappingProcessInterval: 0.15 * /lio_sam/mappingSurfLeafSize: 0.4 * /lio_sam/numberOfCores: 16 * /lio_sam/odomTopic: /odometry/imu * /lio_sam/odometryFrame: odom * /lio_sam/odometrySurfLeafSize: 0.4 * /lio_sam/pointCloudTopic: /velodyne_points * /lio_sam/poseCovThreshold: 0.05 * /lio_sam/rotation_tollerance: 0.05 * /lio_sam/savePCD: True * /lio_sam/savePCDDirectory: /workspace/pcdmap/ * /lio_sam/sensor: velodyne * /lio_sam/surfFeatureMinValidNum: 100 * /lio_sam/surfThreshold: 0.1 * /lio_sam/surroundingKeyframeDensity: 2.0 * /lio_sam/surroundingKeyframeSearchRadius: 50.0 * /lio_sam/surroundingKeyframeSize: 50 * /lio_sam/surroundingkeyframeAddingAngleThreshold: 0.2 * /lio_sam/surroundingkeyframeAddingDistThreshold: 1.0 * /lio_sam/useGpsElevation: False * /lio_sam/useImuHeadingInitialization: True * /lio_sam/z_tollerance: 0.5 * /navsat/broadcast_utm_transform: False * /navsat/broadcast_utm_transform_as_parent_frame: False * /navsat/delay: 0.0 * /navsat/frequency: 100 * /navsat/magnetic_declination_radians: 0 * /navsat/publish_filtered_gps: False * /navsat/wait_for_datum: False * /navsat/yaw_offset: 0 * /navsat/zero_altitude: True * /passthrough/filter_field_name: y * /passthrough/filter_limit_negative: True * /robot_description: <?xml version="1.... * /rosdistro: melodic * /rosversion: 1.14.13 * /use_sim_time: True NODES / lio_sam_featureExtraction (lio_sam/lio_sam_featureExtraction) lio_sam_imageProjection (lio_sam/lio_sam_imageProjection) lio_sam_imuPreintegration (lio_sam/lio_sam_imuPreintegration) lio_sam_mapOptmization (lio_sam/lio_sam_mapOptmization) lio_sam_rviz (rviz/rviz) passthrough (nodelet/nodelet) pcl_manager (nodelet/nodelet) robot_state_publisher (robot_state_publisher/robot_state_publisher) auto-starting new master process[master]: started with pid [11756] ROS_MASTER_URI=http://aimo-master:11311 setting /run_id to a20c91e0-6b8b-11f0-a519-0007328879dc process[rosout-1]: started with pid [11767] started core service [/rosout] process[pcl_manager-2]: started with pid [11774] process[passthrough-3]: started with pid [11775] RLException: Unable to launch [lio_sam_imuPreintegration-4]. If it is a script, you may be missing a '#!' declaration at the top. The traceback for the exception was written to the log file [ INFO] [1753690792.303750132]: Loading nodelet /passthrough of type pcl/PassThrough to manager pcl_manager with the following remappings: [ INFO] [1753690792.304784038]: /passthrough/input -> /driver/velodyne_points [ INFO] [1753690792.304812513]: /passthrough/output -> /velodyne_points [ INFO] [1753690792.307411190]: waitForService: Service [/pcl_manager/load_nodelet] has not been advertised, waiting... [ INFO] [1753690792.320529335]: Initializing nodelet with 8 worker threads. [lio_sam_imuPreintegration-4] killing on exit [passthrough-3] killing on exit [pcl_manager-2] killing on exit [rosout-1] killing on exit [master] killing on exit
最新发布
07-29
首先，用户的问题是关于启动LIO-SAM系统时遇到的错误：运行`roslaunch lio_sam run.launch`时出现`RLException: Unable to launch lio_sam_imuPreintegration-4`。用户需要帮助定位并解决这个异常原因。 从系统级...
start.sh: 4: roslaunch livox_ros_driver2 msg_MID360.launch: not found start.sh: 5: roslaunch fast_lio_localization localization_MID360.launch: not found start.sh: 6: rosrun fast_lio_localization publish_initial_pose.py 0 0 0 0 0 0: not found start.sh: 7: roslaunch sentry_nav sentry_movebase.launch: not found start.sh: 8: roslaunch robot_driver robot_driver.launch: not found start.sh: 9: roslaunch serial_referee referee_serial.launch: not found start.sh: 10: roslaunch logic_control logic_control.launch: not found start.sh: 11: Syntax error: ")" unexpected
03-11
- **软件包未安装**：如 `livox_ros_driver2`、`fast_lio_localization` 等包未安装或路径错误。 - **权限问题**：脚本或相关文件未赋予可执行权限。 2. **语法错误（`Syntax error: ")" unexpected`）** - ...
ros1报错RLException: [mbot_laser_nav_gazebo.launch] is not a launch file nameThe traceback for the ex
CHNNNNNNNN的博客
02-23 2649
我详细记录我遇到的问题，首先工作空间，功能包编译没有问题，已经source，然后rosluanch， roslaunch和mbot_gazebo，可以tab，但是launch文件tab不出来。期间我没有做什么修改，尝试了cd到对应的功能包的launch文件夹下，然后roslaunch这个文件，结果是能够运行gazebo，但是里面的墙不见了，只有一个空的环境和机器人模型。2、如果遇到launch文件名tab不出来，包的名称可以tab出来的，可以尝试复制launch文件名到终端中粘贴，然后运行。
投资组合：Bem-vindo ao projeto do meuportfólio:man_light_skin_tone:‍:man_light_skin_tone:
02-05
Bem-vindo ao projeto do meuportfólio:man_technologist_light_skin_tone: :briefcase: ·报告程序· nd迪斯 原始的灵魂 :information: 住宅的外观设计和外观设计，以及房屋装修。 Construido ...
Oracle日志
Gavin Blog
09-03 681
定期监控数据库的操作很重要，因为这样做，不仅可以提前通知管理员数据库存在的错误，让管理员提高警惕，同时也可以让管理员更好的理解数据库的操作。本文章著作权归作者所有，任何形式的转载都请注明出处。使用跟踪文件和告警日志监控数据库的操作。来源: Transcendent。文章作者: Gavin Wang。
oracle使用trace查看记录
enthan809882的博客
03-24 1182
查看trace文件地址： select tracefile from v$process where addr in (select paddr from v$session where sid in (select sid from v$mystat)); 开启sql_trace功能： alter session set sql_trace=true; 随便执行一句sql： select c...
oracle安装目录满了trace,查看oracle固定目录下日志和trace文件大小脚本
weixin_35545176的博客
04-03 231
python刚入门，在Oracle官网看到个小脚本，感觉挺有意思，经过测试切实可行。[oracle@ycr python]$ more 5.pyimport datetimeimport osimport sysimport timefrom pprint import pprintdef readable(size):si=('B','KB','MB','GB','TB', 'PB', 'EB'...
oracle关闭强制日志,关闭ORACLE客户端trace日志
weixin_32238157的博客
04-04 876
TRACE时的注意事项1、确保所需trace组建的配置文件存在缺省情况下，Oracle会从下列位置搜索网络配置文件a.TNS_ADMINenvironmentvariable(incl.WindowsRegistryKey)b./etcor/var/opt/oracle(Unix)c.$ORACLE_HOME/network/admin(Unix)d.%ORACLE_HOME%...
Oracle 清空Alert和Trace日志 - 待整理
lingyun1987的博客
07-01 4339
【代码】Oracle 清空Alert和Trace日志 - 待整理。
oracle使用sql关闭trace日志,Oracle SQL_TRACE使用小结
weixin_32831131的博客
04-07 772
Oracle SQL_TRACE使用小结一、关于基础表Oc_COJ^c680758rd-A6z\&[1R1] H680758Oracle10G之前，启用AUTOTRACE功能需要手工创建plan_table表，创建脚本为$ORACLE_HOME/rdbms/admin/utlxplan.sql。但在10g中，已经默认创建了PLAN_TABLE$的基表，并以public用户创建了相应的同义词...
Oracle 日志路径查询介绍
亓荼的博客
01-02 3688
节点监控是指监控集群中节点的健康状况，监控的方法是通过网络心跳(network heartbeat)和磁盘心跳（disk heartbeat）实现的，如果集群中的节点连续丢失磁盘心跳或网络心跳，该节点就会被从集群中驱逐，也就是节点重启。如果某个节点连续丢失网络心跳达到阀值，misscount（检查数据库心跳超时，默认30s：/oracle/app/19.3.0/grid/bin/crsctl get cssmisscount），集群会通过表决盘进行投票，使丢失网络心跳的节点被主节点驱逐出集群，即节点重启。
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值