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
  • 00:44, 9 November 2019 Admin talk contribs created page Use Samba to copy file to Windows (Created page with "<blockquote><pre> smbclient //<WINDOWSSERVERNAME>/<SHAREDIRNAME> -A myauth.auth -c "put <sourcefilename> <windowspathname><destinationfilename>" </pre></blockquote> myauth.au...")
  • 00:44, 9 November 2019 Admin talk contribs created page Yesterday's Date (Created page with "<blockquote><pre> date -d '1 day ago' </pre></blockquote> <blockquote><pre> date -d 'yesterday' </pre></blockquote>")
  • 00:44, 9 November 2019 Admin talk contribs created page Check O/S Version (Created page with "uname -a Also ... '''Linux:''' cat/etc/issue '''AIX:''' oslevel oslevel -r (shows technology level) oslevel -s (shows service pack}")
  • 00:44, 9 November 2019 Admin talk contribs created page Chmod (Created page with "Instead of having to work out the numeric settings for chmod, the following conventions can be "literally" used: <blockquote><pre> chmod u+rwx chmod g+rwx chmod o+rwx chmod...")
  • 00:41, 9 November 2019 Admin talk contribs created page TSM Command Line Restore (Created page with "To restore files through TSM command line and pick what is needed. Note: destfile not required if restoring to original source directory. <blockquote><pre> dsmc restore "/pat...")
  • 00:41, 9 November 2019 Admin talk contribs created page Tasks (Created page with "TSM Command Line Restore")
  • 00:38, 9 November 2019 Admin talk contribs created page Random Image Generator (Created page with "On my [http://www.nazimcricket.com website] I had been using a third party Javascript random image generator which scrolled through my /images folder and displayed a random im...")
  • 00:38, 9 November 2019 Admin talk contribs created page Global Parameters (Created page with "New to MySQL, but will make notes for my benefit, and for the odd person who stumbles on this post via Google. I need to write a few cron scripts for a MySQL database and I do...")
  • 00:37, 9 November 2019 Admin talk contribs created page Spooling Out (Created page with "Thanks to my friend LW for helping sort this one out. You can increase the verboseness (is that a word?) of a batch output logfile in MySQL, by repeating the "-v" switch....")
  • 00:36, 9 November 2019 Admin talk contribs created page Script to Backup and Restore a MySQL Database (Created page with "'''Requirements'''<br> * Obtain a simple backup of a Production MySQL database. * Send backup to TSM Tape Storage Device. * Copy the files to a Non-Production MySQL database s...")
  • 00:36, 9 November 2019 Admin talk contribs created page Gen-Tasks (Created page with " Script to Backup and Restore a MySQL Database Spooling Out === MySQL and PHP (The Perfect Match) ===...")
  • 00:29, 9 November 2019 Admin talk contribs created page Email Results of a Database Export (Created page with "Had to write a batch script to check on the status of a nightly database export and email out the Status. Some of what I've done may not be perfect, but it does the job nice...")
  • 00:29, 9 November 2019 Admin talk contribs created page Services Manipulation (Created page with "To stop, start or check status of a Service remotely, you can use the sc utility as follows: <blockquote><pre> sc \\servername stop ServiceName sc \\servername start Service...")
  • 00:29, 9 November 2019 Admin talk contribs created page Count Network Connections (Created page with "To get a count of the number of network connections on a Windows server, you can use the following batch script: <blockquote><pre> REM list network connections and write them...")
  • 00:28, 9 November 2019 Admin talk contribs created page Tree Directory Listing (Created page with "A good way to list your files and folders. '''Syntax''' <blockquote><pre> Drive:\Path Drive Letter and Directory Name /f Displays File Names in each Director...")
  • 00:28, 9 November 2019 Admin talk contribs created page Check Server UpTime (Created page with "<blockquote><pre> systeminfo | find "Time" </pre></blockquote>")
  • 00:28, 9 November 2019 Admin talk contribs created page General (Created page with " Email Results of a Database Export Services Manipulation Count Network Connections | Count Network Con...")
  • 00:25, 9 November 2019 Admin talk contribs created page Check Database Uptime (Created page with "<blockquote><pre> SELECT sqlserver_start_time FROM sys.dm_os_sys_info; </pre></blockquote>")
  • 00:25, 9 November 2019 Admin talk contribs created page Check Database Version (Created page with "<blockquote><pre> SELECT @@version; </pre></blockquote>")
  • 00:24, 9 November 2019 Admin talk contribs created page Clone Role with Securables (Created page with "<blockquote><pre> declare @RoleName varchar(50) = '<ROLE_NAME>' declare @Script varchar(max) = 'CREATE ROLE ' + @RoleName + char(13) select @script = @script + 'GRANT ' + p.p...")
  • 00:24, 9 November 2019 Admin talk contribs created page Check Mirror Status (Created page with "A handy SQL contributed by Andrew R. <blockquote><pre> SELECT left(a.name,50) 'Database' , CASE b.status WHEN 0 THEN 'Suspended' WHEN 1 THEN 'Disconnected'...")
  • 00:24, 9 November 2019 Admin talk contribs created page Querying Active Directory Members for SQL Server Databases (Created page with "This is a rather convoluted way of approaching the task required, but does also provide a degree of flexibility. I needed to write a script to obtain a list of members of use...")
  • 00:23, 9 November 2019 Admin talk contribs created page Various-Tasks (Created page with "Clone Role with Securables Check Database Version Check Database Uptime Check Mirr...")
  • 00:18, 9 November 2019 Admin talk contribs uploaded File:Ss9.png
  • 00:18, 9 November 2019 Admin talk contribs created page File:Ss9.png
  • 00:18, 9 November 2019 Admin talk contribs uploaded File:Ss8.png
  • 00:18, 9 November 2019 Admin talk contribs created page File:Ss8.png
  • 00:18, 9 November 2019 Admin talk contribs uploaded File:Ss7.png
  • 00:18, 9 November 2019 Admin talk contribs created page File:Ss7.png
  • 00:18, 9 November 2019 Admin talk contribs uploaded File:Ss6.png
  • 00:18, 9 November 2019 Admin talk contribs created page File:Ss6.png
  • 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss5.png
  • 00:17, 9 November 2019 Admin talk contribs created page File:Ss5.png
  • 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss4.png
  • 00:17, 9 November 2019 Admin talk contribs created page File:Ss4.png
  • 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss3.png
  • 00:17, 9 November 2019 Admin talk contribs created page File:Ss3.png
  • 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss2.png
  • 00:17, 9 November 2019 Admin talk contribs created page File:Ss2.png
  • 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss1.png
  • 00:17, 9 November 2019 Admin talk contribs created page File:Ss1.png
  • 00:16, 9 November 2019 Admin talk contribs uploaded File:Og5.png
  • 00:16, 9 November 2019 Admin talk contribs created page File:Og5.png
  • 00:16, 9 November 2019 Admin talk contribs uploaded File:Og4.png
  • 00:16, 9 November 2019 Admin talk contribs created page File:Og4.png
  • 00:16, 9 November 2019 Admin talk contribs uploaded File:Og3.png
  • 00:16, 9 November 2019 Admin talk contribs created page File:Og3.png
  • 00:16, 9 November 2019 Admin talk contribs uploaded File:Og2.png
  • 00:16, 9 November 2019 Admin talk contribs created page File:Og2.png
  • 00:15, 9 November 2019 Admin talk contribs uploaded File:Og1.png
  • 00:15, 9 November 2019 Admin talk contribs created page File:Og1.png
  • 23:54, 8 November 2019 Admin talk contribs created page Creating an Oracle Database with Apex on AWS RDS (Created page with "'''Steps to create an Oracle Standard Edition Two database on AWS with APEX as an option. These notes are for Apex version 5.1.2.v1''' '''PRE-REQUISITIES''' If you don't a...")
  • 23:53, 8 November 2019 Admin talk contribs created page SQL Server Backup Script for AWS RDS (Created page with "<blockquote><pre> DECLARE @dbs TABLE (dbname VARCHAR(50)) DECLARE @currentDB VARCHAR(50) declare @SQL1 nvarchar(3000) declare @SQL2 nvarchar(3000) declare @BUCKET nvarchar(2...")
  • 23:53, 8 November 2019 Admin talk contribs created page Auto Refresh of Oracle DB across VPCs (Created page with "<blockquote><pre> #!/bin/ksh # # Shell script for Snapshot of Databases # Nazim Merchant # 26 Jul 2018 # # Usage script.ksh instance-name source_db_name target_db_name e.g. or...")
  • 23:52, 8 November 2019 Admin talk contribs created page Datapump Export to S3/Glacier (Created page with "Another script that has been documented for preservation more than anything else. '''Pre-requisites''' * ec2 Instance with Oracle XE installed * Access to the RDS Databases u...")
  • 23:51, 8 November 2019 Admin talk contribs created page Dynamic Profile Creation Script (Created page with "<blockquote><pre> set serveroutput on declare cursor prof is select dbms_metadata.get_ddl('PROFILE', profile) as profile from (select distinct profile from dba_...")
  • 23:51, 8 November 2019 Admin talk contribs created page Deploy Amazon Web Services Plugin to Cloud Control (Created page with "To monitor AWS RDS Database via Cloud Control (13c), a plugin needs to be deployed on OEM. Here are some rough notes, for my own reference. '''Download Plug-in''' <blockquot...")
  • 23:50, 8 November 2019 Admin talk contribs created page Dynamic Tablespace Creation Script (Created page with "This script generates a dynamic Tablespace Creation (with multiple datafiles) script from my target database for my RDS instance. It deals with smallfile tablespaces. <block...")
  • 23:49, 8 November 2019 Admin talk contribs created page Create a DB Link on RDS DB (Created page with "<blockquote><pre> create database link test connect to <username> identified by "<password>" using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip_address>)(PORT=1521))(CONNECT...")
  • 23:49, 8 November 2019 Admin talk contribs created page General-Tasks (Created page with " Creating an Oracle Database with Apex on AWS RDS Dynamic Profile Creation Script [...")
  • 23:46, 8 November 2019 Admin talk contribs created page Disable Auto SQL Tuning Advisor (Created page with "<pre> select * from dba_autotask_operation EXEC dbms_auto_task_admin.disable( 'sql tuning advisor', NULL, NULL ); </pre>")
  • 23:44, 8 November 2019 Admin talk contribs created page Check Bind Variables (Created page with "Here's a way you can check on what bind variable values have been parsed in a query. <blockquote><pre> SELECT a.sql_id , a.sql_text , b.name , b.value_string...")
  • 23:44, 8 November 2019 Admin talk contribs created page Tuning-Tasks (Created page with " Check Bind Variables Disable Automatic SQL Tuning Advisor")
  • 23:39, 8 November 2019 Admin talk contribs created page RMAN - Create Standby Database (Created page with "These are just rough notes for my own benefit. They are not well researched and are only posted as a reminder for myself. Had to convert a database to a physical standby usi...")
  • 23:39, 8 November 2019 Admin talk contribs created page Resize Online Redo Logs (10g) - Rough Notes (Created page with "To resize redo log files, we have to drop and recreate them. The status of these files is critical. Files with a status of: * CURRENT - cannot/must not be dropped. To ch...")
  • 23:39, 8 November 2019 Admin talk contribs created page READ ONLY Before RESETLOGS (11g) (Created page with "A new feature in Oracle 11g is that after incomplete recovery of a database, you can now open the database in read only mode before opening in resetlog mode. This now enables...")
  • 23:38, 8 November 2019 Admin talk contribs created page Check Recovery Time (Created page with "It's quite useful sometimes to be able to see the timestamp associated with a Database Recovery. <blockquote><pre> SELECT to_char((max(TIME_DP)),'DD MON YYYY HH24:MI') FROM...")
  • 23:38, 8 November 2019 Admin talk contribs created page Manually Create Standby Database from Hotbackup (9i) (Created page with "This is basically a "Note-To-Self". High Level Steps for Reference, are: * Copy Datafiles across. * On Target, set up env variables, password file, oratab entry etc. *...")
  • 23:38, 8 November 2019 Admin talk contribs created page Lost spfile and pfile (Created page with "''Handy Tip'': If you have lost your spfile and pfile, you can recover the non-default values previously set from the database Alert Log, as these values are spooled to the al...")
  • 23:37, 8 November 2019 Admin talk contribs created page Log Mining (10g) (Created page with "'''Please note the database parameter log_parallelism needs to be set at 1 for this to work''' In this day and age of flashback configuration, log mining almost seems like...")
  • 23:37, 8 November 2019 Admin talk contribs created page Check Last Applied Archive Log (Created page with "<blockquote><pre> SELECT max(sequence#) FROM v$log_history; </pre></blockquote> OR ... <blockquote><pre> SQL> archive log list; </pre></blockquote>")
  • 23:37, 8 November 2019 Admin talk contribs created page Foreign Archive Logs (11g) (Created page with "A colleague of mine recently noticed in our Fast Recovery Area (aka Flash Recovery Area) that some FOREIGN ARCHIVED LOGS were taking up space. We knew from a recent implement...")
  • 23:36, 8 November 2019 Admin talk contribs created page Cloning Schema (11g) (Created page with "Found an interesting way to clone a schema '''in the same database''' using datapump with a database link. Could be considered a highly unsupported method, but it worked for...")
  • 23:36, 8 November 2019 Admin talk contribs created page Available db recovery file dest (Created page with "A great script picked up somewhere along the way to check the available amount of db_recovery_file_dest space. <blockquote><pre> SELECT name , floor(space_limit/1024/102...")
  • 23:35, 8 November 2019 Admin talk contribs created page Manually Create a Controlfile via SQL (Created page with "Something I no doubt cobbled together many years ago for reasons I cannot recall. Could be useful though! <pre> declare cursor log_files is select v$log.group#...")
  • 23:35, 8 November 2019 Admin talk contribs created page Datapump Dynamic List of Tables (Created page with "In PeopleSoft, I needed to export out all configuration/system-owned tables as a backup each week. To achieve this, my first step was to create a view listing all these tables...")
  • 23:34, 8 November 2019 Admin talk contribs created page Monitoring Import Job Progress (Created page with "<blockquote><pre> SELECT substr(sql_text, instr(sql_text,'INTO "'),30) table_name , rows_processed , round( (sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss')...")
  • 23:34, 8 November 2019 Admin talk contribs created page Pipe Database Export to Zip (Created page with "Using fifo (first in first out) you can redirect your database exports through a pipe straight to zip. '''Make fifo pipe:''' mkdir fifo db.fifo '''Write the file output...")
  • 23:33, 8 November 2019 Admin talk contribs created page Monitoring RMAN Job Progress (Created page with "<blockquote><pre> SELECT sid , serial# , context , sofar , totalwork , round(sofar/totalwork*100,2) "%_Complete" FROM v$session_longops WHERE opnam...")
  • 23:33, 8 November 2019 Admin talk contribs created page RMAN Archivelog Deletions (Created page with "<blockquote><pre> rman nocatalog<< DATA connect target delete noprompt archivelog until time 'SYSDATE-n'; DATA </pre></blockquote> <blockquote><pre> rman nocatalog<< DATA con...")
  • 23:33, 8 November 2019 Admin talk contribs created page Flashback Table (10g) (Created page with "The ability to flashback transactions to a point in time is quite a handy feature. Here is how it all works .... First of all, the oracle init.ora parameter db_flashback_ret...")
  • 23:32, 8 November 2019 Admin talk contribs created page Flashback Schema (10g) (Created page with "Technically there is no schema level flashback feature available. However, provided your recovery period does not include any data dictionary changes DDL) then you could actua...")
  • 23:32, 8 November 2019 Admin talk contribs created page Flashback Row (10g) (Created page with "The ability to flashback transactions to a point in time is quite a handy feature. Here is how it all works .... First of all, the oracle init.ora parameter db_flashback_rete...")
  • 23:31, 8 November 2019 Admin talk contribs created page Check Space Fast Recovery Area (Created page with "<blockquote><pre> SELECT name , floor(space_limit/1024/1024) "Size_MB" , ceil(space_used/1024/1024) "Used_MB" , floor(space_limit/1024/1024) - ceil(space_used/1...")
  • 23:30, 8 November 2019 Admin talk contribs created page RMAN - Point in Time Duplicate (11.2.0.2.0 (Created page with "I've spent weeks struggling with a point-in-time rman duplicate where for some obscure reason the duplicate would fail to apply point-in-time logs after midnight. FINALLY -...")
  • 23:29, 8 November 2019 Admin talk contribs created page RMAN - Diagnosing Failures (11g) (Created page with "The commands you can use through RMAN to list, seek advice on and in some cases repair Database Failures .. <blockquote><pre> RMAN> list failure [detail]; RMAN> advise failur...")
  • 23:28, 8 November 2019 Admin talk contribs created page Automatic Guaranteed Restore Point (11g) (Created page with "-- Script to schedule the creation of a guaranteed restore point on a database -- and to remove the oldest guaranteed restore point when there are more than 2 -- restore point...")
  • 23:27, 8 November 2019 Admin talk contribs created page Restore in between Upgrades (Created page with "'''Requirement''' Had to restore a database to a point-in-time from a hotbackup. Followed Steps: * Copied datafiles to target * Created a New Controlfile * Recovered using...")
  • 23:27, 8 November 2019 Admin talk contribs created page Snapshot Standby Database (11g) (Created page with "'''Introduction''' <br> One of the best new features of Oracle 11g is the introduction of Snapshot Standby Databases. This feature allows you to take a normal Physical Standb...")
  • 23:26, 8 November 2019 Admin talk contribs created page Recovery-Tasks (Created page with "=== Database Restores/Refreshes/Recovery === Snapshot Standby Database (11g) Restore in between Upgrades | Restore in between Upgrades...")
  • 23:09, 8 November 2019 Admin talk contribs created page Database Size (2) (Created page with "<blockquote><pre> SELECT TARGET_NAME , ROUND (SUM (FILE_SIZE) / 1024 / 1024 / 1024) GB FROM MGMT$db_datafiles_all GROUP BY TARGET_NAME </pre></blockquote>")
  • 23:09, 8 November 2019 Admin talk contribs created page Database Size (1) (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 Admin talk contribs created page Clearing Alerts (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 Admin talk contribs created page Datafile Size (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 Admin talk contribs created page Tablespace Allocated and Used (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 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
Retrieved from "http://www.nazimcricket.com/wiki/Special:Log"