User contributions
Jump to navigation
Jump to search
- 22:57, 8 November 2019 diff hist +376 N 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..." current
- 22:56, 8 November 2019 diff hist +965 N 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..." current
- 22:56, 8 November 2019 diff hist +1,557 N 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..." current
- 22:55, 8 November 2019 diff hist +722 N 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..." current
- 22:55, 8 November 2019 diff hist +854 N 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..." current
- 22:55, 8 November 2019 diff hist +295 N 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..." current
- 22:54, 8 November 2019 diff hist +236 N 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..." current
- 22:53, 8 November 2019 diff hist +752 N 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..." current
- 22:52, 8 November 2019 diff hist +300 N 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..." current
- 22:52, 8 November 2019 diff hist +109 N Check Undo Tablespace Usage Created page with "<blockquote><pre> SELECT sum(blocks) , sum(bytes)/1024/1024 FROM dba_undo_extents; </pre></blockquote>" current
- 22:51, 8 November 2019 diff hist +56 N Check Database UpTime in Unix Created page with "<blockquote><pre> ps -ef | grep pmon </pre></blockquote>" current
- 22:51, 8 November 2019 diff hist +3,555 N Scripts to monitor database is up 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,..." current
- 22:05, 8 November 2019 diff hist +1,119 N Administrative-Tasks Created page with " Scripts to monitor database is up Check Database UpTime in Unix Check Undo Tablespace Usage | C..."
- 22:05, 8 November 2019 diff hist +44 MediaWiki:Sidebar
- 22:03, 8 November 2019 diff hist +38 Linux Filesystem Alerting Script current
- 22:02, 8 November 2019 diff hist +5,750 N Linux Filesystem Alerting Script 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 diff hist +791 N SQL Across Multiple Servers with Password Prompts 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..." current
- 22:01, 8 November 2019 diff hist +601 N SQL Across Multiple Servers 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..." current
- 22:00, 8 November 2019 diff hist -77 Development-Tasks current
- 22:00, 8 November 2019 diff hist +77 Development-Tasks
- 21:59, 8 November 2019 diff hist +1,853 N Load Multiple (over 100,000) Files 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..." current
- 21:59, 8 November 2019 diff hist 0 Development-Tasks
- 21:57, 8 November 2019 diff hist +1,524 N Change Apex 4.0 Admin Password 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..." current
- 21:57, 8 November 2019 diff hist +98 N Check last DML time - if available Created page with "<blockquote><pre>select scn_to_timestamp(max(ora_rowscn)) from scott.employees;</pre></blockquote>" current
- 21:56, 8 November 2019 diff hist +907 N CHANGE text on the current line 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..." current
- 21:55, 8 November 2019 diff hist +672 N The glogin.sql File 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..." current
- 21:55, 8 November 2019 diff hist +197 N Create Table As 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..." current
- 21:54, 8 November 2019 diff hist +379 N Handy values for Oracle Date Functions 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_..." current
- 21:54, 8 November 2019 diff hist +668 N Append DateTime to Spool File 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..." current
- 21:53, 8 November 2019 diff hist +3,499 N UNION (ALL), INTERSECT, MINUS Operators 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..." current
- 21:53, 8 November 2019 diff hist +811 N Invoke SQL *Plus through Textpad Created page with "This will only benefit those people who use the product Textpad and SQL *Plus. If you wish to run SQL *Plus scripts direct through Textpad, you can set it up as follows: ''..." current
- 21:53, 8 November 2019 diff hist +554 N SQL *Plus Ignore Ampersands Created page with "In SQL *Plus when an ampersand (&) is encountered, Oracle treats it as a value prompt. For example, if you try to execute the following statement: <blockquote><pre> INSERT..." current
- 21:52, 8 November 2019 diff hist +1,725 N Trigger to Create Public Synonyms Created page with "We have an application which creates dynamic temporary tables, which require public synonymns generated to enable users to access these tables. The solution which came to mi..." current
- 21:52, 8 November 2019 diff hist +1,481 N Autonomous Transactions (10g) Created page with "'''Requirement''' The task at hand was to create a web-based stored procedure which would enable people from our Security team to add database users themselves, rather than f..." current
- 21:51, 8 November 2019 diff hist +4,361 N Password Change Reminder Procedure Created page with "The following steps are how I set up a process to remind users to change their Oracle password 7 days prior to the expiry .. '''**Note: I have created a schema called ORACLE_..." current
- 21:50, 8 November 2019 diff hist +2,343 N PL/SQL Send Mail Procedure Created page with "A useful way of sending email through Oracle. Parameters such as the SMTP host servername, SMTP port may be entered in as default values or be passed in for greater flexibil..." current
- 21:50, 8 November 2019 diff hist +1,407 N Development-Tasks Created page with "=== PL/SQL === PL/SQL Send Mail Procedure Password Change Reminder Procedure Autonomous Transacti..."
- 21:48, 8 November 2019 diff hist +68 N Installation-Tasks Created page with "Switching On/Off Options (11g-R2)" current
- 21:47, 8 November 2019 diff hist +43 MediaWiki:Sidebar
- 21:45, 8 November 2019 diff hist -41 MediaWiki:Sidebar
- 21:44, 8 November 2019 diff hist -11 MediaWiki:Sidebar
- 21:43, 8 November 2019 diff hist -44 MediaWiki:Sidebar
- 21:40, 8 November 2019 diff hist +8,323 N Oracle Switching OnOff Options Created page with "After an Installation of Oracle Software, you may wish to turn off certain features. These are the steps. Check v$option to see what options are turned on/off <blockquote><p..." current
- 21:40, 8 November 2019 diff hist -8,330 Oracle Replaced content with "===Installation Tasks=== Switching On/Off Options (11g-R2)" current Tag: Replaced
- 21:39, 8 November 2019 diff hist -55 Oracle
- 21:39, 8 November 2019 diff hist +8,478 N Oracle Created page with "===Post Installation Tasks=== Switching On/Off Options (11g-R2) **************************************************** After an Installatio..."
- 21:38, 8 November 2019 diff hist -4 MediaWiki:Sidebar
- 21:37, 8 November 2019 diff hist +189 N MediaWiki:Sidebar Created page with " * navigation ** mainpage|mainpage-description ** Oracle-url|Oracle ** recentchanges-url|recentchanges ** randompage-url|randompage ** helppage|help-mediawiki * SEARCH * TOOLB..."
- 21:32, 8 November 2019 diff hist +2 Main Page →Introduction current
- 21:32, 8 November 2019 diff hist -407 Main Page