Längen nach Anlage der Tabelle mit:
<code sql>
SELECT col.TABLE_NAME
, col.COLUMN_NAME
,... -----------
A VARCHAR2(10)
SQL>select data_type,data_length from user_tab_columns where... -----------
A VARCHAR2(10)
SQL>select data_type,data_length from user_tab_columns where... veroutput ON
DECLARE
cursor c_char_cols
IS
SELECT col.TABLE_NAME
,col.COLUMN_NAME
,co
GPIPPERR"
GPIPPERR@CMAN2_GPIDB23c-oracledb23c01>SELECT SYS_CONTEXT('USERENV','PROXY_USER') FROM dual;
S...
CMAN_TDM
GPIPPERR@CMAN2_GPIDB23c-oracledb23c01>SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') FROM dual;
S... s "HR"
HR@//localhost:1521/freedb1-oracledb23c01>SELECT SYS_CONTEXT('USERENV','PROXY_USER') FROM dual;
S... ser
USER is "HR"
HR@CMAN2_GPIDB23c-oracledb23c01>SELECT SYS_CONTEXT('USERENV','PROXY_USER') FROM dual;
S
l_db
# mit dem Password von GPI anmelden:
SQL>select user from dual;
USER
-----
HR
</code>
==== Übe... darf sich an diesem Schema anmelden:
<code sql>
select proxy
, client
, authentication
, authorizati... arf sich an welches Schema anmelden:
<code sql>
select proxy
, client
, authentication
, authorizati... rage der Umgebung der SQL Session mit:
<code sql>
SELECT SYS_CONTEXT ('USERENV', 'CURRENT_USER')
r über die Umgebung anmelden
sqlplus / as sysdba
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDB... atisch starten:
<code sql>
sqlplus / as sysdba
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDB
st
2> go
Changed database context to 'ORATST'.
1> select * from dual;
2> go
FROM_X
-----------------------... rom_x) values ("X");
2> go
(1 rows affected)
1> select * from dual;
2> go
FROM_X
-----------------------... ST
2> go
Changed database context to 'ORATST'.
1> select * from dual;
2> go
FROM_X
-----------------------... ------------------------
X
(1 rows affected)
1> SELECT NAME FROM sys.sysdatabases;
2> go
1> exit
</co
ontrol','my_secret_pwd');
end;
/
-- DD abfragen
SELECT credential_name
,username
FROM user_... _details ", ob es auch geklappt hat:
<code sql>
SELECT job_name
, status
, error#
, ac... Spalten OUTPUT und BINARY_OUTPUT) :
<code sql>
select OUTPUT from user_scheduler_job_run_details WHERE ... OB- log to std_out
-- bei mehr als 4000 Zeichen
select utl_raw.cast_to_varchar2(BINARY_OUTPUT) from user
für den Job===
Zeitzone überwachen:
<code sql>
SELECT DBMS_SCHEDULER.STIME FROM DUAL;
STIME
----------... zone'
, value => 'EUROPE/BERLIN');
END;
/
SELECT DBMS_SCHEDULER.STIME FROM DUAL;
STIME
----------... e);
END;
/
-- nur im Job Log steht ein Eintrag!
select *
from dba_scheduler_job_log
where job_name = ... gen Beispiel Lightwight Job wird weiterverwendet
select *
from dba_scheduler_programs
where program
e => 'FREQ=MINUTELY; INTERVAL=15');
END;
/
select *
from dba_scheduler_schedules
where schedul... chste mal und das übernächste mal laufen würden:
select js.job_name
, JS.REPEAT_INTERVAL
, js
on 10g vorliegen, neu gesetzt werden!
<code sql>
select password_versions,username from dba_users where p... ob Password Datei in Verwendung ist:
<code sql>
select * from v$pwfile_users;
-- SYS muss dabei sein!
... ed selects.
</code>
Version prüfen:
<code sql>
select * from v$timezone_file;
FILENAME ... 3 level 1';
-- Where is the trace on the server
SELECT VALUE FROM v$diag_info WHERE name = 'Default
s_authent_prefix auf leer stellen!**
<code sql>
select value from v$parameter where name = 'os_authent_p... e>
**remote_os_authent auf false!**
<code sql>
select value from v$parameter where name = 'remote_os_au... o kerbSchema;
-- External Information abfragen:
select username, EXTERNAL_NAME from dba_users where EXTE... bfragen wie der User autorisiert ist:
<code sql>
select sys_context('userenv','authentication_method') fr
E format a32
column OPEN_TIME format a32
SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDB... ode>
Als Json die Metadaten ausgeben:
<code sql>
select JSON_ARRAY(
json_object ( key 'name'