Automatics Storage Management Scripts

最新推荐文章于 2014-02-25 19:07:19 发布
最新推荐文章于 2014-02-25 19:07:19 发布
阅读量1k 收藏
点赞数
分类专栏： Oracle scripts 文章标签： ASM asm Oracle scripts
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/staricqxyz/article/details/8480818
版权

displays one row for every disk discovered by the ASM instance, including disks which are not part of any disk group

SQL> set pages 50000 lines 130 echo on head on flush on veri on feed on
SQL> col PATH form a25
SQL> col GB_read for 99999
SQL> col GB_written for 9999
select PATH,
       mount_status,
       state,
       TOTAL_MB,
       FREE_MB,
       mount_date,
       bytes_read / 1024 / 1024 / 1024 GB_read,
       BYTES_WRITTEN / 1024 / 1024 / 1024 GB_written
  from v$asm_disk_stat
      order by mount_status;

PATH			  MOUNT_STATUS	 STATE		    TOTAL_MB	FREE_MB MOUNT_DATE		GB_READ GB_WRITTEN
------------------------- -------------- ---------------- ---------- ---------- ----------------------- ------- ----------
/dev/asm-diskc		  CACHED	 NORMAL 	       30720	  28333 07-JAN-2013 14:18:16	      6 	 1
/dev/asm-diskd		  CACHED	 NORMAL 	       20480	  19780 07-JAN-2013 14:18:16	      1 	 1
/dev/asm-diskb		  CACHED	 NORMAL 		5120	   4682 07-JAN-2013 14:18:16	      0 	 0
/dev/asm-diske		  CACHED	 NORMAL 	       10240	   9890 07-JAN-2013 15:56:10	      0 	 0

Check Clients that connected to database 

SQL> set pages 50000 lines 150 echo on head on flush on veri on feed on
SQL> col INSTANCE_NAME form a20 
SQL> col SOFTWARE_VERSION form a20 
SQL> col COMPATIBLE_VERSION form a20 
SQL> select * from v$asm_client;

GROUP_NUMBER INSTANCE_NAME	  DB_NAME	   STATUS		    SOFTWARE_VERSION	 COMPATIBLE_VERSION
------------ -------------------- ---------------- ------------------------ -------------------- --------------------
	   1 +ASM1		  +ASM		   CONNECTED		    11.2.0.3.0		 11.2.0.3.0
	   2 zhongwc1		  zhongwc	   CONNECTED		    11.2.0.3.0		 11.2.0.0.0
	   3 zhongwc1		  zhongwc	   CONNECTED		    11.2.0.3.0		 11.2.0.0.0


Provide Information about ASM files 

SQL> col TYPE form a15
SQL> col FILE_NUMBER form 9999 head FILE_NUM 
SQL> col GROUP_NUMBER form 9999 head GR_NUM 
SQL> col GB for 9999.99
select GROUP_NUMBER,
       FILE_NUMBER,
       BYTES / 1024 / 1024 / 1024 GB,
       TYPE,
       STRIPED,
       MODIFICATION_DATE
  from v$asm_file
  8   where TYPE <> 'ARCHIVELOG';

GR_NUM FILE_NUM       GB TYPE		 STRIPED      MODIFICATION_DATE
------ -------- -------- --------------- ------------ -----------------------
     1	    253      .00 ASMPARAMETERFIL COARSE       04-JAN-2013 16:00:00
			 E

     1	    255      .25 OCRFILE	 COARSE       07-JAN-2013 14:00:00
     2	    256      .70 DATAFILE	 COARSE       07-JAN-2013 14:00:00
     2	    257      .74 DATAFILE	 COARSE       08-JAN-2013 11:00:00
     2	    258      .11 DATAFILE	 COARSE       07-JAN-2013 14:00:00
     2	    259      .01 DATAFILE	 COARSE       08-JAN-2013 14:00:00
     2	    260      .02 CONTROLFILE	 FINE	      07-JAN-2013 14:00:00
     2	    261      .05 ONLINELOG	 COARSE       07-JAN-2013 22:00:00
     2	    262      .05 ONLINELOG	 COARSE       08-JAN-2013 09:00:00

