New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 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...")
- 22:01, 8 November 2019 SQL Across Multiple Servers (hist) [601 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 emails the logfile to people on the mailing list. <blockquot...")
- 21:59, 8 November 2019 Load Multiple (over 100,000) Files (hist) [1,853 bytes] Admin (talk | contribs) (Created page with "Requirement is to load 100,000+ CSV files via SQL Loader. Files are located in an Unix directory. Initially attempted to load the files through a single controlfile and it a...")
- 21:57, 8 November 2019 Change Apex 4.0 Admin Password (hist) [1,524 bytes] Admin (talk | contribs) (Created page with "To change the Admin user password on Apex 4.0 run the script '''apxxepwd.sql'''. This will change the encrypted password stored in table apex_040000.wwv_flow_fnd_user. '''Th...")
- 21:57, 8 November 2019 Check last DML time - if available (hist) [98 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre>select scn_to_timestamp(max(ora_rowscn)) from scott.employees;</pre></blockquote>")
- 21:56, 8 November 2019 CHANGE text on the current line (hist) [907 bytes] Admin (talk | contribs) (Created page with "A very basic feature of SQL *Plus which I had forgotten through the passage of time. Documented here so I don't forget again .. You use this to change values on the current...")
- 21:55, 8 November 2019 The glogin.sql File (hist) [672 bytes] Admin (talk | contribs) (Created page with "Whenever SQL *Plus starts up, it looks for a file named glogin.sql which is usually stored under $ORACLE_HOME/sqlplus/admin. You can modify this file to store settings, like...")
- 21:55, 8 November 2019 Create Table As (hist) [197 bytes] Admin (talk | contribs) (Created page with "To create a table identical to another table, yet without any of the data, simply use the following syntax: <blockquote><pre> CREATE tableA AS (SELECT * FROM tableB WHERE 1=2...")
- 21:54, 8 November 2019 Handy values for Oracle Date Functions (hist) [379 bytes] Admin (talk | contribs) (Created page with "* 1 / 24 = one hour * 1 / 1440 = one minute * 1 / 86400 = one second A good way to test the use of the above constructs: <blockquote><pre> SQL> ALTER SESSION SET NLS_...")
- 21:54, 8 November 2019 Append DateTime to Spool File (hist) [668 bytes] Admin (talk | contribs) (Created page with "This is how you append the date/time to an output spool file in SQL *Plus: <blockquote><pre> -- This construct is used to select a value into a user variable SQL> COLUMN dtt...")
- 21:53, 8 November 2019 UNION (ALL), INTERSECT, MINUS Operators (hist) [3,499 bytes] Admin (talk | contribs) (Created page with "The UNION operator is useful when you want to draw information from two or more tables that all have the same structure. Take for example two tables AUSTRALIA_CRICKET contai...")