|
| | Script to view URLs through HTTP proxy server
This PHP function allows to view / download contents from websites on the Internet through a proxy server, with or without proxy authentication. If no username / password supplied to the function it will assume that proxy server does not require authentication.
| | More...
06/07/06 | | | | | | | | |
|
|
|
|
| | Generate drop schema indexes script
I use the below script to drop indexes before running complete refresh in Oracle database. Before dropping the indexes I run export without rows so that indexes can be re-created (get sql script from export dump) after snapshots have been refreshed.
--
-- Replace USERNAME with the actual username
--
set head off pagesize ... | | More...
05/10/06 | | | | | | | | |
|
| | Example exp parfile for Oracle full export
Here's an example of parfile for exporting the whole database without data (no rows):
FILE=DBNAME.dmp
COMPRESS=N
ROWS=N
LOG=DBNAMEexp.log
FULL=Y
Run from command line:
$ . oraenv
$ ORACLE_SID = [DBNAME] ?
$
$ exp parfile=DBNAMEexp.par
Export: Release 8.1.7.4.0 - Production on Wed May 10 10:20:48 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Username: / as sysdba
| |   
More...
05/10/06 | | | | | | | | |
|
| | List all database links
Show all db links in Oracle database.
--
-- I'm sick and tired of typing this almost every day, so here we go, from now on
-- I will just copy and paste. Hope this may be useful for others too.
--
col OWNER format a12
col DB_LINK format a12
col USERNAME format a12
col HOST format a12
select ... | |
More...
05/10/06 | | | | | | | | |
|
| | Script to generate creation of snapshots
Generate Oracle snapshots using the script below. It will check tablespaces for materialized view logs and place the snapshots in the appropriate tablespaces (if you follow the Oracle's recommendation to use different tablespaces for differently sized segments). This script is to be run on spanshotlog site.
set head off verify off ... | | More...
05/04/06 | | | | | | | | |
|
| | Using Oracle statspack
STATSPACK has two adjustable parameters: level and threshold. Level is the type of data collected and threshold acts as a filter for collecting SQL statements. You can use this query to view all levels:
SQL> SELECT * FROM stats$level_description ORDER BY snap_level;
Level 0 This level captures general statistics, including rollback segment, row ... | | More...
04/26/06 | | | | | | | | |
|
<< 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | Page 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 >>
|
