使用 analytics worksheets 上下文可访问工作表维护操作。
使用 show 命令可列出保存的工作表:
walu:> analytics worksheets walu:analytics worksheets> show Worksheets: WORKSHEET OWNER NAME worksheet-000 root Untitled worksheet worksheet-001 root ak.9a4c3d7b-50c5-6eb9-c2a6-ec9808ae1cd8.tar.gz8:27 event
要查看有关某个工作表的更多详细信息,请选择该工作表并使用 show 命令。在此示例中,以 CSV 格式从保存的工作表转储和检索了其中一种统计信息:
walu:analytics worksheets> select worksheet-000 walu:analytics worksheet-000> show Properties: uuid = e268333b-c1f0-401b-97e9-ff7f8ee8dc9b name = 830 MB/s NFSv3 disk owner = root ctime = 2009-9-4 20:04:28 mtime = 2009-9-4 20:07:24 Datasets: DATASET DATE SECONDS NAME dataset-000 2009-9-4 60 nic.kilobytes[device] dataset-001 2009-9-4 60 io.bytes[op] walu:analytics worksheet-000> select dataset-000 csv Time (UTC),KB per second 2009-09-04 20:05:38,840377 2009-09-04 20:05:39,890918 2009-09-04 20:05:40,848037 2009-09-04 20:05:41,851416 2009-09-04 20:05:42,870218 2009-09-04 20:05:43,856288 2009-09-04 20:05:44,872292 2009-09-04 20:05:45,758496 2009-09-04 20:05:46,865732 2009-09-04 20:05:47,881704 [...]
如果要通过 SSH 使用自动化的 CLI 脚本收集分析统计信息,您可以创建包含所需统计信息的保存的工作表,然后可以进行读取。这是通过 CLI 查看 Analytics(分析)信息的一种方式;另请参见Reading Datasets。
要上载某个工作表,请选择该工作表并输入 sendbundle 命令,后跟 SR 号:
walu:analytics worksheets> select worksheet-000 walu:analytics worksheet-000> sendbundle 3-7596250401 A support bundle is being created and sent to Oracle. You will receive an alert when the bundle has finished uploading. Please save the following filename, as Oracle support personnel will need it in order to access the bundle: /upload/issue/3-7596250401/3-7596250401_ak.9a4c3d7b-50c5-6eb9-c2a6-ec9808ae1cd8.tar.gz walu:analytics worksheet-000>
要从工作表中删除数据集,请选择工作表并输入 remove dataset-xxx 命令以删除所需的数据集。
walu:analytics worksheets> select worksheet-000 walu:analytics worksheet-000> list DATASET DATE SECONDS NAME dataset-000 2009-9-4 60 nic.kilobytes[device] dataset-001 2009-9-4 60 io.bytes[op] walu:analytics worksheet-000> remove dataset-001 This will remove "dataset-001". Are you sure? (Y/N) Y walu:analytics worksheet-000> list DATASET DATE SECONDS NAME dataset-000 2009-9-4 60 nic.kilobytes[device]