Welcome, This is an oracle 10g test
800MB
1.2GB
1.5GB
Java pool
Log buffer
Large pool
LGR and online redo log
DBW and archived log
DBW and database buffer cache
Change parameter cursor_sharing from similar to exact
Change parameter cursor_sharing from exact to similar
Use the shared server mode
The segment is moved to SYSAUX tablespace
The segment is still available until the tablespace is full
The segment is still available until the next restart
SHARED_POOL_SIZE can grow up to have SGA=2GB
SHARED_POOL_SIZE can grow up to have SGA=1GB
SHARED_POOL and LARGE_POOL has the specified fixed size
Segment Advisor
ADDM
Memory Advisor
Flashback logs are archived
“Alter database flashback on” must be executed when the instance is mounted
Flashback logs can be manually deleted
UNDO_TABLESPACE
REDO_LOG
Flash recovery area
Backup will be maintained on media for 15 days
Backup will be maintained in recovery catalogue and control file for 15 days
Backup will be maintained in control file for 15 days
You can set AUTOEXTEND at tablespace level
You can set AUTOEXTEND to a dedicated data file
You must set AUTOEXTEND to all data files of a tablespace
Binary backup of the control file
Script to create the control file with the data files
Script to create the control file with the data files and temp files
Alter table statement
Dbms_redefinition package
It is no possible to do it online
The result is the same as drop and create index
It is not possible to rebuild index online
It will be reorganized but the index will keep his depth
V$session
V$process
V$session and v$process
Using ipcs Unix command
Using ipcrm Unix command
It is not possible to do it with an oracle account, call the System Administrator.
each modify object
Stale data
At fixed time interval
Connect to the listener and: set trace_level_listener=admin
Connect to the listener and: set trc_level admin
Restart the listener with the appropriate command option
Using “sys.dbms_system.set_sql_trace_in_session…”
Using “set autotrace on”
Using “alter session trace on”
Not exclude statements run as user SYS
Get information on wait events
Get information on memory usage
Index are not impacted
Parallel query is not allowed during the move of the table
The move will suppress chained rows
C will see the data modified by A and B
C can reach an ORA-01555 if UNDO tablespace is too small
C will have to wait for the end of the update from A and B
UNION ALL
UNION
UNION and UNION ALL gives no performance difference
Dbms_utility.compile_schema
Create our own sql script
Use the Oracle utlrp.sql script
Shutdown the instance and start a complete recovery
Shutdown the instance and start it with “open resetlogs”
Drop the lost member with the instance running and add a new member