Oracle

Two Oracle instance, if you need to directly query the data on another instance on a instance, use the Db-linkCreate:Create Public Database Link name to by Password ' ( DESCRIPTION = ( ADDRESS = (PROTOCOL = TCP) (HOST = server IP) (PORT =

1: Querying the database for table space usageSELECTF.tablespace_name, (T.total_space-f.free_space) "Used (MB)", F.free_space "free (MB)", T.total_space "Total (MB)", (ROUND((F.free_space/T.total_space)* -))|| '% 'Per_free

EMP Employee table (EMPNO employee number/ename Employee Name/job work/mgr Superior number/hiredate Employment Date/sal Salary/comm Commission/deptno department number)Dept Department Table (DEPTNO department number/dname department name/loc

Use JDBC to change the session parameter NLS_DATE_FORMAT of Oracle Except for one problem recently, this is probably the case. The project is developed abroad and a large number of Oracle functions TO_DATE are used in the project development process,

Servlet update execution error ORA-12518 ORA-12518: TNS: listener cocould not hand off client connection This error is generally tested for database concurrency by multiple users, The backend executes an update using the servlet method, but the

Whether the maximum number of connections is set in oracle or an error is returned There are 1100 data records to be updated, and an error is reported during connection. ORA-12518, TNS: listener cocould not hand off client connection According to