Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle View Object Information     - C ++ 11 smart pointers (Programming)

- OpenVPN offsite interconnecting room availability and load balancing solution (Server)

- Access.log Apache access log analysis and how to import it into MySQL (Server)

- Oracle Client Dedicated and Shared connection mode (Database)

- Linux foundation tutorial: how to modify the host name on CentOS or RHEL 7 (Linux)

- Linux character device - a simple character device model (Linux)

- Debian 7.7 Installation and Configuration (Linux)

- Linux environment variable settings methods and differences (Linux)

- PF_RING 6.0.2 compiled and installed on Redhat 6.3 x86_64 (Linux)

- To install and deploy Java applications under CentOS 6.5 (Linux)

- Keepalived + HAProxy high availability load balancing (Server)

- Linux Network Analysis Tcpdump Command Guide (Linux)

- Linux common network tools: batch scanning of nmap hosting service (Linux)

- ORA-00824: can not set sga_target due to existing problem-solving (Database)

- Installation on the way to the root source Ubuntu Server 14.04 LTS version Odoo8.0 (Server)

- Between the two to achieve the main MySQL database synchronization from (Database)

- MySQL optimization of the relevant Group By (Database)

- Use Pylint regulate your Python code (Programming)

- BackTrack (BT3, BT4) Linux installation tutorial (Linux)

- Ubuntu install Eclipse can not find JAVA_HOME problem (Linux)

 
         
  Oracle View Object Information
     
  Add Date : 2018-11-21      
         
         
         
  1. See all the information a user object under:

SELECT owner, object_type, status, COUNT (*) count #
FROM all_objects
where owner = 'xxx'
GROUP BY owner, object_type, status
order by 2;

See Table 2. Number (multiple tables) (required first analysis table) row:

1 select 'analyze table' || table_name || 'compute statistics;' from user_tables;
2
3 select table_name, num_rows from dba_tables where owner = 'WEBAGENT' order by 1;
4
5 select count (*) from WITHDRAWAL_ORG;

3. See table space size:


SELECT t.tablespace_name, round (SUM (bytes / (1024 * 1024 * 1024)), 0) ts_size_GB
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;

4. View the table space usage:


SELECT tablespace_name, SUM (bytes) / (1024 * 1024) AS free_space_MG
FROM dba_free_space
GROUP BY tablespace_name;

SELECT a.tablespace_name,
a.bytes total,
b.bytes used,
c.bytes free,
(B.bytes * 100) / a.bytes "% USED",
(C.bytes * 100) / a.bytes "% FREE"
FROM sys.sm $ ts_avail a, sys.sm $ ts_used b, sys.sm $ ts_free c
WHERE a.tablespace_name = b.tablespace_name
AND a.tablespace_name = c.tablespace_name;

5. Check the name and size of the table space physical file:

SELECT tablespace_name,
file_id,
file_name,
round (bytes / (1024 * 1024 * 1024), 0) total_space
FROM dba_data_files
ORDER BY tablespace_name;

sql and executed the sql 6. check being performed:

a. sql queries being executed

select a.username, a.sid, b.SQL_TEXT, b.SQL_FULLTEXT
  from v $ session a, v $ sqlarea b
where a.sql_address = b.address;

b. query executed within the time specified in sql

select b.SQL_TEXT, b.FIRST_LOAD_TIME, b.SQL_FULLTEXT
  from v $ sqlarea b
where b.FIRST_LOAD_TIME between '2009-10-15 / 09: 24: 47' and
      '2009-10-15 / 09: 24: 47' order by b.FIRST_LOAD_TIME

7. Recycle Bin:

1 drop table t1 purge;
2 purge recyclebin; View Code
8. Monitoring Oracle wait events:

select event,
      sum (decode (wait_Time, 0, 0, 1)) "Prev",
      sum (decode (wait_Time, 0, 1, 0)) "Curr",
      count (*) "Tot"
  from v $ session_Wait
 group by event
 order by 4;

9. The object information within a statistical model:

a. Check the object information of the current schema

select object_type, count (*) from user_objects group by object_type;

b.sys user view under the specified schema object information

select SEGMENT_TYPE, COUNT (*) from dba_segments where tablespace_name = 'TSP_WEBAGENT' GROUP BY SEGMENT_TYPE;
     
         
         
         
  More:      
 
- Linux install Samba file sharing server (Server)
- MySQL Server Time Synchronization Problem (Database)
- NGINX Plus now fully supports HTTP / 2 (Server)
- Oracle 11g through SCN do incremental backup repair standby library detailed process (Database)
- Ubuntu 14.04 / 14.10 how to install FFmpeg 2.5.1 (Linux)
- GRUB and Linux system repair (Linux)
- Linux Live CD lets your PC is no longer secure (Linux)
- Python common data type summary (Programming)
- Delete specific files using bash directory under Linux (Linux)
- Linux environment variable settings methods and differences (Linux)
- Linux operating system buffer overflow attacks Countermeasures (Linux)
- grep command output highlighted word (Linux)
- Linux crontab command format example (Linux)
- Use the TC flow control test under Linux (Linux)
- Zabbix configure DataGuard monitoring (Database)
- Linux kernel TCP / IP parameters analysis and tuning (Linux)
- Git common skills (Linux)
- Linux users should be aware that should the 7 ls command unique skills (Linux)
- VMware clone Linux find eth0 (Linux)
- DB2 table space is redirected to restore the database combat (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.