snum = "format 9G999"
ttitle left "Space Usage of a table" skip 2
define ENTER_OWNER='&TABLE_OWNER... ----------------
segment_owner Schema name of the segment to be analyzed
segment_name Name of the segment to be analyzed
partition_name Partition name of the segment to be analyzed
segment_type Ty
T und OCR Disks zugreifen kann (absolute majority of voting disks (more than half)) wird heruntergefah... .1)
The synchronization services component (CSS) of the Oracle Clusterware maintains two heartbeat me... nfirm valid node membership in the cluster
Both of these heartbeat mechanisms have an associated tim... el loszuwerden
for i in $disks;do
dd if=/dev/zero of=$i bs=1M count=10 ;done
# mit n neu anlegen, p
EST}/${ORACLE_DBNAME}/orapw${ORACLE_DBNAME}_${DAY_OF_WEEK}
</code>
==ASM Spfile ==
Zum Beispiel mit ... race:
<code sql>
..
# Run Script to generate Copy of pfile
#
${ORACLE_HOME}/bin/sqlplus / as sysasm <<... EST}/${ORACLE_DBNAME}/init_${ORACLE_DBNAME}_${DAY_OF_WEEK}.ora' FROM spfile;
exit;
EOScipt
..
</code>
... ACLE_DBNAME}/asm_configuration${ORACLE_SID}_${DAY_OF_WEEK}.trc
${ORACLE_HOME}/bin/asmcmd md_backup -b
------------------
Welcome to the installation of the Database v2.2
----------------------------... installed ASM enviroment
please enter the Name of the database you like to install [GPIDB]:
-------... --------------------
!! Check the name resolution of the DB host
-----------------------------------
PING gpidbsrv (192.168.123.99) 56(84) bytes of data.
64 bytes from gpidbsrv (192.168.123.99): ic
CE9E50396 )
* Patch **6880880**: OPatch patch of version 12.2.0.1.13 for Oracle software releases ... B5573627F )
* Patch **6880880**: OPatch patch of version 11.2.0.3.19 for Oracle software releases ... y Oracle Support patch 6880880 ) => OPatch patch of version 12.2.0.1.13 for Oracle software releases ... n aktuellen OPatch ( Patch 6880880: OPatch patch of version 12.2.0.1.13 for Oracle software releases
21c-a', 'cman21c-b'
cman21c-a: successful removal of the file 'pcsd settings'
cman21c-b: successful removal of the file 'pcsd settings'
Sending 'corosync authke... ', 'cman21c-b'
cman21c-a: successful distribution of the file 'corosync authkey'
cman21c-a: successful distribution of the file 'pacemaker authkey'
cman21c-b: successfu
e Statspack / Perfstat to analyse the performance of the SE Edition ======
=== Overview ===
If you look inside the Oracle statistical views, most of the data in not very helpfully at this time. You ... single value. You need the chronological sequence of the values and the difference between the points in time.
With statspack you snap most of the statics value in the v$ tables of the databas
de.cmd -n 4 -l d:\temp\19cUpgrade
......
Number of Cpus = 8
Database Name = GPI
DataB... .
@?/rdbms/admin/utltz_countstats.sql
..
Amount of TSTZ data using num_rows stats info in DBA_TABLES... useful when using DBMS_DST package or the scripts of --
-- utlz_upg_check.sql and utlz_upg_apply.sql ... /admin/utltz_countstar.sql
..
Estimating amount of TSTZ data using COUNT(*).
..
SYS.XS$PRIN.START_D
r, v_compat);
dbms_output.put_line('--- Version of the database : ' || v_ver ||' Compatible: ' || v_... E
------
Places and formats a title at the top of each report page.
Enter TTITLE with no clause to list its current definition.
The old form of TTITLE is used if only a single word or
a string... [OFF|ON]
where printspec represents one or more of the following clauses:
COL n LE[FT
ame format A20
COLUMN DUMMY NOPRINT;
COMPUTE SUM OF cs ON DUMMY
BREAK ON DUMMY;
select null dummy
... erfügung:
* CREATOR_ADDR - state object address of creating process
* CREATOR_SERIAL# - serial number of creating process
Mit der CREATOR_ADDR kann nu... ROCESS_GROUP
* INDX - Index
* NAME - The name of the process group. The default group is called DE