ORACLE技术问题1000问完整版.docx

?

?

ORACLE之1000问

?

?

???ORACLE之1000问

1.Oracle安装完成后的初始口令??

?internal/oracle?

sys/change_on_install?

system/manager?

scott/tiger?

sysman/oem_temp?

2.ORACLE9IASWEBCACHE的初始默认用户和密码？?

??administrator/administrator?

3.oracle8.0.5怎么创建数据库??

??用orainst。如果有motif界面，可以用orainst/m?

4.oracle8.1.7怎么创建数据库??

??dbassist?

5.oracle9i怎么创建数据库??

??dbca?

6.oracle中的裸设备指的是什么??

??裸设备就是绕过文件系统直接访问的储存空间?

7.oracle如何区分64-bit/32bit版本？?

$sqlplus/ASSYSDBA?

SQL*Plus：Release.0-ProductiononMonJul1417：01：092003?

(c)Copyright2001OracleCorporation.Allrightsreserved。?

Connectedto：?

Oracle9iEnterpriseEditionRelease.0-Production?

WiththePartitioningoption?

JServerRelease.0-Production?

SQLselect*fromv$version；?

BANNER?

----------------------------------------------------------------?

Oracle9iEnterpriseEditionRelease.0-Production?

PL/SQLRelease.0-Production?

CORE.0Production?

TNSforSolaris：Version.0-Production?

NLSRTLVersion.0-Production?

SQL?

8.SVRMGR什么意思？?

svrmgrl，ServerManager9i下没有，已经改为用SQLPLUS了?

sqlplus/nolog变为归档日志型的?

9.请问如何分辨某个用户是从哪台机器登陆ORACLE的??

SELECTmachine，terminalFROMV$SESSION；?

10.用什么语句查询字段呢？?

desctable_name可以查询表的结构?

selectfield_name，...from...可以查询字段的值?

select*fromall_tableswheretable_namelike%?

select*fromall_tab_columnswheretable_name=???

11.怎样得到触发器、过程、函数的创建脚本？?

descuser_source?

user_triggers?

12.怎样计算一个表占用的空间的大小？?

selectowner，table_name，NUM_ROWS，BLOCKS*AAA/1024/1024SizeM，EMPTY_BLOCKS，LAST_ANALYZED?

fromdba_tables?

wheretable_name=XXX；?

Here：AAAisthevalueofdb_block_size；?

XXXisthetablenameyouwanttocheck?

13.如何查看最大会话数？?

SELECT*FROMV$PARAMETERWHERENAMELIKEproc%；?

SQL?

SQLshowparameterprocesses?

NAMETYPEVALUE?

-------------------------------------------------------------------------?

aq_tm_processesinteger1?

db_writer_processesinteger1?

job_queue_processesinteger4?

log_archive_max_processesinteger1?

processesinteger200?

这里为200个