Oracle下绝对文件号和相对文件号区别
Oracle下绝对文件号和相对文件号区别 一：Oracle官方给出的描述 Oracle Database assigns each datafile two associated file numbers, an absolute file number and a relative file number, that are used to uniquely identify it Absolute：Uniquely ide
Oracle下绝对文件号和相对文件号区别
一：Oracle官方给出的描述
Oracle Database assigns each datafile two associated file numbers, an absolute file
number and a relative file number, that are used to uniquely identify it
Absolute：Uniquely identifies a datafile in the database. This file number can be used in many SQL statements that reference datafiles in place of using the file name. The absolute file number can be found in the FILE# column of the V$DATAFILE or V$TEMPFILE
view, or in the FILE_ID column of the DBA_DATA_FILES or DBA_TEMP_FILES view
Relative：Uniquely identifies a datafile within a tablespace. For small and medium size databases, relative file numbers usually have the same value as the absolute file number. However, when the
number of datafiles in a database exceeds a threshold (typically 1023), the relative file number differs from the absolute file number. In a bigfile tablespace, the relative file number is always
1024 (4096 on OS/390 platform).
二：总结如下
总述：oracle数据库会给每一个新创建的datafile分配一个绝对文件号和相对文件号，两者都用于唯一性标识该数据文件，只不过标识范围不一样。
绝对文件号：
1 绝对文件号数据库范围内唯一标识一个数据文件
2 sql语句中常常用绝对文件号代替该数据文件名字。
3 绝对文件号可通过查询视图v$datafile|v$tempfile|dba_data_files|dba_temp_files相关字段file#|file_id 获得
例如：v$datafile 的file#字段
select file#,name,status from v$datafile
FILE# NAME STATUS
---------- ---------------------------------------- -------
1 /oracle/CRM2/system1.dbf SYSTEM
2 /oracle/CRM2/zxb.dbf ONLINE
3 /oracle/CRM2/CRM/sysaux01.dbf ONLINE
4 /oracle/CRM2/CRM/users01.dbf ONLINE
5 /oracle/CRM2/zxa.dbf ONLINE
6 /oracle/CRM2/CRM/test1.dbf ONLINE
7 /oracle/CRM2/zxc.dbf ONLINE
8 /oracle/CRM2/CRM/undotbs1.dbf ONLINE
相当文件号：
1 相对文件号在表空间范围内唯一标识一个数据文件。
2 数据库内数据文件没有超过1023个时，相对文件号和绝对文件号是相等的；数据文件若超出1023个，则会不同。
3 在大表空间中数据文件相对文件号总是1024
4 查询v$datafile|v$tempfile字段RFILE# ,dba_data_files|dba_temp_files字段RELATIVE_FNO等，可查出相对文件号。
例1如 v$datafile的字段rfile#
SQL> Select file#,rfile#,name,status from v$datafile;
FILE# RFILE# NAME STATUS
---------- ---------- ---------------------------------------- -------
1 1 /oracle/CRM2/system1.dbf SYSTEM
2 2 /oracle/CRM2/zxb.dbf ONLINE
3 3 /oracle/CRM2/CRM/sysaux01.dbf ONLINE
4 4 /oracle/CRM2/CRM/users01.dbf ONLINE
5 5 /oracle/CRM2/zxa.dbf ONLINE
6 6 /oracle/CRM2/CRM/test1.dbf ONLINE
7 7 /oracle/CRM2/zxc.dbf ONLINE
8 8 /oracle/CRM2/CRM/undotbs1.dbf ONLINE
8 rows selected.
例2 大表空间绝对文件号和相对文件号情况
SQL> select file#,rfile#,name,status from v$datafile;
FILE# RFILE# NAME STATUS
---------- ---------- ---------------------------------------- -------
1 1 /oracle/CRM2/system1.dbf SYSTEM
2 2 /oracle/CRM2/zxb.dbf ONLINE
3 3 /oracle/CRM2/CRM/sysaux01.dbf ONLINE
4 4 /oracle/CRM2/CRM/users01.dbf ONLINE
5 5 /oracle/CRM2/zxa.dbf ONLINE
6 6 /oracle/CRM2/CRM/test1.dbf ONLINE
7 7 /oracle/CRM2/zxc.dbf ONLINE
8 8 /oracle/CRM2/CRM/undotbs1.dbf ONLINE
9 1024 /oracle/CRM2/CRM/zxbig.dbf ONLINE
SQL>select file_id,relative_fno,file_name from dba_data_files order by 1
FILE_ID RELATIVE_FNO FILE_NAME
---------- ------------ ----------------------------------------
1 1 /oracle/CRM2/system1.dbf
2 2 /oracle/CRM2/zxb.dbf
3 3 /oracle/CRM2/CRM/sysaux01.dbf
4 4 /oracle/CRM2/CRM/users01.dbf
5 5 /oracle/CRM2/zxa.dbf
6 6 /oracle/CRM2/CRM/test1.dbf
7 7 /oracle/CRM2/zxc.dbf
8 8 /oracle/CRM2/CRM/undotbs1.dbf
9 1024 /oracle/CRM2/CRM/zxbig.dbf
www.linuxidc.comhttp://www.linuxidc.com/Linux/2012-12/75509.htm
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What is the difference between pre-market and after-market trading? Detailed explanation of the differences between pre-market and after-market trading
Mar 03, 2025 pm 11:54 PM
In traditional financial markets, pre-market and after-market trading refers to trading activities outside the regular trading period. Although the cryptocurrency market is trading around the clock, trading platforms like Bitget also offer similar features, especially some comprehensive platforms that trade stocks and cryptocurrencies at the same time. This article will clarify the differences in pre-market and after-market trading and explore its impact on currency price. Four major differences between pre-market and after-market trading: The main differences between pre-market and after-market trading and regular trading periods are in four aspects: trading time, liquidity, price fluctuations and trading volume: Trading time: Pre-market trading occurs before the official trading starts, and after-market trading is carried out after the regular trading ends. Liquidity: The liquidity of pre- and after-hours trading is low, there are few traders, and the bid and offer price difference is large; while the liquidity is high during the regular trading period, the price is
Why is Bittensor said to be the 'bitcoin' in the AI track?
Mar 04, 2025 pm 04:06 PM
Original title: Bittensor=AIBitcoin? Original author: S4mmyEth, Decentralized AI Research Original translation: zhouzhou, BlockBeats Editor's note: This article discusses Bittensor, a decentralized AI platform, hoping to break the monopoly of centralized AI companies through blockchain technology and promote an open and collaborative AI ecosystem. Bittensor adopts a subnet model that allows the emergence of different AI solutions and inspires innovation through TAO tokens. Although the AI market is mature, Bittensor faces competitive risks and may be subject to other open source
Is there any difference between South Korean Bitcoin and domestic Bitcoin?
Mar 05, 2025 pm 06:51 PM
The Bitcoin investment boom continues to heat up. As the world's first decentralized digital asset, Bitcoin has attracted much attention on its decentralization and global liquidity. Although China was once the largest market for Bitcoin, policy impacts have led to transaction restrictions. Today, South Korea has become one of the major Bitcoin markets in the world, causing investors to question the differences between it and its domestic Bitcoin. This article will conduct in-depth analysis of the differences between the Bitcoin markets of the two countries. Analysis of the differences between South Korea and China Bitcoin markets. The main differences between South Korea and China’s Bitcoin markets are reflected in prices, market supply and demand, exchange rates, regulatory supervision, market liquidity and trading platforms. Price difference: South Korea’s Bitcoin price is usually higher than China, and this phenomenon is called “Kimchi Premium.” For example, in late October 2024, the price of Bitcoin in South Korea was once
Vertical proxy: Application scenarios and interpretation of disruptive potential of encryption native proxy
Mar 04, 2025 am 10:21 AM
Artificial intelligence agents (AIAgents) are rapidly integrating into daily operations of enterprises, from large companies to small businesses, almost all areas have begun to be used, including sales, marketing, finance, law, IT, project management, logistics, customer service and workflow automation. We are moving from an era of manual processing of data, performing repetitive tasks, and using Excel tables to an era of autonomous operation by AI agents around the clock, which not only improves efficiency but also significantly reduces costs. Application case of AI agents in Web2: YCombinator's Perspective Apten: A sales and marketing optimization tool combining AI and SMS technology. BildAI: A model that can read architectural blueprints,
Redstone/RED currency listing price forecast and detailed explanation of token economics
Mar 03, 2025 pm 10:42 PM
This time, the Redstone token $RED will be launched on Binance Launchpool on Binance TGE! This is also the first time Binance has launched a pre-market trading limit mechanism! The first day limit is 200%, and the ban will be lifted after 3 days to avoid "the peak will be achieved when the market opens"! Launchpool mechanism introduces the BinanceLaunchpool participating in Redstone that needs to pledge designated tokens (BNB, USDC, FDUSD) activity period is 48 hours: 08:00 UTC on February 26, 2025 to 08:00 UTC on February 28, 2025 ending this pre-market daily limit rule: 18:00 on February 28, 2025
What exchange is Nexo? Is Nexo exchange safe?
Mar 05, 2025 pm 07:39 PM
Nexo: Not only is it a cryptocurrency exchange, but also your digital financial manager. Nexo is not a traditional cryptocurrency exchange, but a financial platform that focuses more on cryptocurrency lending. It allows users to obtain loans in cryptocurrency as collateral and provides services to earn interest. While Nexo also offers cryptocurrency buying, selling and redemption capabilities, its core business is crypto lending. This article will explore the operating model and security of Nexo in depth to provide investors with a more comprehensive understanding. Nexo's operating model was founded in 2018 and is headquartered in Zug, Switzerland, and is a pioneer in the field of digital finance. It is different from other centralized exchanges and focuses more on providing comprehensive financial services. Users can buy, sell, trade cryptocurrencies without selling assets and
The difference between Ether and Bitcoin What is the difference between Ether and Bitcoin
Mar 19, 2025 pm 04:54 PM
The difference between Ethereum and Bitcoin is significant. Technically, Bitcoin uses PoW, and Ether has shifted from PoW to PoS. Trading speed is slow for Bitcoin and Ethereum is fast. In application scenarios, Bitcoin focuses on payment storage, while Ether supports smart contracts and DApps. In terms of issuance, the total amount of Bitcoin is 21 million, and there is no fixed total amount of Ether coins. Each security challenge is available. In terms of market value, Bitcoin ranks first, and the price fluctuations of both are large, but due to different characteristics, the price trend of Ethereum is unique.
What does closing a virtual currency position mean? Same as selling? How to avoid forced closing of positions?
Mar 04, 2025 am 06:51 AM
Detailed explanation of closing positions in virtual currency trading: Strategies to avoid the risk of liquidation. This article will deeply explore the concept of "closing positions" in the virtual currency market, and clarify the difference between it and "sell", and how to effectively avoid the risk of forced liquidation (filtering positions). What is virtual currency closing? Close positions refers to investors ending existing positions through reverse trading, thereby locking in profits and losses. For example, investors holding long positions (buy) can close their positions by selling equal amounts of virtual currency; investors holding short positions (sell) need to buy equal amounts of virtual currency to close their positions. A closing operation is essentially closing or releasing an established investment position. Is closing a position equal to selling? Although long closing does involve selling operations, closing and selling are not exactly the same. Close position definition: End opened
