All public logs

Jump to navigation Jump to search

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).

Logs
(newest | oldest) View ( | older 50) (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...")
  • 22:52, 8 November 2019 Admin talk contribs created page Check Undo Tablespace Usage (Created page with "<blockquote><pre> SELECT sum(blocks) , sum(bytes)/1024/1024 FROM dba_undo_extents; </pre></blockquote>")
  • 22:51, 8 November 2019 Admin talk contribs created page Check Database UpTime in Unix (Created page with "<blockquote><pre> ps -ef | grep pmon </pre></blockquote>")
  • 22:51, 8 November 2019 Admin talk contribs created page 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,...")
  • 22:05, 8 November 2019 Admin talk contribs created page Administrative-Tasks (Created page with " Scripts to monitor database is up Check Database UpTime in Unix Check Undo Tablespace Usage | C...")
  • 22:02, 8 November 2019 Admin talk contribs created page 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 Admin talk contribs created page 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...")
  • 22:01, 8 November 2019 Admin talk contribs created page 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...")
  • 22:00, 8 November 2019 Admin talk contribs deleted page Multiple (over 100,000) File Load) (content was: "Requirement is to load 100,000+ CSV files via SQL Loader. Files are located in an Unix directory. Initially attempted to load the files th...", and the only contributor was "Admin" (talk))
  • 21:59, 8 November 2019 Admin talk contribs created page 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...")
  • 21:58, 8 November 2019 Admin talk contribs created page Multiple (over 100,000) File Load) (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 Admin talk contribs created page 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...")
  • 21:57, 8 November 2019 Admin talk contribs created page Check last DML time - if available (Created page with "<blockquote><pre>select scn_to_timestamp(max(ora_rowscn)) from scott.employees;</pre></blockquote>")
  • 21:56, 8 November 2019 Admin talk contribs created page 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...")
  • 21:55, 8 November 2019 Admin talk contribs created page 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...")
  • 21:55, 8 November 2019 Admin talk contribs created page 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...")
  • 21:54, 8 November 2019 Admin talk contribs created page 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_...")
  • 21:54, 8 November 2019 Admin talk contribs created page 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...")
  • 21:53, 8 November 2019 Admin talk contribs created page 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...")
  • 21:53, 8 November 2019 Admin talk contribs created page 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: ''...")
  • 21:53, 8 November 2019 Admin talk contribs created page 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...")
  • 21:52, 8 November 2019 Admin talk contribs created page 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...")
  • 21:52, 8 November 2019 Admin talk contribs created page 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...")
  • 21:51, 8 November 2019 Admin talk contribs created page 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_...")
  • 21:50, 8 November 2019 Admin talk contribs created page 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...")
  • 21:50, 8 November 2019 Admin talk contribs created page Development-Tasks (Created page with "=== PL/SQL === PL/SQL Send Mail Procedure Password Change Reminder Procedure Autonomous Transacti...")
  • 21:48, 8 November 2019 Admin talk contribs created page Installation-Tasks (Created page with "Switching On/Off Options (11g-R2)")
  • 21:40, 8 November 2019 Admin talk contribs created page 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...")
  • 21:39, 8 November 2019 Admin talk contribs created page Oracle (Created page with "===Post Installation Tasks=== Switching On/Off Options (11g-R2) **************************************************** After an Installatio...")
  • 21:37, 8 November 2019 Admin talk contribs created page MediaWiki:Sidebar (Created page with " * navigation ** mainpage|mainpage-description ** Oracle-url|Oracle ** recentchanges-url|recentchanges ** randompage-url|randompage ** helppage|help-mediawiki * SEARCH * TOOLB...")
  • 05:03, 8 November 2019 MediaWiki default talk created page Main Page
(newest | oldest) View ( | older 50) (20 | 50 | 100 | 250 | 500)
Retrieved from "http://www.nazimcricket.com/wiki/Special:Log"