a
inner join v$asm_diskgroup g on (g.group_number=a.group_number)
where g.name like upper ('&&DG_NAME')
and a.name like lower ('%repair%')
order by a.n... 016-09-05 23:32:18.947 [OCSSD(3111)]CRS-1606: The number of voting files available, 2, is less than the minimum number of voting files required, 3, resulting in CSSD te
E, INDEX, or CLUSTER)
unformatted_blocks Total number of blocks that are unformatted
unformatted bytes Total number of bytes that are unformatted
fs1_blocks Number of blocks that has at least 0 to 25% free space
fs1_bytes Number of bytes that has at least 0 to 25% free space
fs
package search_CC
as
type num_arry is table of number
index by binary_integer;
function showCreditCardType (p_number varchar2)
return varchar2;
/*
check if the number string can be check with the LuhnMod10 alogrithmus
1 Sucess - is a Luh10 Number
-1 Invalid
*/
function checkLuhnMod1
-------");
System.out.println("-- Info :: Number of connection requestt, this is the number of times Hibernate asked for a connection");
System.ou... tCount());
System.out.println("-- Info :: Number of flushes done on the session (either by client ... nt());
System.out.println("-- Info :: The number of completed transactions (failed and successful)
=====Besonderheiten bei der Definition des Number Datentypes in Oracle=====
Mit dem Oracle Datentyp Number(p,s) wird ein Festkommazahl definiert, bei der De... Komma angeben.
Eine Integer Zahl kann dann mit Number(p) definiert werden.
<code sql>
column_name NUMBER (precision, scale)
</code>
* precision = Gesammt
d disk UFS:/dev/oracleasm/disks/VOT1_02 with disk number:3 and timestamp (33039887 -1916262400)
Identified disk UFS:/dev/oracleasm/disks/VOT1 with disk number:0 and timestamp (33039532 -1177383936)
Identified... :/opt/oracle/VOTNFSDISK/vote_nfs_disk01 with disk number:2 and timestamp (33039765 973622272)
Checking for... d disk UFS:/dev/oracleasm/disks/VOT1_02 with disk number:3 and timestamp (33039887 -1916262400)
Identified
REATE TABLE Documents
(
ID NUMBER (30) NOT NULL ,
Filename VARCHAR2 ... cascade constraint
/
create table thesaurus(
id number(11) not null
,name varchar2(255) not null
,descr... onstraint
/
create table thesaurus_phrases(
id number(11) not null
,ths_id number(11) not null
,phrase varchar2(255) not null
)
/
--pk
create unique index id
_pk on vertex(name);
create table edge ( edge_id number, Name_from varchar2(1), Name_to varchar2(1) ,val... ration.
,num_hash_ptns => 16 -- Number of hash partitions used to partition the vertices... ^
| VID | NUMBER |Vertex IT ... |
| T | NUMBER(38) |Property value type see h
n the last days" skip 2
select dbid
, instance_number
, snap_id
, to_char(end_interval_time,'hh24:m... ime > trunc(sysdate-1)
order by snap_id, instance_number
/
clear break
ttitle off
set feedback off
set ... spool_name_col new_val spool_name
column instance_number new_val inst_nr
column aktdbid new_val databaseid...
,SYS_CONTEXT('USERENV','INSTANCE') as instance_number
FROM dual
/
select dbid as aktdbid
from v$da
en.
Die ora_rowscn gibt die SCN (System Change Number) der Datenbank wieder, an der zum letzten Mal der... ode sql>
select ora_rowscn,DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid),empno from emp order by 2;
ORA_ROWSCN DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID) EMPNO
---------- --------------------... om emp;
select ora_rowscn,DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid),empno from emp order by 2;
ORA_ROWSCN DBM
le_name varchar2(32) -- Table Name
, total_count number(11) -- Total Number of Rows
, column_name varchar2(32) -- Name of the column
, column_count number(11) -- Distinct values with out null
, null_count number(11) -- Values with null
, column_null varchar2
Initialize(sctx IN OUT t_string_agg)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateIterate(self I... value IN VARCHAR2 )
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateTerminate(self ... flags IN NUMBER)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateMerge(self IN OUT t_string_agg,