暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
03_03_Optimizer_Exercise_OCI.pdf
15
32页
2次
2025-04-03
免费下载
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
RWP Training Optimizer Hands-On Exercise
This hands-on exercise is a step by step guide which will guide you through
resolving issues preventing the optimizer from choosing the optimal
execution plans for a set of queries.
Overview
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
RWP Training Optimizer Hands-On Exercise
1. ssh into the OCI server using putty ssh command line or ssh command from macOS or Linux as the
optXX user
a. Refer to OPT_User_Assignment.pdf on OLL for your assigned optXX ssh user .
b. Refer to the OPT_Connection_Details.pdf on OLL for your specific ssh connection information
2. Change directory to the opt subdirectory under your users home directory
a. $cd opt
b. All the scripts are located here
3. Login to your pdb
a. Use the sql alias which will connect to sqlplus as user opt and your assigned password
b. Therefore, at the $ prompt just type sql
To get started:
of 32
免费下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。