Oracle Express Edition (XE) 21C (21.3.0)
默认创建1个PDB
第一次进入需等待初始化建库完成
预计5分钟
查看建库进度
su - oracle tail -f /opt/oracle/diag/rdbms/xe/XE/trace/alert_XE.log
复制
检查实例状态为open
sqlplus / as sysdba
select status from v$instance;
show pdbs
复制
初始化HR Schema Demo
alter session set container=xepdb1;
@?/demo/schema/human_resources/hr_main.sql
复制
依次输入密码,默认表空间,日志目录
hr2021
USERS
TEMP
$ORACLE_HOME/demo/schema/log/
检查监听
lsnrctl status
复制
HR用户登录
sqlplus hr/hr2021@modb:1521/xepdb1
col TABLE_NAME for a50
select table_name,num_rows from user_tables;
复制
查询SQL
SELECT e.first_name || ' ' || e.last_name "Name",
TRUNC(MONTHS_BETWEEN(j.end_date, j.start_date)) "Months Worked"
FROM employees e, job_history j
WHERE e.employee_id = j.employee_id
ORDER BY "Months Worked";
exit
复制
内置了常用的34个常用脚本在/home/oracle/admin目录下
cd /home/oracle/admin/ sqlplus / as sysdba !ls
复制
2pc_clean.sql bind_noused.sql segment_size.sql sqlhis_awr.sql wait_event.sql
ash_sql_line_id.sql cursor_purge.sql session_kill.txt sqlinfo_total.sql wait_event_block.sql
ash_top_sql_event.txt ddl_metadata.sql session_sid.sql tablespace_used.sql wait_event_hash.sql
ash_used.txt dml_get.sql session_spid.sql tabstat.sql wait_event_sqlid.sql
awr_db_time.sql fra_get.sql shared_pool_free.sql temp_used.txt wait_session_hash.sql
awr_event_histogram.txt param_get.sql sql_monitor.sql transaction_get.sql wait_session_sqlid.sql
awr_metric_name.sql redo_switch.sql sql_profile.txt undo_used.sql
等待事件
@wait_event.sql
复制
查看表空间
@tablespace_used.sql
复制