Table and V$-view common used in Oracle 2020-01-07 Oracle Knowledge, Oracle Comments parameter123 动态性能视图123456789101112131415161718192021222324252627282930313233343536373839404142434445464748v$parameterv$sessionv$processv$sqlv$sqltextv$sqlareav$tablespacev$sgav$sgainfov$sgastatv$sga_dynamic_componentsv$sga_dynamic_free_memoryv$controlfilev$logv$logfilev$datafilev$tempfilev$archived_logv$pgastatv$sgainfov$db_cache_advice(可以建议nk buffer cache大小)v$bgprocessv$block_change_trackingv$backup_filesv$backup_setv$backup_piecev$backup_redologv$backup_spfilev$backup_datafilev$backup_devicev$rman_configurationv$database_block_corruptionv$backup_corruptionv$copy_corruptionv$recover_filev$session_longops-- 监视rman异步IOv$backup_async_io-- 监视rman同步IOv$backup_sync_io-- awr-relatedv$sysaux_occupants 数据字典表1 数据库12345-- 查看数据库服务器上数据库个数cat /etc/oratab -- 由dbca新建的库均记录于此,也意味着手工建库如果不更新此文件,那么此参考将无价值ls $ORACLE_BASE/admin -- 查看文件夹个数ls $ORACLE_BASE/oradata -- 查看数据文件夹(含数据库文件的)个数