• 博客(487)
  • 资源 (11)
  • 问答 (1)
  • 收藏
  • 关注

原创 Good idea of English learning

We can use:Test your English - Every level and every skillComparative and superlative adjectives and adverbs - Test-English 40个中文在线教学资源汇总_Quizlet

2023-10-22 19:43:59 162

原创 解决Coursera 课程无法播放问题

【代码】解决Coursera 课程无法播放问题。

2023-07-25 09:51:24 397

原创 Gamification Learning with Genially

Genially, the platform for interactive animated contentMake interactive presentations, animated infographics, multimedia e-learning materials and other beautiful content for free in Genially.https://genial.lyThere is the tool for designing interactive slid

2023-04-16 22:07:15 136

原创 英文写作中的常用的衔接词

1. 增补2.比较3. 对照

2023-02-14 11:08:47 495

原创 不同词性常见词

情态动词:can, chould ,shall ,should,will,would ,must。人称代词:you ,he ,we, his, her, me , him, us, them。连词:as , so, but ,or, and ,than, that\。be 动词: be, am,is , are ,was,were。介词: at, of., till,to ,for, from。助动词:do,. does, have ,has ,had。不定代词:some,any, an,such。

2023-02-14 10:51:04 83

转载 Job description of Data scientist 大数据科学家职责

大数据科学家(Data scientist)主要负责:研究数据(Study Data),利用数据解决问题,不需要是PhD,只需要投入时间并拥有对数据分析的兴趣!第一步,Observe,数据可视化 第二步,make prediction,建模并预测 第三步,Test,测试模型 第四步,Update:bad move, 迭代更新 数据科学家的主要工具是:Python 最有效的学习方法:Learning By Doing 在学习过程中,把代码/项目发布到Github中去,因为:Github =

2022-04-20 19:04:32 202

原创 Shell 和 Python 分别 实现工作组号匹配不重复考场号

#!/bin/bashMatch_GroupID_ClassroomID(){ ExamClassRoom_Start_Num=$1 ExamClassRoom_End_Num=$2 Officer_Start_GroupID=$3 echo " ExamClassRoom_Start_Num is ${ExamClassRoom_Start_Num} ExamClassRoom_End_Num is ${ExamClassRoom_End_Num...

2021-06-16 16:04:04 130

转载 Mac 安装Jupyter Notebook和使用Jupyter Notebook


2021-06-09 17:19:33 451

原创 【解决】如何将照片从iphone导入到MAC 外置硬盘


2021-05-07 17:48:16 2026

原创 Flashback on ADG

Flashback on ADGFlashback on primary, standby will automatically flashback19c (New Feature) : Automatic flashback on standby (CDB) when flashback on primary (CDB) done and DB open with reset-logs (Doc ID 2465585.1) -- The COMPATIBLE initializat..

2021-03-12 15:15:36 152

原创 Linux上计算每个目录下内容占得空间大小

du -h -x --max-depth=1 # x: skip directories on different file systems

2021-03-10 13:54:15 154

原创 【解决】移动硬盘被MAC电脑识别为只读盘


2021-03-10 11:11:35 5051

原创 Relocate PDB from 18C to 19C

Steps1.Relocate PDB from 18C to 19C2.Upgrade PDB on 19C side3.Open Relocated PDB on 19C side.4.Wait for 10 mins to check if there is block corruption on relocated PDB on 19C sideEnvironment :source DB: 18CTarget DB: 19CSource DB: ATarget DB.

2021-03-03 21:31:57 210 1

转载 常用的Oracle x$ Tables

x$bhInformation onbuffer headers.Contains a record (the buffer header) for each block in thebuffer cache.This select statement lists how many blocks are Available, Free and Being Used.<span style="color:#444444">select count(*), State fro..

2021-02-03 21:28:02 258

原创 Calculate Elapsed Time shell script(计算消耗时间)

当我们用spool log的方式记录RMAN的输出,计算该输出里所有Elapsed Time的时间和:Here is Calculate Time shell script :=========================================================#!/bin/shlogfile=$1grep elapsed $logfile |awk -F " " '{print $NF}' > /tmp/timeList;...

2021-02-02 11:36:34 162

原创 ORACLE: Create block chain table and insert into data

Create Block Chain tablesqlplus / as sysdba <<EOFset echo on;set feedback on;select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;col name form a20;select inst_id,name,open_mode from gv\$pdbs where name='${tpdb}';alter session set cont.

2021-02-01 15:11:31 121

原创 在指定文本中向指定变量所在的行后追加关键词 shell 实现

