Oracle DBA Daily Experiences

set serveroutput on
BEGIN
for i in (select file_name,autoextensible from dba_data_files where autoextensible = ‘YES’) loop
dbms_output.put_line(‘File name is: ‘||i.file_name||’ and autoextensible is: ‘||i.autoextensible);
execute immediate ‘alter database datafile ”’||i.file_name||”’ autoextend off’;
end loop;
END;
/

The Official Oracle Wiki – Oracle Wiki.

the script below will help you to see how big auto allocation is set plus all the report for the current used and free space.

[spocoradb1.aeso.ca]/dbadmin/workspace2/alima/sql>cat db_tablespaces_report.sql
set linesize 200
set trimspool on
set pagesize 100
set feedback off
column dummy noprint
column pct_used format 999.9 heading “%|Used”
column name format a30 heading “Tablespace Name”
column Kbytes_alloc format 999,999,999,999 heading “Alloc|KBytes”
column currently_used format 999,999,999,999 heading “Used|KBytes”
column kbytes_free format 999,999,999,999 heading “Free|KBytes”
column Kbytes_max format 999,999,999,999 heading “MaxPoss|Kbytes”
column pct_free format 999.99 heading “%Free”
column max_kbytes_free format 999,999,999,999 heading “MaxPoss|Free|KBytes”
column max_pct_used format 999.99 heading “%Max|Used”
column host_name format a30

spool $vfile_email

