Author: Leal
Authorization license:
Create sharing agreement
GNU Free Documentation License
Edited by: firehare, dbzhang800
We can use any text editor, such as gedit, kedit, emacs, VI, to write shell scripts. It must start
Code from my blog: http://www.taoniwu.com/archives/3234.html all the great god if there is any good advice, thank you for proposing ~~~~~
?
class collection{
protected $url;//Capture Address
protected $prefix;//rename
I. Improve database performance
1. Use explain plan to check SQL statement Performance
Specific operations:
Generate a plan_table table
Run rdbms \ admin \ utlxplain. SQL
Explain plan set statement_id = 'statement1 'into plan_table
For select * from
The set of all system calls implemented by the operating system is the application programming interface (API ). Is the interface between applications and systems. Linux system calls include most common system calls and functions derived from system
Chapter 4: Index
1. Creating function-based indexesSQL> Create index summit. item_quantity on Summit. Item (quantity-quantity_shipped );
2. Create a B-Tree IndexSQL> Create [unique] index index_name on table_name (column,... ASC/DESC) tablespaceSQL>
Rename a data file
If the primary database re-commands one or more data files, the modification will not be automatically transmitted to the standby database.
If you want to make standby and data files consistent with primary, you can only manually
To test a DG problem, set up a test environment on Vmware and place primary and standby on the same host.I will not repeat the setup process, but I encountered some problems at the end. Record them here for future reference.
---- Some commands
8.3.3 Using Transportable Tablespaces with a Physical Standby Database
8.3.3 use of the transmitted tablespace in the physical standby Database
You can use the Oracle transportable tablespaces feature to move a subset of an Oracle database and plug
104 scp to 25Scp/opt/Oracle/111/dbs/initORCL. ora root@10.1.0.25:/opt/oracle/111/dbs/initORCL. oraScp/opt/oracle/111/dbs/spfileORCL. ora root@10.1.0.25:/opt/oracle/111/dbs/spfileORCL. oraScp/opt/oracle/111/dbs/orapwORCL root@10.1.0.25:/opt/oracle/111
RAC local data file migration to ASM method-non-archive Mode
Reference: How to migrate RAC local data files to ASM
System Environment: rhel6.2 _ x64 + Oracle RAC11g Procedure:1. Non-archive ModeSQL> archive log list;Database log mode No Archive
One linux Command every day (7): mv command link: One linux Command every day (1): ls command http://www.bkjia.com/ OS /201210/163049.html#linuxlinuxcommand every day (2): cd command serial (3 ): pwd command Export (4): mkdir command
(There is an "Enterprise Manager Console" in the Windows Oracle Start Menu, which allows you to directly edit tablespaces and files)
Alter Database
Open an existing database, and/or modify associated files.
Syntax:
ALTER DATABASE database_name
In Linux, you can specify an alias for an alias command: in Linux, if the command is too long and does not conform to the user's habits, you can specify an alias for it. Although you can create a "Link" for a command to solve the problem of long
How can I move data files from drive C to drive D?It's easy, just three steps.Step 1: Move the tablespace offline to the directory specified by disk D.Step 2: Modify the tablespace file path alter database rename file 'old file path' to 'new file
File rename function usage.$ S = explode ("n", trim ('DIR/B E: 11-2caps tutorial '); // Obtain all file names in this path// Print_r ($ s );Foreach ($ s as $ rs){$ Name = explode (".", $ rs );$ File_name = $ name [0]; // Obtain the name of the
Shell programming Basics
Leal
Authorization license:
Create sharing agreement
GNU Free Documentation License
Edited by: firehare, dbzhang800
We can use any text editor, such as gedit, kedit, emacs, VI, to write shell scripts. It must start with
1 #!/usr/bin/python2 #-*-encoding:utf-8-*-3 #___author___: Oracle4 #___date____: 2018/5/17 a.m. 09:045 #___file_name:os Module6 #___project_name:python_lesson7 8 ImportSys,time,os9 " "OS module interaction between the program and the operating
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.