GR_NUM FILE_NUM       GB TYPE		 STRIPED      MODIFICATION_DATE
------ -------- -------- --------------- ------------ -----------------------
     2	    263      .04 TEMPFILE	 COARSE       07-JAN-2013 14:00:00
     2	    264      .34 DATAFILE	 COARSE       07-JAN-2013 14:00:00
     2	    265      .02 DATAFILE	 COARSE       07-JAN-2013 14:00:00
     2	    266      .05 ONLINELOG	 COARSE       07-JAN-2013 14:00:00
     2	    267      .05 ONLINELOG	 COARSE       07-JAN-2013 14:00:00
     2	    268      .00 PARAMETERFILE	 COARSE       07-JAN-2013 14:00:00
     3	    256      .02 CONTROLFILE	 FINE	      07-JAN-2013 14:00:00
     3	    257      .05 ONLINELOG	 COARSE       07-JAN-2013 22:00:00
     3	    258      .05 ONLINELOG	 COARSE       08-JAN-2013 09:00:00
     3	    259      .05 ONLINELOG	 COARSE       07-JAN-2013 14:00:00
     3	    260      .05 ONLINELOG	 COARSE       07-JAN-2013 14:00:00

Displays one row for every disk group discovered by the ASM instance
 

SQL> set pages 100 lines 200 echo on head on flush on veri on feed on
SQL> col TYPE form a20
SQL> col FILE_NUMBER form 9999 head FILE_NUM 
SQL> col GROUP_NUMBER form 9999 head GR_NUM 
SQL> col GB for 9999.99
SQL> select GROUP_NUMBER,
       FILE_NUMBER,
       COMPOUND_INDEX,
       INCARNATION,
       BLOCK_SIZE,
       BLOCKS,
       BYTES / 1024 / 1024 / 1024 GB,
       TYPE,
       STRIPED,
       CREATION_DATE,
       MODIFICATION_DATE
  from v$asm_file
 13   where TYPE <> 'ARCHIVELOG';

GR_NUM FILE_NUM COMPOUND_INDEX INCARNATION BLOCK_SIZE	  BLOCKS       GB TYPE		       STRIPED	    CREATION_DATE	    MODIFICATION_DATE
------ -------- -------------- ----------- ---------- ---------- -------- -------------------- ------------ ----------------------- -----------------------
     1	    253       16777469	 803837763	  512	       3      .00 ASMPARAMETERFILE     COARSE	    04-JAN-2013 16:16:02    04-JAN-2013 16:00:00
     1	    255       16777471	 803837765	 4096	   66591      .25 OCRFILE	       COARSE	    04-JAN-2013 16:16:04    07-JAN-2013 14:00:00
     2	    256       33554688	 803841367	 8192	   92161      .70 DATAFILE	       COARSE	    04-JAN-2013 17:16:05    07-JAN-2013 14:00:00
     2	    257       33554689	 803841367	 8192	   97281      .74 DATAFILE	       COARSE	    04-JAN-2013 17:16:07    08-JAN-2013 11:00:00
     2	    258       33554690	 803841367	 8192	   14081      .11 DATAFILE	       COARSE	    04-JAN-2013 17:16:07    07-JAN-2013 14:00:00
     2	    259       33554691	 803841367	 8192	    1921      .01 DATAFILE	       COARSE	    04-JAN-2013 17:16:07    08-JAN-2013 14:00:00
     2	    260       33554692	 803841523	16384	    1129      .02 CONTROLFILE	       FINE	    04-JAN-2013 17:18:42    07-JAN-2013 14:00:00
     2	    261       33554693	 803841529	  512	  102401      .05 ONLINELOG	       COARSE	    04-JAN-2013 17:18:48    07-JAN-2013 22:00:00
     2	    262       33554694	 803841531	  512	  102401      .05 ONLINELOG	       COARSE	    04-JAN-2013 17:18:50    08-JAN-2013 09:00:00
     2	    263       33554695	 803841555	 8192	    4737      .04 TEMPFILE	       COARSE	    04-JAN-2013 17:19:15    07-JAN-2013 14:00:00
     2	    264       33554696	 803841579	 8192	   44321      .34 DATAFILE	       COARSE	    04-JAN-2013 17:19:38    07-JAN-2013 14:00:00
     2	    265       33554697	 803842085	 8192	    3201      .02 DATAFILE	       COARSE	    04-JAN-2013 17:28:05    07-JAN-2013 14:00:00
     2	    266       33554698	 803842409	  512	  102401      .05 ONLINELOG	       COARSE	    04-JAN-2013 17:33:29    07-JAN-2013 14:00:00
     2	    267       33554699	 803842415	  512	  102401      .05 ONLINELOG	       COARSE	    04-JAN-2013 17:33:34    07-JAN-2013 14:00:00
     2	    268       33554700	 803842431	  512	       9      .00 PARAMETERFILE        COARSE	    04-JAN-2013 17:33:50    07-JAN-2013 14:00:00
     3	    256       50331904	 803841523	16384	    1129      .02 CONTROLFILE	       FINE	    04-JAN-2013 17:18:43    07-JAN-2013 14:00:00
     3	    257       50331905	 803841529	  512	  102401      .05 ONLINELOG	       COARSE	    04-JAN-2013 17:18:49    07-JAN-2013 22:00:00
     3	    258       50331906	 803841531	  512	  102401      .05 ONLINELOG	       COARSE	    04-JAN-2013 17:18:51    08-JAN-2013 09:00:00
     3	    259       50331907	 803842411	  512	  102401      .05 ONLINELOG	       COARSE	    04-JAN-2013 17:33:31    07-JAN-2013 14:00:00
     3	    260       50331908	 803842417	  512	  102401      .05 ONLINELOG	       COARSE	    04-JAN-2013 17:33:37    07-JAN-2013 14:00:00