$ cat a.txt1.Anna2.you3.hihi, welcome$ cat d.sh#!/bin/shexport keyword=hihiawk -vn=2 -vm=1 -v bctvar="$keyword" 'BEGIN{FS=OFS=" "}$n=="#linux64"{$m=bctvar}1' label.txt >tmp.logcat tmp.log$ bash d.sh1.wo2.you3.hihi, welcome #linu...

2021-01-19 16:21:14 427

原创 计算数据库大小

1. 计算数据库里所有数据文件大小总和:SQL> SELECT SUM (bytes)/1024/1024/1024 as GB FROM cdb_data_files; GB----------29.79101562.

2021-01-13 19:33:46 599

原创 Oracle 19C CDB操作课程笔记

##########################监听检查lsnrctl start listenerlsnrctl start listener2启动cdb1和cdb2export ORACLE_SID=cdb1sqlplus '/as sysdba'startupexitexport ORACLE_SID=cdb2sqlplus '/as sysdba'startupexitcdb1注册到listenercdb2注册到listener2lsnrctl status

2021-01-07 16:53:04 1280

原创 PyCharm 2018.2 汉化指南 MAC版

我自己在MAC 上试验过,是可以汉化的。分享一下汉化经验:下载resources_cn.jar :下载地址:https://download.csdn.net/download/mygodhome/137069121.点击”访达“ --> 选择 ”应用程序“2. 选择 “PyCharm" app :3. 右单击 PyCharm CE, 选择 ”显示包含内容“4.点击 “Contents"目录5. 点击 "lib"目录6. 将下载的 resourc

2020-12-16 22:29:49 264

原创 如何在RAC上执行Drop database

在10G之前我们如果要删除一个DB的方法:1) 通过DBCA图形界面,去Delete DB2)用命令行在操作系统级别删除掉数据库的所有物理文件。但是从10g开始ORACLE提供DROP DATABASE语法用来删除数据库。在RAC上不过DROP DATABASE还是有一定的限制条件的: 停掉非第一节点上的DB instance 在第一节点: 关闭数据库SQL> shutdown immediate;以exclusive模式mount第二个实例,并enab...

2020-12-07 17:20:12 353

原创 Create refreshable PDB on 19C

1)On both source side and target side: Grant permission—————————————————————————grant execute on sys.DBMS_SQL to system container=all;grantselect any table to system container=all;grant sysdba to system CONTAINER=ALL;GRANT CREATE SESSION, RESO..

2020-11-27 11:25:18 185

原创 Oracle DB silent install 静默安装 precheck 失败的解决方法

${ORACLE_HOME}bin/dbca -silent -createDatabase -responseFile /home/dbca.rsp -ignorePrereqFailure [WARNING] [DBT-06208] The 'DBSNMP' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends t...

2020-11-25 11:19:53 1151 1

原创 计算ASM diskgroup大小

We are adding datafile in SYSAUX tablespace.First check in the diskgroup how much free space is available to add datafile.You can see in this output we have 3 diskgroups with total size and free size.SQL> SELECT name, free_mb, total_mb, free_mb/total

2020-10-30 12:54:20 143

原创 查看linux系统重启时间历史记录

查看linux系统的开机时间/重启历史记录1、who -b命令[root@sky opt]# who -b ---查看最后一次(上次)系统启动的时间system boot Dec 27 05:062、who -r命令[root@sky opt]# who -r ---查看最后一次(上次)系统启动的时间,及运行级别run-level 5 Dec 27 05:063、last reboot命令[root@sky opt]# last rebootreboot system boot 2.

2020-10-30 11:03:10 12247

原创 Dump trace files for files between SCN range and entire redo log with specified thread#,sequence#

Dump the trace files for 84 archived log files between SCN 6725691 and 67619071. I got the following 84 archived log files fromv$archived_log between SCN 6725691 and 6761907 atPART ONE.2. And on source CDB name: cdb dump the trace files for 84 ar...

2020-10-27 15:04:46 238

原创 如何查询隐含参数的值和描述 (How To query underscore parameter in oracle database)

查询隐含参数的名字,值,及其对应的描述:check_parameter.sqlset lines 1000;col name for a30;col value for a20;col description for a20;select a.KSPPINM name,b.KSPPSTVL value , a.KSPPDESC description from x$ksppi a,x$ksppcv b where a.INDX=b.INDX and a.KSPPINM like '%&

2020-10-19 17:02:25 149

原创 SCN 详解

Oracle中的SCN(system change number)和我们的北京时间的意义是相同的,SCN是Oracle中的时间号。为什么Oracle不用时间来界定呢?我在北京时间8:00的时候执行一条DML语句,然后修改机器上的时间为7:00,再执行一条DML语句。如果用机器上的时间区分的话,那Oracle根本区分不出来这两条DML语句的执行顺序——而这一点对于Oracle是很重要的。所以它采用自己产生的SCN来区分所有操作的先后顺序。SCN设计的值很大,所以不用担心达到最大值后怎么办。可.

