User contributions
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
- 10:12, 11 November 2012 (diff | hist) . . (+173) . . Flashback
- 09:44, 11 November 2012 (diff | hist) . . (+1) . . Flashback (→Put a session back in time)
- 00:10, 11 November 2012 (diff | hist) . . (+345) . . Flashback
- 00:05, 11 November 2012 (diff | hist) . . (+366) . . N Flashback (Created page with "===Enable flashback=== exec dbms_flashback.enable; ===Disable flashback=== exec dbms_flashback.disable; ===To put the session back in time=== Note: undo_management must be auto...")
- 00:01, 11 November 2012 (diff | hist) . . (+15) . . Main Page (→A collection of useful DBA tips and tricks)
- 23:05, 10 November 2012 (diff | hist) . . (+11) . . Handy scripts (→Show which row is locked)
- 23:05, 10 November 2012 (diff | hist) . . (+361) . . Handy scripts (→Show locked objects)
- 23:00, 10 November 2012 (diff | hist) . . (+905) . . Handy scripts (→Info on blocking processes)
- 22:51, 10 November 2012 (diff | hist) . . (+6) . . Handy scripts (→List files that are in hot-backup mode)
- 22:51, 10 November 2012 (diff | hist) . . (+311) . . Handy scripts (→List all datafiles ith their size)
- 22:48, 10 November 2012 (diff | hist) . . (+357) . . Handy scripts
- 22:37, 10 November 2012 (diff | hist) . . (+61) . . Handy scripts
- 22:36, 10 November 2012 (diff | hist) . . (+193) . . Handy scripts
- 22:33, 10 November 2012 (diff | hist) . . (+309) . . N Tablespaces (Created page with "===User quotas on all tablespaces=== col quota format a10 select username , tablespace_name , decode ( max_bytes , -1, 'unlimited' , c...")
- 22:13, 10 November 2012 (diff | hist) . . (+17) . . Database Status
- 22:03, 10 November 2012 (diff | hist) . . (+666) . . Handy scripts
- 21:26, 10 November 2012 (diff | hist) . . (-6) . . Database Overview - from idevelopment (current)
- 21:12, 10 November 2012 (diff | hist) . . (+90) . . Init.ora (current)
- 21:10, 10 November 2012 (diff | hist) . . (+4) . . Init.ora
- 21:10, 10 November 2012 (diff | hist) . . (-6) . . Init.ora
- 21:09, 10 November 2012 (diff | hist) . . (+12) . . Init.ora
- 21:06, 10 November 2012 (diff | hist) . . (0) . . Init.ora
- 21:06, 10 November 2012 (diff | hist) . . (+248) . . N Init.ora (Created page with "===Show non-default parameters=== set pages 999 set lines 100 select name ||'='||decode(type, 2, '''')||value||decode(type, 2, '''') parameter from v$parameter where 1=1 ...")
- 21:04, 10 November 2012 (diff | hist) . . (+13) . . N Configuration (Created page with "*init.ora")
- 21:02, 10 November 2012 (diff | hist) . . (+19) . . Main Page
- 20:27, 10 November 2012 (diff | hist) . . (+1,022) . . Dataguard (→See how up-to-date a standby is)
- 20:22, 10 November 2012 (diff | hist) . . (+1) . . Database sessions (→Show blocking sessions)
- 20:21, 10 November 2012 (diff | hist) . . (+471) . . Database sessions
- 20:01, 10 November 2012 (diff | hist) . . (+258) . . Database sessions
- 19:58, 10 November 2012 (diff | hist) . . (+293) . . Database sessions
- 19:54, 10 November 2012 (diff | hist) . . (+395) . . Database sessions
- 19:52, 10 November 2012 (diff | hist) . . (+362) . . Database sessions
- 19:48, 10 November 2012 (diff | hist) . . (+2) . . Database sessions (→All active sql)
- 19:48, 10 November 2012 (diff | hist) . . (-273) . . Database sessions (→Session status associated with the specified os process id)
- 19:46, 10 November 2012 (diff | hist) . . (0) . . Database sessions
- 16:49, 10 November 2012 (diff | hist) . . (+2,226) . . N Database sessions (Created page with "===Sessions sorted by logon time=== set lines 100 set pages 999 col ID format a15 col osuser format a15 col login_time format a14 select s.username , s...")
- 16:29, 10 November 2012 (diff | hist) . . (+23) . . Main Page
- 15:52, 10 November 2012 (diff | hist) . . (+1,353) . . Database Status
- 15:40, 10 November 2012 (diff | hist) . . (+621) . . N Database Status (Created page with "==How big is the database?=== col "Database Size" format a20 col "Free space" format a20 col "Used space" format a20 select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ' ...")
- 15:36, 10 November 2012 (diff | hist) . . (+21) . . Main Page
- 15:35, 10 November 2012 (diff | hist) . . (0) . . Main Page
- 15:31, 10 November 2012 (diff | hist) . . (0) . . Main Page
- 15:31, 10 November 2012 (diff | hist) . . (+15) . . Main Page
- 15:26, 10 November 2012 (diff | hist) . . (+2,587) . . N Dataguard (Created page with "===Start up a physical standby=== startup nomount alter database mount standby database; alter database recover managed standby database disconnect; ===Stop a physical standb...")
- 14:43, 10 November 2012 (diff | hist) . . (+46) . . Use Physical Standby for testing (current)
- 23:01, 6 November 2012 (diff | hist) . . (+112) . . Handy scripts (→==)
- 22:50, 6 November 2012 (diff | hist) . . (+1,098) . . Handy scripts (→External table for the Alert log)
- 22:47, 6 November 2012 (diff | hist) . . (+672) . . Handy scripts
- 22:33, 6 November 2012 (diff | hist) . . (+6) . . Datapump (→Import into schemas and tablespaces than those contained in the export dump file)
- 22:33, 6 November 2012 (diff | hist) . . (+74) . . Datapump (→Use of a par file to create a consistent parallel export)
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
