Tags:linuxcentosoracle installation configuration /** * CENTOS-6.4-DVD system installed Oracle-11.2.0.4 *------------------------------------------------------------------------ ----------------------------------------------* "Preface" * was originally installed in the centos-6.4-minimal-64bit system oracle-11.2.0.4.0-linux-x86_64, the results of a full toss two days did not install success * Always in the last step [./runinstaller] After executing
Note: Today, when using Swiper.js to do the product carousel, encountered in the use of Flexbox under the premise of the child element set flex:1; All child elements are squeezed in the first phase (not executed to swipe);The reason is because there is no setting:flex-shrink property.Flex-shrink:Default value : 1applies to : Flex subkeyInheritance : NoneAnimation : YesCalculated value : Specify a valueValue:
defines the shrinkage ratio u
table. The occupied space is test1: 17 m, Test2: 9 m.
Now we can compare the execution plan:
Analyze table test1 compute statistics; analyze table Test2 compute statistics;
The execution plans of two tables of the same size are quite different. In this case, we can still see the difference in small data volumes. In this case, the production system may have millions of data records, this efficiency difference is more obvious.
These tables are deleted every day in our system, and
1 move Experiment
SQL> Create Table my_objects_move tablespace assm as select * From all_objects where rownum
Table created
SQL> select Value
2 from V $ mystat, V $ statname
3 where V $ mystat. Statistic # = V $ statname. Statistic #
4 and V $ statname. Name = 'redo size ';
Value
----------
2317832
SQL> Delete from my_objects_move where object_name like '% C % ';
7546 rows deleted
SQL> Delete from my_objects_move where object_name like '% u % ';
2959 rows deleted
SQL> commit;
Commit complete
1 move ExperimentSQL> create table my_objects_move tablespace ASSM as select * from all_objects where rownum
Table created
SQL> select value
2 from v $ mystat, v $ statname
3 where v $ mystat. statistic # = v $ statname. statistic #
4 and v $ statname. name = 'redo size ';
VALUE
----------
2317832
SQL> delete from my_objects_move where object_name like '% C % ';
7546 rows deleted
SQL> delete from my_objects_move where object_name like '% U % ';
2959 rows deleted
SQL> commit;
Commit complete
Recently a friend went to the computer city to buy a 16G u disk, the computer with the Golden Hill poison PA's U disk authentication test results show that the actual capacity of only 4 G, and suggested that it is shrinking u disk. Friends immediately went to buy a U disk where to find business, merchant wrong, obediently changed a true 16G capacity of U disk. What is the shrinking U disk? Today to share with you about the shrinking U disk knowledge and detection methods.
Tags: manual ado An operation understanding data file settings. com colDatabase shrinkage:Personal understanding, the database in the process of ordinary long-term operation of the log files will always be in a certain proportion in the increase, data files in the database after deleting a large amount of data does not necessarily reduce disk space, repeated operations will appear wasted space, so the shrinking database will be reflected.Suppose the database is set to
In OracleVMVirtualBox installation of ubuntu-10.10-dvd-amd64 problems encountered-Linux general technology-Linux technology and application information, the following is a detailed reading. This kernel requires an x86-64 CPU, but only detected an i686 CPU. unable to boot-please ues a kernel appropriate for your CPU
This kernel requires an x86-64 CPU, but only the i686 CPU is detected. Unable to start-Please unified power company for your CPU core a
/*** Install Oracle-11.2.0.4 * CentOS-6.4-DVD in a CentOS-6.4-minimal-64bit system * 'was originally installed in a Oracle-11.2.0.4.0-Linux-x86_64 system, as a result, the installation was unsuccessful for two days. * The installation was always in the last step [. /runInstaller] After executing the command, print the following prompt * Checking monitor: must be configured to display at least 256 colors * >>> cocould not execute auto check for display
, Chen Xudong, who died of cancer.A few months later, finally cheer up to start a new life Lin Yu but met a always let her inexplicable think of the foreign model of the Chen Xudong (decoration). At the same time, McCully has never seen his biological brother Gu Zhun (Ningoming adorn) suddenly appeared, holding the family 20% hidden shares, he told McCully M.E there is a huge financial loophole, the two brothers together want to regain the M.E acquisition of Sheng Gu company. McCully persuaded t
1. Download The Fedora-9-i386-DVD and place it in the FAT32 partition (not in the NTFS partition ).
URL: http://fedoraproject.org/zh_CN/get-fedora
2. Extract the two files initrd. IMG and vmlinuz in the isolinux folder and put them in the C root directory.
3. Download grub4dos and extract the three grldr grub.exe and menu. lst files and put them in the C root directory.
URL: http://download.gna.org/grub4dos/
4. Use notepad to Open menu. lst and a
For today's technology, replacement fast has become a normal, like mobile phones, now popular is a style, perhaps a few months later, another fashion will replace the present, so that many win7 ISO image download computer can not recognize the old DVD drive, Presumably a lot of friends have found out, right? Then if there is a professional demand, then there is nothing to do? Don't worry, we may as well see how small knitting is how to operate it!
Th
Learn how to put a different image and some text together to make it a professional-looking movie poster/DVD cover design. This tutorial contains some very good photo editing techniques and methods that allow you to better edit typesetting characters and layer styles.
Let's take a look at the final effect:
1th Step:
Open the following diagram (Ctrl+o) in Photoshop.
2nd Step:
Open the picture of the explosion footage and dr
Starting from 10 Gb, oracle began to provide Shrink commands. If our tablespace supports automatic segment space management (ASSM), we can use this feature to narrow down the segment, that is, reduce the HWM. Here we need to emphasize that this new 10g feature is only valid for the ASSM tablespace, otherwise the ORA-10635: Invalid segment or tablespace type will be reported.
Here, we will discuss how to recycle wasted space for an ASSM segment.
Simila
Experiment: Comparison of redo logs generated by table shrink and move in Oracle
Experiment: Comparison of redo logs generated by table shrink and move in Oracle
1 move ExperimentSQL> create table my_objects_move tablespace ASSM as select * from all_objects where rownum
Table created
SQL> select value
2 from v $ mystat, v $ statname
3 where v $ mystat. statistic # = v $ statname. statistic #
4 and v
After importing an empty database to the database, we found that the occupied table space was very large. After the shrink space cascade was executed, we found that the actual occupied space was less than 1%.
However, an error message is displayed when the tablespace size is reduced.
Alter database datafile 'd: \ ora_tablespace \ gcomm2.dbf 'resize 5000 m;
Tip: ORA-03297: file contains used data beyond requested resize Value
Cause 1: the size of the
Tags: style color ar using SP strong file data onSQL Server allows the user to set the database initial and maximum values, which can be configured by auto-grow or auto-shrink. With these configurations, we can prevent application modifications that could be caused by database space problems, or when SQL Server disk space is exhausted. In general, if the database is not very busy, the default setting is auto-grow, which can satisfy most of the require
Label:Recently discovered Web sites are inaccessible because the database server disk has no more space left. The log file was found to be 70%, and shrinking the log file failed.The reason for the online lookup is that no backup cannot shrink the log file.A temporary solution:Back up the transaction log, and then shrink the log file. (You can also shrink a log fi
Label:One, Check Database Integrity Task Check the allocation and structural integrity of the user and system tables, and indexes in the database, by running the D BCC CHECKDB Transact-SQL statement. Running DBCC ensures that any integrity problems with the database is reported, thereby allowing them to be addressed Later by a system administrator or database owner. Include indexes Check the integrity of the index pages as well as the table data pages. View TSQL Code -- include Inedexes
DBCC CH
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.