SQL> set pages 50000 lines 200 echo on head on flush on veri on feed on
SQL> col Disk_Group form a15 
SQL> col File_Type form a40
SQL> col MB form  '999,999,999'
select a.NAME Disk_Group, b.TYPE File_Type, b.BYTES / 1024 / 1024 MB
  from v$asm_diskgroup a, v$asm_file b
 where a.GROUP_NUMBER = b.GROUP_NUMBER
  4   order by 1, 2;

DISK_GROUP	FILE_TYPE					   MB
--------------- ---------------------------------------- ------------
CRS		ASMPARAMETERFILE				    0
CRS		OCRFILE 					  260
DATADG		CONTROLFILE					   18
DATADG		DATAFILE					   15
DATADG		DATAFILE					  720
DATADG		DATAFILE					  760
DATADG		DATAFILE					  110
DATADG		DATAFILE					   25
DATADG		DATAFILE					  346
DATADG		ONLINELOG					   50
DATADG		ONLINELOG					   50
DATADG		ONLINELOG					   50
DATADG		ONLINELOG					   50
DATADG		PARAMETERFILE					    0
DATADG		TEMPFILE					   37
FRADG		ARCHIVELOG					   44
FRADG		ARCHIVELOG					    7
FRADG		ARCHIVELOG					   44
FRADG		ARCHIVELOG					    0
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					    0
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					   46
FRADG		ARCHIVELOG					    0
FRADG		ARCHIVELOG					    1
FRADG		ARCHIVELOG					    0
FRADG		ARCHIVELOG					    1
FRADG		ARCHIVELOG					    0
FRADG		ARCHIVELOG					   11
FRADG		ARCHIVELOG					   10
FRADG		ARCHIVELOG					   23
FRADG		ARCHIVELOG					   27
FRADG		ARCHIVELOG					   11
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					   44
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					   43
FRADG		ARCHIVELOG					    0
FRADG		CONTROLFILE					   18
FRADG		ONLINELOG					   50
FRADG		ONLINELOG					   50
FRADG		ONLINELOG					   50
FRADG		ONLINELOG					   50

All of above scripts 

set wrap off
set lines 155 pages 9999
col "Group Name" for a6    Head "Group|Name"
col "Disk Name"  for a10
col "State"      for a10
col "Type"       for a10   Head "Diskgroup|Redundancy"
col "Total GB"   for 9,990 Head "Total|GB"
col "Free GB"    for 9,990 Head "Free|GB"
col "Imbalance"  for 99.9  Head "Percent|Imbalance"
col "Variance"   for 99.9  Head "Percent|Disk Size|Variance"
col "MinFree"    for 99.9  Head "Minimum|Percent|Free"
col "MaxFree"    for 99.9  Head "Maximum|Percent|Free"
col "DiskCnt"    for 9999  Head "Disk|Count"

prompt


prompt ASM Disk Groups
prompt ===============

