Oracle Management Categories
It's a wide topic of Oracle management knowledge, I think it can be list as following.
Init Parameters(ja)
Init parameters are paramters to control Oracle behavior.
Oracle Software (ja)
Oracle DB software is the binary executable files.
- Oracle Database Software Download、Oracle Software Install(ja)、Oracle Component Install / Uninstall(ja)、Oracle Software Uninstall(ja)
- Install oracle db and config sqlplus, isqlplus and em
Oracle Database (ja)
Oracle Database is the unit to store related data.
Storage Management(ja)
Oracle storage management task include tablespace, datafile and ASM management.
- Tablespace (ja)、RAW Device (ja)と(ja)
- create, add, delete, modify
- Tablespace Fragmentation and Defragmentation (jp)
- Oracle Rawdevice To File System Migration
- Oracle row chaining and row migration
Instance (ja)
Oracle database instance is the set of executed processes and shared memory.
Memory
Oracle DB memory management is the management of SGA, PGA, UGA.
Redo and Undo Management
Table(ja)
Oracle database table is a unit to store one data entity or one relation.
SQL*Net
Oracle Database network service.
Security
- Privilege and Grant, Revoke operations
- Protect oracle database object from drop operation
Oracle Performance Tuning
- Monitoring Performance
- Shared Pool Tuning
- Tuning SQL
- Datawarehouse
Collaboration consistence(ja)
Oracle database collaboration feature is not a physical feature, but it's a important feature of Oracle.
Index(ja)
Oracle database index is DB object to fasten query execution or ensure the uniqual of table.
- B-Tree Index(ja)、Bitmap Index(ja)
- Create, Delete, Modify
Backup(ja)とRecovery(ja)
Oracle Database is a good database that provide lots of backup and recovery method for product environment.
- exp(ja)、imp(ja)、RMAN、Tape Backup(ja)、Alter database,tablespace,datafile backup(ja)、Flashback(ja)
- Oracle Rman Command Memo
- Oracle Rman Restore Validate Backup Sets
- Oracle Rman and ASM
SQL*Loader(ja)
SQL*Loader is the utility to load flat file.
Resource Manager(ja)
Resource manager is the feature to restrict the resource consumption and optimize the resource allocation and fasten the entire system.
Oracle Scheduler and Jobs
SQL*Net(ja)
DB Security(ja)
tuning(ja)
* Load Test(ja)
* Linux IO Benchmark
Maintenance
Data Transport(ja)
- Transport Overview(ja)
- Transport with exp/imp
- Transport with expdp/impdp
- Transport with Transportable Tablespace
- Transport with RMAN
- Transport with CREATE TABLE AS/INSERT SELECT
- Transport with CSV+SQLLDR
- Transport with STREAM
Management Utility
Oracle Enterprise Manager(ja)
OS
High Availability
Other Advanced Topics
新功能(ja)
Individual Oracle Software and Thridparty Software
Tasks and Samples
- Change Oracle Charactor Set(ja)
- Manage a unknown database(ja)
- Analyze Schema(ja)
- Create log miner package(ja)
- Oracle Text(ja)
Management Tips
Oracle Source File
- sql
- pls - plsql source file
- pks - plsql source file
- plb - plsql text file
- pkb - plsql text file