select * from ( Select a.tablespace_name, to_char(a.bytes/1024/1024,’99,999.999′) total_bytes, to_char(b.bytes/1024/1024,’99,999.999′) free_bytes, to_char(a.bytes/1024/1024 – b.bytes/1024/1024,’99,999.999′) use_bytes, to_char((1 – b.bytes/a.bytes)*100,’99.99′) || ‘%’ use from (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name) a, (select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name)…
I installed a high version rpm package by mistake , should install a low version. But I don’t want to uninstall the high version firstly…
The amount of dictionaries ls -lR | grep ^d | wc -l The amount of files find /data -type f | wc -l
I need to change NFS configuration recently， so umount original device firstly. But I encuntered one error “umount was not found in /proc/mounts” I checked…
I configured nginx as a loadbalance and reverse proxy. there were 2 real servers in back-end. If client access this website through nginx ip address.…
oracle tablespace isn’t enough，there are 2 reasons： 1. original tablespace is too small, hadn’t been set autoextend； error code: ORA-01653: unable to extend table 2. tablespace…
1. the modified files within n days（-ctime） find . -type f -ctime -n introduction： (1) -type f only search file ,excluding dictionary (2)ctime, the character…
check relationship between tablespace and username. select username,default_tablespace from dba_users; SQL> select username,default_tablespace from dba_users; USERNAME DEFAULT_TABLESPACE —————————— —————————— NAME_A …