CURSOR_SPACE_FOR_TIME

cursor_space_for_time 参数解析
最新推荐文章于 2021-01-02 18:57:38 发布
原创 最新推荐文章于 2021-01-02 18:57:38 发布 · 2k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#sql

本文解析了数据库参数 cursor_space_for_time 的作用及其对共享 SQL 区的影响。当该参数设置为 true 时，共享 SQL 区将被固定在共享池中，从而禁用了 LRU 机制，并提供了一个参考指标 v$librarycache.reloads 字段的含义。

cursor_space_for_time:
说明: 在一个游标引用共享 SQL 区时, 确定将 SQL 区保留在共享池中还是从中按过期作废处理。
值范围: TRUE | FALSE
默认值: FALSE (过期作废)

如果设置为true引起共享SQL区被pinned在shared pool，这禁用LRU机制。常为0在v$librarycache.reloads字段提供了参考。

 

Oracle 11g dba_free_space视图查询慢解决方案——hint调整执行计划
weixin_41429228的博客
02-28 2173
ora11g中查询表空间的使用情况时需要通过dba_free_space视图来查看表空间的剩余量，但有时可能由于回收站的对象较多等原因，导致该视图查询速度较慢，本文将从其执行计划的角度分析其原因并提出一种相对实用且无风险的解决方式。
验证11g的adaptive cursor sharing
qq_33933889的博客
10-23 199
小结：当系统开启绑定变量窥测且收集了直方图时，oracle会对不同的绑定变量生成不同的子游标(但该变量必须运行至少两次)，并依据selectivity生成新的执行计划。开启绑定变量窥视功能，会在sql硬解析时窥探变量的实际值以求生成更为精确的执行计划，但是若该列数据分布极度不均，则可能适得其反，--第一个子游标已经被标识为不可共享，但若将id值重新改为6，还是可以重用。--新生成的子游标选择全表扫描，且bind_aware=Y。--生成一个新的子游标，且第一个子游标被设置为不可共享。
Using CURSOR_SPACE_FOR_TIME
翼向天开
03-21 1460
本文摘自oracle database performance tuning guide 7.3.6，一个有意思的参数CURSOR_SPACE_FOR_TIME
cursor_space_for_time释义
03-20 194
1,如未发生library cache misses,就可以配置此参数加快执行调度速度;2,默认为false3,启用为true4,此参数的作用或含义：是否为执行一个新的sql从library cache释放cursor，从而把空...
cursor_space_for_time 表示de意思
长安诗社社长@-梁瀚文- https://github.com/HevnChin https://gitee.com/HevnChin
11-30 777
<br />           根据Oracle Metalink文档 Note：565424.1，CURSOR_SPACE_FOR_TIME 参数已经被Oracle放弃。<br />最先放弃的版本是：10.2.0.5 and 11.1.0.7<br />在早期的版本中，用户可以通过设置这个参数为True，使得Oracle使用更多的Shared SQL Area去保存SQL，从而提高反复执行SQL解析的速度。<br />然而随着Oracle Mutexes Pin机制的引入，用户已经几乎不再会从这个参数中
cursor_space_for_time惹的祸。
cuanerzhen6450的博客
07-19 178
最近发现一些weblogic的连接占用内存很高，达到6、70M，而且不能释放，程序代码、sql都查了遍都没发现问题，在测试库中测试却没有这个问题，比对了测试库与生产库的参数，发现生产库把cursor_space_for_time...
DRF参数参考
weixin_50018285的博客
09-09 637
drf 参数说明
[INFO] [1758617770.493300611] [rosbag2_player]: Set rate to 1 [INFO] [1758617770.502248250] [rosbag2_player]: Adding keyboard callbacks. [INFO] [1758617770.502263263] [rosbag2_player]: Press SPACE for Pause/Resume [INFO] [1758617770.502267399] [rosbag2_player]: Press CURSOR_RIGHT for Play Next Message [INFO] [1758617770.502270690] [rosbag2_player]: Press CURSOR_UP for Increase Rate 10% [INFO] [1758617770.502273694] [rosbag2_player]: Press CURSOR_DOWN for Decrease Rate 10%
09-24
[INFO] [1630425602.000000000] [rosbag2_player]: Playing back at 2.0x real-time speed ``` 该日志显示rosbag2_player当前的回放速度是实时速度的2倍。 #### 结束信息 ```plaintext [INFO] [1630425610....
[INFO] [1754317308.361425937] [rosbag2_storage]: Opened database '/home/lizhuo/桌面/rosbag2_2025_07_20-21_54_23/rosbag2_2025_07_20-21_54_23_0.db3' for READ_ONLY. [INFO] [1754317308.361550748] [rosbag2_player]: Set rate to 1 [INFO] [1754317308.370022045] [rosbag2_player]: Adding keyboard callbacks. [INFO] [1754317308.370086872] [rosbag2_player]: Press SPACE for Pause/Resume [INFO] [1754317308.370094631] [rosbag2_player]: Press CURSOR_RIGHT for Play Next Message [INFO] [1754317308.370099983] [rosbag2_player]: Press CURSOR_UP for Increase Rate 10% [INFO] [1754317308.370104271] [rosbag2_player]: Press CURSOR_DOWN for Decrease Rate 10% [INFO] [1754317308.370591368] [rosbag2_storage]: Opened database '/home/lizhuo/桌面/rosbag2_2025_07_20-21_54_23/rosbag2_2025_07_20-21_54_23_0.db3' for READ_ONLY. 什么意思
08-05
[INFO] [rosbag2_cpp]: Adjusted start time 0.000000s with next message time 123.456789s ``` 表示系统时间与bag文件时间戳的同步调整[^2] 3. **播放进度日志** ``` [INFO] [rosbag2_transport]: Played ...
[info] Resolving ssh remote authority '10.126.62.76' (Unparsed 'ssh-remote+7b22686f73744e616d65223a2231302e3132362e36322e3736227d') (attempt #1) [info] SSH askpass server listening on port 13431 [debug] hostname: 10.126.62.76, remote platform map: {"gpu_2_docker":"linux","gpu_2":"linux","3ddeepl":"linux","z56czlojo0ebyidesnow.deepln.com":"linux","6ljh9zglyy2h0otnsnow.deepln.com":"linux","eucoyajc4giwbzmosnow.deepln.com":"linux","om2pzjd30jtcbsufsnow.deepln.com":"linux","connect.nmb1.seetacloud.com":"linux","yt4syzxevazoboq7snow.deepln.com":"linux","u4zdwqpxc8zmywy6snow.deepln.com":"linux","slxly8pxw7w1qtkrsnow.deepln.com":"linux","4cb0xbjbbvyndj2puskya100.deepln.com":"linux","v3tjcypfkl2bxpjosnow.deepln.com":"linux","10.126.62.76":"linux"} [info] Using configured platform linux for remote host 10.126.62.76 [debug] hostname: 10.126.62.76, remote server install map: {} [debug] hostname: 10.126.62.76, server port range map: {} [info] Using askpass script: c:\Users\h\.cursor\extensions\anysphere.remote-ssh-1.0.34\dist\scripts\launchSSHAskpass.bat with javascript file c:\Users\h\.cursor\extensions\anysphere.remote-ssh-1.0.34\dist\scripts\sshAskClient.js. Askpass handle: 13431 [info] Launching SSH server via shell with command: type "C:\Users\h\AppData\Local\Temp\cursor_remote_install_126ff9d9-0f0d-44a6-84ee-a667e9d1ae4e.sh" | C:\\Windows\\System32\\OpenSSH\\ssh.exe -T -F "C:\Users\h\.ssh\config" -D 13432 10.126.62.76 bash --login -c bash [info] Establishing SSH connection: type "C:\Users\h\AppData\Local\Temp\cursor_remote_install_126ff9d9-0f0d-44a6-84ee-a667e9d1ae4e.sh" | C:\\Windows\\System32\\OpenSSH\\ssh.exe -T -F "C:\Users\h\.ssh\config" -D 13432 10.126.62.76 bash --login -c bash [info] Started installation script. Waiting for it to finish... [info] Waiting for server to install. Timeout: 30000ms [info] Askpass server received request: POST / [info] Askpass server received request body: {"request":"muyingqi@10.126.62.76's password: "} [info] Pausing timeout; waiting for askpass response [info] Received SSH askpass request: muyingqi@10.126.62.76's password: [info] Resuming timeout; askpass response received [info] (ssh_tunnel) stdout: Configuring Cursor Server on Remote Using TMP_DIR: /run/user/30008 [info] (ssh_tunnel) stdout: Locking /run/user/30008/cursor-remote-lock.51997170e1f99fc2c1738b0b8567549e [info] (ssh_tunnel) stdout: Downloading server via wget from https://downloads.cursor.com/production/ab6b80c19b51fe71d58e69d8ed3802be587b3418/linux/x64/cursor-reh-linux-x64.tar.gz to cursor-server-b025ceca-2f8d-42e2-a66b-f115cfa39e03.tar.gz [info] (ssh_tunnel) stderr: --2025-10-21 11:29:54-- https://downloads.cursor.com/production/ab6b80c19b51fe71d58e69d8ed3802be587b3418/linux/x64/cursor-reh-linux-x64.tar.gz [info] (ssh_tunnel) stderr: Resolving downloads.cursor.com (downloads.cursor.com)... [info] (ssh_tunnel) stderr: 104.18.17.128, 104.18.16.128, 2606:4700::6812:1080, ... Connecting to downloads.cursor.com (downloads.cursor.com)|104.18.17.128|:443... [info] (ssh_tunnel) stderr: connected. [info] (ssh_tunnel) stdout: 33bac3c522a6c867002939a2: start exitCode==1== nodeExecutable==/home/muyingqi/.cursor-server/bin/ab6b80c19b51fe71d58e69d8ed3802be587b3410/node== multiplexListeningOn==== multiplexConnectionToken==== codeListeningOn==== errorMessage==Download failed: Error downloading server from https://downloads.cursor.com/production/ab6b80c19b51fe71d58e69d8ed3802be587b3418/linux/x64/cursor-reh-linux-x64.tar.gz== isFatalError==false== codeConnectionToken==== detectedPlatform==linux== arch==x64== SSH_AUTH_SOCK==== 33bac3c522a6c867002939a2: end [info] Server install command exit code: 1 [info] Download failed: Download failed: Error downloading server from https://downloads.cursor.com/production/ab6b80c19b51fe71d58e69d8ed3802be587b3418/linux/x64/cursor-reh-linux-x64.tar.gz. Downloading server locally and copying it over... [info] Downloading server from https://downloads.cursor.com/production/ab6b80c19b51fe71d58e69d8ed3802be587b3418/linux/x64/cursor-reh-linux-x64.tar.gz to C:\Users\h\AppData\Local\Temp\cursor-server-ea307fa6-c495-42dc-9242-804d118e44c3.tar.gz [info] (ssh_tunnel) stdout: Unlocking /run/user/30008/cursor-remote-lock.51997170e1f99fc2c1738b0b8567549e [info] (ssh_tunnel) stderr: ERROR: no certificate subject alternative name matches requested host name ‘downloads.cursor.com’. To connect to downloads.cursor.com insecurely, use `--no-check-certificate'. [info] Downloaded server locally to C:\Users\h\AppData\Local\Temp\cursor-server-ea307fa6-c495-42dc-9242-804d118e44c3.tar.gz. Copying to remote host at ~/.cursor-server/cursor-server-20ec7d73-2d05-41ea-919c-c328a112d3cf.tar.gz [info] Base64-encoding local file C:\Users\h\AppData\Local\Temp\cursor-server-ea307fa6-c495-42dc-9242-804d118e44c3.tar.gz to temp file C:\Users\h\AppData\Local\Temp\cursor_remote_copy_bf513e35-ef5f-4954-b48e-c3c11ac8a0af.b64 [info] Copying file to remote via SSH: Get-Content -Raw "C:\Users\h\AppData\Local\Temp\cursor_remote_copy_bf513e35-ef5f-4954-b48e-c3c11ac8a0af.b64" | C:\\Windows\\System32\\OpenSSH\\ssh.exe -T -F C:\Users\h\.ssh\config 10.126.62.76 "bash -c `'cat | (tr -d `"[:space:]`" || true) | (base64 -d 2>/dev/null || base64 -D || true) > `"`$HOME/.cursor-server/cursor-server-20ec7d73-2d05-41ea-919c-c328a112d3cf.tar.gz`"`'" [info] Askpass server received request: POST / [info] Askpass server received request body: {"request":"muyingqi@10.126.62.76's password: "} [info] Pausing timeout; waiting for askpass response [info] Received SSH askpass request: muyingqi@10.126.62.76's password: [info] Resuming timeout; askpass response received [info] Deleted local server file C:\Users\h\AppData\Local\Temp\cursor-server-ea307fa6-c495-42dc-9242-804d118e44c3.tar.gz [info] Successfully SCP'd server to the remote host. Reattempting to connect [info] Deleting local script C:\Users\h\AppData\Local\Temp\cursor_remote_install_126ff9d9-0f0d-44a6-84ee-a667e9d1ae4e.sh [info] Using askpass script: c:\Users\h\.cursor\extensions\anysphere.remote-ssh-1.0.34\dist\scripts\launchSSHAskpass.bat with javascript file c:\Users\h\.cursor\extensions\anysphere.remote-ssh-1.0.34\dist\scripts\sshAskClient.js. Askpass handle: 13431 [info] Launching SSH server via shell with command: type "C:\Users\h\AppData\Local\Temp\cursor_remote_install_017cfe13-0bfc-456f-a65c-b4f9f4444c73.sh" | C:\\Windows\\System32\\OpenSSH\\ssh.exe -T -F "C:\Users\h\.ssh\config" -D 10070 10.126.62.76 bash --login -c bash [info] Establishing SSH connection: type "C:\Users\h\AppData\Local\Temp\cursor_remote_install_017cfe13-0bfc-456f-a65c-b4f9f4444c73.sh" | C:\\Windows\\System32\\OpenSSH\\ssh.exe -T -F "C:\Users\h\.ssh\config" -D 10070 10.126.62.76 bash --login -c bash [info] Started installation script. Waiting for it to finish... [info] Waiting for server to install. Timeout: 30000ms [info] Askpass server received request: POST / [info] Askpass server received request body: {"request":"muyingqi@10.126.62.76's password: "} [info] Pausing timeout; waiting for askpass response [info] Received SSH askpass request: muyingqi@10.126.62.76's password: [info] Resuming timeout; askpass response received [info] (ssh_tunnel) stderr: Connection closed by 10.126.62.76 port 22 [info] (ssh_tunnel) stderr: ������ͼд��Ĺܵ������ڡ� [error] Error installing server: [Error: Failed to connect to the remote SSH host. Please check the logs for more details. at t.installCodeServer (c:\Users\h\.cursor\extensions\anysphere.remote-ssh-1.0.34\dist\main.js:2:951304) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async c:\Users\h\.cursor\extensions\anysphere.remote-ssh-1.0.34\dist\main.js:2:402760] [info] Deleting local script C:\Users\h\AppData\Local\Temp\cursor_remote_install_017cfe13-0bfc-456f-a65c-b4f9f4444c73.sh [error] Error resolving SSH authority [Error: Failed to connect to the remote SSH host. Please check the logs for more details. at t.installCodeServer (c:\Users\h\.cursor\extensions\anysphere.remote-ssh-1.0.34\dist\main.js:2:951304) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async c:\Users\h\.cursor\extensions\anysphere.remote-ssh-1.0.34\dist\main.js:2:402760]
最新发布
10-22
### 解决 SSH 连接远程主机 10.126.62.76 安装 Cursor 服务器时的问题 #### 下载失败 - **网络问题**：检查本地网络连接是否正常，尝试访问其他网站确认网络是否可用。也可以检查远程主机的网络设置，确保其网络正常...
算法设计与分析--Space-for-time tradeoffs
毛线岛民的博客
01-02 338
Two Algorithms Input Enhancement Prepocess the input(or its part) to store some info to be used later in solving the problem Counting Sorts String Searching Algorithms Preconstructuring Prepocess the input to make accessing its elements easier hashi
Oracle 游标（cursor） 说明
ijavagos
07-27 634
一. Cursor说明 Oracle里的cursor分为两种：一种是shared cursor，一种是session cursor。 1.1 Shared cursor 说明 sharedcursor就是指缓存在librarycache（SGA下的Shared Pool）里的一种library cache object，说白了就是指缓存在library cache里的sql和匿名pl/...
[20180828]关于参数cursor_space_for_time(10g).txt
08-30 136
[20180828]关于参数cursor_space_for_time(10g).txt --//昨天测试session_cached_cursors不等于0的情况下,如果会话已经缓存了游标,这样即使其它语句消耗共...
oracle10g初始化参数说明
Flora_qxy的专栏
11-14 8874
oracle10g初始化参数说明参数名： O7_DICTIONARY_ACCESSIBILITY类别：安全性和审计说明: 主要用于从 Oracle7 移植到 Oracle8i。如果该值为 TRUE, SYSTEM 权限 (如SELECT ANY TABLE) 将不限制对 SYS 方案中各对象的访问 (Oracle7 行为)。如果该值为FALSE, 只有被授予了 SELECT_CATALOG_R
oracle数据库sga用途_ORACLE之SGA介绍
weixin_39913472的博客
12-19 720
主要的参考的网址：http://www.hellodba.com/reader.php?ID=104&lang=CNhttp://8xmax.blog.163.com/blog/static/1633631020084781125726/http://blog.sina.com.cn/s/blog_4c705ccb0100anl1.html系统全局区SGA：　　SGA包含的组件：共享池(...
代码优化规则
baiwen1979的专栏
03-24 643
1、用空间换取时间规则（Space-For-Time Rules）   > 扩充数据结构。通常，通过给结构增加其他信息或改变结构内部的信息让它访问得更快能够减少对数据的常用操作所需的时间。   > 存储预先计算好的结果。只计算函数一次然后存储结果能够减少重复计算某一昂贵函数所需的成本。以后对该函数的请求就只需通过表查找来完成，而不需要重新计算该函数   > 高速缓存。必须降低经常访问的数据的访问成
链表的游标（cursor）实现
weixin_34218579的博客
03-11 341
诸如BASIC和FORTRAN等许多语言都不支持指针。如果需要链表而又不能使用指针，这时我们可以使用游标（cursor）实现法来实现链表。 在链表的实现中有两个重要的特点： 数据存储在一组结构体中。每一个结构体包含有数据以及指向下一个结构体的指针。 一个新的结构体可以通过调用malloc而从系统全局内存（global memory）得到，并可以通过free而被释放。 游标法必须能够模仿实现...
【笔记】串的模式匹配算法
time-space的博客
10-22 8815
一BF算法 BF算法思想 BF算法实现C语言 二KMP算法 KMP算法思想 next函数的算法 KMP算法的实现C语言 三模式匹配应用举例
数据结构之静态链表的游标表示及其实现（附完整代码）
大地在我脚下
08-09 5964
了解过计算机高级编程语言大家族的我们都知道，并非所有的编程语言都支持指针这种数据类型。诸如BASIC、FORTRAN等许多语言都不支持指针。如果程序中需要利用链表但是又不能使用指针，那么就只能采用类似于指针的办法。我们把这种办法称作游标实现法。在链表的指针实现中有如下两个必不可少的重要特点，那就是：
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值