Apex script output

Output


select * from sys.v_$version
CON_ID
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production 0
PL/SQL Release 12.1.0.2.0 – Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 – Production 0
NLSRTL Version 12.1.0.2.0 – Production 0

5 rows selected. 0.01 seconds


select sys_context('USERENV','HOST') from dual
SYS_CONTEXT(‘USERENV’,’HOST’)
acsmv0121.oracle.com

Statement processed. 0.00 seconds


select sys_context('USERENV','OS_USER') from dual
SYS_CONTEXT(‘USERENV’,’OS_USER’)
oracle

Statement processed. 0.00 seconds


select sys_context('USERENV','DB_NAME') from dual
SYS_CONTEXT(‘USERENV’,’DB_NAME’)
MARVLPRD

Statement processed. 0.00 seconds


select sys_context('USERENV','DB_UNIQUE_NAME') from dual
SYS_CONTEXT(‘USERENV’,’DB_UNIQUE_NAME’)
AEXTPRD

Statement processed. 0.00 seconds


select sys_context('USERENV','INSTANCE_NAME') from dual
SYS_CONTEXT(‘USERENV’,’INSTANCE_NAME’)
AEXTPRD1

Statement processed. 0.01 seconds


select sys_context('USERENV','CON_NAME') from dual
SYS_CONTEXT(‘USERENV’,’CON_NAME’)
MARVLPRD

Statement processed. 0.00 seconds


select sys_context('USERENV','CON_ID') from dual
SYS_CONTEXT(‘USERENV’,’CON_ID’)
0

Statement processed. 0.00 seconds


select * from session_roles
ROLE
DV_PUBLIC

Statement processed. 0.00 seconds


select * from session_privs
PRIVILEGE
CREATE CREDENTIAL
CREATE JOB
CREATE DIMENSION
CREATE INDEXTYPE
CREATE OPERATOR
CREATE TYPE
CREATE MATERIALIZED VIEW
CREATE TRIGGER
CREATE PROCEDURE
CREATE SEQUENCE
CREATE VIEW
CREATE SYNONYM
CREATE CLUSTER
CREATE TABLE
CREATE SESSION

15 rows selected. 0.01 seconds


select * from sys.v_$active_instances
INST_NUMBER INST_NAME CON_ID
1 acsdx0103.us.oracle.com:AEXTPRD1 0
2 acsdx0104.us.oracle.com:AEXTPRD2 0

2 rows selected. 0.00 seconds


select * from sys.all_directories
OWNER DIRECTORY_NAME DIRECTORY_PATH ORIGIN_CON_ID
SYS DP_DEST /u03/download/dump 0

Statement processed. 0.04 seconds


select count(*) from sys.v_$session_connect_info
COUNT(*)
270

Statement processed. 0.01 seconds


select * from sys.v_$session_connect_info where rownum = 1
SID SERIAL# AUTHENTICATION_TYPE OSUSER NETWORK_SERVICE_BANNER CLIENT_CHARSET CLIENT_CONNECTION CLIENT_OCI_LIBRARY CLIENT_VERSION CLIENT_DRIVER CLIENT_LOBATTR CLIENT_REGID CON_ID
5 8921 DATABASE oracle TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0 – Production Unknown Heterogeneous Unknown 11.2.0.3.0 jdbcthin Client Temp Lob Rfc On 0 0

Statement processed. 0.00 seconds


select opname, start_time, last_update_time, message from sys.v_$session_longops where opname like '%RMAN%archive%'
OPNAME START_TIME LAST_UPDATE_TIME MESSAGE
RMAN: archived log backup 21-MAY-2015 06:52:28 21-MAY-2015 14:12:12 RMAN: archived log backup: Set Count 575179: 41787246 out of 41787246 Blocks done
RMAN: archived log backup 21-MAY-2015 06:52:28 21-MAY-2015 14:12:12 RMAN: archived log backup: Set Count 575179: 41787241 out of 41787241 Blocks done
RMAN: archived log backup 21-MAY-2015 06:52:28 21-MAY-2015 14:12:50 RMAN: archived log backup: Set Count 575180: 38535832 out of 38535832 Blocks done
RMAN: archived log backup 21-MAY-2015 06:52:28 21-MAY-2015 14:12:50 RMAN: archived log backup: Set Count 575180: 38535837 out of 38535837 Blocks done
RMAN: archived log backup 21-MAY-2015 06:52:27 21-MAY-2015 14:10:49 RMAN: archived log backup: Set Count 575177: 43566318 out of 43566318 Blocks done
RMAN: archived log backup 21-MAY-2015 14:10:59 21-MAY-2015 14:14:53 RMAN: archived log backup: Set Count 575192: 1798727 out of 1798727 Blocks done
RMAN: archived log backup 21-MAY-2015 06:52:27 21-MAY-2015 14:10:49 RMAN: archived log backup: Set Count 575177: 43566323 out of 43566323 Blocks done
RMAN: archived log backup 21-MAY-2015 14:10:59 21-MAY-2015 14:14:53 RMAN: archived log backup: Set Count 575192: 1798729 out of 1798729 Blocks done

8 rows selected. 0.01 seconds


select count(*) from all_users
COUNT(*)
25660

Statement processed. 0.66 seconds


select count(*) from sys.sysfiles
COUNT(*)
25379

Statement processed. 0.29 seconds


select round(sum(blocks*8192/(1024*1024*1024))) as gb from sys.sysfiles
GB
470

Statement processed. 0.27 seconds


select * from sys.sysfiles where rownum =1
TSNAME FNAME BLOCKS
APEX_70022640525976224373 +DATA_ACS2/aextprd/datafile/apex_70022640525976224373.18939.872323337 328

Statement processed. 0.00 seconds


Run By PIERRE.FORSTMANN@X.Y
Parsing Schema SB001
Script Started Thursday, May 21, 2015
5 days ago
Elapsed time 1.38 seconds
Statements Processed 19
Successful 19
With Errors 0
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: