New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 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...")
- 22:55, 8 November 2019 Check Database Size (hist) [295 bytes] Admin (talk | contribs) (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 Check Oracle Open Cursors by Session (hist) [236 bytes] Admin (talk | contribs) (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 Check Oracle Blocking Locks (hist) [752 bytes] Admin (talk | contribs) (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 Check Temp Tablespace Usage (hist) [300 bytes] Admin (talk | contribs) (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...")
- 22:52, 8 November 2019 Check Undo Tablespace Usage (hist) [109 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sum(blocks) , sum(bytes)/1024/1024 FROM dba_undo_extents; </pre></blockquote>")
- 22:51, 8 November 2019 Check Database UpTime in Unix (hist) [56 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> ps -ef | grep pmon </pre></blockquote>")
- 22:51, 8 November 2019 Scripts to monitor database is up (hist) [3,555 bytes] Admin (talk | contribs) (Created page with "Scenario is I do not have access to Oracle Enterprise Manager or any other monitoring utility and I need to make sure the database is up. Simply checking pmon is not enough,...")
- 22:05, 8 November 2019 Administrative-Tasks (hist) [1,919 bytes] Admin (talk | contribs) (Created page with " Scripts to monitor database is up Check Database UpTime in Unix Check Undo Tablespace Usage | C...")
- 22:02, 8 November 2019 Linux Filesystem Alerting Script (hist) [5,788 bytes] Admin (talk | contribs) (Created page with "This convoluted beauty does a df -h on both a Production and Standby Filesystem (oracle datafile and backup directories) and warns when the threshold of 85% is exceeded and al...")
- 22:01, 8 November 2019 SQL Across Multiple Servers with Password Prompts (hist) [791 bytes] Admin (talk | contribs) (Created page with "An example of a shell script which connects to multiple unix hosted databases and runs a simple SQL. This version prompts for the username/password. <blockquote><pre> #!/bin...")