User contributions
Jump to navigation
Jump to search
- 12:47, 18 April 2016 diff hist +503 N List connected sessions Created page with "Show connected sessions, join of v$session and v$process <source lang="sql"> select s.*, p.* from gv$session s , gv$process p where p.addr = s.paddr and p.inst_id =..." current
- 12:45, 18 April 2016 diff hist +29 Oracle →DBA / Tuning
- 14:09, 13 April 2016 diff hist +440 N Alter logfiles Created page with "Sometimes you want to change a logfile that's still in use. In order to clear it and drop it, execute following commands: <source lang="sql"> alter system checkpoint; alter da..." current
- 14:07, 13 April 2016 diff hist +21 Oracle →DBA
- 11:22, 13 April 2016 diff hist +277 N Linux startup scripts Created page with "=Centos= See what's defined in the startup levels: <source lang="sh"> chkconfig </source> =Gentoo= See what's defined in the startup levels: <source lang="sh"> rc-update -s -..."
- 11:20, 13 April 2016 diff hist +45 Linux snippets
- 15:17, 8 April 2016 diff hist +278 N Datafile operations Created page with "Add datafile: <source lang="sql"> alter tablespace mytablespace add datafile '/dir/file01.dbf' size 20G; alter tablespace mytablespace add datafile '+DATA' size 20G; </source>..." current
- 15:15, 8 April 2016 diff hist +33 Oracle
- 15:47, 6 April 2016 diff hist +263 N Oracle Backup & Restore Created page with "Script to create a backup of all archivelogs and remove them <source lang="sh"> export ORACLE_SID=MYSID export ORACLE_HOME=/oracle/product/11.2/dbhome_1 export PATH=$PATH:$ORA..." current
- 15:44, 6 April 2016 diff hist +32 Oracle
- 15:13, 6 April 2016 diff hist +771 Index Monitoring current
- 12:10, 5 April 2016 diff hist +1,182 N Flash Cache Created page with "Enable flash cache: <source lang="sql"> alter system set db_flash_cache_file='/flash/cache.dbf' scope=spfile; alter system set db_flash_cache_size=10G scope=spfile; </source>..." current
- 12:03, 5 April 2016 diff hist +18 Oracle →DBA / Tuning
- 12:10, 4 April 2016 diff hist +481 N Forall insert Created page with "Create table containing 100M records: <source lang="plsql"> create table testtable(id number); declare type t_table is table of testtable%rowtype index by binary_integer;..." current
- 12:09, 4 April 2016 diff hist +27 Oracle →DBA / Tuning