The sequence of the learning ORACLE.

最新推荐文章于 2025-12-05 12:37:18 发布
最新推荐文章于 2025-12-05 12:37:18 发布 · 81 阅读 · 0
文章标签：

#数据库

本文提供了一条从SQL到高可用性的Oracle学习路径，并分享了作者的经验。建议初学者按顺序学习SQL、PL/SQL、数据库架构、备份恢复、性能调优及高可用性，通过1000小时的学习掌握Oracle。

<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->

The sequence of the learning ORACLE is as below:

SQL->PLSQL->architect->backup and recovery->performance tuning->high availability.

I recommend you to learn ORACLE according to the sequence per my past experience.

Now matter whether you want to take the certification exam or start out your first steps of DBA.

The SQL is easier than you think because it is not procedural so you need not to tell it how to do it. What you need to tell is only what you want to do including get data from the database, put data into it and modify the data that is in the database.

The SQL is general language which can be used in any relational database.

The PL SQL is procedural language of the SQL it only can be used in the ORACLE related products.

Then you can learn the database architect.

The knowing architect will help you understand the ORACLE better and can make the ORACLE at your disposal.

Understanding the architect will help you troubleshoot every problem effectively.

The backup and recovery is important for a DBA.

Knowing the backup and recovery theory and testing out every possible scenario also will help you future understanding the architect.

Performance tuning is more profound field in ORACLE.

Different people has different view and different way to do it.

The high availability is not so hard as you think.

As long as you get the change to set it up for several times you will find it is not mysterious as its conception implying.

Per the sequence I suggest and stick to learn it for 1000 hours.

You will master ORALE well.