SELECT g.group_number  "Group"
,      g.name          "Group Name"
,      g.state         "State"
,      g.type          "Type"
,      g.total_mb/1024 "Total GB"
,      g.free_mb/1024  "Free GB"
,      100*(max((d.total_mb-d.free_mb)/d.total_mb)-min((d.total_mb-d.free_mb)/d.total_mb))/max((d.total_mb-d.free_mb)/d.total_mb) "Imbalance"
,      100*(max(d.total_mb)-min(d.total_mb))/max(d.total_mb) "Variance"
,      100*(min(d.free_mb/d.total_mb)) "MinFree"
,      100*(max(d.free_mb/d.total_mb)) "MaxFree"
,      count(*)        "DiskCnt"
FROM v$asm_disk d, v$asm_diskgroup g
WHERE d.group_number = g.group_number and
d.group_number <> 0 and
d.state = 'NORMAL' and
d.mount_status = 'CACHED'
GROUP BY g.group_number, g.name, g.state, g.type, g.total_mb, g.free_mb
ORDER BY 1;



prompt ASM Disks In Use
prompt ================
col "Group"          for 999
col "Disk"           for 999
col "Header"         for a9
col "Mode"           for a8
col "State"          for a8
col "Created"        for a18          Head "Added To|Diskgroup"
--col "Redundancy"     for a10
--col "Failure Group"  for a10  Head "Failure|Group"
col "Path"           for a19
--col "ReadTime"       for 999999990    Head "Read Time|seconds"
--col "WriteTime"      for 999999990    Head "Write Time|seconds"
--col "BytesRead"      for 999990.00    Head "GigaBytes|Read"
--col "BytesWrite"     for 999990.00    Head "GigaBytes|Written"
col "SecsPerRead"    for 9.000        Head "Seconds|PerRead"
col "SecsPerWrite"   for 9.000        Head "Seconds|PerWrite"
col "name"           for a18          Head "Disk Name"

select group_number  "Group"
,      disk_number   "Disk"
,      header_status "Header"
,      mode_status   "Mode"
,      state         "State"
,      create_date   "Created"
--,      redundancy    "Redundancy"
,      total_mb/1024 "Total GB"
,      free_mb/1024  "Free GB"
,      name          "Disk Name"
--,      failgroup     "Failure Group"
,      path          "Path"
--,      read_time     "ReadTime"
--,      write_time    "WriteTime"
--,      bytes_read/1073741824    "BytesRead"
--,      bytes_written/1073741824 "BytesWrite"
,      read_time/reads "SecsPerRead"
,      write_time/writes "SecsPerWrite"
from   v$asm_disk_stat
where header_status not in ('FORMER','CANDIDATE')
order by group_number
,        disk_number
/



Prompt File Types in Diskgroups
Prompt ========================
col "File Type"      for a16
col "Block Size"     for a5    Head "Block|Size"
col "Gb"             for 9990.00
col "Files"          for 99990

break on "Group Name" skip 1 nodup

select g.name                                   "Group Name"
,      f.TYPE                                   "File Type"
,      f.BLOCK_SIZE/1024||'k'                   "Block Size"
,      f.STRIPED
,        count(*)                               "Files"
,      round(sum(f.BYTES)/(1024*1024*1024),2)   "Gb"
from   v$asm_file f,v$asm_diskgroup g
where  f.group_number=g.group_number
group by g.name,f.TYPE,f.BLOCK_SIZE,f.STRIPED
order by 1,2;



clear break
prompt Instances currently accessing these diskgroups
prompt ==============================================
col "Instance" form a8

select c.group_number  "Group"
,      g.name          "Group Name"
,      c.instance_name "Instance"
from   v$asm_client c
,      v$asm_diskgroup g
where  g.group_number=c.group_number
/

prompt Free ASM disks and their paths
prompt ==============================
col "Disk Size"    form a9
select header_status                   "Header"
, mode_status                     "Mode"
, path                            "Path"
, lpad(round(os_mb/1024),7)||'Gb' "Disk Size"
from   v$asm_disk
where header_status in ('FORMER','CANDIDATE')
order by path
/



prompt Current ASM disk operations
prompt ===========================
select *
from   v$asm_operation
/
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 
Connected as sys@zwc AS SYSDBA
 
SQL> 
Cannot SET WRAP
Cannot SET LINES
 
ASM Disk Groups
===============
 
