In Toad, the undo tablespace undotbs1 usage has reached 100%, but the strange thing is that the database does not hang and still works. The use of the EM View UNDOTBS1 table space provided by Oracle also achieves 78.8 In the previous article, we
1.Linux View disk space size commandThe Df-h DF command is a Linux system that views the file system as a disk partition, which can be added with parameters to view the disk's remaining space information, the command format: DF-HL display format:
Linux: View disk space usageAt times, there is little space in the test machine allocated to the work, often encountering a full disk space situation. The troubleshooting process is as follows:First, use the df-h command to view the remaining space
Table space monitoring
The use of tablespace space is a problem that requires special attention. Because the data files cannot be expanded, the tablespace space is insufficient, and new data may not be written, and even causes the database to stop.
Is your hard drive full again? Do you know what kind of tricks are making? Here, I will introduce five free and easy-to-use disk statistical software, so that you can easily find out the useless files in the hard drive ~ Come and try it.Treesize
1. SQL statement 1:
-- 1. view the table space name and size select T. tablespace_name, round (sum (Bytes/(1024*1024), 0) ts_size from dba_tablespaces T, dba_data_files d where T. tablespace_name = D. tablespace_name group by T. tablespace_name;
Compare clustered indexes (clustered) and non-clustered indexes (nonclustered) in storage mode --> Generate Test Data Using TravyLee: the data volume in all the tables below is 19329 (note that this is not a big data table). Now we are creating a
A tablespace is a disk area consisting of one or more disk files. A tablespace can accommodate many tables, indexes, or clusters.
Create a tablespaceCreate tablespace ts_facial datafile 'C: \ oraclexe \ oradata \ df_facial.dbf' size 500 mUniform
1. create a folder named: dnn under disc E, look like E: \ dnn, and create sub-folders under dnn folder, they are dotnetnuke folder -- which is source code folder and deploy folder which has files for uploading to server.
2. Copy exclude.txt file to
If not exists (select * From DBO. sysobjects where id = object_id (n' [DBO]. [tablespaceinfo] ') and objectproperty (ID, n' isusertable') = 1)
Create Table tablespaceinfo -- create a temporary table(Nameinfo varchar (50), -- table nameRowsinfo int, -
I. query the usage of disk space and the size and utilization of data files and log files in each database:1. query the remaining space of each disk partition:Exec master. DBO. xp_fixeddrives
2. query the data files and log files of the database
Run the following stored procedure
Then you can directly view it by using SpaceUsed.
Stored Procedure Code
Program code
Copy codeThe Code is as follows: Create procedure SpaceUsed
As
Begin
Declare @ id int -- The object id of @ objname.
Declare @
Of course we want to share some of the highlights. upload them to your FTP space! It is convenient for friends to download and enjoy. However, these blockbusters are often "bloated", while FTP space is "Limited". Over time, it is likely to be
You should check the status of Oracle tablespace frequently. When the idle ratio is too low, you should consider increasing the table's viewing space. Check the following SQL statement: Method 1: selectdbf. tab
You should check the status of Oracle
We know that one of the most explicit purposes in a namespace is to solve the problem of duplicate names, so two functions or classes in PHP are not allowed to have the same name, or there will be a fatal error. In this case, as long as you avoid
I don't know if there are any better methods to get it.
1 Create Procedure Rochelle sptablespaceused 2 As 3 Set Nocount On 4 5 Declare @ Result Table 6 ( 7 Tablename Varchar ( 64 ) 8 , [
The customer's database is a standalone database of OracleDatabase11.2.0.3.0forAIX6.164bit. The customer queries DBA_FREE_SPACE and finds that the UNDO tablespace usage is as high
The customer's Database is a standalone Database of Oracle Database 11
Exec sp_msforeachtable@ Precommand = N'Create Table ##(Table Name sysname,Number of records int,Reserved space nvarchar (10 ),Use space varchar (10 ),Index space varchar (10 ),Unused space varchar (10 ))',@ Command1 = n' insert # exec sp_spaceused ''
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.