iteye_8899
关注
Sequence to Sequence Learning with Neural Networks论文翻译
KyrieHe的博客
04-25 4233
Sequence to Sequence Learningwith Neural Networks论文翻译摘要1. 导言2. 模型3. 实验3.1 数据集详细信息3.2 解码和重新评分3.3 反转源语句3.4 训练详情3.5 并行化3.6 实验结果3.7 长句子的表现3.8 模型分析4. 相关工作5. 结论6. 致谢引用 摘要 深度神经网络是在困难的学习任务中取得卓越性能的强大模型。尽管拥有大量的...
【Active Learning - 13】总结与展望 & 参考文献的整理与分享（The End...）
Houchaoqun_XMU的博客
12-01 6208
写在前面： 本篇博文将作为“主动学习系列”博文的结尾。目前，本人在职的相关工作暂无与主动学习相关的需求。因此，之后大概率是不会再更新相关的博文了。能够分享的内容和资料，我都分享在这些博文了。希望能够对大家有帮助！ 主动学习系列博文： 【Active Learning - 00】主动学习重要资源总结、分享（提供源码的论文、一些AL相关的研究者）：https://blog.csdn.net/Ho...
迁移Oracle HR 示例 schema 到 PostgreSQL
In-Memory Computing Technology
07-08 853
现在开始一点实战。其中最小和最简单的是HR，我们就从他开始。我们也按以上顺序来迁移，并且文件名与Oracle保持一致。
学习笔记：The Best of MySQL Forum
weixin_30340745的博客
12-09 905
http://mysql.rjweb.org/bestof.html I have tagged many of the better forum threads. 'Better' is based on how good I thing the answer was. (<bias> I wrote many, but not all, of the better an...
Terraform 和 Oracle Cloud Infrastructure
In-Memory Computing Technology
12-24 1254
简介 https://oracle.github.io/learning-library/oci-library/DevOps/Terraform-and-OKE-LAB/tf_oke_hol.html#practice-2-signing-in-oci-console 过程 创建一个云实例，Image选择Oracle Cloud Developer Image. 这样terraform, oci...
验证oracle 19c单条命令恢复ADG GAP
weixin_42501331的博客
08-12 164
登录后复制 文档课题：验证oracle 19c单条命令恢复ADG GAP. 数据库：oracle 19.13 主库：IP 192.168.133.101 实例名 tmis 主机名 leo-oracle-19c 备库：IP 192.168.133.38 实例名 tmisdg 主机名 leo-19c-tmisdg ...
Getting The Hang Of IOPS v1.3
行风
05-31 1046
From: http://www.symantec.com/connect/articles/getting-hang-iops-v13 In today's enterprise, application administrators are increasingly required to be IT generalists with knowledge spanning f
flink oracle cdc实时同步（超详细）
热门推荐
阿甘兄
07-26 1万+
超详细讲解Oracle CDC实时同步
【COMP2411: Database Systems Learning Notes】
m0_66706847的博客
10-05 1619
Database Systems Learning Notes
通过主动学习生成自动机 (A Quick Survey of Active Automata Learning) - wcventure
wcventure的博客
03-13 2622
A Quick Survey of Active Automata Learning Remark 1：For Basic theoretical knowledge of the Angluin’s L* Algorithm, the interested reader can refer to this article. Remark 2：go through the article on...
IV. METHOD In this section, we first present our formulation of VLN as a multi-turn process (Section IV-A). We then describe the ActiveVLN framework (Section IV-B), which enables learning from self-generated trajectories through active ex ploration (Section IV-B.2) and employs a dynamic early stopping strategy to enhance RL training efficiency (Sec tion IV-B.3). Finally, we provide engineering details for further acceleration of RL training (Section IV-C). A. Multi-Turn Paradigm Following video-based MLLMs, most prior end-to-end VLN models adopt the single-turn paradigm (Figure 2a), where each action is predicted from the instruction and past observations: at ∼ π&theta;(at | I,V1:t). (3) In contrast, we adopt the multi-turn paradigm (Figure 2b), where actions are modeled autoregressively from both past observations and actions: at ∼ π&theta; at | I,{(Vi,ai)}t−1 i=1, Vt . (4) Fig. 1: Overview of ActiveVLN. In Stage 1, ActiveVLN performs imitation learning (IL) using expert trajectories. In Stage 2, it conducts multi-turn reinforcement learning (RL), autonomously collecting trajectories in the simulator, receiving rewards that encourage progress toward the goal, and updating the policy via GRPO. Key components, including the dynamic early-stopping strategy, scene preloading, and scene caching, are incorporated to ensure efficient training during RL. (a) Single-turn paradigm: each action is predicted from the instruction and past observations only. (b) Multi-turn paradigm: actions are generated autoregressively from the instruction, past observations, and past actions. This allows training signals from future steps to backpropagate and refine earlier predictions. (see Section V-F.2). B. ActiveVLN Framework 1) Compact Action Prediction: The raw VLN-CE action space comprises four primitive actions: FORWARD, TURN LEFT, TURN RIGHT, and STOP. Prior work augments this space by merging consecutive actions of the same type [3] [5]. For instance, three FORWARD steps (each 25cm) can be merged into a single FORWARD 75cm action. This aug mentation diversifies action granularity and shortens episode length, improving training efficiency. Building on this, we adopt action chunking to further reduce episode length, where the agent predicts up to three future actions at once rather than a single action per step. 2) Active Exploration: Since MLLMs are not pre-trained for VLN tasks, we start with imitation learning (IL) using a small number of expert demonstrations to initialize the navigation policy. The IL objective is: nt LIL = − t i=1 log P(ai t | I,H<t,a<i t ), (5) where I is the navigation instruction, H<t is the interaction history up to step t, and a<i t are the actions already generated in the current chunk. Formally, the history is: Fig. 2: Comparison between the single-turn and multi-turn paradigms. H<t ={V1,A1,V2,A2,...,Vt−1,At−1,Vt}, (6) where Vt is the observation at step t, and At = {a1 t, a2 t, . . . , ant This paradigm offers several advantages. First, it naturally enables KV-cache reuse for efficient inference. Second, while the single-turn paradigm breaks actions within the same episode into independent pieces, the multi-turn formulation allows actions to be packed together, accelerating training. Most importantly, it enables gradients associated with trajec tory outcomes to be propagated to all preceding actions. We f ind this property to be crucial for the success of RL in VLN t } is a sequence of low-level actions. IL provides a good starting point, but it has a key lim itation: the agent only learns to mimic expert trajectories. Once it encounters unfamiliar situations, it has no mechanism to recover or adapt. To overcome this, we introduce active exploration through reinforcement learning (RL). Here, the agent is no longer restricted to expert data. Instead, it can interact with the environment on its own: given an instruc tion, it predicts an action, executes it in the simulator, and observes the outcome. By repeating this loop until it issues a stop action (or an exception occurs), the agent actively generates diverse trajectories, learns from its successes and failures, and gradually improves its policy. For optimization, we use Group Relative Policy Optimiza tion (GRPO) [31]. GRPO samples G candidate trajectories for the same instruction and compares them within the group. Trajectories that perform better than the group average are reinforced, while weaker ones are suppressed. The RL objective is:  LRL = E{oi} 1 clip G G |oi| 1 |oi| t=1 min π&theta; π&theta;old Ai,t, i=1 π&theta; π&theta;old , 1 − ϵ,1 + ϵ Ai,t , (7) where oi is the i-th trajectory with length |oi|, π&theta; and π&theta;old are the new and old policies, ϵ is the clipping parameter, and Ai,t is the estimated advantage. We use a soft success reward: R=15·I(success) · dgoal 3 , (8) where dgoal is the geodesic distance to the goal. The indicator I(success) = 1 if the agent issues a valid stop within 3 meters of the goal, and 0 otherwise. In this way, the agent is no longer just imitating experts but is encouraged to explore actively, discover different ways of reaching the goal, and improve by trial and error. This self-driven learning process is the key to stronger generalization in unseen environments. 3) Dynamic Early-Stopping Strategy: Trajectory rollout time can account for over half of total RL training time, making it the primary bottleneck. We observe that exces sively long trajectories often dominate this time, and in most cases correspond to unsuccessful attempts in which the agent wanders aimlessly or explores irrelevant regions. To address this issue, we introduce a dynamic early stopping strategy that adaptively terminates unpromising rollouts. Specifically, a trajectory is stopped and marked as failed once its length exceeds a threshold Tmax, defined as: Tmax = αroll · |τ∗|, (9) where |τ∗| is the length of the oracle (expert trajectory), and αroll > 1 is a tolerance factor that specifies how much deviation from the oracle is acceptable (we set αroll = 2 in our experiments). This strategy avoids wasting computation on hopeless rollouts, while maintaining a balance between preventing excessive exploration and avoiding overly strict cutoffs, ultimately leading to more efficient training. C. Engineering Details in RL To further accelerate RL training, we adopt several tech niques: Scene caching stores frequently accessed scene data in memory, enabling faster loading when the same scene is revisited. Scene preloading pipelines scene loading with policy updates, reducing idle time during training. These techniques cut down scene-loading overhead and improve training efficiency. In addition, similar to [35], we decouple the simulator from the training server by deploying it as a standalone HTTP server, which allows scalable and parallel execution of multiple navigation environments.详细解释一下
10-25
这篇文章提出了一种新的主动视觉语言导航（ActiveVLN）框架，用于解决视觉语言导航（VLN）任务中的多步交互与训练效率问题。以下是对文中方法部分的详细解释： ### A. 多步范式（Multi-Turn Paradigm） ...
Learning to Communicate with Deep Multi-Agent Reinforcement Learning
weixin_41697507的博客
06-23 2458
Abstract We consider the problem of multiple agents sensing and acting in environments with the goal of maximising their shared utility. In these environments, agents must learn communication protocol...
matlab 交替出现,在MATLAB / Octave中创建一个递增的整数交替序列(Create an increasing integer alternating sequence in MAT...
weixin_39679664的博客
03-19 772
在MATLAB / Octave中创建一个递增的整数交替序列(Create an increasing integer alternating sequence in MATLAB / Octave)我正试图找到一种方法来创建一个如下所示的数字模式0,1,-2,3,-4,5 ....请注意：它需要达到200000，但我会将它们分成2000组 。我找到了一个似乎可以在http://oeis.org/...
NineData社区版V4.7.0发布！新增MySQL至TiDB等6条数据复制对比链路，SQL窗口新增谷歌云6种数据源类型
最新发布
云原生智能数据管理平台
12-05 665
NineData社区版V4.7.0正式发布，新增6条数据复制链路（包括MySQL至OceanBase/TiDB等5条跨源链路和1条同构链路），均支持全流程数据同步与对比功能。同时新增6种谷歌云数据源支持，优化了MongoDB内网复制和MySQL XA事务性能。该版本现已支持27种数据库迁移链路，提供包括SQL审核、结构设计等企业级DevOps能力。作为免费开源工具，NineData社区版支持Docker快速部署，具备高性能CDC同步技术，适用于数据库迁移、容灾、ETL等场景，5-10分钟即可完成安装体验。
【免费云平台部署指南】按场景选型+全维度对比（附直达地址）
分享技术干货，聚焦AI前沿科技
12-03 941
免费云平台已能覆盖从静态网站到AI模型部署的大部分场景，核心是根据项目类型（静态/后端/AI）、访问地区（国内/国外）和功能需求（数据库/容器/GPU）选择适配平台。新手建议从简单场景入手（如GitHub Pages部署博客、Hugging Face Spaces部署AI Demo），熟悉后再尝试全栈或容器化部署。
001-计算机实验报告之数据库原理实验报告
LF__plus的博客
12-02 234
001-计算机实验报告之数据库原理实验报告 一共四个实验，分别是：1、使用powerdesigner建模；2、在idea里操作数据库；3、在数据库实现多种查询，如简单查询，连接查询，嵌套查询，分组查询等；4、视图创建
向量数据库原理
qq_38895905的博客
12-04 184
day22 了解向量数据库原理（相似度检索）
python+django/flask+vue的基于协同过滤算法的体育商品推荐系统
Q_Q1963288475的博客
12-04 525
相比于传统的体育商品推荐方式，个性化智能的管理方式可以大幅提高体育商品推荐的管理效率，实现了个性化智能体育商品推荐的标准化、制度化、程序化的管理，有效地防止了体育商品推荐的随意管理， 功能主要包括首页、个人中心、用户管理、商品分类管理、商品信息管理、交流论坛、留言板、系统管理、订单管理等功能，从而实现个性化智能体育商品推荐方式，提高个性化智能体育商品推荐的效率。
Representing The Order of The Sequence Using Positional Encoding
11-02
Positional encoding is a crucial technique in models like transformers to represent the order of a sequence. In a sequence, each token's position matters as the context and meaning can change based on...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值