Gro Group  State      Type         Total GB    Free GB  Imbalance   Variance    MinFree    MaxFree Disk
--- ------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----
  1 CRS    MOUNTED    EXTERN              5 4.57226562          0          0 91.4453125 91.4453125    1
  2 DATADG CONNECTED  EXTERN             30 27.6591796          0          0 92.1972656 92.1972656    1
  3 FRADG  CONNECTED  EXTERN             30 28.9746093          0         50 96.5820312 96.5820312    2
ASM Disks In Use
================
 
Gro Dis Header    Mode     State    Created              Total GB    Free GB Disk Name  Path                SecsPerRead SecsPerWrite
--- --- --------- -------- -------- ------------------ ---------- ---------- ---------- ------------------- ----------- ------------
  1   0 MEMBER    ONLINE   NORMAL   2013-1-4 16:15:51           5 4.57226562 CRS_0000   /dev/asm-diskb      0.006590407     0.005541
  2   0 MEMBER    ONLINE   NORMAL   2013-1-4 16:31:06          30 27.6591796 DATADG_000 /dev/asm-diskc      0.014182072 0.0378489233
                                                                             0                                          
 
  3   0 MEMBER    ONLINE   NORMAL   2013-1-4 16:31:40          20 19.3164062 FRADG_0000 /dev/asm-diskd      0.020543327 0.0322575097
  3   1 MEMBER    ONLINE   NORMAL   2013-1-7 15:56:10          10 9.65820312 FRADG_0001 /dev/asm-diske      0.006110032 0.0257169399
File Types in Diskgroups
========================
 
Group  File Type        Block STRIPED Files         Gb
------ ---------------- ----- ------- ----- ----------
CRS    ASMPARAMETERFILE .5k   COARSE      1          0
CRS    OCRFILE          4k    COARSE      1       0.25
DATADG CONTROLFILE      16k   FINE        1       0.02
DATADG DATAFILE         8k    COARSE      6       1.93
DATADG ONLINELOG        .5k   COARSE      4        0.2
DATADG PARAMETERFILE    .5k   COARSE      1          0
DATADG TEMPFILE         8k    COARSE      1       0.04
FRADG  ARCHIVELOG       .5k   COARSE     27       0.64
FRADG  CONTROLFILE      16k   FINE        1       0.02
FRADG  ONLINELOG        .5k   COARSE      4        0.2
 
10 rows selected
Instances currently accessing these diskgroups
==============================================
 
Gro Group  Instance
--- ------ --------
  2 DATADG +ASM1
  3 FRADG  +ASM1
Free ASM disks and their paths
==============================
 
Header    Mode     Path                Disk Size
--------- -------- ------------------- ---------
Current ASM disk operations
===========================
 
GROUP_NUMBER OPERATION STATE         POWER     ACTUAL      SOFAR   EST_WORK   EST_RATE EST_MINUTES ERROR_CODE
------------ --------- -------- ---------- ---------- ---------- ---------- ---------- ----------- --------------------------------------------
 
SQL>



