- 博客(6)
- 资源 (6)
- 收藏
- 关注
转载 How to collect the full path name of the files in ASM diskgroups (文档 ID 888943.1)
Connect to the ASM instance: in 10g: sqlplus / as sysdba in 11g: sqlplus / as sysasm Then perform the following query: SELECT gnum, filnum, concat('+'||gname,sys_connect_by_path(aname, '/'))
2015-04-30 15:43:35 461
转载 Automatic Storage Management (ASM) in Oracle Database 10g
Automatic Storage Management (ASM) is a new feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles and logfiles. Overview of Automatic Storage Manage
2015-04-29 22:31:33 663
转载 ASM data extent VS tablespace extent
Please don't mix oracle extent with the data extents concepts being used here, see http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/ostmg_gloss.htm#BABFCABI I presume that you know ab
2015-04-25 17:18:04 426
转载 RAC Filesystem Options
RAC Filesystem Options DBAs wanting to create a 10g Real Applications Cluster face many configuration decisions. One of the more potentially confusing decisions involves the choice of fil
2015-04-14 21:20:17 752
转载 Bash Conditional Expressions
6.4 Bash Conditional Expressions Conditional expressions are used by the [[ compound command and the test and [ builtin commands. Expressions may be unary or binary. Unary expressions are often us
2015-04-08 09:54:15 462
转载 raw to number
create or replace function value_to_number(i_raw in raw) return number deterministic as m_n number(6); begin dbms_stats.convert_raw_value(i_raw,m_n); return m_n; end; . /
2015-04-04 17:15:40 573
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人