Catégorie:Sqlplus
Aller à la navigation
Aller à la recherche
🗂️ Organisation
- ASM
- Diskgroups, disques, alias, fichiers ASM.
- Administration (Dba*)
- Tablespaces, objets invalides, jobs, contraintes, fragmentation d'index — scripts de diagnostic courants.
- Exemples DDL (Example*/Exemple*)
- Scripts de création (tables, index, séquences, LOB, partitionnement, tablespaces).
- Sessions et verrous (Sess*/Locks*)
- Sessions actives, verrous bloquants, transactions en cours.
- Performance (Perf*)
- Buffer cache, I/O fichiers, SGA, latences, top SQL.
- RMAN — vues catalogue
- Requêtes SQL*Plus sur les vues RMAN (backup sets/pieces, configuration) — complémentaire des commandes Rman elles-mêmes.
- Workspace Manager (Wm*)
- Gestion des espaces de travail versionnés (Oracle Workspace Manager).
📌 Pages repères
- Dba tablespaces — état des tablespaces
- Sess users — sessions actives
- Locks blocking — verrous bloquants
🔗 Voir aussi
📊 Contient 214 élément(s) (214 page(s), 0 sous-catégorie(s)).
Pages dans la catégorie « Sqlplus »
Cette catégorie comprend 214 pages, dont les 200 ci-dessous.
(page précédente) (page suivante)A
D
- Dba blocks used by table
- Dba column constraints
- Dba compare schemas
- Dba controlfile records
- Dba controlfiles
- Dba cr init
- Dba db growth
- Dba directories
- Dba errors
- Dba file
- Dba file space usage
- Dba file space usage 7
- Dba file use
- Dba file use 7
- Dba files all
- Dba free space frag
- Dba highwater mark
- Dba index fragmentation
- Dba index schema fragmentation report
- Dba index stats
- Dba invalid objects
- Dba invalid objects summary
- Dba jobs
- Dba object cache
- Dba object search
- Dba object summary
- Dba options
- Dba owner to tablespace
- Dba plsql package size
- Dba query hidden parameters
- Dba random number
- Dba rebuild indexes
- Dba recompile invalid objects
- Dba registry
- Dba related child tables
- Dba row size
- Dba segment summary
- Dba snapshot database 10g
- Dba snapshot database 8i
- Dba snapshot database 9i
- Dba table info
- Dba tables all
- Dba tables current user
- Dba tables query user
- Dba tablespace mapper
- Dba tablespace to owner
- Dba tablespaces
- Dba tablespaces 7
- Dba tablespaces 8
- Dba top segments
E
- Erp conc manager job status
- Erp conc manager job status2
- Erp conc manager user query
- Example create clob 8
- Example create dimension
- Example create emp dept custom
- Example create emp dept original
- Example create index
- Example create index organized table
- Example create materialized view
- Example create not null constraints
- Example create primary foreign key
- Example create profile password parameters
- Example create profile resource parameters
- Example create resource plan multi resource plan 9i
- Example create sequence
- Example create table
- Example create table buffer pools
- Example create tablespace
- Example create temporary tables
- Example create user tables
- Example database resource manager setup
- Example drop unused column
- Example lob demonstration
- Example move table
- Example partition range date oracle 8
- Example partition range number oracle 8
- Example transport tablespace
- Exemple create clob
L
M
P
- Perf db block buffer usage
- Perf explain plan
- Perf file io
- Perf file io 7
- Perf file io efficiency
- Perf file waits
- Perf hit ratio by session
- Perf hit ratio system
- Perf log switch history bytes daily all
- Perf log switch history count daily
- Perf log switch history count daily 7
- Perf log switch history count daily all
- Perf lru latch contention
- Perf objects without statistics
- Perf performance snapshot
- Perf redo log contention
- Perf sga free pool
- Perf sga usage
- Perf shared pool memory
- Perf top 10 procedures
- Perf top 10 tables
- Perf top sql by buffer gets
- Perf top sql by disk reads
- Plsql random numbers
- Plsql webdba utl pkg
R
- Rac instances
- Rc databases
- Requete plan execution
- Rman backup pieces
- Rman backup sets
- Rman backup sets 8i
- Rman configuration
- Rman configuration clear all 9i
- Rman configuration setup 9i
- Rman controlfiles
- Rman progress
- Rman spfiles
- Rollback segments
- Rollback users
- Rsrc plan status detail
- Rsrc plan status summary
S
- Sec default passwords
- Sec roles
- Sec users
- Sess current user transactions
- Sess query sql
- Sess uncommited transactions
- Sess user sessions
- Sess user stats
- Sess user trace file location
- Sess users
- Sess users 8i
- Sess users active
- Sess users active 8i
- Sess users active sql
- Sess users by CPU
- Sess users by cursors
- Sess users by io
- Sess users by memory
- Sess users by transactions
- Sess waiting
- Sess waiting 8i
- Session plus consommatrices
- SGA usage
- Sp auto
- Sp auto 15
- Sp auto 30
- Sp auto 5
- Sp list
- Sp parameters
- Sp purge
- Sp purge 30days 10g
- Sp purge 30days 9i
- Sp snap
- Sp statspack custom pkg 10g
- Sp statspack custom pkg 9i
- Sqlplus buffer
- Sqlplus dictionnaire