SQL> explain plan for select count(*) from tablo;
SQL> @?/rdbms/admin/utlxpls.sql
On version up to and including 9i, use the utlxplan.sql script to createthe plan table as instructed below.
SQL> @?/rdbms/admin/utlxplan
On 10g and above there is a new script - catplan.sql - to create the plan
table that creates a public plan table as a global temporary table
accessible from any schema.
SQL> @?/rdbms/admin/catplan
Note that the plan table format can change between versions so ensure
that it is created using the utlxplan script from the current version.
sapnotes:#1303908
27 Ocak 2010 Çarşamba
4 Ocak 2010 Pazartesi
instance bilgileri sql komutları
SELECT NAME, description FROM v$bgprocess ORDER BY NAME, description
select * from v$version
where banner like 'Oracle%';
select * from v$database
select * from v$license;
select * from v$version;
select * from v$version
where banner like 'Oracle%';
select * from v$database
select * from v$license;
select * from v$version;
rman tsm backup
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/sid/102_64/dbs/snapcf_BPD.f'; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/sid/yedek/ora_df_%t_%s_%p';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/sid/yedek/%F';
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO TSM;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'TSM' TO 'AUTOBACKUP_%F';
CONFIGURE DEVICE TYPE TSM PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE TSM TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'TSM' PARMS 'ENV=(tdpo_optfile=/usr/tivoli/tsm/tdp_r3/ora64/dsm.sys)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';
CONFIGURE CHANNEL DEVICE TYPE 'BOYDAKTSM' PARMS 'ENV=(tdpo_optfile=TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';
XINT_PROFILE=//init.utl,PROLE_PORT=portnumber
CONFIGURE CHANNEL DEVICE TYPE 'TSM' MAXPIECESIZE 100 M;
CONFIGURE CHANNEL DEVICE TYPE 'TSM' clear;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(tdpo_optfile=/tsm/conf/client/tdpo.opt.tst)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';
SHOW CHANNEL FOR DEVICE TYPE TSM;
http://forums.oracle.com/forums/thread.jspa?threadID=697031
v$backup_device
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=tape_svr, NSR_CLIENT=oracleclnt, NSR_GROUP=oracle_tapes)' FORMAT "BACKUP_%U";
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/api/bin/dsm.sys.smp)';
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/sid/102_64/dbs/snapcf_BPD.f'; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/sid/yedek/ora_df_%t_%s_%p';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/sid/yedek/%F';
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO TSM;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'TSM' TO 'AUTOBACKUP_%F';
CONFIGURE DEVICE TYPE TSM PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE TSM TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'TSM' PARMS 'ENV=(tdpo_optfile=/usr/tivoli/tsm/tdp_r3/ora64/dsm.sys)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';
CONFIGURE CHANNEL DEVICE TYPE 'BOYDAKTSM' PARMS 'ENV=(tdpo_optfile=TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';
XINT_PROFILE=/
CONFIGURE CHANNEL DEVICE TYPE 'TSM' MAXPIECESIZE 100 M;
CONFIGURE CHANNEL DEVICE TYPE 'TSM' clear;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(tdpo_optfile=/tsm/conf/client/tdpo.opt.tst)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';
SHOW CHANNEL FOR DEVICE TYPE TSM;
http://forums.oracle.com/forums/thread.jspa?threadID=697031
v$backup_device
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=tape_svr, NSR_CLIENT=oracleclnt, NSR_GROUP=oracle_tapes)' FORMAT "BACKUP_%U";
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/api/bin/dsm.sys.smp)';
solaris oracle kurulumu
phgadd -d . SUNWbtool
http://ivan.kartik.sk/oracle/install_ora10gR2_solaris.html
http://blogs.sun.com/mandalika/entry/oracle_on_solaris_10_fixing
useradd -R printadm -m -d /export/deneme -s /usr/bin/bash deneme
http://www.kobhi.com/solaris/user_management/solaris_user_modify.htm
http://belgeler.org/lis/archive-tlkg-lis-7.2.html
http://www.ugurileri.com/2009/05/solaris-10da-network2u-restart-etmek.html
http://forums.oracle.com/forums/thread.jspa?threadID=382389
http://www.lazydba.com/oracle/0__53774.html
ifconfig -a pcn0
netstat -rn
route add default 10.200.0.111
etc/defaultrouter 10.200.0.111
/etc/nsswitch.conf host files dns
/etc/resolv.conf - nameserver -ip-
http://ivan.kartik.sk/oracle/install_ora10gR2_solaris.html
http://blogs.sun.com/mandalika/entry/oracle_on_solaris_10_fixing
useradd -R printadm -m -d /export/deneme -s /usr/bin/bash deneme
http://www.kobhi.com/solaris/user_management/solaris_user_modify.htm
http://belgeler.org/lis/archive-tlkg-lis-7.2.html
http://www.ugurileri.com/2009/05/solaris-10da-network2u-restart-etmek.html
http://forums.oracle.com/forums/thread.jspa?threadID=382389
http://www.lazydba.com/oracle/0__53774.html
ifconfig -a pcn0
netstat -rn
route add default 10.200.0.111
etc/defaultrouter 10.200.0.111
/etc/nsswitch.conf host files dns
/etc/resolv.conf - nameserver -ip-
oracle enterprise manager
emca -config dbcontrol db -repos create -- manager console oluşturulur
emca -deconfig dbcontrol db -repos drop -- console silinir.
1) Set the environment variable ORACLE_SID to SID
2) /oracle/SID/102_64/bin/emctl stop dbconsole
3) /oracle/SID/102_64/bin/emctl config emkey -repos -sysman_pwd pass < Password for SYSMAN user >
4) /oracle/SID/102_64/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user >
5) /oracle/SID/102_64/bin/emctl start dbconsole
emca -deconfig dbcontrol db -repos drop -- console silinir.
1) Set the environment variable ORACLE_SID to SID
2) /oracle/SID/102_64/bin/emctl stop dbconsole
3) /oracle/SID/102_64/bin/emctl config emkey -repos -sysman_pwd pass < Password for SYSMAN user >
4) /oracle/SID/102_64/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user >
5) /oracle/SID/102_64/bin/emctl start dbconsole
Kaydol:
Kayıtlar (Atom)