New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 23:09, 8 November 2019 Database Size (1) (hist) [1,111 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> select a.DTTM , trim(substr(a.target_name, instr(a.target_name,'.')+1,20)) HOST_NAME , trim(substr(a.target_name, 1, instr(a.target_name,'.')-1))...")
- 23:08, 8 November 2019 Clearing Alerts (hist) [421 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT 'execute em_severity.delete_current_severity(p_target_guid =>'''||sev.target_guid||''', p_metric_guid =>'''||sev.metric_guid||''' , p_key_value...")
- 23:08, 8 November 2019 Datafile Size (hist) [345 bytes] Admin (talk | contribs) (Created page with "In my case, I used the following scripts to list the datafiles incorrectly set to unlimited, i.e. growing to 32768M. <blockquote><pre> SELECT target_name , file_name...")
- 23:07, 8 November 2019 Tablespace Allocated and Used (hist) [844 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT A.RT , A.ALLOCATED , B.USED FROM (SELECT TO_CHAR(ROLLUP_TIMESTAMP,'YYYY-MM') RT , AVG(AVERAGE) ALLOCATED FROM MGMT$...")
- 23:07, 8 November 2019 User Defined Metrics (hist) [287 bytes] Admin (talk | contribs) (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 List DBs on AIX (hist) [1,173 bytes] Admin (talk | contribs) (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 UDM Collection Interval (hist) [581 bytes] Admin (talk | contribs) (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 High Level Steps to Migrate Datafiles (Disk Groups) (hist) [2,038 bytes] Admin (talk | contribs) (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 Check Disk Groups (hist) [108 bytes] Admin (talk | contribs) (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 DBLinks not in Use (hist) [264 bytes] Admin (talk | contribs) (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 Trigger to Startup Pluggable Databases and Services (hist) [1,196 bytes] Admin (talk | contribs) (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 Dynamically Create/Drop Restore Points (hist) [1,260 bytes] Admin (talk | contribs) (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 Enable Resumable (hist) [2,781 bytes] Admin (talk | contribs) (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 Lookup v$ Views (hist) [549 bytes] Admin (talk | contribs) (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 Create User Script (hist) [1,481 bytes] Admin (talk | contribs) (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 Sys Aux Statistics (hist) [376 bytes] Admin (talk | contribs) (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 Process Details with SQL Text (hist) [965 bytes] Admin (talk | contribs) (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 Logon Audit Trigger (hist) [1,557 bytes] Admin (talk | contribs) (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 Object with Block Corruption (hist) [722 bytes] Admin (talk | contribs) (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 Check Generated Archivelog Sizes (hist) [854 bytes] Admin (talk | contribs) (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...")