2020-09-28 10:16:52 1469

原创 oradebug dump library cache

Shared_Pool 是 Oracle SGA中最复杂的一部分,在分析很多 library cache 问题时,经常会用到转储命令。oradebug dump library_cache 的常用级别包括 (注意,一定要测试之后再采用,要先看看 library cache 大小,如果库缓存非常大,这个转储的日志可能会是 Huge 的):1:关键结构的统计汇总信息等级2:HASH CHAIN 信息等级4:持有对象结构 Bucket 信息,可以看到一个对象的lock,pin,mutex信息。

2020-08-07 13:49:43 171

原创 BCT query 隐含参数

List the parameter name and its value:col name for a50;col value for a20;select a.KSPPINM name,b.KSPPSTVL value from x$ksppi a,x$ksppcv b where a.INDX=b.INDX and a.KSPPINM like '%_bct%';List the value of the parameter:select KSPPSTVL from x$ks...

2020-08-03 14:53:10 306

原创 Solved: libclntsh.so.19.1: cannot open shared object file: No such file or directory

Problem decription:[oracle@Host ~]$ rman target /rman: error while loading shared libraries: libclntsh.so.19.1: cannot open shared object file: No such file or directorySolution:Solution:[oracle@Host lib]$ export LD_LIBRARY_PATH=$ORACLE_HOME...

2020-07-06 11:35:45 3195

原创 debug related sql

In alert log , we can see:-------------------------------...PDB2(5):Dynamic CPU count change - Current effective cpu count = 8PDB2(5):Recovery scanning directory /oraclebase/oradata/CDB/A96C665A2DE313D5E0531236D60AAB32/datafile/ for any matching fi...

2020-07-06 11:18:57 107

原创 Hanlaysis releted sql

Generate hanganalysis:SQL> oradebug setmypid;Statement processed.SQL> oradebug unlimit;Statement processed.SQL> oradebug -g all hanganalyze 3SQL> oradebug -g all hanganalyze 3SQL> oradebug setmypid;Statement processed.SQL> or

2020-07-06 10:47:47 200

原创 RMAN crosscheck command作用

CROSSCHECK命令: 用于核对磁盘和磁带上的备份文件,以确保RMAN资料库与备份文件保持同步。注意:该命令只会检查RMAN资料库所记载的备份文件。当执行crosscheck命令时,如果资料库记录不匹配于备份文件的物理状态,那么该命令会更新资料库记录的状态信息。备份文件的状态包括:AVALIABLE、UNAVALIABLE、EXPIRED。 1、核对所有备份集 RMAN> crosscheck backup; 2、核对所有数据文件的备份集 RMAN...

2020-05-22 15:50:31 210

原创 How To Catalog Backups / Archivelogs / Datafile Copies / Controlfile Copies in Oracle Database

TheRMAN CATALOGcommand is used to accomplish the following:Add backup pieces and image copies on disk to the RMAN repository. Record a datafile copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incr..

2020-05-18 09:28:30 134

原创 backup corrupted datafile as copy check V$COPY_CORRUPTION 

https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1051.htmV$COPY_CORRUPTION :Physical datafile block corrupted.Then backup the corrupted datafile:dba:bk $ rman target /c...

2020-04-27 18:53:21 228

原创 收集Oracle备份恢复信息

收集Oracle备份恢复信息rman target /spool log to rman_report.logset echo onshow all;report schema;list incarnation;list backup summary;list backup;list copy;report need backup;report obsolete;...

2020-04-27 18:48:54 182

原创 How to set and remove event value on oracle

Set mutiple event:alter system set event='10335 trace name context forever,level 1:10235 trace name context forever,level 2:600 trace name heapdump level 1025:7445 trace name heapdump level 1025:650...

2020-04-24 16:33:20 124

原创 已解决:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

oracle@hostA:admin $ rman target sys/<passwd>@cdbRecovery Manager: Release - Development on Wed Apr 8 06:19:36 2020Version =============================...

2020-04-08 22:50:30 731

原创 怎用oradebug生成call stack - Using oradebug to dump call stack

Using “oradebug dump errorstack <dump level>” one can dump the call stack of the process after attaching to a running session. There are 3 values that can be passed as dump level0 – dump error ...

2020-03-31 10:31:06 218




BBS 论坛系统需求分析




my pc have to use this "WindowsXP下触控板驱动程序.exe" ,i'd rather use this pure things than 万能的那些


计算机网络课件 下载






















陈文灯2007年数学复习指南,from XML,电子版,题和答案及分析


TA创建的收藏夹 TA关注的收藏夹


取消 删除