All public logs

Combined display of all available logs of NazimWIKI. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)

• 23:07, 8 November 2019 Admin talk contribs created page User Defined Metrics (Created page with "<blockquote><pre> SELECT * FROM mgmt$metric_current WHERE metric_name like '%UDM%'; </pre></blockquote> <blockquote><pre> SELECT * FROM mgmt$metric_hourly WHERE target...")
• 23:06, 8 November 2019 Admin talk contribs created page List DBs on AIX (Created page with "<blockquote><pre> select target_name , host_name from mgmt$target where target_type='oracle_database' and host_name in (select target_name...")
• 23:06, 8 November 2019 Admin talk contribs created page UDM Collection Interval (Created page with "You may have noticed that User Defined Metrics (UDM) in Oracle Enterprise Manager (OEM) have a minimum collection time of '''5''' minutes. If you wish to change this interva...")
• 23:04, 8 November 2019 Admin talk contribs created page High Level Steps to Migrate Datafiles (Disk Groups) (Created page with "Just some notes for my own reference. Had to migrate all my datafiles on a database from one Disk Group (DATA) to Another (DATAR), using RMAN to copy the datafiles. '''Pre-...")
• 23:03, 8 November 2019 Admin talk contribs created page Check Disk Groups (Created page with "<blockquote><pre> SELECT NAME, HEADER_STATUS, PATH, OS_MB FROM V$ASM_DISK ORDER BY NAME; </pre></blockquote>")
• 23:01, 8 November 2019 Admin talk contribs created page DBLinks not in Use (Created page with "<pre> select db_link from dba_db_links where db_link not in (select db_link from dba_db_links where db_link in (select referen...")
• 23:00, 8 November 2019 Admin talk contribs created page Trigger to Startup Pluggable Databases and Services (Created page with "The following trigger starts up all pluggable databases once the container database has been started and calls a stored procedure which starts up services which have been set...")
• 23:00, 8 November 2019 Admin talk contribs created page Dynamically Create/Drop Restore Points (Created page with "Task Objective: To create a Guaranteed Restore Point Dynamically and remove the earlier Restore Point if more than 2 exist. <blockquote><pre> set serveroutput on declare v_k...")
• 22:58, 8 November 2019 Admin talk contribs created page Enable Resumable (Created page with "As a DBA one thing I've seen quite a few times is tablespaces being maxed out by large data loads, which in turn leads to the data load being rolled back and developers having...")
• 22:58, 8 November 2019 Admin talk contribs created page Lookup v$ Views (Created page with "It's often difficult to remember which v$ view contains information you might be after. One way of quickly looking up the various views, is to run a query on the v$fixed_tabl...")
• 22:57, 8 November 2019 Admin talk contribs created page Create User Script (Created page with "There are many ways of cloning a user account or two from one database to another. Here are a few simple SQLs to dynamically generate scripts from the source database, which c...")
• 22:57, 8 November 2019 Admin talk contribs created page Sys Aux Statistics (Created page with "Note to-self: Hardware Stats are stored in <blockquote><pre> SYS.AUX_STATS$ </pre></blockquote> To gather the statistics: <blockquote><pre> exec dbms_stats.gather_system_st...")
• 22:56, 8 November 2019 Admin talk contribs created page Process Details with SQL Text (Created page with "<blockquote><pre> SELECT s.sid , p.pid , p.spid , s.process , s.status , s.username , s.osuser , s.program , a.name , s.client_inf...")
• 22:56, 8 November 2019 Admin talk contribs created page Logon Audit Trigger (Created page with "This is my version of a logon audit trigger. It picks up every iteration of a logon, even to the point of when a session switches from ACTIVE/INACTIVE mode. The more convent...")
• 22:55, 8 November 2019 Admin talk contribs created page Object with Block Corruption (Created page with "Identifying which object is corrupt in a block corruption .... ORA-01578: ORACLE data block corrupted (file # 54, block # 18689) <pre> select * from dba_extents where fil...")
• 22:55, 8 November 2019 Admin talk contribs created page Check Generated Archivelog Sizes (Created page with "Script may or may not work for everyone. The difficulty with this one is that it has to get the archivelog sizes from v$archived_log which could contain duplicate rows as ind...")
• 22:55, 8 November 2019 Admin talk contribs created page Check Database Size (Created page with "<blockquote><pre> SELECT sum(megabytes) FROM ( SELECT sum(bytes)/1024/1024 megabytes FROM dba_temp_files UNION SELECT sum(bytes)/1024/1024 megabytes FROM...")
• 22:54, 8 November 2019 Admin talk contribs created page Check Oracle Open Cursors by Session (Created page with "<blockquote><pre> select o.sid, o.sql_text, o.address, o.hash_value, o.user_name, s.schemaname, o.sql_id from v$open_cursor o, v$session s where o.saddr = s.saddr a...")
• 22:53, 8 November 2019 Admin talk contribs created page Check Oracle Blocking Locks (Created page with "<blockquote><pre> SELECT to_char(sysdate,'yyyy-mm-dd hh24:mi') dttm , ' --- BLOCKER --- ' , lo.session_id , lo.process , lo.os_user_name , dob.object...")
• 22:52, 8 November 2019 Admin talk contribs created page Check Temp Tablespace Usage (Created page with "<blockquote><pre> SELECT distinct s.username , s.sid , s.serial# , s.osuser , u.tablespace , u.contents , u.segtype , u.extents , u.blo...")

(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)