ZhongWeicheng
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Marine Automatics: MATLAB/Simulink 船用自动化元件库的仿真模型-matlab开发
06-01
该库是作为什切青海事大学学生关于船舶自动元件仿真模型的硕士论文（导师 Jerzy Brzozka，博士）的一部分创建的。 它包含 35 个完全可... 将存档解压到 C:\ 并通过执行文件夹内的图标“Marine Automatics”来运行库。
Trajectory Planning for Automatic Machines and Robots
03-25
机器人轨迹规划方面很不错的的参考资料，内容非常实用。
Colorization for gray scale facial image by locality-constrained linear coding
02-09
Colorization for gray scale facial image is an important technique in various practical applications. However, the methods that have been proposed are essentially semi-automatic. In this paper, we ...
TRB0_SETUP_mousedraw_
09-30
【描述】"AEc171 automatics than window" 这个描述似乎不完整，但我们可以推测其中包含了一些关键信息。"AEc171"可能是软件版本号或者是某种特定的代码或组件，"automatics"可能指自动功能，意味着软件具有自动化...
全球自动平开门操作器市场总体规模，前十一强厂商排名及市场份额.pdf
最新发布
11-16
全球市场上，主要的自动平开门操作器制造商包括亚萨合莱、纳博特斯克、Stanley Access Technologies、通力、Dormakaba、TORMAX、Horton Automatics、GEZE、Portalp、Allegion等。2022年，前五大厂商占据了约77.0%的...
Oracle ASM hidden parameters
Zhong Weicheng Study Notes
11-09 5758
[oracle@vzwc2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 9 21:43:58 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g E
Oracle使用触发器禁止远程DDL操作
Zhong Weicheng Study Notes
01-15 2257
SQL> grant select on v_$session to zhongwc; Grant succeeded. SQL> grant execute on dbms_system to zhongwc; Grant succeeded. SQL> @ddl_trigger Trigger created. SQL> !cat ddl_trigger.sql cre
Oracle记录用户DDL操作脚本
Zhong Weicheng Study Notes
11-28 2200
--当前普通用户创建 issgzt create table TAB_DDL (   LOGIN_USER         VARCHAR2(60),   AUDSID             NUMBER,   MACHINE            VARCHAR2(60),   IPADDRESS          VARCHAR2(20),   SCHEMA_USER
使用DBLINK访问LOB类型表
Zhong Weicheng Study Notes
12-23 2197
This is a bit twisted solution, but works. Basically you first need to convert LOB (in these example I refer to CLOB, BLOB is similar but you will probably not use varchar2) to multiple varchar2(4000)
使用PL/SQL获取创建用户的语句
Zhong Weicheng Study Notes
05-18 2157
Create procedure: create or replace procedure get_case_sqls_for_ddls_ver1 as cursor get_username is select username from dba_users; begin for l_user in get_username loop DBMS_OUTPUT.P
Oracle SQL hints
Zhong Weicheng Study Notes
02-25 2113
--Oracle 8i SQL> select NAME,CLASS,SQL_FEATURE from v$sql_hint where VERSION LIKE '8%'; NAME                                     CLASS                                    SQL_FEATURE ---------
使用PL/SQL获取Oracle Event名称
Zhong Weicheng Study Notes
12-18 1819
我们知道通过启动Oracle内部事件可以获得更多额外的可用信息,但是如何知道每个事件对应哪些功能呢？这里可以使用pl/sql来获取所有事件的名称。 SET linesize 200 SET feedback off SET SERVEROUTPUT ON DECLARE err_msg VARCHAR2(200); BEGIN dbms_output.enable(1000000);
使用存储过程和dbms_job自动添加表分区
Zhong Weicheng Study Notes
12-18 1695
被添加分区的表必须初始化分区 CREATE TABLE t_test ( spBillno VARCHAR2 ( 20 ) NOT NULL, orderId VARCHAR2 ( 50 ) NOT NULL, userId NUMBER ( 12 ), bankType CHAR ( 5 ), payMoney NUMBER ( 10 ) DEFAULT 0 NOT N
Oracle 12C Auto Start PDB Pluggable Database
Zhong Weicheng Study Notes
09-26 1425
sqlplus / as sysdba CREATE TRIGGER open_all_pdbs    AFTER STARTUP    ON DATABASE BEGIN    EXECUTE IMMEDIATE 'alter pluggable database all open'; END open_all_pdbs; /
Oracle DBlink 比较两边对象和数据
Zhong Weicheng Study Notes
08-15 1347
对象比较 select a.object_type, a.ds_count, b.dt_count, ds_count - dt_count minus_count from (select object_type, count(*) ds_count from dba_objects@dbverify wher
Oracle Logical Replication install check scripts
Zhong Weicheng Study Notes
08-15 1135
set null "NULL VALUE" set feedback off set heading off set linesize 132 set pagesize 9999 set echo off set verify off set trimspool on col table_name for a30 col column_name for a30 col data_type fo
Python Generate reports for Oracle username Role/Privs
Zhong Weicheng Study Notes
11-19 1001
python code #!/usr/bin/env python import cx_Oracle username='zwc' password='zwc' database='oraprod' conn=cx_Oracle.connect(username,password,database) curs=conn.cursor() user_query='select username
Oracle Check Current platform
Zhong Weicheng Study Notes
11-05 799
[P720:/home/dsg]$sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 5 21:50:30 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g En
使用DBMS_JOB包创建删除schema下的job
Zhong Weicheng Study Notes
12-18 750
CREATE OR REPLACE PROCEDURE p_test AS BEGIN NULL; END p_test; HR@joydb:~>select text from user_source where name=upper('p_test'); TEXT ----------------------- procedure p_test as begin null;
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值