临时表存在于临时表空间,非临时表一般要指定表空间
查询阻塞session这个应该就够了select pro.spid,
ses.machine,
ses.username,
ses.sid,
ses.serial#,
ses.status
from v$session ses, v$process pro
where ses.sid in (select sid from v$session where username is not null)
and ses.paddr = pro.addr;
ALL_SOURCE表存放脚本的,
表所占表空间:SELECT SEGMENT_NAME ,TO_CHAR(SUM(BYTES) / (1024 * 1024), '999G999D999')
FROM DBA_EXTENTS
WHERE OWNER = 'ZJZJ_USER'--用户
AND SEGMENT_NAME = 'AC01'--表名
AND SEGMENT_TYPE LIKE 'TABLE%'
GROUP BY SEGMENT_NAME;
sqlcode,sqlerrm是一些执行出错的信息
查询阻塞session这个应该就够了select pro.spid,
ses.machine,
ses.username,
ses.sid,
ses.serial#,
ses.status
from v$session ses, v$process pro
where ses.sid in (select sid from v$session where username is not null)
and ses.paddr = pro.addr;
ALL_SOURCE表存放脚本的,
表所占表空间:SELECT SEGMENT_NAME ,TO_CHAR(SUM(BYTES) / (1024 * 1024), '999G999D999')
FROM DBA_EXTENTS
WHERE OWNER = 'ZJZJ_USER'--用户
AND SEGMENT_NAME = 'AC01'--表名
AND SEGMENT_TYPE LIKE 'TABLE%'
GROUP BY SEGMENT_NAME;
sqlcode,sqlerrm是一些执行出错的信息
select * from sys.all_objects where OBJECT_TYPE='TABLE' AND TEMPORARY ='Y'
就是想问你写这些代码是在什么编辑器里写的。是用的界面插件么,类似于pl/sql
就是想问你写这些代码是在什么编辑器里写的。是用的界面插件么,类似于pl/sql是的,我是用plsql的
# Generated by Oracle configuration tools.XW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XW)
)
)LISTENER_XW =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)上面是一另台服务器上找到的tnsnames.ora中的内容,我现在想要在我的电脑上连接该电脑需要怎样处理,我电脑上安装有PL/SQL developer 9.0 与oracle 9i数据库与客户端,请问怎样处理,谢谢!
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 对方主机名或者ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XW)
)
)
database选项直接写
ip或主机名:1521/XW,如:127.127.127.127:1521/XW
sqlplus中也可以这么用,conn 用户名/密码@127.127.127.127:1521/XW注意,你本机是9I,而连接的服务是11g,注意版本之间的导入导出
你好,若我要连接多个不同的oracle服务器,里面可以进行多个这样的设置吗?谢谢!
你好,若我要连接多个不同的oracle服务器,里面可以进行多个这样的设置吗?谢谢!是的 每个都配置一个