select TO_CHAR(sysdate, ‘DD-MON-YYYY HH24:MI:SS’) TODAY FROM dual
/
SELECT host_name, instance_name FROM v$instance
/
break on report
compute sum of Kbytes_alloc on report
compute sum of kbytes_free on report
compute sum of currently_used on report
compute sum of Kbytes_max on report
select decode(extent_management,’LOCAL’,'*’,”) ||
decode(segment_space_management,’AUTO’,'a ‘,’m ‘) ||
b.tablespace_name name,
Kbytes_alloc,
kbytes_max,
(Kbytes_alloc – NVL(kbytes_free, 0)) currently_used,
NVL(kbytes_free, 0) kbytes_free,
(NVL(kbytes_free, 0))*100/Kbytes_alloc pct_free,
(Kbytes_max – Kbytes_alloc + NVL(kbytes_free, 0)) max_kbytes_free,
(Kbytes_alloc – NVL(kbytes_free, 0))*100/kbytes_max max_pct_used
FROM
( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest,
tablespace_name
from sys.dba_free_space
group by tablespace_name ) a,
( select sum(bytes)/1024 Kbytes_alloc,
sum(decode(AUTOEXTENSIBLE, ‘NO’, bytes,
decode(sign(maxbytes – bytes), 1, maxbytes, -1, bytes, 0,maxbytes)))/1024 Kbytes_max,tablespace_name
from sys.dba_data_files
group by tablespace_name) b,
dba_tablespaces c
where a.tablespace_name (+) = b.tablespace_name
AND c.tablespace_name = b.tablespace_name
AND b.tablespace_name NOT IN (select distinct TABLESPACE_NAME from
DBA_UNDO_EXTENTS)
— 5% free and less than 2GB
– AND (Kbytes_max – Kbytes_alloc + NVL(kbytes_free, 0))*100/kbytes_max < 5
– AND (Kbytes_max – Kbytes_alloc + NVL(kbytes_free, 0)) < (2*1024*1024)
ORDER BY (Kbytes_max – Kbytes_alloc + NVL(kbytes_free, 0))*100/kbytes_max, b.tablespace_name
/
spool off

This script will format the new 11G crsctl status resource in a tabular format.

#!/usr/bin/ksh
#
# Sample 11g CRS resource status query script
#
# Description:
# – Returns formatted version of crsctl status resource, in tabular
# format, with the complete rsc names and filtering keywords
# – The argument, $RSC_KEY, is optional and if passed to the script, will
# limit the output to HA resources whose names match $RSC_KEY.
# Requirements:
# – $ORA_CRS_HOME should be set in your environment
#
#
# HISTORY ##################################
#
# 28/06/2010 – Alex Lima – UPgraded to 11G commands.
#
################################################################
export CRS_HOME=/usr/grid/product/11.2.0

RSC_KEY=$1
QSTAT=-u
AWK=/usr/bin/awk # if not available use /usr/xpg4/bin/awk

# Table header:echo “”
echo “”

$AWK \
‘BEGIN {printf “%-30s %-70s %-18s\n”, “HA Resource”, “State”, “Target”;
printf “%-30s %-70s %-18s\n”, “———–”, “—–”, “——”;}’

# Table body:
$CRS_HOME/bin/crsctl status resource | $AWK \
‘BEGIN { FS=”=”; state = 0; }
$1~/NAME/ && $2~/’$RSC_KEY’/ {appname = $2; state=1};
state == 0 {next;}
$1~/STATE/ && state == 2 {appstate = $2; state=3;}
$1~/TARGET/ && state == 1 {apptarget = $2; state=2;}
state == 3 {printf “%-30s %-70s %-18s\n”, appname, appstate, apptarget; state=0;}’
echo “”

Oracle OpenWorld 2010.

I use this simple script to find bind variables with or without sql_id.

select
sql_id,
t.sql_text SQL_TEXT,
b.name BIND_NAME,
b.value_string BIND_STRING
from
v$sql t
join v$sql_bind_capture b
using (sql_id)
where
b.value_string is not null
– and sql_id=’974ju5zc5whfn’;

If you need to generate SQL Profiles and then move to another instance below are the procedures. Just keep in mind that in the example below i generated the SQL Profiles in advance (5) then restored and imported to the same instance.

1- Already had the table so I dropped
SYS@ELSIPOC1 SQL> drop table alex.sql_profiles;

Table dropped.

2- Create the staging table
SYS@ELSIPOC1 SQL> SYS@ELSIPOC1 SQL> BEGIN
2 DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF (
3 table_name => ‘SQL_PROFILES’,
4 schema_name=>’ALEX’);
5 END;
6 /

PL/SQL procedure successfully completed.

3- Packed all the existing SQL profiles in the staging table
SYS@ELSIPOC1 SQL>
SYS@ELSIPOC1 SQL> BEGIN
2 DBMS_SQLTUNE.PACK_STGTAB_SQLPROF (
3 profile_category => ‘%’,
4 staging_table_name => ‘SQL_PROFILES’,
5 staging_schema_owner=>’ALEX’);
6 END;
7 /

PL/SQL procedure successfully completed.

4- Count the staging table
SYS@ELSIPOC1 SQL> select count(*) from alex.sql_profiles;

COUNT(*)
———-
5

SYS@ELSIPOC1 SQL>exit

5- Export the staging table
[spocoradb1.aeso.ca]/dbadmin/workspace2/RAT/capture/CDMS>expdp system/abc123 dumpfile=expdp_sql_profiles.dmp TABLES=ALEX.SQL_PROFILES DIRECTORY=CDMS_REPLAY

Export: Release 11.2.0.1.0 – Production on Tue Jun 8 11:14:04 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Starting “SYSTEM”.”SYS_EXPORT_TABLE_01″: system/******** dumpfile=expdp_sql_profiles.dmp TABLES=ALEX.SQL_PROFILES DIRECTORY=CDMS_REPLAY
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 384 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported “ALEX”.”SQL_PROFILES” 98.50 KB 5 rows
Master table “SYSTEM”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/dbadmin/workspace2/RAT/capture/CDMS/expdp_sql_profiles.dmp
Job “SYSTEM”.”SYS_EXPORT_TABLE_01″ successfully completed at 11:14:53
###

6- Restore the database to a backup taken before All 5 SQL profiles were generated###

7- Truncate all the records from staging table
SYS@ELSIPOC1 SQL> truncate table alex.sql_profiles;

Table truncated.

SYS@ELSIPOC1 SQL> exit

8- import the staging table
[spocoradb1.aeso.ca]/dbadmin/workspace2/RAT/capture/CDMS>impdp system/abc123 dumpfile=expdp_sql_profiles.dmp TABLES=ALEX.SQL_PROFILES DIRECTORY=CDMS_REPLAY TABLE_EXISTS_ACTION=REPLACE

Import: Release 11.2.0.1.0 – Production on Tue Jun 8 11:22:49 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Master table “SYSTEM”.”SYS_IMPORT_TABLE_01″ successfully loaded/unloaded
Starting “SYSTEM”.”SYS_IMPORT_TABLE_01″: system/******** dumpfile=expdp_sql_profiles.dmp TABLES=ALEX.SQL_PROFILES DIRECTORY=CDMS_REPLAY TABLE_EXISTS_ACTION=REPLACE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported “ALEX”.”SQL_PROFILES” 98.50 KB 5 rows
Job “SYSTEM”.”SYS_IMPORT_TABLE_01″ successfully completed at 11:22:54

[spocoradb1.aeso.ca]/dbadmin/workspace2/RAT/capture/CDMS>

9- Drop the 2 existing SQL profiles that were in the instance when backup was taken.
SYS@ELSIPOC1 SQL> BEGIN
dbms_sqltune.drop_sql_profile(‘SYS_SQLPROF_0228d51a0db60000′, TRUE);
END;
/ 2 3 4

PL/SQL procedure successfully completed.

SYS@ELSIPOC1 SQL> BEGIN
dbms_sqltune.drop_sql_profile(‘SYS_SQLPROF_0128d2628b7e0000′, TRUE);
END;
/ 2 3 4

PL/SQL procedure successfully completed.

10- Unpack the SQL profiles from the staging table
SYS@ELSIPOC1 SQL> BEGIN
DBMS_SQLTUNE.UNPACK_STGTAB_SQLPROF(
staging_table_name => ‘SQL_PROFILES’,
staging_schema_owner=>’ALEX’,
replace=>FALSE);
END;
/ 2 3 4 5 6 7

PL/SQL procedure successfully completed.

SYS@ELSIPOC1 SQL>

And you should be done…….

Here is a manual procedures to replay a workload capture without a specific user, by adding filter.

1- ### Create Filter
BEGIN
DBMS_WORKLOAD_REPLAY.ADD_FILTER (
fname => ‘user_web_proxy_exclude_from_replay’,
fattribute => ‘USER’,
fvalue => ‘WEB_PROXY’);
END;
/

2- ### Create filter set, this operation needs to be done when no replay is initialized, prepared or in progress.
BEGIN
DBMS_WORKLOAD_REPLAY.CREATE_FILTER_SET (
replay_dir=> ‘RAT_CDMS_PROD_DIR’,
filter_set => ‘user_web_proxy_filter_set_1′,
default_action => ‘INCLUDE’);
END;
/

3- ### initialize replay
BEGIN
dbms_workload_replay.initialize_replay(
replay_name=>’ELSIPOC_0607_1′,
replay_dir=> ‘RAT_CDMS_PROD_DIR’);
end;
/

4- ### enable use of the filter, this procedure should be called after the replay has been initialized and before it is prepared.
BEGIN
DBMS_WORKLOAD_REPLAY.USE_FILTER_SET (
filter_set => ‘user_web_proxy_filter_set_1′);
END;
/

5- ### Remap all connetions, find the content of the file below.
@/dbadmin/workspace2/RAT/capture/CDMS_PROD/conn-remap.sql

6- ### Prepare the replay
begin
DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY (
synchronization=> TRUE,
connect_time_scale => 15,
think_time_scale =>0,
think_time_auto_correct => TRUE,
scale_up_multiplier => 1);
end;
/

7- ### Run WRC clients
nohup wrc system/abc123@spocoraclu-scan.aeso.ca:1521/ELSIPOC.AESO DEBUG=ON \
REPLAYDIR=/dbadmin/workspace2/RAT/capture/CDMS_PROD \
WORKDIR=/dbadmin/workspace2/RAT/capture/logs/0607 > /tmp/zzz.log &

8- ### Start replay

begin
dbms_workload_replay.start_replay;
end;
/

### Content of the connection file ###
[spocoradb1.aeso.ca]/dbadmin/workspace2>cat /dbadmin/workspace2/RAT/capture/CDMS_PROD/conn-remap.sql
exec dbms_workload_replay.remap_connection(connection_id=>1, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>2, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>3, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>4, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>5, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>6, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>7, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>8, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>9, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>10, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>11, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>12, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>13, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>14, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>15, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>16, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>17, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>18, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>19, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>20, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>21, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>22, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>23, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>24, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>25, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>26, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>27, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>28, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>29, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);
exec dbms_workload_replay.remap_connection(connection_id=>30, replay_connection => ‘(DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE = ON)(ADDRESS = (PROTOCOL = TCP)(HOST = spocoraclu-scan.aeso.ca)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ELSIPOC.AESO)))’);

[spocoradb1.aeso.ca]/dbadmin/workspace2>

The deadline for submission is June 20.

Missed the Call for Papers Deadline? Don’t Despair!